SUMMARY

• Having around 10 years of IT experience in the implementation of Data Warehousing applications.
• Well versed with Data warehousing Architecture on the Design, Development, Extraction, Transformation and Loading of data using Informatica Power Center 5.1/6.2/7.1.3/8.1/8.6/9.1/9.5 as an ETL tool.
• Extensive experience in design and creating data warehouse, data marts using Informatica Power Center.
• Extensively worked on SQL and PL/SQL (Oracle 8i/9i/10g/11g, DB2 8.1/9.7, Teradata 13/14).
• Worked with business users for requirement gathering, planning and analyzing to prepare functional specification document (FSD), Systems Design Specification (SDS) documents etc.
• Exposure to various business processes spanning over Insurance, Banking, Health Care, Finance and Retail.
• Having excellent knowledge on Data Warehousing and BI concepts.
• Experienced in Installation, Configuration and Administration of Informatica Power Center on Client/Server environment.
• Data modeling experience using Dimensional Data modeling, Star Schema modeling, Snowflake modeling, FACT and Dimension tables, Physical and logical data modeling using Erwin.
• Worked on Informatica Powerconnect for SAP R/3 systems and worked in ABAP method for RFC/ BAPI method of mappings
• Experience in SAP BW data load using Informatica Power Connect and good Knowledge on PSA data model.
• Worked on Data Profiling - IDE and IDQ to examine different patterns of source data.
• Developed Power Exchange data maps and used CDC techniques to capture the changed data that were used to pull the data from files on the Mainframe /VSAM files.
• Worked on advanced Informatica power center version 9.5 and used critical transformations like Transaction Control, Java Transformation and XML Generator. Also worked on application configuration to send the messages to JMS Queue.
• Worked as a configuration management/versioning to migrate updated mappings, sessions and workflows in XML form to rational clear case environment and promote the code from one environment to other.
• Used Requirement Traceability Matrix (RTM) to ensure all the requirements are covered as per the business needs.
• Proficiency in the areas of Access Management, Trouble Shooting and Technical Documentation.
• Having good knowledge on Informatica B2B tools like Informatica DX Tool and Data Transformation components like Parser, Mapper and Serializer.
• Worked on all major databases like Teradata, Oracle, DB2 and SQL Server. Also having good knowledge in Netezza and Hadoop.
• Having knowledge in other ETL Tools IBM Info sphere (Data stage 8.1), Abinitio and OLAP Tools Hyperion 6.1.

TECHNICAL SKILLS

Operating Systems: Window 9X/NT/2K/XP, UNIX, Linux.

GUI: SQL Loader, TOAD, Winsql and DB2 Visualiser.

Databases: Oracle 8x/9i/10g/11g, DB2 8.1/9.7, SQL Server and Terradata 6.1/8.1/13/14.

Data Warehousing/BI Tools ETLTools: Informatica Power center 5.1 /6.2.1/7.1.3/8.1/9.1/9.5 Power Exchange Navigator v5.2.2/8.1, Power Connect for SAPIBM Info sphere (Data stage 8.1) and Hadoop.

OLAP Tools: Hyperion, OBIEE and Cognos.

PROFESSIONAL EXPERIENCE

Confidential, Columbus, Ohio

Sr. Informatica Developer

Responsibilities:

• Participated in design and review of software requirement specifications (SRS) documents
• Prepared the Technical specification documents based on business requirements
• Involved in logical and physical data modeling was done using Erwin for data warehouse database in STAR SCHEMA.
• Extensively used almost all of the transformations of Informatica including complex lookups, Stored Procedures, Update Strategy, mapplets and others.
• Used post session success, post session failure commands in the session task to execute scripts for reconciliation, cleanup and updates.
• Involved in writing test scripts, unit testing, system testing and documentation.
• Worked with Developers to understand requirements for the purpose of generating test cases.
• Prepared and ran sql queries to verify Dimensional and Fact tables.
• Prepared test data for functional & Integration testing
• Scheduled, Run and Monitored Informatica flows using scheduling tool Maestro
• Used requirement Traceability Matrix (RTM) to ensure all the requirements are met.
• Involved in performance tuning issues at various levels such as target, sessions, mappings and sources.
• Improved session Performance by enabling property incremental aggregation to load incremental data into target table.
• Used pmcmd commands for stopping and starting workflows and tasks and involved in postproduction support and enhancements.

Environment: Informatica Power Center 9.5, Teradata 14.10, Netezza, Hadoop, Unix/ Linux, Scheduling tools Maestro/ ESP.

Confidential, Dover, NH

Technical Lead

Responsibilities:

• Referenced Functional Specification documents to understand the functional requirements to prepare the Technical Design documents
• Analyzed project requirements and participated to prepare the project plan at the task level
• Compared DB2 and Teradata databases properties/ metrics/ features to migrate DB2 warehouse to Teradata warehouse
• Prepared design documents as per the analysis of DB2 stored procedures
• Created the Teradata Set/ Multiset tables as per the data model/ requirements specifications
• Developed complex mappings to convert DB2 stored procedures into ETL mappings using Informatica Power Center to load data into Teradata
• Developed many Informatica mappings to replace DB2 targets with Teradata tables using Informatica 9.1.
• Tested and implemented appropriate Teradata loader utilities as per the load volume/ job requirements for better performance
• Designed delta or Incremental load process for all the ETL jobs
• Developed the error Logic for streamlining, automating the data loads for cleansing incorrect data and developed Auditing mechanism to maintain the load statistics of transactional records
• Worked on performance Tuning of the mappings to handle increasing data volume
• Prepared the scheduling document to implement the job dependencies, setup the sequential or concurrent jobs for better execution in each subject area.
• Design and review documents including Software Requirement Specifications to ensure all the requirements are covered
• Creation of Unit Test Cases (UTC’s), Unit Test Scripts and captured unit test results
• Involved in ETL, Unix and DDL’s code migration from one environment to other
• Reviewed complex mappings using multiple transformations, sessions, workflows in Informatica and lead the ETL team

Environment: Informatica Power Center 9.1, Teradata 13.10, DB2 8.1, Sybase and UNIX.

Confidential, Phoenix, AZ

Technical Lead

Responsibilities:

• Worked as onsite lead in the Onsite/Offshore Model Production Support.
• Participated in preparing the System Design Specification using the Functional Specifications Document (FSD)
• Prepared the Technical Design documents as per the System design specification (SDS)
• Worked to design the proper architecture which can isolate the application component (business context) of thedata integrationsolution from the technology, also helps for reuse of skills and design objects
• Create Business Process Flow diagrams showing interfaces among connected systems for each scenario in Visio
• Prepared the Design documents as per the requirements of the Business Analysts and Data model
• Developed complex mappings using Informatica Power Center Designer to transform Telephone service centers data for multiple geographic locations via flat files to load to DB2 database
• Worked on converting sql server, .net code to Informatica mappings
• Designed and Developed Informatica Mappings using Informatica 8.6 with DB2 as Target Database
• Head the internal technical review board with the rest of the leads for any design related changes, additions and initiatives
• Designed delta or Incremental load process for all the ETL jobs
• Performance Tuning of the mappings to handle increasing data volume
• Developed Shell Scripts for retrieving files from FTP server, achieving the source files, Concatenating files and finally to deliver them to remote shared drive
• Developed the error Logic for streamlining, automating the data loads for cleansing incorrect data and developed Auditing mechanism to maintain the load statistics of transactional records
• Creation of Unit Test Cases (UTC’s), Unit Test Scripts with captured unit test results
• Reviewed complex mappings, Workflows using different transformation, sessions in Informatica and leading the ETL team

Environment: Informatica Power Center 8.6, DB2 8.1/ 9.7, SQL Server 2005, Control M Scheduling tool.

Confidential, Dublin Ohio

ETL Team Lead

Responsibilities:

• Worked as onsite lead in the Onsite/Offshore Model Production Support.
• Acted as a key contributor in the team to ensure delivery and SLA based production support.
• Worked with the various enterprise groups to document user requirements, translate requirements into system solutions and produce development, testing and implementation plan and schedules.
• Load monitoring and Enhancement of existing application for business changes/improvement/audits.
• Developed complex mappings using Informatica Power Center Designer to transform Financial Data extraction from different legacy systems (AS400, SAP, and Oracle), Oracle, SQL Server, flat files and loading to different target systems.
• Create connectivity to sapr/3 legacy system by configuring sapfrc files and worked with Basis/Unix teams for required access to there systems.
• Handled Data Loads for conversions during Production Go-Live.
• Performance tuning of the mappings to handle high data volume.
• Understanding Source system data issues with Source System Owners and designing to handle the gaps.
• Developed BAPI Mappings to use custom and existing SAP Functions from the SAP legacy system.
• Generated and installed SAP R/3 code for mapping extracting data for SAP source/ Target tables and worked with Basis team to promote the SAP R/3 code as Transports into other environments.
• Responsible for maintaining different process documents like mapping status document, Issue log, Defect detection log etc.
• Responsible for analyzing the Error table data/rejected data and fix them.

Environment: Informatica 8.1.1, Oracle 9.1, Teradata 8.1, SAP R/3, SQL server 8.0, UNIX and Unicenter scheduler.

Confidential, Dublin Ohio

Team Lead

Responsibilities:

• Acted as a key contributor for Production support and involved in supporting the Data Integration application for ETL.
• Referenced Functional Design Documents (FDS), Systems Design Specification (SDS) to understand the overall application.
• Worked as onsite lead in the Onsite/Offshore Model Production Support.
• Monitoring the data loads and Enhancement of existing application for business changes/ improvement/audits.
• Performance Tuning of the mappings to handle increasing data volume.
• Resolved different issues in the support environment like code issues, connectivity issues, data issues, scheduling conflicts, managing dependency jobs, space issues on the Unix server or databases, capacity planning, system maintenance etc so worked with appropriate teams in resolving the production issues in a timely manner by identifying the issues.
• Responsible for proper knowledge transfer from development team and ensure all the required documents are handed over.
• Responsible for maintaining different logs like mapping status document, Issue log, Defect detection log etc.
• Responsible for analyzing the Error table data as well as rejected data and fix them.
• Played an active role in preparing the ETL specification documents for customization.
• Managing the work load timely by distributing it appropriately among the team and prioritizing the severity issues in a timely manner.
• Able to quickly investigate/identify the root causes of the issue, if required reach to other teams if it’s an external issue and fix it ASAP.

Environment: Informatica 7.1.1, Oracle 9.1, Teradata V2R5/ V2R6, SAP R/3, SQL server 8.0, UNIX and Unicenter.

Confidential, Detroit

Sr. Informatica Developer

Responsibilities:

• Understanding the customer requirements and analyzing or resolving the discrepancies in the business requirements
• Worked to design the proper architecture which can isolate the application component (business context) of thedata integrationsolution from the technology, it also helps for reuse - reuse of skills, design objects, and knowledge
• Prepared the Technical Design documents as per the Functional Requirements document and Logical Data model
• Worked on IDE/ IDQ for creating profiles in identifying different patterns of source data and examined with business team for correcting/ Analyzing
• Extensively used Informatica to load data from VSAM, flat files and DB2
• Developed Power Exchange data maps that were used to pull the data from files on the Mainframe / VSAM files
• Developed Shell Scripts for retrieving files from FTP server, achieving the source files, Concatenating files and finally to deliver them to remote shared drive
• Developed the error Logic for streamlining, automating the data loads for cleansing incorrect data and developed Auditing mechanism to maintain the load statistics of transactional records
• Designed and developed standard load strategies to load data from source systems to Actimise Database which is the final target system.
• Prepared documentation on the design, development, implementation, daily loads and process flow of the mappings and participating in review design documents
• Used IBM DB2 Control center, Control editor to check the table design, records populated in the DB and used to test the data to check whether it is correctly loaded into the required schemas as per the business requirements
• Extensively involved in performance tuning using various components in the mappings, sessions or database tables and used Parameter files, Variables, cache mechanism and using SQL overrides

Environment: Informatica Power Center 8.1, Power Exchange Navigator v.8.1, Mainframe source system, DB2, AIX OS as platform and CA7 Scheduling tool.

Confidential

Sr. Informatica Developer

Responsibilities:

• Understanding existing system and customer requirements and analyzing the data model and identification of heterogeneous data sources
• Designed Low level documents as per the requirements
• Extensively used ETL to load data from Oracle, AS400 using Informatica Power Center
• Extensively used Informatica Power Center for Extracting, Transforming and Loading from different databases.
• Developed mappings, tested the mappings using various test cases in the test plans
• Converted the data mart from Logical design to Physical design, defined data types, Constraints, Indexes, generated Schema in the Database, created Automated scripts, defined storage parameters for the objects in the Database.
• Worked on advanced informatica power center version 8.1 and used critical transformations like XML Generator and worked in configuration to send the messages to JMS Queue
• Created workflows, sessions and maintained database connections using connection variables in Informatica Workflow Manager
• Extensively involved in performance tuning of complex mappings and make required changes in the mappings, sessions or database table depending on case to case
• Moving of mappings and sessions from development repository to production repository
• Participating in providing solutions to the bugs identified and resolved the tickets raised by testing team in the available time frame
• Migrated updated mappings, sessions and workflows in XML form to Rational clear case environment

Environment: Power Center 8.1, Power Exchange Navigator v.8.1, Oracle 10g, Windows XP, Oracle 9i, VLAN for Network Connectivity, IBM Rational Clear Case(RCC) for Backup, Global Delivery Dashboard(GDD) and Sun Solaris as Platform.

Confidential

Informatica Developer

Responsibilities:

• Understanding the business requirements from External Design and preparing Internal Design
• Created data maps using Power Exchange Navigator for the sources and targets as required
• Having interaction with Accenture Canada Team and Confidential Tech Arch’s to resolve some of the offshore tech & functional issues
• Used SQL Loader utility to load data from flat files to relational tables by using the control files to pass the required parameters to read the data file. Also resolved the issues identified in loading larger data files and using multiple files in a single session.
• Creation of Informatica Mapping & Mapplets for ETL processing of inbound feeds & other sources to EDSF
• Mockup of Unit Test Data (only for some of the mappings)
• Code reviews of Informatica Mapplets, Mappings, and Workflows
• Creation of Unit Test Plans (UTP), Unit Test Cases (UTC’s), Unit Test Scripts with captured unit test results
• Taken care of all the mandatory checks for all distinct field types - Date Field, Number field and etc
• Used most of the transformations of Informatica - Expression, Sequence Generator, Filter, Router, Sorter, Normalizer, Update Strategy and LookUp Transformations
• Created data maps using Power Exchange Navigator for the sources and targets
• Tuning of Informatica mappings to improve the performance
• Providing solutions to the bugs identified by the testing team

Environment: Informatica 7.1.3, Power Exchange Navigator v.5.2.2, Oracle 9i, TIDAL as 3rd Party Scheduler Tool, Citrix, Actuate 8 (SP2) as Reporting Tool, Windows XP and Sun Solaris.