Brian Ford Email & Phone Number

Waukesha, Wi, Us

Milwaukee, Wisconsin, United States

EBS Business/Systems Analyst responsible for supporting and enhancing various Oracle applications, such as Financials (GL, AP, AR, Cash Management, OPM Financials), Supply Chain (Inventory, Order Management, Purchasing), and Pricing (Advanced Pricing, Channel Revenue Management). Handled system administration tasks and utilized reporting tools like Oracle Discoverer, SQL Developer, and Insight Software Wands Suite to improve data analysis processes.• First line of support for Oracle EBS Financial Modules, Supply Chain Modules and Pricing Modules• First line of support with any technology requirements to support Oracle Financials or 3rd Party reporting and API software (More4Apps and Insight Software Wands)• Secondary support for Oracle EBS Production and Shipping modules• Project Manager for migrating Broker Commission process from Oracle Incentive Compensation module to Trade Management (Channel Revenue Management)• Administrator/License Manager for 3rd Party API and Reporting software in Excel More4Apps and Insight Software (GL, Reports, Budget, and Journal Wands)• Team Member to build BI reporting solution through Power BI for Profitability Reporting and Margin Extract files to Load into Oracle HFM. Built Oracle database tables and views for Power BI dataflows from Oracle EBS data• Define, build, and test reporting built in SQL Developer for business users. Put in Production in Reports Wand 3rd party product• Troubleshoot all Oracle EBS process and reporting tickets assigned • Built and maintain interface to General Ledger for Concur Travel and Expense • System Administrator for user access and new program configurations. • Responsible for system user audits and gathering information for Finance for audits• Responsible for Sales reporting to Corporate at month end close• Recommend Process and Reporting improvements or automation

Milwaukee, Wisconsin, United States

Responsible for Business Rule documentation and working on various projects at client site in the Dental Insurance Industry. • Extracted and analyzed data from DB2 database using multiple tools including MS-Query, Access, SQuirrel SQL Client, IBM iNavigator for Business Rules and Regression Testing scenarios• Reviewed IBM RPG programs for hardcoded Business Rules • Collaborated with management and IT on Role Standardization for The Resource Center (Help Desk)

Glendale, Wi

Sr Systems Administrator working with various Financial and Manufacturing Systems. Responsible for managing the transition of work to the Financial System Administrator while working on the SAP RTR (Record to Report) Core Team Implementing SAP for Power Solutions US.• Maintain RTR Master Data including Profit Centers, Cost Centers, Cost Elements, Accounts, and Statistical Accounts in Production/Project/Gold Environments/Clients• Maintain RTR Sets for Validation and Substitution Rules in Production/Project/Gold Environments/Clients• Support SAP Help Desk and End Users with Master Data related Issues/Tickets• Helped build ARIS flows for RTR FI Processes• Prepared Process Definition Documents for business sign off• Helped in design of the SAP Org Structure, including Company Codes, Profit Centers, Cost Centers• Participated in Blueprint sessions to assist with business requirements• Designed GL interfaces for Payroll, Transportation, Utilities, Corporate Intercompany, and Kronos• Designed Cross Reference//File splitting tables in ETL middleware for the various interfaces• Tested and Trained Users on the GL Interfaces and Cross Reference Table maintenance for Payroll, Transportation, Utilities, Corporate Intercompany, and Kronos• Designed, Tested, and Implemented Payroll Reporting solution with BW/BI Team• Provided scheduled data updates for mapping team to update mappings between Oracle Financials to SAP and HFM• Cutover duties included: Manual Configuration in production client, AP reconciliation for cutover, GL reconciliation for initial GL balance load• Gather any necessary data that is needed and requested by implementation team members

Glendale, Wi

Systems Administrator working with various Financial and Manufacturing Systems. Clients include 15 US and Mexico plant controllers and staff, as well as Power Solutions Headquarter employees. Responsible for support, enhancements, and administration of the following Applications: Oracle Financials (GL, AP, Projects), QAD/BES, Hyperion Enterprise, Oracle Hyperion Financial Management (HFM), Oracle Hyperion Financial Data Quality Management (FDM), Oracle Application Desktop Integrator, Oracle Discoverer, and AssureNet. • First line of support for Oracle Financials, Oracle Applications Desktop Integrator, and Oracle Discoverer.• Coordinate Oracle database upgrade testing to version 9i for Oracle Financials.• Install and Coordinate Applications Desktop Integrator upgrades and documentation for installs• Upload data and research issues with various subsystems and external system data (payroll, corporate payables, QAD/BES, transportation, utilities, and data warehouse)• Communicate between Accounting and IT to resolve system and data issues regarding QAD/BES, Oracle Financials, and Data Warehouse• Communicate between Accounting and Corporate Accounting on data issues regarding Payroll and Corporate Intercompany files• User Maintenance and auditing, including internal and external SOX auditing.• Vendor maintenance• Administer and first line of support for AssureNet (on-line Reconciliation Software)• Worked with FDM Middleware technical team to design the import scripts to work with the multiple mapping tables in FDM• Designed mapping tables necessary to get data from Oracle Financials to FDM and exported to HFM• Two time Corporate Merit Award winner for Fixed Asset Conversion and Global HFM Conversion

