SUMMARY

• Over 7+ years of IT experience in the Requirement Analysis, Data Analysis, Application Design, Application Development, Implementation and Testing of Applications in Data warehousing, OLAP with strong business knowledge of Financial, Insurance, Energy Telecom, Banking domains.
• Extensive Data Warehouse experience using Informatica Power Center v6.x, 7.x, 8.x (Repository Manager, Mapping Designer, Workflow Manager, Mapplet Designer, Workflow Monitor, Source Analyzer, Transformations Designer, Warehouse Designer) ETL tool on Oracle, Sybase, DB2 and SQL Server Databases.
• Experience in supporting the offshore people.
• Expertise in Informatica Performance tuning and Database Performance tuning.
• Extensively used ETL methodology for supporting of Extract, Transform, and Load environment using Informatica Power Center.
• Experienced in implementing the business rules by creating transformations (Expression, Aggregate, Unconnected and Connected Lookup, Router, Update Strategy, Filter, Joiner, Union, SCD’s Type1,Type2,Type3), and developing Mappings.
• Experienced in SQL Optimization and SQL Loader.
• Experience in integration of various data sources like Oracle, Sybase, DB2, SQL Server, and Flat Files.
• Transformation and Loading of data from multiple feeds and sources into Data Warehouse.
• Extensive knowledge of PL/SQL, SQL programming.
• Experience in working with UNIX Shell Scripts for automatically running sessions, aborting sessions and creating parameter files. Written number of shell scripts (Korn Shell) to run various batch jobs.
• Experience on Debugger to validate the mappings and gain troubleshooting information about data and error conditions.
• Good understanding with all phases of SDLC (System Development Life Cycle) including Planning, Analysis, Design, Implementation and Maintenance.
• Have strong work experience with Database Programming in Oracle 10g/9i/8i/7xs, MS Sql Server 2K, & Access.
• Excellent understanding and best practice of Data Warehousing Concepts, involved in Full Development life cycle of Data Warehousing. Expertise in enhancements/bug fixes, performance tuning, troubleshooting, impact analysis and research skills.
• Good exposure in projects with the Onsite - Offshore model.
• Expert in data warehouse performance tuning.
• Data modeling experience using Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, Erwin 4.x.
• Excellent analytical, problem solving skills and a motivated team player with excellent inter-personal skills and familiar with offshore and multi-site development.
• Created the Process Flow Documentation for the Informatica process.
• Good team player, strong interpersonal and communication skills combined with self-motivation, initiative.

TECHNICAL SKILLS:

• Database : Oracle 11g/10g/9i, MS SQL Server 2008/2005, MS Access, DB2, Sybase.
• Operating Systems : Windows 2003/2000/XP/Vista, UNIX, Sun Solaris.
• Programming Languages C, PL/SQL, Perl, java, SQL, UNIX shell scripting.
• ETL Tools : Informatica (Power Center 8.x, 7.x, 6.x).
• Data modeling tools : Erwin 4.x
• Database Tools : TOAD, Visio, Control-M, SQL*Loader, Rapid SQL ,SQL Navigator, PUTTY, Autosys, Mercury Quality Center ,Business Objects, Oracle SQL Developer.

PROFESSIONAL EXPERIENCE:

Client: Confidential, VA. Aug ’10 to till date
Role: Informatica Developer.
Description: Verizon is a leader in delivering broadband and other wire line and wireless communication innovations to mass market, business, government and wholesale customers. Verizon is the wireless phone provider that owns and operates the largestmobile telecommunications network in theUnited States, based on a total of 101.1 million U.S. subscribers. 
Responsibilities:

• Identified data source systems integration issues and proposing feasible integration solutions.
• Partnered with Business Users and DW Designers to understand the processes of Development Methodology, and then implement the ideas in Development accordingly.
• Worked with Data modeler in developing STAR Schemas and Snowflake schemas.
• Created Oracle PL/SQL queries and Stored Procedures, Packages, Triggers, Cursors and backup-recovery for the various tables.
• Identifying and tracking the slowly changing dimensions (SCD)
• Extracting data from Oracle and Flat file, Excel files sources and performed complex joiner, Expression, Aggregate, Lookup, Stored procedure, Filter, Router transformations and Update strategy transformations to extract and load data into the target systems.
• Created reusable Mailing alerts, events, Tasks, Sessions, reusable worklets and workflows in Workflow manager.
• Scheduled the workflows at specified frequency according to the business requirements and monitored the workflows using Workflow Monitor.
• Fixing invalid Mappings, Debugging the mappings in designer, Unit and Integration Testing of Informatica Sessions, Worklets and Workflows.
• Extensively used TOAD for source and target database activities.
• Involved in the development and testing of individual data marts, Informatica mappings and update processes.
• Created repository, users, groups and their privileges using Informatica Repository Manager
• Involved in writing UNIX shell scripts for Informatica ETL tool to run the Sessions.
• Generated simple reports from the data marts using Business Objects.

