SUMMARY:

• 16 years of expertise in Oracle E - Business Suite (11i, R12) wifin Financials and Supply Chain Management as a Techno-Functional consultant in a variety of engagements including implementation, upgrade, rollouts, maintenance, and support in large global fortune 500 organizations. Worked in five full life cycle implementations.
• Experience in managing all aspects of ERP implementation and Support projects, including business process analysis, requirements gathering, fit-gap analysis, configuration, RICE /CEMLI object design and development, Conversion, third party software integration wif oracle applications, integration testing, UAT, user, functional testing and post implementation hypercare.
• Expertise in Oracle SCM (Inventory, Order Management, Shipping, Purchasing, iprocurement, WMS), Finance (General Ledger, Financial Accounting Hub, Receivables, Payables) and manufacturing (WIP) modules. Exposure to Pricing, Oracle Product Data Hub, ASCP.
• Specialization in Order to Cash and Procure to pay business cycles wif strong functional exposure.
• Experience in creating Oracle Unified Method (OUM) documents like MC050, AN100, DS140 design documents and Testing Documents like TE20, TE40 and IM090 installation documents etc.
• Technical expertise includes Oracle application technical architecture, SQL, PL/SQL, API development, SQL Tuning, XML Publisher, Oracle Forms 10g, Oracle Reports 10g, SQL* Loader, Web ADI, Alerts and FNDLOAD. Exposure to OAF and workflows.
• Experience inbuilding integrations between on-cloud and on-premise applications using Oracle Integrated Cloud Service (ICS) for real time order placement.
• Strong working noledge of API testing tools like Postman and SOAPUI
• Experience in working wif Oracle e-business suite REST web services through Integrated SOA Gateway. Experience using XSDs and REST to develop Web Services working wif JSON-based payloads.
• Proficient in both waterfall and Agile project management methodologies in CMMi-5 environment
• Ability to prioritize business needs wif project timelines and recommend best course of action.
• Strong business communication and Customer management skills. A team player, quick learner and self- motivated

TECHNICAL SKILLS:

Software Products: Oracle E-Business Suite ERP R12/11i (GL, FAH, AR, AP, INV, OM, PO, iprocurement, WMS,ASCP, AOL), Oracle Service cloud(CX), ClearOrbit Gemini, i2 Demand Fulfillment, Factory Planning

Oracle Tools & Technologies: Web ADI, XML Publisher, FNDLOAD, SQL * Loader, Forms 10g, Reports 10gOracle Alert, Workflow, Integrated SOA Gateway, Form Personalization, SQL Developer, TOAD, SQL Navigator, Oracle Integration cloud services, Oracle API Platform cloud service, apiary

Languages: SQL, PL/SQL, XML, UNIX shell scripting

RDBMS: Oracle 12C/11g/10g, MySQL 5.0

Version Control System: WinCVS, PVCS, Harvest, GitHub

Build Tools: Anthilpro 3.8, uDeploy

API Test tools: SoapUI, Postman

Other Tools & Technologies: Putty, WinScp, SharePoint, JIRA, Confluence, HP-QC, MS Project, Visio, REST WebServices, YAML, JSON, Textpad, Notepad++, Tivoli Workflow Scheduler, Autosys, HP Service Desk, Google Suite, Remedy 4.0, Jasper Reports

Operating System: Windows XP/2000/NT, Linux, UNIX

PROFESSIONAL EXPERIENCE:

Sr. Oracle EBS SCM Techno-Functional Consultant

Confidential

Responsibilities:

• Solution Design of integrations/interfaces between Oracle service cloud (CX application) and oracle E-Business Suite application enhancing the customer support journey covering O2C processes.
• Setups and MC050 document: WMS and INV Picking rule for FEFO, Pick release rule, pick release sequence rule, RMA orders processing constraints, Internal Sales order, New Holds creation, Pricing modifiers, lookups, order line additional attribute Descriptive flex field to capture DHL shipping information, Inventory Parameters, Transaction Type
• Lead a team to develop EBS APIs and publishing those as REST web services through oracle EBS Integrated SOA gateway for sales order flow from Oracle service cloud to Oracle EBS.
• Documented Functional Specification (AN100) for multiple CEMLIs
• API design and development of End-to-End interfaces using Oracle ICS for an online self-service portal for Clinigen end customers to place orders which flows through oracle service cloud and oracle EBS.
• REST API Design and documentation using swagger/YAML through apiary. Publishing the API definitions through Oracle API Platform service cloud.
• Testing APIs wif JSON-based payloads in postman and SoapUI including building Postman test scripts
• Working wif oracle Service Requests. Providing analyzers and testing patches.
• System Integration Testing and UAT Support. Functional testing and TE040 documentation.
• SQL, PL/SQL development, Web-ADI development for iprocurement expense receipt
• APIs: On hand quantity API, Create and book order, Holds Apply, reservations
• Reports design- Commercial invoice report as part of the print ship document
• Order line form personalization to populate warehouse based on shipping address
• Production support including Identify problems, root cause analysis, and team collaboration activities. Functional Support for Order to cash cycle. Support for pick release, manual reservation and fulfillment process, back-to-back order, drop-ship orders, Internal sales orders and RMA processes
• On-going participation in Agile- daily scrum for 14 days sprint for development

Sr. Oracle EBS Consultant/ Technology Manager

Confidential

Responsibilities:

• Planning & execution of corporate ledger application implementation project under significantly challenging deadlines. Implementations were delivered wif smooth cutover, accurate data conversion and highly successful go-live support
• dis project was delivered ahead of schedule and wifin budget and improved the performances of journal processing, GL closing process and improved on time quarterly reporting by 350%.
• Led entire project and team from India during implementation of 50 odd complex business processes as a SME for Oracle EBS
• Analyze existing RICE customizations, perform impact analysis and identify necessary changes working wif business users and technical team.
• Technical design of GL Balance conversion, daily rates interface, Journal Import interface from legacy mainframe, extract balance outbound interface to other Reporting systems and GL data reconciliation
• Translated complex functional requirements into detailed design documents for some of the major extension like Elimination, Intercompany. Also delivered system configuration document and test cases.
• Coordinated wif the technical teams to deliver the solutions as per the functional designs
• Conducted UAT and collaborated wif the QA team to develop the test plans and test cases
• Configuration of Chart of account, ledger, Document sequence, security rules in sandbox
• Project Management: Manage Delivery, Resource, stakeholder engagement, Monitoring and Tracking, change Management, Coordinated activities wif other IT teams and their managed service providers
• Led Oracle R12 Financial Accounting Hub (FAH) implementation project. dis involved assessing changes in the GL system and updating more than 30 existing business-critical.
• Design & development of FAH GL to Corporate GL interface to transfer summarized journals
• Custom development to create events through oracle provided API
• SLA export and Import Accounting definition Testing
• Helping the technical team in clarification of Business Requirement.
• Support during UAT including defect fix, bug fix, end user manual creation
• Logged, monitored, followed up and closed the Service Request (SR) wif Oracle Support

Technology Lead

Confidential

Responsibilities:

• Maintenance and support of Corporate GL application wifin Wells Fargo.
• Led a significant performance tuning project dat resulted in a 150% improvement in stability (measured by occurrence of Severity 1 issues & downtime)
• Technical Designs, development, deployment of ongoing system enhancements
• Setup: Desktop ADI for creation of Journals wif WEB ADI, audit trail for custom tables
• Provided 24/7 Production Monitoring and Support coverage. Post-Production as Level3 support
• Execution and support for monthly Integration and Enterprise functional testing
• Coordination wif Key users for issue resolutions and getting sign-off for production release
• Team Lead and coordinated wif US and India team
• Implemented INV, OM, shipping, PO modules to a new warehouse in the USA west coast.
• Functional Specification document (MD050) for custom module developments
• Design of Conversion of Item on hand, lot and serial numbers.
• Quick sales order form customization to invoke custom form to capture information for label printing.
• Requirements and FSD for Order Import Interface for importing orders, returns and swap orders.
• Custom Freight cost calculation program for Sales order interfacing UPS.
• Custom Reports: Order return serial mismatch, Item tax report for controller requirements
• Setups/configuration: OM, shipping, Item Master, Item templates, Account Alias, Alert for Inventory minimum level, subinventory, Serial number Descriptive flex field to capture return order, PO, invoice
• QA (RICE Testing, Functional, Integration, System, User experience, Regression Testing)

IT Analyst

Confidential

Responsibilities:

• Liaison between stakeholders from several business units to gather requirements
• Developed PL/SQL procedures, functions and Jasper reports. Production Support Analyst