Summary:

• More than 8 years of professional IT experience in Analysis, Design, Development, Testing and Implementation of various Data Warehousing and Software Applications.
• Over 7 years of extensive experience of BI / Data warehouse projects using Informatica Power Center with strong understanding of Business, Extraction, Transformation and Data Loading from heterogeneous sources like Flat files, Excel, XML, Oracle, Sybase, SQL Server.
• Experienced in different data warehousing/ETL tools Informatica 6.1/7.1/ 8/9, Power Mart 6.1/5.1/4.7, Power Center 9.5/9.1/ 8.6.1/8.1/7.1.2/7.0/6.2 Power Exchange, Power Connect. .
• Experienced in Informatica Power Center tools Designer, Repository Manager, Workflow Manager, and Workflow Monitor .
• Understanding Working knowledge of Informatica CDC Change Data Capture .
• Developed Strategies for Extraction Transformation Loading ETL mechanism.
• Creation and maintenance of Informatica users and privileges.
• Migration of Informatica Mappings/Sessions/Workflows from Dev, QA to Prod environments.
• Created Groups, roles, privileges and assigned them to each user group.
• Extensive knowledge with Dimensional Data modeling, Star Schema/snowflakes schema, Fact and Dimension tables.
• Extensive work with SQL, PL/SQL and Performance Tuning of Oracle.
• Experienced with Informatica PowerExchange 5.x/9.x for Loading/Retrieving data from different source and target
• Experienced in Oracle Apps Oracle E-Business Suite . Worked on retrieving data from Oracle Applications Sources like Accounts Payable, Accounts Receivable and General Ledger.
• 3 years of Data Modeling experience using Microsoft Visio and Ewin.
• Experienced in using Teradata as the target for data marts and writing TSQL statements.
• Extensive Unix Shell Scripting knowledge.
• Basic Knowledge of AutoSys,
• Hand-on experience in failure Investigation, error tracking, creating bug fix plan, coordinating with all the teams involved, communicating with the client management for all the Production related issues.
• Strong experience in providing Production Support to various client applications
• Extensive experience with relational databases Oracle 8i/10g/11g, Sql Server 2000/2005 .
• Experience in working with XML, Flat Files.
• Reliable, responsible, hard working and good team player.
• Technical Skills:
• ETL Tools : Informatica Power Center, Power Exchange 9.5,9.1/8.6/8.1/7.2
• Modeling Tools : MS Project, MS Visio, Erwin.
• Databases : Oracle 8.x/10g/11g,Teradata, SQL Server 2000/2005/2008.
• DB Programming : Stored Procedures, Database Triggers, and Packages
• Languages : SQL, PL/SQL, TSQL, HTML/DHTML, Java.
• Web Servers : IIS v4.0/5.0/6.0, Apache Tomcat
• OS : UNIX, Red Hat Linux, Windows 2000/2003/XP/Vista
• Hardware : IBM PC Compatibles and NT servers
• Version Control : Visual Source Safe 6.0.

Professional Experience:

Primatics Financial, McLean, VA

Sr. ETL / Informatica Developer

Description: Primatics Financial is the market-leading enterprise software company that uses its proven domain expertise to provide integrated solutions for complex business problems in the financial services industry. Primatics combines domain-rich, enterprise software and integrated services to enable clients to better process, model and analyze their loan portfolio, comply with existing and new regulatory requirements, and grow their business. Primatics is headquartered in McLean, Virginia, USA.

Job Responsibilities:

• Responsibilities included analysis of source systems, data transformation, and loading, validation for data marts and data warehouse.
• Extraction, Transformation and Load was performed using Informatica PowerCenter 9.1 to build the data warehouse.
• Monitored the flow of inbound and outbound data, EDI transaction flow, and provided error resolution in a timely fashion. Worked with PMCMD and PMREP command line program to run workflows using shell scripts.
• Served as a key development resource in the creation and enhancement of internal accounting and financial software systems.
• Responsible for defining the data standards while converting the source reports to the csv format using a java program then Designing and developing ETL mappings and workflows for populating large scale data marts and data warehouses.
• Analyze, design, test, and document application software in support of distinct mortgage, banking and finance business areas.
• Worked on data migration effort from one environment to another.
• Developed Shell Scripts for running and automating the Informatica Workflows.

