Business requirements gathering for development releasesAgile project management and scrum masterJira/sprint/release management and maintenance, setup Jira issue types, workflows, dashboards, filters, sprints, test cycles/cases and upload templates for Delivery and MS TeamSoftware testingCoordinate managed services team resources (BAU and Release)SPM development

EIM development

Recent Projects:•2017 Q1 Built an MSAccess-based sales crediting application that assigns crediting for over 200 sales reps based upon 18 complex territory components parsed from text-string descriptions. The tool applies crediting rules to a point of sale revenue dataset exceeding 100,000 monthly transactions and generates an assignment load file in excess of 1 million records that is pushed into the sales performance management tool for payment processing. •2017 Q1 Built an MSAccess-based ETL automation that transforms raw Oracle HR and other system data extracts into plan component txt files that can be interfaced with the Callidus sales compensation management and Plan Communicator tools via FTP drop box. •2016 Q2 MsAccess-based auditing and approval automation that performs 21+ logical audit checks on 50k Sales Force CRM transaction records to verify their completeness and accuracy prior to approval for payment, then transforms and generates the csv upload files required to update the transactions in SFDC through the Data Loader tool.•Accrual support reporting accuracy vastly improved by developing a month-over-month incentives snapshot comparison for identifying previously undeterminable earnings periods for given month's payments. •Built a database tool to extract, transform, enrich, and audit sales data from SFDC for load into Callidus for processing, calculation and commission payment.Responsibilities:•Extract, pre-process, transform, audit and upload revenue, positions, plans, rules, and measurements for 1500+ active positions into the Callidus compensation tool•Periodic and ad hoc reporting for Commissions, HR, Finance, Operations, and executive teams•Core reporting for commissions expense accruals and commissions analysis•Provide output, process, and reconciliation details for internal internal audit, external audit and Sarbanes-Oxley requirements. •Trigger, audit, reconcile and submit payroll files.

Accounting Analyst/Financial Analyst•Developed trend reporting based on multiple dimensions using Business Objects, Oracle/Toad, Access, Excel 2007•Extracted and transformed usage records into product life cycles using statistical methods and database tools.•Developed KPI and lifecycle reporting for new PAYGo business line•Monthly sales quota development (with seasonality components)•Created a daily sales unit MTD performance report for the PAYGo line of business•Developed forecasting methodology based on store counts and seasonality regressors•Ad Hoc Executive management analysis for ARPU (average revenue per unit)

Operations/Finance Manager•Used fixed cost allocations and field data to model and consolidate routes and take the Residential Recycle line of business from -$70k/month EBIT to profitable•Developed new pricing methodology for HOA contracts that added $200k in EBIT/year in 2007•Created simplified Zone Pricing pricing structure that added over $250k in EBIT to the Residential LOB in 2008•Rerouted and consolidated the Mountain Routes and added >$200k/EBIT per MonthController•Developed piecework/commission compensation plan•Monthly sales commission and draw validation and Quota review•Budgeting, Forecasting, Variance Analysis for a $45M Division•Balance Sheet and GL Close Responsibility•Developed AP/Purchase Order application in Access•Sarbanes Oxley Testing, Remediation and Reporting

Sales Operations Consultant•Quota Development, Allocation•Commission calculation and validation in compensation plans with recurring and non-recurring revenue streams, payout rates that varied by 7 product categories, ytd and discreet-month plan components, and threshold/attainment accelerators•Developed a dynamic, Rolling Product Revenue Forecast•Revenue Targets•Sales CompensationFinancial Analyst•FP&A Functions•Reorganization Allocations•Board Meeting Presentation Development•HR Headcount Cost Mapping Project