Rajeshwari Burgul
Data Analytics Engineer
Alpharetta,GA
Summary
Results-driven Data Analyst & Data Engineer with 6+ years of experience delivering data-driven solutions across diverse industries. Expert in data visualization, ETL development, and cloud-based data processing, with proficiency in Tableau, Power BI, SQL, Python, and SSIS. Strong background in data modeling, transformation, and automation, with expertise in designing scalable data pipelines, optimizing SQL queries, and ensuring data integrity across enterprise systems. Experienced in report development, real-time analytics solutions, data warehousing, and designing scalable data pipelines to enhance business intelligence and data-driven decision-making. Adept at collaborating with cross-functional teams to deliver insightful, high-impact reporting and analytics that drive strategic decision-making and operational efficiency.
Overview
7
7
years of professional experience
2
2
years of post-secondary education
Work History
Data Analytics Engineer
Virginia Department of Health
04.2021 - 04.2025
- Design and develop dynamic Tableau dashboards using LOD expressions, R/Python integration, and advanced table calculations to support business processes, healthcare metrics, and emergency response monitoring.
- Leverage R and Python to create custom visualizations, statistical models, and machine learning-driven insights, enhancing data storytelling and decision-making.
- Develop, optimize, and maintain scalable ETL pipelines for seamless data ingestion, transformation, and integration from multiple sources using Python, SQL, and automation tools, while leveraging Hadoop, Spark, and distributed processing frameworks to efficiently handle large datasets.
- Develop SQL-based ETL scripts for high-performance data extraction, transformation, and loading (ETL) into data warehouses like BigQuery while implementing cloud-based data processing and pipeline automation using GCP and Azure.
- Maintain comprehensive documentation of systems, analytics solutions, and workflows, translating complex technical processes into business-friendly insights for diverse stakeholders.
Data Analyst and Visualization Specialist
American Red Cross
02.2020 - 12.2020
- Developed complex Power BI data models using DAX expressions and Power Query to perform advanced calculations, data transformations, and optimize performance for large datasets, ensuring efficient reporting and analysis.
- Developed and optimized ETL pipelines using Python and SQL to automate data extraction, transformation, and loading into Power BI, ensuring seamless integration with source systems and enhancing the overall efficiency of data workflows.
- Developed and optimized complex SQL queries using MS SQL Server, including views, stored procedures, and subqueries, to extract and aggregate data for high-performance Power BI dashboards.
- Conducted root cause analysis of data anomalies and improved data quality and integrity by implementing robust ETL validation frameworks, metadata consistency checks, and data governance standards to ensure accuracy and compliance.
Business Intelligence Developer
Chartered Financial Analyst Institute
04.2019 - 02.2020
- Designed and developed interactive Power BI dashboards with dynamic filters, drill-through options, and slicers, enabling enhanced user-driven data exploration and improved analytical capabilities.
- Led a data migration project by developing SSIS packages and writing advanced SQL scripts to migrate data from SQL Server to the Azure cloud. Utilized Power BI to create pre- and post-migration reports, ensuring data accuracy and identifying discrepancies through interactive visualizations to support data validation and ensure seamless migration.
- Developed and optimized complex SQL scripts for ETL workflows using SSIS in MS Visual Studio, leveraging SSIS components such as Lookup, Merge, Derived Column, and Conditional Split for data extraction, transformation, including data type conversions, cleansing, enrichment, and structured data loading into SQL Server.
Business Intelligence Developer
Crystal Flash
04.2018 - 03.2019
- Collaborated with migration teams to design, develop, and implement comprehensive data migration strategies, ensuring seamless transition of data across systems. Conducted in-depth analysis to define the migration scope, including data mapping, transformation, validation, and reconciliation to maintain data accuracy and integrity.
- Configured secure and optimized data integration between Dynamics CRM and SQL Server, developing scheduled SSIS packages to enable incremental data extraction, transformation, and loading (ETL).
- Designed robust data pipelines to efficiently process customer data, ensuring data consistency, integrity, and accuracy while automating workflows for seamless synchronization between Dynamics CRM and SQL Server.
Education
Master of Science - Information Technology
Wilmington University
New Castle, DE 01.2016 - 12.2017
Skills
Tableau, Power BI , Excel Visualization Tools
Python and R Programming Launguages
SQL, Hadoop, Apache Spark
SSIS, Alteryx, Informatica, Power Query ETL tools
AWS, GCP, Azure Cloud Platforms
Timeline
Data Analytics Engineer
Virginia Department of Health
04.2021 - 04.2025
Data Analyst and Visualization Specialist
American Red Cross
02.2020 - 12.2020
Business Intelligence Developer
Chartered Financial Analyst Institute
04.2019 - 02.2020
Business Intelligence Developer
Crystal Flash
04.2018 - 03.2019
Master of Science - Information Technology
Wilmington University
01.2016 - 12.2017
Similar Profiles
LEAH CULLOPLEAH CULLOP
Infection Prevention Mentee at Virginia Department of HealthInfection Prevention Mentee at Virginia Department of Health
RENEE GOULDRENEE GOULD
Covid Case Investigator/Program Admin Specialist 2 at Virginia Department Of HealthCovid Case Investigator/Program Admin Specialist 2 at Virginia Department Of Health
Krystal CopelandKrystal Copeland
Deputy Director of General Accounting at Virginia Department of HealthDeputy Director of General Accounting at Virginia Department of Health