Phanichandra Kosana

Phanichandra Kosana

Business Analyst / Data Analyst
India
Telugu, English
Full-time Hybrid

About Me

Business Analyst / Data Analyst with 2 years of experience supporting business requirements, client communication, cross-functional delivery, testing, reporting, and operational analytics. Experienced in gathering and do…

Experience

Business Analyst

TATA CONSULTANCY SERVICES (TCS) · Hyderabad , Telangana , India
Dec 2021 - Nov 2023 · 1 year 10 months

<p>Gathered, analyzed, and documented functional and non-functional requirements through stakeholder discussions, translating business needs into clear functional specifications and actionable deliverables.</p><p> Collaborated with clients and cross-functional business and technical teams to clarify requirements, provide progress updates, track deliverables, and support delivery within agreed SLA timelines.</p><p> Supported implementation of client-requested solutions in cloud-based applications by coordinating requirement development, testing, validation, and deployment into production.</p><p> Prepared and maintained requirements and testing documentation, including client requirements, test results, validation outcomes, and implementation-related documentation.</p><p> Coordinated end-to-end delivery activities across business and technical teams, following up on dependencies, actions, and blockers to support timely delivery of client solutions.</p><p> Supported change management by assessing requirement changes, evaluating their impact on business processes and reporting solutions, and coordinating updates with relevant stakeholders.</p><p> Prepared and maintained requirements and testing documentation, supported functional testing and UAT, validated expected outcomes against business requirements, and coordinated defect resolution with technical teams.</p><p> Analysed 10,000+ HR and operational records to identify patterns, business risks, performance trends, and actionable insights supporting business decision-making.</p><p> Retrieved, aggregated, cleaned, and validated data from multiple enterprise sources using SQL and Advanced Excel, converting complex datasets into actionable business insights.</p><p> Developed and maintained interactive Power BI dashboards to monitor SLA compliance, ticket resolution performance, workforce metrics, and operational KPIs.</p><p> Analyzed ServiceNow and SAP HCM processes and ticket data to identify process gaps, recurring issues, and improvement opportunities, supporting business and technical teams in solution analysis.</p><p> Executed ETL-related activities including data extraction, transformation, cleansing, validation, and integration from multiple data sources.</p><p> Collaborated with stakeholders to define reporting requirements and translate business requirements into scalable Power BI dashboards and actionable analytical solutions.</p><p> Planned and executed analytics and reporting deliverables within defined timelines while maintaining data accuracy, quality, and consistency through validation and reconciliation.</p><p> Designed and maintained Power BI data models using relationships, calculated columns, and DAX measures; optimized reports and visuals to improve performance and usability.</p><p> Leveraged AWS S3 for managing and accessing datasets used in reporting and analytics activities, with working knowledge of GCP, BigQuery, Python Notebooks, and Gemini AI.</p>

Skills

Requirement Gathering & Documentation Stakeholder Management Client Communication Business Reporting Process Improvement UAT Testing Documentation SLA Tracking Cross-functional Coordination Task & Deliverable Tracking Dependency Follow-up Implementation Support Requirement-to-Deployment Lifecycle Production Deployment Power BI Desktop Power BI Service DAX Data Modeling Dashboard Development KPI Reporting Data Cleaning Data Transformation EDA Trend Analysis SQL Advanced Excel Power Query XLOOKUP Pivot Tables Python pandas NumPy Matplotlib Jupyter Notebook BigQuery AWS S3 GCP ServiceNow SAP HCM ChatGPT Gemini AI
Report this Profile?