New Berlin, Wi

Application Analyst working with various Financial and Collection systems, applications, and databases. Responsible for support, enhancements, and delivery of the following Applications: Oracle Financials, Oracle Application Desktop Integrator, Oracle ODBC Drivers, MS Access, Business Objects, Oracle Discoverer, Crystal Reports, Bottomline Software (Check Writing Program), Best Software (Fixed Assets), Ceridian ESource (HRIS/Payroll/Time and Attendance), Convey (Tax Software). • First line of support on Oracle Financials, Oracle Application Desktop Integrator, Fixed Asset System (Best Software), and 3rd Party Software solutions for Oracle (Bottomline and Convey Software) • Define, document, and implement new processes or reporting enhancements for Oracle Financials.• Reporting for the collection systems via Business Objects• Creating and Maintaining Business Objects Universes (Meta-Data Layer) • Data integrity auditing on Oracle databases through MS Access utilizing ODBC Connections• Training Oracle Financial end users on features and functionality in the software package• Upgrades and testing of latest versions and patching of software• Reporting for the HRIS/Payroll system through Crystal Reports.• Communicate with DBAs on various issues concerning the interaction of the software and the databases and servers• Communicate with Developers concerning enhancements and reporting needs

Milwaukee, Wi

Business Analyst working with Oracle Financial Applications. Responsible for the delivery and support of the following applications: Accounts Payable, System Administration, Web Requisitions, Accounts Receivable, General Ledger, and third party faxing and e-mail solutions. • Defining and documenting client requirements• Reviewing and implementing third party solutions for clients• Process re-engineering• Quality Assurance reviews on existing system• Testing and Implementing processes when procedures, system setups, and system changes occurred• Worked on internal projects to create sales reports and views to offer prospective clients• Correcting printing issues with the IT staff• Documentation of system setup, processes, and system changes for end-users and management

Milwaukee, Wi

Business Analyst working with Oracle Financial Applications. Responsible for the support of the following applications: General Ledger, Accounts Receivable, Accounts Payable, Fixed Assets, Purchasing, Human Resources, and Payroll. • Create and modify test scripts to be used during testing• Documentation of General Ledger and Fixed Asset system setup information• Testing General Ledger and Accounts Payable• Documentation of General Ledger, Accounts Payable, Purchasing, Fixed Assets, Human Resources, Payroll, and customization test scripts• Worked with Credit Manager and end users to conduct business processes and accounting flows• Conducted user training to make sure that client could reconcile the AR module internally and externally• Worked with sales on project proposal for a prospective client

Milwuakee, Wi

Business Analyst working with Oracle Financial Applications. Responsible for the delivery and support of the following applications: General Ledger, Accounts Receivable, Cash Management, Accounts Payable, and Order Entry. • Interviewing users to define business processes and requirements• Gapping current processes against Oracle Application functions• Defining and Implementing Application setups with users• Setting Application parameters• Testing process flows in applications and integration flows between modules• Training end users• Verification and testing of all process and accounting flows through the various modules

Waukesha, Wi

Responsible for all Accounting functions at the Waukesha Freeman and its various satellite papers. Implemented Oracle Financials Release 9.4.2. Implemented General Ledger and Accounts Payable modules used by a group of daily and weekly newspapers in southeastern Wisconsin. Supervised eight employees whose responsibilities included General Ledger, Accounts Payable, Accounts Receivable, Collections, and Payroll

Waukesha, Wi

Worked as Group Accountant for the Great Lakes Group, a Strategic Marketing Group (SMG) for Thomson Newspapers. This group consisted of 14 daily newspapers throughout Wisconsin and Upper Michigan. • General Ledger – Journal Entries, Budgeting, Reporting• Intercompany Accounting• Bank Reconciliations for cash disbursements account, deposit accounts, and payroll account• Responding to problems at other sites including system, accounting, and data problems• Month end and Year End reporting to the Corporate Office • Budgeting - with Hyperion's Pillar program and Oracle• Accounts Payable and Accounts Receivable

Bachelor Of Science (Bs), Business Administration, Finance Emphasis

Activities and Societies: Football Team (Freshman Year)

Associate Of Arts And Sciences (Aas), Business Emphasis