SUMMARY

• Over 7+ years of experience in IT industry, related to various aspects involving Data analysis and Data Modeling techniques, using OLAP & ETL tools like Informatica PowerCenter 8.x/7.x/6.x/5.x, Oracle9i/8i, SQL, PL/SQL and Business Objects.
• Over 5+ years of ETL Data warehousing experience using Informatica Power Center/Power Mart 9x/8.6.1/7.1 (Source Analyzer, Mapping Designer, Mapplet Designer, Transformations Designer, Warehouse Designer, Repository Manager, and Workflow Manager/Server Manager).
• Worked with different data sources non - relational Databases such as Flat files, XML files, and other relational sources such as Oracle, Sql Server, SAP R/3, AS400 and DB2.
• Extensive experience in Application testing using QA Run tool.
• Worked extensively with Data migration, Data Cleansing, Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse.
• Instrumental in setting up standard ETL Naming standards & BEST Practices throughout teh ETL process (Transformations, sessions, maps, workflow names, log files, bad files, input, variable, output ports)
• Worked with different Informatica performance tuning issues like source, target, mapping, transformation, session optimization issues and fine-tuned Transformations to make them more efficient in terms of session performance.
• Developed a number of Complex Mappings and Reusable Transformations.
• Experience in implementing teh complex business rules by creating re-usable transformations, developing complex Mapplets and Mappings, PL/SQL Stored Procedure and Triggers
• Worked with different data sources non-relational Databases such as Flat files, XML files, and other relational sources such as Oracle, Sql Server and Teradata.
• Extensive experience in Data modelling (logical and Physical), Forward Engineering, Reverse Engineering & Complete Compare using Erwin 4.1.
• Database experience using Oracle 11g/10g/9i/8.x, MS SQL Server 2000, MS Access, and Teradata. Also used SQL Editors such as SQL*PLUS, SQL Analyzer.
• Extensive Experience in Installations of (ETL tools) Informatica PowerCenter 8.x, Data stages 7.x & OLAP tools
• Has exposure to Business Objects XIR2
• Experience in Unit, Functional, Integration and Regression Testing.
• Experience in Creating ETL Design Documents.
• Excellent communication, presentation, project management skills, a very good team player and self-starter with ability to work independently and as part of a team.

TECHNICAL SKILLS

Data Warehousing: Informatica Power Mart 7.1.1/6.1/5.1 , Informatica Power Center 9/8.6.1/8.1.1/7.1.4 , Mapping Designer, Warehouse Designer.

Business Intelligence: Business Objects XIR2 (Designer, Desktop Intelligence, & WEBI), Cognos

Data Modelling: Erwin 7.2.8/4.5, Star-Schema Modeling, Snowflakes Modeling, FACT & Dimensions

Databases: Oracle 11g/ 9i/ 8i/8.0/7.x,MS Access 7.0,DB2,SQL SEVRER 2005,SAP R3

Programming: SQL, PERL, PL/SQL, C, C++, Visual Basic

PROFESSIONAL EXPERIENCE

Confidential, IL

Informatica Developer

Responsibilities:

• Design and development of Informatica mappings for data loads, business rules development and data cleansing for loading dimensions and fact tables which followed star schema architecture.
• Developed mappings using Informatica Power Center Designer to load data from staging environment to warehouse
• Creation of complex mappings using Aggregator, Expression, Lookup, Joiner, Router, Filter, Source Qualifier, Sequence Generator, Stored Procedures, Update Strategy and others.
• Integration with different legacy systems and source types such as Oracle, SQL server, DB2, XML, Fixed & Delimited Flat files etc.
• Created reusable transformations and Mapplets in teh designer using transformation developer and Mapplets designer tools.
• Creation of Sessions, Workflows, Worklets and Tasks to schedule teh loads at required frequency using Workflow Manager.
• Technical analysis and effort estimation of project requirements
• Performance tuning & code optimization of ETL mappings and SQL Queries.
• Responsible for high quality, timely, defect-free deliverables within teh estimated project cost.
• Conducting Unit Testing and preparing Unit Test Cases according to requirements.

Environment: Informatica Power Center 9.1, Oracle 11g, Toad 11.6, Windows 7, UNIX, SQL Server 2008, Siebel, DB2, Shell Script.

Confidential, IL

Informatica Developer

Responsibilities:

• Workedwith Business users to collect requirements and prepared ETL technical specifications.
• Performance tuned various mappings, Sources, Targets and transformations by optimizing caches for lookup, joiner, rank, aggregator, sorter transformation and tuned performance of Informatica session for data files by increasing buffer block size, data cache size, sequence buffer length and used optimized target based commit interval and Pipeline partitioning to speed up mapping execution time.
• Worked on SQL tools like TOAD to run SQL queries to validate teh data.
• Used shortcuts to reuse objects without creating multiple objects in teh repository and inherit changes made to teh source automatically.
• Created Jobs and Jobstreams in Appworx scheduling tool to schedule Informatica, SQL script and shell script jobs.
• Created reusable transformations and Mapplets in teh designer using transformation developer and Mapplets designer tools.
• Extensively used transformations like router, aggregator, lookup, source qualifier, joiner, expression, Aggregator and sequence generator transformations in extracting data in compliance with teh business logic developed.
• Involved in cleaning teh repository metadata objects
• Documented handbook of standards for Informatica code development.

