Talk to sales Try for Free
Amit K. Pandey

Amit K. Pandey

Data Analyst

Followers of Amit K. Pandey449 followers
location of Amit K. PandeyGurugram, Haryana, India

Connect with Amit K. Pandey to Send Message

Connect

Connect with Amit K. Pandey to Send Message

Connect

  • Timeline

  • Skills

    Analytics
    Assimilate data & convert it into meaningful reports and spot any anomalies.
    Business Analysis
    Business Development
    Business Strategy
    Contact Center as a Service (CCaaS)
    CRM
    Customer Relationship Management (CRM)
    Excellent analytical skills and demonstrated aptitude for attention to detail an
    Experience with Dynamics CRM Salesforce.com
    Fresdesk
    Freshchat
    Leadsquared
    Management
    Monitor data to look for trends and anomalies that might indicate abnormal behav
    Ozonetel
    Procurement
    Product Management
    Proficiency in excel
    Proficiency in SQL
    SQL
    Strong analytical mind with ability to process information logically
    Team Management

  • About me

    A competent professional in Manipulating, cleansing & processing data using SQL, ETL Process and Advanced Excel & Statistical tools for delivering meaningful information and uncover hidden patterns from organizational datasets.

  • Education

    • Lucknow University, Lucknow

      2009 - 2012
      Master of Computer Applications (M.C.A.) Computer Software Engineering

      Groomed the software skills and strengthen the computer application aspect of modern, industry-oriented education in applied computer science.

  • Experience

    • CRIS; A Autonomous Society under the Ministry of Indian Railways

      Jan 2011 - Apr 2014
      Data Analyst

      SAP ERP implementation & Data Analysis, Refining & cleaning Raw data to meaningful data to customize ERP in different modules of SAP. Plant Maintenance, Material Management & HRUsing Excel Techniques to convert Raw Data to meaningful data sets. Comprehensive dataset management.

    • Snapdeal

      Jan 2015 - Jun 2016
      Data Analyst

      1 - Applying Data Analytics for Reducing Returns in post-delivery segment, coming up with new hypothesis about high return rate and verify it using data analysis and quantitative/qualitative analysis.2 - Managing service operations for rendering and achieving quality services; providing second line support by providing insights & revamping metrics to ensuring gaps in customer experience metrics.3 - Monitor data to look for trends and anomalies that might indicate abnormal behavior.4 - In collaboration with others, interpret data and develop recommendations based on findings.5 - Develop graphs, reports, and presentations.6 - Perform basic statistical analyses for key reports.7 - Developing new streams for revenue growth and maintaining relationship with customers to achieve repeat / referral business. Show less

    • University of Petroleum and Energy Studies

      Oct 2016 - Sept 2022

      - Analyse information to produce the forecast of the academic products.- Innovative analysis in academic and industrial fields.- Responsible for improvement in Operational Systems, process and policies and business process and planning for College of Engineering. - Assist in special projects for cost optimization & efficiencies.

      • Assistant Manager

        Oct 2016 - Sept 2022

      • Sr. Business Analyst

        Oct 2016 - Jul 2020

    • Adda247

      Sept 2022 - now

      Administrator of various renowned products i.e. LeadSquared, Freshdesk, Ozonetel Cloud Telephony Contact Center as a Service (CCaaS).

      • Manager | Business Intelligence - CRM & Dialer

        Sept 2022 - now

      • Associate Manager

        Sept 2022 - Jun 2024

  • Licenses & Certifications

    • Excel Skills for Business: Essentials

      Macquarie University
      Apr 2020
      View certificate certificate

    • Everyday Excel by University of Colorado Boulder

      Coursera
      Apr 2020
      View certificate certificate

    • Spreadsheets for Beginners using Google Sheets

      Rhyme.com (Acquired by Coursera)
      Apr 2020
      View certificate certificate