SUMMARY:

• Over 7 years of IT experience in doing analysis, System Design, Development and maintenance.
• Over 5 years of strong Data Warehousing ETL experience of using Informatica Power Center 8x/7x/6x (Source Analyzer, Repository Manager, warehousing designer, Mapping Designer, Mapplets, Transformations), Informatica Power Mart, PowerConnect, MS SQL Server, Mappings, Mapplets, Transformations, Autosys, Control M, OLAP, OLTP, MOLAP, ROLAP, Datamarts, Datamining. Solid experience in Developing/Optimizing/Tuning mappings using Informatica. Sound knowledge in using Workflow manager (Tasks, Sessions, Worklets and Workflows) and Workflow Monitor.
• Seven years of Database experience using Oracle, MS SQL Server, MS Access, flat files, XML files, COBOL files, SQL, XML, DB2, Teradata, PL/SQL, SQL*Plus, SQL*Loader and Developer 2000.
• Extensive experience in supporting Informatica applications.
• Extensive experience in error handling and problem fixing in Informatica
• 5 years of experience in Dimensional Data Modeling using Data modeling, Star Schema/Snowflake modeling, Fact & Dimensions tables, Physical & logical data modeling and hands on experience in Star and Snowflake schema design in relational, dimensional and multidimensional modeling and De-normalization techniques. Thorough understanding of Kimball and Inmon methodologies. Experience using tools like Kalido for Dynamic Information warehouse.
• Involved in full life cycle development of Data Warehousing.
• Expertise in other ETL tools like Datastage, Pentaho Data Integration.
• Completed documentation in relation to detailed work plans, mapping documents and high-level data models. Worked in Production support team for maintaining the mappings, sessions and workflows to load the data in Data warehouse.
• Worked in a fast paced team environment with excellent communication skills.

TECHNICAL SKILLS:

Data Warehouse Tools : Informatica Power Center 8.6.1, 8.1.1/ 7.1, Informatica Power Mart, Power Exchange, Visio. 
Data bases/RDBMS : Oracle, DB2, XML, Teradata, SQL Server, COBOL, Sybase.
Message Systems : MQ Series, JMS. 
Business Intelligence Tools : Business Objects 6.5/6.0., Cognos, Actuate 8. 
Programming Languages : SQL, PL/SQL, SQL*PLUS, UNIX shell scripts, C, C++, TSQL, TOAD, COBAL. 
Operating Systems : UNIX, Windows NT/2000.

PROFESSIONAL EXPERIENCE:

Confidential, Chicago
Sr. Informatica Developer
Nov 09 to till date:

Confidential is a full-service of insurance, financial, and auto registration agency has been in business since 1988. This is a Claim Data warehouse (CDW) providing Policy Transactions, Premium and Claims Transactions data to the business users. Users want to measure profit over time by coverage, coverage item type, and geographic, demographic and sales distribution channels.
The system is fully integrated, enabling the entry and sharing of policy and claims data among all components of the system and capturing data to complete policy administration, claims administration, policy issuance, billing, reinsurance accounting, and bureau reporting and management reports.

Responsibilities:

• Responsible to meet with business stakeholders and other technical team members to gather and analyze application requirements.
• Responsible for Design database solutions to satisfy application (business and technical) requirements.
• Responsible to implement database solutions using available database development tools like BPM, Informatica Powercenter.
• Responsible to providing first level operational support for development and production database systems.
• Responsible for providingwritten status reports to management regarding project status, task, and issues/risks
• Responsible for developing complexInformaticamappings using different types of transformations like UNION transformation, Connected and Unconnected LOOKUP transformations, Router, Filter, Aggregator, Expression and Update strategy transformations forLarge volumes of Data.
• Responsible forUnitandRegressiontesting of theInformaticaMappings created according to the business requirements.
• Created, optimized, reviewed, and executed Teradata SQL test queries to validate transformation rules used in source to target mappings/source views, and to verify data in target tables
• Using of SQL tools likeTOADto runSQL queriesto validate the data.
• Responsible for creating Workflows and sessions usingInformaticaworkflow manager and monitor the workflow run and statistic properties onInformatica Workflow Monitor.
• Responsible for DefiningMapping parametersandvariablesandSession parametersaccording to the requirements and performance related issues.
• Responsible for Performance tuning of Informatica code for better performance.
• UsedVersion controlprovided byInformaticaon each and every object used. In this way, each and every version of the process will be available for recovery or research purposes.
• DevelopedUnix Scriptsfor updating the control table.

Environment:Informatica PowerCenter 8.6/8.1, Informatica Power Exchange 8.1.1, Teradata SQL Assistant, BTEQ, Business Process Modelling (BPM), SAP R/3 7.1, Oracle 10g/9i,Mainframe,DB2,Flat files, TOAD, Visio,PL/SQL,SQL,UNIX (AIX), Unix Shell Scripting,Windows XP.

Confidential, Pittsburg 
Sr. Informatica developer 
Feb 09 to Oct 09

