Uttam Roy Email and Phone Number

Job responsibilities:● Plan configuration management of mediation system for mapping the call/event recordsthose are collected from different network elements to achieve the company’s business goal.● Project planning and management, Disaster recovery management & Vendor management.● Analyze the existing business processes to introduce new guidelines, better techniques etc. for constantimprovements/automation on the process, reports, and tools.● Identify the security gap of own area and take necessary action to enforce security as per Robi securitypolicy.● Meet product service delivery objectives to internal stakeholders by analysing requirements, prioritizingdeliverables, suggesting alternatives and implementing products as per business process (SOP).● Build coalition building, teamwork among internal & external stakeholders and shows sense of urgencyin case of business needs.Achievements:● Saved CAPEX of $423K through inhouse development in 2018 for MNP project.● Saved CAPEX of $226K through inhouse development in 2022 for different projects includingTMS(BTRC).

Lead the configuration of Mediation workflow/Node integration/Service integration etc. and ensure theE2E service delivery from upstream to downstream.● Configure Advance data product/VAS configuration.● Meet product service delivery objectives to internal stakeholders by analyzing requirements, prioritizingdeliverables, suggesting alternatives and implementing products as per business process (SOP).● Analyse the existing business processes to introduce new guidelines, better techniques etc. for constantimprovements/automation on the process, reports, and tools.● Coordinate and follow up vendor on technical issues for proper and timely delivery of service andsupport.● Identify the security gap of own area and take necessary action to enforce security as per Robi securitypolicy.● Build coalition building, teamwork among internal & external stakeholders and shows sense of urgencyin case of business needs.

Job responsibilities:● Configure mediation system (HP IUM) for mapping the call/event records according to business& charging requirements.● Manage and configuring all the processes of CDR collection from different network elements,processing and distribution to the downstream system.- Working on Ericsson, Huawei [Packet & circuit], and ZTE switches. Alcatel & Huawei SMSC.- Huawei IN, GPRS, WAP and MMS systems.● Ensure backup CDR files.● Generates management report.● Design and develop in house system as per departmental needs.● Integration of OCS with mediation & provisioning.● Ensure system health, disk usage management, smooths operation and record keeping of automated logs.● Ensure system availability and taking actions to minimize system downtime in case of disaster.Achievements:● Experienced with the CDR format of Ericsson ASN.1, Huawei Soft Switch and fixed lengthASN.1 and ALCATEL fixed length ASN.1● Handling huge volume (500 million/day) CDR of 10 million concurrent subscriber base.● CDR based analysis and reporting.Development:● Developed a reporting system using java 2.0, php 5, oracle 11i and shell script.● Prepaid Itemize System using java 2.0, php 5, oracle 11i and java script to provideperiodical customer usage information and handle online customer charging complain.● Developed several CDR file collection, distribution and reconciliation process using shell script.● SMS and email-based monitoring process using shell script, java 2.0 and oracle 11i.● VAS CDR processing system using perl.

Job responsibilities:● Prepaid and postpaid subscriber provisioning in HUAWEI IN and HLR.● Prepaid service provisioning HUAWEI IN and HLR.● Postpaid service provisioning in BSCS.● Postpaid provisioning system BSCS (GMD/VMD) monitoring and maintenance.● RBT provisioning system monitoring and maintenance.● Handling miscellaneous complaints of prepaid and postpaid subscribers● Resolve service data mismatch on HLR.● Monitoring and maintenance of standalone provisioning applications.● Generates management report.Achievements:● Around 10 million subscribers provisioning in IN, HLR and BSCS.● Around 20 million services provisioning in HLR and BSCSDevelopment:● Developed RBT provisioning System for Real time customer CRBT provisioning process to provisioncustomer in IN (Prepaid), BSCS (Postpaid) and HLR using java 2.0, oracle 11i and shell script.● Developed System monitoring process using shell script and oracle 11i.

Job responsibilities:● Monitor and Resolve alarms generated through RAID system.● Postpaid/ Prepaid Rate Check.● International Roaming (TAP IN / TAP) Rate Check.● Reconcile Commission/GL reports.● Bill Cycle verification.● Interconnect reporting accuracy.● Maintenance of the Revenue Assurance database.● Upload, Process IN subscriber dump and generate report.● Upload, Process Billing database (TABS) dump and generate report.Developments:● Developed a system to process International Roaming (IR) files to perform rating check, rejectprocessing and generating reports by using PHP5 and Oracle 9i.● Developed various reporting tools to support business needs by using PHP5 and Oracle 9i.● Working on a project ‘Re-rating Engine’ to process IN (Siemens)/MSC (Huawei/Siemens) CDRdaily to perform rating check of prepaid and postpaid CDR by using Java 2.0 and Oracle 9i.

Job responsibilities:Provisioning System:● Monitor the flow of provisioning requests to provisioning system● Generate provisioning request and reports on provisioning activitiesMediation System:● Monitor flows of CDR through Collector, Decoder, Normalizer and Rating process.● Take proper action in case of any interrupt in the flow of CDR through those processes.● Generate daily and monthly reports on file counter records.Rating System:● Configure Rate Codes, Rate Plan and Charge Matrix.● Reprocess rejected CDR s. Generate daily reports on online rating status, pending rating, CDR statistics.Other responsibilities:● Write shell and perl scripts to enhance monitoring process.● Develop various reporting tools using PHP 5 and Oracle 9i.

Job responsibilities:● System analysis, design, coding, debugging, testing and provide user end trainingDeveloped Projects:● Club Campus: A web-based community site.● Blog Portal: A blog site.● Blog CMS: A blog site where a user creates own HTML Pages.● Sophie: An E-commerce Site.