Phani Chandra

Data Analyst/Business Analyst with 2 years of experience in data analysis, business intelligence, and dashboard development. Proficient in Power BI, SQL, and Advanced Excel for building KPI-driven dashboards, performing data cleaning and transformation, and generating actionable insights. Experienced in stakeholder management, cross-functional collaboration, and translating business requirements into actionable analytical solutions.

Experienced in working with HR analytics, SAP HCM, and ServiceNow data to analyze operational performance, track SLA metrics, and support data-driven decision making.

Business Analyst at TATA CONSULTANCY SERVICES (TCS) (2021-01 – 2023-12)

• Analysed 10,000+ HR and operational records to identify patterns, business risks, performance trends, and actionable insights supporting business decision-making.
• Retrieved, aggregated, cleaned, and validated data from multiple enterprise sources using SQL and Advanced Excel, converting complex datasets into actionable insights for business decision-making.
• Developed and maintained interactive Power BI dashboards to monitor SLA compliance, ticket resolution performance, workforce metrics, and operational KPIs.
• Designed KPI reports and visualizations that enabled stakeholders to track business performance and support data-driven decision-making.
• Automated recurring business reports and dashboard workflows, reducing manual effort and improving reporting efficiency.
• Performed Exploratory Data Analysis (EDA) to identify trends, anomalies, and operational performance patterns.
• Conducted trend analysis on ServiceNow and SAP HCM ticket data to evaluate priority levels, resolution timelines, and service metrics.
• Executed ETL-related activities including data extraction, transformation, cleansing, validation, and integration from multiple data sources.
• Utilized Advanced Excel features including Pivot Tables, XLOOKUP, Conditional Formatting, and Power Query for reporting and analysis.
• Wrote and optimized complex SQL queries using joins and aggregations across multiple datasets to support operational analysis and business reporting.
• Leveraged AWS S3 cloud storage for managing and accessing datasets used in reporting and analytics activities.
• Collaborated with cross-functional teams and business stakeholders to define requirements, analyze business needs, and deliver data-driven reporting and analytical solutions.
• Maintained high standards of data accuracy, quality, and consistency through validation, reconciliation, and regular quality assurance activities.
• Designed, developed, and maintained Power BI reports and dashboards using DAX, data modeling, SQL, and Power Query to support business reporting and decision-making.
• Designed and maintained data models in Power BI using relationships, calculated columns, and DAX measures to support scalable business reporting.
• Collaborated with business and technical stakeholders to gather reporting requirements and translate business requirements into scalable Power BI dashboards and actionable analytical solutions.
• Collaborated with business and technical teams to plan and execute analytics and report deliverables within defined timelines.
• Performed exploratory data analysis (EDA), data cleansing, and validation to ensure high-quality reporting and actionable insights.
• Optimized Power BI data models, DAX measures, and report visuals to improve dashboard performance and usability.
• Familiar with Power BI Desktop and Power BI Service for report development, publishing, and dashboard management.
• Working knowledge of Google Cloud Platform (GCP), Big Query, SQL, Python Notebooks, and Gemini AI for data analysis, query development, and understanding cloud-based analytics workflows.

Master of Business Administration (MBA) in Human Resources