Sales Oracle

Location:

Posted:

October 25, 2013

Contact this candidate

Resume:

Ramesh K

408-***-****

***.********@*****.***

PROFESSIONAL SUMMARY

• Having around 9 years of experience as a Techno-Functional Consultant on Oracle

Applications R12 / 11i – Distribution (Order Management, Shipping, Inventory, and

Purchasing), Financials (Accounts Receivables, Accounts Payables, General Ledger, and Fixed

Assets) and CRM (Install Base and Service Contract) modules.

• Extensive experience in New Implementation projects, Oracle Apps Rollouts & Well-versed

with all the phases of Software Development Life Cycle (SDLC).

• Extensive experience on working on Business requirements analysis, review, definition and

documentation.

• Well experience in System Impact Analysis, Design, Systems Architectural Design, Interfaces

Process Design, Functional Flow Design, Data Process Flow Designs &presentations.

• Experience in Business Process mappings for Integration project with interdependent

modules and teams.

• Well experience in Oracle Applications R12 version in Financial Modules – Accounts

Receivable (AR), Accounts Payable (AP) & General Ledger (GL).

• Extensive Experience in Oracle Forms, Oracle Reports, XML reports, Discoverer reports

using Oracle Forms 6i/ 9i, Oracle Report builder6i / 9i, XML, Discoverer tool &

Oracle 10g/11g technologies.

• Experience in Oracle Workflow processes & methodologies.

• Proven experience in project and team leading with extensive organizational and

interpersonal skills. Equally comfortable working independently as well as in a team

environment.

• Experience in oracle query tuning methods & tips for improving the system performance.

• Excellent communicator with strong information analysis and continuous learning skills.

• Excellent troubleshooting, de-bugging and problem-solving skills.

Technical Skills

SQL, PL/SQL, C, C++

Programming

Languages

Oracle Applications R12 / 11i (11.5.9 and 11.5.10)

ERP

Oracle 8i/9i /10g / 11g

DBMS

Oracle Forms 6i / 9i / 10g, OAFramework

GUI

Oracle Reports 6i / 9i / 10g and XML publisher

Reporting Tools

MS Project

Design/CASE Tools

Win 2003/XP/2000/NT/ 7, MS DOS

Operating Systems

Workflow, VSS, PVCS

Others

Education

Master in Business Administration (MBA) from Andhra University.

Professional Experience

Cisco Systems Inc., San Jose, CA

MCD Make Jul 2013 – Till Date

Role: Techno-functional Consultant

Manual Compliance Deal (MCD) is a process to improve revenue for Trade Compliance required

opportunities through a manually driven supply chain solution. Some countries, agencies and organizations

provide special sales or financing opportunities to qualifying businesses, goods, and transactions through

special programs. Cisco collectively refers to these programs as "special sales/trade programs". Cisco

actively participates in special sales/ trade programs globally to strategically expand sales. Cisco has

processes in place to ensure accurate assessment of Cisco's ability to comply with program requirements as

well as accurate reporting of program data to relevant authorities.

Responsibilities:

• Preparation of MD50 & MD 70 documents as per business requirements.

• Identification of impacts on other modules per this new / enhancement process implementation.

• Analyze Design and Develop new software and enhancement modules per the business requirements in

SCM Modules.

• Co-ordination & Interaction with different application stakeholders, cross functional teams per the new

requirement changes and acceptance.

• Carry out Solution review, Design flows, testing, fixing of bugs etc.

• Design and development database Tables, Triggers, Database Triggers, Cursors, Procedures, Stored

Procedures and Functions.

• Development of Oracle Forms, Oracle Reports, XML Publisher and Discoverer reports.

• Involved in Adaptive planning process which includes programs development certain reports and running

through SOA process.

• Involved in oracle workflow processes changes and impact analysis to the existing system.

• Involved in Production support issues raised by business.

• Supporting QA, UAT and BAT Test Cycles.

GTMS Sales Jan 2013 – Jun 2013

Role: Techno-functional Consultant

Sales’ reporting is the consolidation of different sales applications. As part of Cisco’s Go to Market Strategy, the

business is requiring Multidimensional Reporting of Bookings and Opportunity/Commit data for the WW Sales and

WW Field Operations Organizations. These sales reports will comprise of Bookings and Opportunity/Commit

reports by the following dimensions: Sales Hierarchy, Corporate Vertical Market, Localized EMEA Vertical Market,

and Core/Advanced Technology.

Responsibilities:

• Preparing Technical specification documents as per the functional requirements.

• Analyze Design and Develop new software and enhancement modules per the business requirements.

• Design and development database Tables, Triggers, Database Triggers, Cursors, Procedures, Stored

Procedures, Functions, Forms, and Reports.

• Carry out Design review and code review, testing, fixing of bugs etc.

• Involved in understanding different servers data process & flows used across cisco for the data received.

• Co-ordination & Interaction with different application stakeholders, cross functional teams per the issues

raised.

• Managing and supporting the Cross vendor teams/tracks for resolving the inter-dependency issues in the

day-day activities.

