Santosh Roy

Business Development Executive

Gurugram, Haryana, India6 yrs 4 mos experience
Highly StableAI Enabled

Key Highlights

  • Achieved 35% boost in organizational profitability.
  • Led initiatives resulting in 40% reduction in MIS closure time.
  • Recognized as top 5% employee for exceptional contributions.
Stackforce AI infers this person is a Business Analyst with expertise in data-driven strategies and operational efficiency in the e-commerce sector.

Contact

Skills

Other Skills

AlgorithmsAuditAuditingBusiness AnalysisBusiness Intelligence (BI)Business ProcessBusiness StrategyBusiness financeCommunicationCustomer Relationship Management (CRM)Data AnalyticsData ModelingData ScienceData StructuresData Visualization

About

Summary As a Business Analyst with nearly 5 years of experience, I’ve successfully driven a 35% boost in organizational profitability and a 5% increase in revenue. My expertise spans R, Python, Pandas, Numpy, SQL, and Power BI, with a strong focus on supply chain management and inventory oversight. Recognized with the prestigious 'Most Impactful' award, I’m proud to be among the top 5% of employees for my exceptional contributions to the firm's success. Lenskart I specialize in driving business impact through data-driven strategies. In my recent role, I collaborated with Business and Operations teams to implement advanced forecasting techniques using Power BI and SQL, achieving a 3% boost in EBITDA. I led due diligence for a ₹450 crore omni-channel eyewear business, leveraging Redshift SQL and Excel to manage risk and ensure compliance. By developing an automated Power BI dashboard with MySQL, I reduced MIS closure time by 40%, enhancing operational efficiency. Additionally, I directed the creation of a revenue management dashboard using Power BI and DAX, streamlining investor KPI reporting. Convosight I have a proven track record of leveraging advanced analytics to drive significant business results. At Facebook, I boosted revenue generation for Community Admins by 40% through the implementation of cutting-edge analytics. I collaborated closely with Product and Marketing teams to redesign and automate brand campaigns, leading to a 25% increase in client retention. Additionally, I streamlined analytical frameworks with the Marketing Team, which contributed to a 12% growth in customer loyalty metrics and enhanced campaign monetization. Executed data extraction and manipulation on extensive relational datasets of around 5 million rows. Developed advanced sentiment and emotion models using machine learning techniques like XG Boost, providing deep insights and interpretation of complex data patterns.

Experience

Noise

Business Finance Manager

Oct 2024Present · 1 yr 5 mos · Gurugram, Haryana, India · On-site

  • 1) Developed and implemented a Noise Product Scorecard model. This contributed
  • to the reduction of ~4 Cr in P&L impact for FY25 by optimizing decision-making,
  • identifying key performance gaps, and aligning product strategies with optimizing
  • business goals.
  • 2) Managed end-to-end distribution operations for Bose, overseeing ~₹8 Cr MOM
  • purchase orders and ~₹12 Cr in inventory valuation, ensuring timely fulfillment and
  • seamless coordination with suppliers and online marketplaces.
  • 3) Created the AOP for Bose's distribution model, P&L creation , MIS creation ,
  • aligning sales forecasts, inventory planning, and promotional strategies with overall
  • business objectives.
  • 4) Spearheaded the launch of new Bose products on Amazon and Flipkart, driving
  • visibility and sales, while executing strategic discounting initiatives and ensuring
  • strict compliance with brand and channel guidelines.
  • 5) Implemented a comprehensive ₹200 crore noise inventory optimization flow
  • system, which significantly improved inventory management and demand-supply
  • alignment.

Lenskart.com

Business Analyst

Sep 2021Oct 2024 · 3 yrs 1 mo · Gurugram, Haryana, India · On-site

  • 1) Collaborated with Business and Operations teams, to assess inventory aging
  • dynamics, implementing forecasting techniques using Power BI and advanced SQL
  • window functions. This initiative led to a notable 3% increase in EBITDA, demonstrating
  • expertise in strategic forecasting and financial performance enhancement.
  • 2) Led due diligence for a 450 crore omni-channel eyewear business, evaluating risk
  • factors through analysis of Redshift SQL databases and Excel. Ensured compliance with
  • end-user standards, facilitating informed decision-making.
  • 3) Established cross-functional collaboration between business and technical teams to
  • enhance ERP processes. Developed an automated Power BI dashboard with MySQL
  • queries, reducing MIS closure time from 20 days to 12 days and improving operational
  • efficiency by 40%.
  • 4) Directed the development and deployment of a revenue management Power BI
  • dashboard using DAX queries and relational databases such as MySQL and PostgreSQL.
  • This effort accelerated investor KPI reporting by 47%, reducing the reporting timeframe
  • from 15 days to 8 days.

Convosight

2 roles

Data Analyst

Feb 2020Aug 2021 · 1 yr 6 mos · Delhi Area, India

  • Enhanced revenue generation for Facebook Community Admins
  • by implementing advanced analytics resulting in a 40% increase
  • in group monetization.
  • Collaborated with Product and Marketing team to redesign and
  • automate Brand campaigns, driving a 25% increase in client
  • retention.
  • Streamlined automated analytical frameworks with Marketing Team
  • which directly facilitated to a 12% growth in customer loyalty

Data Science Intern

Nov 2019Jan 2020 · 2 mos · Delhi Area, India

  • · I have done reporting and dashboard creation for different brand's on Content Marketing.
  • · I am working on Sentimental Analysis Model for will go for production for the Saas product of
  • our company which is
  • Convosight In the Sentimental Analysis.
  • · I have done data tagging , data visualisation for the model.
  • · I have done Amazon Scraping for the reviews in python.
  • · I am the owner of one of the Google Sheet of this company where Brand's team see there
  • facebook post Insights
  • and it was built through Advanced Excel Formula's

Chegg india private ltd

Subject Matter Expert-statistics

Jul 2019Nov 2019 · 4 mos

Education

University of Kalyani

Master's degree — Mathematical Statistics and Probability

Sep 2017Sep 2019

University of Kalyani

Master of Science — Statistics

Jan 2017Jan 2019

University of Calcutta (maulana azad college)

Bsc honours — Statistics

Jan 2014Jan 2017

Bhai parmanand vidya mandir, delhi

Higher secondary education

Stackforce found 100+ more professionals with Algorithms & Audit

Explore similar profiles based on matching skills and experience