Nishant Kumar

Operations Associate

North Delhi, Delhi, India2 yrs 5 mos experience
Highly Stable

Key Highlights

  • Reduced quote preparation time by 70% through automation.
  • Achieved a 15% reduction in customer churn metrics.
  • Developed automated dashboards improving sales accuracy by 20%.
Stackforce AI infers this person is a Data Analyst with expertise in SaaS and Business Analysis.

Contact

Skills

Core Skills

Business AnalysisData AnalysisData ManagementData Visualization

Other Skills

Business Process AutomationChurn ManagementCohort AnalysisCustomer SatisfactionDescriptive AnalysisETL ProcessesETL ToolsExcelExcel DashboardsGoogle Apps ScriptGoogle Data StudioGoogle SheetsGrowth StrategiesLeadershipLooker

Experience

Globalfair

2 roles

Assistant Manager (Business Analysis)

Promoted

Dec 2022Aug 2024 · 1 yr 8 mos · Bengaluru, Karnataka, India · Hybrid

  • #Automated Quote Generation System Development -
  • +Spearheaded the development of a cutting-edge automated quote generation system using Google AppScript, SQL (with ETL processes), Excel, and Google Sheets. Revolutionized data retrieval and logistics cost calculation, seamlessly integrating comprehensive data analysis to refine pricing strategies. Achieved a remarkable 70% reduction in quote preparation time while significantly enhancing data accuracy and workflow efficiency.
  • +Provided actionable insights that supported strategic decision-making, driving notable improvements in team productivity and operational effectiveness.
  • #Data collection & Management -
  • +Streamlined data collection for Project RFQ by creating an advanced Google Sheets system with automated categorization using complex formulas and scripting, and subsequently migrated data management to MySQL with ETL processes, enhancing integration and workflow efficiency by 30%.
  • +Standardized data across customer churn metrics, achieving a 15% reduction in churn, regional order analytics, resulting in a 20% increase in orders, and product SKU information. Applied data wrangling techniques such as normalization and aggregation using SQL and Excel array formulas to improve overall data accuracy and consistency by 25%.
  • # Data Analysis & Visualization –
  • +Developed automated dashboards in Looker Studio, Power BI, and Google Sheets (Pivot). Conducted analyses like category wise Profit and Loss order, top-selling product identification, sales forecasting, market segmentation, and inventory turnover. Improved decision-making, leading to a 20% increase in sales accuracy and a 15% reduction in inventory costs. Delivered actionable insights through data visualization for strategic growth.
Google Apps ScriptSQLExcelGoogle SheetsData AnalysisData Visualization+5

Business Analyst

Feb 2022Nov 2022 · 9 mos · Bengaluru, Karnataka, India · Hybrid

  • #Orders Workflow Automation:
  • +Spearheaded the comprehensive implementation of Zoho Projects for order tracking, meticulously designing project timelines and workflows. Successfully implemented web-hooks and developed an in -built tracker to monitor task statuses and order positions. This initiative resulted in a 30% improvement in tracking efficiency and a 25% reduction in task completion times.
  • #Data Analysis & Visualization -
  • +Analyzed data to uncover trends, collaborated with teams on data-driven solutions, and designed dashboards for stakeholders. Mentored junior analysts, executed A/B tests, and ensured data quality and governance. Managed multiple projects, stayed current with industry trends, and communicated technical concepts effectively to non-technical stakeholders. Used - SQL, Excel and Python for analysis and Looker, PowerBI and Pivot for Visualization.
Zoho ProjectsSQLExcelPythonLookerPower BI+2

Shiprocket

Product Analyst Intern

Aug 2021Sep 2021 · 1 mo

  • Leveraged descriptive, cohort, segmentation, and predictive analyses to address churn. Utilized descriptive metrics for historical trends, cohort analysis to pinpoint retention patterns, segmentation to identify high -risk groups, and predictive modelling to forecast churn probabilities. Achieved a 10% reduction in churn rate through targeted retention strategies.
Descriptive AnalysisCohort AnalysisSegmentationPredictive ModellingData Analysis

Shiksha.com

Business Analyst Intern

Jan 2020Mar 2020 · 2 mos

Education

Delhi College of Engineering

Bachelor of Technology - BTech

Jan 2018Jan 2022

Delhi Technological University (Formerly DCE)

Bachelor of Technology - BTech

Aug 2018May 2022

Air Force Bal Bharati School

Higher Secondary(10+2)

Jan 2017Jan 2018

Air Force Bal Bharati School

10th CBSE

Jan 2016Present

Stackforce found 100+ more professionals with Business Analysis & Data Analysis

Explore similar profiles based on matching skills and experience