• Supporting in Month End (ME) and Quarter End (QE), Year End (YE) closing activities.

• Involved in DU jobs performance, enabling / disabling activities & analysis for the job aborting causes.

• Resolving Production support issues / bugs raised by the business with-in a stipulated timeframes.

• Supporting the issues related to the data mismatches / discrepancy from the cross flow streams on a

priority basis.

Environment: Oracle Applications R11, Forms 6i, Reports 6i, HP-UX, Oracle 10g / 11g

Bloom Energy Systems Inc., Sunnyvale, CA Apr 2012 - Dec 2012

Role: Techno-functional Consultant

Bloom Energy used to make highly efficient, low cost and low polluting solid oxide fuel cell servers using a wide

variety of inputs to generate onsite electricity. Bloom Energy has more than 500 servers deployed for number of

corporations like eBay, Google, Apple, Wal-Mart, ATT & many more.

Responsibilities:

• Preparing Technical& Functional Specification Documents as per the business requirements.

• Involved in analysis, requirement gathering and design using MD70 documents.

• Involved in system analysis per the requirements.

• Impact analysis in Order Management – SFDC integration for the gap and solutioning as per the business

requirements.

• Involved in development of reports in IB & SC module.

• Involved in Adaptive planning process which includes programs development certain reports and running

through SOA process.

• Development of discoverer, XML Publisher reports & Interfaces per the requirement in ASCP modules.

• Involved in new / updating the oracle workflow processes.

• Creation of new Triggers, Packages, Procedures, Functions, Concurrent Programs, Forms, reports, Alerts,

Request Sets, Notifications setup.

• Tax data verification & uploading process on a monthly basis.

• Resolving Production support issues / bugs raised by the business.

• Resolving the issues related to the Customer billing invoices on a priority basis.

Environment: Oracle Applications R12, Forms 10g, Reports 10g, HP-UX, Oracle 10g

Cisco Systems Inc., San Jose, CA

Mar 2010–Mar 2012

CCW

Role: Techno-Functional Consultant

The Cisco Commerce Workspace (CCW) project is an ongoing transformation project to improve the way Cisco

does business with its customers. The main objective of CCW is to provide a holistic purchasing experience

through which customers will order all products and services from Cisco. The continued development of CCW will

reduce the number of tools customers currently need to use to place and manage their orders and also provide a

consistent purchasing experience.

Responsibilities:

• Preparing Functional Specification Documents as per the business requirements.

• Impact analysis on OTC / QTC areas in Order Management, Receivables for the gap and solutioning as

per the business requirements.

• Involved in impact analysis discussions on Oracle Trading Community Architecture (TCA) for the scopes

impacted.

• Analyzing and identifying the impacts at Order Management side for this new process implementation.

• Involved in analysis, requirement gathering and design using MD70 documents.

• Involved in Post analysis for the functional mappings.

• Creation of new Triggers, Packages, Procedures, Functions, Concurrent Programs, Forms,

• Reports, Interfaces as per the requirement.

• Unit Testing & Test Cycle support.

Environment: Oracle Applications 11i, Forms 6i, Reports 6i, HP-UX, Oracle 9i/10g

NGCCRM Oct 2009 -Feb 2010

Role: Technical Consultant

NGCCRM is a new application which is going to replace the existing Accounting Engine (AE) application with new

features added like Revenue calculations, discounts for the Cisco business requirements. This new implementation

project describes the calculations of Revenue Recognition deferrals and which is for the Q3FY’12 release.

Responsibilities:

• Preparing Functional Specification Documents as per the business requirements.

• Involved in gap analysis for the business requirements and identification of the custom

• Identifying impacts to GL & AR Modules for the new introduction tool Revenue Accounting Engine (RAE).

• Analyzing and identifying the impacts on other modules for this new process implementation.

• Impact analysis on Oracle Trading Community Architecture (TCA) discussions for the this new application

introduction.

• Involved in system impact analysis per the business requirements.

• Creation of new Triggers, Packages, Procedures, Functions, Concurrent Programs, Forms, Reports,

Interfaces as per the requirement.

• Test Cycle support.

Environment: Oracle Applications 11i, Forms 6i, Reports 6i, HP-UX, Oracle 9i/10g

STC/CI 2.0 Dec 2008 - Sep 2009

Role: Technical Consultant

CI 2.0 is the new implementation project where the new operating unit for United Kingdom is setting up for

capturing the new business in Europe market and this UK operating unit will overcome the Europe Cisco business

requirements and which is on Q1FY’10 release.

Responsibilities:

• Preparing Functional Specification Documents (FSD) as per the BRD requirements.

• Identifying impacts to GL Modules for the new operating unit STC-UKH.

• Impact analysis on OTC areas in Receivables for the gap and solutioning as per the business

requirements.

• Involved Oracle Trading Community Architecture (TCA) analysis discussions for the new UKH operating

unit introduction.

• Analyzing and identifying the impacts on other modules for this STC-UKH operating unit.

• Involved in analysis, requirement gathering and design using MD70 documents.

• Creation of new Triggers, Packages, Procedures, Functions, Concurrent Programs, Forms, Reports,

