Oracle Financial Functional analyst
Resume:
OYIEKO, Elizabeth, PMP
Oracle Financials Functional Consultant
ac5omh@r.postjobfree.com
Highly organized and dynamic project management professionalwith 10+ years’ experience in private, government and non-government institutions providing comprehensive research/analysis, planning, coordination, communication management, process development and audit of projects
Proffessional Summary
Substantive 9 years of experience as an Oracle Functional Consultant with expertise in R12 version.
Practical experience in analyzing, developing, customizing, implementing and testing Oracle Apps solutions with rich knowledge of the Financial Modules.
Worked in different roles such as a Functional Consultant and Support Analyst with mid-size team of analysts to successfully deliver tasks in a timely fashion.
End-to-End Implementation experience on the following Oracle Application modules - AP,AR,FA,GL, iExpenses,EB Tax.
Direct interaction with end users for requirement gathering and architecting the To-Be processes
Extensive experience in conducting Conference Room meetings and end user trainings
Sound knowledge of Sub ledger Accounting (SLA) in Release 12.
Good understanding of Order to Cash (O2C), Procure to Pay (P2P) and Acquire to Retire business life Cycles
Interaction with Oracle support to resolve application issues through SR/TAR.
Experience in using Application Implementation Methodology(AIM) documentation(BR100, TE40, RD20, MD50, BP80, and CV40)
Good understanding of Accounting Principles, US GAAP and business flows.
A clear understanding of the functionality of the core Oracle Financials modules and their interplay in the overall accounting structure of an organization.
Worked on Data Conversions from Legacy system to Oracle using Web ADI and standard interface.
Research, Business Growth and Analysis: Proven track record of accurately analyzing research data, creating reports, documenting and managing information, managing grants, recommending market strategies, and business process-development efforts within time and budget requirements.
Risk/Change Management: Skilled at evaluating project and program procedural processes and recommending new or changed approaches that reduce redundancy, improve accuracy and efficiency, and achieve organizational objectives. Success at creating innovative project monitoring, evaluation and audit systems.
Project Coordination: Effective project manager focused on planning complex, critical organizational operations; identifying strategic goals and priorities, and resolving issues using knowledge and expertise in current and emerging social research methodologies. Successful team builder and mentor.
Communication Management: Collaborative advocate capable of both individual coaching and group facilitation. Excellent written and oral communication skills with proven success building consensus and negotiating outcomes.
Technical Skills: Advanced skills in Microsoft Office Suite, Web ADI, Toad, Data Loader, SQL*Loader, SQL*Plus
Advanced Skills in use of Visual Paradigm tool for Business Process information modelling and Management of processes
Academic
Master of Science (Project Management)
Bachelor of Education
Certification
PMP, Project Management Institute, 2018
Professional Experience
Milgard Manufacturing – Tacoma, WA (June 2016 – ToDate)
Role: Oracle EBS Financial Functional Consultant
Description
Implementation and Support of R12.2.3 AP,iExpenses, AR, GL
Support and Enhancement of existing systems with extensive reporting needs, integrating with Customers, Suppliers systems and other third party systems
Responsibilities
Working extensively as part of requirement gathering, current business process analysis, re-engineering and designing of business process, system configuration and system testing in the P2P and O2C cycles.
Responsible for GAP and FIT GAP analysis, creation of Setup Documents and Functional Design Documents. Conducted CRP and UAT Sessions.
Responsible for creation of MD050 for custom objects, and BR100 setup documents.
Working on an offshore model, as part of a team of 9 members.
Implementing Payables, Receivables and iExpenses for Tacoma, Portland and Temecula.
Responsible for designing various custom interfaces outbound and inbound between Oracle and Legacy systems/Third Party/Banks inclusive of Invoice Interfaces, Customer and Supplier Outbound, Bank Statements, Remittance Advices.
Designing Custom ACH CTX format for Corporate Card Program, worked on EDI 810 Invoice Outbound program, 820 Inbound Remittance Advice, worked on Custom Process for Cancellation of Journal Workflows and resubmissions and custom notification for iExpenses related to Compliance Issues.
Working Extensively on Custom Templates for ACH payments, Checks, Positive Pay files with several customizations on these templates.
Creating design documents for Form personalization, AR SLA customization and WF customizations.
Working on integration with Document Imaging Services like Docuware. Integration of Invoices, Transactions, Customer Statements, Remittances into Docuware.
Providing active support for modules including AP, AR, GL, CE, iExpenses on a daily basis.
Working on Service Now for Incident Handling, Creation of Enhancement requests, Stories and Scrum Tasks.
Raising SR’s with Oracle Support, involved in OWC and resolved issues.
Client: Lattice Semiconductor Corp, Portland, ORJanuary 2015 to May 2016
Role: Oracle Financials Consultant
Description: Oracle R12 implementation
●Defined systems’ strategy, developed systems requirements, designed and prototyped, tested and trained users.
●Provided solution design to R12 Project implementation.
●Designed, developed and documented functional specifications for reports, interfaces, conversions, extensions and workflows related to Inventory, Order management COGS
●Mapped and validated conversion data.
●Evaluated the current business processes and advised on new R12 features and functionalities that could be implemented.
●Part of solution for EDI external facing documents design.
●Raised issues and worked resolutions as they came up to ensure adherence to the project schedule.
●Participated with the respective client functional lead throughout system testing.
●Provided guidance to the respective client functional lead in the preparation of training materials and class agendas.
●Designed and implemented Revenue recognition contingencies for client specific requirements
●Worked on integration of Payments with Wells Fargo bank.
●Implemented solution to handle point of sales/Disti revenue & cogs with a custom bolt on for third party system ‘ Azerity’
●Worked on integration of Payables Processing with ‘Accelim’ tool. Accelim tool is a third party system capable of using the Optical recognition technology to process supplier invoices.
Mercury Marine – Fond du Lac, WI (October 2013 – December 2014)
Role: Oracle EBS Financial Functional Consultant
Description: Implementation of R12.1.3 GL, AP, FA and few areas in AR, and E-B Tax (End to End Implementation through to Go-live and Support)
Responsibilities
Worked extensively as part of requirement gathering, current business process analysis, re-engineering and designing of business process, system configuration and system testing.
After analyzing the Business processes and workflows, defined various responsibilities for single application and assigned to users.
Identification of Gaps and providing Workaround solutions for the Gaps.
Designed Key Accounting Flex field structure (COA) for Ledger and configured with Multi Org and Multi Reporting Currency setup. Defined system controls, intercompany accounts, summary accounts, journal sources, and journal categories. Defined various currencies for multi-currency operations and currency translation, conversion, revaluation to meet the requirement. Cross validation rules were setup for various GL codes. Configured Sub-ledger accounting process to GL. Defined Security rules at segment level.
Reviewed current business process and documented the business procedures for Procure to Paycycle. Dealt with Buyer Setup, RFQ, and third party custom POs. Also dealt with Outbound POs through EDI.
Payables process was designed and system configured and setup for(Financial option, Payable system option & Payable option) to meet the requirements such as batch invoices, batch payments, employee expense report process, withholding tax, 1099 reporting, cross currency invoices and payments.
Performed manual conversion of Fixed Assets with using Web ADI and review other steps with FA Mass Additions, Asset transfers, Asset depreciation,
Reconciled FA balances with GL balances at Company and Account level combinations.
Configured CRP’s, Prepared Test Scripts, Test plan, Test Scenarios, User Manuals, plan for UAT, user feedback integration.
Prepared Cut- over Plan, Listing down all Pre & Post Go- live tasks. Involved in Post-Production support.
Developed and tested multiple financial statements generated using Financial Statement Generator (FSG)
Created/Maintained Business process Documents BP-80,RD-20,BR-30,BR-100,MD-50,TE-40,CV-40 for requirement gathering, process design, system configurations, custom reports, discoverer reports and conversions (RICE) and test scripts in AIM methodology as part of project implementation task.
Involved in preparation of various scenarios on Financial Modules considering different business assumptions.
Application Support and troubleshooting of issues on R12 Oracle Financial modules.
Involved in making the detailed Project Test Plan regarding the scope and focus of the testing (TE 10).
Interacted with Oracle Support whenever needed, and coordinating with Oracle via Metalink for product related issues.
Maintained and updated issues Log for reporting the status of the issues and conducting issue status meetings with users on weekly basis.
Owens and Minor, Richmond VA September 2012 – August 2013
Role: Oracle Business Analyst
Description: Oracle Apps 12.1.3 Modules:(GL, FA)
Responsibilities
●Worked as part of the Finance team in Upgrade project from 11.5.10.2 to 12.1.3 (Fixed Assets)
●As a Functional Consultant reviewed and analyzed current business processes in 11.5.10.2 and explained new features to business users in R12.
●Coordinated the effort for the Monthly Releases (Release Management).
●Involved in technical discussions for migrating the code and validated the code by testing in Test and QA before moving the PPM Packages to Production
●Prepared issues list, Risk plan, change request forms and regular client status reports.
●Prioritized the tasks for the team based on feedback from the client meetings, number of defects and project progress
●Gathered detailed user requirements and educated the users on high level system. Explored alternative ways of meeting user requirements through improving business process & system configurations.
●Worked on Functional Specs (Additional Requirements from Users).
●Configured, Conducted Training sessions and Prepared Training Material for Report Manager in R12.
●Conducted CRP Sessions for the business users.
●Worked closely with the business users for validating the system once the upgrade is completed.
●Helped the business users in taking the key validation reports before and after the Upgrade.
●Involved in technical discussions for migratingthe code and validated the code by testing in Test before moving the PPM Packages to Production.
●Performed User Acceptance Test (UAT) & Training for the end user on business process and procedures based on Financials modules.
●Interacted with the client on regular basis to apprise them of the progress of the project activities.
●Coordinated with Off-shore team members.
●Coordinated with other members in the team to resolve the issue through raise a Service request (SR) TAR in Metal ink.
K12 Inc. Herndon VA Jan 2011 – Aug 2012
Role: Financial Functional Analyst
Description
Oracle Enterprise Business Suite R12.1.3 implementation.Oracle R12 GL, AP, AR, iExpense
Responsibilities
Responsible for implementing Accounts Payables, Receivables, General Ledger for all 6 business units of K12 from requirement gathering phase to production cutover and support.
Identified standard functionalities and gaps for Accounts Receivables, Payables and General Ledger
Set up Accounts Payables for PO matching and non-matching supplier invoices, payment profiles for check, wire and ACH, sub ledger accounting of payables transactions and transfer to General Ledger
Set of Accounts Receivables for invoice transactions including auto invoicing from Order Management and Service Contracts, auto application of receipt application to invoices using auto lockbox functionality, sub ledger accounting.
Conducted 3 CRPs, UAT and end user training
Prepared BP 040, BP080, test scripts and BR 100 documents
Responsible for customer data conversion, customer interface, open invoice conversion, report customizations.
DMJM Harris-AECOM, Baltimore, MD (Feb 2010 – Dec 2010)
Role: Oracle Financial Functional Analyst
Description: Upgrade from 11i to R-12 on GL, AP and P2P cycle.
Responsibilities
Involved in Data Conversions, Developing, customizing reports and interfaces in GL Module i.e. Journals importing from mainframe legacy system using SQL Loader
Involved in the Functional Setup of GL and AP
Month end support in financial modules AP and GL
Registration of Concurrent Programs and Request Sets in AOL and System Administration
Customized the Invoice Aging and Customer Balance Report in AR
Used Standard Oracle API’s to check holds on the invoice
Gathered, analyzed and wrote detailed business requirements, user profile, created workflow processes documents and charts
Knowledge of Performance tuning of various queries and stored procedure
Involved in post-production troubleshooting exercises, bug fixes, raising TAR's and working with oracle support for escalating issues and finding resolutions
Developed several BR 100s on required reports to fulfill the business need
Created Accounting Flex Field Structure; Chart of Accounts; Set of Books, Mass Allocations and Summary Template. Tested features Translation, Reevaluations, and consolidation. Designed FSG Report for Budget Balance, Actual Balance and Funds Available
Involved in data conversion for data like supplier data, customer data and Address details
Prepared end user training material with specific business cases and conducted end-user training
Reviewed the existing reports and collected requirements to develop additional custom reports for engineering change order report, Warehouse summary report etc
Business process study and creating business process maps using Visio for Oracle E-Business Suite GL and AP modules implementation
Worked with business users to define their business requirements in preparation for developing program solutions and translated the requirements into R12 Processes
Identified gaps between system processes and Business processes and documented using Gap Analysis Document. Also analyzed and indicated proposed workarounds and resolutions
Was part of team involved in the cut over planning and execution including finalizing the processes, scenarios and ways to handle exceptions, executing and monitoring of cut over activities
Netherlands Development Organization (SNV)
Project Advisor, Education and IT 2009
Analyzed SNV education programs based on the organization’s vision of providing people the skills, services and opportunities needed to live a healthy and productive life, while sustaining natural resources.
Monitored and recorded client outcomes.
Researched and analyzed client records.
Collaborated and shared assignment data with SNV educational colleagues.
Effectively documented assignments researched and analyzed client data, conducted case studies, and shared results and recommendations with the Kenya Country Education Sector Group.
Improved SNV education services by developing and implementing program monitoring and evaluation systems based on client experience and outcome analyses.
Earth Institute, Columbia University
Role: Project Assistant 2006 to 2009
Analyzed community development needs and established project objectives in support of the Millennium Villages Project mission of enabling communities to become self-sustaining through investments in health, food production, education, access to clean water, and the building of essential infrastructures.
Drafted concept and fundraising program proposals. Provided ongoing performance improvement recommendations and technical support to sector extension agents and supervised project interns.
Developed, implemented, and documented community program monitoring and evaluation systems. Trained enumerators to conduct surveys and evaluations. Produced and documented program plans, determined budgetary requirements, and managed financial and procurement activities and procedures.
Collaborated with government ministries, stakeholders, and community leaders for the promotion of holistic community development through the formation and organization of community-based committees for education and other services.
Trained school administrators, teachers, and community stakeholders and provided technical support to community organizations until they achieved successful autonomy.
World Vision International
Graduate Intern (Project Management), 2004 to 2005
Provided planning, administrative, and management support for all aspects of the organization’s projects focused on working with children, families, and communities to overcome poverty and injustice.
Developed project design documents, proposals, operational plans, annual reports, and budgets. Implemented and monitored development plans.
Prepared and documented project materials to support evaluations, surveys, and learning activities.
Monitored and evaluated project performance and reported findings to stakeholders.
Facilitated and coordinated Community Based Organization (CBO) training and capacity assessments.
Monitored all aspects of project performance and produced monthly, quarterly, and yearly reports.
Contact this candidate