Khem Karan Sharma

Business Analyst

Faridabad, Haryana 2+ yrs exp 83 · Excellent

About

Business Analyst with experience driving data-informed business decisions through pricing analytics, BI dashboards, process automation, and ETL pipelines in a B2B travel environment. Comfortable across the full analytics stack — from PostgreSQL and Power BI to AWS Lambda and Google Apps Script, delivering solutions used daily by management, sales, and HR teams.

Skills & Expertise (14)

SQL Advanced

8.5/10

Years Exp

Postgresql Advanced

8.0/10

Years Exp

Advanced Excel Advanced

8.0/10

Years Exp

Power BI Advanced

8.0/10

Years Exp

Python Intermediate

7.5/10

Years Exp

Pandas Intermediate

7.0/10

Years Exp

Google Sheets Intermediate

7.0/10

Years Exp

Google Apps Script Intermediate

7.0/10

Years Exp

Matplotlib Intermediate

6.5/10

Years Exp

Looker Studio Intermediate

6.5/10

Years Exp

Seaborn Intermediate

6.0/10

Years Exp

ETL Pipelines Intermediate

6.0/10

Years Exp

AWS Lambda Intermediate

5.5/10

Years Exp

PyInstaller Intermediate

5.0/10

Years Exp

Work Experience

Business Analyst 1

Yutrp

Jul 2024 - Present

Analyzed international vs. domestic sales performance; findings drove a strategic shift to international-only queries, maintaining revenue targets at improved margins over 6 months. Built GMV, TAT, and KPI dashboards in SQL, Excel, and Power BI (DAX, star schema), cutting reporting time by ∼35%; presented insights to management for operational decisions. Processed 1M+ row datasets in PostgreSQL (CTEs, window functions, multi-table joins) to extract, clean, and validate booking and pricing data. Automated reporting workflows via Google Apps Script, reducing manual effort by ∼40% and improving stakeholder turnaround time. Built travel quote calculators automating cost computation across 20+ destinations, improving sales team quote speed.