Environment: Informatica Power Center 9.1.0, Oracle 11g, SQL Developer, Windows 7, Unix Shell Scripting.

Confidential

Informatica Developer

Description: State Farm Insurance is a group of insurance and financial services companies in the United States.

Job Responsibilities:

• Analyzed the specifications, requirements and source data needs for data warehouse.
• Involved in database design, entity relationship modeling and dimensional modeling using Star schema.
• Used all the features of Informatica Versions 9.X including Designer, Workflow manager and Repository Manager, Workflow monitor.
• Developed and modified UNIX shell scripts to reset and run Informatica workflows using pmcmd on UNIX Environment. Conversant with the Informatica API calls.
• Created ETL mappings to perform tasks like validating file formats, business rules, database rules and statistical operations.
• Worked extensively with mappings using expressions, aggregators, filters, lookup, update strategy and stored procedures transformations.
• Created flexible mappings/sessions using parameters, variables and heavily using parameter files.
• Extracted and loaded Procurement, Order Management, and Accounting data from Oracle database.
• Performed tuning of Informatica sessions by using optimizing techniques such as database partitioning, increasing block size, and data cache size, sequence buffer length, target based commit interval and SQL overrides. Identify the Bottlenecks in mappings.
• Create test cases for the above projects in providing error free solution.
• Improved performance by database fine tuning creating indexes, stored procedures, etc , partitioning oracle databases.
• Setting up Batches and Sessions to schedule the loads at required frequency using Power Center Server manager.
• Used Informatica Version Control for checking all the versions of objects, used in Mappings and Workflows to track the changes in Development, Test and Production environments.
• Debug through Session logs and fix issues utilizing database for efficient transformation of data. Prepared Mapping documents, Data Migration documents, and other project related documents like mapping templates and VISIO diagrams.
• Develop technical documents in ease of improvements on existing code.
• Worked on several data mart projects as a senior data warehouse architect, was involved in complete system development life cycle, starting from requirement specifications to delivering the tested product.
• Participated in Design, Development and Implementation of a Reporting system for Business management using Cognos impromptu and Powerplay and configured various components Transformer/Powerplay .
• Implemented Filters, Calculations, Conditions, and Graphs Prompts in Impromptu reports
• Developing reports in ReportNet1.1 using Report Studio Query Studio.
• Creating ad-hoc reports/ Migrating reports from Cognos Impromptu.

Environment: Informatica Power Center 9.1, Power Mart 6.1, Power Exchange, Power Connect, Oracle 9i, MSSQL Server 2005, PL/SQL, SQL Plus, SQL Loader, PLSQL Developer, TOAD, UNIX, Windows XP.

Confidential

Informatica Developer

Description: Confidential is the second largest GSM mobile service provider in USA. It stores its entire customer information, both post-paid and pre-paid, in a data warehouse. It receives data from various legacy systems and Oracle applications like AR, AP and PO of GL module.

Responsibilities:

• Gathered data migration requirements and applied functional and technical specifications for data migration.
• Worked on retrieving data from Oracle Applications Sources like Accounts Payable, Accounts Receivable and General Ledger.
• Developed various mappings for extracting the data from different source systems using Informatica, PL/SQL stored procedures.
• Developed mappings for extracting data from legacy and Oracle Applications into our data warehouse.
• Extensively used Informatica to load data from MS SQL Server into the data warehouse
• Developed mappings between multiple sources such as flat files, oracle and multiple targets.
• Strong experience in using Expressions, Joiners, Routers, Lookups, Update strategy, Source qualifiers and Aggregators.
• Created Informatica mappings with PL/SQL stored procedures/functions to incorporate critical business functionality to load data.
• Developed Informatica mappings for Slowly Changing Dimensions.
• Created Mapplets for implementing the incremental logic, in identifying the fiscal quarter of the transaction and in calculating various requirements of business processes
• Extensively used almost all the transformations, which includes Sequence Generator, Expression, Filter, Router, Sorter, Rank, Aggregator, LOOK UP Static and Dynamic , Update Strategy, Source Qualifier, Stored Procedure, Joiner, Normalizer, XML Source Qualifier .
• Used Mapplets, Reusable transformations, Parameters and Variables to implement OO object orientation techniques and to facilitate the reusability of Code.
• Involved in creating and running Sessions Workflows using Informatica Workflow Manager and monitoring using Workflow Monitor.
• Extensively worked on creating and executing formal test cases, test plans for functional, system and regression testing

