PROFILE SUMMARY

Sumeet is an information technology practitioner having around nineteen

years of experience in technologies including Oracle Apps DBA/Core Oracle

DBA/Unix Shell Scripting. He has got vast experience in Oracle Apps

Implementations, Upgrades, Production Support, Platform Migration projects

. Expertise in understanding and analyzing solutions in the areas of Oracle

Apps DBA, Oracle Core DBA . He possess a clear understanding of the IT

industry, technology trends with the distinction of instituting quality

practices to enhance performance at the lowest overall cost. He also has

strong analytical, problem solving & organizational abilities. Having

worked for companies like IBM, Oracle - India, Deloitte Consulting - the

incumbent has ample exposure to various clients across platforms across

geographies .

EXPERIENCE SYNOPSIS

o Worked extensively on the design, development and support of database

applications using formal software engineering and project management

methodologies.

o Involved in all the stages of Practice Development using onsite-offshore

model.

o Adept at mapping client's requirements, custom designing solutions &

troubleshooting for complex Oracle Apps DBA & Core DBA related problems.

o Possesses a clear understanding of the IT industry, technology trends

with the distinction of instituting quality practices to enhance

performance at the lowest overall cost.

o An effective communicator with excellent relationship building &

interpersonal skills. Strong analytical, problem solving &

organizational abilities. Possess a flexible & detail oriented attitude.

ACADEMIC QUALIFICATION

Degree Institute

MSc(Operations Research) Delhi University

SKILLS SUMMARY

Hardware Paltform Sun / HP / IBM / Compaq /Tata Elxsi - SGI

Machines.

Operating Systems Solaris 2.5/2.6/8,9,19

HP-UX(10.2/11/11i),Linux,Win-NT,DOS

Software tools Oracle Apps DBA (10.7/11/11i/R12) on both Unix

and NT

Oracle DBA (7/8.8i,9i/10g,11g), UNIX shell

scripting .

Application Oracle Applications (ERP) -- >

knowledge 10.7/11.0.X/11i/R12.

MAJOR PROJECTS

CURRENT PROJECT : Globacom, Lagos Nigeria

Working as Lead Oracle / Oracle Apps DBA - handling support for all BSCS,

CRM, ERP databases for Globacom - Nigeria in 24 X 7 mode with a team of 7

DBAs .

Others:

1. Oracle APPS DBA Support

Project Description: Worked as Associate Practice Lead for Oracle Apps DBA

/ Oracle DBA Support for US based clients from the offshore Support Centre

of Titan Global Solutions based out of Pune, India .

Client Multiple clients based in US

Duration May 2012 - Feb 2013 .

Environment Linux, HP-UX, Solaris Servers Oracle

Apps/Peoplesoft/ Custom Applications

Role Associate Practice Lead

Responsibilities: Worked as Lead for providing DBA Support from

the offshore office for 10 clients based out of

the US mainly on Oracle Apps R11.5.10.2 / R12 &

some custom environments .

Organized the team as required to stabilize

support Operations and reduce the number of

incidents reported .

Improved the communication process with the

onsite team .

2. Oracle / Apps DBA Support - Tricore Solutions . (Gurgaon)

Project Description: Worked as Senior Principal Consultant for Oracle Apps

DBA / Oracle DBA Support for US based clients from the offshore Support

Centre of Tricore Solutions based out of Gurgaon, India .

Client Multiple clients based in US

Duration Aug 2011 - Apr 2012 .

Environment Linux, HP-UX, Solaris Servers Oracle Apps Env.

Role Sr. Principal Consultant .

Responsibilities: Worked as Lead for providing DBA Support from

the offshore office for 17 clients based out of

the US mainly on Oracle Apps R11.5.10.2 / R12

environments .

Worked on Performance Tuning assignments and

mentored the team for the same .

Was supposed to start support for a European

client - Direct to India (Support) without any

