SUMMARY

• Over 7.5 years of progressive IT experience with prime focus on Data Analysis, Data Warehouse Design, Application Development and Business Intelligence in a Client - Server environment.
• 7+ years of stupendous experience in extraction, transformation and loading of data using Informatica PowerCenter 9/8.6.1/8.x/7.x/6.x.
• 2.5+ years of extensive experience in Informatica data quality 9.5x/9.6x.
• Strong technical exposure with good degree of competence in business systems such Sales and marketing, Life sciences.
• Substantial experience in the complete Software Development Life Cycle (Planning, Requirement Analysis, Design, Development, Testing & Implementation).
• Efficient in gathering requirements from the user group and translating the requirements into detail technical and functional specifications.
• Expertise in all activities related to the development, implementation and support of ETL processes for large-scale data warehouses using INFORMATICA PowerMart and PowerCenter.
• Efficient in scheduling and monitoring Informatica jobs using, Informatica built-in schedulers, UNIX and Oracle scheduler.
• Profound experience in pre-processing the data using UNIX Korn/Bash shell scripts. Experience in developing mappings with Oracle, DB2, VSAM, SQL Server, XML, flat files as sources and targets.
• Well versed with the Database and Data Warehouse concepts such as dimensional data modeling, OLTP, OLAP, Star and Snowflake Schemas, RDBMS, Multidimensional Modeling, Views, Physical and Logical models, Analytical functions, Stored Procedures, Functions and Triggers.
• Efficient in trouble shooting, performance tuning, system testing and debugging and optimization of ETL and reporting analysis.
• Hands on experience with ETL process flow - Gather requirements, Create physical design, Design test plan, Create ETL process, Test process, Move to QA, Test process, Move to PROD, Maintain ETL process.
• Committed team player with multitasking capabilities. Excellent interpersonal and human relations skills. Strong communication skills, both verbal and written, with an ability to express complex business concepts in technical terms.

TECHNICAL SKILLS

ETL Tools: Informatica 9, 8.6.1, 8.5.x, 8.1.x, 7.x, 6.X

Domain: Sales and Marketing, Life science, Incentive.

Operating Systems: Windows 98, 2000, 2003 server, XP, Win.7, UNIX

Databases: Oracle 8i, 9i, 10g, 11g

Other Tools: TOAD, SQL Loader, SQL Developer, Visio.

Languages: SQL, PL/SQL, UNIX & Shell Scripts, C, C++, HTML, XHTML,Java.

PROFESSIONAL EXPERIENCE

Confidential, VA

Sr. Informatica data quality Developer

Responsibilities:

• Involved in Full project life cycle (requirements gathering to implementation phase) which included Data analysis, creation of business rules, creating Profiles and scorecards.
• As an ETL developer designed, developed Physical and logical data objects to read data from source.
• Worked on performance tuning the IDQ generated SQL in case of source database.
• Worked on creation of Data mart process to capture metadata and results of scorecards in teradata tables.
• Strong skills in managing and planning Technical implementations and Customization of projects, including interfaces to legacy systems, data Conversion exercises.
• Development of the complex ETL mappings using Informatica.
• Worked closely with Business Analyst’s and DBA’s in understanding the Databases and Structures.

Environment: UNIX, Windows XP, Oracle 11g, Teradata, SQL server, Toad, Informatica Data quality 9.6.1 (Hot Fix 2).

Confidential, PA

Sr. Informatica/ETL Developer

Responsibilities:

• Involved in Full project life cycle (requirements gathering to implementation phase) which included Data Cleansing and Data Integration of the various data sources into one single Data mart.
• As an ETL developer designed, developed mappings/sessions/workflows to move data from source to staging to warehouse.
• Worked on two projects simultaneously.
• Strong skills in managing and planning Technical implementations and Customization of projects, including interfaces to legacy systems, data Conversion exercises.
• Development of the complex ETL mappings using Informatica.
• Worked closely with Business Analyst’s and DBA’s in understanding the Databases and Structures used in the life science environment.
• Performed performance and tuning functions on Informatica sessions, batches and other related scripts.
• Worked on MS Access to oracle table linking to avoid manual errors caused by file updations.

Environment: UNIX, Windows XP, Oracle 10g, Toad, Informatica 9x, Power Center Designer, Workflow Manager.

Confidential, PA

Sr Developer

Responsibilities:

• Involved in Full project life cycle (requirements gathering to implementation phase) which included Data Cleansing and Data Integration of the various data sources into one single Data mart.
• As an developer designed, developed oracle procedures to move data from source to staging to warehouse.
• Strong skills in managing and planning Technical implementations and Customization of projects, including interfaces to legacy systems, data Conversion exercises.
• Development of the complex stored procedure logic using PLSQL.
• Worked closely with Business Analyst’s to understand how to Incentives are calculated..
• Performed performance and tuning functions on oracle procedures.
• Worked on oracle scheduler to schedule the processes..

