Summary of Qualifications:

• Around 7 years of IT experience in Design, Develop, Test and troubleshoot various software and Business Intelligence applications
• Experience in various Industry verticals like Retail , Manufacturing, Healthcare , Finance, Telecommunication with appropriate DW/ETL Implementations
• 5 Years of strong Data Warehousing experience specializing in RDBMS, ETL, data modeling and data warehousing techniques
• Expertise in the ETL Tool Informatica which includes components like Power Center, Power Mart, Power Connect, Designer, Workflow Manager, Workflow Monitor, Repository Manager, Metadata Manager, Repository Server Administration Console, IDE – Informatica Data Explorer, IDQ - Informatica Data Quality
• Experience in working with various Data Sources like Sybase, Oracle, MS Access, MS Excel, MF COBOL EBCDIC Files, Flat Files, XML Files, etc
• Involved in the configuration, administration of Informatica 8.6.1, upgrading the repository from 8.6.1 to 9.1
• Worked onCDC at the database layer for nearReal Time Data warehousingusing Informatica.
• Expertise in performance tuning ETL code, mappings, sessions and database
• Experience in the complete life cycle of quite a few Data Warehouse implementations
• Excellent knowledge ofOLTP System Study, Analysis andE-R modeling
• Good experience in UNIX Shell Scripting and ETL Process Automation using Shell Programming
• Experience in resolving on-going maintenance issues and bug fixes
• Experience in Dimension and Fact table loading and data load validations
• In depth knowledge of Rational Unified Process (RUP) methodology, Use Cases, Software Development Life Cycle (SDLC) processes, Object Oriented Analysis and Design (OOA/D)
• Progressive experience in all phases of the iterative Software Development Life Cycle (SDLC) with a rich experience in gathering the functional requirements and competent in creating the Unified Modeling language (UML)
• Experience in using the Informatica command line utilities likepmcmdto controlworkflowsin non-windows environments
• Quick learner and adaptive to new and challenging technological environments and initiative to learn new technologies and tools quickly

Technical Competencies:

ETL Tools : Informatica Power Center/Power Mart 9.1/8.x/7.x, Power Exchange
RDBMS : Oracle 11g/10g/9i/8i,MS SQL Server 2008/2005/2000,Sybase, DB2,
: Netezza, Teradata, etc.
Operating Systems : MS-DOS, Linux, UNIX, Windows 95/98/2000/XP/Vista.
Data Modeling : Erwin 4.0/3.5.2.
Languages/Utilities : UNIX Shell Scripting (Korn shell).
GUI Tools : Toad, Peregrine, CVS, SQL assistant, SQLdeveloper, etc.

Professional Experience:

Confidential,MN Nov 2011 – Present
Sr.Informatica Developer

Confidential,is an institution providing an array of financial services to individuals, small businesses, middle-market companies and major corporations. I am a part of Enterprise Data Warehouse (EDW) team.

Responsibilities: Define scope and implement data integration architecture. Coordinate with business areas, IT cross-divisional technical resources and external customers regarding system scope, objectives and solutions. Responsible as a technical expert in design, development, coding, UAT, and debugging new data integration, application, and development. Responsible for making significant enhancements to existing applications. Collaborate with project managers in developing project plans, schedule, status reporting, and issue/risk management. Coordinate and participate in project estimate, development and implementing recommended architecture approaches. Interface with Engineering, DBA and Operations departments ensuring application performance, capacity Review and approve design specifications and perform code reviews. Enforce the data integration development standards and best practices for design, coding, migration and scheduling

Environment: Informatica Power Center 9.1/8.6, Oracle 11g, TOAD, Windows, Tidal

Confidential,FL March 2010 – Oct 2011
Sr.ETL Developer

Confidential, is a long standing primary health care center. The patient data is imported from various sources into Patient management system (PMD), which is a data warehousing system where information is brought into and processed. Informatica Power Center tool was used for extracting, transforming, validating and loading data into the Data Warehouse and Data Mart.

