Data Analyst Power Bi

Mahad Latif

***********@*****.*** linkedin.com/in/mahad-latif Keller, TX 817-***-****

EDUCATION

The University of Texas at Arlington Arlington, TX

Masters of Science in Business Analytics

The University of Texas at Arlington Arlington, TX

Bachelor of Science in Information Systems Honors: cum laude

EXPERIENCE

Lenity Light Hospice Watauga, TX Jan 2024 – Present

Operations Data Analyst

Built a real-time Employee Productivity Dashboard in Power BI, automating KPI tracking and delivering actionable insights to upper management for data-driven decision-making.

Designed and implemented an automated inventory tracking system with Power Automate and Excel, achieving a 15% reduction in inventory costs and improving accuracy, resulting in enhanced patient satisfaction.

Developed predictive models using Python to forecast inventory demand, optimizing stock levels and reducing overstock by 20%, resulting in more efficient resource allocation and cost savings.

Frontier Communications Dallas, TX Jun 2022 – Aug 2022

Customer Operations Data Analyst Intern

Organized coordination on the Fix-It Journey project, an intensive deep dive into the customer support side on web-based and mobile app platforms, searching through data and finding trends.

Presented a solution for improving the support of digital products in front of members of upper-level management including the COO, several SVPs, and VPs by gathering and analyzing data from the website, synthesizing information into key findings and recommendations, and communicating these ideas in a pitch presentation.

Engaged in mentoring sessions with the CEO and other C-level executives throughout the summer by asking questions to gain insights into the business, discussing their career journeys, and providing advice on life after graduation.

Boost Mobile Watauga, TX Oct 2018 – Nov 2021

Store Manager

Supervised and trained employees by holding weekly meetings, demonstrating sales pitches, and providing tips and advice, resulting in a sales increase in one year and employees with a 45% increase in average sales.

Created sales reports and controlled the flow of inventory while keeping within budget.

Developed and maintained store standards for customer service and environment, achieving a 95% customer satisfaction rating.

PROJECTS

Employee Productivity Dashboard

Lenity Light Hospice

Extracted data from multiple sources including the hospice software database and employee tracking software, using Power Query in Power BI to clean and transform the data through various data preprocessing techniques, to ensure consistent KPIs.

Collaborated with stakeholders to identify KPIs such as task completion rate, hours worked, patients visited, etc., and developed through Power Automate allowing for the removal of manual reporting and ensuring insights are up to date.

Designed an interactive platform for user-friendly visualizations such as line charts, bar charts, and heatmaps to present trends, variances, and overall employee performance. Implemented slicers and filters to allow upper management to inspect data thoroughly, which provided actionable insights for decision-making and performance optimization

Fix-it Journey Jun 2022 – Aug 2022

Frontier Communications

Discovered inconsistencies with information on the website through data scraping and transformed the qualitative data found into quantitative metrics that allowed stakeholders a better understanding of the data.

Analyzed and categorized data using advanced bucketization techniques to identify patterns and similarities, enabling the identification of critical issues and prioritization of the most significant challenges.

Delivered a presentation to a team of SVPs and the Chief Operating Officer, highlighting data inconsistencies discovered on the company website, and proposing strategic solutions to rectify the issues and improve data accuracy.

SKILLS

Technical Skills: Python, SQL, R, Power Query, Tableau, Power BI, Power Automate, Java, SAP

Certified in MS Office (Word, Excel, PowerPoint)

Languages: English, Urdu, Spanish

Contact this candidate