Nithesh Nandagiri

Detail-oriented Data Analyst with over 3 years of experience in business intelligence, data analytics, and reporting across diverse industries. Proficient in SQL, Power BI, Power Query, Python (Pandas), Advanced Excel, and Google Sheets, with expertise in dashboard development, KPI tracking, report automation, and data validation. Proven ability to translate business requirements into scalable BI solutions, improve reporting efficiency, and support data-driven decision-making through strong analytical and stakeholder management skills.

Data Analyst (Sales & Workforce Analytics) - Techno Communications Global Pvt. Ltd

(2024-12 - 2026-01)

• Analyzed workforce and sales datasets to evaluate attendance adherence, employee engagement, and store-level performance, identifying performance trends and operational gaps to support data-driven business decisions.
• Developed SQL queries in MySQL and SQL Server using joins, CTEs, window functions, aggregations, and conditional logic to consolidate multi-source datasets, optimize query performance, and support efficient reporting and data analysis.
• Developed KPI measures to track key sales and workforce metrics, including store performance, attendance rates, productivity, training completion, and performance trends, enabling stakeholders to monitor operational performance and identify areas requiring attention.
• Implemented star schema data models and developed optimized DAX measures in Power BI to support accurate KPI calculations and consistent analysis of sales and workforce performance.
• Built interactive Power BI dashboards for sales and workforce performance analysis, integrating and transforming data from Salesforce CRM, RTBDI, and other source systems to deliver KPI reporting and actionable business insights.
• Developed a centralized KPI framework to evaluate sales and workforce performance, enabling senior leadership to identify underperforming regions and prioritize performance improvement areas.
• Streamlined recurring reporting workflows using SQL and Power Query for ETL, data transformation, and validation, reducing manual reporting effort and improving data consistency.
• Constructed dynamic Pivot Table summaries and XLOOKUP/INDEX-MATCH cross-checks within shared Google Sheets trackers to address urgent ad-hoc reporting requests, complementing major dashboards for fast turnaround on leadership asks.
• Used Python (Pandas, NumPy) to perform exploratory data analysis and generate summary metrics from workforce datasets, supporting KPI reporting and trend analysis.

Associate Analyst (Workforce Analytics) - Nakshatra IT Solutions India Pvt. Ltd

(2023-06 - 2024-11)

• Analyzed ATS datasets covering 1,000+ candidates monthly across a diversified, multi-location client base to track end-to-end hiring funnel metrics, including submissions, interviews, placements, and backouts, enabling data-driven decisions and improving hiring visibility across the organization.
• Performed stage-wise funnel conversion analysis using SQL in MySQL and SQL Server to identify hiring bottlenecks and support improvements in hiring cycle time and recruiter efficiency across active hiring pipelines.
• Built Power BI dashboards using SQL-based recruiter KPI data, applying data transformation and validation processes with DAX measures to track placement rates and turnaround times, enabling hiring managers to monitor weekly team performance and make data-driven decisions.
• Maintained shared Google Sheets trackers with Pivot Table summaries and XLOOKUP/INDEX-MATCH formulas to monitor daily candidate pipeline status, providing recruiters and hiring managers with visibility into submissions and placements across teams.
• Analyzed staffing pipeline and consultant availability data to identify redeployment opportunities and support efficient workforce allocation across consultant teams.
• Used Python (Pandas) to clean and standardize raw ATS exports, resolve inconsistent data formats, and validate candidate records to improve data quality and streamline report preparation.

B.Tech - Information Technology - University College of Engineering, Kakatiya University (2019-06 - 2023-05)