Data Engineer Power Bi

Aakash Alugala Data Engineer

MI, USA +1-248-***-**** ***************@*****.*** LinkedIn

SUMMARY

Data Engineer with 4+ years of experience extracting, interpreting, and visualizing complex datasets to drive strategic decision-making. Proficient in SQL, Python, Tableau, Power BI, and advanced Excel, with a strong background in predictive modeling, A/B testing, and statistical analysis. Proven ability to identify trends, uncover business opportunities, and optimize workflows, leading to measurable efficiency gains and revenue growth. Expertise in EHR/EMR analytics, population health management. Deep understanding of HIPAA, FHIR, and CMS reporting, ensuring regulatory co mpliance while optimizing data- driven decision-making. Skilled in cost reduction analysis, and value-based care performance tracking to improve operational efficiency. Adept at collaborating with clinicians, administrators, and executives to drive strategic initiatives through advanced analytics and data storytelling SKILLS

Languages: Python, C, C++, Java, Scala.

Databases: SQL, PostgreSQL, MySQL, Oracle, DB2, MongoDB, Cassandra, Snowflake, Redshift, Teradata. Data Engineering: Apache Airflow, PySpark, Databricks, AWS (S3, EC2, MWAA, Cloud Watch), Google Cloud (Big Query, Data Fusion), ETL Pipelines, Informatica, Talend, Alteryx, dbt.

Data Analysis Tools: Excel, Tableau Desktop, Tableau Server, Power BI, Looker, SAS, R, Python (Pandas, NumPy, Matplotlib, Seaborn) Microsoft Fabric Big Data Frameworks: Apache Spark, Hadoop, Kafka, Databricks. Cloud Platforms: AWS (S3, Redshift, Glue), Azure (Data Factory, Synapse), Google Cloud Platform (Big Query, Dataflow). BI Tools & Version Control: Tableau Desktop, Tableau Server, SSRS, Git, GitHub, GitLab. Scripting: Shell, PowerShell Collaboration.

Tools: Trello, Slack, Jira, Confluence Operating Systems: Linux, Windows, OSX. PROFESSIONAL EXPERIENCE

Data Engineer AIG MI, USA Oct 2024 –Present

• Built PySpark + Databricks ETL pipelines to consolidate 2.4 TB+ of daily claims and policy data from 9+ legacy systems into Snowflake, enabling timely actuarial reporting and reserve calculations.

• Automated ingestion of claims settlement and premium data from AWS S3 and external partners via Airflow DAGs, reducing manual file handling and saving

~18 hours per week for operations teams.

• Developed SQL-based validation scripts that flagged mismatched policy–claim records, improving reconciliation accuracy to 99.7%, directly reducing financial restatement risk.

• Optimized Informatica and Talend ETL jobs for underwriting risk models, cutting processing time by 35%, which allowed risk analysts to refresh exposure models twice daily instead of once.

• Partnered with actuarial teams to design Power BI dashboards that tracked claims loss ratios and reserve adequacy, leading to a 12% faster identification of adverse claim patterns.

• Integrated Kafka real-time streams for fraud detection, feeding suspicious claim events into investigative models with sub-second latency, which improved fraud case referrals by 14%.

• Enforced role-based access policies in AWS IAM and Azure Synapse to secure Personally Identifiable Information (PII) within claims and policy datasets, achieving zero audit findings during SOX and HIPAA reviews. Data Support Engineer Genius Soft Tech India Dec 2021–Jul 2023

• Resolved 3,200+ support requests involving SQL, Python, and Power BI, achieving 95% SLA compliance while restoring critical data pipelines and correcting user-facing reporting inconsistencies.

• Developed automated file validation scripts using Shell scripting and Pandas, improving client data onboarding accuracy from 74% to 93% by detecting schema mismatches and null-field errors.

• Monitored Apache Spark workflows deployed on Azure Data Factory, leveraging Azure Monitor and Log Analytics for error tracing, reducing average incident recovery time from 40 minutes to <12 minutes.

• Refactored dbt models and updated PostgreSQL schemas to align with evolving business logic, reducing monthly data inconsistency tickets by 28% across finance department reports.

• Documented release schedules and data fixes using Jira and Confluence, improving cross-team communication and ensuring clear traceability for audit teams during deployments and regression cycles.

• Scheduled and maintained Power BI datasets, resolved DAX expression issues, and ensured consistent refresh accuracy for 45+ enterprise-level dashboards utilized by client-side stakeholders.

Data Analyst Fusion Software Technologies India Jan 2020 – Nov 2021

• Delivered end-to-end data pipeline support, resolving 3,200+ SQL, Python, and Power BI requests, achieving 95% SLA compliance and ensuring high data availability.

• Automated data onboarding with Shell scripting and Python (Pandas), improving client data quality from 74% to 93% by implementing schema validation and null-check detection.

• Created and scheduled ETL pipelines using Talend, Alteryx, and PostgreSQL, processing 500K+ daily records from ERP and CRM systems with consistent data accuracy.

• Administered and monitored Apache Spark workflows in Azure Data Factory, leveraging Azure Monitor and Log Analytics for error tracing, reducing average recovery time by 70%.

• Built interactive Power BI dashboards for supply chain teams, optimizing backend queries and cutting report refresh time from 18 minutes to 3 minutes per session.

• Refactored dbt models and redesigned PostgreSQL schemas to align with evolving business logic, reducing monthly finance data inconsistencies by 28%.

EDUCATION

University of Detroit Mercy–Detroit, MI

Master of Science in Computer and Information Sciences GPA:3.7/4.0 May 2025 Jawaharlal Nehru Technological University –Hyderabad, India Bachelor of Technology in Electronics and Communication Engineering GPA:3.0/4.0 Sep 2022 CERTIFICATIONS

• Databricks Data Engineer Associate–Databricks,2025

• Databricks Fundamentals–Databricks,2025

• Python Essentials–CiscoNetworkingAcademy,2025

• Data Analytics Essentials–CiscoNetworkingAcademy,2024

• AI fundamentals–IBM,2024

• Power BI Job Simulation–PwCSwitzerlandviaForage,2024

Contact this candidate