Sql Server Power Bi
Resume:
Priyanka P
MSBI Developer
Email: *************@*****.***
PROFESSIONAL SUMMARY
Microsoft SQL Certified BI Developer with over 5+ years of experience in end-to-end development and support of SQL Server-based BI solutions, including ETL, Data Warehousing, Reporting, and Analytics. Adept in designing and optimizing complex SQL queries, SSIS packages, SSAS cubes, and SSRS reports. Proven expertise in creating scalable data solutions, supporting enterprise analytics, and enhancing data integrity and performance.
Strong command over T-SQL (DDL, DML), Stored Procedures, Triggers, Views, Functions, and Cursors.
In-depth experience with SQL Server Integration Services (SSIS), SSAS, and SQL Server Reporting Services (SSRS).
Proficient in building ETL pipelines, data migration, and integration from various sources (SQL, Oracle, Excel, CSV, FTP).
Skilled in Dimensional Data Modelling, developing OLAP cubes, and writing MDX queries for analytics.
Extensive use of Power BI for building dashboards and reports, including Power Query, DAX, and Tabular Models.
Familiar with Tableau: Desktop, Reader, Server for building dashboards and visualizations.
Hands-on experience with Control-M and TWS scheduler tools for ETL job orchestration.
Solid understanding of Data Governance, SDLC, Agile methodologies, and DevOps practices using TFS, SSMS, and Visual Studio.
TECHNICAL SKILLS
Languages: SQL, T-SQL, PL/SQL, C, C++, C#, VB 6.0, HTML, CSS, XML, MHTML
Databases: SQL Server 2018/2017/2019, Oracle 8i–11g, Toad for Oracle
ETL Tools: SSIS, DTS, BCP, Import/Export Wizard
Reporting Tools: SSRS, Crystal Reports XI/10/9, SAP BO
BI Tools: Power BI, Tableau (Desktop, Server, Reader)
Other Tools: Visual Studio, MS Offic9e, SharePoint, Performance Monitor, SQL Profiler, BIDS, OWB
Operating Systems: Windows (XP–10, Server 2008), Unix
Version Control: TFS, VSS, ClearCase
Methodologies: SDLC, Agile, Scrum, UML, Data Normalization, Logical & Physical Data Modeling
PROFESSIONAL EXPERIENCE
MSBI Developer February 2023 to now
USI Insurance Services-Valhalla, NY
Designed and delivered daily operational dashboards and business-critical reports using SSRS, SSIS, and T-SQL, highlighting job failures, data anomalies, and volumetric trends to key stakeholders.
Engineered and automated ETL workflows using SSIS to extract, transform, and load data from heterogeneous sources; scheduled packages for daily/weekly execution and exported outputs in CSV and Excel formats.
Developed and maintained parameterized, drill-down, and drill-through SSRS reports with dynamic data visualizations, enhancing end-user interaction and decision-making.
Architected Tabular Data Models and implemented DAX calculations to support Power BI and SSRS reporting needs; created and deployed SSAS Tabular and Multidimensional cubes for analytical reporting.
Built and optimized Power BI dashboards with live connections to SSAS Tabular models, enabling real-time insights and performance metrics for business units.
Designed and implemented scalable ETL pipelines using Azure Data Factory (ADF) to orchestrate and automate data workflows across Azure Blob Storage, Azure SQL Database, and Azure Synapse, improving data processing efficiency by 40%.
Deployed and managed end-to-end data solutions on Azure, leveraging Azure Data Lake, Azure Functions, and Azure Databricks to support real-time data ingestion, transformation, and analytics for business-critical insights.
Utilized MDX queries to retrieve multidimensional data from cubes and developed advanced aggregations for high-level reporting.
Created SSAS Write-back functionality to allow data entry from Power BI and Excel, enhancing planning and forecasting workflows.
Implemented file automation using FTP Tasks in SSIS to transfer inbound/outbound files securely; integrated Send Mail Tasks for automated notifications on process completion or failure.
Enhanced data reliability by building robust error and event handling mechanisms in SSIS packages, including detailed logging and exception alerts.
Tuned SQL Server performance using index optimization, SQL Profiler, and Performance Monitor; significantly reduced query response times and resource consumption.
Leveraged Control-M and IBM TWS (Tivoli Workload Scheduler) for end-to-end job orchestration, improving scheduling accuracy and reducing manual intervention.
Collaborated with business analysts and data stakeholders to define KPIs and reporting metrics; participated in agile sprints and delivered work through TFS and Azure DevOps.
Migrated legacy SSIS/SSRS packages to newer SQL Server versions (2019), ensuring compatibility and leveraging modern features.
Conducted knowledge-sharing sessions and created documentation for BI solutions, promoting best practices and team knowledge retention.
Environment: SQL Server 2017/2019, SSIS, SSRS, SSAS (Tabular & Multidimensional), Power BI, DAX, MDX, T-SQL, FTP, Excel, Tableau, Visual Studio 2019, Control-M, TWS, TFS, Azure DevOps.
MSBI Developer September 2021 to January 2023
UnitedHealthcare – Minnetonka, MN
Designed and developed interactive SSRS reports including drill-down, drill-through, matrix, and sub-reports to support financial and operational analytics.
Built Power BI dashboards using advanced DAX expressions, role-based row-level security (RLS), and data modeling techniques to enable self-service analytics for business users.
Developed and maintained SSIS ETL packages for data extraction, transformation, and loading from various sources including SQL Server, flat files, and Excel, with comprehensive SCD Type 1 and Type 2 logic implementation.
Created parameter-driven Tableau visualizations, leveraging calculated fields, dynamic filters, and Excel integration for executive-level reporting.
Implemented Azure Synapse Analytics to unify big data and data warehousing workloads, enabling seamless querying across structured and unstructured data using on-demand serverless and provisioned resources.
Participated in Agile sprints, SCRUM meetings, sprint planning, and retrospectives, ensuring timely and quality delivery of BI artifacts and project documentation.
Designed and deployed SSAS cubes (multidimensional), developed calculated members and implemented business KPIs to support OLAP queries and performance analysis.
Automated report deployment and subscriptions via Report Manager, enabling secure distribution of reports with role-based access.
Migrated legacy reports and ETL packages to the latest SQL Server 2017 platform ensuring performance optimization and maintainability.
Designed end-to-end ETL pipelines using Azure Data Factory (ADF v2).
Implemented data quality checks and validation rules to ensure data integrity in ETL processes and reporting layers.
Collaborated with cross-functional teams including data architects, business analysts, and QA to translate business requirements into scalable BI solutions.
Environment: SSIS, SSRS, SSAS, Tableau, SQL Server 2017, T-SQL, Agile/SCRUM, Power BI, Report Builder 3.0, Windows Server, Excel, Git.
SQL BI Developer September 2019 to August 2021
Numerix – New York City, NY
Developed robust and scalable ETL packages using SQL Server Integration Services (SSIS), incorporating data conversions, transformations, error handling, and event logging for efficient data flow management.
Designed, developed, and maintained SSRS and Crystal Reports, including parameterized, snapshot, and subscription-based reports for various business units.
Built and deployed normalized and denormalized database schemas, stored procedures, user-defined functions, views, and triggers to support complex business requirements.
Collaborated with cross-functional teams including business analysts and front-end developers to translate business rules into T-SQL logic.
Optimized SQL queries and applied indexing strategies, execution plan analysis, and database tuning to improve performance and reduce latency.
Generated ad-hoc reports using SSRS, Excel, and Power BI based on business user requests and executive dashboards.
Utilized Team Foundation Server (TFS) for version control, issue tracking, and task management in an Agile development environment.
Created data models in Power BI and developed interactive dashboards for KPI tracking and trend analysis.
Participated in code reviews, unit testing, and data validation to ensure accuracy and quality of BI deliverables.
Assisted in the migration of legacy reports and packages to newer SQL Server environments and supported production deployments.
Environment: SQL Server 2015/2017, SSIS, SSRS, TFS, Crystal Reports, Agile, Power BI, Visual Studio
EDUCATION:
Masters in Information Technology Management Webster university.
Contact this candidate