Ayush

WORK EXPERIENCE Professional Experience

 Business Intelligence Consultant, Qral Group, India o Lead Developer/ Lead Analyst

 Lead the design, development, deployment and operations of 30+ PowerBI and Tableau based sales, KPI and leadership reporting solutions for 700+ users ranging from senior leadership to field sales reps across 3 US based fortune 500 clients. Senior leadership’s primary point of contact, responsible for requirements gathering, KPI / metrics design and reporting tool demos.

 Delivered 100+ adhoc analyses for sales and marketing leadership of different client teams supporting them in strategic business decisions in their respective organizations.

 Built a self service analytics tool for internal business analysts, by integrating and combining 5 different data sources into a single data model. The tool served as a user-friendly interface to the data warehouse, and simplified pulling data extracts from diverse data sets by reducing dependencies by upto 80% and reducing the turnaround time by 70%. o Process Improvement and Operations Excellence Improved the process efficiencies by upto 90% through diligent application of Operations Excellence, and implemented zero manual touch point operations using Microsoft PowerAutomate, SQL and Alteryx, thereby, bringing the ops time and effort down by 90%. o Project Management

 Regular direct communication with client Senior Directors and Directors, shaping up their unarticulated business needs into tangible data solutions

 Timeline negotiations and setting up delivery expectations with client and internal teams

 Managed overall report/ dashboard delivery ensuring timeline adherence, prioritizing change requests, tracking project KPIs and collaborating with internal teams at 3 global locations.

 Client and internal stakeholder communication and management

 Onboarding and mentoring new team members

 Associate Consultant, ZS Associates, Gurgaon Dec 2015 to Aug 2018 o Lead a Business Intelligence Reporting Operations team of 6 members working for a Fortune 500 client o Developed, deployed and operationalized 20+ PowerBI, excel VBA and Tableau based weekly and monthly reports/ dashboards for the commercial leadership and sales force of 400+ sales reps o Primary analyst for client sales planning team and collaborated directly with the Sr. Director to answer day-to-day business questions in the form of actionable insights using data o ZS firm wide “Operations Excellence Leader” – launched 3 firm wide initiatives related to quality, project management and automation. The initiatives were piloted and eventually adopted by 5 large client teams improving the operational efficiency by upto 50% o Ensured end to end project delivery from timeline adherence, resource management, effort estimates to tracking performance KPIs o Onboarded, trained and mentored new team members on the project and ensured their professional development goals are met