Charles Collins

Charles Collins

Lead Analytic Consultant at Wells Fargo · Under Armour

St Paul, Minnesota, MN

In My Own Words

I am an analytics consultant with a passion for coding. I am a learner, relator and achiever. New challenges, partnerships and tools excite me. I am driven by being a part of a team with common goals and diverse skillsets.

Work Experience

Data Visualization Engineer

Under Armour

2021 – Present

Analytics Consultant

Wells Fargo

2016 – 2021

- Communicated across organizational functions including technology, financial reporting, and operations to provide human resources analysis to business leaders - Manipulated large data sets in various formats into dashboards to present critical insight around employee movement and high risk locations to senior leadership - Acted as a liaison across human resources analytical teams to automate over 200 manual reporting processes - Maintained critical deadlines and processes supporting 900+ reporting deliverables of various frequencies and clients - Built dashboards for monitoring intake requests that eliminated hours of daily manual triaging tasks and improved reaction time to escalated work

Operations Analyst

Wells Fargo

2015 – 2016

• Wrote, edited and maintained help menus and technical documents for VBA routines used by modification closers and approvers • Designed error handling routines to automatically document errors users encountered while utilizing VBA programs • Directed research efforts of dozens of team members across multiple departments for customer impact issues • Assisted with internal and external reporting by developing queries in SQL Server Management Studio (SSMS) • Gathered, organized and interpreted data from multiple sources (such as SQL Server databases, Excel and internal Wells Fargo systems) in order to asses and present process gaps • Organized monthly meetings with leaders to present data on pipelines trends and suggest solutions for improving metrics

Research Remediation Associate

Wells Fargo

2013 – 2015

• Decreased outstanding modification discrepancies with the investor from 130 to 62 in four months. • Enhanced automated modification reporting process from a pull-though rate of 71% to an all-time high of 89% in five months • Implemented new processes for reporting modifications which yielded an 85% reduction in monthly outstanding loan modification rejects with investors • Developed and generated reports using SQL server to analyze pipelines on a daily basis and increased reaction time to events on loans by up two weeks • Redesigned old tools and programmed new tools used by Home Preservation Closer • Lead and facilitated calls with internal and external departments to resolve escalated issues with minimal impact to all groups and customers.

Home Preservation Closer

Wells Fargo

2013 – 2013

• Reviewed 300+ documents with a less than 1% error rate • Trained in new closers • Developed and refined VBA routines • Collaborated with HPS, SMA, Closers, County Officials and other outside departments to facilitate timely and accurate execution of loan modifications with minimal borrower impact

Education

Masters

University of Saint Thomas

2016 – 2021

Masters

Bachelors of Science

University of Wisconsin - River Falls

2008 – 2013

Bachelors of Science

Industries

BikeMusicOutdoorRunTriathlonHealth & Fitness