onsite mediator but project did not matieralize

.

3. CRM Apps DBA Support

Project Description: Oracle Apps DBA Support across all installations of

Oracle Apps Environments in India from the centralized data centre in Poona

.

Client Vodafone Essar - India (Pune) via IBM - INDIA.

Duration September 2009- Feb 2011

Environment IBM AIX Servers, Oracle Apps 11.5.9 / Custom

Applications

Role Lead Apps DBA

Responsibilities: Worked as Lead for Data purging in all CRM

Environments since data growth had been a major

issue since the past 5 years and had to be taken

up on urgent basis since this had been

highlighted as a major concern by the client .

Worked on developing Custom scripts for purging

CRM data and scheduling seeded concurrent

requests for purging seeded AOL data

(Workflow,Concurrent Manager/Request, Login

details) .

Worked on streamlining Apps DBA operations and

developing the practice after complete

transition of Apps DBA support to to IBM From

Oracle India Support .

4. Production Support (Oracle India - Bangalore).

Project Description:

Client 1800 Flowers,VALE, Boart LongYear, P&G

Duration July 2007 - August 2009

Environment Intel Servers, Sun Sparc Servers, Oracle Apps

11i/R-12 (12.0.6) / Custom Applications.

Role Senior Principal Consultant . Worked as Lead

Oracle Apps DBA for 3 projects .

Responsibilities: Implementations and production Apps DBA support

leading a team of 8 Apps DBAs .

Involved in technical work as well as client

handling, team management and working in sync

with pre-sales team for new projects etc .

5. Oracle Apps DBA support (Employer : Tricore Solutions - Delhi) .

Project Description: Oracle Apps DBA support to Multiple clients based out

of the US . The clients have outsourced all Apps DBA support related

activities to Tricore . Support includes - both Apps DBA and CORE DBA

support for multiple installations across clients .

Client Siemens,Orvis,NaviMedix,American

BioPhysics,National Dentex, Granite Telecom

Duration March 2006 - July 2007

Environment Oracle Apps 11.5.7,11.5.8,11.5.9 and 11.5.10.2,

Intel Servers, HP-UX servers . and other

Custom applications .

Role Project Lead Oracle Apps DBA

Responsibilities: Was responsible for 2 complete upgrades (end to

end ) from 11.5.5 to 11.5.10.2 and 11.5.8 to

11.5.10.2 (with 9i RAC) .

Scope of support includes day to day DBA

support with production issues,

cloning,patching, TAR follow-ups, client

calls apart from long term projects like

Application and DB upgrades .

6. Apps 11.5.8/11.5.9 for GE Commercial Finance .

Project Description: Oracle Apps DBA support to GE Commercial Finance based

out of US. The client has outsourced its support to Birlasoft. DBA support

includes - both Apps DBA support and CORE DBA support to Oracle Apps

Installations and other Custom Applications . There are more than 300

databases for which the support is being provided by our offshore - onsite

Model . Offshore Team consists of 8 Apps DBAs and 4 Apps DBAs are onsite .

Between the 2 teams 24 X 7 support is being provided to all Oracle Apps /

Oracle Installations of GE Commercial Finance and GE - Access clients .

Client GE Commercial Finance (USA)

Duration October 2005 - March 2006

Environment Sun Solaris Servers, Oracle Apps 11.5.9/11.5.8

and other custom applications.

Role Offshore Apps DBA (Technical Leader)

Responsibilities: Oracle Apps DBA Lead (technical) . Involved in

providing 24 X 7 Apps DBA support leading a

team of 10 DBAs offshore and 2 DBAs in US .

7. Offshore Apps DBA support for Apps 11.5.9 & other custom applications

for Proquest-USA (Employer : IBM India - Calcutta) .

Project Description: Oracle Apps DBA support to Proquest client based out

of US. The client has outsourced its support

To IBM . DBA support includes - both Apps DBA support and CORE DBA support

