Project Oracle
Resume:
Experience Summary
**+ years of work experience in Software Development that includes
Technical Development experience on various full life cycle implementations
of Oracle Applications in 11i and R12 versions.
. Proficient in Developing, Customizing and Implementation of Oracle
Modules: Oracle General Ledger (GL), Oracle Accounts Payables (AP),
Oracle Fixed Assets (FA), Oracle Purchase order (PO), Oracle Project
Accounting (PA), Oracle i-Expenses, Oracle i-Supplier Portal and
Oracle Sourcing. Also have very good functional knowledge in the above
modules.
. Experienced Technical Development skills in developing RICE Components
(Reports, Interfaces, Conversions, Extensions) in the domain of Oracle
Applications E-Business Suite.
. Strong programming experience in creating Packages, Procedures, API,
Functions, Triggers and other database objects using SQL and PL/SQL.
. Experienced in writing SQL statements and fine tuning the SQLs using
EXPLAIN PLAN. Also, experienced in debugging the existing codes by
generating the trace files, formatting it using TKPROF and to analyze,
identify and fix the long running SQL statements.
. Expertise in using tools like Oracle JDeveloper for Oracle Application
Framework developments, Oracle BI Publisher, TOAD, SQL*Loader, Forms
6i &10g and Reports 6i & 10g, Workflow Builder, Unix, HPPPM, CVS,
PVCS, P4V, Data loader, SQL Developer and Forms Playback.
. Experienced in bug fixing and Oracle Applications Production support.
. Experienced in Customizing Oracle seeded Reports in Oracle Payable
Module (AP) and Purchase Order (PO), Expertise in Interfacing,
Conversion and Data Migration from Legacy systems to Oracle General
Ledger, Oracle Human Resources, Oracle Purchasing and Oracle Payables
modules.
. Expertise in System Administration and Application Object Library
(AOL) to manage Concurrent managers, application user setup, defining
responsibilities, values sets, flex fields, registering menus, forms,
reports, concurrent programs, request groups, request sets,
descriptive flexfields providing support to apps users for any
technical or functional issues and Data conversion from legacy system
to Oracle Database.
. Strong technical writing and communications skills.
. Commitment to excellence proven by an outstanding career track.
Oracle Skills Summary
> Oracle Applications Modules (versions 11.5.9, 11.5.10 and R12)
Oracle General Ledger (GL), Oracle Fixed Assets (FA), Oracle Payables
(AP), Oracle Purchasing (PO), Oracle Project Accounting (PA), Oracle i-
Expenses, Oracle i-Supplier Portal, Oracle Sourcing and Application
Object Library (AOL).
> Oracle Technical Knowledge and Tools
Oracle JDeveloper for Oracle Application Framework development, SQL,
PL/SQL, UNIX, Oracle BI Publisher, Developer 2000 (Forms Builder 10g/
6i and Reports Builder 10g/ 6i), Oracle Workflow Builder, TOAD, SQL
Developer, SQL Loader, Data Loader, Forms Playback, PVCS, Kintana, SSH
and HP Open View, Oracle Code Analyzer and $U Unix Scheduling tool,
P4V, WinSCP, Minority Reports.
> Operating Systems
Sun Solaris 9 & 10, Linux, Windows 2003 Server.
> Oracle Database versions
Oracle 8i, Oracle 9i and Oracle 10g.
> Methodology
Oracle Application Implementation Methodology (AIM).
Trainings
. Trained in Performance Tuning and writing Optimal PL/SQL coding
concepts by Google Inc., Mountain View, CA.
. Trained in Oracle Application modules Oracle General Ledger,
Oracle Accounts, Oracle Fixed Assets, Oracle Payables, Oracle
Purchase Order, Oracle i-Expenses, Oracle Inventory, Oracle
Project Accounting, Oracle Sourcing and Oracle i-Supplier
Portal.
. Trained in J2EE language by Wipro Technologies.
Awards
. Feather on Cap Award from Wipro Technologies for working in the
R12 Upgrade Project for SuperValu, Inc., USA. This is the first
Oracle E-Business Suite R12 version RAC implementation across
the globe.
. Client Appreciation Certificates from SuperValu, Inc, USA, for
the dedicated service given in the Production Support.
Professional Experience
From Dec'10 to till date
Client: Google Inc., Mountain View, USA
Google is the worldwide leader in Internet search and advertising.
Google's mission is to organize the world's information and make it
universally accessible and useful. It was founded in 1998 and is
headquartered at Mountain View, CA, USA. Google provides a variety of
services and tools for advertisers of all sizes, from simple text ads to
display and mobile advertising, and to publishers, whether small or
large. Google has annual revenue close to $30 billion. Its key service
offerings are Internet Search, Search advertising, display advertising,
Mobile advertising, Enterprise search, Google Applications such as Maps
besides others.
i. Project: Google GAC Performance Tuning Project(Sep'12 to till date)
This is basically an initiative taken by Google to performance tune
all its existing SQL/PLSQL codes and creating new optimized SQL/ PLSQL
codes.
As part of this project, long running Concurrent programs and queries
in Production environment were identified by the Data Base
Administrator team and bugs will be created for the same. These bugs
will be assigned to developers, for analyzing the codes and taking
appropriate corrective action on the codes for improving the
performance.
ii. Project: Google FA - Automation of F-Project CIP Asset
Capitalization (Apr'12 to Aug'12)
This F-Project is mainly focused on automating the manual efforts
involved in capitalizing the CIP Assets and drastically reducing the
time spent by the offshore BPO (Accenture team) in preparing these
Assets for capitalization. Also, the time spent by Business users to
review and validate the prepared Asset records before Posting them in
Fixed Assets module. This automation is achieved by providing users
with OAF pages that will act as a centralized console for the users to
perform the various functionalities on the Asset records in one place
and the ability to process the Asset records in groups, thereby
reducing the processing time to a greater extent. Also, with the help
of the Reconciliation reports, the users will be able to track the CIP
Assets data that are been Posted in the Fixed Assets system.
iii. Project: Google FA Re-Class MAC Journal Entries Automation (Jan'12
to Mar'12)
The intended purpose of the Google FA Re-Class MAC Journal Entries
Automation project is to create offset Journals with the data
available in Oracle Fixed Assets into Oracle General Ledger to cancel
the effect of the wrong journals posted from Oracle Payables to Oracle
General Ledger.
iv. Project: Google GL Legal Accrual Automation (TeamConnect) (Nov'11
to Dec'11)
The purpose of this project is to automate the Accrual Journal
creation process based on the extracted files from TeamConnect system
to eliminate the manual work being performed by the accountants in the
Accounting & Controls group.
v. Project: Google GL gCrew Accrual Automation (Sep'11 to Oct'11).
The intended purpose of the project is to create an automated process
and standardize it globally for the gCrew accrual (temporary employee
timesheet entry tool) Journal creation. This automation was
implemented globally (NORTAM, EMEA, APAC and LATAM regions) based on
the accrual reports from gCrew system. This new gCrew Journal creation
process automation will eliminate the manual work being performed by
the accountants in the Accounting & Controls group.
vi. Project: Google GL ICON- Phase 1.5 Project (Jul'11 to Aug'11).
Google ICON is a custom application built with OAF technology for
Google's internal usage. This tool will handle all the intercompany
transactions within Google and create appropriate journals for the
transactions in respective Entities.
I developed the following reports Audit reports for this project using
Oracle BI publisher tool, to simplify the Task of tracking and
auditing the journals and associated Intercompany transactions created
from the ICON tool.
1. Google GL InterCompany Entity Details Report.
2. Google GL InterCompany Force Approved Batches Report.
3. Google GL InterCompany Balances by Currency Report.
4. Google GL InterCompany Reconciliation Detail Report.
5. Google GL InterCompany Status Exception Report.
6. Google GL InterCompany Expat Mapping Details Report.
vii. Project: Google Consolidated Income Tax Reconciliation Automation
(Mar'10 to Jul'10)
The tax team prepares the consolidated T-schedule on a monthly basis
as a part of the monthly required reconciliations. The current process
is manual and error prone. This Automation solution will automate the
roll forward/ reconciliation of income taxes for Google Inc and its
subsidiaries on a monthly basis. By this Google Inc can realize
$130K/yr in time savings of Finance FTE time upon implementing of this
automated solution.
viii. Project: Google Adjusting and Reclass Metrics Automation(Dec'10 to
Feb'11)
Google Adjusting and Reclass Metrics Automation projects aims at
automating the process of categorizing the Journal Entries entered
both manually and through the Web ADI tool into the specified
Adjustment and Reclass categories. This categorization was done
earlier through manual process which consumed a lot of manual efforts
of the GL users. This automation has made the process simple and
quick.
Role: Programmer Analyst
Contributions:
. Requirement gathering and preparing the Technical Design documents.
. Getting design approval from the review committee.
. Development, Performance tuning, Testing and obtaining Code review
approval from Technical leads.
. Using trace and TKPROF, identify the long running SQL statements.
. Fine tune the SQL statements using EXPLAIN PLAN command, by identifying
FULL TABLE scans, establishing the missing joins and by using SQL hints
to force the SQL optimizer to use a particular access path, while
executing the SQL statements, rewriting the poorly performing queries
and creating INDEXES wherever necessary.
. Fine tuning PLSQL codes by identifying the unwanted loops, repeated
COMMIT statements inside the codes, replacing the DML statements with
BULK COLLECT option where ever huge data volume is concerned,
identifying unwanted loops within codes and replacing them
appropriately.
. After tuning the codes, getting the performance approval from the
performance team.
. Coordinating with Business Users for retesting the codes in UAT
environment and obtaining signoff.
. Migration of the code using the Kintana tool.
. Knowledge Transfer to Production Support Team.
From Oct '09 to Dec'10
Client: Cisco Systems Inc., San Jose, USA
i. Project: Procure to Report (P2R) Development Project (Jul'10 to
Dec'10)
Cisco Procure to Report (P2R) Development Project is an on going
project that takes care of the Production Supports Bug fixing activity
in the Finance track for which the resolution time is more than 40
hours.
ii. Project: Cisco Web Based CT2R Quote Governance(Dec'09 to Jun'10)
Cisco Web Based CT2R Quote Governance Project is a Web based solution
to find and correct the CT2R (Cycle time to replenish). Through this
project Cisco could reduce the Weeks of Supply time and increase
profit considerably.
iii. Project: Cisco X1 Project(Oct'09 to Dec'09)
Cisco X1 Project is a customized Oracle Sourcing Module development
project.
Role: Technical Consultant
Contributions:
. Requirement gathering from business users and preparing the FSD
documents in MD50 template.
. Analyzing the requirements and preparing the Technical design
documents in MD70 template.
. Getting the FSD and the TDD reviewed by the Business leads and
obtaining signoff for design.
. Development of the RICE components and getting the code reviewed by
the code review team.
. Preparing Test cases for Unit Acceptance Testing by user.
. Preparation of Test Documents (UTC), Code Review Documents and
conducted testing on all the developed components and entering the
same in the quality center.
. Go-live preparations such as Kintana Patch creation and migration
activities.
From Aug'09 to Sep'09
Client: Avago Technologies, Singapore
Project: Inventory Reservation Automation
The Open Sales Order lines were manually pecked against the
Available to reserve quantities in inventory. This process was
time consuming and resource intensive. So in this project the
subject pecking process was Automated by developing a custom
program.
Role: Technical Consultant
Contributions:
. Involved in the requirement gathering, design, coding testing and
promotion of the Inventory Reservation Automation system for Avago.
This Automation program will handle the mapping of the available On
hand quantities with the open Sales Order lines based on the specified
business logic. This program minimized the manual work, increased
production efficiency and resulted in headcount/ cost reduction.
. Preparation of Test Documents (UTC), Code Review Documents and
conducted testing on all the developed components and entering the
same in the quality center.
. Go-live preparations such as Kintana Patch creation and migration
activities.
From Jun'06 to Jul'09
Client: SuperValu, USA
Worked for SuperValu, USA client for the below projects. SuperValu is #2
grocery chain in USA, with more than 2500 stores in 37 states under names
such as Albertson's, Acme Markets, Bristol Farms, Jewel, and Shaw's.
Projects:
i. Multi -Org Expansion Project (June '06 to Dec '06).
Albertson's stores were acquired partially by SuperValu. The remaining
stores operated under the Albertson's LLC. So, a new set of books and
operating unit was created for SuperValu and data was segregated for
SuperValu and Albertson's LLC. For achieving this all the codes of
custom objects were modified appropriately to make it Multi-Org
enabled, to meet the business requirement.
ii. Oracle i-Expenses Implementation Project (Jan '07 to Dec '07).
Oracle i- Expenses module was implemented for SuperValu, USA client
for reimbursing the official expenses incurred by their company
employees.
iii. IT Asset Management Project (Jan '08 to Feb'08).
The objective of this project is to build centralized console for IT
Asset tracking using HP OpenView software. I built an outbound
interface to pull all the IT Asset related information from Oracle
financials base tables and create an extract with relevant IT Asset
details, this extract will be the input to Asset tracking console.
iv. EquipPro Project (Apr '08 to Oct '08).
The DSG (Design Service Group) department of Supervalu will procure
the high value equipments required by the Supervalu, Inc. DSG was
using the Intergy software (developed with Power Builder) for this
purpose and they wanted to switch over to the Oracle Applications
software for Integrating this sourcing application with Oracle. Hence,
in this project we developed a Custom responsibility involving 15
custom forms exactly replicating the earlier Intergy software forms.
We developed associated codes, workflows and Reports for this project.
After Development of the forms in Form6i it was upgraded with R12
compatibility features and migrated to Oracle Apps R12 version.
v. R12 Upgrade project (Mar '08 to Jul '09).
Upgrade of 11i Oracle EBS instances to R12 (database instances from 9i
to 10g) for SuperValu, USA.
Role: Technical Consultant
Contributions:
. Requirement gathering from business users and preparing the FSD
documents in MD50 template.
. Analyzing the requirements and preparing the Technical design documents
in MD70 template.
. Getting the FSD and the TDD reviewed by the Business leads and
obtaining signoff for design.
. Development of the RICE components and getting the code reviewed by the
code review team.
. Preparing Test cases for Unit Acceptance Testing by user.
. Testing, Documentation and Migration of components from one environment
to another with necessary co-ordination with the Business users for
approvals and DBAs for migration.
. Post Go-live Support assisting users to get acquainted with the new
Oracle Application Environment (R12) across modules.
. Gave Techno-Functional transition to ongoing Production support team
(Keane Inc., India) and Supervalu India Development Team as per the
Business requirement.
. Received Feather On Cap award from Wipro for the contributions made on
these Projects and also received Client appreciation award from
SuperValu.
From Aug'05 to Apr '06
Client: Rogers Machinery Company, Inc., USA
Project: Implementation of Oracle Applications 11.5.9
Role: Technical Consultant
Contributions:
. Involved in the analysis of the existing legacy systems and the
business processes.
. Preparing Technical Documentation.
. Development, testing and implementation of code for Supplier Bank
Conversions.
. Developed Custom Report on Purchase Orders for Service Items.
. Form Customization - Supplier entry, Invoice form and the Purchase
Order were customized as per the Business requirements.
From May '04 to July '05
Client: Gulf Food Industries, Dubai
Project: Re- Implementation of Oracle Applications 11.5.9.
The existing version of 11.5.8 was upgraded to 11.5.9.
Role: Technical Consultant
Contributions:
. Requirement gathering and preparation of MD50 and preparation of
MD70 documents.
. Developed code for standard invoice and receipts conversions.
. Developed Custom Reports on PO details and also customized existing
reports.
. Form Customization such modification to PO form to make the DFF
display the details relevant to items ordered and development of
custom forms.
. Worked in the onsite implementation team with additional
responsibilities to co-ordinate with the offshore developers.
From Aug' 02 - Mar'04
Client: Emirates Group, Dubai
Project: Development and Support of Air Traffic Management System
Role: Oracle Developer
Contributions:
. Worked onsite developing various custom reports and forms as per
business needs.
. Worked in design, development and modification of PL/SQL stored
procedures, functions, packages and triggers to implement business
rules into the application.
. Worked in Production Support and developed SQL queries for various
extracts for the business user's day to day Business requirements.
Education
. Madras University, Bachelor of Engineering in Electrical and
Electronics Engineering, 2002.
Employment History
. Wipro Technologies, Bangalore ( From May 2006 till date
. APPSUPPORT, Chennai ( From July 2002 to May 2006.
Contact this candidate