SUMMARY:

• Around 6 years of IT experience with expertise in analysis, design, development & implementation of Data warehousing using ETL tools with Oracle, MS SQL server and Sybase databases on windows and UNIX platforms.
• Expert level experience in Data Integration and Data Warehousing using ETL tool INFORMATICA PowerCenter8.6/8.1/7.1 (Source Analyzer, Warehouse Designer, Mapping/Mapplet Designer, Sessions/tasks, Worklets /Workflow Manager).
• Knowledge of Informatica tools Power Exchange, Power Analyzer, Power Connect, Data Mart, OLAP and OLTP.
• Expert - level mastery in designing and developing complex mappings to extract data from diverse sources including flat files, RDBMS tables, legacy system files and XML files
• Experience in integration of various data sources like Flat files, EDI files, IDOC, Oracle, SQL server, SAP and MS access into staging area.
• Proficient in implementing Complex business rules by creating re-usable transformations, workflows/worklets and Mappings/Mapplets.
• Experience in Performance Tuning of targets, mappings and sessions.
• Thorough knowledge of database management concepts like conceptual, logical and physical data modeling and data definition, population and manipulation.
• Expertise in logical and physical database design and Data Modeling using data modeling tools like Erwin.
• Involved in different phases of SDLC from requirement, design, development, testing, and rollout to the field user and support for production environment.
• Strong expertise in Relational data base systems like Oracle, SQL Server, MS Access, Sybase, DB2 design and database development using SQL, PL/SQL, SQL PLUS, TOAD, SQL-LOADER. Highly proficient in writing, testing and implementation of triggers, stored procedures, functions, packages, Cursors using PL/SQL.
• Worked on Data Loading from ASCII flat files to Oracle database using SQL*Loader.
• Experience in Task Automation using UNIX Shell Scripts, Job scheduling (AUTOSYS) and Communicating with Server using pmcmd.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 8.6.1,9.x.

Data Modeling: Erwin 4.0, Star-Schema Modeling, FACT and Dimension Tables

DBMS: Oracle 11g/10g/9i/8i,TeraData, Microsoft Access, SQL Server 2005, MS Excel, Flat Files, Sybase

Languages: C, C++, Java, SQL, PL/SQL, T-SQL, HTML, DHTML, XML, UNIX, Shell ScriptingVisual basic, ASP, JSP, Macromedia Software, JCL.

Scripting Languages: Java Script, VB Script and UNIX Shell Scripting, Perl.

Operating Systems: Windows 2008/2003/NT/XP, HP-Unix, Linux

Design Skills: Object Oriented Analysis Design using UML.

Others: MS Project, MS Office Suite, Toad

PROFESSIONAL EXPERIENCE:

Confidential, Lexington, MA

Informatica Developer

Responsibilities:

• Documenting user requirements, Translate requirements into system solutions and developed implementation plan and schedule.
• Responsible for reviewing Business Requirement document.
• Translated user requirements into system solutions.
• Involved in Data Analysis of the OLTP system to identify sources data elements.
• Prepared Technical Specification Document.
• Prepared Source to Target ETL mapping Documents.
• Designed and developed Informatica Mappings, Reusable Sessions, Worklets, Workflows, Dynamic Parameter files.
• Provided solutions for various performance bottle necks in Informatica Mappings.
• Coding UNIX scripts and ParamFiles for implementing business rules.
• Created complex mappings with Indirect file list methodology.
• Handled extraction of various types of source files Flat files, XML standard source data of different transactions and loading to staging area.
• Have written lots of SQL Scripts in Pre-SQL and Post-SQL session tasks.
• Building complex views based on various business rules out of the staging tables to extract data in a more faster and efficient manner
• Created Batch jobs, scheduling and testing the reports.
• Designed and Developed Autos ys jil scripts to Schedule Informatica workflows.
• Developed various shell scripts using Korn Shell to integrate various components.
• Developed and implemented Audit control and Exception control Strategies.
• Created test cases and pseudo test data to verify accuracy and completeness of ETL process.
• Involved in Unit testing, System Integration testing, User Acceptance Testing.
• Involved in Informatica Code Migration across various Environments.
• Involved in Production Support and Knowledge Transfer sessions.

Environment: Informatica Power Center 8.6.1, Oracle 10G, Business Objects, Relational Junction, DB2, Flat files, PL/SQL, SQL*Plus, TOAD, UNIX, Shell Scripting, Autosys, Erwin 4.2.

Confidential, Columbus, OH

ETL Developer

Responsibilities:

• Mainly involved in Preparation of Low level Designs (Mapping Documents) by understanding the system privacy Guard.
• Used lookup, aggregator, Router, sorting, sequence, Stored Procedure transformations in the mapping to meet the business logic.
• Created the unit test scripts to check the data quality.
• Mainly involved in developing Star Schema (Facts and dimensions based on future requirements).
• Creating the Mappings, Sessions, workflows and Parameter files.
• Pulling required data sets from General Ledger and making General Ledger Reports.
• Used Power Connect for SAP to extract data from SAP FICO tables
• Responsible of business requirement and analysis from business users.
• Created Complex Informatica mappings for Exception Handling Process and Loading of tables with Type 2 for CDC.
• Extensively worked with Parameter files.
• Created Complex Mapping for generating the parameter files.
• Created complex mappings with Indirect File list methodology.
• Responsible for tuning the bottle necks in different levels (mapping, sessions and source and Target).
• Created reusable components for using them in across the projects.
• Responsible for migrating from Development to staging & to Production (deployments).
• Resolving the Bugs Issues in Mappings, Sessions & Parameter file.
• Preparing release note documents for different releases.

Environment: TeraData, S1032, Informatica Power Center 7.1, Power Connect for SAP, Data Profiling, Windows 2000/2003, UNIX (server), AIX, SAP, Toad, SFTP.

Confidential

Data Analyst - ETL Developer

Responsibilities:

• Involved in different phases of SDLC from requirement, design, development, testing, and rollout to the field user and support for production environment.
• Handled the ETL related activates by interacting with onsite team on a regular basis.
• Have worked on requirement gathering and E/R modeling.
• Collected all necessary data for a project to track that particular project.
• Created and managed workflows for the automated tracking of things.
• Have worked on performance tuning by collecting statistics and observing explain plan.
• Worked with Informatica Power Mart client tools like Source Analyzer, Warehouse Designer, and Mapping.
• Created source and target mappings, transformation logic and processes to reflect the changing business environment over time.
• Designed and developed mapping, transformation logic and processes in Informatica for implementing business rules and standardization of source data from multiple systems into the data warehouse.
• Developed source to target mappings and scheduling Informatica sessions.
• Maintained source and target mappings, transformation logic and processes to reflect the changing business environment over time.
• Worked in Oracle SQL, PL/SQL, Query performance tuning, Created DDL scripts, Created database objects like Tables, Indexes, Synonyms, and Sequences etc., closely worked with DBAs to create Physical Databases.
• Involved in designing the Data mart and entire data warehousing life cycle.
• Involved and Worked with DBA to build Dimension Tables and Fact Tables.
• Interacted extensively with user and Involved in gathering requirements, prototyping and prepared various documents like Interface Requirement Document, Customer Requirement document, Integration test plan, Unit test plan Release notes etc.

Environment: Informatica Power Center 7.1, PL/SQL, Oracle 9i, DB2, HMTL, DHTML TOAD, ERWIN 4.1, UNIX, Windows NT/2000.