Resume

Sign in

Service Developer

Location:
Phoenix, Arizona, United States
Posted:
April 21, 2018

Contact this candidate

Resume:

Victor Manuel Magana-Lopez

Resume

Senior Systems Analyst and Developer with over 15 years of experience working with IBM’s AS/400 based Customer Care and Billing (CC&B) systems in the Communications industry. Most of this involved the DPI integrated CC&B. I have experienced with implementation, conversion, and production operations. Worked in all CC&B application areas including Service Orders, Plant, Provisioning, Rating, Billing (including Products and Call Detail), Accounts Receivable, Control Records, Customer Inquiry, and Trouble Reporting.

Relevant Project Experience Summary

Frontier Communications

DPI CC&B Gap development for conversion of 4M customers

Group Service Order Enhancement

Automated Pre-Order Loop Qualification

Speed Display Information for Given Line Cards via SalesForce.com

TelMex – DPI CC&B Analysis and Gap development for 34 conversions of 8M customers

Conversion Data Mapping and Coding

Gap Design and Development

South Bay Consulting Services – May 2016 – Present

Senior AS/400 Developer for any company that needs maintenance or enhancement for current system also provides posting programs (RPG ILE/RPG Free with Embedded SQL & DDL or DDS database) and production on call support.

Frontier Communications – April 2014 – May 2016

Senior Developer for support, maintenance, and enhancement of the AS/400 based DPI CC&B. Technical environment consisted of RPG ILE/RPG Free with Embedded SQL & DDL or DDS Database. Specific responsibilities and projects included:

Trouble Ticket Quality Initiative Phase 2

Need the ability within the work schedule calendar to manage the number of appointments that are scheduled and assigned for OOS trouble tickets.

Service Area Master - Create Mass Address Upload Process for Bulk/Non Bulk Properties

Enhance the existing HOA ID Maintenance Screen (PL0170R) program routines with mass update functionality to add, move, change, and delete records in the PLHOA Master File and to update the Service Area Master (SAM) File records associated to the (HOA) Connected Community Property ID

Service Area Master – DPI Cable Pair to Address Dedication

Provide the Connecticut U-verse customer base with the same level of in-house functionality and quality of service, as offered by AT&T

Plant Line Card - Service Qualification.

Enhance its OSS/BSS systems to provide the Connecticut customer base with service ordering, activation, billing, and account maintenance support for the U-verse product.

Modify service qualification logic as it relates to the service address and terminal to support CT U-Verse Network. Enhance.

Automation of the SOA (Service Order Administration) activation for Port In (PI), LNP Winback (WT) resale orders, and Intra-Company port.

Multiple Switches serving common serving areas Intra Company Porting and Native Switch Phone Auto Assignment.

Billing System - CT Regulated Customer Communications

CT regulations require customer notification of activities that will impact their billing charges.

Service Order - support Over-The-Air (OTA) video services (branded as Freedom TV)

Dixie Supplies – May 2013 – March 2014

Senior AS/400 Developer for Estimating and Distribution Systems. Developed, maintained and supported Price, Cost, and Additive maintenance and posting programs.

Frontier Communications – 2010 – April 2013

Senior Developer for support, maintenance, and enhancement of the AS/400 based DPI CC&B. Technical environment consisted of RPG ILE. Specific responsibilities and projects included:

Service Order Inquiry and Maintenance

Service Order Group Orders Enhancement

Created a Group Order (Multi-Line) process in CRM that allows the Commercial Universal Service Rep to place one order flow for the same customer with multiple lines, and allow multiple addresses that will create order numbers for each line to flow to DPI for provisioning.

Service Order – CLEC USOCs

Automated Loop Makeup/Loop Qual Pre-Order Transaction

FiOS Service Order / Trouble Ticket

Synchronoss Trouble Tickets

LSR Embedded Wholesale Conversion/Preorder Embedded

Verizon Corporate Rewards Plan

Summary Billing Discount Enhancements

LSR - Trouble Administration Phase I and II

Mediate and Deliver DUF Files to CLEC

WATS Hotcut Coordination Service Order

Vertex Implementation – Tax Calculation Interface

FiOS Multiple Dwelling Units (MDU) Project

Service and Equipment (S&E) Scrub process

CCST Historical Data Load to Pluto (FTP).

Created DPI files that contain a snapshot of all converted F13 accounts including billing data, S&Es with activation dates for the S&Es, and sales reps.

