Summary

• 7 years of IT experience in System Analysis, Design, coding and testing of Data Warehousing implementations across Financial, Pharmaceutical, Insurance and Telecom Industries.
• Informatica: 6 years of Data Warehousing experience using Informatica Power Center 9.1/8.6.1/8.1.1/7.1.1/7.0/6.2, PowerMart5.1.1/5.x, Warehouse Designer, Power Connect for SAP / Oracle Apps / Siebel/DB2,, OLAP, OLTP, Autosys, Control M, Expert-level mastery in designing and developing complex mappings to extract data from diverse sources including flat files, RDBMS tables, legacy system files.
• Data Analysis: 5 years of strong experience on Data Design/Analysis, Business Analysis, User Requirement Gathering, User Requirement Analysis, Gap Analysis, Data Cleansing, Data Transformations, Data Relationships, Source Systems Analysis and Reporting Analysis.
• Data Modeling: 2 years of Dimensional Data Modeling experience on Data modeling, ERwin 7.1/4.5/4.0/3.5.5/3.5.2, Dimensional Modeling, Ralph Kimball Approach, Star/Snowflake Modeling, Datamarts, OLAP, FACT Dimensions tables, Physical Logical data modeling and Oracle Designer.
• Data Cleansing: 2 years of Data Cleansing experience using Trillium 7.6/6.5 Converter, Parser, Converter Geocoder , Firstlogic 4.2/3.6 and SQL coding.
• Business Intelligence: over 2 years of Business Intelligence experience using Cognos 7.0/6.0/5.x, Business Objects XI R2/6.5/5.1, Web-Intelligence 2.5, Designer 5.1, BO Developer Suite, Broadcast Agent, Supervisor, Designer, Info View, BO Universe Developer, BO Supervisor, BO Set Analyzer 2.0 , Developer 2000 Forms 4.5/5.0, Reports 2.5/3.0 , SQL Server Integration Server SSIS , MS Access Reports.
• Methodologies: Complete knowledge of data ware house methodologies Ralph Kimball, Inmon , ODS, EDW and Metadata repository.
• Databases: 6 years of experience using Oracle 10g/9i/8i/7.0, Postgre SQL9.0/8.4, DB2 8.0/7.0/6.0, MS SQL Server 2005/2000/7.0/6.0, T-SQL, Teradata V2R5/V2R4/V2R3, Sybase 12.x/11.x, MS Access 7.0/2000.
• Good understanding and hands on experience on other programming languages like JAVA, HTML, AJAX and C and shell scripting specially in Korn and Bourne UNIX shell scripting

Technical Skills

Confidential

Sr. ETL/Informatica Consultant

Frontier Communications is one of the nation's largest independent telecommunications providers offering local, long distance, and Internet access services in 24 states and supporting more than 2 million access lines. Frontier is in the process of acquiring approximately 4.8 million access lines from Verizon Communications and on the way to becoming America's 1 communications carrier focused on rural areas and small and medium-sized towns and cities. The transaction involves 14 states and they need to be converted to Frontier's DPI Billing System.

Responsibilities:

