We provide IT Staff Augmentation Services!

Onsite Lead/managing Consultant Resume

2.00/5 (Submit Your Rating)

PROFESSIONAL SUMMARY:

  • Over 15 years of experience in the software industry, with expertise in Oracle EBS 11i/R12, Financials and Order Management Cloud.
  • Various roles including:
  • Functional Lead/Techno - Functional Lead
  • Project Leader/Project Management
  • Subject Matter Expert/Solution Architect
  • Extensive experience with the Order to Cash and Procure to Pay Business Flow.
  • Expert in Stakeholder Management, Business Requirement gathering and Analysis, Gap analysis, Solution Design and Testing.
  • Oracle Financials Cloud Certified Specialist.
  • Oracle SCM Cloud Certified Specialist.
  • Experience in ASC 606/IFRS15 Revenue Recognition Standards.
  • Experience in Oracle Fusion Financials (AR).
  • Ability to handle multiple projects/assignments.
  • Experience in managing and implementing Cloud Application - ADORB, Order Management and Revenue solution for usage and subscription based billing.
  • Experience in providing full-fledged support and end to end implementations as Oracle EBS Functional Lead Consultant/Techno-Functional Lead/Solution Architect.
  • Conducting Requirement Gathering, Solution design workshops.
  • Conducting CRP/UAT workshops.
  • Extensive Experience in Oracle Financials custom SLA rule setups/debugging.
  • Expertise in the AIM Methodology, Documentation, Configuration of Applications, Testing, End-User Training and Supporting for Oracle Financials R12/11i AP, AR, GL Order Management, Advanced Pricing and iProcurement modules.
  • Extensive Experience with
  • Extensive Experience with Oracle AIM (Applications Implementation) Methodology/SDLC.
  • Experience in leading offshore team.

TECHNICAL SKILLS:

Oracle Apps Versions: 11.0.3, 11i (11.5.8,11.5.9,11.5.10.2), R12

Databases: Oracle 8, 9i, 10g

Programming Languages: PL/SQL, SQL, BPEL, Java 2.0, JSP, C/C++, VC++, Unix Shell Scripting

Reporting Tools: XML Publisher 5.6.2, Discoverer10g

Operating Systems: UNIX (sun OS 5.8), Windows 9x/2000,IBM AIX 5.3

Oracle Development Tools: Developer 2000 (Forms 6i/9i, Reports 6i/9i), OA Framework/ADF, Discoverer 10g, SQL Loader, TOAD, SQL Developer, Workflow Builder 2.6, SQL* Plus,jDeveloper10g

Oracle Applications Server: Oracle 9iAS

Versioning Tools: PVCS, CVS, Harvest CM and VSS

Migration Tools: Kintana

WORK EXPERIENCE:

Confidential

Onsite Lead/Managing Consultant

Responsibilities:

  • Managing Offshore Team.
  • Client Management, Effort Estimations, task planning, assigning tasks.
  • Solution Design, POC, Functional Flows and Preparing Functional and Technical Specifications documents.
  • Responsible for requirements gathering for enhancements and monitoring support tickets.
  • Responsible for resolving support tickets and assigning to offshore resources based upon workload.
  • Review existing customizations and suggest improvements.
  • Responsible for delivery of technical components.
  • Preparing/Reviewing Code and Work Instructions for deployment.
  • Preparing and Presenting Weekly status report to Client.
  • Mentoring Technical team for development.
  • Co-ordinate with DBA for deployment.
  • Writing Complex SQL queries and support Productions issues.
  • Design and Develop B2B EDI Integration using SOA suite 12c.

Modules: Oracle EBS Release 12-Order Management, Shipping, Advanced Pricing, Receivables, Oracle Process Manufacturing, Payables, PO and Inventory

Confidential

Oracle Order To Cash Subject Matter Expert/Track Lead

