Data Analytics Information Security Business Intelligence Analyst

Brian Czech, MSDA

586-***-**** ad9rf9@r.postjobfree.com Clinton Township, MI

www.linkedin.com/in/BrianCzech/ www.github.com/BrianCzech

CAREER OBJECTIVE

Recent master’s graduate seeking a position in data analytics or information technology in order to utilize Excel, SQL, Python, Power BI and other software tools to build creative code, analyze data, and protect networks from cyber threats.

EXPERIENCE

Business Intelligence Analyst Intern, Helm August 2022 – November 2022

●Executed analysis on various data sources for company's clients to achieve their goals

●Developed tools in Power BI and fulfilled ad hoc analysis within Google Analytics

●Collaborated with Executive Vice President, Supply Chain Solutions for tracking merchandise sales within Power BI to visualize and spot trends, and to communicate to our clients

●Built equations to determine automotive dealers' loyalty and performance ratings to know which clients need to improve their evaluation

●Presented Google Analytics data and analysis of Stellantis and NRA brands to upper management so they can relay our findings to each client

●Managed an automotive Dealer Master file with various types of client data for daily updates in order to spot trends

●Produced additional visualizations in Python to establish graphs that are not standard in Power BI for better analysis

Underwriter, United Wholesale Mortgage January 2021 – April 2021

●Studied and evaluated risk from borrower's credit report, assets, tax information, and homeowner's insurance policy to determine the borrower’s eligibility for loan

●Called 5 to 10 mortgage brokers daily to discuss the next steps to close the mortgage deal

EDUCATION

Masters of Science, Data Analytics September 2023

Walsh College, Troy, MI

GPA: 3.627

Bachelors of Science, Management Information Systems April 2020

Oakland University, Rochester, MI

GPA: 3.23

SKILLS

Power BI, Google Analytics, SAS Studio, Systems Development Life Cycle, Data Analysis, Lean Six Sigma, HTML5, CSS, Python, SQL, Excel-VBA, Tableau, Hadoop, MapReduce, Kali Linux, MINITAB, Ubuntu, Wireshark, OWASP ZAP Proxy, Virtual Machines, C#, .NET, Azure

PROJECTS

Developed a Power BI tool to track merchandise sales

Constructed a Tableau program to analyze NBA success for college basketball players

Determined which house appliances are most influential in sale price and developed a formula to predict future home sales in Ames, Iowa using SAS Studio

Fabricated an application for a pseudo business called Plow ‘N’ Mow which allows individuals to purchase contract services for lawn care and snow removal; based on the Uber concept

Created a sporting goods store website using HTML5, CSS, and JavaScript

CERTIFICATES/CERTIFICATIONS

●Extract, Transform and Load Data in Power BI September 2024

●Introduction to Microsoft Azure Cloud Services August 2024

●C# for .NET Developers August 2024

●Harnessing the Power of Data with Power BI August 2024

●Preparing Data for Analysis with Microsoft Excel August 2024

●Google Analytics for Beginners August 2022

●Certified Internet Web Professional (CIW) Site Development Associate May 2016

Contact this candidate