Environment: Oracle 10g, Windows XP Prof, Unix, ORACLE, PL/SQL, TOAD, Sql nevigator, MS-Office.

Confidential, PA

Informatica Technical Analyst

Responsibilities:

• Involved in gathering requirements, performing gap analysis, creating functional specifications, High Level Design, Detail level Design documents, Unit Test cases.
• Designed and developed very complex mappings to integrate and validate data from various third party source systems.
• Employed error handling mechanisms to capture critical errors and send out e-mails to designated users in the distribution list.
• Performed User Acceptance Testing (UAT) and System Integration Testing (SIT).
• Involved in Informatica code migration from DEV to UAT to PROD repositories.
• Perform impact analysis on downstream applications for the changes in source system.
• Fixed the invalid mappings and troubleshoot the technical problems of the database.
• Debug the sessions by utilizing the logs of the sessions.
• Performed effort estimation of project for change request.

Environment: Informatica Power Center 9X, Oracle 10g, Windows XP Prof, ORACLE, PL/SQL, TOAD.

Confidential

Informatica/ETL Developer

Responsibilities:

• Worked on two projects at a time.
• Involved in Full project life cycle (requirements gathering to implementation phase) which included Data Cleansing and Data Integration of the various data sources into one single Data mart (ASD).
• As an ETL developer designed, developed and tested around 150 mappings/sessions/workflows to move data from source to staging to warehouse in a complex insurance industry.
• Worked on two teams simultaneously, Viz. Old Informatica system and new oracle system.
• Strong skills in managing and planning Technical implementations and Customization of projects, including interfaces to legacy systems, data Conversion exercises.
• Hands on oracle scheduler.
• Established appropriate archive strategy for historical data.
• Performed performance and tuning functions on Informatica sessions, batches and other related scripts.
• Extensively applied SQL, PL/SQL programming skills in optimizing the session performance.
• Provided On-Call support during the Production implementation.

Environment: UNIX, Windows XP, Oracle 10/11g, Toad, Informatica 8.6, OBI, Power Center Designer, Workflow Manager, Oracle Apps, VB.

Confidential

Programmer/Analyst

Responsibilities:

• Involved in Full project life cycle (requirements gathering to implementation phase) which included Data Cleansing and Data Integration of the various data sources into one single Data mart (ASD).
• As an ETL developer designed, developed and tested around 150 mappings/sessions/workflows to move data from source to staging to warehouse in a complex insurance industry.
• Worked on two teams simultaneously, Viz. Old Informatica Developer and production support
• Strong skills in managing and planning Technical implementations and Customization of projects, including interfaces to legacy systems, data Conversion exercises.
• Hands on oracle scheduler.
• Established appropriate archive strategy for historical data.
• Performed performance and tuning functions on Informatica sessions, batches and other related scripts.
• Extensively applied SQL, PL/SQL programming skills in optimizing the session performance.
• Provided On-Call support during the Production implementation.

Environment: Oracle 9i, Informatica 8i, MS VSS.

Confidential

Programmer/Analyst

Responsibilities:

• Involved in Analysis, Designing.
• Leading the offshore team.
• Designed and implemented the application using J2EE, JSP.
• Co-ordinate the build and release
• Involved in application releases and Acceptance Testing.
• Testing and defect fixing of the system.

Environment: J2EE,JSP,MS Access,Oracle.

Confidential

Programmer Analyst

Responsibilities:

• Actively involved in Analysis, Requirement gathering, function/technical specification, development, deploying and testing. Analyzed the business requirements in terms of enhanced usability.
• Identified Facts, Dimensions, and Hierarchies of the business model.
• Implemented upgrade plan including testing of all production mappings, sessions, workflows.
• Changed architecture and mappings as needed to improve performance.
• Performance statistics were considered during the integration testing.
• Replaced lookups in mappings with join conditions.

Environment: Informatica Power Center 8i, Oracle 9i, Toad, Windows, PL/SQL, SQL.

Confidential

Programmer/Anayst

Responsibilities:

• Involved in logical and physical data model design, Star Schema design. Meet business users to collect and analyze business requirements and provide system enhancement recommendations. Also responsible for trouble shooting, data cleansing and data integrity.
• Create a set of definitions for a logical warehouse schema, its data sources, target and theoperations that map, transform, and populate a warehouse.
• Involved with Informatica Designer to create the various mappings for extracting, transforming and loading operational data into the data mart from ODS/Flat file to Reporting Tables.
• Created various stored procedures for removing the indexes before the data is loaded, rebuilt the indexes after the load has been completed.

Environment: Informatica 7, Oracle 8i, PL/SQL, UNIX Script