Summary
Overview
Work History
Education
Skills
Timeline
Generic

Somil Guglani

Rohtak

Summary

Accomplished Data Engineer at Prepladder with expertise in SQL and Linux, driving a 30% reduction in system downtime through automation. Proven ability to manage database performance and enhance team communication, ensuring data integrity and compliance. Adept at utilizing Python and Git for efficient project execution and collaboration.

Overview

4
4
years of professional experience
17
17
years of post-secondary education

Work History

Data Engineer

Prepladder
Chandigarh
01.2024 - Current
  • Ensured regular backups and supported disaster recovery efforts
  • Reduced system downtime by 30% through automation
  • Linux Server patching, db maintenance and SSL deployment
  • Proficient in gathering, cleaning, and processing large datasets using tools like SQL, and Excel/Spreadsheets, ensuring data integrity and accuracy for subsequent analysis.
  • JIRA ticket handling by enhancing documentation, standardizing updates, and prioritizing urgent requests, leading to better team communication and faster issue resolution.
  • Executed 50+ Ad-hoc SQL queries in Amazon Redshift to generate an end-to-end view of Product Metrics, including Free and Premium bifurcation. This includes the data comparison in three types, Today, MTD and YTD.

Product Engineer

Ameyo
Gurgaon
04.2021 - 01.2024
  • Hands on knowledge on SIP, PRI, VOIP, CODEC and Asterisk
  • Installation of Application Server, Database Server, CRM server and Call Server into client places and Product Training and on-site support to customers
  • PostgreSQL Database administrators - install, configure, upgrade and migrate existing databases
  • Successfully configured and deployed server at client side.
  • Managed access controls for 100+ database users, enforcing encryption and auditing for compliance
  • Monitored database performance using tools like Zabbix, leading to 50% faster issue resolution through proactive alerts.

Education

Bachelor of Technology - Computer Science & Engineering

Maharashi Dayanand University
Rohtak
04.2001 - 01.2018

Skills

Networking

Linux

SSL

Database

RDS

undefined

Timeline

Data Engineer

Prepladder
01.2024 - Current

Product Engineer

Ameyo
04.2021 - 01.2024

Bachelor of Technology - Computer Science & Engineering

Maharashi Dayanand University
04.2001 - 01.2018

Similar Profiles

CREATE PROFILE
Somil Guglani