Portfolio.

Data Analyst/Scientist (Freelance)

Nov 2024 – Present

1. Sustainability Analyzer Tool
• Cleaned and preprocessed 10M+ rows of data using Python (Pandas, NumPy) to generate actionable insights for sustainability analysis.
• Developed an interactive Tableau tool with dashboards displaying KPIs, carbon emissions trends, and sustainability scores with YoY comparisons and industry benchmarks.
• Automated reporting with export options, reducing manual effort by 10-12 hours per month and providing real-time insights for data-driven decision-making.
2. Budget Optimization Tool
• Cleaned, combined and preprocessed 12+ CSV files with 5M+ rows using Python by removing duplicates, handling outliers, and normalizing data for accurate analysis.
• Developed an interactive Excel dashboard to visualize budget distribution, YoY comparisons, growth trends, sales forecasts, and cash flow projections with actionable insights.
• Implemented "What-If" simulation scenarios, enabling the company to model revenue changes and budget adjustments, improving budgeting accuracy by 40% and enhancing budget allocation.

AI and Data Analyst (Contract) - Data Bridge (Oman)

Aug 2024 – Oct 2024

1. AI Band Project
• Designed and implemented a SQL database for Omani songs and lyrics, enabling structured storage and efficient retrieval.
• Preprocessed audio by removing background noise, normalizing frequency and sampling rates, and extracting features (e.g., MFCCs, spectral, tonnetz, tempo).
• Utilized pre-trained models like Mellotron and RAVE to generate music samples.
• Applied correlation analysis and hypothesis testing to identify impactful audio features and optimize training datasets.
2. Admin Dashboard Project
• Developed a secure Django-based web application with user authentication, analytics, and full admin control features (CRUD operations, request approvals, price settings, chat monitoring).
• Built backend synchronization with the main app and external PostgreSQL database via APIs.
• Conducted A/B testing on UI/UX features for new users; used statistical significance testing (Z-test) to compare groups. Improved early user engagement by 30%.
• Documented backend and API processes for seamless collaboration and future development.
3. Database Architecture for an App
• Designed a robust architecture integrating external servers, PostgreSQL databases, and multiple web applications.
• Implemented API-driven data flow for CRUD operations and real-time notifications via email, SMS, and push notifications.
• Identified and resolved database issues, ensuring on-time project delivery under tight deadlines.

AI Data Dashboard Developer (Contract) - Data Bridge (Oman)

June 2024 – July 2024

• Developed a comprehensive demo for the "AI Dashboard" project, integrating web scraping, data cleaning, sentiment analysis, SQL data storage, and a Chatbot-like interface using Streamlit, Llama 2, and mBERT, securing the project for the company.
• Designed and implemented a meeting verification app in Streamlit, leveraging Excel for data cleaning and unique ID generation, reducing manual processing time by 10-11 hours.
• Automated messaging and document distribution processes, cutting down manual work by 3-4 days.

Freelancer - Portfolio Website Creation

Feb 2024 – May 2024

• Managed 5 clients over 3 months, delivering tailored portfolio websites and ensuring client satisfaction through clear project scopes and regular meetings.
• Established clear communication channels and developed an efficient onboarding process to understand client needs and expectations.
• Implemented business strategies in project management, including contract negotiation, invoicing, and documentation.

Data Analyst Intern – Nexus Info

April 2024 – May 2024

• Conducted Exploratory Data Analysis (EDA) on the Iris dataset with Python (Pandas, MatPlotLib, Seaborn), showcasing skills in preprocessing, statistics, and visualization.
• Created dynamic Power BI dashboards for Iris Classification and weather analysis, utilizing DAX measures, KPIs, and navigation.
• Applied correlation and regression analysis to 2.2M+ rows weather dataset, highlighting strong statistical and machine learning capabilities.

Business Analytics Intern – Cognifyz Technologies

Feb 2024 – March 2024

• Leveraged Python (Pandas, Matplotlib, Seaborn) to perform EDA on investment avenues data, extracting actionable insights.
• Employed Power BI's Power Query and data groups for effective data preprocessing, facilitating the creation of a dynamic dashboard featuring demographic insights, investment avenue preferences, and key motivations for investment.
• Demonstrated the significance of data-driven approaches in optimizing capital allocation and strategic planning processes.

Data Analyst Intern – KultureHire

Dec 2023 – Feb 2024

• Excel: Utilized VLOOKUP, INDEX, MATCH, Pivot Tables, Conditional Formatting, and Macros for creating comprehensive dashboards.
• Power BI: Applied Measures, Power Query, and data groups to create dynamic dashboards from multiple tables (each containing over 3000 records).
• Collected data through Google Forms, conducted MYSQL-based analysis (including Joins, CTEs, Window Functions, CASE), created dashboards in Power BI, and presented insightful recommendations to the CEO/Founder.

Data Analyst Intern – CognoRise InfoTech

Jan 2024

• Conducted exploratory data analysis on a cereal dataset using Python (Pandas, NumPy, Matplotlib, Seaborn) for nutritional insights.
• Leveraged PostgreSQL (CASE statements, aggregations, window functions) to analyze 8500+ retail rows and designed a PowerBI dashboard for Indian unemployment trends from raw data.
• Selected as “Best Performer” for the Jan-Feb batch.

Data Analyst Intern – Psyliq

Dec 2023 – Jan 2024

• Analyzed a 100,000+ row diabetes dataset using PostgreSQL, extracting key insights for enhanced healthcare data understanding.
• Manipulated a 4000-employee dataset in Excel, utilizing VLOOKUP, INDEX, MATCH, and Macros to streamline processes and boost efficiency.
• Conducted detailed analysis of a 4400+ row HR dataset with Excel and Power BI (DAX, Relationship Establishment, Data Visualization). Delivered actionable insights for informed decision-making.

Data Analyst Intern – MeriSkill

Nov 2023 – Dec 2023

• Analyzed 185,000+ rows of sales data using Power BI, identifying trends, top-selling products, and calculating revenue metrics. Used data manipulation for effective visualizations, aiding strategic decision-making.
• Cleaned and transformed HR data in Power BI, including data grouping, column operations and duplicate handling. Utilized Power BI for visualizing correlations between HR factors, enhancing talent management and organizational performance.

Student Researcher – Lovely Professional University

Jun 2020 - May 2023

• Published two impactful scientific papers in international journals during undergraduate and postgraduate studies.
• Conducted rigorous mathematical analysis using MATLAB and Excel, presenting findings at global conferences like RAFAS 2021 and RAFAS 2023.

Publications

• Singh, K., Kashyap, M. “Memory Effects on Rayleigh Waves Propagation in a Micropolar Thermoelastic Half Space”. Mech. Solids 58, 1228–1238 (2023).
• Kashyap, Muskan, and Sukhdev Singh. “A Study of Bicomplex Gamma and Riemann Zeta Functions and their Conjugations.” Journal of Physics: Conference Series. Vol. 2267. No. 1. IOP Publishing, 2022.

Private Tutor (Self Employed)

Jan 2019 – May 2021

• Empowered 15-20 high school students (grades 9-12) through targeted Mathematics tutoring, achieving a noteworthy 15-20% improvement in academic performance.
• Applied data-driven insights to customize lesson plans, resulting in consistent marks between 75-90 and earning positive feedback from students and parents, showcasing adept analytical and communication skills.