Vanita Garg Email & Phone Number

Mountain View, California, Us

Mountain View, Ca, Us

Tracking and analyzing escalations for 4 agency segmentation and creating buganizer components for each area to channelize the issues in a way that it can be addressed quickly and directly by the right team without going through unnecessary channels.Creating biweekly performance snippets to give team of 4 managers and 8 BI analysts insight of each agency program related to revenue increase, WoW growth , actual v/s forecast growth across 3 regions for search, display and adsProviding assistance to data analytics team in analysing revenue growth for GMS stakeholders by writing complex database queries to materialize the data in spreadsheets into sql tables and normalize it for better and simple understanding of tables.Working in ambiguity, coordinating with different teams to understand working process, team responsibilities and creating Dashboards, reports as needed using calculations, parameters in Tableau.

Morristown, Nj, Us

Customer Service Business AnalystAnalyzed Gfiber’s customer service data to increase team’s effectiveness and productivity by finding out reasons for escalations,giving solution (creating website for Installation process and FAQs) to reduce vendor expenses related to support team by 30%Used my technical knowledge , SQL for data analysis and good communication skills to coordinate with the support and finance team to understand ROI factors of Gfiber and then implementing operational solutions.Analyzed the existing customer’s usage data, follow up post installation and product features and implemented the process of live chat and response for tickets logged within 24 hours. I was involved in in-depth visualization of Google Fiber’s Customer ServiceData and designing tableau dashboards to provide insights to Product Managers.Systems Developer/Data AnalystDesigned Retail Supply Chain and Google’s Reverse Logistics Tableau dashboards which is used extensively by googlers and vendors around the globe to understand sales of different Google products.Formatted and Materialized very large data in spreadsheets to create sql tables and denormalized it for data visualization.Created and maintained workflows to run the data pipelines for Google hardware’s sales and making sure the dashboards are showing correct and reliable data.Expertise in Tableau Admin activities, Tableau Server and go to person for Tableau related queries for Google’s BI Team

Berkeley, Ca, Us

● Responsible for direct individual interaction with clients and gathering requirements for data analysis● Lead telemetry data reporting initiative; Use Impala to perform analytics via SQL; build 4+ Tableau dashboards ● Prepared PowerPoint presentations and Excel spreadsheets for business meetings. Delivered recommendations and forecasts to executive teams. Received certificate in Business Administration from University of California, Berkeley

Worldwide, Oo

● 3 years of experience working with Global clients to improvise their Business Processes using SAP ABAP. Experience working on SD/ Procurement/ Material Management Modules using FRICEW objects.● Proficient in Relational Database Management Systems. Created database objects like tables, views, functions and triggers using SQL to ensure database consistency and orderly availability of data in required tables ● Extremely adept at reporting analysis by utilizing Excel (Pivot tables and Vlookups) and Access database. Daily use of complex Excel formulas and pivot tables to manipulate large datasets● Received client appreciation for pro-activeness, dedication, quality of work and other project contributions

Kista, Stockholm, Se

Project Title: GUI Automation in Software Testing● Learned and worked on Automation Tool (QFS Tool) for Automation of File and event Mediation

Certificate In Business Administration, Financial Management

B. Tech, Electronics And Communications Engineering