Confidential is a diversified financial service company that provides a broad range of banking, asset management, wealth management, and corporate and investment banking products and services. The Data mart was primarily designed to provide Marketing Managers with the complete understanding of customer pattern (market based analysis) and their preference (Trend Analysis). This data warehouse was later extended to cater the needs of Sales, Marketing and Human Resources.

Responsibilities:

• Involved with Business Analyst in requirements gathering, business analysis and project coordination.
• Analyzed the source data coming from different sources like Oracle, flat files, XML, DB2, SQL Server and worked with business users and developers to develop the model.
• Involved in dimensional modeling to design and develop the STAR Schema using Erwin.
• Developed data Mappings between source systems and warehouse components.
• Worked closely with data population developers, multiple business units and a data solutions engineer to identify key information that will enhance business decision-making.
• Extensively used Informatica versions for various ETL purposes.
• Involved in migrating repositories from one environment to another environment.
• Developed ETL procedures to ensure conformity, compliance with standards and lack of redundancy, translates business rules and functionality requirements into ETL procedures.
• Used Power Exchange to extract DB2 Source from mainframe server.
• Used Industrial Best Practices for Error handling.
• Developed and test all the backend programs, Informatica mappings and update processes.
• Managed the Metadata associated with the ETL processes used to populate the data warehouse.
• Worked extensively on SQL, PL/SQL.
• Worked on removing bottlenecks for the optimum usage of sources, transformations and targets.
• Used SQL loader to load data from flat files to Oracle target database.
• Performed Unit and Integration Testing of Informatica Sessions, Batches and Target Data.
• Involved in generating reports using Cognos ReportNet 8.0

Environment: Informatica Power Center 8.6.1/8.1.1, Teradata SQL Assistant, Windows XP, Oracle 10g/11g, HTML/XML, SQL Server2000, IBM- DB2.

Confidential, VA
Sr. Informatica Developer 
Jun 08 to Jan 09

Confidential is the nation’s leading provider of saving, planning and paying for education programs. Their Core business is Student Loans. Data Improvement Project (DIP) is to address issues with access and consistency of information for business stakeholders. In DIP, data populated from different sources like Flat files, MS SQL Server, DB2 and RDBMS to Oracle database and Flat files.

Responsibilities:

• Responsible for working with the Business analysts for gathering functional requirements and analysis.
• Responsible for taking Strategic decisions for Complex Process including analyzing 20 years old huge financial legacy data.
• Responsible for working with DBA and Data Modelers for project coordination.
• Responsible for Detail design of each interface.
• Responsible for developing complex Informatica mappings using different types of transformations like Stored Procedure, Connected and Unconnected LOOKUP, Router, Joiner, Filter, Aggregator, Expression and Update strategy transformations for Large volumes of Data.
• Responsible for Unit and Regression testing of the Informatica Mappings created according to the business requirements.
• Responsible for configuring the workflow tasks like EMAIL task, Command task and make it reusable for other team members.
• Responsible for writing stored procedures to increase the performance of Load Strategy.
• Responsible for creating the Batch files for Recurring process (loops concept) to load the 20 years of Historical data and make the process reusable for the rest of the team.
• Responsible for guiding the whole team regarding the workflow level, session level, task level Configurations.
• Guiding the team in migration process by moving the code from one environment to another environment.
• Using of SQL tools like TOAD to run SQL queries to validate the data.
• Responsible for Using ESP and workflow Manager Tools to schedule Informatica jobs.
• Responsible for creating Workflows and sessions using Informatica workflow manager and monitor the workflow run and statistic properties on Informatica Workflow Monitor.
• Responsible for Defining Mapping parameters and variables and Session parameters according to the requirements and performance related issues.
• Responsible to generate Ad-hoc reports using OBIEE.
• Used Version control provided by Informatica on each and every object used. In this way, each and every version of the process will be available for recovery or research purposes.
• Responsible for tuning the Informatica mappings to increase the performance.
• Responsible for Unit and Regression testing of the Informatica Mappings created according to the business requirements.
• Responsible to co-ordinate with Product, SIT, CAT, Performance test teams to fix the Informatica Code defects and various performance related issues.

Environment: Informatica Power Center8.6.1/8.1.1, OBIEE, Business Objects XI R2, Oracle 10g/11g, Mainframe sources(VSAM), DB2, Flat files, MS SQL Server, ESP, Oracle SQL Developer, TOAD 9.0, Visio, PL/SQL, SQL, UNIX (AIX), Unix Sell Scripting, MS DOS, Windows NT.

Confidential, FL
ETL Informatica Developer 
Apr 07 – May 08

Confidential is the largest not-for-profit health care organization in the region. Its network of services extended with Confidential Hospital of Miami, Confidential Children\'s Hospital, South Miami Hospital, Homestead Hospital, Mariners Hospital, Doctors Hospital and Confidential Cardiac & Vascular Institute. The project deals with decision support system, where the information about various entities are integrated and stored in data marts (Point of Service and Care Discovery). These data marts assists various department managers in their decision making process by trending and forecasting.

