Programmer Analyst Resume
0/5 (Submit Your Rating)
Carlsbad, CA
PROFESSIONAL EXPERIENCE:
Confidential, Carlsbad, CA
Responsibilities:
- Internet domain registry and retail/wholesale online domain seller.
- Programmer Analyst: Perl/Mod Perl/HTML/CGI, Oracle (primarily) and MySQL Database, Linux.
- Responsible for maintaining, streamlining and enhancing in - house intranet and batch accounting processes, and internet online domain order processing system including a multi tiered commission structure.
- Extensive use of SQL/PLUS and the Perl scripts with imbedded SQL (DBI module) and frequent use of regular expressions for data de-corrupting, adhoc report generation, and creation of dynamic intranet accounting functionality.
- Designed and coded all batch processing for auto-renewing domain and related subscription based services while interfacing with multiple credit card gateways such as Payflow as well as PayPal Preapproved Payment services to charge and renew thousands of customer accounts nightly.
- Designed and coded invoicing system to allow accounting personnel to easily track and bill orders to our wholesale registrars including GoDaddy, Enom, and Register.com. Designed integrated payment system to allow registrars to log in and pay invoices online by credit card.
- Designed and implemented system for accounting personnel to issue credit card refunds, record credit card chargebacks, and capture auth-only and referral credit card transactions.
- Designed and coded script for intercepting PayPal Instant Payment Notifications (IPN’s) and reconciling notifications with existing sales data.
- Developed flexible effective-date and quantity driven product pricing system.
- Designed and coded voucher ing and redeeming processes.
- Designed interactive administrative tools for transaction playback to recalculate and verify accuracy of domain expiration dates.
- Designed and implemented database triggers to automatically record domain additions, deletions and changes to domain owner ids, registration and expiration dates and status fields. Designed and coded nightly batch process to reconcile the resulting audit records and with supporting transactions and report on exceptions found.
Confidential, Irvine, CA
Responsibilities:
- Researched problem tickets and implemented code fixes for the VMS/DBMS based Prism cellular message processing and billing system utilizing COBOL, DCL, and DBQ programs and procedures.
Confidential, Cypress, CA
Responsibilities:
- Worked in the Claims Technical Team on code maintenance and enhancement projects utilizing VMS COBOL, Rdb/SQL and DCL.
- Responsible for design and coding of Confidential Claims Archive/Purge process including supporting retrieval and reporting functions. Coded Episode/Authorization Load program.
- Participated in claims workflow redesign project. Modified VMS command procedures to accept and process claim files from multiple vendors. Created command procedures to FTP claims files to, and retrieve correction files from, the Imaging Group’s NT server. Modified source programs to accept expanded Document Control Number.
Confidential, Long Beach, CA
Responsibilities:
- Performed code maintenance and worked on numerous enhancement projects for AFSA’s student loan servicing systems utilizing Vax/VMS COBOL with imbedded SQL.
- Converted billing system from exclusively month-end billing to weekly cycle billing under FOCUS enhancement project as well as for the National Direct Student Loan system.
- Designed, coded, and unit tested system to track the number of ‘delinquent days’ for loans under the income-contingent repayment plan with fixed monthly payments that triggered negative amortization.
- Redesigned, coded, and unit tested billing system to parameterize individual repayment plan requirements as well as to allow for repayment plans with periods of interest-only and/or periods of interest plus ‘partial-principal’.
Confidential, Woodland Hills, CA
Responsibilities:
- Worked closely with Confidential Touche analysts on the development of Vax/VMS COBOL batch programs for the billing system under the MAGICS enhancement project.
Confidential, Woodland Hills, CA
Responsibilities:
- Development and maintenance of batch programs using Vax/VMS COBOL/Rdb and DCL command procedures in the areas of MediCal, Capitation and Decision Support Systems.
Confidential, Sacramento, CA
Responsibilities:
- Modified Vax/VMS COBOL SQL and RDO batch programs and DCL command procedures to add Base Realignment and Closure (BRAC) areas to Champus Reform Initiative applications.
Confidential, San Diego, CA
Responsibilities:
- General partner in joint venture to develop proprietary electronic current measurement technology. Ultimately negotiated sale of technology in the form of an exclusive license to AEMC Instruments/Chauvin Arnoux. Currently marketed as the AEMC DC/AC Model K100 and K110 microprobes.
Confidential, Cypress, CA
Responsibilities:
- Development and maintenance of real-time and batch Vax/COBOL RDO applications. Some exposure to writing and modifying ACMS/TDMS on-line tasks and screens.