Business Analyst Customer Service

THOMAS BUTTS

Greenwood Village, CO ***** ***-*****@*******.*** 303-***-****

Professional Summary

Accomplished Business Analyst and self-starter who accumulated excellent analytical, problem solving, and customer service skills through 14+ years of Business/Financial Analysis, Data Research, Mining as well as Financial Modeling. Excels at process performance analysis, improvement, requirements gathering and teamwork. Highly motivated with the technical expertise and business acumen necessary to translate business requirements and objectives into successful system solutions. Displays exemplary communication skills with all levels of colleagues, management and business partners. Possess exceptional initiative and is highly organized while working under minimal supervision. Consistently works well under pressure to meet tight deadlines. Always eager to learn new methodologies, technology, ideologies and business solutions for the benefit of the company.

Skills

Technical Skills:

Analysis Skills:

Business Skills:

SQL, PL/SQL, MySQL Querying & Databases

Business Intelligence Reporting

Financial and Accounting data

Power Excel User

Extremely well organized

Project Management

Liaison between Bus. & IT Units

Financial Modeling & Analysis

Logical & analytical thinker

Teradata

Office Suite: Expert Excel, Intermediate Word, Outlook & PowerPoint, Power BI, BI 360

Toad Data Point 2.0

Oracle OBIEE

Alteryx 10.5

SSIS,SSRS, Developer-Beginner

Python-beginner

Tableau Certification Course Study levels I, II & III

Salesforce

Gap/Variance Analysis

Advanced Business process mapping & workflow analysis-software similar to Visio

Tableau 8.3-2018, 2021.4.4, 2022.1

Tableau Certification in process

SAP Business Objects (Finance)

Universe Design Tool

Webi Business Object App

Information Design Tool

Excellent communicator

Oracle Financial Reporting

Team player & multi-tasker

Agile/Scrum via ServiceNow and Waterfall

Sharepoint

Costing, invoicing tracking, budget analysis

Data warehouse, data governance, data dictionary dev

Jira/Confluence

Education

University of Colorado at Denver

MBA & Masters of Science in Finance with an emphasis in Business Analysis & Financial Modeling

Metropolitan State University of Denver

Bachelor of Science in Finance with an emphasis in Business Analysis, Financial Modeling, and Investments

Metropolitan State University of Denver

Bachelor of Science in Computer Science with an emphasis in Business Intelligence-Senior Year

Work History

Business Analyst Tableau Dashboard Developer&Admin, BAM Broadband, Greenwood Village, CO May 2023-Present

Migrate 100+ reports from Power BI to Tableau and develop automated reporting to C-level group

Analyze business divisions for gaps in strategies and report findings to appropriate managers

Create new, dynamic dashboards for use on Tableau cloud for immediate findings for upper management

Company trainer and mentor for all things Tableau related

Analyze “holes” and inconsistencies within a Snowflake database environment

Developed the beginning of a non-existent data dictionary for the IT group as well as other reporting analysts

Senior Dashboard Developer, Tom Butts LLC., Highlands Ranch, CO Jan 2018 – May 2023

Q&A with SMEs for the development of new Dashboards for reporting on business departments KPIs

Design, develop and enhance existing Tableau dashboards for new, existing small businesses

Prospect and market to companies that could benefit, become educated and grow the company with Tableau dashboard reporting

Salesforce reporting for financial companies

Mentor less experienced Tableau users to increase skill level and expertise

Reverse engineer dashboards where there was little to no process documentation and created said documentation

Business Consultant, Tableau Dashboard Reporting, Catch Intelligence, Omaha, NE Mar 2022 – Sep 2022

Mentored a group of 4 average to intermediate skill leveled Tableau users

Created a Tableau template is being used as a base for new Tableau users to expedite delivery of dashboards

Reverse engineered existing dashboards and produced process documentation from little to no existing documentation

Produced a consistent style guide with color schemes, fonts, spacing, alignment for equivalent look and feel across the department

Developed a quicker process for migrating 90+ dashboards from one platform to the company’s current environment

Participated in 2-3 day long sprint planning meetings to develop 4-5 weeks work schedule for the team

