Powered by
Codebasics DA Bootcamp

Tushar Dubey

HR Analyst

+91 6306427845 [email protected]

Resume

Hello, I am

Tushar Dubey.

1

Excel Project

1

PowerBI Project

1

SQL Project

About Me

My name is Tushar and I have around 3 years of experience as HR analyst & Talent Acquisition. Additionally, I have Sharpened my skills in Advanced Excel, Intermediate SQL and Power BI, which enables me to efficiently handle, analyze, and visualize large datasets. Looking for an opportunity where I can leverage my expertise in Advanced Excel, SQL, and Power BI to drive strategic approach and help in decision making process.

Key Skills

MIS reporting

Advanced Excel

SQL

Power BI

Stakeholder Manageme

DAX

Vlookup

Xlookup

Pivot Table

Power Query

Dashboard

My Projects

My Experience

With 3 years of experience in HR analysis & Talent Acquisition, I excel in optimizing recruitment processes and data-driven decision-making to boost efficiency.

I have managed Team Reports using Advanced Excel to improve hiring workflows and utilized Power Query to transform data from sources like LinkedIn and Dice. My background also includes client engagement, working closely with US-based stakeholders to align recruitment strategies with business goals and drive new opportunities.

👉𝗪𝗵𝗮𝘁 𝗶 𝗯𝗿𝗶𝗻𝗴 𝘁𝗼 𝘁𝗵𝗲 𝘁𝗮𝗯𝗹𝗲:
✅ MS Excel – Advanced Excel, Data cleaning, Pivot Table, Pivot Chart, Lookup Functions, Power Query, Excel Functions, Excel dashboard, MIS preparation.

✅ Power Bi – Power Bi Desktop, Power Query, Data Modelling, DAX, Power Bi Services, Extract, Transform & Load (ETL), Data Reporting, Data Transformation, Data Visualization, Power Apps.

✅ SQL – SQL Queries, Subqueries, Joins, CTE, Window functions, Aggregate functions, My SQL, SQL Server, Aggregate functions, Data Warehouse Concept.

✅ Stakeholder Management

Let's Connect

Feel free to get in touch with me. I am always open to discussing new projects, creative ideas or opportunities to be part of your visions.

[email protected]

https://www.linkedin.com/in/tushar-dubey09/

+ 91 6306427845

https://github.com/Tush-09

Excel Project

Customer Performance Report

Domain/Function: FMCG

This project allowed me to gain hands-on experience with several advanced Excel features and processes, including: ✅ Power Query for efficient ETL processes and data transformation. ✅Writing and applying complex DAX formulas for insightful metrics and KPIs.

View Project
Engagement

View Project
on GitHUB

Customer Performance Report

Financial Report

Customer Performance Report

Customer Performance Report

Project Details

📄Objective

• Created a Comprehensive Sales Analysis Report
• Analyzed sales data to generate actionable insights.
• Compared performance across different metrics and dimensions.

Empower Business Decisions:
• Identify key sales patterns and trends.
• Facilitate strategic decisions with detailed performance metrics.

🔍 Reports Overview:

• Customer Performance Report: Analyzes customer performance metrics to identify high and low-performing customers.
• Market Performance vs. Target Report: Compares actual market performance against sales targets to identify gaps and opportunities.
• Growth % of Top 10 Products in 2021 vs. 2020: Analyzes the growth percentage of top products year-over-year to understand product performance trends.
• Top 10 Products Performance: Analyzed top 10 products based on sales over the years.
• Top 5 and Bottom 5 Products Sold in 2021: Highlights the best and worst-performing products to guide inventory and marketing strategies.

PowerBI Project

Business Insight 360

Domain/Function: FMCG

This project features an in-depth Power BI dashboard designed to analyze and visualize critical performance metrics across multiple departments at AtliQ Hardware. It delivers actionable insights into finance, sales, marketing, supply chain, and executive operations, enabling stakeholders to make inf

View Project
Engagement

View Project
on GitHUB

Business Insight 360

𝗙𝗼𝗿 𝗙𝗶𝗻𝗮𝗻𝗰𝗲, I built a Profit and Loss statement to track financial performance across various markets and customer segments.

Business Insight 360

I created an 𝗘𝘅𝗲𝗰𝘂𝘁𝗶𝘃𝗲 𝘃𝗶𝗲𝘄, which compiled all the important metrics for the stakeholders to get a quick view of the company’s overall p

Project Details