Responsibilities:

• Extensively used Informatica Power center for extracting, transforming and loading data from relational sources and non-relational sources.
• Developed complex Informatica mappings, re-usable transformations, Mapplets for accomplishing complex business requirements.
• Developed UNIX scripts to schedule workflows in the batch process.
• Used mapping parameters and variable along with parameter files.
• Created mappings/Workflows to extract data from SQL server, Sybase, XML sources and Flat File sources and load into data warehouse and the data mart.
• Created complex SQL, PL/SQL, stored procedures, triggers and functions.
• Provided reliable, timely support of integration, performance and user acceptance testing processes.
• Designed and developed complex aggregation, and calculation to implement complex business rules to generate consolidated summary tables using Informatica ETL (Power Center) tool.
• Involved in execution of Unit test plans & prepare the Unit logs and in migrating the Mappings, Sessions, Workflows from Test environment to Production environment. Monitoring the ETL jobs and fixing the Bugs.
• Worked on analyzing the performance data to suggest changes to improve performance of Informatica load.
• Was involved in migrating Informatica objects from Development and Test to PROD using deployment groups.

Environment: : Informatica Powercenter 9.0/8.6.1, Microsoft SSIS, MS SQL Server 2008R2, Oracle 11g/10g, Sybase,XML, SQL, PL/SQL, TOAD, Java, J2EE &XSLT, SQL *Plus, Autosys, Windows and UNIX.

Confidential,TN Dec 2008 – Mar 2010
Sr. ETL Developer

This Project clearly describes the business measures and supports the business model and processes for Schneider Electric French Bridge Load, In Stage1 Data Discovery and Data Cleansing of legacy data. In Stage2, A copy of the master data will be moved to an interim database. ETL tools will "transform" legacy data into SAP formats. In Stage3, master data is loaded to the productive systems and update reports.

Responsibilities:

• Requirement gathering and requirement Analysis
• Responsible to Track, Document, Capture, Manage and Communicate the Requirements using Requirement Traceability Matrix (RTM)which helped in controlling numerous artifacts produced by the teams across the deliverables
• Involved with all the phases of Software Development Life Cycle(SDLC)methodologies throughout the project life cycle
• Interacting with the client on various forums to clarify any queries regarding the functionality and appropriate access required etc
• Created the technical Design documents from Business Requirements Documents using MS VISIO tool
• Created Data flow diagrams including the Informatica mappings in the MSVISIO
• Exposure to configuration of nodes, Repository services and Integration services
• Worked on Metadata Manager to generate the reports for comparing the different source databases, to see the run time of long running sessions, etc
• Created and Monitored Sessions and various other Tasks such asEvent-Raise Task, Event-Wait Task,Decision Task, Email Task, Assignment Task, Command Task etc using Informatica Workflow
• Perform unit testing of these Workflows from source to staging and staging to Warehouse of data warehouse
• Created Archive script for the source Files and analyzed scheduling methods
• Responsible for cleansing of extracted data to make it suitable for use with existing group projects, integration of extracted data with other internal & external data feeds, and data analysis
• Analysis & fix on QA defects made by QA team
• Conducted review sessions on regular basis with QA and development teams for preparing status, delivery report and client reporting
• Involved in Unit testing and UAT defect fixing
• Involved in Informatica sessions partitioning and mappings performance tuning
• Migration of theSessions, Workflows, Mappings and other objects from Development to Production by Exporting/Importing asXMLfiles from Development to QA and Production Deployment
• Supported Informatica and various Applications including HR Smartstream Financial Smartstream and resolved Severity 1 and Severity 2 tickets without missing Service Level Agreement
• Worked on Change Requests while supporting the project

