Summary:

• BI professional with excellent experience in Oracle ODI, OBIEE, PL/SQL and extensive back ground in designing ETL solutions for data extraction and data warehouse load at an enterprise level.
• Experience with Software development life cycle SDLC process performing detailed data analysis, requirement gathering, documenting requirements, coding and unit testing, integration and system integrating
• Strong experience in ELT/ETL Extraction, Transformation and Loading process using Oracle Data Integrator
• Good knowledge in Data Modeling using Star and Snowflake Schemas, ER Model, De-Normalization, Dimensional Data Modeling, Dim Hierarchies, Dim Extensions, Physical Logical Data Modeling
• Extensively used ODI Oracle Data Integrator to perform ELT from different sources such as RDBMS, flat files, XML and complex ERP systems into a data warehouse
• hands on experience in developing Procedures, Packages, Interfaces and Workflows in ODI
• Good experience in Installing and Configuring ODI environment to perform ELTs
• Good Knowledge on reporting tools such as OBIEE, Oracle Discoverer.
• Excellent knowledge on RDBMS concepts and various Relational Databases like Oracle 11g/10g/9i/8i, SQL Server 2005/2008 and MS Access 2003/2007.
• Extensive experience in migration of data from legacy systems and also involved in Data Warehouse Development and Data warehouse Life Cycle development.
• Good knowledge on Oracle functions, SQL query tuning using EXPLAIN PLAN, Hints and SQL Plus Auto trace report for query optimization
• Proficient in Oracle tools and utilities for Extracting Transforming and Loading ETL such as TOAD, SQL Loader, SQL Developer.
• Hands on experience in advanced pl/sql concepts like Dynamic SQL, Ref Cursors, PL/SQL tables, PL/SQL Collections, VARRAYS etc.
• Experience in converting business user requirements into process, functional and technical design.

• Excellent technical abilities and possess strong oral and written communication skills, analytical and interpersonal skills with good business acumen, effective communicator and a team player.
• Experience in working with Business Users, Controllers, Directors, Senior Managers, Executive and Project Stake Holders

Technical Skills:

• ETL Tools: Oracle Data Integrator 11g/10g, Synopsis, Informatica 9.1
• Operating Systems: Windows, UNIX
• Languages/Middleware: SQL, MySQL, PL/SQL, Java, UNIX Shell Script.
• RDBMS and DB Appliance: Oracle 8i/9i/10g/11g, MS SQL Server 2008, DB2 V6.0, DB2 V7.1
• Reporting Tools: OBIEE 11g, Oracle BI Publisher, Oracle BI Applications

Tools : TOAD, SQL ASSISTANT, SQL Developer, Embarcadero Rapid SQL, Microsoft Visual Source Safe 6.0, WinRunner, Test Director, Erwin 8.0, Erwin 7.x, ER/Studio 7.0, SQL Plus, SQL Loader

Professional Experience:

Confidential

ODI/ETL Technical lead

Responsibilities:

• The goal of the project is to implement and customize Oracle ERP product, Retail Merchandising Analytics ORMA to cater to the BI and Reporting needs for JC Penny.
• RMA is the Analytics/Reporting component from Oracle Retail which utilizes Oracle Business Intelligence suite for reporting and Oracle Data Integrator as the out of the box ETL tool Customized out of the box code to implement financial data merge from EBS and Retail data from RMS Oracle Retail Merchandising System into ORMA.
• Developed ODI ETL jobs to extract and load data from several legacy applications, Oracle retail planning application, RPAS and load into ORMA.
• Implemented performance tuning features such as multi-threading, Oracle parallel dml Range and hash partitioning features to handle huge data volumes.
• Developed and customized new knowledge modules as per the project requirement.
• Lead offshore development team, provided inputs, and shared best practices as and when required.
• Implemented agile practices such as daily standups/status calls to keep a track on the project plan and met the deliverables and project milestones.
• Prepared ITDDs technical design documents , mapping docs, and deployment guides and conducted code review sessions with the client.
• Developed ETL shell scripts for daily batch schedule.
• Worked closely with the OBIEE reporting team.

Environment: ODI 11.1.6.3, ORMA 13.3, Linux 6.3 x86-64, Toad 10.6, Sql developer.

Confidential

ETL/ELT Technical Architect

Responsibilities:

