SUMMARY

• 8+ years of IT experience in the Analysis, Design, Development, Testing and Implementation of business application systems and strong experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, BI, Client/Server applications.
• Strong experience with Ralph Kimball and Inmon data modelling methodologies.
• Strong experience working with ETL tools Informatica/SSIS.
• Strong Data Warehousing ETL experience of using Informatica 10.0/10.1/9.6/9.1/8.6.1/8.5 PowerCenter Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools - Informatica Server, Repository Server manager.
• Expertise in database programming in writing of the SQL, Stored Procedures, Functions, Triggers, Views in Teradata, Oracle, DB2 & MS Access.
• Experience working on Dataquality tools Informatica IDQ (9.1), Informatica MDM (9.1).
• Expertise in Data Warehouse/Data mart, ODS, OLTP and OLAP implementations teamed with project scope, Analysis, requirements gathering, data modeling, Effort Estimation, ETL Design, development, System testing, Implementation and production support.
• Informatica MDM Hub Match and Merge Rules, Batch Jobs and Batch Groups.
• Strong experience in Dimensional Modeling using Star and Snow Flake Schema, Identifying Facts and Dimensions, Physical and logical data modeling using ERwin and ER-Studio.
• Experience in usingInformatica MDM 10 HF1, MDM 10 HF2 Tool. Well Aware ofLoad, Match, Consolidation and
• Publish process of MDM.
• Expertise in working with various sources such as Oracle 11g/10g/9i/8x, SQL Server 2012/2008/2005 , DB2 8.0/7.0, UDB, Netezza,Teradata,flat files,XML,COBOL,Mainframe.
• Extensive experience in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using SQL Server, TSQL and Oracle PL/SQL.
• Utilized AUTOTRACE and EXPLAIN PLAN for monitoring the SQL query performance.
• Experience in IDD configuration
• Experience in implementing MDM software solutions with Informatica MDM formerly, Siperian, Strong exposure to working on scheduling tools like AutoSys and Control-M.
• Utilized AUTOTRACE and EXPLAIN PLAN for monitoring the SQL query performance.
• Good experience in Informatica Master Data Management (MDM), IDD, IDQ.
• Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.
• Created pre-session, post session, pre-sql, post sql commands in Informatica.
• Worked with different Informatica transformations like Aggregator,Lookup,Joiner,Filter,Router,Update strategy,Transaction Control,Union,Normaliser,SQL in ETL development.
• Worked with Event wait and event raise tasks, mapplets, reusable transformations.
• Worked extensively on NZLOAD, NZSQL scripts to read and write data with Netezza Database.
• Worked with Parameter file for ease of use in connections across Dev/QA/Prod environments.
• Experience in all phases of Data warehouse development from requirements gathering for the data warehouse to develop the code, Unit Testing and Documenting.
• Extensive experience in writing UNIX shell scripts and automation of the ETL processes using UNIX shell scripting.
• Proficient in the Integration of various data sources with multiple relational databases like Oracle11g /Oracle10g/9i, MS SQL Server, DB2, Teradata, VSAM files and Flat Files into the staging area, ODS, Data Warehouse and Data Mart.
• Experience in using Automation Scheduling tools like Autosys, Tidal, Control-M, Tivoli Maestro scripts.
• Experience working with Powerexchange.
• Worked extensively with slowly changing dimensions SCD Type1 and Type2.
• Excellent interpersonal and communication skills, and is experienced in working with senior level managers, business people and developers across multiple disciplines.

TECHNICAL SKILLS

Data Warehousing: Informatica Power Center 9.5/9.1.0/8.6.1/7.1/6.2 (Designer, Workflow Manager, WorkflowMonitorRepository Manager), Informatica Power Connect, DTS, SQL Server Integration Services (SSIS),Webservices,Informatica MDM, Informatica IDQ, IDD

Data Modeling: Erwin, Toad

Databases: Oracle11i/10g/9i/8i/7x, SQL Server 2003/2008, MS Access,Excel, Netezza, DB2, Teradata.

Business Intelligence: Hyperion,OBIEE,Cognos (Impromptu, Transformer, Power Play ReportsScheduler, IWR, PPWR, Upfront, Access Manager)Business Objects XI/6.5(Supervisor, Designer, Reporter), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS)Crystal Reports 9/10/11.