Business Objects Reporting Consultant, USAA, San Antonio, TX Aug 2020-Feb 2021

Develop automation to the daily tasks for the Real Estate Accounting and Reporting Team

Created an interim solution to handle the projected increase of Buyouts for the data analysts, reduced labor from 15 minutes per file to about 5 minutes

SQL coding within a SAS environment to create a database for the Accounting and Reporting team for Tableau Dashboard and Reporting purposes

Liaison between the Accounting team and Information Technology

Business Requirements Gathering for the creation of UDAs

Completed UDAs that have been in backlog for two years

Cyber Security Analyst, Nelnet, Aurora, CO Jan 2020 – Dec 2020

Migrate Oracle reports to Microsoft platform

Develop automation for 250 reports via the government student loan databases

Strategic plan on process efficiencies

Create meaningful dashboards within Tableau and Power BI for upper management

Senior Data Analyst/Developer, Nordstrom Credit, Centennial, CO Aug 2017 to Dec 2017 (contract)

Administrator of Business Objects SAP 4.3

Maintain and enhance SQL code using Universe Design Tool and Information Design Tool

Maintain and enhance SQL Code using a Business Objects tool called Webi

Migrate Oracle databases into SQL Server 2014 environment using SSIS

Research via Q&A with business stakeholders to determine downstream financial impacts of report migration

Translate and blend disparate sources of data into Tableau to create visualizations for online publication

Develop ad hoc reporting to business leaders to help efficiencies of scale

Conduct and present new technologies that will help move the team and the company in a forward direction

Maintain and enhance existing Tableaus with new bells and whistles the business owners didn’t know was possible

Always on the lookout for new and more efficient ways of doing things quicker for the betterment of the company

Senior Financial Data Analyst, Performance Food Group Corporation, Centennial, CO Apr 2017 to Aug 2017 (contract)

Developed merged KPI Metrics from PFG’s numerous business partners from several different data sources

Provided data analytics services to the accounting and finance department within the shared services organization

Interpreted data, analyze results using statistical techniques, and provide detailed information for ongoing financial reports and business review packages (Powerpoint decks)

Developed and implemented databases, data collection systems, data analytics and other strategies, using SQL, that optimize efficiency and quality within accounting data

Identified, analyzed, and interpreted trends or patterns in complex data sets

Filtered and cleaned data by reviewing financial reports and key performance indicators to locate and resolve potential financial issues to the Company’s bottom line

Identified and defined new process improvement opportunities

Senior Data Analyst Corp FP&A (IT), Charles Schwab, Lone Tree, CO Apr 2016 to Jul 2016 (contract)

Develop Teradata reporting for upper management KPI metrics

Automate ongoing monthly, quarterly SQL reporting via Alteryx

Create visualizations of data in Tableau using SQL, Teradata and Excel to help managers pick up SWOT for their business units

Produce new Driver, Products, Channel codes for use on the Planning and Analysis teams

Fund Transfer Pricing monthly validation and trouble shoot variance errors

Work across different teams to complete high profile projects

Big Data analysis using Teradata to find discrepancies in data for internal and external audits

Salesforce Reporting for 3 separate databases

Technical Business Analyst, Davita Healthcare, Denver, CO. Nov 2015 to Apr 2016 (contract)

Develop new KPI metrics and maintain existing KPI metrics for reporting purposes

Create and maintain Tableau and Excel dashboards for 10 different application teams

Liaison between business units and IT for project and reporting purposes

Complete Epics, Stories and Tasks for team in an Agile environment

Enhance SQL queries for more efficient server performance

Write code in SQL for reporting purposes to benefit the teams supported

Constantly share information across teams to help find inefficient processes

Present dashboards to team leads/managers to have final sign off for online publishing of reports and dashboards

Business Analyst III, Comcast, Centennial, CO. Mar 2015 to Nov 2015 (contract)

Developed automated reporting using SQL, Excel, and Tableau for presentations for upper management

Created and enhanced new and existing SQL databases

Work hand in hand with the Corporate Finance team for Budget, Forecasting and Actual reporting

