SUMMARY

• 9+ years of overall experience in the IT Industry.
• 8+ years of experience in working with data warehouses and using Informatica Powercenter 6.1, 7.1, 8.1, 8.6, 9 (Designer, Repository Manager, Workflow Manager and Workflow Monitor).
• 8+ years of extensive experience with databases (MS SQL Server 2000/2005/2008 , Oracle 8i/9i/10g/11g, Teradata, and IBM DB2).
• 4+ years of data modeling experience using ERWIN.
• 4+ years of UNIX shell scripting. Hands on exposure on UNIX environment and experience in using third party scheduling tools like Autosys.
• Experience with Medicare, Medicaid, Medigap/Medsupp & commercial insurances in HIPAA ANSI X12 4010, 5010 formats including 270,271, 276, 277, 835, 837, 997, NPI, ICD 9,ICD 10, NDC, DRG, CPT, NCPDP codes & NSF formats for interfaces & images to clearinghouses/ trading partners applications.
• Extensive knowledge with dimensional data modeling, star schema/snowflakes schema, fact and dimension tables.
• Experience in building of ODS, data marts, and enterprise data warehouses.
• Expertise in configuration, performance tuning, installation of Informatica, & in integration of various data sources like Oracle, Teradata, MS SQL Server, IBM DB2, XML and Flat files.
• Extensive work with PL/SQL, performance tuning of Oracle using Tkprof, SQL trace, SQL plan, SQL hints, Oracle partitioning, various indexes and join types.
• Understanding & working knowledge of CDC.
• Experienced in tuning Informatica mappings to identify and remove processing bottlenecks.
• Experienced with IDE/IDQ tools for Data Analysis / Data Profiling and Data Governance.
• Hands on experience on Informatica Power Exchange for loading/retrieving data from mainframe systems.
• Experience in UNIX shell scripting, FTP and file management in various UNIX environments.
• Wrote UNIX shell scripts to automate the data transfer (FTP) process to and from the Source systems, to schedule weekly and monthly loads/jobs.
• Extensive experience with the Trizetto FACETS 4.60 Data models.
• Good working knowledge and experience with ODI.
• Experience in working with COBOL files, XML, and Flat Files.
• Written the scripts needed for the business specifications (BTEQ Scripts).
• Knowledge of Oracle Apps (Oracle Enterprise Business Intelligence).
• Proficient knowledge in ETL using SQL SSIS.
• Strong skills in data analysis, data requirement analysis and data mapping for ETL processes.
• Experience in mentoring and providing knowledge transfer to team members, support teams and customers.
• Reliable, proactive, responsible, hardworking and good team player.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.0/8.x/7.x/6.x, SSIS, OWB, ODI

BI Tools: Cognos BI Suit, SSRS, Business Objects 6.5, OBIEE

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

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

Client Side Skills: SQL, T - SQL, PL/SQL, UNIX shell scripting, Java, HTML, XML, CSS, JavaScript, C, C++, VB 6.0

Web Servers: IIS v5.0/6.0, Apache Tomcat

OS: Windows 2000/2003/XP/Vista/Windows 7/8.1, UNIX/Solaris, Red Hat Linux, AIX.

Version Control: Visual Source Safe 6.0, CVS

Methodologies: Data Modeling Logical / Physical, Star/ Snowflake Schema, FACT & Dimension Tables, ETL, OLAP, Agile, RUP, SDLC

Design/Process: UML

Tools: Toad, Erwin, Rational Rose, MS Project, JIRA, Test Director, Bugzilla, TestTrack Pro, MS Visio, Autosys, Turbo Data Generator, Advance Data Generator.

PROFESSIONAL EXPERIENCE

Confidential, Buffalo Grove, IL

ETL Consultant

Environment: - InformaticaPower Center 9.5.1,DB2, Oracle 11g, PL-SQL, SQL Loader, ERWIN, Flat files, TOAD, PL/SQL, Teradata, Tivoli, UNIX, Informatica Data Quality, Informatica power Exchange.

Responsibilities:

• Extracted the data from the DB2, flat files, XML and loaded intoData warehouse.
• Used Different transformations like Source Qualifier,Filter, Expression, Sequence Generator, Update Strategy, Joiner, SQL Transformation and Lookupto develop robust mappings in theInformaticaDesigner.
• Performed data analysis with match and consolidation transformations in Informatica Data Quality (IDQ)
• UsedSCD Types mappings to updateSlowly Changing DimensionTables.
• Prepared code withETLstandards, Naming conventions and wrote
• Prepare Processflowdocumentation for Project.
• Involved in migrating the mappings and workflows variousenvironments.
• Involved inQA Testing,User AcceptanceTesting to check data flow and load is expected according to the user requirements.
• Extensivelymigrateddata from different source system toODS, Data marts and Data warehouse.
• Maintainedstoreddefinitions, transformation rules and targets definitions usingInformaticarepository Manager.
• Standardizedparameterfiles for Session and Workflow likedatabase connection and many default values for table and process.
• Involve in UNIX scripting, Tuning, Modification
• UsedDebuggerto Check thedata flowandfixthe mappings.
• Testedthe data and data integrity among various sources and targets.
• DevelopedUNIX shell scriptsto move Staging files toDB2 databaseusing DB2bulkloads.

Confidential, Lake Forest, IL

ETL Developer

Environment: Oracle 11g, PL-SQL, InformaticaPower Center 9.1.0, ODI, Oracle Warehouse Builder, TOAD, DB2, Erwin, TFS, Daptiv, SharePoint, MS SQL Server 2008

Responsibilities:

• Mapped business requirements to source systems to decide what data elements will be extracted.
• Create Mapping and design Document.
• Worked extensively in the development of Extract,Transformationand Load routines.
• Involved in full development cycle of Planning, Analysis, Design, Development, Testing and Implementation.
• Working on implementing logic for change data capture.
• Involving in tuning view and materialized view with update query and change structure.
• Involving in creation of Migration document to code migration with dependencies.
• Working on change request system to make changes through getting approval of reviewer, tester and management.
• Created mappings using various active and passive transformations.
• Implemented data warehousing methodologies for Extraction, Transformation and Loading using Informatica Designer, Repository Manager, Workflow Manager, Workflow Monitor, and Repository Server Administration Console.
• Created mapping using different transformations like - Source Qualifier, Connected - Unconnected Lookup, Filter, Expression, Router, Normalizer, Joiner, Update, Rank, Aggregator, Stored Procedure, Sorter and Sequence Generator.
• Created mapping on new transformations like SQL transformation, XML transformation, Java transformation, Transaction Control transformation, and Web service consumer transformation.
• Extensively worked onInformatica IDE/IDQ
• Worked on data profiling using IDQ.
• Expertise in implementing complex business rules by creating re-usable transformations, Mapplets, Mappings, Session and Workflow Variables.
• Design and Develop PL/SQL scripts.
• Documented all the mappings, Procedure, Function, Packages involved inETL process Unit test and integration testedTarget data.
• Implemented optimization and performance tuning of code to achieve high response times.
• Created variables and parameters files for the mapping and session so that it can migrate easily in different environment and database.

Confidential, Denver, CO

ETL Developer

Environment: InformaticaPower Center 9.1.0, Oracle 11g, TOAD, PL-SQL, Teradata, DB2, Erwin.

Responsibilities:

• Mapped business requirements to source systems to decide what data elements will be extracted.
• Create Low Level Design Document.
• Working on change data capture from source to target.
• Worked extensively in the development of Extract,Transformationand Load routines.
• Coordinated between theonsite and offshore ETL teams as a lead offshore developer for meeting the scheduled project milestones and deadlines.
• Collected, normalized and integrated source data from its operational databases, as well as from third-party hospital, laboratory and physician disease reports.
• Developed transformations and mapping guidelines for loading different targets
• Used Informatica Power Centerto create maps and transform data.
• Used IDQ to implement validation process from Data Dictionary tables and ensure standardization in the data warehouse.
• Created mappings using various active and passive transformations like source qualifier, lookup, router, procedure, aggregator, filter, joiner, expression and reusable mappings inInformatica.
• Design and Develop PL/SQL scripts.
• Documented all the mappings and the transformations involved in ETL process
• Unit and integration tested Informatica Sessions, Batches, Workflows and the Target data.
• Implemented optimization and performance tuning of mappings to achieve high response times.

