Resume 1

EDUCATION:

Bachelor of Professional Aeronautics
Embry-Riddle Aeronautical University - Daytona Beach, Florida

HARDWARE AND SOFTWARE:

Visual Basic 4.0/5.0/6.0 , ADO, SQL, MS Access 2.0, 97, 2000 , MS SQL Server 6.5 , 7.0 , Oracle7, Sybase, Lotus Notes Script, ActiveX, Win32, API, SAS, C, HTML, Claris FileMaker Pro, Windows NT, Windows 2000, UNIX, VAX, VMS

OBJECTIVE:

To work as a value added resource in a creative\diverse environment for developing or maintaining complex to simple, multi-tier, business applications.

PROFESSIONAL SUMMARY:

11 years of progressive experience with the Grundic Corporation including:

• Produced first time quality programs in the following industries: Automotive; Aerospace; Health Care; Petroleum; and Entertainment.
• Experience in debugging, design, development, testing and implementation of industrial applications with Environment : Visual Basic, ASP, SQL, Sybase, Access, and SQL Server in a Windows NT environment.
• Strong back-end data manipulation background using COM programming style.
• Solid front-end background using Microsoft s standards for form controls, structured coding , naming convention, error trapping, and documentation.

PROJECTS EXPERIENCE:

British Petroleum BP / Arco

Environment : Visual Basic 6.0/ Sybase/SQL-Server 6.5/UNIX/Oracle/Access2000

Developed a security application for maintaining ID s and Usernames on 16 Unix servers hosting a replicated Sybase database in terminals throughout the West coast. Developed COM objects to encrypt/decrypt server ID s and passwords, as well as data access objects using ADO wrappers. Establish a process for converting BP s Terminal Operating System TOS written in Visual Basic 3.0 to 6.0 Visual Basic application. Converted 16 bit controls to 32 bit controls and made the necessary code changes. Worked in a team environment using SourceSafe, Rapid-SQL, Transact-SQL,SQL-PLUS Oracle and Unix scripting. Created simple maintainable and easy to test code using API wrapper for INI files , and Registry entries. Performed on call duties on TOS related issues by handling trouble tickets application supported 24/7, 365 days a year opened in Vantive Support System. Modified SQL statements in the Gas Ordering System application due to changes in the Petrosoft s Oracle database tables. Performed maintenance on application using Microsoft s Winsock control that interfaces with IBM mainframe. Created and modified stored procedures.

Toyota Corporation 08/00 02/01

Environment : Visual Basic 6.0/ Access97/SQL-Server 7.0/ASP

Developed, modified, and debugged Toyota s leasing ordering system and financial system at the headquarter facility in Torrance. Vehicles are ordered through Lotus Notes and maintained through an Access97 front-end. The back-end data stored on a SQL Server 7.0 database. Ten users clerks and office administrators utilized the two tier application to handle the administration of cars in service that were sold or leased to over two thousand associates employees in the southern California area. The Access97 front end contained over 100 tables, 50 forms, and modules. Scheduled SQL Server MTS Packages to clean up data dumped via Lotus Agents from Lotus database documents created daily from new car activity. Daily activities included working developing new GUI s for enhanced functionality of existing business practices rules not already incorporated in the newly deployed application 1 year . Responded to users problems new application bugs by debugging and fixing them as a number one priority. Prepared documentation for training and desktop procedures. Created and modified Lotus Notes agents and SQL Server 7.0 MTS Packages for data manipulation. Performed job duties in a team environment with five programmers 2- VB/Access , 3 Lotus Notes . Created VB 6.0 executables for deployment of application through Lotus Notes agent.

Pacific Medical Care 05/00 08/00

Environment : Visual Basic 6.0/ Sheridan Grid/Toolbar/Listbar

