SUMMARY:

Oracle EBS Techno Functional consultant over 15 years of experience in design, development and support working on EBS R12/11i modules, blending flawless execution with technology and business process optimization skills to drive competitive business advantage. Excel at leading large global teams in disparate global applications environments. Offer proven success directing highly complex programs and projects, including large - To-Medium scale Oracle EBS Suite implementations, Upgrades and Support also Oracle EBS integrations with 3 rd party systems. Demonstrate exceptional team-building and leadership abilities, effectively communicate & collaborate with individuals from varying professional levels and cultures.

MANAGEMENT SKILLS:

• Managed/worked: in team in Multi-million dollars Oracle EBS projects in Global Delivery environments including (4) Oracle EBS full life cycle Global implementations (2) Oracle EBS Upgrades (4) Oracle EBS support
• Technology Forte: - Leading/working in high growth, complex and rapidly changing environment with enterprise vision, full lifecycle of technology initiatives, enable business transformation and establish world-class delivery organization.
• Fulllife: cycle (Order to Cash OTC, Contract to Cash, Issue to Resolution, Procure to Pay P2P) implementation cycle experience for multiple Operating Units with Oracle 11i/R12 including post implementation support.
• Extensive experience in generating and customizing Reports, building and customizing Forms, and registering concurrent programs/reports/forms in Oracle applications using AOL and system admin activities.
• Functional expertise: in EBS modules in Finance ( AP/AR/GL/TCA/PA/iExpanses), SCM (PO, OM,INV, MRP,BOM,WIP,WMS),ASCP,VCP and CRM (Service Contracts, Field Services, iStore,Email Centre, Marketing, Tele Services and Depot Repair)
• Strong Technical background: working in PO,OM,WIP,BOM,MRP,INV,AP,AR,GL,iStore and CRM Requirement, Order Confirmation and Contract Approval process, design, development and support on Oracle Apps R12/11i e Business Suite modules like iStore, PO, OM, INV,BOM,MRP,WMS,AP,AR, GL, CRM (Service Contracts, Install Base, Tele Services and Depot Repair) and Marketing modules on technologies like SQL, PL/SQL, Workflow, Oracle Forms/Reports, BI-XML reports
• Interface Development: Payable Open Interface, Supplier Open Interface, Journal Import, Customer Interface, AR Auto Invoice Interface, Item Interfaces
• Industries: Consumer Goods, Telecom, Copier, Healthcare and Banking
• Personal Skills: - Excellent Leadership, mentoring and interpersonal skills with strong functional background. Experienced with medium to large-scale enterprise software projects.
• Selfstarter, entrepreneurial, highly motivated team: player with excellent communication / problem-solving skills. Quick learning ability vis- -vis new technology. Easy adaptability to new environments.
• Experience of working in cross: cultural environment.

SKILL:

Business Processes: Procure-To-Pay, Order-To-Cash, Contract Approval Process .

Oracle EBS Suite Modules:

SCM Modules: PO/INV/OM/WIP/BOM/QP/MRP/Quoting/VCP/ASCP/iProcurement

CRM Modules: IB/Service Contracts/Field Services / Depot Repair/Teleservice/iSuppor/iStore/Email Centre /Marketing

Financials: AP/AR/GL/TCA/PA/iExpanses

Software/Languages/Tools: Oracle Discoverer, XML/BI Publisher, PL/SQL, SQL, SQL*PLUS, TOAD, PVCS

RDBMS: ORACLE 11G/10G/ 9i

RICEW: Conversion,PO/OM/INV/OKS/IB/AP/AR/GL Interfaces, Workflow, Oracle Reports,XML Reports development, Forms Development, AOL, Work Flow, Alerts.

Interface Development: Purchase Order Interface, GL Budget Interface, Purchase Order Interface Payable Open Interface, Supplier Open Interface, Journal Import, Customer Interface, AP Invoice Interface

Workflow Customization: Oracle Projects Workflow, Order Management and AP Invoice Approval Workflow

PROFESSIONAL EXPERIENCE:

Oracle EBS Solution Architect

Confidential

Environment: Oracle EBS Suite (PO,OM,INV,BOM,WIP,MRP,AP, AR, GL, iStore, Service Contracts, Install Base and Tele Services ), Power Help Tools with Cloud Technologies .

Responsibilities:

