Apoorv Agarwal

Consultant
Gurgaon, IN.

About

Data & Observability Engineer with 8+ years of experience building scalable analytics platforms and automation workflows using ELK Stack, Splunk, and Python/Bash. Skilled in data ingestion, visualization, and observability design across systems like ServiceNow and Cisco DNA Center. Proven ability to enhance real-time insights, platform performance, and operational efficiency through intelligent dashboarding and automation.

Work

Orange Business
|

Consultant

Gurugram, India

Groupon
|

Business Intelligence Analyst

Bengaluru, Karnataka, India

Summary

As a Business Intelligence Analyst at Groupon, I lead cross-functional initiatives to transform raw, disorganized data into accessible real-time dashboards and actionable reports, driving significant improvements in business processes and operational efficiency.

Highlights

Developed and deployed over 10 intelligence-sharing visualizations and management dashboards, providing real-time analysis of process metrics to enhance operational transparency and decision-making.

Led technical aspects across all phases of data projects, from defining intelligence needs and data metrics to implementing solutions, ensuring alignment with business objectives and driving successful data delivery.

Automated daily reporting by designing a procedure to publish snapshots from Kibana dashboards, delivering End-of-Day mailers/newsletters with critical summaries to stakeholders, significantly reducing manual effort.

Enhanced customer service process quality by designing and implementing an alert system that flagged and notified non-compliant tickets, improving adherence to business procedures.

Streamlined merchant deal management through an RPA procedure, automating the extraction and validation of weblinks/URLs from hosted deals and creating corresponding Salesforce tasks, boosting efficiency in merchant operations.

Configured, maintained, and installed highly scalable ELK Stack environments, alongside developing robust ETL pipelines, to process and integrate data from diverse sources for comprehensive business intelligence.

Real Time Data Services
|

Product Engineer

Gurugram, Haryana, India

Summary

As a Product Engineer, I specialized in building and maintaining high-performance, fault-tolerant data infrastructures, including ELK Stack, SIEM solutions, and robust database systems, to ensure real-time data availability and product stability for VoIP telephony services.

Highlights

Engineered and managed a centralized ELK Stack for logging across diverse applications and servers, utilizing Filebeat, Metricbeat, and Heartbeat to collect critical data and logs, ensuring comprehensive tracking for stakeholders.

Designed and implemented descriptive Kibana visualizations and dashboards for real-time monitoring of VoIP telephony performance, achieving and maintaining over 90% uptime through proactive data insights.

Deployed an open-distro Elasticsearch-Kibana cluster and integrated PowerCLI with Logstash to dedicatedly monitor vCenter data, enhancing infrastructure oversight and stability.

Developed and deployed a comprehensive SIEM solution using ELK, configuring alerts for Windows-based servers and Watcher to proactively identify and respond to security and operational incidents.

Architected and implemented a production-ready, load-balanced, highly available, and fault-tolerant VoIP telephony infrastructure, significantly improving system reliability and performance.

Managed and optimized MariaDB (MySQL) database clusters, including planning and implementing Master-Slave and Galera replication for high availability, alongside developing shell scripts for automated encryption, backup, and recovery.

Designed and configured an online reservation bot using AWS (Lex, Lambda, Polly), accessible over VoIP, demonstrating innovative application of cloud services.

Devs Journal
|

Contributor/Content-Writer Freelancer

Gurugram, Haryana, India

Summary

Contributed written content as a freelancer for Devs Journal, focusing on technical and industry-specific topics.

Wipro BPS
|

Associate

New Delhi, Delhi, India

Summary

Served as an Associate at Wipro BPS, contributing to business process services within a dynamic corporate environment.

Matter of Tech
|

Intern

Gurugram, Haryana, India

Summary

Completed an internship at Matter of Tech, gaining foundational experience in technology-related operations.

Volunteer

Rotaract Club of Delhi South
|

Club Secretary (Administration)

New Delhi, Delhi, India

Summary

Managed administrative duties and coordinated club activities for a community service organization, ensuring smooth operations and effective communication among members.

Comic Con India
|

Volunteer (Cosplay Registration)

New Delhi, Delhi, India

Summary

Assisted with event operations at Comic Con India, specifically managing cosplay registrations and providing attendee support to ensure a positive experience.

Education

Kurukshetra University
Kurukshetra, Haryana, India

Bachelor of Technology

Technology

DAV Public School
Gurugram, Haryana, India

Class XII

Secondary Education

OLF Convent School
Gurugram, Haryana, India

Class X

Secondary Education

Skills

Data & Business Intelligence

ELK Stack (Elasticsearch, Kibana, Logstash, Beats, Watcher), Data ETL (Extract, Transform, Load), Elastalert, Tableau, Data Visualization, Real-time Reporting, Actionable Insights.

Database Management

MySQL, MariaDB, Salesforce, SOQL (Salesforce Object Query Language), Database Replication (Master-Slave, Galera), Database Encryption, Backup & Recovery.

Programming & Scripting

Python, Bash Scripting, PowerCLI.

DevOps & Cloud Platforms

Linux, Jenkins, Docker, AWS (Lex, Lambda, Polly), CI/CD.

System Monitoring & Security

SIEM Solutions, Alerting Systems, vCenter Monitoring, Fault-Tolerant Systems.

Project Management & Collaboration

Jira, Scrum/Agile Methodologies, Cross-functional Team Leadership, Technical Documentation, Requirements Gathering.

Infrastructure & Telephony

VoIP Telephony Infrastructure, High Availability Solutions, Load Balancing.

Apoorv Agarwal