Jenry D. Sumalbag

Block 21 Lot 14 Reno Street Ciudad Grande Phase 2, Lawa, Meycauayan City

PHONE: 09054437377

E-MAIL: [email protected]

Work experience

Nov. 2016 – Oct. 2018

Globe Telecom, Inc.

Revenue Assurance Manager

·         Provides revenue reports and analysis for management reporting to share and update them regarding the status of business revenue.

·         Lead to develop a revenue assurance strategy for all revenue streams, including identification and prevention of revenue leakage activities, evaluation and improvement of controls coverage, gap analysis, expansion of controls across systems and products.

·         Manage and implements daily revenue assurance control such as revenue trending, data reconciliation and validation to monitor and avoid possible revenue leakages.

·         Accountable for the process, including the design and execution of new controls to deliver new capabilities which facilitates revenue recovery and cost saving across all revenue products.

·         Establish and lead the team to collaborate with other business partners (IT, BI, Finance, Billing, Marketing, etc.) in any business, systems or revenue issues that may arise to help them strategies and recommends possible solutions for the fix.

·         Optimize data, develop SQL scripts and automates manual revenue control processes to be more accurate and efficient.

·         Ensuring major leakage issues are rapidly detected and resolved.

·         Assess and report the team’s achievements and performance

Oct. 2013 – Oct. 2016

Smart Telecom Inc.

Revenue Assurance Supervisor

·         Accountable for ensuring completeness, data optimization and accuracy of data to be utilized across all Revenue Assurance team.

·         Implements data reconciliation of Call Detail Records (CDR) switch versus billing system to to avoid revenue leakage.

·         Upholds integrity of data through parallel checking/testing of all revenue streams parameters involved in reconciliation.

·         Regularly reviews, validates and updates data call types reference for R.A. team to be used for revenue assurance reports.

·         In charge in data validation and data recovery from all source systems and platforms

·         Recommends necessary changes or corrections as needed.

·         Analyzes cause of escalated errors / discrepancies at the source data level and coordinates with concerned groups.

·         Initiates inter-department coordination with relevant groups (IT, Technical, etc.) to swiftly resolves issues.

·         Develops program for the automation of CDR database upload using MS SQL automated packages and stored procedures.

·         Develops tool for data extraction and databases used for call detail record (CDR) processing, reconciliation and report generation for revenue assurance.

·         Web developer / programmer for revenue assurance intranet / ireports web portal.

·         Develops SQL scripts to be used for CDR and data validation.

July 2007 – Oct. 2013

Digitel Mobile Phils. Inc. (Suncellular)

Revenue Assurance Supervisor

·         Develops program for the automation of CDR database upload via File Transfer Protocol (FTP) being used for daily revenue text report.

·         Develops tool for CDR extraction and databases used for call detail record (CDR) processing, reconciliation and report generation for revenue assurance.

·         Web developer / programmer for revenue assurance web portal.

·         Develops tools for revenue assurance and fraud requirements using SQL automated packages and stored procedures.

·         Responsible for the creation of SQL scripts to be used for CDR validation

·         Prepares subscriber usages and top-up for management reporting.

·         Monitors subscribers abusive call usage trending to avoid revenue leakage.

·         Monitors Revenue Assurance server, maintains and backup database.

·         Monitors daily scheduled batch processing and automated programs for report generation.

·         Participated in Users Acceptance Test (UAT) to validate subscriber profile configuration and business rules before the implementation of new products and services.

Jan. 1998 –  May 2006

Express Telecom (Extelcom)

Database Administrator / Fraud Analyst

·          Detects and updates cloned numbers through Extelcom  Watchdog System.

·         Monitors fraud server and extracts cloned mobile numbers.

·         Responds to job requests regarding bill adjustment of fraudulent calls.

·         Responsible for database optimization for fraud team.

·         Provides automation of Data Collection and Report Generation for efficient and accurate data.

·         Sets and troubleshoots fraud detection utility and link connections, system configurations and other technical works.

·         Analyze and validates call data record integrity & accuracy.

Education

1992 – 1997   Adamson University Manila

B.S. Computer Science

1987– 1991     Saint Pius X Institute

Cuyapo Nueva Ecija

1981– 1987     Cuyapo Central School

Cuyapo Nueva Ecija
Operating System / Software Application skills

MS SQL (Client & Server),  SQL Server Integration Services (SSIS)

Extract, transfor, load (ETL)

PHP, HTML, CSS, Javascript,

TCP/IP Networking,  FortiClient, VNC

MS Windows / NT, MS-DOS

MS Office (Word, Excel, Powerpoint)

MS Front Page, Dream Weaver, Web Style,

Hardware Experience

Personal Computer (PC)

Laser Jet / Inkjet printers

Image Scanner

Fax and Modems

Router, LAN computer connection set-up
PERSONAL INFORMATION

Date of Birth : June 15, 1974

Place of Birth : Cuyapo, Nueva Ecija

Citizenship : Filipino

Sex : Male

Civil Status : Married

PERSONAL REFERENCE

Mr. Don Nino Santos

Revenue Assurance Director

Globe Telecom,  Inc.

0917-5889070

Mr. Harold Tyrone Cruz

Revenue Assurance Manager

Globe Telecom, Inc.

0917-6880952