Oracle Project

Summary

. HAVING AROUND * YEARS OF INDUSTRIAL AND TECHNICAL EXPERIENCE.

. Technology: Oracle Apps 11i/R12 and Development Tools (9i/10g SQL,

PL/SQL, Reports, BI Publisher, JDeveloper), Oracle BI Applications and

OBIEE

. Industry/Domain: Financials (GL, AP, AR, FA,CM)

. Experience in Oracle Forms & OAF Customizations, Extensions &

Personalization.

. Experience in Oracle BI Applications ETL processes and BI Reporting.

. Familiar with ITIL processes and involved in QA & ISMS audits.

technical summary:

APPLICATIONS ORACLE APPS 11I (GL, AP, AR, FA, CM,

AOL)

Oracle BI Applications

Tools Developer 10g (Forms 6i, Report 6i),

SQL Developer, JDeveloper, OBIEE &

Informatica 9.0.1

Web Technologies BI Publisher, OAF

Programming Languages C++, C, PL/SQL, SQL

Databases Oracle 9i/10g, SQL Server

Operating Systems MS-DOS, Windows 98, 2000, NT, XP

Industry Expertise

. WORKING AS A PRE-SALES SOLUTION CONSULTANT IN ORACLE INDIA PVT. LTD.,

BANGALORE FROM NOV'11 TO TILL DATE.

. Worked as an Oracle ERP Advisor in Dell Services, Bangalore from

Jul'10 to Nov'11.

. Worked as a Sr. Technology Consultant in Hewlett-Packard Global soft,

Bangalore from Jun'06 to Jul'10.

. Worked as a Technical Consultant in TATA Consultancy Services Ltd.,

thru Trans Horizon Consulting Pvt. Ltd., Mumbai, from Apr'04 to

Sep'05.

. Worked as Jr. CAD Engineer in Infotech Enterprises Ltd., Hyderabad

from Feb'03 to Aug'03

assignment Details

ORGANIZATION: ORACLE INDIA PVT. LTD. (NOV 2011 - PRESENT)

Environment: Oracle Applications R12, Oracle BI Applications, Oracle

Developer 10g.

As a Pre-Sales Solution Consultant, I have worked for multiple customers,

project deals across APAC region.

Current Job Title: Pre-Sales Solution Consultant

Responsibilities

. Provided Oracle Apps Technical, Oracle BI Applications Proof of

Concepts (POC) for multiple customer deals.

. Delivered RFIs /RFPs for multiple customer deals.

. Delivered OAF Customizations, Extensions and Personalization as a

Proof of Concept.

. Delivered a POC on Oracle Site Hub Integration for a Govt. Industry.

. Provided POCs on Oracle BI Applications by running ETL processes on

Financials, HR, SCM, EAM, Manufacturing and Service Analytics.

. Customized Informatica ETL processes to load the data in custom

tables.

. Installed and upgraded Oracle BI Applications from 7.9.6.3 to 7.9.6.4.

. Knowledge in development of OBIEE reports.

. Customized and implemented Electronic Records and Electronic Signature

(ERES) on Supplier Lifecycle Management and Case Management modules.

. Provided Oracle BI Applications trainings for Oracle Partners in APAC

region.

. Building User Productivity Kits (UPK) on the POCs and delivered

Knowledge Sharing sessions internally.

Organization: Dell Services (JUL 2010 - Nov 2011)

PROJECT: Owens & Minor - Support (Aug 2010 - Till Date)

Client: Owens & Minor, USA

Environment: Oracle Applications 11.5.10.2, Oracle Developer 10g. Modules:

GL & FA

Owens & Minor is a Healthcare manufacturing company. This project is about

post production support and with enhancements.

Current Job Title: Oracle ERP Advisor

Responsibilities

. Support maintenance for the General Ledger and Fixed Assets modules

. Implemented WebADI to load GL Journals & FA Assets.

. Developed OM Depreciation/NBV Exception Report in XML.

. Implementing Capital Lease concept for FA Assets.

Organization: HEWLETT-PACKARD (JUN 2006 - JUL 2010)

PROJECT: GOVT. OF PAPUA NEW GUINEA, PAPUA NEW GUINEA (NOV 2008 - JUL 2010)

Client: Govt. of Papua New Guinea, PNG

Environment: Oracle Applications 11.5.10.2, Oracle Developer 10g. Modules:

GL

This project is to migration of the Department of Finance (DoF) Treasury

Management System (TMS) from the 11.0.2 on AIX 4.3.2 to 11.5.10.2 on Red

Hat Linux 4.0 of Oracle e-Business solution. And also an enhancement and

maintenance work after the Migration has done.

Role: Technical Lead

Responsibilities

. Team lead for the 6 member's team.

. Migrated the custom forms and reports from 11.0.2 to 11.5.10

