David Brehen Email & Phone Number

Deliver strategic direction and mentorship to data analysts to build a culture of ongoing development. Meet with directors, supervisors, and team members to optimize communication and improve project efficiency. Offer invaluable insights for reporting and analysis to create FACT and DIMENSION datasets. Oversee daily job failure to ensure operational success. Execute iterative plans to ensure processes and foster continuous improvement. Address inquiries and rectify discrepancies in reports for accuracy. Formulate and execute various training methods to cultivate team synergy and individual advancement. Empowered data-driven decision-making by creating highly informative reports and leveraging the capabilities of Power BI and Databricks.Aligned data and report requirements with business objectives through coordination with internal department managers.Set a benchmark of excellence by achieving cleaning and processing of extensive datasets while using Azure Databricks, Excel, SQL Server Management Studio, Python, and Power BI.

Phoenix, Arizona Area

Applied SQL jobs, SQL server integrated service, and SQL server management studio to transfer various amounts of data across servers. Examined the performance of 50 SQL jobs across diverse servers and resolved failures to ensure smooth operational continuity. Analyzed key information to formulate initial reports and resolve discrepancies, through validation testing. Directed ETL processes for data extraction, transformation, and loading to assure seamless reporting. Improved efficiency and accuracy by utilizing SQL Jobs and SSIS tools. Gathered requirements and specifications to offer tailored data and reports in liaison with internal department managers. Assumed and maintained full accountability for producing reporting information through SQL server analysis services (OLAP Cube), SQL server reporting services, and Power BI.Delivered impactful insights to craft final reports by using SQL, Databricks, custom-built report viewers, and Power BI.Directed the extraction, transformation, and loading (ETL) of data from diverse sources to meet reporting needs.Succeeded in boosting reporting, data analysis, and decision-making efficiency by creating a CUBE using SQL Server Analysis Services (SSAS) for a crucial report.Led the collection and cleansing of data vital for producing 30 reports utilized by diverse organizational departments.

Phoenix, Arizona Area

Manage the workload between two applications. Maintain quality control and workload over team members. Help the team out with validation for items ready to be released. Tested, debugged, and recommend changes to web application that is used by 1500+ locations nationwide. Developed systematic test plans to ensure quality control and consistency of product. Verified, at minimum, that all requirements have been met and looked outside the standard requirements to make sure nothing else was affected by the changes in the program. Wrote SQL statements to verify the information was passed or retrieved correctly when testing changes.

Assist with testing and ongoing development of current and upcoming programs for U-Haul Contact Center. Wrote and developed business requirements for new applications and program improvements. Provide technical support to all sub-departments of Contact Center, as well as general computer/phone support to employees in house and work from home.

Handled day-to-day operations including hiring, scheduling, accounting, and the profit and loss. Diffused situations when necessary where both parties felt comfortable with the outcome. Built customer relations by providing personal services, such as movie recommendations and knowing my customers by their first name.

Greet clients and provide them access to the club.

Bs, Cis Information Security, A

Graduated Summa Cum Laude Project: Served as a Lead Programmer and Project Coordinator and led a cross-functional team of four members.

General Studies