to Oracle Apps Installations and other Custom Applications .

Client Proquest (Ann Arbor - MI USA)

Duration February 2005 - October 2005

Environment Sun Solaris Servers, Oracle Apps 11.5.9 and

other custom applications.

Role Lead Oracle Apps DBA

Responsibilities: Involved in Production Apps & Core DBA support

(offshore) for Proquest (USA) .

8. Offshore Apps DBA support for Apps 11.5.9 Implementation - HACH USA .

(Employer : Zensar India - Pune)

Project Description: Offshore Oracle Apps DBA Support to HACH

implementation team in US implementing Oracle Apps 11.5.9 with

Financials,CRM,SCM . The DBA support is being handled from India for all

this implementation - activities included Installation,Patching, Cloning,Tar followup, Olite implementation, Metric server implementation .

Client HACH chain of stores - DANAHER group USA

Duration October 2004 - January 2005

Environment HP Machines (RP-3440/7420), Oracle Apps 11.5.9

.

Role Oracle Apps DBA

Responsibilities: Hands on Installation,Cloning,Patching,env

creation, tar followup as per requirement from

Implementation Team's specifications .

Coordinating with US Hosting team for the H/W

configuration .

Mentoring junior Hach US DBA .

Performing routine backups and working with

applications team on tools configuration like

Logical Apps,Olite etc .

9. Offshore Apps DBA Support (Employer : Corio India) .

Project Description: Offshore Oracle Apps DBA Support to 14 clients on

Oracle Apps - major amongst them listed above from Corio Offshore India

Centre . All clients were based in the USA - Production support was

provided from India for all these clients - activities included

Cloning,Upgrades,Patching, Tar followup, Code Migrations and Performance

Monitoring .

Client IngersollRand-US,Toshiba-US,ASRC,XO Comm,SU

Duration October 2003 - April 2004

Environment Sun Machines, Oracle Apps 11i / 11.0.3 .

Role Senior Oracle Apps DBA

Responsibilities: Hands on Cloning,Patching,Performance

Monitoring across all clients as per

requirement .

Coordinating with US Hosting team for the

different tasks being handled .

Guiding Juniors in the team on Apps DBA related

issues . Giving KT to Non ERP DBAs

Performing flip overs for new clients from old

ASP to Corio Data Centres .

10 . Offshore Apps DBA Support (Employer : Deloitte Consulting - Offshore,Mumbai)

Project Description: Offshore Oracle Apps DBA Support to Agilent

Technologies - one of the biggest customers of Oracle Apps in the world .

The client was based in the USA (San Jose, CA) - Production support was

provided from India - activities included Cloning,Patching, Tar followup,

Code Migrations and Performance Monitoring .

Client Agilent Technologies Ltd.

Duration January 2003 - October 2003

Environment HP - Superdome, Oracle Apps 11i .

Role Senior Oracle Apps DBA

Responsibilities: Hands on Cloning,Patching,Performance

Monitoring as per requirement .

Coordinating with US Hosting team for the

different tasks being handled .

Founder Member of the team - went to US for KT

- provided guidance/documentation for all Apps

DBAs recruited in India . Formed a team of 9

offshore DBAs at Deloitte - Mumbai Offshore

Office .

Initiated all maintenance processes at Agilent

- Defragmentation, Purging of old data /log

/req files /trace files/temp files /space

reclamation exercises etc and

documented,implemented the same .

11. Offshore Apps DBA Support

Project Description: Offshore Oracle Apps DBA Support to all clients of

Oracle Atlanta - major amongst them GE Medicals,GE Plastics, RedHat,

IngerSollRand above from Mascot Offshore India Centre . All clients were

based in the USA - Production support was provided from India for all these

clients - activities included Cloning,Upgrades,Patching, Tar followup,

Code Migrations and Performance Monitoring .

Client Oracle Corp - Atlanta .

Duration October 2002 - January 2003

