Prudent Business Intelligence and Operations Lead with close to 9 years of experience providing employers with valuable and actionable data to drive profit growth. Practiced at filtering information to find and highlight vital metrics and revelatory findings. Keenly supporting business growth by leveraging intelligence assets to predict and reveal optimal business strategies.
• Experience in building, publishing customized interactive reports and dashboards using Excel and Power BI.
• Experience in back end using SQL features such as join, sub-queries, aggregate functions etc.
• Experience in designing wireframes and data models in Power BI.
• Experience in writing DAX queries and M queries in Power BI.
• Experience working in Agile Scrum development process.
• Experience in pulling data from various sources like Microsoft SQL Server, Excel, CSV, Sharepoint, Salesforce, Jira, Azure, Web etc
• Experience in leading, coaching and mentoring a team of junior resources.
• Interact with country stakeholders to understand key business problems faced and convert them into solutions of analytical interest.
• Understanding consumer behavior across different market segments, challenges in marketing new product and strategic insights in targeting new customers.
• Enhance operational efficiency in existing technology systems & bring down turnaround time so that key findings can be communicated to countries much prior.
• Manage the reporting for number of European countries like Poland, Italy, Germany, Greece, UK etc.
• Preparing reports that explains business about performance in terms of different region, brands and sales rep.
• Keeping an eye on data and reporting for any discrepancies.
• Automated all routine reports done over week which saves substantial time.
• Saved hours from each report and converted it into 10 minutes task.
• Own and ensure delivery of each project from end to end starting from requirement gathering to release or go live within estimated timelines.
• To manage and close all incidence and enhancement requests.
• 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.
• Working closely with a global insurance client to understand and solve various business problems.
• Extraction of data from various sources like DB2, MS Access, Salesforce, Excel, CSV, Sharepoint and some Web Pages.
• Data preparation and manipulation using Excel, MySQL and Power BI.
• Creation, validation and refresh of various sales and performance matrices to generate reports and dashboards in Power BI.
• To produce various types of insights through data visualization and reporting with a focus to make it visually appealing, user friendly and easy to interpret from end user perspective.
• Closing all AD-Hoc requests from clients with minimum TAT.
Power BI
6 Sigma Green Belt Certification
• Received Silver and Bronze Awards in 3M.
• Received Kaliber Awards in Diageo for Exceptional Performance.
• Received League of Champions Award for Outstanding Performance in WNS.
Professional Scrum Master I
Integrated Program In Business Analytics
Data Science With SAS
6 Sigma Green Belt Certification