• Responsible for utilizing a formalized project management lifecycle-Interacting with business users, involves activities like requirement gathering, identifying functional and technical gaps, application design, functional /and technical specifications, configuration, module setup, programming, scheduling, documentations, test script generation, end users and production move.
• Lead all aspects of the design, development and deployment of the Oracle solution and related components (interfaces, conversions, etc.). Designed custom Billing solution for client specific. Responsible for setting the timelines, assigning project resources, and determining and managing the scope of various projects.
• Assigning work to members of different teams like Development, Functional testing, Release management, System Test and Tech Pubs at Onsite, Offshore teams and getting the work done on daily basis, reviewing them, providing guidance and suggestions as part of their improvement in terms of Technology, Process and Domain, and delivering it to Customer.
• Maintains quality service by enforcing quality and customer service standards; analyzing and resolving quality and customer service problems; identifying trends; recommending system improvements. Addressing operational problems, concerns, and questions posed by users.
• Resolving production issues using technical as well as functional expertise in Oracle SQL/PLSQL, Oracle applications
• Responsible for Building Technical design documents, Code, Unit Testing Documents.
• Performed peer reviews of Technical Designs, Code and Installation Documents.
• Responsible for building and review code Involved in design, development.
• Working towards Establishment of a communication protocol with Client (End User), with teams for timely updates, issue.
• Responsible for publishing status report to senior management from client side as well from Cognizant side.

Confidential

Oracle EBS Solution Architect

Environment: Oracle R12 EBS Suite (PO,OM,INV,BOM,WIP,AP, AR, GL, iExpense, Customer Online, iStore, Email Center, Marketing Procurement and Tele Services, IPM, Hyperion)

Responsibilities:

• Fixed production issues using technical as well as functional expertise in Oracle SQL/PLSQL, Oracle application R12
• Responsible for Building Technical design documents, Code, Unit Testing Documents.
• Performed peer reviews of Technical Designs, Code and Installation Documents.
• Responsible for building and review code Involved in design, development.
• Worked towards Establishment of a communication protocol with Client (End User), with teams for timely updates, issue.
• Responsible for publishing status report to senior management from client side as well from Cognizant side.
• Responsible for managing team from onsite side as well as grooming new resources on various modules and Oracle Apps Tools which include Oracle project Accounting, iStore, Order management process, Interfaces, Reports and Forms.
• Worked/Supported Payables Open Interface, Supplier Interfaces, Order Management Interfaces, Item Import, Journal Import, Customer and Auto Invoice interface, Design and developed program for converting SR Purge data, Designed Payable Open Interface to import invoice data from legacy system into Oracle Application
• Supported Journal Import, Customer and Auto Invoice Interface to make sure smooth processing of legacy system data into existing Oracle Application.
• Resolved many issues in iStore module and provide the support.
• Involved Testing of contract Approval process in istore and resolved many issues.
• Resolved and supported integration issues with EBS from other systems.
• Make changes into existing interfaces due to changes in existing design.
• Developed Order confirmation with email notifications
• User evaluation and support team member for User Acceptance testing
• Understand business requirement and prepare MD.070 document for enhancements to existing extensions.

Confidential

Oracle EBS Solution Architect

Environment: SCM, Finance and CRM Modules. Manufacturing, OM, Quoting, Inventory (INV), WIP, BOM, Oracle Project, Install Base, Service Contracts, Felid Service, Call Center

Responsibilities:

• Understand business requirement and prepare MD.070 document for enhancements to existing extensions.
• Requirements gathering and documentation for CCR’s
• Worked on Solution Design Document for migrate the Order Management to Service Contract
• Technical Solution design and documentation for CCR’s
• Developed Tier Pricing Form
• Worked on Quote to Contract process
• Developed Contract User provision form along with Password security management to Contract users.
• Conducted CRP sessions to show case the application capabilities in support to the business specific requirements and functions
• Studied the entire application management process and identified areas of improvement to the business process
• Gap Analysis of Tier Pricing
• Worked on Contract user provisioning
• Developed Contract user provisioning, DE dupe and tier pricing forms
• Gap Analysis on Order Management and Quoting.
• Worked on Financial modules.
• Worked in a role of techno functional consultant analysing the functional description and preparing md70 and implementing the solution for r12 RICEWF components. It requires the analysis of older functionality and feasibility of working on r12 with required changes.
• Oracle Modules setup/configuration/CRP
• Designed Technical Approach for RICE deliverable.
• User /Hyper care cutover support.

Confidential

Sr Oracle Apps- Techno Functional Consultant

Confidential, NJ

Environment: SCM and CRM Modules. Manufacturing, OM, Inventory (INV), WIP, BOM, Project Manufacturing, Warehouse Management, Install Base, Service Contracts, Felid Service, Call Center

Responsibilities:

