Bi Analyst Public Health

Amisha Shukla

******************@*****.*** 469-***-**** Dallas,TX

Summary

Results-driven BI Analyst with expertise in requirement gathering, data analysis, and data visualization. Proficient in SQL and skilled in optimizing Tableau dashboards to deliver actionable insights that support strategic business growth and informed decision-making.

Work Experience

BI Analyst, Texas Department of State Health Services March 2024-June 2025

● Texas Maternal Health Metrics Developed a comprehensive suite of dashboards and reports by integrating death certificates with birth and fetal death records, enabling early identification of high-risk maternal cases, supporting public health interventions. Reduced reporting delays by 25% through automated data linkage. Recognized by leadership for delivering impactful insights.

● Severe Maternal Morbidity Analyzed 20+ datasets to create reports analyzing unexpected labor outcomes and severe maternal morbidity. Enabling leadership to identify health impacts, increased medical costs, and extended hospitalization stays for public health awareness through press releases.

● Non-Fatal Drug Poisoning Trends Analysis from EMS Records Conducted Gap Analysis on technologies, documenting – enhancements that met end-state requirements.

● Texas Health Dashboard Re-Design – BI Usability Optimization Designed 12 dashboard wireframes using Adobe Illustrator for the Texas Health, increasing user adoption and engagement by 35%.

● Agile Transformation and Process Improvement Facilitated JAD sessions, documenting functional requirements as product backlogs in Jira. Boosted developer productivity by 25% by implementing iterative sprint planning and daily stand- ups to improve team collaboration, transparency, and delivery cadence. Business Intelligence Analyst, Dallas Rugs May 2023-October 2023

● Executive Summary - Digital Footprint Overview Streamlined data integration from diverse digital sources and purchase order reports. Utilized advanced data modelling techniques to build a leadership dashboard. Focused on optimizing conversion rates and lowering bounce rates, resulting in a notable 17% increase in conversions, equating to 56 more conversions per month.

● Customer Journey Customer journey analytics dashboard incorporated pattern recognition analysis by measuring visits to the Dallas Rugs landing page, analysing the time spent on each page to gauge interest, tracking cart additions, monitoring progress through checkout, and recording purchase completion. Achieved a 75% improvement in overall visibility through this project, garnering significant appreciation.

● Analytical Reporting Monitored metrics, including post reach, impressions, likes, comments, open rates, click-through rates, and conversions to evaluate the success of campaigns

● Enhanced campaign efficacy and extended outreach for product promotions and customer engagement by leveraging online tools including Social Media Platforms, Targeted Advertising, Email Marketing via Mail Chimp, and comprehensive utilization of google analytics

● Adhoc Reporting and Data Warehousing Streamlined reporting processes, reducing time spent on data analysis by 21% while improving accuracy.

BI Marketing Analyst, Evitamin Business Consulting May 2018-October 2021

● Developed projects using SDLC and Waterfall Methodology, completing 95% within deadlines.

● Performed SWOT analysis and market research on 15 competitors, improving market positioning by 25%.

● Created 30+ visualizations using Tableau and Power BI, enhancing stakeholder decision-making by 40%.

● Collaborated with cross-functional teams to align requirements with ERP solutions. SKILLS

Methodologies and frameworks: SDLC, Agile/Scrum, Waterfall Data Analysis and Visualization: Statistical Analysis, R, Python (Pandas, NumPy), Tableau, Power BI, Hadoop, MS Excel, Oracle SQL, MySQL, Google Cloud, AWS, Microsoft Azure

Project Management Tools: JIRA, Microsoft Project Suite EDUCATION

The University of Texas at Dallas, Richardson, TX Master of Science, Business Analytics Medi-Caps University, Indore, India Bachelor of Technology, Electronics and Communication CERTIFICATIONS

Microsoft: Data Analysis and Visualization with Power BI, Google: Google Analytics

Contact this candidate