Summary
Overview
Work History
Education
Skills
Affiliations
Certification
Languages
Timeline
Generic

Ojas Agrawal

Gurgaon

Summary

Analytical Operations Analyst specializing in data visualization and process optimization. Expertise in developing dashboards that enhance decision-making and improve operational efficiency. Proficient in Microsoft Excel, Google Sheets, AppSheet, WhatsApp automation workflows, and Tableau, equipped to tackle new challenges in a dynamic environment.

Overview

2
2
years of professional experience
1
1
Certification

Work History

Operations Analyst

Ooms Polymer Modified Bitumen Pvt. Ltd.
Gurgaon
10.2023 - Current
  • Translated raw data into meaningful insights using advanced statistical techniques.
  • Leveraged SQL queries to extract, transform, and load datasets efficiently.
  • Collaborated with cross-functional teams to streamline project workflows and communication.
  • Developed interactive dashboards using Power BI for impactful data visualization projects.
  • Built visualizations that enabled quick interpretation of complex analyses.
  • Analyzed operational data to identify trends and enhance process efficiency.
  • Assisted in implementing new inventory management software tools via Google AppSheet.
  • Provided data-driven solutions to support strategic decision-making.

Business Analytics Intern

Marche Ricche Pvt. Ltd.
Gurgaon
03.2023 - 05.2023
  • Conducted market research to identify customer preferences and behaviors.
  • Reviewed and analyzed customer data to uncover trends in consumer behavior.
  • Created visualizations using Tableau and Power BI for effective communication of findings.
  • Presented analytical findings to stakeholders through engaging visual formats.
  • Supported data cleaning and validation efforts to ensure accuracy in reporting.
  • Participated in project meetings to align on analytics strategies and objectives.
  • Assisted with presentation development summarizing outcomes from analytical exercises.
  • Maintained an organized library of relevant documents, including reports and charts.

Education

MBA - Business Analytics

ITM University
Gwalior
06-2023

Certification of Data Analytics - Data Analytics

Kanishka Infotech
Gwalior
01-2023

Bachelor of Science -

IHM Panipat
Panipat
10-2020

Skills

  • Advanced Excel
  • Data cleaning
  • Data analysis
  • SQL querying
  • Data visualization
  • Dashboard development
  • Project coordination
  • Reporting
  • Pabbly workflow
  • Google AppSheet
  • Power BI

Affiliations

Financial Analysis & Reporting — Marche Ricche Pvt. Ltd.

Profit & Loss Analysis using MS Excel

  • Developed an Excel-based financial model to analyze revenue trends and profitability.
  • Managed large datasets from Amazon sellers across multiple stores, utilizing complex formulas and macros to streamline data processing and analysis.
  • Improved forecasting accuracy by 20% and identified cost-saving opportunities that contributed to a 15% increase in profit margins.

Profit & Loss Reporting using Power BI

  • Created an interactive Power BI dashboard to monitor company-wide financial performance and highlight key drivers of profitability.
  • Consolidated financial data from multiple Excel sheets and text files into a unified data model for comprehensive analysis.
  • Designed dynamic visualizations including charts, graphs, and KPIs, leveraging DAX formulas to create advanced calculations and metrics for actionable business insights.

Technical Skills:

  • Excel (Advanced formulas, Macros, VBA)
  • Power BI (Data modeling, DAX, Visualization)
  • Data consolidation and ETL from multiple sources

Certification

  • Certification of Data Analytics

Languages

Hindi
First Language
English
Upper Intermediate (B2)
B2

Timeline

Operations Analyst

Ooms Polymer Modified Bitumen Pvt. Ltd.
10.2023 - Current

Business Analytics Intern

Marche Ricche Pvt. Ltd.
03.2023 - 05.2023

MBA - Business Analytics

ITM University

Certification of Data Analytics - Data Analytics

Kanishka Infotech

Bachelor of Science -

IHM Panipat
Ojas Agrawal