These files will be used to determine which of the customer accounts are F13 and used to calculate churn logic and upgrade/downgrade and sidegrade logic in CCST.

FTR13 Conversion – One-Time Credit/Debit Card and ACH Fees

Trickle Cash – Decommissioning of Verizon Systems

DPI Contract changes related the Commercial E2E project. S&E item codes

DPI Contract changes related the Commercial E2E project - Contract DB

DPI Contract changes related the Commercial E2E project - Billing Enhancements

DPI Commercial Replication – Available Address Speed

DPI Credit Check Enhancements and Collection Agencies Files

Plant Line Card - PSAMAS Changes. FTR13 has address fields (house number prefix, house number suffix, and post directional fields) that are not adequately cared for in the physical service address file structure in DPI.

Service Order and Trouble Tickets to EDW

Automate Preorder Loop Makeup - Loop qualification Transaction.

The Frontier 13 systems provide an automated Pre-order Loop Qualification/Loop via Verizon applications.

Available Speed information for a given Plant Line Card PSAMAS address. requirement for Salesforce,”SF” to display Available Speed information for a given address.

Telgua (Telefonos de Guatemala) – 2008 – 2010

Senior Developer for support, maintenance, and enhancement of the AS/400 based DPI CC&B system. Technical environment consisted of RPG ILE & COBOL. Provided day to day support for the following modules:

Billing

Payment and Adjustments

Customers Credit Limit

First Communications – 2007 - 2008

Senior Developer for enhancements and support of this AS/400 based Teleflex Customer Care and Billing System. Technical environment consisted of RPG ILE. Participated in Development and implementation of the following systems enhancements

Margin Analysis for the following vendors: AT&T, Sprint, MCI, Qwest, Smart Telecom.

Tier and Revenue Assurance module

Implementation of Thousand Block feature over Teleflex system

Customer Auto-provisioning and suspension

Teleflex System Integration from San Diego to Akron, Ohio

TelMex (Telefonos de Mexico) – 2005 - 2007

Senior Developer for enhancements to the AS/400 based DPI Customer Care and Billing system. Technical environment consisted of AS/400 RPG ILE & COBOL. Developed and implemented enhancements, as well provided day to day support for the following DPI modules:

General Plant

Trouble Tickets

Service Orders

Internet Infinitum

Telgua (Telefonos de Guatemala)

Developed and Implemented Improvements, as well provided day to day support for the following DPI modules:

Billing

Payment and Adjustments

Customers Credit Limit

Acceris Communications – 1999 - 2005

Senior Developer responsible for enhancements to the AS/400 based Teleflex Customer Care and Billing System using RPG ILE. Participated in the development of the following systems enhancements

Traffic Answer Supervision (Incoming and Outgoing Traffic)

Customer Purge and Unpurged

Vendors and Carriers Maintenance and Reporting

Implementation rating modification for new products

Un-price and Re-price Customers Traffic

AMA conversion and Rate Toll Tickets Traffic

Revenue reports

Attrition reporting (New and Repeat Lines)

Vertex Long Distance Taxation

Telefonos del Noroeste – 1991 - 1999

Project Leader, Analyst and Senior Developer for numerous conversions to the AS/400 based DPI Customer Care and Billing system using RPG ILE and COBOL. Primary responsibilities involved the conversion of over 8,000,000 access lines from each state in Mexico plus Guatemala (33 conversion) to the DPI applications. Specific responsibilities included:

Participated in the enhancement of the following DPI modules, and their implementation for Telmex: General Plant, Trouble Tickets, and Service Orders.

Converted Service Area Master from multiple old TelMex systems into DPI.

Created an Automatic assignation feature for Repairs in Trouble Tickets.

Created an Automatic Installer assignation feature for new orders in Service Order module when a customer needs a new telephone installation.

Developed multiple reports for Service Orders, Plant, Long Distance, Customer complaints, Payments and Adjustments.

Several Companies (Government and Private) – 1978 - 1991

Project Leader and Developer for a variety of projects and companies. The technical environment consisted of the IBM 4341, COBOL, and VSAM for data access system. Specific responsibilities included the enhancement and day to day support of the following applications:

General Accounting

Inventory

Unit Cost

Account Receivable

Payroll

Yearly Tax Return

Assets

Gasoline Control

Tax Collecting

Managerial Statistics

Human Resource and Bureaucracy



Contact this candidate