Summary:

• Eight years of experience in IT industry involving analysis, design, developing, testing and implementation of various client/server, web based and data warehousing applications in Financial, Manufacturing, Insurance, Educational, Heath Care verticals. v Five plus years of experience as a Data Warehouse consultant using Informatica Power Center good understanding of Data Warehouse architecture and life cycle. v Well versed with Data warehousing concepts using Kimball's principles or methodology- Dimensional modeling, slowly changing dimensions type1, type2, and type3 , surrogate keys, star schema and snowflake schema in implementing DSS Decision Support Systems. v Solid understanding of Extraction, Transformation and Loading ETL process and usage of ETL tools v Knowledge of various techniques for Performance Tuning involved with sources, targets, mappings and sessions. v Highly proficient in Development, Implementation, Administration and Support of ETL processes for Large-scale Data warehouses using Informatica PowerCenter and PowerMart. v Designed and developed efficient Error handling methods and implemented throughout the mappings in various projects. v Experience in writing Server Side Programming with PL/SQL Stored Procedures, Stored Functions , UNIX Korn Shell Scripting
• Expertise in doing Unit Testing, Integration Testing, System Testing and Data Validation for Developed Informatica Mappings.
• Experience with Other Utilities: TOAD, SQL Loader, Export/Import Technical Skills: ETL Tools : Informatica PowerCenter v 8.x/7.x / 5.0 PowerMart v 6.2 / 5.0 Databases : Oracle 10g/9i/8i/7x, MS SQL Server, Teradata, DB2 and MS Access Data Modeling : Star-Schema Modeling, Snowflakes Modeling, Dimension Tables, FACT, and Erwin Operating Systems : Windows 95/ 98/NT/2000, XP, Linux, UNIX Languages : C, Java, Visual Basic 6.0, SQL, PL/SQL, HTML, DHTML Tools and Servers : Toad, SQL Loader, FTP, SQL Plus Project Experience:

Confidential

Sr. ETL Informatica Developer

Confidential is one of the world's largest direct response television companies with sale of nearly 2Billion per year. Originally launched as a television direct marketer but vertically-integrated company has since broadened its focus into every area of electronic retailing, making quality products available to U.S. and international consumers through broadcast television, cable and satellite, as well as internet, telemarketing, direct mail, and retail channels.-related, emissions tests.

Responsibilities:

• Analyzing business requirements and preparing technical documentation and application process and writing test cases.
• Working on Designing and Creating tables for new setup database, writing sub routines as per the business requirement.
• Analyzing and evaluating data sources fields to match the target fields for moving the data from denormalized legacy system to normalized New Setup database.
• Developed mappings to load the date form different sources like oracle, flat files
• Gather and/or clarify requirements directly from the users or PM and developing new informatica process for automating various new ETL activities.
• Writing UNIX scripts to ftp files, cleaning the data, other required functionalities and place them in the proper source/target directories for processing.
• Enhancement of existing complex ETL processes to support additional design, development and deployment of new and enhanced ETL processes to production and support new load strategy.
• Created variables in Expression transformation to compare current record with the previous record and combine the data for these records based on the same claim numbers
• Responsible for creating shared and reusable objects in Informatica shared folder and update the objects with the new requirements and changes.
• Responsible for providing consolidated daily and weekly status reports to the management and team.
• Responsible for coordinating the Offshore and Onsite team and resolve all the issues faced by the team.
• Used FileZilla and WINSCP tool to create and view the parameter files and other source files in Unix in DEV, Testing and Production Environments.
• Extensively used pmcmd commands on command prompt and executed Unix Shell scripts to automate workflows and to populate parameter files
• Created/Enhanced Teradata Stored Procedures to generate automated testing SQLs
• Performance tuning for Teradata SQL statements using Teradata EXPLAIN plan.
• Wrote numerous BTEQ scripts to run complex queries on the Teradata Database directly rather than implementing the same in Informatica, to reduce the time it takes for successful execution.
• Designed, developed and fine-tuned stored procedures. Tuning of SQL queries for better performance. Imported external data flat files into Teradata tables.
• Worked on Change Data Capture data sources.
• Prepared ETL low level and high level design documents.
• Debugging invalid mappings using break points, testing of stored procedures and functions, testing of Informatica sessions, batches and the target Data.
• Wrote SQL, PL/SQL codes, stored procedures and packages for dropping and re- creating indexes, to generate oracle sequences, procedures that cleans up the base automatically in case the mapping already ran, the procedure that will logically expire existing records and update specific Code, packages to incorporate business rules to sometimes eliminates transformation dependency
• Improving the SQL query performance, and updating the technical documents.