• Extensively used ODI designer and ODI Studio to create and manipulate source data stores, target data stores, packages, interfaces, procedures, variables.
• Analyzed the Explain Plan to improve the performance of long running queries.
• Used Optimizer hints in ODI for better performance and accommodate large incremental loads.
• Unit testing and documentation the same.
• Redesigned the existing ODI/ODQ 10g architecture to 11g architecture across all environments which include Dev, Qa, Uat and Production on both unix and windows platforms.
• Upgraded 10g repositories and performed extensive testing in UAT to ensure successful migration of code from 10g to 11g
• Created extensive test plan and a cutover plan with strict timelines.
• Worked with different teams such as infrastructure, firewall and dba teams as and when required during the upgrade process.
• Created upgrade documents with all the details and maintained logs for future reference
• Worked closely with other in house ERP teams such as salesforce and Hyperion to ensure that their data requirements are fulfilled.
• Created ODI interfaces for loading the data from source to Data Warehouse
• Worked closely with BI and Date warehouse reporting team.
• Lead offshore development team, assigned tasks and provided KT

Environment ODI 11.1.1.7, ODI 10.1.3.6, RHEL 5.7, Windows Server 2003, XML, PL/SQL, SQL Loader, Flat files, Oracle 11g, MS SQL Server 2008/2005

Confidential

ETL/ELT-ODI Lead/Developer

Responsibilities:

• Installed and Configured ODI agent, repositories. Created projects, models, sources, targets, packages, Knowledge Modules, Interfaces, Scenarios, filters, conditions, metadata.
• Used Oracle Data Integrator ODI 11.1.1.6 to extract data from multiple sources systems such as RDBMS, flat files CSVs , XML and ERP systems
• Extensively used ODI to create xml files xml as target and flat files for data integration.
• Created interfaces, packages and workflows to extract and load data between existing applications and oracle data warehouse database
• Implemented knowledge modules such as LKM, IKM control append and IKM Incremental update, RKM.
• Implemented SCD type 2 scenarios and change data capture.
• Scheduled package and scenarios, application and system Deployment.
• Created PL/ SQL procedures and Packages for loading data in various schemas
• Responsible for tuning and debugging of ODI objects.
• Created multiple packages with parallel and sequential flows based on the requirement.
• Developed and maintained projects and interfaces in heterogeneous environment.

Created ODI Packages, Jobs of various complexities and automated process data flow

• Closely worked with OBIEE report developers and end users. Good working knowledge on OBIEE report development.
• Supported client during development, testing phase and production support and provided hands on training to the developers.

Environment ODI 11.1.1.6, OBIEE 11.1.1.6, Windows Server 2008, XML, PL/SQL, SQL Loader, Flat files, Oracle 11g, MS SQL Server 2008/2005

Confidential

ETL/ELT/ODI Developer

Responsibilities:

• Defined ODI ETL framework and installed, configured and administered various components of Oracle Data Integrator and customized ODI Knowledge Modules as per client's need.
• Actively involved and worked with data warehouse design and implementation team.
• Prepared technical specifications, mapping documents and test specifications as per business requirements.
• Consolidated data from different systems to load Client's data warehouse using ODI interfaces and procedures.
• Develop packages for the ODI objects and scheduled them as scenarios.
• Implemented change data capture using ODI Journalizing Knowledge Module on the source data.
• Fine tuned the applications for performance and Generated batch feeds for analytics.
• Developed ODI packages for creating workflows and scheduled them as scenarios.
• Developed Oracle Data Integrator interfaces and procedures to extract data from Oracle Applications, SQL Server and flat files to load Terex Planning warehouse.
• Installed and Configured ODI 11g - Topology/Environment to integrate data from Oracle, Microsoft SQL Server, Oracle ERP and flat files.
• Customized out of the box Knowledge Modules as needed.

Environment ODI 11.1.1.5, PL/SQL, SQL Loader, Toad, Erwin 7.x, Flat files, Oracle 11g, MS SQL Server 2008/2005, OBIEE 11g

Confidential

ETL/ELT/ODI Developer

Enterprise Data warehouse Migration project

Responsibilities:

• As per the SOX compliance created six work repositories for the project.
• Creating Data servers, Model folders and project folders.
• Extensively used ODI to develop and deploy integration packages and workflows.

ODI Designer:

• ODI packages for initial load and incremental load
• CDC using ODI JKM for the DB2 source data stores.
• Prepared ODI objects Project, Models for deployment by using import export method
• Implemented JKM for CDC set up.
• Modified IKM and LKM to populate additional FLAG columns in the target

ODI Topology Manager:

• Created Data Servers to Oracle and DB2 databases
• Created Physical and logical schemas
• Created agents to run and schedule ODI jobs
• Created Work Repository
• Created contexts, physical and logical schemas as per the requirement

ODI Operator:

• Monitor ODI jobs using operator
• Troubleshoot issues using the logs for Session, Step and Task level
• Work Repository tables

Cleanup of log tables

