Gavin Greer

Wells Fargo - Irving, Texas

Served as Analytics Manager for the Analytics Quality Review (AQR) group providing centralized review of high-risk data solution activities across Wells Fargo through internal validation and credible challenge of documentation, assumptions and results. In November 2021, the AQR process was retired in favor of the Customer Remediation Verification (CRV) approach. This change focused efforts on customer remediation work and brought additional oversight, validation and a formal relationship with the execution team. This has further reduced errors in data and strategy ensuring customers and the company are protected.

• Led the transition from the AQR approach to the new CRV process as the data SME for the pilot program. This included development of training materials, hosting procedure training sessions, and recording team specific reference videos. Provided key input and process enhancements throughout procedure development and subsequent revisions.
• Coordinated operation for team members to self-develop and implement resources to improve opportunities identified through the annual Wells Fargo global team survey.
• Selected by leadership to lead effort to analyze and review peer organization procedures for overlap. Presented findings and proposals to organization leaders on both teams leading to removal of unnecessary duplication of effort and opportunities for additional efficiency gain.
• Led special team to review CRV artifacts for efficiency and risk. Project team provided direct enhancements to the majority of the retained, auditable document stack to streamline and align these documents to their owners along the process path. These changes were reviewed and approved by internal audit.
• Selected for two Manager Spotlight awards in 2023 for excellence in team development and process enhancements.
• Led the development of a system utilizing three data systems to provide a high-level overview of the project pipeline. This was expanded to include all areas under AQR and was utilized across the organization to track and project capacity and coverage.
• Proposed, designed and led the effort to implement consolidated project intake procedures reducing in-flight churn by 2 weeks on average. This procedural change improved resource assignment efficiency by identifying project submissions that were incomplete before committing a resource to the effort.

Zoёs Kitchen - Plano, Texas

I led finance operations and strategic initiatives for the company-wide reporting services platform in a hybrid role marrying technology and data skills with business operations experience. In this role, I was able to simplify and focus reports, KPIs and metrics to align with larger company objectives. In my finance role, I provided data and modeling analytics for all corporate and store level financial reporting. These reports were presented and tailored for the CFO, senior leadership and store-level directors.

Reporting and Analytics

• Led initiative to revamp existing automated SSRS report portfolio. Objectives were to eliminate duplicate report deployment, implement a standardized, branded report template and install a publication process including an isolated development environment, UAT checkpoints and user group segmented production space.
• Created automated, self-serve P&L reports in support of all 250+ individual stores including aggregate views at the field organization levels.
• Led analysis and reporting for the launch of key company initiatives including DoorDash web integration and limited time offer products.

Finance

• Managed budgeting process in Oracle PBCS (Hyperion) for consolidated $500MM company.
• Partnered with Operations and Finance teams to develop specific budgets for catering delivery sales and store-level operational expenses.
• Created SQL model to project monthly forecast sales to daily sales targets based on store-specific historical sales trends.
• Supported CFO and Sr. Director of FP&A in delivering period close reporting packages.

Data Management

• Led the database transition to a new fiscal calendar. Objectives were to identify impacted tables, views and stored procedures, capture historical archives and restate existing data structures on the new calendar.
• Created ETL processes and automations for weekly labor data and period P&L data for all stores.
• Led initiative to consume guest feedback data from third-party API directly into our database through automation routine.

Wells Fargo - Irving, Texas

I led the team responsible for providing reporting, analytics and automation used by the Home Mortgage Default Compliance Operations group to reduce risk to Wells Fargo and its customers as well as influence and enhance business processes. The team also served as a de facto in house consulting firm, offering analysis-based process improvement recommendations, key performance indicators and organizational support.

Reporting, Analytics and Automation

• Led project to enhance automated system designed to analyze the entire default loan portfolio and detect potential borrower harm based on over 800 individual business rules. The solution reduced process execution time by 70%.
• Led the team that successfully automated many large-scale manual processes. This improvement created development capacity equivalent to four full-time employees.
• Led the team responsible for the report portfolio that played a crucial role in providing the OCC with the performance data needed to close the government issued Consent Order in May 2016.
• Led team through large scale database migration (SQL 2008 to SQL 2016) requiring table, data, ETL and report migrations with tight deadlines and zero report downtime.
• Managed a portfolio of over 50 active SSRS reports and 20+ dynamic SSIS data automation routines.
• Independently worked directly with business leaders to develop entire suite of reports for new business unit in the mortgage space.
• Reporting scope included daily pipeline management, branch specific income statements, daily and monthly revenue, daily processor productivity and cycle time and trends.
• Data automation projects included automated off-site database snapshots (backups), custom enhanced reporting views and automated flat file imports.
• Developed custom automated report email delivery system utilizing Python and Linux shell scripts.

Commitment to Customer Through Strategic Perspective

• Partnership with business going well beyond just reporting. Consulted the business regarding operations processes, operational performance metrics, technology solutions, project management and staffing capacity models.
• Assumed the functional role of business liaison during the rollout of third-party audit application. Led team in developing audit process flow and ensured data generated by the application would be stored in a dimensional schema available for automated reporting. Keeping the end goal in focus from the very first step.
• Researched, analyzed, proposed and implemented operational performance metric suite specifically for senior leaders. Metrics have been incorporated into the Monthly Business Review across all of Servicing Operations.
• Identified blind-spots and risk gaps in existing audit processes and audit evaluation model and proposed actionable solutions to eliminate these risks by utilizing existing data with minimal process interruption.
• Developed forecast model for default file referrals used to determine and project the attorney firm network reductions over time.

Team Development

• Developed and groomed three entry-level team members into top performing leaders on the team preparing them for larger roles in the organization.
• Maintained high levels of productivity and engagement through difficult reorganization transition. Zero staff turnover on my team compared to rates of 40% across peer group.

JPMorgan Chase - Lewisville, Texas

I joined as a lead developer of the Third-Party Oversight group, specifically in charge of their default attorney scorecard data and process. In just six months, an entire application was implemented to capture attorney data, revisions and protests. This data was then utilized in high level performance reports used across the organization to ensure third parties with the lowest risk were preferred for default servicing.

• Led peers by providing focused direction in projects by assigning development tasks and providing processes for testing and validation.
• Conceived and developed File Manager application and database that accurately tracked file submissions and uploads by external attorney entities monthly.
• Built a Customer Request application and database that allowed internal business partners to submit service requests and application errors. System also provided tracking of these issues from opening to completion.

Falcon Physician Reviews - Coppell, Texas

In this high-growth, entrepreneurial environment, I was given the opportunity to wear multiple hats and provide extensive influence and value across the organization in operations, finance, technology and analytics.

• Developed website that allowed institutions access to streaming video content saving the company $200k in contracted development expenses.
• Responsible for month end close and associated reporting activities working directly with CFO.
• Implemented revenue recognition process, purchase order system accurately providing deferred revenue data for financial planning and budgeting.
• Created automated web-based attendance tracking system in live class environments. Data provided real time feedback to leaders on instructor and course material success.
• Managed operational schedules and financial reports during acquisition by Fortune 1000 company.