## BIO
VB/VBA ... MS Office Systems, Database Systems, Web Site Design, and IVR/CTI/TAPI ... Specific information is provided with each bid.
## Area of Expertise
Technical Design:
* Network Infrastructure, OSP Cable/Fiber Design, conduit, RF location, circuit design (DS0/DS1).
* Business process, information flow, storage analysis, hardware requirements, integration capabilities, network extensions
* CO & Building Wiring (Bicsi), cat5/6, ethernet, coax, fiber.
* Equipment Engineering Central Office and Transmission (voice/data), support systems
* Client-Server networks & topology, routing and address topology
* CTI, Integrated Voice Response, Voice Mail (system & board level), ACD, Call-Center
* Interface circuits (x.25, LS/GS, E&M, rs-232c, SNMP, H303, CDR, 56/64 kbs, OC1/3/12)
Systems Support:
* Customer Support (CPE, SQL, Office Systems) , switching systems, PBX, Key, Client-Server
* Engineer-Facilitate-Implement (EF&I) Toll-Grade International Networks
* Private Line Lan/Wan/Toll Gateway, TCP/IP, ATM, Frame-Relay
* Network Management (NMS) and Integration
* Sales Engineering & Proposals, as well as, Product Development (R&D)
* Switching Administration (call vectors, number translations, and routing protocol)
Software Tools:
* DOS (1x-5x, Win98, WinXP, NT), OS/2 with SDK, Java 1.2, Unix with Solaris, HPOpenView
* C/C++ (OWL/MFC), VB/VBA, COM, OLE, scripting, batch files
* Database languages; R:Base 3GL/4GL, SQL, DBase, Oracle, Access, Excel, Sybase
* Protocols; H303, CDMA/TDMA, GSM, VoIP, Ethernet, wireless, ATM, Frame-Relay, TCP/IP
Software Languages:
Operating Systems; DOS (1x-5x, 98, NT, 2000 Server), OS/2+SDK, Unix, Java 1.2, TI 9900, IBM 360
Development with C/C++, VB/VBA, COM, OLE, Fortran, TI 9900, IBM CICS, Basic, C-Builder5
Web development with HTML, TopStyle 1.5 text editor, IE 5.5-6.0
Applications:
Database:
Client Server (1/2/3 level), SQL schema. Table structure, indexes, forms & reports
R:Base 3GL/4GL, SQL, DBase, Oracle, Access, Excel, FoxPro, PFS: File/Reports
Graphical User Interface (GUI) design; forms, pivot tables, calculated fields
Reporting with Crystal Reports, Word, Notes, Exchange, VB/VBA
Automated backup and restore scripts, calendar watchdogs
Office Application and Integration (VB/VBA, DLL's, OLE, Automation)
Accounting Applications:
Client Server with Chart of Accounts development, journals and ledgers, forms & reports, medical billing lookups, invoice & receivables processing
QuickBooks Pro Authorized Developer; including VB/VBA processing scripts
Peachtree and Excel expertise
Multi-location consolidated statements
Switching Applications:
Network SNMP, traffic load, Call detail recording (CDR), Maintenance control systems
PBX, Key, Voice Mail, IVR script or table programming (boolean)
Network address translations (table lookups), and routing protocol test keys
CTI, Fax-back, call-center system development with interfaces, TCP/IP network topology and DSN
Recent network projects (hardware & software) completed:
AT&T Broadband (Avaya, CTI, Ascend) Customer Service Network, area code routing design, traffic balance, disaster recovery, switch topology & programming, etc.
Saudi Telcom (Avaya, Siemens, Lucent, Cisco) Nation-wide Network TCP/IP routing, load matrix, ISP integration, ATM/Frame-Relay Remediation Design, GSM expansion.
Southwestern Bell (Lucent, Avaya, Cisco, Nortel) ATM, Frame-relay implementation, End Node configuration (L2F, Vpn, Passport, DSL, Remote Access framework)
U. of Colorado Medical School (Cisco, Fiber, Tellabs) campus facility design and implementation, Part #16 drawings and design.
Denver Convention Center (Lan/Wan, Cisco, Tellabs, Fiber) campus facility design and implementation, major system architecture design.
Recent software projects completed:
Accounting System Design (MS Access, COM, VBA, GUI) - Enterprise level RBDMS system, inventory control, metrics modeling and analysis.
Project Manpower Scheduling (MS Project, MS Access, SQL, Quickbooks, GUI) - Project metrics, estimation models, Proposal Printing, and Consultant time-reporting sub-system to update customer sales, billing and payroll system.
Facsimile integrated voice switching system (R:Base RDBMS, CTI, DS-1, SQL, SDK) - Remote data retrieval system, automated graphics composition, time-of-day broadcast management, local user switching control. 25 Faxes per hour per port (25 port maximum, dialed number list unlimited)
PSTN/ISP traffic modeling (Oracle & Sybase RDBMS, ATM/TCP/IP, Cisco, Nortel, SQL, SDK) - Nationwide capacity analysis, remote data retrieval (SNMP), and predictive load modeling system.
Equipment Manufacturers:
Cisco, Lucent, Nortel, Avaya, Mitel, Siemens, Newbridge, Dialogic, Natural Microsystems, Tellabs, Telcom Systems, ADC, Belton, Novell, 3Com, Dell, IBM, ATI Graphics, Hayes, D-Link