. Support maintenance for the Treasury Management System (TMS) and

Planning and Budgeting System (PBS)

. Involved as Configuration Management and Records Coordinator for the

project

. Involved in Oracle iSetup POC.

. Given Oracle Apps Technical trainings to the Interns

PROJECT: Qatar Airways R12 (Sep 2008- Oct 2008)

Client: Qatar Airways, Qatar

Environnent: Oracle Database 10g, Oracle Apps R12. Modules: AR

This project is about to migrate the existing Oracle Applications 11.5.9 to

R12 version. Migration of all the existing components into R12 version.

Role: Sr. Technical Consultant

Responsibilities

. Migrated the existing Custom Reports to R12 instance and enhance the

reports based on the R12 changes and tuning.

PROJECT: Avago - Day2 (JUN 2006- AUG 2008)

Client: Avago Technologies, USA

Environnent: Oracle Database 9i, Oracle Apps 11.5.10.2. Modules: GL, AP,

AR, FA, CM

Avago Technologies, an American company, headquartered in California, which

was earlier the semiconductor products division of HP and later Agilent

Technologies, before being spun off into a distinct legal entity.

Avago needed an independent Financial Accounting system. This project

covers the Knowledge Transmission (KT) from the Oracle Implementation Team

and the Support post implementation. It's an IT Service Management (ITSM)

model project.

Role: Sr. Technical Consultant/ Onsite Coordinator

Responsibilities

. Coordinating the Finance team from Onsite (Singapore) an Onsite

Coordinator.

. Daily interacting with the Clients (Business Process Engineers) to

understand their needs and requirements.

. Worked on the complex interface MT940 Bank Statement Auto Loader,

which gets the statements from CITI bank and imports the statements

into base tables.

. Involved in 445- Calendar implementation project, enhanced the objects

based on 445 Calendar.

. Issue identification & resolution for all components in Finance track.

. Familiar with the Incident Mgmt, Change Mgmt, Release Mgmt and Problem

Mgmt process.

. Good hands on usage of Kintana to move the custom code into

Production.

Organization: Trans Horizon Consultancy Pvt. Ltd. (Deputed to 'TCS') (Apr

2004 - Sep 2005)

PROJECT: ORACLE INSTRUMENTARIUM (APR 2004 - SEP 2005)

Client: GE HealthCare, USA

Environnent: Oracle Database 9i, Oracle Apps 11.5.9. Modules: GL, FA, AR,

OM

GE Healthcare is one of the world's leading manufacturers of diagnostic

imaging equipment, including conventional and digital x-ray, computed

tomography (CT) magnetic resonance (MR), ultrasound, positron emission

tomography (PET), and nuclear medicine.

GE Healthcare has strategically positioned its sales, service, engineering

and manufacturing organizations world wide to provide highly responsive

local service to customers.

Role: Application Programmer

Responsibilities

. Involved in customization of 'Japanese Depreciable Assets Tax Reports'

which is in Japanese characters.

. Member of team consists of 6 to up grade Database objects from 11.5.9

to 11.5.10. The process includes finding the changed objects in

11.5.9, and up grading with effected changes. Analyzing, Compiling &

Testing.

. It was an automation of Global Parts extracts, involved in complete

automation process from developing scripts, making SQL reports to

generate extracts. Automated the SQL reports by registering Concurrent

programs using APIs.

Organization: Infotech Enterprises Ltd. Hyderabad (Mar 2003 - Aug 2003)

PROJECT: TELE-ATLAS (MAR 2003 - AUG 2003)

Client: Tele-Atlas (U.S.A)

Environnent: AutoCAD. Role: Jr. CAD Engineer

Education

. BACHELOR OF TECHNOLOGY (COMPUTER SCIENCE & ENGG.), SRI VENKATESWARA

COLLEGE OF ENGG. & TECH. (JNTU), CHITTOOR, A.P. IN 2002.

Certifications and Trainings

. ORACLE EXTENDED 11I FORMS BY ORACLE CORPORATION

. R12 - Delta concepts by Oracle Corporation

. Oracle BI Applications 7.9.6.3 by Oracle Corporation

Awards, Publications and Professional Affiliations

. AWARDED WITH "PROCESS CHAMPION" FOR FOLLOWING THE GUIDELINES OF 100%

PROCESS TO RESOLVE THE ISSUES IN HEWLETT-PACKARD.

. Awarded and rewarded with "e-Awards" for my strong Technical and

Troubleshooting skills in Hewlett-Packard.

In-house Responsibilities

. DELIVERED ORACLE BI APPLICATIONS TRAININGS TO ORACLE PARTNERS IN APAC

REGION.

. Delivered Oracle Apps Technical trainings to the Interns.

. Involved in ISMS (Information Security Mgmt. Systems) awareness program &

audits.

. Involved in Team building activities like recruitments process.

Contact this candidate