Environment: Informatica Power Center 8.6.1, Business Objects XI, Oracle 9i, SQL/PLSQL, TOAD, UNIX Shell Programming, UNIX, and Windows NT.
Client: Confidential, Houston, TX. June’09 to Jul’10
Role: Informatica Developer.
NAGP- CDM ( North America Gas and Power- Credit Data Mart)
Description: This application enables NAGP Credit and Contract teams to effectively and efficiently manage measure and monitor credit related risks in a timely manner. This way it helps business to understand credit risk of the entire portfolio and rectify discrepancies in case if any in deal source systems. The objective of CDM application is to:

• Provide a medium to calculate current exposure, potential total exposure and expected loss.
• Monitor and manage future exposure.

The commodities for which exposures and other measures are calculated in CDM include Gas, Power and Coal.

Responsibilities:

• Interacted with Business Analyst (Line of Business) to understand requirements and translated them into the appropriate technical solution.
• Developed complex mappings in Informatica to load the data from various sources using different transformations like Source Qualifier, Look up (connected and unconnected), Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Update Strategy Rank and Router transformations.
• Created data modeling for staging area as well as Data warehouse (Star Schema) database.
• Extensively worked on developing Informatica Mappings, Mapplets, Sessions, Workflows and Worklets for data loads
• Extensively used ETL to load data from wide range of sources such as flat files (CSV, fixed-width or delimited)
• Performance tune ETL mappings, Maintenance and enhancements of ETL code.
• Responsibilities included designing and developing complex Informatica mappings including Type-II slowly changing dimensions.
• Taken part of Informatica administration. Migrated development mappings as well as hot fixes them in production environment.
• Identifies, researches, and resolves ETL root cause of production issues or system problems.
• Created packages using Microsoft Data Transformation Services (DTS/SSIS)
• Created several projects and packages in Framework Manager and worked with Framework Manager to create metadata models and published packages based on the security.
• Constructed Drill Through, Master-Detail and dashboard reports using parameterized filters in Report Studio.
• Validated report results with the source data and sanctioned the reports to production environment.
• Created Reports in Report studio comprising of list reports, cross-tab reports and chart reports, Maps, Repeater tables using underlying multiple query structure by using filters, calculations, complex expressions, conditional formatting, and prompts including cascading prompts.
• Carried out training sessions for users to learn how to execute Cognos reports in Cognos connection.
• Responsible for preparing test cases and technical unit testing for the developed reports.
• Responsible for to analyze and apply new requirements to existing reports.
• Continuously monitor the accuracy of the data and the content of the delivered reports.
• Involved in Onsite & Offshore coordination.
• Responsible for to provide production support and resolve issues.

Environment: Informatica 8.6.1, Toad tool for Oracle (10g), Business Objects XI, Oracle 9i, SQL/PLSQL, TOAD, UNIX Shell Programming, UNIX and Windows.

Client: Confidential, CT
Role: Informatica Developer Dec’08 to May’09
Description:- At Hartford Investment Management Company, asset management is the only business. No matter what kind of institutional investors are – an insurance company, mutual fund or employee benefit plan, a foundation or endowment, or other institution. All disciplines contribute buy/sell ideas and decisions are reached through fluid multi-disciplinary discussions. 
Responsibilities:

• Involved with Business Analyst Team to identify the requirements
• Identified and designed Information analysis attributes and entities
• Written Technical Data Flows and Element Mapping between Source and Target Systems
• Designed ETL architecture and mappings to process data
• Prepared the deployment and metadata standards for ETL processes
• Involved in Designing and creating mappings and Mapplets using Informatica Source Analyzer, Warehouse designer, Mapplet Designer &, Transformation Designer
• Used all Transformations such as Expressions, Filters, Joiners, Aggregators, Lookups, Normalizer and Routers to load consistent data into Database.
• Worked on Mapplets, shortcuts and reusable transformations
• Informatica Workflow Manager usedto create Workflows, database connections, sessions, and batches to run the mappings.
• Various Performance and Tuning techniques used to improve the load.
• Have written complex SQL Queries involving multiple tables with joins.
• Involved in writing of Triggers, Functions, and Packages.
• Tuning PL/SQL procedures and Functions with different utilities like EXPLAIN PLAN, TKPROF.
• Involved in writing UNIX shell scripts and PL/SQL procedures, Pre-session and Post- Session Scripts.
• Involved in development of Control M jobs to schedule the Informatica jobs.
• Extensively worked with Test Director