𝘼𝙩𝙡𝙞𝙦 𝙃𝙖𝙧𝙙𝙬𝙖𝙧𝙚 𝙞𝙨 𝙤𝙣 𝙤𝙛 𝙩𝙝𝙚 𝙛𝙖𝙨𝙩𝙚𝙨𝙩 𝙜𝙧𝙤𝙬𝙞𝙣𝙜 𝙘𝙤𝙢𝙥𝙖𝙣𝙮 𝙞𝙣 𝙚𝙡𝙚𝙘𝙩𝙧𝙤𝙣𝙞𝙘 𝙢𝙖𝙧𝙠𝙚𝙩 𝙨𝙚𝙡𝙡𝙞𝙣𝙜 𝙘𝙤𝙢𝙥𝙪𝙩𝙚𝙧 𝙝𝙖𝙧𝙙𝙬𝙖𝙧𝙚s.
𝙏𝙝𝙚𝙮 𝙬𝙚𝙧𝙚 𝙪𝙨𝙞𝙣𝙜 𝙚𝙭𝙘𝙚𝙡 𝙛𝙤𝙧 𝙩𝙝𝙚𝙞𝙧 𝙖𝙣𝙖𝙡𝙮𝙨𝙞𝙨 𝙗𝙪𝙩 𝙙𝙪𝙚 𝙩𝙤 𝙧𝙖𝙥𝙞𝙙 𝙜𝙧𝙤𝙬𝙩𝙝 𝙞𝙣 𝙨𝙖𝙡𝙚𝙨 𝙫𝙤𝙡𝙪𝙢𝙚 𝙞𝙩 𝙞𝙨 𝙩𝙤𝙪𝙜𝙝 𝙛𝙤𝙧 𝙩𝙝𝙚𝙢 𝙩𝙤 𝙘𝙤𝙥𝙚 𝙪𝙥 𝙬𝙞𝙩𝙝 𝙚𝙭𝙘𝙚𝙡 𝙨𝙤 𝙩𝙝𝙚𝙮 𝙖𝙧𝙚 𝙩𝙧𝙖𝙣𝙨𝙞𝙩𝙞𝙤𝙣𝙞𝙣𝙜 𝙩𝙤 𝙋𝙤𝙬𝙚𝙧 𝘽𝙄.
𝘼𝙨 𝙖 𝘿𝙖𝙩𝙖 𝙖𝙣𝙖𝙡𝙮𝙨𝙩, 𝙈𝙮 𝙥𝙧𝙞𝙢𝙖𝙧𝙮 𝙩𝙖𝙨𝙠 𝙬𝙖𝙨 𝙩𝙤 𝙙𝙚𝙫𝙚𝙡𝙤𝙥 𝙖 𝙙𝙖𝙨𝙝𝙗𝙤𝙖𝙧𝙙 𝙩𝙝𝙖𝙩 𝙬𝙤𝙪𝙡𝙙 𝙖𝙡𝙡𝙤𝙬 𝙩𝙝𝙚 𝙘𝙤𝙢𝙥𝙖𝙣𝙮 𝙩𝙤 𝙢𝙖𝙠𝙚 𝙞𝙣𝙛𝙤𝙧𝙢𝙚𝙙 𝙙𝙚𝙘𝙞𝙨𝙞𝙤𝙣 𝙖𝙘𝙧𝙤𝙨𝙨 𝙖𝙡𝙡 𝙩𝙝𝙚𝙞𝙧 𝙙𝙚𝙥𝙖𝙧𝙩𝙢𝙚𝙣𝙩𝙨—𝙁𝙞𝙣𝙖𝙣𝙘𝙚, 𝙎𝙖𝙡𝙚𝙨, 𝙈𝙖𝙧𝙠𝙚𝙩𝙞𝙣𝙜 & 𝙎𝙪𝙥𝙥𝙡𝙮 𝘾𝙝𝙖𝙞𝙣.

Live Interactive Dashboard

SQL Project

Ad-hoc Analysis

Domain/Function: FMCG

Atliq’s Management noticed that they are not getting enough insights to make quick & smart decision data Informed decision making. So I’ve done Ad-hoc Analysis to provide insights to the management in consumer good domain.

View Project
Engagement

Ad-hoc Analysis

Wrote Query and prepare ad-hoc Report

Ad-hoc Analysis

Created several Stored Procedure and Views to avoid repetitive task and optimize performance.

Project Details

𝗧𝗮𝘀𝗸:
As an Analyst, I reviewed the 'ad-hoc-requests.pdf' to understand the 10 specific ad hoc requests for which the business needs insights. Then, I executed appropriate SQL queries to provide the necessary data and insights for each request.

𝗧𝗼𝗼𝗹𝘀 𝗨𝘀𝗲𝗱:

𝐌𝐲𝐒𝐐𝐋 - to query database
𝗘𝘅𝗰𝗲𝗹: For Validating Data and for charting purpose
𝐏𝐨𝐰𝐞𝐫𝐏𝐨𝐢𝐧𝐭 - to present the insights

𝗔𝗰𝘁𝗶𝗼𝗻𝘀:
1.Crafted ad-hoc reports by integrating around 𝟮𝗠+ 𝗿𝗼𝘄𝘀 𝘂𝘀𝗶𝗻𝗴 𝗦𝗤𝗟, 𝗲𝗺𝗽𝗹𝗼𝘆𝗶𝗻𝗴 𝗰𝗼𝗺𝗽𝗹𝗲𝘅 𝗷𝗼𝗶𝗻𝘀, 𝗻𝗲𝘀𝘁𝗲𝗱 𝘀𝘂𝗯𝗾𝘂𝗲𝗿𝗶𝗲𝘀, 𝗖𝗧𝗘𝘀 and analytical functions to solve business problem.

2. Applied essential SQL concepts such as 𝗦𝘁𝗼𝗿𝗲𝗱 𝗣𝗿𝗼𝗰𝗲𝗱𝘂𝗿𝗲, 𝗩𝗶𝗲𝘄𝘀 𝗮𝗻𝗱 𝗳𝘂𝗻𝗰𝘁𝗶𝗼𝗻𝘀 to boost the performance and query timing.

3. Created badge for Market on logic 𝗜𝗳 𝘁𝗼𝘁𝗮𝗹 𝗤𝘂𝗮𝗻𝘁𝗶𝘁𝘆 𝗦𝗼𝗹𝗱>𝟱 𝗠𝗶𝗹𝗹𝗶𝗼𝗻 𝘁𝗵𝗲𝗻 𝗴𝗼𝗹𝗱 𝗲𝗹𝘀𝗲 𝗦𝗶𝗹𝘃𝗲𝗿