Summary of Qualifications:

• 7+ years of IT experience in various phases of IT projects such as analysis, design, coding and testing, deployment and production support. Extensive experience in the implementation of Data warehouse/ Data marts for various clients.
• 6+ years of extensive experience with ETL tool Informatica in designing the Workflows, Worklets, Mappings, Configuring the Informatica Server and scheduling the Workflows and sessions using Informatica Power Center 8.x/7.x/6.x/5.x. and Power Mart .
• Proficient in the development of ETL (Extract, Transform, Load) processes with a good understanding of source to target data mapping, ability to define, capture metadata and business rules.
• Knowledge in Data Analyzer tools like Informatica Data Quality, Informatica Data Explorer and Informatica Power Exchange.
• Responsible for all activities related to the development, implementation, administration and supportof ETL processes for large-scale data warehouses using Power Center and Power Exchange
• Experience in Administration activities like Creating and Managing Repositories, Users, User Groups, Folders, Working with Administrator functions of Repository Manager.
• Extensive experience in Designing and developing complex mappings from varied transformation logics like Unconnected and Connected lookups, SourceQualifier, Router, Filter, Expression, Normalizer, Aggregator, Joiner, Update Strategy, Rank, XML, Source Qualifier etc.
• Experience in Debugging and Performance tuning of targets, sources, mappings and sessions. Experience in optimizing the Mappings and implementing the complex business rules by creating re-usable transformations, Mapplets and PL/SQL stored procedures.
• Implemented Slowly Data Capture (SDC) techniques like (type1, type2, and type3) in slowly growing targets, and simple pass through mapping using Power Center.
• Hands on experience on Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling using Erwin.
• Hands on experience on Dimensional Data modeling and Relational Data modeling.
• Expertise in the QAprocess of ETL mappings like unit, Functional and Integration testing.
• Extensive experience with relational databases (Oracle 9i/10g, DB2, SQL, PL/SQL).
• Involved in complete System Software development Life Cycle (SDLC) of Data warehousing, Decision Support System.
• Experience in different Data Sources like Teradata, Oracle, DB2, XML, FlatFiles
• Experience in Oracle and Other Utilities/tool: TOAD, SQL Developer, PL/SQL Developer, Teradata SQL assistant, UNIX Shell Scripting, Export/Import, SQL*Loader.
• Excellent communication skills and Ability to work in-groups as well as independently.
• Effective problem-solver, Organized and Team player.

Technical Competencies:

ETL Tools: Informatica Power Center, Power Exchange, Power Connect
Reporting Tools: Cognos, Business Objects, Crystal reports.
Operating Systems: Windows XP, 2000, UNIX, Linux.
Programming skills: C, C++,HTML, JavaScript, Visual basic, SQL, PL/SQL.
Databases: Oracle 8i/ 9i, 10g/11g, MS Access,DB2, Sybase, Teradata, MS SQL Server 2000/2005,
Other Tools: TOAD, SQL Navigator, PL/SQL Developer, Teradata SQL Assistant, SQL LOADER, Visual Basic 6.0/5.0

Professional Experience:

Confidential April 09 - Till Date
Sr. Informatica Developer

Bank of America Corporation is a financial services company, the largest bank holding company in the United States, by assets, and the second largest bank by market capitalization. The company is a member of the Federal Deposit Insurance Corporation (FDIC) and a component of both the S & P 500 Index and the Dow Jones Industrial Average.

Responsibilities:

• Involved in all phases of SDLC from requirement, design, development, testing, training and rollout to the field user and support for production environment.
• Identified the facts and dimensions and designed the relevant dimension and fact tables.
• Involved in production support activities with Installation and Configuration of Informatica Power Center 8.6.1/8.1.1 versions, both Client, and Server.
• Developed PL/SQL scripts and stored procedures to create necessary indexes and for loading data from various sources to staging area.
• Extensively used Informatica Client tools Repository Manager, Designer, Workflow Manger and Workflow Monitor.
• Developed various mappings using Mapping Designer and worked with Aggregator, Lookup (connected and unconnected), Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter and SequenceGenerator transformations.
• Created Complex Mappings which involved slowly Changing Dimensions (SDC) to implement Business logics.
• Created and scheduled Sessions, Jobs based on demand using Workflow Manager and monitored workflows and sessions using Workflow Monitor.
• Performed Unit testing, Integration testing and System testing of Informatica mappings.
• Used Debugger in troubleshooting the existing mappings.
• Involved in Fine tuning SQL overrides and Look-up SQL overrides for performance enhancements.
• Extensively involved in parameterization of the workflow objects.
• Proficiency in error handling mechanisms.
• Executed sessions, sequential and concurrent batches for proper execution of mappings.
• Wrote UNIX shell scripts Pre and Post session commands and executed on Source and Target database.
• Experienced in Troubleshooting and Performance Tuning of sessions.
• Experience in ETL design documentation, reviewing designs and mappings to ensure compliance to standards and processes.
• Created and integrated reconciliation mappings for loading into ODS and Data mart
• Wrote documentation for all mappingsand workflows done.

