SUMMARY

• Information systems professional with extensive experience in many aspects of information technology including system administration and software development.
• Possess recent Oracle 10g, Crystal Reports XI and Unix experience.

TECHNICAL SKILLS

OPERATING: Unix, DEC VMS, OPEN VMS, RSTS/E, RSX - 11, IAS, TSX, DG AOS, RDOS.

SYSTEMS: Honeywell (Bull) GCOS, Microsoft Windows 98, 2000, XP and NT, SOLARIS, CICS.

LANGUAGES: SQL, PL/SQL, Oracle Developer Forms and Reports 6, C, C++, Basic, PL/I, VAX Basic, VB, COBOL, COBOL II, ACUCOBOL, MF Cobol, Pascal, Fortran, Asp, Java Script, VB Script, Java

DATA BASES: Oracle 7,8,9i, 10g Ingress, Informix, DB2, RDB, RMS, DBMS, DB3, Btrieve, Revelation, MS Access, SQL Server, Terra Data Database

SYSTEMS: DEC ALPHA, VAX and PDP series, IBM, Data General Eclipse, Nova, Apollo, Micro-computers (various), Sun, Honeywell (Bull) 6000, Windows

ERP: SAP/ABAP 4

COMMUNICATIONS: X.25, Ethernet, Decnet, Kermit, TCP/IP, SYSQIO

PACKAGES: Oracle APPS, AllData Gold-Solutions, BO Crystal Reports (multiple versions), BOE

MISC. SKILLS: PVCS, SQL*Loader, SQL Navigator, Toad, Oracle Developer 2000, Oracle Developer Forms and Reports 6, System Management, CMS, ACMS, FMS, TDMS, DECforms, MS Word, Excel, SQL Assistant, Jasper Reports

PROFESSIONAL EXPERIENCE

Confidential, Phonenix, CA

HMO Provider / Member Support System

Responsibilities:

• Provide system design, development and testing for data migration and application modification to support new Provider Member Support System.
• Customer is migrating from Amisys 11.0 to Health Suite.
• Scope of work included reviewing Legacy applications and provide redesign, development and testing of application to provide identical and enhanced capabilities on new system.
• The new applications has been developed using MF COBOL using imbedded DB2 SQL running under AIX.

Confidential, Long Beach, CA

Billing System Support

Responsibilities:

• Provide system analysis, design, development and testing for custom modifications to Billing System used for third party administration of college student loans.
• Work included designing, developing and testing both new applications and modifications to existing software written in COBOL using Oracle RDB running under VMS on HP Integrity.

Confidential, Phoenix, Az

Custom Reports

Responsibilities:

• Provided development and testing for custom operational reports developed to support the operational and trading activities of Confidential .
• Reports were developed to run both as batch daily reports and Web Activated reports.
• Responsible for report development using Crystal Reports, BO Ent using CMC,WEBI and Infoview.
• Responsible for SQL to support reporting process including packages, functions, procedures were developed using Oracle 10 G using SQL Navigator.

Confidential, Monrovia, CA

Custom Reports

Responsibilities:

• Responsible for all development and testing of more than 300 custom operational and accounting reports developed to support the warehousing operations and logistics for Confidential ’s.
• The reports were developed to support and enhance the AllData Gold-Solutions system.
• All reports and SQL were developed from ground up, and all development was accomplished using Crystal Reports.
• SQL including packages, procedures, functions, tables and triggers were developed using Oracle 9i and SQL Server.
• Performed modification and enhancement to Report Driver a VB 6 application that used the Crystal Reports Runtime and SQL Server database to generate reports.
• Provided support for maintenance screen applications, which were written in Java and Jasper Reports.
• Developed Quick Item Lookup, a web application developed to enable stores to view product information, including pricing, vendor information, current and future order information. Developed using Asp, Java Script, VB Script, HTML and Oracle.

Confidential

Billing System

Responsibilities:

• Provided software development support, including analysis, design and coding as needed in the transition to a multi-rate billing system.
• Modifications included changes to online, PL/SQL procedures and batch billing processes.
• The online systems ran using Oracle Forms 5.0, and modifications were accomplished using Developer 2000.
• Changes for the online system included changes to forms and procedures.
• The batch systems ran using MicroFocus COBOL and Oracle, running on UNIX.
• Batch system changes included modifications to COBOL, embedded SQL and developing stored SQL procedures, functions, packages and triggers and UNIX scripts. PL/SQL changes to stored procedures and packages.

