Avanish Pandey Email & Phone Number

New Delhi, Dl, In

Noida, Uttar Pradesh, India

Business Requirements Gathering: Collaborateing with business stakeholders, product managers, and other team members to understand business objectives and translate them into clear and concise requirements.Report and Dashboard Development: Designing and developing comprehensive reports, interactive dashboards, and visualizations to present key performance indicators (KPIs) and other relevant metrics to stakeholders.SQL Queries and Database Management: Writeing… Show more Business Requirements Gathering: Collaborateing with business stakeholders, product managers, and other team members to understand business objectives and translate them into clear and concise requirements.Report and Dashboard Development: Designing and developing comprehensive reports, interactive dashboards, and visualizations to present key performance indicators (KPIs) and other relevant metrics to stakeholders.SQL Queries and Database Management: Writeing complex SQL queries to extract, manipulate, and transform data from relational databases. Optimize database performance and ensure data integrity and security.Data Analysis & Data Crunching: Gathering, analysing, and interpreting data from multiple sources, including databases, spreadsheets, and other data repositories, to identify trends, patterns, and insights relevant to the business objectives.Team Management & Performance Tracking: Oversaw and analysing the Business Analyst team's performance, identifing improvement areas, and providing recommendations for enhancing operational efficiency. Distributing relevant work assignments to optimize productivity. Show less

Gurugram, Haryana, India

Sales and Business Solutions:Analyzed on-demand reports by higher management, providing insights for strategic business solutions and change requirements.Updated and created Business solution ideas to support the overall growth and development of the business.Dashboard Creation and Visualization:Crafted visually appealing dashboards for senior management, ensuring easy consumption of complex data.Utilized data visualization techniques to facilitate effective… Show more Sales and Business Solutions:Analyzed on-demand reports by higher management, providing insights for strategic business solutions and change requirements.Updated and created Business solution ideas to support the overall growth and development of the business.Dashboard Creation and Visualization:Crafted visually appealing dashboards for senior management, ensuring easy consumption of complex data.Utilized data visualization techniques to facilitate effective communication and decision-making.Team Management and Leadership:Managed and led the Business Analyst team, fostering a collaborative environment and enhancing overall productivity.Sales Prediction and Forecasting:Monitored and created data models for accurate sales prediction and forecasting during the execution of various initiatives, employing advanced tools.Database Scheduling and Automation:Responsible for scheduling databases to automate various reports, ensuring timely and efficient delivery.Store Reviews and Ratings Analysis:Analyzed Reviews and Ratings at the store, city, and zone levels, extracting valuable insights for strategic decision-making.Kaizen Leadership and Cost Savings:Led Kaizen and business promotional activities, contributing to continuous improvement.Provided cost-saving suggestions, optimizing operational efficiency.Analytical Modeling:Utilized analytical models and mathematical analysis to create and maintain key performance metrics.Supply Chain Optimization:Optimized the execution of the supply chain by planning, scheduling orders, and balancing inventory levels for efficient Stock-in and Stock-out. Show less

Gurugram, Haryana, India

Sales Planning: Created comprehensive product sales plans for the upcoming year based on thorough analysis of the last 2-3 years' sales data and aligned with the budget constraints.Buying Plan Optimization: Developed buying plans by meticulously considering current stock levels, ensuring optimal inventory management.Sales Dashboard Creation: Designed and implemented sales dashboards, providing a detailed overview of key performance indicators (KPIs) for each store.Store… Show more Sales Planning: Created comprehensive product sales plans for the upcoming year based on thorough analysis of the last 2-3 years' sales data and aligned with the budget constraints.Buying Plan Optimization: Developed buying plans by meticulously considering current stock levels, ensuring optimal inventory management.Sales Dashboard Creation: Designed and implemented sales dashboards, providing a detailed overview of key performance indicators (KPIs) for each store.Store and City-Wide Analysis: Conducted in-depth analyses of store and city-wise growth and financial performance, facilitating strategic decision-making.Salesperson Incentive Calculation: Devised and implemented a system for analyzing and calculating incentives for sales personnel, enhancing motivation and performance.MIS Reporting: Responsible for generating accurate and timely Monthly, Weekly, and Daily MIS reports, providing crucial insights for decision-makers.Product-Wise Data Analysis: Conducted thorough analysis of product-wise data, enabling informed decision-making and strategic planning. Show less

Banglore

Advanced Data Management:Stepped into a more advanced role, handling end-to-end data management processes.Contributed to the design and implementation of robust data collection, processing, and storage systems.Efficient ETL Processes:Developed and optimized Extract, Transform, Load (ETL) processes, ensuring seamless and efficient data flow.Implemented automation techniques to enhance the speed and accuracy of data transformations.Data Quality… Show more Advanced Data Management:Stepped into a more advanced role, handling end-to-end data management processes.Contributed to the design and implementation of robust data collection, processing, and storage systems.Efficient ETL Processes:Developed and optimized Extract, Transform, Load (ETL) processes, ensuring seamless and efficient data flow.Implemented automation techniques to enhance the speed and accuracy of data transformations.Data Quality Assurance:Spearheaded initiatives to ensure data quality and integrity, implementing validation checks and error handling procedures.Collaborated with cross-functional teams to establish and enforce data quality standards.Scalable Database Architecture:Contributed to the design and implementation of a scalable database architecture, accommodating the growing data needs of the organization.Implemented strategies to enhance database performance and reliability.Advanced Analytics Integration:Actively integrated advanced analytics into data processes, providing actionable insights for decision-makers.Collaborated with data scientists and analysts to implement machine learning models for predictive analytics. Show less

Bengaluru, Karnataka, India

Daily Production Data Collection:Successfully collected and compiled daily production data from the team, ensuring accuracy and timeliness.Implemented efficient data collection processes for streamlined reporting.Product-Wise Production Planning:Updated and maintained product-wise production plans, aligning with organizational goals and responding to dynamic production demands.Production Engineer KPI Analysis:Actively analyzed Production Engineers' Key… Show more Daily Production Data Collection:Successfully collected and compiled daily production data from the team, ensuring accuracy and timeliness.Implemented efficient data collection processes for streamlined reporting.Product-Wise Production Planning:Updated and maintained product-wise production plans, aligning with organizational goals and responding to dynamic production demands.Production Engineer KPI Analysis:Actively analyzed Production Engineers' Key Performance Indicators (KPIs), including plan vs. production, minimizing rework, and reducing rejections.Implemented data-driven strategies to enhance production efficiency and reduce operational discrepancies.MIS Reporting:Responsible for generating Monthly, Weekly, and Daily MIS reports, providing critical insights to support decision-making processes.Continuous Improvement Initiatives:Spearheaded initiatives aimed at continuous improvement within the reporting processes.Collaborated with cross-functional teams to identify areas for enhancement and implemented solutions for increased efficiency. Show less

Bachelor'S Degree, Mechanical Engineering

Diploma, Mechanical Engineering