Project Oracle
Resume:
Sivaprasad . Y Mobile :
(Oracle Apps Techno Functional Consultant) Email :
**********.******@*****.***
Objective:
To be a Competent Software Professional through consistent updating of
skills, contributing significantly to the Organization and to serve the
organization with utmost commitment and dedication.
Professional Experience:
. Total 10+ years of professional experience in IT industry.
. Having 9+ years of experience in Oracle Applications as a Techno
Functional Consultant.
. Having 1+ years of experience in Oracle and D2K.
Strengths:
Oracle Applications R12 & 11i
. Techno-Functional expertise to provide expert consultancy in
Implementation, Upgradation, Maintainance or Supporting, Integration
projects and able to work technically on
GL,AP,AR,PO,INV,OM,BOM,Advanced Pricing,Oracle Quoting, Oracle
Configurator, Install Base,Service Contracts,Service Requests,MRP,OIC
modules in Oracle Applications.
. Expertise to develop the assigned RICE components i.e, Reports,
Interfaces, Conversions and Forms by following the Business Process
Analysis and development standards for the projects and expertise with
code reviewing, unit testing, preparing technical design documents and
testing documents to ensure that quality process is maintained at all
stages.
. Responsible for System Integrity Testing(SIT) and User Acceptance
Testing(UAT).
. Extensively experienced in development and customization of Interfaces
and Conversions by using Unix shell scripting, SQL*Loader, PL/SQL,
Oracle Reports, XML Publisher.
. Experienced in requirement gathering, solution design, developing
programs, Unit testing, preparing technical design documents and
working collaboratively with all levels of project organization to
ensure smooth and successful execution of a project.
. Proficient in programming using Oracle (SQL,PL/SQL),Oracle ERP APIs &
Standard Interfaces, Forms and Reports, Oracle Workflow & Business
Events and Discoverer and all AOL Objects.
. Well versed with Forms Personalizations & OAF personalizations.
. Responsible for Writing the installation scripts and migration
documents.
. Capable of working independently and as well as a part of a team.
. Possess good communication and interpersonal skills.
. Self-motivated, quick learner, zealous, and deligent.
Professional Profile:
. Oracle Applications Techno-Functional Consultant
Feb'13 to Till Date
Working for Equinix Singapore Pte Ltd.
. Oracle Applications Techno-Functional Consultant
Feb'11 to Jan'13
Working for Panasonic Singapore Pte Ltd., on Oracle R12 & 11i.
. Oracle Applications Techno-Functional Consultant
July'10 to Jan'11
Worked for Equinix Singapore Pte Ltd
. Sr Oracle Applications Technical Consultant
Nov'09 to June'10
Worked for Canon Singapore Pte Ltd, Singapore
. System Analyst
Sep'07 to Sep'09
Worked for Creative Technology Limited, Singapore
. Oracle ERP Consultant
May'07 to Aug'07
Worked with Oracle Consulting Services, Singapore through Marc-
Software Pte Ltd
. Oracle Apps Technical Consultant
Jun'06 to May'07
Worked with CMG Online Sdn. Bhd., Malaysia through Coralsoft Sdn
Bhd
. Technical Consultant
Feb'04 to May'06
Worked with Axel Technologies, Hyderabad(India)
. Software Engineer
Jan'03 to Jan'04
Worked for Innovate Technology Services, Hyderabad on Oracle and D2K.
Education:
. Bachelor of Engineering in Mechanical,Production and Industrial
Engineering from Andhra University, Andhra Pradesh..INDIA..
Software Skills:
ERP : Oracle Applications R12 & 11i
Financials
(GL,AP,AR,FA)
Distributions
(PO,INV,OM,WMS,WSH,CZ)
Manufacturing
(BOM,MRP)
Project Accounting
(PA)
CRM (Service Requests,
Install Base, OIC)
RDBMS : Oracle 8i,9i, 10g
GUI : D2K (Forms & Reports) 6i &
10g
Tools : FTP, Telnet, Oracle Workflow
Builder 2.6,
Oracle Discoverer,Toad, SQL*Loader,
Filezilla.
Languages : SQL, PL/SQL, C, C++
Operating Systems : Windows, Unix & Linux
ERP Career Chronicle:
Project #1.
Project : AR Synchronization Project (Invoices &
Receipts)
Client : Equinix Singapore Pte Ltd
Project type : Oracle Apps 11i
Modules : Oracle Financials
Role : Functional & Technical
Environment : Oracle Applications 11i, Oracle 9i, PL/SQL,
Reports6i
Toad 8.6, SQL*Loader, UNIX, Workflow,
Discoverer Reports.
Role : Techno-Functional Consultant
Description : Equinix is the world's well known Data Center
services provider located in 35
Strategic markets in 11 countries
across 4 continents, Equnix enables customers
To rapidly deploy data center
operations, application nodes and network PoPS
Worldwide. They have their presence in
US, Europe and Asica Pacific Regions
Across several places.
Responsibilities :
. Gathering business requirements from Users, Preparing functional
Document with Test Cases, Developing respective Interface programs
using Oracle Standard Interfaces, APIs
& Workflow Business Events and then code reviewing and unit testing.
Project #2.
Project : R12 Implementation Project,
R12 Supporting,
11i Set Of Books Change Project for One
Operating Unit,
11i Production Support,
LEI Integration to Oracle,
Client : Panasonic Singapore Pte Ltd
Project type : Oracle Apps R12 & 11i Implementation & Supporting
Modules : Financials, Distribution
Environment : Oracle Applications R12 & 11i, Oracle 9i/10g,
PL/SQL, Reports 6i/10g,
Toad 8.6, SQL*Loader, UNIX,
Role : Senior Oracle Consultant
Description : Panasonic Corporation is one of the largest
electronic product manufacturers in
the world, comprised of over 680
companies. It manufactures and markets a wide
range of products under the Panasonic
brand to enhance and enrich lifestyles all
around the globe.
Responsibilities :
. Studying, understanding and analyzing the given requirements/requests
and customizing, enhancing and developing the programs according to
the Business Process Analysis and Specifications.
. Development and customization of the assigned RICE Components
according to the Business Process Analysis and development standards.
. Discussing with the end users and developing the components according
to their requirement.
. Responsible for code reviewing, tesing.
. Responsible for migrating the components to Production Instance.
. Testing and Implementation.
R12 Imeplementation :
. AR Invoices Conversion
. AP Invoices Conversion
. Customers Conversion
. Item Costs Conversion
. Item On-Hand Quantities Conversion
. OAF Personalizationss
11i Set Of Books Change Project :
. Items & Categories Conversion
. Supplier & Internal Banks Conversion
. Suppliers Conversion
. Customers Conversion
. Item Costs Conversion
. Item On-Hand Quantities Conversion
. AR Invoices Conversion
. AP Invoices Conversion
. Fixed Assets Conversion
. BOM Conversion
. Purchase Orders Conversion
. Pricelists Conversion
11i Integration Project :
. Oracle Integration with LEI (Lotusnotes Enterprice Integrator)
AP Claim & Travel Expenses for Two Operating Units,
AR Customer Interface from LEI to Oracle for One Operating Unit.
Worked on several xml publisher reports.
Project #3.
Project : 11i Production Support, 4Char IBX Project,
APGSI-1 Phase Project
Client : Equinix Singapore Pte Ltd
Project type : Oracle Apps 11i Support
Modules : Distributions, Service Requests, Install Base
Environment : Oracle Applications 11i, Oracle 9i, PL/SQL,
Reports6i
Toad 8.6, SQL*Loader, UNIX, Workflow,
Discoverer Reports.
Role : Business Analyst
Description : Equinix is the world's well known Data Center
services provider located in 35
Strategic markets in 11 countries
across 4 continents, Equnix enables customers
To rapidly deploy data center
operations, application nodes and network PoPS
Worldwide. They have their presence in
US, Europe and Asica Pacific Regions
Across several places.
Responsibilities :
. Studying, understanding and analyzing the given requirements/requests
and customizing, enhancing and developing the programs according to
the Business Process Analysis and Specifications.
. Development and customization of the assigned RICE Components
according to the Business Process Analysis and development standards.
. Discussing with the end users and developing the components according
to their requirement.
. Responsible for code reviewing, tesing.
. Responsible for migrating the components to Production Instance.
. Testing and Implementation.
Data Migrations :
. PO Conversion
. AP Bank Conversion
. AP Vendor Conversion
. XML Publisher Reports
Project #4.
Project : 11i Production Support
Client : Canon Singapore Pte Ltd
Project type : Oracle Apps 11i Support
Modules : Distributions
Environment : Oracle Applications 11i, Oracle 9i, PL/SQL,
Reports6i
Toad 8.6, SQL*Loader, UNIX
Role : Business Analyst
Description : Canon started out in 1937 with the vision to make
the best camera for the world.
More than 6 decades later, it has made
a name not only in photography arena but
is now a renowned brand in digital
imaging. With a goal to bring the best
innovations to people around the world,
Canon has built up more than 195
companies worldwide, employing more
than 90,000 people in research and
development, production, sales and
marketing activities.
As a regional headquarter, Canon
Singapore Pte Ltd is Canon's regional
headquarters for South & South East
Asia. In a move to bring about a unified
Canon presence in Singapore, it merged
its operations with its local sales and
marketing company, Canon Marketing
(Singapore) Pte Ltd on 1st January 2004.
Responsibilities :
. Studying, understanding and analyzing the given requirements/requests
and customizing, enhancing and developing the programs according to
the Business Process Analysis and Specifications.
. Development and customization of the assigned RICE Components
according to the Business Process Analysis and development standards.
. Discussing with the end users and developing the components according
to their requirement.
. Responsible for code reviewing, tesing.
. Responsible for migrating the components to Production Instance.
. Testing and Implementation.
Interfaces :
. Items and Item Categories Interface
. QP Price List Interface
. Production Support
. Bug fixing in Drop-Ship Order Cycle
Project #5.
Project : 11i Production Support
Client : Creative Technology Limited
Project type : Oracle Apps 11i Support, CQD Detach Project
Modules : Financials, Distributions & Manufacturing
Environment : Oracle Applications 11i, Oracle 9i, PL/SQL,
Reports6i
Toad 7.6, SQL*Loader, UNIX
Role : System Analyst
Description : Creative is the worldwide leader in digital
entertainment products for the personal
computer (PC) and the Internet,
headquartered in Singapore and expanded in
US,UK and Asia wide.
Responsibilities :
. Studying, understanding and analyzing the given Functional
Specifications and customizing and enhancing the reports according to
the Business Process Analysis and Specifications.
. Development and customization of the assigned RICE Components
according to the Business Process Analysis and development standards.
. Discussing with the end users and developing the components according
to their requirement.
. Responsible for code reviewing, tesing.
. Preparing installation scripts and migration documents.
. Testing and Implementation.
Interfaces :
. PO Mirroring from one Operating unit to another operating unit.
. Forecast Items Extraction from one operating unit and importing into
another operating unit.
. Past Due PO Alert Report(PO)
. BOM Loading Program
. Customers Ship To Sites without Bill To Assignment Alert
Reports :
. Bug fixing of Royalty Where-Used Report
. Bug fixing of Custom Pick Slip Report
. Finetuning of CTL Demand Supply Report
. Created new alert for Capturing Material Issues in cancelled jobs
. Purging of Inventory interface tables
. Adding some fields in Invoice print selected invoice report
. Conversion of BO report into Oracle - CT2 QD3 Buffer QOH Comparison
Report
Project #6.
Project : 11i Upgradation from 11.0.3
Client : Chartered Semiconductor Manufacturing,
Singapore
Project type : Oracle Apps 11.5.10.2 Upgradation
Modules : Financials, Distributions & Manufacturing
Environment : Oracle Applications 11.5.10.2, Oracle 9i, PL/SQL,
Reports6i
Toad 7.6, SQL*Loader, UNIX
Role : Oracle ERP Consultant
Description : Chartered Semiconductor Manufacturing (Nasdaq:
CHRT, SGX-ST:
CHARTERED), one of the world's top
dedicated semiconductor foundries,
offers leading-edge technologies down to
90 nanometer (nm), enabling
today's system-on-chip designs. The
company further serves the needs of
customers through its collaborative, joint
development approach on a
technology roadmap that extends to 32nm.
Chartered's strategy is based
on open and comprehensive design
enablement solutions, manufacturing
enhancement methodologies, and a
commitment to flexible sourcing. In
Singapore, the company operates a 300mm
fabrication facility and four
200mm facilities. They are upgrading their
E-Business Suite from 11.0.3 to
11i to enhance their business and
productivity.
Responsibilities :
. Studying, understanding and analyzing the given Functional
Specifications (MD050) and development of the requirements according
to the Business Process Analysis and Specifications.
. Development of the new reports and customization of the assigned RICE
Components according to the Business Process Analysis and development
standards.
. Involved in the enhancements of forms, interfaces, stored procedures
and triggers
. Migrating the reports from older version to 11i.
. Responsible for code reviewing, unit tesing and preparing AIM
Documents(MD050).
. Preparing technical, installation scripts and migration documents.
. Testing and Implementation.
Enhancements done :
. MRP Forecast Interface
. Supply and Demand User Interface Tagging Process
. BPA exchange rate and rate date updation
. Updating the revenue code for NRE and Reticle items invoices
. Weekly billing tracking report enhancement
. Creating Stored Procedures and triggers
. Developing and Migrating the reports
. Customization of the forms, reports, stored procedures, sql scripts
and triggers.
Project #7.
Project : PIERS (Pharmaniaga Integrated Enterprise
Resource Solutions)
Client : Pharmaniaga Bhd., Malaysia
Project type : Oracle Apps 11.5.10.2 Implementation
Modules : Financials & Distributions
Environment : Oracle Applications 11.5.10.2, Oracle 9i, PL/SQL,
Reports6i
Toad 7.6, SQL*Loader, UNIX
Role : Oracle Apps Technical Consultant
Description : Pharmaniaga Berhad is the largest integrated local
healthcare company in
Malaysia. It is a Public listed company on
the main board of the Bursa
Malaysia Securities (BMS) with paid up
capital of RM 100 million.
As a leading Malaysian healthcare company,
Pharmaniaga is driven by its
Core business namely, generic
pharmaceuticals manufacturing and R&D,
Warehousing and distribution of
pharmaceutical and medical products,
Sales & Marketing as well as hospital
equipping. Pharmaniaga has also
Created a niche in healthcare IT Solutions
which forms the backbone of its
Operations. They implemented Oracle
Applications 11.5.10.2 for its
enterprise resource solutions in order to
enhance the productivity and their
business.
Responsibilities :
. Studying, understanding and analyzing the given Functional
Specifications and development of the reports according to the
Business Process Analysis and Specifications.
. Development and customization of the assigned RICE Components
according to the Business Process Analysis and development standards.
. Discussing with the end users and developing the components according
to their requirement.
. Responsible for code reviewing, tesing and preparing AIM Documents.
. Preparing technical, test case, installation scripts and migration
documents.
. Testing and Implementation.
Interfaces :
. Item Master and Item Categories Migration.
. Suppliers Migration.
Reports :
. Detail Expenses by Cost Center Report (GL).
. Detail Expenses by Account Report (GL).
. Consolidated Invoice Report By Customer(AR).
. Aging by Salesman by Month Report(AR).
. Monthly Total Collection Summary & Detail Report(AR).
. Account Receivable Aged Summary Report(AR).
. Tracking Collection Report(AR).
. Projects Monthly Claim Report(PA).
. Projects Monthly Billing Report(PA).
. Daily Management Report (OM)
1. Picking List by Warehouse, Back Order by Warehouse, Nett Delivered
Items on Back Order(2005).
2. Back Order Aging by Warehouse (by ordered date), Back Order (COGS).
3. Daily Sales Order from Customer, MTD Sales Order from Customer, YTD
Sales Order from Customer.
4. Picking List by Warehouse, Back Order by Warehouse, Nett Delivered
Items on Back Order(2006).
. Outstanding PO's Report(PO)
. Completed PO by Number Report(PO).
. MTD/YTD Purchase Order Report(PO).
. Product By Location Listing Report(INV).
. Product By Item Listing(INV).
Project #8.
Client : CSC, Hyderabad(India)
Project type : Oracle Apps 11.5.9 Implementation
Modules : Financials, Distributions and Manufacturing
Duration : Mar'05 - May'06
Environment : Oracle Applications 11.5.9, Oracle 9i, PL/SQL,
Reports6i
Toad 7.6, SQL*Loader, UNIX
Role : Technical Consultant
Responsibilities :
. Studying, understanding and analyzing the given AIM Documents (MD50).
. Development and customization of the assigned RICE Components
according to the Business Process Analysis and development standards.
. Building packages, procedures, functions and triggers using Oracle &
D2K.
. Registration of tables, DFFs in the Forms development.
. Responsible for code reviewing, tesing and preparing AIM Documents.
. Preparing technical, test case, installation scripts and migration
documents.
Interfaces:
. Developed Open Item Interface to upload all the items data from legacy
to Oracle Apps base tables by using Standard Item Import Program.
. Developed Backorder Outbound Interface to extract the back orders data
from Order Management base tables into the flat file.
Reports:
. Developed Custom Vendor Transaction Details Report
. Developed Custom On-Time Delivery Perf. Report
. Extraction of Outstanding POs and sending an email attachment
. Customized Printed Purchase Order Report
Project #9.
Client : Hexaware Technologies, Chennai
Project type : Oracle Applications Upgradation from 10.7 Release
to 11.5.9
Modules : Financials, Distributions and Manufacturing
Duration : Feb'04 - Jan'05
Environment : Oracle Applications Release 11.5.9, Oracle 8i,
PL/SQL, Reports6i
Toad 7.3, SQL*Loader, UNIX
Role : Oracle Technical Consultant
Responsibilities :
. Studying, understanding and analyzing the given AIM Documents (MD50).
. Development and customization of the assigned RICE Components
according to the Business Process Analysis and development standards.
. Building packages, procedures, functions and triggers using Oracle &
D2K.
. PL/SQL method of submitting concurrent programs.
. Creating the scripts for concurrent executables and concurrent
programs for interfaces and reports.
. Responsible for code reviewing, tesing and preparing AIM Documents.
Interfaces:
. Developed Invoice Outbound Interface to extract all the AP Invoices
information from the Account Payables base tables into the flat file
using UTL_FILE package.
Reports:
. Convertion of Pick Slip report from ASCII to PDF Format
. Customized Custom AP Invoice Payment Schedules Report
. Extracted data from Material Account Distribution Detail for specific
items, subinventory and transaction dates range.
Oracle & D2K Projects :
Project#1
Client : Mediq, USA
Team Size : 8
Tools Used : Oracle8i, Forms6i, Reports6i
Role : Coding
Duration : July'03 - Jan'04
Description:
CCI is basically engaged in the manufacture and marketing of cement. The
work order entries are made when customer places an order for goods
manufactured by the company. Challans are prepared when the customer places
a order. Invoices are prepared based on materiel delivered on the challans.
This system consists of 3 modules. Viz.,
Order entry,
Generation of challans,
Invoice Printing.
Role :
Involved in designing Forms & Reports.
Developing Procedures & functions.
Project#2:
Title : Banking System
Team Size : 5
Tools Used : Oracle 8i, Forms6i, Reports6i
Role : Coding
1 Duration : Feb'03 - Jun'03
2 Demand Draft Description:
3
In this module issuing of drafts is in two ways. Customer can take draft by
paying money. If the system is having online connectivity with nearest
branch then customer is able to get draft by paying through his account.
There is also provision for destroy the Demand Draft in case of any mistake
done by employee. Reconciliation will be done at the nearest branch linked
with the system. These are the operation we can do with DD Module.
DD
Issue,Stop,Cancellation,Duplication,Paid,Revalidation,Destroy,Authorizations
.
1
GL Module Description:
This package is also a part of the Banking product. GL stands for General
Ledger Module. GL Module deals with general banking transactions. This
includes New Account holder details, types of accounts like SB, RD etc.,
Account holder details etc.
Role :
Involved in designing Forms & Reports.
Developing Procedures & functions.
Personal Profile:
Name : Sivaprasad . Y
Nationality : Indian
Current location : Singapore
Residential status : Permanent Resident
Alternate Mail : ************@*****.***
************@*****.**.**
Contact this candidate