Environment: Informatica Power Center v 8.6, Oracle 9i/10g, CSV Files, Excel files, SQL, PL/SQL, Teradata, Unix Shell scripting, Windows XP and, SQ Developer, Toad, Microsoft Visio.

Confidential

Sr. Informatica ETL Consultant

Confidential is one of the world's largest financial institutions, serving individual consumers, small and middle market businesses and large corporations with a full range of banking, investing, asset management and other financial and risk-management products and services. Bank of America Bought one credit card Bank called MBNA Bank, which is a leading credit card company. In this project all the customer data has been converted in BOA format and loaded into BOA data base. The objective is to build various reports as per business requirements that enable the management to take corporate decisions. Using this Data, we have developed different Data Marts and Analysis Reports like Market Shares of BOA and compared with Competitors, Sales performance with Time frames. These reports can give failure analysis for BOA

Responsibilities:

• Creating technical design specifications documents for ETL jobs.
• Creating source to target mappings and developing the ETL mappings using Informatica Power center.
• Developing mappings, sessions and workflows using Informatica.
• Involved in production support to resolve production tickets and data clean up operations.
• Creating SQL,PL/SQL scripts to fix the data in production and development environments.
• Tuning mappings and sessions to optimize the performance.
• Creating SQL's and Oracle scripts to customize the ETL operations in Informatica.
• Preparing unit test cases and documentation.
• Participating in Integration testing and User Acceptance testing.
• Involved in implementation support.
• Playing an effective team member's role in the team of 8.
• Extensively used ETL to load data from wide range of sources such as flat files CSV, fixed-width or delimited .
• Converted PL/SQL code into ETL Informatica mappings.
• Extensively worked on performance tuning and monitoring of programs, ETL procedures and processes.
• Developed ETL Design Documents and managed the Business rules and data validation.
• Maintained both development and production environments since a long time using Power Center, Oracle PL/SQL under UNIX and NT. Involved in writing UNIX parameter files for Informatica jobs.
• Designed MultiLoad scripts to load data into multiple tables based on MultiLoad Layout Labels.
• Worked with transformations such as expression, filter, router, update, union, lookup, rank, connected stored procedures, aggregator, and sequence generator, Sorter, joiner transformation.
• Customized the existing dimensions and fact tables.
• Monitoring the load jobs, checking the error log files for regular load and interacting with users were my primary focus areas.

Environment: Informatica Power Center 8.6.0, Oracle 10g SQL, PL/SQL , TOAD, and UNIX

Confidential

Informatica Consultant

Confidential companies is the leading publisher of standardized achievement tests for children and adults which assist thousands of schools districts cross the nationwide over the years. The Online Assessment System OAS is CTB's state of art and web based assessment platform on which CTB delivers renowned tests for students nationwide U.S.A .The objective of this HWDI project is thus instead of replicating the functionality of all these traditional systems within the online testing platform, OAS platform is integrated through the informatica with two process the first process Track A1 which provides with organizational hierarchy and complete student related data and the second process Track A2 which will integrate OAS to other CTB internal systems to feed the data as per their requirement with the organization and also generates flat files in the specified format with student scores and required information as per the customer requirement.

Responsibilities:

