Mr. KUMAR SOURABH

BE (Pune University)

Email: ac0jf5@r.postjobfree.com

Mobile No : 805-***-****

Passport No : Z3516431

job Experience(3.5 years)

Currently employed with Accenture from nov 2013 till now.

Expert in Waterfall model and Agile model of oracle development using advanced pl/sql.

Knowledge of Unix shell scripting, oracle concurrent programs,SQL Loader.

Worked on Oracle PL/SQL for British Telecom Client (6 months) and for ATNT client (2 year 6 Months) in Accenture and NG client (5 months).

Used All the tools of BT like BFG IMS, BGS, EXPEDIO, CAFs and worked as solution designer on database.

Complete hands on Billing system of British Telecom.

Proficient in pl/sql, UNIX,c, c++ and other MS Office tools.

Got ACE Award in Accenture for smart work.

1st phase of Oracle certification Associate cleared.

Technical Skills:

Technical language known : Oracle PL/SQL, Unix shell scripting,C++, C, PeopleSoft,MATLAB, VHDL, ASSEMBLY LANGUAGE,

Operating system : windows7, vista, unix

Database : Oracle 11 g

Project Details:

1)Project Title : SVOP NATIONAL GRID (UK).

Customer : National Grid.

Period : November 2016 – Till Now.

Role : Core Pl/SQL Developer and Optimiser.

Technology : Oracle 11g, unix.,ETL.

Tools : TOAD,SQL developer,putty

Description:

National Grid supplies electricity to UK customer and So we are designing their

Database Screen with the help of UI, API and other team.

Responsibility for me:

1)Analyse the requirement for Sprint(Agile) and provide estimates.

2)Prepare TD for requirement.

3)Development of procedures, packages and other oracle DB related activities.

4)Unit testin and deployment.

5) Defect fixing.

2)Project Title : Aristos(ATNT US).

Customer : ATNT.

Period : May 2014 – Oct 2016.

Role : Pl/SQL Developer and oracle Apps developer.

Technology : Oracle 11g, Oracle Apps, Unix,Sql loader, ODI(basic).

Tools : Toad, Sql developer, Oracle EBS, Putty,HP dev. Lifecycle tool.

Description:

1)Component Analysis – After understanding the design document and analyzing, giving the estimated hours require to develop and the complexity and tools required.

2) Component Development and Migration – Develop Component using specified tools on Dev environment with implementation of all changes given by business analyst. Then Migrate on Testing environment.

3) Defects and Enhancements Resolution – Implement all the enhancements in component and resolve any defect if raised.

Responsibility:

Analysis and Estimation of design document(waterfall).

Development of component.

Call with client and business analyst for accurate implementation.

Migration of Component on testing environment.

Resolving defects and enhancements.

keep track of development tracker and defect tools.

Mentoring others in their component Development.

3)Project Title : BT Javelin Demand (British Telecommunications).

Customer : British Telecom.

Period : November 2013 – April 2014.

Role : Pl/SQL Developer and Analyst.

Technology : Oracle 11g.

Tools : PL/SQL, MS office, BT Tools – BFG-IMS, CLASSIC, BGS,GLOSSI, SHOPIE, DIPLOMAT, CRT, PSO and DCMO.

Description:

1)Billing Migration - The main objective of our project is to collect raw bill from BT sites on customer basis and clean it by doing analysis. Then processed data is migrated on BT automated tools. Reconciliation of Bill is also done to generate discrepancy report.

2) BFG-BGS sync – To find all the missing inventory for which currently billing is not active.

3) Inventory Aligmnent - In which we have to find a common issues under the whole database and need to clean BFG with respect to issue or customer.

Responsibility:

Analyse Issue and writing procedures and packages to extract & update.

Data Cleansing and Inventory Allignment using BT tables.

Call with client for issue discussion and status.

Migration of Contracts for automation of billing.

Comparison and reconciliation of Bill.

Work allocation and report generation.

Daily updating Client tracker

CO-Curricular Activities:

Given knowledge session on BSS/OSS and PL/SQL topics.

Participated in National Paper presentation on “NANO-ELECTRONICS”

Attended short term training program on “MATLAB”

Attended the seminar on “GPS SYSTEM”

Educational Qualification:

Pre-engineering

EXAM

YEAR

SCHOOL

MARKS

CLASS

H.S.C

2005-06

SARASWATI VIDYA MANDIR,MUNGER,BIHAR

90.60%

FIRST

S.S.C

2006-08

KENDRIYA VIDYALAYA

MUNGER,BIHAR

84.60%

FIRST

Engineering(Entc)

EXAM

YEAR

UNIVERSITY/BOARD

MARKS CLASS

SEM I

SEM II

AVG

B.E

2012-13

PUNE UNIVERSITY

72.13

80.00

76.06

DISTINCTION

T.E.

2011-12

PUNE UNIVERSITY

66.90

63.40

65.15

FIRST

S.E.

2010-11

PUNE UNIVERSITY

66.80

73.60

70.20

DISTINCTION

F.E.

2009-10

PUNE UNIVERSITY

77.50

75.60

76.55

DISTINCTION

Engineering Aggregate 71.99% (DISTINCTION)

Project Work In Engineering:

B.E. PROJECT : “Image encryption and decryption using dip”

T.E PROJECT : “Infrared wireless remote extender”

S.E PROJECT : “Automatic switch using photodiode and relay”

ROLE: : Group Leader

Personal details:

NAME : KUMAR SOURABH

FATHER NAME : DIWAKAR PRASAD SINGH

DATE OF BIRTH : 21-DEC-1991

SEX : MALE

MARITAL STATUS : SINGLE

HOBBIES : PLAYING CARROM, CHESS, POOL AND CRICKET, SINGING

LANGUAGES KNOWN : ENGLISH, HINDI, MARATHI

PERMANENT ADDRESS : MAHADDIPUR MUNGER BIHAR, PIN-811201

I hereby declare that the above-mentioned information is correct up to my knowledge.

Place: PUNE

Date: KUMAR SOURABH

Contact this candidate