Environment Sun Machines/HP Machines, Oracle Apps 11i /

11.0.3 .

Role Senior Oracle Apps DBA

Responsibilities: Hands on Cloning,Patching,Performance

Monitoring across all clients as per

requirement .

Coordinating with Oracle Atlanta US team for

the different tasks being handled .

Formed a team of 10 DBAs - in Mascot . Most of

them from Non ERP background - cross trained

people from other domains to perform routine

tasks for the team .

Handled Upgrades to 11i,Installations during

off hours for Oracle Atlanta .

12. Apps DBA Support for Implementation

Project Description: Oracle Apps DBA Support for Implementing Oracle Apps -

at Elecon - a leading Manufacturing Company in India based at Anand Gujarat

. Oracle Apps 11.5.6 was being implemented by Apps NIIT team at Anand -

Gujarat . Provided DBA support to the team at Elecon - activities included

Installation of Apps, Cloning,Patching, Tar followup, Code Migrations and

Support to developers .

Client Elecon - Anand, Gujarat

Duration July 2002 - October 2002

Environment Tru - Compaq, Oracle Apps 11i.

Role Senior Oracle Apps DBA

Responsibilities: Hands on Cloning,Patching,Multi Node Install as

per requirement .

Coordinating with Functional/Dev team for the

different tasks being handled .

Provided inputs on Architecture, Backup

Strategy and Maintenance activities .

13. 11i Upgrade and Platform Migration

Project Description: APAR Industries was migrating its existing

Installation of Oracle Apps on NT from 11.0.3 on WIN-NT 4.0 to 11i (11.5.3)

on HP - UX . This was a major activity taken from their offshore

Development Centre in India - Mumbai . The entire Migration was completed

in 3 months successfully (including Customizations etc) . Handled the

entire migration from Offshore Centre - with help for Media handling (Cds

etc) from US data centre .

Client APAR Industries US .

Duration March 2002 -June 2002

Environment HP Machine / Compaq Machine (NT Platform),

Oracle Apps 11i / 11.0.3 .

Role Senior Oracle Apps DBA

Responsibilities: Installation of Apps 11.5.3 (Upgrade FS) on

HP-UX for Upgrade .

Performiing the Pilot Upgrade end to end along

withj Platform Migration to HP .

Coordinating with US/UK/S'pore team for the

different tasks' validation .

Fixed all reported issues/coordinated with

developers for customisations migration and

performed the final upgrade/migration to 11i on

HP within 3 months .

14. Apps DBA 11i Implementation Support

Project Description: Apps 11.5.5 was being implemented by Polaris Software

Labs at Winsome Industries in Mohali (Punjab - India) but the

implementation was stuck up due to DBA support issues . Was hired by

Polaris from Rapidigm on Contractual basis to provide DBA support and train

junior DBAs for the same . Succesfully installed Apps 11.5.5 on Solaris

Platform and then configured system as per requirement . Installed

Localization Modules/OPM as required and supported the implementation apart

from training a junior DBA from Polaris .

Client Winsome Industries (Contractor to Polaris via

Rapidigm) .

Duration November 2001 - February 2002

Environment Sun Machines, Oracle Apps 11i .

Role Oracle Apps DBA

Responsibilities: Installation of Apps 11.5.5 on Solaris with OPM

and India Localizations .

Provided Apps DBA support to Functional /

Technical Team during implementation .

Coordinating with Oracle India support for

Localization/Standard Apps Issues .

Gave recommendations for Backup strategies and

Architecture related issues .

15. Prod Support/Upgrade - ONSITE in USA ) .

Project Description: Onsite Production AppsDBA Support for all clients of

Fidelity Investments on Oracle Apps 11.0.3/10.7 . The clients were mainly -

Genuity,Oracle Corp, Hughes, Fidelity (Internal) . Was instrumental in

