Gary Pearce Email & Phone Number

Columbia, Missouri, United States

Horn section contractor and performer for Rock and Roll Hall of Famers The O'Jays playing tour dates throughout Texas, Oklahoma, Arkansas, and Western Louisiana. 2012 - Present.Other tour date and TV taping performances include Little Feat and Doug Allen Nash.Performance credits include Grammy-winning jazz artists Phil Woods, Kurt Elling, Randy Brecker, Bob Mintzer, and more, and venues including American Airlines Center (Dallas), Toyota Center (Houston), Meyerson Symphony Center (Dallas), Austin City Limits, Richardson Wildflower Festival, State Fair of Texas, and Denton Arts and Jazz FestivalSelected discography includes studio recordings with the Grammy-nominated Dallas Jazz Orchestra (Forty Years of American Grace) and Texas Instruments Jazz Band (Jazz Bytes v1.0 and Algo-Rhythm).Currently performing in the Dallas area with Crosswinds Jazz Ensemble.Performance credits also include Dallas Jazz Orchestra, Tower of Power tribute band Urban Renewal, Texas Instruments Jazz Band, and Top 40 bands Definitely Maybe and Time Warp. Founding director of the Frisco Community Jazz Band.

Dallas, Texas

• Working 100% remotely, developed data feeds and dashboards of operational pull-through and mortgage processing stage durations giving executives their first detailed views into performance of lines of business.• Revived abandoned Python scripts used to condition input data for critical business purposes and translated them into SQL data feeds for Capital Markets group to automate performance modeling in BigQuery.• Wrote Excel VBA code to automate manual compilation of lead source data and metrics for Marketing and trained users on how to run it, cutting daily completion times from 2+ hours to 5-10 minutes. Code also interfaced with 3rd party vendor API to update selected fields in their database.

Dallas/Fort Worth Area

• Managed development and deployment of new executive and operational KPI dashboards for all functions in Client Service for Commercial Banking.• Developed staffing model for 350 member workforce to manage resource planning and allocation by location.• Earned internal Green Belt certification in Digital Accelerator technologies covering use of Alteryx, Tableau, Xceptor, and RPA

Dallas, Tx

• Presented development and deployment case study to CEO, COO, and other executive leadership for buy-in and approval to transition corporate BI reporting platform from SSRS and QlikView to SSRS and Power BI.• Conducted decision tree analysis of customer bad debt and gained management approval for changes in deposit policies for Energy business to secure a much larger percentage of at-risk customer debt.• Developed criteria and wrote SQL code for internal Regulatory team to link sales associate business accounts to their corresponding customer accounts, for the first time allowing company to withhold commission and bonus payments from sales associates past due on customer accounts.• Developed seasonal forecasts of customer energy usage and spending on current energy plans for Marketing, and presented options of plans that would save money to increase customer loyalty and goodwill while lengthening contract term of service for customers who did switch plans.• Defined criteria and developed SSRS reports identifying suspected customer fraud in Wireless business. Resulting business rule changes saved tens of thousands of dollars in unearned sales commission bonuses.• Defined relevant KPI’s and developed executive and operational reporting for company’s launch of a new business line as a wireless phone service reseller.• Led BI team efforts to seamlessly transition existing business reports in SSRS and QlikView from DPI database platform to DirectScale platform and for Wireless business reporting from BeQuick platform to RiverRock platform. All reports were ready and validated on time with no adverse effect on operations.

Dallas, Tx

• Created linear regression forecasts of telecom sourcing revenue from carrier partners based on industry and internal KPI’s. For CY2015 forecast on $1B+ in sales, this model differed from customer’s revenue forecasts by $5K. • Created metrics to assess penetration of telecom sourcing into individual member employee bases to identify high-growth targets of large member networks with low telecom penetration.• Modernized internal pricing analysis tools, and provided technical documentation and SQL training to client team on query algorithms and optimization.

Frisco, Tx

• Delivered three major releases and additional incremental releases to international customers. Managed all internal testing to schedule and functional requirements. Performed live final UAT’s for customer personnel to earn approvals for deployment.• Automated validation of all client output calculations reducing test time from two weeks to two minutes.• Developed sufficient competence with C# and XML languages to grow into company’s prime for ETL application maintenance and development.• Developed test case scenarios to ensure new features were properly implemented and worked closely with internal consultants to ensure customer use cases were sufficiently tested before external release.• Company suspended operations in July 2014 due to financial pressures.

Richardson, Tx

• With no budget and no staff, developed and maintained suite of tools to monitor and forecast telecom network KPI’s nationwide. Reports had visibility at all levels including CEO and formed the majority of a new multimillion-dollar analytics services contract which ran for several years.• Created linear regression models of voice and data traffic growth by site/sector to forecast capacity bottlenecks nationwide and build business cases for accelerated sales of network infrastructure.• Automated creation of national network performance reports with Excel VBA, eliminating eight full-time contractors and enabling daily publication instead of Fridays only. • Authored and presented to customer engineering teams nationwide training on new product features developed as a result of above analytics. Recognized by customer’s corporate engineering management for contributions to the success of nationwide deployment.• Created many tools to provide custom ad-hoc analysis for new product rollouts, business-critical troubleshooting, sales forecasts, and other business needs. These efforts likewise received corporate and customer recognition for contribution to achieving business and customer satisfaction objectives.

Master Of Science, Applied Mathematics

Courses taken: Principles and Techniques of Applied Math I and II, Ordinary Differential Equations I and II, Numerical Analysis I and II.

Bachelor Of Science, Electrical Engineering

Activities and Societies: Tau Beta Pi, Eta Kappa Nu, Band, Kappa Kappa Psi

Electrical Engineering

Activities and Societies: Tau Beta Pi, Eta Kappa Nu, Pi Mu Epsilon, Band, Kappa Kappa PsiUndergraduate researcher on transformer loading.