Azure Data Power Bi

Swapnali Digambar Babar

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

Phone: +91-823*******

LinkedIn: https://www.linkedin.com/in/swapnali-babar-23941b187 PROFILE SUMMARY

Detail-oriented Data Engineer and Analyst with 4.9 years of experience in Azure Data Factory, Data Lake, Databricks, SQL and Power BI. Skilled in building ETL pipelines using the Medallion Architecture (Raw-Silver-Gold) and creating insightful Power BI dashboards to enable data-driven decisions and improve project reporting efficiency. EDUCATION

SVERI’s College of Engineering, Pandharpur 2012 – 2016 Bachelor of Engineering in Computer Science 72%

EXPERIENCE

Freelance Jul-2024 to Sep-2025

Azure Consultant

Project Title:

End-to-End Data Ingestion Pipeline using Azure Data Factory and Medallion Architecture Responsibilities:

Designed and built ADF pipelines to ingest SAP source data (Excel files) into Azure Data Lake Storage (ADLS) following the Medallion Architecture (Raw Silver Gold).

Built Azure Data Factory (ADF) pipelines to ingest data from SAP tables (extracted as CSVs with primary keys) into Raw Layer of Azure Data Lake Storage (ADLS).

Configured schedule triggers to load incremental data (last 7 days) every alternate day, ensuring optimized performance and cost efficiency.

Created SQL staging tables (Intermediate Layer) from landing data for data validation, cleansing, and incremental logic.

Performed full and incremental load strategies; validated data quality and lineage across layers.

Integrated Databricks with SQL Database for end-to-end ETL and analytical readiness.

Ensured data availability, scalability, and reliability across all layers of the Medallion architecture. Asentech LLC Jun-2019 to Mar-2024

Associate Data Analyst

Project Title:

1. Content Analysis for Daily Milwaukee Reporter

Responsibilities:

Reviewed and analyzed project advertisements from the Daily Reporter to identify and classify construction and non-construction projects, extracting key details such as scope, budget, timelines, and stakeholders.

Collected and verified project data by visiting source links and downloading relevant documents to ensure information accuracy and completeness.

Entered and maintained structured project information in the client’s online portal, adhering to defined workflows and data field requirements.

Published validated project details to the client’s bid magazine, providing subscribers with accurate and actionable data to support bidding opportunities.

Used JIRA to track content-related tasks, monitor progress, and manage approvals and issue resolution, ensuring smooth coordination across teams.

2. Viatris Global Sales & Market Performance Dashboard Responsibilities:

Collaborated with business stakeholders to define KPIs such as sales revenue, prescription volume, and regional growth trends.

Extracted and transformed data from SQL Server, Excel, and SAP using Power Query.

Designed a star schema with Sales and Inventory fact tables linked to Product, Region, and Customer dimension tables.

Built interactive visuals for sales performance, market share, and product analysis with filters by region, brand, and month.

Improved performance using incremental refresh, aggregation tables, and optimized DAX calculations for faster load times.

Implemented Row-Level Security (RLS) for region-based access and published reports to Power BI Service for automated refresh and alerts.

Presented actionable insights highlighting top growth regions, underperforming markets, and forecast trends to business leadership. SKILLS

Technical Skills: Power BI, SQL, Azure Data Factory, Azure Data Lake Storage (Gen2), Azure SQL Database, Azure Databricks, Medallion Architecture, Incremental Load, Scheduling & Triggers, JIRA.

Soft Skills: Active listening and requirement gathering, Attention to detail and accuracy, Research and analysis, Teamwork and adaptability, Quick learner, Task prioritization and multitasking, Flexibility and openness to feedback.

Contact this candidate