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.
• 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.
• 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.

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'.

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.
• 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.