• Generated reconciliation and duplication reports
• Wrote SQL's for the reconciliation of the source--target data.
• Tuning and error handling in the ETL process.
• Worked closely with the Report Development team OBIEE .
• Developed Database Objects, Triggers, stored procedures, Functions, Packages in Oracle.
• Created Oracle Tables, Indexes, Views, Materialized views, Synonyms, database links.
• Developed Oracle based SQL and PL/SQL programs for the creation of DW/ETL Process, ad hoc queries/reports, including requirements gathering, design and testing.
• Wrote SQL queries Sub queries and Join conditions , PL/SQL programming and Query Level Performance tuning.
• Worked on Collections, Bulk Binds Bulk Collects and Table Partitioning.
• Customized the IKM incremental update/IKM Control append knowledge modules for making the entry in control tables to track the daily load from source to target. Created complex mappings and packages, administration tasks, support and maintenance
• Created jobs to load the data on hourly and daily using ODI agent
• Created complex interfaces and packages and scenarios.
• Created ODI packages, scenarios using interfaces, variables, procedure
• Used ODI commands like ODIFile Move, odiFileAppend, odiFilecopy etc.
• Optimized the knowledge modules to improve the functionality of the process.
• Code promotion between the environments.
• Implemented the simple change data capture to populate the latest data from the source.
• Support and Maintenance of the production jobs.

Environment: Oracle data integrator 10.1.3.5/11.1.1.5.0 Enterprise Edition, Oracle 10g,PlSql , windows XP, Dimensional model, RHEL AS 4.8 64-bit.

Confidential

Oracle Database/ ETL Developer

Responsibilities:

• Developed utilities for Mass updates program for HR entities such as Salary, Elements, Jobs, Grades and various HR entities
• Used ODI to extract data from Oracle to various target systems. Created interfaces and scheduled jobs for ODI extracts.
• Load data from flat files to oracle using ODI
• Created missing members interface to support month end process
• Setup ODI work repository and agents for production.
• Supported client during testing phase and production support.
• Manage and build ODI repositories
• Create workflow in ODI designer.
• Created and maintained projects and interfaces in heterogeneous environment.
• Used different ODI knowledge modules.
• Design and configure the initial 'folder' structure /Data Models for selected environments.
• Import metadata from selected source systems into the ODI repository.
• Provided suggestions and technical guidance to client for process improvement.
• Worked on back-to-back process that involved creation of requisitions, internal sales order, receiving and processing orders.

Environment: Oracle data integrator 10.1.3.5, oracle 10g, Pl/Sql

Confidential

INFORMATICA /ODI SUNOPSIS DEVELOPER

Responsibilities:

• Developed mapping specifications based on the business requirement analysis
• Extensively used Erwin to generate logical and physical data models
• Developed mappings as per business requirements
• Created mappings to load data from source to staging, and staging to ODS Operational Data Stores
• Designed and implemented Slowly Changing Dimensions-Type II in various mappings.

Environment: Oracle10g/9i,ODI Sunopsis v3 , Informatica Power Center 7.1/6.2, Workflow Manager, Autosys, PL/SQL Developer, Erwin 4.0, Business Objects 6.5, Unix Shell Scripts, Windows 2000, Sun Solaris.

Confidential

ETL/Oracle Developer

Responsibilities:

• Involved with a team in understanding the present system to come up with guidelines to improve the performance of the system by identifying the root causes and coming up with a solution.
• Creation of Tables, Indexes, Clusters, Rollback Segments, Database Triggers, Functions and new Users using SQL and PL/SQL scripts
• Worked on PL/SQL procedures, functions, packages, PL/SQL Cartridges and SQL Tuning.
• Performed maintenance of Shell scripts on UNIX server for data feeds for our Data Marts to the front-end reports.
• Planning and testing of Backup and recovery procedures of Online and offline Backups, Logical Backups using Export/Import utilities.
• Involved in certain responsibilities of DBA like creating triggers, new tables, managing, Backup and recovery, and monitoring of database 24/7.
• Support of daily operations including job monitoring and troubleshooting of the 24x7 production.
• Worked on HP service desk tool to monitor issues and provide the resolution to the end user Generated server side PL/SQL scripts for data manipulation, validation and created various snapshots and materialized views for remote instances.
• Worked extensively on advanced PL/SQL concepts like Dynamic SQL's, Varrays, and Bulk binding to develop PL/SQL scripts.
• Designed and developed ETL Interfaces using PL/SQL Stored Procedures, UTL FILE, External Tables, and Oracle Utilities for the Staging Area and Target Database.

.

Environment: Oracle 9i, Toad, Pl/SQL developer, UNIX, Windows 2000/XP, Toad, Sql Loader.