Responsibilities:

• Interacted with business analysts and business users while gathering business requirements.
• Analyzed the source data coming from different sources like Oracle, flat files, XML, DB2, SQL Server and worked with business users and developers to develop the model.
• Responsible for creating, testing and validating the Informatica mapping against the predefined ETL design standards.
• Responsible for Unit and Regression testing of the Informatica Mappings created according to the business requirements.
• Involved in creating simple to complex mappings using transformations like expression, router, source qualifier, update strategy, joiner, lookup, filter, sorter, normalizer and aggregator.
• Optimized the mappings and debugged the existing mappings to fix various issues in production.
• Analyzed the various bottlenecks at source, target, mapping and session level.
• Involved in performance tuning to get optimal performance.
• Created UNIX wrapper scripts and shell scripts for individual sessions to automate the process.
• Involved in user acceptance testing and system testing while creating and validating the test scenarios and business requirements.
• Involved in deployment of Informatica mappings and sessions from development to test and then to production.
• Documented the entire process for future maintenance and support.
• Created Universes using Business Objects for pulling data for online reporting and analysis.

Environment: Informatica Power Center 8.1/7.1, Informatica Power Exchange 8.1.1,Oracle 8i/9i,Mainframe,DB2,Flat files, PL/SQL, SQL, UNIX (AIX), Unix Shell Scripting, Windows XP.

Confidential, NY 
ETL Informatica Developer
Feb 06 to Mar 07

The Global Transaction Services (GTS) project is involved in the design and development of trade management data mart for Confidential. Confidential provides innovative Mortgage products and Fast Closings to independent brokers throughout the country. Confidential deployed an innovative data warehouse project to scale its branches performance (region wise). This would help the upper level management to lay down an efficient business strategy. Data is extracted from different sources like DB2 UDB, Microsoft SQL server and transformed as per business requirements and loaded into oracle data mart.

Responsibilities:

• Requirements gathering and analysis for the Mortgage Products.
• Involved in development of Logical and Physical data models that capture current state/future state data elements and data flow using Erwin.
• Developed end-to-end ETL processes for Trade Management Data Mart Using Informatica.
• Worked on source analyzer, Designer, Mapping and Mapplet Designer.
• Used Joiner, Aggregator, Expression, Router, Sequence Generator, Update Strategy and Lookup Transformation to manipulate data related to customers.
• Designed and developed Informatica Mappings, Mapplets and Sessions for data loads and data cleansing.
• Developed and implemented various enhancements to the application in the form of production and new production rollouts.
• Extensively worked on confirmed Dimensions for the purpose of incremental loading of the target database.
• Tuning of the mappings and SQL Scripts for a better performance.
• Generated ad-hoc reports as requested by the team lead using Business Objects free hand SQL. Helped in maintenance work related to reports.

Environment: Informatica Power Center 8.1.1/7.1,Power Exchange, Erwin, Business Objects 6.5, Autosys, Oracle 9i, DB2, XML, TSQL, MS SQL Server 2005, Teradata, UNIX (AIX), UNIX Shell Scripting, windows 2000.

Confidential, NY 
ETL Informatica Developer 
Jan 05 to Jan 06

Confidential is one of the Leading Pharmaceutical company in USA and mainly Developed Drugs like Zoloft,Lipitor,Norvasc,Zithromax, Aricept,Diflucan, andViagra. The Name of Project is SSR (Stock Status Report) & the basic aim of Project is to know Stock Status of our Drugs. The Information was acquired from Cord flat files and oracle using ETL to load Data warehouse which enable the End Users to make quicker decisions.

Responsibilities:

• Worked with Business analysts and the DBA for requirements gathering and project coordination.
• Involved in Installation and Setup Informatica Client tools on client machines.
• Performed extraction, transformation and loading of data from RDBMS tables and Flat File sources into Oracle 9i in accordance with requirements and specifications.
• Extensively used various transformations Lookup, Update Strategy, Expression, Aggregator, Filter, Stored Procedures and Joiner etc.
• Performed Unit Testing and tuned the Informatica mappings for better performance
• Used TOAD to run SQL queries.
• Extensively used SQL*Loader to load data from flat files to database tables in Oracle.
• Used Informatica Power Center Workflow manager for session management, database connection management and scheduling of jobs to be run in the batch process.
• Generated Adhoc reports using Query studio in Cognos.
• Actively interacted with business analysts.
• Responsible for writing Unix Shell Scripts to schedule the jobs.

Environment: Informatica Power Center 8.1.1/7.1, Power Exchange, Erwin, Oracle 9i, IMS, TDR, Windows NT, Flat files, Sybase, SQL, PL/SQL, SQL*Loader, Cognos 7, Autosys, UNIX, UNIX Shell Scripts.

EDUCATION:
Bachelors of Technology in information technology