• Responsible for gathering Business requirements and translate into technical requirements.
• Involved in translating the functional requirements into technical mapping specifications and leveraged Informatica Power Exchange 8.6.1 to extract the data from AS/400 DB2 files and Informatica Power Center 8.6.1/9.1 to extract data from Oracle tables and flat files to populate billing, service order and plant interface files, which are then loaded into the Citizens DPI Billing system.
• Experienced in migration of the informatica objects sources, targets, mappings, mapplets, workflows, sessions from 8.6.1 to 9.1.
• Experienced in writing Queries against DB2 on AS400 Environment.
• Experienced in working with DB2 commands for creating objects CRTDUPOBJ, copy files CPYF, removing logicals on a file to improve load performance and calling RPGLLE, CLLE programs to perform testing.
• Experience in optimization/performance tuning techniques implemented to identify bottlenecks- Query tuning Explain Plan, SQL Trace , table partitioning, memory tuning and cache management.
• Expertise in debugging and production support.
• Experience in writing Shell scripts using pmcmd for concurrent execution of Workflows.
• Created repository assigned grants to users to access the repository.
• Used transformations like Joiner, Expression, Connected, Unconnected lookups, Filter, Aggregator, Stored Procedure, Rank, Update Strategy, Router, Sorter, Sequence generator, XML Source Qualifier and Stored procedure transformations etc.
• Developed mappings/sessions using Informatica Power Center 9.1/8.6.1.
• Created Access data collection task in Outlook, for keeping track of the various extracts that are being loaded.
• Worked with Power exchange 8.6.1 to import sources from various schemas in DB2.
• Developed various mappings that use XML sources.
• Developed mappings to generate monthly bill summary file as a XML file.
• FTP scripts and Extraction of Unstructured Data from various Verizon Data formats using Perl/Shell Scripts.
• Responsible for managing Informatica Services like Repository Service, Integration Services, Reference Table Manager Services etc.
• Creating Change Control Requests as required by assigned projects and ensuring end to end extensive support as Data Analyst and address overall data quality, including the design of ETL strategies to source, match a Merge from various disparate systems.
• Debugged mappings by creating logic that assigns a severity level to each error and sending the error rows to error table so that they can be corrected and reloaded into a target system.
• Involved in the Unit testing and System testing.
• Worked on bug fixes on existing Informatica Mappings to produce correct output.

Environment: ETL/Informatica Power Center 9.1/8.6.1/8.5.1, Informatica Power Exchange 8.6, Oracle 11g, PL/SQL, XML, Flat files, UNIX, Toad, SQL Developer, CSV, AS400, DB2, Perl, Shell Scripting, Outlook, HP Quality Center.

Confidential

Sr. ETL/Informatica Consultant

• AXA Equitable is one of the world's premier financial services organizations for Financial Protection and Wealth Management. AXA Equitable, as part of the global AXA Group, is one of the world's premier financial services organizations. AXA brand is represented in United States by: AXA Advisors, LLC, AXA Equitable Life Insurance Company, AXA distributors and Alliance Capital Management L.P.
• The project was to build a data warehouse for operational and strategic reporting MODS . The project was to design, develop and maintain Enterprise data warehouse. The objective is to integrate different source systems into homogeneous environment to build Enterprise Data Warehouse. The goal of the project is to better decision making with appropriate data views.

Responsibilities:

• Extracted data from flat files and oracle database, applied business logic to load them in the central oracle database.
• Developed mappings/Reusable Objects/Transformation/mapplets by using mapping designer, transformation developer and mapplet designer in Informatica PowerCenter7.1.1/8.6.1.
• Knowledge in upgrading from Informatica version 7.1.1 to 8.6.1.
• Created reusable transformations and mapplets and used them in mappings.
• Used Informatica Power Center 8.6.1./7.1.1 for extraction, loading and transformation ETL of data in the data warehouse.
• Worked with data modelers in preparing logical and physical data models and adding/deleting necessary fields using Erwin.
• Implemented Informatica recommendations, methodologies and best practices.
• Implemented populate slowly changing dimension to maintain current information and history information in dimension tables.
• Used Informatica Power Center Workflow manager to create sessions, batches to run with the logic embedded in the mappings.
• Involved in creation of Folders, Users, Repositories, Deployment Group using Repository Manager.
• Worked on different data sources such as Oracle, SQL Server, Flat files etc.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, Union, Lookup, Joiner, XML Source Qualifier and Stored procedure transformations.
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression, Lookup, Update strategy and Sequence generator, Procedure. Knowledge in use of SQL and Java Transformations.
• Worked with Web services.
• Created SSIS Packages to migrate slowly changing dimensions.
• Developed PL/SQL and UNIX Korn Shell Scripts for scheduling the sessions in Informatica.
• Created E-mail notifications tasks using post-session scripts.
• Worked with command line program pmcmd to interact with the server to start and stop sessions and batches, to stop the Informatica server and recover the sessions.
• Wrote SQL, triggers, cursors for implementing business rules and transformations using T-SQL.
• Coded, tested and optimized complex stored procedures with Transact-SQL.
• Created procedures to drop and recreate the indexes in the target Data warehouse before and after the sessions.
• Created deployment groups, migrated the code into different environments.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Involved in configuring LDAP authentication for Informatica.
• Involved in managing the Unix servers and defining the file systems/directory structures on the Unix box for various parameters and deciding the disk space and memory requirements.
• Provided support to develop the entire warehouse architecture and plan the ETL process.
• Documented technical design documents based on the BRD and SRS.

