SUMMARY: 

• Thirteen years of Techno - Functional expertise in Oracle Applications Development, Production Support, Enhancements, and Upgrading Oracle EBS 11i / R12 applications from end to end deployment and testing.
• Proficiency in Warehouse Management System (WMS), Supply Chain Management (SCM) including Order Management (OM), Shipping (WSH) and Inventory (INV), Oracle Applications Financials (AP, AR & GL), Approval Management Engine (AME), self-service modules (iExpense and iProcurement).
• Expertise in SCM domain and laying out Blue prints for complex EBS solutions.
• Sound knowledge of O2C and P2P cycles with data flows.
• Extensive hands-on experience in Oracle PL/SQL - APIs, Packages, Procedures, Functions, Sequences, SQL Loader, and other SQL and PL/SQL components
• Building custom Oracle Workflows and standard Customization as per client requirements
• Strong expertise in Oracle Applications Framework (OAF) - building medium to complex pages from scratch and OAF customizations.
• Strong expertise in XML Publisher Reports (BI Publisher) with Advance features - building custom reports from scratch, reports conversion from Oracle Reports to XML with advanced features like Bursting, Matrix reports, PLSQL based XML generations, translations etc.
• Worked on Documentation using AIM methodology for Business Requirements Setups (BR100), Functional Design Documents (MD50), Technical Design Documents (MD70), Conversion Mappings (CV40), and Conversion Test Plans (CV70)
• Experience in interacting with client/business and building the business requirements. Proficient in analyzing and translating business requirements to technical requirements and architecture the solution.
• Experience in effectively managing remote and local development team and providing leadership and direction with effective interpersonal and team building skills.

TECHNICAL SKILLS:

ERP: Oracle E-Business Suite (11.5.10, 12.1.3)

Work Areas: SQL, PL/SQL, XML Publisher, Unix Shell Scripting, Java, Oracle Applications Framework (OAF), Forms 6i/10g, Reports 6i/10g, Oracle BI Publisher, Discoverer 9i/10g, MSCA MWA Telnet Screen Development, Oracle Work Flow Builder, Oracle Fusion Middleware basics (SOA, BPEL)

Modules: Warehouse Management System (WMS), Supply Chain Management (SCM) with OM, Shipping (WSH), Inventory (INV), Service Contract with some exposure to WIP and BOM; Oracle Applications Financials Account Receivables (AR), Account Payables (AP), General Ledger (GL), Cash Management (CE), Purchasing (PO); Self Service modules iExpense, iProcurement, Approval management Engine (AME), Tech stack modules AOL, FND, AD, Workflow

Database: Oracle 9i/10g/11g

Languages: SQL, PL/SQL, UNIX, Shell Scripting, Java

Reporting Tools: BI Publisher Desktop, Developer suite 10g, Oracle Discoverer

Tools and Utilities: TOAD, SQL Loader, SQL Developer, FileZilla (FTP), JDeveloper 11g, WinScp, STAT, Subversion.

Operating Platforms: Linux, Windows 2003, MS-DOS, 

PROFESSIONAL EXPERIENCE:  

Confidential, San Jose, CA

Lead Oracle EBS Technical Consultant

Responsibilities:

• Liaise between vendors and internal Project teams for business/Technical requirements.
• Leading solution design for Supply chain and GTM modules.
• Preparing high level and detail design document.
• Coordinated with the infrastructure and DBA team on the instance strategy, instance planning, clone and refresh for development and various test execution cycles
• Data Migration for Item Master, Customer, Supplier, Open Requisitions, Purchase Orders, and Blanket Purchase Agreements.
• Implementation of GTM (Global trade Management) for Sales Order screening, Delivery Screening, Party synchronization, and Item synchronization. Oracle uses XML Gateway to integrate EBS with GTM. This implementation is done with the focus of keeping the architecture fusion ready and integration between GTM and EBS was done using SOA instead of XML Gateway.
• Creation of custom form to handle the Cavium custom Picking to Shipping process.
• Order Management, Requisition, Account Generator workflow customizations.
• Automation of complete O2C cycle using PL/SQL APIs.
• Application, invoice interfaces - inbound and outbound between EBS instances.
• Worked on Oracle Application Framework(OAF) - creation of new pages (UI), personalization and extension of seeded pages.
• Technical Lead on divestiture engagements involving segregation of data through configuration and performing master and transactional data conversions. Lead and design & build effort for the conversions which include - Customers, Supplier/Sites/Banks, Blanket Purchase Agreement, IR/ISO, etc.
• Resolve issues identified during System Integration Testing, User Acceptance testing by working with the business and IT SME’s.
• Responsible for coordinating on various issues with Oracle through SR’s.

Environment: Oracle EBS 11.5.10.2, R12.1.3, BI Publisher, OAF, SQL, PL/SQL, XML, Workflow, Forms, Reports etc.

Confidential, Kalamazoo, MI

Senior Oracle EBS Technical Consultant

Responsibilities:

• Performed all the setups for OM, Shipping and Advance Pricing, AR, INV modules.
• Flow Testing for SCM Modules (AR, AP, OM, WSH, QP, BOM, INV, PO) to make sure flow is working without any issues.
• Automation for O2C and integration with third party systems.
• AME integration with iProcurement and iExpense. AME setup for iExpense and iProcurement applications. Approval process setup by defining / modifying Attributes, Conditions, Actions, Approval Groups, and Rules.
• Worked extensively on understanding the proposed 100% customized business logic of the Business in building the customized solutions for Shipping on OA framework Technology based on the legacy of Oracle application E-business suite 11.5.10. All the above bases business logic was captured in OA Framework code.
• Design & customization, RDF and XML Publisher Reports, Oracle Workflows, Form Personalization’s and OAF.
• Analyzed the custom code components in proc to pay process and retrofitted custom PL/SQL Packages, Reports, Forms, and Workflows to make them work in R12. Personalization and Extension of OAF pages in various modules.
• Created multiple Complex OAF Pages for Purchasing, Order Management, and iExpense which included Partial page rendering functionality
• Lead a team of OAF developers and workflow consultants to accomplish the custom module development in time
• Baselined technical design and migration documents for OAF.
• Created a custom application from scratch using oracle OAF (Query Bean, Create Page - Tables, Advanced Tables, Shuttles, Invoking DB procedures/API’s and workflows etc.)
• Worked on enhancement of seeded iExpense OAF pages like modification of LOVs for fetching the data from third party systems by calling the webservices, adding the custom regions and enabling partial page rendering at multiple levels, extending the VO, creation of validation view object, adding Entity expert to the standard EO.
• With Acquisition of Berchold by Stryker communications, it is required to gain operational efficiencies by moving both the organization on same CRM, ERP and Quality systems. Bright 2.0 program is responsible for process mappings, application integrations, infrastructure setups and implementing quality control procedures as per Stryker standards.
• Implemented changes to send pick tickets from the OE/OM module (based on the delivery shipping model; WSH) to a vendor’s warehouse management system (WMS). Extensive architectural changes and enhanced error checking. Also enhanced the custom ship confirmation process which takes ship confirmations from the vendor’s WMS, and loads them into the standard Oracle Applications interface tables (Open Shipping Interface) so the data can be populated (via the standard Oracle API) into the OE.
• Understanding complex business requirements and processes and liaising between Business Analyst / External Partners and development team.
• Spearheaded functional training on Order-to-Cash for technical team and technical trainings on OAF and Java for Stryker Global IT team.
• Order Management O2C (Order to cash) end-to-end cycle using API as Shipping is being done from legacy systems.
• Order Management and Purchasing enhancement for integrating it with Third Party Logistics information systems.
• The Returns feature in Oracle Receiving does not provide the flexibility to track the returns. The Business process requires Return to Vendor functionality to provide an efficient method of controlling the return and exchange of items bought from suppliers, ensuring visibility and tracking of the item until the transaction is concluded.
• Kit Cross Docking project to automate many parts of the processing of Affiliate packaged Kits containing multiple saleable SKU. A custom OAF page was developed in which unique Kit ID and detailed component data get housed. Users can view Kit ID data and Receive, Put Away, Pick and Ship Kits at a Kit ID Summary Level. By updating the form at the Kit ID level, an automation of all Kit component transactions take place.
• Oracle ERP R12 implementation for Stryker Canada & Japan.
• Implementation of Mobile van inventory concept, for Stryker COM Division, for the service and repair business. This allows technicians immediate response capabilities as opposed to waiting on the delivery of parts prior to going onsite, hence reducing CPR from 9 days to 3 days. The objective of the project was to implement the customer and replenishment cycles in Oracle EBS.
• Order Management, Requisition, Account Generator workflow customizations.
• Liaise between vendors and internal Project teams for business/Technical requirements.
• Leading solution design for Oracle Manufacturing, Purchasing and Supply chain modules.
• Preparing high level and detail design document.

Environment: Oracle EBS 11.5.10.2, R12.1.3, BI Publisher, Oracle forms, reports, Discoverer, OAF, SQL, PL/SQL and XML, Workflow, STAT, ITG Subversion.

Confidential

Lead Oracle EBS Technical Consultant

Responsibilities:

• Engage with customer to gather requirements, analyze, and design business solutions.
• Spearhead functional and technical training in Oracle HRMS to customer HRMS team.
• Design and develop automated solution for Internal Promotion Process to streamline the process from internal vacancy creation to final selection, with the capability to modify the business rules (as promotion rules are governed by central government of India and changes very frequently). It will reduce the promotion cycle time from 2 months to 20 days.
• Preparing high level and detail design document.
• Optimization and Performance tuning of the developed codes.
• Code Review, Testing, and Effort estimation for the enhancement requests.
• Developing XML Publisher Reports, D2K Reports, Form Customization and Personalization, and Interfaces.

Environment: Oracle EBS 11.5.10.2, BI Publisher, Oracle Reports, Oracle Forms, SQL, PL/SQL and Oracle Workflow.

