Professional Summary

• Supervise entire Software Development Life Cycle of large projects: Analysis, Design,
• Implementation, Testing, Installing, Supporting.
• Excellent communication skills. Team oriented. Self motivated. Leader.
• 25 years programming in multiple languages: PL/SQL, Perl, JAVA, .NET, C, COBOL, shellscript.
• Problem solver, applying analytical, design, technical skills.
• Experienced with Agile.
• Experienced with GitHub.
• Core Qualifications
• 25 Years Programming Experience
• Visual Studio for .NET
• PL/SQL Developer
• Eclipse for JAVA
• PL/SQL, Perl, JAVA, .NET, C, COBOL, Javascript
• Operating Systems: Linux, Unix, Windows

Experience

Software Developer Confidential

• As the Production Control Administrator, it was my responsibility to upgrade the perl programs that
• run the business, to make them more efficient, handle errors properly, make them easier to debug,
• create useful logfiles and ensure that they were functioning properly. Worked in a Linux environment.
• Used GitHub for software source control. Used Agile to manage software releases by sprint. Served
• on the Data Control Group to maintain the integrity of the company data. Used MySQL.

Perl Programming

1 20 Reports for Mastercard audit

2 Risk Review Report to reveal vendors at risk

3 Upgrade existing perl programming - 93 programs

A. Log4perl logfiles

B. Error catching - proper error handling to exit gracefully

C. Sending emails when errors are caught

D. Removing hardcoded email addresses

4 Create and maintain program documentation - 155 programs

Senior Programmer

Confidential

1 Load 5300 files a day into tables in an Oracle database.

2 Perl to parse the files, process the data, embedded SQL to insert into the tables.

3 .Net to build screens for the reconciliation of the data loaded from the files.

4 .Net to build data entry screens.

5 .Net to build grids online reports.

6 JAVA to access tables in the Data Warehouse.

7 PL/SQL Developer to manage the tables.

8 PL/SQL to perform queries for grids.

9 Unix shellscripts to launch Perl or PL/SQL.

Specific

1 Vision CDR project Load 1000s of files into database tables, and build 100s of audit points.

Audit points will alarm when the difference exceeds a threshold value. Thus, the user can

investigate the alarms and ignore all the other audit points for that day. This eliminated

70 of the work for Revenue Assurance, studying reports for differences. When

reconciliations didn't balance, I developed a better formula for some of the audit points,

preventing them from alarming, and eliminating the need for Revenue Assurance to

investigate the false alarms.

2 GSM project To recreate everything a third-party was providing for Verizon: receive 20 files

from multiple sources, load them into the database, build 10 screens to reconcile the data,

some screens having a primary screen, secondary screen and tertiary screen: to drilldown

to the necessary data. This saved the company the very large fee paid to the third party.

3 Wholesale project Load 25 files of invoice/billing data, build 15 reconciliation grids and 80 audit

points that will alarm when a threshold is exceeded. Reconciliation grid online report with

multiple types of selection criteria. The user enters their selection options Date, Switch,

Company, Region, etc then hits Search and the requested data is displayed in the grid.

Grids can scroll right or down, like an excel spreadsheet. 4 EUP project Load 15 files, convert the existing system of spreadsheets into 20 audit points and

30 reconciliation grids. This eliminated 50 of their work.

5 Usage Broker project Load 25 files from 3 Usage Broker sites, build 35 audit points.

6 EQP project Load files into Oracle database, access Data Warehouse tables from a second

database to generate reports for Equipment returns, refunds, exchanges.

7 Send daily emails to users to announce the success/failure of files that have loaded. 8 Exception Handling project Truncate the tables to delete yesterday's data, load 128 new files of

EH data each day, summarize the loaded data into a history table.

9 JITR - EH data loaded into tables from 3 sources, deleted from tables by source, when the new file

arrives for 1 source, while leaving the data from the other 2 sources, before loading new file.

10 Skipped Batches- I found missed batches of calls that were not processed. Each month I would

submit the list of skipped batches that were never processed, and have them reprocessed,

saving millions for the company.

11 Vision CDR Reports - Worked with Revenue Assurance to design the reports they needed for reconciliation and auditing purposes. Reports designed to provide the auditors with the

specific information they requested.

12 Vision CDR Queries - System of automatic queries displayed on website screens, performed at

6:00 AM. This eliminated the need for Revenue Assurance to perform their daily queries

