Owb (Oracle Warehouse Builder). Have worked on apex (Oracle Application Express). Have worked on unix

Rahul Gupta Email :- [e-mail] Contact Number:- [phone]
Experience Summary

• 
  Currently working as a Lead Enginner in Sopra Group.
  

• 
  Result oriented professional with 5 yrs 6 months of experience in Oracle.
  

• 
  Have worked extensively on Functions, Procedures, Triggers etc.
  

• 
  Good knowledge of Performance Tuning techniques.
  

• 
  Database optimization using AWR (Automatic Workload Repository) and ADDM (Automatic Database Diagnostic Monitor) utilities.
  

• 
  Sound understanding of ETL concepts and Data Migration methodology.
  

• 
  Good exposure on TOAD,SQLPLUS,PL/SQL DEVELOPER.
  

• 
  Hands on experience on Oracle ETL Tool OWB (Oracle Warehouse Builder).
  

• 
  Have worked on APEX (Oracle Application Express).
  

• 
  Have worked on UNIX and Windows platforms.
  

• 
  Strong skills include SQL,PL/SQL.
  

Educational Qualifications

Qualification	College/University	Year of Passing	Percentage
PGDBA (Finance)	Symbiosis Center for Distance Learning	2012	65%
Bachelor Of Technology (Computer Science)	Krishna Institute of Engineering and Technology	2008	70.64
XII	Delhi Public School Ghaziabad (CBSE Board)	2004	78.6
X	Delhi Public School Ghaziabad (CBSE Board)	2002	79

Certifications

Title	Acquired On
OCP - Oracle PL/SQL Developer Certified Professional.	05-Jun-2011
OCA - Oracle PL/SQL Developer Certified Associate.	05-Apr-2011
OCA - Oracle Database 11g Administrator Certified Associate.	19-Feb-2011

Technical Summary

Category	Skills
Languages	PL/SQL, SQL
Databases	Oracle 11gR2, MYSQL
Tools	Toad, SQL*Plus, Apex 4.2 (Oracle Application Express), OWB (Oracle Warehouse Builder)
Operating Systems	UNIX/AIX/Linux, Windows

Work Summary

Organization	Time Period	Designation
Tata Consultancy Services	21^st Nov 2008 – 03^rd Oct 2011	Systems Engineer
Sopra Group Pvt Ltd	07^th Oct 2011 – till present	Senior Consultant

Project Summary

Sopra Group Pvt Ltd (Noida - India)
Project: B2Bi-Axway

Client: Axway

Period: 07^th Oct’11 till Present

Tools Used : B2Bi, Mapping Services, Sentinel, Toad, APEX

Role: Senior Consultant
PROJECT DETAILS
Axway products deals in logistics/financial domain in France. Electronic Data Interchange (EDI) is used as a protocol in various bank data exchange activities.
ROLES AND RESPONSIBILITIES

• 
  Worked on Mapping Services, an Axway product to map EDI formats.
  
• 
  Worked on Oracle Application Express (APEX) , an Oracle web development tool.
  
• 
  Implemented functions, procedures and triggers for Oracle applications.
  
• 
  Have worked on Oracle instance creation and setting up a Database in Linux.
  
• 
  Worked on SQL Analytical functions.
  

Tata Consultancy Services (Kolkata - India)
Project #1 : ENTERPRISE ORACLE PROGRAM

Client : THE HARTFORD

Period : Oct ’10 – Oct ‘11

Tools Used : Toad, SQL Plus, UNIX

Role : Developer

PROJECT DETAILS:

• 
  The Hartford Group is a leading provider of life insurance, group and employee benefits, automobile and homeowners insurance and business insurance - as well as investment products, annuities, mutual funds, and college savings plans.
  

• 
  Purpose of this project is to Upgrade/Migrate all the databases to Oracle 11gR2 version and the platform to the Linux environment.
  

ROLES AND RESPONSIBILITIES:
As a part of the Enterprise Oracle Program Team, my responsibility was to provide the following core support functions.

• 
  Oracle Behaviourial changes in 11gR2 – The aim is to examine the behaviourial changes that may happen for some Oracle functions from lower Oracle versions to Oracle 11gR2.
  

• 
  Performance Tuning – Involved in optimizing the SQL queries to increase performance gains.
  

• 
  Estimation Metrics - The aim is to quantify an application’s complexity level which is currently running on Oracle 9i/10g databases. To achieve this, different Oracle centric attributes were taken as baseline like objects,hints,queries etc.
  

• 
  Functions/Procedures – Worked on writing code for functions, procedures and triggers.
  

Project #2 : DILIGENTA TRANSFORMATION PROGRAMME

Client : PEARL GROUP LIMITED

Period : Jan ‘09 – Oct ‘10

Tools Used : OWB(Oracle Warehouse Builder), PL/SQL Developer,UNIX,
OEM(Oracle Enterprise Manager)

Role : Developer
PROJECT DETAILS:

• 
  Purpose of this project was to transform the business of PGL by migrating and consolidating applications on a higher capability platform such that they provide long term sustainable price advantage and support future growth ambitions of the PGL Group.
  

• 
  In TCS BANCS Insurance, there are 4 stages through which the data is passed to reach the target database from the source system.To achieve this OWB tool was implemented.
  

• 
  Oracle Warehouse Builder is a comprehensive tool for all aspects of data management.Oracle Warehouse Builder enables you to create data warehouses, migrate data from legacy systems, consolidate data from dissimilar data sources, clean and transform data to provide quality information.
  

ROLES AND RESPONSIBILITIES:

• 
  Data migration from Legacy system to Oracle.
  
• 
  Worked on Tuning the SQL queries.
  
• 
  Involved in coding using OWB Tool.
  
• 
  Worked on SQL Analytical functions.
  
• 
  Environment setup and deployments in OWB.
  
• 
  Implemented Functions/Procedures, Triggers, Indexes.
  

Personal Details

Contact Address : 3/8 Sector-5, Rajender Nagar Sahibabad, Ghaziabad, (U.P)

Date of Birth : May 9th, 1987

Father’s Name: : Mr. Ramesh Gupta

Mother’s Name: : Mrs. Renu Gupta

Marital Status: : Married

Nationality: : Indian

US work status : Valid Business Visa (B1/B2)

Passport Details : F4816384 (29-sep-2015)

Contact No : [phone]

Linguistic Proficiency : Hindi , English & French

Page of 4