SUMMARY

• 9+ years of IT experience in Data Warehouse and Business Intelligence, Design and Implementation of ETL Processes on large scale and small scale projects.
• Experience as a PL/SQLDeveloper in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
• Experience in working on different domains such Insurance, Banking & Finance, Retail, and Healthcare.
• Experience in complete SDLC involving on Business Requirements Analysis, Application Design, Development, testing, implementation and maintenance of Enterprise Data Warehouse applications and providing active and on call production support.
• Extensive experience in working with ETL tool like Informatica Power Center suites Designer, Workflow Manager, Workflow Monitor, Repository Manager, and Administrator Console. Also, worked in different ETL tool like Informatica Power Exchange, Informatica Developer, Informatica B2B Data Exchange, Informatica MDM, and IBM Data Stage.
• Effectively made use ofTable Functions, Indexes, Table Partitioning, Analytical functions, Query Re - Write.
• Developed Complex database objects likeStored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Experience in Performance tuning with both Database queries and Informatica processes.
• Experience in working with data warehouse models like Star and Snowflake schemas and in ER data modeling.
• Create data objects (DDL). Enforce standards and best practices around data modeling efforts Ensure data warehouse and data mart designs efficiently support BI and end user
• Experience in integration of various data sources like Oracle, Sybase, DB2, SQL Server, Teradata,COBOL VSAM, Flat Files like .txt, .csv, Excel and XML files.
• Experience with scheduling ETL processes with Tivoli Workload Scheduler, Control M, Autosys and Informatica scheduler
• Analyzes Business to Technology transition effectively and provide comprehensive design and implementation solutions with the combined technical and functional skills.

TECHNICAL SKILLS

Database: Oracle 11g/10g/9i/8i, SQL Server 2008/2005, Sybase, DB2 UDB.

Operating Systems: UNIX, LINUX, Mainframes, Windows 95/NT/XP, Solaris.

Programming Languages: C, SQL, PL/SQL, UNIX Shell scripts, XML

ETL Tools: Informatica Power Center, Informatica Power Exchange, Informatica B2B Data ExchangeInformatica Developer, IBM Data Stage

Database Tools: Toad, IBM Data Studio, Sybase Central, AQUA DATA, SQL Developer

Automation Tools: Tivoli Workload Scheduler, Control M, Autosys and Informatica scheduler

Test Management tools: Quality Center

PROFESSIONAL EXPERIENCE

Confidential, Cranston, RI

ETL Lead

Responsibilities:

• Worked closely with Business Analysts and was Involved in design and implementation of the ETL processes (Informatica mappings and SQL, PL/SQL) to load data into Data warehouse; Used UNIX/Shell commands for flat file processing.
• Involved in integration of data from various Source System into common fact tables as part of Data Centralization efforts.
• Involved in the Data Modeling, Collaborate with data architects for data model management.
• Conduct data model reviews with project team members.
• Capture technical metadata through data modeling tools.
• Create data objects (DDL). Enforce standards and best practices around data modeling efforts Ensure data warehouse and data mart designs efficiently support BI and end user.
• Performed Informatica administration tasks including creating work folders, assigning owners using Repository manager, migrating xml code from lower environments to higher environments, scheduling workflows.
• Involved in analyzing Informatica metadata by querying repository database tables and Performance tuning of Informatica mapping and workflows.
• Implemented Exception/ Error handling processes by creating email tasks and maintaining error tables.
• Performed Unit testing and supported the UAT by the business users and provided production support for the warranty period.
• Effectively Coordinate and discuss with the Users, Business Intelligence Leader, and the Process leads to clarify their requirements and gather additional information regarding the request to be developed
• Creating weekly status and monthly status reports and metrics.
• Actively involved in providing production support and debugging/ resolving ETL issues.

Environment: Informatica Power Center 9.1.0, Oracle, DB2, SQL/PLSQL, Teradata, SQL Developer, UNIX, Microsoft Visio, MS SharePoint and MS Office applications.

Confidential, Columbia, SC

Lead ETL Developer

Responsibilities:

• Involved in research and POC and then design and development of the Geo Codes for the Mobile App using Informatica Developer tool.
• Identified the different types of records and data defects in file and based on that the data clean-up was done using the Informatica Coding.
• Involved in the Creation of Geo Codes (Latitude and Longitude) of address for each records in file using Informatica Developer.
• Involved in the Migration and then System Integration testing.
• Involved in Migration, Creating error handling processes, UAT & SIT testing, debugging issues and providing support.
• Involved in analyzing the existing ETL Codes in Informatica and created the low level documents for the Migration Project to help the development in SSIS.

Environment: Informatica Power Center 9.5x, Informatica Developer 9.5.1, SQL Server 2008, Oracle SQL developer, Toad, SQL/PLSQL, UNIX, Mainframe, MS Office.

Confidential, Windsor, CT

Sr. ETL/ Lead Developer

Responsibilities:

• Analysis of specifications provided by Clients in the Functional Document and Functional element data dictionaries.
• Understand the existing flow of data and design the new approach.
• Performed Gap analysis, created technical design/STT documentation and developed the new code using Informatica Power Center. Created Informatica mappings to load data from files into the RCDS and ODS tables.
• Worked onSQL*Loaderto load data from flat files to the Oracle Tables.
• Created scripts to createnew tables, views, queriesfor new enhancement in the application.
• Createdindexes on the tables for faster retrieval of the data to enhance databaseperformance.
• Created the Unix Shell scripts for file transfer. Email & Archive script for files.
• Schedule to Jobs in Tivoli Workload Scheduler. Also, created the PMCMD command to run them.
• Mentored team members and was involved in peer review processes.
• Worked actively in production support as L2 support. Performed error handling, Change request, ticket handling using the ITSM tool.

