Summary
Overview
Work History
Education
Skills
Languages
Certification
Timeline
Generic

ROHAN ARORA

BHOPAL

Summary

Solutions-oriented business analyst possessing unique combination of business analysis, quality assurance testing and applications development experience in top-tier organizations. Solid sql query writing skills paired with familiarity of visualization tools and techniques. Successful provider of financial services with several years of comprehensive experience.

Overview

3
3
years of professional experience
1
1
Certification

Work History

Business Analyst

ICE COLD TRADERS
BHOPAL
06.2022 - Current
  • Supported alcohol shop tender bidding by collecting and analyzing sales data to forecast future sales and optimize bidding amounts over a 3-year period.
  • Enhanced inventory management through data analysis using Excel and SQL, ensuring efficient stock control and minimizing shortages or excesses.
  • Contributed to smooth business operations by providing data-driven insights that improved decision-making and operational efficiency.

Education

BBA - Business Administration

SRK UNIVERSITY
BHOPAL
08-2020

HIGH SCHOOL

ST JOSEPH COED SCHOOL
BHOPAL
06-2017

Skills

  • Data Analysis: Sales forecasting, inventory management, bidding optimization, trend analysis, business operations analysis, root cause analysis
  • Tools & Technologies: SQL, Microsoft Excel (advanced formulas, pivot tables, dashboards), Power BI / Tableau, Google Sheets
  • Data Management: Data cleaning, data preparation, data modeling (basic understanding), data-driven decision making
  • Visualization & Reporting: Creating dashboards, visual reports, and actionable insights for stakeholders
  • Soft Skills: Strong attention to detail, effective communication, cross-functional collaboration, time management, process improvement mindset, adaptability

Languages

Hindi
First Language
English
Upper Intermediate (B2)
B2
Punjabi
Beginner
A1

Certification

  • Data Analytics Virtual Job Simulation
    Deloitte | Forage
    Completed: [JUNE, 2025]
    Gained practical experience in data cleaning, sales performance analysis, and business insights presentation through real-world case simulations.
  • SQL (Basic) Certificate
    HackerRank | Issued: [APRIL, 2025]
    Demonstrated foundational knowledge in SQL queries, data retrieval, filtering, and aggregation.
  • SQL (Intermediate) Certificate
    HackerRank | Issued: [JUNE, 2025]
    Validated skills in advanced SQL concepts including joins, subqueries, window functions, and complex data manipulation.

Timeline

Business Analyst

ICE COLD TRADERS
06.2022 - Current

BBA - Business Administration

SRK UNIVERSITY

HIGH SCHOOL

ST JOSEPH COED SCHOOL

Similar Profiles

CREATE PROFILE
ROHAN ARORA