SUMMARY

• Over 9 years of experience in design, development and delivering IT solutions to complex enterprise problems.
• Expert in Informatica PowerCenter 9.x, 8.x Designer, Workflow Manager, Workflow Monitor , and Power Connect, Power Exchange, Data Quality, Data Explorer, LifeCycle Management ILM .
• Experienced in Performance of Mapping Optimizations in Informatica.
• Experienced in Powercenter Change Data Capture CDC to perform database changes and forward to power center.
• Experienced in the Analysis, Design, Development, Testing, and Implementation of Data Warehouse solutions for Financial and Retail Sectors.
• Used various sources like Oracle, SQL Server, DB2 UDB, Sybase, Flat files, and XML in creating reports.
• Experienced in using the Oracle SQL Loader feature for loading the data from Flat Files to Data Base tables for Bulk Loading.
• Automated and scheduled the Informatica jobs using UNIX shell scripting CRONTAB and Control M.
• Expert with Oracle PL/SQL Programming, SQL, SQL Tuning, Analytical Functions, Collections
• Excellent in analyzing and documenting the business requirements in functional and technical terminology.
• Strong functional experience for FMCG Sales Direct and Retail Knowledge of Retail as well as organized trade for FMCG products, Sales Cycle for FMCG goods, EDI interface.
• Experience of working on Agile and Waterfall Methodology.
• Excellent interpersonal and communication skills.

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Confidential

Senior ETL Developer

Responsibilities:

• Data modelling for new facts as per requirement
• Technical design for new mappings with details about data lineage
• Developed and implemented Custom SDE mappings for Source dependent extraction of data for Dimension and Fact tables.
• Developed and implemented Custom SILOS mapping for Source Independent loading of data for Dimension and Fact tables.
• Developed and implemented Custom PLP mappings for post load processing of data for creating aggregates based on fact tables
• Worked with Data warehouse Adminitration Console DAC for configuration and scheduling of full and incremental load
• Designed, developed, and tested complex Informatica mappings/Mapplets to extract data from oracle tables using Informatica powercenter 9.0.1
• Extensively worked on Mapping Variables, Mapping Parameters, Workflow Variables and Session Parameters for the CDC process during that period.
• Extensively used debugger in identifying bugs in existing mappings by analyzing data flow and evaluating transformations.
• Created and implemented mappings and mapplets using transformations like Source Qualifier, Connected/ Unconnected lookups, and filter and Update Strategy transformations.
• Performance tuning the mappings to achieve quicker execution times for the multi-terabyte join/ lookups.
• Responsible for creating complex Queries for data retrieval processing.

Environment: Informatica Power Center 9.0.1, Oracle11g SQL, TOAD, Windows 2008, Sun Solaris, OBIA

Confidential

Technical Lead

Responsibilities:

• Technical lead for Commerce applications which includes different sales systems.
• Perform data modeling tasks for the new enhancements
• Responsible for Communication with Functional and technical teams.
• Developed, implemented and enforced ETL best practices standards.
• Designed, developed, and tested complex Informatica mappings/Mapplets to extract data from external flat files, SQL Server, oracle tables using Informatica powercenter 9.1.
• Implemented Slowly Changing Dimension Type 1 and Type 2 for inserting and updating Target tables for maintaining the history.
• Extracted data from Salesforce.com SFDC , Oracle, excel ,data files using Informatica ETL and SQL-PL/SQL scripts
• Extensively worked on Mapping Variables, Mapping Parameters, Workflow Variables and Session Parameters for the CDC process during that period.
• Extensively used debugger in identifying bugs in existing mappings by analyzing data flow and evaluating transformations.
• Worked with mappings to dynamically generate parameter files used by other mappings.
• Used PL/SQL with Informatica Power Center 9.1 for Oracle 9i database.
• Created and implemented mappings and mapplets using transformations like Source Qualifier, Connected/ Unconnected lookups, XML, Routers, Joiners and Stored Procedures.
• Performance tuning the mappings to achieve quicker execution times for the multi-terabyte join/ lookups.
• Generate complex workflows/worklets taking into consideration the interdependencies between sessions and mappings using Informatica PowerCenter.
• Responsible for creating complex Queries PL/SQL procedures for data retrieval processing.

Environment: Informatica Power Center 9.1/8.6, Oracle10g SQL, Oracle10g PL/SQL, TOAD, Windows 2008, Sun Solaris, XML

Confidential

Technical Lead

Responsibilities:

