SUMMARY

• Over 8 years of experience in ETL Data warehousing using Oracle Data Integrator (ODI)/Sunopsis 3.x 10.1.3.x, Informatica PowerCenter/PowerMart 7.1/6.2/5.0.
• Worked extensively with Sunopsis/ODI Designer, Operator and Security Manager.
• Set up topology for different technologies like Oracle, Sybase, SQL Server, Flat files.
• Developed Interfaces, Procedures, Packages, and Scenarios using Sunopsis/ODI Designer.
• Used variables, sequences, ODI tools and user functions in the development of interfaces, procedures and packages.
• Debugged and tuned interfaces using Designer and Operator to improve the performance.
• Involved in creating various Projects, models for different technologies using Sunopsis/ODI Designer.
• Reverse engineered models from different databases like Sybase, Oracle and Flat files.
• Have good knowledge on journalizing data stores.
• Knowledge in Dimensional Data Modeling (Star Schema, Snow-flake Schema, FACT and Dimension tables).
• Worked extensively with Data migration, Extraction, Loading and Transformation of data from Multiple Sources to Data Warehouse.
• Worked with different data sources non-relational Databases such as Flat files (fixed length and delimited) and other relational sources such as Oracle, Sybase, and SQL Server.
• Database experience using Oracle 10g/9i/8.x, Sybase, MS SQL Server 2000 and also used SQL Editors such as TOAD, SQL PLUS, and Query Analyzer.
• Excellent communication, presentation, project management skills; a very good team player and self-starter with ability to work independently and as part of a team.

TECHNICAL SKILLS

ETL Tools : Sunopsis 3.x/ODI10.1.3.x, Informatica PowerMart v6.1/5.0, PowerCenter 7.1/6.2/5.0
RDBMS : Oracle 10g/9i/8i, Sybase 12.5.x, MS SQL Server2000
Languages : SQL, PL/SQL, Transact SQL, C, C++, JAVA, ABAP, COBOL
Data Modeling Tool : Erwin 4.2/4.0/3.5.2
Database Tools : SQL* Plus, SQL* loader, TOAD v7.6/8.6, SQL Advantage, Embarcadero Rapid SQL
Operating Systems : MS Windows 98/2000/XP/NT, UNIX HP B.11.23.

PROFESSIONAL EXPERIENCE

Confidential,NJ Apr’06 –Till Date
Sr.ETL Consultant

NYK is a leading global logistics enterprise providing world-class logistics solutions to its customers. This project involved development and maintenance of data marts, which helped business users better understand the trends of the business thereby helping them in the decision making.

MIS (Management Information Systems)
Responsibilities:

• Worked with topology manager, creating data servers and data schemas, agents (physical and logical architecture) for different technologies like Oracle, Sybase, SQL Server and Flat files.
• Worked with Security manager creating ODI users, as and when necessary, and giving them privileges by assigning generic or non generic roles.
• Worked with business users and analysts to gather requirements and framed it into technical design document.
• Worked on data profiling and data analysis of the various systems used by ODI.
• Worked with data modeler in designing models for MIS Centralized Data Warehouse (CDW), Net Contribution and Equipment Data Marts.
• Actively participated in the data model reviews and the BI meetings.
• Worked and customized different types of knowledge modules (CKM, IKM & LKM) while developing interfaces.
• Reverse engineered models to retrieve data stores and created keys, references and conditions on the data store.
• Developed Interfaces, Procedures and Packages using ODI Designer to implement business requirements.
• Worked with various data sources like Oracle, Sybase, SQL Server, XML and flat files.
• Worked extensively on debugging and performance tuning of interfaces.
• Implemented the error handling logic in the ETL interfaces.
• Performed unit testing of the ODI packages and provided support during QA phase.
• Imported and exported scenarios from and to different environments.
• Executed, monitored and scheduled scenarios using ODI Operator.
• Executed and monitored scenarios using Metadata navigator.
• Worked with the QA team in developing test cases and helped them better understand the implementation.

Tactical Reporting
Tactical Reporting provides various reports related to Accounting, Shipment, Job Orders and Vessel Schedules to the NYK business users. These data integration projects involved sending Flat Files as FTP to NYK Tokyo and Europe Systems through ODI. These also involve creation of various reports and sending them to the business users through email.

