PROFESSIONAL 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, Manufacturing, 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 TEMPeffectively with all levels of management, and ability to share noledge 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 has sound noledge in Oracle Architecture.

TECHNICAL SKILLS:

ETL/ELT: ODI 12C/11g/10g, OWB 11g/10g

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

REPORTING: OBIEE 11/10x, Tableau 8.2

Data Modeling: CA Erwin r8/7.3, Visio

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

DB Tools: SQL Developer, WinSQL, JSQL, TOAD, Microsoft SQL Studio

Version Management: ClearCase, SCM, Rational Team Concert

PROFESSIONAL EXPERIENCE

Confidential, Columbus, IN

ODI Consultant

Responsibility:

• Analyzing and designing mapping with requirement documents.
• Installing ODI 11G on standalone systems, remote desktop, and server on Linux box.
• Cloning work and master repository.
• Purging logs to shrink repository size for upgrading.
• Checking repository consistency with Oracle RCC.
• Upgrading ODI 10.1.3.5 to 11.1.1.7 on Linux box using UA utility.
• Configured ODI to integrate with third-party LDAP autantication.
• Setup and maintain multiple instances and repositories for multi-user environment.
• Configured ODI physical and logical schema with Context.
• Deploy and configure J2EE and Standalone for load balancing and scheduling ODI jobs.
• Monitoring jobs through ODI Console.
• Established standards, guidelines, and practices for DW development.
• Extensively worked on loading enterprise level data like Accounts, Assets, Contacts, and Products from legacy to Oracle System.
• Extracted data from various sources Legacy and flat files including XML and loaded into target Oracle system.
• Created OdiInvokeWebService for SOA with BAMUtiltyService/BAMMonitoringWebService (WSDL) for Audit framework.
• Created OdiInvokeWebService for SOA with AIA/BPELProcess (WSDL) for Error handling.
• Configured OdiWaitForData for Event Detection to poll data from source table.
• Code migration between environments and synchronizing repositories.
• Calling API to fetch teh data from source system.
• Polling core tables to fetch teh data from source system.
• Created temporary and permanent data store interfaces according to teh requirement
• Created load plans, packages, procedures, variables, and generated scenarios.
• 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 teh work progress.
• Documented ETL test plans, test cases, test scripts, and validations based on design specifications for unit testing, system testing, functional testing, regression testing, prepared test data for testing, and error handling.
• Customizing noledge modules whenever it’s needed.

Environments: ODI 10.1.3.5/11.1.1.7, Oracle 11g, Oracle ERP application, Oracle RAC, SQL Developer 3.2, RTC, Clearcase, BMC Service Request Management 8.1, Linux Red Hat 5.8

Confidential, Rochester, NY

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 Paychex, IKM Oracle Control Append Paychex, 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 on a standalone system.
• Upgraded from 11.1.1.6 to 12.1.2.0 using oracle upgrade utility.
• Worked on customizing noledge modules according to teh project requirement.
• Scheduled CDC process using Oracle Gloden Gate and tested journalized interfaces.
• Created temporary and permanent data store interfaces according to teh requirement
• Created load plans, packages, procedures, variables, and generated scenarios.
• Scheduling jobs using Tidal scheduler.
• Created different types of Customized Reports (Drilldown, Aggregation, Levels) to meet business requirements. Generated various Analytics Reports like Formulary Report, Union Report and Direct Sales Report using global and local filters.
• Developed custom reports/Ad-hoc queries using Answers and assigned them to application specific dashboards.
• Created proper documentation to describe program development, logic, coding, testing, changes and corrections.
• Worked on CR and SR tickets to solve teh production and change request issues.
• Created dashboards, worksheets using Tableau 8.2
• Responsible for migrating teh web catalog and RPD from DEV, SIT, UAT and PROD environments.
• 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 teh work progress.
• Used SQL Developer and TOAD tool to unit test teh code.

Environments: ODI 11.1.1.6/1.7, ODI 12C, OBIEE 11.1.1.6.5, Tableau 8.2, Tidal, Oracle 10g/11g, SQL Server, Netezza, SQL Developer, TOAD, IBM Rational Clearcase, SCM, RTC, Linux

Confidential, MA

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 noledge modules according to teh project requirement.
• Used hints and joins for handling performance of teh job.
• Worked on upgrading to ODI 11.1.1.6.
• Moved repositories from ODI 10.1.3.5 to ODI 11.1.1.6.
• Worked on teh existing upgrading issues by logging teh 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, ODI 10.1.3.6, Oracle 10g, DB2, SQL Server, Netezza, WinSQL 9.0, Windows, Linux, Putty.

Confidential, Rockleigh, NJ

ODI Consultant

Responsibilities:

• Gathered Business requirement, coordinate with end user and offshore Mexico team.
• Translated business requirements into technical specifications to build teh 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 teh 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 teh interfaces, defining teh data stores, interfaces and packages, utilized teh ODI Knowledge Modules (Reverse Engineering, Loading, Check, and Integration) to create interfaces to cleanse, Load, and transform teh 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 teh 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.

Environments: 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, NY

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 teh ETL strategy to populate teh 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 teh 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 teh 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 teh data quality analysis process and to re-structure teh data for reporting purposes.
• Created type 2 slowing changing dimensions mappings by comparing grain of teh incoming to teh existing rows.
• Created mappings for 3 and 4 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 TEMPthan 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 teh specs, loaded data in target table has teh 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

Environments: OWB 11.1.2.4, 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 teh data into Oracle database.
• Worked extensively on LKM, IKM, and CKM for running teh interfaces and also some KM’s has been customized for teh 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 teh noledge 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.

Environments: ODI 10.1.3.5, OWB 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 teh 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 teh mappings.
• 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 teh data quality analysis process and to re-structure teh data for reporting purposes.
• Created type 2 slowing changing dimensions mappings by comparing grain of teh incoming to teh existing rows.
• Created mappings for 3 types of loads with proper renaming columns, validating dates and times columns, and setting indicator values.
• Writing UNIX scripts to automate teh process of loading flat files on daily basis.
• Involved in teh creation of mappings using different transformations.
• ETL design, development and implementation for Program specifications.
• Created and modified process flows according to teh flow and also created restart teh process flows if a PF fails.
• Creation of process flows to run teh mappings in parallel and sequential order depending on requirements.
• Automated teh entire process of ETL using process flows and shell scripts.
• Wrote Unit Test Plans and Integration test plans.
• Maintenance of development & Production environments.

Environments: Oracle 10g, PL/SQL, UNIX, OWB10g, SQL*Loader, SQL, PL/SQL, SQL*Plus