Himanshu Yadav

Junior Data Analyst

Lucknow, India 3+ yrs exp 87 · Excellent

About

Detail-oriented junior data analyst skilled in Excel (VLOOKUP, HLOOKUP, Pivot Tables), Google Sheets, SQL, and Power BI, with hands-on experience in data cleaning, preparation, and dashboard creation. Proven ability to deliver accurate reports, maintain data quality, and document metrics and logic for non-technical stakeholders. Strong communicator in English, comfortable with remote collaboration, and eager to learn new BI tools and analytical techniques.

Skills & Expertise (23)

MS Excel Intermediate

7.8/10

Years Exp

Report Creation Intermediate

7.5/10

Years Exp

Data Preparation Intermediate

7.5/10

Years Exp

Data Cleaning Intermediate

7.5/10

Years Exp

VLOOKUP Intermediate

7.0/10

Years Exp

Teamwork Intermediate

7.0/10

Years Exp

Problem-solving Intermediate

7.0/10

Years Exp

Analytical Thinking Intermediate

7.0/10

Years Exp

SQL Intermediate

7.0/10

Years Exp

Pivot Tables Intermediate

7.0/10

Years Exp

Power BI Intermediate

6.5/10

Years Exp

Dashboard Development Intermediate

6.5/10

Years Exp

HLOOKUP Intermediate

6.5/10

Years Exp

Python Intermediate

6.0/10

Years Exp

Google Sheets Data Quality Checks Zoho Desk Charts Basic Automation Microsoft Office Data Analysis Zoho CRM Quick learner

Work Experience

Career Services Analyst

Imarticus Learning

Feb 2025 - Present

Collected, organized, and maintained candidate and corporate databases, ensuring data accuracy, performing data quality checks, and supporting business reporting requirements. Prepared daily, weekly, and monthly reports using MS Excel and Google Sheets to track placement activities, KPIs, and key performance metrics. Created data-driven reports and dashboards to support business decisions, improve process visibility, and assist stakeholders with data insights. Analyzed hiring trends and placement data to identify patterns, generate actionable insights, and support decision-making. Supported cross-functional teams by coordinating with Sales, Product, and Marketing departments to gather, validate, and prepare data for reporting requirements. Built and maintained a verified HR database using Lusha, Apollo, and SalesQL while ensuring data accuracy and proper documentation for targeted outreach.

Technical Research Analyst

Intellipaat Software Solutions Pvt. Ltd.

Mar 2023 - Feb 2025

Managed and maintained large datasets using Google Sheets, MS Excel, SQL, and CRM tools, ensuring data accuracy for daily operations and reporting. Implemented basic automation and process improvements that reduced turnaround time by 20% and enhanced reporting efficiency. Prepared and maintained MIS reports, performed data quality checks, and created analytical reports to support business decision-making. Supported the CEO on strategic initiatives by conducting data research, lead generation, and reporting using MR E, Apollo, and Lusha, while maintaining well-documented datasets and collaborating with cross-functional teams.