Adwait Dwivedi
Data Analyst
Bengaluru,KA
Summary
Analytical and detail-oriented Data Analyst with 7+ years of experience in Analytics, AI, and Data Engineering across domains such as Sales, Sales Operations, Client Operations, Finance, and Retail. Skilled in data warehousing, process validation, and business requirements analysis, with a proven ability to translate complex customer needs into actionable project plans. Working experience in statistical analysis, predictive modeling, and data visualization, leveraging advanced tools and techniques to deliver meaningful insights. Proficient in SQL, Python, Power BI, and Tableau, with a passion for Business Intelligence and driving data-driven decision-making to optimize business performance
Overview
8
8
years of professional experience
2
2
years of post-secondary education
4
4
Certificates
Work History
Data Analyst
Insight
Bengaluru, KARNATAKA
11.2023 - Current
- Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.
- Collaborated with cross-functional teams to ensure data integrity and accuracy, resulting in better-informed decisions.
- Enhanced business efficiency by identifying trends and patterns in complex datasets.
- Provided actionable insights through comprehensive reports and dashboards, supporting strategic initiatives.
- Integrated multiple sources of disparate data into cohesive datasets using ETL processes, improving overall analytic capabilities.
- Developed custom algorithms to optimize data mining, increasing the effectiveness of analytical insights.
- Implemented robust control measures to improve analytical output reliability.
- Streamlined reporting processes, resulting in faster turnaround times for monthly performance reports.
- Increased efficiency in data storage and retrieval by implementing robust database management systems.
- Optimized data collection methods to enhance quality and volume of data captured for analysis.
- Enhanced data accuracy by automating data cleansing processes, significantly reducing manual errors.
- Conducted comprehensive data analysis to support strategic planning, leading to more informed decision-making.
- Collaborated with IT to ensure data security measures were in place, safeguarding sensitive information.
- Improved data visualization techniques, making insights more accessible to non-technical stakeholders.
- Developed and implemented data governance policies and procedures.
- Developed and maintained data warehouses and data marts to support business operations.
- Assisted with creating data cubes and OLAP models to improve data analysis.
- Created dashboards to monitor and track key performance indicators.
- Created data models to support decision-making processes.
- Facilitated cross-departmental data integration, enhancing overall data coherence and utility.
AI Consultant
Insight
Bengaluru, KARNATAKA
11.2022 - 03.2023
- Designed and implemented an AI-powered chatbot leveraging SQL database analysis to deliver accurate, context-specific responses to user queries.
- Collaborated with cross-functional teams to update the codebase and optimize the architecture of the Generative AI solution.
- Managed client interactions, providing detailed insights and explaining the functionality and benefits of the Gen AI product.
- Developed a chatbot integrated with Azure Storage, enabling precise data-driven responses based on stored information.
- Engineered a robust Python codebase for analyzing and summarizing data from diverse sources, including PDF documents, CSV files, and SQL databases.
Ju. Data Scientist
PBI Analytics
Pune, Maharashtra
04.2021 - 11.2022
- Contributed to a Churn Modeling project focused on forecasting quarterly churn and delivering actionable insights that supported retention strategies, resulting in a 10% reduction in churn rate.
- Performed comprehensive data preprocessing and exploratory data analysis (EDA) to ensure data quality and uncover key patterns, improving model accuracy by 15%.
- Implemented predictive models that achieved over 85% accuracy in churn prediction, enabling data-driven decision-making for customer retention..
Sales Analyst
Reckitt Benkiser
Delhi, Delhi
09.2019 - 04.2021
- Analyzed and evaluated sales trends, performance metrics, and market share across multiple channels, geographies, and outlet types, driving insights that contributed to a 12% increase in regional sales performance.
- Developed accurate sales targets for value and SKUs based on historical data analysis, improving forecasting accuracy by 15%.
Collaborated with marketing teams to design and implement high-impact promotional strategies, resulting in a 10% uplift in campaign-driven sales. - Monitored and optimized regional sales performance, ensuring achievement of potential targets and exceeding quarterly goals by 8%.
- Conducted regular product training sessions for the sales team to ensure a deep understanding of offerings and value propositions.
- Enhanced profitability with thorough sales trend evaluations and strategic recommendations.
- Developed accurate sales forecasts by analyzing sales feedback and wrote reports for senior leadership.
Sales Team Lead
Hindustan Coca-Cola Beverages Private
Surat, Gujarat
05.2018 - 09.2019
- Drove strategic sales and business development initiatives for new product launches, resulting in a 15% increase in market penetration within the first quarter.
- Managed a network of over 1,800 retail outlets, improving coverage and driving a 20% growth in overall sales volume.
- Oversaw manpower allocation, distributor consolidation, and inventory management, reducing stock discrepancies by 15% and improving operational efficiency.
- Trained, coached, and mentored new sales associates for maximum performance.
- Nurtured long-term relationships with top-performing accounts, ensuring continued growth in recurring revenue streams.
- Built relationships with customers and community to promote long term business growth.
Education
MBA - Marketing & IT
Jaipuria Institute of Management
Indore 06.2016 - 04.2018
Skills
SQL
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Certification
Microsoft Certified: Azure AI Fundamentals(AI 900)
Timeline
Microsoft certified: Fabrics Analytics Engineer Associate(
02-2025
Data Analyst
Insight
11.2023 - Current
Microsoft Certified: Azure Data Engineer Associate
11-2023
Microsoft Certified: Azure AI Fundamentals(AI 900)
06-2023
Fundamentals of databricks Lakehouse platform Accreditation
02-2023
AI Consultant
Insight
11.2022 - 03.2023
Ju. Data Scientist
PBI Analytics
04.2021 - 11.2022
Sales Analyst
Reckitt Benkiser
09.2019 - 04.2021
Sales Team Lead
Hindustan Coca-Cola Beverages Private
05.2018 - 09.2019
MBA - Marketing & IT
Jaipuria Institute of Management
06.2016 - 04.2018