Shreyash Khairnar

Junior Analyst

Nashik, Maharashtra 2+ yrs exp 80 · Excellent

About

Detail-oriented Junior Analyst with 1+ year of hands-on experience in data analytics, business intelligence, and KPI reporting within a remote-friendly, cross-functional environment. Proficient in Microsoft Excel (Advanced functions, Pivot Tables, VLOOKUP/XLOOKUP, Power Query), SQL (MySQL), and Power BI / Tableau for building interactive dashboards and automated reports. Skilled in data cleaning, ETL processes, data validation, and quality checks to ensure accuracy and consistency. Strong track record of translating complex business data into actionable insights, identifying trends and anomalies, and presenting findings clearly to stakeholders to support data-driven decision-making.

Skills & Expertise (36)

SQL Intermediate

7.3/10

Years Exp

Power BI Intermediate

7.1/10

Years Exp

Python Intermediate

6.9/10

Years Exp

Data Cleaning Intermediate

6.5/10

Years Exp

Problem Solving Tableau NumPy Exploratory data analysis Trend Analysis Time management Performance Metrics Data Interpretation Trello Remote work Critical thinking Microsoft Teams Slack Git GitHub Jira Pandas Microsoft Excel Power Query DAX Data Modeling ETL Pipelines MySql KPI Reporting Anomaly Detection Quality Checks Data Validation Google Workspace Google Sheets XLOOKUP VLOOKUP Pivot Tables

Work Experience

Data Analyst

Scalent Infotech Pvt. Ltd

Jan 2024 - Present

Data Collection, Cleaning & Validation: Collected, organized, and transformed business data from multiple internal sources using SQL, Excel, and Power Query; performed rigorous data validation and quality checks to maintain 100% accuracy and consistency across all reporting pipelines. Reporting & Dashboards: Designed and deployed interactive Power BI dashboards with complex DAX measures and calculated columns to monitor real-time KPIs, operational metrics, and business performance indicators for executive stakeholders. Process Automation: Automated recurring daily, weekly, and monthly reports using Python (Pandas) and SQL, reducing manual reporting effort by 40% and improving data delivery timelines. Business Insights & Analysis: Performed trend analysis, pattern identification, and exploratory data analysis (EDA) on large datasets to uncover actionable business insights; identified data anomalies and inconsistencies and coordinated with relevant teams for resolution. Stakeholder Communication: Prepared clear summaries and presentations based on analytical findings; communicated insights to cross-functional teams (Operations, Business, Finance) to support strategic, data-driven decisions. Documentation & Compliance: Maintained accurate documentation of datasets, report methodologies, and analytical processes; adhered to data privacy, security, and confidentiality guidelines throughout all projects.