Prangya Paramita Mohapatra

Email: aco1if@r.postjobfree.com

Contact Number: 267-***-****

OBJECTIVE

Seeking an opportunity to lead a team in a reputed organization, where I can use my knowledge of datawarehousing to develop solutions. Drive IT service Management processes, supporting commitment to customer services, thereby maximizing my leadership qualities and enhancing ETL as well as reporting skills.

PROFESSIONAL SUMMARY

• 9 years of working experience in Datawarehousing .

• 7 years of experience in Datastage

• 4 years of experience in BI testing, creating test cases and documentation. Laying down approach for SIT and UAT.

• ITIL V3 certified, having extensive experience in configuration management, release management and change management processes.

• Presently working as a ETL Team Lead for healthcare major clinet, providing support to a datastage based application

• Work experience in Cognos reportnet, Impromptu, Transformer

• Industry experience in Oil and Gas sector and health Care, with 7 years of supply chain domain experience.

EDUCATIONAL QUALIFICATION

Qualification Course Tenure Name & Address of School / College / Institution and

University Class/Division/ Percentage/ Grade Points

Start Completion

SSLC Apr-1998 Jun-1999 BJEM school (CBSE)

BJB Nagar Bhubaneswar- 751014 Orissa 89%

HSLC Aug-1999 Jun-2001 BJB College(CHSE)

Bjb Nagar Bhubaneswar-751014 Orissa 85.40%

Graduation Sep-2001 Jun-2005 National Institute Of Science and Technology(Berhampur University)

Near Pallur Hills 78%

AREAS OF EXPERTISE

Programming Languages: SQL, PL/SQL, UNIX scripting, vb scripts

DBMS: Oracle 9i

Operating System: Windows XP, UNIX

Tools:,Datastage 8.7 Cognos7 Impromptu, Reportnet, Transformer

Domain Knowledge: Oil and Gas, Banking and Finance, Health Care

Visa Holding: H1 – B

CERTIFICATIONS

• EXIN ITIL V3 Foundation Exam

• Cognos Reportnet Productuser

• Cognos Reportnet Product Professional

• Cognos Impromptu series7 Product Professional

AWARDS AND ACHIEVEMENTS

• Received certificate of Appreciation from IBM for participating in Infosphere Information Server v8.5 Beta program and providing valuable feedback

• Received team terrific award for great team work in Baxter Project.

• Received Applause award from my service Line lead for exemplarily work in Baxter Project

• Pat on Back award from Mahindra Satyam for exceeding expectations at Project Lynx, Chevron

• Pat on Back award from Mahindra Satyam for performance at CRG project IFC

PROFESSIONAL EXPERIENCE

Project 5 ERP-BI

Client Baxter

Role ETL Lead

Organization Deloitte Consulting India private LTd

Duration May /2010 Till Date/2015

Environment

(with skill versions) Languages : Unix Scripts, vb scripts

Software’s : Datastage 8.0,DAtastage 8.7

Database : Oracle

Tools : DataStage Enterprise Edition : 8.7, cntrlM

O/s : Windows XP professional

Hardware P-IV, 512 MB

Project Description

Baxter is a leader in healthcare for more than 75 years. Baxter assists healthcare Professionals and their patients with treatment of complex medical conditions. Baxter International Inc. (NYSE:BAX), through its subsidiaries, develops, manufactures and markets products that save and sustain the lives of people with hemophilia, immune disorders, infectious diseases, kidney disease, trauma, and other chronic and acute medical conditions. As a global, diversified healthcare company, Baxter applies a unique combination of expertise in medical devices, pharmaceuticals and biotechnology to create products that advance patient care worldwide.

Contribution

• Manage multiple modules across locations

• Assign action items to team members

• Co-ordinate all ETL activities

• Onsite –Offshore co-ordination

• Send daily status to Onsite on call

• Analyze Technical specification documents for technical feasibility.

• Deciding on Deployment approaches, coordinating with multiple teams on release activities.

• Understanding downstream impact of CRs and coordinating with required stakeholders

