SUMMARY

• Over Seven 7 years of ETL and data integration experience in developing ETL mappings and scripts usingInformatica Power Center 8.x/7.x/6.x and PowerMart 8.x/7.x.
• Experience in all the phases ofData warehouse life cycleinvolving Requirement Analysis, Design, Coding, Testing, and Deployment.
• Experience in working withbusiness analysts to identify study and understandrequirements and translated them into ETL code in Requirement Analysis phase.
• Experience in creatingHigh Level Design and Detailed Designin the Design phase.
• Expertise in Business Model development withDimensions, Hierarchies, Measures, Partitioning, Aggregation Rules, Time Series, Cache Management.
• Extensively worked on theETL mappings, analysis and documentation ofOLAP reportsrequirements. Solid understanding of OLAP concepts and challenges, especially with large data sets.
• Well versed inOLTP Data Modeling, Data warehousing concepts.
• Strong knowledge ofEntity - Relationship concept, Facts and dimensions tables, slowly changing dimensionsand Dimensional Modeling (Star Schema and Snow Flake Schema).
• Experience in integration of various data sources likeOracle, DB2, SQL server and MS access andnon-relational sources likeflat filesinto staging area.
• Experience in creatingReusable Transformations(Joiner, Sorter, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator, Normalizer and Rank) andMappingsusingInformatica Designerand processing tasks usingWorkflow Managerto move data from multiple sources into targets.
• Experience in creatingReusable Tasks(Sessions, Command, Email) andNon-Reusable Tasks(Decision, Event Wait, Event Raise, Timer, Assignment, Work let, Control).
• Tuned mappings using Power Center-Designer and used different logic to provide maximum efficiency and performance.
• Experienced inUNIXwork environment,file transfers,job schedulingand error handling.
• Extensively worked ondevelopinganddebuggingInformaticamappings,mapplets,sessionsandworkflows.
• Loading data from various data sources and legacy systems into Teradata production and development warehouse using BTEQ, FASTEXPORT, MULTI LOAD, FASTLOAD and Informatica.
• Worked onPerformance Tuning,identifyingandresolving performance bottlenecksin various levels like sources, targets, mappings and sessions.
• Experience in writing, testing and implementation of thePL/SQL triggers, stored procedures, functions, packages.
• Involved inUnit testing, System testingto check whether the data loads into target are accurate.
• Experience in support and knowledge transfer to the production team.
• Proficient in interaction with the business users by conducting meetings with the clients in Requirements Analysis phase.
• Extensive functional and technical exposure. Experience working on high-visibility projects
• Assign work and provide technical oversight to onshore and offshore developers
• Excellent analytical/ communication skills and good team player.

TECHNICAL SKILLS

Databases: Oracle 7.x/8.x/9x/10g/11g, SQL Server 2008/2005/2003/2000 , DB2 UDB 7.2, My SQL 5.0/4.1, MS-Access. Editors (SQL Navigator, Toad), Netezza, Teradata

Oracle Tools: Oracle Enterprise Manager, Quest TOAD, SQL*PLUS, SQL*Loader, SQL*Net, SQL Navigator Export/Import, Oracle Discoverer 10g

ETL Tools: Informatica 8.x/7.x/6.x, Informatica PowerExchange 8.x/7.x

Data Modeling: ERWIN,Visio

Reporting Tools: MS SQL Server Reporting services 2005, Business Objects XI, Crystal Reports 10, Crystal Reports 2008, Oracle Reports 2.5.

Programming Skills: C++, Shell Scripting (K-Shell, C-Shell), PL/SQL, PERL, FORTRAN, JAVA (Eclipse IDE and Net Beans IDE), HTML, JAVA Script, J2EE, CSS.

Operating Systems: UNIX, HP, Sun Solaris 2.x/7/8, Windows ME/2000/2003/NT/XP, IBM AIX, Exceed (Editor).

PROFESSIONAL EXPERIENCE

Confidential, PA

Informatica Developer

Responsibilities:

• Interacted with the Business users to identify the process metrics and various key dimensions and measures. Involved in the complete life cycle of the project.
• Developed FRD (Functional requirement Document) and data architecture document and communicated with the concerned stakeholders. Conducted Impact and feasibility analysis.
• Extensively usedTeradata Utilities likeFast-Load, MultiLoad, and BTEQ& Fast-Export.
• Created Teradata External loader connections such as M Load, Upset and Update, Fastload while loading data into the target tables in Teradata Database.
• Created salesforce External loader application and used this application to connect to salesforce.com.
• CreatedMapplets, reusable transformationsand used them in different mappings.
• Created Workflowsand used various tasks likeEmail, Event-wait and Event-raise, Timer, Scheduler, Control, Decision, Sessionin the workflow manager.
• Made use ofPost-Session successandPost-Session failurecommands in the Session task to execute scripts needed for cleanup and update purposes.
• Implementedparallelismin loads bypartitioningworkflows usingPipeline, Round-Robin, Hash, Key Range and Pass-through partitions.
• Validation ofInformatica mappingsfor source compatibility due to version changes at the source.
• Trouble shooting of long runningsessionsand fixing the issues.
• Implementeddaily and weekly audit processfor theClaimssubject area to ensure Data warehouse is matching with the source systems for critical reporting metrics.
• Developedshell scriptsfor Daily and weekly Loads and scheduled usingUnix Maestroutility.
• Involved in writingSQL scripts, stored procedures and functionsand debugging them.
• Prepared ETL mapping Documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and then to production environment.
• Involved inUnit testing, System testingto check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.
• Worked with reporting team to help understand them the user requirements on the reports and the measures on them. Helped them in creating canned reports.
• Migrated repository objects, services and scriptsfrom development environment to production environment. Extensive experience in troubleshooting and solving migration issues and production issues.
• Actively involved inproduction support. Implementedfixes/solutionsto issues/tickets raised by user community.

