Aman Kohli - Business Analytics Professional

Projects

Power BI Dashboard 1

Comprehensive business intelligence dashboard providing real-time insights and analytics for data-driven decision making across multiple business metrics and KPIs.

Power BI Data Analysis Visualization

Power BI Dashboard 2

Advanced analytics dashboard featuring interactive visualizations, trend analysis, and performance monitoring tools for strategic business insights and reporting.

Power BI Interactive Reports Business Intelligence

R Shiny Dashboard

Interactive Entrepreneurial Insights Dashboard providing multidimensional analytics and visualizations to explore relationships between business characteristics, demographic factors, and entrepreneurial well-being across key performance indicators (KPIs).

Machine Learning R EDA

Skills & Tools

Programming

Microsoft SQL Server MySQL

MySQL

Project Management

Jira

Azure DevOps Asana

Asana

Tools

PowerBi

Tableau

SAS Studio Microsoft Suite

Microsoft Office Suite AWS

AWS

Google Cloud

Google Workspace

Professional Certifications

Professional Scrum Master I Certification

Professional Scrum Master I (PSM I)

Certified July 2025

Scrum Agile Project Management

Professional Experience

May 2025 – Sep 2025

Operations and Strategy Intern

Seaport Inn (Harbourview Hospitality Group), Cape Cod, MA

Consulted Harbourview Hospitality Group on implementing Lean Management practices, streamlining cross-property operations to reduce idle labor by 75%, optimize resource allocation, and align operational processes with KPI-based cost-efficiency targets
Reconciled financial records across 9 hotel properties and automated 80% of expense categorization in Excel, then built a dynamic Power BI dashboard to compare property-level expenses and identify cost-saving opportunities, recommending measures that reduced operating costs by 10%
Launched 20 Sojern email campaigns reaching 90,000 guests, achieving a 31% CTR and enhancing guest retention and engagement
Centralized daily performance reporting by building a lightweight on-prem SQL Server data mart using SSIS and Power Query from PMS, POS, and Excel sources, with Power BI Desktop views for occupancy and labor-to-revenue metrics, reducing manual consolidation from 5 hours per day to under 1 hour and enabling staffing adjustments that saved $85K annually
Built a 14-day bookings and F&B demand forecast in Python orchestrated via SQL Server Agent with SQL ELT and QA checks, improving MAPE by 25% and informing rate changes and targeted Sojern re-engagement that drove a $95K seasonal revenue uplift

May 2022 – Aug 2024

Marketing Data Analyst

Saas Cloud LLC, Delhi, India

Led a data-driven Reddit growth strategy following Google’s UGC policy update, generating $60K in revenue within 6 months with no ad spend
Created structured campaign datasets and collaborated with stakeholders to improve attribution visibility and budget optimization across platforms
Enhanced email funnel personalization using ActiveCampaign, driving a 27% open rate, 5% CTR, and 3% conversion
Planned, launched, and optimized paid social campaigns using Facebook Business Manager, conducting A/B tests on creatives and audiences to achieve a 20% improvement in CTR and a 15% reduction in CPA
Developed and deployed SEO and keyword strategy using SEMrush, growing organic search visibility to 2,000 monthly queries and increasing qualified inbound leads
Analyzed ad creative and placement trends across competitors, resulting in a revamped GTM plan and content refresh for Scribebuddy and Transcription.app

Marketing Projects

Amazon Affiliate Program

Strategic affiliate marketing initiative leveraging Amazon's platform to drive revenue through targeted product recommendations and optimized conversion funnels.

Affiliate Marketing Amazon Conversion Optimization

Mean Time

I enjoy performing standup comedy in my mean time.

Let's Connect

Ready to discuss opportunities, collaborations, or innovative projects? Let's connect!

akohli2@babson.edu +1 (339) 204-3976

Boston, MA