Ashwini Raut
Data Analyst / Power Bi Developer
Pune
Summary
Enthusiastic Data Analyst with 3 plus years of experience interpreting and analysing data in order to drive successful business solutions. Proficient knowledge in Business Intelligence in working with visualization tool Power BI, DAX, SQL. Excellent understanding of business operations and analytics tools for effective analysis of data.
Overview
7
7
years of professional experience
6
6
years of post-secondary education
Work History
Sr.Batch Support Engineer
CompuCom Systems
Pune
06.2018 - Current
- Growth-oriented professional, with 3 plus years of Power BI experience in developing various reports and data visualization. Currently working for Compucom Systems .
- Hands on experience on Power BI Desktop, Power Query and Power BI Service, DAX, Azure data factory.
- Experience in creating Charts like Pie Charts/Donut/Word/charts/cards/gauges/slicers etc. and working with custom visualizations using Power BI
- Good knowledge on Data warehousing concepts like Star schema, Snowflake schema and identifying dimension and fact tables.
- Good at analyzing, gathering, managing and documenting business requirements.
- Extensively used transformations like Merge Queries, Append Queries, Pivoting Column, Un-Pivoting Columns, Adding Custom Columns, Splitting Columns, Merging Columns etc.
- Experience in connecting with multiple data sources like SQL Server, json, csv and Excel from Power BI to build complex Datasets.
- Skilled in Advanced Excel, SQL and Power BI (Power BI Desktop and Power BI Service).
- Extensively worked on performing ETL Activities in Power Query.
- Extensively used different Categories of DAX functions like Time Intelligence Function, Filter Functions, Date Functions, Logical Functions, Text Functions, Number and Statistical Functions for Creating New Information.
- Extensively worked on Enhancing Data Model by Creating New Columns, New Measure and New Tables using DAX Expressions.
- Hands on Experience with Visual level, Page level, Report level and Drill Through filters for filtering data in a Report.
- Published Power BI Reports in required organisation and made Power BI Dashboards available in Web clients and mobile apps.
- Hands on experience on Implementing Row Level Security, Bookmarks, Parameters to restrict user dataset.
- Experience in publishing Reports to Power BI Service and setting up necessary connections.
- Extensive Experience in Creating Dashboards and Mobile View using Multiple Reports.
- Worked on On-Premise Data Gateway to Refresh and Schedule Refresh Data in Dataset.
- Experience in sharing Reports and Dashboards with End Users.
- Good Experience and knowledge on cloud computing such as – Azure
- Experience in working with Azure services such as – Azure Storage, Azure Lake Storage, Azure SQL Database, and Azure Data Factory
- Collaborated with azure data engineers and operation team to implement ETL process using Azure Data Factory wrote and optimised SQL queries to perform data extraction to fit analytical requirements
- Performed data cleaning including transforming variables and dealing with missing value and ensured data quality, consistency, integrity using ADF
Research Analyst
XDBS
Pune
03.2017 - 06.2018
- Gathered, arranged and corrected research data to create representative graphs and charts highlighting results for presentations.
- Collected data on competitors, consumers and marketplace and consolidated data into presentations and reports.
- Performed valid and accurate market research for XDBS Corporation.
Computer Expert
Unity IT
Aurangabad
07.2013 - 09.2015
Education
Bachelor of Electronics Engineering -
PES College of Engineering
Aurangabad 07.2011 - 07.2014
Diploma in Electronics And Communication -
Hi-Tech College of Engineering
Aurangabad 06.2008 - 07.2011
Skills
- Power Bi
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Quote
I feel that luck is preparation meeting opportunity.
Oprah Winfrey
Timeline
Sr.Batch Support Engineer
CompuCom Systems
06.2018 - Current
Research Analyst
XDBS
03.2017 - 06.2018
Computer Expert
Unity IT
07.2013 - 09.2015
Bachelor of Electronics Engineering -
PES College of Engineering
07.2011 - 07.2014
Diploma in Electronics And Communication -
Hi-Tech College of Engineering
06.2008 - 07.2011
Similar Profiles
Saloni GandhiSaloni Gandhi
Subject Matter Expert at CompuCom SystemsSubject Matter Expert at CompuCom Systems
Arshdeep Kaur SarwaraArshdeep Kaur Sarwara
Incident Management Coordinator at CompuCom SystemsIncident Management Coordinator at CompuCom Systems
SUHAIB AHAMEDSUHAIB AHAMED
NOC Engineer at CompuCom SystemsNOC Engineer at CompuCom Systems
Vivek Bhimrao AbitkarVivek Bhimrao Abitkar
Telecommunications 2 at CompuCom SystemsTelecommunications 2 at CompuCom Systems
Amol Dilip WaniAmol Dilip Wani
Senior Specialist – Client Services Project Manager at NICE Interactive SolutionsSenior Specialist – Client Services Project Manager at NICE Interactive Solutions