Environment: Informatica PowerCenter 8.6.1/9.0.1 , PowerExchange 8.1, Teradata,oracle 11g, XML,Unix,Unix Shell Script,Erwin, Micro strategy.

Confidential, Bellevue, WA

Informatica Developer

Responsibilities:

• Resolving issues related to Enterprise data warehouse (EDW), stored procedures in OLTP system and analyzed, design and develop ETL strategies.
• Developed mappings, sessions and workflows in Informatica Power Center.
• Identified performance issues in existing sources, targets and mappings by analyzing the data flow, evaluating transformations and tuned accordingly for better performance.
• Worked with heterogeneous source to Extracted data from Oracle database, XML and flat files and loaded to a relational Oracle warehouse.
• Developed standard and reusable mappings and mapplets using various transformations like Expression, Aggregator, Joiner, Router, Lookup (Connected and Unconnected) and Filter.
• Migrated day one data for existing members in PCMH program from EDW into OLTP system using ETL process.
• Performed tuning of SQL queries and Stored Procedure for speedy extraction of data toresolve and troubleshoot issues in OLTP environment.
• Troubleshooting of long running sessions and fixing the issues related to it.
• Worked with Variables and Parameters in the mappings to pass the values between sessions.
• Involved in the development of PL/SQL stored procedures, functions and packages to process business data in OLTP system.
• Carried out changes into Architecture and Design of Oracle Schemas for both OLAP and OLTP systems.
• Worked with Services and Portal teams on various occasion for data issues in OLTP system.
• Worked with the testing team to resolve bugs related to day one ETL mappings before production.
• Creating the weekly project status reports, tracking the progress of tasks according to schedule and reporting any risks and contingency plan to management and business users.
• Involved in meetings with production team for issues related to Deployment, maintenance, future enhancements, backup and crisis management of DW.
• Worked with production team to resolve data issues in Production database of OLAP and OLTP systems.

Environment: Informatica Power Center 8.6.1,oracle 11g/10g/9i/8i, PL/SQL, SQL Developer 3.0.1, Toad 11.

Confidential, Michigan

Informatica Developer

Responsibilities:

• Analyzed business process and gathered core business requirements. Interacted with business analysts and end users.
• Prepared ahandbook of standardsfor Informatica code development.
• Analyzed business requirements and worked closely with the various application teams and business teams to develop ETL procedures that are consistent across all application and systems.
• Developed Custom metadata repository.
• Used Informatica designer for designingmappings and mappletsto extract data fromSQL Server, and Oracle sources.
• Created differentparameter files and changed Session parameters, mapping parameters,and variables at run time.
• Extensively usedSource Qualifier Transformationto filter data at Source level rather than at Transformation level. Created different transformations such asSource Qualifier, Joiner, Expression, Aggregator, Rank, Lookups, Filters, Stored Procedures, Update Strategy and Sequence Generator.
• UsedDebuggerto test the data flowand fix the mappings.
• Created and monitored workflows and taskusing Informatica Power Center Workflow Manager.
• Partitioned Sessionsfor concurrent loading of data into the target tables.
• Tuned the workflows and mappings.
• Involved in identifying the bottle necks and tuning to improve the Performance.
• Created workflowsusing Workflow manager for different tasks like sending email notifications, timer that triggers when an event occurs, and sessions to run a mapping.
• Executed Workflows and Sessions using Workflow Monitor.
• Dealt with data issues in the staging flat files and after it was cleaned up it is sent to the targets.
• Activelycoordinated with testing team in the testing phaseand helped the team to understand the dependency chain of the whole project.
• Executed the workflow using paced command in UNIX.

Environment: Informatica Power Center 8.1.1/7.1.3 , Oracle 10g/9i/8i, SQL Server 2000, PL/SQL, Erwin, TOAD, SQL*Plus, SQL*Loader, XML, Windows, Linux and HP-UNIX.

Confidential

Informatica Developer

Responsibilities:

• Interacted with business analysts and translate business requirements into technical specifications.
• Designed and developed end-to-end ETL processfrom various source systems toStaging area, from staging to Data Marts.
• Extensively worked on Informatica to extract data fromFlat files, Excel files, and MS Access databaseto load the data into the target database.
• Implemented the Incremental loading of Dimension and Fact tables.
• CreatedStored Proceduresfor data transformation purpose.
• CreatedTasks, Workflows, and Sessionsto move the data at specific intervals on demand using Workflow Manager.
• Developed the control files to load various sales data into the system via SQL*Loader.
• Developed Unix Shell scripts for maintaining Files.
• Designed and created an Autosys job plan to schedule our processes.
• CreatedPL/SQL Stored proceduresand implemented them through the Stored Procedure transformation.
• Develop, test and implement break/fixchange tickets for maintenance.
• Involved in writing test cases, assisting Testing team in testing.
• Developed the document of the complete ETL process.

Environment: Informatica 7.1.1, UNIX, TOAD, IBM DB2 8.1, Oracle 8i (SQL/PLSQL), MS Access 2006, Win 2000, Autosys, MS Excel 2006,UNIX, UNIX Shell Script.