Developed a client tracker to help users manage client relationships through a structured lead-to-deal progression pipeline. The application centralizes client data and provides clear visibility into each stage of the pipeline, enabling users to prioritize leads, track negotiations, and manage ongoing clients more effectively.

The project includes secure user authentication, full CRUD functionality for client management, and a personalized dashboard for tracking client activity and status. A data visualization component was also implemented to provide insights into client distribution across platforms and pipeline stages.

View Source Code

Designed a CRM-based client portal for Roya Designs to streamline client communication and improve operational efficiency. Conducted systems analysis and designed a centralized solution, including database schema development, use case and sequence diagrams, and a UI prototype in Figma.

UI prototype screenshots are shown below.

Completed Harvard's CS50: Introduction to Computer Science, covering computational thinking, algorithms, data structures, and full-stack fundamentals. Applied programming concepts across C, Python, SQL, and JavaScript.

Applied Python for data wrangling, aggregation, and visualization. Worked with DataFrames to clean and transform data, merge multiple datasets, build pivot tables, and generate visual insights using libraries such as Pandas, Matplotlib, and Seaborn.

Applied R for data wrangling, exploratory analysis, and visualization. Performed data transformation, joins, and missing value handling, and developed a linear regression model to analyze structured datasets.

Applied SQL to query and analyze relational databases using SELECT, GROUP BY, ORDER BY, HAVING, and INNER JOIN. Performed data extraction, aggregation, and transformation within a relational database environment using DBeaver.

Applied Power BI to clean, model, and visualize structured datasets through interactive dashboards. Built relational data models and applied DAX measures, calculated columns, and moving average analysis to evaluate financial performance metrics and generate insights.

Applied Tableau to explore, clean, and visualize structured datasets through interactive dashboards. Built KPI dashboards and applied calculated fields, forecasting, parameterized controls, and multi-source data analysis to evaluate business performance and support decision-making.

Developed practical Excel skills in data analysis and visualization through hands-on business challenges. Built PivotTables and interactive dashboards, and applied lookup functions, conditional logic, and data modeling techniques, with introductory exposure to Power Query, Power Pivot, and VBA.