Oracle Financial Functional Analyst
Resume:
C. Wanjiru Bachia (Korry)
**************@*****.***
PROFESSIONAL SUMMARY
9+ years’ experiencein ERP Implementation, Customization and Production Support of Oracle E-business Suite Financial Modules which include General Ledger (GL), Accounts Payable (AP), Accounts Receivable (AR), Fixed Assets (FA) and Cash Management (CM).
Experience in Oracle Applications Implementation projects, upgradation projects and Post Production support projects in both 11i and R12 versions.
Experience in ERP Functional Consulting, Oracle E-Business Suite Release 11i and R12, Financial Modules – General Ledger (GL), Accounts Payable (AP) including Payments, Accounts Receivables (AR), Cash Management (CE), Fixed Assets (FA), Purchasing (PO), Order to Cash (O2C Cycle), Procure to Pay (P2P Cycle) and Acquire to Retire (A2R Cycle) and Sub Ledger Accounting (SLA).
Worked on Functional Planning, System Design, Chart of Account Design, Requirements gathering, Gap Analysis, functional design, Configurations, Conversion, Data Migration using API, Chart of Accounts Mapping, GL Consolidation, Intercompany, Taxation, Sub Ledger Accounting, Localizations, Mass Allocations, Multi Org, Multi Currency, CRP, Testing and User Training.
Experience in documentation using the Application Implementation Methodology (AIM) documents such as RD020, BP040, BR30, BP080, BR100, MD050 and TE040.
Conducted CRP’s, providing functional training to multiple business user groups and co-ordinate UAT sessions.
Hands on experience in troubleshooting Production Issues in various modules.Expertise in coordinating large business user groups and offshore teams.
Understanding and working within software development life cycle on Agile and Waterfall testing methodologies. Ran SQL scripts and validated tables for proper entries per requirements documentation. Conducted regression testing, negative testing, stress testing, UI testing.
Extensive experience developing test plans, and test scenarios, Functional and Business Requirement documents. Experience in defect documentation and tracking, performing regression testing and prioritizing defects.
Experience working in UNIX, SQL, and Java based platforms.
Communication with key managers on Business and technicalrequirements in accordance with Customer requirements. Resource and Time management with regards to handling multiple projects and resources.
Excellent business and interpersonal skills, goal oriented. Aggressive Team Player with positive attitude.
TECHNICAL SKILLS:
Oracle Applications: R12 (12.0.6,12.1.2, 12.1.3,and 12.2.6)&11i (11.5.10.2, 11.5.8)
Modules: GL, AP, AR, FA, CE, SLA
Languages and Tools: PL/SQL, Discoverer Viewer, Web ADI, SQL Loader, Data Loader, Toad, Visio. Others: MS word, Excel, PowerPoint, Test Director, Lotus Notes, Access.
Methodologies: AIM (RD020, BP040, BR30, BP080, BR100, MD050 and TE040), Agile and Waterfall
EDUCATION & TRAINING:
Bachelor of Arts Degree (Economics & Public Administration)
Computer Programming and Concepts
Software testing methodologies and best practices
PROFESSIONAL EXPERIENCE
GDC Technics(Aircraft Modifications and Technology)
Fortworth, TX
Functional Consultant
R12 (12.2.6) AR, AP, CE –Fresh Implementation Jan 2016-Present
GDC is an aircraft modifications and technology company. I joined to assist in the re-implementation of the payables, receivables and cash management modules as well as perform tests on GL module.
Responsibilities;
Functional analysis, Requirements gathering, design and configuration for financial and statutory reporting.
Design test scripts for all business processes. Perform UAT testing and ensure functionality meets business requirements.
Perform regression testing on GL module ensuring proper data flow from accounting activities and events in the implemented modules.
Gap analysis, planning and mapping of the business processes to meet client needs.
Process documentation of standard and custom processes using AIM methodology.
Leading the CRP2 sessionsand providing clarification on the functionalities in each of the financial modules as well as working on and giving feedback to the client on all open issues discussed during the sessions.
Conduct Oracle functionality training to the end users based on business requirements.
Involved in the Functional implementation of Oracle Applications Financial including AP, AR and CE modules.
MRV Communications
Chatsworth, CA
Functional Consultant
Upgrade/Re-Implementation
11.5.10.2 to R12.1.3(GL, AP, AR, FA & CE Sept 2014 – Dec 2015
Assisted this communications equipment and services company in their re-implementation and upgrade project. Got in during requirements gatheringto migration phase.
Responsibilities;
Implemented R12 Financial Modules (GL, AP, AR, FA & CE), Acquire to Retire (A2R), Procure to Pay (P2P), and integration of Account Receivable module with legacy billing system.
Setting up the GL,AP, PA,CE,FA modules according to the business needs.
Created multiple responsibilities, developed security rules and customized menu to restrict user access to GL functionality as per clients’ requirement.
Defined formulas for Mass Allocation and Recurring Journals. Completed setup of options required to perform Mass Allocations.
Business process documentation for all modules using the AIM methodology (BP40/BP80).
Was involved in validating and coordination of business requirements and development of training material for end users.
Coordinating with management and technical teams across the company performing CRPs and system clarifications.
Analyze all business requirements and get user sign off with all relevant stakeholders ensuring business needs are catered for in implementation project.
Development of complex test cases for GL modules validating COA structure, Security and major functionality required by client before go live.
Performed UAT testing, documentation of bugs, coordination with technical teams to recreate system errors and re-test fixes including regression testing to ensure integrity of the system.
Functional lead for Documentation and testing ensuring team delivers according to project time lines in coordination with technical teams.
Ensuring conversion items are completed and balances reconciled with the legacy system e.g. open AR and open AP, GL Balances. Automatic reconciliation of bank statements by configuration of CE.
High Street Consulting
Home Away, Rockville MD
Functional Analyst October 2012 to July 2014
Implementation Project (Oracle R 12.1.3) GL, AR, AP, CE
Worked as a senior analyst with this vacation rentals company to implement the Oracle General Ledger, Receivables and Payables modules and integrate data from legacy systems to ensure minimum interruptions to business processes.
Responsibilities;
Requirements gathering and GAP Analysis.
Designing, COGS developing and documenting functional specifications for reports, interfaces, conversions, extensions and workflows related to Inventory, Order management
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.
Functional Setups for AP and AR modules.
Prepare and Conduct Conference Room Pilots (CRP1, CRP2, CRP3 and CRP4).
Writing test scripts and performing Functional Testing, Integration testing, UAT of all Financial modules.
Coordination of testing teams, status reporting and management of test documentation.
Developing Training Material for All Financials Modules.
Designing and Validating Financial Statements using FSG.
Designing of Key Accounting Flex field structure (COA) for General Ledger.
Involved in thoroughly testing GL functionality and validation of COA values.
Reports and recommendations for future upgrades as per business needs.
CVR Energy, Kansas City, Kansas
Functional Analyst July 2011 -Sept 2012
Business Integration 11i (11.5.8)GL, AP, AR
CVR Energy group is a petroleum refining and fertilizer manufacturing company whose headquarters is based in Sugarland, Texas. Worked with CVR energy on their Business integration project from requirement gathering till go live. The client had acquired a new business and were on the 11i platform and needed to integrate that new business into the 11i platform. Was mostly responsible for CE, AP and FA modules but occasionally worked on GL, Inventory, OM and Receivables, Modules
Responsibilities;
Comprehensive study of Current business processes, future business flow & identification of GAP/Workaround in order to provide an integrated information system solution to meet the business needs of the company.
Business Requirements Mapping and documentation (BR100) using AIM methodology for AR, AP, CE and GL modules.
Configuring/Updating Functional Setups of GL, AP, AR, and CE modules.
Develop Unit (TE.020) and System Integration Test Scripts (TE.050)
Perform Conference Room Pilot (CRP) and User Acceptance Testing (UAT)
Perform Train-the-Trainer and End User Training on Financials Modules
Support Business Users in Month End Close Process
Consolidations of Ledgers for Financials Reports
Support Business Users in Month End Close Process
Consolidations of Ledgers for Financials Reports
Create and follow up Service Requests from Oracle
Data Migration from Legacy systems and Open Interfaces
Schneider Corporation USA
Wisconsin
Functional Consultant
Implementation /Migration Oracle(R12.1.2) AR, AP, CE May 2010 – June 2011
Worked as a functional consultant with this transport logistics company to implement the Oracle Receivables, Payables and CM modules to integrate data from transport logistics systems to ensure timely payments to carriers through their factoring companies.
Responsibilities;
Prepared Test Scripts, Test plan, Test Scenarios, User Manuals, plan for UAT, user feedback integration.
Payables configuration: Responsible for setting up Bank, Suppliers, Payment Terms, Invoices, Invoice matching, Expense Template. Engaged in Vendor and open Invoice conversion from legacy systems.
Receivables configuration: Customer setup, Customer and Invoice conversion, Billing Statement, Lockbox processing, Cash application using Auto Cash, Consolidated billing, Revenue Recognition, deductions and adjustments.
Prepared Cut- over, documentation of Pre-& Post Go- live tasks and involved in Post-Production support.
Created/Maintained Business process Documents BP80,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.
Defined system controls, intercompany accounts, summary accounts, journal sources, and journal categories.
Defined various currencies for multi-currency operations and currency translation, conversion, revaluation for consolidation purpose.
Information verification as part of test process to ensure proper setups and configurations as per business requirements.
Work with technical team to resolve any outstanding issues and perform UAT and regression testing to ensure integrity of bug fixes on Oracle.
American Commercial Lines (ACL)
Jeffersonville, IN
Oracle Financials Functional Analyst
R12 (12.0.6)GL, AP, AR,-Post-Production support June 2009- April 2010
American Commercial Lines (ACL) is leader in the transportation and manufacturing markets. I joined the team mostly to assist in post- production issues that arose in the various modules and ensure they were resolved in a satisfactory manner.
Responsibilities:
Involved in supporting Month-end reconciliation for close inn GL, AP and AR modules
Preparation of impact analysis reports for critical issues for technical and management teams.
Testing fixes (regression and UAT) in test environment before pushing to production. Signoff on this from client.
Process documentation and updates based on changes made to system to facilitate business needs.
Prioritize, document and resolved all the issues which were raised in Bugzilla.
Interacted with Oracle Support to resolve critical issues through SR/TAR
Periodical status updates to PMO and follow up with pending business input or issue resolutions as part of status meeting.
Document recommendations for future system upgrades based on issues encountered and fixes or workarounds.
Perform minor setups to GL for COA values, responsibilities, profile options, new users etc. as per business needs.
Contact this candidate