Environment: Informatica Power Center/ Power Mart 8.6.1/7.1.1, Oracle 10g/9i, SQL Server 2008/ T-SQL, PL/SQL, XML,AS 400, MS Access, Web services,JAVA,UNIX, UDB DB2 8.1, Shell Script, SSIS, Business Objects 6.5.

Confidential

Sr Informatica Consultant

AT T Mobility is one of the one of the telecom giants in the in the wireless arena. Huge amount of customer data like Account, Subscription, Services, Geographical, Billing etc., is stored in one of the biggest Teradata warehouse of size 140TB called Business Intelligence Database BID which is used for reporting, business analysis, decision making and also bringing the customers from different billing systems into consolidated AT T customer base. The data in BID is organized as different subject areas like Address, Party, Product, Account, Subscription and Billing. CRM and Mercury are the Data Marts built on top of the central data warehouse which are used by Marketing and Finance teams respectively.

Responsibilities:

• Extensively used Informatica PowerCenter 8.1.1 to extract data from various sources like Teradata, SQL Server, oracle 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.
• Developed Informatica mappings and mapplets and also tuned them for Optimum performance, Dependencies and Batch Design.
• Extensively worked with Informatica Source Analyzer, Warehouse Designer, Transformation developer, Mapplet Designer, Mapping Designer, Repository manager, Workflow Manager, Workflow Monitor, Repository server and Informatica server to load data from flat files, legacy data.
• Designed the mappings between sources external files and databases to operational staging targets.
• 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.
• Wrote Teradata SQL queries according to Process need.
• Generated reports using Teradata BTEQ.
• Wrote BTEQ Scripts for extracting data.
• Consumed a Web Service to retrieve user credentials from an LDAP server.
• Designed dynamic SSIS packages to transfer data crossing different platforms, validate data and data clearing during transferring, and archived data files for different DBMS.
• Deployed SSIS packages and Scheduled Jobs.
• Establish Loading process using MLOAD, FLOAD, and BTEQ.
• Exporting Data using BTEQ and Fast Export.
• Implemented Slowly Changing Dimension methodology.
• Created Several Informatica Mappings to populate the data into dimensions and fact tables.
• Maintaining the bugs in the bug tracker tools based on their severity.
• Developed Perl Script for loading of Data from Source to Target.
• Maintained Versions of Mappings, Mapplets, Sessions, and Workflows etc using StarTeam/Accurev.
• Worked cooperatively with the team members to identify and resolve various issues relating to Informatica and other database related issues.
• Designed and Developed Procedures using T-SQL and UNIX Shell Scripts, Data Import/Export and Data Conversions.
• Optimized and tuned SQL queries, Stored Procedures.
• Trouble shooting the problems using SQL server profiler.
• Designing mapping templates to specify high level approach.
• Involved in Unit testing and documentation.
• Provided production support for Business Users and documented problems and solutions for running the work flow.

