SUMMARY

• Has over 12 years of progressive experience in Implementations, Modernization, Change Management and Migration and Support of Oracle Apps ERP systems with very strong exposure in areas such
• AR, AP, GL, Payments, Cash Management, Project Costing and Billing, Advanced Pricing, Order Management, Inventory, Integrated SOA Gateway, SLA, Account Generators, Integration of EB - Tax with Vertex both technically and functionally
• Oracle E-Business Suite 12 Financial Management Certified Implementation Specialist: Oracle Receivables
• Trained on Oracle Fusion Financials and Project Portfolio Management Cloud
• He has vast experience in design, development and testing of components such as Sql and Pl/sql programs, Oracle Workflows, Webservices using Integrated SOA Gateway, XML, Extensions, D2K Reports and BI Publisher/XMLP Reports, Interfaces and Conversions, Hyperion Essbase and Interactive Reporting Tools.
• Exposure to R12 Financial Applications concepts like Accounting Setup Manager, Sub Ledger Accounting (SLA), Multi-org Access Control (MOAC) etc.
• Well versed in Oracle AIM methodology and in writing documents like, RD20, BP80, BR100, MD50, MD070, MD120, MD200, TE20 and TE40
• He has vast experience interacting with the end-users, consultants and other Stakeholders of the project for requirement gathering, implementation, development, testing and support.
• He has over 5 years of consulting experience from Deloitte Consulting
• Being an Oracle SME or Techno-Functional Lead involved in Oracle ERP Implementations, Upgrades, Scoping, Resource planning, GAP Analysis, Effort Estimation, Application Development, Integration Testing, Post-Implementation Support and End-User Handholding and Training
• In his current role he is Onsite Project Lead supporting R12 across modules like AR, AP, PA and CM
• In his previous role he worked as Functional Consultant on an R12.2 upgrade project for Harvard Pilgrim Healthcare, an Insurance provider
• In his earlier role at Dell Services he led a team of 12 individuals working on Implementation of AR, OM and EB-Tax integration with Vertex for Owens and Minor. These involved gathering requirements for solution-ing, delivering proof of concepts, designing, developing and testing several interfaces using Pl/sql and Integrated SOA gateway which provided a communication channel for integration with several non-Oracle systems. In his earlier role he lead 12 individuals with experience ranging from 2 7 years for an R12 Upgrade Project which involved upgrading 1000+ RICEFW objects from 11.5.10 to R12. He has been appreciated for recommending Best practices and aligning the team for following the same which has driven efficiency
• In his recent role at Deloitte he led a team of 6 Consultants from Offshore who were part of Sherwin Williams Global Implementation of Oracle Release 12. He has been the key member in designing and developing Interfaces and Conversions Strategy

TECHNICAL SKILLS

Softwares/Products: Toad, Oracle Reports 10G, BI/XML Publisher, Oracle Workflow Builder, Oracle JDeveloper, SOAP UI, Fiddler, Hyperion Interactive Reporting Tool, MS Office tools like, Project, Excel, Word, PowerPoint and Visio, Edit Plus, Textpad, etc.

PROFESSIONAL EXPERIENCE

Confidential

Project Lead/Onsite Lead

Responsibilities:

• Gathering and analyzing requirements and working on providing optimal solutions both technically and functionally
• Preparing MD050s for the identified Gaps, Testing the objects built, Creating BR100s for configuration changes
• Conducting CRPs with Client Users and capturing the feedbacks to identify gaps
• Doing a feasibility study of various Business requirements thru’ proof of concepts and coming up with best approaches for implementing the same
• Providing support for ongoing issues and recommending and providing solutions to fix root causes

Confidential

Project Lead

Responsibilities:

• Responsibilities Similar to the above project
• Incorporating Pricing requirements of various products using R12.2 Advanced Pricing

Confidential

Project Lead

Responsibilities:

• Gathering and Analyzing requirements and working on providing optimal solutions both technically and functionally
• Doing a feasibility study of various Business requirements thru’ proof of concepts and coming up with best approaches for implementing the same
• Writing MD050s, MD070s and TE020s
• Developing Custom WebServices using Pl/Sql and exposing them using “Integrated SOA Gateway”, Customizing Workflows and leveraging Form Personalization for calling the Webservices from Order Entry Screen
• Estimating the efforts required in developing the programs
• Leading a team of 12 consultants for designing and developing conversions, interfaces and reports, for customizing workflows and developing custom Business event subscriptions required for the integration
• Won Silver Award for Outstanding commitment showed in developing proof of concepts using custom webservices
• Testing Webservices using SOAP UI and Fiddler

Confidential

Oracle Senior Consultant

Responsibilities:

• Leading the team Assessing 1000+ RICEW objects that were present in the Clients existing 11i Instance
• This project being only 2nd Upgrade project delivered by the Practice, Developing best practices for efficient execution of Assessment, Upgrade and Testing cycles
• Scoping and Estimating the efforts required in upgrading the same to R12
• Functional testing of various objects in AP and AR
• Leading the team for Upgrading and Testing the objects to be compatible on R12
• Identifying the reports which would need to be re-built as per the enhanced features in R12 and driving the development of the same especially AP Check Printing and other R12 specific changes in AP

Confidential

Oracle Senior Consultant

Responsibilities:

