Resume 11

SUMMARY

Eleven years experience in information systems design, development and implementation utilizing client/server and Microsoft Windows DNA technologies, with seven of those years as an I.T. Consultant. This experience includes:

• Distributed application full life-cycle analysis, design and implementation
• Database design, development and database conversion
• Integration of third-party applications with custom developed applications
• E-Business solutions

PROGRAMMING EXPERIENCE

• Visual Basic
  Versions 4.0 - 6.0. Advanced programming creating ActiveX DLL s, executables, ActiveX documents, custom controls and standard applications

• SQL Server
  Versions 6.0 - 2000. Versions 6.0 - 2000. Design, develop, tune and maintain SQL Tasks, Triggers, Stored Procedures, Views, Defaults, Rules and Functions SQL2000 , create and schedule Maintenance Plans, monitor performance

• Windows DNA
  Experienced in ADO, COM/DCOM/COM+, MTS, MSMQ, IIS, ASP/VBScript, Site Server, stateless programming, MAPI/CDO and Visual Studio

• Microsoft
  All versions of Windows and Windows NT/2000, all versions of Office. Experienced Access developer.

• ERwin
  Version 3.5.2 of database modeling tool, including ERwin macros

• Solomon IV
  Integration of Client/Server Accounting system with a custom applications

• Onyx
  Integration of Customer Relationship Management system with custom applications

• Miscellaneous
  HTML, XML, Seagate Crystal Reports, DataDynamics ActiveReports, APEX True DBGrid, SQL Compare

PROFESSIONAL EXPERIENCE

This position requires the ability to take written and oral information and formulate systems necessary to implement the business requirements. This process results in estimates, design documents and other system documentation used in developing estimates and project plans.

Contracts include: Bantor Health Care System

• Converted a poorly designed and implemented SQL Server database design to a more stable and reliable schema without impacting existing production. This process required restructuring the existing schema, converting existing stored procedures and views, and migrating the data.
• Created a Data Dictionary of the affected systems allowing development managers to describe and document the systems.
• Introduced a naming convention for SQL objects and "best practices" for SQL code development for stored procedures, views and triggers. Tools used for this engagement include Windows 2000 Advanced Server, SQL Server 2000, ERwin and Visual SourceSafe. The Telemetry Company
• Added functionality to handle long distance dialing-rules for their existing alarm system application. Tools used for this engagement include Visual Basic, and Microsoft Access 2000.

• WEB-TPA is a third-party administrator ABC for health insurance claims processing and benefits administration.
• Developed strategies to migrate their legacy 2-tier monolithic Visual Basic 6.0 application to a scalable n-tier distributed architecture.
• Collaborated on the development of their engineering standards laying the foundation for the migration to the proposed system.
• Designed the security architecture to facilitate compliance with upcoming HIPAA regulations dealing with application security, data security and privacy.
• Modified the vendor processing sub-system to assure the correct vendor is selected for claims processing.
• Developed an application to handle check returns to WEB-ABC because they were sent to the incorrect vendor.

This position required the ability to take written and oral information from technical and non-technical managers and formulate the systems necessary to implement their business requirements into coherent information systems. This process results in estimates, design documents and other system documentation used in developing cost estimates and project plans. Trained client s staff through knowledge-transfer sessions using code reviews and best practices. Project assignments include:

A Startup Equipment Monitoring Company

• Data Architect/DBA for a n-tier, distributed, fully redundant, web-enabled, reusable, extendable systems architecture capable of simultaneously supporting multiple lines-of-business. The system was a completely integrated solution from sale configuration to billing. This included integration with existing legacy systems/software and the development/integration of proprietary software.
• Integrated the Solomon IV GL/AP/AR database modules, the Onyx CRM database with a custom order entry database into a unified system.
• Developed "NT" Services to provide numerous reliable start-up/fail-over capabilities
• Assisted with the development of four ASP/IIS web-based portals to control access and provide customers, sales force, employees and administrators with timely information relevant to their needs
• System developed using Windows 2000 Advanced Server, WLBS, MSCS, SQL Server 2000, COM+, MTS, ADO, MSMQ, IIS, Exchange Server, ActiveReports, Visual Basic, Visual InterDev, and ASP/VBScript

A National Semiconductor Manufacturer

• Lead developer of the software download system. This set of ActiveX DLL s would verify the users purchase of the software, create a new header and certification file and then wrap the software into a bundle and downloaded to either Windows or Macintosh computers for eventual upload into a programmable calculator.
• Developed ASP pages to read customer receipts and build lists of downloadable software.
• Created software build processing that would mask the server name and location.
• System developed using Windows 2000 Advanced Server, SQL Server 2000, COM+, ADO, MTS, IIS, Visual Basic ActiveX DLLs, Visual InterDev, ASP/VBScript, WinZip and WinZip SE.

A National Telephone Company