Confidential, Falls Church, VA

ETL Consultant

Environment: - InformaticaPower Center 8.6.1/9.0.1 , Oracle 10g/11g, PL-SQL, SQL Loader, ERWIN, Flat files, TOAD, PL/SQL, MS SQL Server 2005, Teradata, Crystal Reports,Autosys, OBIEE 10g/11g, UNIX.

Responsibilities:

• Extracted the data from the Oracle, flat files, XML and loaded intoData warehouse.
• Provided support and assist toonshoreandoffshoreTeam members.
• Used various transformations like Source Qualifier,Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure and Lookupto develop robust mappings in the Informatica Designer.
• Involved in analysis for ICD - 10 changes and HIPAA EDI 5010 changes.
• Involved inDimensional modeling(Star Schema)of the Data warehouse and used Erwin to design the business process, grain, dimensions and measured facts.
• UsedType 1 SCD and Type 2 SCDmappings to updateSlowly Changing DimensionTables.
• PreparedETLstandards, Naming conventions and wroteETLflowdocumentation for Stage andODS.
• Involved in migrating the mappings and workflows from Development toTestingand then toProductionenvironments.
• Involved inUnit Testing,User Acceptance Testing to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.
• Extensively migrated data from different source system to ODS, Data marts and Data warehouse.
• Maintainedstoreddefinitions, transformation rules and targets definitions usingInformaticarepository Manager.
• Standardizedparameterfiles to define session parameters such asdatabase connectionfor sources, targets, last updated dates for Incremental loads and many default values of fact tables.
• Involve in PL/SQL scripting, Tuning, Modification
• Created sessions, configured Workflow to extract data from various sources,transformed data, and loading into data warehouse.
• UsedDebuggerto test thedata flowandfixthe mappings.
• Involved inPerformance tuningat source, target, mappings, sessions, and system levels.
• Testedthe data and data integrity among various sources and targets.
• Used RapidSQLto test the SQL’S and to view the data coming from different systems.
• DevelopedUNIX shell scriptsto move Staging files to DB2 databaseusing DB2bulkloads.
• Prepared documentation describing development of mappings, coding, testing and designing of Autosys jobs and Developed Autosys Jobs to run theworkflows in batches.

Confidential, Minneapolis, MN

ETL Developer

Environment: -InformaticaPower Center 8.1.1/7.x, Oracle 8i/9g, PL/SQL, CVS, Maestro, Toad, SQL * Loader, MS SQL Server 2000, Sun Solaris 2.6, UNIX, Perl, Windows XP.

Responsibilities:

• Used Repository manager to create user groups and users, and managed users by setting up their privileges and profile
• Tuned performance ofInformaticasession for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Created Complex mappings using Unconnected Lookup, Aggregate and Router transformations for populating target table in efficient manner.
• Created Mapplet and used them in different Mappings.
• Created events and tasks in the work flows using workflow manager.
• Provided production support by monitoring the processes running daily.
• Created Schema objects like Indexes, Views, and Sequences.
• Wrote stored procedure to check source data with Warehouse data and if not present, wrote the records to spool table and used spool table as Lookup in Transformation.
• Involved in backing up and restoring of Repository.
• Designed and Developed Oracle, PL/SQL and Shell Scripts, Data Import/Export, Data Conversions and Data Cleansing.
• Used BO Designer Module to implement Universes, linkages between tables, creating prompts and queries, parsing the Universes, applying contexts and alias tables to remove cyclic dependencies.
• Worked with Business Objects Supervisor for creating repository, creating and managing the universes, creating categories, creating and managing the users, giving access permissions for Business Objects Reports.
• Created reports like Reports by Policy, Reports by Customer and Reports by Period, Demographic reports and Comparative reports.
• Working with database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.
• Used Perl Scripting schedulingInformaticamaps.

Confidential, Cincinnati, OH

Data Warehouse Developer

Environment: - InformaticaPower Center 8.1.1/7.1, Power Exchange,Erwin, Business Objects 6.5, Autosys, Oracle 8i/9i, DB2, XML, TSQL, MS SQL Server 2005, Teradata, UNIX (AIX), UNIX Shell