• Performed peer reviews of Technical Designs, Code and Installation Documents. Build and review code Involved in design, development.
• Developed Interfaces to bring the data from the legacy system to Oracle Application
• Worked on Design and Development of Payable and Supplier Open Interface to bring data from old application into Oracle Application
• Understand business requirement and prepare MD.070 document for enhancements to existing extensions.
• Working on various requirements which needs enhancement to bill customers usage for more types of counter than existing Confidential Business
• Worked On Service Contracts Billing Schedule process.
• Worked on Automatic Service Contract Creation from Order management.
• Worked on Rollup Meter Reads for Fleet Contracts (Service Contracts)
• Worked Billing on Hold until all meters read are completed.
• Developed Contract Credit and Re-Bill Form
• Developed Confidential Profitability Review Forms
• Developed Confidential Delivery Confirmation Form
• Developed Profitability Discrepancies Report
• Worked on Email Meter Import Program by using PERL script for reading Billing Data.
• Confidential Today’s Revenue /Non-Revenue Sales Estimation Report
• Requirements gathering and documentation for CCR’s
• Technical Solution design and documentation for CCR’s
• Conducted CRP sessions to show case the application capabilities in support to the business specific requirements and functions
• Studied the entire application management process and identified areas of improvement to the business process

Confidential

I.T. Analyst

Environment: Oracle Applications Rel 12, 11.5.10, INV,OM, QP, IB, Service Contracts and Depot Repair Oracle 9i/10g, Forms 6i/10g, SQL*Loader, Reports 6i/10g, TOAD, SSH Secure Shell, Kintana - Code Migration Tool, QC for Testing Tool.

Responsibilities:

