Summary
Overview
Work History
Education
Skills
Websites
Certification
Timeline
Generic
Rakesh K Devagalla

Rakesh K Devagalla

DATA ANALYST
Baltimore,MD

Summary

Experienced Senior Data Analyst with 4+ years of experience in healthcare and finance. Specializes in OLAP-based reporting, ETL processes, and Business Intelligence (BI) for data-driven decision-making. Proficient in SQL, Python, PHP, Java, and HTML. Hands-on experience in database management, marketing automation, and web-based data visualization. Optimized ETL pipelines and automated marketing analytics at Molina Healthcare, ensuring regulatory compliance and reducing reporting turnaround by 30%. Implemented OLAP-based financial analysis and developed database-driven dashboards at I Sparrow, enhancing accessibility for stakeholders. Proficient in Power BI, Tableau, Snowflake, AWS, and Databricks. Expertise in data cleansing, transformation, and automation. Passionate about building scalable solutions to optimize operations and improve business intelligence insights.

Overview

5
5
years of professional experience
6
6
years of post-secondary education
2
2
Certifications

Work History

Data Analyst

Molina Healthcare
07.2023 - Current
  • Implemented Azure Databricks workflows and Alteryx processes to analyze over 250,000 healthcare claims weekly, reducing reporting turnaround time by 30%
  • Deployed probabilistic models and Bayesian networks for predictive analytics on EHRs, achieving a 25% improvement in medication adherence insights while ensuring compliance with HIPAA standards
  • Applied FHIR standards to streamline EHR data exchange, enhancing data interoperability by 30% and reducing processing times for downstream analytics by 20%
  • Utilized Spark SQL and T-SQL within Azure Databricks Notebooks to transform datasets of approximately 200 GB, ensuring accurate medication adherence reports for 500,000+ members
  • Automated ETL pipelines in Databricks Jobs and Alteryx workflows to integrate Medispan drug databases, reducing manual errors and bi-weekly update time by 30%
  • Designed interactive Power BI dashboards hosted on Power BI Report Server, enabling 20+ stakeholders to access real-time insights, reducing report generation time by 40%
  • Developed and optimized ETL pipelines for structured (SQL) and unstructured (JSON, XML) data, enhancing Business Intelligence reporting efficiency.
  • Developed OLAP cubes for multi-dimensional analysis, improving reporting efficiency by 30%.
  • Automated marketing analytics processes, ensuring accurate and timely insights for 500,000+ members.
  • Teamed up with data engineers to design and implement Snowflake data models, improving data accessibility and reducing query latency by 20%

Data Analyst

I Sparrow
11.2019 - 08.2022
  • Collaborated with stakeholders across Finance, Credit Risk, and Treasury to deliver projects that improved operational efficiency, resulting in a 20% reduction in manual reporting time
  • Developed Tableau, Looker, and Adobe Analytics dashboards to support internal and external reporting, increasing data accessibility for 30+ business users and enhancing decision-making speed by 35%
  • Leveraged SQL, PySpark, and Python for complex data analysis and automation, reducing regulatory reporting errors by 15% and increasing processing speed by 25%
  • Took advantage of AWS for scalable financial and risk data storage, enabling seamless processing of over 500 GB of data monthly
  • Implemented OLAP-based reporting to enhance financial trend analysis.
  • Built marketing automation scripts in Python, SQL, and PHP to optimize campaign performance.
  • Designed a database-driven web dashboard (HTML, Java, SQL) to centralize reporting for stakeholders.
  • Migrated 10+ datasets from SQL Server to Snowflake, improving query performance by 40% and ensuring compliance with governance policies
  • Conducted segmentation analysis using SQL and Python, identifying customer behavior trends that boosted retention rates by 13%
  • Automated ETL workflows using Alteryx and dbt, cutting reporting times by 40% and ensuring consistency across 50+ KPIs
  • Engineered machine learning models with Scikit-Learn for targeted marketing campaigns, improving campaign ROI by 15%
  • Built Tableau, Looker, and Adobe Analytics dashboards for sales and marketing metrics, providing real-time insights for 25+ stakeholders and driving a 10% improvement in resource allocation efficiency

Education

Master of Science - Information System

University of Maryland, Baltimore County
Baltimore County, Maryland
08.2022 - 05.2024

Bachelor of Technology - Electronics and Communication Engineering

Vignan's Foundation For Science, Technology & Research
India
06.2017 - 06.2021

Skills

Power BI, Tableau, Looker, Adobe Analytics, Advanced Excel (Pivot Tables, VLOOKUP), Azure Databricks, Databricks Jobs, Alteryx, dbt, AWS, Snowflake, SQL, Python, PySpark, T-SQL, PL/SQL, PostgreSQL, AWS (certified), Azure Cloud, Snowflake, Scikit-Learn, Regression Analysis, A/B Testing, Classification, Clustering, SQL Server, MySQL, PostgreSQL, Oracle, Spark SQL, T-SQL, SSIS, SSRS, Power BI Report Server, Jira, Confluence, Git, Bitbucket, JSON, XML, OLAP, ETL, Business Intelligence, Marketing Automation, Java, PHP, HTML, CSS, Microsoft SQL Server, Talend Open Studio, XMPie, Stored Procedures, Data Normalization, Data Types, Relations, Keys, Constraints, DQL, DML, DDL, Control Flow Statements, Class Objects, Methods, File Types, File Encodings, Delimiters, Line Breaks, Escape Characters, Special Unicode Characters.

Certification

AWS Certified Data Engineer - Associate, 2024

Timeline

Data Analyst

Molina Healthcare
07.2023 - Current

Master of Science - Information System

University of Maryland, Baltimore County
08.2022 - 05.2024

Data Analyst

I Sparrow
11.2019 - 08.2022

Bachelor of Technology - Electronics and Communication Engineering

Vignan's Foundation For Science, Technology & Research
06.2017 - 06.2021

Similar Profiles

CREATE PROFILE
Rakesh K DevagallaDATA ANALYST