Summary
Overview
Work History
Education
Skills
Languages
Personal Social Responsibilities
Skill Summary
Hobbies and Interests
Certification
Disclaimer
Timeline
Generic
Manish Agrawal

Manish Agrawal

Mehrauli, Delhi South,DL

Summary

Collaborative leader with dedication to partnering with coworkers to promote engaged, empowering work culture. Documented strengths in building and maintaining relationships with diverse range of stakeholders in dynamic, fast-paced settings. Organized and dependable at managing multiple priorities with a positive attitude. Willingness to take on added responsibilities to meet team goals. Detail-oriented team player with strong organizational skills. Ability to handle multiple projects simultaneously with a high degree of accuracy.

Overview

12
12
years of professional experience
1
1
Certification

Work History

Manager - MIS & Data Analytics

Trucare Kidz India pvt ltd
New Delhi
09.2023 - 04.2024
  • Developing and maintaining data analytics strategies to support business decision-making processes
  • Analyze and interpret data to identify trends, opportunities, and risks within the organization
  • Creating dashboards and reports to visualize key performance indicators (KPIs) for various departments and business aspects
  • Collaborating with cross-functional teams to gather requirements and provide insights for strategic planning
  • Monitoring data quality and integrity, and implement corrective measures as needed
  • Driving continuous improvement in data analytics processes and tools to enhance efficiency and effectiveness
  • Sharing findings and recommendations to senior management to ensure informed decision-making.
  • Managed and motivated employees to be productive and engaged in work.
  • Accomplished multiple tasks within established timeframes.
  • Maximized performance by monitoring daily activities and mentoring team members.
  • Monitored and analyzed business performance to identify areas of improvement and make necessary adjustments.

Ecommerce Data Analyst

Andis US
Remote
09.2020 - 08.2023
  • Responsible for product listing/management on E-commerce marketplaces
  • Responsible for compliance on listings
  • Responsible to share MIS presentations with management and the internal team on a timely basis using Google sheets & Excel
  • Responsible for inventory management, best seller analysis, and order confirmation to partners
  • Creating business dashboards (Sales reports, Revenue reports, End-to-end business tracking)
  • Timely reporting (Daily, Weekly & Monthly MIS Reports & Dashboard) across products & verticals
  • Analysing data & trends to generate actionable business insights
  • Collating the data from various sources into a structured format & cleaning raw data
  • Co-ordinating with existing MIS systems to ensure the accuracy of data
  • Automation of MIS & reports
  • Provided actionable insights through comprehensive reports and dashboards, supporting strategic initiatives.
  • Creation of monthly & weekly review decks using Google data studio.
  • Utilized data visualization tools to effectively communicate business insights.
  • Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.
  • Extracted and interpreted data patterns to translate findings into actionable outcomes.
  • Upheld security and confidentiality of documents and data within area of responsibility.

Business Intelligence Analyst

Soundrise Hearing Solution Pvt. Ltd (Hear.com)
Gurgaon
09.2017 - 11.2019
  • Responsible for custom reports creation from database for different functions across organization based on their specific requirements
  • Streamlined reporting processes for increased efficiency and accuracy with the development of custom dashboards.
  • Introduced report automation using VBA which resulted in time saving
  • Responsible for tracking of Partner clinic performance on weekly, monthly, quarter, and on requirement level using DOMO and excel
  • Responsible for tracking and analyzing performance of Sales team to provide insights and input for betterment in performance which lead to growth in revenue inflow
  • Initiated Collection tracking activities which resulted the decrease on bad debts and increased revenue and profit margins
  • Creating Marketing related reports to track marketing expense and the benefits on campaign level using DOMO and excel
  • Introduced and modified new incentive plans (from time to time) to create healthy and competitive environment for sales team to compete which resulted in better performance and displayed better sales output over time and increase their earnings and appreciations
  • Used excel with VBA and DOMO to automate and simplify all daily, weekly, monthly reports for enhanced efficiency and time savings
  • Analyzed business trends for scope of improvements in all verticals of business
  • Played an active role with Finance team in reconciling Ledgers for smooth functioning and clearing backlogs of payments
  • Responsible for publishing Team level Development Path reports for global teams
  • Managing, cleaning, realigning Global data for better readability which resulted in better readability and collaboration within different departments.
  • Developed intelligence-sharing dashboards, providing company-wide access to collected data.

Specialist Business Development

Aegis Ltd.
Gurgaon, IN
09.2015 - 12.2016
  • Responsible for handling RFI for prospective clients
  • Preparing data for response of RFP Questionnaire
  • Business proposal writing, business presentation and Client coordination
  • Identifying, preparing and tracking every detail of businesses handled by Aegis (e.g
  • Vertical, country wise, seats, headcount, volume information which helps in adhoc requirement sought by prospective clients)
  • Preparing transitional and Process Flow references which was helpful in showcasing our operations efficiency to clients
  • Responsible for maintaining updated case study for clients we serve.

Specialist Business Analytics

