Power Bi Sql Server

Snehal Patil

+91-982******* ️ ****************@*****.*** Pune, Maharashtra, India

Summary

Power BI and MS SQL Server Developer with 3+ years of experience in building end-to-end BI solutions and data-driven dashboards.

Strong expertise in Power BI for developing interactive, visually compelling reports using DAX, Power Query, and advanced visualization techniques.

Experienced in designing data models, building star/snowflake schemas, and implementing row-level security in Power BI.

Skilled in MS SQL Server for writing complex T-SQL queries, stored procedures, views, and performance tuning.

Proficient in developing automated ETL pipelines using SQL Server Integration Services (SSIS) and Azure Data Factory.

Knowledge of SSAS and SSRS for tabular data modeling and paginated reporting

Collaborated with cross-functional teams in Agile/Scrum environments to deliver insights aligned with business goals

Successfully delivered BI solutions across banking, healthcare, and electronics domains for clients in Singapore and India.

Skills

BI & Visualization: Power BI, QlikView, SSRS

Data Engineering: SQL Server 2012/2016/2019, Azure Data Factory (ADF), SSAS, SSIS

Programming & Tools: Java, Amazon Alexa Skills, Oracle, T-SQL, Power BI Desktop

Process & Practices: Agile, SDLC, UAT, TFS

Experience

Keyrus, Singapore – Solution Consultant (Mar 2021 – Dec 2021)

Client: Credit Agricole Investment Bank Domain: Banking Tools: Power BI, SQL Server, SSRS, SSAS

Project Description

Developed a comprehensive HR Employee Data Analytics solution encompassing global employee information across multiple regions. Integrated data from various sources into a centralized staging area and data warehouse to ensure data consistency and accuracy. Designed and implemented a SSAS tabular model to enable self-service BI for end-users, facilitating efficient data exploration and reporting. Created a suite of detailed Power BI dashboards and SSRS reports to provide HR and management teams with actionable insights into employee metrics, workforce composition, and portfolio analysis. The solution improved decision-making by enabling dynamic reporting and real-time data visualization.

Responsibilities

Designed SSAS tabular models for self-service BI with DAX measures.

Delivered 15+ interactive Power BI dashboards and SSRS reports used by 100+ HR and management stakeholders globally.

Worked on complex SQL queries, stored procedures, views and SSIS packages.

Conducted demos and user training sessions on report usage.

Advintek Pte Ltd, Singapore – Solution Consultant (Dec 2020 – Feb 2021)

Client: Advintek BI Solutions Domain: Healthcare Tools: Power BI, SQL Server

Project Description

This company specializes in delivering Business Intelligence solutions to clients. As part of this project, we developed a comprehensive Location Intelligence tool that analyzes geographical data from multiple perspectives to support strategic decision-making. Leveraging MapInfo Pro, the tool provides advanced spatial analytics and visualization capabilities, enabling users to gain deep insights into location-based trends and optimize their operations effectively. Developed interactive Power BI dashboards.

Responsibilities

Developed analytical dashboards using Power BI for location intelligence.

Supported UAT and PROD testing cycles.

Demonstrated solutions to business users and stakeholders.

Sky & F Pte Ltd., Singapore – BI Developer (Apr 2020 – Jul 2020)

Client: Panasonic Domain: Electronics Tools: Power BI, SQL Server, Azure Data Factory

Project Description

Developed multiple Power BI dashboards for Panasonic, focusing on financial and operational reporting across different business regions and product lines. Implemented row-level security to ensure data privacy and role-based access. Designed key financial and operational KPIs to enable effective decision-making. Managed data migration and integration using Azure Data Factory for streamlined data processing.

Responsibilities

Built region-specific financial and operational dashboards in Power BI.

Implemented Row-Level Security and KPIs for executive decision-making.

Developed and optimized complex T-SQL queries, stored procedures, and functions for efficient data extraction and transformation.

Automated data migration using ADF pipelines.

Zensar Technologies, India – BI Developer (Feb 2018 – Jun 2019)

Client: Candela Medical Domain: Healthcare Tools: Power BI, QlikView, SQL Server and ADF

Project Description

At Syneron - Candela, a leading company in cosmetic and skin-related treatments, we developed comprehensive Revenue and Budget reports using Power BI to support data-driven decision-making across various business regions and product lines. The project involved creating financial and operational dashboards, incorporating both financial and operational KPIs to highlight key performance indicators critical for strategic planning. We also implemented Row-Level Security (RLS) to ensure secure, role-based data access within Power BI. Additionally, we successfully migrated legacy QlikView reports to Power BI, enhancing report interactivity, usability, and performance.

Responsibilities

Worked on the Power BI reports and Power BI services.

Developed automated dashboards and scheduled dataset refreshes.

Worked on migration of QlikView reports to Power BI reports.

Created and modified stored procedures, functions and SQL queries for data migrations.

Created Pipelines in Azure Data Factory for data migrations from source to destinations.

Actively contributed to SIT, UAT and production deployments.

Education

B.E. in Computer Engineering – Dr. D. Y. Patil College, Pune University – 2017 76.6% (Distinction)

H.S.C. – Jawahar Navodaya Vidyalaya, Bhusawal (CBSE) – 2013 70.4%

S.S.C. – Jawahar Navodaya Vidyalaya, Bhusawal (CBSE) – 2011 82.04%

Academic Projects

Auditing and Block Level Redundancy in Cloud – Implemented secure data deduplication with encryption using Java.

Library Management System – Built a web-based portal using Java, HTML, and CSS for online library access.

Achievements

“Best Delivery Team Award” for high-quality and timely project execution.

Delivered Power BI dashboards that helped teams track performance KPIs daily.

Improved report refresh speed by optimizing data models and relationships.

Core Java Certification – SKYLARK Institute.

National Certification in Elementary and Intermediate Drawing Exams.

Key Strengths

Excellent written, verbal, and presentation skills

Quick learner and action-oriented problem solver

Strong organizational and time management abilities

Team player with a focus on results

Personal Details

Date of Birth: 29-Oct-1994

Gender: Female

Marital Status: Married

Husband's Name: Dushyant Jagatrao Patil

Languages: English, Hindi, Marathi

Nationality: Indian

Interests: Singing, dancing, painting

Contact this candidate