Environment: Oracle 10g, Linux, Sun Solaris 8, Informatica Power center8.1.1, SQL Loader, Microsoft Visio.

Client: Confidential, Southern California, CA. Oct ‘07 to Nov ‘08
Role: Informatica Developer.

Description: - California National Bank provides consumer, commercial, investment, brokerage and trust banking services, as well as leasing, mortgage services, to individuals and businesses. The project was to design, develop and maintain a data warehouse to understand the client needs, undertake trend analysis, provide better customer service and assess current and future profitability, Cross-sell products to increase revenue generation from the most profitable customers.

Responsibilities:

• Assisted gathering business requirements and worked closely with various Application and Business teams to develop Data Model, ETL procedures to design Data Warehouse.
• Designed and developed star schema model for target database using ERWIN Data modeling.
• Extensively used ETL Informatica tool to extract data stored in MS SQL 2000, Excel, and Flat files and finally loaded into a single Data Warehouse.
• Used various active and passive transformations such as Aggregator, Expression, Sorter, Router, Joiner, connected/unconnected Lookup, and Update Strategy transformations for data control, cleansing, and data movement.
• Designed and developed Mapplets for faster development, standardization and reusability purposes.
• Implemented Slowly Changing Dimension Type 1 and Type 2 for inserting and updating Target tables for maintaining the history.
• Used Debugger to validate transformations by creating break points to analyze, and monitor Data flow.
• Tuned performance of Informatica Session by increasing block size, data cache size, sequence buffer length and Target based commit interval, and mappings by dropping and recreation of indexes.
• Worked along with the QA Team and provided production support by monitoring the processes running daily.
• Involved in pre and post session migration planning for optimizing data load performance.
• Interfaced with the Portfolio Management and Global Asset Management Groups to define reporting requirements and project plan for intranet applications for Fixed Income and Equities.
• Performed Unit testing during the mapping phase to ensure proper and efficient implementation of the transformations.
• Wrote UNIX Shell Scripts and pmcmd command line utility to interact with Informatica Server from command mode.

Environment: Informatica Power Center 7.x, MS SQL 2000, Oracle 9i, SQL, PL/SQL, SQL Navigator, Erwin 4.1, UNIX Shell Scripting, Windows XP and 2000.

Client: Confidential, MA
Role: Oracle DB/Informatica Developer May’06 to Aug’07

Description: This project involves building a Data warehouse. Worked for the brokerage department which arranges loans on mortgages .The primary aim of this project is to integrate the data sources from existing system and to provide analysis to make business related decisions.
Responsibilities

• Involved in Designing and developing multi-dimensional model (Star Schema) using Erwin
• Scheduling meetings with the business users to gather the business analysis reporting requirements.
• Designing and developed ETL process.
• Developed Mappings and reusable Transformations and Mapplets.
• Extensively worked with Informatica Transformations and also Override SQL using Oracle Functions.
• Informatica Server Manager usedto create database connections, sessions, and batches to run the mappings.
• Various Performance and Tuning techniques used to improve the load.
• Involved in writing of Triggers, Functions, and Packages.
• Converting from SQL/Procedures and SQL Loader scripts to Informatica mappings
• Scheduling the batches and sessions for daily loads.
• Automation of FTP process to and from source systems.
• Involved in writing Unix shell scripts and PL/SQL procedures, Pre-session and Post- Session Scripts

Environment: Oracle9i, Sun Solaris, Windows NT/2000, Informatica PC 6.x SQL loader, Toad Modeler.

Project Description: 
ZIL is a project for the Birla Group of companies in providing the Zuari industries with a comprehensive Data store for their analytical purpose of their Sales and Purchase of Fertilizers and Pesticides.

Responsibilities:

As Tech Lead & Developer

• Worked as a Data Modeler and Data Analyst.
• Worked at the client Site for the Building a Data warehouse Scheme.
• Analyzed, diagnosed and resolved business and technical issues effectively consulting with clients.
• Worked with ETL tools in building a CUBE for the logical design.
• Worked on Purchase, Sales, Transport Billing, And Regional Accounting System Modules.

Environment: Informatica, Oracle.