SUMMARY

• Extensive career experience in Data Warehousing and Decision support Systems with wide experience in implementing Data Warehousing solutions to large corporate clients, and has professional experience with various industries such as Financial, Healthcare, Retail/RND Industry, Energy, and Government healthcare data warehouse.
• Strong experience in Implementing Full Life cycle Data Warehousing Projects and Extensive experience in development of Decision Support Systems (DSS) and developing, designing, testing, implementing, and deploying DW and BI Solutions
• Strong Data Warehousing experience using Oracle 11g/10g Warehouse Builder, OLTP, OLAP, Dimensional Data Modelling using Star & Snow Flake schema. Extensive Experience with Ralph Kimball and Bill Inman Methodologies
• Experience working with Oracle Data Integrator (ODI) topology manager, designer, Operator and trouble shooting issues.
• Worked on Extensive Coding in Oracle, PL/SQL and UNIX with large databases in various stages of SDLC like Development, Enhancement, and Maintenance & Production Support.
• Exposure to handling large volumes of Data Extraction and Data Loading and full cycle implementation of DW project and managed small/medium size projects including client interactions
• Exposure to handling Data from various sources (Oracle, Netezza, SAP, SQL Server, DB2, Teradata, Flat files, etc.)
• Hands - on experience in designing, tuning, and leveraging large data warehouses using RDBMS databases applications.
• Proficiency in data warehousing techniques for data cleansing, Slowly Changing Dimensions, surrogate key assignment and change data capture.
• Possess analytical skills, ability to communicate effectively with all levels of management, and ability to share knowledge of I.T. process best practices, project planning, application build and testing, data integration, reporting, and documentation.
• Expertise with large database application of Data warehouse, Client/Server in various stages of SDLC like Development, Enhancement, Maintenance & Production Support and have sound knowledge in Oracle Architecture.

TECHNICAL SKILLS

ETL/ELT: ODI 12C/11g/10g, Oracle Warehouse Builder 11gr2 (OWB)

RDBMS: Netezza, Oracle 11g/10g, SAP ECC 6.0, SQL Server 2005/2000, Teradata v2r5, DB2

REPORTING: OBIEE 11.1.1.5

Data Modeling: CA Erwin r8/7.3, Visio

Programming Languages: SQL, PL/SQL, UNIX shell scripting

Oracle: SQL Developer, SQL*PLUS, WinSQL, TOAD, Microsoft SQL Studio

Version Management: IBM Clear Case, IBM SCM, Rational Team Concert

PROFESSIONAL EXPERIENCE

Confidential, Rochester

ODI Consultant

Responsibilities:

• Analyze and support ETL mapping specification
• Extract data from Oracle to Oracle and SQL server to Oracle 11g
• Create interfaces using Knowledge modules like IKM Oracle Incremental update Confidential, IKM Oracle Control Append Confidential, CKM Oracle.
• Worked on Changed Data Capture (CDC) to Journalized Knowledge Module (JKM) Simple
• Applied patch from ODI 11.1.1.6 TO 1.7
• Worked on customizing knowledge modules according to the project requirement.
• Scheduled CDC process using Oracle Golden Gate and tested journalized interfaces.
• Created temporary and permanent data store interfaces according to the requirement
• Created load plans, packages, procedures, variables, and generated scenarios.
• Scheduling jobs using Tidal scheduler.
• Used IBM CLEAR CASE/SCM to version all ODI objects and unit test documents for backups.
• Used IBM Change and Configuration Management Application (CCM) to track the work progress.
• Used SQL Developer and TOAD tool to unit test the code.

Environment: ODI 11.1.1.6, ODI 12C, Oracle 10g/11g, SQL Server, Netezza, SQL Developer, Tidal, TOAD, IBM Rational Clear Case, UNIX, Putty

Confidential, Boston

ODI Consultant

Responsibilities:

• Created specification documents for all interfaces.
• Extracted data from SQL Server, Oracle, DB2, Flat files to Netezza database.
• Created interfaces using KM (file to Netezza, oracle to Netezza, Sql server to Netezza), IKM (Netezza control append, Netezza incremental update, Netezza SCD), CKM (CKM Netezza)
• Created procedures, packages, global functions, global and project variables.
• Created temporary and permanent datastore interfaces by re-modifying db2 scripts in ODI.
• Created home grown scrub function using Korn shell script and executed functions.
• Created packages with error and success emails notification and also created email notification variables.
• Used markers and memos to distinguish interfaces and projects for ease to other developers.
• Schedule scenarios using packages.
• Worked on customizing knowledge modules according to the project requirement.
• Used hints and joins for handling performance of the job.
• Worked on upgrading to ODI 11.1.1.6.
• Move repositories from ODI 10.1.3.5 to ODI 11.1.1.6.
• Worked on the existing upgrading issues by logging the issues and working with oracle team.
• Unit tested all interfaces, procedures, variables, and functions using ODI and WINSQL tools.

Environment: ODI 10.1.3.5, Oracle 10g, DB2, SQL Server, Netezza, WinSQL 9.0, Windows, Unix, Putty.

Confidential, New Jersey

ODI Consultant

Responsibilities:

• Gathered Business requirement, coordinate with end user and offshore Mexico team.
• Translated business requirements into technical specifications to build the Enterprise Data Warehouse.
• Installed ODI 11g on server and client machines, created physical and logical schema for Oracle, SAP, and file server for development, testing, and production.
• Responsible for configuration of Master and Work Repository on Oracle
• Involved in system study analysis for logical/physical data model there by defining strategy for implementing Star Schema with Fact and Dimension tables
• Created Logical and Physical data modeling schemas for fact and dimensions, oracle schemas, tables, procedures, etc.
• Develop packages for the ODI objects and scheduled them as scenarios.
• Support in full legacy to ODI data conversion and Integration task.
• Responsible for creating complex interfaces according to business requirements.
• Worked on ODI Designer for designing the interfaces, defining the data stores, interfaces and packages, utilized the ODI Knowledge Modules (Reverse Engineering, Loading, Check, and Integration) to create interfaces to cleanse, Load, and transform the Data from Sources to Target database.
• Created ODI Packages, Jobs of various complexities and automated process data flow.
• Used ODI Operator for debugging and viewing the execution details of interfaces and packages.
• Worked closely with OBIEE11g developer for creating RPD’s, created users and access roles through EM, and installed OBIEE on client machines.
• Created reports by sorting, applying aggregator, and created dashboards.

Environment: ODI 11.1.1.6, SAP ECC6.0, Oracle 10g, SQL developer 3.0, MS SQL Server Management Studio 10.50, CA Erwin DM r8, Visio, OBIEE 11.1.1.5

Confidential, Albany

OWB Consultant

Responsibilities:

• Gathered business rules and created/modified logical and physical design using CA Erwin DM for ETL process.
• Responsible for writing PL/SQL Programs stored procedures, packages, functions which accomplish solutions to existing DW which served as service/Change request.
• Responsible for designing, developing and testing of the ETL strategy to populate the data from various source systems (Flat files, Teradata, MS SQL Server and Oracle) feeds using PL/SQL and OWB.
• Wrote Technical specifications for developing OWB mappings.
• Responsible for extract data from old Data warehouse to existing data warehouse according to the client requirement.
• Involved in data conversion from multiple databases to an existing Data Warehouse.
• Developed PL/SQL Programs to load data to DW from various sources using stored procedures, packages, functions and triggers.
• OWB 11gr2 is used to validate, cleanse, transform, and load data within the Oracle staging database.
• Created complex mappings with transformation objects such as Joins, Expressions, Filters, Union, Aggregator, Pivot, De-duplicator, Splitters, Sequence, etc., to implement complex logic. These are used to cleanse data identified in the data quality analysis process and to re-structure the data for reporting purposes.
• Created type 2 slowing changing dimensions mappings by comparing grain of the incoming to the existing rows.
• Created mappings for 5 types of loads with proper renaming columns, validating dates and times columns, and setting indicator values.
• Handel mapping performance, if mapping takes more time to run than expected.
• Created Process Flows for data flow with binding variables and directing transitions with its status.
• Worked on Performance Tuning by Analyzing tables, Transformations, Hints, Explain Plan, Indexes, constraints, partitions, and Materialized Views.
• Unit Test all mappings to verify if mappings are according to the specs, loaded data in target table has the matching/relevant records, and insert/updated some sample records for accuracy.
• Worked in QA for testing ETL mappings which compares data from EMED to current MDW system. Testing includes minus scripts and sampling data in SQL Dev 3.0

Environment: Oracle Warehouse Builder 11gr2, Oracle11g, Teradata, CA Erwin DM r7.3, Visio, SQL Developer 3.0, UNIX

Confidential, NC

ETL Consultant

Responsibilities:

• Extracted data from flat files, Oracle, SQL Server 2005 and load the data into Oracle database.
• Worked extensively on LKM, IKM, and CKM for running the interfaces and also some KM’s have been customized for the performance wise.
• Wrote some home grown function for date, strings, conditional, numeric, and hash.
• Configured flat files and oracle Data Servers in Topology Manager.
• Created standard reverse engineering models and created constraints on existing data stores.
• Created many complex interfaces and packages with error and success emails.
• Some of the knowledge modules used are LKM (file to oracle, oracle to oracle, Sql server to oracle), IKM (oracle control append, oracle incremental update, oracle SCD), CKM (CKM Oracle)
• Supported production and testing team.
• Created procedures, global variables and global user functions
• Unit tested all interfaces, procedures, variables, and functions for better performance.

Environment: ODI 10.1.3.5, Oracle Warehouse Builder 10g, Oracle10g, SQL Server 2005, PL/SQL, Oracle workflow, OEM, Windows, OBIEE 10.1.3, OBIEE Administrator

Confidential 

Database Developer

Responsibilities:

• Developed Complex SQL Queries to update and maintain the database
• Developed Stored Procedures using PL/SQL for updates, inserts, and deletes.
• Developed PL/SQL Functions, Cursors for various calculations for reusing.
• Responsible for Tuning SQL Queries and Query Optimization, fixing bugs encountered by users.
• Developed Staging jobs where in using data from different sources formatted, Cleaned, aggregated and transform into data warehouse.
• Worked with Design time repository, run time repository, Target repositories to create and run the mappings.
• Writing UNIX scripts to automate the process of loading flat files on daily basis.
• Involved in the creation of mappings using different transformations.
• ETL design, development and implementation for Program specifications.
• Created and modified process flows according to the flow and also created restart the process flows if a PF fails.
• Creation of process flows to run the mappings and UNIX scripts in parallel and sequential order depending on requirements.
• Automated the entire process of ETL using process flows and shell scripts.
• Wrote Unit Test Plans and Integration test plans.
• Maintenance of development & Production environments.

Environment: Oracle, PL/SQL, UNIX, SQL Server 2000, Oracle Warehouse Builder 9i, SQL*Loader, SQL, PL/SQL, SQL*Plus