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, VB.NET, JAVA, C, COBOL, shellscript.
• Problem solver, applying analytical, design, technical skills.

Core Qualifications

• 25 Years Programming Experience
• Visual Studio for VB .NET
• PL/SQL Developer
• Eclipse for JAVA
• Operating Systems: Linux, Unix, Windows
• PL/SQL 12 years
• Perl 12 years
• VB .NET 8 years
• Unix shellscript 12 years
• JAVA 1 year
• C 3 years
• COBOL 12 years
• Javascript 5 years
• HTML 5 years
• Experienced with Agile.
• Experienced with Version Control: GitHub, Subversion, CVS.
• Experience

Software Developer

Confidential

I meet with members of the business to learn what they need, translate their requests into programming changes, make the changes, present the results to the members for approval, and install into production.

1 Created a report that saved 5 hours of research work for the Marketing Dept.

2 Using HTML for front end modifications.

3 Created a Monthly Loan Report for the Financial Dept.

4 Created a report that identifies Members by SSN to get a Member total for the Credit Union.

5 Created two file import programs to load data from outside sources.

Software Developer

Confidential

• As the Production Control Administrator, I upgraded and standardized 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.

1 Created 20 Reports for Mastercard audit

2 Created Risk Review Report to reveal vendors at risk

3 Upgraded 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 Created and maintained program documentation - 155 programs

5 Crontab to execute the programs, passing in optional parameters.

Senior Programmer

Confidential

1 ETL - 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 VB.Net to build screens for the reconciliation of the data loaded from the files.

4 VB.Net to build data entry screens.

5 VB.Net to build grids online reports.

6 JAVA to access tables in the Data Warehouse.

7 PL/SQL to perform queries for grids.

8 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 their

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 and Data Center are in

different time zones, 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 keys.

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 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. 20 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.

21 ROAMING project - Convert C programs to Perl.

22 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.

23 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 .

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

25 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.

26 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.

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. Create tables, program all the user screens
• with colors and function keys: F1 description, F4 list, F7 up, F8 down. Search windows allowed
• the selection of data, 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.