• Leading a team of 6 consultants, coordinating and tracking their work end to end till it’s delivery and testing post delivery
• Status reporting to Onsite Senior Manager
• Sanity checking, Unit and Integration Testing and reviewing all the objects delivered from the Off-shore team members
• End-to-end design and development of Interfaces, Conversions and Extensions
• Developing “FTP and Interface Strategy” for Interfaces and working on developing the common programs for the same which were reused by all the team members
• Allocating the objects amongst the team members, communicating risks associated to Senior Management at appropriate times ensuring no impact on Deliverables and their timelines
• Developing several Conversions and Interfaces like Inventory Items, Routings, Stock Locators and Purchase Orders and promoting the Code using Kintana

Confidential

Business Analyst/ Oracle SME

Responsibilities:

• Being Onsite Coordinator understanding requirements from the Client’s Business Users
• Coordinating between Business Users and Technical resources working on Discoverer RC and Hyperion Essbase reports for gathering change request details, analyzing the requirement and studying feasibility
• Objects involved GL Interface program, Trial Balance, Daily Rates and Ledger Summary Reports
• Functional Unit Testing, Creating Test Scripts along with relevant Test Cases, Defects management and resolution, preparing training material for End User Training and handholding

Confidential

Oracle Consultant

Responsibilities:

• Coordinating with the Onsite Functional Team and Manager for requirements gathering and Issue resolutions related to various Project activities
• Develop customized AR BI Publisher reports using standalone Oracle BI Publisher tool for the Organization setup changes to be taken up so the new reports would be aligned to changed Organization Structure
• Working with Client team for knowledge sharing of the existing system and modifying the reports for the new Org structure, fine tuning and performance tuning the underlying code and resolving any existing issues

Confidential

Oracle Consultant

Responsibilities:

• Coordinate with onsite Functional counterpart and help a Junior Colleague in delivering the objects assigned to him. Developing Pl/Sql Programs for Advanced Pricing, AR and Service Module related objects.
• Developing extension programs which were used by custom Pricing attributes
• Extension program for Distance based calculation of Transportation cost given a set of ship-from and ship-to addresses along with their geographic co-ordinates. This involved complex programs extending the features of Advanced Pricing
• Developing plsql interfaces and BI Publisher reports
• Customizing account generator workflow

Confidential

Oracle Developer

Responsibilities:

• Gathering high-level requirements from Business users
• Translating the high-level requirements to details design documents line MD050 and MD070
• Developing Pl/Sql Programs for Inbound and Outbound interfaces needed in implementing Payroll module.

Confidential

Oracle Consultant

Responsibilities:

• Coordinate and Communicate with the Functional team at onsite for design, development, integration, testing and delivery of various objects using the Deloitte best Practices
• Implementing an Extension for optimally loading the Items on Sales Order Lines into Skids (packages or boxes)
• Design and Development of Complex Extensions for Effective Utilization of the Packaging material used of packing the various products sold by the Producer which was integrated with the Order Management system. This is helping save cost to the Company in a big way.
• Involved in coordinating the implementation of the Skid form and Exception report which were integral parts of the Skid functionality.
• Developing Oracle report which shows Scheduling of WIP Jobs against BOM resources in 3 different formats or layouts.
• Developing an Extension for updating the BOM material or item with the total of the weights of the components.
• Developing an XMLP Report to show the Performance history of all the AR Salesmen defined, against the Objectives set for each of them.
• Implementing an Extension to apply multiple types of Discounts and Adjustments on the AR Invoices against Customers with an EDI Location set and developing an XMLP report to show the discounts applied against each of such Customers
• Involved in customizing the standard EDI Outbound process for splitting the Invoice lines to be sent to the Customers based on the Zoom lines against the respective Orders
• Fixing the issues related to Conversion on BOD
• Interacting and coordinating with Onsite Resources in implementing and developing all the objects mentioned
• Involved in fixing the issues related to all these objects and making sure of their smooth delivery and migration
• Participated in the Post Go-Live support by making the needed changes in the objects mentioned and in the objects around them like EDI Interface Outbound
• Was awarded “Applause award” for developing very complex and critical extensions in the project

Confidential

Oracle Consultant

Responsibilities:

• Requirement gathering from the users, Development of the Objects and testing of the same to prepare them for delivery. Coordination with a Consultant and a Fresher in making sure of successful delivery of the objects assigned to them on time and as per the 6 sigma standards
• Implementation of Interfaces for Requisitions, POs, Receipts and AP Invoices
• Customization of PO Creation Workflow as a part of the requirement for updating the source of the Requisitions imported.
• Creation of Pl/Sql Reports for Requisition, PO and Receipts extract to be outbound.
• Gathering requirement for Charge Account Generator based on the Project Numbers entered while creating the Requisitions and customizing account generator workflow for fulfilling the same.

Confidential

Oracle Consultant

Responsibilities:

• Customizing the Requisition Approval and PO Approval Workflow for one of the Businesses as a part of AP Integration for identifying Charge Accounts from a particular Business.
• Customizing Requisition and PO Workflows and Reports. Learnt Workflows with minimal assistance given by the Team members. Handling the Technical issues related to workflows
• Got a “Silver Award” for solving a Business Critical Issue within a day.
• Handling Technical issues related to workflows and Reports as the Project was in enhancement phase.
• Testing Business Specific Workflow Customizations when the Applications were upgraded from version 11.5.9 to 11.5.10