Power Bi Data Analytics

Page * of *

JOSEPH SANDLIN

619-***-**** • ******.*******@*****.*** • LINKEDIN.COM/IN/JOESANDLIN/

PROFESSIONAL PROFILE

Data analytics professional with a customer service-oriented mindset, a master's degree in data analytics, and certified in Power BI (PL-300). Proficient at handling complete report development cycles; possessing a strong foundation in a wide range of analytical concepts and an intuitive, common-sense approach to reporting and communication. CORE COMPETENCIES

• Exhibits strong communication skills to effectively engage and collaborate with stakeholders, including C-level executives, IT professionals, labor union leaders, and front-line staff.

• Capable of effectively gathering reporting needs, identifying essential Key Performance Indicators (KPIs), and providing actionable insights that improve work processes and drive better outcomes.

• Creatively utilize advanced data analysis skills to develop clear reports and visualizations that offer valuable information to enhance operations and enable informed business decisions.

• Demonstrate a solid comprehension of relational database structures to anticipate and efficiently resolve potential data quality issues.

• Technical skills include SQL Server Management Studio (SSMS), Power BI, DAX, SQL Server Reporting Services (SSRS), and MS Office suite, with an emphasis on Power BI, and developing SQL queries. PROFESSIONAL EXPERIENCE

Business Intelligence Analyst

Southwest Ohio Regional Transit Authority (METRO), Cincinnati, Ohio 2019 – Present

• Serve as a liaison between the IT department and multiple departments to develop complex T-SQL queries and/or Power Bi reports that translate data and reporting needs into actionable insights that drive business decisions.

• Conduct bi-weekly Operations “Think Tank” meetings; an open forum to discuss data driven solutions to solve pressing operations issues including customer service complaints, missed trips, operator retention, operator job satisfaction, operator performance, absenteeism; led to management changes and changes to operator pay for more difficult routes, and sub operator work.

• Prepare and model data: gather report requirements, identify sources of data for reports including internal and external sources including onsite and cloud-based databases, APIs, excel spreadsheets, etc.

• Clean and transform data: utilize SQL joins or Power BI Query Editor, addressing inconsistencies, unexpected values, and data quality; employee advanced SQL practices for filtering, variable creation, grouping, and additional techniques like merging data, formatting and creating date tables, optimizing analysis and presentation through sub queries, conversion functions and conditional formatting; write complex DAX measures or calculated columns.

• Model data: define relationships between tables; create universal date tables; optimize model performance by removing unnecessary rows or columns or analyzing performance to identify bottlenecks in model process.

• Visualize and analyze data: determine the visualization or descriptive statistical technique appropriate for the analysis, incorporating line charts, scatter charts, matrices, paginated reports, and more.

• Played an integral role in diverse projects, leveraging data-driven insights to troubleshoot complex database issues and maintain data integrity and availability.

• Contributed to the successful completion of application upgrades, database migrations, and financial forecasting initiatives, consistently delivering high-quality work to meet project goals.

• Assisted in resolving labor disputes by providing analytical support through data analysis, leading to informed decision-making and improvements.

• Awarded the Silver Wheel for April 2022, recognizing excellence as the administrative employee of the month. Financial Analyst

Southwest Ohio Regional Transit Authority (METRO), Cincinnati, Ohio 2018 – 2019

• Executed multiple projects on ROI analyses, budget forecasting, labor trends identification, and process improvements, utilizing advanced features of MS Excel and MS Access such as pivot tables, V-lookup, conditional Page 2 of 2

formatting, aggregate formulas, and large dataset manipulation. These projects provided critical inputs for making key financial decisions.

• Develop data-driven reports using MS Excel and SSRS Report Builder, and present findings to operational, finance, and executive management through MS PowerPoint. Effectively communicate insights derived from the data to inform key decision-making processes.

Business Analyst

Fifth Third Bank (Contractor), Cincinnati, Ohio 2017 – 2018

• Collaborated with the cybersecurity team on the Annual Access Review, using MS Excel and MS Access for exploratory data analysis and database management. Identified outliers and opportunities to optimize employee entitlement databases and improve data accuracy and access control policies. Benefits Counselor

Colonial Life & Accident Insurance Company, San Diego, California 2008 - 2017

• Provided excellent customer service and managed clients’ open enrollments, resulting in an average of $390K in annual premiums generated. Conducted open enrollment meetings, gave group presentations, and met one-on-one with employees of companies ranging from 3 to 10K employees to determine prospects’ needs for supplemental benefits.

EDUCATION AND TRAINING

National University, San Diego, California

Master of Science in Data Analytics (2016)

San Diego State University, San Diego, California

Bachelor of Arts in Philosophy (2007)

Microsoft Certified

Power BI Data Analyst Associate PL-300 (December 2023)

Contact this candidate