Environment: Informatica Power Center 9.1, Oracle 11g, Toad 11.5, Erwin 4.1, UNIX, BO XI Release2, Appworx, SSH Secure Shell.

Confidential, TX

Informatica Developer/Production Support

Responsibilities:

• Created Technical design specification documents based on teh functional design documents and teh physical data model.
• Responsible for developing, support and maintenance for teh ETL (Extract, Transform and Load) processes using Informatica power center 8.6/7.1.4.
• Understanding teh domain and nodes as well as by using teh informatica integration service to run teh workflows in 8.6
• In teh billing system, calculating sum of teh MRC, NRC, and VOICE USAGE records by using aggregator transformation.
• Tuning teh complex mappings based on source, target and mapping, session level
• By using teh Brio 6.6,Understanded teh data model, based on teh model created teh mappings and load teh data into infostore and compare teh data with brio report data
• Extensively used pmcmd commands on command prompt and executed Unix Shell scripts to automate workflows and to populate parameter files
• Involved in performance tuning in teh ETL processes.
• Worked on Change Data Capture data sources
• Debugging invalid mappings using break points, testing of stored procedures and functions, testing of Informatica sessions, batches and teh target Data.
• Developed shell scripts, PL/SQL procedures, for creating/dropping of table and indexes of performance for pre and post session management.
• Used SQL tools like TOAD 10.5 to run SQL queries and validate teh data in warehouse.

Environment: Informatica Power Center 8.6, Oracle 10g, Toad 10.5, Erwin 4.1, UNIX, Brio 6.6, Seibel, UC4 Global3, Shell Scripts.

Confidential, Cincinnati, OH

DW Developer

Responsibilities:

• Involved in gathering functional and technical requirements.
• Written ETL specifications for all teh development tasks, to better evolve teh ETL design.
• Worked extensively with Informatica tools such as Source Analyzer, Warehouse Builder, Mapplet Designer, Mapping Designer and Workflow Manager.
• Written SQL overrides in source Qualifier according to business requirements
• Created Packages and Triggers to parse XML data into teh staging area
• Updated Code (Tables, views, Mappings and Packages) in CVS Version control tool
• Designed Sequential Workflow using Workflow Manager, Workflow Monitor for whole process.
• Created sessions and workflows for designed mappings
• Performance Tuning of Sessions and Mappings.
• Created Job’s and Job plan’s in teh UC4 scheduling tools
• Documented teh data into teh Doors
• Trained on Doors and Informatica version controlling.

Environment: Informatica Power Center 8.6, Oracle 10g, Toad 9.7, Liquid XML Studio 0.9.10, UC4 Global 3, Telelogic Doors, 8.1, Tortoise CVS

Confidential

Informatica Developer/ Production Support

Responsibilities:

• Understand teh business needs and implement teh same into a functional database design using Erwin.
• Data Quality Analysis to determine cleansing requirements.
• Documented data conversion, integration, load and verification specifications.
• Developed complex mappings using corresponding Source, Targets and Transformations, which were optimized for maximum performance.
• Created mappings using various transformations like update strategy, lookup, stored procedure, router, filter, sequence generator, joiner, aggregate, and expression transformation.
• Created reusable transformations and Mapplets in teh designer using transformation developer and Mapplets designer tools.
• Created different parameter files and started sessions using these parameter files using pmcmd command. Session parameters, mapping parameters, and variables are changed at run time.
• Modified teh PL/SQL stored procedures to meet teh changing standards.
• Generated completion messages and status reports using Informatica Server Manager
• Created and monitored Batches and sessions using Informatica Server Manager.
• Worked in teh performance tuning of teh programs, ETL procedures and processes.
• Developed shell scripts to automate teh update processes.

Environment: Informatica Power Center 7.1, Tidal, Oracle 9i, DB2, SQL, PL/SQL, TOAD 9.0, UNIX shell scripting and Windows 2003.

Confidential

Programmer Analyst

Responsibilities:

• Interacted with Business Analysts, Source to Target Mapping and E-R Diagramming.
• Developed teh ETL process from teh source system into teh Oracle Dimension and Fact tables using POWERCENTER 5.1. Developed stored procedures, functions and database triggers in teh backend.
• Automated teh report generation process from Oracle using Essbase 5.0 through VBA coding in EXCEL.
• TEMPEffected Modifications to teh reports on user-request and comprehensively tested teh reports.
• Participated in Data Modeling in Designer 2000, Source System Analysis and STAR Schema design.
• Created very complex SQL and used dynamic views and correlated queries of teh highest quality.
• Developed stored procedures, functions and database triggers in teh backend.
• Tuned teh SQL using optimizer hints and EXPLAIN PLAN.

Environment: Oracle 7.3, MS SQL Server 2000, HTML, XML, SQL Plus, PL/SQL, SQL, and Windows 2000