Data Analyst
Dhwani Shah - Data Analyst - Sunnyvale, CA
Team-work oriented, spear-headed Data Analyst with 9 years of IT experience of which 6+ years of interpreting and analyzing data in order to drive
progressive business solutions. Proficient in designing business intelligence solutions with attention to detail on the problem statement. Excellent
understanding of business operations and analytics tools for effective analysis of data.
TECHNICAL SKILLS
Technologies Tools
SQL, BigQuery, Hive/Presto, App Script, SAP ABAP Tableau, GSuite, Microsoft Suite
WORK EXPERIENCE
Senior Data Analyst
Google, San Jose 02/2017 – Present
Responsibilities
? Developed BI frameworks using Tableau and Data Studio for multiple teams within Google: GUTS (internal ticketing system) Team, Asset
Management Team, Room Service Team.
? Implemented online portals using Google Sites by embedding the visualization reports highlighting data insights.
? Designed and managed data model using SQL capturing data from legacy system into Google BigQuery system.
? Effectively communicated with technical and non-technical stake holders and other teams to cut through business requirements and propose
end-to-end BI solution.
? Accomplished ad-hoc requests on data mining and spontaneous reports created along with data dumps for pattern and trend identification.
Project CUBE
? Performed data modelling to design the backend system logging AV Spaces Proactive Maintenance KPIs.
? Created automated data flow to gather inputs from on-field users and feed it to the back-end system using Google Sheets and App Script.
? Interpreted data, analyzed results, identified patterns and trends; communicated results back to the relevant members of the business
through reports and dashboards
Project AVFD
? Analyzed the legacy systems’ data and incorporate the sources into Bigquery data warehouse.
? Cleansed and normalized the data to be consumed for ETL pipelines and dashboards.
? Automate monitoring the data quality issues and send alerts to concerned stake holders.
Data Analyst
Facebook, Menlo Park 07/2016 – 10/2016
Responsibilities
? Analyzed massive Audio/Video Infrastructure HIVE data sets, performing ad-hoc analysis and data interpretation for meeting rooms and event
spaces.
? Collaborated with Data Engineers and communicated across multiple AV teams to assess the response time in troubleshooting outages and
thereby exposing connection issues.
Project Audio & Video Analytics
? Developed reports to monitor the onsite team’s daily performance and highlighting key metrics to carry out team tools’ inspections.
? Migrated existing backend tables and tableau dashboards from Oracle to Hive.
Data Analyst
Capgemini, Mumbai 04/2013 – 11/2014
Responsibilities
? Worked with Business Analyst to evaluate design specifications and identify source data that needs to be migrated to data warehouse,
participated in the design team and stakeholders’ meetings.
Project British Gas
? Created Technical Design Document from the functional specification documents.
? Extensively used Filters, Actions along with Forecasting, Data Blending, Hyperlink Objects, Color-coded tabs etc. in Tableau to create
interactive reports and then published, scheduled on the Tableau Server.
Software Programmer
Accenture, Mumbai 07/2008 – 04/2013
Responsibilities
? Played role of SQL and ABAP Technical member to lead a team of 3 resources.
? Constructed and tested complex SQL code scripts to analyze data on past, current and forecast sales.
Project EDF Energy, American Waters, EON Espana
? Designed reports allowing executive management to have impact-analysis with changing rate structure for Utilities clients across the globe.
? Implemented macros to devise technical solutions for SAP landscape in Billing Domain.
EDUCATION
Bachelor of Computer Engineering (B.E.)
Mumbai University, Mumbai, India
06/2008
Questions for the job opening:
Q - What time commitments do you currently have that could affect your availability to cover matches?
A - Currently I am working with Google on a contract for 8hrs/day
Q - How familiar are you with using smartphones or tablets (1-not familiar, 10-very familiar)?
A - I would rate my familiarity to screen gadgets as 8.5
Q - What is your background in Soccer? What is your level of knowledge?
A - I am keen to learn all about Soccer if given an opportunity, and that said I have very low exposure to the game
Q - What is your current employment situation? Are you currently looking for or have a full time position?
A - I have a full time currently with a vendor but looking for full time at an end client company
What do you foresee your living situation being for the next few years? Could you be moving to a new city in the future?
Dhwani Shah - Data Analyst - Sunnyvale, CA
Team-work oriented, spear-headed Data Analyst with 9 years of IT experience of which 6+ years of interpreting and analyzing data in order to drive
progressive business solutions. Proficient in designing business intelligence solutions with attention to detail on the problem statement. Excellent
understanding of business operations and analytics tools for effective analysis of data.
TECHNICAL SKILLS
Technologies Tools
SQL, BigQuery, Hive/Presto, App Script, SAP ABAP Tableau, GSuite, Microsoft Suite
WORK EXPERIENCE
Senior Data Analyst
Google, San Jose 02/2017 – Present
Responsibilities
? Developed BI frameworks using Tableau and Data Studio for multiple teams within Google: GUTS (internal ticketing system) Team, Asset
Management Team, Room Service Team.
? Implemented online portals using Google Sites by embedding the visualization reports highlighting data insights.
? Designed and managed data model using SQL capturing data from legacy system into Google BigQuery system.
? Effectively communicated with technical and non-technical stake holders and other teams to cut through business requirements and propose
end-to-end BI solution.
? Accomplished ad-hoc requests on data mining and spontaneous reports created along with data dumps for pattern and trend identification.
Project CUBE
? Performed data modelling to design the backend system logging AV Spaces Proactive Maintenance KPIs.
? Created automated data flow to gather inputs from on-field users and feed it to the back-end system using Google Sheets and App Script.
? Interpreted data, analyzed results, identified patterns and trends; communicated results back to the relevant members of the business
through reports and dashboards
Project AVFD
? Analyzed the legacy systems’ data and incorporate the sources into Bigquery data warehouse.
? Cleansed and normalized the data to be consumed for ETL pipelines and dashboards.
? Automate monitoring the data quality issues and send alerts to concerned stake holders.
Data Analyst
Facebook, Menlo Park 07/2016 – 10/2016
Responsibilities
? Analyzed massive Audio/Video Infrastructure HIVE data sets, performing ad-hoc analysis and data interpretation for meeting rooms and event
spaces.
? Collaborated with Data Engineers and communicated across multiple AV teams to assess the response time in troubleshooting outages and
thereby exposing connection issues.
Project Audio & Video Analytics
? Developed reports to monitor the onsite team’s daily performance and highlighting key metrics to carry out team tools’ inspections.
? Migrated existing backend tables and tableau dashboards from Oracle to Hive.
Data Analyst
Capgemini, Mumbai 04/2013 – 11/2014
Responsibilities
? Worked with Business Analyst to evaluate design specifications and identify source data that needs to be migrated to data warehouse,
participated in the design team and stakeholders’ meetings.
Project British Gas
? Created Technical Design Document from the functional specification documents.
? Extensively used Filters, Actions along with Forecasting, Data Blending, Hyperlink Objects, Color-coded tabs etc. in Tableau to create
interactive reports and then published, scheduled on the Tableau Server.
Software Programmer
Accenture, Mumbai 07/2008 – 04/2013
Responsibilities
? Played role of SQL and ABAP Technical member to lead a team of 3 resources.
? Constructed and tested complex SQL code scripts to analyze data on past, current and forecast sales.
Project EDF Energy, American Waters, EON Espana
? Designed reports allowing executive management to have impact-analysis with changing rate structure for Utilities clients across the globe.
? Implemented macros to devise technical solutions for SAP landscape in Billing Domain.
EDUCATION
Bachelor of Computer Engineering (B.E.)
Mumbai University, Mumbai, India
06/2008
Questions for the job opening:
Q - What time commitments do you currently have that could affect your availability to cover matches?
A - Currently I am working with Google on a contract for 8hrs/day
Q - How familiar are you with using smartphones or tablets (1-not familiar, 10-very familiar)?
A - I would rate my familiarity to screen gadgets as 8.5
Q - What is your background in Soccer? What is your level of knowledge?
A - I am keen to learn all about Soccer if given an opportunity, and that said I have very low exposure to the game
Q - What is your current employment situation? Are you currently looking for or have a full time position?
A - I have a full time currently with a vendor but looking for full time at an end client company
What do you foresee your living situation being for the next few years? Could you be moving to a new city in the future?