Data Analyst Power Bi

Sneha Mandha

Data Analyst Registered Pharmacist (India) Clinical Informatician

+1-803-***-**** ć **********************@*****.*** Professional Summary

• Results-driven Data Analyst with 3+ years of experience transforming complex healthcare, clinical, and business data into actionable insights using SQL, Power BI, Tableau, and Excel.

• Demonstrated success in EHR data analysis, KPI dashboard development, HIPAA-compliant systems. Skilled in data story- telling, statistical analysis, and stakeholder communication to support clinical decision-making, operational improvements, and regulatory compliance.

• Developed interactive Power BI dashboards with slicers, drill-through filters, and KPIs to track hospital admissions, diag- nosis trends, bed occupancy, and staff workloads.

• Wrote complex SQL queries (JOINS, CTEs, subqueries) to extract, clean, and aggregate data from relational databases for patient records, appointments, and treatment outcomes.

• Built and normalizedMySQLdatabaseswithstoredprocedures,indexing, and foreign key constraints to ensure data integrity and optimize query performance.

• Created a HIPAA-compliant web platform for a cancer care initiative using REST APIs, JWT authentication, and secure analytics dashboards.

• Designed data stories in Tableau using calculated fields, dynamic parameters, and annotated trends for clinical reviews and academic decision-making.

• Conducted cohort and time-series analysis to explore student engagement and retention trends, using Tableau Prep for cleaning and reshaping datasets.

• Cleaned and analyzed Qualtrics survey data with SQL and Excel (VLOOKUPs, pivot tables, regression analysis) to measure behavioral trends and campaign outcomes.

• Managed Google Analytics and CMS content, conducted A/B testing, and built dashboards to monitor SEO, traffic sources, bounce rates, and CTRs.

• Contributed to pharmaceutical research by conducting a literature review on COVID-19 and diabetes, supporting meta- analysis and glycemic control evaluations.

• Gained GMP lab experience, working on HPLC, titration, and stability testing for batch release and documentation with QC teams.

• Used Power Query and advanced Excel formulas (CASE WHEN, GROUP BY) to restructure and clean healthcare data for BI integration.

• Partnered with UX designers and clinical stakeholders to translate workflows into data specifications, enhancing dashboard usability and decision support tools.

• Presented analytical findings through visual storytelling to interdisciplinary teams, influencing strategic direction with evidence-based recommendations.

Skills

Technical and Data Tools SQL MySQL Power BI Tableau R Programming Advanced Excel MS Access DAX MongoDB REST APIs HTML/CSS XML Microsoft Visio Power Query Open EMR Xpoda Qualtrics

3D-Printing Data ETL

Standards ICD-10 CPT HL7 HIPAA SNOWMED FHIR CDISC GMP/cGMP ISO 9000 & ISO14000 SUPAC Web Technologies Wordpress SEO Web development PHP XAMPP SEO Canva Publisher Pharmaceutical Skills Prescription dispensing Patient Education Pharmacy Drug Database CDS LIMS TIMS QbD Statistical Tools PC/SAS SPSS STATA MINITAB ANOVA Digital Marketing Research and Analytical Skills Content Developer Molecular Docking IMViC Tests Staining Techniques CADD Gaming Unity

Languages English, Telugu (Mother Tongue), Hindi (Native), Sanskrit (Basic Proficiency) License

Registered Pharmacist March 2023 - March 2028

Telangana State Pharmacy Council Telangana, India

Work Experience

Web Developer January 2025 - May 2025

MaxLiving Lexington Chiropractic Lexington, SC

• Contributed to the design, development, and maintenance of “Meta Rest,” a secure, responsive web platform supporting Cause-Centered Cancer Care, ensuring compliance with HIPAA data protection standards.

• Implemented MongoDB-based data collection and storage workflows with encrypted transmission protocols, enabling secure handling of sensitive patient information.

• Integrated REST APIs and built dynamic, interactive modules to support personalized treatment plans and drive patient engagement.

• Collaborated with UX/UI designers, developers, and healthcare providers to enhance platform accessibility, responsiveness, and usability using HTML5 and Tailwind CSS.

• Designed and deployed a relational healthcare database in MySQL, incorporating normalized schemas and foreign key relationships to ensure data accuracy and scalability.

• Authored and optimized complex SQL queries using JOINs, aggregations, window functions, and CASE logic to generate insights into read- mission trends, ICD code frequencies, and departmental utilization.

• Created Power BI dashboards with DAX measures, KPIs, and slicers to visualize key metrics such as average length of stay, top diagnoses, and staff workload distribution.

• Delivered end-to-end data analytics solutions, including ETL processes using SQL and Excel (Power Query), and developed compelling data visualizations in both Power BI and Tableau..

• Applied healthcare analytics best practices, including knowledge of clinical workflows, quality metrics, and compliance frameworks, to develop decision support tools.

• Demonstrated a strong commitment to leveraging technology, data science, and storytelling to enhance patient care, optimize clinical operations, and support evidence-based strategies in healthcare. Graduate Research Assistant January 2024 - May 2025 University of South Carolina Columbia, SC

