Senior-level financial analyst leader with a consistent, proven track record of solving problems.

  Saved two days per month on close after creating Visual Basic scripts for accounting journal entries.

  Improved current processes within an entire organization after making recommendations to vice presidents.

  Returned shipping costs into the black after developing Webshopps shipping rate algorithms.

  Experienced developing forecasting models in Microsoft Excel and handling corporate finance, payroll, auditing and multiple General Ledger reconciliations.

  Outstanding background performing query writing, sub-queries and partitioning data.

  Proficient with Microsoft Excel (VBA Macros, If Statements, V-Lookup, Index Match Nested Arrays and Pivot Tables); Tableau (Table Calculations, LOD Expressions and JavaScript embedding and animation); Visual Basic; and complex SQL, among others.

Financial Analysis Operations Analysis Problem Solving

Team Leadership Forecasting Process Improvement

Auditing Project Management Request for Proposals (RFPs)

Acme Manufacturing Co. Xxxxxx, CO Apr. 2015-Present

Managing Analyst (Apr. 2016-Present)

  Saved two days per month on their close after creating Visual Basic scripts for accounting journal entries.

  Improved current processes within the entire organization after making recommendations to vice presidents.

  Successfully managing a team of up to two analysts, including setting priorities and timetables for completion.

Operations Analyst (Apr. 2015-Apr. 2016)

  Excelled as Technical Lead on a plant transformation project worth more than $1 million, including developing the rollout plan and schedule and presenting milestones to the Vice President and Plant General Manager.

  Created a Microsoft Excel-based forecasting model using Holt-Winters Exponential Smoothing, including leveraging the model to set production Min/Max/Trigger levels and production schedule.

  Designed visualizations in Tableau for production monitor displays.

Think Geek Solutions, LLC Glendale, CO Nov. 2013-Apr. 2015

Operations Analyst

  Delivered on-going analysis for all operational functions for this international e-commerce firm.

  Collaborated with the CEO, as well as IT, accounting and marketing personnel to develop projections, profit and loss reports, royalty reports and month and year-end accounting close processes.

  Returned shipping costs into the black after developing Webshopps shipping rate algorithms.

Hospital Couriers Corp. Centennial, CO Aug. 2011-Sept. 2013

Business Analyst (Aug. 2012-Sept. 2013)

  Analyzed and sorted Request for Proposal (RFP) data in Excel using Pivot Tables and If-Then statements, including leading proposals through the development and implementation cycles.

  Conducted market research and analysis of current and potential future clients.

Staff Accountant (Aug. 2011-Aug. 2012)

  Maintained ledgers, payroll and tax liability for seven subsidiary companies and the corporate holding company.

AdamWorks LLC Xxxxxx, CO May 2011-Aug. 2011

Finance & Accounting Manager

  Managed accounting functions, including responding to RFP s by developing spreadsheets using VBA Macros to show projects bids in government-required FAR 31 format.

  Updated active project budgets in Microsoft Excel and linked the budgets to Microsoft PowerPoint for weekly presentation to the company President.

Signia Marketing Xxxxxx, CO Aug. 2010-Apr. 2011

Marketing Associate

  Provided marketing services for telecommunication companies and political campaigns.

Romolo & Associates Peoria IL Jan. 2005-June 2010

Independent Auditor

  Processed payroll and performed benefit audits at various union pension fund offices and union health and welfare fund offices across the State of Illinois.

Bachelor of Arts (BA), Financial Economics, with a minor in Psychology; earned 2008

Southern Illinois University, Carbondale