David E. Russell
Princeton, NJ
*********@*****.***
EDUCATION
Rutgers University School of Business, BS, Accounting 1993
EXPERIENCE SUMMARY:
** ***** ** ********** **** the Oracle Financial Application modules including General Ledger, Fixed Assets, Accounts Payable, Accounts Receivable, Cash Management, and Projects.
Conducted Sales demonstrations of the Oracle Application.
Executed Business Process and Gap analysis of the end-users requirements for the Oracle Finance modules
Identified and designed enhancements based on the Business Requirements and Gap analysis.
Trained users directly, also conducted Train the Trainer session, and written training materials for the General Ledger, Fixed Assets, Accounts Payable, Accounts Receivable, Cash Management, and Project modules
Creative in designing workarounds within the standard Oracle processes and educating client personnel on configuration strategies.
Identified control risks within each module and how each module mitigates those risks.
Completed configuration and documentation of the General Ledger, Fixed Assets, Accounts Payable, Accounts Receivable, Cash Management, and Projects modules in conjunction with Client personnel.
Created Functional Design Documents for to provide guidance to our technical team to create technical designs documents.
Created Test Scripts, conducted User Acceptance Testing and Integration Testing of the modules supervised other consultants and client personnel and I have been responsible for management of the project and keeping Executives Sponsors informed of the status of the project. I participated in the training of users and the creation of training materials. I have worked with Oracle Support to resolve issues that occur during the project.
TECHNICAL SUMMARY
Oracle Financials R12, 11i, 11.03, and 10.7 SC Fixed Assets, General
Ledger, Payables, Receivables, Project Costing, Project Billing, Cash Management, ADI, Hyperion Financial Manager, PLSQL, Discoverer, OBIEE
Microsoft Office (Word, Excel, Project, Outlook, Access),
Visio
PROFESSIONAL EXPERIENCE
Louisville Kentucky Light & Energy Business Analyst/Project Manager Oracle Oracle EBS (Accenture)
March 2020 – Present
Design Segregation of Duties Matrix/SOX Controls for the Oracle Application
Configure General Ledger and iReceivables
Author Functional Design Documents for Journal Approval
Willis Taylor Watson Business Analyst/Project Manager Oracle Cloud Financials (Accenture)
May 2019 – September 2019
Configure Oracle Payables Release 13 19C
Author Functional Design Documents for Supplier Conversion and Positive Pay
Design and Conduct Sprint Validation/CRP of Payables Functionality
Legg Mason Inc. Business Analyst/Project Manager Oracle Cloud Financials (Contractor)
June 2018 – April 2019
Drive Chart of Accounts and Organizational design including the number of Ledgers assigned to 15 countries
Solution Architect providing a customized solution for the Purchase Order Approval hierarchy and a 3rd Party Billing System Revpro to Oracle Accounts Receivable
Completed Customer and Invoice Conversion in Receivables
Configure (GL and AP)
Provide weekly status of the Project to the Core Team and Project Sponsors
Scholastic Inc. Business Analyst/Project Manager Oracle Cloud P2P (Contractor)
January 2018 – June 2018
Manage UAT Phase, tracking issues in Quality Center, working with Technical Team to drive issues to resolution
Configure UAT Environment for AP in order to resolve issues discovered during testing
Provide daily status of Testing to the Project Core Team and Project Sponsors
Develop training plan for the user community for Oracle P2P
Oracle Order to Cash Lead in R12 resolving production tickets and monthly close issues in the Order Management module
Willis Towers Watson Finance Manager (Contractor)
June 2017 – January 2018
Create FSGs (Balance Sheet and Income Statement) for the UK, Germany, and Sweden Business Units
Create and run Consolidation Sets for the UK and Ireland
Create and run Revaluation Templates for the UK and Ireland
Train users on SmartView HFM to create Balance Sheets and Income Statements
Train users to create FSGs in Oracle Report Manager
State Street Project Manager (Contractor)
August 2016 – March 2017
Plan and Manage the UAT phase for the (GL, AP, AR, FA, HFM, and GRC) modules for a R12 Upgrade in United States, Europe, and Canada from a business and logistical perspective.
Train users in the Payments process in R12
Reconcile GL Balances in Oracle and HFM
Create test plans for the (AP, AR, FA, and GRC) modules
Responsible for creating the test scripts for the (AP, AR, FA, and GRC) modules
Drive resolution of issues that occurred during the testing process
Completing weekly Status Reports and providing Project Financial results to the client’s Project Management Office (PMO)
Business & Decision Project Manager Keystone Foods (Contractor)
February 2016 – May 2016
Project Manager for a reimplementation Cash Management Project and a R12 Assessment
Configured the Cash Management module and a was the liaison between Wells Fargo and the client for Check Formatting and EFT Payment Formats
Completed weekly Status Reports and providing Project Financial results to the client’s Project Management Office (PMO)
Trained users in the Cash Management module
Provided Post Production Support of the Payables Module which includes configuring Positive Pay Formats in XML.
LinkedIn Project Manager (Contractor)
June 2015 – November 2015
Project Manager for a Portfolio of 10 Oracle projects while providing resource management and introducing project management best practices to LinkedIn. One of these projects included an implementation of Order to Cash in Singapore. This included data migration for Customers and Invoices as well.
Project Manager for an upgrade to Vertex O Series
Completed weekly Status Reports and providing Project Financial results to LinkedIn’s Project Management Office (PMO)
Worked with the LinkedIn's Project Management Office (PMO) to establish dash boards and score cards to measure the efficiency of their Project Road Map on a Quarterly and Annual basis.
Also, collaborated with 3rd party implementers to complete the Cutover Plan with Stage Gates for entry and exit for a Double Click project.
Computer Sciences Corporation Functional Lead (Contractor)
Client Dun & Bradstreet
October 2014 – February 2015
Functional Lead for a R12 upgrade for the Order to Cash Process for multinational client in Australia and New Zealand
Lead business requirement meetings for the Order to Cash process
Completed “As Is” and “To Be” Process Flows in Visio
Complete test scripts TE020 and TE050 for the Order to Cash process
Lead Conference Room Pilots for Order to Cash process
Completed BR010, BR050, BR100, and MD050 documents for the Order to Cash, Accounts Receivable module
Configured the Accounts Receivable module in Test and Gold Environments
Herbalife Enterprise Manager (Contractor)
November 2013 – June 2014
Project Manager for a R12 upgrade with (GL, FA, AP OM, AR, Payments, PO, OBIEE, HFM, and I-Procurement) at a Salem NC Manufacturing Location. This includes creation of the Cut-Over Plan for the upgrade
Lead Chart of Account Design and Legal Entity Organizational discussions and provided the final solution for the Chart of Accounts, Ledgers, and Legal Entities
Project Manager for an Oracle GRC implementation identifying risks and reporting the status of the Project on a weekly basis and leading the steering committee meetings
Create FSGs (Balance Sheet and Income Statement) for the Brazil, Mexico, and US Business Units
Managed 7 resources for Post Production Support of an 11i environment for the (GL, FA, AP, HFM, and AR modules) for 45 countries including Brazil
Lucidity Consulting (Contractor)
Client – Education Credit Management Corporation
May 2013 – July 2013
Project Manager for a R12 implementation with (GL, FA, AP, CE, Payments, PO, I-Procurement)
Lead Chart of Account Design and Legal Entity Organizational discussions and provided the final solution for the Chart of Accounts, Ledgers, and Legal Entities
Managed a team of 6 resources
Completed BR010, BR050, BR100, and MD050 documents for the GL, AP, CE modules
Completed configuration, testing, of the GL, AP, Payments, and CE modules
The functional Liaison between the client and J.P. Morgan Chase for the EFT Payment Format
Rolta Solutions (Contractor)
Client – Memphis Light Gas and Water
December 2012 – May 2013
Functional Lead for a R12 implementation with (GL, FA, AP, CE, Payments, PO, OBIEE, and I-Procurement)
Lead Chart of Account Design and Legal Entity Organizational discussions and provided the final solution for the Chart of Accounts, Ledgers, and Legal Entities
Completed “As Is” and “To Be” Process Flows in Visio for the Procure to Pay Process
Completed BR010, BR050, BR100, and MD050 documents for the GL, AP, CE modules
Managed 4 Rolta resources
Completed configuration, testing, and Post Production Support of the GL, AP, Payments, and CE modules.
The functional Liaison between the client and Citibank for the EFT Payment Format
Capgemini Financial Services (Full Time Employee)
Client – Home serve UK
February 2012 – December 2012
Project Manager for a R12 implementation with Client locations in Stamford CT and Birmingham UK (GL, FA, AP, CE, Payments, PO, I-Procurement and HFM)
Managed 12 Cap Gemini resources
Create FSGs (Balance Sheet and Income Statement) for the UK
Use of Web ADI for loading Journal Entries and Fixed Assets
Completed BR010, BR050, BR100, MD050, TE020, and TE050 documents for the GL, FA, AP, and CE modules
Completed configuration, testing, and Post Production Support of the GL, FA, AP, Payments, and CE modules
The functional Liaison between the client and Chase for the EFT Payment Format
Accenture (Full Time Employee)
Client – US Steel and Cisco
February 2011 – February 2012
Manager
Project Manager of a R12 OTC Implementation at Cisco for 17 Plant locations in 17 Countries which focused on Localizations for VAT and Invoice Formats based on their countries requirements
Lead the RTR R12 Implementations (GL, FA, PA, CE, XTR, COSTING, OM, AR, INV, and HFM) for multiple deployments including Europe. Managing 22 Accenture Resources
Managed and Designing the ETL and Consolidation Process for HFM
Managed combined Client and Accenture 40 resources
Very complex role managing projects at different stages of deployment simultaneously
Prepared and participated in Weekly Status PMO Meetings.
Provided Training and Post Production Support of the GL, FA, PA, and OM modules
Continuum Health Partners, New York, NY (Full Time Employee)
June 2009 – February 2011
Manager
Lead a team of 6 consultants responsible for implementing functional and technical initiatives for the Supply Chain Process at (Beth Israel and St. Luke’s Hospitals).
Executing the month end close of the Purchasing, Inventory, and Payables modules.
Provided Production support of the Oracle Financial modules (GL, AP, PO, INV, and FA) for the Finance Department.
Marvel Entertainment Incorporated, New York, NY (Full Time Employee)
September 2008 – June 2009
Senior Business Analyst
Managed a Financial Consolidating, Reporting, Budgeting, and Forecasting initiative using Hyperion Financial Manager as the solution.
Managed a Project that improved the Publishing Life Cycle Process time by 20%. and provided cost savings of 2 million dollars annually.
Trained users in HFM, Smartview, and Report Studio
Provided Production support of the Oracle Financial modules (GL, AP, AR, and PA) for the Finance Department.
Project Lead for a R12 Upgrade (GL, AP, AR, and PA modules)
Blood Systems Incorporated, Scottsdale, AZ (Full Time Employee)
March 2006 – August 2008
IT Auditor
July 2007 – August 2008
Conducted Software validations of medical device software
Completed Internal Audits h for SOX compliance, COBIT compliance
Executed a Linux Audit
Established controls for an implementation of EDI
Senior Business Analyst
March 2006 – June 2007
Provided Post Production support of the Oracle Financial modules (GL, AP, AR, FA, and PA) for the Finance Department.
Managed 3 Junior Analysts on various Post Production issues
First American Corporation, Santa Ana, CA (Contractor)
Oracle Financials Functional Consultant
June 2005 - March 2006
Completed configuration of Oracle Receivables, Oracle General Ledger.
Provided training materials for Oracle General Ledger 11i, Oracle Receivables 11i
Conducted end user training for Oracle General Ledger 11i, Oracle Receivables,
Ixia Inc, Calabasas, CA (Contractor)
Oracle Financials Functional Consultant
March 2005 - May 2005
Completed configuration of Oracle General Ledger, Oracle Assets 11i, Oracle Receivables,
Oracle Payables (Multi Reporting Currency, Multi Org Implementation)
Provided training materials for Oracle General Ledger 11i, Oracle Receivables, and Oracle Assets 11i
Conducted end user training for Oracle General Ledger 11i,
Oracle Assets 11i and Oracle Receivables 11i,
Implemented Oracle Internal Control Manager
Established Risk Controls based on SOX compliance for the Accounts Payable and Accounts Receivable processes.
Tested Risk Controls in Oracle Payable and Receivable modules
Department of Health and Human Services, Rockville, MD (Contractor)
Oracle Financials Functional Consultant
November 2004 - February 2005
Provided training materials for Oracle General Ledger 11i, and Oracle Receivables 11i
Coordinated the Test Plan in Mercury for General Ledger and Projects
Prudential Financial Services, Newark NJ (Contractor)
Oracle Financials Functional Consultant
April 2004 - November 2004
Completed configuration of Oracle Assets 11i, Oracle General Ledger, and Oracle Payables
Provided training materials for Oracle General Ledger 11i and Oracle Assets 11i
Conducted end user training for Oracle General Ledger 11i and Oracle Assets 11i
Create FSGs (Balance Sheet and Income Statement)
Established Risk Controls based on SOX compliance for the Accounts Payable and Fixed Asset processes.
Tested Risk Controls in Oracle Payable and Assets modules in Singapore as well as the United States.
Guthy-Renker, Palm Desert CA (Contractor)
Oracle Financial Functional Lead Consultant
September 2003 - March 2004
The Functional Financial Lead for the configuration of an Oracle based
Budgeting/Forecasting/Reporting System
Gathered requirements from the client and translated those requirements into
System Design Documents.
Managed 4 Oracle Developers during the development phase of the project.
Provided training materials and end user support to the client.
Boilermakers, Kansas City, KS (Contractor)
Oracle Financials Functional Consultant
May 2003 - September 2003
Completed configuration of Oracle Assets 11i and Oracle Receivables 11i for a multinational Labor Organization.
Gathered and Documenting Business Requirements from Business Users for Developers and the End User community.
Re-engineering and improved their Business Process for Accounts Receivable based on gathered Business Requirements
Created (EFT) Payment Process in Oracle Payables.
Provided training materials for Oracle Assets 11i, Oracle Receivables 11i
Conducted end user training for Oracle Assets 11i, Oracle Receivables 11i
Activision Publishing, Santa Monica, CA (Contractor)
Oracle Financials Functional Consultant
November 2001 - February 2003
Served as Functional Lead for an 11.03 to 11i upgrade for Oracle General Ledger, Oracle Assets, and Oracle Projects for an interactive entertainment company.
Gathering and Documenting Business Requirements for Developers and the End User community in order to create a new Accounting Flexfield i.e. Chart of Accounts.
Configuration Oracle General Ledger 11i, Oracle Assets 11i, and Oracle Projects11i,
Provided training materials for Oracle General Ledger 11i, Oracle Assets 11i, and Oracle Projects
Conducted end user training for Oracle General Ledger 11i, Oracle Assets 11i, and Oracle Projects
Served as a Business Analyst to convert Budgeting Forecast System from Excel to Oracle Financial Analyzer (OFA)
Created Reports (Balance Sheet, Income Statement, Budgeting Reports)
Built Reporting Hierarchies; Creating Dimensions, Dimension Values
Created Financial Data Items and Created Models
Trained End Users in (OFA)
VarTec Telecom, Dallas TX (Contractor)
February 2001 - November 2001
Oracle Financials Functional Consultant
Led a conversion from Solomon to Oracle 11i for Oracle General Ledger, Oracle Assets, Oracle Projects, and for an international Long Distance Carrier.
Gathered and Documented Business Requirements to assist Developers in creating Data Conversion and Data Interface programs
Served as a Business Analyst to convert their Budgeting Process from Excel Templates to Oracle Financial Analyzer.
Providing training materials for Oracle General Ledger 11i, Oracle Assets 11i, Oracle Projects, and Financial Analyzer
Conducting end user training for Oracle General Ledger 11i, Oracle Assets 11i, Oracle Projects and Financial Analyzer
AmeriCredit Corporation, Ft. Worth TX (Contractor)
August 2000 – January 2001
Oracle Financials Functional Consultant
Served as a Business Analyst to convert Budgeting Forecast System from Excel to Oracle Financial Analyzer (OFA)
Created Reports (Balance Sheet, Income Statement, Budgeting
Reports)
Built Reporting Hierarchies; Creating Dimensions, DimensionValues
Created Financial Data Items and Created Models
Trained End Users in (OFA)
Aramark Corporation, Managed Services, Philadelphia, PA (Full Time Employee)
November 1998 – August 2000
Fixed Asset Supervisor - April 1999 to August 2000
Functional Project Lead for Oracle Fixed Assets and Oracle General Ledger, Oracle Accounts Payable, Oracle Accounts Receivable, Oracle Discoverer and Financial Analyzer
Supervising a staff that is responsible for the Fixed Assets of three Aramark Lines of businesses
Responsible for daily and month-end processing of Oracle Fixed Assets for Aramark.
Review and analysis for Fixed Asset General Ledger Accounts.
Updating Profitability and Sales Analysis for all Profit Centers within a Line of Business.
Capitalized Buy Back agreements and providing Job Costing Analysis for our Profit Centers.
Provided Capital Expenditures Reports for each profit center on a monthly and annual basis.
Extensive use of Oracle Financials and Oracle Discoverer for processing and reporting purposes
Implemented Tax Books for Federal, State, Alternative Minimum Tax and Adjusted Current Earnings
Rosenbluth International, Corporate Travel Services, Philadelphia, PA (Full Time Employee)
April 1997 – November 1998
Staff Accountant
Prepared Balance Sheet, Cash Flow Statement and Income Statement
Completed Journal Entries for the monthly close
Responsible for managing Assets with a Net Book Value of 30 million dollars.
Supervised the daily processing of an Accounting Clerk, entered Journal Entries in Vision and PCFAS Fixed Asset Systems.
Reconciled Fixed Asset Accounts on a monthly and annual basis.
Determined whether costs should be capitalized along with a project or expensed to a particular department.
Rohm & Haas, Chemical Manufacturers, Philadelphia, PA (Full Time Employee)
November 1995 – Apri1 1997
Fixed Asset Accountant
Responsible for managing Plant Assets with a Net Book Value of
130 million dollars.
Entered Journal Entries in J.D. Edwards and Dun and Bradstreet Fixed Asset Systems.
Reconciled Fixed Asset Accounts on a monthly and annual basis.
Completed Excel Spreadsheets for Capital Project Management Analysis.
Determined whether costs should be capitalized along with a project or expensed to a particular department.
Nicholas Panarella, Esquire, 404 S. Front Street, Philadelphia, PA (Full Time Employee)
November 1993 to July 1995
Staff Accountant
Responsible for supervising the calculation of local tax returns that totaled 10 million dollars annually. (10 Accounting Clerks)
Completed journal entries for the month end close and generated the monthly Income Statement.
Use of Quattro Pro 6.0 to create budget reports, operational reports and financial reports on a weekly, quarterly, and annual basis.