Confidential

 Lead Oracle EBS Technical Consultant

Responsibilities:

• Deliver and implement the project as per schedule timelines.
• Business requirement gathering.
• Conduct current business study, identify gaps, and map processes.
• Design various customizations on Account Payables, Fixed Assets, and Purchasing modules.
• Mentor and monitor offshore team.
• Design, develop, and test conversions to migrate data from Legacy system to Oracle.
• Implement and integrate AME (Approval Management Engine) with iExpense module.
• Create customized workflows and modifying oracle seeded workflows.
• Prepare 30+ XML Publisher reports on Payable, Purchasing, and Fixed Assets modules.

Environment: Oracle EBS 12.1.3, Oracle Forms, Oracle Reports, XML Publisher, Oracle 10g, PL/SQL, SQL Developer, Oracle Workflow, Putty etc.

Confidential

Senior Oracle Apps Technical Consultant

Responsibilities:

• Acted as onsite coordinator for client MDS Inc. (Canada) with primary responsibility of understanding the business processes, gathering the requirements by conducting discussions/meetings, and performing feasibility study. It also involves the onsite-offshore coordination, issue resolution, functional design and technical design discussions, and working parallel on the requirements.
• Confirm quality standard of ERP Application Maintenance and enhancement, and interaction with internal quality team.
• Part of the design review teams.
• Work on Effort estimation
• Work on consolidated project plans.
• Prepare MD050 (Functional), MD070 (Technical) documents for business requirements.
• Review documents and deliverables.
• Analyze business processes, requirements, and provide feasible solutions and prepare high level and low-level solution design.
• Work as Techno-Functional consultant for Oracle Apps ERP.
• Maintain version control and details of deliverables for team in RPM (Rational Portfolio Manager). Fetch matrices from RPM, analyze for any deviation and to take preventive action. Showcase the matrices to all the stakeholders.
• Mentor the team members.
• Streamline Intercompany process and prepare multiple dashboards on intercompany transaction details.
• Design and develop multiple conversions, reports, interfaces on Financials and SCM modules.
• Create new workflows and customize oracle seeded workflows.

Environment: Oracle Applications 11i, SQL PLSQL, Oracle forms, reports, XML Publisher, Unix Scripting etc.

Confidential, Boston, MA

Senior Oracle Apps Technical Consultant

Responsibilities:

• Played a key role as P2P Track Lead and managing a team of 5 people for in-house implementation and support of Oracle Financials and Self-Service modules.
• Handled weekly status calls with the top management viz Finance Directors, Procurement Directors. And, handled internal SOX auditing with external vendors PWC and KPMG.
• Prototyper, System Administrator, System developer, Technical Analyst in Sapient’s EA.
• Implement AP, AR, GL, PA, iExpense, and iProcurement.
• Integrate AME (Approval Management Engine) with iExpense and iProcurement.
• Lead a P2P team.
• Module Integration (HRIS - HRMS and Oracle AP to Self Service applications).
• Design and develop Standard and Technical documentation and provide user trainings.
• Personalize and customize OAF pages and D2K Forms as per the business requirements.
• Migrating AP, PA, and HRMS data from legacy system to Oracle Apps.
• Identify process gaps and design the system to streamline the processes.
• Prepare dashboard for Expense Payment cycle that reduced the cycle time from 40 days to 5 days.
• Handle weekly status calls with the top management viz Finance Directors, Procurement Directors.
• Technical Queries/Forms Customization, new Reports etc.
• India/US/Canada/Germany Localization issues solving in HRMS and Financials
• Administration of REMEDY HELP DESK SEVERITY 1 -Tickets from entire ORACLE Financials Community: HAVE a 100% timely solution.
• Handling Internal SOX auditing with external vendors like PWC and KPMG.
• Help Entire EA team for SOX Compliance processes.
• Sound Integration with US (Cambridge) ORACLE Finance team for smooth running of Oracle APPS

Environment: Oracle Applications 11.5.10, Oracle Forms 6i, Reports 6i, Oracle 9i, PL/SQL, TOAD, Workflow, OAF, etc.

Confidential, St. Louis, MO

Oracle Apps Technical Consultant

Responsibilities:

• Implement Account Payables, Account Receivables, Project Accounting, and Oracle Incentives and Compensation in multiple organizations.
• Work as a Configuration Controller for the project
• Work as Techno-functional for Oracle Apps ERP
• Code Review, Testing, and Effort estimation for the enhancement requests.
• Develop Conversions, Interfaces, Reports, PLSQL Packages and enhancing the Oracle standard ones as per client requirements.
• Performance Tuning of existing code. Handled 50+ components for tuning and in most cases reduced the execution time from 1 hour to less than 3 minutes.

Environment: Oracle Applications 11.5.10, Oracle Forms 6i, Reports 6i, Oracle 9i, PL/SQL, TOAD, Workflow, Putty, UNIX Scripting, Discoverer, etc.