Senior Programmer Analyst Resume
Walnut Creek, CA
Design, build, and test systems, applications, as well as tools for software development and QA, using Object-Oriented analysis, design, construction techniques, and sound software engineering practices at all stages of software system life.
Technical Skills:(listed in order of relative expertise)
Languages: Perl, SQL, Forté 4GL, SPITBOL/SNOBOL, HTML, CSS, DHTML, CGI, XML, Kornshell,
COBOL, Java, Ruby, PAL, Pascal, JCL, Smalltalk
OS: Unix, Linux, AIX, Windows NT/2000/XP, OS/2
Framework/API: Synapses 3, JUnit, FUnit, Swing, Ruby on Rails
CASE/UML: ArgoUML, Poseidon, Rational Rose, Select, OO~Connect, ADW
Network/Web: TCP/IP, NetBios, ftp, telnet, Unix tools, tomcat, jBoss, Apache
DBMS: Informix, MySQL, Oracle, DB/2, Paradox, Btrieve, xBase, R:Base
PC: MS Excel, MS Word, Visio, OpenOffice.org, Firefox
IDE: Eclipse, OpenPerl, Komodo, JBuilder, Telon
Other: ETL, Subversion, CVS, RCS, HL7, EDIFACT, EDI X12, Antlr, Ant, Librarian
Confidential Walnut Creek, CA
Senior Programmer Analyst July, 2001 – June, 2009
Designed, developed, tested, deployed, and executed:
Fully automated extract, transfer, and load (ETL) prescription conversion processes for Longs to CVS pharmacy systems for 500+ stores, and Longs archive to CVS data warehouse for 800+ pharmacy images. Reduced conversion throughput from 3 stores per day to 3 stores per hour by loading data from Informix to MySQL and doing actual extract and transform on three Windows servers.
Initial ETL of pharmacy data from 500+ pharmacies to a central database, Informix to Oracle.
Archive/purge process to move outdated data from 480 store databases to a central archive.
Web-based application to automate assignment management and configuration of laboratory test servers for pharmacy applications to reduce time to setup for QA and Acceptance testing.
Metrics and status monitoring applications for mission-critical applications, reducing down time at over 480 pharmacies.
Conversion process verification tool that saved hundreds of hours of manual verification time.
Performed many data mining/analysis investigations providing critical information for:
Longs to CVS conversion, Loss prevention, Fraud investigation and security breach analysis, Data corruption analysis and repair, HIPAA compliance.
Developed suite of Perl utility modules to speed development, enhance reliability, and automate regular and ad hoc data capture and analysis programs for business and system metrics and reporting.
One report restored $700k to company profit in a single quarter, as well as preserving that amount over future quarters.
Participated in design, development and support of successful roll-out of two mission-critical pharmacy applications.
Performed defect history analysis and writing of help desk diagnostic and resolution procedures.
Ported jUnit to Forté TOOL for use by development team in improving development process.
Advised on and initiated testing and configuration management process improvements.
Mentored colleagues in Object-Oriented concepts and techniques.
Prepared and taught class in OO concepts.
Using: Unix, Aix, Linux, Perl 5.x, HTML, CSS, Eclipse, Informix, Oracle, MySQL, CGI, Forté 3.x, Kornshell, SPITBOL, MS Word, MS Excel, Subversion, RCS, CVS, Java, COBOL.
Confidential San Bruno, CA
Management Consultant in Software Design and Development April 1997 – May 2001
Frameworks-based analysis, design, and development of critical supply chain systems for major retail client.
Developed and used load test application for stress testing back ends of Forte 4GL Applications.
Developed and taught course in Object-Oriented Analysis and Design.
Mentored client and ThoughtWorks personnel in use of frameworks and OO design and development.
Developed and tested prototype metrics utilities for Forte and Java.
Using: Synapses 3, Forté 3.x, SPITBOL, VBA, MS Word, JBuilder, Excel, Visio, Select, VisualCafe, Rational Rose, Java, RCS, CVS, Antlr, SPITBOL, AnyJ, CVS, tomcat, jBoss
Confidential San Ramon, CA
Senior Systems Analyst June 1984 – March 1997
Pacific Bell Billing Services Group (1991-1997)
Designed, developed, and used for shared and private billing systems:
Object- Oriented design for linear state machine architecture.
Rule-driven data stream editing engine.
Software utilities to augment CASE tool capabilities.
Used above in data migration application for EDIFACT, EDI X12, etc. data formats into internal billing formats.
Designed, developed, and used:
Testing, configuration and repository management procedures and tools in integrated CASE environment, including documentation and incident tracking.
CASE repository management and testing utilities.
Software integration and regression testing, batch system.
Using: OO~Connect, Smalltalk, ADW, SPITBOL, Btrieve, PAL, Paradox, xBase, COBOL, SQL, JCL, DB/2, OS/2, MS Word, MS Excel, Visio, MicroFocus Workbench, SPF/2
Pacific Bell Systems Technology (1984-1991)
Designed, developed, and executed:
System-level integration and regression testing, for batch and real-time, on-line systems, including
inter-system communication.
Configuration management procedures in 3GL and 4GL environment including supporting utilities.
Process for estimation of testing resources based on analysis of requirements-driven test conditions.
Tools for mechanized system structure, behavior, impact analysis, and documentation.
Performed defect/incident tracking.
Application programming
Using: SPITBOL, JCL, DB/2, COBOL, SQL, Query Manager, Librarian, Telon, MS Word, R:Base, LU 6.2
Education:
Master of Music in Vocal Performance
Bachelor of Music in Vocal Performance, cum laude