Stephen Smith
Senior Power BI Analyst
Ruther Glen, VA 22546
*******.*********@*****.***
Power BI and Microsoft Excel expert specializing in ad hoc projects to solve the unsolvable. Authorized to work in the US for any employer
Work Experience
Senior Reliability Engineer
GEICO-Fredericksburg, VA
April 2023 to Present
Analyze data from application and/or system outages in order to avoid future incidents or improve resolution speed, calculate the cost of downtime, and correlate similar incidents to map trends, solutions, and business impact.
Import data from multiple sources into Power BI to provide quick insight and understanding to upper management.
• Import data using API's and connectors from multiple sources such as Azure Synapse, Excel files, SQL, JSON files, or external databases.
• Manipulate, clean, and organize the data using DAX and Power Query
• Build new tables with distinct values and IDs by concatenating multiple data points, such as Date/Time/ Department in order to create in-depth and thorough analysis
• Present findings to multiple levels of management from direct manger to vice presidents, with varying audience sizes ranging up to 2,000 participants
Senior Tech Talent Acquisition Analyst
GEICO-Ruther Glen, VA
August 2022 to April 2023
Analyze and distribute incoming resumes for GEICO's IT department, approving or denying candidates based off various data including but not limited to:
• Education
• Experience
• Candidate Intake Tests
• Questionnaire Answers
• Multi-Dimensional Interviews
Track hiring statistics, creating dashboards in Microsoft Power BI that are broken into different departments, management levels, and similar categories. Senior End User Experience Analyst
GEICO-Fredericksburg, VA
February 2020 to August 2022
Query data from multiple sources such as Aternity, BMC Helix, and Active Directory using a combination of Tableau, Power BI, Azure, and some other reporting systems in order to:
• Assist upper management in making multi-million dollar decisions regarding application choices
• Report GEICO's End User experience by monitoring application and device health (laptops, desktops, tablets, mobile devices)
• Improve employee efficiency by investing application response time IT Service Desk Analyst
GEICO-Fredericksburg, VA
December 2018 to February 2020
Maintain and create reporting for the IT Service Desk using Excel and Tableau, including Agent Report Cards, Executive Summary, Call Volume Capacity Reports, Efficiency Reports and Productivity Reports.
• Maintain and create data tracking and projection reports.
• Create reporting system to reduce Help Desk tickets by 15%
• Project incoming Call Volume
• Analyze Work Order and Incident trends
Commercial Sales and Service Analyst
GEICO-Fredericksburg, VA
July 2017 to December 2018
Analyze data to assist upper management in making multi-million dollar decisions. Maintain and create reporting for GEICO's Commercial Department, such as efficiency reports, productivity reports, agent progress reports, compliance checking reports, data tracking and projection reports, as well as other overall department analytics.
• Maintain and create new pages for interdepartmental website.
• Maintain and create programs designed to increase individual sales agent output, as well as programs to assist in servicing of policies.
• Assisted in the development and creation of a new Commercial Automatic Telephone Attendant. Sales Associate
GEICO-Fredericksburg, VA
May 2016 to June 2017
Sold commercial insurance to business owners, by having in depth conversations over the phone to determine which coverages they needed most, in order to protect all aspects of their life and businesses. Some products include:
• General Liability
• Professional Liability
• Business Owner's Policies
• Commercial Auto businesses.
Education
BS in Kinesiology
SUNY College at Cortland - Cortland, NY
August 2008 to June 2013
Skills
• Extensive knowledge of Microsoft Office products, specializing in Microsoft Excel including VBA, as well as Extensive knowledge of Microsoft Power BI. Knowledge of SQL and AGILE. Knowledge of Sharepoint, using HTML and CSS.
• Data Analysis
• Business Analysis
• HTML
• SQL
• Cisco
• access
• Microsoft Office
• Sharepoint
• training
• Active Directory
• Project Management
• Analysis Skills
• IT Support
• Help desk
• Power BI
• Tableau
• Six Sigma
• Root cause analysis
• RESTful API (3 years)
• APIs (3 years)
• Cloud infrastructure (Less than 1 year)
• Editing
• Power BI
• Project management
• Communication skills
• Time management
• Business analysis
• Data analytics
• Data modeling
• Presentation skills
• Data management
• IT
• Data analysis skills
• Microsoft SQL Server
• Data lake
• Data warehouse
• Azure
• Business intelligence
• DAX
• SQL
• Math
• Relational databases
• Tableau
• XML
• APIs
• Analytics
• Data science
• Data visualization
• REST
• Workday
• SharePoint
• Analysis skills
• Systems analysis
• Database design
• Databases
• Forecasting
• Statistical analysis
Certifications and Licenses
AZ900
Present
DP900
Present
AI900
Present
Assessments
Analyzing data — Proficient
November 2021
Interpreting and producing graphs, identifying trends, and drawing justifiable conclusions from data Full results: Proficient
Indeed Assessments provides skills tests that are not indicative of a license or certification, or continued development in any professional field.