Samvedna Kannamwar
Analytics Consultant
Bengaluru,India
Summary
Consultant - Business Insights and Analytics Professional Business Analyst coming with extensive experience in business analysis with excellent knowledge of business process automation and workflow concepts. Multi-tasking Consultant well-known for successfully taking projects from beginning stages to completion. Polished and professional offering proficiency in retail and CG. Commended for consistently meeting new technical challenges and finding solutions to satisfy customer needs.
Overview
4
4
years of post-secondary education
6
6
years of professional experience
Work History
Consultant
Diageo Business Services India
Bengaluru, Karnataka
03.2019 - Current
- Preparing reports that tells business about performance in terms of different region, brands and sales rep.
- Delivered regular business insights and recommendations to Stakeholders across Europe, related to Sales Team everyday execution.
- Collaborated with market and Europe Stakeholders in order to understand current business needs and establish priorities for analytical research.
- Experience in building, publishing customized interactive reports and dashboards using Excel and Power BI.
- Responsible for requirement gathering, implementing solutions and documentation.
- 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.
- 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 them into 10 minutes task.
- Developed Outlet Execution KPI Report for execution team that tracks progress of Execution and Financial KPI’s across months, allowing users to slice data across different regions / markets, as well as compare results in various ways - vs targets, vs LY, vs P1, vs F20 P7 etc.
- Create analytical model, performing analyses on data in order to identify and resolve data quality issues, spotting trends and gaps in Sales Teams effective performance, simplify sales automation tools, gathering insights from commercial reports and verification of execution metrics and to increase productivity and efficiency of commercial reporting.
Senior Data Programmer
Epsilon India
Bengaluru, Karnataka
06.2017 - 12.2018
- Responsible for data mining and converting data into specific data driven catalog to help organization in campaign and marketing.
- Responsible for creating interactive and data driven dashboards and reports in Excel and Tableau, moving static Excel reports to tableau and enhancement of existing reports. This in turn helped in reducing time taken to generate reports on weekly and monthly basis by 60% and reduced chances of manual err.
- Responsible for organization and implementation of workflows to update, audit and report on data integration projects.
- Experience in translating business requirements into functional/business specifications, creating test plans, and developing quality assurance methodologies.
- 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. - Direct email Marketing: Derived churn rate of customers of different clients and built models to able to identify/segment customers who are not happy with provided solution to identify important KPIs and driving factors for same which helps business to leverage their optimum solution to retain customer.
- Worked closely with onsite partners to maintain optimum levels of communication to effectively and efficiently complete projects.
- Developed team communications and information for meetings
- Actively listened to customers' requests, confirming full understanding before addressing concerns
Data Analyst
Cognizant Technology Solutions
Bengaluru, Karnataka
10.2014 - 04.2017
- Supporting Client and their marketing team to engage with key stake holders, as part of Multi-channel Marketing engagement to maintain and enhance market share.
- Responsible for data harmonization and data ingestion in SQL.
- Created Excel master sheets with inbuilt formulas for processing of data.
- Identified and documented detailed business rules and use cases based on requirements analysis.
- Recommended data standardization and usage for protection of data integrity.
- Customer Master Data Management, using Veeva CRM/ MDM.
Education
Bachelor of Engineering - Electronics And Telecommunication
Chhattisgarh Swami VivekanandTechnology University
Bhilai, Chhattisgarh 07.2010 - 06.2014
Skills
Analysis & Evaluation
Power BI
Requirement Gathering
Agile Methodology
SQL Server
Advance Excel
Tableau
Business Analysis
Azure Data Lake
Market Understanding
Reporting and Insights
Accomplishments
- Received Kaliber Award in Diageo for Exceptional Performance.
- Part of Cognizant Outreach program to help kids with their homework.
- Organized college and department level fest.
- Received various awards and certificates in dance and debate competitions at school and state level.
- Was head girl at school.
Timeline
Consultant
Diageo Business Services India
03.2019 - Current
Senior Data Programmer
Epsilon India
06.2017 - 12.2018
Data Analyst
Cognizant Technology Solutions
10.2014 - 04.2017
Bachelor of Engineering - Electronics And Telecommunication
Chhattisgarh Swami VivekanandTechnology University
07.2010 - 06.2014