Ujjwal Sharma

Logo

View the Project on GitHub usujjwals/ujjwalsharma.github.io

Business Analytics Graduate Student | Data Science & Analytics Enthusiast

LinkedIn URL

Technical Skills:- Python, SQL, R Script, Data Mining, Machine Learning, Statistics, Database Management Systems, Microsoft Office.

EDUCATION

WORK EXPERIENCE

Program Analyst/Coordinator @ BACL Corp (Jan 2023 - Jan 2024)

Student Assistant @ Institute of Social Research (Mar 2025 - Jun 2025)

INTERNSHIP EXPERIENCE

Project Assistant @ B.O.K Ranch (Jan 2022 - May 2022)

Projects

Database Property Management System (April 2025 - May 2025) URL Designed and implemented both an operational OLTP database and a star-schema analytical data warehouse for residential property management. Developed SQL-based ETL pipelines to incrementally load and transform leases, maintenance requests, inspections, staff assignments, and client data, with Type 2 slowly changing dimensions for full historical tracking. Built data-quality checks and pre-built analytical views (occupancy, maintenance turnaround, revenue trends), then created a BI report to visualize key operational and financial metrics. BI design overview

CERTIFICATION

Data Analyst in Python @ DataCamp (Issued Oct 2024) URL

This Certification went from the basics to the advanced level of data analysis. I learned about various hypothesis testing and sampling methods. I also performed Exploratory Data Analysis using different Python tools: pandas, seaborn, matplotlib, numpy, and scipy.stats. Certificate of Completion