Confidential, Riverside, CA

Provided software development support

Responsibilities:

• Service parts system including analysis, design and coding as needed in the data cleanup for Service Parts within the MCBA Manufacturing system . dis included writing procedures and functions as needed to clean up part numbers in preparation for transition to J.D. Edwards and Siebel system.
• The current parts data resides on an Alpha running under PowerHouse.
• ConneX and SQL*Loader were used to load the data to Oracle 9i for cleanup.
• The cleanup of the data included development of Oracle SQL packages, procedures, function and triggers.

Confidential, Irvine, CA

VAX/VMS Conversion

Responsibilities:

• Provided programming and expertise in all aspects of transition from VAX/VMS Oracle Forms/Reports 4.5 /COBOL/ to NT/2000 platform using Oracle 9i, Forms 6 /Reports, including analysis, design, coding and testing.
• Transition responsibilities involved PL/SQL package development including the writing and testing of stored procedures and triggers.
• SQL development included development of packages, procedures, functions, view and triggers, and views.
• Developed extensive OOP concepts including object views, nested tables and varying arrays.
• Used extensive standards including GUI, PL/SQL and testing, and used SQL Navigator in debugging.
• Legacy data extraction and load was accomplished using SQL*Loader and PL/SQL procedures developed for data load process.
• Designed and developed a Purchase Request Tracking System, which provided tracking & reporting on all Purchase Orders for the department including the input, reporting and e-mail notification on all PO activities such as backorders, pricing and distribution.
• Pricing was kept current from downloads provided by vendors and loaded using SQL*Loader. All development was completed using Oracle 9i, Oracle Developer Forms and Reports 6, PL/SQL packages and procedures SQL*Loader, SQL Navigator.
• Coordinated release management activities involving management of multiple versions of development objects, including version comparison and merge activities.
• Responsibilities included the installation and configuration of PVCS Version Manager and I-Net components, as well Database tables in SQL Server.

Confidential, Burbank, CA

Provided analysis and programming support

Responsibilities:

• The Confidential Advertising System which ran on DG/AOS, using COBOL and Fortran.
• Provided programming and support including testing for transition to SUN SOLARIS (Unix), running Oracle 8i and AcuCOBOL.
• Oracle development included PL/SQL packages and stored procedures.

Confidential, Chandler, AZ

Provided analysis and programming support

Responsibilities:

• An Confidential Access DB and tool set. The Confidential Access DB provided statistical analysis and reporting on Confidential manufacturing processes.
• Development was in Pascal, C, and Datatrieve on both Alpha and Vax platforms and VB, Access on HP platform.

Confidential, Newport Beach, CA

Provided analysis and programming support

Responsibilities:

• Online and batch processes supporting the medical community.
• Development was in Pro*COBOL, C, Pro*C, using Oracle and Ingress on both Vax and ALPHA platforms.
• Oracle development included development of packages and stored procedures as well as database triggers.
• Applications were running in both UNIX and VMS environments.

Confidential, Anaheim, CA

Responsibilities:

• Provided Y2K impact analysis on three major billing systems.
• Designed and wrote applications to provide data migration and migration support to Oracle Applications.
• Additional applications included tools to archive and provide data warehousing of legacy data.
• Tools for data extraction were developed on IBM Mainframe using COBOL II, CICS, and DB2 and on VAX using VMS, COBOL and RMS, Access.
• Tools for data reporting were developed using Crystal Reports.
• Provided software development support on billing system including maintenance, design and new programming.
• System included both online and batch operations. Programming was done in both COBOL and VAX Basic using RMS.

Confidential, Sacramento, CA

Performed coding, QA, and support

Responsibilities:

• That provided for optical character recognition for ten print cards.
• The system provided for capture, validation, and database storage of alpha information on fingerprint cards.
• All work was done on VAX/VMS, using C, COBOL, RDB SQL, SQL module, and ACMS.

Confidential, Springfield, OH

Performed design, coding and testing

Responsibilities:

• A conversion project from IBM Oracle to VAX VMS, using C/RDB, SQL, ACMS for a quality control/customer service manufacturing system.

Confidential, Anaheim, CA

Senior Software Engineer

Responsibilities:

• Several different systems within a large automated fingerprint identification system.
• Position involved analysis, design, implementation and customer support for both new and existing systems.
• Most work was done in Fortran and C, including database management using Ingress.
• Served as group leader for some projects, managing activities of up to 14 engineers.