Environment: Informatica Power Center 8.6.1, Teradata V2R5/V2R6, Oracle 10g, SQL Server 2008/ T-SQL, SSIS, JAVA, Perl Wrapper Script, SQL, XML, Web Services, Unix HP-UX.

Confidential

ETL / Informatica Developer

Description: Virtual Credit Intelligence VCI is the Global Credit and Collections Data Warehouse providing a standard worldwide reporting environment. VCI is also designed to deliver business intelligence so that Hewlett Packard can better manage the credit lines of its customers. Business Objects is the tool used in VCI. Virtual Credit Professional - Analysis VCPA is a web-based intranet application that is a credit analysis tool and a data repository for HP customer credit-related information. It is the unique front office credit application used by HP Credit to support transaction processing, decision making, static credit data maintenance, and document management. All customer information, credit approvals and static credit data such as credit rating, credit line, credit scores, financial information and credit analysis, is stored in one central location easily accessible by the WW credit community, regardless of physical location.

Responsibilities:

• Responsible for definition, development and testing of processes/programs necessary to extract data from operational databases, Transform and cleanse data, and Load it into data warehouse using Informatica Power center.
• Created the repository manager, users, user groups and their access profiles.
• Extracted data from different sources like DB2, Sql server, flat files and integrated them and loaded them into the central data warehouse.
• Created complex mappings in Power Center Designer using Expression, Filter, Sequence Generator, Update Strategy, Joiner and Stored procedure transformations.
• Created connected and unconnected Lookup transformations to look up the data from the source and target tables.
• Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands to debug troubleshoot and monitor and measure SQL queries and stored procedures.
• Used data miner to process raw data from flat files.
• Used the update strategy to effectively migrate data from source to target.
• Wrote SQL, PL/SQL, stored procedures for implementing business rules and transformations.
• Responsible for writing SQL queries, stored procedures, views, triggers, T-SQL and DTS/SSIS.
• Developed and documented Mappings/Transformations, Audit procedures and Informatica sessions.
• Used Informatica PowerCenter Workflow to create sessions and run the logic embedded in the mappings.
• Used Teradata fast loads for truncate load tables and mloads for insert, update options.
• Created test cases and completed unit, integration and system tests for Data warehouse.

Environment: Informatica PowerCenter 8.1.1/7.x Repository Manger, Designer, Workflow Monitor, Workflow Manager , Teradata, Flat files, DB2, SQL server 2005/T-SQL, SSIS, SQL, PL/SQL, Win 2000.

Confidential

Informatica Developer

Great West Insurance Company serves more than 3.6 million Americans through a full range of managed healthcare, life and disability insurance, and retirement savings products and services. This system gives full information regarding benefits, plans offered by the company, educate people about diseases, prevention, ICD codes, HIPPA act and users can enroll and can avail the benefits offered

Description: The Primary objective is to build a Data Warehouse from different data feeds and other operational data sources. Built a central Database where data comes from different sources like Oracle, SQL server and flat files, and generate reports.

Responsibilities:

• Extensively used Informatica PowerCenter 7.1.2/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 9i using Informatica PowerCenter 7.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.
• In charge of converting data using SQL Server 2005 using SSIS.
• 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 BusinessObjects and Web Intelligence.
• Developed PL/SQL scripts to move historical data from ERP sources to BOW.

Environment: Informatica PowerCenter 7.1.2/8.1, Oracle 10g/9i, Business Objects XI R2, Web Intelligence 2.5, PL/SQL, TOAD, SQL Plus, Erwin, Windows, UNIX HP UX, Control M.

Confidential

ETL Developer

AllState is a leading Insurance company. AllState offers services like health care, retirement and investment, life, accident and disability services, and group insurance benefits. This project is to create and maintain a central data warehouse for all the data and to create reports to give better analysis to the financial group.

Responsibilities:

