SUMMARY:

• A decision - making and productive information technology professional, with extensive experience in programming and applications development, systems analysis and engineering, computer operations, data application services, training and development.
• Ensures the presence of cutting-edge tools and updated systems within a diverse environment.
• An adaptable coordinator, who streamlines processes and maintains the simplicity of programs to grow and improve company operations,.

TECHNICAL SKILLS:

• PL\SQL
• Oracle SQL
• C
• Perl
• Oracle
• SQL Server
• UNIX
• Microsoft Office Suite
• TCL
• T-SQL
• SQL Developer

PROFESSIONAL EXPERIENCE:

Confidential, Monroe, LA

Lead Deveeloper

Responsibilities:

• Developed program to insert/update records loaded in to the CAJUN system from the CRIS system for accounts that have combination products between the Ensemble and CRIS systems.
• Created Perl script to replace the billing telephone number stored in each table in the CAJUN system when it has changed. This required having the Perl script dynamically build the SQL for each table by looking up the columns and index columns to complete the process.
• Modified billing records IVR (Invoice Verification Response) extract program to use partitioning versus billing account number substring for record lookup.
• Mentored new team member (new college hire) with several changes to source code, shell, Perl, and SQL scripts.
• Modified Perl script used to create daily balance report to automatically calculate daily variance and print values to a file that can then be copied and pasted into the report spreadsheet.
• Chaired meetings to resolve issues with data not being transmitted to the CAJUN system from CRIS.
• Created views to be used by SQL scripts used to copy data from the Ensemble system into CAJUN.
• Resolved issues on ACH files from outside vendors on daily basis.
• Created process to identify records in CAJUN system where the ban has multiple btns or multiple bans point to the same btn. This involves using Perl to identify the records to be corrected and inserted into a table that are then removed by a PL/SQL script.
• Perform daily error resolution.

Contractor

Responsibilities:

• Developed COBOL program to insert charges and adjustments for combo accounts in support of the ICE project.
• Created Perl script to compare two data files and list differences to be sent to reporting agency.
• Resolved issue of records being duplicated for collection agencies.

Software Engineer

Responsibilities:

• Develop and maintain TCL scripts with embedded SQL for Oracle database used to process and resolve issues with credit card transactions received prior to being sent to the credit card associations to ensure the data meets the proper criteria.
• Created CSV files for reporting 1099K data for merchants managed by Merrick Bank.
• Created XML document to be sent to major credit card processing company for the Acquirer Merchant Master File processing.
• Created PL/SQL script to automate the backup of data from production DB as part of the month-end financial process.
• Resolved and recovered transactions that had been deleted in error from the Oracle database. This involved reloading the data via the front end loader into a development/test database. Then transfer the missing records into the production Oracle database. This required a PL/SQL script to check the production database tables to avoid duplicate records.
• Created views in Oracle database to list transactions rejected by the association and list the error message based upon the reason code.
• Resolved issue of error processing for rejected Discover cards not being inserted into the error table due to incorrect embedded SQL in TCL script.

Consultant

Responsibilities:

• Reviewing Perl scripts to port to new environment running on Solaris 5.10
• Performing analysis and updating Perl scripts to work with new directory structure based upon requirements from contracting company.
• Review of scripts ported by junior level developers in India to ensure correct modifications made.
• Perform acceptance testing of the scripts to ensure they will work properly in new environment.

Mediation and Usage Analyst 3

Responsibilities:

• Created Perl scripts run on Netezza DB to retrieve call-detail records used in error-suspense analysis.
• Developed Perl script to interface error suspense records in Revchain billing system with original call detail records in the Netezza mediation database.
• Developed Perl script to create Excel spreadsheet, listing toll-free call counts for customer on recurring basis.
• Established Perl script to build EMI format files containing calls billed to wholesale customers, validating charges of customers from database on AS400 system.
• Assisted team members in development of Oracle SQL scripts for query optimization.
• Resolved over $100,000 in error suspense by correcting errors in the system or informing service delivery personnel to correct information on the switches. This involved creating a PL/SQL script that would perform the steps of analyzing the data to see what was missing or needed correcting.
• Interfaced with vendor providing mediation of call detail records to give direction for needed changes and testing the results.
• Automate download and load process of localizer data with Perl script. This script created an FTP script to retrieve the data files from the vendor then build the SQL loader script to load the data. This was needed as the data file names changed with each months load. It then executed the SQL loader script to insert the new data.
• Documented all processes created and trained billing OPS personnel on execution.

Consultant

Responsibilities:

• Developed SQL scripts for billing systems to analyze and resolve billing issues in Billplex and Revchain billing systems running on Oracle db.
• Trained billing operations personnel on coordinating bill-cycle errors in billing systems. Provided Oracle SQL scripts to resolve errors, making resolution easier and faster.
• Created Perl scripts with embedded Oracle SQL to report duplicate payment issues in billing systems, removing duplicate payments.
• Implemented PL\SQL script to analyze call records in error suspense to facilitate resolution of errors.
• Reloaded missing taxes incurred during update to Vertex tax system. This involved Oracle SQL scripts to retrieve the records in error.
• Developed PL/SQL script to resolve back-billing charges for new rate plan provisioned for feature in Revchain 7 billing system.
• Contributed to requests for call detail records. Automated process to retrieve data from compressed data files, searching for telephone numbers, loading into Oracle tables, and formatting SQL script with data for customer.

Billing System Support Developer -

Responsibilities:

• Developed and maintained SQL scripts for Daleen billing system, utilizing Oracle as RDBMS.
• Created PL/SQL script to bill customers correctly for 911 charges, recouping $30,000 per month in taxes for company.
• Created PL/SQL script to replicate international rate plans to generate new rate plans. Reduced time required to implement rates from several months to a few weeks.
• Created PL/SQL script to reactivate over 2,000 customers deactivated in error, including correcting service start dates to avoid lapses in service.
• Modified 10 Crystal reports to work with new interface to the Revchain Billing system and to add some new functionality to the reports.
• Reviewed and updated Unix Korn and C shell scripts used by the billing system support team to run the system.
• Worked directly on migration of two billing systems into new billing system.
• Established process to take manual payments received by A/R and load, using lockbox process.
• Created SQL scripts to migrate existing customer information to new billing system.

Billing System Developer

Responsibilities:

• Took over Billplex upgrade process from vendor company, saving company over $10,000 per upgrade.
• Developed and maintained SQL scripts for Daleen Billing system, utilizing Oracle as RDBMS.
• Performed billing operations support by analyzing and correcting errors entered into system.
• Created general ledger interface written in PL/SQL for billing system to feed into Oracle financials A/R system.
• Completed migrations of Billplex system and tested system after executing migration.
• Created views within Billplex system to group different services into logical groups for revenue reporting.
• Created queries for billing personnel to read data in billing system via Microsoft Excel.