• Technical lead for Finance applications which includes suppliers and invoice systems.
• Involved in business requirement analysis and design
• Responsible for preparing design document
• Involved in creating conceptual, logical and physical data models for cleansing model
• Responsible for developing and enforcing standards and best practices
• Involved in data profiling ,data quality, data cleansing and metadata management
• Created complex Informatica mappings using Unconnected Lookup, joiner, Rank, Source Qualifier, Sorter, Aggregator, newly changed dynamic Lookup and Router transformations to extract, transform and load data to Cleansing area
• Wrote complex PL/SQL functions/procedures/packages
• Developed Informatica workflows/worklets/sessions associated with the mappings using Workflow Manager
• Wrote Test cases and executed test scripts in Cleansing area
• Involved in performance tuning of Informatica mappings and PL/SQL scripts
• Supported during QA/UAT/PROD deployments
• Wrote UNIX shell scripts for file transfer/archiving.
• Scheduling of Informatica workflows/sessions using Control-M

Environment: Erwin4.5,Informatica Power Center 8.2.1/8.5.1, Oracle9i/10G, PLSQL, SQL Server 2005, XML, Sun-Solaris Shell Scripting , MS Excel ,Flat Files

Confidential

IT Consultant

Responsibilities:

• Analyzed Business requirements, prepared the Physical design, High level designs and technical specifications.
• Involved in the process of extracting data from integrated heterogeneous sources using Pro C, and sorting extracted data using Synch sort methods.
• Performed the preparation of technical design docs, source to target mapping.
• Prepared the strategies for performance tuning and reusable components in the custom PL/SQL scripting.
• Coded complex mappings using PL/SQL, responsible for establishing connectivity with various data sources including SQL Server, FlatFiles, XML and SAP R/3.
• Created mappings to generate the statistics for the dataflow and also mail notification when a particular load doesn't meet the SLA.
• Created UNIX scripts to call other programs and file maintenance. And also, oracle database scripts for table partitions compress and rebuild indexes, partition exchange and purging the partitions.
• Experience in writing SQLs, views and PL/SQL programs like functions, stored procedures, packages and cursors.
• Involved in the preparation of the QA check list as per standards. And also, prepared the test cases based on the business requirements and documented them in a specified manner.
• Prepared Technical Design Documents, Impact Document for the enhancement required by the client.

Environment: Oracle 8i, SQL Server 2003, Cognos Report net, UNIX, Windows, Erwin4.1 SQL Navigator.

Confidential

Senior Developer

Responsibilities:

• Member of design team and developed application to load data coming from different sales system, validated data and loading data into targets.
• Prepared Technical Design Documents, Impact Document for the enhancement required by the client.
• Developed Extraction, Transformation and Loading of data from different source systems using Informatica PowerCenter tools Mapping Designer, Repository Manager, Workflow manager and workflow Monitor
• Created complex mappings using transformations like Source qualifier, Sequence generator, Lookup, Joiner, filter, Update Strategy, Rank and aggregators.
• Implemented Slowly Changing Dimension Type 1 and Type 2 for maintaining Targets.
• Created workflows and worklets taking into consideration the interdependencies between sessions and mappings and various commands like command, assignment, control and session tasks.
• Performance enhancement of the Mappings and data access
• Involved in preparing test plan and testing for ETL development

Environment: Informatica 6.2, Oracle 8i, Cognos Report net, UNIX, Windows, Erwin4.1, PL/SQL, TOAD

Confidential

Senior Developer

Responsibilities:

• Member of design team and developed application to load data from different sources, validate order data against master data and order specific validation and made entry of valid orders in NOTS database. If invalid, made entry for such orders in invalid tables for correcting the orders.
• Developed software for checking the validity of the orders and populating Order Management Database and Erroneous Orders Database if required.
• Tested the functionality against test cases.
• Version Control Maintenance.
• Prepared technical design documents for EDI interface.
• Responsible for the release of EDI interface

Environment: Oracle 9i, Oracle PLSQL, TOAD

Confidential

Senior Developer

Responsibilities:

• Member of design team and development team for third party logistics Inventory Management Interface
• Tested the functionality against test cases.
• Version Control Maintenance.
• Prepared technical design documents for 3PL IM interface.
• Responsible for the release of EDI interface.

Environment: Oracle 9i, Oracle PLSQL, TOAD

Confidential

Programmer Analyst

Responsibilities:

• Involved in analysis and design of the Product Registration and Image Server
• Developed and implemented online GPS based module
• Tested the functionality against test cases.
• Responsible for Version Control

Environment: Oracle 8i, Oracle PLSQL, JSP

Confidential

Programmer Analyst

Responsibilities:

• Member of development team for Health Care Codes Data Upload System
• Tested the functionality against test cases.
• Version Control Maintenance

Environment: Oracle 8i, Oracle PLSQL, TOAD