ETL Informatica Analyst

Name Darshana Nejkar

Current Designation Consultant at CapGemini India

Previous Employer Accenture India Pvt Ltd

Mobile no. +91-981*******

Email Id **************@*****.***

PROFESSIONAL PROFILE

Brief Profile Informatica professional having diverse exposure in various projects and being trained on Business Objects with comprehensive understanding of major aspects of Data Warehousing. Developed, Tested and Supported ETL Informatica Mappings; Able to create effective Documentation, including High level and Low level Design including Unit test , SIT test plan.

Over 4.6 years experience in –ETL Informatica.

• Completed Informatica Designer Vendor Certification

• Functional Knowledge Utilities, Telecom and Finance Domain.

Total Experience 4.6 Years

Informatica Experience (4.6 years)

• Strong product knowledge of Informatica 8.x.

• Experience in Designing mappings using Mapping Designer.

• Experience in Creating, Running, Scheduling & Monitoring Workflows using Workflow Manager & Monitor and Autosys Utility

• Informatica Certified Developer in Informatica 8.x

__________________________________________________________________________________________________

Education MCA -Master in Computer Application from S.N.D.T University

Mumbai,

B.Sc(Information Technology) from Mumbai University

Operating Systems Windows XP, Unix

IT Skills C, C++, SQL, Visual Basic, HTML, Core Java

Databases Oracle 9i, 10G, TeraData

Tools Trained on Business Objects (Reporting tool) ,Rational Rose, MicroSoft- Vsio,WinScp, Filezilla, Putty

_______________________________________________________________-

Project Experience Summary

Project Name & Description Technologies Role Period Team Size

Cornwall Council (Onsite role) Informatica + Oracle + CSV files Developer Aug 2011- Till Date 4

KPN-Runtime van Success Informatica + Oracle + CSV files Developer Dec 2010-

July 2011 5

JPMC-JPMorgan & Chase [IBT Core Processing] Informatica + Oracle + CSV files Developer March 2010-

Dec 2010 30

Amex-PMC [ American Express Product Manager Component ] Informatica + Oracle + CSV files Developer

& Support Nov 2008-March 2010 30

AT&T –EDW [Enterprise DataWarehouse] Informatica + Oracle + TeraData Developer

& Support May 2008-Nov 2008 20

CNE – Constellation New Energy Informatica + Oracle Developer Oct 2007 – May 2008 20

_____________________________________________________________________________________-

PROJECT DETAILS

Client Name : Cornwall Council – UK

Project Name: Cornwall Council .

Domain: UK Gov.

Operating Software Unix

Tools and Utilities Used Informatica 8.6.1 ,WinScp, Putty ,Toad 9.5 , Oracle Data Integrator.

Role ETL Developer.

Team Size 5

Project Description:

Cornwall Council is the unitary authority for Cornwall, in England, United Kingdom.

Cornwall Council provides a wide range of services to more than half a million residents, has an annual budget of more than £1 billion and is the biggest employer in Cornwall with a staff of over 22,000.[1][2] It is responsible for schools, social services, rubbish collection, roads, planning and more .The project deals with extracting information about the HR, Finance and Procurement related activities and providing this data in OBIEE reports to higher end management.

Responsibilities:

• Interacting with the client and extracting the required information for ETL development with direct interaction and development at client location at Cornwall, UK.

• Develop Low level Design Document from Functional and gathered business requirements.

• Develop ETL code to meet the business requirement and standards.

• Configuring the ETL jobs in DAC.

• Resolving any defects with respect to data and debug and fix problems in mapping and sessions by utilizing the logs of the sessions.

• Testing of the code includes Regression Testing, Integration Testing and done defect logging.

Client Name :KPN

Project Name: Runtime van Success.

Domain: Telecommunications.

Operating Software Unix

Tools and Utilities Used Informatica 8.6.1 ,WinScp, Putty ,Toad 9.5 , Oracle Data Integrator.

Role ETL Analyst Designer and Developer.

Team Size 5

Project Description:

In the Dutch telephone market, KPN is the owner of the fixed telephone operations (FLO) network and is the market leader in mobile phone operations (MNO), with the brands KPN Mobile and Telfort and as a virtual mobile phone operator (VMNO) under the brand names Simyo, Ay Yildiz, Ortel Mobile. In the Netherlands, KPN has 6.3 million fixed-line phone customers. Its mobile division, KPN Mobile, has more than 33 million subscribers in the Netherlands, Germany, Belgium, France, and Spain under different brand names

Responsibilities:

• Understand the DataVault architecture and its ETL implemetation..

• Develop Low level Design Document from Functional Documents and business requirements.

• Develop code to meet the business requirement and standards.

• Resolving any defects with respect to data and debug and fix problems in mapping and sessions by utilizing the logs of the sessions.

• Testing of the code includes Regression Testing, Integration Testing and done defect logging.

Client Name: JPMorgan & Chase (UK )

Project Name: DCPP REC

Domain: Finance and Banking.

Operating Software Unix