• Develop ETL code in Datastage supporting the Technical design document

• Test, review code & documentation for the deliverables designed

• Fixing defects raised by testing team

Project 4 GS&T IA

Client Chevron Texaco

Role Technical Analyst

Organization Mahindra Satyam

Duration January/2008--TillDate/2009

Environment

(with skill versions) Languages : Unix Scripts, vb scripts

Software’s : Datastage 7.5.1

Database : MS SQL server

Tools : DataStage Enterprise Edition : 7.5.1.A

O/s : Windows XP professional

Hardware P-IV, 512 MB

Project Description

Lynx is down stream’s Project to implement targeted, sustainable improvements in Supply Chain Optimization Processes, Technology/Information and Organizational Capabilities. Lynx Runtime Organization provides support to the existing systems and makes required changes.

Contribution

• Resolving incidents logged as part of tickets by users through Remedy tool Working on change requests

• Testing and Installing the changes in production environment

Project 3 Chevron Lynx

Client Chevron Texaco

Role ETL Developer

Organization Mahindra Satyam

Duration February/2007--January/2008

Environment

(with skill versions) Languages :

Software’s : DataStage Enterprise Edition : 7.5.1.A

Database : SQL Server 2005

Tools : DataStage Enterprise Edition : 7.5.1.A

O/s : Unix & Windows XP Professional

Hardware P-IV, 512 MB

Project Description

Lynx is down stream’s Project to implement targeted, sustainable improvements in Supply Chain Optimization Processes, Technology/Information and Organizational Capabilities. This particular module deals with integration of subsystems. The source data is provided by SAP systems in form of text files. This data is then populated into SQL database by applying Chevron business rules with help of ETL Tool, Data stage.

Contribution

• Understanding the business rules completely as per the Functional Specification, Technical Specification and implementing the data transformation methodology.

• Working on DataStage Designer - for Extracting Source Transactional Database and transforming and then load into Target Database.

• Performance Tuning of Jobs process, identifying and resolving performance Issues.

Project 2 CRG-SLA

Client International Finance Corporation

Role Team Member

Organization Satyam Computer Services

Duration June/2006--February/2007

Environment

(with skill versions) Languages : SQL, PL/SQL

Software’s : Cognos Reportnet,Impromptu,PowerPlay

Database : Oracle-9i

Tools : Cognos Reportnet,Impromptu,PowerPlay

O/s : Windows-XP

Hardware P-IV, 512 MB

Project Description

CRG services are defined as services covering the development, testing and production of COGNOS and JAVA based reporting objects (reports, cubes and underlying database objects) in the following applications used by IFC. COGNOS Reporting Applications Fund Management System (FMS) Management Information System (MIS) Resource Management System (RMS) Loss Reserves (PLR) Insurance (INS)

Contribution

• Delivery of services and execution of associated activities per the SLA definitions, targets, process flows and associated activities

• Adherence to the IFC CRG ticket & issue management processes Compliance to IFC standards

• Participation in reviews and continuous improvement activities as mutually agreed to by Satyam and IFC-CBI

• Assistance in other projects and service delivery activities (non-CRG) as determined by the CRG Core Team/ Client officer, ensuring zero impact to CRG service delivery)

• Raising migration requests and verification of migrations by DBA team.

Project 1 HR Reports

Client International Finance Corporation

Role Team Member

Organization Satyam Computer Services Ltd

Duration May/2006--June/2006

Environment

(with skill versions) Languages : PL/SQL

Software’s : Cognos ReportNet 1.1

Database : Oracle-9i

Tools : Cognos ReportNet 1.1

O/s : Windows-XP

Hardware P-IV, 512 MB

Project Description

The aim of this project is to eliminate the existing manual excel sheets in HR department of International Finance Corporation (World Bank Group), by developing reports using Cognos ReportNet.

Contribution

• Development of Cognos ReportNet Reports.

• Preparation of Unit Test Cases and performed testing in the development environment.

• Resolving the bugs reported by PQA and CQA.

Contact this candidate