Created eye-catching Dashboards within and out of Tableau to help PM Managers and Engineering Management understand the finances behind their departments and developed more efficient ways to operate to eventually have them fully automated

Extracted data from large files from disparate sources and load to develop one stop shopping for reporting purposes

Developed Salesforce data for project tracking for NVDEs Project and Engineering teams

Introduced upper management to Heatmaps to look at department data in different ways

Developed and maintained KPI metrics in DataZen, Tableau and other software available to help build the big picture

Costing, invoice tracking, and budget analysis

Liaison between business units and IT for clarification on project and reporting requests

Lead SQL Data Analyst, Specialized Loan Services, Highlands Ranch, CO. Dec 2013 to Mar 2015

Supervised a team of 7 employees

Personally responsible for boarding 6,337 loans with an Unpaid Principal Balance of $374,705,256 within a 3 month period

Change champion, constantly organize team process improvements to increase efficiencies

Maintained Monarch Models to pull Fidelity data into a useable format for reporting purposes

Created complex dashboards for interactive charts to help business leaders make more informed decisions to the benefit of the company

Used BIG data SQL queries, turned out to business leaders in a more informative manner quickly

Presented business-level reports, charts, and graphs to business leaders and upper management

Assisted in data definition, development, and documentation of application’s business requirements with internal users and departments

Implemented automation of frequency reports emailed daily to business leader’s inbox before they arrive for work

Department trainer for Intermediate Excel users and beginner SQL users & Mentor for Department Interns

Reports-responsible for 10 daily, 5 weekly, 4 monthly frequency reports and 25 Ad Hocs on average per month

Data sources used were SQL Server 2008 R2 databases, both development and stage, DataMart, Excel and Access databases

Use Business Objects to pull data from Datamart into Excel to create Dashboards/Reports

Extract data from large flat files from various prior investors/servicers to parse into Excel

Business Analyst III, Nelnet Business Solutions (NBS), Aurora, CO. Apr 2010 - May 2011

Prepare, implement, lead and maintained projects for Process improvements and present results to upper management

Worked across teams to negotiate buy-in from other key members to contribute to the finished project/product on or before deadline

Provided SQL reporting support to department as well as other departments for the benefit of the company to achieve monthly & quarterly goals

Programmed Word and Excel documentation to reduce labor by 35%-replaced antiquated daily processes for a more efficient department

Self-taught Business Process mapping technology called BPMN 2.0 and became head trainer for the company

Co-developer of Business Process flows for employees that didn’t have defined process flows for daily & monthly tasks

Developed meaningful reports using advanced Excel functionality like dashboards, nested IF statements, concatenation, V-lookups and Pivot tables to help business managers run their departments more efficiently

Mortgage Loan Originator, Gemini Group Holdings, Inc., Highlands Ranch, CO. Mar 2003 – Dec 2013

Originate FNMA, Freddie, VA loans through strategic business alliances with Realtors, CPAs & online sources

Research and analyze loan programs to comply with state and federal regulations on fair lending practices

Pre-underwrite files for submission to lender for final approval using Desktop Underwriter and Loan Prospector

Top 50 National Producing Originator for 2006

Highest Origination year $35.45 Million, averaged $23.8 million over a 5 year period

Pre-underwrite files according to Fannie Mae, Freddie Mac, VA and HUD guidelines prior to submission

Awards/ACCOMPLISHMENTS

2 time Colorado Scholar recipient while in College

Government security clearance level 11

3 S&P ACE Awards for Customer Service

2 S&P ACE Awards for Teamwork

6 time National Top Producing Mortgage Broker

Additional Information

“Tom worked in the Finance Department at Pinnacol Assurance; during his tenure I found his work very accurate and timely. Tom was a great team player within the department; always exhibiting a high degree of integrity and was highly respected among all his peers.”

-Jeff Tetrich, CFO Pinnacol Assurance

INTERESTS

10 year volunteer for Habitat for Humanity( break due to Covid). Interests include the P90X workout, analytics, finance, athletics & reading. Highly experienced, efficient & cost effective for business travel. Over 6 years as a restaurant cook-including 2 years as a Sous Chef for Rock Bottom Denver

Contact this candidate