System design, architecture, prototyping, application development and project management of business database, internet and intranet systems.
MBA, Management, Georgia State University, Atlanta, GA
BBA, Economics, West Georgia College, Carrollton, GA
Microsoft Visual Basic.Net, Microsoft Access, Microsoft SQL Server, MySQL
Active Server Pages (ASP and ASP.Net), Microsoft Visual Studio
Designed and developed a system to track charges generated by construction firms working on plant expansions for Intel. System integrated with Intel’s central accounting database on a vendor and work order basis.
Designed and developed a satellite telemetry tracking system for a joint project between Stanford, NASA and Lockheed designed to test Einstein’s General Theory of Relativity. The database maintains data on approximately 5,000 telemetry signals available from the satellite with dozens of characteristics about each.
Union Bank of California
Designed and Developed an Access-based client server system to automate the tracking of Community Reinvestment Loans. The database processes approximately eighty-five thousand loan records per year. It interfaces with a mainframe system and with specialized “GeoCoding” software that validates address data.
Managed six intranet web site development projects for Global Service Marketing, Professional Services, Internet Business Systems Group and other departments. Web sites were built with Java, Perl, and Oracle database back end. The sites are used for marketing, sales forecasting, customer service, project tracking and service contract sales.
Boston Scientific Corporation
Upgraded and enhanced document management system used in Engineering Services Department. System tracks revision levels, location, authorization and other data for approximately 14,000 critical engineering documents used in manufacture of heart catheters.
Abbott Vascular Devices
Developed multiple in-house applications for the Clinical Data Management Department for both administrative systems such as clinical trial inventory and databases designed for the entry, storage and analysis of data gathered from various clinical studies for a variety of specialized cardiovascular devices.
Santa Clara County, California
Developed “SafetyNet” Intranet web site providing access to services of the Office of Safety and Environmental Compliance. Site includes the ability to submit various OSHA standard forms including First Report of Injury, Hazard Reports and others. Developed intranet-based employee Training Tracking system allowing employees to view course schedules and register on-line. Also developed Microsoft Access administrative module for reporting and maintenance of the training database. Developed Worker’s Compensation reporting system that involved Microsoft Access driving Excel via OLE to graph and analyze worker’s comp data for all County divisions and departments on a quarterly and annual basis. Designed and developed an environmental compliance system to monitor approximately 200 hazardous materials storage sites in the County. System was written in Microsoft FoxPro and tracks materials stored, disposal methods, permits, EPA and State audit data. Includes custom search engine allowing user to find sites with specified complex characteristics.
Designed and developed sales forecasting, RMA and manufacturing QC test results tracking systems for microwave component manufacturing company.
SigningPro Document Signing Service
Developed database for scheduling and managing the signing services of over 10,000 notaries nationwide who service 5,000 escrow and loan officers at 2,000 banks, loan and escrow companies.. Database functions include scheduling appointments, customer/notary tracking, invoicing and accounts receivable including automatic interface to QuickBooks accounting system.
Developed sales commission system for direct and point-of-sale operations. Monthly commission calculations include complex commission split arrangements, adjustments and variable commission rates implemented in a multi-tier sales organization. Designed, prototyped and managed development of a database to track sales contracts, design win and subsequent ship and debit to customers. System maintained history of pricing given to distributors when bidding on parts contracts with manufacturers. System also interfaced with legacy mainframe providing data files of pricing and shipments for billing purposes.
Designed and developed a client server COBRA administration system containing over 400 queries, 100 data entry screens and over 50 database tables. The system produces dozens of automated letters and printed forms and tracks thousands of COBRA events for approximately 100 client organizations. Designed and developed a Section 125 Flexible Spending Account system managing dozens of client companies and thousands of employees, accept insurance claims, produce claim reimbursement reporting, write reimbursement checks and perform direct deposits into employee bank accounts.
Designed and develop a demand deposit and time deposit pricing system to allow this large east coast bank to set interest rates for over 700 interest bearing products in seven states and multiple regions. Developed a competitive information tracking database to compare BB&T performance to other banking institutions on a regional, state and county basis.
Designed and developed web site for largest business brokerage on the West Coast (www.business-team.com). Site is supported by a database containing thousands of business listings and buyer information.
Designed, prototyped and managed development project for client-server customer telephone support system. System tracked 400,000 customers, their registration data, call history and open incidents, several dozen software products/versions with known bugs and resolution for each
Jefferson County, Colorado
Developed JPAS (Jail Population Analysis System) to provide user-friendly query and analysis tools for County Jail administrators to increase their ability to evaluate the inmate population and improve facility planning and design.
KLA/Tencor Instruments, Inc.
Designed, prototyped and managed development of a production quality control system used on the production line to record results of several dozen tests performed during the production process. System maintained history of each unit by serial number and provided graphical output comparing a unit to others in various user-specified ways.
Designed QA system to control quality of parts purchased from vendors. Nellcor produces anesthesiology equipment and is closely supervised by the FDA and ISO. The QA system was designed to maintain standards for inspection at the loading dock as well as in the lab for all suppliers and track various versions of a product, deficiencies found, resolution of problems, etc.
2010 - present
2010 - present