Power Bi Sql Server

Roshani Abhishek Khapare

Contact: 917-***-****

Email: ad5ocv@r.postjobfree.com

LinkedIn: www.linkedin.com/in/roshani-k-9b1119285

PROFESSIONAL SUMMARY:

• Highly motivated BI Data Analyst with over 7 years of IT experience behaving in multiple skill sets and extensive working experience in Data Warehousing, Data Analysis, and Business Intelligence Technologies with expertise in SQL Server development, MSBI stack (TSQL, SSIS, SSAS, SSRS), Azure, Power BI for building, deploying, managing applications and services through a global network of Microsoft - managed Data Centers

• Motivated and responsible professional with proven ability to achieve organizational and professional goals and accomplish high career growth through a continuous learning process

• Designed, developed, and implemented Power BI Dashboard, Scorecards, and KPI reports

• Experience in implementing dashboarding, data visualization, and analytics using Microsoft Power BI Desktop and Power BI Server

• Advanced knowledge of Python programming for data analysis, manipulation, and visualization

• Proficient in data modeling and integrating report components from data sources

• Understanding of Microsoft BI suite products including SQL Server Integration Service (SSIS), SQL Server Analytical Services (SSAS), and SQL Server Reporting Services (SSRS)

• Skilled and experienced data analyst with expertise in utilizing Power BI and Snowflake to extract insights from complex datasets

• Good experience in dashboard designing with large data value from various data sources like SQL, MS Excel

• Used Power Query to acquire data and Power BI desktop for designing rich visuals

• Experience in Power BI to import data from various sources such as SQL Server, Azure SQL DB, SQL Server Analysis Services (Tabular Model), MS Excel, etc

• Design and implement Tableau data sources, including connecting to various data platforms and performing data blending

• Having in-depth knowledge of Software Development Life Cycle (SDLC) including Waterfall, Agile, and Scrum Methodology

• Assist end users with problems installing the Power BI Desktop, installing and configuring the Personal and On- Premises gateway, connecting to data sources, and adding the different users

• Experience in creating quick Filters, table calculations, calculated measures, and parameters in Power BI.

• Extensive experience with SQL Server with DAX Functions Such as SUMX, CALCULATE, ALLEXCEPT, and FILTER Functions. Designed and developed a new ETL/SSIS package that loads data from OLTP into our existing Data Warehouse based on technical specifications and business requirements

• Involved in creating Jobs, SQL Mail Agent, Alerts, and Scheduled DTS/SSIS Packages

• Adept in creating Ad-hoc, Cross-Tab, Drill-down, and Sub-Report using RDL in SSRS

• Worked with table and matrix visuals, worked with different levels of filters like report level, visual level filters, and page level filters

• Responsible for building Power BI reports from Scratch and creating and changing the visualizations in Power BI reports and Dashboards on client requests. Experienced in both live and import data into Power BI for creating reports

• Utilized complex SQL queries and worked with various database management system

• Expert in ETL (SSIS) and DTS packages to perform data transfer from different server locations and heterogeneous sources like Oracle, Excel, CSV, XML, MS Word, and Text Format Data

• Adept at creating Power BI scorecards, and dashboards using stack bars, bar graphs, scatter plots geographic maps

• Ability to communicate data insights and present concepts to technical and non-technical audiences

• Hands-on experience in MDX Expression, DAX Expression, Power BI Pivot, Power integrated with SharePoint, and in creating a dashboard in the Power BI tool

SKILLS:

Reporting Tool: Microsoft Power BI, MS Excel, SharePoint Database: MS SQL Server, Oracle, MS Access, Snowflake, Salesforce, PostgreSQL Programming Language: SQL, T-SQL, DAX, Python

Business Intelligence Tools: Microsoft Power BI, Power Pivot, Power View, Power Query, Power BI Desktop, Power BI Services, Visual Studio (SQL SSIS, SSAS, SSRS), Tableau ETL Tool: SQL Server Integration Services, Data Transformation Service (DTS) Methodologies: Agile and Waterfall

Operating Systems: Windows, Unix/ Linux, Mac

Others: Azure, Azure Data Factory, Azure SQL, Databricks, AWS, Snowflake, Jira, Synapse Analytics, GIT, Confluence, Talend, and MS Office tools PROFESSIONAL EXPERIENCE:

CenterLight Health System, New York, USA Nov 2021 - Present BI Developer / Data Analyst

Responsibilities:

• Enabled decision-making by conducting analyses from multiple sources to present research in a digestible and actionable format

• Work closely with Data Engineers on the team to identify data sources, build scalable data models, and operationalize the data analytics

• Involved in building dashboards in any of the BI platforms and strong experience in writing SQL queries to understand and build dashboards/reports as per the user's request

• Writing complex SQL queries for data extraction, transformation, and loading (ETL) processes

• Developed Python scripts for data preprocessing, cleaning, and transformation tasks to prepare data for analysis and reporting

• Collaborated with cross-functional teams to identify data requirements and implement solutions using Databricks and Power BI

• Designed and developed paginated reports using Power BI Report Builder or SQL Server Reporting Services

(SSRS) to meet specific business requirements

• Developed and maintained data pipelines using Synapse Analytics to ingest, transform, and load data from various sources

• Writing complex DAX formulas to calculate measures and create calculated columns in Power BI

• Provide technical design, coding, testing, implementation, maintenance, system, and technical support for BI initiatives

• Utilized Python programming to perform advanced data analysis, extract insights, and visualize trends and patterns in large datasets

• Create and administrate workspace for each project on Power BI service and publish the reports from Power BI Desktop to Power BI Services workspace.

• Wrote T-SQL (DDL and DML) queries, stored procedures used them to build packages, and handled slowly changing dimensions to maintain the history of the data

• Utilized parameters and filters in SSRS reports to enable dynamic report generation based on user input.

• Implemented advanced formatting options such as tables, matrices, charts, and gauges to visualize data effectively in paginated reports

• Developed ETL processes to extract, transform, and load data from various sources into the Snowflake data warehouse

• Used Power Query in the context of Microsoft Excel and Power BI

• Involved in data modeling techniques including dimensional modeling and creating star schemas to optimize data for reporting and analysis in Power BI

• Designing and implementing ETL processes to cleanse, transform, and aggregate data for analysis

• Used DAX functions to create measure and calculated fields to analyze data for logical visualization and used Power Queries to transform the data

• Generating reports using SQL Server Reporting Services (SSRS) 2014/ 2008/2005

• Integrated paginated reports with other Power BI artifacts such as dashboards and datasets for comprehensive business intelligence solutions

• Involved in Data Migration using SQL, SQL Azure, Azure storage, Azure Data Factory, SSIS, PowerShell

• Involvement in developing reports and dashboards from multiple data sources such as on-premises and cloud using Power BI desktop

• Optimizing ETL workflows for performance and scalability

• Create dynamic calculations using DAX measures and variables for enhanced interactivity in Power BI reports.

• Used various sources to pull data into Power BI such as SQL Server and Oracle. Used advanced features of T-SQL in order to design and tune T-SQL to interface with Azure

• Implemented report versioning and change management processes to track and manage revisions to SSRS reports

• Designed Cubes with star schema and snowflake schema in SSAS and Executing Analysis Services Processing Tasks in SSIS for processing cubes in packages

• Integrated data visualizations such as sparklines, indicators, and data bars to convey trends and patterns effectively within paginated reports

• Power query used to create custom functions and queries for data extraction and transformation

• Developed and published reports and dashboards using Power BI and written effective DAX formulas and expressions

• Ability to troubleshoot and resolve data quality issues during the ETL process

• Developed paginated reports to match the invoice formats. Utilized Power Query in Power BI to Pivot and Un- pivot the data model for data cleansing and data massaging

• Follow the release cycles and implement on-time delivery of bug fixes, change requests, and enhancements

• Monitor Dashboard Reporting and Presentation Layer functioning and performance and proactively fix issues as found. Support the performance of systems.

Environment: Power BI, MS SQL Server 2012/2008, Aws, SQL Server Integration, Azure Data Factory, Services SSIS, T- SQL, Export Data, Databricks, Snowflake, Python, Oracle Warehouse Builder, Synapse Analytics, SQL Server Analysis Services SSAS

Host Layer Technologies, Maharashtra, India Jan 2020 – Feb 2021 Power BI Developer

Responsibilities:

• Designed and implemented multiple dashboards using Power BI - PowerPivot and Power Query for in-house metrics

