Projects
Automation and Coding was my passion and as a result I was always predisposed to such tasks. I continuously kept on learning new and efficient ways of handling complex scenarios. As time went by and my works came into light, this remained no longer a passion but a career path and my primary job role. Among many of my developments, I am highlighting some them below.
Auto messaging API Coding
Design and Code
There has always been a target to reduce the MTTR (minimum time to restore) in order to garner customer satisfaction. There were certain types of critical faults which resulted outages and our teams wanted the responsible engineer be notified in a faster way rather than via a human agent. So I have developed an SMPP code which will shoot sms to the concerned engineer in case of abnormality in the system. I have also integrated telegram bot with it so that the platform can reach the engineers through internet as well. Finally made an api which could be called to send notifications. I also have made a front end CRUD app to manage the whole platform as well as the back end database from one single place.
User experience automation
Design and Code
One of the major reasons of customers dissatisfaction was latency while using internet. Traditional way of checking latency by ping doesn't always reflect the real user experience. So I have developed a system which will periodically keep browsing and perform activities just like a human and report back the latency of each use case. These tests will keep on going in different virtual machines where we want to check the internet quality and all the reports will come back to a central server. I have also made a dashboard which will show a graphical comparisons among the machines. This brought up the actual feel of a user to our table and later on several identifications as well as rectifications were performed.
JSON decoder of a bulky and streaming file
Code
One of our peripheral team were facing issues when parsing a certain JSON file in which all the base stations continuously reported their logs. There were over thousands of base stations and this count kept on increasing. So the file was very big in size (~5 GB+) which also happened to be updating every second. This caused the existing monitoring tool to lag after certain period and also chocked servers RAM memory. To extricate them out of this situation, I have developed a code which will use the pointer method of php. The code will only remember the byte where it last decoded instead of loading the entire file into memory. As a result, it will not crunch the memory of the server. It will also parse the JSONs according to the requirement and feed back to their database. Previously where it took an hour to perform the task, this development reduced it down to seconds.
Convergent tool and XML decoder
Design and code
There was a known outage and revenue impact due to a malfunction of certain network service. This project was all about to invent a way forward to tackle this situation. All other network services used to communicate in XML format with the affected device. So I have established a server which will have same communication matrix as the affected device. Whenever the service sensed down, this alternate route will be activated and will get the data from all other network devices in XML format. My code will then decode the XML, perform mathematical calculations according to business logic, make new XMLs for rest of the end network elements and finally submit it. This innovation completely eliminated the revenue dent that we used to face for this particular outage.
Business configuration Sync
Desing and code
Short codes dedicated for companies and business configuration syncing were one of many tasks which was required to be accomplished within strict timeline. This task involved more than 75 different network elements spread all across the country. An average of 7 commands needed to be performed in each node resulting of 525 commands! This took almost a week of 8 human agent to complete the task. I took the project to automate the whole scenario. This included a dashboard with a visualization of end to end workflow and historical logs. The user will only have to upload the excel sheet containing the required configuration. The excel is first decoded using python and then socket programming of php coding was used to complete the back end workflows.
