SUMMARY:

• 8+ years of IT experience with expertise in analysis, design, development and implementation of Data warehousing and Business Intelligence applications using ETL and BI tools with Oracle, DB2, MS SQL server and Teradata databases on windows and UNIX platforms.
• Expert level experience in Data Integration and Data Warehousing using ETL tool INFORMATICA PowerCenter / PowerMart 7.x/8.x/9.x (Source Analyzer, Warehouse Designer, Mapping/ Mapplet Designer, Sessions/tasks, Worklets / Workflow Manager).
• Knowledge of Informatica tools Power Exchange, PowerAnalyser, PowerConnect, Data Mart, OLAP and OLTP.
• Highly proficient in Data Modeling retaining concepts of RDBMS, Logical and Physical Data Modeling and Multidimensional Data Modeling Schema (Star schema, Snow - Flake Modeling, Facts and dimensions).
• Complete knowledge of data ware house methodologies (Ralph Kimball, Inmon ), ODS, EDW and Metadata repository.
• Expert-level mastery in designing and developing complex mappings to extract data from diverse sources including flat files, RDBMS tables, legacy and COBOL Sources.
• Maintain Development, Unit testing of framework.
• Proficient in implementing Complex business rules by creating re-usable transformations, workflows / worklets and Mappings / Mapplets.
• Experience in Performance Tuning of source, target, mappings, transformations and sessions.
• Implemented the Slowly Changing Dimensions for the purpose of incremental loading of the target database.
• Strong expertise in Relational data base systems like Oracle, SQL Server, Netezza design and database development using SQL, PL/SQL, SQL PLUS, TOAD.
• Domain Data warehousing experience including Investment banking, Credit card and Insurance. Proven ability to implement technology based solutions for business problems.
• Excellent analytical, problem solving and communication skills, with ability to interact with individuals at all levels.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center/Power Mart 9.x/8.x/7.x, Power Exchange, Power Connect, Pervasive Data Integrator, Map Designer, Process designer and Data Profiler Microsoft DTS.

Analysis/Reporting Tools: Business Objects, SSRS, Oracle Reports.

Databases: Oracle 11i/10g/9, MS SQL Server 2005/2008, DB2, Netezza.

DB Tools: SQL*Plus, TOAD, Aginity.

Operating Systems: UNIX, WINDOWS XP/NT/ 2000/98/95.

Languages: C, SQL, PL/SQL, T-SQL, XML.

Data Modeling: All-Fusion Erwin, Visio.

Scripting Languages: UNIX Shell Scripting.

Data Modelling/Methodologies: Logical/Physical/Dimensional, Star/Snowflake, ETL, OLAP, Complete Software Development Cycle.

PROFESSIONAL EXPERIENCE:

Confidential, San francisco, CA

Informatica Developer

• The objective was to extract data from Flat Files and Oracle database and to finally load it into a single data warehouse repository, which was in Oracle, Facets.
• Extensively used Informatica Power Center tool (Source Analyzer, Transformation Developer, Warehouse Designer, Mapping Designer and Mapplet Designer) for ETL process.
• Worked extensively on different types of Transformations like Source Qualifier, Expression, Filter, Aggregator, Rank, Update Strategy, Lookup (Connected & Unconnected), Stored Procedures, Sequence Generator and Joiner.
• Using crosswalk and CDM portal to reference the static data and generation parameter file.
• Handling team of 5 and make sure to meet the requirements and timelines for the release.
• Quick comeback for the defects and job issues.
• Developed Data Mappings between source systems and warehouse components. Analyzed the mappings to reposition the transformation for optimal performance.
• Responsible for Debugging & Performance Tuning of the Informatica mappings and sessions.
• Used Session Parameters to increase the efficiency of the sessions in the Workflow Manager.
• Tuned Performance of Informatica session for large Data Files by increasing block size, data cache size, Sequence buffer length and target based commit interval.
• Developed reusable Mapplets, Transformations and worklets. Created and scheduled Workflows.
• Set up Workflows to schedule the loads at different intervals using Power Center Workflow Manager, Generated completion messages and status reports using Workflow Monitor.
• Analyzed Session Log files, In case the session fails in order to resolve errors in mapping or session configurations.
• Involved in identifying issues in existing mappings by analyzing data flow, evaluating transformations using Debugger.

