Summary:

• 4 years of experience in ETL (Extraction, Transformation, Loading) of data from various sources into Data Warehouses and Data Marts using Informatica PowerCenter 8.5/8.1/7.1/6.2 (Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet and Mapping Designers,Task Developer, Workflow & Worklet Designers,Repository Manager, Designer, Workflow/Server Manager, Workflow Monitor.).
• Excellent Working Knowledge in Dimensional modeling using multi-dimensional models (Star, Snow Flake schema).
• Implemented Slowly Changing Dimensions - Type I & II in different mappings as per the requirements.
• Extensive experience in designing the data sourcing, data transformation, mapping, conversion and loading.
• Proficient in implementing complex business rules by creating re-usable transformations, Worklets and Maplets.
• Good knowledge on working with Business Components in Informatica ETL tool.
• Extensive working experience in RDBMS like Oracle 10g/9i/8i, SQL Server, Sybase, MS Access and Object oriented design and development.
• Good knowledge in Unit /Integration testing.
• Strong experience in design and development of database using SQL, PL/SQL using the IDE like TOAD.
• Good knowledge in preparation of Documentation part on projects worked.
• Production support using monitoring tools like Control-M and Autosys.

Technical Skills:

Operating Systems: Windows 95/98/Xp, Windows NT/2000 Server and UNIX
RDBMS: Oracle 10g/11g
Data Modeling: Star Schema, Snowflake Schema
ETL Tools: Informatica Power Center /Power Mart 8x/7x/6x/5x/4x
Monitoring Tools: Control-M, Autosys.
Languages and scripting: SQL, PL/SQL, Unix Korn Shell Scripting.

PROFESSIONALEXPERIENCE:

Confidential, GAMarch3010-October2011
Position: ETL Developer
Confidential is a privately owned subsidiary of Confidential headquarters in Atlanta, GA and provides digital cable television and telecommunication services in the United States. I worked with Billing Data Mart and mappings related to it. I was also actively involved in transformations and slowly changing dimensions type1,typ2. The sources included Oracle, Flat Files and DB2. The Data Mart was built on Oracle. I worked with a team on the ETL process and development of the data mart using Informatica PowerCenter

Environment : : Informatica PowerCenter 8.1.1, Oracle 10g, Unix Shell, PL/SQL, TOAD, SQL * Plus, crystal reports, Flat files

Responsibilities:

• Involved in gathering business requirements, functional requirements and data specification.
• Support of the existing environment.
• Performance tuning for the existing jobs (when and where required).
• Creation of new ETL processes for new requirements.
• Looking into the incident requests (support tickets).
• Communicating with the Business Team (End Users) if there is a special requirement.
• Looking into the reports.
• Looking into the business requirements for the new reports.
• Use Informatica Designer to create mappings using transformation such as Sorter, Router, Union, Joiner, Filters, Router, Normalizer, Expression andAggregator to load data
• Design and Implementation of custom shell scripts to process data coming from different systems for which we don’t have direct access.
• Preparing the technical specs based on the functional specs.
• Preparing Unit Test plans based on the technical specs.
• Preparing Integration Test Plans and executing them.

Confidential, Malvern, PA June 2008 - Feb 2010
Position: ETL Developer
Confidential Stands for innovative products and complete solutions as well as services and consulting in the healthcare industry. The healthcare brings together advanced imaging and laboratory diagnostic equipment, information technology, management consulting and services to help customers achieve positive and sustainable clinical and financial outcomes.

The purpose of this project is to manage the data warehouse that contains both Customer and Product information of diagnostic equipment. This data warehouse was built from many different data feeds and other operational data sources for information about orders, products, order items, customer and product returns. It is also used to capture of daily changes to the data warehouse. Informatica 7.1 version is used to read the data from the source, load it into Oracle staging and to the data warehouse.

Environment : Informatica 7.1, SQL * Loader, oracle 10g, Windows NT, UNIX, Siebel, SAP,sql Server 2005, MS Excel 2002

Responsibilities:

• Gathering the business requirements, functional requirements and data specification from the technical and Business Analysts to complete the Work Requests on time.
• Involving in CR’s (Change Request) Issues and resolving them in an estimated time period.
• Extracting Data from different sources like SIEBEL, Oracle Apps and flat files and loading them into requested target flat files, excel sheets, Oracle Tables using Informatica.
• Responsible for the Estimation and completion of CR projects and also involved in Documentation of the Projects.
• Involved in creation of sessions and running different tasks in workflow monitor in Informatica.
• Use Informatica Designer to create mappings using transformation such as Sorter, Router, Union, Joiner, Filters, Router, Normalizer, Expression andAggregator to load data
• Design and Implementation of custom shell scripts to process data coming from different systems for which we don’t have direct access.

Confidential, Princeton, NJJune 2007 - May 2008
Confidential is a leading developer and marketer of innovative medical technologies inspired by improving the lives of millions of patients around the world. With four key business units - Ostomy Care, Wound Therapeutics, Continence and Critical Care, and Infusion Devices - Confidential provides a broad array of products and customer solutions developed from rigorous science and borne from our collaboration with healthcare professionals and end-users. The company oversees more than 7,500 employees in over 90 countries serving consumers and their healthcare professionals. In August 2008, Confidential, with backing from two private equity firms, Nordic Capital and Avista Capital Partners, created an independent enterprise.

Environment: Informatica 7.1, Oracle 9i, PL/SQL, SQL * Plus, TOAD, Windows 2000, MS Excel, MS Access

Responsibilities:

• Implemented the ETL processes using Informatica PowerCenter to load data from flat files and Oracle into the target data warehouse, as per requirement specifications
• Scheduled workflows to run on daily and weekly basis, using PowerCenter Server Manager.
• Support the existing processes.
• Working on the change requests.
• Working closely with the business team and providing the required information.

Education:

E-Commerce certification.(courses like Java,Oracle7g,SQL,Xml etc)
Masters In Financial Applications (MFA).
Bachelors In Commerce (B.Com).