• As part of BTS team, we receive new enhancement requests and system defects reported by users.
• Analyze/Research the defects and provide effective solutions (root cause and key technical inputs) to the BTS Team.
• Conduct a thorough impact analysis for new enhancements on the existing system
• Provide Functional Specifications and Techno functional document on Components.
• Leading/Mentoring the BTS during development
• Developed Serial number Search Form from Scratch and done the Form personalization for opening from different modules.
• Enhanced Delivery Confirmation Form and done the form personalization for opening from Order Management (OM) Module.
• Developed Repair processing form
• Enhanced Motorola Mobility process remittance Creation Program (EDI) for USA according to business requirements (related to Verizon, RNT and RL data loaded into Interface tables .
• Enhanced Process of Mass loader program with Item, IB, Fedex and Customer Validation
• Developed a Cust Web loader Program for Crating Service Request and Repair Order by using Verizon, RNT and RL Data based on Serial number and RMA.
• Enhanced to check the warranty details of devices on particular customers.
• Enhanced Motorola BTS service Contract creations and warranty details.
• Enhanced Repair Processing and validate on devices.
• Enhanced on Receiving, Update and Shipment process with several business scenarios.
• Developed a new Mass loader Concurrent programs for loading data on schedule bases into Interfaces tables with request set .
• Developed a new Cust Web loader Program for creating SR and RO .
• Provided Functional Specifications and Technical assistance (scripts) for the new report ‘FedEx Label Report’ .This report is used to take the print outs of Labels .
• Enhanced Packing Slip Report.
• Developed Traveler Report.
• Provided Functional Specifications for the Motorola BTS 2.1 releases.
• Provided Functional Specifications for the new reports as part of Motorola BTS releases.
• Provided Functional Specifications for the new forms and Interfaces as part of Motorola BTS releases.
• Trained support and Business teams on enhancements.
• Provided IT support to Biz team during UAT Testing.
• Involved in Assembly Testing on End to End process and updated test cases in QC.
• Support to Business users while during UAT.
• Worked on Service Contracts and Install Base Conversions.
• Worked on Automatic Service Request Creation through mail.

Confidential, NY

Oracle EBS Solution Architect

Environment: .Oracle Application 11.5.10, SQL, PL/SQL, Toad, Oracle10g, Accounts Receivables (AR),Account Payables (AP), Purchase Order (PO), Order Management (OM) and Inventory (INV),Service Contract(OKS),Field Service(CSC),Bill of Material(BOM),Install Base(IB),Fixed Assets(FA) modules

Responsibilities:

• Initiating Monthly Integration calls with clients and other coordinating teams
• Preparing Year End Closing Letter.
• Performed the performance tuning on Daily Invoices and PAID programs.
• Developed New Cash Requirement Report which in turn sends an email to the business users.
• Developed new custom OAF pages for Vendor Terms approvals.
• Coordinating the Month/Year End closing schedules with Business and processing teams.
• Customized the 1099 report as per business requirements.
• Tuning the Oracle reports which really impacted the business in monthly closing.
• Helping out in submitting the 1099 reporting to IRS
• Creating the Alerts on Business critical programs.
• Having control on Business critical Scheduled Concurrent Jobs.
• Scheduling Concurrent requests/request sets whenever there is any schedule change.
• Managing the Instance Outage windows with proper sanity checks.
• Coordinating with Oracle on Standard AP issues.
• Initiating weekly SR meetings with Oracle to escalate the high priority issues.
• Explaining the action items to the offshore team
• Helping in closing related critical issues.
• Guiding team time to time whenever it is required and helping them out in case of any issue/bug
• Interacting directly to client by conf. call and Web-ex meeting.
• Taking the ownership of any object where it is required.
• Taking ownership of team objects during rollout when issue or bug was on higher priority.
• Providing guidance to the team in components like Extensive usage of XML publisher.
• Helping to the project team while Data Migration for AP invoices.
• Worked on Major Enhancements
• Working on oracle alerts to make sure the failed scheduled jobs have been re-scheduled in time.
• Created Request Set for AP invoice Interface program as well as adding one custom program.
• Working on enhancement on some existing objects.
• Working experience on KOFAX business priority issues
• Key data inputs for Automatic Contract Creation Form.
• Developed Delivery confirmation form
• Developed on Mass update price Form
• Worked on Price Indexation Programs and Form
• Updating the warehouse Information
• Worked on Billing Schedule update program for contracts.
• Developed Service Contract Creation with warranty details.
• Review the packages contents and ensure that change has properly done as per requested, tested and documented
• Worked on Dock Assignment Report
• Worked on Customer Change Requests
• Check in the code into RCSMENU if the migration involves a file based object
• Review the contents of the package to ensure that they fit the bug/release and are appropriate for migration to the next environment
• Review the package contents and ensure that change has properly requested, tested and documented
• Coordinate with Onsite team and offshore team.
• Develop, perform, and code review and customization according to the business requirements.
• Design and Development of the ERP (OM, PUR, AP, AR) Interfaces between legacy and oracle Applications.
• Gathered and analyzed the business requirements, Process Mapping and carried out gap analysis
• Responsible for implementing Order Management, Inventory and Procure to pay cycle
• Implemented Approval Hierarchy and Employee/Supervisor relationship for approval of PO
• Defined transaction types, order modifiers and price lists
• Defined shipping parameters, picking rules and credit check rules
• Maintained physical inventory procedures for inventory and sub-inventory locations
• Build Technical design documents, Unit Testing Documents.

Confidential

Environment: Accounts Receivables (AR), Purchase Order (PO), Order Management (OM) and Inventory (INV), Bill of Material (BOM)

Responsibilities:

• Modified existing custom LPN receiving process
• Developed a form for scheduling delivery and trip creation
• Developed a concurrent program to create deliveries and Trips automatically using standard Oracle Load Truck and Unload Truck functionality
• Developed an Error report for failed assignment of deliveries and trips
• Developed a concurrent program to purge error records
• Developed a custom BOL (Bills Of Lading) form to show all open Trips, assign them to trailers and finally create stops
• Developed Master and Customer Bill of Lading reports for each Trailer and stop respectively.
• Creation of Proof Of Concept and Impact analysis for new customizations
• Responsible for getting the required approval for the requirements for the stakeholders and starting the development.
• Working on customizations requested by the business
• Developing PL/SQL packages, functions and procedures as per the requirements.
• Creation of Unit test plans for the business.
• Creating technical documents like System Design documents.
• Responsible for testing of the code and creation of the move sheet to move the code to QA environment for business testing.
• Responsible for implementation of new enhancements requested by the business
• Creating whitepapers for the requirements and providing walkthrough sessions for business.
• Resolving issues faced by the users while testing in Development and QA instances
• Providing burn-in support for the changes and enhancements in production for 3 months and resolve productions issues that user faces during this time.

Confidential

Environment: Accounts Receivables (AR),, Purchase Order (PO), Order Management (OM) and Inventory (INV),Service Contract(OKS),Field Service(CSC),Bill of Material(BOM),Install Base(IB),Fixed Assets(FA) modules.

Responsibilities:

• Worked on EDI Order Import & Scheduling (Order Booking, Hold and Notify to the customer)
• Updating the Customer Details
• EDI Price validation
• Updating the warehouse Information
• Worked on Auto create delivery
• Handling the trouble tickets providing solution to the unicenter helpdesk calls raised by clients resolving the issues and escalating as per the procedures defined by the action plan.
• Check in the code into PVCS if the migration involves a file based object
• Check in the code into PVCS if the migration involves a file based object
• Creating a package through Kintana using the Dynamic Workflow
• Review the contents of the package to ensure that they fit the bug/release and are appropriate for migration to the next environment
• Review the package the package contents and ensure that change has properly requested, tested and documented
• Performed by SCM within the Linksys Dynamic Workflow. The DBAs will perform migration to secured environment such as PROD
• Developed scripts to validate the data and load Customers, address, contacts, profiles, banks and Payment methods information into the interface table as part of the conversion process.
• Developed scripts to validate the data and load the items in INV module as part of the conversion process.
• Registered Forms and defined Menus & attached to various Responsibilities.
• Registered concurrent programs (including Reports, PL/SQL procedures).
• Provided production support for SCM modules PO, OM, INV and also worked on AP and GL as part of the production support.