• Participating, understanding and reviewing the functional requirements which, we get from different states with the Business Analyst and signing off the requirement document.
• Prepared technical design document as per the functional specification and unit test cases.
• Developed and tested Informatica mappings based on the specification.
• Used various transformations to extract data from different formatted files and relational source system.
• Developed reusable transformations and mapplets to offset redundant coding and reduced development time and improving loading performance both at mapping and at session level.
• Created tables in staging to reduce code change in mapping to handle dynamic field positions in the source data files and generating flat file with UDF values in customer defined positions.
• Used Informatica client tools - Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, and Transformation Developer for defining Source Target definitions and coded the process of data flow from source system to data warehouse.
• Designed and developed ETL strategy for the Workflows and set dependencies between the workflows.
• Created SQL scripts for configuring staging and OAS environment and parameter files per customer and wrote PL/SQL stored procedures to manipulate the data.
• Created UNIX shell scripts for archiving source files and splitting the file based on the district.
• Analyzed long running SQL's and tuned them.
• Migrated Informatica mappings, sessions and workflows from development environment to QA, CQA and production environments and checking the developed code into CVS for release managements.
• Prepared and maintained all phases of support documents like operation manual, application flows, white board for mappings, workflows and documentation to describe mapping specifications.
• Worked cooperatively with the team members to identify and resolve issues relating to informatica and other database related issues.
• Involved in performance tuning and finding out the bottlenecks.
• Transferred knowledge to out source team prior to my project completion.

Environment: Informatica Power Center v 8.1, Oracle 9i/10g, Flat Files, SQL, PL/SQL, SQL/Shell scripting, UNIX, Windows XP, SQL Loader, Toad, Microsoft Visio.

Confidential

Informatica ETL Developer

Confidential is a world-class organization who is responsible for developing and maintaining applications and systems that support all of PepsiCo's divisions and key partners. QBI provides efficient and effective technical solutions to address complex business decisions and execute business transformation for Quaker other PepsiCo divisions. The applications are business mission critical transactional and decision support systems that include Marketing, financial, supply chain, sales and promotional, and data maintenance.

Responsibilities:

• Reviewed the functional specification document and prepared technical specification document.
• Developed new mappings and making changes to the existing mappings according to Functional specification and changing requirements to extract data from different sources like Oracle Applications modules, Oracle, DB2, and flat files and loaded them into Oracle database.
• Involved in fixing invalid Mappings, Unit and Integration Testing of Informatica mappings and sessions matching with the client's scenarios. Used various Transformations to handle business rules and functionalities depending upon the requirement Created Mapplets with the help of Mapplet Designer and used those Mapplets in the Mappings. Developing reusable transformations to use them across all the mappings. Wrote stored procedures and used stored procedure transformations during pre and post target load.
• Versioned mappings in the Development Environment to keep track of the changes in the mappings.
• Integrated all the mappings and session, created workflows using different tasks in the main folder and setting dependencies between the workflows.
• Monitored data loads to ensure data has been loaded into the warehouse properly and the data is ready for reporting.
• Wrote dynamic parameter files to reduce maintenance, fixing existing parameter files, created files to maintain environment variables and wrote scripts files which uses environment variables to run the workflows
• Designed and maintained the operations support document like application flows, white board for mappings, Session batch and written documentation to describe mapping specifications.
• Involved in performance tuning of sources, targets, mappings, and sessions. Also involved in tuning of SQL queries and PL/SQL procedures
• Migrated Informatica mappings, sessions and workflows from development environment to beta and production.
• Used PMCMD command to start and run the workflow from the UNIX environment.

Environment: Informatica Power Center 8.1/7.1.3, Unix, Windows XP, Oracle 9i, Flat Files, SQL, Pl/SQL, SQL/Shell Scripts, TOAD, SQL Loader, Microsoft Visio, UNIX

Confidential

ETL Informatica Developer

Responsibilities:

• Participating, understanding and reviewing the functional requirements which, we get from different states with the Business Analyst and signing off the requirement document.
• Study of detailed requirement of end users of system their expectations from Applications
• Understand the components of a data quality plan. Make informed choices between sources data cleansing and target data cleansing.
• Strong experience on ER Entity Relationship Data Modeling.
• Experience in Data Conversion from various data sources like Oracle, SQL Server, Fixed Width and Delimited Flat Files, MS Access, XML Files.
• Implementing Documentation and physical designing of data warehouse using ERWIN.
• Extensively worked on Power Center Client Tools like Metadata Manger, Designer, Workflow Manager, Workflow Monitor, and Repository Manager.
• Strong experience on understanding of Business Intelligence and Data Warehousing Concepts with emphasis on ETL and Life Cycle Development.
• Strong experience Data Modeling using Dimensional Data Modeling, Star Join Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling using ERWIN.
• Extensively Used Transformations like Source Qualifier, Expression, Filter, Aggregator, joiner, lookup, Sequence Generator, Router, Sorter and Stored Procedures, Java Transformations. And used debugger to test the mappings and fixed the bugs.
• Involved in fixing of invalid Data Conversion, Data Mappings, Performance tuning, testing of Stored Procedures and Functions, Testing of Informatica Sessions, troubleshooting, Batches and the Target Data.
• Strong Experience on writing SQL Queries, PL/SQL Procedures in Oracle Databases.
• Developed slowly changed dimensions SCD Type 2 for loading data into Dimensions and Facts.
• Involved in Data Extraction from Oracle and Flat Files using SQL Loader.
• Strong experience on using web services when loading data into Data Warehouse.
• Using Toad to increase User productivity and application code quality while providing an interactive community to support the user experience.
• Good experience in writing UNIX shell scripts.

