SUMMARY

• 8+ years of experience in working with data warehouses and using Informatica Powercenter 7.1, 8.1, 8.6, 9.1 (Designer, Repository Manager, Workflow Manager and Workflow Monitor).
• 4+ years of data modeling experience using ERWIN.
• Extensive knowledge in dimensional data modeling, star/snowflakes schema.
• Expertise in configuration, performance tuning, installation of Informatica, & in integration of various data sources like Oracle, Teradata, MS SQL Server, IBM DB2 and working experience with Cobol,XML and FlatFiles,
• 6+ years of extensive experience with databases (MS SQL Server 2000/2005/2008 , Oracle 8i/9i/10/11g, Teradata, and IBM DB2).
• Extensive work with PL/SQL, performance tuning of Oracle using Tkprof, SQL trace, plan, hints, Oracle partitioning, various indexes and join types.
• Understanding & working knowledge of Informatica CDC (Change Data Capture) using Triggers and PowerCenter.
• Good exposure inInformatica MDMwhere data Cleansing, De - duping and Address correction were performed
• Experience with PowerCenter RealTime- Webservice publishing to PowerCenter, Webservice hub and consuming Web Service using Webservice Consumer Transformation.
• Experienced in HIPPA 4010/5010 EDI transactions.
• Experience with testing various test cases for FACETS interfaces..
• 4+ years of Unix shell scripting. Hands on exposure on UNIX environment..
• Strong skills in data analysis, data requirement analysis and data mapping for ETL processes.
• Extensively worked with Teradata utilities likeBTEQ, Fast Export, Fast Load, Multi Loadto export and load data to/from different source systems including flat files.
• ImplementedSlowly Changing dimensions Type 1andType 2, methodology for accessing the full history of accounts and transaction information.
• Involved in understanding requirements and in modeling activities of the attributes identified from different source systems likeOracle, Teradata, SQLandFlat files.
• Expertise in Data modeling techniques like Dimensional Data modeling, Star Schema modeling, Snowflake modeling, and FACT and Dimensions tables.
• Expertise in implementing complex business rules by creatingre-usable transformations, Mapplets,Mappings, Mapping, Session and Workflow Variables.
• Experience in staging, validating and loading the data intoTeradata Warehouseusing Informatica.
• Worked in Informatica B2B Data Transformation
• Good understanding of relational database management systems like Oracle, TeraData, DB2, and SQL Server and extensively worked on Data Integration using Informatica for the Extraction transformation and loading of data from various database source systems and mainframe Cobol and VSAM files
• Experienced inPerformance of Mapping Optimizationsin Informatica.
• Experienced in using the Oracle SQL* Loader feature for loading the data from Flat Files to Data Base tables for Bulk Loading.
• Involved in Relational database design and development of data warehouse data feeds.
• Involved in CompleteSoftware Development LifecycleExperience (SDLC) from Business Analysis to Development, Testing, Deployment and Documentation
• Very strong in Relational Databases (RDBMS), Data Modeling and Design and build the Data Warehouse, Data marts using Star Schema and Snow Flake Schema for faster and effective Querying.
• Good experience in using SQL, PL/SQL, Indexes, Functions, Procedures, Triggers and Cursors.
• Excellent Team Player self-motivated with good communications skills.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.5/9.1/8.1/7.1 , SSRS

Databases: MS SQL Server 2005/2008, Oracle 8i/9i /10g/11g, Teradata, IBM DB2, Sybase

Database Skills: Cursors, Stored Procedures, Functions, Views, Triggers and Packages

Client Side Skills: SQL, T-SQL, PL/SQL, UNIX shell scripting,, XMLWeb Servers IIS v5.0/6.0, Apache Tomcat

OS: Windows 2000/2003/XP/Vista/Windows 7, UNIX.Linux

Methodologies: Data Modeling Logical / Physical, Star/ Snowflake Schema, FACT Dimension Tables, ETL, OLAP, Software Development Life Cycle (SDLC)

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

Sr. Informatica Developer

Environment: Informatica Power Center 9.1(Repository Manager, Designer, Workflow Manager, and Workflow Monitor), Oracle 11g, SeaQuest, HPDM, SQL Server, TeraData,UNIX, Toad, MDM,Control-M.

Responsibilities:

• Worked as a Sr. Informatica Developer and participated in all the project phases starting from Requirements gathering through Deployment of this Program (SDLC).
• Used Full PDO (Push down optimization) in informatica for loading data.
• Creating mappings to load data using different transformations
• Resolved Inconsistent and Duplicate Data to Support Strategic Goals with Multidomain MDM
• Cleansed the data usingMDMtechnique
• Troubleshooted the ETL process developed for Conversions and implemented various techniques for enhancing the performance.
• Involved in development of Logical and Physical data models that capture current state/future state data elements and data flow using Erwin.
• Worked in Informatica B2B Data Transformation
• Developed end-to-end ETL processes for Trade Management Data Mart UsingInformatica.
• Extensively involved in creating design documents for loading data into Data warehouse and worked with the data modeler to change/update the Data warehouse model when needed.
• Created medium to complex PL/SQLstored proceduresforintegrationwith Informatica using Oracle 10g.
• UsedTeradata utilities fastload, multiload, tpumpto load data
• WroteTeradata Macrosand used various Teradataanalytic functions
• Excellent knowledge on ETL tools such as Informatica, SAP BODS to load data to Teradata by making various connections to load and extract data to and from Teradata efficiently.
• Developed ETL processes to load data into dimensional model from various sources using Informatica Power Center 9.5
• Developed Mapplets and reusable transformations that were used in different mappings and across different folders
• Designed and developed the error handling mechanism to be used for all the Informatica jobs, which load data into the data warehouse.
• Extensively used warehouse designer of Informatica Power center Created different target definitions.
• Working on Billion record tables ( performance tuning for historical loads )
• Created robust and complex workflows and worklets using Informatica workflow manager and Trouble shooted data load problems

Confidential, Oakland, CA

ETL Developer

Environment: InformaticaPowerCenter 9.1/8.6,Oracle 10g/11g, SQL developer, Erwin, Flatfiles, TOAD,PL/SQL, MS SQL Server, Cognos, UNIX.

Responsibilities:

• Analyzed functional specs and created technical documentation.
• Extensively used all the features ofInformatica9.1/8.6 includingDesigner, Workflow manager and Repository Manager, Workflow monitor.
• Responsible for developing, support and maintenance for theETL(Extract, Transform and Load) processesusingInformatica powercenter.
• Implemented various workflows using transformations such as SQL Transformation,XML transformation, Normalizer, look up, aggregator, stored procedure and scheduled jobsfor different sessions.
• ImplementedSlowly Changing dimension methodologyfor accessing thefull history of accountsand transaction information.
• Reviewed Business Requirement Document (BRD) for accuracy and Completeness.
• Created capture registrations and extraction maps in PowerExchange navigator for Change Data Capture(CDC).
• Used PowerCenter Power Exchange Client to define CDC in configuring Mapping,Workflows and Sessions.
• Designed and implemented HIPAA 835 Payment Advice Transaction, 837 Health Care Claim Transaction.
• Informatica B2B Data Transformation supports transformations and mappings, via XML, ofmost healthcare industry standards including HIPAA 275,277.
• Performed Data Analysis and developed Data Mapping documents for ETL (SSIS) projects.
• Developed Test Cases and SQL Queries to perform various Validations.
• Executed Test Cases with respect to Source and Target database tables.
• Written SQL queries to validate reports against the database.
• Extensive SQL querying on Staging, Data warehouse and Data Marts.
• Extracted Patient data from Server into flat file and imported to Oracle DB.
• Developed Procedures and Functions in PL/SQL for Data ETL.

Confidential, Atlanta, GA

Data ModelerInformaticaDeveloper

Environment: InformaticaPowerCenter 7.1 8.1, Flat files, Oracle10g, MS SQL Server 2000, Erwin 7.2, PL SQL, TOAD, MicroStrategy 8.1.1, UNIX (Solaris), Windows NT.

Responsibilities:

• Involved in business analysis and technical design sessions with business and technical staff to develop requirements document and ETL specifications.
• Designed and developed the Logical and Physical data models using Erwin 7.2 based on the reporting requirements given.
• Designed and developed the ETL Mappings for the source systems data extractions, data transformations and aggregation.
• Designer to map the sources to the target, Mapplets and Transformation Developer.
• Developed standard and re-usable mappings and mapplets using various transformations like expression, aggregator, joiner, source qualifier, router, lookup, and filter.
• Configured the mappings to handle the updates to preserve the existing records using Update Strategy Transformation.
• Made performance improvements to the database by building Partitioned tables, Index Organized Tables .
• Used SQL tools like TOAD to run SQL queries and validate the data in warehouse and mart.
• Involved in error checking and testing of ETL procedures and programs usingInformaticasession log.
• Tuned performance ofInformaticasessions for large data files by implementing Pipeline partitioning and increasing block size, data cache size, sequence buffer length, target based commit interval.
• Involved in designing and developing Reporting System using MicroStrategy 8.1.1.

Confidential Charlotte, NC

InformaticaDeveloper

Environment: Informatica.Power Center 8.6,Informatica,Oracle 11i/10g, SQL Server 2005, UNIX, Shell Scripting, Toad

Responsibilities:

• Worked closely with business analysts to understand and document business needs for decision support data.
• Used several Informatica Transformations i.e Lookup. expression, aggregator, joiner, filter, normalizer
• Used the Update Strategy Transformation to update the Target Dimension tables.
• Developed ETL procedures to transform the data in the intermediate tables according to thebusiness rulesandfunctionality requirements.
• Involved in the development ofInformatica.mappingsand alsotuned for better performance.
• CreatedMappletsand used them in different Mappings.
• Useddesigner debuggerto test the data flow and fix the mappings.TunedInformatica.Mappings and Sessions for optimum performance.
• Provided detailed technical,process and supportdocumentationlike daily process rollback and detailed specificationsand very detailed document of all the projects with the workflows and their dependencies.
• Worked with mappingparametersandvariablesto load data from different sources to correspondingpartitionof the database table..
• Created Schema objects like Indexes, Views, and Sequences.
• Extracting the data from.BRD files, Flat files &Orcaleand load them throughInformatica..
• Production Supportand issue resolutions.
• Involved in Unit testing ofMappings,Workflowsanddebuggingmappings for failed sessions.
• Created partitions, SQL over ride in source qualifier, session partitions for improving performance.
• Performedunit testingandsystem testingof the mappings developed and documented with various scenarios.
• WrittenUnix Shell Scriptingbased on requirements

Confidential, Hartford, CT

ETL Developer

Environment: Informatica Power Center 7.1, 8.1.1 SP4, Oracle 9i, MS SQL Server 2005 PL/SQL, SQL*Plus, SQL*Loader, Unix, Linux, Windows XP.

Responsibilities:

• Involved in identifying dimensions and facts to create enterprise data warehouse and model.
• Converted the already existing PL/SQL extracts and procedures to Informatica. Built new logic and designs in mapping to help work the existing PL/SQL logic and rebuilt the entire process model in Informatica.
• Extensively used all the features ofInformatica 8.1 includingDesigner, Workflow manager and Repository Manager, Workflow monitor.
• Created mappings using varioustransformationslike update strategy, lookup, stored procedure, router, filter,JAVA, SQL, sequence generator, joiner, aggregate, and expression transformations in extracting data in compliance with the business logic developed.
• Created workflows and tasks in Workflow Manager and linked the database through server setup and various other connections. Created users in Informatica, assigned them various permissions.
• Test HIPPA regulations in Facets HIPPA privacy module.
• Worked with EDI transaction sets like 834,835,837,820 to load the data in the datamarts and verified the data on the reports.
• Involved in impact analysis of HIPAA 5010 835 and 837P transaction sets on different systems.
• Used procedures and triggers to catch and handle exceptions at database level.
• Extracted and loaded data from flat files and Oracle sources to Oracle database usingInformaticamappings.
• Developed Test Cases and SQL Queries to perform various Validations.
• Developed the Test Plan based on the Business Requirement Document.
• Review the test cases based on the Change Request document.
• Preparation of System Test Results after Test case execution.
• Performed testing on various reports generated using Business Objects.
• Tuned the mappings to perform better using different logics and checking the Cache to provide maximum efficiency and performance..

Confidential, Herndon, VA

ETL Consultant

Environment: InformaticaPower Center8.1/7.1, Hyperion Essbase, Teradata, Mainframe, AIX, MS SQL Server 2005, Windows XP.

Responsibilities:

• Worked closely with the end users in writing thefunctional specificationsbased on the business needs.
• Participated in data modeling (logical and physical)for designing theData Marts for finance, Sales, Billingand EDWH.
• Responsible for developing, support and maintenance for theETL(Extract, Transform and Load) processesusinginformatica PowerCenter8.6/7.1.
• Prepared a handbook of standards and Documented standards forinformatica code development.
• Involved insource data profiling& source system analysis.
• Involved in designing theLogical and Physicaldata models for the data warehouse.
• Used transformations likeAggregator, Filter, Router, Sequence Generator, lookup, ExpressionandUpdate Strategyto meet business logic in the mappings.
• Pulled the data from various sources (Mainframesfiles, SQL server) and loaded intoTeradata DWH. And also loaded data into Hyperion Cubes for reporting purpose. CreatedMappletsand used them in different Mappings.
• Useddesigner debuggerto test the data flow and fix the mappings.TunedInformatica.Mappings and Sessions for optimum performance.
• Provided detailed technical,process and supportdocumentationlike daily process rollback and detailed specificationsand very detailed document of all the projects with the workflows and their dependencies.
• Worked with mappingparametersandvariablesto load data from different sources to correspondingpartitionof the database table..
• Created Schema objects like Indexes, Views, and Sequences..
• Involved in Unit testing ofMappings,Workflowsanddebuggingmappings for failed sessions.
• Created partitions, SQL over ride in source qualifier, session partitions for improving performance.
• WrittenUnix Shell Scriptingbased on requirements