Environment: Informatica Power center 8.6.1, Informatica Power Exchange 8.6.1,Informatica Metadata Manager, IDE – Informatica Data Explorer, IDQ - Informatica Data Quality, Oracle 10g , AIX Version 5(Kron shell), Windows XP, Toad,MS VISIO,Perigrine, Tidal, Control-M, Netezza.

Confidential,CO Oct 2007 – Dec 2008
Informatica Developer

Confidential,through its subsidiaries, provides homebuilding and financial services in the United States. It operates in two segments, Homebuilding, and Financial Services and Other. The Financial Services and Other segment originate mortgage loans primarily for homebuyers, as well as broker’s mortgage loans for origination by outside lending institutions.

Responsibilities:

• Worked on Power Center client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformations Developer.
• Used most of the transformations such as the Source Qualifier, Expression, Aggregator, Connected & unconnected lookups, Filter, Router, Sequence Generator, Sorter, Joiner, and Update Strategy.
• Used Workflow manager for workflow and session management, database connection management and scheduling of jobs to be run in the batch process.
• Imported data from various sources like oracle, SQL server transformed and loaded into Data Warehouse targets (Teradata) using Informatica.
• Used shortcuts to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.
• Optimizing Query Performance, Session Performance.

Environment : Informatica Power Center 8.1/8.6, Oracle 9i, ERWIN 4.0 , PL/SQL, TOAD, SQL Server 2005, TERADATA v12, DB2, Windows NT/2000.

Confidential,TX Jan 2006 – Oct 2007
Informatica Developer

Confidential,was to deliver ETL solution for their Claims related Data mart and creation of Online Cognos Reports. ETL Module step involves data loading from OLTP to ODS using CDC feature of Power Exchange. From there the data is loaded to Claims Data mart using Informatica PowerCenter.

Responsibilities:

• Interacted with the business analyst to gather business requirements Power Exchange Change Data Capture has been done for data updates (have knowledge of Power Exchange)
• Used Power Exchange CDC feature to get the data from mainframe machine and also involved in starting and stopping the CDC Listener
• Involved in development and unit testing of Informatica Power Center mappings and Workflows.
• Converting the Functional specifications into ETL specification documents
• Performed Debugging of mappings and rectified data errors
• Involved in Performance tuning of mappings and Code Review
• Creation of Unit test cases and executing the same
• Developing Reconciliation process and error routine
• Creation of Review documents for specification documents and test cases
• Responsible for migrating projects between multiple environments (Dev, QA, UAT and Prod)
• Resolved issues resulting from User Acceptance Testing (UAT)

Environment: Informatica Power center 8.0/8.1, Informatica Power Exchange 8.1.1, Oracle 9i, AIX Version 5, Windows XP, and Toad.

Confidential,India May 2004 - Jan 2006

Informatica Developer

Confidential,is the nation’s leading health benefits company serving the needs of approximately 34 million medical members nationwide in India. The goal was to create a Enterprise Data Warehouse (EDW) solution to create a single, authoritative source for analytical reporting by integration heterogeneous source systems.

Responsibilities:

• Involved in understanding client business process and data profiling.
• Understanding ETL requirement specifications to develop HLD & LLD for type-1, SCD Type-II and Type-III mappings and was involved in testing for various data/reports.
• Developed Informatica objects – Mappings, sessions, workflows based on the prepared low level design documents.
• Involved in developing custom SQLs, to generate pre-aggregated tables.
• Performance tuned ETL code and database.
• Preparing Test Cases for Component testing, review and rework.
• Involved in preparing the UNIX Scripts.
• Performed testing, knowledge transfer, provided technical support and trained newly recruited consultants.
• Using Erwin data modeler for maintaining consistency between the dimension model and the database.

Environment: Informatica Power Center 7.1 (Repository Manger, Designer, Workflow Monitor, Workflow Manager), Oracle 9i, Flat files, SQL, PL/SQL, TOAD, Windows NT, Shell Scripting

EDUCATION:

BS in Electronics & Instrumentation