Experience

• 

  Technohead Security IT & Telecom Projects LLP

  • India
  • Retail Office Equipment
  • 1 - 100 Employee

  • Data Analyst

    • May 2024 - Present

    Customer Billing Data Analysis: Conducted comprehensive analysis on 5 years of billing data to enhance customer insights and business strategies.Data Cleaning and Preparation: Cleaned and structured raw billing data to ensure accuracy and reliability for analysis.Customer Segmentation: Identified active customers and segmented them into prime and non-prime categories to aid in targeted marketing efforts.Yearly Trend Analysis: Focused on year-wise trends to provide actionable insights on customer behavior and purchasing patterns over time.Customer Retention Metrics: Analyzed customer retention by identifying repeated customers and distinguishing them from non-repeated ones.Reporting and Visualization: Created detailed reports and visualizations to present findings to stakeholders, aiding in data-driven decision-making processes.

  • Management Information System Executive

    • Apr 2023 - May 2024

    System Design and Implementation: Accountable for designing and implementing various systems to enhance operational efficiency across the organization.Lead Management and CRM System: Developed a Lead Management and CRM System using AppSheet, enabling salespersons to access and update their leads, and trace service requests in a centralized location for easy updates.Quotation and Purchase Order Software: Created and continuously enhanced software on Google Sheets using Apps Script to generate quotations and purchase orders, incorporating new features as needed.MIS Reporting: Prepared comprehensive daily, weekly, monthly, and yearly MIS reports for all staff members to support informed decision-making.Email Marketing Campaigns: Managed email marketing campaigns using Sender.net and Brevo platforms, integrating Google Sheets with Apps Script for streamlined processes.WhatsApp Marketing Automation: Drove WhatsApp marketing initiatives using MaytAPI, integrating with Google Sheets and automating processes with Apps Script.

• 

  Rahul Jain-Business Coaching India

  • New Delhi, Delhi, India

  • MIS Executive

    • May 2022 - Apr 2023
    • New Delhi, Delhi, India

    As a tech support specialist, I provide assistance to clients on Zoom, helping them troubleshoot technical issues and providing guidance on a range of software and systems, including Google Sheets, Checklists, FMS, IMS, PMS and more.I developed an automated system for Google Sheets by integrating various tools and systems, including Checklists, FMS, Delegation, IMS, Project Management System (PMS), and more.I am responsible for creating and managing Google Forms, utilizing regular expressions (regex) and validations to efficiently handle and organize data.I have experience in creating and managing business intelligence dashboards using Looker Studio. I have expertise in linking these dashboards to Google Sites.I am responsible for executing email campaigns using Mailchimp. This includes managing subscriber lists, designing email templates, and tracking campaign performance through analytics tools.I am responsible sending bulk WhatsApp messages using Google Sheets and MaytAPI.

• 

  Gigatel Solutions

  • Kalkaji

  • Backend Executive

    • Jun 2021 - May 2022
    • Kalkaji

    Verification of invoices and maintaining data on Google Sheets and as well as on MS Excel and directly reporting to the director.Preparation of MIS report on a daily, weekly, and monthly basis.Assisting and coordinating with the stock team and maintaining data on MS Excel.

• 

  Flaberry

  • New Delhi, Delhi, India

  • Backend Executive

    • Feb 2020 - Jun 2021
    • New Delhi, Delhi, India

    Verified and corrected database and made their entries in MS Excel.Interaction with vendors through various way, by Phone, Email, WhatsApp and etc. for safest delivery of products which placed by the customers on company's website or application.