Summary
Overview
Work History
Education
Skills
Accomplishments
Software
Timeline
Debayan Chakraborty

Debayan Chakraborty

MIS Manager
Kolkata

Summary

With over 14 years of experience and advanced skills in Excel, I have the ability to effectively process and analyze large volumes of data. Using my expertise in data visualization, I can create reports and dashboards that present data in a clear and concise manner, making it easy for organizations to analyze and make informed decisions. By identifying patterns and trends within the data, I can offer valuable insights and actionable recommendations that contribute to the success of the organization. Additionally, my forecasting skills enable me to predict future trends and developments, providing proactive insights that help organizations stay ahead of the curve. Overall, my proficiency in Excel and Power BI allows me to deliver high-quality data analysis that drives success for organizations.

Overview

14
14
years of professional experience
7
7
years of post-secondary education
3
3
Languages

Work History

MIS Manager

Senco Gold Ltd.
Kolkata
2021.03 - Current
  • Analyzing large volumes of data using Excel and Power BI to create reports and dashboards that present data in a clear and concise manner. This involves analyzing complex data sets and presenting findings in a format that is easy for stakeholders to understand, such as creating charts, graphs, and other visual aids.
  • Identifying patterns and insights within the data to offer informed recommendations. This requires a deep understanding of the data and the ability to identify patterns and insights that may not be immediately apparent. I will be responsible for providing recommendations based on my findings and collaborating with cross-functional teams to implement data-driven strategies.
  • Using data visualization techniques to create visually appealing dashboards that showcase key metrics and trends. My responsibility is to create dashboards that provide stakeholders with an easy-to-understand snapshot of key metrics and trends. I will need to be familiar with a variety of data visualization techniques and tools and be able to choose the best approach for each situation.
  • Forecasting future trends and developments to provide valuable insights for proactive decision-making. I am responsible for using my expertise to forecast future trends and developments and provide stakeholders with valuable insights that can help inform their decision-making. This involves analyzing historical data and market trends and considering external factors that may impact the organization.
  • Developing and implementing data analysis processes and best practices. I am responsible for developing and implementing data analysis processes and best practices that help ensure the accuracy and reliability of my findings. This may involve developing new tools and methodologies and working with IT teams to implement data management systems.
  • Training and mentoring team members to improve their skills and knowledge. My responsibility is to provide ongoing training and support to team members to help them improve their skills and knowledge.
  • Managing team workload and prioritizing tasks to meet deadlines. As the MIS Manager, I am responsible for managing the workload of my team and ensuring that all tasks are completed on time. I will need to be able to prioritize tasks based on their importance and urgency and make quick decisions when necessary to ensure that deadlines are met.
  • Collaborating with cross-functional teams to understand business needs and provide data-driven insights. I am expected to work closely with cross-functional teams to understand their business needs and provide them with data-driven insights that can help them achieve their goals. This may involve participating in meetings and presentations and providing recommendations based on my analysis.

Executive Sales Operation

Emami Agrotech Limited
Kolkata
2019.07 - 2021.03

• Generate reports for each Daily, Weekly, and Monthly Covering Primary and Secondary data.
• Track different dashboard metrics daily and organize them for reporting purposes.
• Download and map different data for analysis.
• Produce tables, pivot reports, and charts for use in key-decision-making processes.
• Using SAP, SFA, and DMS to analyze model data.
• Review performance data to monitor and measure productivity, goal progress, and activity levels.
• Apply performance data to evaluate and improve operations, target current business conditions, and forecast needs.
• Boost productivity by consolidating material planning and data collecting.
• Discover areas of improvement by generating Daily, Weekly, and Monthly sales reports.
• Reduce operational risks while organizing sales dashboards to forecast performance trends.
• Coordination with Regional MIS team, Managers, and RSMs.
• User Acceptance Testing to assess if the system can support business, and user scenarios, and ensure the system is sufficient, and correct for business usage.

Sales Support Executive

RSH Global Pvt. Ltd.
Kolkata
2011.09 - 2019.06

• Generate timely and accurate Dashboard for analysis.
• Creating MIS Dashboard and presenting it to the concerned department and updating the management.
• Managing the monthly, weekly & daily reports using advanced excel (Lookups, Index & Match, Pivot table, Table, etc.) with in-depth analysis for producing the actionable information's.
• Conducting the Monthly Sales Meeting with Salesforce.
• Channel Management by using regular reviews to track the progress on the priorities (productivity, revenue targets, other KPI's) set out at the beginning of the year/month.
• Monitoring the daily sales reports of the Sales team (both Primary and Secondary).
• Coordination for Sales and Sales Support Operation.
• Identifying and targeting new accounts, driving marketing and growth initiatives, and delivering revenue and acquisition targets for assigned territory by driving marketplace execution.
• Complete client satisfaction through regular client meetings and relationship building and direct dealing with existing customers if required.
• Visit markets for collecting different market intellects (Competitors activities, rates, and schemes) also measuring the depth and width of distribution by visiting retails and collecting the sample data for giving better and real feedback to management as well as to the sales force.
• Planning different OPS plans, BTL activities, targeting with the management and trade marketing team by giving the feedbacks and different analysis like MAT data, product life cycle, CAGR, etc.
• Handling secondary automation software.

Trade Trainee

Exide Industries Ltd.
Kolkata
2010.01 - 2011.09

• Maintain and generate records of man-hours for workers.
• Assessment of daily productivity.
• Support service to Monthly and Absolute productivity assessment.
• Incentive calculations for workers.

Regional Sales Coordinator

Joy Cosmetics Pvt. Ltd.
Kolkata
2009.08 - 2010.01

• Coordination with Field Forces and distributors.
• Verification and follow up of daily sales activities.
• Provide data support to Field Forces.
• Daily update of primary closing figures Depot, ASM area, and Distributor wise.
• Coordinate between mother depot and depots for logistical support.

Education

Bachelor's of Commerce - Commerce

Barrackpore Rastraguru Surendranath College (CU), Barrackpore
2005.05 - 2008.08

Higher Secondary - Commerce

Union Institution (WBCHSE), Serampore
2003.03 - 2005.03

Madhyamik -

Nandalal Institution (WBBSE), Serampore
2001.04 - 2003.03

Skills

    Data Processing and Validation

undefined

Accomplishments


  • Implemented CRM with EY in Senco Gold Ltd.
  • Established MIS department in Senco Gold Ltd.
  • Emami Agrotech Ltd. awarded Champion OF Champs for Q4 2019 performance.
  • Initiated SFA and DMS implementation project with Hira Software Solution for RSH Global Pvt. Ltd. in 2018.

Software

Microsoft Office and Excel

Power BI

Microsoft Dynamics 365 (Report generation purpose)

SAP (Report generation purpose)

Timeline

MIS Manager - Senco Gold Ltd.
2021.03 - Current
Executive Sales Operation - Emami Agrotech Limited
2019.07 - 2021.03
Sales Support Executive - RSH Global Pvt. Ltd.
2011.09 - 2019.06
Trade Trainee - Exide Industries Ltd.
2010.01 - 2011.09
Regional Sales Coordinator - Joy Cosmetics Pvt. Ltd.
2009.08 - 2010.01
Barrackpore Rastraguru Surendranath College (CU) - Bachelor's of Commerce, Commerce
2005.05 - 2008.08
Union Institution (WBCHSE) - Higher Secondary, Commerce
2003.03 - 2005.03
Nandalal Institution (WBBSE) - Madhyamik,
2001.04 - 2003.03
Debayan ChakrabortyMIS Manager