• Assisted Microsoft Consulting Service with design and development of a prototype application used to re-engineering the existing IMS mainframe billing application to scalable n-tier architecture. The data solution is a featured Microsoft SQL Server case study.
• Developed a Microsoft Outlook-style interface with numerous Microsoft Visual Basic ActiveX Documents and ActiveX Controls to allow consistent Plug-and-Play development. This prototype was a featured presentation at Microsoft TechEd 2000 and is currently the largest installation of MS SQL Server 2000 having a 9 terabyte database spread over four data centers and accessed using partitioned views.
• System developed using Windows 2000 DataCenter, MSCS, WLBS, SQL Server 7/2000, COM/DCOM/COMTI, MTS, ADO, ActiveReports, and Visual Basic ActiveX DLLs, ActiveX Executables, ActiveX Documents and ActiveX Controls. A Real Estate Investment Trust
• Data Architect on the conversion from Microsoft Access databases to SQL Server 7.0. This consisted of converting the Access tables, defaults, validation rules into their SQL equivalents, converting QueryDefs to SQL Views and stored procedures.
• Assisted with the conversion of Microsoft Access 97 forms into ASP/VBScript pages.
• System developed using Windows NT, SQL Server 7.0, MTS, ADO and Microsoft Access 97.

A Gasoline Service Company

• Lead developer on n -tiered, distributed, fully automated leak detection system. This system ensures that underground storage tanks are actively monitored for leaks as specified by federal law. One of two projects winning "Sales Solution of the Year" internally at Radiant. Submitted to Microsoft as a Case Study.
• This project entailed the initial design and planning of the system. Primary responsibilities were for the development of the reporting system. Assisted with the development of numerous ASP/VBScript pages used for the configuration of the monitoring services and for requesting reports.
• System developed using Windows NT Server, SQL Server 6.5, MTS, MSMQ, ADO, IIS, Exchange Server, Visual Basic, ActiveReports, and Visual InterDev.

A National Restaurant Chain

• Lead developer on the conversion from a two-tier to n-tier Food Cost application. This application uses SQL Servers push replication to maintain consistent recipe information between the corporate recipes and the restaurants. Converted dynamic SQL statements into stored procedures. Converted data access from legacy DAO to newer RDO.
• Developed a catering application that pulls cost/price information from the Food Cost application and provides scheduling of bulk meal preparation.
• System developed using Windows NT Server, SQL Server 6.5 and push replication, DAO to RDO, Visual Basic, Crystal Reports and Microsoft Access 95.

This position required an understanding of real estate operation and acquisition, banking, accounting, and finance. This knowledge was used to develop custom solutions for the troubled loan and REO portfolios of banks. The primary Tools used for development were DataEase for the Asset Management & Disposition System AMDS and Microsoft Access and Visual Basic for ReCAST and Reflections.

• Primary developer of ReCAST using MS Access 2.0. This portfolio roll-up and reporting system imports financial projections from the leading real estate valuation tools.
• Primary developer of Reflections using MS Access 2.0. This Executive Information System consolidates accounting and property management information from the SKYLINE real estate accounting system, imports financial projections from the leading real estate valuation tools.
• Improved the import processes of the DataEase based AMDS that resulted in a threefold improvement in performance.
• Developed a critical loan system module in DataEase for AMDS using knowledge of loan workout, borrower & guarantor dynamics, loan/collateral valuation as well as data acquisition and conversion.

Managed the Covered Portfolio database consisting of 200 performing and non-performing loans and 400 REO properties. The book value for this portfolio was over 3.4 billion with a market valuation of 2.9 billion.

• Developed methods and procedures to ensure that First Gibraltar Bank would remain in compliance with the Southwest Plan Assistance Agreement.
• Automated the reconciliation of the Bank s accounting records with the portfolio s book value and reduced the time required for this task from three weeks to three hours.
• Compiled the Real Estate group s presentation to the Board of Directors.
• Developed an asset-level cash flow model using Lotus 1 2 3 that was used by senior management during negotiations for the sale of the Bank to Bank of America.

Responsible for the review, analysis and preparation of budgets, inventory and non-manufacturing overhead valuations, and variance analysis for seven manufacturing programs within the Electro Optics Entity.

• Improved the performance of several Lotus 1 2 3 templates used to calculate R&D tax credits that remained in compliance with strict governmental CS audit requirements.
• Developed several Lotus 1 2 3 macro-driven templates that were implemented on other CS programs throughout the Defense Systems Electronics Group at Texas Instruments.

Assigned to various bases in Germany, Georgia, Korea and Louisiana as an Engineering Assistant Specialist.

• Selected as "Airman of the Quarter" for the second quarter of 1980, through a board selection process
• Promoted to Senior Airman ahead of peers through a board selection process
• Promoted to Staff Sergeant in under four years normal at the time was six years
• Honorably discharged in 1985

EDUCATION

B.B.A. in Finance from Stephen F. Austin State University, Nacogdoches Texas.
Graduated in 1988 with a 3.0 GPA overall and a 3.9 in major.