Tools and Utilities Used Informatica 8.1, Microsoft- Visio,WinScp, Putty , Autosys Scheduling

Role ETL Analyst, Designer and Developer.

Team Size 30

Project Description:

JPMC is one of the global financial services firm with investment, research, banking, finance, insurance, and other businesses. The project revolved around reconciliation of two of the RECS for JPMC financial business for North America, Europe and Asia regions.

The main focus of the project was to cleanse and prepare data coming from various source systems such that it can be processed through the TLM for Reconciliation. The responsibility of end to end Informatica work was handled independently by me to success; and also without any post production defect.

Responsibilities:

• Responsibilities include designing the documents which is based on the requirement specifications.

• Develop test conditions from Functional Documents and user requirements.

• Developed and implemented the coding of Informatica Mapping for the different stages of ETL. Also developed reusable code such that number of mappings required had reduced drastically from 4 as against 22 mappings created in earlier such TLM projects

• Done extensive testing and wrote queries in SQL to ensure the loading of the data.

• Debug and fix problems in mapping and sessions by utilizing the logs of the sessions.

• Developed and implemented the UNIX shell script for configuring the job to be run by the Master shell script.

• Developed Autosys jobs for scheduling these workflows [appr 30 +]

• Testing of the code includes Regression Testing, Integration Testing.

• Defect logging.

• Mentoring junior resources in the team.

• Conducting knowledge sharing sessions for the team.

Client Name: American Express (US )

Project Name: Amex Product Manager Component

Domain: Financial Services

Operating Software Unix

Databases DB2, Oracle 10g

Tools Used Informatica 8.1,Microsoft- Visio,, Putty, WinScp, Micro Strategy Reports

Role ETL Designer and Developer.

Team Size 30

Project Description:

Amex is best known for its credit card, charge card, and traveler's cheque businesses and accounts for approximately 24% of the total dollar volume of credit card transactions in the US, the highest of any card issuer.Amex PMC – Product Manger Component is Amex’s warehouse dealing with all of its Cards related Information (like all of the physical properties related with the cards e.g. type ,color etc) and all of the Market Offers related with the cards (like Membership rewards, special offers , students discounts).

Responsibilities:

• Studying and understanding the product from Functional Documents.

• Develop High Level Design and Low Level Design document from Functional Documents and user requirements.

• Developing and testing complex Informatica mappings to map the requirements of the increase in number of products and market offers and to load the data in data mart specially designed to be extensively used for Microstrategy reports generated for executives and senior management for taking day to day business decisions

• Developed approximately [80 + ] mappings of medium and high complexity

• Handled Sterno Module independently.

• Done production support for NAG7 module.

Client Name: AT&T (US)

Project Name: AT&T- EDW[ Enterprise Data Warehouse]

Domain: Telecommunications

Operating Software Unix

Tools Used Informatica 8.1, Putty

Role ETL Designer and Developer.

Team Size 30

Project Description:

Development, maintenance and production/support to clients. The Enterprise Data Warehouse (EDW) is a business critical data environment containing customer centric data throughout the enterprise as well as external demographic data. The data processed by these applications is deemed to be business critical (billing and others may be impacted).The applications extract data from Unix and Oracle source system, transform the data using Informatica and load data into Teradata Data Warehouse.

Responsibilities:

• Understand the technical aspects of the applications

• Understand the processes and service level targets as it applies to the EDW application set in the following areas:

• New Development- New application development associated with committed projects.

• Maintenance & Enhancements- detail design, coding, unit testing of projects committed to a billing release

• Production Support – Support of the application, responding to callouts ,investigation and resolution of defects

• Testing – unit testing of code developed, support for system and regression testing for all release deliverables

• Compliance of SLA administration and production processes.

• Developing and Unit testing of Lightspeed Releases

• Handling client calls independently to understand the requirements and deliver the code accordingly.

• Opimization of existing mappings using Informatica and unix scripting.

• Handling individual modules independently

• Production monitoring of eCI,SDP,CRM module jobs which run daily

• Developing automated tools using Unix shell scripting to automate the processes in the project

• Developing documents related to the project to help in knowledge transfer to new joiners in the project

Client Name: A Major Client (US )

Project Name: CNE [Constellation New Energy ]

Domain: Utilities

Operating Software Unix

Databases Oracle 9i

Tools Used Informatica 7.1, Putty

Role ETL Developer.

Team Size 20

Project Description:

CNE project dealt with the billing application and maintenance of its related database. Various legacy systems used to send data in flat file, csv and in relational databases which was merged in to a single Oracle database which was backend to billing related application Loadstar.

Responsibilities:

• Studying and understanding the requirement from the design document.

• Develop the mapping as per the requirement and perform unit testing.

• Defect logging.

Educational Qualification

Degree Institution / University Percentage Year

M.C.A S.N.D.T University, Mumbai 67.72% 2007

BSc(Information Technology) Mumbai University 77% 2004

12th HSC, Maharashtra Board 68.17% 2001

10th SSC, Maharashtra Board 79.76% 1999

Contact this candidate