Ayush Gupta Email & Phone Number

New York, Ny, Us

Mountain View, Ca, Us

Mountain View, Ca, Us

Mountain View, Ca, Us

Mountain View, Ca, Us

• Spearheaded product development efforts by defining product roadmap, developing detailed wireframes and conducting over 50 customer interviews to build self-serve analytics for Google’s nascent vendor operations for consumer products.• Defined technical architecture and built a self-serve analytics solution, with 1000+ lines of productionized R & SQL code, reducing time to deliver analytics from 6 weeks to under 30 minutes.• Collaborated with eight Product and Capability Support teams, and Operational Excellence and Analytics functions to create KPI definitions for nascent vendor-managed operations.• Created Business Requirements Document and Technical Design Document for project continuity.

Singapore, Singapore, Sg

• Automated org-wide manual reporting by spearheading org-wide development of analytics stack and 20+ cross functional BI dashboards using Amazon Redshift and Periscope, which enabled management to track 50+ KPIs.• Spearheaded project to improve visibility of sales metrics to C-Suite by implementing sales funnel and KPIs in Prosperworks, which reduced dropoffs at various stages of the sales funnel by 20%.

Gurgaon, Haryana, In

• Leveraged clickstream data to code tools in Python for PMs to analyze user behavior on app and website, driving up repeat users and reducing search and product page dropoffs by ~20%.• Developed probabilistic model to predict inventory for vendors nationwide, which increased order fulfilment rates from 15% to 60% and lowered order processing times from by 75%.• Managed infrastructure (AWS + 3rd party services) for analytics team and ensured cost savings of 40% by creating internal processes to optimize infrastructure allocation.

Gurgaon, Haryana, In

• An early hire. First analyst at the firm.• End-to-end implementations of the first reporting platform (BIRT) for the firm.• Spearheaded development of 1mg’s analytics stack (SQL, Python, Redshift), used by firm’s 600+ employees to track/improve metrics, growing monthly revenue 38x to $2.26M in 30 months.• Collaborated with management across product, marketing, operations to create 50+ dashboards in Tableau and Sisense, reporting 300+ metrics in near real-time for all 4 businesses of the firm.• Coded and deployed scripts in Python and SQL to identify unique users across mobile and web platforms to uncover true customer retention rates (jumping up ~8%), enabling board to present it as a key metric for obtaining bridge funding.• Led creation of income statements and key transactional and user engagement metrics report, which helped raise $16M in Series B funding.

Bengaluru, Karnatka, In

-> Youngest member on core team of 10 engineers (chosen from 200 employees on the project) to develop an insurance application for a large European financial conglomerate.-> Negotiated with counterparts in Brazil to customize software, allowing the module to be deployed in 1 month instead of the allocated time of 4 months, helping client save $86K on billing. -> Altered an algorithm to reduce the time to handle insurance claims by 40%.

Charlotte, North Carolina, Us

•Conducted research and developed code profiling tools for performance evaluation of Flight Management Systems (FMS).•Singularly planned, designed and developed three separate tools for the project and executed testing in less than five months. •The tools involved determining the depth of procedure/function call, determining the duration of execution for a procedure and finding the size of call stack for a given function at runtime.•For each of these tools, accompanying scripts were written using VBScript to automate the consolidation and sorting of data for different builds.

Master Of Business Administration - Mba, Decision Sciences, Technology Management

Bachelor Of Engineering (B.E.), Computer Science & Engineering

Education record