• Collected, cleaned, and analyzed student engagement and housing datasets to uncover trends in participation, program success, and overall student well-being.

• Built interactive Tableau dashboards to visualize metrics such as event attendance, housing satisfaction, and community engagement segmented by demographics and time.

• Created calculated fields, filters, and dynamic parameters to support real-time reporting needs for program coordinators, enabling data-driven planning and resource allocation.

• Conducted exploratory data analysis to identify patterns in engagement peaks, underrepresented student groups, and preferred event formats, guiding inclusive programming strategies.

• Partnered with residential life leadership to translate analytical insights into actionable strategies to improve student retention and program effectiveness.

• Monitored and analyzed digital engagement metrics from social media and web platforms, refining outreach strategies based on observed trends.

• Designed visual marketing assets in Canva, using community insights to align promotional content with student preferences.

• Assisted in marketing research in the Behavioral Lab under Prof. Elise, conducting Qualtrics-based experiments, managing sessions, and gathering consumer behavior data.

• Cleaned and transformed large experimental datasets using Excel and Power BI, ensuring accuracy and readiness for statistical and behavioral analysis.

• Applied advanced techniques like pivoting, unpivoting, and Power Query to restructure raw data for improved usability in BI dashboards.

• Developed interactive Power BI dashboards with DAX-based KPIs, slicers, and custom metrics to interpret consumer trends and visualize experimental results.

• Standardized data workflows for importing, validating, and analyzing raw datasets, improving research efficiency and ensuring high-quality, reproducible outputs.

• Built visual summaries such as clustered bar charts, line graphs, and matrix tables to present key experimental outcomes and behavioral patterns.

• Presented insights to faculty and research stakeholders through data storytelling, supporting academic publications and strategic study design.

• Collaborated with fellow researchers to enhance data tracking protocols, experimental infrastructure, and reporting workflows using SPSS, Excel, and Google Sheets.

• Strengthened expertise in data governance, reproducibility, and transparent reporting, aligning with academic and industry analytics best prac- tices.

Content Developer January 2022 - August 2023

PenUp Marketing Agency Telangana, India

• Created, edited, and published high-quality written content for blogs, websites, newsletters, and social media, tailored to diverse audiences and aligned with brand voice.

• Conducted SEO-focused keyword research using SEMrush and Google Keyword Planner, enhancing content visibility and boosting organic search rankings.

• Leveraged Google Analytics and Google Search Console to track user engagement, website traffic, and content performance metrics, informing optimization strategies.

• Collaborated with designers and developers to ensure cohesive UX, branding, and content alignment across marketing campaigns and digital platforms.

• Managed end-to-end content publishing workflows via WordPress and other CMS platforms, ensuring consistent updates and accurate format- ting.

• Developed content calendars, campaign briefs, and reporting templates to streamline planning and measure campaign effectiveness.

• Adapted content style and structure across digital formats, including landing pages, infographics, social media posts, email campaigns, and video scripts.

• Utilized A/B testing, heatmaps, and user behavior data to refine messaging and improve conversion rates, click-through rates (CTR), and audience retention.

Industrial trainee May 2019 - December 2021

Arch Pharmalabs, Ltd. Telangana, India

• Performed analytical testing of raw materials and finished pharmaceutical products in accordance with SOPs and cGMP standards to ensure product quality, safety, and regulatory compliance.

• Collaborated with cross-functional teams including Quality Control, Research & Development, and Production to support the end-to-end pharmaceutical manufacturing process.

• Participated in data recording, deviation tracking, and documentation audits as part of compliance and quality assurance workflows.

• Monitored and supported ongoing research titled “Advances in Diabetes Management during COVID-19”, examining clinical data related to morbidity and mortality in diabetic patients co-infected with COVID-19.

• Contributed to literature review and pharmaceutical analysis, evaluating alternative treatments such as Dapagliflozin in comparison to Met- formin for COVID-19 patients with diabetes.

• Assessed the importance of glycemic monitoring and proposed protocols for preventive care and clinical tracking based on findings from the research project.

• Gained exposure to clinical trial principles, pharmaceutical formulation analysis, and risk assessment practices during real-time lab observation.

• Actively engaged in fostering a culture of quality improvement, research-driven innovation, and data accuracy throughout laboratory and collaborative work environments.

Education

University of South Carolina August 2023 - May 2025 Masters in Health Information Technology GPA: 4.0/4.0 Columbia, SC President’s List: Fall 2023, Spring 2024, Fall 2024, Spring 2025 Harvard Business School Online November 2022

Digital Health 22QG-0SJU-STA5

Vishnu Institute of Pharmaceutical Education and Research August 2018 - May 2022 Bachelors in Pharmacy CGPA: 8.01/10 Telangana, India Publications

Biocompatible Nanosponges for Multifunctional Drug Delivery Applications August 2024 Book Chapter - Published IIP

ISBN: ***-**-****-310-5

Contact this candidate