Data Engineer Power Bi

Susmitha Basavapatruni

Email ID: ***********@*****.***

Phone: 929-456- 3071

SUMMARY

Data Engineer with 3+ years’ experience in designing, developing, and optimizing data pipelines, ETL workflows, and BI solutions in cloud and on-premises environments. Skilled in SQL Server, SSIS, SSRS, Azure Data Factory, Power BI, and Python. Experienced in building scalable data integration solutions, implementing data quality checks, and delivering interactive dashboards. Adept at collaborating with cross-functional teams to meet business goals in healthcare and retail domains.

TECHNICAL SKILLS

Cloud & Data Platforms

Azure Data Factory, Azure SQL DB, Azure Synapse, Azure Backup/

Recovery, Snowflake (familiar), AWS (basic)

ETL & Data Integration

SSIS, DTS Migration, Python (pandas, Django ORM), Hive, REST API

Integration

BI & Visualization

Power BI (DAX, gateways, automation), Tableau (parameters,

Drilldowns, dashboards), SSRS

Databases

MS SQL Server (2012/2008), T-SQL, PL/SQL, Stored Procedures,

Triggers, Indexing, Query Optimization

Data Modeling

Star & Snowflake Schema, Schema, OLAP Cubes (SSAS), Fact &

Dimension Tables

Tools

Git, Azure Devops, SQL Profiler, Redgate, Erwin Data Modeler

PROFFESIONAL EXPERIENCE

CVS Health – Woonsocket, RI

Data Engineer / SQL Developer March 2024 - Present

Designed and automated end-to-end ETL pipelines in Azure Data Factory, integrating data from multiple upstream systems into enterprise data warehouse.

Developed and optimized SSIS packages for high-volume data transfers, reducing ETL runtime by 30%.

Created Power BI datasets and dashboards with scheduled refresh, enabling near real-time KPI reporting.

Built SSRS reports (drill-down, parameterized) for operational and executive reporting.

Developed backend logic using T-SQL & Stored Procedures to support analytics and reporting solutions.

Enhanced SQL Server performance using index tuning & execution plan optimization, improving query performance by 40%.

Designed and deployed ETL workflows using SSIS for OLTP to OLAP data movement.

Built advanced Tableau dashboards and Power BI reports with multiple data sources.

Wipro – Hyderabad, India

Data Engineer Aug 2020 – Dec 2022

Migrated on-prem data systems to Azure Cloud using Azure Site Recovery & Azure Backup.

Built Python-based data pipelines and Hive scripts to ingest large datasets into the data lake.

Maintained & enhanced Power BI dashboards for operational monitoring and KPI tracking.

Created reusable SSIS templates for dynamic deployment across environments, cutting development time by 25%.

Developed cross-validation rules and error-handling in SSIS for higher data accuracy.

Designed and scheduled SSRS reports for ad-hoc and executive-level analytics.

Created stored procedures, triggers, and functions to support data transformation logic.

Managed Azure SQL Database, security, and backup/restore processes.

EDUCATION

Masters in Information System 2024 - Pace university, One pace plaza, New York

CERTIFICATIONS

Microsoft Certified: Azure Data Engineer Associate (DP-203) (In Progress)

Microsoft Certified: Power BI Data Analyst Associate (PL-300) (In Progress)

Snowflake SnowPro Core Certification (Planned)

Contact this candidate