Matthew Bereuter

Matthew Bereuter

$60/hr
POWER BI, PYTHON, SQL, EXCEL
Reply rate:
-
Availability:
Hourly ($/hour)
Location:
Grapevine, Texas, United States
Experience:
20 years
MATTHEW BEREUTER- EXPERIENCE NORFLEET LAND SERVICES 2018 – 2023 DIRECTOR OF DOCUMENT AND DATA MANAGEMENT ≻ Established and managed a proprietary land records database, ensuring efficient handling of extensive complex data volumes while prioritizing data integrity and security ≻ Developed and implemented document/data processes, procedures, and best practices ≻ Managed over 1M land acquisition records and data for over 1K pipeline projects ≻ Provided technical support, facilitated knowledge sharing, fostered collaboration among employees and clients in effective document and data management DATA ANALYTICS CONTENT CREATOR ≻ Created client-specific reports using Microsoft Power BI, incorporating data transformation, modeling, Data Analysis Expressions (DAX), and advanced visualization techniques ≻ Developed Power BI reports from various data sources, optimizing performance in Power Query and DAX to enable advanced querying and analysis ≻ Designed intelligent data structures to enhance overall workflow efficiency and effectiveness WILLIAMS COMPANIES 2008 – 2017 REPORT DEVELOPER / DATA ANALYST ≻ Assisted in the creation of a proprietary land records database, contributing to the development of a robust data foundation ≻ Created interactive dashboards using SQL and SSRS, offering stakeholders real-time clarity into pipeline operations and compliance ≻ Generated reports on environmental impact, safety, and compliance to meet regulatory requirements ≻ Provided meaningful business value through clear data visualizations, enabling self-service analytics, and configuring solutions for easy consumption ≻ Supported clients in designing analytical tools, encompassing needs analysis, defining KPIs, and developing customized solutions ≻ Developed complex worksheets for monitoring financial performance ≻ Monitored usage and created statistical views to optimize the utilization of reports and dashboards ≻ Assisted in transforming reporting procedures, focusing on redesigning report structures, visualization techniques, and overall report functionality ≻ Conducted onsite visits to Shale plays (Barnett, Eagle Ford, Fayetteville, Haynesville-Bossier, and Marcellus) for ad-hoc business analyses, providing valuable insights during BI report development LAND REPRESENTATIVE ≻ Collaborated with route development to establish economically sound routes and plan future connections ≻ Assisted in route development, Right of Way (ROW), title, survey, and permitting to define and refine KPIs ≻ Analyzed ROW agreements for accuracy and completeness, ensuring contractual obligations were met ≻ Negotiated and drafted various agreements, including ROW Agreements, amendments, surface use Agreements, etc. ≻ Developed, implemented, and maintained processes for ROW, title, survey, and permitting using Visio crossfunctional flowcharts, enhancing efficiency and clarity in workflows 1 PENNINGTON COMMERCIAL (formerly MSI Flooring) 2005 – 2008 SENIOR PROJECT MANAGER ≻ Primary point of contact for clients, ensured effective communication, successfully managed expectations, and resolved issues to guarantee client satisfaction ≻ Collaborated with cross-functional teams including developers, designers, and quality assurance personnel, fostering successful project outcomes for local and international clients across diverse industries ≻ Engaged in report development creation for clients providing valuable insights into project progress and key metrics ≻ Prepared and delivered regular project status reports to the CEO, summarizing accomplishments and key metrics for transparency and strategic decision-making ≻ Utilized self-customized Excel project management software and tools to track progress, providing realtime updates to the CEO ≻ Led a team of 50 flooring professionals, ensuring the successful execution of projects within established timelines and budgets ≻ Conducted risk assessments and implemented effective risk mitigation strategies, resulting in a reduction of project-related issues ≻ Developed and maintained comprehensive project plans, encompassing scope, schedule, budget, and resource allocation ≻ Coordinated and facilitated regular team meetings to review project status, address roadblocks, and identify solutions collaboratively ≻ Managed project budgets of up to $1.5M, consistently meeting or exceeding financial objectives ≻ Validated data for quarterly and annual reports, ensuring accuracy and reliability for informed decisionmaking ≻ Prepared one-off operational analyses to meet internal and external reporting needs EDUCATION THE UNIVERSITY OF TEXAS - ARLINGTON 2007 ≻ Bachelor Of Business Administration - Management CERTIFICATIONS AND SKILLS THE UNIVERSITY OF OKLAHOMA ≻ Lean Six Sigma Greenbelt 2014 2 ENTERPRISE DNA Accessing Data Via API’s Advanced Analytics Advanced PBI Visualization Techniques Applied Problem Solving with Power Query/M Beginners Guide to DAX Beginners Guide to PBI Dashboarding & Data Visualization Intensive DAX Formula Patterns GeoSpatial Analysis Mastering Charticulator Mastering DAX Calculations Mastering Report Development Optimizing DAX Paginated Report Writer II PBI Super Users Workshop Report Development Best Practices Scenario Analysis Deep Dive SharePoint Introduction for PBI Users MICROSOFT APPLICATIONS Access BIDS Excel Power BI PowerPoint SharePoint Visio Visual Studio Code – GitHub CoPilot Report Builder Word ADDITIONAL Python SQL 3
Get your freelancer profile up and running. View the step by step guide to set up a freelancer profile so you can land your dream job.
Similar profiles