Experience

CallTower

• United States
• Telecommunications
• 100 - 200 Employee

• Senior Commissions Analyst

  • Apr 2021 - Present



Vivint

• United States
• Computers and Electronics Manufacturing
• 700 & Above Employee

• Corporate Commissions Analyst

  • May 2019 - Apr 2021

  • Advanced in SQL Server: Construct queries with left, right, outer, self, type joins while creating and modifying user, local, and global tables, with CTE, Over, Partition, Cast, Convert, When, Where, Having, Declare, loops and more for calculations, formatting, report automation, and analysis. • Expert in MS Excel: Author macros for expediting repetitive processes, enforcing data integrity, circular reference handling, emails, and UserForms, with the use of multidimensional arrays, collections, loops, event and error handling, class modules, formatting, password protection, etc. • Statistical Analysis: Data mining for quantitative and/or qualitative analysis, experimental design & analysis, design of experiments (DOE), hypothesis testing, analysis of variance (ANOVA) and data visualization. • Experienced in project management and identifying stakeholder needs for program design, implementation, and SOX compliance while maintaining flexibility to identify issues and creative solutions that should arise. • Develop and execute plans to collect, explore, and analyze data for answering complex questions. • Build and oversee creation of scalable financial models in Excel, SQL, R, and Tableau to be used for ad-hoc and routine reporting by FP&A, Payroll, internal and external audit and other various roles and responsibilities. • Coach teammates in data handling, best practices, and process improvements. • Design complex systems to facilitate simple communication between intercompany departments of varying skill levels to ensure on-time delivery of correctly formatted data.

• Solar Commissions Analyst

  • Jul 2017 - Jul 2019

  • Built scalable, SOX complaint, commission process and calculations around Solar’s dealer economics.• Compensation processes include: weekly training pay, standard weekly commissions and advances, monthly performance bonuses, and quarterly overrides and performance commissions. • Average weekly spend is $175,000 with an average quarterly spend of $850,000 across ~200 reps.• Author custom VBA and UserForms for data manipulation, file management and automated distribution.• Frequently use Workday, Callidus, Salesforce, Tableau, and Insider to manage sales force, calculate pay, and publish weekly and monthly reporting.



Swire Coca-Cola, USA

• United States
• Food and Beverage Services
• 700 & Above Employee

• Pricing Analyst

  • May 2017 - Jul 2017

  • Organize and implement pricing changes with field sales and pricing coordinators for upcoming and ending promotions via SAP.• Provide reporting to management and other divisional stakeholders for economic analysis and strategic planning. • Manage publication and communication of pricing changes and other ad-hoc requests. • Organize and implement pricing changes with field sales and pricing coordinators for upcoming and ending promotions via SAP.• Provide reporting to management and other divisional stakeholders for economic analysis and strategic planning. • Manage publication and communication of pricing changes and other ad-hoc requests.



Circle K

• Retail
• 700 & Above Employee

• Financial Analyst

  • Jul 2012 - Feb 2017

  • Compiled, summarized, and submitted asset, liability, capital, and expense account information from 550+ cost centers, for performance evaluation and compensation relevant to ranking within the SBU.• Reconciled vendor accounts each period for ~$2million in D&R by collecting and auditing sales/order volume for contractual compliance.• Created ad-hoc reports for all departments and all levels of management.• Identified and recommended purchasing opportunities to maximize revenue while reducing opportunity costs and optimizing lean practices.