Environment: Informatica 7.1 Power Center , Windows XP/2000, Business Objects XIR2/6.5.1, Oracle 10g SQL, PL/SQL , UNIX, SQL Server 2005.

Confidential

Data warehousing/ETL Developer

This system helps the customer service representatives to deal and transact with customers loan, credit, debit, portfolios, investment etc. The operational data of different financial departments loaded into central Data Warehouse and transformed into different regional data marts. The various corporate metrics/web reports like Credit Profile, Product Profile, and Funds Transfer etc are generated periodically. Informatica Power Center is used to extract the base tables in the data warehouse and the source databases include Oracle.

Responsibilities:

• Extensively used Shell scripts to automate the Pre-Session and Post-Sessions processes.
• Involved in fixing of invalid Data Conversion, Data Mappings, Performance tuning, testing of Stored Procedures and Functions, Testing of Informatica Sessions, troubleshooting, Batches and the Target Data.
• Extensively Used Transformations like Source Qualifier, Expression, Filter, Aggregator, joiner, lookup, Sequence Generator, Router, Sorter and Stored Procedures, Java Transformations. And used debugger to test the mappings and fixed the bugs.
• Created reusable transformations and Mapplets and used them in mappings.
• Created and Monitored Batches and Sessions using Informatica Power Center Server.
• Developed and tested all the backend programs, Informatica mappings and update processes.
• Imported an XML file to Designer, did some modifications, used in the Mappings and exported into an XML file.
• Created the Source and Target Definitions using Informatica Power Center Designer.
• Involved in Extraction, Transformation and Loading ETL Process.
• Worked Extensively on Informatica tools -Repository Manager, Designer and Server Manager.
• Created Repository using Repository Manager.
• Involved in the requirement definition and analysis in support of Data Warehousing efforts.
• Tuned the mappings to increase its efficiency and performance.
• Used Informatica Workflow Manager to create workflows
• Workflow Monitor was used to monitor and run workflows
• Worked on SQL queries and tuned them to improve performance.
• Performed data manipulation using basic functions and Informatica Transformations.
• Involved in production support which also includes trouble shooting of connectivity issues.

Environment: Informatica Power Center 6.1/6.2.2, Oracle 8i, UNIX, TOAD, SQL Loader, Windows NT.

Confidential

ETL/Data warehousing Developer

Responsibilities:

• Designed and developed Informatica Mappings and Sessions based on user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Worked with various data sources like oracle, flat files.
• Performed data manipulation using basic functions and Informatica Transformations
• Most of the transformations used were source qualifier, Aggregators, Connected unconnected lookups, Filters Sequence generators
• Created reusable transformations and Mapplets and used them in mappings.
• Wrote stored PL/SQL procedures for certain Business Requirements
• Written SQL overrides in source Qualifier according to business requirements
• Written pre session and post session scripts in mappings
• Designed Sequential Workflow using Workflow Manager, Workflow Monitor for whole process.
• Created sessions and workflows for designed mappings
• Performed unit testing for the mappings using SQL scripts
• Monitoring the session logs to check the progress of data load.
• Experience in PL/SQL Programming Stored procedures, Triggers, Packages using Oracle SQL, PL/SQL , Teradata and SQL Server, Teradata.
• Strong experience on using web services when loading data into Data Warehouse.

Environment: Informatica Power Center 6.1, Oracle 8i, UNIX, TOAD, SQL Loader, Windows NT.