Data Analyst Power Bi

Dharmatejaswi Gogineni

Data Analyst

USA +1-937-***-**** Email: **********************@*****.*** Professional Summary

Data Analyst with 3+ years of experience delivering insights through data analysis, BI dashboards, ETL pipelines, and predictive modeling in healthcare and IT consulting domains. Skilled in SQL, Python, Tableau, Power BI, and cloud platforms (AWS, Azure, GCP), with expertise in data governance, forecasting, and KPI reporting. Proven record of enabling data-driven decisions, improving reporting efficiency, and ensuring compliance with HIPAA, GDPR, and SOX. Technical Skills

• Data Analysis & Querying: SQL (T-SQL, PL/SQL), Python (Pandas, NumPy), R, Excel (VBA, Pivot, Power Query).

• Business Intelligence Tools: Tableau, Power BI, Qlik Sense, Looker, Google Data Studio.

• Databases & Warehousing: Snowflake, Redshift, BigQuery, Teradata, SQL Server, Oracle.

• ETL & Data Integration: Alteryx, SSIS, Talend, Informatica, Apache Airflow, Azure Data Factory.

• Cloud Platforms: AWS (S3, Athena, Redshift), Azure (Synapse, Data Lake, Databricks), GCP (BigQuery).

• Data Modeling: Star/Snowflake schemas, OLAP/OLTP, dimensional modeling, fact/dimension design.

• Statistics & Predictive Analytics: Regression, clustering, time-series forecasting, hypothesis testing.

• Automation & Scripting: Python (automation scripts), SQL stored procedures, Excel macros, report scheduling.

• Visualization & Reporting: Executive dashboards, KPI scorecards, operational analytics, ad-hoc reporting.

• Data Governance & Compliance: HIPAA, GDPR, SOX, data validation, quality frameworks, audit readiness.

• Agile & Collaboration Tools: Jira, Confluence, SharePoint, MS Teams, Agile/Scrum delivery lifecycle.

• Other Tools: SAS, STATA, DAX, M language, API integrations for data pipelines and BI dashboards. Professional Experience

Data Analyst, Elevance Health, USA Jan 2025 – Present

• Built Tableau and Power BI dashboards with Snowflake, SQL Server, and Redshift, enabling near real-time tracking of claims, patient outcomes, and provider performance while reducing reporting turnaround from 5 days to hours.

• Built and optimized ETL workflows with Python, Airflow, and Azure Data Factory to integrate EHR/EMR, claims, and provider datasets, improving data quality, reducing refresh times by 60%, and enabling predictive analytics at scale.

• Conducted statistical analysis and ML modeling with Python (Scikit-learn, Pandas, NumPy) for patient readmission and fraud detection, improving prediction accuracy by 19% and enabling earlier clinician intervention in at-risk cases.

• Designed KPI dashboards and forecasting models with regression and time-series methods, improving budget planning accuracy by 14% while ensuring HIPAA and SOX compliance in financial reporting.

• Improved Snowflake and Redshift performance by redesigning schemas, applying clustering/partitioning, and tuning queries, cutting report execution times by 35% and enabling faster ad-hoc analysis for 500+ users.

• Defined and executed UAT plans, SQL-based data validation, and automated testing frameworks, ensuring accurate reporting pipelines, eliminating discrepancies across business units, and reducing production defects by 22%.

• Authored detailed BRDs, FRDs, and data dictionaries and created BPMN/UML diagrams in Visio to align technical teams and stakeholders on data flows, reducing requirement ambiguity and accelerating project sign-off timelines.

• Worked in Agile/Scrum delivery cycles, participating in backlog refinement, sprint planning, and daily standups, aligning with product owners and data engineers to deliver 25+ analytics features on schedule with measurable business impact.

• Implemented robust data governance frameworks with access controls, encryption, and metadata management policies, ensuring HIPAA, GDPR, and SOX audit readiness and maintaining 100% compliance during external audits.

• Mentored and trained junior analysts in SQL optimization, BI dashboard development, and Agile practices, creating reusable templates and guides that reduced onboarding time by 20% and improved team-wide efficiency. Data Analyst, Mphasis, India July 2020 – July 2023

• Designed and deployed dashboards in Tableau, Power BI, and Qlik Sense for healthcare clients, integrating SQL Server, Oracle, and MySQL to improve visibility into patient outcomes, claims, and KPIs while reducing executive reporting delays by 35%.

• Built ETL pipelines with Talend, Informatica, and SSIS to load large-scale healthcare data into Snowflake and Redshift, reducing manual processing by 30% and improving data accuracy across reporting workflows.

• Conducted financial and clinical data analysis with SQL, Python, and Excel (VBA, Pivot, Power Query) to uncover revenue leakage, optimize resources, and deliver $1.5M in annual cost savings for client organizations.

• Collaborated with clinicians, business stakeholders, and IT teams to capture requirements and deliver analytics solutions aligned with compliance standards, ensuring adoption of BI tools by 200+ business users across multiple client hospitals.

• Designed and optimized data warehouse models (Star and Snowflake schemas) for healthcare analytics, applying indexing and partitioning strategies that reduced reporting latency by 28% and improved support for complex ad-hoc queries.

• Applied predictive analytics and forecasting techniques in R and Python to support disease trend analysis, patient churn prediction, and demand forecasting, which improved healthcare resource planning accuracy by 14%.

• Implemented data quality frameworks with SQL and Python scripts, improving data accuracy by 20%, reducing duplicates, and creating automated validation pipelines that saved 15 analyst hours per week.

• Supported Agile delivery methodology, engaging in sprint planning, backlog grooming, and retrospective sessions, ensuring timely delivery of analytics enhancements and measurable alignment with evolving business requirements.

• Authored end-user documentation, training manuals, and release notes to facilitate smooth onboarding of healthcare stakeholders, increasing adoption of dashboards and reducing reliance on IT teams for reporting by 30%.

• Ensured compliance with HIPAA, GDPR, and SOX regulations by embedding encryption, access controls, and audit logging into analytics workflows, strengthening security posture and passing client audits without escalations. Education

Masters CLEVELAND STATE UNIVERSITY, CLEVELAND, USA. Aug 2023 - May 2025 Bachelor GITAM DEEMED TO BE UNIVERSITY, VISAKHAPATNAM, INDIA. June 2018 - April 2022

Contact this candidate