• Worked on the development of a compliance dashboard for two projects from requirement gathering to deployment

• Optimized SQL queries for performance and scalability by using techniques such as indexing and query

• Integrated SSRS reports with Power BI dashboards and other BI tools to provide comprehensive insights across multiple platforms

• Used DAX functions to create aggregated measures and complex formulas to deliver KPIs and scorecards as per requirements

• Developed ETL processes to extract, transform, and load data from various source systems into the data warehouse, utilizing tools such as SSIS and Azure Data Factory

• Integrated data from multiple sources into paginated reports, including SQL Server databases, Excel files, and SharePoint lists, ensuring data accuracy and consistency

• Utilized DAX (Data Analysis Expressions) to create complex calculations and measures for deriving key performance indicators (KPIs) from Salesforce data

• Generated periodic reports based on the statistical analysis of the data from various time frames and divisions using power pivot, power query, and power view

• Conduct data mapping, design, develop, and implement extract / transform / load processes using custom ETL based on SSIS technology

• Designed and developed Snowflake data warehouse solutions, including schema design, data modeling, and optimization for performance

• Developed and maintained Power BI reports and dashboards, connecting directly to Azure SQL databases to visualize real-time data

• Developed and maintained automated processes for refreshing and updating Salesforce data in Power BI reports and dashboards

• Analyze large data sets using a variety of query and visualization tools

• Writing complex SQL queries to extract and transform data from multiple sources for Power BI data modeling and visualization

• Creating custom aggregations and statistical calculations using DAX functions tailored to specific business requirements

• Created dynamic reports in SSRS utilizing various properties such as chart controls, filters, interactive sorting, and SQL parameters to deliver engaging and insightful reporting solutions

• Maintained and updated existing paginated reports to accommodate changing business requirements, data sources, and user feedback

• Designing and implementing ETL workflows using Power Query Editor within Power BI to cleanse, transform, and shape raw data

• Generated Power BI scoreboards and dashboards using stack bars, bar graphs, scattered plots, geographical maps, heat maps, bullet charts, and Gantt charts demonstrating key information for decision-making

• Perform data analysis, design, and development of new and ongoing business intelligence(BI) tools Tableau involving complex Data structures

• Involved in data profiling and data cleansing techniques in SQL to ensure data quality and accuracy for Power BI reporting and analysis

• Using DAX to perform advanced statistical analysis, forecasting, and predictive modeling within Power BI

• Designed and created dashboards using POWER BI Desktop and POWER BI Service, integrating SSRS reports using the Pin feature for enhanced data visualization

• Leveraged expressions and calculated fields to perform complex calculations and aggregations within paginated reports, providing valuable insights to stakeholders

• Troubleshooting ETL errors, performance issues, and data discrepancies to ensure data integrity and consistency

• Developed reports to visually explore data and create an interactive report in Excel and Power BI

• Deployed Power BI dashboards and worksheets in a clustered environment

• Extracted and transformed data from different sources and loaded data to target Data warehouse

• Developed and enhanced reports connection to single multiple data sources to improve performance Environment: MS SQL Server 2016/2014, MS SQL Server Integration Services (SSIS), MS SQL Server Analysis Services

(SSAS), Data Warehouse, Snowflake, Azure SQL, Power BI Desktop, Power BI Service, Data Gateway, DAX, T-SQL, Tableau, Azure Data Factory, ETL, MS Excel, Excess, Windows 8 WNS Global Service, Maharashtra, India Feb 2018 – Dec 2019 Power BI Data Analyst

Responsibilities:

• Gathered requirements from IT help desk customers to create prototypes and Power BI reports to help answer business questions. Created dashboards to show performance by countries, and geographies with various metrics.

• Created Power BI reports by using Joins in multiple tables from multiple databases using complex SQL queries.)

• Generated Power BI scoreboards and dashboards using stack bars, bar graphs, scattered plots, geographical maps, heat maps, bullet charts, and Gantt charts demonstrating key information for decision-making

• Designing and Developing the Dashboard Reports using MDX and insights and Reports

• Scheduling and automating ETL jobs to ensure timely data refreshes and updates for Power BI reports and dashboards

• Utilized Azure Data Factory activities such as copy data, transformations, and control flow tasks to automate data processing and ensure data consistency and reliability

