Amrutesh Yerva

Project Name: Microsoft

• Developed interactive reports and dashboards using Power BI, providing insights for multiple MSBU business verticals.
• Connected to various data sources through Power BI connectors and APIs, performing data cleansing, ETL operations, and data modeling.
• Created complex DAX measures and calculated columns to enhance data analysis and reporting capabilities.
• Built and maintained data models to support robust and scalable reporting solutions.
• Designed and developed visually appealing and intuitive Power BI dashboards, enabling senior leadership to monitor team performance and business status effectively.
• Implemented row-level security (RLS) to ensure data privacy and access control.
• Utilized Power BI Service for report publishing, sharing, and scheduling data refreshes.
• Collaborated with business stakeholders to gather requirements and translate them into actionable insights through Power BI.
• Provided data-driven recommendations to support decision-making and strategic planning.
• Team Lead:
• Led a team to deliver efficient break-and-fix solutions for Microsoft Fabric, ensuring top-notch customer satisfaction.
• Ensured team adherence to SLAs, KPIs, and client SOPs, maintaining high-quality standards.
• Groomed team members with technical knowledge and kept them updated on new product feature rollouts.
• Training Lead:
• Conducted comprehensive training for new engineers on Power BI Desktop, Service, Admin Portal, Azure Portal, Gateways, Dataflows, Datamart, REST API, Embed concepts, troubleshooting tools, and other fabric products.
• Managed a team of 6 trainers, ensuring seamless training experiences for new hires while adhering to training schedules.
• Trained approximately 250 engineers in one year, supporting project growth by delivering quality training and ensuring new hires were production-ready through various assessments.

• Business Analyst, Modern Trade and E-Commerce Channel Departments Reporting:
• Developed and maintained data and reporting infrastructures using SQL, Microsoft Excel, and Power BI to provide insights for B2B, B2C, and E-Commerce channel businesses.
• Published daily, weekly, and monthly business reports on sales performance by region, division, ASM, and KAM.
• Generated customer-wise offtake reports across categories, brands, products, and SKUs on a monthly basis.
• Prepared fortnightly demand forecasting reports and CFA and distributor-wise stock holding norm reports at the SKU level.
• Conducted monthly reviews of each state's growth compared to last year and targets, tracked team productivity, and monitored attrition rates of the field team.
• Report Automation:
• Automated daily and weekly reporting using SQL and Power BI, reducing report time from 15 hours to just 1 hour per week.
• Market Effectiveness Tracker:
• Developed Power BI dashboards for the business team to visualize KPI performance across customers and regions.
• CK Market Connect App:
• Played a key role in developing a real-time application to track promoters and merchandisers (field team) in collaboration with an app development company.
• Achievements:
• Achieved category-best growth in personal care and dairy products, with increases of 35% and 40% respectively, resulting in revenue growth of ₹125 crores in personal care and ₹24 crores in dairy products.

• Completed a year-long management trainee program, gaining comprehensive experience across Operations, Sales, Marketing, Logistics, Production, and Analytical departments.
• This role provided a holistic understanding of the business processes within an FMCG company, significantly enriching overall skill set and knowledge.