Professional Summary:

• Overall 12 Years of experience with Oracle products.
• Around 9 Years in Oracle eBusiness Suite 11i/R12
• 5 Years of Onsite (US, Australia and Singapore) experience.
• Insightful experience and understanding of application development, implementation and customization in Financials, Distribution modules and other modules.
• Extensive technical and significant functional skills encompassing requirement analysis, solution architect, maintenance and enhancement of applications
• Strong experience in Oracle BI Discoverer and BI Publisher.
• Possess excellent team leading skills including Delivery Management, Onsite and Offshore Interaction, Strategy Planning etc.

ERP Expertise:

Technical

• Extensive experience in Reports, Interfaces (Inbound/Outbound) and Customized Extensions (RICE).
• Data Migration and Data Conversion during project Implementation R12 and lower versions of Oracle Apps.
• Preparation of technical documentation such as MD10, MD70, CV10, CV40 and CV60.
• Created Packages and Stored Procedures using API’s for various modules of Financials and Supply Chain.
• Technically expert in Reports, Discoverer, XML Publisher, Forms, XML, PLSQL, WebADI and UNIX programming.
• Expert skills on DB object creation, triggers, procedures, functions and packages.
• Tuning of reports, queries and processes.
• Has been using SQL*Loader, UTL_FILE, UTL_HTTP, XMLGEN Oracle Export and Import utilities.
• Customizations by Personalization.
• Experiences in registration/migration of concurrent programs, creation of users, responsibilities, forms, functions, menu, values sets, request sets, request-groups registration in Oracle Applications.
• Development of Reports using XML Publisher/BI Publisher.
• Experience in creating programs using Bulk Collect and programming using collections.

Functional

• Data gathering, Solutions Recommendation.
• Logs service requests (SR)
• Good in Financials, CRM and SCM modules like Receivables, Payables, General Ledger, Service Contracts, Credit Management, Order Management, Inventory, Procurement.
• Design of Application Extensions and Integrations.
• Preparation of functional documentations such as BR100, MD50 and TE40 and user guides.
• Production Support.
• Application administration of Oracle Application.
• Conducted user trainings.

Current Employer:
Confidential, Programmer Analyst Aug 2012 – till date

PROJECT PROFILE:

Project: Oracle eBusiness Suite R12 – CEMLI Mar 2012 – Aug 2012

• Client: Confidential
• Modules: Oracle CRM (Service Contracts, Install base), Oracle Receivables, Order Management. Clear Case( Unix based)

Role: Designation & Description
Working as Tech Lead for Confidential project.

Roles and Responsibilities

• Involved in delegation and co-ordination of Change Requests (Clear Quests) in the team.
• Compiling the data from the team and Preparing metrics reports for the monthly deliverables.
• Working with functional analysts in ascertaining the requirements for the CEMLI components to be developed.
• Worked on Service Contracts, Renewal and Revisions reports
• Worked on business flow customizations by using APIs in contracts.
• Worked on a program to zero item prices for tailor made services/contracts.
• Worked on Renewal Forecasts and Revision Sales Order Error Handling report.
• Worked on setting up “stage test” environment for CQs, before promoting them to next level.

Project: Oracle eBusiness Suite R12 – Support Jul’10 – Feb 2012.

Client: Confidential.
Modules: Oracle Financials, Oracle Credit Management, Project Accounting.

Role: Designation & Description
Working as Techno/Functional Lead for Confidential project as part of Help Desk and Assurance practice

Roles and Responsibilities

• Planning and co-ordination of the team in addressing and assigning the issues to the resources to support the activities for resolving the applications functional areas.
• Work closely with the business functional leads in ascertaining the requirements for the RICE components to be developed
• Worked on Oracle HRMS(Time and Labor)
• Worked on Web ADI for PA related invoices
• Working on Oracle Credit Management
• Worked on OCM enhancements
• Working on Month End Close activities
• Involved in UAT with users and bug analysis process.
• Received client accolades for my work in OCM module.

Project: Oracle eBusiness Suite R12 – Upgradation May’09 – Jun 2010.

Client: Confidential
Modules: Manufacturing (BOM), Oracle Financials, Oracle Project Accounting and Oracle Distribution

Roles and Responsibilities

Worked as technical consultant

• Working on Oracle 11i to R12 Upgradation project.
• Working on gap identification process and custom object identification.
• Worked on Project Accounting Transaction Item interface.
• Developed PA custom reports such as Project Cost Tracking report and Budget, Cost Tracking reports at individual project level.
• Worked on custom “Manufacturing Cost Variance Report”
• Implemented RBAC – Security model.
• Designed and developed various types of BI/XML Publisher reports.
• Customized complex reports such as, Standard PO and Complex PO.
• Worked on variety of reports across Financials and Distribution (OM) modules.
• Developed XML Publisher Report for Employee Expenses and AP/AR Netting Reports.
• Carried out FND object (Users, Responsibilities, and Menus) migration across the instances.
• Involved in iProcurement Personalization(OAF)
• Worked on Inventory Aging Report.
• Worked on Order Management Reports such as Revenue-COGS, Sales Order, Packing List, Material Onhand.
• Involved in UAT with users and bug analysis process.

Project: Oracle ERP Support Jan’09 – May-09

Client: Confidential.
Modules: Oracle Projects, Oracle Financials and Oracle SCM.

