Candidates About

 

 

 

CAREER HISTORY

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.

 

 

 

EDUCATION:

•          B.S at State University Of New York, Albany, NY

 

 

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

 

•          Permanent US Resident

•          Willing to relocate anywhere

 

Professional Experience:

IWireless (Kroger Company). Cincinnati OH                                                         Sep 2016 to present

 

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

 

 

 

MAXIMUS Inc. Albany NY                                                                          Oct 2014 to Aug 2016           

 

MAXIMUS has partnered with state, federal and local governments to provide critical health and human service programs to a diverse array of communities. It has approximately 16,000 employees and is dedicated to providing innovative programs that improve the quality of life around the globe.

 

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

 

 

 

Macy Inc. Houston, TX                                                                                  Sep 2013 – Sep 2014  

 

Macy's provides services through Internet under two brand names: Macy's and Bloomingdale's sells wide range of merchandise, including men's, women's and children's apparel and accessories, cosmetics, home furnishings and other consumer goods. It also operates seven Bloomingdale's outlet stores. It provides services through its subsidiaries which include Macy's Systems and Technology, Inc. and Macy's Merchandising Group, Inc. The company's Macy's Systems and Technology, Inc. subsidiary provides operational electronic data processing and management information services to all of the Company's operations.    

 

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

 

 

David’s Bridal. Conshohocken, PA                                                       Sep 2012 – Aug 2013

As the largest bridal retailer in the world, David's Bridal has 300+ stores in the United States, Canada, Puerto Rico and United Kingdom with beautiful boutique-like store environments. Corporate headquarters located in Conshohocken, PA where over 200 individuals work together to support the 8,000 employees working in our stores. The corporate office hires people with educational and/or work experience in accounting, accounts payable, administration, sales auditing, marketing, buying/merchandising, information systems, manufacturing, distribution/warehouse operations, training, and human resources.

 

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