Senior Data Analyst

PAVINAYAN SHARMA

PROFESSIONAL SUMMARY

* ***** *****-** ********** playing with data in a fast pacing Startup environment. A notable history of working in a Business Intelligence & Data Analytics role. Skilled in extracting, interpreting and visualizing data by using Analytical Skills, Advanced Excel, SQL and BI Tools.

WORK HISTORY

Senior Data Analyst, 01/2017 to 12/2019

WizIQ.com, Gurgaon, India

• Data Extraction by building queries and transforming it into insightful visuals

• Generating dashboards using Tableau to access employees' Key Point Indicators

• Creating Reports & Metrics using advanced excel functions like fuzzy lookups, lookups.

• Assisting marketing campaigns by generating dashboards for tracking A/B testing data

• Generating monthly MIS reports

• Designing and developing sales analytics reports and dashboards on weekly/monthly/quarterly basis to provide actionable insights for executive leadership teams

• Utilize BI tools for creation of reports, scorecards, dashboards and other solutions (MS Excel, Tableau, PowerBI)

• Using Zoho CRM and ZOHO reports for day to day data insights

• Generating weekly Customer Support Ticketing dashboards from Helpdesk Associate Data Analyst, 01/2015 to 01/2017

WizIQ.com, Gurgaon, India

• Analyzed large amounts of data to find patterns for answering sales queries

• Corrected any data entry error to prevent later issues such as duplication or data degradation.

• Gathered and Compiled competition data and potential customer data

• Assisted in creating Marketing dashboards

• Generated weekly dashboards for geographical sales performance campaigns

• Collect and present weekly customer ticketing reports from Helpdesk Executive Assistant to the Chief Executive Officer, 01/2014 to 01/2015 WizIQ.com, Mohali, India

• Created business presentation decks for investor meetings using MS Powerpoint

• Handled project management tasks on behalf of CEO whenever required

• Generated weekly status reports of ongoing projects under the for the CEO EDUCATION

MBA, H.R Analytics, 09/2018

IMT Ghaziabad - India

Bachelor of Engineering Technology, Computer Science, 08/2012 Chitkara University - Baddi, India

Address : Brampton, Ontario L6Y-5X1

Phone : 647-***-****

Email : ***************@*****.***

TECHNICAL SKILLS

• MS Excel Advance Functions

• SQL Server : Query Extraction, Temp Tables,

Joins, Subqueries

• Tableau: Visual Business Insights,

Daily/weekly Reports, Dashboards

• Zoho: CRM, Reports

• Python: Pandas, seaborn, plots

• MS Office Suite

HARD SKILLS

• Data Analysis

• Dashboard Development

• Advance Microsoft Excel

• Data visualization

• Analytical skills

SOFT SKILLS

• Strong Communication skills

• Excellent Interpersonal skills

• Team player

• Punctual to a fault

• Divergent thinking

ACCOMPLISHMENTS

• Assisted in successfully setting up a new

Learning Market Place for WizIQ called

Learno

• Assisted in launching a new B2C tutoring

app

• Hiring and leading a team of 3 to clean up

the customer segmentation project

• Working with the CXOs to deliver data and

reports that helped close the C-Round

funding for WizIQ.com

• Assisting in due-diligence for the successful

accusation of WizIQ.com

.

Contact this candidate