Summary
Overview
Work History
Education
Skills
Timeline
Generic

Apoorva Anwekar

Sunnyvale,CA

Summary

Seasoned professional with eight plus years of experience in global consumer technology industries. Proficient in analyzing metrics, deriving data-driven insights and offering strategic recommendations for product and business advancement. Adept at fostering collaboration across teams to streamline project lifecycles and attain overarching strategic objectives.

Overview

12
12
years of professional experience

Work History

Data Governance Program Manager

Google Cloud (via Mackin)
09.2023 - Current
  • Oversees and manages Google’s critical partnerships with Supply Chain Partners, ensuring seamless collaboration for delivery of essential services
  • Led development and implementation of comprehensive business review scorecard, aligning it with organizational objectives to provide actionable insights for informed decision-making
  • Directed seamless integration and deployment of compliance dashboard, enhancing operational efficiency and ensuring adherence to regulatory standards
  • Spearheaded development of automated email reminder system to promote a culture of compliance within organization, streamlining communication processes and increasing awareness
  • Managed ongoing system maintenance activities to uphold data integrity and accuracy, ensuring that systems operate smoothly and reliably.

Quality Business Analyst - Data Center Quality

Google Cloud (via Mackin)
09.2021 - 09.2023
  • Led transformation of manual business continuity plan into fully automated web app, resulting in fourfold increase in completion rate and streamlined data collection for insights generation
  • Produced and presented data-driven dashboards and reports for weekly global stakeholder meetings, utilizing SQL for analysis
  • Predictive insights from past experiences informed knowledge-driven decisions
  • Collaborate cross-functionally to establish data policies, processes, and governance, creating comprehensive documentation for clarity and alignment.

Fraud Risk Analyst - Intuit QuickBooks

Intuit (via Apex)
08.2019 - 11.2019
  • Designed and implemented workflow to analyze third-party alerts and detect potential fraud, aiming to minimize financial impact.
  • Automated data migration from Oracle to Amazon Redshift to centralize data storage.
  • Conducted real-time transaction analysis to identify and prevent potential fraud, reducing financial losses.
  • Presented analysis reports to stakeholders, showcasing effectiveness of fraud risk analysis on weekly basis.

Business Analyst - Google Pay

Google (via Vaco)
05.2018 - 08.2019


• Designed intuitive BI dashboards to monitor Google Payments performance globally post-launch.
• Developed and presented compelling product usage stories to stakeholders, aligning with Google Pay's strategic goals.
• Gained deep industry knowledge and analyzed product metrics to recommend effective marketing strategies, resulting in an 8% increase in email open rates.
• Conducted comprehensive analysis of user interactions with Google Pay, benchmarking key metrics across platforms.
• Proficient in data querying and visualization tools such as SQL and advanced Excel.

Technical Business Analyst -Copyright & Legal team

YouTube (via Vaco)
10.2016 - 04.2018
  • Technical Business Analyst – Copyright and Legal team
    • Quantified abuse rates, identified emerging trends, preempted complaints resolution, and evaluated impact on policy positions.
    • Classified inbound complaints into different categories based on nature of complaint, demography, sensitivity, potential virality
    trends etc.; assigned priorities based on the categorization resulting in reduction in avg. time to respond by 12%.
    • Created interactive dashboards for management to review copyright violation cases and their trend across multiple dimensions.
    • Automated weekly analysis reports by integrating multiple data sets; achieved 25% reduction in person-hours due to this.
    • Identified bots and spammers to create segmentation between genuine and bogus complaints; resulted in cost reduction.
    • Ran ongoing and ad-hoc analyses in support of site-wide Trust and Safety objectives as well as operational effectiveness and incident
    response.

Senior Systems Executive - Financial Asset Management

Cognizant Technology Solutions
04.2012 - 10.2014
  • IT Support: Assisted a global financial firm in executing an IT strategy aligned with desired business outcomes.

Education

Data Analytics Bootcamp -

University of California, Berkeley Extension
San Francisco, CA
04.2018

Bachelor of Technology, Electrical Engineering -

Swami Vivekananda Technical University, Bhilai Institute of Technology
Chhattisgarh, India
05.2011

Skills

  • Databases: Oracle 11g, SQL Server, MySQL, Google SQL, Dremel, Google F1, Google BigQuery, AWS Redshift
  • Querying Languages: SQL, PL/SQL, Python, Pandas, NumPy, Jupyterhub, Matplotlib, HTML
  • Tools and Platforms: MS Excel, Advanced Excel (VLOOKUP, Pivot table, app script), VBA, Tableau, Control M, Informatica, BI tools, PLX, Google Dashboards, Google Data sites

Timeline

Data Governance Program Manager

Google Cloud (via Mackin)
09.2023 - Current

Quality Business Analyst - Data Center Quality

Google Cloud (via Mackin)
09.2021 - 09.2023

Fraud Risk Analyst - Intuit QuickBooks

Intuit (via Apex)
08.2019 - 11.2019

Business Analyst - Google Pay

Google (via Vaco)
05.2018 - 08.2019

Technical Business Analyst -Copyright & Legal team

YouTube (via Vaco)
10.2016 - 04.2018

Senior Systems Executive - Financial Asset Management

Cognizant Technology Solutions
04.2012 - 10.2014

Data Analytics Bootcamp -

University of California, Berkeley Extension

Bachelor of Technology, Electrical Engineering -

Swami Vivekananda Technical University, Bhilai Institute of Technology
Apoorva Anwekar