SUMMARY

• Over 8 years of IT experience in System Analysis, Design, Development, Implementation and Testing of Data Warehouse and Data Integration applications in domains like Financial, Banking, Insurance, and Telecommunications.
• Hands on experience with AGILE and Software Development Life Cycle (SDLC) in all aspects of Software development.
• Expert level skills in developing Strategies for Extraction, Transformation and Loading (ETL) using Informatica Power Center 7x, 8x and 9x, Informatica Data Exchange, Data stage etc.
• Profound knowledge in the principles of DW, designing and implementing Fact Tables, Dimension Tables, E - R modeling, Star schema and Snowflake Schema modeling using ERWIN.
• Worked in projects with Dimensional Modeling, Data migration and ETL Processes.
• Experience in writing BTEQ scripts and loading data into Teradata using FASTLOAD, MLOAD and TPUMP utilities.
• Expert in Unit Testing, System Integration Testing, Implementation, Maintenance and Performance Tuning.
• Good knowledge in designing & developing application using J2EE, Server Side Components using Java,, XML,, Web Services (SOAP).
• Expert in Data Warehousing techniques for Data Cleansing, Slowly Changing Dimension phenomenon (SCD), surrogate key assignment and CDC (Change Data Capture).
• Experience with high-end programming using PL/SQL, SQL, and Unix Shell Scripting.
• Expert in working on various operating systems like UNIX, LINUX and Windows.
• Expertise in debugging and optimizing the Business Objects/Oracle BI and Informatica Mappings / Workflows.
• Experienced in Multi-Terabyte environments, solid experience in coding using SQL, SQL*plus, PL/SQL, TOAD, stored procedures/functions, triggers and packages.
• Extensive experience in extraction, transformation and loading of data directly from different heterogeneous source systems like Relational Sources, Flat files, XML, Mainframe COBOL files, Web Services.
• Highly motivated and adaptive with the ability to grasp things quickly.
• Excellent team member with effective communication, interpersonal skills, ability to balance multiple short-term programming projects.

TECHNICAL SKILLS

ETL: Informatica PowerCenter 9.1/8.6/8.1/7.1 , Metadata Manager, IDQ, IDE IBM InfoSphere Data Stage 8.X/7.X.

Databases: Oracle 9i /10g, ParAccel, SQL Server 2000/2005, Teradata, DB2.

Database Modeling: Erwin 4.0/3.5, Star Schema, Snowflake schema, Fact and Dimensions Tables, Physical and Logical Data Modeling, Dimensional Data Modeling

Programming: SQL, SQL PLUS, PL/SQL,C, Shell Scripting, XML, HTML.

Database Tools: Data Studio, WinSQL, TOAD, SQL Navigator, SQL*Loader, Test Director, Quality Stage, ERWIN.

Operating Systems: Windows NT/9X/2000/XP, UNIX, LINUX

Other Tools: WinSCP, DAC, Putty, Autosys, Tidal, HP Quality Center, MS Visio, MS Project, MS office

PROFESSIONAL EXPERIENCE

Confidential, Portland, OR

ETL Developer/Informatica

Responsibilities:

• Worked with Internal IT teams to prepare functional and technical specifications from which integrations will be written and other activities to ensure successful implementation.
• Created ETL jobs to generate and distribute reports from MySQL database using Pentaho Data Integration and to handle the maintenance and processing of data.
• Function as a hand- on member of team, supporting the teams in the design, documentation, and development, troubleshoot, and validate ETL process and publishing of various technical components.
• Creation of mappings for decoding files containing different SWIFT message formats and Intercepting different SWIFT messages.
• Designed and exported universe for standard/ad hoc reporting requirements for end users. Linked Universes and modified the Budget Universe for the purpose of generating ad-hoc reports. Involved in Writing Detailed Level Documentation for reports and Universe design.
• Effective use of advanced reporting and formatting functions in Business Objects reporting.
• Create and execute unit test plans based on system and validation requirements to support for Integration testing, User acceptance testing and Go Live.
• Involved in Relational and Dimensional Data Modeling Techniques to design ERWIN data models.
• Assisted in designing and management of PostgreSQL database schemas and tables.
• Document all ETL related work per company’s methodology including specifications for new/existing and operational turnover/support.
• Created the ETL exception reports and validation reports after the data is loaded into the Data warehouse.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Worked Single handedly on Logility Forecast Project for Demand Planning Analysis by integrating the Logility and EDW. Worked with Tidal enterprise scheduling tool as part of the requirement.
• Worked as a member of the team for SAP landing into EDW and involved with the SAP BW teams in creating process chains and open hubs as part of the requirement