Debugged and modified developmental phase of Pacific Medical Care s Reconcile Billing financial application. This Two tier application would replace 400 manual laborers that reconcile bills for the entire Pacific Care organization. The application was built on a VB 6.0 front-end consisting of class modules, Sheridan Grid for accounting , Sheridan Toolbar \ Toollist, and approximately 50 forms. The backend resided on mainframe DB tables which interfaced with VB via and program called ACMS. Daily activities included working with a weekly revised squawk and enhancement list controlled by a project manager and distributed to a team of six programmers 3 VB , 3 Cobol . Each squawk or enhancement was given an allotted amount of time to work which were closely monitored by the project manager for project cost control. Utilized version control and synchronized code through SourceSafe.

ElMapsUSA inc., Hot Rod Magazine 02/00 05/00

Environment : Access97/ Class Modules

Performed routine maintenance on Hot Rod Magazine s Special Events reservation system. The two tier Access97 Application consist of 20 forms, Acess97 security, 30 tables and ActiveX documents class modules . User group consist of two phone preservationists, office manager, and manager. Daily duties included implementing front-end change request and generating reports.

Visual Basic Developer, Sr. Methods Engineer

Environment : Visual Basic 5.0/ Access 97/Microsoft Project 98/SQL/SAS

Access Developer / Sr. Methods Engineer

Access/Environment : Visual Basic/Microsoft Project/SQL

Delivered an in-house scheduling system using Microsoft Access as a front-end and data warehouse, while integrating Microsoft Project as a scheduling engine in producing schedules for the build-up of the MD80 and MD90 aircraft. Created a multi-user database and graphical user interface for a team of ten Industrial Engineers and five USC intern students. The database was originally populated with 7,000 records with the aid of Teradata s SQL from the mainframe. A text file was generated on the mainframe and downloaded into the PC environment using Extra. This text file was imported into Access. Forms, pull-down menu s, buttons, and radio dials were used as GUI s for navigating through the database. Utilizing Visual Basics 5.0, data could be passed from Microsoft Project into Microsoft Access and vice versa. Visual Basic in code was used for massive updating of records. Security was added to prevent unwanted intrusion and inadvertent updating of someone else data. Performed testing, distribution, documentation, and training on final application.

Application Developer / Sr. Methods Engineer

Environment: Unix Based Compass/SQL/Microsoft Project

Tested , Developed, and converted NASA s Space Shuttle operations scheduling system Unix based into a manufacturing application for scheduling the build-up of aircraft MD80 s Nose as pilot . Using the MD80 Nose Build-up as a pilot, resources and predecessor information was downloaded from the legacy mainframe system using Teradata s SQL for 300 Assembly Orders AO s . Microsoft Project was used as an intermediate tool to store the scheduling data for testing prior to FTPing a generated text file into the Unix based Compass scheduling system. In Compass, true constraint based schedules were produced with the aid of Script programming. Performed testing, distribution, documentation, and training on final application.

Filemaker Pro Developer/ Sr. Methods Engineer

Environment: Claris Filemaker Pro/SQL

Built a database to automate the auditing check of 2,000 Assembly Orders AO required to build the Aft Fuselage of the C-17 Transport Aircraft. This task normally took eight Industrial Engineers three 8- hour days 192 Hours . Using Teradata and SQL, a query program was written to extract the customer requirements of AO s from the legacy mainframe system. A text file was generated and imported into Claris Filemaker Pro PC Platform Application Database . A front-end was built with buttons and pull-down menu s. Scripts were use in the backend to give the database performance power. The GUI was used by the eight Engineers to navigate to their respective data set. Security was added to prevent unwanted intrusion and inadvertent updating of someone else data. Auditing time was reduced to ten minutes with only one person. Performed testing, distribution, documentation, and training on final application.

Web Developer / Sr. Methods Engineer

Environment: HTML/Adobe Acrobat/Adobe Photoshop

Created an internal Intranet site that would host information regarding the department s organization structure, reports, calendar of events, and feedback. Created a Web Site using Adobe Photoshop for the graphics and Adobe Acrobat to view and download reports. Tables were utilized for visual appearance. Microsoft Word Editor , Hotmetal Pro, and Netscape Editor were used for HTML programming. Performed testing, distribution, documentation, and training on final application.

Environment: HTML/FrontPage/Adobe Photoshop

Developed online inventory and product description website using FrontPage. Coordinated with Graphic Artist for layout details and images.