LAKSHMI TANUJA TANGA
Columbia,SC
Summary
Insightful and results-driven Data Analyst with over 3 years of experience converting complex healthcare and operational data into meaningful insights that guide strategy and performance. Proficient in Power BI, SQL, SAS, and Excel, with proven expertise in building dynamic dashboards, ensuring data accuracy, and streamlining reporting processes. Experienced in collaborating with business and clinical stakeholders to translate data into clear, actionable solutions that advance public health goals.
Overview
4
4
years of professional experience
Work History
Data Analyst
BlueCross BlueShield of SC via Consulting Solutions
01.2025 - Current
- Expert in extracting, transforming, and consolidating recruitment and operational data from multiple sources including Workday, SQL Server, MS Access, and Excel, ensuring unified and accurate datasets for analysis and reporting.
- Designed and developed interactive Power BI dashboards visualizing key project and recruitment metrics, enhancing visibility into estimator workloads, project timelines, and business insights.
- Utilized Power Query (M language) to clean, reshape, and automate data workflows—streamlining manual reporting processes and ensuring real-time, accurate updates.
- Extracted and optimized complex SQL queries from BusinessObjects and SQL Server, improving data retrieval efficiency and enabling faster Power BI refresh cycles.
- Built Excel and Access macros to automate data imports, filtering, and report generation, significantly reducing manual effort and turnaround time for weekly and monthly reports.
- Performed rigorous data validation and quality control checks, identifying and resolving inconsistencies across systems to maintain data accuracy and reliability.
- Authored technical documentation detailing data logic, workflow steps, and validation rules to ensure consistency, sustainability, and team knowledge sharing.
- Enhanced dashboard and query performance through efficient data modeling and query tuning, resulting in improved refresh speed and user experience.
- Partnered with HR, recruiter, and executive stakeholders to deliver actionable insights, translate complex data into clear narratives, and support strategic decision-making
Graduate Research Analyst
University of South Carolina
01.2023 - 12.2024
- Utilized Logi Report Builder, Excel, and SAS to extract, clean, and analyze large-scale national administrative and research datasets, supporting evidence-based insights for childcare and consumer behavior studies.
- Applied advanced Excel functions, data validation techniques, and SAS programming to standardize raw data and ensure high data accuracy across multiple research streams.
- Developed dashboards and visual reports to present statistical outcomes and behavioral insights, enhancing data-driven decision-making for research teams.
- Streamlined data collection and volunteer tracking processes, increasing workflow efficiency by 30% and reducing manual effort through automation and process standardization.
Health Care Analyst
Sibar Institute of Dental Sciences
01.2022 - 12.2022
- Retrieved and analyzed large volumes of clinical and operational data from Electronic Health Records (EHRs) to generate insights supporting evidence-based treatment planning and patient care optimization.
- Partnered with clinicians, IT, and administrative teams to develop data reports and dashboards that enhanced visibility into key performance indicators (KPIs) and operational metrics.
- Designed and implemented audit and validation frameworks that increased patient data accuracy by 25%, ensuring compliance with HIPAA and internal governance standards.
- Conducted statistical and trend analyses on patient outcomes to identify performance patterns, supporting improved clinical recommendations and patient satisfaction.
- Streamlined data collection, validation, and reporting workflows using advanced Excel techniques and automation scripts, reducing manual errors and reporting time.
Education
Master of Science - Health Information Technology
University of South Carolina
Columbia, SC12.2024
Bachelors - Dentistry
NTR University of Health Sciences
11.2021
Skills
- Excel functions
- SQL
- Microsoft Access
- Microsoft Visio
- PowerBI
- Data cleaning
- Data validation
- ETL processes
- Statistical analysis
- R programming
- Data modeling
- Data mapping
- Workflow automation
Timeline
Data Analyst
BlueCross BlueShield of SC via Consulting Solutions
01.2025 - Current
Graduate Research Analyst
University of South Carolina
01.2023 - 12.2024
Health Care Analyst
Sibar Institute of Dental Sciences
01.2022 - 12.2022
Bachelors - Dentistry
NTR University of Health Sciences
Master of Science - Health Information Technology
University of South Carolina
Similar Profiles
Lacie PennyLacie Penny
Senior Medical Reviewer at BlueCross BlueShield of SCSenior Medical Reviewer at BlueCross BlueShield of SC
Tieshia GarnerTieshia Garner
Stop Loss Accounting Analyst at BlueCross BlueShield Of SCStop Loss Accounting Analyst at BlueCross BlueShield Of SC
Alicia BrownAlicia Brown
Senior Operations Analyst at BlueCross BlueShield of SCSenior Operations Analyst at BlueCross BlueShield of SC
Keisha L. BudgettKeisha L. Budgett
Supply Systems Analyst at SC Army National GuardSupply Systems Analyst at SC Army National Guard
Jennifer WigginsJennifer Wiggins
Regional Sales Manager at VirbacRegional Sales Manager at Virbac