SUMMARY

• Over 8+ years of IT experience in analysis, design, development, data quality, data analysis, deployment and post production of technical solutions to business requirements
• Extensively worked on Data Quality, ETL, Data Analysis, Data Migration, Data Consolidation, Data Cleansing, Master data Management and Metadata Management and defining Data Quality rules according to Business rules of enterprise - wide
• Has In depth knowledge and Hands on experience in IDQ (Informatica Data Quality), Data Profiling, Data Cleansing, Data Standardization and integrating with several Targets databases
• Has In depth knowledge and experience in developing and implementing business-driven data warehouse and data mart in a sophisticated and complex technical environment, while anticipating and mitigating risks
• Extensively worked on Data Warehouse Full Life Cycle Projects for Financial, Health & Life Science, Insurance, Retail and Utility industries
• Extensive experience in Data Warehouse applications using Informatica Power Center 9.5/9.1/8.6/8.1, Power Exchange for Oracle, Cognos, OBIEE, Oracle 10g, Unix, MS SQL Server 2005 and Teradata
• Handled with different sources like SAP R/3, Mainframe VSAM, Oracle, Oracle EBS, SQL Server, Essbase, Confidential FR, Flat file, XML & COBOL files and also worked with Web services and calling java programs using Java Transformation
• Handled with different informatica transformations like Aggregator, Expression, Filter, Joiner, Lookup, Normalizer, Rank, Router, SQL, Source Qualifier and Sorter
• Expertise in identifying and analyzing technical and architectural requirements and also expertise in Data Vault and Dimensional modeling for Data Warehouses (Star / Snowflake schema) and ODS
• Experience in writing SQL queries, views and PL/SQL programs like functions, procedures, packages, triggers, cursors and exception handlers
• Good understanding & hands on experience with UNIX Shell scripts
• Experience in leading the ETL technical team, by providing technical solutions to the team members, conducting reviews, prepare team based documents like technical specs, test plans and prepare project implementation docs like execution plans, operational manual, disaster recovery and back out plan strategy
• Strong experience to lead the team and as well as massive experience on coordinating project work between on-site and off-shore / off-site
• Excellent skills are backed by technical excellence, huge-data expertise, commitment to the client, willingness to learn and adopt new technologies / environments quickly

TECHNICAL SKILLS

ETL & BI Tools: Informatica Power center 9.5/9.1/8.6/8.1, Oracle Warehouse Builder, PL/SQL, SSIS, Cognos 8.4, Informatica Data Quality (IDQ) 9.1 & Data Analyzer, Confidential FR, and OBIEE 11g

Database & Tools: Oracle 10g/9i/8i, MS SQL Server 2005/2003, Teradata, Essbase, MDX, XMDX, TOAD, SQL Navigator, COMPOSITE, Erwin 4.1, Visio, and Serena PVCS

Methodologies & Techniques: ETL, Data Warehousing, Data Quality, Master data Management, Metadata Management, Dimensional Model (Star/Snow Flake), Data Vault Data model, Data migration/ cleansing/ validation techniques, Partitions and Pursing and CDC mechanisms

Languages & OS: SQL, PL/SQL, JAVA, C, C++, PHP, HTML, XML, VB Script, UNIX, Linux, Mac, and Windows

PROFESSIONAL EXPERIENCE

Confidential, Savannah, GA

ETL Dev Consultant

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 developingSTARSchemas andSnowflakeschemas
• Identifying and tracking theslowly changing dimensions (SCD)
• Created reusableMailing alerts, events, Tasks,Sessions,reusable worklets andworkflowsin Workflow manager
• Scheduled the workflows at specified frequency according to the business requirements and monitored the workflows using Workflow Monitor
• Fixinginvalid Mappings,Debuggingthe mappings in designer,Unit and Integration Testingof Informatica Sessions, Worklets and Workflows
• Extensively usedTOADfor source and target database activities.
• Involved in the development and testing of individualdata 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 theSessions
• Generated simple reports from the data marts usingBusiness Objects
• Worked on dimensional modeling to design and developSTAR schemasby identifying the facts and dimensions. Designed logical models as per business requirements usingErwin
• Worked withPower Center Designertools in developingmappingsandMappletsto extract and load the data from flat files, XML files and Oracle (source) and loaded into Oracle (target)
• Tracking development activities against the project management plan
• Identifying the risks and mitigating where ever required
• Performed and supported project for all testing phases from development phase through user acceptance test phase and as well post production