Environment: Informatica power Center 8.6.1/8.1.1 (Repository Manager, Designer, Workflow Manager, Workflow Monitor), DB2, Oracle 10g, SQL*Loader, Flat Files, MS SQLServer 2005, Control - M, Erwin 4.1/4.0, UNIX Shell Scripting, TOAD, Windows XP.

Confidential Westbrook, Maine Jan 08 - Mar 09
ETL Informatica Developer

IDEXX Laboratories, Inc. is a multinational corporation engaged in the development, manufacture, and distribution of products and services for the veterinary, food, and water testing markets.

Responsibilities:

• Involved in building a common Customer Data Mart (CDM) from the data coming from different divisions.
• Involved in gathering the requirements from the end users.
• Involved in the analysis of the user requirements and identifying the sources.
• Created technical specification documents based on the requirements.
• Involved in the design and development of Stage, ODS and CDM layers for the CVC program.
• Involved in design, analysis, implementation and support of ETL processes for Stage, ODS and CDM layers.
• Involved in production support activities with Installation and Configuration of Informatica Power Center 7.0/7.1.2/7.1.4 versions, both Client, and Server.
• Prepared ETL standards, naming conventions and wrote ETL flow documentation for Stage, ODS and CDM layers.
• Created Shell scripts to start/stop workflows which would be invoked by TIDAL scheduler.
• Extensively used pmcmd command to invoke the workflows from UNIX shellscripts.
• Prepared Run books providing guide lines to trouble shoot the errors occurred during the run time.
• Used Informatica Workflow Monitor, Workflow Manager, and Designer to monitor and control jobs.
• Wrote DB2 stored procedures/functions to read and write data for the Control Processes at Stage, ODS and CDM levels.
• Create mappings accessing data from DB2 mainframes using Informatica Power Connect.
• Designed and developed various kinds of mappings using different transformations like Expression, Aggregator, External Procedure, Stored Procedure, Lookup, Filter,Joiner,Rank,Router, Update Strategy and XML.
• Analyze Informatica Session logs for failed processes and accordingly create and assign defects in Test Director.
• Creation on status reports for various daily jobs and reporting any mismatches.
• Capturing the process timings of scheduled jobs and maintaining the records.
• Wrote SQL / PL SQL scripts as required checking various jobs status.
• Developed UNIX shell scripts to invoke the stored procedures for the control process for the parameter file generation and to automate the ETL process.
• Helped the Tuning team in tuning the existing mappings and sessions to improve the performance.
• Involved in preparing test plans and testing all the ETL process.
• Developed various Ad-hoc mappings for various business needs.

Environment: Informatica Power Center 7.0 /7.1.2/7.1.4, IBM Mainframes, DETAIL/Power Connect for Mainframe,DB2, Oracle 10g/9i, DB2, Erwin 3.5.2, PL/SQL, WINCVS, TIDAL, Windows XP, SunOS 5.9, HP-UX, IBM AIX, TOAD, Windows XP/2000

Confidential, Hartford, Connecticut Sep 06 - Dec 07
Informatica Developer

The Hartford Financial Services Group, Inc, usually known as The Hartford, is a Fortune 100 company and one of America's largest investment and insurance companies. The Hartford is a leading provider of investment products, life insurance and group benefits; automobile and homeowners products, business property and casualty insurance.

Responsibilities:

