Skip to content
View mkyaduvanshi555's full-sized avatar
🎯
Job Hunting!
🎯
Job Hunting!
  • Indore

Block or report mkyaduvanshi555

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Maximum 250 characters. Please don't include any personal information such as legal names or email addresses. Markdown supported. This note will be visible to only you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
mkyaduvanshi555/README.md

Hi, I'm Mayank 👋

Data Analyst & Business Analyst: Bridging the gap between raw data and strategic business decisions

As a recent Computer Science graduate, I specialize in bridging the gap between technical data analysis and strategic business goals.

I am a hybrid analyst skilled in data-driven problem-solving, whether that means using Python and SQL to analyze complex datasets or defining clear business requirements (BRDs, UML, User Stories).

This portfolio details my projects, professional experience, and core competencies. I am actively seeking a full-time role where I can empower your organization to make smarter, data-driven decisions.


My Projects

  • Built a core recommendation logic by analyzing 500k+ transactions using Python (Pandas and Mlxtend Apriori algorithm).
  • Proved project ROI by simulating an A/B test and building a Tableau KPI dashboard, achieving a +6.29% lift in AOV and +4.84% lift in Conversion Rate.
  • Managed the full project lifecycle, identifying the core business problem (Low AOV) and authoring key BA artifacts (BRD, As-Is/To-Be, FRS, User Stories).
  • Performed complete data cleaning and analysis on Diwali sales data using Python (Pandas), Advanced Excel (Pivot Tables), and MySQL.
  • Identified key business insights, such as top customer segments (Females 26-35) and high-value states (UP, MH), to inform future marketing strategy.
  • Developed and published an interactive Tableau dashboard to visualize all findings for non-technical stakeholders.

My Professional Experience

Business Analyst Intern | New Talent Infotech (Jul 2025 – Oct 2025)

  • Developed comprehensive BRDs, SRSs, and User Stories from stakeholder requirements in an Agile/Scrum environment.
  • Conducted market analysis using Excel and presented data-driven recommendations to enhance their educational website and management system.
  • Created UML/BPMN process models and managed the project backlog using Jira.

Recruitment Analyst | Vastek Inc. (Sep 2022 – Dec 2022)

  • Managed the full recruitment cycle, handling all communication for US-based stakeholders and candidates.
  • Organized and tracked all recruitment data and candidate pipelines using MS Excel and Google Sheets.

My Technical Skillset

Data Analysis (Python)
Databases
Data Visualization
BA & Design Tools

My Core Competencies

Methodologies
Process Modeling
Core BA Skills




Generative AI


My Certifications


Connect With Me

LinkedIn    Outlook Mail    My Resume

Popular repositories Loading

  1. Fashion-Retail-Dashboard-Excel Fashion-Retail-Dashboard-Excel Public

    A comprehensive data analysis of a fashion clothing store's sales using Excel to create an interactive dashboard and report.

  2. amazon-clone-website amazon-clone-website Public

    A front-end clone of the Amazon website, built for educational purposes to replicate key design elements and layouts.

    HTML

  3. Currency-converter Currency-converter Public

    A modern currency conversion application built with HTML, CSS, and JavaScript.

    JavaScript

  4. Tic-Tac-Toe Tic-Tac-Toe Public

    A classic player-versus-player Tic-Tac-Toe game built entirely with front-end web technologies.

    JavaScript

  5. Nandu-bakery-Dashboard Nandu-bakery-Dashboard Public

    A data visualization project using Power BI to create an interactive dashboard for a bakery.

  6. Pizza-sales-analysis Pizza-sales-analysis Public

    An in-depth data analysis of a pizza sales dataset using SQL to derive key business insights