Data Analyst / Engineer with 6 Years Experience

PRASANNA B

Data Analyst / Engineer

+1-845-***-**** *************@*****.*** https://www.linkedin.com/in/prasanna-b-a4579a388/ Pennsylvania, PA

SUMMARY

Analytical and detail-oriented Data Analyst with 6 years of experience leveraging Python, SQL, and data visualization tools to design, automate, and optimize data solutions. Skilled in data modeling, ETL, data governance, and BI dashboarding using Power BI, Tableau, and Snowflake. Adept at transforming raw data into actionable insights that drive smarter business decisions. Passionate about data innovation and building self-service solutions that empower teams to make data-driven decisions.

KEY ACHIEVEMENTS

Supply Chain & Inventory Analytics

Designed and implemented SQL-based ETL pipelines and interactive Power BI dashboards to monitor business performance and ensure compliance reporting accuracy.

SQL & Python at Scale

Built optimized SQL queries and Databricks Spark ETL scripts to process multi-terabyte datasets, improving reporting accuracy and cutting execution time by 40%. Business Insights

Developed interactive dashboards for claims analytics and operational performance, reducing decision-making time by 40% using Tableau and QuickSight.

Data Warehousing Excellence

Migrated 20+ enterprise pipelines to Snowflake/Redshift, reducing query latency by 40% and lowering storage costs by 30%.

EXPERIENCE :

Elevance Health – Data Analyst

VA, USA Aug 2024 – Present

•Collaborated with clinical and analytics teams to translate healthcare and behavioral data into meaningful insights for research and performance evaluation.

•Designed and built ETL workflows in Azure Data Factory and Databricks to process patient outcomes, provider data, and operational metrics.

•Wrote complex SQL queries and stored procedures to aggregate and clean data from multiple systems including Salesforce and Azure SQL.

•Created and maintained Power BI dashboards for research, outcomes tracking, and leadership reporting.

•Partnered with researchers to define data requirements for new studies and surveys, ensuring alignment with IRB and HIPAA standards.

•Integrated real-time data feeds from clinical applications to support reporting on treatment outcomes and patient engagement.

•Automated routine data validation and reconciliation tasks using Python scripts, improving data accuracy and reducing manual review time.

•Designed ROI analysis reports to evaluate conference, education, and training program performance using event and participation data.

•Documented data dictionaries, lineage, and transformations for audit and reproducibility.

•Provided technical support for data integration, research queries, and outcomes analysis, often translating technical results into easy-to-understand summaries for non-technical stakeholders.

Tata Consultancy Services (TCS) – Data Analyst / Engineer

India Jun 2021 – May 2023

•Supported data analysis and reporting for healthcare clients, focusing on outcomes research and operational efficiency.

•Built and maintained ETL pipelines using SSIS, Python, and Azure Data Factory to consolidate data from claims, billing, and survey systems.

•Developed data models and stored procedures in PostgreSQL and SQL Server to support dashboards and regulatory reporting.

•Created interactive Power BI reports to visualize training participation, event feedback, and program outcomes.

•Partnered with business and clinical stakeholders to design metrics that measure performance improvement initiatives.

•Conducted data validation and QA to ensure reports were accurate before publication.

•Worked closely with the governance team to standardize data collection, improve naming conventions, and enhance overall data quality.

•Implemented data cleansing scripts in Python to fix inconsistencies and improve reliability of research datasets.

•Documented ETL flows and contributed to internal best-practice guides for new data analysts joining the team.

•Collaborated in Agile sprints to deliver enhancements, bug fixes, and new reports on time.

Accenture – Associate Data Engineer

India May 2020 – May 2021

•Assisted in the development of ETL processes that integrated data from multiple clinical and financial systems into centralized reporting platforms.

•Built SQL and Python scripts for daily and weekly data loads, including error handling and exception logging.

•Worked with Azure SQL and Snowflake environments to migrate and optimize reporting datasets.

•Supported data quality initiatives, developing validation reports to compare source and target records.

•Collaborated with data architects to refine schema designs and indexing strategies to improve query performance.

•Designed and published Power BI dashboards that provided insights into key operational KPIs and compliance tracking.

•Participated in cross-team meetings with analysts, QA, and developers to troubleshoot data discrepancies and plan process improvements.

•Maintained documentation for ETL jobs and data dictionaries, ensuring traceability for all reporting datasets.

•Automated recurring reporting tasks using Python scripts, saving hours of manual effort each week.

•Helped streamline data delivery timelines by optimizing load schedules and improving SQL query efficiency.

PROJECT

Clinical Training Insights Platform

•Built Power BI dashboards tracking participation, course completions, and training ROI across clinical programs.

•Integrated Salesforce data with SQL-based models to enhance reporting accuracy for leadership reviews.

Healthcare Outcomes Research Analytics

•Designed and maintained Azure-based data pipelines for outcomes and patient satisfaction studies.

•Delivered dashboards tracking key metrics—response times, program efficiency, and clinical improvements.

•

EDUCATION

Master's in COMPUTER SCIENCE

Rivier University 12/2024

Bachelor's in Computer Science and Engineering

Jawaharlal Nehru Technological University 04/2021

SKILLS

Languages: Python, SQL, R, PowerShell, JavaScript, PySpark

Data Tools: Azure Data Factory, Databricks, SSIS, Airflow, Spark, ETL/ELT.

Databases: Azure SQL, SQL Server, PostgreSQL, Snowflake, Redshift, BigQuery

Visualization: Power BI, Tableau

CRM Tools: Salesforce, Dynamics 365

Cloud & DevOps: Azure, AWS (S3, Lambda, EC2), GCP, CI/CD (Azure DevOps, Jenkins)

Concepts: Data Modeling, Data Governance, Data Quality, ROI Analysis, Statistical Analysis, Behavioral Research Analytics

Contact this candidate