Summary
Overview
Work History
Education
Skills
Timeline
Generic

NEERAJ PATHAK

Bengaluru

Summary

Analytics professional with 6 years + of work experience currently working as Business intelligence engineer for Amazon seller lending business with previous experiences in the analytics team of social commerce and Full stack food delivery startups. My expertise lies in coherently using my technical and leadership skills to maximize efficiency, minimizing expenditure, providing relevant dashboards and keenly analyzing data to improve processes.

Overview

7
7
years of professional experience

Work History

Business Intelligence Engineer

Amazon
12.2020 - Current
  • Updating established dashboards through Quicksight used by 40+ product and marketing users across the world in Amazon Seller lending vertical
  • Maintaining existing data pipelines, creation of new data pipelines for critical reports through ETL and big data tools during normal and oncall activities.
  • Created 10+ Looks in Looker and maintaining explores by adding 120+ metrics to help stakeholders self-serve with ad hoc data requests.

Business Analyst

Amazon
  • Owned the instrumentation of tables for the new registration flow for IN sellers on Amazon and documented specific details of new table design which captured seller activities.
  • Deep dived to find data discrepancies in new table in initial phases of dialup and worked with Tech to resolve the same
  • Created denormalized and aggregated layers of tables through ETL helping the product and other partner teams to take action during dialup phase
  • Created a dashboard at 10% dialup which helped to report metrics to IN leadership and was critical for further dialup alignment
  • Due to delay in enabling spoofing to registration pages, built a near real-time dashboard for 90+ associates which allowed them to view detailed Seller activities helping them to effectively debug issues when calling to sellers
  • Due to this new flow, our launch rate improved by 48bps and time to register improved from 3.2 days to 24 mins.

Data Analyst

Amazon
  • Built business dashboard for old registration flow extensively used by 50+ unique users and helped save ~50 man-hours/wk across levels in org as it gave freedom of dissecting the data in just a few clicks and no query run time (saving approx 1.5MM INR annually)
  • Assisting seller support team in lead prioritization models 1) Goldmine model - stopping leakage of 10k annualized leads 2) Post QR launch score which provided added conversion of ~1k annualized launches (70MM annualized GMS)
  • Analysis on problems faced by sellers using vernacular languages while contacting seller support which laid foundation for voice notes feature in Seller registration flow (+640 bps launch conversion improvement)
  • Maintaining reports and metrics for business reviews (weekly/monthly), assisting team in projecting goals for OPs, owning requests of program/product for funnel drop and product improvements, correcting/creating tables for reporting numbers
  • Mentoring 2 BAs in a partner team by helping them in their assigned tasks with SQL, table information, and different tools.

Data Analyst

Shop101(Glance)
12.2019 - 12.2020
  • Providing data visibility through showing trend of metrics of each department through widgets /bar pie charts on homegrown tool
  • Development of Real-time tracker on Kibana which shows the major metrics compared to previous days at the same time and overall
  • Creating dashboard for Product, Growth and founders and providing relevant insights for e.g., reason for high cancellation, fraud
  • Building all of Logistics dashboards detailing First Mile, Intransit and Last Mile
  • Preparation of cohorts for giving credits to RS and dashboard for assisting marketing spend of Growth team.

Business Analyst

Eatclub Brands(Box8)
01.2019 - 12.2019
  • Automating existing processes, making dashboards/reports for reconciliation whenever required by accounts or operations team
  • Analyzing the Overall sales and ensuring correct MDR Reduction by over 15 payment partners such as Zomato by identifying any inconsistencies and disputing the same and overlooking MDR reduction of 10 partners saving revenue of over 2lac/year
  • Overlooking Rent analysis of over 120 outlets and 180 staff rooms spread over 4 major cities and seeing any recovery of deposits, vendor payments and closing necessary assets thus reducing yearly losses by over 25 lacs
  • Optimizing and automation of existing processes in the finance through SQL, google apps script, and python whenever necessary.

Analyst

Searce Inc
10.2017 - 11.2018
  • Dealt with accrual accounting of various shipments across US and the world done by CEVA, audit the entries and prepare Excel reports
  • Liaising with US and overseas billing team to clear all pending errors done in the transaction flow across various CEVA offices

Education

B.E. Civil -

Maharashtra Institute of Technology, Pune
06.2016

Skills

  • SQL
  • Advanced Excel
  • AWS Quicksight
  • ETL (Extract,Transform,Load)
  • Looker
  • Spark SQL
  • Tableau
  • Google sheets
  • Python(Pandas, NumPy)
  • CI/CD deployment

Timeline

Business Intelligence Engineer

Amazon
12.2020 - Current

Data Analyst

Shop101(Glance)
12.2019 - 12.2020

Business Analyst

Eatclub Brands(Box8)
01.2019 - 12.2019

Analyst

Searce Inc
10.2017 - 11.2018

Business Analyst

Amazon

Data Analyst

Amazon

B.E. Civil -

Maharashtra Institute of Technology, Pune

Similar Profiles

CREATE PROFILE
NEERAJ PATHAK