Languages: SQL,T-SQL,ANSI-SQL, PL/SQL, Unix Shell Script, Visual BasicANSI SQL, SQL*Plus 3.3/8.0

Tools: Toad, SQL* Loader, Crystal Reports 9.0/8.x/7/6/5/4

Operating Systems: Windows 2007/2005/2003/ XP/NT Server and Windows NT, UNIX, HP-UXUNIX AIX 4.2/4.3, Sun Solaris 8.

Analytical Tools: SQL Server Analysis Service (SSAS), Performance Point Server 2007ProClarity Analytics Server

SQL Server Tools: Query Analyzer, SQL Server Profiler, SQL Server Mail Service, Enterprise Manager, SQL Server Agent, DTS, BCP,Microsoft Visual Studio

Versioning: Team Foundation Server (TFS), Visual Source Safe (VSS).

PROFESSIONAL EXPERIENCE

Confidential, IL

Sr ETL Informatica MDM Developer

Responsibilities:

• Interacted with business users, analysts to gather, understand, analyze, program and document the requirements of Data Warehouse.
• Worked on identifying Mapping Bottlenecks and improved session performance through error handling.
• Worked on Mappletsand createdparameter fileswherever necessary to facilitatereusability.
• Created IDD application and Subject Areas, Subject Area Groups, Deploy and test IDD application, cleanse functions, utilizing timeline, and export and import data.
• Configured Address Doctor and fixed the AD issues by doing the changes in the config file.
• Worked on BDD config file to get the changes reflected on IDD.
• Teradata installs patches and upgrades where necessary, but we will coordinates with Teradata GSC Team and users.
• UsedError Handlingto capture error data in tables for handling nulls, analysis and error remediation Process.
• Design and Configuration of IDD Screens.
• Build end to end MDM solution integrating several application systems.
• Providing Technical solutions to the team on ETL and MDM.
• Providing solutions to client on various problems involved in project. Interaction with Client, Project Managers and Team Members on project scope and business design.
• Establish the ETL data flow from Source to MDM Landing tables
• Design and Development of Informatica mappings as per the Business Criteria
• Design and Development of MDM components for Load, Match and Publish process.
• Create the DDL scripts using ER Studio and source to target mappings (S2T- for ETL) to bring the data from NS to the warehouse.
• Participated in addition of new sources for MDM implementation
• Identified source systems, their connectivity, related tables and fields and ensure that data is suitable for mapping.
• Documented logical, physical, relational and dimensional data models. Designed the data marts in dimensional Data modeling using star and snowflake schemas.
• Extensively used Informatica FunctionsLTRIM, RTRIM, DECODE, ISNULL, IIF, INSTR and datefunctions in Transformations.
• Extensively used Informatica XML transformations like XML Source Qualifier, XML Parser and XML Generator to load data from XML files to DWH
• Designing the Data Acquisition, Transformation, and Data Cleansing approach for the MDM implementation
• Worked on the business rules assessment upon validating them before developing the code in IDQ
• Worked on creating rules in IDQ based on the business requirements
• Invloved in determining all the source data and metadata characteristics
• Created Informatica data load where source files have XML applications
• Effectively workedon Mapping Designer, Workflow Manager, and Workflow Monitor.
• Created Partners and Accounts in B2B DX along with creation of users for the business to access the interface
• Extensively usedSequence Generator in all mappingsandfixed bugs / ticketsraised in production for existing mappings in common folder for new files through versioning(Check in and Check out)on an urgency through support for QA in component unit testing and validation.
• Usedshortcuts for sources, targets, transformations, Mapplets, and sessions to reuse objectswithout creating multiple objects in therepository and inherit changesmade to the source automatically.
• Created Tidal jobs to schedule Informatica Workflows. Executed workflows using Tidal schedule.
• Utilized InformaticaIDQ (Data Analyst, Developer) for data profiling and matching/removing duplicate data, fixing the bad data, fixing NULL values.
• Implemented MDM in testing the data quality services and good working knowledge on MDM
• Involved in checkingData accuracystandards for NULLS, Comparison, key generator and labeler usingreference table manager in PWHand rolled based on statistics throughThreshold value and Score Cardsapplied the Data cleansing process in Model Repository on same domain and merged to Power center.
• Used the PL/SQL procedures for Informatica mappings for truncating the data in target tables at run time.

