Shivam Keshri

Data Analyst · Aspiring Data Engineer · Builder of AureoStays

Work Experience

Elivaas

Aug 2025 – Present

▸Developed and automated a Daily Business Health Tracker for key business channels (B2B, B2C, Supply, Website) using Google Apps Script, delivering timely executive-ready reporting that enabled data-driven decision-making for senior management.
▸Designed and maintained monthly performance dashboards for B2B and B2C channels, translating complex operational data into clear, compelling management presentations — contributing to a 2.8x revenue increase from September to December.
▸Organised and presented property- and location-level performance analyses to cross-functional stakeholders, closing revenue gaps and driving a 42% property-level and 35% location-level revenue increase between September and December.
▸Managed end-to-end pricing operations by maintaining and updating property rate plans in PostgreSQL, ensuring data accuracy and competitive positioning across all platforms.
▸Executed targeted promotional campaigns and tracked conversion metrics, improving direct channel revenue by 18% over a quarter through structured analysis and iterative recommendation cycles.

National Institute of Technology, Jaipur

2021 – 2025

Data & Analytics Tools

SQL / PostgreSQLPower BIMetabaseRedashMixpanelGoogle Analytics

Presentation & Reporting

PowerPointExcel (Pivot Tables, Advanced Formulas)Google SheetsDashboards

Collaboration & PM Tools

SharePointGoogle Apps ScriptJupyter Notebook

Business Analysis

KPI TrackingFunnel AnalysisCohort AnalysisA/B TestingBusiness Performance Reporting

Languages

PythonSQL

Project Management

Executive Ad-hoc ReportingCross-functional CoordinationProcess ImprovementDocumentation

Data Engineering Portfolio Project

2026

▸Built a production-grade ETL pipeline where every guest booking flows through a FastAPI backend into a structured PostgreSQL database with atomic transactions and double-booking prevention.
▸Designed a 4-table schema (properties, inventory, guests, bookings) with generated columns, price snapshotting, and inventory-based availability tracking.
▸Built a live analytics dashboard at /dashboard showing real-time revenue, occupancy, and booking data — demonstrating the full Extract → Transform → Load cycle.
▸Deployed frontend on Vercel, API on Render, and database on Supabase with transactional email via Resend.

Next.jsFastAPIPostgreSQLPythonSupabaseTailwind CSSMetabaseRenderVercel

▸

All India Rank 13,000 in JEE Mains 2021, competing with approximately 1 million students nationwide.