PROFESSIONAL SUMMARY
7+ years of IT experience in Analysis, Design, Development, Maintenance and Documentation for Data warehouse and related applications using ETL, BI tools, Client/Server and Web applications on UNIX and Windows platforms. Experience working in Banking, Financials, Healthcare, Pharmaceuticals and Insurance sector.

• Expert level experience in implementing advanced ETL methodologies for corporate wide – ETL solution using Informatica Power Center 9.x/ 8.6/7.x/6.x.
• Data modeling knowledge of Ralph Kimball’s Dimensional Data Modeling using Star Schema and Snow-Flake Schema.
• Experience in user interaction to gather and analyze the project requirements.
• Strong expertise in design, development and integration of complex ETL processes.
• Experience with databases like Oracle, SQL Server, Teradata and MS Access 2000 and excellent in writing, testing and implementation of triggers, stored procedures, functions, packages,dimensional loading of tickets using PL/SQL.
• Strong Experience in designing and developing complex mappings using various transformations for implementing advanced ETL techniques such as slowly changing dimension, change data capture and incremental loading.
• Extensively worked on transformationslike Aggregate, Lookup, Router, Filter, Joiner, Update Strategy, Sequence generator, Normalizer transformations.
• Expertise in defining Workflows and Tasks, Monitoring Sessions, load scheduling and automation of Informatica workflows using shell scripting.
• Experience in performance tuning of ETL Mappings involving ETL Sources, Targets, Transformations, stored procedure and Sessions.
• Experience in upgrading Informatica Repository, making related changes to existing models, mappings to resolve upgrade issues and also responsible for Informatica server administration.
• Expertise in working on the releases, providing production, technical and onsite release support.
• Excellent analytical, problem solving and communication skills, with ability to interact with individuals at all levels.

TECHNICAL SKILLS
ETL Tools: Informatica Power Center 9.x/8.x/7.x/6.x, Informatica Power Mart 5.0, Informatica Power Connect, Informatica Power Exchange.
Databases: Oracle 11g/10g/9i/8i, MS SQL Server 2008/2005/2000, DB2, Teradata.
Reporting Tools: Oracle BI Apps, OBIEE(10.x), Business Objects.
Data Modeling: Erwin 3.5/4.0/7, UML.
Data Modeling Methodologies: Logical/Physical/Dimensional, Star/Snowflake, ETL, OLAP, Complete Software Development Life Cycle.
Programming Languages: SQL (DDL and DML), PL/SQL, C, Java 
Operating Systems: UNIX, Linux, MS Windows 2000/NT/XP/VISTA/7.
Other Tools: TOAD, VISIO, SQL * PLUS, SQL * PLUS Loader, Trillium, QA.

EXPERIENCE 

Confidential, Boston, MA Oct’10-Till date Sr. Informatica Developer
Confidential is one of the leaders in financial services, offering solutions to clients in more than 100 countries.They offer a variety of products and services,asset management, investment banking, private banking, treasury and securities services,and commercial banking. A data warehouse has been built for cash reserve calculations, customer information sales tracking.The architecture involved moving data from legacy systems to relational tables in the staging area, moving staging data to the Data Mart and finally moving data to the Multi-Dimensional Data Warehouse which is stored in Oracle 11g.

• Worked with business analysts to identify appropriate sources for data warehouse and prepared the Business Release Documents, documented business rules, functional and technical designs, test cases, and user guides.
• Actively involved in the Design and development of the STAR schema data model.
• Implemented slowly changing and rapidly changing dimension methodologies; created aggregate fact tables for the creation of ad-hoc reports.
• Extensively Used Change Data Capture (CDC) to simplify ETL in data warehouse applications.
• Extensively worked on Connected & Unconnected Lookups, Router, Expressions, Source Qualifier, Aggregator, Filter, Sequence Generator, etc.
• Created and maintained surrogate keys on the master tables to handle SCD type 2 changes effectively.
• Mentored Informatica developers on project for development, implementation, performance tuning of mappings and code reviews.
• Used SQL tools like TOAD to run SQL queries and validate the data in warehouse and mart.
• Developed Informatica mappings/mapplets, sessions, Workflows for data loads and automated data loads using UNIX shell scripts.
• Used variouslookup caches like Static, Dynamic, Persistent and Non-Persistent in Lookup transformation.
• Involved in debugging mappings, recovering sessions and developing error-handling methods.
• Successfully migrated objects to the production environment while providing both technical and functional support.
• Developed E-MAIL tasks to send mails to production support and operations.
• Used Session Parameters to increase the efficiency of the sessions in the Workflow Manager.
• Designed and developed UNIX Scripts to automate the tasks.
• Resolved memory related issues like DTM buffer size, cache size to optimize session runs.