• Worked with the NYK Regional System end users in gathering the business requirements.
• Worked with various data sources and targets like Oracle, Sybase, SQL Server, XML and flat files (fixed and delimited).
• Developed ETL interfaces to load the Staging/Temporary tables which are used in subsequent interfaces to handle the complex business logic.
• Created models in ODI for the fixed and delimited files in ODI designer.
• Created the ODI procedures for file renaming and file moving in the servers.
• Used various ODI functions while developing the packages to implement the business logic.
• Developed complex packages which involved using Project/Global variables to dynamically pass the database names during run-time.
• Used ODI API’s to sending the reports as email attachments
• Performed the integration and connectivity tests with the target system as part of pre-production deployment activities.
• Worked with business users directly and executed the jobs as and when they requested and reported the data issues.

Environment: Sunopsis 3.x/ODI 10.1.3.4.x, Oracle10g/9i, Sybase, SQL Server 2000, TOAD, Erwin 4.2, Windows 2000, UNIX, SQL Advantage, Embarcadero Rapid SQL

Confidential,Indianapolis, IN Jan’05 - Mar‘06
ETL Consultant

Eli Lilly And Company, a leading pharmaceutical company in Indianapolis. Project involved in Data Warehouse development for sales division, which contains the company’s sales data. This Data Warehouse project will enable management to better leverage information collected within current operational systems to help in their decision making process.

Responsibilities:

• Participated in requirement gathering meetings with business analysts and ETL architect to understand source and data warehouse data model, technical metadata.
• Documented required technical metadata such as source and target definitions.
• Created technical design specifications for mappings, sessions, workflows.
• Worked on different OLTP data sources such as Oracle, SQL Server and Flat files.
• Created complex mappings in PowerCenter Designer using Aggregate, Expression, Filter, Sequence Generator, Update Strategy, Rank, Sorter, Lookup and Joiner transformations.
• Implemented Type II slowly changing dimensions using date-time stamping.
• Created reusable transformations and mapplets and used them in mappings.
• Configured and used the Debugger to troubleshoot the mappings.
• Proficient in using Informatica workflow manager, workflow monitor, pmcmd (Informatica command line utility) to create, schedule and control workflows, tasks, and sessions.
• Worked with DBA team to fix performance issues in ETL programs.
• Wrote SQL, PL/SQL, stored procedures for implementing business rules and transformations.
• Created users, folders and set their access privileges in repository manager.
• Worked with export and import utilities in Repository manager.
• Involved in migrating from 6.1 to 7.1.
• Scheduled workflows in Unix using CRON job.
• Involved in writing test cases and unit testing; worked with QA team to resolve any QA or UAT issues.

Environment: Informatica Powercenter 6.1/7.1, Oracle/9i, SQL Server 2000, SQL, PL/SQL, SQL*Plus, TOAD, Erwin 4.2, Windows NT, Unix.

Confidential,Auburn Hills, MI Aug’04 - Dec’04
ETL Developer

Gedas USA is a global IT provider successfully supporting select industries for over 20 years. Gedas is involved in developing, implementing and operating individual solutions along entire value-added chain. Its service portfolio includes general consulting, business process consulting, and systems integration & operation. It has its central focus on the automotive industry and its suppliers.

Responsibilities:

• Created technical design specifications for mappings, sessions, workflows.
• Used Reverse Engineering principle in Erwin 4.2 to understand the existing data model.
• Extensively used Flat Files to read/write data and databases like Oracle, SQL Server.
• Created complex reusable transformations and mapplets using Lookup, Aggregator, Update strategy, Expression, Joiner, Rank, etc. in the Transformation Developer, and Mapplet Designer, respectively.
• Implemented Type II slowly changing dimensions using date-time stamping.
• Reusable tasks such as Sessions and Commands were developed using Task Developer.
• Worked with worklets in Worklet Designer and set up workflows in Workflow Manager.
• Assisted the production support team with the deployment and the troubleshooting initial phase hiccups.
• Used the Mapping Debugger to debug mappings in the Mapping Designer.
• The session, event and error logs were examined and analyzed for troubleshooting mappings and sessions.
• Performance issues were extensively dealt by making necessary coding changes for improving the system performance.

