Data Analyst with 3+ years of rich experience in creating compelling reports and dashboards using Power BI advanced DAX. Looking to work with an esteemed organization that gives me an opportunity to utilize my existing analytical skills and help me to make better business decisions.
Overview
3
3
years of professional experience
4
4
years of post-secondary education
3
3
Languages
Work History
Senior Data Analyst
Mindtrail Technologies Private Limited
Pune
11.2019 - 03.2023
Developed Power BI dashboards utilizing multiple data sources: Excel, CSV, SQL Server.
Created calculated columns, measures ,parameters and computed tables using Data Analysis Expression (DAX).
Installed and Configured Enterprise Gateway in Power BI Services to keep the dashboards and reports up to date.
Developed SQL queries / scripts to validate the data such as checking duplicates, null values, truncated values and ensuring correct data aggregations.
Extensively used joins and Sub-Queries to simplify complex queries involving multiple tables.
Used Tableau to create tree map ,waterfall chart and correlation graphs
Optimized data collection procedures and generating reports on weekly basis as per client requirements
Used Power BI to create real-time ROI graphs of different business verticals in the organization that helped the team focus on high-profit business. This lead to a 8% increase in annual profit.
Education
Bachelor of Science - Civil Engineering Technology