Piyus Kumar, Developer in Bengaluru, Karnataka, India
Piyus is available for hire
Hire Piyus

Piyus Kumar

Verified Expert  in Engineering

Database Developer

Bengaluru, Karnataka, India

Toptal member since June 18, 2020

Bio

Piyus is equipped with 12+ yrs of software development experience in building products in startups, the travel industry, and VMware. With a sound background in mathematics, he loves to play with data. Most of his time was spent writing back-end applications, providing scalable and high availability solutions to the distributed applications, and writing automated test suites and continuous integration to bind the application with a scale of robustness.

Portfolio

VMware
Kubernetes, Docker, Linux, GoLand, Go, Python, PostgreSQL
HTMedia Ltd
Linux, MySQL, Django, Python
Knowlarity Communications Pvt Ltd
RESTful Development, REST APIs, Django, Python, PostgreSQL

Experience

  • Linux - 10 years
  • Python - 10 years
  • PostgreSQL - 8 years
  • REST APIs - 8 years
  • Django - 7 years
  • MySQL - 5 years
  • DevOps - 5 years
  • Docker - 2 years

Availability

Part-time

Preferred Environment

Kubernetes, Docker, Go, Python, PostgreSQL

The most amazing...

...thing I have learned is a way to set the baseline of the product and continuously make it better every day,

Work Experience

Senior Member of Technical Staff

2015 - PRESENT
VMware
  • Made improvements to our product which spawns and deletes 150,000+ VMs every day.
  • Completed upgrades with very little downtime by using SQL script in phases and application design acceptability.
  • Wrote reporting SQL queries and designed beautiful charts.
  • Split several monolithic giant applications into microservices. Used Docker and Kubernetes to host on the cloud with easy deployment and horizontal scalability.
  • Wrote a pipeline script in Jenkins and Groovy to enable continuous integration wich verifies your code before submitting.
  • Introduced a test-driven development approach that helped set a baseline for our product feature before heading towards production and then later gauges the improvement based on that.
  • Improved the backup strategy with logical (pg_dump) and physical (binary files + WALs) backup availability.
Technologies: Kubernetes, Docker, Linux, GoLand, Go, Python, PostgreSQL

Tech Lead

2012 - 2015
HTMedia Ltd
  • Contributed to the revamp of the education portal of the giant Indian media company.
  • Improved the time to serve page bytes and rendering time in browsers using Steve Souders' high-performance websites technique. Improved the overall speed by 250%.
  • Added a review tool called ReviewBoard to the development process and used it to onboard all the developers across the company.
  • Prepared and delivered the training content for Python and MySQL along with coding guidelines for the new members of the company to enhance productivity.
  • Improved code quality after writing the unit test as an integral part of the project and increased code coverage.
Technologies: Linux, MySQL, Django, Python

Product Development Engineer

2009 - 2012
Knowlarity Communications Pvt Ltd
  • Created RESTful APIs using the Knowlus platform to make bulk calls and reporting—2 million calls per day.
  • Developed a CRM like a tool in Django using MySQL as the back end to handle the data for the sales team along with the call recordings; they target 10 million SMEs in India.
  • Developed a voicelet application using Knowlus back-end API and Facebook graph API. People were able to post voice messages on their Facebook wall following the IVR call instructions.
  • Involved in most of the architecture planning and DB migrations.
  • Served as the key person for any DB scaling improvement and review; we used PostgreSQL as well as MySQL for different projects.
Technologies: RESTful Development, REST APIs, Django, Python, PostgreSQL

Software Engineer

2008 - 2009
TravelBoutiqueOnline
  • Integrated GDS for air ticketing e.g. Amadeus and Hermes, for a web panel for booking air tickets and hotels by agents across India—15,000 tickets per day back in 2009.
  • Integrated hotel booking sources like HotelBeds, Tourico, and IAN (Expedia).
  • Wrote APIs to expose the search and booking for customers to integrate into their portal.
Technologies: SQL Server 2005, ASP.NET, C#

Software Engineer

