Financial Consultant--(independent Consultant) Resume
Alpharetta, GA
PROFESSIONAL SUMMARY:
- 20+ years of financial accounting and management with a strong functional background using Oracle financial suite.
- 15+ years Oracle Business Suite Functional/Set up/Configuration experience. GL SME.
- 6+ years Project Management
- 2+ years’ Workday Financials
- Consulting Nationwide for clients in the following areas:
- Project Management - Oracle Chart of Account (COA) conversion and Oracle FSG report Replacement
- Oracle Financial Functional Support (GL/AP/AR/I-proc/I-Exp/Purch/FA,INV)
- Oracle configuration setup's (Cross Val Rules, Security Rules, Mass Allocation, Segment Values, Sys Admin. Profile/Access control, Chart of Account Structure-Accounting String, Recurring JE’s, FSG’s, Expense Reports coding, Banking information)
- Oracle FSG SME (Financial Reporting and Analysis)
- Financial Reporting/Analysis
- GL Wand Report SME
- Desktop/Web ADI SME
- Staff (Oracle Financial Reporting M/E)
- Financial Reporting Soft Close Initiatives
- Interim Financial Reporting Management
- UPK Documentation and
- Quality Assurance Testing-Workday Financials Application
- Workday Project Management
- Workday Financials Lead
- Workday Release Management
- Workday Release review
- Workday multiple implementations support
- Workday Post Implementation Support-Financial
- Oracle General Ledger/Chart of Accounts re-implementation in R12 environment
- Oracle Fixed Assets module R12 support.
TECHNICAL SKILLS:
Technology and Tools: Oracle General Ledger Super User Oracle Financial Analyzer Super User Oracle FA / AR / PA / Functional User Oracle Procurement Card functional User Oracle I - Procurement Functional User Oracle I-Expense Functional User ADI Super User(FSG) Oracle Payables Functional User 11i, and R12 Oracle GL functional User Oracle GL Administrator Financial Accounting / Budgeting management Month End close reporting management Capital Budgeting management Project Management (Oracle System Conversions) Agile PM approach (SDLC, AIM) Inventory Accounting Intercompany Accounting Consolidated Statement Reporting management State and Local Tax preparation/Audit management Vertex tax application Super User Hyperion Financial Management User MS Project/Word/Excel/PowerPoint/Visio/LiveLink User Workday Financials and HCM Quality Assurance Testing Workday Project Manager Workday Financial Lead Oracle R12 Financials One Source Application user Oracle R12 Fixed Asset module
PROFESSIONAL EXPERIENCE:
Confidential
Financial Consultant--(Independent Consultant)
Responsibilities:
- Global Chart of Accounts Revision Project-Oracle R12 EBS Version.
- Lead Consultant performing the system conversion using a third party tool.
- Supporting North American Region financial reconciliation process with reporting tools (FSG, OBIEE, HFM, HPB) as required.
- Supporting the Testing, CRP,UAT.
- Performed Conversion
- Providing Post Conversion Support and reconciliation
- Supporting One Source Statutory Financial Reporting Application roll out for North America.
- Working with the OneSource Reporting application to map all selected entities and load prior year reporting data into new system.
- Perform reconciliation of data to prior year reporting.
- Load all historical notes/tables into entity structures and make format revisions as required by management.
- Supporting the Fixed Assets and Corporate Reporting group.
- Compilation and presentation of Fixed Asset account lead schedules monthly.
- Preparation/processing of monthly depreciation vis Oracle R12 FA module.
- Units of production depreciation calculation.
- Useful life depreciation calculation.
- Perform quick additions of assets in FA module as required.
- Perform Asset transfers as required.
- Monthly Oracle Account Reconciliation process performed for selected Entities Fixed Asset Accounts (General Ledger vs Sub ledger Balances).
Confidential
Workday Financials Lead-(Independent Consultant)
Responsibilities:
- Workday Financial/HCM implementation
- Supported Financial Design
- Lead financial data migration/validation of legacy to Workday tenant.
- Developed EIB’s to load historical legacy data.
- Worked with client on End to End functional testing.
- Supported creation of reporting tools.
- Created Workday Financial Job Aids
- SaaS environment.
- Performed Data validation for migration to Gold tenant.
- Provided Sys Admin support, assigning access as needed to test functionality in test instance.
- Worked with client to identify and create required reporting in the Workday system.
- Supported client developing client reporting in Workday (developed reports, custom reports).
- Reviewed WD 25 enhancements and how they impact the client.
- Worked with finance client to in corporate the new workday financial apps into the month end close and reporting cycle.
- Performed Post go live production support to finance team to perform first month end close and reporting.
Confidential
Workday Project Manager-(Independent Consultant)
Responsibilities:
- Workday Release Manager-Weekly and Bi-Annual updates.
- Compiled and distributed weekly Workday updates being loaded to Production and also new functionality being placed in Preview tenant to review.
- Reviewed, compiled, and communicated to Finance/HCM/Payroll areas, new functional updates coming to production.
- WD 22, WD 23, WD24 Set up Required Functionality Catch up Project
- Reviewed and compiled all new functionality available to implement from past Workday updates that require set up.
- Worked with Finance/HCM/Payroll departmental teams to review new functionality available and select items to set up, test, and migrate to production.
- Workday Special Projects Manager-Finance/Payroll/HCM
- Worked with the Finance/HCM/Payroll departments to roll out specific value add workday projects.
- Workday HCM Talent-Performance Review
- Project Managed State Reporting created in Workday environment.
- SaaS environment.
Confidential
Quality Assurance Support-(Independent Consultant)
Responsibilities:
- Member of the QA team responsible for testing the Workday Financials integrations and configurations for a Workday Financial application implementation.
Confidential
Sr. Financial Consultant/Project Manager -(Independent Consultant)
Responsibilities:
- Oracle GL chart of account Replacement consulting.
- Oracle FSG Report Replacement consulting.
- Oracle Discoverer Report Replacement consulting.
- Federal and State Tax Management consulting.
Confidential, Alpharetta, GA
Oracle Senior Consultant - (Independent Consultant)
Responsibilities:
- Supported Oracle R12 COA rationalization across company.
- Supported Oracle R12 COA workshops with finance, accounting, and operations team and provide leading practices.
- Analyzed difference between COA structures.
- Developed approach to rationalize structure and code combinations into a common COA and code combinations based on leading practices in Oracle R12.
- Recommend future-state Oracle R12 COA structure.
Confidential
Sr. Oracle Functional Consultant/Project Lead-(Independent Consultant)
Responsibilities:
- Performed Oracle Financial Process/ Reporting Review.
- Updated FSG Company Reporting using ADI application.
- Project Lead on GL Wand Application Review/Implementation.
- Re-built current Oracle financial reporting in GL Wand environment.
- Reviewed current Oracle Reporting and proposed Pre-work to be performed prior to R12 migration.
- Supported IT members on Oracle 11i application/data clean up projects.
Confidential, Salt Lake City, Utah
Project Manager/Sr. Oracle Financial Consultant-(Independent Consultant)
Responsibilities:
- Oracle Garnishment Management System update to EFT payments
- Oracle Project Manager on Set Books Merge Project
- Oracle Project Lead on P-Card Integration Project
- Managed Chart of Accounts conversion.
- Managed Oracle Calendar Conversion.
- Managed Oracle Currency Conversion.
- Performed Application Performance Analysis.
- Performed Multiple Oracle Business Suite Functional Testing.
- Created and Maintained Project Documentation on LiveLink.
- Worked with 3rd party vendors.
- Worked with Oracle to resolve service requests.
- Provided interim Accounting support to the North America Finance Department.
- Performed various Oracle Application cleanup projects.
- Utilized Eprentise Applications.
Confidential, Bowling Green, KY
Oracle Financial Consultant-(Independent Consultant)
Responsibilities:
- Supported Post Oracle inventory conversion go live issue resolution.
- Project Support for 9i to 11g Oracle upgrade Project.
- Created project documents, project plan, and UAT test scripts.
- Performed research and proposed replacement applications for Oracle Financial Analyzer.
- Worked with Oracle A/R interfaces, identifying errors, and working with business group to resolve.
- Performed research and resolved Oracle Inventory and Order management issues.
- Worked with Red Prairie Warehouse Management System and Oracle Inventory to bring systems in balance.
Confidential, Salt Lake City, UT
Consolidation Analyst/Project Manager (Independent Consultant)
Responsibilities:
- Managed monthly financial close and consolidated financial reporting.
- Performs M/E closes, consolidated financial statement preparation for joint venture North America region companies including Canadian mines.
- Maintained monthly North America inter-company transactions and reconciliation.
- Performed monthly Oracle GL account maintenance for North America Region.
- Seconded to Toronto Canada Corporate office for six month Global Chart of Accounts project. North America Regional Representative.
- Supports Accounting Department with Report Application(Oracle 11i)
- Trains North America regional accounting staff on reporting applications as required.
- Supports the annual management of company budgeting process.
- Project Manager on conversion of North American chart of accounts. Utilized Eprentise Application.
- Project Consultant on conversion of Parent Company office Toronto Canada chart of accounts. Utilized Eprentise application.
- HFM reporting and reconciliation for corporate consolidated reporting.
Confidential, Bowling Green, Ky
GL Manager/Tax Manager
Responsibilities:
- Manages monthly financial close and consolidated financial reporting.
- Performs M/E closes, variance analysis, consolidated financial statement preparation, and narrative and quantitative variance explanations and recommendations.
- Maintains monthly inter-company transactions and reconciliation.
- Performs monthly Parent Company Reporting, Quarterly SEC.
- Manages a staff of seven. Staff Accountant, Senior Accountant, Clerks.
- Maintains Company Retail and Corporate Reporting in Oracle 11i.-ADI.
- Supported Corporate Accounting Department with Report Application
- Trained staff on reporting applications as required.
- Performed periodic physical store inventories.
- Supported the annual management of company budgeting process.
- Worked with auditors perform yearly audit of the company.
- Managed tax staff, performing monthly SALT reporting.
- Performed tax research as required.
- Managed Company Sales tax audits.
Confidential, Orlando, FL
Accounting Supervisor
Responsibilities:
- Participated in implementation of new company financial reporting (Oracle Financial Analyzer).
- Performed M/E closes, variance analysis, consolidated financial statement preparation, and narrative and quantitative variance explanations and recommendations for 60 plus profit centers.
- Perform Annual Company Intercompany closing project.
- Interview and hire staff. Perform evaluations.
- Supervise a staff accountant in corporate accounting department.
- Support Corporate Accounting Department with Report Application
- Train staff on reporting application as required.
Confidential, Orlando, FL
Senior Financial Analyst
Responsibilities:
- Perform M/E closes, variance analysis, consolidated financial statement preparation, and narrative and quantitative variance explanations for entire state of Florida (400 plus properties).
- Managed functions for customer service department.
Confidential, Orlando, FL
Information Resource Manager
Responsibilities:
- Worked with federal and state regulators to gather and maintain all compliance reports for all fifty states.
- Responsible for gathering and maintaining Secretary of State reporting requirements for client companies to operate in all fifty states.
- Responsible for creating and updating all client FCC reports for all compliance-reporting clients.
- Maintained accuracy in the compliance-reporting database.
- Interviewed, hired, and trained support staff.
Confidential, Orlando, FL
Oracle Financial Analyst
Responsibilities:
- Created system financial reports via Oracle financial applications (FSG).
- Produced financial analysis for multiple locations using various accounting applications.
- Compiled and loaded budgets for over thirty properties.
- Developed consolidated Budget reporting for company in the budget process.
- Created variance reporting for all company locations and departments.
Confidential, Orlando, FL
Financial Analyst
Responsibilities:
- Prepared monthly area F&B financial statements.
- Performed various financial analysis for the Food and Beverage Line of Business.
- Prepared annual budgets for Food and Beverage operations based on meetings with operations management.
- Prepared rate/volume variance analysis reports for the F&B line of business.
- Provided 29+ Food and Beverage managers with financial analysis.
- Performed inventory system analysis and reconciliation.
Confidential, Sedalia, KY
Senior Public Accountant
Responsibilities:
- Prepared individual, partnership, and corporate income tax returns.
- Analyzed client financial data and presented financial statements.
- Consulted with client companies in developing operating budgets.
- Prepared and processed client payrolls and related tax reports.
- Worked with client companies, developing projected financial statements, cash flow statements, personal financial statements, and loan applications.
- Performed all financial and administrative tasks related to the accounting office.
- Responsible for the review, implementation, and maintenance of all office computer systems.