Sr. Functional Consultant /project Mgr. Resume
Jacksonville, FL
SUMMARY:
- Confidential possesses over 16 years of consulting experience across several industries as Functional Lead, Solutions Architect, Project Lead/Manager, Techno - Functional Lead Analyst and Oracle eBusiness Training Specialist. P2P track in Oracle Financials has been a key focus of his career including all aspects of implementations, upgrades, conversions, customizations & enhancements.
- Confidential has strong knowledge & experience working exclusively with Oracle Financials & P2P modules (General Ledger, Accounts Receivables, iReceivables, iExpenses, Accounts Payables, Fixed Assets, Cash Management) and Oracle Distribution/Advance Procurement modules (Core Purchasing, iProcurement, Inventory, Purchasing, Accounts Payables, iSupplier Portal, Sourcing & Procurement Contracts). Special expertise in integration of these modules and conducting Gap analysis.
- Hands-on Oracle E-Business Suite specialist with many full life-cycle implementation engagements.
- Proficient in setups/configs, customizations/enhancements, data conversions design, mapping and migrations of Oracle Applications (Rel.12.x,11i,11,10.x). Strong expertise in business process analysis and design, current & future states, Gap-Fit analysis, functional system design and specification, development of system tests, procedures, documentation and designing system enhancements to facilitate overall system requirements.
- Very strong and knowledgeable in managing and planning functional implementations and customization including interfaces to legacy systems, data conversions, and system upgrades.
- Confidential ’s experience also includes providing industry best practices, logical design, business process re-engineering and strategic solutions for Oracle Financials, Self Service Apps, test plans, alternative business solutions and lessons learned.
- He has acted as a competent liaison between management, clients and personnel supporting business transformation initiatives and assisted the clients with the roadmap definition. Confidential holds an MBA and advanced understanding of business & accounting processes. He is a proven team player, strong at interfacing with users at all levels and a skilled communicator of design concepts in functional documents.
SKILLS OVERVIEW:
Oracle Financials: (GL, AR, iReceivables, Accounts Payables, Project Accounting, Fixed Assets, Advanced Collections, Cash Management) Rel. 10.6/10.7/10.7 SC, 11, 11i, Rel.12, Oracle Advance Procurement Suite (iSupplier Portal, Procurement Contract, iProcurement, Sourcing, Supplier Hub, Supplier Life Cycle Management)
Distribution: Inventory, Order Management, Purchasing,, Sourcing, Procurement Contracts (Rel.10.6/10.7 NCA, 10.7SC, 11, 11i,Rel.12), EDI/E-Commerce Gateway/ System Admin, Web ADI, Oracle Warehouse Builder, Workflow Builder
RDBMS/Tools: Oracle 7.x, 8i,9i,10g TOAD, SQL Navigator, XML Publisher, Report Builder 6i, 10g, Designer 2000 & Discoverer2000 & Discoverer 9iAS.
Software: MS Access, MSWord, MS Excel, MS Visio, MS Project, Power Point, iManage, LotusNotes, SharePoint, Oracle UPK & SnagIT training document tools.
Operating Systems: MS DOS, Windows 95, 98, Windows XP, Win NT and UNIX (HP, Sun So)
PROFESSIONAL EXPERIENCE:
Confidential, Jacksonville, FL
Sr. Functional Consultant /Project Mgr.
Responsibilities:
- This is Oracle Rel (12.1.3) environment live on Oracle Financials and Advanced Procurement suite. My role is to implement Oracle Sourcing and ensure the customizations/extensions work properly and the integration with Oracle iSupplier Portal, Oracle Procurement Contracts, Oracle Inventory, Oracle Purchasing works seamlessly.
- Lead weekly calls, discuss open issues list, collaborate with cross-functional teams and manage the project plan.
- Gather business requirements, complete GAP-Fit Analysis, finalize the list of customizations and enhancements, lead CRPs, configure and test the system.
- Document the AS-IS and Future state, BR100s, MD050s, BR30s, TE40s and training the users in all key areas of Oracle Sourcing module.
Confidential, Ann Arbor, MI
Sr. Functional Lead/Project Mgr.
Responsibilities:
- This was Oracle Rel (12.0.4) SCM environment live on Oracle Financials and ASCP.
- My role was to implement Oracle iSupplier Portal, Oracle Sourcing, Oracle Purchasing, Oracle Payables.
- Gather business requirements, complete GAP-Fit Analysis, finalize the list of customizations and enhancements, lead CRPs, configure and test the system.
- Document the AS-IS and Future state, BR100s, MD050s, BR30s, TE40s and training the users on iSupplier Portal in all key areas.
Confidential, Houston, Texas
Sr. Functional Consultant
Responsibilities:
- Setup & implemented iProcurment and Accounts Payable out of the box functionality with no customizations as part of Phase I deliverables.
- Gathering requirements for enhancements/customizations, interfaces, and documentation using AIM.
- Assisting the client with functional requirements gathering, proof of concepts, GAP Analysis, in-depth analysis of current state business processes, creation of business process flows and identification of key functional business areas needing business process re-engineering, Laid out a road map and documented/designed To-Be process flows and setups.
- Conducting CRPs and assisting users with UAT and understanding out of the box Oracle functionality.
- Using Oracle AIM for creating documentation (MD050s, BR100, TE40, etc.)
- Actively participating with the data conversion tasks of Active Suppliers, Open POs, OSP POs, and Open Invoices.
Confidential, Jacksonville, FL
Techo-Functional Lead
Responsibilities:
- This was a Rel 12 environment 12.1.2. Assisted the client with the implementation of Oracle eAM, Purchasing, Oracle Payables and GL.
- This was a vanilla out of the box implementation with minor customization.
- Lead the project in the capacity of a PM as well. Managed the Project Plan, resources, time and budget.
- Gathered functional requirements and conducted in-depth GAP analysis. Wrote BR10, BP80,BR100s, MD50s and MD120 documents.
- Trained the end-users as an Oracle EBS trainer. Responsible for creating training user-workshops, scheduling training and creating training material.
Confidential, Boston, MA
Sr.Functional Lead
Responsibilities:
- Assisted the client with functional requirements gathering, proof of concepts, GAP Analysis, in-depth analysis of current state business processes, created process flows and identified key functional business areas needing business process re-engineering, laid out a road map and documented/designed To-Be process flows and setups.
- Conducted CRPs and assisted users with UAT and understanding out of the box Oracle functionality.
- Defined AME rules for supplier’s approval process, and created Multi-Row UDAs.
- Used Oracle AIM for creating documentation (MD050s, BR100, TE40, etc.)
- Advised the client on Supplier On-boarding process, cleaning existing data on supplier base, ASNs, Payments and Receiving, on-line collaboration with suppliers including PO Change requests, catalog vs. non-catalog items, etc.
- Worked with business to finalize the testing and training plans. Created user training material including training guides and conducted end-user training as a Professional Oracle EBS Trainer.
Confidential, Miami, FL
Sr.Functional Analyst
Responsibilities:
- Design, configure, and document the implementation of Rel.12 Oracle Adv Proc Suite of Apps (iProc, Sourcing, Procurement Contracts and iSupplier Portal) as well as P-Card Implementation.
- Conduct CRPs, create prototypes to demonstrate standard functionality and how to bridge the Applications GAPs.
- Prepare MD050s, MD070s for solutions requiring customizations and logical Architecture and Technical design
- Prepare Product Scope & Requirements documents and managed changes according to changes provided by Customers, Product Business Development and Conceptualizing teams, and other Stakeholders.
- Cost, Quality, Scope and Schedule were reported to the Sr. Management both at on-site and off-shore and discussed accordingly to get the necessary resources to align progress towards the plan.
- Create Training plans/docs for user training on new applications roll outs including Core Purchasing, Payables, iProc, iSupplier Portal, Procurement Contracts, etc.
- Using Oracle OAM (formerly AME) created approval rules to route the invoice approval based on the ordered list of approvers.
- Wrote dynamic usage query to identify a starting approver by using requester on the purchase order.
- Modified the Invoice Approval Workflow using workflow builder and changed the verbiage on the workflow notifications as well as displayed the invoice status. Also set up an OAM rule to remove invoices from the approver’s list when the status becomes Cancelled.
- Responsible for Production support as SME and handle support calls routed to the 3rd tier support group.
Confidential, Tampa, FL
Sr.Functional Consultant
Responsibilities:
- Prepare RD050, BP 040 covering both the business and technical requirements which collectively comprise Project Scope as well as current functional specifications, use cases and task flows.
- Conduct Gap-Fit Analysis and carry out all functional setups and configurations. Also prepare Configuration Management document (BR100) for Environment Configuration settings.
- Prepare MD050s, MD070s for solutions requiring customizations and logical Architecture and Technical design.
- Educating the users on high level system capabilities (functions, workflows, reports, configurations, personalizations).
- Lead reviews and document existing processes, business process maps. Create Business Process Flows for current business and changes in the Business Process Flows and document all changes to the Business Process Flows.
- Assist development with standardizations, mappings, and data cleansing in preparation for data conversions and legacy system integrations.
- Design, configure, and document interface mappings from new and legacy systems to the existingOracleFinancials and Adv Proc Suite of Apps (iSupplier Portal, iSourcing, Proc Contracts, iProc, etc.)
- Assist in formatting scripting, and testing for the system applications software; developing specifications, and testing required software changes. Prepare TE040 covering Test Plans and Test results for system load testing and system performance testing.
Confidential
Sr.Functional Analyst/Team Lead
Responsibilities:
- Developed detailed project plans, resource plans and status reports. Drove the projects from the concept through final implementation while ensuring good practices in standard methodologies and processes.
- Managed assigned projects and ensured agreed scope is adhered to while maintaining projects timelines and quality.
- Provide report of forecasted and unexpected delays in the project; to include reason for delay with proposed solutions and timeframes
- As a Functional Consultant reviewed and analyzed current business processes for Purchasing, iProcurement, Inventory, iSupplier Portal, Sourcing and Procurement Contracts applications. Worked with the project ‘core’ team in formulating and defining system scope and objectives.
- Offered industry best practices and assisted the client with the roadmap definition.
- Gathered detailed user requirements and educated the users on high level system capabilities (functions, workflows, reports, configurations, personalizations). Explored alternative ways of meeting user requirements through improving business process, personalizations & system configurations.
- Analyzed and understood the existing system foot print and identified opportunities for improving processes and functions.
- Documented and analyzed the existing & To-Be processes (BP070s) and compared it with Oracle Apps functionality. The gaps were identified and documented in BR010.
- Involved in the functional design and setups/configs/personalizations of the assigned modules.
- Authored and executed test plans (TE040s) to ensure successful implementation. Actively involved with Unit test, UAT, QA, Integration and Regression testing.
- Resolved/debugged various issues during process mapping, development, unit testing & UAT,etc.
- Supported the Business Process Flows related to data conversion and extensions from legacy internal and external systems into the standardized software and processes of OracleE Business Suite applications.
- Oracle Purchasing/iProcurement:
- Carried out all necessary setups and configurations of core Oracle Purchasing system. Implemented approval hierarchies for Req./ Purchase Order approvals. Defined Approval groups, Approval Assignments, Lookup Codes, Document Types, Purchasing/Receiving Options, etc.
- Also configured workflow in Purchasing by choosing appropriate workflow options i.e. Workflow Background mode, Timeout feature, Archive on Approve, Send Notifications for POs, etc.
- Designed and wrote interface programs specs for PO and Requisition interfaces.
- Coonfigured AME approval hierarchy for iProc requisitions, conducted user requirements gathering, gap analysis, CRP with users, carried out various personalization (Function security & form level), created internal and supplier catalogs.
- Wrote functional specifications for the customization of the PO & Requisition Account Generator workflows. Configured “My Profiles” settings in iProcurement to offer more security and control.
- Set up information templates to gather additional info in iProc to pass necessary order processing information to suppliers.
- Analyzed and documented detailed business functions, accounting entries and functional requirements using process flows, use cases, business narratives, T-account examples, matrices, etc.
- Analyzed and understood current accounting and business processes quickly and created documents for new system in a fast paced environment with aggressive deadlines.
- Offered production support and assistance to business users in GL. Created users documentation on creating a new batch with multiple Journal Entries, Period-end process for combining the financial results of separate subsidiaries, Accounting Rules.
- Managed the Inventory project from requirements gathering/analysis to Post-Prod support.
- Offered best practices Oracle Inventory setups and participated in CRP, UAT & system testing.
- Completed all Inventory related setups and configurations. Defined Oracle Inventory Key iflexfields (items, item category, stock locator), system items, items categories, Inventory Orgs, etc. iSupplier Portal: Implemented Oracle iSupplier Portal from requirement analysis to user training. This involves automating the PO communication, PO Change, ASN and invoice processes. Designed and implemented Consigned Inventory for supplier. Suppliers use iSupplier to manage and view consignment process. Also implemented Approved Supplier Management process.
- Oracle Sourcing: Analyzed requirements, designed, implemented, tested, documented, provided end-to-end solutions and rolled out Oracle Sourcing application. The client wanted to utilize out of the box functionality of Oracle Sourcing in the areas of RFI, RFQ and Buyer’s Auction. Offered end-user training and created user-training documentation.
- Defined custom sourcing responsibilities and set up Negotiations configurations, templates along with Negotiations terms. Set up Inbox for Notifications and Workflow options.
- Oracle Procurement Contracts: Analyzed requirements, designed, implemented, tested, documented, provided end-to-end solutions and rolled out Procurement Contracts. The client was keen in establishing contract standards, use this tool for authoring/negotiating the contracts, approve and sign contracts, execute and monitor contracts, and renegotiate and close out contracts.
- Utilized AME to create simple and complex business cases involving the approval of AP invoices, and PRs/POs. Worked with Attributes, Conditions, Rules while setting up AME. Assisted the client with Approval routing hierarchies, Transaction Types, Configuration Variables, Action Types, etc.
Confidential, WI
Principal Functional Consultant
Responsibilities:
- Worked with the project ‘core’ team in formulating and defining system scope and objectives. Reached consensus with the core team on what would be ‘nice-to-have’ and what is ‘must have’ functionality. Accordingly, prioritized the RICE list.
- I setup the system to demonstrate how supplier hierarchy works in iSupplier Portal and different statuses PO can have during the PO Change Process.
- Demonstrated high level system capabilities (business functions, workflows, reports, configurations, personalizations), explored alternative ways of meeting user requirements.
- Documented and analyzed the existing & To-Be processes and compared it with Oracle Apps functionality. The gaps were identified and documented in the form of BR010.
- Involved in the complete functional design and setups of the assigned modules. Also put together the conceptual/logical designs for interfaces, workflows & other customizations.
- Created number of MD050 and TE040 documents for different standard reports customizations.
- Provide written analysis of changes or new requirements within the Business Process area and report forecasted times to implement the changes and reason for and purpose of the change in the Process Flows.
- Defined AutoCash Rule Sets to determine the sequence of cash application methods. Defined statement cycles/messages, dunning letters, receipt classes, payment methods, collectors, remittance Banks, Receivable Lookups.
- Setup Credit Memo workflow for Invoice Disputes in iReceivables. Established credit memos approval limits and set up employee approval hierarchy.
- Customized iReceivables using Menu exclusion functionality and self-service page personilizations.
- Collaborated with HelpDesk and Oracle Support for AR issues.
- Configured and setup Oracle Purchasing/iProcurement. Conceptualized process controls for Procure to Pay cycle.
- Conducted careful Gap Analysis and identified the customizations and extensions needed for Oracle Purchasing. Implemented approval hierarchies for Requisition/ PO approvals.
- Defined Sourcing rules, Approved suppliers list (ASL), Lookup Codes, Document Types, Purchasing/Receiving Options, Requisition Templates, etc.
- Completed (BR100s) for all the Purchasing setups/configurations & wrote customization specs for PO/Requisition approval workflows, MD050s.
- Created and updated test scripts for global testing requirements. Analyzed the customizations, enhancements requirements and mapped them to Rel.12.
- Coonfigured AME approval hierarchy for iProc requisitions, conducted user requirements gathering, gap analysis, CRP with users, carried out various personalization (Function security & form level), created internal and supplier catalogs.
- Also configured workflow in Purchasing by choosing appropriate workflow options i.e. Workflow Background mode, Timeout feature, Archive on Approve, Send Notifications for POs, etc.
- Designed and wrote interface programs specs for PO and Requisition interfaces.
- Analyzed requirements, designed, implemented, tested, documented, provided end-to-end solutions and rolled out Procurement Contracts. The client was keen in establishing contract standards, use this tool for authoring/negotiating the contracts, approve and sign contracts, execute and monitor contracts, and renegotiate and close out contracts.
Confidential
Sr. Techno-Functional Consultant/Team Lead
Responsibilities:
- Carried out Inventory setups and configs. Defined system items, items categories, item flexfield, Inventory Orgs, Subinventories, System Items, flexfields, organization parameters, locators, etc. in a multi-org env.
- Offered best practices to client's unique requirements and processes. Identified opportunities for process optimization and process redesign.
- Wrote functional specs for Conversion/Interface Program to convert the Inventory Items and Item Cross-Reference data into Oracle.
- Authored and executed test plans (TE040s) to ensure successful implementation. Actively involved with Unit test, UAT, QA, Integration, Regression testing and conducted formal training classes.
- Defined AutoCash Rule Sets to determine the sequence of cash application methods. In addition, set up AutoAccounting to determine how AR creates the GL accounting flexfield combinations for different types of accounts, such as Revenue, freight, tax, finance charges, and more.
- Defined statement cycles/messages, dunning letters, /sets, receipt classes, payment methods, collectors, Banks, Receivable Lookups.
- Interfaced with the client team to prepare the Business Requirement documentation . Also involved in the process analyzing & scoping business requirements, process/software gap analysis, mapping, configuring and testing the Core Purchasing, iProcurement, iSupplier Portal & Payables modules using Oracles version 11.5.10.
- Implemented the approval hierarchies in Oracle PO for requisition/ Purchase Order approvals, Sourcing rules, Approved suppliers list (ASL), & Quotations.
- Defined items and item categories for Catalog and Non-catalog purchases. Worked with Blanket POs as well as Contract Purchase Agreements and Global Contract Agreements in Oracle Purchasing.
- Wrote functional specifications for the customization of the PO & Requisition Account Generator workflows. Configured “My Profiles” settings in iProcurement to offer more security and control.
- Helped senior management with presenting solutions and assisted them with making decisions on customizing the standard iProcurement functionality, especially PO/Req Account Generator workflows.
- Implemented this web-enabled analysis tool which provides access to enterprise-wide procurement information, along with the ability to perform ongoing analysis of sourcing decisions, contract compliance, and supplier performance .
- Using Oracle Discoverer modified several Purchasing Intelligence reports like Invoice Amount Report which displays how spend (based on Supplier Invoice Amount) changes. Also worked with Rejection on Inspection, Contract Purchases Details, PO reports for Contract Utilization (Contract leakage by PO number, Non contract purchases by PO number, etc.).
- Configured and setup Oracle Payables. Defined set of books, Suppliers, payment terms, invoice and payment currencies, Financial Options, Payable Options, Invoice Tolerances, Signing Limits, Bank Transactions Codes, Reporting Entities, etc.
- Wrote functional specs for importing CitiBank PCard transactions into Oracle Payables as well as customization of EFT NACHA report.
- Assisted users with the UAT and Integration testing of various customizations and extensions.
- Also trained the AP users on Month End process and key AP programs like Invoice Validation program, Payables Open Interface, Supplier Merge Program, etc.
- Implemented and rolled out Oracle iSP application and covered all aspects of implementation from requirement gathering to user training. This involves automating the PO communication, PO Change, ASN and invoice processes.
- Wrote a comprehensive 'Users Training Guide' for iProcurement & iSupplier users with simple to follow steps covering each function clearly with screenshots using 'SnagIt' .
- Conducted comprehensive training with key functional users “Train the Trainer” approach.
Confidential, Ft. Lauderdale, FL
Functional Consultant
Responsibilities:
- Successfully Implemented Oracle Purchasing (11.5.6). Carried out all functional setups and configurations. Helped the client in identifying ways to leverage Oracle applications to better control and manage Purchasing. Designed and defined Position Approval Hierarchy and configured workflow options.
- Implemented core Contracts applications, created documentation and offered user-training. iProcurement: Used the catalog extractor to load items and services from Oracle Purchasing into iProcurement catalog.
- Set up information templates to gather additional information in Oracle iProcurement 11i to pass necessary order processing information to suppliers.
- Defined locators, Physical Inventory, Cycle Counts, etc.trouble-shooting and debugging of the Production issues.
- Trained the users with the Month End close, Cycle Counts and Physical Inventory processes.
- Implemented iSupplier Portal enabling the supplier to enter invoices, ASN’s and view their PO’s in iSP. ses: Implemented Oracle iExpenses to establish centralized T&E management function and enforce company wide policies. Analyzed client’s existing T & E processes and carried out gap-fit analysis.
- Covered several integration points between Payables and Payroll. Carried out the necessary setups and configs. Wrote functional specs for new reports and customizations to the existing ones, etc.
- Carried out AP setups and configurations. Worked on conceptual/logical design of customizations. Also participated in testing, training and Support.
- Defined statement cycles/messages, dunning letters, receipt classes, payment methods, collectors, remittance Banks, Receivable Lookups.
- Techno-functional troubleshooting of the Shipping Execution (WSH), Order Management (OM), and Inventory (INV) modules within Oracle Applications. Worked on issues related to pick release, pick confirm, deliveries, reservations (hard, soft, ATP), backorders (B/O), interfacing to 3rd party warehouse/packaging systems (ALS and FedEx), and ship confirmations (WSH, INV). Methodological identification of issues starting from order initiation to ship confirmation and closing of order line. Analysis of all scenarios/paths an order line can go through, and issues that may occur during the full lifecycle of an order.
- Changes in configuration to Shipping, OM, and INV setups as needed to address issues, improve performance, and ensure proper flow of data to 3rd party systems.
- Wrote several alerts in GL, HRMS, AP and AR modules.
- Designed purchasing documents notifications sent to multiple approvers simultaneously using Approval Management Engine (AME).
- Lead several in-house and offshore projects. For the remote-users training used WebEx and NetMeeting conferencing tools. Wrote easy-to-follow user training guides, etc.