BI Data Analyst

• Mar 2021 - Present

• Created automated weekly, monthly, and quarterly reports/dashboards using Power BI and SQL for Scorecards, commissions, digital marketing, and clinical outcomes for the Sales, Customer Success, Marketing and Product team respectively. • Developed and maintained a consistent data warehouse and a curated data model for all data sourcing, data wrangling, transformations, analytics and reporting purposes on Microsoft Azure. • Worked closely with a wide variety of teams to ensure that all decisions across the business are data driven and well informed. • Analyzed data to deliver insights about operational performance and proactively drive improvements. • Built visualizations, scheduled performance updates, and conduct ad hoc analysis as required to deliver definitive answers to questions raised within the business • Work with the Sales team to retrieve data from HubSpot CRM and Pipedrive to create automated reports on weekly scorecard, roll over deals and week over week changes in Power BI. Used Azure data factory to store the data and pull them into Power BI, used Power Query for transformations and ETL purposes, and well experienced with DAX formulas. • Used SQL and Advanced Excel (including Pivot tables, VLOOKUP, Macros) to validate data through database and Power BI. • Work with the Marketing team to track and monitor leads through specific campaigns, sources, and medium. Created customizable dashboards with Google analytics data to help the digital marketing team gather information about user behavior on the website. Implemented various time intelligence analysis including WoW, and QoQ changes to help make strategic decisions. • Sent automated emails using Power Automate and Power BI dataflows to the leadership team with data related to sales based on region, strategic business units and business development representatives. Show less

Business Data Analyst

• Oct 2020 - Mar 2021

✦ Use Power BI and DAX to create dashboards to track, monitor and analyze user health KPIs including but not limited to nutrition, exercise, sleep, and stress. ✦ Drive customer acquisition, user engagement, and customer retention by making weekly engagement plans for our client base and setting deliverables for every week. ✦ Create a rules engine for content delivery and lead social media analytics on HubSpot. ✦ Act as a liaison between the development team and company leadership to create and manage company’s new website. Created several as-is, to-be documents and managed product backlogs on JIRA. ✦ Lead User Acceptance testing and Application testing to find bugs and create JIRA tickets for the development team. ✦ Use open source video editing software’s like iMovie and Windows video editor to create user onboarding and app navigation videos for first time users. Show less

Sales Data Analyst (Consultant)

• May 2018 - Jun 2019

✦ Setup an internal ticket tracking system using Advanced Excel, (Pivot tables, VLookup, Macros, VBA, and Dynamic formula’s) & Google forms. ✦ Assisted the team to ensure that all requirements documentation can be easily translated, understood, documented, owned, and actioned by the team. ✦ Established professional relationships with SME’s, business users, and other user groups/stakeholders to determine the requirements and the desired outcomes for the solution, and to produce and develop relevant documentation. ✦ Extract raw data from Querybuilder & Salesforce using SQL, apply data manipulation and cleaning techniques to derive meaningful data insights. ✦ Gathered and defined business requirements through meetings with business and technical stakeholders. ✦ Worked closely with the technical team to assist in the analysis and design of technical solutions that fulfill the stated requirements. Achievements: ✦ Created 50+ dashboards using Tableau and Excel charts to track week on week progress of restaurant KPI’s, analyze key parameters, identify gaps & inefficiencies in the business processes, and help managers make informed business decisions. ✦ Increased restaurant supply hours from around 50% to 75% in a span of 4 months by identifying key operational issues. ✦ Created an effective communication channel between restaurant partners and operations team by raising and keeping track of solved vs unsolved tickets. ✦ Worked extensively on the Salesforce application to help restaurant partners get onboard with the UberEATS platform. Worked on various assignments including but not limited to New City launches, Pre-launch Assessment, geo Expansion, Densification, and Enterprise Franchise & Management Show less

Application Development Analyst

• Nov 2016 - May 2018

Worked on SAP UI5 and Java development projects like Mergers & Acquisitions, Woolsworth, Liquid Studio to create visual charts and models in a mobile application. Assisted the product owner with various activities including communicating updates and impediments as well as supporting the application and prioritizing the requirements for sprint. Created an automated mail system to send mails to concerned individuals using mapping (assignment matrix) through Excel and JavaScript. Worked on SAP UI5 and Java development projects like Mergers & Acquisitions, Woolsworth, Liquid Studio to create visual charts and models in a mobile application. Assisted the product owner with various activities including communicating updates and impediments as well as supporting the application and prioritizing the requirements for sprint. Created an automated mail system to send mails to concerned individuals using mapping (assignment matrix) through Excel and JavaScript.

Business Development Associate

• Nov 2015 - Nov 2016

Managed and conducted on-ground promotional campaigns in Karnataka and looked after the sales and marketing activities across India.Spearheaded a team of 7 people to assist them with closing deals and track their monthly revenue targets.

Intern

• Dec 2015 - May 2016

Internship

• Dec 2014 - Jan 2015