SUMMARY

• 6 years of experience in Information Technology with strong background in Data integration and Data Warehousing concepts using Informatica 8.6/9.1
• Strong working experience on Informatica Power Center Designer, Workflow Manager, Workflow Monitor, Repository Manager, Power Exchange for Mainframes, Power Exchange for SAP Net weaver.
• Strong experience in Data warehousing concepts, Star Schema and Snowflakes Schema methodologies used in dimensional modeling
• Experience in working with heterogeneous Sources\Targets like DB2, MS SQL Server 2005/2008, Oracle, XML, SAP R/3, Mainframe Datasets\Cobol Files, Message Queue.
• Extensively worked on ETL Informatica transformations effectively including - Application Source Qualifier, Java Transformation, SQL Transformation, Web Service, SAP BAPI/IDOC Transformations.
• Experience in ETL Tools like Ascential Datastage 7.5 and SSIS.
• Experience in identifying and tuning performance bottlenecks at various levels.
• Experience withUNIX shellscripting for Job executions, Deployments and file validations.
• Designed and developed robust Audit trail and Error handling systems for business users
• Working experience in Informatica Data Quality.
• Experience in using Scheduling Tools like Control M.
• Experience in building Windows/Web based applications using C#, VB.NET and ASP .NET, with strong knowledge of Object oriented concepts.
• Strong knowledge in Relational Database Concepts, ER Diagrams,Normalization and De normalization Concepts.
• Technical expertise well augmented by excellent analytical, problem solving, communication, and interpersonal skills, with the ability to deliver innovative solutions well within timeframe

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 8.6/9.1, Ascential DataStage 7.5,SSIS

Databases: IBM DB2 V9.1, MSSQL Server 2005/2008, Oracle 9i

Web Technologies: ASP.NET, XML, HTML, JavaScript, AJAX

Languages: C, C#, Java,VB.NET, Shell Scripting, T-SQL

Scheduling Tools: Control-M

ERP: SAP R/3

Environment: s: Windows Server 2003/2008,XP,Win7, AIX UNIX

PROFESSIONAL EXPERIENCE

Sr. ETL Developer

Confidential, Fort Worth, TX

Responsibilities:

• Responsible for Requirements analysis, Technical feasibility Analysis, Effort estimates, Documentation, Development/Defect Fix, Unit Testing and Functional Testing.
• Developed mappings\workflows to extract and load data to heterogeneous systems like SAP R\3, Mainframe Datasets\Cobol Files, Message Queues, Web Services\XML, DB2, SQL Server 2008, and Flat Files.
• Analyze and simplify the development/maintenance by creating Re-usable Transformation Objects, Mapplets, Sessions, Work lets, Shortcuts.
• Raised change requests, incident Management, analyzed and coordinated resolution of break fixes for the Development environment and hot fixed them in the QA, Pre-Prod and prod environments.
• Developed mappings to translate EDI transaction system data to SAP IDOC’s
• Developed Data Quality Mapplets for Address validations and Standardizations of Vendor Data.
• Developed and used Informatica Real-time and Batch web services for Audit Trail.
• Assisted in developing test plans, test data and support for User acceptance testing.
• Implemented incremental loads using mapping variables\parameter files.
• Implemented Performance tuning using Partitioning, Cache, Buffer Size techniques.
• Developed UNIX scripts for creating deployment groups, wrapper scripts for Job executions and file validations.
• Developed Control M (Scheduler) jobs for Informatica workflows.
• Developed executables for analyzing and validate mappings against set of predefined coding standards.
• Developed real time audit, error system to track errors and report to business users.
• Created pre and post session scripts to handle errors and database checks.
• Coordinate work with offshore team

Environment: Informatica Power Center 8.6/9.1, Power Exchange SAP Net Weaver, Power Exchange Mainframe, IDQ, Web Sphere MQ, AIX DB2, SQL Server 2008, AIX UNIX.

Confidential

Responsibilities:

• Coordinating with Business Owners for gathering user requirements, designing technical and functional specifications
• Involved in the entire system study, analysis and Identify the source systems, source-to- Confidential data analysis, and transformation analysis
• Developed one time load jobs to extract data from various sources systems and load to asset hub system
• Assisted in creating detailed test plans and test data.

Environment: Informatica Power Center 8.6, Power Exchange Mainframe, AIX UNIXWindows7

ETL Consultant

Confidential

Responsibilities:

• Involved in requirement gathering, analysis and identifying the project scope
• Translate the requirements to ETL design specifications
• Implemented proof of concept for integrating SAP system using Informatica as middleware
• Developed Informatica mappings to extract data from SAP tables using custom ABAP code.
• Developed mappings to translate data to SAP ECC via BAPI and IDOC’s.
• Implemented proof of concept to trigger real time job loads using Informatica web services.

Environment: Informatica Power Center 8.6, Power Exchange SAP Net Weaver, AIX DB2ASP.Net

ETL Developer

Confidential, Minneapolis, MN

Responsibilities:

• Involved in understanding of business processes.
• Analyzed the existing informational sources and methods, to translate the business requirements to specifications.
• Documented Technical Design Document and Detail Design Document.
• Prepared Source to Confidential Mapping documents
• Extensively used Data Stage stages namely Sequential file, Transformer, Aggregate, Sort, Datasets, Join, Lookup, Change Capture, Funnel, Peek, Row Generator stages in developing the jobs.
• Developed job sequencer with proper job dependencies, job control stages, triggers.
• Developed Extraction tool from source using VB.Net
• Implemented Slowly Changing Dimension Type 1 and Type 2 for inserting and updating Confidential tables for maintaining the history.
• Created Materialized views for summary tables for better query performance.
• Developed UNIX shell scripts for file validations and job executions.
• Documented test cases, test scripts, and validations based on design specifications for unit testing.
• Created Job schedule documents for Control M(Job Scheduler)

Environment: Data Stage 7.5.1 Enterprise Edition, Oracle 9i, DB2 UDB, VB.Net, AIX UNIXWindows XP

Software Developer

Confidential

Responsibilities:

• Studied the existing data sources and methods.
• Created Source to Confidential Mapping documents.
• Worked on Data Stage as ETL tool to extract data from sources systems(Oracle), loaded the data into the DB2 UDB
• Extensively used Data Stage stages namely Transformer, Aggregate, Sort, Datasets, Join, Lookup, Funnel, Peek, Row Generator stages in developing the jobs.
• Enhanced the reusability of the jobs by making and deploying shared containers and multiple instances of the jobs
• Involved in performance tuning of the jobs.
• Documented test cases, test scripts, and validations based on design specifications for unit testing.
• Participated in weekly status meetings.

Environment: Data Stage 7.5.1 Enterprise Edition, Oracle 9i, DB2 UDB, AIX UNIX, Windows NT/XP

Software Developer

Confidential

Responsibilities:

• Creating and Modifying the PL/SQL procedures and shell scripts according to business requirement.
• Created and updated technical documentations.
• Extensively interacted with users and resolved the adhoc requests from business users
• Time/Effort Estimation and Impact analysis prior to coding.
• Unit test and document the code modifications.
• Configuration Management using MS VSS.
• Involved in Daily and weekly project status meetings.

Environment: Oracle 9i, PL\SQL, AIX UNIX, Windows NT/XP