Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic
Aastha Shah

Aastha Shah

Thane

Summary

Experienced Assistant Consultant with expertise in data visualization, SQL query development, and Power BI dashboard creation. Skilled in gathering requirements, implementing security protocols, and optimizing workflows to support organizational goals. Focused on leveraging analytical abilities and problem-solving skills to deliver impactful insights and drive success in data-driven environments.

Overview

9
9
years of professional experience
1
1
Certification

Work History

Assistant Consultant (Grade C3A)

Tata Consultancy Service
03.2021 - Current
  • Create,update & maintain the dashbaord for multiple user from multiple database tools
  • Work along with user to gather therequiremnts for the dashbaord and visulization
  • Create wireframe for dashabord and obtaining sign off
  • Creating Row level security as per hierachical implementation
  • Writing SQL query for PBI data extrction
  • Accomplished challenging task to creating an excel viewin PBI dashbaord

Data Analyst

Randstad India Pvt Ltd
Mumbai
03.2019 - 12.2020
  • Deployed at Client: Procter & Gamble, Pvt. Ltd
  • Company Overview: Deployed at Client: Procter & Gamble, Pvt. Ltd.
  • Making reports such as MTD, retailing, distributor, channel-wise, ISC, DOS, DSR, etc. This helps to analyze the P&G products.
  • Coordinating and sharing reports with the market planners to achieve targets.
  • Data preparation and visualization using Power BI Desktop, Adv. Excel, Ms. Access, PPT for RTDC, Depot, and Regions, etc.
  • For data extraction using software such as Oracle and SAP, we even communicate with the related team.
  • Mining the data at Sub Brand Form Level.
  • Creating a report by combining the data of MSU shipment, retailing vs. targets.

Data Analyst

Leap India CO.
Mumbai
09.2016 - 03.2019
  • Leading a Team of MIS Executives.
  • Data Mining and Data Auditing.
  • Reconciliation against Audit v/s Invoice v/s System Stock.
  • Creating various reports such as client report, implementation report, visit report.
  • Coordinating with the Asset Management Team for audit, CRM report and monthly reconciling.
  • Collecting the data from the Asset department & CRM Department.

Education

BACHELOR IN BANKING AND INSURANCE -

K.E.S Shroff College, Mumbai University
Mumbai
05.2014

Skills

  • Power BI Desktop
  • sql query
  • Salesforce
  • Data auditing
  • Data extraction
  • Problem solving
  • Communication
  • Attention to detail
  • FMCG domain knowledge

Certification

Financial Analyst Pro-degree, IMARTICUS

Timeline

Assistant Consultant (Grade C3A)

Tata Consultancy Service
03.2021 - Current

Data Analyst

Randstad India Pvt Ltd
03.2019 - 12.2020

Data Analyst

Leap India CO.
09.2016 - 03.2019

BACHELOR IN BANKING AND INSURANCE -

K.E.S Shroff College, Mumbai University
Aastha Shah