Senior Lead Functional Consultant Resume
Logitech, CA
EXPERIENCE SUMMARY:
- Eminently Focused, Result driven senior consultant with 12 years of extensive experience Oracle EBS functional role.
- Comprehensive experience in different areas of Design, Production System Support, Data Conversion techniques, Implementation, System Configuration and Customization of Oracle Application modules like Oracle General Ledger, Oracle Accounts Payable, Accounts Receivable, Oracle Cash Management, Oracle Purchasing, Oracle Fixed Asset, iSupplier and iExpense module.
- Strong familiarity with AIM methodology in creating document like BRD, BR - 100 and MD-50 documents throughout multiple Projects.
- Highly skilful in Designing completely new system and troubleshooting the legacy systems with unique ability to deliver under critical time bound requirements.
- Knowledge and skill set with Financial Fusion application. Experience of participating in demonstrating the Fusion application to clients.
- Skilled in eliciting user demands and translating them to data, functional and usability requirements.
- Facilitated and participated in Joint Application Design (JAD) sessions, user workshops, conference calls and white board sessions to plan strategic Business decisions and detailed systems design.
- Experience in implementation of iExpense and iSupplier module.
- Worked extensively on onsite offshore model and expertise to guide, coordinate and assist team members to provide deliverables.
- Extensive experience with R12 implementation and upgrade project in Procure to Pay (P2P) and Financial modules.
- Experience in working implementation and upgrade projects in R12.2.4, R12.1.2, R12.1.3 and 11i application.
- Strong quality bias, self driven and highly motivated for timely target achievement.
- Excellent written and oral communication skills with a results-oriented attitude.
- Skilled in various MS Office tools including MS Visio and MS project.
- Served as the key point of contact/Liaison between onsite and offshore.
- Co-ordinate and follow with offshore team to accomplish the milestones as per project time line.
- Effective time management and multitasking skills, which help in conducting project meetings, reviews, walkthroughs, and customer interviews according to the varied needs of the people involved.
- Experience in reviewing Test Procedures, defining Test Cases, reviewing and maintaining Test Scripts, analyzing bugs, interacting with team members in fixing errors and User Acceptance Testing (UAT).
- Good Knowledge ofSOX (Sarbanes-Oxley act) compliance.
- Enjoys a professional attitude and have excellent communication skills, self-motivated and multi-task oriented, with strong work ethics and ability to work effectively and cohesively in a team or individually.
- Experience in working as team lead on onsite and offshore model for more than 7 year in Wipro Technology.
TECHNICAL SKILLS
Environment: R12.2.4, R12.2.3, R12.3 and 11i, Fusion Financial Application
Skill Set: Accounts Payables, Payments, Account Receivables, AME, General Ledger, Order Management iExpense, iSupplier, iProcurement, Purchasing, SLCM and Cash Management
PROFESSIONAL EXPERIENCE
Confidential, Logitech, CA
Environment: iProcurement, SLCM, Purchasing, AME, AP, Payments, iExpense and iSupplier
Senior Lead Functional Consultant
Responsibilities:
- Responsible for lead, coordinate, support procure to pay track of the R12 upgrade project.
- Worked with global business user across Asia, Europe and North America.
- Worked on analysis, design and rolling out of custom solution for generation of accrual account through account generator.
- Worked on the design and implementation of approval process for Requisition, Purchase Order and Payable Invoice through AME process.
- Implemented SLCM along with iSupplier for direct suppliers of Logitech.
- Worked on configuration and set up of iProcurement and iSupplier module.
- Implemented the Global Banking solution for USA and Canada. Working on the next phase of the solution to extend it to Asia.
- Conducted a virtual workshop to train the business super users across Asia to train them with usage of SLCM, Payments process and Accrual Process.
- Designed the complete conversion process for Expense Report, Purchase Order and Invoices.
- Worked on preparation, planning and coordination of cutover process with different stakeholders of the project.
- Successfully conducted and coordinated the UAT testing for users across America and Asia on a timely manner with resolution and closing of issues without missing deadline of the UAT.
- Worked on critical issues pertaining to reconciliation of accounting entries in procure to pay process at the month end process of UAT2.
Confidential, Lexington
Environment: Accounts Payable, Purchasing, General Ledger
Senior Functional Consultant
Responsibilities:
- Working as a functional consultant for a multi country rollout of Oracle R12.2.4 for Europe, Australia and Canada.
- Created the requirement gathering document, prepared presentation and demonstrated to the business about R12 Suppliers, Invoicing, Electronic Payment and Bank Statement Reconciliation solution to business group.
- Demonstrated Purchasing and procurement solution at the initial scoping process of the project.
- Implemented procure to pay module for Europe and Australia roll out of the phase -1 of the project.
- Worked on the creation of requirement gathering document, configuration and set up document (BR.100) and conversion strategy for purchase order and receipts from the source system.
- Created the Functional design document for the specific custom reporting solution and worked with technical team for delivery of the solution.
- Worked with the business group and suggested the best practices that is being implemented with respect to purchasing and accounts payable process.
- Created test case scenarios and worked with QA team with successful completion of testing process.
- Coordinated the entire phase of CRP and UAT testing along with the business team.
- Worked on configuration and set up of Purchasing, design and implementation of approval process mechanism.
- Designed and configured the PO approval process through AME.
- Worked functional design of rules for PO account generator for generation of charge account in PO with detail analysis of the business processes
- Set up the payment process for performing electronic payment process for suppliers.
- Working on creation of use training manual for payable and purchasing user group.
Confidential, Demand media, CA
Environment: AP, FA, iExpense, PO and GL
Lead Functional Consultant
Responsibilities:
- Working as a functional lead for procure to pay and GL track of this project.
- Responsible for delivery of end to end solution for GL, iExpense, AP and PO module.
- Working on analysis, design, installation and multi country rollout of Oracle R12.1.3 for US, Canada, Ireland and Australia.
- Configured Chart of Accounts (COA), including new Parent/Child rollups, move balances utilizing the Mass allocation Workbench to populate new COA structure.
- Worked on design and creation of FSG reports that will be used by accounting reporting group.
- New FSG reports corresponding to global consolidated ledger to report consolidated financial statements from US, Canada, Ireland and Australia is created.
- Configured and set up the Fixed Asset Corporate Book as well as the Tax Book.
- Created new Accounting method to fulfill the requirement from fixed asset to team.
- New SLA ADR is created to accommodate different accounting snapshot for Fixed Asset module.
- Created customized WEB ADI template for accounting group for reporting and Journal upload respectively.
- Design and set up of Consolidation rule to perform revaluation of GL balances of Ireland, Australia and Canada journal balance to parent ledger.
- Worked on configuration of corporate book for US, Australia, Canada and Ireland.
- Implemented fixed Assets module to implement corporate assets. Coordinated closely with accounting team to reconcile GL Account balances to asset history. Worked with AP to cleanup capital goods purchase invoices to correctly populate Mass Additions for import into FA. Completed post CRP reconciliations to ensure converted data reconciled to source system balances.
- Created additional Asset category and Depreciation methods based on the specific need of the customer.
- Prepared and designed the conversion mapping documents for Conversion/Migration of data (Supplier, Customers, Assets, GL Balances, Open AP, Open PO and Open Receipts) from legacy systems toOracle.
- Worked on set up and configuration of Cash management. Implemented the auto reconciliation functionality of payments and receipts from bank. Coordinated the entire cycle of testing activity and set up of in Oracle and working with US Bank IT team for completing of the testing activity.
- Worked on configuration and set up of Purchasing, design and implementation of approval process mechanism.
- Completed set up of AP Approval process with AME.
- Worked on configuration and functional design of rules for PO account generator for generation of charge account in PO.
- Implemented iExpense for employee reimbursement process. Conducted interactive session with business team to understand the audit rules, different policy like meals, travels and hotels for employee reimbursement and configured.
- Implemented iExpense approval process through AME.
- Configured Payable module for US, Ireland, Australia and Canada. Prepared BR.100 document and CV.040 document to capture configuration and conversion details respectively.
- Worked on functional design, configuration and documentation of Payable invoice conversion interface, Supplier and Supplier site import interface.
- Worked on payments process design, configuration, documentation and testing of check payment process through Oracle payment module.
Confidential
Environment: AP, CM, PO, GL
Functional Consultant
Responsibilities:
- Worked as a team lead for providing production support and performing user initiated enhancement for financial application such as GL,AP,AR,PO,FA and expense module.
- Apart from production support, implemented following solution to improve the efficiency of the financial system.
- Implemented oracle 1099 process for tax reporting. Worked on set up, validation, testing, reconciliation and documentation of 1099 process.
- Worked on a major SOX initiative to adhere to issues concern raised by quality team for Oracle user.
- Implemented Bank statement reconciliation feature to reduce the time of reconciliation of bank statement for payments and receipts.
- Created a new Issue Resolution Process for my team that helped us to reduce time lag in responding and resolution of the issues with improved efficiency by my team members.
- Impended a custom reporting solution to a bug related to Accrual Reconciliation at month end close period to improve turnaround time in closing the PO period.
- Responsible for working on debugging the issue, identification of resolution, testing the solution in development environment and migrating the solution to production.
- Worked with Oracle Support team in case of any issues in standard financial solutions by logging Service Request.
- Performed AP and PO functional setups such as new Banks and Bank Accounts, Supplier, Supplier Sites, Payment Terms, Profile Options, signing limits, approval groups, and approval assignments.
- Worked complex issues relating to month end and year end schedule.
- Introduced and implemented the automated 1099 Tax reporting in Oracle replacing the manual reporting process in existing process to my Confidential .
- Implemented the WEB ADI and Report manager to Accounting, Fixed Asset and Payroll team for usage of data upload and further usage by business team.
Confidential
Functional Consultant
Environment: AP and PO
Responsibilities:
- Created document for conversion activity for Supplier, Invoice, PO and Receipt conversion process.
- Worked on creation of test data strategy for CRP testing and created related test case document.
- Set up Web ADI for Journal Upload process, mass allocation rule, Cross validation rule and Security rule.
- Involved in Period Closing process for sub ledger module like PO and AP & Reconciliation with GL.
- Configured FSG Reports for customized Financial Statements - Division wise and Department wise Breakup of Expenses and Revenue and allocation of corporate and Branch expense to their divisions, products and departments
- Coordinating and lead the entire testing phase of the project for Oracle Payable and Oracle Purchasing which included initial of analysis, provide resolution of issues during the CRP and supporting reconciliation activity between sub ledger and gl.
Confidential:
Functional leaD
Environment: iExpense, General Ledger (GL), Accounts Payable (AP), AME, Order Management
Responsibilities:
- Responsible for end to end process for implementation of iExpense project for Dendreon.
- Conducted workshops and user interaction session with IT stakeholders to explain about the benefit of iExpense to the existing business process.
- Designed and performed the setup, configuration, functional design of custom solution and unit testing at the development and controlled environment.
- Worked with technical team members to work on custom solution development to report aggregate spend expensed in the expense report.
- Designed and implemented iExpense approval process through AME.
- Conducted and coordinated the complete testing cycle of the project and completed in within specific time.
- Implemented AMEX Corporate credit card process to sales employees for iExpense.
- Created and designed custom solutions to capture aggregate spend expenses that are a mandatory and critical feature in expense reporting in health care industry.
- Created user training document for the usage of the iExpense solution by the employees.
- Conducted workshops both onsite and for remote super users to provide training to employees.
- Implemented following solution to improve efficiency of financial system.
- Creating a custom solution to replace manual process of Order processing through McKesson with Systematic process with designing of interfaces with Oracle EDI format.
- Time consuming manual Invoice creation process and reconciliation was replaced with implementation of Pay on receipt process for some major vendor. It helped to reduce the time of Invoice and receipt processing for the impacted supplier.
- Implemented Web ADI with creation of custom template for asset addition to the Oracle.
- Worked on Internal Requisition (IR) and Internal Sales Order process (ISO) process.
- Worked with production support team to assist to resolve specific issue related to account balance reconciliation at the month end period.
Confidential
Onsite Lead: Finance Track
Environment: iExpense, iSupplier, PO, AP and GL
Responsibilities:
- Responsible for entire life cycle of implementation of iExpense and iSupplier module.
- At the initial phase, iExpense has been rolled out to more than corporate employees for my Confidential with replacement of 3rd party expense reimbursement process.
- Demonstrated the benefits and usage of iExpense to executives before start of the project.
- Interacted with the business user to assess the existing expense reimbursement process and gathered the requirement.
- Created the framework of iExpense process and conducted CRP with specific set of user to ascertain preliminary feedback.
- Performed CRP and UAT with business user and responsible for successfully completion of the testing process.
- Conducted workshops after the roll out of the project to perform a user training session with employees.
- Prepared user manual to use expense report process for employees.
- Responsible for identification, analysis, documentation, configuration and testing for entire life cycle of the project.
- Performed System Administration tasks such as setting up custom responsibilities, function /menu exclusions, updating user profiles iSupplier & Core, setup DFFs/Value Sets/Values.
- Performed CRP and UAT with business user and responsible for successfully completion of the testing process.
- Conducted workshops after the roll out of the project to perform a user training session with SME team member from my Confidential .
Confidential
Onsite Lead/ Functional Consultant
Environment: Oracle Financial, Accounts Payable (AP), AME, Purchasing (PO), Accounts Receivable (AR), General Ledger (GL) and Cash Management (CM).
Responsibility:
- Responsible for studying the business process.Prepared AS-IS understanding document for financial modules to demonstrate existing process flow for financial modules like PO, AP, CM and AR module.
- Coordinating and lead the entire phase of the project for AP, PO, AR and CM which included initial of analysis, conversion strategy, business process re-evaluation and solution design.
- Worked on preparation of set up document (BR.100) for Payable, Receivable, Purchasing and Cash Management.
- Worked on configuration and set up of payment module. Configured check and credit card payment process.
- Designed the conversion strategy for Open Purchase Order, Unbilled Receipt and Open Invoices. Created conversion strategy document (CV.040) and performed reconciliation of converted data with source system with required testing.
- Designed the custom AP interface to integrate Legacy Payable system with Oracle. Netting process is set up to handle supplier/customer balances for improvement of efficiency.
- Set up new SLA rules for Supplier invoices and Assets.
- Implemented the PO approval process through AME in place of workflow process that was existing in 11i.
- Configured and designed the rules for customization of PO account generator to derive charge account.
- Worked on set up of CM. Automatic reconciliation of Payments and receipts with help of bank statements are configured.
- Worked on setting up of AR module. Set up auto lock box to process the receipts.
- Designed test plan and testing strategy for CRP and UAT.
- Conducted the CRP and UAT testing successfully with business team with providing immediate support and helping the business team to complete the testing process on scheduled time.
- Successfully conducted a user training with creation of user training manual and demonstrating the process flow for financial modules for procure to pay track.
Confidential
Track Lead Finance Team
Environment: Oracle Applications, General Ledger (GL), Accounts Payable (AP), Accounts Receivable (AR), Purchasing (PO) and 170 Mark view.
Responsibilities:
- Coordinated and lead the entire phase of the project which included initial operations analysis, business process re-evaluation, testing, training, conversions, customizations and documentation and implementation of modules.
- Created MD.20 and MD.050 document for a project life cycle.
- Studied the Required business processes and suggested alternate ways to accomplish the same through Non-Customizations of Oracle Application in 11i. Business Processes which does not fall under the Standard features within Oracle were analyzed and required customizations were made in the Oracle system to accommodate the Business Process.
- Designed Custom AP interface process for inter company affiliate reconciliation and settlement of AP invoices.
- Performed AP and PO functional setups such as Banks, Bank Accounts, Supplier, Supplier Sites, Payment Terms, Financial & Payables Options, Profile Options, signing limits, approval groups, and approval assignments.
- Involved in the Setting ups Transaction Types (Invoice Types), Auto Accounting Setups, Invoice Types, AR Batch sources, remit to addresses, Receipt Classes and Payment Methods, Adding and Maintaining Suppliers and Customers etc.
- Prepared the test plan and test cases for different stages of testing cycle. Designed data strategy that was used for testing and reconciliation of month end close testing process in the UAT.
- Lead and conducted CRP and UAT testing with providing resolution of the issue raised during the testing process. Designed the conversion strategy for Purchase Order, Receipts and Invoices. Performed reconciliation of converted data with source system.
Confidential
Onsite Lead
Environment: Oracle Applications, General Ledger (GL), Accounts Payable (AP), Accounts Receivable (AR), Purchasing (PO), I expense, Cash Management (CM), and 170 Mark view Imaging system.
Responsibilities:
- Worked as a team lead for providing production support and performing user initiated enhancement for financial application such as GL,AP,AR,PO,CM,FA and expense module.
- Apart from production support, implemented following solution to improve the efficiency of the financial system.
- Implemented integration of American Express credit card the expenses to process employee expenses through corporate credit card.
- Implemented oracle 1099 process for tax reporting. Worked on set up, validation, testing, reconciliation and documentation of 1099 process.
- Worked on a major SOX initiative to adhere to issues concern raised by quality team for Oracle user.
- Implemented a custom imaging solution provided by Wipro in place or Mark view that was intended for improve the efficiency and reduce the cost of the imaging solution for AP team.
- Implemented Auto reconciliation feature to reduce the time of reconciliation of bank statement for payments and receipts.
- Designed and implemented a custom solution to replace existing Non Oracle Sony Logistic Application. It helped to improve efficiency in recording logistic transaction to Oracle and settlement of logistic transaction with less time at month end close period.
- Created a new Issue Resolution Process for my team that helped us to reduce time lag in responding and resolution of the issues with improved efficiency by my team members.
- Impended a custom reporting solution to a bug related to Accrual Reconciliation at month end close period to improve turnaround time in closing the PO period.
- Responsible for working on debugging the issue, identification of resolution, testing the solution in development environment and migrating the solution to production.
- Worked on various issues relating to FSG, MRC, Revaluation, Translation and Consolidation process.
- Worked with Oracle Support team in case of any issues in standard financial solutions by logging Service Request.
- Performed AP and PO functional setups such as Banks, Bank Accounts, Supplier, Supplier Sites, Payment Terms, Financial & Payables Options, Profile Options, signing limits, approval groups, and approval assignments.
- Involved setting ups Expense Report Templates and creating expense reports.
- Experience with setting up of Transaction Types (Invoice Types), Auto Accounting Setups, Auto lock box Auto invoice process, Grouping rule, Invoice Types, AR Batch sources, Remit To addresses, Receipt Classes and Payment Methods, Adding and Maintaining Suppliers and Customers etc.
- Worked complex issues relating to month end and year end schedule.
Confidential
Onsite Lead
Environment: Accounts Payable (AP), Purchasing (PO), Accounts Receivable (AR), Oracle Financial
Responsibilities:
- As a functional consultant, responsible for studying the business process. Prepared AS-understands document for AP, PO and AR modules.
- Assisted in business process reengineering, created TO-BE process document for AP, AR and Procure to pay process module in Oracle Financial.
- Prepared functional design document and Test case document for custom enhancements.
- Assessed the current use of Oracle applications and the mapping of new features and functionality of 11.5.10 to the functionality required in the present company environment.
- Responsible for providing identification, analysis, documentation, configuration and testing for procure to pay process of the project.
- Also involved in preparing test cases as per the requirement, testing all Configuration, Set up, end to end processes, interfaces, reports and conversion programs, coordinate with super user for testing.
- Responsible for attending Confidential meetings on giving project status, plan etc.
- Participated in CRP, UAT, Go live activities and Post implementation support had extensive business user interaction during each phase of implementation.
- Worked on all phases of implementation, involved in various stages of projects.
- Also worked as a functional Lead for new 11i new invoice approval process using AM and implemented successfully which has got high visibility in the organization.
Confidential
Environment: Oracle Applications, General Ledger (GL), Accounts Payable (AP), Accounts Receivable (AR), Purchasing (PO), iExpense, iSupplier, Cash Management (CM), Fixed Asset (FA)
Responsibilities:
- Responsible for providing production support and resolution of the issues created in the ticketing system.
- Interaction with onsite teal lead for requirement gathering for issue and enhancements regarding standard and custom solutions. Analysis of functional and technical issues involved in standard and custom financial applications.
- Worked extensively on providing functional support for issues related to Month End Processes, GL reconciliation, Accrual Process, Period End Closing, MRC, Revaluation, Translation and Financial Statement Generator (FSG) process.
- Defined formulas for Mass Allocation and Recurring Journals. Completed setup of options required to perform Mass Allocations.
- Worked on issues pertaining to all modules in financial module.
