Onsite Lead/managing Consultant Resume
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).