Adam Baker Email & Phone Number

Palm Beach Gardens, Fl, Us

Palm Beach Gardens, Florida, Us

Mclean, Va, Us

Boca Raton, Florida, Us

I shaped the analytics strategy, drove solutions delivery, and managed ourEDW and 100+ automated reports, alerts, invoices, and tools. This includedmonitoring KPIs for partner-specific product sets and serving as the SME fordefining and tracking sales targets, geographic analysis, andinternal/external commissions.My key achievements:• Leveraged proprietary CRM and related DWHs, including mining numerousdata points.• Optimized reporting, tracking, and transparency by implementingiDashboards and building SSRS profitability report with drill-down/drill-upfor all metrics combinations.• Redesigned payroll commission database system and recreated spreadsheet models to drive major schedule overhaul for 500 employees.• Enabled partners to optimize lead routing by building custom ZIP Coderanking models using FCC filing data, Census tract data, and 12-monthrolling historical sales results.− Leveraged similar approach to build dynamic model to drive digitalproperty comparison shopping site, as well as to create tool to show mostprofitable option for partners transferring sales calls to Infinity.• Drove innovation and accuracy by introducing new revenue recognitionmethod that aligned ad spend with revenue, implementing product-levelrevenue estimation model, and developing master revenue DWH.• Harmonized reporting and normalized data across all 15+ partners bycreating universal revenue analysis tool to reconcile 40K+ in monthly salestransactions.• Standardized payment systems by building customer DWH to load revenuefiles via SQL Server and SSIS with custom flags and stored procedures.• Achieved >98% accuracy by running regression models to assign monthlyrevenue accruals forecasted two or more months prior to actual performance.• Also automated 7(i) compliance reporting, partner invoice reporting, andabandon lead dataset.

Boca Raton, Florida, Us

I played a key role in driving cohesion and consistency across the companyby providing high-quality, timely analytics solutions. I also oversawrevenue analysis, marketing, and sales reporting.My key achievements:• Implemented automated solution for processing commission payroll for 400+employees, including handling payroll batching and web commissionstatements.• Designed learning model for using most granular statistics for revenuedrivers (activation rate, product SKU commission rate, and disconnectionrate) to maximize accuracy of profit forecasts.• Enabled near-real-time partner performance reporting by designing macro-enabled Excel dashboard with automated daily updates and integrated Googleand Bing Ads API data into reporting set with attribution.• Orchestrated A/B testing to evaluate impact of new call routing software on close rate.• Wrote dynamic code to group interactive voice response (IVR) scripts andmarketing campaigns into predefined list by customizing string patternsearches with multi-level prioritization using advanced 'row_number' SQLfunction.• Assisted in efforts to coach sales specialists with low conversion ratesby building automated excessive leads report, categorization of lowperformance statistics, and counter for frequent and consecutive lowperformers.

Boca Raton, Florida, Us

I was initially hired to support the CFO by performing revenue analysis.My key achievements:• Successfully reconciled $250K in unpaid sales revenue within first 90 daysof hire.• Reconciled $35K in unpaid small denomination residuals.• Slashed processing time by over 70% by automating payroll commissioncalculations in SQL and Excel statement generation with VBA macro.

West Palm Beach, Florida, Us

I onboarded the insurance line payload to facilitate post-acquisitionintegration of a large servicer by developing a SQL program to load ~200Kpolicies in one day. In addition, I processed daily batches of priority loaninsurance payments in excess of $500K, on time and with 100% accuracy.My key achievements:• Selected to review key loan document set for statistical coherenceregarding industry-wide "robo-signing" compliance.• Triggered 10-fold increase in accuracy of critical escrow auto-generatedletter issuance by correcting loan commenting bugs.