doing the first Oracle Apps Upgrade from 11.0.3 to 11.5.2 (HRMS and

Financials modules) and from 10.7 to 11.5.2 .(Financials) successfully .

Also involved in Performance tuning .

Client Fidelity Investments -Merrimack, NH USA .

Duration September 2000- September 2001

Environment Sun Machines . Oracle Apps 11i / 11.0.3/10.7 .

Role Oracle Apps DBA

Responsibilities: Hands on Cloning,Patching,Performance

Monitoring across all clients as per

requirement .

Coordinating with Hosting team for the

different tasks being handled .

Performed 2 Upgrades within 1 year from 10.7 to

11i and 11.0.3 to 11i .

Code Migrations using Kintana .

16. Apps DBA Prod Support/Upgrade - ONSITE in AFRICA ) .

Project Description: Onsite Production AppsDBA Support for all clients of

RPC Systems - Botswana on Oracle Apps 11.0.3/10.7 . The clients were mainly

- BMC,BIFM/Botswana Life,Botswana Telecoms etc as detailed above . Was

instrumental in stabilizing the existing Apps 11.0.3 installation at

Botswana Meat Commision (one of the biggest sites of Apps in Africa .

Installed and gave support for Apps Implementation at BIFM .

Client Botswana Meat Comm/Botswana Fund Mgt./Botswana

Telecoms/Botswana Life Insurance .

Duration December 1999 - August 2000

Environment Sun Machines /Compaq Machines/HP machines/SCO.

Oracle Apps 11.0.3/10.7 .

Role Oracle Apps DBA

Responsibilities: Hands on Cloning,Patching,Performance

Monitoring across all clients as per

requirement .

Coordinating with client to get maintenance

windows for performing the above

Installing Apps / developer tools for BIFM Apps

11.0.2 implementation . Gave Support to

Implementation team .

DBA support for Botswana Telecoms (Telecom

Billing System - Arbor) .

17. APPS DBA SUPPORT

Project Description: Onsite Production Apps DBA Support for all clients of

Oracle India- on Oracle Apps 11.0.3/10.7 . The clients were mainly - BPL

Sanyo, Gonterman Pipes, Henkel Spic, Toshiba India, Thomson India ..

Client All clients of Oracle Apps in India - under

Oracle Support

Duration October 1998 - September 1999

Environment Sun Machines /HP Machines/Compaq, Oracle Apps

11.0.3/10.7 .

Role Oracle Apps DBA

Responsibilities: Hands on Cloning, Patching, Installations,

Localization Install across clients as per

requirement .

Coordinating with Oracle US Support for tars

from India clients and implementing bug fixes

for the same .

Created Install scripts for India Localization

Module on 10.7 and 11.0.3 . Gave support to

Localization development team .

Travelling to client sites to resolve issues,

installations, implementation support .

18. Oracle RDBMS DBA

Project Description: Oracle DBA Support for one of the biggest clients of

Oracle in India . SHCIL is one of the premier Custodial services

organization in India running one of the biggest databases on Oracle . Was

selected in the DBA team after opting for Automation after clearing All

India exam conducted by BSRB . Was given exposure to Operations and DBA

activities for 6 months and then supported the entire installation along

with a team of 7 DBAs .

Client SHCIL - Mumbai (Internal ) .

Duration March 1994 - August 1998

Environment Tata Elxsi/Pyramid Machines with Irix V.4 (SGI), Oracle 7.

Role Oracle DBA

Responsibilities: Backups / Recoveries . Supervising and

validating the the jobs done by operators.

Creating new environments for new modules being

implemented (e.g, Corporate Actions -

Dividend,Interest Tracking) for holdings of

Financial Institutions .

AD-HOC exports/imports/dataloads for sending

data to brances/loading data from

branches,Stock Exchanges,Clients .

Performance monitoring,tuning, involved in

application design and object sizing .

Development Support and Hands-on development

for modules like ISA .

Contact this candidate