HEMANSHI PATEL

Ph. 226-***-**** adi4ar@r.postjobfree.com Ottawa, ON

Professional Summary

A hard working & talented Professional Data Analyst who can provide senior company executives with the dashboards, reports and analysis needed to make strategic decisions that are related to the business’s everyday needs with Team Leading experience of 3+ years in Customer Service and Industry challenging environment along with education in Computer Engineering.

Skills

Microsoft Power BI

Advance Excel (VLOOKUP, Power Pivot, INDEX,

MATCH, Pivot tables, Dashboards)

Microsoft Office Suite

Tableau

HTML

CSS

C/C++ Programming

Report Development

Strong Communication and Interpersonal skills

Azure Cloud

SQL Server Analysis Service(SSAS)

SQL Server Reporting Service(SSRS)

SQL Server Integration Service(SSIS)

MY SQL

T-SQL

Database Management

Python

Team Management

Problem Solving Skills

Data Analysis and Data Storytelling

skills

Work History

Data Analyst – Remote Support 02/2020 to Current

Alpha Analytics – Sydney, AUS

Understanding Business Requirements and interactive with relevant stakeholders for dashboard design projects

Designing of ETL based on solution requirement using tools such as SSIS, Azure Data Factory and Power Query Dataflows etc

Designing of tabular data models in Power BI Desktop

Developing Semantic Models as per the project requirement

Developing Metric using Power Query, DAX, and other Power BI services

Documenting technical solutions for future reference.

Coordinating with business users on solution improvement and bug fixes.

Publishing, Sharing and Distributing Power BI Reports, KPI and Dashboards to relevant stakeholders as per the approved guidelines.

Managing Monitoring and Governing Workspaces and Reports on a daily basis as part of BAU (Business as Usual) work.

Data Analyst 03/2019 to 12/2019

Devi Electro Engineers – Gujarat, India

Collecting data from the particular department and synthesizing data.

Manage and design database, write complex query as per requirement.

Working closely with project managers to understand and design dashboards to meet their analytical requirements, including identifying critical metrics .

Analyze the project using Google Analytics etc.

Prepared reports from data management frameworks using T-SQL, Power Queries etc. and design of ETL using SSIS .

Creating and maintaining interactive visualizations in Power BI through data interpretation and analysis, integrating various reporting components from multiple data sources.

Communicate effectively with project management regarding any issues as per need of projects.

Present new strategies and monthly reports to the management. Customer Service Representative – Team Lead 12/2017 to 03/2019 Teleperformance – Gujarat India

Develop and Manage teams of customers service representatives.

Conduct customer feedback for quality of calls and provide feedback to Senior Management.

Maintain strong relationship with stakeholders and internal departments.

Develop schedule and conduct performance reviews of customer service representatives.

Prepare customer satisfaction reports including presentation of new strategies focused on addressing new customer needs.

Customer Service Representative 08/2016 to 12/2017 Teleperformance – Gujarat India

Attend customer service calls and provide resolution regarding to any account issues.

Provide on-site assistance to the field crews and resolve any issues.

Prepare shift handover reports and daily customer satisfaction report.

Develop resolutions for issues that are not mentioned in the standard manuals.

Raise any corrections required in the standard manuals and support documentations. Education

Bachelor of Computer Engineering 2016

Gujarat Technological University - India

Projects Accomplished

Poll day monitoring system by using PHP,HTML and SQL server 2016 Gujarat Technical University - India

Webpage of Movie review by using HTML,CSS and JavaScript 2020 Concordia Admission Challenge

Certification

Azure Fundamentals 2020

Microsoft

Business Intelligence 2020

Udemy

Microsoft SQL Server 2020

Stackskills

Contact this candidate