System Analyst Resume
Woodstock, GA
Career Profile
A results-oriented professional with over 15 years combined experience in accounting and finance systems. Extensive functional and technical expertise in several ERP systems and custom application development focused on streamlining Finance and Supply Chain Management processes.
Systems Background
Oracle General Ledger, Oracle Fixed Assets, Oracle AR, Oracle AP, Oracle Order Management, Oracle Configurator, Oracle CRM, Oracle Sales, Oracle iExpense, Oracle Inventory, Oracle Service Contracts, Oracle Purchasing, Oracle HR, Oracle System Administrator, Oracle Workflow, Oracle Install Base, Oracle eBusiness tax, Vertex, Great Plains Dynamics, SQL Tools, Excel, Peoplesoft, MS Access, MS Projects, Oracle Databases, Airtrak, WebDM, MobileCast, SPLUS 3.1 (Order Fulfillment Systems), SPLUS 3.9, FAP (Freight Audit and Pay), SCM Intranet Billing, SCM Oracle Billing, SPL Oracle Billing.
Professional Experience
Confidential, Atlanta, GA
System Analyst, Oracle Applications July 2009 - Dec 2009
Project lead for Oracle Financials System. Lead portal project automating distributor's invoices and billing processes resulting in reducing headcount by 10. Data conversion of all vendors from legacy system to Oracle AP. Lead ACH project - implementing Oracle Automatic payments. Support new Oracle development and provide system and QA testing of all new functionality. Support all Oracle Financials Release 12 applications and streamline user processes. Oversee UAT testing and provide new functionality user documentation. Provide support for Oracle AP, GL, AR, iExpense and Fixed Asset. Supporting Order to Cash projects and custom programs. Responsible for troubleshooting and setup in iExpense.
Confidential, Atlanta, GA
Advance Application Business Analyst, January 2007 - June 2009
Lead transition of ISS ERP global rollout of Oracle 11i AR and Service Contracts Billing. Support and lead projects surrounding Oracle 11i EBS. Compile BR 100s, MD 50s. Assist in sunsetting all legacy financials and OM systems. Implementation and integration of Oracle Order to Cash processes. Responsible for management of Receivables consultants related to worldwide rollout of Oracle AR. Project Lead for global go live with Oracle Receivables module. Provide training and support to all global users. Responsible for system configuration, upgrades, testing, and UAT for Oracle AR and OM. Supervise all system administration related to Oracle AR, GL, AP and PO globally. Provide support for Oracle AR, AP, GL, Service Contracts, and iExpense.
Confidential, Alpharetta GA
Lead System Analyst, IT, Global Financial Systems, October 2002 - October 2006
Supervise developers and business analysts in daily support of the UPS SCS Oracle Financials System and change management process. Lead and participate in all billing and financial systems projects and initiatives. Responsible for quality management of all financials billing. Liaison to the Operations and F & A functions for resolution of Billing and Payables issues. Management of change controls related to billing and accounts receivable. Auditing and troubleshooting of financial/billing system and production support. Responsible for Business Analysts who design and document all requirements and functional specifications for financial/billing software development. Lead and participate in integration projects related to consolidating and best practices for all billing. Responsible for providing functional guidance to developers and prioritizing development activity. Implementation of Order to Cash applications.
Projects Led:
- Reimplementation of Oracle AR for all SCS Companies
- Implementation of Mail Innovations on Oracle Financials
- Integration of Computron/IE into Oracle Financials
- Implementation of EXE Billing Customers
- Implementation SPLUS 3.9 Billing System
- Implementation of Revenue Recognition Programs for Logistics Technology
- Interface TM 4.22, TM 5.0 and TM 6.0 to Financials
Senior Business Analyst, October 2000 - October 2002
Project lead for Oracle Financials and Billing Projects. Responsible for all aspect of Oracle AR and the Oracle Billing Engine. Liaison between end users and developers. Responsible for documentation of all financial interface projects. Responsible for AR and Billing Training. Led and participated in various projects related to corporate initiatives, process improvements and integration of newly acquired companies. Billing system audit of SCM and SPL accounts to contract.
Projects Led:
- Interface from WebDM to Oracle AR
- Implementation SPLUS 3.9 Billing System
- Implementation of Revenue Recognition Programs for Logistics Technology
Confidential, Atlanta GA
Billing Manager, November 1999 - October 2000
Responsible for billing systems support and timeliness for the Southeast. AS400 queue management. Maintain SQL for billing updates. Responsible for field and help desk training on all financial systems. Responsible for testing enhancements, software upgrades and training. Responsible for company wide billing and financials documentation. Ensured that 240 billing sites completed billing 100% on time and to the terms of customer contracts. Led and Participated in billing audits and year end audit.
Confidential, Alpharetta GA
Finance Manager May 1999 - November 1999
Responsible for financial reporting for long term maintenance and sale-lease contracts. Analysis of trends, review forecast and budgets, financial close. Responsible for long term management contracts line of business. Determined service line of business profitability. Educated field managers on proper accounting and revenue recognition treatments. Compiled and reviewed financial statements from several ledgers. Determined revenue deferral and expense accruals. Managed two financial analysts. Management of Sale-leaseback billing audit and compliance with GAAP.
Acquisition Manager, November 1997 - May 1999
Integration of Finance and Accounting functions of newly acquired companies into Parent. Conversion of acquired companies billing and account systems to Parent. Worked with Oracle conversion team to convert GL and Fixed Asset information. Communication / training of newly acquired accounting staffs on Parent's systems and procedures. Compiled information from financial data warehouses to determine acquisition contingencies payout. Management of acquisition reserve and goodwill accounts. Determined wind down reserves for closing facilities and management of reserves. Liaison between Parent management and subsidiary management. Internal audit of subsidiary balance sheets prior to integration. Managed three staff accountants and one accounting admin.
Confidential, Atlanta GA
Accounting Manager, September 1996 - November 1997
Implemented Great Plains Dynamics Financial System. Responsible for Great Plains system maintenance and admin. Merged six subsidiaries into one accounting system. Responsible for purchasing and implementing billing database for internet business. Responsible for credit card system maintenance and interfaces. Moved Accounting department from Houston to Atlanta. Trained accounting staff of new acquires companies including international offices. Responsible for billing close, financial close, financial and tax reporting. Responsible for integrity testing of new accounting and billing software. Managed five staff accountants and 2 senior accountants.
Confidential, Roswell, GA
Asst. Controller December 1993 - September 1996
Implemented FACTS (Infor) UNIX billing and financial system. Responsible for system setup and conversion of all accounting information from Platinum to UNIX financial system. Responsible for report writer for all GL, AP, AR, and PO custom reports. Implementation / Conversion from UNIX billing and financial system to Great Plains Financial System. Responsible for system maintenance and administration for Great Plains. Responsible for all accounting department activities: financials statement preparation, payroll and sales tax reporting and compliance, inventory management, budget preparation, forecast reviews, financial close and reconciliations for a rapidly growing consulting firm. Managed two staff accountants.
Confidential, Marietta GA
Accounting Manager, September 1991 - December 1993
College intern position made permanent. Responsible for set up of accounting software and accounting operations for new entrepreneurial manufacturing plant. Set up accounting software, chart of accounts, and reports. Managed all accounting activities: payroll and sales tax reporting, billing, collections, purchasing, vendor payment, bank reconciliation and cash management, GL close, and management of external annual audit.
Education
BA Accounting
Oracle University Receivables
UPS Management Training
IBM Project Management Training