Skip to content

Syam Kumar Maddina

Senior Data Engineer • Hyderabad, Andhra Pradesh • m***************@gmail.com • 798****582 • linkedin.com/••••• • drivetube.ai/•••••

Professional Summary

Senior Data Engineer with 4+ years of experience delivering enterprise-scale Business Intelligence, financial reporting, and healthcare analytics solutions. Expertise in Power BI, DAX, Power Query (M), SQL, Python, Azure Data Factory, Databricks, data modeling and ETL. Proven record improving dashboard performance, automating pipelines, ensuring data governance and building semantic models to support executive decision-making.

Technical Skills

Programming Languages: Python
Databases: SQL,SQL Server,Azure SQL,Oracle,Stored Procedures,CTEs,Window Functions
Cloud and DevOps: Azure,ADLS Gen2,Azure Data Factory,Databricks
Data and Analytics: Power BI Desktop,Power BI Service,Paginated Reports,DAX,Power Query M,ETL,ELT Pipelines,Informatica,Incremental Refresh,Data Integration,Data Transformation,Dimensional Modeling,Star Schema,Snowflake Schema,Fact & Dimension Design,Semantic Modeling
Tools and Methodologies: Agile
Governance & Security: Row-Level Security,Data Governance,Data Quality,Data Validation,Data Reconciliation
Processes & Methods: UAT Support,Release Management,Performance Optimization

Work Experience

LTIMindtree
Hyderabad, India
Senior Data Engineer
Oct 2024 – Present
Worked at LTIMindtree, an IT services and consulting firm, delivering BI and analytics solutions for finance, healthcare and operations stakeholders.
Tech Stack: Power BI Desktop, Power BI Service, DAX, Power Query M, Azure Data Factory, Databricks, ADLS Gen2, SQL
  • Architected and delivered enterprise Power BI dashboards and KPI scorecards using Power BI Desktop and Service to support executive and operational reporting across finance and healthcare domains.
  • Built reusable semantic datasets and optimized models (DAX, Power Query) to reduce dashboard load times and improve interactive performance by 30%.
  • Developed advanced DAX measures, calculated columns and Power Query transformations to implement complex financial and claims calculations and role-based Row-Level Security for sensitive data.
  • Automated ETL and ELT workflows with Azure Data Factory and Databricks, reducing manual data preparation effort by 40% and improving pipeline reliability.
  • Implemented data validation, reconciliation and governance controls across analytics pipelines, increasing reporting accuracy to above 99% and accelerating issue resolution.
  • Led mentoring and knowledge-sharing for junior developers on semantic modeling, DAX optimization and SQL tuning, standardizing BI best practices and improving delivery consistency.
LTIMindtree
Hyderabad, India
Data Engineer
Aug 2021 – Oct 2024
Delivered data engineering and reporting solutions at LTIMindtree for enterprise clients across financial reporting, revenue analytics and healthcare claims.
Tech Stack: Power BI, Informatica, Databricks, SQL Server, Azure SQL, ADLS Gen2
  • Streamlined and maintained Power BI reports, paginated reports and centralized BI datasets to support cross-functional enterprise reporting and self-service BI adoption.
  • Designed dimensional data warehouse models using star and snowflake schemas, defining fact and dimension structures to enable revenue and claims analytics at scale.
  • Built scalable ETL workflows with Informatica, Databricks and SQL-based transformations, implementing incremental refresh strategies and ADLS Gen2 storage for large datasets.
  • Developed and optimized complex SQL queries, views and stored procedures (CTEs, window functions) to improve query performance and reduce report runtimes.
  • Led migration of legacy reporting applications to cloud analytics platforms, coordinating UAT, release management and deployment schedules to ensure smooth cutovers.
  • Performed data profiling, quality checks and reconciliation for healthcare and financial datasets, reducing manual reconciliation effort by 60% and improving report availability.

Projects

Reporting Enhancement Initiative
Tools Used: Power BI, Databricks, SQL, Azure Data Factory
  • Constructed executive dashboards, paginated reports and KPI scorecards to centralize strategic business reporting for finance and operations.
  • Created reusable semantic models, optimized DAX calculations and established Row-Level Security to secure and speed up reporting.
  • Managed Power BI workspaces, dataset refresh schedules, deployment pipelines and security configurations within Power BI Service to ensure reliable access.
Healthcare Data Modernization and Reporting Transformation
Tools Used: Databricks, SQL, Power BI
  • Migrated legacy reporting data into modern analytics datasets and designed dimensional models for claims and revenue analytics.
  • Implemented automated refresh and monitoring processes to improve report availability and reliability; built 15+ interactive Power BI dashboards tracking revenue, KPIs and compliance.
  • Delivered reporting solutions consumed by 500+ business users across finance and operations, reducing manual reporting effort by 60%.

Education

Bapatla Engineering College
B.Tech, Computer Science and Engineering • Andhra Pradesh, India • Aug 2017 – Aug 2021

Certifications

Databricks Lakehouse Fundamentals — Databricks
Databricks Certified Associate Data Engineer — Databricks
Azure Data Engineer Associate (DP-203) — Microsoft
Microsoft Azure Fundamentals (AZ-900) — Microsoft
Microsoft Data Fundamentals (DP-900) — Microsoft
Microsoft Power BI Course Completion Certificate — Udemy
Advanced SQL — HackerRank

Achievements

  • Recognized member of 'Best Project Team': Contributed to successful Azure-based data transfer and interactive Power BI visualizations for critical business reporting; received team recognition.

Powered by Drivetube · Create your own profile at drivetube.ai