Environment: Informatica Power Center 8.6/9.1, Power Exchange (CDC), IDQ, IDE, Oracle 11g, Erwin–7.0, TOAD 9.x, Oracle Financials, Shell Scripting, Oracle SQL *Loader, OBIEE, PL/SQL, and Sun Solaris UNIX, Windows-XP

Confidential, Fairfield, CT Nov’09-Sep’10 Sr. Informatica Developer
Confidential is an advanced technology, services and finance company taking on world’s toughest challenges. They have consistently received high ratings for financial strength and claims paying ability from various independent rating agencies. The Insurance Data warehousing project was developed in an effort to streamline the entire process of Insurance and to keep track of various financials on a daily, weekly, monthly basis. Policy, Premium, Claims and Payments were the modules we were basically dealing and make it available for analysis and reporting.

Responsibilities:

• Involved in business analysis and technical design sessions with business and technical staff to develop requirements document and ETL design specifications.
• Used Erwin for Logical and Physical database modeling of the warehouse, responsible for database schemas creation based on the logical models.
• Designed and developed mapping, transformation logic and processes in Informatica for implementing business rules and standardization of source data from multiple systems into the data warehouse.
• Created mappings to load the data mart with the use of transformations like Aggregator, Filter, Router, Expression, Joiner, Sequence generator and Update Strategy.
• Involved in performance tuning of targets, sources, mappings, and sessions.
• Wrote complex SQL scripts to avoid Informatica Look-ups to improve the performance as the volume of the data was heavy.
• Implemented Error Handling Strategy in Mappings to fix the Errors.
• Co-ordinate off shore team and provided training in understanding business requirements and performed code reviews.
• Involved in creation of Technical specification document (Source to Target) for the project by conducting technical meetings.
• Created stored procedures to extract data from various data sources like Oracle and SAP.
• Involved in unit testing of the mappings and mapplets.
• 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 pmcmd to run workflows and used schedulers for scheduling of sessions.
• Used Trillium to improve data quality.
• Used different kind of tasks like Event wait and Event raise in the Workflow designer.
• Created and monitored sessions using workflow manager and workflow monitor.
• Interacted with offshore team members on a regular basis.

Environment: Informatica Power Center 8.6, Oracle 10g, SQL Server 2005, Sybase, Windows XP, UNIX, SQL Developer, SQL, PL/SQL, Oracle SQL *Loader, QTP, Erwin 4.0, Trillium, OBIEE.

Confidential, Dublin, OH Oct’08 - Oct’09
Informatica Developer
Confidential is a global healthcare company that develops and delivers the information, products, services and technologies that improve the essential processes in the healthcare industry. The company manufactures packages and distributes pharmaceuticals and medical supplies, offers a range of clinical services and develops automation products that improve the management and delivery of supplies and medication for hospitals, physician offices and pharmacies.

Responsibilities:

• Extensively used Informatica Power Center 8.1 to extract data from various sources and load in to staging database.
• Extensively used transformations such as Source Qualifier, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Joiner, Transaction Control and Stored Procedure.
• Extensively used ETL to load data from multiple sources to Staging area (Oracle 10g) using Informatica Power Center 8.1 Worked with pre and post sessions, and extracted data from Transaction System into Staging Area. Knowledge of Identifying Facts and Dimensions tables.
• Tuned sources, targets, mappings and sessions to improve the performance of data load.
• Designed Logical and Physical Modeling using Erwin Data Modeler tool.
• Did data migration of Informatica Mappings, Sessions, and Workflows to Data Integrator.
• Created data stores, project, jobs, and data flows using Data Integrator.
• Involved in the Development of Informatica mappings and mapplets and also tuned them for Optimum performance, Dependencies and Batch Design.
• Created Several Informatica Mappings to populate the data into dimensions and fact tables.
• Worked cooperatively with the team members to identify and resolve various issues relating to Informatica and other database related issues.
• Designing mapping templates to specify high level approach.
• Involved in creating/modifying reports using Business Objects and Web Intelligence.
• Developed PL/SQL scripts to move historical data from ERP sources to BOW.

Environment: Informatica Power Center 8.1, Oracle 10g, Teradata, Business Objects XI R2, Web Intelligence 2.5, PL/SQL, TOAD, SQL*Plus, Erwin, Windows, UNIX HP UX, Control M.

Confidential, Malvern, PA Jun’07-Sep’08
Informatica Developer 
The project dealt with the Sales & Marketing Data collected from different tests and IMS data which consisted of all the sales and marketing information for the drugs in the market and prescriber information (Hospitals and private clinics). The data was then consolidated into the data mart which was used for report generation. Responsibilities:

• Interacted with the business community and database administrators to identify the business requirements and data realties.
• Responsible for dimensional modeling of the data warehouse to design the business process.
• Designed new database tables to meet business information needs. Designed Mapping document, which is a guideline to ETL Coding.
• Developed a number of Informatica Mappings, Mapplets and Transformations to load data from relational and flat file sources into the data warehouse.
• Used SQL queries and database programming using PL/SQL (writing Packages, Stored Procedures/Functions, and Database Triggers).
• Used various transformations like Source Qualifier, Lookup, Update Strategy, Router, Filter, Sequence Generator, and Joiner on the extracted source data according to the business rules and technical specifications.
• Loaded the data from IMS files into oracle tables using Informatica with any data cleansing required.
• Worked on SQL tools like TOAD to run SQL queries and validate the data.
• Worked on database connections, SQL Joins, views in Database level.
• Extensively used SQL*Loader to load Data from flat files to Database tables in Oracle.
• Used Power Center server manager/Workflow manager for session management, database connection management and scheduling of jobs to be run in the batch process.
• Used UNIX shell scripting for Scheduling Informatica Workflows.
• Optimized the mappings using various optimization techniques and also debugged some existing mappings using the Debugger to test and fix the mappings.
• Implemented procedures/functions in PL/SQL for Stored Procedure Transformations.
• Monitored workflows and collected performance data to maximize the session performance.

Environment: Informatica Power Center 7.1.2, MS SQL Server 2005, Oracle 9i, ERWIN 4.0, WINDOWS XP, DB2, PL/SQL, SQL.

Confidential, Seattle, WA Apr’ 06-May’ 07
Role: ETL Informatica Developer
The scope of the project is to build Data Marts for business analysis departments, such as generation, transmission, distribution and customer satisfaction. The project involved extracting data from the different sources and loading into data Mart. It enables an insight in to the current and future customer service and helps in making business decisions based on the reports generated from data warehouse.
Responsibilities:

• Developed Logical and physical database designs for the transaction system.
• Extract the XML file from source transform it with multiple transformation including XML Transformation.
• Performance tuning on sources, targets, mappings and SQL queries in the transformations.
• Used PL/SQL Views, Triggers, Procedures and Functions.
• Designed and developed complex ETL mappings making use of transformations like Source Qualifier, Expression, Joiner, Update Strategy, Connected Lookup and unconnected Lookup, Rank, Router, Filter, Aggregator and Sequence Generator transformations.
• Created reusable transformations and mapplets based on the business rules to ease the development.
• Developed mappings to implement type 2 slowly changing dimensions.
• Developed and implemented the Unix shell script for the start and stop procedures of the sessions.
• Used various Informatica Error handling technique to debug failed session.
• Developed workflow tasks like reusable Email, Event wait, Timer, Command, Decision.
• Used various debugging techniques to debug the mappings.
• Created Test cases for Unit Test, System Integration Test and UAT to check the data quality.
• Created Materialized view for summary data to improve the query performance.

Environment: Power Center 6.2 ,Oracle9i, SQL Server 2000, SQL,PL/SQL, shell scripts, Mainframe DB2, MS Visio, ERWIN Data Modeling tool, Toad 8.0, Windows 2000,XML,UNIX.

Confidential Mar’ 05 – Mar’ 06
Informatica Developer
Confidential project is a strategic initiative designed to improve the client reporting efforts of the various functional groups. Reliance is expected to create competitive advantage by improving the management decision making process with more accurate and timely information and improving the quality of the client interactions with better advance communication and coordination among the various teams. 
Responsibilities:

• ETL tool Informatica was used to load strategic source data to build the data marts.
• An operational data store was created. Metadata Build up was designed for performing data mapping.
• Also involved in Mass data loads, refreshing the data in various applications, Performance evaluations, modifying the existing code to accommodate new features.
• Used various Transformations like Aggregator, Router, Expression, Source Qualifier, Filter, Lookup, Joiner, Sorter, XML Source qualifier, Stored Procedure and Update Strategy.
• Worked extensively on Flat Files, as the data from various Legacy Systems are flat files.
• Have setup Test and Production Environment for all mappings and sessions.
• Created and configured Sessions in Workflow Manager and Server Manager.
• Debugged the sessions using Debugger and monitored Workflows, Worklets and Tasks by Workflow Monitor.
• Extensively used SQL & PL/SQL for Transformations.
• Developed Oracle stored procedures, packages and triggers for data validations.

Environment: Informatica Power Center 6.1, Oracle 8i, SQL, PL/SQL, IBM DB2, TOAD, Windows 2000

EDUCATION: Bachelor’s degree in Electronics and Communication Engineering .