E-**, Srushti, Guru Ganesh Nagar,

Kothrud, Pune – 411038,

Maharashtra, India.

Email: sg1zh1@r.postjobfree.com

Mobile: +91-787*******

Amruta Degaonkar

Career Objective:

Seeking more exposure and a challenging career at Offshore / Onshore; with respect to enhanced

learning & implementing my Data Warehousing skills on to projects, at an Organization that is rapidly

expanding and offers good advancement potential.

Professional Summary:

Oracle 9i Developer OCA & DBA OCA Certified professional.

3.4 Years of experience with core competency in Data Warehousing Tools & Technologies.

Domain expertise in Life Sciences, Distribution, Telecom.

Proficiency on working with Data Warehousing Tools – Ascential DataStage 7.5 & IBM WebS-phere DataStage 8.1, Business Objects XI, Informatica & Databases – Oracle, MS SQL Server, Teradata & Basic UNIX Commands.

Experience on DataStage Designer, DataStage Director, DataStage Manager, DataStage Administrator, Web Console.

Worked with Sever & Parallel Jobs, Containers, Sequences.

Stages extensively used in Parallel jobs are Sequential File, Dataset, TD Enterprise & Connec-tor, Oracle Enterprise, Transformer, Aggregator, Join, Lookup, Funnel, Sort, Remove Dup-licates, Copy, Filter, Change Capture, Pivot, Row/Column Generator, Build Ops etc.

Good experience on SDLC with respect to Data Warehousing projects.

Strong contributor towards quality related and knowledge management activities including project documentation and other technical documentation.

Organizational History:

Organization Designation Duration

IBM (I) Pvt. Ltd. Application Programmer Feb 2010 – Till Date

Cognizant Technology Solutions (I) Pvt. Ltd. Programmer Analyst Trainee Aug 2007 – July 2008

Educational Qualifications:

Class Board / University Year Of Passing

Bachelor of Engineering

[Computer] Pune University 2007

H.S.C. [12th] Maharashtra Board 2003

S.S.C. [10th] Maharashtra Board 2001

Technical Skills:

• Operating Systems: Windows, UNIX

• Data Warehousing Tools: Data Stage 7.5 & 8.1, Business Objects XI, Informatica

• Databases: Oracle, MS SQL Server, Teradata

• Languages: C, SQL

• Other Utilities: Toad (Quest Software), Microsoft Office Suite

Professional Experience:

Organization: IBM (I) Pvt. Ltd.

Client: Vodafone, India

Role: Developer

Location: India – Pune

Duration: Oct. 2011 – Till Date

Project: VLR(Visitor Location Register) DWH

Project Abstract: Business requires VLR – Attached (HOME – OUTROAMERS) status for all active prepaid and postpaid subscribers to be provided to DWH through Mediation on bi weekly basis. This will be further used for reporting purpose for analysis by business.

Responsibilities:

• Involved in the Analysis and Gathering of Business Requirements and documenting the same.

• Designed & Developed Parallel Jobs, Sequences to extract data from different resources, clean-sing, applied various Business rules and logic and loaded data into Target DWH.

• Tested Jobs & Sequences with sample data.

• Deploying ETL jobs From Development to Production Environment.

Client: Philip Morris International, Switzerland

Role: Developer

Location: India – Kolkata

Duration: Feb. 2010 – Sep.2011

Project: Neuchatel (Applications - PPQDWH, Genesis DWH, PPQLIMS DWH)

Project Abstract:

• PPQ DWH - PPQ DWH previously known as CQA DWH consist of nine applications namely PICT, CPQI, G-CRS, QDP, CVQA, SQA, SSA, MARKET OVERVIEW, CDB & SMOKE ICT. All these are web based applications (PPQ) are meant for different quality audit types. These applications are align to visual quality methodology to consumer perception of quality, premium criteria, and manufacturing requirements. In the DWH the data get loaded in the database every day through Data Stage jobs (Data Stage 7.5) and Reports get generated using (BO XI).

• Genesis DWH - Genesis DWH application covers the Data Warehousing application to be implemented locally in PMI associated affiliates that extract data from PMI QA applications Ge-nesis Modules - AQA/PQA/MQA, CVQA and CSR, transforms and loads into Data Ware-housing through SSIS packages. It also covers the usage of reporting interface for the Data Wa-rehousing Business Object XI (Web Intelligence).

• PPQLIMS DWH - The PPQLIMS Data Warehouse provides Management and Scientists with a better and faster overview of available data in the PPQ_LIMS system. It will allow the PPQLIMS Data Warehouse users to keep focus on their research projects without the need to have an extensive IS knowledge. It will assist in summarizing and reporting the data in the most appropriate format. This will help them to find relations and optimize processes & concepts. In the DWH the data get loaded in the database through Data Stage jobs (Data stage7.5) and Reports get generated using (BO XI).

Responsibilities:

• Involved in Requirement Analysis, Designing, Coding and Unit testing for enhancements in accordance to the Business Requirements. (ETL & Reporting).

• Worked on Support / Change Requests as per the IBM's Service Delivery Model.

• Carry out Quality Enhancement related activities like maintenance and updating various deliverables.

• Monitoring scheduled ETL jobs and resolving failures.

• Supporting Published and Ad-hoc Reporting.

• Project enhancements and Bug fixes. (ETL & Reporting).

Organization: Cognizant Technology Solutions (I) Pvt. Ltd.

Client: MERCK, USA

Roles: Developer

Location: India – Pune

Duration: Mar. 2008 – Jul. 2008

Project: Compliance Management Reporting [CMR]

Project Abstract: This project deals with training data. The main initiative for this project is to provide training count and compliance training count on monthly and yearly basis.

Responsibilities:

• Involved in the Analysis and Gathering of Business Requirements.

• Designed, Developed and Tested Mappings, as per the identified Requirements using Infor-matica and Toad.

• Carry out Quality Enhancement related activities like maintenance and updating various deliverables.

Client: Takeda Abbott Pharmaceuticals Ltd., USA

Role: Developer

Location: India – Pune

Duration: Sep. 2007 – Feb. 2008

Project: TAP Cognos Development

Project Abstract: The project aims at constructing a Sales Data-Mart that is loaded on a weekly basis. The data is extracted from IMS files and undergoes various Quality Checks and Transformations as per Business Rules.

Responsibilities:

• Developed and Tested Mappings, as per the identified Requirements using Informatica and Toad.

• Carry out Quality Enhancement related activities like maintenance and updating various deliverables.

Achievements:

Received ‘Certificate of Appreciation 2010’ from IBM client Phillip Morris International.

Extra-Curricular Activities:

• Won ‘Best Female Player Award’ for Inter Company Badminton Competition, in Kolkata.

• Participated in Fashion Show for functions at Cognizant and IBM.

• Active member of ‘Computer Literacy Program’ for NGO students through IBM, Kolkata.

• Worked as a Swimming Coach.

• Won 3rd prize in College BE Project Competition.

• Won Badminton Singles and Doubles, in College Annual Sports.

• Worked as a Head of Reception Committee at College event ‘TECHTALK 2K5’.

Languages Known:

• English, Hindi, Marathi.

Hobbies:

• Swimming, Badminton, Athletics, Listening Music, Dance.

Personal Details:

• DOB: May 30th, 1985

• Nationality: Indian

• Passport: G3573858

Contact this candidate