Created Flash product demos. Integrated parts catalog/ordering with third party web applications using VB6 and C#. Responsible for desktop installation development using InstallShield/Wix.
Responsible for managing production support and development team supporting pension payment applications for banks including US Bank, Charles Schwab, and Union Bank. Applications included a centralized mainframe application using COBOL II, View Plus, and TurboImage on an HP 3000, distributed PC-based application using Delphi, C++, Pervasive, and Btrieve, and a web-based application using Java, NXJ, and Data Manager. Responsible for working with internal and external business users to determine priorities, allocate resources, and coordinate releases from development, QA, and release. Performed system management tasks including recommending and implementing Security/3000. Responsible for setting up DR procedures and coordinating tests. Developed standards and procedures to meet SAS70 audit requirements.
Created automated file transfer system using PHP and MySQL. System included a web interface for defining and monitoring file transfers from a schedule or event driven. PHP command line procedures transferred critical financial information including ACH files via secure FTP to and from banks to facilitate pension payments.
Created balancing system in PHP and MySQL to extract data from pension payment system and soft copy of reports when loading new client's data. Data was extracted from reports that were provided from client's previous system. Data was extracted from pension system after data was loaded. Extracts were then compared to provide validation of successful transfer of pensioner's current and historic payment information. Out of balance conditions at the pension plan could be drilled down to the payment level to identify problems. System used command line PHP and web interface for loading and comparing data with an export to CSV option.
Created initial database structure for development of next generation pension payment system using Java and Oracle 10g. Managed and performed database development and test systems. Served as application architect and domain knowledge expert for design and development on new system. Developed ETL procedures to convert legacy pension payment data from HP 3000 TurboImage to Oracle 10g database using Cobol to extract and sqlldr and PL/SQL procedures to load into new Oracle tables. Adapted PHP/MySQL balancing system to balance legacy data to extracted data from Oracle database after ETL.
Contracted to Quest Diagnostics. Performed maintenance of legacy systems using COBOL II, View Plus, and TurboImage.
Part-time contract ED for a community center, organized annual fundraising festival for two years, which over 5,000 people attended. Increased event net amount by over 20% from the previous year. Organized annual banquet taking it from a loss to a profit. Reorganized the organization building the infrastructure to take it from grassroots level to a professional business level. Wrote and obtained $50,000 grant from the California Endowment. Established a membership club program and several new fundraising events during the year—increasing the annual income by over 50%.
Designed and developed programs and web sites for small businesses. Created member donation tracking system for local church using Visual Basic 6 and Microsoft Access. Developed intranet and internet applications using HTML, DHTML, JavaScript, PHP, MySQL, Coldfusion, and MS Access.
Contracted to California State Department of Corrections in Folsom, California.. Converted PC application from standalone using several copies of a database to network version accessing common database. Designed data transfer system for transfer of inmate restitution information between institutions.
Contracted to Cardinal Distribution in Folsom, California. Supported finance applications. Made changes in existing software to convert inventory costing from average cost to NIFO (next in, first out). Programs were in HP Basic, Cobol, Pascal, and Cognos' Quick, Quiz, and QTP. Functions included receiving, return to vendors, return from customers, invoicing, sales, and G/L journals. Created new system to transmit division warehouse receiving information to corporate A/P system. Converted legacy A/P transmission for chargeback system to new J.D.E. A/P feed with audit controls and validation. Programmer/Analyst responsible for emergency IRS audit project. New programs written in Cobol and Visual Basic. Streamlined chargeback processing reducing processing time on major processes to 10% - 30% of original time required. Normalized 34GB database table to two tables taking 9 GB. Reduced access time by 50% or more depending on the process. Create Visual Basic and Web prototypes for new development for chargeback enhancements. Team lead providing direction and support to rest of finance team.
Contracted to Hewlett-Packard Company in Roseville, California. Supported legacy systems on HP 3000 using COBOL II, Image/Query, Cognos, and Allbase. Since January, 1998, designed and developed Y2K compliant, replacement on-line system for Site Purchasing from COBOL II on the HP 3000 to Visual Basic 5 (then to VB 6) on the PC. New programs include: 1) Purchase Order Entry; 2) Change Orders; 3) Vendor Maintenance; 4) Dock Receiving; and 5) Site Traffic. New programs include enhanced functionality and the combination of multiple old programs. All user screens were moved to windows-based applications on the PC. Application uses several databases including Allbase on the HP 3000 and SQL Server.
Second part of project was the modification of over 60 COBOL II programs and several databases to bring to Y2K compliance. Testing included several cycles of unit testing and system integration testing of all batch jobs including database data with year 2000 and beyond as well as the system date with the year 2000 and beyond including February 29, 2000. Testing also included outgoing and incoming data transmissions linking to other HP systems.
During the above projects, another site, Fort Collins, Colorado was migrated to use the Roseville purchase order system. Programs were enhanced to restrict access of data to applicable site (i.e. Roseville could only look at Roseville's data. Fort Collins could only look at Fort Collins' data). Several batch programs and jobs were changed for splitting of reports and separating of data transmissions to HP's Financial Server Center for each location. Included unit testing and full integration test cycles of converted data.
Developed dictionary system for Visual Basic applications that facilitates database changes and moves. Database changes, such as database type and location and data formats (e.g. date formats), are applied in the dictionary with no changes to the application. Dictionary definition can handle any stored database format for dates including Y2K compliant. Developed web site using HTML, JavaScript, VBScript, and active server pages (ASP) to help with user communication and to support application development. Also, redesigned and upgraded web site for Chart of Accounts. Database administrator for SQL Server. Designed new databases, implemented naming and other standards for new SQL Server.
Self-employed, owner and computer and communication consultant. Designed, developed, and implemented PC-based, networked, point-of-sale applications in Clipper for video stores, hardware stores, and fast-food restaurants. Products include full-store support, integrated communications support with warehouse (ordering & invoicing), banks (credit, debit, and check authorization and settlement), and credit bureaus. Hardware store system also fully integrated with accounting system. Developed laser forms processing programs for IRS forms and medical school application forms. Installed, customized, and supported SBT Accounting system for customers using Clipper and FoxPro. Installed PC network and Workers' Comp application software and developed custom software for Sutter hospital chain. Installed PC networks for software clients. Provided on-going customer support for clients. Worked on team to implement changes to billing system for SMUD using COBOL II, DB2, VSAM, TSO, and JES2. Managed from 1 to 5 employees including two programmers.
Advanced from self-managed to simultaneous managing two teams and administrative assistant. The first team of four provided PC and network support. The second team of five managed computer operations. Together, teams were responsible for installation and support of 85 networked and stand-alone PCs, data communications, telecommunications, and computer operations (HP 3000 systems and IBM 3270 terminals). Designed and installed stand-alone Novell networks. Developed and implemented consolidation of Novell networks into company-wide network. Designed and implemented conversion from HP terminals on local HP 3000s to 190 IBM 3270 terminal network with 3174 cluster controllers. Cluster controllers and HP 3000 RJE V.35 connected to local IBM 3745 communications controller which connected to EDS. Specified and reviewed VTAM/NCP definitions. Responsible for design and implementation of remote V.32 and V.35 data circuits for other company sites. Managed 250 station phone system with 2 T-1 circuits for long distance. Technical consultant for cabling, telephone, security, and computer requirements for new building. Team leader for design and development of networked PC application for medical insurance benefits tracking and payment system using Clipper. Installed and supported networked PC system for hospital utilization review. Developed reports in R&R report writer. Designed and developed provider directory type-setting programs on HP LaserJet in Basic.