SHIVA Krishnan

2024-08 - 2024-08

Reporting Analyst

PWC Consulting, Remote

· Completed job simulation wherein Power BI skills were strengthened to better understand clients and their data visualization needs.

· Demonstrated expertise in data visualization through creation of Power BI dashboards that effectively conveyed KPIs, showcasing ability to respond to client requests with well-designed solutions.

· Strong communication skills reflected in concise and informative email communication with engagement partners, delivering valuable insights and actionable suggestions based on data analysis.

· Leveraged analytical problem-solving skills to examine HR data, particularly focusing on gender-related KPIs, and identified root causes for gender balance issues at executive management level, highlighting commitment to data-driven decision-making.

· Utilized advanced Excel skills to analyze data and create interactive dashboards, demonstrating commitment to data-driven decision-making

· Demonstrated proficiency in over 50 Excel formulas, including VLOOKUP, HLOOKUP, SUM, COUNT, AVERAGE, AVERAGEIF, SUMIF, COUNTIF, AVERAGEIFS, COUNTIFS, SUMIFS, INDEX and MATCH, IF, nested IF, and XLOOKUP

· Automated nested (IF and VLOOKUP, IF and HLOOKUP) functions using macros and other tools.

· Utilized in-depth analysis and creative problem solving to troubleshoot reporting issues

· Assisted in development of long-term strategies based on thorough understanding of data trends and patterns observed in reports

• Reduced collection time for outstanding invoices by closely monitoring aged accounts and maintaining frequent communication with clients.
• Mitigated disputes over invoices by liaising between internal departments and clients, ensuring clear communication and swift resolution of issues.
• Shaped best practices within the team through regular review meetings focused on enhancing overall performance in accounts receivable functions.
• Negotiated favorable payment terms with clients experiencing financial difficulties, preserving valuable business relationships while safeguarding company interests.

• Assisting doctors in creating profile on appointment scheduling platform
• Analyzed reporting functions and efficiency to reduce error rates and increase efficiency by 100%
• Improved existing reporting by researching data sources, compiling data and designing output.

• Follow up with patients through phone calls
• Identified, recommended and executed opportunities to enhance accounts receivable and billing processes to meet finance requirements
• Reduced collection time for outstanding invoices by closely monitoring aged accounts and maintaining frequent communication with clients.
• Analyzed aging reports to identify trends and patterns causing missed collections.
• Mitigated disputes over invoices by liaising between internal departments and clients, ensuring clear communication and swift resolution of issues.

• Resolving queries of customers through chat as part of customer service
• Provided friendly, helpful customer service to over 60 customers daily
• Provided excellent customer service for positive experiences and returning patrons.

• Enhanced closing efficiency by meticulously reviewing and verifying all documentation related to property transactions
• Demonstrated problem-solving skills in addressing any unexpected issues during closing, ultimately ensuring successful outcome for all parties involved
• Improved customer satisfaction by providing timely updates on status of closings and addressing any concerns or questions promptly.

• Sharing Service level excel reports to management indicating whether agreed upon service level was met or not met
• Performing ad hoc tasks in excel
• Sharing attendance reports of agents with management
• Monitoring real time status of agents
• Selling insurance policies and handling customer service enquiries over phone
• Developed custom reports to provide management with valuable insights into workforce performance metrics
• Ensured compliance with labor laws and regulations through meticulous tracking of work hours, overtime calculations, and paid time off accruals.
• Balanced employee needs with business objectives by creating flexible scheduling options that accommodated personal requests while maintaining appropriate coverage levels.
• Improved customer satisfaction, ensuring adequate staffing levels during peak business hours.