Vaibhav Raj - Analyst Intern - Rubixe

Summary

Detail-oriented analyst skilled in Power BI, SQL, and advanced Excel functions. Successfully streamlined reporting processes, reducing time and enhancing data visualization for strategic decision-making.

Skilled in extracting, transforming, analyzing, and visualizing data to generate insights and support data-driven decision-making.

Work History

Analyst Intern

Rubixe

Bengaluru

12.2025 - Current

Processed and standardized a dataset of over 100,000 rows from multiple regions to support weekly analytics enabling business teams to track KPIs across geography and time.

Designed smart Excel functions embedded with lookup functions and pivot logic, saving 40% of reporting time.

Developed and maintained Power BI dashboard venue trends, customer mix, and monthly performance regularly used by managers and analytical business units.

Collaborated with 4 analysts and 2 senior managers to define and validate BRDs and FRDs, improving report reliability and strategic alignment.

Analyzed data sets to identify trends and support strategic decisions.
Assisted in preparing reports for management review and team presentations.
Partnered with team members to improve data collection processes.

Education

BBA - (H)

T.M Bhagalpur University

Bhagalpur,Bihar

07-2024

Skills

Programming & Querying: SQL

Data Visualization Tools: Advanced MS Excel, Power BI, Tableau

Analytical Abilities: Data cleaning, Exploratory Data Analysis (EDA), Descriptive Statistics, Extract-transform-load (ETL)

Data analysis
Power BI

Excel functions
Data warehousing

Affiliations

* Amazon Sales and Unit Analysis Power BI. Analyzed the behavior of 132,992 e-commerce customers and customer attrition based on total sales, product type, and seller count. Engineered new features, including customer segmentation. Generated 10 visualizations (slicers, box plots, visual charts) to highlight order status segments. Revealed that 38% of churned users were on monthly contracts with a tenure of less than 3 months, suggesting early engagement strategies.

Timeline

Analyst Intern

Rubixe

12.2025 - Current

BBA - (H)

T.M Bhagalpur University