Badges
Certifications
Work Experience
Consultant
Diageo• December 2018 - Present
Experience in building, publishing customized interactive reports and dashboards using Excel and Power BI. Experience in using SQL features such as join, subqueries, aggregate functions etc. Experience in writing complex queries in SQL to query database to get desired result and to increase operational efficiency. Understanding consumer behavior across different market segments, challenges in marketing new product and strategic insights in targeting new customers. Interact with different country stakeholders to understand key business problems faced and convert them into analytical solutions. Enhanced operational efficiency in existing technology systems & bring down turnaround time so that key findings can be communicated to countries much prior. Taking care of reporting for number of European countries like Sweden, Denmark, Norway, Belgium, Luxembourg, Netherlands, Greece, Italy etc. Preparing reports that tells business about performance in terms of different region, brands and sales rep. Keeping eye on data and reporting for any discrepancies. Automated all routine reports done over week which saves substantial time. Saved 3 hours from each report and converted it into 10 minutes task. Developing Insights Identification of relevant KPIs for country, brand, sales rep, store etc which could best indicate commercial performance & its alignment to operating plan. Design of commercial scorecards which could portray precise performance metrics for each country, strategic market, region and global (with specific focus on key drivers and drainers). Manage multiple stakeholders including partner organizations, data owners, process owners, domain subject matter experts; and leverage on cumulative learning to provide insightful results. Help partners by not only building strategies but also implementing solutions to achieve top line and bottom line impact.
Software Engineer
accenture• May 2015 - December 2018
Created Excel master sheets with inbuilt formulas for processing of data. Expertise in collecting and organizing quantitative data to derive on meaningful analysis by building Models/Dashboards from scratch to lead business improvement and cost reductions. Saved hours of human effort and decreased chances of human error (by approx. 95%) by writing VBA code and automated whole reporting process. Analysis of data and implementing solutions. Have done root cause analysis using SQL and Excel to uncover core issues using data and then assisted team and clients to improve and create new measures for productivity, accountability and presentation. Handled requests from client on ad-hoc/urgent basis for analysis and interpretation of data and interacted with client for requirement gathering and analysis to build dashboards/reports. Had eye towards enhancing reports and developed new reports as per requirements and changing scenario to innovate and simplify operational process. Automated all reports(approximately 5 reports) to bring down reporting time from 6 hours each report to 5 minutes each which also reduced chances of human error by 95%.
Education
Uttar Pradesh Technical University
Electrical Engineering, B.Tech• July 2010 - June 2014
· Organised several events in college including College fest, Department fest. · Organised and hosted Departmental fest for EC Department for two consecutive years. · Organised and Hosted several quiz competitions in College like G.K Quiz and Technical Quiz. · Represented college at inter college cultural fest. · Organised and trained a team for the same for Fashion show. · Mentored Junior batch with various technical topics by taking KT whenever needed.