Janaki Yazna Sriprada

Results-driven Programmer Analyst with a proven track record at Healthcare, leveraging advanced Excel and Power BI to enhance data analysis and visualization. Achieved a 25% improvement in collection rates and a 15% boost in client satisfaction through effective team leadership and strategic problem-solving. Skilled in data modeling and client relationship management.

• HackerRank – SQL Gold Badge.
• Omega Star Award for the best performer with 100 % quality and target achieved.
• Gebbs Rising Star Award for two quarters for the best performer with 100 % quality and target achieved.

Power BI developer| Cognizant, Coimbatore |

• created a call center analysis report, which gives a 3.4/5 average customer rating to see performance trends by setting KPIs, and designed a churn analysis report for 7,043 customers, resulting in a 26.54% churn rate by using charts and DAX functions, which help in data-driven decision-making to operability
• Crafted a diversity and inclusion report, harmonizing the workforce based on gender for 500 employees

Zomato restaurant analysis| Power BI |

• Analyzed a dataset of 9,551 restaurants in 15+ countries, which shows an average rating of 2.6/5 and an average cost of $1,200; crafted Power BI reports for global analysis and restaurant performance by using Power Query, charts, and DAX for calculations

superstore sales analysis| Power BI

• I built an overview report of sales and profit trends, providing insight into the top five selling and profitable subcategories across four years, used Power Query Editor for data cleaning, DAX for measures, and visualization with charts, cards, tables, and filters

air cargo analysis| SQL

• Leveraged airline dataset to optimize travel operations, analyze busiest routes, ticket sales, and enhance the booking experience, resulting in a 25% increase in revenue collection and a 15% reduction in customer complaints

comparison of region-based sales| Tableau |

• Prepared a dashboard to compare revenue distribution, KPIs, and sales trends between two selected regions of the sample superstore, increased sales by 45% on the first order of the Central and East regions; analyzed by using charts, filters, calculated fields, and parameters

e-commerce sales analysis| MS Excel

• created an insightful dashboard for 2015 sales by analyzing the growth trends of four product categories using a pivot table, incorporating clustered column charts, bar charts, a control combo box, and the data analysis add-in to accomplish the top 10 products