Managing Roaming partners: The management of the Roaming partners is an active Business Process in Telco. Few times in the month, Roaming Team used to give the requirement of roaming partners configuration in Billing systems for proper CDR Rating. Most of the time the actual change in Billing System and requested change were not same. After analysing we came to conclusion that there was a gap in understanding the E2E Business Process of Roaming Partners Management. Both teams were aware of specific part of process, but not as a whole. We helped in identification of the gaps and conduct couple of workshops. On top of awareness and transparency in teams, we also implemented a process of providing the data dump (excel with search macro) to roaming team so that they can do initial analyses of the requirement at their end. Due to this process, both team saved time and efforts up to 70% and also deleted non useful and duplicate records.
DB Sync: This project was mainly to synchronize all the database environments available to development team. We started with requirement gathering, handled all the database design & development phase and ended with UAT/deployment. The team consist of 3 PL/SQL Developers including me, our team was also responsible for DBA tasks (Data modeling, DB Designing, Installations, backups, performance & SQL tuning).