Summary
Overview
Work History
Education
Skills
Accomplishments
Timeline
Generic

Matthew W Burke

Lee’s Summit,Missouri

Summary

Accomplished consultant with a proven track record of driving organizational improvements through research, training, and implementation of new processes. Collaborates with employees and leaders to resolve control and procedural problems that impact business operations. Dedicated to optimizing costs, processes, and resources for maximum efficiency and success. Passionate about delivering results that drive business growth and sustainability.

Overview

8
8
years of professional experience

Work History

Principal Consultant, Software Developer

ICE Mortgage Technology
02.2024 - Current
  • Act as subject matter expert, trainer, and leader on multiple programs including two different ETL tools, T-SQL, SQL Server Management Studio, stored procedures, RETS, and javascript.
  • Manage a team of 6 employees including allocation of tasks, management of projects, approving time off, training, and final approval on finished work.
  • Manage gathering of data from multiple API data sources to be ingested into proprietary ETL tools.
  • Developed effective improvement plans in alignment with goals and specifications.
  • Evaluated staff performance and provided coaching to address inefficiencies.
  • Conducted regular reviews of operations and identified areas for improvement.

Database Analyst II

ICE, formerly Black Knight Financial Services
07.2022 - 02.2024
  • Act as subject matter expert for Paragon (internally created software), PETL (internally created ETL tool), SQL server, and RETS.
  • Create and update training documents including SQL scripts, task walkthroughs, and videos.
  • Create training lesson plans and act as trainer to new members of the Implementation team.
  • Ownership of System Change Requests in Paragon system for existing customers which includes researching customer requests, quoting work to be performed in billable man-hours, presenting the quote to the customer, performing the work on the System Change Request, and turning it over to accounting afterwards.
  • Act as point of contact for entire Implementation team as well as perform all previous tasks expected of a Database Analyst I.
  • Lead on Listing Publisher ETL tool produced by a third party including the design phase, setting up new customers inside of the tool, data mapping inside the tool, managing AWS Cloudwatch logs, QA for updates, and training.
  • Act as lead point of contact, manage special code, ETL projects, and special projects for our largest customers.
  • As part of this position, I average over 300 work hours of ad-hoc customer paid special project hours, which generates over $61k of extra revenue to the company.

Database Analyst I

Black Knight Financial Services
05.2019 - 07.2022
  • Utilize SQL Server Management Studio to build queries, run scripts, and gather data for proprietary software. All work is done by hand in T-SQL and re-usable scripts are saved to a shared workspace and provided for the team.
  • Complete work orders for service requests that involve using SQL and Javascript to change simple rules or major functionality of the proprietary software, such as converting data types IE Char to Int or normalizing data.
  • Work closely with customer representatives to determine needs, clarify work orders, and ensure work completed meets expectations.
  • Work with a team to fix the proprietary software through work orders, emergency tickets, and automated alerts.
  • Create and produce ad-hoc reports for management that cover a wide array of information such as current customers with specific data types being used, customers with under-normalized data, or databases currently using a specific configuration.
  • Manage and update software configuration using SQL Server Management Studio to control, change, or remove entire configurations such as end-user interface or remote connections.
  • Create, manage, and run stored procedures within SSMS to alter data for ETL that cannot be done through the UI as well as stored procedures that manage customer data which are run on a schedule.
  • Work within proprietary ETL software to insert data into local systems from external sources. Manage, diagnose, and repair faults that occur within the ETL system.
  • During my time in this position I have been the primary contact on projects that required complete reworkings of the backend data structure for the entire system for one or more customers which included altering data types, creating new fields, and providing reporting on existing data to map to new incoming data.

Senior Data Analyst

Department of Homeland Security NBC Contract
01.2017 - 05.2019
  • Collect and organize relevant data into usable formats through extracting data, transforming it, and loading it into required systems. Data gathered are ran through queries with results validated and utilized to create reports or in various databases.
  • Acted as manager of team of 8 people from January 2017 through May 2017.
  • Present reports to management ranging from my manager all the way to contract management and groups of up to 20 people. These reports can range from ad-hoc reports to monthly/quarterly/yearly data analysis.
  • Analyze problems to identify contributing factors, gather data from various sources, and create solutions for problems ranging from process related issues to database structure.
  • Modeling data using Oracle Business Intelligence Enterprise Edition for reporting. Models cover a range of information from file movement to number of incoming files per month per location.
  • Researching new sources to gather data and supporting information from.
  • Draft operating procedures, query documentation, data modeling, and database guides for use by programming department, management, or by individual teams.
  • Identify and collect data identified as necessary from various data warehouses to be used in reporting and resolution of procedural issues.
  • In this position, I performed daily fact-finding and investigative techniques to survey areas of improvement for processes timeliness which helped a number of teams perform better.
  • During my time, I completely redesigned all Perfects processes to utilize SMART data, which led to higher accuracy of data and reduced time needed to produce perfects from 3-4 hours per form type per day to just 1 hour per process per day.
  • For cost effectiveness, this has saved the contract $76,440 over the last year through increased streamlining of queries and better data acquisition.
  • This position required performing computations such as addition, subtraction, multiplication, and division correctly using whole numbers, fractions, decimals, and percentages during the creation of reports and analyses designed to estimate incoming workload and personnel management.
  • I summarized data in an appropriate format using resources and tools such as SAS, SQL Server Management Studio, Oracle Business Intelligence Enterprise Edition, and Microsoft Excel to create executive reports and summaries including pivot tables.
  • During my time in the position I developed and maintained collaborative working relationships with others on my team, in my company management, and with our primary client.

Education

Bachelors of Arts - English, History

University of Central Missouri
Warrensburg, Missouri
05.2015

Skills

  • Solution planning
  • Project Management and Oversight
  • Strategic development
  • Data analytics
  • Assessments
  • T-SQL
  • ETL

Accomplishments

Helped build and design a new proprietary ETL tool that allows for faster gathering and movement of data, which has improved time for records to be moved from the source system to destination in 20 seconds rather than the 5 minute minimum the process was using previously.


Hired 3 new team members in the last two years who have become top producers on the team.

Timeline

Principal Consultant, Software Developer

ICE Mortgage Technology
02.2024 - Current

Database Analyst II

ICE, formerly Black Knight Financial Services
07.2022 - 02.2024

Database Analyst I

Black Knight Financial Services
05.2019 - 07.2022

Senior Data Analyst

Department of Homeland Security NBC Contract
01.2017 - 05.2019

Bachelors of Arts - English, History

University of Central Missouri

Similar Profiles

CREATE PROFILE