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
Gwalior06-2023
Certification of Data Analytics - Data Analytics
Kanishka Infotech
Gwalior01-2023
Bachelor of Science -
IHM Panipat
Panipat10-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
Similar Profiles
Gopi Krishna VGopi Krishna V
Executive Accountant at Ooms Polymer Modified Bitumen Pvt LtdExecutive Accountant at Ooms Polymer Modified Bitumen Pvt Ltd
Saurabh RajSaurabh Raj
Sales Executive at Ooms Polymer Modified Bitumen Private LimitedSales Executive at Ooms Polymer Modified Bitumen Private Limited
Bernadette HilarioBernadette Hilario
HOMECARE/ CAREGIVER at Renata Ooms, Jonathan OomsHOMECARE/ CAREGIVER at Renata Ooms, Jonathan Ooms
Kuljit SinghKuljit Singh
Head (Director), Business Transformation & Risk Control at AIS Info SourceHead (Director), Business Transformation & Risk Control at AIS Info Source
Girish MisraGirish Misra
Director – Operations at FareportalDirector – Operations at Fareportal