Data Analyst

Venkata Sahithi Ankareddi

Data Analyst

Indiana, USA **********@*****.*** 812-***-**** LinkedIn PROFESSIONAL SUMMARY:

5+ years of experience as a Data Analyst with experience in the healthcare and banking sectors.

Proficient in Tableau, SQL (including CTEs, window functions, multi-level joins), Electronic Medical Records (EMR), HL7, EDI, SSIS, Snowflake, Azure Data Factory, FHIR APIs, EHR systems, Excel (Pivot Tables, VLOOKUP), A/B testing, AWS (S3, RDS, Redshift), Power BI, Excel VBA, Python, Jira and Confluence.

Adept at data extraction, cleaning, transformation, dashboard development, ETL/ELT pipelines, data warehousing, cloud data management, fraud detection, and ensuring regulatory compliance (HIPAA, CMS, GDPR, RBI).

Experienced in Agile Scrum methodologies, JAD sessions, and data governance. TECHNICAL SKILLS:

Data Analysis & Reporting: Tableau, Power BI, Excel (Pivot Tables, VLOOKUP), Advanced Excel, Excel VBA

Databases & Querying: SQL, Oracle SQL, MySQL, PostgreSQL, Snowflake ETL & Data Integration: SSIS (SQL Server Integration Services), Azure Data Factory, AWS S3, AWS RDS, AWS Redshift

Data Transformation & Scripting: Python (for automation and reporting), SQL (CTEs, window functions, joins) Healthcare Data Standards: EDI 837, EDI 835, HL7, FHIR, EMR, EHR Compliance & Security: HIPAA, CMS Regulations, PHI Governance, GDPR, RBI Guidelines APIs & Integration: FHIR APIs, EDI Transaction Mapping Cloud Platforms: Microsoft Azure, AWS (S3, RDS, Redshift) Project & Agile Tools: Jira, Confluence

Statistical Techniques: A/B Testing, Fraud Detection Algorithms Data Governance: Data Quality Validation, Governance Standards, Joint Application Development

(JAD)

Collaboration & Modeling: Agile Scrum, Use Cases, User Stories, Sprint Management Other Skills: Ggplot, Jupyter Notebook, decision tree, linear regression, Looker Studio, BigQuery, Data Storytelling, Data Wrangling, Regression analysis, A/B testing, Data Modeling, Data Cleaning, Data Transformation, Data Visualization, Data warehousing

Operating Systems: Windows, Linux, Mac, iOS

PROFESSIONAL EXPERIENCE:

McKesson – IN January 2024 – Present

Data Analyst

Designed and implemented interactive Tableau dashboards for monitoring clinical outcomes, readmission rates, and operational KPIs, increasing visibility into key metrics by 68% and enhancing executive decision-making.

Enhanced claims data integrity by aligning and validating EDI 837 and 835 transaction sets, improving claims adjudication accuracy by 25% and reducing claim denial rates by 30%.

Extracted, cleaned, and transformed multi-source healthcare data from Electronic Medical Records (EMR), HL7 messages, and EDI transactions, streamlining data pipelines and reducing ETL processing time by 35%.

Authored complex SQL scripts utilizing CTEs, window functions, and multi-level joins for granular ad-hoc reporting and performance trend analysis on patient outcomes and claims efficiency.

Developed robust ELT pipelines using SSIS and Snowflake to centralize clinical, claims, and operational data, enabling seamless data warehousing and downstream analytics.

Built dynamic Looker Studio dashboards integrated with BigQuery datasets to visualize trends in-patient admissions, chronic disease prevalence, and care costs, enabling real-time insights for population health management and reducing manual reporting efforts by 50%.

Leveraged Azure Data Factory to orchestrate and automate ingestion of large-scale EMR and claims data from on- premises and cloud sources, improving data refresh cycles by 40% and supporting timely healthcare analytics delivery.

Integrated FHIR APIs with EHR systems and mapped EDI 837 data formats to support real-time claims adjudication, eligibility verification, and automated benefit checks.

Maintained full compliance with HIPAA, CMS regulations, and internal PHI governance standards, ensuring secure handling of sensitive healthcare data across systems and reports.

Collaborated with clinical SMEs, data engineers, and product owners in Agile Scrum ceremonies, utilizing Jira and Confluence to manage sprints, track user stories, and maintain documentation.

Participated in Joint Application Development (JAD) sessions and enterprise Data Governance Committees, presenting analytics-driven insights and actionable recommendations to C-suite leadership and clinical directors. BitInfoCom Technologies – India September 2018 – November 2022 Data Analyst

Executed complex data extraction and transformation processes using SQL across Oracle SQL, MySQL, and PostgreSQL, resulting in a 30% increase in data retrieval efficiency tailored for banking operations.

Developed dynamic Excel dashboards incorporating Pivot Tables and VLOOKUP functions, facilitating real-time financial reporting and decision-making for stakeholders in compliance with Indian financial regulations.

Designed and implemented robust A/B testing frameworks to assess marketing campaign performance, achieving a 15% increase in conversion rates through data-driven insights specific to the Indian banking sector.

Leveraged AWS services (S3, RDS, Redshift) for efficient cloud-based data storage and processing, achieving a 40% reduction in data access time, thereby enhancing operational efficiency in financial data management.

Created and maintained comprehensive ETL workflows using SQL Server Integration Services (SSIS), ensuring seamless integration of data from diverse banking sources, thereby improving data accuracy and availability.

Developed and implemented advanced fraud detection algorithms that successfully identified suspicious transactions with a 95% accuracy rate, significantly mitigating financial risks for the organization.

Automated routine financial reporting processes through the use of Excel VBA and Python scripts, resulting in a time savings of approximately 15 hours per week, allowing for more strategic analysis and insights.

Effectively managed project timelines and deliverables using JIRA, ensuring adherence to project schedules and successful completion of data analysis initiatives within the banking sector.

Designed and developed comprehensive financial KPIs and metrics dashboards using Power BI, enhancing visibility into key performance indicators critical for strategic decision-making in the Indian banking landscape.

Collaborated closely with IT teams to implement data encryption protocols and ensure compliance with GDPR and Reserve Bank of India (RBI) regulations, safeguarding sensitive financial data and maintaining regulatory standards. EDUCATION:

Master's in Science in Information Science - Indiana University, IN, USA Bachelor of Electronics & Communication Engineering - Andhra University, Andhra Pradesh, India CERTIFICATIONS:

Business intelligence and data analytics: Generate insights - Macquarie University Certified Google Cloud Data Analytics – Google

Certified AWS Fundamentals – Coursera

Certified Google Business Intelligence – Google

Contact this candidate