Shardul Bhot

Solution Integrator

Ericsson•  May 2022 - Present

UNN Brunei ● Development of 95/5 DataBurstBilling solution from scratch, to bill data bursts during high demands & process monthly bandwidth consumption using configured data burst charge tariffs. ● Development of LateCDRDebitNote solution from scratch to generate a report of amount calculated from late CDR's which will applied in form of debit note and charged to the customer in next upcoming billcycle. ● Development of OnDemand_Billing report to generate a report having list of customers which are to be billed on or by the date passed as an input. ● Development of ServiceTerminationReport_Alert to generate a report of services ending between day range from a reference date on an user input passed date & user input day range & send notifications to impacted Account managers as an alert. ● Development of OM_MAPPING solution from scratch to post one time charge to existing customer as per bill plan selected on billing frequency of customer & development of trigger to post one time charge on new customers opting for this bill plan. TMNL ● Developed Python code that reads all Excel files using openpyxl package from a directory and insert data inside it into database tables, thus automating data loading task and reducing time required for data input and manipulation by 50%. ● Automated provisioning and baseline configuration of virtual machines using Vagrant and manipulation in Vagrantfile, reducing manual configuration time and increasing efficiency. ● Cythonized python code to improve performance for computationally intensive tasks which also allows easy integration with other programming languages and libraries and enables code reusability. ● Proficient in creating sequence diagrams, activity diagrams, and class diagrams using PlantUML to visualize software architecture and system design of complex code base. ● Proficient in creating custom Docker images using Dockerfile to package and deploy applications as containers. ● Contributed to complex modularized Python code base, modifying multiple files to meet the requirements outlined in high-level design (HLD) ● Utilized version control tools (such as Git) to manage code changes and ensure stability of the code base. . Ericsson Internal ● Developed rule-based chatbot using Microsoft SDK Chatbot & Python, creating a conversation flow & rule-based system, and implemented a data management system enabling upper management to extract data from large Excel sheets via filters. TMNL Migration - Successfully executed and managed database migration activities for a complex Data Migration Framework (DMF) architecture. - Manually ran SQL scripts for each release, ensuring a seamless transition of the database from the source version to the target version. - Proficiently utilized Unix commands and DMF architecture to facilitate the migration process. - Conducted thorough sanity testing to verify the integrity and consistency of data after each migration, identifying and rectifying issues promptly. - Demonstrated a strong aptitude for debugging errors encountered during migration activities by adapting SQL scripts and XML configurations as necessary. - Accomplished approximately 8 migration projects, including high-stakes production migration successfully. - Actively managed Docker pods by performing tasks such as scaling, killing, and restarting, gaining hands-on expertise in Docker commands and container orchestration. - Developed and implemented automation scripts for comparing database objects before and after migration, streamlining quality assurance and reducing manual effort.

Associate Developer

Atos•  August 2018 - April 2022

Configuration of services, rateplans, free units and promotions, rating packages, usage types, business scenarios and complex condition for offline rating purpose by designing scripts, complex procedures & triggers in PL/SQL . ● Configuration of client customized product offers, event handlers for notification communications. ● Reviewing bugs and defects reported by front end developers and troubleshoot towards fine tuning software deliverables. ● Involved in migration activities of critical customers using Unix/Shell scripting . ● Involved in analysis & resolution of rating issues, solving of environment errors & retrofit issues, DBA related table extraction activities.