Ernest Fries Email & Phone Number

Tampa/St. Petersburg, Florida Area

Project Management RPA Bot DevelopmentProcess ImprovementFieldglass Application Management

Brandon, Florida

Produce various well-received SQL/Excel-based reports, including impairment schedules, multiple depreciation reports, Internal and External Audit reports, data integrity reports as well as month end journal entries.✪ Received multiple promotions up to Financial Services Manager II, orchestrated flawless sale of $1.3B+ in Cold Drink Equipment via a custom SQL-based system while adhering to all corporate standards.✪ Reorganized and optimized an existing SQL process, eliminating 4 weeks out of quarterly activities.✪ Reconciled 1M+ pieces of equipment between two ERP systems (SAP and B.A.S.I.S) under heavy workload.✪ Chosen as the primary liaison between deal team, fixed assets, audit, master data and senior business leaders on Cold Drink Equipment matters, guaranteeing continued organizational coordination.

Brandon, Florida

Managed RTR technical project designs focused on creating multiple business solution applications that reduce time and cost by streamlining complex reporting, business processes and analytics while maintaining internal controls and audit compliance. Provided Tier 2 Admin support for the TrinTech accounting systems suite products including AssureNet, a GL account reconciliation tool. Provided Power User support for SAP reporting tools such as Every Angle.✪ Coordinated with RTR management to meet the objectives of a Shared Services RTR organization, eliminated hundreds of hours from the close process, and improved information quality and delivery through technical tool development.✪ Designed and developed specialized systems that performed reconciliations and produced journal entries over 90% faster than previous methods while simultaneously increasing the accuracy of such tasks considerably. ✪ Developed custom reporting for the TrinTech accounting systems suite via SQL Server Report Services (SSRS).✪ Generated a unique ASP.Net web-based tool to facilitate more efficient SOX-required SAP User Access Reviews resulting in over 100k+ in savings and eliminating 2-3 weeks of administrative work.

Brandon, Florida

Managed a technical project design and reporting team of 5-6 people that focused on creating multiple business solution applications that reduce expense for Shared Services by streamlining complex reporting, business processes and analytics while maintaining internal controls and audit compliance. Extensive work with SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS). Regularly managed between 15-20 projects both large and small. Conducted Power User training for the SAP BI reporting tool Business Objects (BOBJ).✪ Realized $20M+ in savings due to the SQL/Access databases designed by myself and my team in 2010.✪ Developed/oversaw development of ASP.NET web apps for workflow/reporting/project management, with the SSC Customer Contact Solutions call center providing support, and the Electronic Changer Fund web application.✪ Oversaw complete redesign and distribution of the Daily Case Sales report produced to enhance related planning.✪ Designed the SQL process that took over the Full Service Commissions program and allowed the company to achieve modern performance based commissions program (a record $14M in savings the first year).

Brandon, Florida

Developed 150+ SQL and Access (VBA) databases for reporting and automation purposes. Heavy use of VBA. Developed ASP 3.0 Web tool for logging pricing changes. Designed, developed and administrated the web-based daily driver route reconciliation tool “Over/Short on the WEB.” (O.S.O) – Version 2.0✪ Sought for leadership acumen, maintained emphasis on training/mentoring Analyst I positions.✪ Administrated Reconciliation Management Summary application which was used to document and track monthly account reconciliation and significantly increase overall workflow. ✪ Generated SQL/Access-based tax application for Sales and Use tax department, automating the Sales/Use tax filing process for all states and eliminating 80% of the time and effort previously required✪ Utilized SSRS (SQL Server Reporting Services) for report development and SSIS for data manipulation.

Brandon, Florida

2004 -2005 contract with AdeccoDeveloped Access- and Excel-based reporting tools for the Route Accounting Department. ✪ Designed, developed and administrated the web-based daily driver route reconciliation tool “Over/Short on the WEB.” (O.S.O) - Version 1.0 which exceeded lofty expectations put forth by management. ✪ Provided Microsoft Office Training to enhance employee performance across administrative efforts.✪ Spearheaded HTML and ASP 3.0 web-based tool to track delivery driver accountability, leading to process flow standardization and dramatic improvement across all related metrics.

Brandon, Florida

- Developed Access and Excel based reporting tools for the Route Accounting Department. - Designed and developed HTML and ASP 3.0 web based tool to track delivery driver accountability. The O.S.O. tool provided reporting via SQL Server Reporting Services (SSRS) as well as process flow standardization and improvement.

Bachelor'S Degree, Business Administration And Management, General, 3.8 (Magna Cum Laude)

Activities and Societies: Student Government - President, Resident Assistant, Student Ambassador, General Tutor

Master Business Process Management

Master Certificate in Business Process Management