Environment: Informatica Power Center 8.6.1, Workflow Designer, Power center Designer, Power Exchange, Repository Manager, Power Mart, Oracle10g, SQL Server, PL/SQL, Flat files, PLSQL Developer, TOAD and Windows.

Confidential

ETL Developer

Description: Confidential is one of the nation's leading health care companies, providing innovative health benefit plans, dental and vision benefits, pharmacy benefit management services. This project aimed at making a data warehousing system of customers having different health insurance policies. The objective was to implement ETL process using Informatica in three layers, ODS, Data Warehouse and Data Mart. This application provides business intelligence analysis to decision-makers using Business Objects as an interactive OLAP tool with its Web Intelligence module.

Responsibilities:

• Used Informatica Designer for developing mappings using transformations, which includes aggregation, update strategy, lookup, stored procedure.
• Requirement understanding from business point of view.
• Preparing the high level and low level design documents.
• Mapping Development using Informatica PowerCenter8.6.
• Developed and Monitored Tasks and Workflows using Informatica Workflow Manager.
• Preparing Unit test cases and doing unit testing.
• Solving any technical issues arising during development and integration phases.
• Bug fixing and executing Ad-hock Requests.
• Coding Data Quality edit checks.
• Defect assignment, resolving escalated issues proactively.
• Defect tracking maintaining defect log.
• Prepare weekly/monthly status reports.
• Deployment of code in QA and Production.

Environment: Informatica Power Center 7.1.x, Power Mart 6.1, Power Exchange, Power Connect, Oracle 10g, DB2, MSSQL Server 2005 PL/SQL, SQL Plus, SQL Loader, PLSQL Developer, TOAD, UNIX, Windows XP

Confidential

Informatica Developer

Description: Confidential is a well known courier company offering logistics services all over Confidential. The name of the project is OTSM On Time Service Measurement and its main objective is to design and develop Data warehouse so as to enable the management to make better and quicker decisions. OTSM is the process to track the time taken by the FedEx to deliver the Parcels.

Responsibilities:

• Used Informatica 8.1 to extract, transform, and load data from multiple input sources
• Worked closely with the Business Analyst for gathering business requirements
• Created Mappings, Mapplets and Transformations using the Designer and developed Informatica sessions using Workflow Manager as per business requirements
• Done extensive bulk loading into the target
• Used workflow manager for session management, database connection management and scheduling of jobs
• Monitored sessions using the workflow monitor, which were scheduled, running, completed or failed. Debugged mappings for failed sessions
• Assisted the team in the development of design standards and codes for effective ETL procedure development and implementation
• Responsible for entire team deliverables Prioritizing, Assigning work and Tracking
• Knowledge Transition and resolving day-to-day production issues
• Extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings and sessions
• Used Korn shell scripts and CRONTAB for scheduling the informatica sessions
• Worked on Source Analyzer, Warehouse designer, Mapping, Mapplet Designer, Transformations, Informatica Repository Manager, Workflow Manager and Monitor
• Documented technical documents, Unit test plans and also written test cases for Unit and System testing
• Performed thorough end to end testing using Informatica mapping debugger
• Tested the data and data integrity among various sources and targets
• Associated with Production support team in various performances related issues

Environment: Informatica Power Center 7.1, Power Mart 6.1, Power Exchange, Power Connect, SQL Server 2008 R2, PLSQL Developer, TOAD, SQL, PL/SQL, UNIX HP-UX , Korn Shell and Windows XP

Confidential

Informatica Developer

Description: Confidential is a rapidly growing global specialty biopharmaceutical company. The company focuses its drug research and development on the relatively common mental abnormality Attention Deficit Hyperactivity Disorder ADHD .

Responsibilities:

• Involved in gathering business requirements, analysis, design, development and testing and production support of client application.
• Created high level design documents, functional specification documents.
• Extracted data from various heterogeneous sources like Oracle, Netezza, MS Access, and Flat files.
• Extensive programming experience of PL/SQL, Stored Procedures, Functions, Packages, Database Triggers for Oracle and SQL Server.
• Extensively worked with Slowly Changing Dimensions Type1, Type2, and Type3 for Data Loads
• Involved in handling the production tickets and resolve them in timely manner.
• Responsible for Performance Tuning at the Mapping Level, Session Level, Source Level, and the Target Level.
• Used SQL Override function in Source Qualifier Transformation, worked with Source Qualifier Transformation to join the homogeneous sources and Joiner Transformation to join the heterogeneous sources.
• Implemented Informatica PowerExchange CDC Option to capture the changes for up-to-the-minute data and increasing business agility.
• Informatica Web Services integrated with Informatica PowerCenter to exploit the platform's scalability and management of Web services for enterprise deployment.
• Worked with both Connected and Un-Connected Lookups.
• Extensively worked with Look up Caches like Shared Cache, Persistent Cache, Static Cache, and Dynamic Cache to improve the performance of the lookup transformations.
• Worked with Re-Usable Transformation and Mapplets.
• Extensively worked with aggregate functions like Avg, Min, Max, First, Last in the Aggregator Transformation
• Extensively used Normal Join, Full Outer Join, Detail Outer Join, and master Outer Join in the Joiner Transformation.
• Responsible for migrate the workflows from development to production environment.
• Extensively worked with Incremental Loading using Parameter Files, Mapping Variables, and Mapping Parameters.
• Involved in maintaining the share point portal to upload the documents regularly and store them on share point site.

Environment: Informatica Power Center 8.x, Power Mart 6.1, Power Exchange, Power Connect , Oracle 10g, PLSQL Developer, TOAD, PL/SQL, Linux, Microsoft Visio, Window XP

Confidential

Data warehouse Developer

Description: Developed and maintained ETL maps to Extract, Transform and Load data from various data sources to the Enterprise Data warehouse. The project aims to make decisions for the business users.

Responsibilities

• Involved in Dimensional modelling of the Data warehouse and used Erwin to design the business process, dimensions and measured facts.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated into Data Warehouse.
• Developed number of complex Informatica mappings, maplets, and reusable transformations to implement the business logic and incrementally load data.
• Worked on performance tuning of SQL and mappings by usage of SQL overrides in Lookups, source filter in Source Qualifier and data flow management into multiple targets using Router transformations.
• As per the requirement of the business users to manage change data capture, implemented slowly Changing Dimensions type I and type II.
• Worked with Persistent Caches for Conformed Dimensions for the better performance and faster data load to the data warehouse.
• Used Debugger by making use of Breakpoints to monitor data movement, identified and fixed the bugs.
• Used PowerCenter Workflow Manager for session management, database connection management and scheduling of jobs to be run.
• Developed Static and Dynamic Parameter Files for reusability and database connection management among Development/Testing/Production environments.
• Created List, Crosstab, Chart type reports for the sales data using Crystal Reports.

Environment: Informatica Power Centre 7.1.1, Power Mart 6.1, Power Exchange, Power Connect, Erwin 7.2, Oracle 10g, SQL Server 2005, SQL Loader, SQL, TOAD, UNIX, MS Office.

Confidential

Database Developer/ Programmer

Description: Confidential is a fully electronic and completely automated stock exchange of Confidential. Members do day to day trading and can manage their own accounts and deposits. It is using Oracle database as back end and GUIs built in java, Developer 6i. Members use Smart Stock System can not only maintain the accounts and deposits of their clients but also implement the exposure checks on them by using this system.

Responsibilities

• Studied the existing systems built in dBase, Foxpro and Sql Server database, Gathered requirements, analyzed the system.
• Development and implementation of Smart Stock System.
• Written Database procedures and functions to increase usability and performance tuning.
• Created various programs to load data files of existing system by flat files into new format.
• Created various SQL and PL/SQL scripts for comparison of data database procedure.
• Developed forms and reports.

Environment: Oracle 8i on Windows NT/2000 Server, Developer 6i, SQL, PL/SQL, PLSQL Developer, TOAD.