2007 - 2008
Viplav Communications Pvt Ltd
  • Contributed to desktop software that matches voters in polling booths using Levenshtein distance algorithm for name matching on a probabilistic parameter of matches based on similar phonetic alphabets with acceptance rate 64%.
  • Created reports from SQL Server data with a variety of SQL queries.
  • Involved in most of the CPU time/memory-based performance improvement on old projects.
Technologies: SQL Server 2005, ASP.NET, C#

Experience

Dashboard Using Python, PostgreSQL, and Highcharts

Developed a dashboard which has interactive graphs using Postgres, Python, and Highcharts.
Customers get an insight into product usage in a different part of the system. It helped them to understand the real use and improve pipeline accuracy.
This has helped us to reduce the daily job numbers by 30% for many old customers and improved the reusability of the components. It gave a pathway to the new customers to accommodate their usage.

Continuous Improvements on The Ongoing Product

Usage of distributed cache improved part of the system speed up to 150%.
Making a shallow clone during the sync phase has sped it up by 5X, as it was earlier loading the whole index for the repo.
Instantiating machines by tracking historical usage and pre-configuration have reduced the machine requesting time by 50%.
Making use of multi-core processing at several places has given performance a boost up.
Wrote client-side binaries in Golang to make it independent of the client OS configuration and ease of use. Since Golang comes with cross-compilation, it has reduced the maintenance of the code and improved developer productivity.

A Giant MySQL Database Migration to PostgreSQL

Curated an existing MySQL database and successfully migrated it to the PostgreSQL cluster.
This was done along with an upgrade to the application which needed to run some offline processing to change the underlying data structures from the old format to the new format.
Added multiprocessing code in Python to handle the in-migration phase smoother and faster.
Adapted a load testing framework for the application to test it well before moving ahead to production.
We did set the baseline for the project to handle the 5X instant load on the production server.

Raahi a Carpool Initiative

A self-initiative carpool application which was made pledging the environment cleanliness. It can at least make 50% car off-road, which can majorly happen through awareness. It was used in the company to allow employees to be in coordination and find the carpool in the vicinity of their accommodation using the location of their accommodation and Google Map API. This way, we reduced the carbon footprint and gasoline usage in the city.

Alert and Monitoring Setup Using Grafana

Set up a list of Grafana charts using Prometheus client and pushgateway underneath. A lot of queries have been in execution on the PostgreSQL slave to get the data at a regular interval.
It keeps us aware of the system load and infrastructure status as our current project is mostly dependent on cloud-native applications.
It sends us alerts whenever a threshold is crossed.

HTMedia Educational Background

Worked for a revamp of the education portal of the Indian giant media company. The major work was to allow students a seamless experience while browsing content on the htcampus site, a lot of architectural changes like CDN, caching, and image resizing was involved.
Developed an SDA (student dashboard access) app using Python, Django, and MySQL. It was used by a team of callers to update certain info after calling the students over the phone, which can later be sent to colleges using an automated filter job.

Knowlarity an Exposure With APIs

Wrote a Django-based REST API called Knowlus for the product to be exposed to the customers. Customers can easily integrate the REST API on their end and enable it themselves to use bulk calls wherever needed.
Used C/lua based open source FreeSWITCH API and integrated with Python to make an IVR system to make and receive bulk calls. This was using the PRI lines from a telecom service provider and PRI cards to connect them in the computer.

Education

2003 - 2007

Bachelor of Technology Degree in Computer Science and Engineering

Dr K N Modi Instt of Engg and Technology - Ghaziabad, India

Skills

Libraries/APIs

REST APIs

Tools

Git, Celery, GoLand

Languages

SQL, Python 2, Python 3, Python, C#, Go

Frameworks

Django, Django REST Framework, ASP.NET

Paradigms

Database Design, DevOps, Testing, REST, RESTful Development

Storage

PostgreSQL, MySQL, DB, Databases, Memcached, Database Migration, SQL Server 2005

Platforms

Docker, Kubernetes, Linux, Amazon Web Services (AWS)

Other

Performance Tuning, Database Optimization

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring