SUMMARY

• Over Seven years of IT experience in various phases of IT projects following the SDLC process such as analysis, design, coding, testing and deployment.
• Six plus (6+) years of strong Data warehousing experience in building and managing various data warehousing/data marts using Informatica products such as Power Center 8.6.1/8.5/8.0/7.1/6.2/5.1 , Power Exchange 5.2, Metadata Reporter, Metadata Exchange for Data models.
• Extensive experience with ETL tool Informatica in designing and developing complex Mappings, Mapplets, Transformations, Workflows, Worklets, Configuring the Informatica Server and scheduling the Workflows and sessions.
• Extensive experience in designing and developing complex mappings from varied transformation logic like Unconnected and Connected lookups, Normalizer transformation using various COBOL sources, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy etc.
• Extensively worked in OLTP & OLAP environment that includes production, QA and development databases in SQL Server.
• Extensive Experience in Performance Tuning of targets, sources, mappings and sessions
• Extensively worked in Client - Server application development using Oracle 9i/8i, PL/SQL and SQL*Plus.
• Extensively worked with different Teradata utilities
• Experience in writing SQL queries, Stored Procedures, Cursors, and Cursor variables.
• Extensively worked with Change Data Capture (CDC) in all my previous projects.
• Good Knowledge with UNIX Operating System and Shell scripting
• Demonstrated ability to quickly grasp new concepts, both technical and business related and utilize as needed.
• A Team Player with excellent communication, analytical, verbal and writing skills.
• Excellent Communication and interpersonal skills.

TECHNICAL SKILLS

Data Warehousing: Informatica Power Center 8.6.1/8.6/ 8.5.1/ 8.1/ 7.1.3/7.1.1/6.2/5.1.2/5.0 (Source Analyzer, Warehouse Designer, Metadata Manager, Mapping Designer, Mapplets, Transformations, Workflow Manager, Worklets, Workflow Monitor), ETL, PowerCenter Connect for Siebel CRM & SAP R/3.

Data Modeling: Logical and Physical data modeling, Star-Schema Modeling, Snowflake Modeling, FACT and dimension tables, ERWIN

Databases & GUI: Oracle, Teradata, SQL Server, IBM DB2

Operating Systems: MS Windows XP, 98, Windows NT/2000, NT 4.0

Languages: PL/ SQL, SQL* Plus 8, UNIX Shell Script

Tools: & Utilities: SQL* Plus 8, Erwin 3.5/4.0/4.1/7.1 , Toad for Oracle V8.6, FTP Tools, BTEQ

PROFESSIONAL EXPERIENCE

Confidential, Thousand Oaks, CA

Informatica Developer

RESPONSIBILITIES:

• Developed technical design specs to pull the data from MPS(Medicaid Processing System) and load in to MODEL N
• Developed Informatica mappings which includes data validations and error handling mechanism
• Converted Functional Design in to technical design and presented to architecture team
• Mentored onsite team on daily activities and deliverables
• Developed unit test plans to validate the data flow and error handling
• Extensively used Teradata Parallel Transformer (TPT), a new feature of Power center 8.6.1
• Worked on Push down Optimization (PDO), which improves the mapping performance
• Extensively worked on tuning the indexes on Teradata tables
• Developed different mappings by using transformations like expression, router, normalizer, lookup, aggregator, filter
• Prepared mapping specification documents for EDW project
• Fixed bugs for ongoing production support application
• Developed technical design documents of EDW
• Scheduled different workflows using Informatica scheduler
• Developed workflows using different tasks Decision, Email, Command, Event wait
• Designed and Deployed extract-transform-load (ETL) processes using Informatica and Teradata SQL
• Worked along with the DBA to resolve performance and tuning issues

Environment: Informatica Power Center 9.1/8.6.1/8.1 , Power Exchange 8.6.1/8.1, SAP R3, Power Connect/ Power Exchange, SQL Server 2005, Oracle 10g, Teradata, SQL Assistant, Meta Data Manager, Erwin

Confidential, PA

Sr Informatica Developer

Responsibilities:

• Working as an ETL designer for multiple processes to build new DWH model.
• Worked on real time data HL7 messages, flat file, relational sources to load staging area and DWH tables.
• Designed and Developed mappings in Informatica to load the data from DWH sources to Netezza dimensional model for reporting purpose.
• Designed and developed ETL Informatica Interfaces and Stored procedures for data integration.
• Worked on Tidal scheduling tool to create job stream and dependency for different process.
• Worked on Oracle OHADI tool to load data from staging to DWH tables.
• Developed several Mapplets by identifying the reusable logic used in various mappings.
• Worked on the archive strategy to move production data to archive server for exception log data.
• Implemented Persistent cache reusable transformation to use by multiple process to get patient Id for patient related encounter to load in DWH.
• Implemented Web service call through Java transformation to get patients Id which doesn’t exist in DWH.
• Implemented the design for incremental process to load the new data.

Environment: Informatica 9.5.1, Oracle 10g, Tidal scheduler, SQl developer, UNIX, Oracle OHADI, HL7spy.

Confidential, Richmond, VA

Informatica Developer

RESPONSIBILITIES:

• Mentored offshore team on daily activities and deliverables
• Reviewed the code developed by offshore team
• Followed work break down structure (WBS) for assigning tasks to offshore team
• Reviewed and translated BRD/BSD in to technical specifications design (TSD)
• Developed technical specifications design (TSD) for VA Claims track
• Coordinated with SME for technical clarifications
• Extensively worked on 3NF ER modeling tables to load the data in to reporting layer
• Extensively worked on BTEQ scripts to load huge volume of data in to EDW
• Integrated data in to EDW by sourcing it from different sources like SAP, mainframe copy books (Cobol files), DB2 and Teradata tables
• Loaded data in to some of the DB2 X-ref tables
• Developed Infa mappings with DB2 as targets to support ESI application
• Loaded data in to Landing Zone (LZ) Teradata tables, applied transformations and then loaded the data in to conformed staging area(CSA)
• Analyzed the source systems before starting the development
• Loaded data from CSA to EDW by cross referencing the RDM codes
• Extracted data using BTEQ scripting which includes Fast Export and Multi Load utilities
• Extensively worked on Informatica 8.6.1 to extract the data and load it in to LZ
• Coordinated with SIT team for testing different scenarios
• Developed unit test cases with different scenarios
• Production support of different subject areas which loads the data in to Teradata DWH
• Implemented Audit balancing using BTEQ scripting
• Designed Teradata LZ tables with appropriate Primary index

Environment: Informatica Power Center 8.6.1, Power Exchange 8.6.1, SAP R3 Power Connect/ Power Exchange, Windows, SQL SERVER 2005, SSIS, Teradata 12.x, SSIS, IBM DB2 8.x, Oracle 10g, Toad for IBM DB2, Erwin, BTEQ

Confidential, Burbank, CA

Informatica Developer

RESPONSIBILITIES:

• Responsible for Data Extraction and Transformation from disparate sources like Oracle, SAP R/3, SQL Server, XML files and loading in to XML files using Informatica Power Center 8.5.1/8.6.
• Imported SAP Source definitions such as SAP tables and views, SAP hierarchies, SAP IDOCS into the Power Center Repository using Power Exchange 8.5.1 (Power Connect).
• Extensively worked with different sources in order to feed the data to MDM System
• Involved in developing Thirteen interfaces of MSB Application
• Developed Error handling mechanism to enhance the data quality loaded to MDM
• Involved in documenting the Technical Design Specs (TDS) for all Thirteen interfaces
• Used Workflow Manager for creating workflows, Worklets, Decision, Control, command and email tasks
• Involved in scheduling the informatica workflows using Tidal Scheduler
• Imported SAP Source definitions such as SAP tables and views, SAP hierarchies, SAP IDOCS into the Power Center Repository using Power Exchange 8.5.1 (Power Connect).
• Worked with SAP/ALE IDoc Interpreter transformation in an outbound IDOC mapping
• Validated all the output XML files against the XSD’S using Liquid XML Studio 2008.
• Processed SAP Outbound IDOCS of 300 KB for MPM Interface through JMS Listener
• Unit tested different SAP OUTBOUND IDOCS with different Test cases
• Developed a shell script in order to append Date and Time stamp for output xml files, to remove empty delta files and to FTP the output xml files to different server
• Developed mappings with XML Parsers in order to split the incoming message from Web sphere/Message Queue
• Extensively worked with Target XSD’s in order to generate the output xml files.
• Developed mappings with xml file as source and XSD as target for MARS INPUT SYSTEM
• Involved in performance tuning of different views with Oracle and SQL SEVER DBA’S

Environment: Informatica PowerCenter 8.5.1/8.6, XML, Oracle, SQL, BTEQ, Power Connect, PL/SQL, SAP R3, UNIX, C#, SQL Server 2005, Windows XP, Liquid XML studio 2008, Tidal

Confidential, Minneapolis, MN

Informatica Developer

RESPONSIBILITIES:

• Involved in analysis and resolving the data issues related to Customer, Distributor and Transaction increments of the data warehouse
• Involved in review and finalizing the technical specs of source-target mapping documents
• Involved in designing Error Handling strategy using Error detection/Notification/Re-Processing processes
• Experience in working with ETL against large scale terabytes of data and databases including SAP
• Invoked IDOC program through Informatica Power Connect to push data from an ETL target to SAP R/3.
• Developed scripts for automating workflows using ksh and Bourne shell scripting.
• Involved in designing Audit process for the sessions loaded as part of mapping design as well querying against informatica repository tables
• Involved in enhancing the current data model using Erwin 4.0 to accommodate the new EDW and Cross-Reference tables
• Involved in data migration procedure and mapped data from legacy systems to new existing systems for providing a design for data extraction and data loading.
• Involved in all data migration phases like design, extraction, cleansing, load and verification
• Created mappings using the transformations such as the Source qualifier, Aggregator, Expression, lookup, Router, Filter, Sequence Generator, Update Strategy
• Involved in performance tuning Informatica mappings with XML, Normalizer, Joiner, Aggregator, Sequence Generator, Union, Router, Filter transformations
• Used Workflow Manager for creating workflows, Worklets, emails, and command tasks
• Development of Unix shell scripts to automate starting/recovering the informatica workflows
• Involved in scheduling the informatica workflows using Control-M
• Involved in tuning the mappings with audit, error design and reprocessing strategies
• Implemented load parallelism using informatica database partitioning
• Performed Unit Testing and Integration Testing on the mappings
• Lead a team of 15 offshore resources and monitored the tasks assigned to them

Environment: Informatica Power Center 7.1/8.1, Power Exchange 8.1, Metadata Manager, C#, SAP, BTEQ, Power Connect, SQL Server 2005, XML, Oracle 10g, Autosys, Teradata, SSIS, Erwin 7.0, DB2 on Mainframe

Confidential, Hartford, CT

ETL Developer

RESPONSIBILITIES:

• Involved in discussing Requirement Clarifications with multiple technical teams
• Extensively worked on Informatica tools such as Source Analyzer, Data Warehouse Designer, Transformation Designer, Mapplet Designer and Mapping Designer to designed, developed and tested complex mappings and Mapplets to load data from external flat files and RDBMS.
• Worked with the Business Analyst team during the functional design and technical design phases. Designed the mappings between sources (external files and databases) to operational staging targets.
• Extensively used various transformations like Source Qualifier, Joiner, Aggregators, Connected & Unconnected lookups, Filters, Router, Expression, Rank Union, Normalizer, and Update Strategy & Sequence Generator.
• Extensively used Workflow Manager and Workflow Monitor and scheduling ETL jobs in Informatica 6.2 using PMCMD, repository creation/Backup/Restore using PMREP, Creating repository user/role/group
• Used INFORMATICA POWERCONNECT to extract data from IBM MAINFRAME/DB2 environment, Evaluated INFORMATICA Power exchange for CDC (Change Data Capture)
• Used SQL, PL/SQL to validate the Data going in to the Data Ware House
• Worked along with the DBA to resolve performance and tuning issues
• Worked on Informatica Schedulers to schedule the workflows.
• Created Task Session, Email and Workflow to execute the mappings. Used workflow monitor to monitor the jobs, reviewed error logs that were generated for each session, and rectified any cause of failure.

Environment: Informatica Power Center 7.1, PowerConnect, Power exchange, SAP, Oracle 10g, PL/SQL, SQL, SQL*PLUS, SQL*LOADER, ERWIN 3.5, WINDOWS NT