Responsibilities:

  • Conducting Pre-implementation workshop.
  • Conducting Requirement Gathering workshops for Order to Cash track with stakeholders.
  • Stakeholders Management, Effort Estimations, task planning, assigning tasks and managing teams (Onsite/Offshore).
  • Responsible to prepare Business Requirement traceability matrix and Requirement Documents and review with stakeholders.
  • Responsible for preparing RD050 (Requirements Documents), BP080 (Future Process Model) for Order to Cash Track.
  • Solution Design, POC, Functional Flows and Preparing MD050 documents.
  • Responsible for Fit-gap analysis BR030 for Order to Cash.
  • Responsible for Functional Setups and BR100 for Order to Cash Track (Order Management, Advanced Pricing, Shipping and Receivables).
  • Conducting CRP sessions.
  • Prepared Functional design (MD050) and Mapping EDI 850 (Inbound Purchase Orders) Interface.
  • Prepared Functional design (MD050) and mapping EDI 855 (Outbound Order Acknowledgement) Interface.
  • Prepared Functional design (MD050) EDI 810 (Outbound AR Invoices) Interface.
  • Integrate Online Store with EBS Order Management.
  • Solution Design and Functional Design (MD050s) for Credit Return Authorization process for Software, Service and Support SKUs.
  • Design and Develop Upload Service Contracts /Items Serial Numbers form to Credit Return Authorization.
  • Responsible for AME configurations for Credit Return Authorization approval process.
  • Design and Develop Zoom form to fetch Quotes information to create Orders based upon the quote created in quoting system.
  • Customize Order Line workflow (Payment Gateway integration, Forticare Contract service contract termination).
  • Design Evaluation to sell Process.
  • Responsible for Sales Order Form Personalization and customer page OAF personalization.
  • Help Technical teams to troubleshoot the issues.
  • Design worldwide backorder /daily-weekly shipment/CRA order status reports.
  • Design Pick Slip/Pack Slip/ Commercial Invoice documents.
  • Design Invoice Print/Credit Memo documents.
  • Provide inputs to RevPro and Vertex implementation teams.
  • Preparing Test plan/Test scripts and perform end to end integration testing
  • Coordinating with technical team and DBA for development and migration activities.
  • Conducting CRP sessions and helping users in executing test scripts.
  • Coordinating with other partners like vertex and RevPro.

Confidential

Functional Lead/Architect/Techno-Functional Lead

Responsibilities:

  • Work closely with Business users for Requirement Gathering.
  • Client Management, Effort Estimations, task planning, assigning tasks and managing teams (Onsite/Offshore).
  • Solution Design, POC, Functional Flows and Preparing MD050 documents.
  • Responsible for Functional Setups.
  • Prepare Mapping and design Salesforce to Oracle Integration.
  • Supporting Order to Cash, Advertising, Subscription Billing and Revenue Recognition Processes.
  • Conducting UAT sessions.
  • Work closely with Business Users during Period end closing activities.
  • Design and Testing Credit Card Integration with Oracle Receivables from Cyber source and Paymentech.
  • Customization of check print template and testing of Accounts Payable Payment process.
  • Customization of GL Journal approval process.
  • Setting up banks in Cash Management.
  • Design, Develop and Testing Adjuster Interface.
  • Implementing iProcurement, setting up AME Rules, OAF Personalization and Workflow Customizations.
  • Design and Develop Quoting Tool.
  • Responsible for Product Development - Adorb (Custom Order Management Solution for Advertising Industry) SaaS Application.
  • Integrating Adorb with Oracle Fusion Receivables.
  • Design and Develop Revenue Engine for Adorb Application and integrated with Oracle Receivables.

Confidential

IT Lead/ Financial Consultant

Responsibilities:

  • Involved in functional discussions for requirements gathering.
  • Preparing MD050 and MD070 documents.
  • Supporting Daily issues in Orders, Shipping and invoicing processes.
  • Designed solution for adding CRV charges to AR invoice, including necessary functional setups.
  • Developed Customer, Item Category/Category assignments/Item Cost/Contract Purchase Orders/Formula/Vendor conversion scripts.
  • Responsible for Master/Transactional Data Conversion (Items, Customer(Using TCA architecture), Vendor, ASL, Price List, Vendor Promotions/Rebates, Customer Promotions/Rebates, Item Cost, Open Sales Orders, Open Purchase Orders, AP Invoices, AR Invoices from legacy to Oracle Release 12) in CRP/UAT/Production using Oracle APIs and Interfaces.
  • Supported production cut-over to transactional data conversion reconciliation.
  • Developed GL Sub-ledger accounting report displaying accounts, a/c balances with invoice details using Oracle BI (XML) Publisher.
  • Responsible for Resolving daily production support tickets relating to Oracle Financials (AP, AR, and GL Modules).
  • Responsible for OA Framework customization and personalization in Trade Management and AR.
  • Worked on Trade Management Claims, budgets and offers.
  • Integration of Bill back Workbench with Trade Management, Receivables and Payables.
  • Worked on Trade Management Accruals in General Ledger.
  • Supporting Sub ledger Accounting, Month-end activities and Reconciliation of accounts.
  • Worked on Custom SLA rule setups.
  • Developed/Customized custom Oracle forms (Item Inquiry, Bill back Workbench).
  • Support Custom Modules Bill back Workbench, Auto invoice preprocessor and Payment Upload Custom applications.
  • Developed Custom Reports (Customer Credit Report, Net Sales Report, Customer/Vendor Spoils Reports.

Confidential

IT Consultant

Responsibilities:

  • Involved in analyzing the Requirement Document/Requirement gathering and write Functional MD050 / Technical Design MD070 Document.
  • Involved in writing MD050/MD070 and developing outbound interface to publish order data to other systems for reporting purpose.
  • Involved in writing MD050/MD070 and developing core charge matching program and screen (automatically create core charge debit memo for unmatched or overdue shipments).

We'd love your feedback!