Thomas Butts

Present Location: Lone Tree, CO

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

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 Modelling & Analysis

Logical & analytical thinker

Monarch Pro 10.5

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

Toad Data Point 2.0

ETL

Oracle OBIEE

Alteryx 10.5

SSIS and SSRS-Beginner

SQL Developer-Beginner

Salesforce

Gap/Variance Analysis

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

Tableau 2018-2021.1

SAP Business Objects

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/Agile

Education:

University of Colorado at Denver -MBA & Masters of Science in Finance with an emphasis in Business Analysis & Financial Modelling

Metropolitan State University of Denver -Bachelor of Science in Finance with an emphasis in Business Analysis, Financial Modelling, and Investments

Professional Experience:

Tom Butts, LLC., Highlands Ranch, CO Jan 2018 – Present

BI Analyst

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

Built extract, transform, and load (ETL) process to migrate data from multiple types of data sources (SQL Server, Excel, Flat files, etc.)

USAA San Antonio, TX

Business Objects Reporting/ BI Analyst 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 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

Nelnet Aurora, CO

BI Analyst 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

Nordstrom Credit Centennial, CO Aug 2017 - Dec 2017

Senior BI Data Analyst

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

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

Analyse requirements ETL/BI reports with minimal supervision

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

Performance Food Group Corporation Centennial, CO Apr 2017 - Aug 2017

BI Analyst

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, analyse 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, analysed, 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

Possesses strong knowledge of MS SQL 2008 R2 Integration Services (or similar): required for new ETL packages and modification of existing ETL packages

Identified and defined new process improvement opportunities

Charles Schwab Lone Tree, CO Apr 2016 - Jul 2016

BI Analyst

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

Excellence in data analytics, ETL and data warehousing techniques

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

Davita Healthcare Denver, CO Nov 2015 - Apr 2016

BI Analyst

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

Experience with any business intelligence, analytic and ETL tools likeTableau, Qlik, Talend, etc…

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 lead/managers to have final sign off for online publishing of reports and dashboards

Comcast, Centennial, CO Mar 2015 - Nov 2015

BI Analyst

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

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

Specialized Loan Services Highlands Ranch, CO Dec 2013 - Mar 2015

Lead SQL Data Analyst

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

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

Business Analyst III

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 from Hong Kong 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

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

Mortgage Loan Underwriter/Originator

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

Research and analyse 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

Camelot Mortgage Group Denver, CO Jul 2002 – Mar 2003

Senior Loan Officer

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

Complete Processing of loan files for more efficient closings

Attend closings to ensure accurate closing figures and satisfied customers

Negotiate loan files with borrowers to make sure there was a win-win situation

Pinnacol Assurance, Denver, CO Mar 2001 – Jul 2002

Financial Analyst III

Provide P&L analysis, Capital Budget planning, Financial Management & Financial modelling to individual Business Groups

Developed SQL reports using Oracle Financials to provide insight to each business managers department to help them understand team financials

Partnered with IT department to maintain debt levels at 1.2% of revenues, proved to be best over a 3 year period

Conduct Trend & Variance Analysis, Corporate Finance Management with strategic planning assistance to teams across the company

Provided Financial Statement Analysis explanations to non-Finance personnel to ensure understanding of results for team managers

Standard and Poors Englewood, CO Jul 1996 – Feb 2001

Project Manager/Lead Senior Analyst

Served as data expert for department, employees, clients and upper management, provided expertise regarding corporate financial reporting practices and internal policies and procedures, interpreted and analysed ambiguous, nebulous financial presentations and devised optimal explanations

Senior consultant to clients, internal departments and other staff members on program design requirements and provides customer support by producing documentation and researching program and data questions

Conducted program survey modifications by getting specifications, anticipating database inconsistencies, programming studies, implementing changes, validating output and consulting with upper management when necessary

Collected custom data, validated data, wrote procedure documentation for projects, programmed to produce validation reports. Followed up with clients and reporting companies for additional information and data clarification for national print products

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