| Skills |
| Telecommunications Billing: Programming and Analysis |
|
Extensive experience in SMDR Call Detail processing and reporting, including retail and wholesale long distance rating, billing and internal call accounting; phone bill analysis; vendor comparisons; importing CDR data from billing files and exporting data to billing applications, tax rating vendors, and wholesale customers. Creation of web applications for customer invoice and call detail viewing and downloading.
|
| Systems Analysis |
|
Reviewing and documenting procedures and operations; programming solutions and streamlining automated and manual tasks; converting operations between programming languages; data interfacing; task automation; documentation and implementation of user requirements.
|
| Database Design and Management |
|
Database design and management in MS SQL Server, Oracle, and MySQL. Extensive SQL query programming. Oracle PL/SQL programming, including conversion of legacy COBOL code to PL/SQL stored procedures. Extensive MS Access experience including VBA programming.
|
| Web Programming |
|
Perl, PHP, ASP, and ASP.Net programming integrated with MySQL, MS SQL, and Oracle databases. Extensive HMTL experience, including CSS. Some experience with Ruby on Rails and object-oriented programming.
|
| Operations Programming |
|
Automated file retrieval, processing, reporting, etc. in Perl, PHP, OS scripts. PL/SQL reporting applications and queries. Forms, processing and reporting in Access including VBA. File processing and reporting in COBOL. Small-business telephone wiring and phoneset/phone system programming on various platforms.
|
| Management |
|
Manage programming teams and outside contractors for IS departments.
|
| Other Computer Experience |
|
Extensive experience with operating system and applications in Windows, Macintosh, Unix, HP3000/MPE, and other environments. Maintenance of email and web hosts in Unix, Mac OSX Server and IIS.
|
|
| Experience |
| Backbone Communications, Los Angeles, CA (May 2005 – Current) |
|
Programmer/Analyst and IS Manager. Responsible for operations and LCR analysis databases, PHP, Access, SQL Server, Unix and Windows System Administration, formulating backup plans, Perl data loading and unloading, Excel file to database, management of IS team for wholesale TDM/VOIP telecommunications provider. Created web-based customer front-end for viewing and downloading invoices.
|
| Open Source Programming, Los Angeles, CA (July 2004 – May 2005) |
|
Creation of open-source Telecommunications call accounting and retail billing application using Perl, PHP, MySQL on Unix/MacOSX Server platform. Responsible for all aspects of system.
|
| Cybertel Communications Corporation, Vista CA (January 2000 – June 2004) |
IS Manager. Created and managed all aspects of a custom long distance billing application. Created and managed Perl scripts for FTP data collection, retail rating, FTP lockbox billing integration, data manipulation, exception reporting and export to print shop. Created and managed ASP web-based user screens, including multi-level security, data entry, reporting and online invoice viewing.
Managed or created entire company web site, including sales information, new customer online sign-up, and customer invoice viewing.
IT manager. Supported email, file, database, and web servers and network, user PC configuration.
Programmer/Analyst – The Giving Card (a division of Cybertel). Created and managed all aspects of a web-based credit card affinity program application. Designed, created ASP.NET user screens, Perl data processing and file i/o. Managed outsourcing of application to Cybertel subsidiary BigVault Storage Systems.
|
| Telenomics, Inc, Temecula CA (January 1988-May 2001) |
Senior Customer Engineer, VP Customer Support. Application design, programming, management and documentation for MPE/HP3000, HP-UX, and Windows call accounting software. Worked with all aspects of system.
Managed development team and directed conversion from legacy mainframe to client-server ODBC to web-based application. Worked with customers to specify requirements and implement standard and custom applications.
User training, customer support and sales support; telephone and remote support for several hundred customers across the US. Travelled to customer sites for pre-sale consulting, on-location system install and training, and follow-ups.
|
| Freelance computer support (January 1988-Current) |
|
Computer support, computer instruction, web page design and domain hosting, email hosting; PHP and MySQL programming; primarily with MacOS including OSX.
|
|