• Participated in business analysis, ETL requirements gathering, physical and logical data modeling and documentation.
• Analyzed business requirements, performedsource system analysis, prepared technical design documents.
• Developing ETL design, change data capture, creating SQL views.
• Designing and developing Informatica mappings, sessions, worklets and workflows.
• Establishing and monitoring issue management, risk management and quality management processes.
• Loading data from Flat Files into the Staging area and into the datamart using Informatica PowerCenter.
• Extensively used Router, Lookup, Aggregator,Expression,Normalize, Sorter, Incremental aggregation, store procedure and Update Strategy, Transformations.
• Debugger to monitor and ensure correct flow of data through mapping.
• Responsible for validating the Informaticamappings against the pre-defined ETL design standards.
• Made substantial contributions in simplifying the development and maintenance of ETL by creating re-usable Mapplets and Transformation objects.
• Worked with pre and post sessions, and extracted data from Transaction System into Staging Area.
• Tuning the Mappingsfor Optimum Performance, Dependencies and Batch Design.
• Tunedperformance of Informatica sessionfor large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Created, launched & scheduled tasks/sessions. Configured email notification. Setting up tasks to schedule the loads.
• Scheduling and monitoring automated daily and weekly jobs.
• Migrated Mappings, Sessions and Common Objects from Development to Test and to Production.
• Involved in creating test cases.
• Developedthe documentation on the complete ETL process.
• Prepared Run books, migration documents and production monitoring and support handbook for daily, weekly and monthly processing.
• Generatedthe List Reports, Drill through Reports, and Cross Tab Reports using CognosImpromptu.
• Sending the updatedstatus report to the client/vertical manager on weekly basis.

Environment: Informatica Power Center 6.1.2 (Repository Manager, Designer, Workflow Manager, and Workflow Monitor), Oracle 9i, DB2, MS SQL Server 2000, Teradata V2R5, SQL, T-SQL, PL/SQL, SQL*Plus, Cognos 6, TOAD, Erwin 4.0, HP UNIX 10.2, WINDOWS NT.

Confidential, Madison, Wisconsin June 05 - Aug 06
Informatica Developer

Department of Revenue is a department of the Wisconsin state government responsible for the collection of taxes as well as valuing property and the wholesale distribution of alcoholic beverages and enforcement of liquor laws.

Responsibilities:

• Designed, developed Informatica mappings, enabling the extract, transport and loading of the data intotarget tables.
• Extensively worked on Informatica client tools like Designer, Workflow Manager and Workflow monitor.
• Created complex mappings using Aggregator, Expression, Joinertransformations including complex lookups, Stored Procedures, UpdateStrategy and others.
• Created Workflow, Work lets and Tasks to schedule the loads at required frequency using Workflow Manager.
• Designed and developed table structures, stored procedures, and functions to implement business rules.
• Extensively involved in migration of ETL environment, Database objects and EDW.
• Tested data integrity among various sources, targets and various performance related issues.
• Debugging and problem resolution in Reports and Forms. Generated master-detail, matrix groups and tabular reports.
• Involved in jobs scheduling, monitoring and production support in a 24/7 environment.

Environment:
Informatica Power Center 5.1, Windows 2000, Sun Solaris, SQL Server 2000, Oracle 8i, PL/SQL,UNIX Shell Scripting.
Confidential, Bangalore, India Sep 03 - May 05
Oracle Developer

This project is aimed at developing a single, structured and integrated Data Warehouse for Nestle Information Systems (NIS), giving robust and standardized reports. Data is extracted from various OLTP systems like billing, order and provisioning etc. The data from the OLTP systems is extracted and loaded into staging tables first and after processing of these raw data, they are inserted into the target database tables.

Responsibilities:

• Involved in Data transferfrom OLTP systems forming the extracted sources.
• Interpreted logical and physical data models for Business users to determine common data definitions and establish referential integrity of the system.
• Analyzed the sources, transformed the data, mapped the data and loadingthe data into targets using Power Center Designer.
• Designed and developed Oracle PL/SQL Procedures.
• Designed and Developed Oracle PL/SQL and Shell Scripts, DataImport/Export, Data Conversions and Data Cleansing
• Worked on Informatica Utilities - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Worked with various transformations like Source Qualifier, Expression, Filter, Aggregator, Lookup, Update Strategy, Stored Procedure, Sequence generator, joiner transformations.
• Involved in creating Shell Scripts toautomatePre-Session and Post-SessionProcesses.
• Developed Sessions and Batches to schedule the loads at required frequency using Power Center Server Manager 5.1.
• Involved in data quality testing.

Environment: Informatica Power Center 4.1 and Power Mart 5.1, Oracle 8i, SQL, PL/SQL, Quest TOAD 7.3 and Windows NT.

EDUCATIONAL QUALIFICATION:

• Bachelor's of Technology in Computer Science