SUMMARY:

• Having 5+ years of experience in IT, background in Oracle Data Integration, ETL Design, Analysis, Development, Testing, Implementation and error handling using ODI 11g, 12c
• Experience in Oracle Database Administration on Linux, UNIX and Windows operating systems
• Efficient interpretation of the Business needs to draft transformation rules.
• Experience in ODI 11g/12c
• Experience on dealing with ODI Knowledge Modules like LKM, IKM and CKM.
• Maintenance and management of look up data.
• Implemented data from different Source systems and correct the existing code for better performance.
• Worked closely with the BI team and the Project Management team to gather requirements and generate a unique solution for proper flow and consistency of the data.
• Experience in identifying bugs in existing interfaces, mappings and debugging them.
• Excellent analytical, problem solving, communication and interpersonal skills, with ability to interact with individuals at all levels.
• Experience in Working with Load Plans and Scenarios and numerous all ODI objects.
• Experience in taking regular off - line, online and logical Backups.
• Good exposure in translating business requirements into creation of database objects: tables, indexes and views.
• Provide technical support to application development teams and testing team.
• Experience in creation of database Users, Tablespaces, assigning Quotas, Roles, Privileges and Profile to users.
• Experience in migrating NON-RAC database to RAC database by using RMAN utility.
• Created databases in both RAC & NON-RAC environments, registering the database with SRVCTL (server control utility) in RAC environment.
• Experienced in Cloning and Migration, AWR reports and Patching.

TECHNICAL ACUMEN:

Operating System: Windows Server, Linux

ETL Tools: ODI 11g and 12c

Tools: Tkprof, explain plan, Putty, OEM, VNC Viewer, RMAN, BMC trackit SQL*Loader, Lsnrctl, MOVEIT, ADDM, SQL Developer, SQL*Plus

Database: Oracle 11g and 12c

Language: SQL, PLSQL

PROFESSIONAL EXPERIENCE:

Confidential, Cincinnati, OH

BI/ETL Developer

Responsibilities:

• Gathered, Compiled and synthesized information into a data warehouse for decision making and reporting.
• Supported the development and management of data warehouse comprised of data imported from oracle 11g enterprise, 12c Enterprise, Microsoft SQL server databases and various flat files imported from third party systems.
• Performed data analysis.
• Converted PLSQL procedures into ODI objects as per the business rule usinig Oracle Data Integrator Studio.
• Reviewed business requirements and current data models to develop a framework that supported BI Reporting/ Data warehouse.
• Identified gaps and developed tactical and strategic plans to support implementation of initiatives by working with wide spectrum of key vendors and internal personnel. This incorporated using innovative approaches to better serve the customer as well as improve processes.
• Monitored data warehouse performance and size with oracle DBAs.
• Participated in overnight and weekend support on call for ETL issues that came up and during maintenance windows.
• Migrated legacy jobs into ODI objects as per the business rule.
• Scheduled Scenarios and Loadplans on nightly loads.
• Managed and maintained ETL through Oracle Data Integrator.

Environment: ODI 12c, SQL Developer, Oracle 12c, BMS ticketing system, Moveit tool, Datapipe, Windows and UNIX platform, Putty, PLSQL

Confidential, Albany, NY

ODI Developer

Responsibilities:

• Interacted with clients for appropriate requirement specifications.
• Analyzed the sources, targets, transformed the data, mapped the data and loaded the data into the data.
• Worked with knowledge modules like LKM, IKM, and CKM in ODI to create interfaces, cleanse, Load and transform the Data from Sources to Target.
• Created Master and Work Repository and developed the ODI mappings.
• Created and maintained integration process using ODI and load rules.
• Used ODI Designer for importing tables from database, reverse engineering, to develop projects, and release scenarios.
• Mapped different data sources to the Physical Layer and created the Business Model and Mapping Layer (design of hierarchies, dimensions, and aggregates) by defining appropriate joins, calculations, dimensions and measures in the repository.
• Debugged the mappings using debugger to resolve code issue.
• Used Topology Manager to create database connections, schemas, etc.
• Developed various ODI interfaces/mappings to load data from Flat file & Relational Sources.
• Used Topology Manager to define data servers and physical schemas for source and target databases.
• Generated scenarios and deployed them using ODI Operator for code migration from one environment to another.
• I extracted data from Oracle EBS and integrated this data into the data warehouse using dimensional modelling.
• Worked on data modeling and developed fact queries based on the grain required to fulfill the reporting requirements.
• Good knowledge about Topology, Designer, Operator and Security in Oracle Data Integrator.
• Increased efficiency of data load from source to target by doing performance tuning.
• Used ODI Security manager for managing users and permissions

Environment: ODI 12c, ODI 11.1.1.7, Oracle 12c, SQL Developer, Erwin 7.2

Confidential, Houston, TX

ODI Developer

Responsibilities:

• Used Knowledge modules to achieve client requirements such as connecting to specific technology, extracting data from it, transforming the data, checking it, integrating it, and loading the data in source database.
• Used ODI Designer to develop interfaces (mappings) to load the data from the various sources into dimensions and facts.
• Used ODI Operator for debugging and viewing the execution details of interfaces and packages.
• Created Master and Work Repository to develop the ODI mappings.
• Reverse Engineered Source and Target Data Stores using Reverse Engineering Knowledge Module (RKM).
• Used Topology Manager to create database connection, physical and logical schema in order to achieve the whole infrastructure.
• Debugged the sessions by utilizing the logs of the sessions.
• Analyzed business functionality with the client and the developers.

Environment: ODI 11g, PL/SQL, SQL, SQL Loader, SQL Developer, Windows

Confidential, Conshohocken, PA

Associate DBA

Responsibilities:

• Installation of oracle software and database creation
• Ensured that archiving, storage, backup and recovery procedures are functioning correctly.
• Installation, creation and support of Oracle 9i and 10g database in Production Environments.
• Involved in DBA activities, supporting Production Environments
• Allocation and Reorganization of tablespaces and Monitor the table spaces growth.
• Managing and maintaining hot, cold and RMAN backups for disaster recovery and making sure the mean time to recover as low as possible.
• Creation of Database LINKS, Materialized Views and Performed Database Cloning from Production to Test environment.
• Monitoring and optimizing the performance of the Database through Stats pack /AWR.
• Scheduled database backups, diagnosed and resolved backup failures.
• Adding space to the data files to accommodate growth of tablespaces.
• Worked as a team with other DBAs to provide support to clients and maintain multiple databases
• Supported high-availability databases and applications in a 24x7 environment
• Expert knowledge in Performance Tuning, Troubleshooting Database, Managing, Monitoring RMAN Backups, Configuration of RMAN Backup Policy

Environment: Oracle 11g, Windows 2012, HP/Unix, Tkprof, explain plan, Putty, OEM, VNC Viewer, SQL*PLUS, RMAN