Environment: Informatica Power Center 9.6, Power Center designer, workflow manager, workflow monitor, Oracle11g,12c, PL/SQL Developer, SQL plus, UNIX, Windows XP/NT.

Confidential, Carrollton, TX

Sr Informatica Developer

• Worked with Power Center- Designer tool in developing mappings and mapplets to extract and load the data from various sources.
• Parsed High Level design specs to simple ETL coding and mapping standards.
• Developed various transformations like Source Qualifier, Joiner transformation, Update Strategy, Lookup transformation, stored procedure Transformations, Expressions and Sequence Generator for loading the data into target DATA MART.
• Modified the existing mappings and created the new ones based on specification documents.
• Usage of Aggregator, SQL Overrides usage in Lookups and Source qualifiers and data flow management into multiple targets using Routers was extensive.
• Strong expertise in Relational data base systems like Oracle, SQL Server, Netezza design and database development using SQL, PL/SQL, SQL PLUS, TOAD, AGINITY.
• Developed various reusable transformations using the Transformation Developer in the Informatica PowerCenter Designer.
• Maintain Development, Unit testing of framework.
• Implemented the Slowly Changing Dimensions for the purpose of incremental loading of the target database.
• Complete knowledge of data ware house methodologies (Ralph Kimball, Inmon ), ODS, EDW and Metadata repository.
• Responsible for Debugging & Performance Tuning of the Informatica mappings and sessions.
• Used Session Parameters to increase the efficiency of the sessions in the Workflow Manager.
• Tuned Performance of Informatica session for large Data Files by increasing block size, data cache size, Sequence buffer length and target based commit interval.
• Used Maestro for job scheduling.
• Used Korn Shell scripts for Informatica pre-session, post session procedures.
• Create Reports as per the user requirements using extensive functionalities in Business Objects, which allow the users to analyze the data.

Environment: Informatica Power Center 9.x, Cobol Flat Files from Mainframes, Informatica Power Analyzer, Erwin, SSRS, Maestro, Web Services, Info View, Clear Case, PL/SQL, SQL Server 2008, Aginity, Win 2000, Netezza.

Confidential, Aiken, SC

Sr Informatica Developer

• Created Logical & Physical models and used Erwin for data modeling and Dimensional Data Modeling.
• Written Data loading stored procedures, functions using PL/SQL from Source systems into operational data storage.
• Worked with Pervasive Data Integrator in developing mappings and process flows to extract and load the data from various sources.
• Worked with Map Designer, Process designer and Data Profiler to create transformations
• Modified the existing mappings and created the new ones based on specification documents.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Usage of Expression builder with Real-time Integration Flow Language (RILF) customized existing pre-built functions as per requirement.
• Developed various reusable transformations using the Map designer
• Implemented the Slowly Changing Dimensions for the purpose of incremental loading of the target database.
• Responsible for Debugging & Performance Tuning of the Map Designer mappings and process flows.
• Complete knowledge of data ware house methodologies (Ralph Kimball, Inmon ), ODS, EDW and Metadata repository
• Used Parameters to increase the efficiency of the sessions in the Process flow Manager.
• Pervasive Data integrator increases operational efficiency with real time integration.
• Create Reports as per the user requirements using extensive functionalities in Business Objects, which allow the users to analyze the data.

Environment: Informatica Power Center 9.x, Cobol Flat Files from Mainframes, Pervasive Data Integrator, SQL 2005/SQL 2000, Mainframe, MS Visio, TOAD, PL/SQL Developer, windows NT/XP .

Confidential, Cupertino, CA

Claims Analyst/ETL Developer

• Translated requirements into business rules & made recommendations for innovative IT solutions
• Documented data conversion, integration, load and verification specifications.
• Parsing high-level design spec to simple ETL coding and mapping standards.
• Coordinating with source system owners, day-to-day ETL progress monitoring, Data warehouse target schema Design (Star Schema) and maintenance.
• Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping designer& Mapplets, and Transformations.
• Designed and developed Informatica mappings/mapplets, Work flows/worklets for data loads.
• Using Server Manager to run Batches and schedule them to run at specific time.
• Maintain Development, Unit testing of framework.
• Test and Production mapping migration Using Repository Manager, also used Repository Manager to maintain the metadata, Security and Reporting.
• Developed E-MAIL tasks to send pager mails to production support and operations.
• Tuning the Informatica Repository and Mappings by various tests on sources, targets and transformations for optimum performance.
• Modeling and populating the business rules using mappings into the Repository for Meta Data management.
• Designed and developed UNIX scripts to automate the tasks.
• Used Business Objects for report generation.

