A

Amit Roy

Business Development Executive

Delhi, India11 yrs 10 mos experience
Most Likely To SwitchHighly Stable

Key Highlights

  • Reduced manual interventions by over 20 hours weekly.
  • Developed dashboards for critical decision-making.
  • Increased PAN India logins by 1.5% through quality SOP.
Stackforce AI infers this person is a SaaS Business Analyst with strong data analytics and visualization skills.

Contact

Skills

Core Skills

Data AnalyticsBusiness InsightsData VisualizationQuality AssuranceBusiness AnalyticsData ManagementAutomationBusiness DevelopmentManagement Information Systems (mis)

Other Skills

AirflowAnalyticsApache DruidApache SparkApache SupersetBusiness PlanningDAGData StructuresExtract, Transform, Load (ETL)FinanceGitHubGoogle Apps ScriptLeadershipMicrosoft ExcelOperations Management

About

As a skilled analyst with more than 7 years of industry experience, I specialize in collecting, organizing, interpreting, and disseminating various types of statistical figures. My expertise in providing realistic projections, establishing viable process strategies, and developing creative solutions to problems make me an energetic presenter with the ability to circulate information in a way that is clear, efficient, and beneficial for end users. In my current role as a Business Analyst at Zomato, I have successfully built data flow to push information to systems, reducing manual interventions by 20+ hours per week, and built Tableau dashboards that proactively and re-actively send reports to all levels of management, detecting anomalies before-hand. With a strong prioritization skill set and analytical ability, I aim to help achieve the goals of your company.

Experience

11 yrs 10 mos
Total Experience
2 yrs 4 mos
Average Tenure
6 yrs 6 mos
Current Experience

Zomato

5 roles

Senior Business Analyst

Promoted

Jan 2024Present · 2 yrs 4 mos

  • Spearhead the development and optimization of data pipelines and backend logic, focusing on cost per order and maintaining a balance between fleet supply and demand for a platform handling 300,000+ daily active riders and ~3.7 million orders per day.
  • Utilize Presto SQL, Python, Airflow, GitHub, and Superset to manage and enhance ETLs, automated reporting, and dashboard creation, delivering key insights to leadership teams.
  • Successfully saved 20% of daily bandwidth (including weekends) by automating routine operational tasks, significantly improving team efficiency.
  • Developed and maintained three major dashboards, used by city CEOs for critical decision-making related to gig-booking, serviceability loss, rain impact, login dip, order growth, and utilization trends.
  • Collaborate closely with program managers and cross-functional teams (finance, quality, supply, operations) to strategize, plan, and implement logic changes that enhance delivery partner performance and optimize cost efficiency.
AirflowApache SupersetVersion ControlApache DruidPrestoPython (Programming Language)+2

Business Analyst (Quality)

Promoted

Mar 2023Sep 2024 · 1 yr 6 mos

  • Gather information about products and processes by observations, with the help of stakeholders and team members, using related reports, etc.
  • Analyze business processes to understand the problems and their root causes, distinguish opportunities, and define areas that need improvement.
  • Based on the independent analysis, redefine the quality SOP and threshold to increase PAN India Logins by 1.5% (~15K Hrs of login per day)
Extract, Transform, Load (ETL)SQLAirflowMicrosoft ExcelTableauPython (Programming Language)+4

Business Analyst (Logs)

Oct 2022Feb 2023 · 4 mos

  • • Built data flow to push information to system depending upon data predicted by ML-model, which reduces the manual interventions and saves more than 20+ hours of manual work per week.
Extract, Transform, Load (ETL)DAGAirflowApache SparkPython (Programming Language)GitHub+3

Business Analyst (Finance)

Promoted

Jul 2020Sep 2022 · 2 yrs 2 mos

  • Built tableau dashboards which proactively and re-actively sends reports to all levels of management which also helping detect anomalies before-hand.
  • Built model to Reduce pilferage by 40% by applying segmentation in rider cash limit.
  • Gained valuable knowledge of customer service and risk analysis.
  • Designing automated dashboard for live business tracking with the help of R, SQL, Excel, Google Spreadsheet with the help of ETLs on different platform like Airflow DAG, R-Studio.
  • Conceptualize and redesign the script to calculate PAN India payouts more efficiently with 99.95% accuracy.
Extract, Transform, Load (ETL)AutomationData StructuresOperations ManagementData VisualizationApache Spark+5

Business Analyst (Growth)

Aug 2019Jun 2020 · 10 mos

  • Analyse business requirements and processes through various analysis and A/B testing resulting 10% uptake in Mx commission value.
  • Worked in Pan India growth team and helped in deriving many experiments to grow business and reduce burn.
Extract, Transform, Load (ETL)Management Information Systems (MIS)Data AnalyticsFinanceApache SparkBusiness Development

Spectrum

MIS Executive (For Zomato)

Jan 2019Jul 2019 · 6 mos · Gurugram, Haryana, India · On-site

Qualtech edge

Sr. MIS Excecutive

Jan 2018Jan 2019 · 1 yr · Gurugram, Haryana, India

  • Publishing daily MIS Reports with the MS excel & MS access.
  • Making P&L reports for pan India visibility to take business calls.
  • Calculating GPA Score for more than 300+ channels, agents & offices.
  • Reducing the existing reports TAT by 30% trough automation via VBA & MS Access.
  • Developed and implemented new strategies to existing reports to reduce TAT and increase accuracy and efficiency .
Management Information Systems (MIS)Data AnalyticsFinance

Ola (ani technologies pvt ltd)

MIS Executive

May 2015Jan 2018 · 2 yrs 8 mos

  • Monitoring Data for various Projects such as City Taxi, Local Rental & Outstation.
  • Maintains data as per requirement of management authority by use of various aspects like graphics, dashboard, pivot table etc. so we can easily come to know where we are?
  • Provide constructive feedback to ensure fulfillment rate.
  • Preparing daily schedules, creating daily reports such as booking dashboard, weekly iteration to control the Quality.
  • Assist in creating business reviews and join business reviews with Assistant Manager.
  • Performing studies on various reports to analyze and suggest improvements
Management Information Systems (MIS)

One point one solutions

Content Writer

Feb 2014Apr 2015 · 1 yr 2 mos

  • Creating and suggesting new forms and editing existing forms.
  • Prepared weekly and monthly Reports.
  • Conduct calibrations and attend calibrations with the client to make any changes or suggest improvements.

Education

GBSSS Motibagh

High School — Non Medical

Jan 2010Jan 2011

Stackforce found 100+ more professionals with Data Analytics & Business Insights

Explore similar profiles based on matching skills and experience