• Designed and implemented Data Warehouse solutions using Power BI and SQL Server, ensuring data consistency, integrity, and accessibility for reporting and analytics purposes

• Conducted data analysis to identify trends, patterns, and insights from Salesforce data to support sales and marketing strategies

• Implement complex business logic and custom calculations using DAX, enhancing the analytical capabilities of Power BI reports

• Created new measures and new calculated columns for reports and dashboard analysis

• Created data visualizations using various visual objects (Line chart, Bar chart, Treemap, Single card, KPI, Map, Pie chart, custom visuals)

• Published reports and dashboards to the Power BI service. Created Parameterized Reports, Dashboard Reports, Linked Reports, and Sub Reports by Year, Quarter, Month, and Week

• Implemented report integration among Power BI, SSRS, and Python reports

• Created drill-down reports, Drill Through Reports by Region

• Utilized Python scripts within Power BI to perform advanced data analysis, manipulate data, and create custom visualizations

• Automated Power Query refresh using PowerShell script and Windows task scheduler

• Creating and optimizing complex calculated columns and calculated tables using DAX expressions

• Used various sources to pull data into Power BI such as SQL Server, Oracle, SQL, Excel, etc

• Integrating ETL processes with data quality tools and platforms to automate data profiling, cleansing, and enrichment tasks as part of the data preparation pipeline

• Worked with import and direct query, creating custom tables in the Power BI merging and appending queries removing and splitting columns, and choosing required columns in the data

• Worked with different data sources, non-relational Databases such as Flat files, Excel sheets, and other relational sources such as Oracle, and SQL Server

• Troubleshooting and debugging DAX formulas to identify and resolve calculation errors or inconsistencies

• Power BI helps to quickly filter the project or component to generate new insights into your JIRA data

• Involved in overall SDLC–Gathering requirements, design prototypes, multiple iterations, dashboard development, data testing, unit testing, UAT, and then deployment

• Responsible for testing dashboards on monitors with different resolutions, iPads, and mobiles Environment: Power BI, SQL Server 2016, Teradata, Azure Data Factory, Python, SSIS, SSRS, SSAS, Data Warehouse, Power BI, Salesforce, MySQL, TFS, Jira, MS Office

Sun Pharma, Maharashtra, India April 2017 - Jan 2018 Data Analyst

Responsibilities:

• Created the Design-level document from the business specifications provided by the client and SMEs

• Coordinating with the business analyst to get a clear understanding of the business and meet their expectation Leveraged Oracle SQL Developer to write ad hoc queries to build reports and Dashboards

• Engage in analysis using data mining techniques, researching, identifying, and aggregating complex data sets

• Used the tortoise SVN version control to maintain the mapping versions

• Co-ordinate with the QA and UAT team for any issues and provide the fixes

• Automated strategic business planning process by deploying centralized Reporting/ Data Catalogue from source to target data

• Conducted data analysis using Python and SQL to extract insights from various data sources, including relational databases, CSV files, and APIs

• Create quarterly KPI dashboards using Tableau to identify opportunities for system improvements

• Worked on creating reports by integrating JIRA with Tableau

• Developed data models using star schema

• Used MS Excel, MS Access, and SQL to write and run various queries. Worked extensively on creating tables, views, and SQL queries in MS SQL Server

• Designed and optimized data models in Synapse to ensure scalability, performance, and accuracy of analytical insights

• Worked with internal architects and assisted in the development of current and target state data architectures

• Prepared and presented custom Executive dashboards using live and extract for operations using Tableau

• Perform ETL maintenance and support activities involving the development of data workflows for customers

• Resolved data issues reported by customers, analyzed fallouts after data conversion, and resolved trouble tickets

• Lead client meetings to brainstorm functional requirements, negotiate, and provide suggestions for improvements. Initiated design review sessions, discussed the development, and created user stories

• Worked and created BRDs over SharePoint to document business and technical requirements

• Created custom test cases to analyze the development work

• Maintained Product Backlog and prioritized user stories into Sprints based on customer needs using JIRA Environment: SQL, MS SQL Server, JIRA, Tableau, Synapse, Python, MS Office, and MS Visio EDUCATION:

• Bachelor of Engineering: Electronics and Telecommunication, Pune University, Maharashtra, India CERTIFICATIONS:

• Google Data Analytics Professional Certificate

Contact this candidate