Environment: Informatica PowerCenter 7.1, Windows NT, Unix, Oracle9i, SQL server, TOAD, Erwin 4.2.

Confidential,San Francisco, CA Nov’03 – Jun’04
ETL Developer

The Providian financial is one of the leading financial companies of USA. Providian has various data marts like OIS, ODSP, CAPONE and ICARD. Their marketing information system (MIS) team runs reporting on pre-screen, non-prescreen and booked data for their various decision supports. The MIS team runs report by setting many options manually at present, since the data is stored at various servers like DWPODS1, CHEWY, SHEMP and MKTDB. In order to eliminate the cumbersome and time consuming process, the ADM project arises to serve MIS development team have better reports, time savings and better utilization of data. The ADM process will store all static information about the Acquired/Booked customer required by MIS team.

Responsibilities:

• Extensively worked with both fixed width and Delimited Flat files and also the relational database Oracle 9i.
• Developed mappings, reusable Transformations for ETL using Informatica Power Center 6.2.
• Worked extensively on different types of transformations like source qualifier, expression, filter, aggregator, rank, update strategy, lookup, sequence generator and joiner.
• Configured sessions with Email and Command task.
• Configured workflows with email task, Control task, Event-Raise task, Event-Wait task, Timer task, Command task and decision task based upon business requirements.
• Created workflows and reusable worklets for designed mappings.
• Worked on Dimension as well as Fact tables, developed mappings and loaded data.
• Analyzed the session, event and error logs for troubleshooting mappings, sessions and workflows.
• Worked with mapping variables, Mapping parameters and session parameters.
• Extensively used debugger to troubleshoot logical errors.
• Extensively used PL/SQL for creating views, stored procedures on the tables.
• Involved in partitioning of the sessions and performance tuning of database, Mappings, as well as Sessions.
• Used the Informatica command line utility pmcmd to start and schedule the workflows by setting a cronjob and wrote UNIX Shell scripts to create pre and post session commands.

Environment: Informatica PowerCenter 6.2, Oracle 9i, SQL*Plus, PL/SQL, TOAD 7.6, UNIX, Windows NT.

Confidential,Kalamazoo, MI, Nov’01– Oct’03
DW Consultant

Pfizer Pharmaceuticals is one of the largest pharmaceutical companies in USA and manufactures some of the highest quality prescription drugs that are used in the whole world.
Our project was creation of Sales Data Mart, an extraction of data from various data sources. The other sources that were integrated are data from IMS into ODS (Operational Data store). The project involved extracting data from heterogeneous data sources, transforming the data and then loading the data into the target Data Mart for Warehouse operations. This central location of data will made it easier to acquire tool(s) to create and manage common reports so that each group can benefit from or leverage work done by other groups. Informatica PowerCenter 6.2 is the ETL tool on Unix HP box and Windows 2000 platform, Oracle 9i RDBMS.

Responsibilities:

• Worked with data modeler’s team to create Data Flow Diagrams.
• Developed Informatica mappings and mapplets, between sources and operational staging targets, and fine-tuned some of them for better performance.
• Created views and altered some of the dimensional tables to satisfy the reporting needs.
• Employed Source Qualifier, Lookup, Expression, Aggregator, Rank, Sequence generator and Joiner transformations for populating the datamarts
• Used pre-session and post-session stored procedures in PL/SQL to improve the performance of the session.
• Implemented Type II Slowly Changing Dimensions using Version number.
• Performed migration from 5.0 to 6.2, and performed backup and performance tuning.
• Extensively Worked with Variables and Parameters in the mappings to pass the values between sessions.
• Instrumental in writing PL/SQL stored procedures and packages for transactional details (insert, update and delete operations)
• Created Migration Documentation and Process Flow for mappings and sessions.
• Created Event Wait, Event Raise, Timer and Control Events in workflow manager according to the business requirement.
• Responsible for unit testing the mappings using SQL scripts.
• Coordinated the UA testing with business users

Environment: Informatica PowerCenter 6.2, ORACLE 9i, HP-Unix, Windows 2000, Erwin 3.5, SQL*PLUS, SQL, PL/SQL.

EDUCATION

Master of Science in Computer Science