Team Size 5
Role: Designation & Description
Working as Technical Consultant

Roles and Responsibilities

• Providing production/customer support by resolving client’s day to day issues.
• Worked on Transaction Import interface(Oracle Projects)
• Worked on Datacom Projects CIP Transaction Report
• Worked on Datacom Project Issue Slip
• Worked on AIM documentation for custom objects.
• Involved in UAT process with clients.

Project: Oracle ERP Support Mar’08 - Dec\'08

Client: Confidential
Modules: PO, AP, GL

Team Size 7
Role: Designation & Description
Onsite Tech Lead.

Roles and Responsibilities

• Involving in business meetings to understand business requirements.
• Having good knowledge on SSS custom processes.
• As a tech lead - exercised activities like resource, work planning, and deliverables management.
• Involving in system design.
• Designed ISTL/XML Invoice inbound interface.
• Worked on AP and GL inbound and outbound interfaces.
• Involved in UAT process with clients.
• Attended BPEL seminars and involved in developing proof of concepts using BPEL for evaluation purpose.

Project: Oracle ERP Support Apr’07 – Mar’08

Client: Confidential, Wayne, PA
Modules: Oracle Inventory, Order-to-Cash (OM, AR), PO.

Roles and Responsibilities

• Worked as a technical consultant at client (Onsite) place
• Worked on Order Import interface to import orders (Import, Validate and Load).
• Created reports for Order Import process.
• Involved in Receivables transaction (Auto Invoice), Cash Receipt related setups.
• Worked on AR open interface to deal with Receivables transactions (invoices, Credit Memos) and customer’s data.
• Worked in AR open interface for Cash Receipts data conversion from legacy system.
• Implemented Change Requests and documenting the changes.
• Designing specifications for customisations and implementing the customisations.
• Involved in testing process during data migration.

Project Name: Oracle eBusiness Suite (Apollo) Nov’06 - Mar’07

Client Confidential
Environment Oracle ERP 11.5.9

Role: Designation & Description
Worked as a technical consultant(OBIEE) at Confidential

Responsibilities:

• Involved in proposing suitable topology which suites to client requirements
• Developed rollout strategy for complete project
• Provided Installation and configuration document for Application Server in consultation with DBAs
• Developed EUL migration strategies and assisted developers for smoother execution of project
• Proposed and implemented Materialized Views, where it had lot of summaries and pre-computations were involved.
• Provided end user training, material and hands-on sessions on new discoverer tools
• Organized UAT
• Creating Application Users and assigning various responsibilities.
• Resolving the issues raised by the client requests for ad-hoc queries and reporting.
• Designed and certain AP/PO related reports such as “Contract Savings”, “Pos raised in the period”, “Position Hierarchy report”, “Receipts Analysis”, “Analysis of Orders Invoiced”, “Canon BISG Unpaid Invoices”

Project Name: Compass- Coventry Group Limited Mar’06 – Sep’06

Client Confidential
Environment Oracle ERP 11.5.10, XML Publisher 5.6

Role: Designation & Description
Worked as a technical consultant at Confidential

Responsibilities:

• Customized Discoverer reports to suite for the new Org. structure.
• Implemented Materialized views as a measure of performance improvements in sales specific reports.
• Worked on developing Slow Moving Stock sub module to calculate provision for the slow moving stock products.
• Developed PL/SQL objects for slow moving stock.
• Successfully converted many text reports to XML Publisher reports to produce rich PDF reports as output.
• Designed and developed many XML publisher based reports.
• Developed Tax Invoice reports AR and deployed.

Project Name: Launchpad – Bunnings Dec’05 – Mar’06

Client Confidential
Environment Oracle ERP 11.5.10, BI Discoverer 6i
Role: Designation & Description
Worked as a consultant at Confidential

Responsibilities:

• Did EUL setups in various environments (UAT, Prod, and Dev etc) at client’s place.
• Worked with the Floor Managers to analyze specifications for Discoverer BI Reports.
• Defined BI Discoverer administration, controlled system access policy to developers and end users.
• Involved in Discoverer reports design and validations.
• Delivered documentation and held Technology transfer sessions to BI Discoverer developers.

Project Name: GE CFS Europe Jan’05 - Oct’05

Client Confidential
Environment Oracle ERP 11.5.8(GL, AP and PO), Forms 6i, Reports 6i, Discoverer 6i, TOAD

Role: Designation & Description
Working as a technical SPOC for Confidential
Involved in PO and AP rollout process.
Team Size 15

Responsibilities:

• Possessed good understanding of the entire Procure to Pay Process from Requisition to RFQ to Purchase Order
• Involved in defining PO setups like Financials, PO options and Receiving options.
• Involved in creation of Suppliers, Payment terms, Distribution set.
• Involved in Defining Buyers, Approved Suppliers list, Sourcing rules and Assignments.
• Developed custom Invoice interface and Suppliers Interface for AP /PO.
• Developing/customization of Reports such as EFTs, PO conversion error.
• Designing Technical specifications for Customizations.
• Designed and Developed in automation of Cross charge in GL
• Worked on Discoverer reports migration (from Discoverer 3 to 4i).
• Implemented Auto Reconciliation program for GL module.

Education:

• B.Tech
• Oracle 9i Certified Associate
• Certified Oracle e-Business Suite Technical Integration Champion