and wait on long searches. When they arrived at 8:00AM, the queries were finished, ready.

13 Create Views - Consisting of selects from a remote database, to bring the data to our database

for faster response time.

14 Data Mediation project - Synchronize time zones. When the cell tower is in 1 time zone and the

Data Center is in a second time zone, conversion is necessary to reconcile a block of 24

hours of calls.

15 Hurricane Sandy - Loaded multiple files averaging 20 million rows to study customer needs in

a disaster or emergency situation. Required overtime on three days to complete ASAP.

16 Audit Points - Led weekly design meeting to gather the necessary requirements and

development criteria to ensure the end product met the needs of the customer.

17 Creating Tables - Conducted research to gather the information to properly create new tables:

Column names, maximum column sizes, data types, column descriptions, primary key

columns.

18 Managing Tables - Tables with slow select times need indexes. Tables that have grown too

large need a shorter deletion window. Some tables need partitions to facilitate faster

selections and smoother deletion.

19 Emergency programmer - Whenever an emergency happens and a project needs to be

completed in record time, it was given to me.

20 Disaster Recovery - When the main server went down and 30,000 files were lost, I identified

the lost files and contacted all the entities that sent us the files, to have them resent. I

confirmed the files were received and notified all parties that they were received.

Required overtime to recover all the files. 21 I2K Reports project - Flew to New York to get the specifics on 15 new reports that needed to

be developed for the I2K billing system.

22 ROAMING project - Convert C programs to Perl.

23 DATA CDR project - Loaded 12 files into Oracle tables, built necessary audit points.

24 Alltel Wireless Conversion - Each time Verizon purchased smaller companies we had to

convert the smaller company's data. I worked with the other company to produce

multiple data files that we could load into our existing tables.

25 BTGL - Billing to General Ledger. Verizon was using a third party to do General Ledger work,

so we created files of our Billing data and transmitted them via NDM to the third party

for processing.

26 REVO menu - Early versions of the department website menu written in HTML and Javascript.

27 On Call Support - Two weeks out of every three months, I was on call, kept a laptop nearby,

and would have to respond and dial in to do support whenever I was called.

28 New Server - When our database moved to a bigger server, I coordinated the transition and got

all the groups that sent us files to send them to the new server.

29 Reference Data - Started with 84 files of reference data, had to create tables/loaders for all the

new files. This eventually grew to over 100 reference files. Revenue Assurance needed the

reference files to research audit point alarms.

Programmer/Analyst

Confidential

Support the 401k system that Nationwide handles. Programming in COBOL, SQL, C. The Flow

followed the law on 401k processing, and had to be updated when the 401k laws changed.

1 Y2K Programming - to convert all dates to 4 digits to ensure no problems happened at the

turn of the century.

2 On Call Duties - Support the Flow at night when it ran and problems happened.

3 Made programming changes based on changes in the 401k laws.

Senior Programmer

Confidential

Team leader, giving assignments to junior programmers.

MicroFocus COBOL in DOS/UNIX, programming data entry systems. Screens had colors,

function keys, popup windows for descriptions, listing functions, second screens for drilldown

capability.

1 Operating system for a medication dispenser for hospitals coke machine for medicine .

2 Course and Books for Buckeye Books - OSU bookstore.

3 Restaurant software for Beulah Park.

4 Networking stores for Longaberger Baskets.

5 Trucking for Edwards Insulation. Keep track of what ships in each truck.

6 Parts Inventory for Springfield Tool and Dye.

7 Point of Sale for The Cook Store.

Programmer Confidential

COBOL - Rewrote their existing School System software, to store everything a school district needs

to keep track of. Creating the tables, programming the data entry screens to load the data, and

screens to process the data. Data entry screens had colors and function keys: F1 description,

F4 list, F7 up, F8 down. Search windows allowed the selection of an entry and would return

to the primary screen, populating the data that was selected.

1 STUDENTS - Students personal information, courses, grades, history.

2 ATTENDANCE - Keep track of whether student was present in each of their classes.

3 ACCOUNTING - All the General Ledger needs for a school district.

4 WAREHOUSE - Anything not nailed down - books, chairs, tables, phones, computers.

5 FOOD SERVICES - The schedule of food served in the lunch room.

6 EMIS - State required documentation for every student to drive government funding.

7 DISCIPLINE - Springfield needed a special package to track disciplined students.