Environment: Pentaho Data Integration, 9.1/9.5, Teradata v13, SQL Server 2005/2008, SAP BW, SFDC, Flat Files, XML, Windows XP, Tidal Scheduler.

Confidential, Minneapolis, MN

Informatica Developer

Responsibilities:

• Created mappings and sessions to implement technical enhancements for data warehouse by extracting data from Flat file sources.
• Used Teradata utilities fastload, multiload, tpump to load data.
• Written BTEQ scripts to transform data and Fast export scripts to export data.
• Implemented Teradata Fastload, Multiload and Bteq scripts, DML and DDL and constructed Korn shell driver routines (write, test and implement UNIX scripts)
• Wrote views based on user and/or reporting requirements.
• Development of ETL jobs for error handling in ParAccel using Informatica 9.1.
• Created jobs for straight loading of the data coming from Flat files and SFDC files into tables in ParAccel Database.
• Generated dynamic web-reports using java, JavaScript, HTML, DHTML using PL/SQL with HTP and HTF.
• Applied slowly changing dimensions like Type 1 and 2 effectively to handle the delta Loads.
• Extensively used Informatica debugger to figure out the problems in mapping. Also involved in troubleshooting existing ETL bugs.
• Writing File watcher jobs to schedule the jobs and call the dependency jobs in ParAccel.
• Scheduled ETL Jobs using Data Administration Console in Operational Data Store.
• Involved in Requirement Analysis, Existing code Analysis and worked on Fact tables, Dimension tables, History tables.
• Performed Unit testing of several jobs and involved in deploying the code from development to Production.
• Verify program logic by overseeing the preparation of test data, testing and debugging of programs.
• Scheduling of the jobs are done in DAC
• Closely worked with the Micro Strategy (reporting) team to ensure that correct data is presented in the reports

Environment: Informatica Power Center 9.1, ParAccel Database, Teradata R12/R13, Java, J2EE, Teradata SQL Assistant, Oracle, SQL, SQL Developer, WinSQL, DAC, WinSCP, UNIX.

Confidential, Minneapolis, MN

Tech Lead/Informatica Developer

Responsibilities:

• Used Informatica Power Exchange for loading/retrieving data from mainframe systems.
• Developed complex ETL structures to extract, transform and load data from multiple data sources into data warehouse based on business requirements.
• Extensively worked with SCD Type-I, Type-II and Type-III dimensions and data warehousing Change Data Capture (CDC).
• Created ODI design documents from the existing Informatica mappings. Used these design documents in development of ODI interfaces/packages.
• Troubleshooted the ODI connection with oracle by fixing the tnsnames.ora file, TNS listener and DNS entries.
• Set up the ODI connection with Oracle, MS SQL Server and flat files and performance tuned the ODI interfaces
• Verify program logic by overseeing the preparation of test data, testing and debugging of programs.
• Oversee overall systems testing and migrations of platforms and applications to production.
• Assure quality, security and compliance requirements are met for supported area and oversee creation of or updates to and testing of the business continuation plan.
• Significant and in-depth Data analysis, data management and determining data behaviors.
• Worked closely with Onsite Coordinator and attend Design Review and Code Review meetings.
• Worked on Data Quality issues which ensure accurate reports in downstream jobs by identifying the code issues and redesigning the code in Informatica Power Center Client.

Environment: Informatica Power Center 9.5/9.1, Informatica Power Exchange, Autosys, UNIX, Solaris, Oracle, SQL, SQL Developer, DB2, IBM Data Studio

Confidential, Minneapolis, MN

Sr. Data Integration Developer

Responsibilities:

• Worked closely with the Business analyst to understand the various data sources and requirements.
• Heavily involved in Requirement Analysis, ETL Design and Development for extracting from the source systems and loading it into the Data mart, and creating documents according to project standards.
• Used Informatica Power Center Workflow manager to create sessions and workflows to run the logic embedded in the mappings.
• Worked in on-site offshore model. Managed offshore team of 4 developers during testing phase to register and resolve defects and change requests using HP quality center.
• Created complex mappings which involved Slowly Changing Dimensions, implementation of Business Logic and capturing the deleted records in the source systems
• Performed Informatica administrative tasks such as stopping/starting Informatica Repository and Server processes.
• Provided Production Support for business users and documented problems and solutions for running the workflow.
• Used Workflow Monitor to monitor the progress of workflow and session and also used the workflow log and session log for trouble shooting purposes.
• Debug mappings to gain troubleshooting information about data and error conditions using Informatica Debugger.
• Understanding the specification and analyzed data according to client requirement.
• Performed unit testing to test load time and documented the Unit Test Results and Unit Test Cases.
• Involved in unit testing and preparing test cases and Involved in peer-to-peer reviews. Used HP Quality Center for defect logging and resolution.

Environment: Informatica Power Center 9.5/9.1, XML, Oracle 11g, TOAD 8.6, SQL plus, Win XP, HP Quality Center, Teradata, SQL assistant, SQL Server 2005/2008

Confidential, NY

Informatica Developer

Responsibilities:

• Interacted with business users to understand the business requirements
• Translated business requirements into Data warehouse design.
• Coordination with offshore team for development and support activities.
• Extracted data from different source systems /flat files/parameter files to load the staging tables and the master tables.
• Worked extensively with front end team to meet the business requirements.
• Developed various shell scripts for ETL process, to truncate the staging tables, to ftp the files from local server to remote, file validation scripts, file archive scripts, mailing scripts.
• Worked extensively in Informatica Designer, Workflow Manager, and Workflow Monitor.
• Created stored procedures, packages, triggers, tables, views, synonyms, and test data in Oracle.
• Creating Data Maps, Extracting (incremental) CDC data from Main frame sources, exporting Data maps to Repository and Importing Mainframe source files on to shared folders.
• Involved in the design phase of logical and Physical data model using ERWIN.
• Extensively worked in the performance tuning of the programs, ETL Procedures and processes.
• Developed PL/SQL procedures for processing business logic in the database.
• Used SQL tools like TOAD to run SQL queries and validate the data in warehouse.
• Created and scheduled jobs using Autosys.

Environment: Informatica Power Centre 9.1, Oracle 11g, DB2, MS SQL Server, IBM Mainframes, Flat files, TOAD, Autosys, UNIX scripting, ERWIN.

Confidential, Battlefield, MO

Informatica Developer

Responsibilities:

• Analyzed the business systems, gathered requirements from the users and documented business needs for decision support data.
• Responsible for performance tuning at all levels of the Data warehouse.
• Prepared technical design/specifications for data Extraction, Transformation and Loading.
• Interpreted logical and physical data models for business users to determine common data definitions and establish referential integrity of the system.
• Created the Entity Relationship diagrams and maintained corresponding documentation for corporate data dictionary with all attributes, table names and constraints.
• Prepared technical documentation to map source to target.
• Designed, Developed, Deployed and implemented ETL mappings using Informatica.
• Developing PL/SQL Procedures, functions, packages to load the data from sources to targets and utilized multi-threading for the parallel execution of same procedure.
• Testing Informatica mappings, PL/SQL programs and Tuning the mappings, PL/SQL programs.
• Pushing the data from development database to PLE (Production like Environment) database.

Environment: Informatica Power Center 8.6/8.1, Toad 8.5.1.6, Teradata, Oracle 10g/9i, PL/SQL, Erwin 4.x, SQL server 2005.

Confidential

Data base Developer Intern

Responsibilities:

• Involved in Business Analysis and Requirements Gathering.
• Attended in-house Training in Informatica and Dimensional Data Modeling.
• Utilized SQL*Loader to load data from flat files in to the base tables.
• Designed various Database objects like tables, Views, Sequences, Collections.
• Used Informatica Power Center 6.1 to create data mappings.
• Developed Analytical applications that can analyze large amounts of online and offline data.
• Installation and setting up of oracle database dedicated server and multi-threaded server.
• Developed front-end forms and Reports using Oracle Forms and Reports builder.

Environment: Oracle 9i, Informatica Power Center 6.2, SQL, TOAD, UNIX.