Environment: Informatica Power Center 9.5/9.1.0/10.0 , 10.1, Informatica Data Quality 9.1.0/9.5.1/10.0/10.1 , Flat Files,MainFrame Files, Oracle 11i, Netezza, Teradata SQL Assistant, MDM, IDD, Quest Toad Central 9.1, Unix Shell Scripting and Windows 2000, Windows 2003,SQL Server 2005,SQL Server 20012, Salesforce.com,Webservices,Informatica B2B DX

Confidential

Sr.ETL Informatica MDM Developer

Responsibilities:

• Involved in translating business requirements to technical requirements.
• Teamed up with Enterprise Information Quality & Governance Office and business data stewards to provide summary results of data quality analysis, which will be used to make decisions regarding how to measure business rules and quality of the data.
• Documented at a functional level how the procedures work within the data quality applications
• Worked on various Informatica Power Center components like Designer, Workflow Manager, Workflow Monitor, Repository Manager
• Extracted data from various heterogeneous sources like Oracle, SQL SERVER, Flat files and Mainframe files.
• Led the design, development and implementation of the MDM decommissioning project using Informatica PowerCenter that reduced development and implementation cost and time.
• Worked on several transformations such as Filter Transformation, Joiner Transformation, Sequence Generator Transformation, Aggregator Transformation, Source Qualifier Transformation, Expression Transformation, Lookup Transformation (Connected and Unconnected), Joiner Transformation, and Router Transformation, Web services Consumer Transformation, Normalizer Transformation and Java Transformation in Informatica Power center.
• Performed Business/IT landscape analyses, ETL/MDM Proof of Concepts, and advised clients
• Extensively used XML Parser, XML Generator and XML Source Qualifier transformations where applicable.
• Involved in upgrade of MDM hub involved in performance tuning of MDM
• Used Power Exchange for Oracle to capture Real Time data from Source and published the data to target usingPowerCenter and Service Integration Framework of Informatica MDM.
• Design and implementation of IDD Task management
• Provide input to Data modeling and physical database development standards with the Data Modeling Team. Assist in the review of database structures of proposed business application purchases.
• Designed and built MDM batch load solution (Landing Table, Staging Table,
• Created reference/passthrough ports in XML Transformations to correlate the parsed data.
• Extensively worked with Web Services Consumer Transformation to retrieve data from web services applications and web oriented systems.
• Develop master data using Informatica MDM Hub Formerly Siperian .
• Built complex Teradata SQL code in BTEQ script to populate the data as per business rules.
• Designed and developed client centric Master Data Management (MDM) solution.
• Define and design the Data Acquisition, Transformation, and Data Cleansing approach for the MDM implementation.
• Used user defined functions to minimize the overhead of coding and enhanced reusability of the same.
• Created IDD application and Subject Areas, Subject Area Groups, Deploy and test IDD application, cleanse functions, utilizing timeline, export and import master data from flat file.
• Worked extensively on BDD config file to get the changes reflected on IDD.
• Design and Implementation of MDM & IDD release and deployment procedures for full and incremental releases and automating the change list promotions to different environments using Met command
• Build end to end MDM solution integrating several application systems.
• Designed and built MDM batch load solution (Landing Table, Staging Table, Mappings, User Exits, Hard Delete Detection, Cleanse Function, and Batch Group Definition, Match Rules Definition) and automating the execution.
• Designed Role Based PDP Security Externalization for the MDM solution and defined complete MDM security framework.
• Develop master data using Informatica MDM Hub Formerly Siperian .
• Creation of Informatica MDM Mappings, Cleanse Functions and Cleanse List
• Created a Batch script to pass database connections, parameter entries for source and target.
• Wrote SQL, PL/SQL, stored procedures for implementing business rules and transformations.
• Coordinated with DBA for create sources, targets and views.
• Created Unit Test Case Document, Technical Design Documents, Informatica Hub and IDD Migration Request Document.
• Scheduled MDM Stage Jobs, Load jobs.
• Created IDD application to support the ongoing business needs to feed the data into the hub.
• Production support for the Informatica process, troubleshoot and debug any errors.
• Worked with Informaticatools IDQ (Data Analyst,Developer) with various dataprofiling techniques to cleanse, match/remove duplicate data.
• Installed & Configured MDM Hub on Dev, Test and Prod Server, cleanse, and Address Doctor in Dev, QA.
• Providing End to End solution for the project, which involves ETL, Infa MDM, SIF.
• Worked with cleanse, parse, standardization, validation, scorecard transformations.
• Worked extensively with Netezza scripts to load the data from flatfiles to Netezza database
• Involved in create a data base tables and views in SQL SERVER using Erwin.
• Developed Batch scripts for doing automated file transfer to customer FTP.
• Migrated the code from DEV repository to QA and then to PROD Repositories while in our monthly releases.
• Involved in ETL loads (Enable/disabled) through Informatica Admin Console during all the monthly releases.
• Worked on XML generated files as targets.
• Created test cases and completed unit, integration and system tests for Data Warehouse and Data mart.

Environment: Informatica Power Center 9.5/9.1.0, Flat Files,MainFrame Files, Oracle 11i, Quest Toad Central 9.1, IDD, Unix Shell Scripting and Windows 2000, Windows 2003,SQL Server 2005,SQL Server 2008, Teradata utilities - TPT, BTEQ, MDM, Netezza,Aginity workbench.

Confidential, Addison, TX

Informatica Developer

Responsibilities:

• Understanding the Business Requirements and Develop an ETL process to load data from source to target.
• Regular interaction with the client to get clarity on any business related queries
• Involved in designing the mappings between sources and targets and also tuned them for better performance.
• Created Informatica Mappings to build business rules to load data using transformations like Source Qualifier, Aggregator Expression, Joiner, lookup, Filters, Router and update strategy.
• Used mapping designer to generate different mappings for different loads and did performance tuning at mapping level.
• Created mapplets and reusable transformations.
• Created and executed sessions using Workflow Manager.
• Monitoring sessions by using Workflow Monitor.
• Deploying the Informatica objects to Production Server and scheduled them.

Environment: Informatica Power Center 9.1/8.6, IDQ, Windows NT, Oracle 9i/10g, DB2, SQL, PL/SQL, XML, TOAD, OBIEE.

Confidential

ETL Developer

Responsibilities:

• Developed and supported the Extraction, Transformation, and load process (ETL) for data migration using Informatica power center.
• Developed Transformation logic and created various Complex Mappings and Mapplets using the designer.
• Extensively used Informatica Client tools- Source Analyzer, Warehouse Designer, Mapping Designer.
• Developed Informatica mappings for data extraction and loading worked with Expression, Lookup, Filter and Sequence generator and Aggregator Transformations to load the data from source to target.
• Conceptualized and developed initial and incremental data loads in Informatica using Update strategy transformation.
• Developed mappings, sessions for relation and flat source and targets.
• Imported data from various sources and transformed and loaded into targets using Informatica.
• Created and scheduled Session, jobs based on demand, run on time.
• Monitored Workflows and Sessions.

Environment: Informatica Power center 8.6 xs, Oracle9i, SQL and Windows XP.

Confidential

Data Warehouse Developer

Responsibilities:

• Involved in design & development of operational data source and data marts in Oracle
• Reviewed source data and recommend data acquisition and transformation strategy
• Involved in conceptual, logical and physical data modeling and used star schema in designing the data warehouse
• Designed ETL process using Informatica Designer to load the data from various source databases and flat files to target data warehouse in Oracle
• Used Power mart Workflow Manager to design sessions, event wait/raise, and assignment, e-mail, and command to execute mappings
• Created parameter based mappings, Router and lookup transformations
• Created mapplets to reuse the transformation in several mappings
• Used Power mart Workflow Monitor to monitor the workflows
• Optimized mappings using transformation features like Aggregator, filter, Joiner, Expression, Lookups
• Worked extensively on Oracle database 9i and flat files as data sources.
• Performed integrated testing for various mappings. Tested the data and data integrity among various sources and targets.
• Created daily and weekly workflows and scheduled to run based on business needs
• Created Daily/weekly ETL process which maintained 100GB of data in target database
• Created complex stored procedures/functions/triggers/query tuning in MS Access 97

Environment: Oracle 8i, Informatica Power Center 7.1/8.1,Windows NT, UNIX, SQL Server, PL/SQL