Environment: Informatica 8.6.1, Oracle 10g, UNIX- Korn Shell, TOAD, Erwin, PL/SQL

Confidential, New York, NY

Senior ETL Developer

Responsibilities:

• Analyzed Business requirements, prepared the Physical design, High level designs and technical specifications
• Involved in the process of extracting data from integrated heterogeneous sources using Pro*C, and sorting extracted data using Synch sort methods
• Performed the preparation of technical design docs, source to target mapping (filed to field matrix). Prepared the strategies for performance tuning and reusable components in the PL/SQL Functions
• Created mappings to generate the statistics for the dataflow and also mail notification when a particular load doesn’t meet the SLA
• Experience in writing SQL Queries, views and PL/SQL programs like functions, stored procedures, packages and cursors
• Involved in the preparation of the QA check list as per standards. And also, prepared the test cases based on the business requirements and documented them in a specified manner
• Profile the source data and clean bad data by Informatica data explorer and quality tools. And also, performed data validation, data reconciliation on the target, source data
• Worked withPMCMDcommand line program to talk with the Informatica server
• Involved in migrating theETL applicationfrom development environment to testing environment

Environment: Informatica 8.6.1, Oracle 10g, UNIX, Erwin4.1, TOAD, Proc*C, Synch sort, Control M, Harvest and Microsoft TFS

Confidential

ETL Developer

Responsibilities:

• Involved in gathering and analyzing the requirements and preparing business rules
• Designed and developed complex mappings by using Lookup, Expression, Update, Sequence generator, Aggregator, Router, Stored Procedure, etc., transformations to implement complex logics while coding a mapping
• Worked with Informatica power center Designer, Workflow Manager, Workflow Monitor and Repository Manager
• Developed and maintained ETL (Extract, Transformation and Loading) mappings to extract the data from multiple source systems like Oracle, SQL server and Flat files and loaded into Oracle
• Developed Informatica Workflows and sessions associated with the mappings using Workflow Manager.
• Involved in creating new table structures and modifying existing tables and fit into the existing Data Model.
• Extracted data from different databases like Oracle and external source systems like flat files using ETL tool.
• Involved in debugging Informatica mappings, testing of Stored Procedures and Functions, Performance and Unit testing of Informatica Sessions, Batches and Target Data
• Developed Mapplets, Reusable Transformations, Source and Target definitions, mappings using Informatica 8.5.1
• Generated queries using SQL to check for consistency of the data in the tables and to update the tables as per the Business requirements
• Involved in Performance Tuning of mappings in Informatica
• Good understanding of source to target data mapping and Business rules associated with the ETL processes
• Worked closely with Business Analyst to make sure that all specs are understandable and good for development
• Prepared the team based development doc, which includes development techniques, common functions (lookups & mapplets in Informatica, functions & procedures in Oracle and scripts in Unix), directory structures and regulations for change request. Also, performed the high level design documents
• Coded common functions logic like mapplets, lookups, stored procedures, and functions etc. which can be reused by rest of the team

Environment: Oracle 10g, Informatica 8.5.1, Power Exchange for Web services, Cognos, UNIX, MS SQL Server 2005, PHP, Java Script

Confidential

ETL Developer

Responsibilities:

• Working in a team responsible for Design and Development of Data warehouse System
• Designed and developed ER Diagrams and Mapping document. Writing functional and technical detail design documents
• Developed, Tested and debugged Mappings, Created Sessions and workflows to run the mapping, using Informatica ETL tool, Oracle database scripts, SQL * loader scripts
• Working with teams of Global offshore / near shore delivery model outside Canada. Resolving production change requests
• Designed load strategy and schedule process for Dimensions and Fact loads along with other applications dependencies
• Wrote PL/SQL objects like, Stored Procedures / Functions, Packages, Triggers, Logical and Materialized views code for snapshots, Control Files (SQL loader script), Utility files and calling Stored Procedures/Functions from Informatica PowerCenter ETL tool
• Developed Mappings and Mapplets using different Transformations like XML, Update Strategy, Lookups/Reusable, Router/Filter, Expression, Normalizer, Union, Joiner, Source Qualifier, Sorter, Aggregator, Transaction Control etc
• Created mappings to load data from different sources like Relational Database tables, Access/Excel files, CSV/flat files, EBCDIC Files from COBOL by using Informatica PowerCenter ETL Tool
• Deployed/Copied Informatica Repository objects between different environment repositories in the project for phases by folder copy
• Analyzed, designed and optimized packages, procedures, functions and triggers using PL/SQL for best performance

Environment: Informatica Power Center 8.6.1, Oracle 10g/9i, TOAD, Windows NT, UNIX, HP Quality Center

Confidential

Informatica Developer

Responsibilities:

• Correlate the business to technical aspect and come up with high level design to create the mappings
• Parsing high-level design spec to simple ETL coding and mapping standards.
• Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet Designer and Transformation Designer
• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse
• Creation of Informatica Workflows, sessions and Run that Sessions to load into Target and Debugging, Unit Testing of Mappings
• Developed mapping parameters and variables to support SQL override
• Designed and developed Informatica Mappings to load data from Source systems to ODS
• Extensively used Power Center to design multiple mappings with embedded business logic
• Developed mappings to load into staging tables and then to Dimensions and Facts
• Used existing ETL standards to develop these mappings
• Creation of mappings with the transformations like Lookup, Joiner, Rank and Source Qualifier Transformations in the Informatica Designer as per the business need
• Created mappings using Unconnected Lookup, Sorter, Aggregator, and Router transformations for populating target table in efficient manner
• Knowledge sharing with the end users, clients and documented the design, development process, the process flow and the schedule of each mappings/jobs
• Create the schema for the new mappings; define the data types, constraints, indexes in the database
• Involved in Performance tuning at source, target, mappings, sessions, and system levels
• Prepared migration document to move the mappings from development to testing and then to production repositories
• Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables
• Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse

Environment: Informatica Power Center 8.1, Oracle 10g, TOAD, Windows NT, UNIX

Confidential

Product Developer

Responsibilities:

• Involved in development XML templates for converting the client Invoice data to EMS format data using data processor tool for the clients BELL CANADA, TELUS CANADA, JPMC, T-Mobile etc
• Analyzed Requirement Specifications and Interacted with clients for gathering business information
• Worked at Client locations for setting up data processor and EMS environment
• Analysis of ETL Mappings based on Facts & Dimensions from source to target tables
• Development of customer specific ETL(XML, Java combination)’s that help to process a large amount of data using ETL framework
• Development of email template using Velocity. Velocity is a Java-based template engine. It permits anyone to use a simple yet powerful template language to reference objects defined in Java code
• Development of change requirements as and when needed by the customer
• Responsible for entire Co-ordination between onsite (Client side) and Offshore Team. Tracking defects using Issue tracker
• Responsible for the timely and defect-free delivery of each release at core development level
• Involved in the various design, development and enhancements activity for the clients

Environment: Java, JSP, Servlets, Struts, JBoss, HTML, XML, Data Processor tool, Data Migrator, Windows XP, LINUX, Oracle 9i, SQL Server 2005, CVS, Team Track

Confidential

Developer

Responsibilities:

• Involved in understanding the user requirements configuring the data sources
• Involved in implementing the templates for retrieving the data from multiple data sources using XML & JavaScript
• Involved in writing and executing MDX & XMDX queries
• Setup data so that all functionality are covered and prepared weekly and monthly reports

Environment: Java, JSP, Servlets, Struts, JBoss, HTML, XML, JavaScript, Oracle 9i, ESSBASE, XMDX, MDX, CVS, SQL Server 2005, HFM, Confidential Planning, Confidential FR