Responsibilities:

• Worked with business stakeholders and other technical team members toGather and analyze application requirements.
• Involved in development of Logical and Physical data models that capture current state/Future state data elements and data flow usingErwin.
• Developed end-to-endETLprocesses for Trade Management Data Mart Using Informatica.
• Worked on source analyzer, Ware House Designer, Mapping and Mapplet Designer, Workflow manager and Workflow Monitor.
• UsedJoiner, Aggregator, Expression, Router, Sequence Generator, Update Strategyand Lookup Transformationto manipulate data related to customers.
• Designed and developedInformaticaMappings, Mapplets and Sessions for data loads anddata cleansing.
• Developed and implemented various enhancements to the application in the form of Production and new production rollouts.
• Worked extensively onconfirmed Dimensions for the purpose of incremental loading of the target database. Tuning of the mappings andSQL Scriptsfor a better performance.
• Analyzed the variousbottlenecksat source, target, mapping and session level.
• Generated ad-hoc reports as requested by the team lead using Business Objects free hand SQL. Helped in maintenance work related to reports.

Confidential, Gainesville, GA

Data Warehouse Developer

Environment: InformaticaPower Center 6.x/7.x, Oracle 8i/9i, MS SQL Server 2000, Erwin, UNIX, Business Objects 5.0.

Responsibilities:

• Involved in gathering, analyzing and documenting of the data mart system requirements.
• Designed and maintained logical and physical model for data mart schema using ERWIN
• Consolidated data from various sources into the marketing data mart by identifying common data and solving the discrepancy on data values.
• Developed ETL mappings using Informatica Power center 6.1.
• Extensively used Informaticaclient tools - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Transformation developer, Workflow Manager.
• Worked on reusable transformations and transformations like expression, aggregation, lookup, router, filter, update strategy.
• Created staging area tables connecting to relational and flat file sources in target designer.
• Scheduled batches using UNIX scripting.
• Worked on mapping performance issues and session failures.
• Interacted with business users to know their business views in developing and modifying universes and reports accordingly.
• Modified the existing business objects universes.
• Generated Master/Detail reports based on user specification(s).
• Worked towards optimal design of universes, removed loops using aliases and contexts.
• Scheduled and monitored reports using Broadcast Agent Server.

Confidential, Harrisburg, PA

ETL Developer

Environment: InformaticaPower Center 6.x, Oracle 8i, SQL Server, DB2,MS Access 2000, SQL, PL/SQL, MS SQL Server 2000, Erwin, Windows NT.

Responsibilities:

• Mapped business requirements to source systems to decide what data elements will be extracted.
• Created Logical and Physical Modeling of Star and Snowflake schemas based on the business rules inErwin.
• Developed Logical model by iteratively refining it based on user feedback to match analysis and reporting requirements.
• Worked extensively in the development of Extract,Transformationand Load routines.
• Coordinated between theonsite and offshoreETL teams as a lead offshore developer for meeting the scheduled project milestones and deadlines.
• Collected, normalized and integrated source data from its operational databases, as well as from third-party hospital, laboratory and physician disease reports.
• Developed transformations and mapping guidelines for loading different targets
• Used Informatica Power Centerto create maps and transform data.
• Created mappings using various active and passive transformations like source qualifier, lookup, router, procedure, aggregator, filter, joiner, expression and reusable mappings inInformatica.
• Documented all the mappings and the transformations involved in ETL process
• Implemented optimization and performance tuning of mappings to achieve high response times.
• Developed Shell Scripts to automate file manipulation and data loading procedures

Confidential

Database Developer

Environment: Oracle, SQL*Plus, PL / SQL, Windows 2000

Responsibilities:

• Created database objects including tables, indexes, roles, clusters, sequence and privileges.
• Involved in Unit testing, Integration testing and Load testing of the interface.
• Involved in documenting the modifications and intended functionalities of the interface.
• Calculated and monitored size and space for tables, clusters and indexes.
• Created and maintained triggers, packages, functions and procedures.
• Helped in creating technical specifications by mapping the interface tables with the base tables.
• Helped Project Lead to develop various reports as needed by management.