• Involved in the preparation of High level design documents ADR, TDR, DMD and Low level design documents PS, UTC, REVIEW CHEKLISTS .
• Involved in the analysis of source systems.
• Involved in the preparation of Technical design documents, Source to target S2T document, Review checklist and Program Specifications or Technical Specification.
• Designed the ETL processes using Informatica tool to load data from Oracle database into the target oracle data warehouse.
• Designed and developed Informatica Mappings and Sessions based on business user requirements and business rules to load data from source flat files and oracle tables to target tables.
• Prepared Level 2 Update plan to assign work to team members. This plan is very helpful to know the status of each task.
• Extensively worked in data Extraction, Transformation and Loading from sources to target system using Informatica Power Center.
• Created transformations and mappings using designer tools of Informatica
• Extensively used Lookup, Joiner, Aggregator, Expression, Update, Filter, Router transformations.
• Used debugger to debug mappings to gain troubleshooting information about data and error conditions.
• Followed performance tuning techniques for developing the mappings.
• Prepared UNIX Shell Scripts and these shell scripts will be scheduled in AUTOSYS for automatic execution at the specific timings.
• Prepared test cases and involved in unit testing of mappings, system testing and user acceptance testing.
• Documented the purpose of Data warehouse including transformations, Mapplets mappings, sessions, and batches so as to facilitate the personnel to understand the process and incorporate the changes as when necessary.
• Used Alerters, Filters, Breaks, Sorts and Ranks in the reports.
• Published and retrieved documents through Info view.
• Used the Broadcast Agent Server to Schedule, Refresh Reports.

Environment: Informatica Power Center 6.2/7.1.1, Cognos7.0, Oracle9i, Sybase, Windows XP, UNIX AIX, AUTOSYS, Erwin 3.5, PL/SQL, Toad for Oracle.

Confidential

ETLDeveloper

The Lending Value Calculation System LVCS is a tool for DB to calculate the Lending value for different securities collateral based on their market data. The collateral can take the form of any security, e.g. equities, bonds, gold etc, but the amount that the bank is willing to lend against it depends on a number of features of the individual security. Typically, the bank will lend a percentage 0 P 100 of the market value of the security. It is this percentage that is referred to as the Lending Value.

Responsibilities:

• Created the mapping documents based on the data model and the client requirements.
• Developed Informatica Mappings as per the documents.
• Responsible for testing and migration of ETL maps from the development to production environment.
• Worked on performance tuning.
• Prepared test cases and test plans.
• Loading the data received from the wholesalers and the distributors, which are lying in the Unix box into the data warehouse on daily and weekly basis.
• Involved in analysis of data in various modules of the project.
• Worked with the data-modeling tool Erwin.
• Loaded the Dimension tables with the various Sales force data at various levels.
• Worked with MS-Excel spreadsheet and MS-Word for Documentation.

Environment: Informatica Powercenter 6.2, Cognos 5.x/6.1, DB2, Oracle 8i, UNIX Solaris , Windows NT.

Confidential

ETL Developer

Responsibilities:

• Extracted Data from Different Sources by using Informatica.
• Extensively used Informatica client tools Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformations.
• Cleanse the source data, Standardize the Vendors address, Extract and Transform data with business rules, and built Mapplets using Informatica Designer.
• Extracted data from different sources of databases. Created staging area to cleanse the data and validated the data.
• Designed and developed complex Aggregate, expression, filter, join, Router, Lookup and Update transformation rules.
• Developed schedules to automate the update processes and Informatica sessions and batches.
• Analyze, design, construct and implement the ETL jobs using Informatica.
• Developed UNIX Bourne Shell Scripts for scheduling the sessions in Informatica.
• Created Users, user groups, database connections and managed user privileges using supervisor.
• Created universe and reports.
• Involved in creating desktop intelligence and web intelligence reports.

Environment: Informatica Power Center 5.1.1, Windows NT, UNIX, Bourne Shell Scripting, PL/SQL, Excel, SQL Server 7.0, Erwin, Business Objects 6.5/5.1.