Interfaces as per the requirement.

• Tracking the issues in the PROPEL tool for the new enhancements required for the business.

Environment: Oracle Applications 11i, Forms 6i, Reports 6i, HP-UX, Oracle 9i/10g

Cisco POC Jul 2008 - Nov 2008

Role: Technical Consultant

The Fast Track Project will provide a blueprint to the ICW release planning process for the enablement of new

software business models. Cisco has no automated system to support the end-to-end transaction of new SW

business models, impacting revenue growth, acquisition integration and causing financial risk and operational

inefficiency.

Responsibilities:

• Conduct Impact analysis in the POC fast track in AR module

• Providing solutions to the analyzed products & service line track

• Changes required to the AR modules related issues.

• Preparing the functional specifications as per the BRD provided.

Environment: Oracle Applications 11i, Forms 6i, Reports 6i, HP-UX, Oracle 9i/10g

Checkpoint AMS, Boston MA

Role: Technical Consultant Feb 2008- Jun 2008

Checkpoint has three operating units in US, Canada and Hong Kong. They have another Operating unit named

SSG for which they are going for Upgrading from 10.7 to 11.5.10.2 later. They are implementing all the modules

Financials, Distributions, Manufacturing and CRM. Currently supporting with pre-upgrade issues like new reports,

report modifications, data fixes etc.

Responsibilities:

• Development of new reports, OA Pages & XML reports using Pl/Sql as per the client requirement.

• Development of new Packages, Procedures, Functions, Database Triggers using Pl/Sql as per the

requirement

• Part of production as well as enhancement team on support 365X7X24.

• Resolved the issues related to customizing the reports, extracts etc.

• Conduct Technical analysis for developing new reports.

• Other issues related to reports in Production.

Environment: OA Framework, Jdeveloper, Oracle Applications 11i, HP-UX, Oracle 8i

Parsons Brinckerhoff, New York NY

Role: Technical Consultant Aug 2007- Jan 2008

Parsons Project is an up gradation project from 11.5.8 instance to 11.5.10 instance. This project was planned to

fully re-implement the required customizations currently in 11.5.8 ASF to 11.5.10 ASN. In 11.5.10 a new Sales

product - Oracle Sales (ASN) has been introduced. This is a separate product from Oracle Field Sales (ASF:

previously known as OSO - Oracle Sales Online). Oracle Sales is based on the OA Framework and Oracle Field

Sales is based on JTT (Java Server Pages - JSP).

Responsibilities:

• Developing OA pages based on the functional specifications.

• Developing Interfaces & conversions using Pl/Sql in PO, OM, AR modules.

• Additional code needs to be implemented as per the enhanced functional requirements.

• Conduct Technical analysis for developing new OA Pages.

• Unit testing and Integration testing.

• Fixing of the Issues of the developed OA Pages.

Environment: OA Framework, Jdeveloper, Oracle Applications 11i, HP-UX, Oracle 8i

Tempel Steel, Chicago IL

Role: Technical Consultant Feb 2007- Jul 2007

The Pressroom module will provide functionality to handle a variety of shop floor control functions. Specifically, the

mod will track all aspects of reporting production, conservation of mass verification, the current state of the

resources, the current disposition of the dies and, finally, to which resources operators are currently assigned.

These functions will be accessed via a custom user interface, but will communicate with standard Oracle

Applications in the background by way of standard APIs.

Responsibilities:

• Developing OA pages based on the functional requirements.

• Conduct Technical analysis for developing new OA Pages.

• Development of new reports.

• Resolving the issues related to the developed OA Pages.

• Unit testing and Integration testing.

Environment: OA Framework, Jdeveloper, Oracle Applications 11i, HP-UX, Oracle 8i

ETS Maaden, Saudi Arabia

Role: Technical Consultant Mar 2006- Jan 2007

ETS Maaden is one of the largest mining companies in the Kingdom of Saudi Arabia. They are engaged in oil

exploration, gold mining, infrastructure development, ports development, etc. The present engagement with

Maaden involves up gradation of their current Oracle Apps instance from 11.5.9 to 11.5.10.2 and also

implementation of new modules like HRMS, Financials, Encumbrance, iProcurement and Oracle Projects.

Responsibilities:

• Run all the reports in 11.5.9 and 11.5.10 and compare the outputs in both of the instances and if any

conflicts related to the reports arise.

• Setup problems needs to be checked based on the report

• Running all reports also documented the all the Report Test Cases specific to the modules

• Development of the new reports & Interfaces based on the specifications.

• Unit Testing & Integration Testing.

Environment: Oracle Applications 11i, Forms 6i, Reports 6i, HP-UX, Oracle 8i

GE Infra, India

Role: Technical Consultant Mar 2005- Feb 2006

GE Infrastructure is based on different businesses like GE- Sensing, GE-Security, GE- HQ. Sensing is mainly

concentrated in US only whereas Security has its businesses at Europe, US, China and Ireland. Different modules

covered under this engagement are AP, AR, OM, BOM, WIP, INV etc. At GE-HQ level only consolidation takes