Aegis Ltd.
Gurgaon, IN
09.2013 - 08.2015
  • Analysis on Revenue Forecasts
  • Compilation of quarterly Revenue projections with analysis on the up & down trend of the projected figures
  • Analysis on Attrition & Shrinkage% for PAN India & Sri Lanka to get in depth reason for revenue fluctuation
  • Calculation & Keeping track of Seats occupied by each processes for analysis on process & Centre level seat utilisation required for P&L cost allocation
  • Manpower Allocation for all the Centres/Processes which helps in Salary & other Cost Allocation while P&L preparation
  • Tracking daily revenue with analysis on reasons for up/down trend of the projected figures
  • Creating Span report & analysis and help leadership to take decision on Non CSA Hiring to reduce Direct & Indirect cost of business.

Senior Executive (Operations)

Aegis Ltd.
Gurgaon, IN
12.2011 - 08.2013
  • Lifecycle management of airtel employee DTH connection
  • Getting employee DTH connections activated and converting back to Individual connection at the time of separation of employee (Complete lifecycle of Pan India Bharti Employees DTH Connections)
  • Raising IUT (bill) to circle HR & Finance for DTH benefits provided to employees on a monthly basis
  • Bill clearance from each Circle of Airtel & Bharti Group Companies to reduce Bad Debts for Airtel DTH
  • Reconciliation of employee connections (Mobile/ Landline/ Broadband/ DTH) to ensure that only entitled connection gets benefitted
  • Apart from DTH was also responsible for any query/request/complaints related to Mobility & Tele-media for pan India Bharti employees
  • Respond to employees query/request/complaints through e-mails and phone using the Best Practice guidelines ensuring First Time Resolution by taking complete ownership of each case individually
  • Work within agreed service levels, striving to exceed client's expectations like productivity standards; such as overall accuracy; maintaining SLAs; backlog management of process and daily statistics
  • Assist Team, Fresher's and Management with any special projects assigned and provide backup to team when necessary
  • Maintain advanced working knowledge of all customer service processes for different market segments and communicate discrepancies/ issues with suggested resolution to team manager when necessary.

Education

Bachelor of Arts - Political Science

T. M. Bhagalpur University
Munger, India
01.2006

Skills

  • Data and Reporting Management

  • Data Analysis and modification using tools like Advanced Excel, VBA, Macros, SQL, Salesforce, Microsoft Dynamics NAV, Google Sheets

  • Hands on experience in Data Visualization tools like Domo, Tableau, Klipfolio, MS Power point, Google Data Studio, Power BI

  • Proven experience working across functions (Operations, Finance, Sales, Customer Services, Marketing, Human Resources, Logistics) to gather insights through first and/or third party data for analysis (eg Cost Center Analysis, Profit Center Analysis, Business Insights, Sales Analytics, Marketing Analytics, HR Analytics)

Languages

Hindi
Advanced (C1)
English
Advanced (C1)
Marathi
Intermediate (B1)
Urdu
Elementary (A2)

Personal Social Responsibilities

  • Active Volunteer of NGO "Beti Foundation" working to provide free education to street children
  • Volunteered as a first line worker in association with government agencies and NGO(s) to curb and fight Covid 19 by assisting people in need of Medical attention, Plasma, Blood, Hospitalization, Oxygen, Covid Tests, Covid Vaccinations to the residents of Mehrauli District and people approaching/reffered from multiple sources (i.e. Social Media, Mouth of Words, etc.)
  • Assisted people in Home quarantine for speedy recovery by regular followups with help of local authorites
  • Arranged Food distribution thru Social Kitchens for homeless and people in need at places like hospitals, Rain baseras with the help of other volunteers and government agencies

Skill Summary

  • Data and Reporting Management
  • Analysis and modification using tools like Advanced Excel, VBA, Macros, SQL, Salesforce, Microsoft Dynamics NAV, Google Sheets
  • Hands on experience in Data Visualization tools like Domo, Tableau, Klipfolio, MS Power point, Google Data Studio, Power BI
  • Proven experience working across functions (Operations, Finance, Sales, Customer Services, Marketing, Human Resources, Logistics) to gather insights through first and/or third party data for analysis (e.g. Cost Center Analysis, Profit Center Analysis, Business Insights, Sales Analytics, Marketing Analytics, H.R Analytics) and automations resulting in swift functioning and better decision making

Hobbies and Interests

  • Currency Collection
  • Photography (Street, Landscape and Nature)
  • Travelling
  • Playing Chess

Certification

  • Certified Data Visualization with Power Bi from Great Learning
  • Certified Advanced Lean Six Sigma Yellow Belt from Sparen & Gewinn Consulting
  • Certified Business Process Automation from Airslate
  • Certified Business Process Analyst from Airslate
  • Certified Advanced Google Analytics from Google Analytics Academy

Disclaimer

I Manish K. Agrawal do here by declare that all the information given above is true to the best of my knowledge and belief. I understood that in the event of any information being found false or incorrect, my candidature / appointment is liable to be cancelled.

Timeline

Manager - MIS & Data Analytics

Trucare Kidz India pvt ltd
09.2023 - 04.2024

Ecommerce Data Analyst

Andis US
09.2020 - 08.2023

Business Intelligence Analyst

Soundrise Hearing Solution Pvt. Ltd (Hear.com)
09.2017 - 11.2019

Specialist Business Development

Aegis Ltd.
09.2015 - 12.2016

Specialist Business Analytics

Aegis Ltd.
09.2013 - 08.2015

Senior Executive (Operations)

Aegis Ltd.
12.2011 - 08.2013

Bachelor of Arts - Political Science

T. M. Bhagalpur University
Manish Agrawal