BeReal. logoBeReal. Externship via Extern
Bharat Ravilla portrait

Early-career strategist focused on operations and people analytics

Completing an Amazon Operational Strategy & People Analytics externship while preparing to begin my professional career.

Work samples

Portfolio of externship projects focused on operational strategy and people analytics work completed during the Amazon program.

  • BreakBulk Case Study
    BreakBulk Case Study

    Led a 4-person team to develop an IoT-powered berthing solution, targeting a 15% increase in port operational efficiency; applied Agile project management principles; presented strategic recommendations to 50+ industry stakeholders.

  • Relational Database Design & Analytics with SQL
    Relational Database Design & Analytics with SQL

    Designed and deployed a SQL database to structure and analyze 3,000+ records; optimized SQL queries and schema design; applied database architecture and data governance best practices.

    SQL

About me

Completing an Amazon Operational Strategy & People Analytics externship while preparing to begin my professional career.

I am Bharat Ravilla, an early-career professional completing the Amazon Operational Strategy & People Analytics externship. I focus on operational strategy and people analytics work, and I am building experience through project-based externship assignments while preparing to start my career.

Externships

BeReal Product Management Externship

In progress

Experience

Commercial Project Manager Extern

Siemens · June 2026 – August 2026

Data Analyst Extern

Deloitte · May 2026 – July 2026

Inventory Specialist

Dick’s Sporting Goods · May 2023 – November 2024

Academic Coach

The Stanford Academy · February 2021 – August 2024

Education

University of Houston, Cullen College of Engineering

Bachelor of Science in Supply Chain and Logistics Technology · Class of 2025

Skills

Operational strategy (externship experience)People analytics (externship experience)Project-based problem solvingLearning and applied practiceSupply Chain

BreakBulk Case Study

Led a 4-person team to develop an IoT-powered berthing solution, targeting a 15% increase in port operational efficiency; applied Agile project management principles; presented strategic recommendations to 50+ industry stakeholders.

View all work

Relational Database Design & Analytics with SQL

Designed and deployed a SQL database to structure and analyze 3,000+ records; optimized SQL queries and schema design; applied database architecture and data governance best practices.

SQL
View all work

Business Data Analysis & Insights with Excel

Performed exploratory data analysis on 5,000+ business records; leveraged pivot tables, VLOOKUP, and dashboards; automated Excel-based analysis to improve reporting efficiency.

ExcelVLOOKUPPivot tablesDashboards
View all work

The Fresh Connection Simulation

Led a team in a competitive supply chain simulation, driving process improvements across procurement, sales, and operations and improving simulated business performance by 40% ROI.

View all work

✅ Verified by Extern · ⏱️ In progress

BeReal Product Management Externship

Discover how product teams at social apps like BeReal design for authenticity while driving user growth. In this externship, you’ll explore what keeps users coming back— benchmarking competitors, analyzing engagement features, and designing your own growth-driven app feature. You’ll learn how to balance product innovation with BeReal’s unique mission of real, unfiltered connection. Perfect for those interested in product management, UX strategy, or social media innovation, this experience gives you a hands-on look at how product teams grow platforms without losing their core values.

DesignUI/UXProduct Management

Overview

The externship examined product and growth approaches used by social apps, focusing on benchmarking competitors, analyzing engagement features, and designing a growth-oriented feature concept. Work combined comparative analysis with a feature design artifact. The deliverables included a competitor benchmark and a feature concept proposal.

BeReal Product Management Externship

What I've accomplished

I produced a five-stage user journey map that recorded actions, thoughts, and feelings at each stage, plus a PM problem statement identifying prompt-trigger anxiety and a proposal to reduce it.

Project breakdown

During the BeReal externship I built a five-stage user journey map, recorded users actions/thoughts/feelings at each stage, and produced a PM problem statement identifying prompt-trigger anxiety and a proposal to reduce it to improve completion and engagement.

Google Sheets
Access

During the BeReal benchmarking task I listed core product features (Daily notification, Dual-camera capture, Post-to-view friends feed, Discover, Memories, BeReal Wrapped), described each feature, and connected each to retention or MAU-growth mechanisms.

Google Docs
Access
View all work