Environment: Informatica Power Center 9.1.1/8.1, Sybase, SQL/PLSQL, TWS, UNIX, ITSM, Microsoft Share Point, Visio, MS Office.

Confidential, Windsor, CT

Sr. ETL Developer

Responsibilities:

• Involved in Analysis, preparation of ETL design documents, technical diagrams, run books required for the Client Centralization project.
• Worked as a Senior Developer to implement the whole New Informatica changes for RCDS along with the UNIX scripts and TWS scheduler scripts.
• Responsible for Informatica Mapping, Workflow development, Deployment Group for migration.
• Developed the UNIX shell scripts which are mainly used for FTP the output files from Informatica server to downstream server.
• Provided effort estimates, assigned work to team members and coordinate between different cross functional teams.
• Worked with Sybase and created a mechanism in PL/SQL codes for switching the tables before and after load.
• Implemented Exception/ Error handling processes by creating email tasks and maintaining error tables.
• Performed Unit testing and supported the UAT by the business users and provided production support for the warranty period.

Environment: Informatica Power Center 9.1.1/8.1, Sybase v6.0, SQL/PLSQL, TWS, UNIX, ITSM, Microsoft Share Point, Visio, MS Office.

Confidential, Windsor, CT

Sr. Developer

Responsibilities:

• Provided project estimates, work on the timelines for the deliverables, update status reports and work very closely with the manager and the business partners in identifying key issues and resolving them pro-actively.
• Gathered requirements, created ETL design documents and mapping documents.
• Developed the stored procedures in DB2 Database which implement the business logic to provide the desired Admin Server data extracts for RCDS.
• Developed the informatica mapping which uses the DB2 Procedures to extract data from Admin Server Database and generated the files for RCDS.
• Responsible for Informatica mapping, Workflow development, Deployment Group for migration.
• Developed the UNIX shell scripts which are mainly used for FTP the output files from Informatica server to downstream server.
• Involved in design review, code review and in performance analysis;
• Worked closely with the QA team to ensure the quality of the code and provided support to the business users doing the User Acceptance Testing.

Environment: Informatica 9.1, DB2 UDB, UNIX, Aqua Data, UNIX shell script, PL/SQL.

Confidential

Sr. Developer

Responsibilities:

• DB2 is used to write the stored procedure to load data from the XML sources to the EODS database.
• Created the XML Schema Definition (XSD) for the source of XML.
• Created stored Procedure to move data from the stage area to the ODS tables.
• Created procedures to automatically drop the indexes before data load and create the indexes after load.
• Prepared test cases for EODS Stored Procedures.
• Prepared design document for the project.
• Prepared the Implementation Plan for the stored procedures.

Confidential

Responsibilities:

• Transformed data according to the business requirements and loaded into the Relational Database and Delimited flat files; Created complex mappings/ workflows and implemented Slowly Changing Dimensions (SCD 1 & 2).
• Prepared the DB2 load utilities for different tables to load data in faster way.
• Created the PL/SQL Trigger to load tables in DB2 to avoid the Integrity constraint issue.
• Preparation of Unit test cases and execution of unit test.
• Involved in testing Interfaces dealing with huge amount of data and fixing critical bugs within the mappings/ work flows.
• Maintained documentation for each ETL process including the mapping and transformation rules, source and target definitions, output flat file locations, shell scripts and template files directories.
• Review of coding Standard with use of tools like AQUA Report

Environment: Informatica Power Center 8.1.0, DB2, UNIX, SQL/PLSQL, AQUA DATA, MS office, Microsoft Share Point, Control M

Confidential

Informatica Developer

Responsibilities:

• Analysis of specifications provided by Clients in the Functional Document and Functional element data dictionaries.
• Understand the existing flow of data and design the new approach.
• Construct the new tables and alter the existing ones to suit the requirement.
• Responsible for creating Informatica mapping & Workflow development based on the requirement documents.
• Code review and preparation of code review check list.
• Effectively Coordinate and discuss with the Users, Business Intelligence Leader, and the Process leads to clarify their requirements and gather additional information regarding the request to be developed
• Creating weekly status and monthly status reports and metrics.
• Debug and resolve the issues that arise in case of any failures in mappings and those logged through tickets

Environment: Informatica Power Center 8.1.0, Oracle, UNIX, Toad, SQL, PLSQL, MS office

Confidential

Informatica Developer

Responsibilities:

• Responsible for gathering the requirement from Clients and creating the mapping documents.
• Prepared the Informatica mappings and Workflows based on the mapping documents using Informatica Power center.
• Worked on Complex informatica mappings to eliminate the duplicates data.
• Informatica Power Exchange was used to fetch the data from Mainframe Cobol files.
• Analyzed the data mapping and developed test scenarios to verify the data migration from Preparing Test cases and scripts based on client requirements
• Performance tuning on the Informatica mapping at the transformation level as well as workflow level.

Environment: Informatica Power Center 8.1.1, DB2, UNIX, Mainframe, AQUA DATA, MS office

Confidential

Informatica Developer

Responsibilities:

• Understand the current architecture, existing Informatica Jobs and the Mainframe system populating the DB2 Database.
• Actively Production Monitoring of the existing system and solving Production/Data Issues.
• Responsible for debugging the issues in case of any failure and communicate accordingly.
• Responsible for Error handling and bug fixing.
• Responsible for accepting the failure tickets and finally close them after resolution.
• Worked on enhancement of mappings to permanent resolution of failures.

Environment: Informatica Power Center 7.1.1, DB2, UNIX, Mainframe, Control Centre, MS office