Environment: Informatica Power Center 9.x, power exchange, HP-UX, Oracle10g/9i, SQL 2005/SQL 2000, Mainframe, UNIX Shell Scripting, MS Visio, Business Objects 6.0/ 5.0, TOAD, PL/SQL Developer, windows NT/XP .

Confidential, Omaha, NE

Informatica Developer

• The objective was to extract data from Flat Files and Oracle database and to finally load it into a single data warehouse repository, which was in Oracle.
• Extensively used Informatica Power Center tool (Source Analyzer, Transformation Developer, Warehouse Designer, Mapping Designer and Mapplet Designer) for ETL process.
• Worked extensively on different types of Transformations like Source Qualifier, Expression, Filter, Aggregator, Rank, Update Strategy, Lookup (Connected & Unconnected), Stored Procedures, Sequence Generator and Joiner.
• Developed Data Mappings between source systems and warehouse components. Analyzed the mappings to reposition the transformation for optimal performance.
• Developed reusable Mapplets, Transformations and worklets. Created and scheduled Workflows.
• Set up Workflows to schedule the loads at different intervals using Power Center Workflow Manager, Generated completion messages and status reports using Workflow Monitor.
• Analyzed Session Log files, incase the session fails in order to resolve errors in mapping or session configurations
• Involved in identifying bugs in existing mappings by analyzing data flow, evaluating transformations using Debugger.

Environment: Informatica Power Center 8.x, Power Center designer, workflow manager, workflow monitor, Oracle10g, PL/SQL Developer, SQL Server 2000, UNIX, Erwin, Windows XP/NT, TOAD8.0.

Confidential

Informatica Developer

• Designed and developed Star & Snowflake Schema and created Fact and Dimension Tables for the Warehouse, Data Marts and Business Intelligence Applications using Erwin Tools.
• Used Informatica Repository Manager to create Repositories to give permissions to users & create folders.
• Used Informatica Designer to create mappings using different transformations to move data from source to target Data Warehouse.
• Designed and Developed mappings in Informatica using different transformations like Source Qualifier, Expression, Lookup (Connected & Unconnected), Aggregator, Router, Rank, Filter and Sequence Generator.
• Created Update Strategy and Stored Procedure transformations to populate targets based on business requirements.
• Created and Configured Workflows, Worklets and Sessions to transport the data to target warehouse tables using Informatica Workflow Manager.
• Scheduled workflows to extract transform and load data into warehouse as per Business requirements. Improved the session performance by pipeline partitioning.
• Optimized the performance of the mappings by various tests on sources, targets and transformations. Developed Procedures and Functions in PL/SQL for ETL.

Environment: Informatica PowerCenter 8.1.0,XML,DB2, Informatica Power Connect, ERWIN, windows 2000, Oracle 9i, PL/SQL Developer, SQL Server 2000, Toad, UNIX, SQL LOADER, Microsoft Excel.

Confidential

Developer- Solution/Production Development

• Used Informatica as an ETL tool to create source/target definitions, mappings and sessions to extract, transform and load data into staging tables from various sources.
• Responsible for mapping and transforming existing feeds into the new data structures and standards utilizing Router, Lookups (Connected, Unconnected), Expression, Aggregator, Update strategy & stored procedure transformation.
• Responsible for identifying reusable logic to build several Mapplets, developed E-Mail Tasks in the Workflow Manager for sending successful or failure messages.
• Involved in documentation of the project activity all along the course of the project along with Failure Recovery plans.
• Designed and developed UNIX scripts for creating, dropping tables which are used for scheduling jobs.
• Created and Configured Workflows, Worklets and Sessions to transport the data to target warehouse tables using Informatica Workflow Manager.
• Scheduled workflows to extract transform and load data into warehouse as per Business requirements. Improved the session performance by pipeline partitioning.
• Optimized the performance of the mappings by various tests on sources, targets and transformations. Developed Procedures and Functions in PL/SQL for ETL.

Environment: Informatica PowerCenter/PowerMart 8.1.0, XML, DB2, Informatica Power Connect, Workflow Monitor, ERWIN, windows 2000, Oracle 9i, PL/SQL Developer, SQL Server2000, Toad, UNIX, Microsoft Excel.