We provide IT Staff Augmentation Services!

Lead Consultant Resume

0/5 (Submit Your Rating)

Data Migration Lead San Jose, CA

PROFESSIONAL SUMMARY:

  • Confidential has 10+ years of professional experience in Oracle ERP Applications in Business Consulting, Product Ownership
  • Tremendous Expertise on Implementing, Testing and Project Management/Product Ownership on Oracle E - Business Suite Applications versions - 11i, R12 and Oracle Fusion.
  • Experienced working as SME/Product owner/Lead Consultant in different projects for Implementing, Rollout, Production Support, Testing of Oracle Applications.
  • Worked for different clients - Confidential (for US & Canada Portfolio, Netherlands & Mexico) IKON Office Solutions, Confidential etc in USA and UK in client driven environment.
  • Conducted Enormous Customer/Client meetings to gather requirements and worked on Providing best feasible functional specifications, implemented the solutions in order to meet the customer requirements with minimal change to the existing the software architecture and existing operational process.
  • Worked on various Rollout projects for multiple operating units across European countries in Confidential project (was part of multiple deployment WAVE's) for Austria, Switzerland, Poland, Hungary, South Africa, Germany, Turkey, Ireland, Sweden, Spain & Netherlands for along with handling enhancements for Pilot deployment for UK.
  • Functional expertise in Order Management, OM implementation setups and Order to Cash flow - Order entry (Creation of order /booking of order), Order fulfillment (Pick Release, Ship Confirm), Invoicing, Invoice presentation, Customer payments/Collections, Receipt creation, Cash Application and posting to GL.
  • Extensive functional expertise on setups and implementation of Purchasing, Procure to Pay Cycle flow- Requisition creation, Purchase Order creation, Inventory Receipt creation, AP Invoicing, payments and posting to GL.
  • Functional expertise in Lease and Finance Management, Contracts to Cash flow with knowledge on key business flows Originations to Activations process, Invoice to receipt process, Quote to Termination process, Asset to Disposal, Collections, Inquiry to Resolution.
  • Good working knowledge of Oracle Financials - Oracle General Ledger, Multi- Org concepts, Month End/Year End Closing process Support.
  • Worked on different Field Service Business Models - 1. Break/fix and 2.Planned work.
  • As part of Break/fix Field Service Business Model, Worked on Creation of Service Requests, Auto generation of Field Service Tasks, Scheduling Tasks for Field Service Technicians, Scheduling Field Service Technician Trips, Executing Services, Dispatcher Operations in Monitoring Service Visits, Debriefing Service Visits of Technicians, Task completion and Closure, Implementing Field Service Manager Operations for invoicing process based on Service Contract (Billing for field service visits), etc.
  • As part of Planned work Field Service Business Model, Scheduled Preventive Maintenance programs as per Business needs.
  • Have hands on experience in Oracle Fusion on Procurement modules and SFDC, Confidential Originations application and Siebel application for deal entry for lease and service contract creation.
  • Support during the month end and end period close processes and worked with PWC audit team to provide support for the Year End audit.
  • Worked on Requirement Gathering and Analysis, Process flows, Business Requirements documentation, Fit-GAP analysis ( mapping of RICE/CEMLI Components), Designing functional requirement documents, Authored functional design documents for conversions and interfaces(CV040, MD050 and helped technical teams on documenting - CV60 and MD70 documents), Business flows (Wire frames and Visio diagrams), Gap analysis and worked on functional testing with the extensive functional experience.
  • Worked on different QA activities like designing the End to End business scenario’s, creating Unit Test Plans, Functional QA Testing, Conducted Business Acceptance testing, System testing, System integration testing, User acceptance testing, End to end Sanity/Smoke Testing and identify the defects/Enhancements and follow them to closure. Also worked on and Automation Testing using different tools - QTP, OATS, Win Runner.
  • Worked on Waterfall model and in Agile testing methodologies, Experienced in AGILE working model like creating Sprints, writing Stories, Backlog items and Acceptance Criteria. Participated in SCRUM meetings and stand up calls.
  • Excellent documentation skills such as preparing solution approaches, User manuals, Test Scenarios, Release notes for various releases and in resources.
  • Skilled in developing numerous functional deliverables and has the ability to meet deadlines and perform well in a fast paced environments, add value by independently anticipating work demands.

TECHNICAL SKILLS:

Oracle University Trained and Expertise Applications: Oracle Order management (Order to Cash Cycle, Quote to Cash Cycle, WIP, BOM, OM Setups etc) Oracle Purchasing (P2P Cycle, iProcurement, Supplier Management) Oracle Inventory Install Base Business Presentment Architecture (BPA) TCA Model Oracle Lease and Finance Management Accounts Receivables (Invoicing, Billing,Cash Application) Accounts Payable Fixed Assets (Asset Management) General Ledger (Financial Reporting and Reconciliation Process and Support for Month End Closure process)

Industry & Process Expertise: Marketing, Manufacturing, Retail, Networking, Software Engineering, Software Development, Leasing Industries.

Core Technology, Software Utilities, Languages: Win runner, QTP, OATS, TOAD, Clear Quest, Clear Case, SQL, PL/SQL, C-Language, EBS Architecture, Fusion Cloud Architecture, Visio Professional 2016.

Functional Roles: Functional Manager, Functional Lead, Product Owner, Solution Architect, Test Strategy Lead, Management Consultant, Program/Project Coordinator, Trainer, QA Analyst. The primary responsibilities for these positions are to act as a Senior Functional Business Support Lead Analyst on Oracle End to End Business applications, Order to Cash module, Procure to Pay module, Supply Chain modules, CRM Modules - Sales, Marketing, Field Service Operations, Leasing & Finance Management modules. Worked closely with a cross functional team within IT and also with the business users in the areas of Sales and Global Operations, Customer Service, Finance, Tax, Collections, Third Party teams. Provide an exceptional level of customer service and maintain well documented systems, processes and knowledge library. Work closely with and provide leadership and guidance for the onshore + offshore team of external consultants supporting the EBS suite.

PROFESSIONAL EXPERIENCE:

Confidential, San Jose, CA

Data Migration Lead

Responsibilities:

  • Extensively worked on different phases Application implementation methodology (AIM) i.e. Gathering Requirements, Operation Analysis, Functional Specification, Solution Design and implementation, Build Support, Unit Test, Conducting Business Acceptance Test, User Acceptance Test, Transition, & Production.
  • Conducted enormous requirement discussions with Business stake holders, Gathered requirement and Prepared Business Requirement documents (BRD's), Fit Gap Analysis for Confidential US implementation.
  • Worked on various types of orders - B2B Order, Drop Ship order, Internal Sales Order, RMA, Standard Order etc.
  • Designed and Implemented Order to Cash Cycle with Customer Acceptance at Pre-Billing and Post-Billing Events.
  • Responsible for Configuration of Setups, Testing and Implementation of Oracle iSupplier Portal, Oracle OM, Purchasing, Oracle Lease and Finance Management, Accounts Receivables.
  • Responsible for Configuration of Setups, Testing and Implementation of Oracle OM, Purchasing, Oracle Lease and Finance Management, Accounts Receivables.
  • Designed the Functional Solutions (FSD/MD50) documents, Documented the Order-to-Cash Module implementation setups, Order Management enhancements, Defined custom holds, defined in new transaction types and linked with Workflows, Shipping Execution and Fulfillment, Implemented the Drop Ship Process with customizations as per customer needs and Procure-to-Pay modules including Purchasing, (Supplier Base, Sourcing, Supplier Management), BOM, WIP.
  • Worked on defining setups for Inventory - items, item categories, Org structure, Inventory Orgs, etc. Procure-to-Pay modules including Purchasing, Supplier Management.
  • As a track lead for servicing extensions for I2R along with O2C, Implemented Oracle Receivables (AR) for Cash Application for different customer payment methods - Lockbox, ACH, Wire and Direct Debit.
  • Designed Invoice printing solution using the Oracle Bill Presentment architecture as per the US specific requirements.
  • Worked on various third party integrations for Cash, Invoicing, Printing, Collections and Property Tax Billing as per the Confidential Requirements.
  • Designed inbound/outbound interface with Confidential Third Party Vendors: -Coordinating with the technical team members and helping them in Technical design documents (TSD's/MD70).
  • Worked on all test phases and provided s to business users.
  • Prepared Test Scenarios and Test Scripts, End to End Integration testing across the applications and sub modules of oracle (Sales force, OM, PO, INV, AR, OKL and OLFM)
  • Worked on Month End, Quarter-End Activities during period closure.
  • Worked on Sub Ledger Accounting Architecture and configured SLA rules for Lease and Finance Management, AR and posted Journals to GL.
  • Prepared guides
  • Conducted CRP and UAT, Resolution of conference room pilot/UAT issues
  • Prepared production cut over plan documents.
  • I was involved in the Data migration activities as conversion lead.
  • Current Confidential has multiple legacy systems for US Operations. E.g.: E-lese as Origination system, Leasepak for Operational activities of the lease contracts and transactional data source system, GATE for maintaining the leased assets, Confidential In-house applications - Invoice & Reporting Tool for invoicing/collections activities and Cash Application Tool for applying the receipts to the Invoices.
  • Data Migration (DM) involves defining conversion rules for Customer/Supplier master data and transactional data for extracting the master data information from E-lese, contract related data from Leasepak and Asset related data from GATE and extracting invoicing and cash related data from Leasepak Invoicing tool and Cash App Tool respectively.
  • As part of DM, Below were the responsibilities:
  • Understanding the legacy data systems and their tables structure, legacy application functionalities and define conversion rules for those data fields/sets as per Oracle standard functionalities with minimum need for extensions.
  • Have authored the Design documents of Lease Contracts CV40, Open AR Invoices CV40 and Cash CV40.
  • Worked on Recon templates of the migrated data Vs legacy data at various stages of the contracts migration and invoice/cash migration.
  • Data migration involves extracting the legacy data into custom tables and then to oracle standard interface table and then to Oracle base tables through standard interface.
  • Worked on the Open AR invoice migration through OKL third party import interface.
  • Cash migration involves creation of Unapplied Cash, Applying Cash to the partially paid migrated Invoices.
  • Coordinating with the technical team members and helping them in Technical design (CV60) document.
  • Prepared the CV70, conversion test plans for each of the CV40.
  • Helping the Servicing Extensions, Reporting & testing teams to fix their issues.
  • Hand hold business SMEs on Data clean-up activities for Mater Data and Transactional Data as data migration from Legacy to OLFM.

Confidential

Lead Consultant

Responsibilities:

  • Worked in London and played the role of functional Lead Consultant in Retail & Logistics vertical for Client - RICOH which had been consistently expanding its business across different countries in Europe.
  • Requirement gathering analysis with Client and worked on estimations.
  • Worked on implementing Order Management, Inventory, Oracle Purchasing, Lease Contracts, Service Contracts, Invoice Presentation, Cash Application modules for different operating units of Europe.
  • Conducted meetings with Super users/SME’s to gather requirements for Procure to pay and Order to Cash cycles and documented.
  • Preparing the Business Requirement documents like RD, FD, SCR, ER docs etc.
  • Worked on designing the interfaces between the front office application (Siebel) and back office application (Oracle) for order import and contract import in to order staging tables and contract staging tables.
  • Worked on designing the 10 different contract structures as per the business needs for complex orders and designed the oracle transaction types specific to each contract structure for the workflow processing.
  • Worked on multiple enhancements for Pilot production country (UK) and provided futuristic solution for future rollout countries.
  • Worked on configuring the OM workflows, created new OM transaction types of different types of orders (Simple orders and Complex Orders). Worked on different types of order flows - Standard Order, RMA Order, Drop Ship process, Back to Back Order, Internal Sales Order.
  • Worked on Order Processing, order fulfillment, Order Shipping execution, Install Base Instance creation, OM-AR invoice creation, Posting to General Ledger.
  • Worked on Contract Import and Booking/Authoring process for Lease and Service contracts and creation of assets in Fixed assets, Accrual Revenue Recognition process for Back to Back (B2B) and Non-Back to Back (NB2B) deals, Invoice generation in AR and posting to GL.
  • Worked on designing the invoice presentation layouts as per different country specific requirements throughout the rollout project.
  • Worked on various Intercompany flows, Inter-organization Transfers for Purchasing and Order Management transactions across the European countries.
  • Responsible for the complete setup and implementation of Oracle Order Management, Purchasing, Inventory, AR, Lease Contracts, Service Contracts, General Ledger
  • Designed and developed all the setups and configurations for Inventory management, Worked on the Configuration of the INV module including setting up of the Item Categories, Defining Catalogs, Defining change categories and Types, Defining Item structures, setting up document management, defining roles and implementing role-based security.
  • Performed Purchasing Set-Ups, Set up the approval hierarchies and workflow in Purchasing.
  • Established Purchase Requisition process and Approval hierarchy to manage non-production (Indirect) Items purchases in the Organization, Configured Auto-Sourcing rules, Approved Supplier List(ASL) and BPA to enable Buyers to release purchase orders automatically from Planners Workbench. Developed solution to manage Inventory using ‘Inspection’ as receipt routing for Items routed through Quality department and established ‘Return to Vendor’ process.
  • Worked closely with Client finance user team and Oracle finance consultant on issues like intercompany invoicing, auto invoicing, tax codes and inventory valuation and resolved them by explaining the standard Oracle functionality.
  • Supported Month End activities.
  • Worked on Web ADI with Assets upload and Journals upload to GL.
  • Designing the solution approaches for the production issues.
  • Identifying Testing requirements. Designed the test strategy, test scenarios, test plans for different rollout projects as per the country specific needs.
  • Leading a team of 6-8 members and handling and managing Implementation activities of Ricoh.
  • Resource Management and work delegation among the team.
  • Coordination with Technical and DBA team.

Confidential

Consultant

Responsibilities:

  • Worked in Confidential as Offshore lead consultant and functional lead in Retail & Logistics vertical for Client - RICOH which had been consistently expanding its business across different countries in Europe.
  • Responsibilities were to gather the client requirements and design the best functionally and technically feasible solution approach meeting the Client requirement.
  • Work on different Gaps and on design and build activities for Scope Change Requests identified during the deployment activity.
  • Support Customizations, Extensions and Configurations for the project as per the business requirements.
  • Designed interface between oracle application and Siebel for interfacing the install base details for SR closure.
  • Designed the multi currency solution for Ricoh Turkey.
  • Designed the complete end to end order process and contract process flows across the different applications (Siebel, Oracle) for Complex order structures in Back to Back and Non-Back to Back scenarios.
  • Have extensive functional knowledge on all the SCM modules.
  • Guide a team of offshore consultants for functional activities.
  • Create and review the solution designs, functional design documents, support the Technical team to come up with technical design documents and build the Solutions.
  • Work and support on different QA activities like - User acceptance test, System testing, System integration testing, Acceptance testing and identify the defects/Enhancements and follow them to closure.

Confidential

Consultant

Responsibilities:

  • Worked for Retail business Client - IKON Office Solutions.
  • Worked in Developing, Testing Support Website based on Oracle Service modules R12.
  • Implemented creation of Service Requests, Auto generation of Field Service Tasks, SLA (Service Level Agreement) creation.
  • Scheduling Tasks to Field Service Technicians, Scheduling Field Service technician trips, Executing services.
  • Worked on Dispatcher operations in Monitoring service visits, Debriefing service visits of Technicians, Task completion and Closure, implementing Field Service Manager Operations for invoicing process based on Service Contract (Billing for field service visits).
  • Worked on defining the Preventive Maintenance Programs as per business needs.
  • Worked as offshore functional Lead and managed the Team of 6 resources.
  • Was involved in implementing and in rigorous End to End testing phases (including unit testing, Business Acceptance Testing, User Acceptance Testing) of the application and raised major enhancements and took them to closure.
  • Conducted multiple Client meetings to gather requirements and worked on Providing best feasible functional specifications, implemented the solutions in order to meet the customer requirements with minimal change to the existing the software architecture and existing operational process.

Confidential

Functional Analyst

Responsibilities:

  • Have been trained on various modules of Fusion SCM (Order Management, Inventory, AR) and Fusion Procurement listed below:
  • Self Service Procurement Portal iSupplier Portal
  • Procurement Contracts
  • Worked as Trainee in Oracle Fusion Procurement Team.
  • Developed test cases for different releases.
  • Worked on different QA activities like - User acceptance test, System testing manually and using the QTP and OATS.

Confidential

Product Owner/Functional Owner

Responsibilities:

  • Worked as a functional analyst on the CRM - Field Service Test flow designing, Testing and ERP - P2P, O2C.
  • Have been Product owner of Field Service as part of Integration Testing Team.
  • Created and tested the End to End Functional Integration flows of Oracle E-Business Suite (11i and R12.x.x) with major concentration on the Integration aspects between modules.
  • Design, develop and execute the Functional integration flow documents across various domains and products and also worked on automation testing on Win-Runner and OATS tool.
  • Worked on the basic and custom setups for the above mentioned modules on various environments cloned from the template, which is delivered to the Customer, Ensuring that the data used for this closely resembles the typical customer environment.
  • Attending Dev QA Hands-off during Application release, and analyzing the Enhancements of every Application release and build the business flow to verify the enhanced functionality concentrating from regression aspect as well.
  • Proficient at gathering requirements from the Design documents and customizing them as Business scenarios which involves combination of more than a product to ensure the quality and the cross functionality of both ERP and CRM modules of the Oracle E-business Enterprise application.
  • Major involvements are Application Release Testing, Rollup patch updates- RUPs; Verifying Critical patch updates- CPUs;
  • Front end functionality testing and data validation.
  • Raising and Tracking the Defects till closure.
  • Have done Project management of many projects including major releases and regular roll up patches for the Team.

We'd love your feedback!