Neva Tavoada, Resume as of */**/****
Software Experience:
Database Design and Development:
MS Office Groove 2007
SQL Server 6.5, 7.0, SQL Server 2000, SQL Server 2005
SQL Navigator, SQL Query Analyzer
MS Access 1, 1.1, 2.0, 95, 97, 2000, 2002, 2003 (VBA, DAO, ADO, ODBC, ActiveX, Security, SQL, ADP)
(complex queries (pass-throughs, union), macros and extensive VBA coding, extensive form design, security, reports, class modules, external references, import/export processing, frontend and backend)
Oracle 9i (PL/SQL)
Speed Ferret, Total Access Analyzer
Excel VBA, import/export from Access, MS Query, Charts and Graphs
Crystal Reports and Crystal Info
Lotus SmartSuite, Lotus Approach, Lotus Script
Visual Basic 6.0, VBA Tools for VB.NET 2003, Visual Studio.NET 2005
Web Design and Development:
VBScript
JavaScript
HTML, XML, CCS, FTP
(web hosting, shopping cart system, file paging, search engines, templates, navigation, forms validation, add/edit/delete records, upload files, HTML email blasts, database integration)
ASP Classic
ASP.NET 2.0 and Visual Studio.NET 2005 (Web Forms: DataGrid; GridView; DataReader, EditTemplate)
Macromedia Suite: Dreamweaver 8, Flash 8, Director 8, Fireworks 8, Dreamweaver MX
Google Earth (maps and satellite images)
Other Software:
MS Office Professional & Developer's Editions 95/97/2000, 2002, 2003
Visio 2000, 2003
MS Project
WordPerfect 5.1, 5.2, and 6.1
CorelDRAW 3.0, 5.0, PhotoDraw, Photo Shop 6.0
ADP HR Perspectives/Payroll Software, Agresso Accounting (Excelerator Reporting Tool)
Rational ClearQuest
Visual SourceSafe
File Magic 5.0 and WTI Fortis 1.12 Document Imaging Software
Work Experience:
5/08 – Present Teleworld Staffing, Brent Coon & Associates, Beaumont, TX (telecommute via Citrix and VPN) – contract Access 2003 database developer: enhancements to Case Law System database to include search screens to build queries on the fly using pass-through queries (SQL Server) for search “My Cases” and search “Calendar” items based on logged in user.
4/08 – 04/08 DAC International, Austin, TX – Create runtime MS Access database tool to incorporate into Electronic Flight Bag software (GENESYS). The application displays data for selected airport along with JPG and Flash movies that were created from recorded AVI files. The AVI files were then encoded and imported into Flash as Flash Video format, with additional JPG animation. The AVI files were created utilizing Google Earth, Google Maps, FRAPS, Virtual Dub, and ImTOO Encoder. The Flash movies are detail zoom and rotated views of the runways for 10 Special Use Airports. The runtime installation routine was created using MS Office MS Access Extensions SDK Package Wizard.
3/08 – 4/08 – Enviroquip, Austin, TX – Access 2003 database enhancements; add new reports; add new data entry and edit forms; create search forms; add new tables
1/08 to 2/08 – Butterfield-Shore Custom Homes, Austin, TX – ASP.NET Programmer – create Access 2003 database and ASP.NET web pages (using DataGrid, GridView and Master pages) to add/edit/delete records for lookup tables; login screen and portal menu system accessible based on user login
1/08 to 2/08 – Website Geeks (Lutheran Social Services of the South, Austin, TX) – ASP Classic Web Developer – revise existing and create new ASP Classic web pages for intranet; edit existing and create new Access 2003 database files
10/07 to 11/07 – AmerOnc (Medisun Consulting, Austin, TX) – Visual Basic Programmer – edit existing VB 6.0 project for DTS processing code to SQL Server 2005; write new code to process DTS functions via ADO; create code for file system objects to copy Access MDB database files for import into SQL Server 2005; create new Web Application using ASP.NET 2.0 and VB Studio.NET 2005 to display data from a SQL Server 2005 database dataset into an editable DataGrid; analyze queries using SQL Navigator and SQL Query Analyzer.
09/07 to 09/07 – Technisource/Solarwinds (Austin, TX) – HTML programming – edit ASP.NET aspx for HTML content (3 day project)
09/07 to 09/07 – Inceed/Helix Energy Systems (telecommute – Houston, TX) – Excel VBA programming – VBA revisions to existing Excel 2003 application (User Forms, add min/max buttons, add calculator buttons, edit code) 1 week project
08/07 to 08/07 – Triangle Technology/Renewable Energy Systems (Austin, TX) – create data dictionary for Agresso Accounting System tables to utilize in Excel Excelerator SQL query tool for reporting purposes (3 week project).
05/07 to 08/07 – Technisource/Exxon Mobil (telecommute – Houston, TX) – 3 mo contract MS Access 97 programming VBA to update Access database with revisions (updating fields, tables, queries, and VBA code for import/export processes; add security update forms).
02/07 to 05/07 –TidyTechs (telecommute - Austin, TX, Houston, TX, Fort Worth, TX, and Pittsburgh, PA) – Self-employed consulting - Provide part-time telecommute web hosting, domain management, email for 13 domains; also provide ASP (Classic) website/database development and contact management services to www.sugarboutique.com, www.pavementshoes.com, www.ybdoakmont.com, and www.rareplum.com using Access 2000 database and Dreamweaver. Also provide web hosting and website development services to www.jasonworx.com, www.starpromowear.com, www.slobbergoblin.com, www.fudgeknuckle.net, www.divaoad.com, www.aqpgh.com, and www.britheloanguy.com for Classic ASP and ASP.NET development, using Access 2000 database, Dreamweaver, Fireworks, Flash and VB.NET. Provide php database connection troubleshooting/support (to MySQL database) for www.pittsburghnorthrealestate.com. Provide back-up Access database development support to Caterpillar staff developer for various projects as needed. Provide web hosting and complete web development (including shopping cart maintenance for product updates), FTP and email support, as well as Flash and database development services (Access 2000) to www.hand-madejewelry.com. Provide continued database development support to www.publicfundsurvey.org (NASRA) using Access 2003.
04/05 to 05/07– Litton Loan Servicing, LP (Houston, TX) – Programmer III/Tech Liaison providing Access database development and support for Collections/Default Technology department. Develop and maintain multiple applications for call center and managerial support for databases frontend, backend (Access 2000 and ODBC Oracle); develop processes to provide repayment plan history data for IVR project; designed Disaster Relief database for Special Forbearance repayment plans; revise and maintain Collect database and Collection Letters databases and processes (42+ databases); design and support Loss Mitigation database; provide support for Research database; troubleshooting databases as needed. Maintain new hires, terminations and USER ID table linked to 42 databases for security. Provide Visual SourceSafe training to co-workers, create Visio data flow charts and documentation for department databases and processes. Create processes for end of month credit reporting for 600,000+ loans to conform to Metro2 format and credit reporting requirements and standards. Member of the Process Improvement Team: re: Stop Codes. Database development in Oracle i9, PL/SQL, pass-through queries, crosstab queries, VBA, Access queries, forms, reports, macros and Excel macros; automated Excel exports and email processing, and batch file version releases. Software utilized: MS Access 2000, Oracle 9i, PL/SQL, SQL Navigator, Speed Ferret, Total Access Analyzer, Visual Source Safe, MS Project, and Rational ClearQuest. Trained in Fair Credit Reporting Act, Metro2 standards, and Introduction to Project Management.
01/05 to 07/05 – TekSystems/Hilcorp Energy (telecommute – Houston, TX) – Programmer/Analyst custom reports interface to ADP HR Perspectives (accounting software) using Access 2002. Created 352 queries using ADP HR Perspectives Toolbox and then created 352 tasks for automated export and task schedule; create interface for custom reports, report filtering, and Excel export process.
09/04 to 01/05 - Allied Consulting/Municipal Service Bureau (Austin, TX) – Programmer/Analyst providing part-time backup support for multiple Access 2003 databases (VBA), SQL Server 2000, XML, Classic ASP and Visual Basic 6.0 projects.
07/04 to 08/04 – ECS/El Paso Gas (Houston, TX) – Access Developer using Access 2003 ADP with SQL Server 2000; Gas pipeline Right of Way (ROWDMAP) application. Design UI for tract data entry, document information, and party of interest tracking database conversion from Access 97. Troubleshoot bugs, add new functionality to forms.
04/04 to 7/04 – Spherion/Dell Computers (Austin, TX) – Design and develop metrics tracking database for Software Licensing group using MS Access 2003. Work completed includes extensive Excel import/export process to create Lead Time Calculator report in Excel; simple security included (not using workgroup file but using data table for assigning members, member groups and security levels); also 3rd Party ActiveX (Lebans RichTextEdit ActiveX control) for rich text editing in memo fields on forms and reports; report filtering; installation package build using VBA Tools for Visual Studio .Net.
04/04 to 04/04 - Kforce/URS Engineering (Austin, TX) – 3 week project to design and develop Accounts Payable Statistics metrics tracking database (with install routine, setup as a runtime application, using workgroup file security, multi-user, networked) using MS Access 2000 for tracking employee metrics for Accounting Department.
09/03 to 04/04 - Tidy Techs/DEP Computers, Inc. for client, Transport-Tech, Inc. (telecommute – Pittsburgh, PA) – Foxpro Placement Manger program (DBF files) and imported into Access 2002 and created new database system for tracking student information, attendance, grades, follow-up and loan account information. Also included tracking for job leads, Employer and job placement information, and student leads. Created Loan Calculator and Amortization Schedule using OLE automation to export/import data to/from Excel back into Access. Also researched SQL Server conversion and SQL Server replication to the web. Created ASP’s to view all of the data submitted for an applicant from multiple table sources; converted, imported and cleaned data for normalization and naming conventions from multiple DBF files into Access 2002 database. Created ASP’s for reports online against Access database, using column head sorting and CSS (FTP processing uploading, downloading database files and ASP’s). Designed ASP's for Enrollment Application and Employment Application (with VBScript, CSS and form validation done in javascript), including security login, for one-to-many tables for add/edit records pop-ups. Created ASP's to display data (from multiple tables) for selected applicant. Created data process flow for project in Visio and converted to HTML for website.
09/03 to 07/05 - Tidy Techs/NASRA (part-time telecommute – Georgetown, TX) – Continued support for Public Fund Survey and Providers Access 2002 databases and website; continued part-time web site development and maintenance for website (www.publicfundsurvey.org); developed process flow in Visio of entire website (showing multi-tier logins) and access to all ASP’s; converted to HTML for customer online viewing. Created add and edit ASP submit forms for NASRA Roll Call of the States and view ASPs for viewing data by State or by Category; including sort by column head ASP reports (FTP processing uploading, downloading database files and ASP’s).
07/03 to 9/03 - Eurosoft/Covantage (Austin, TX) – MS Access Developer – Troubleshoot existing and create new EDI import/export processes (HIPAA 834 format) with batch files in multiple Access 2002 databases; troubleshoot and create new macros, VBA code functions, and forms processing as appropriate; enter new jobs in Tidal Scheduler - create calendars, add jobs, create instructions and notes documents; document incident resolutions in Magic Service Desk Enterprise.
05/03 to 07/03 - Tidy Techs/DEP Computers, Inc. for client, Physical Rehab, Inc. (part-time telecommute – Pittsburgh, PA) - Convert Allicance, DART, WIU, and AIU9798 databases from Access 97 to Access 2002; edit tables and data as needed for normalization and naming conventions; consolidate all tables, queries, forms and reports into one new Access 2002 database, to eliminate multiple data entry. Created table links to existing Turbo Accounting System and created Turbo reports, including Medicaid Report (UB92). Created report filter screens to select by District, Therapist, and Date Range; automate with new GUI. Created automated EDI export for monthly AIU Export Report to eliminate multiple data entry. Edited Turbo reports using Crystal Reports and Access. Revised Turbo ODBC table links, queries, and reports; revised AIU Export Report (for export process) using ODBC table links to Medics Elite Accounting System (CACHE SQL) and multiple queries to manipulate the exported data to Excel for new EDI export for monthly AIU Export Report (FTP processing database files to/from client).
05/03 to 05/03 - PDS Technical/State of Texas, Department of Human Services (Austin, TX) - VBA Developer – 1 week project for DHS, Special Nutrition Program to add/edit Word macros in VBA for multiple Word merge documents.
09/02 to 05/03 - Tidy Techs/Independent Consultant (Bryan/College Station, TX, Austin, TX, Georgetown, TX, Fort Worth, TX, Pittsburgh, PA) – Part-time telecommute on programming projects including Visual Basic 6.0 integration with Fortis document imaging software for Anco Insurance (Bryan, TX), Visual Basic 6.0 utility for Medimation software (C. Summers, Austin, TX), Public Fund Survey Access 2002 database, secured website and web database (ASP financial reports - www.publicfundsurvey.org, FTP processing) for Keith Brainard (NASRA), Georgetown, TX). Data analysis for Hot Mix, Inc. (Austin, TX). Website and shopping cart ASP store front (Hand-made Dichroic Glass Jewelry, Ft. Worth, TX www.hand-madejewelry.com using Dreamweaver and Fireworks (classic ASP, HTML, javascript, vbscript) and Flash logos, including shopping cart system using Access 2000. Customer Survey Satisfaction submit form, web database (ASP reports, FTP) for Jamie’s on the Square (Pittsburgh, PA), data conversion.
6/02 to 09/02 - Comsys/State of Texas Department of Human Services (Austin, TX) – Contract Programmer Analyst – Conversion of DHS Leasing System Access 97 database application to Access 2000 for Facilities Service Bureau. Combine data from several agencies into one database and recreate frontend functionality for multiple agencies. Wrote code to restore data integrity using transaction processing, commit and rollback; also wrote code for all forms to store user information. Detailed data analysis, Visio process flow, forms, modules, SQL and reports development, with security.
5/02 to 6/02 - Aquent/State of Texas Firefighters Pension Commission (Austin, TX) – Contract Programmer Analyst – Conversion and File Magic Document Imaging Interface to EPPS – Conversion of client/server EPPS (Emergency Personnel Pension System) frontend from Visual Basic 5.0 to Visual Basic 6.0 and database backend from Access 97 to Access 2000. New development including document imaging interface to open, query, and view scanned historical documents (File Magic) for current participant and/or payee from EPPS application, print and email options. Research File Magic 5.0 document imaging software for Batch Indexing process and DDE code. Incorporate Crystal Reports 7.0/True DB Grid 5.0 ActiveX controls.
1/02 to 04/02 - C&T Consulting/Texas Guaranteed Student Loan Corporation (Austin, TX) – Contract Programmer Analyst - CAO Database Conversion – False Certification, Treasury Offset, and Administrative Wage Garnishment. Data analysis, design and develop front-end for client/server application in Access 2002 ADP database for SQL Server 7 back-end. Stored procedures, views. Detailed reports. FMS Total Access Memo ActiveX control. Also responsible for tracking time on project line items using MS Project 98 and Access 2002 to complete weekly status reports.
12/01 to 2/02 - Vaporwerks/Greyfox Systems (Pittsburgh, PA) – (part time telecommute) Contract Data Analyst – Data analysis, development plan, project scope and software eval for e-Commerce business website, Great Plains Sage MAS-200 accounting software, e-Business Manager modules, FrontPage, Dreamweaver, MS Access 2000, SQL Server 2000. Edit ASP’s for customization.
1/01 to 4/01 - Vertigo Media/Clear Choice Laser Eye Centers (New York, NY) – (part time telecommute) Contract Programmer/Analyst - Develop two Access 2000 and one MySQL database systems to exchange data between them via FTP and HTTP using Microsoft ActiveX Internet Transfer Control (Inet), import and export processes and a web submit form using Php3 (Perl), Javascript, Vbscript, and HTML. Designed and tested ODBC connectivity with MySQL and ASP’s. Created submit form (to update MySQL tables) for customer requests; created two runtime installations for Centers Database and Call Center Database to track Center Information and New Patient Information. Extensive report filtering and sychronization of data. Created custom icons and background, refreshlinks code, Internet Transfer Control code, workgroup file, readme files; burned CD’s.
9/00 to 8/01 - Comsys/Texas Health & Human Services Commission, Office of Investigations and Enforcement (Austin, TX) – Contract Programmer/Analyst/Technical Writer/Trainer - Gather user requirements for Access 2000 conversion from Access 97 and Windows 98 for multiple client/server database applications (OIE Medicaid programs (Hospital, CaseMix, Nurses TILE, Physicians, PurposeU), converted VBA code from DAO to ADO where necessary, and solved issues with the production Access 97 databases for multiple client sites, multi-user, networked and linked databases. Investigated NT server performance issues, database performance issues, THHSC one-on-one staff training, and user support. Also provided support for Ombudsman FY 2001 Clipper program upgrade and installation, 28 AAA’s (over the phone), and created export function for Access 97 database to extract text file for import for Texas Dept on Aging (TDOA) Fiscal Tools to USAS. Provide support regarding Access security and miscellaneous issues (setup wizard, package and deploy wizard, writing queries, creating report and form filtering, and normalization) for NHIC program. Created documentation for Utilization Review Dept on all programs (Visio 2000). Created Access 2000 database and import/export process for Medicaid Exclusion website; also created ASP’s for searching records against Access 2000 database on website. Provided support and training as well as database revisions for Early Childhood Intervention (ECI) for multiple databases. Gather requirements, design Access 2000 Ombudsman FY2001 to replace Clipper system; data entry user training and support; converted historical data.
7/00 to 9/00 - Comsys/Texas Dept of Human Services, Office of Program Integrity (Austin, TX) – Contract - Programmer/Analyst – Access Developer: created database application for Quality Assurance Risk Assessment program, designing data entry screens, search screens, browse screens, print screen reports, summary reports, and associated automation (including security maintenance module for runtime) for entering data from case reading forms for Food Stamp program, welfare program, and Aid to Needy Families program. Database designed in Access 97, VBA, DAO including workgroup security for runtime.
5/00 to 7/00 - Kforce/Catapult Systems: State Bar of Texas (Austin, TX) – Contract - Access Developer – Troubleshoot and maintain client/server Access 97 databases and SQL Server 6.5, 7.0 databases for State Bar of Texas departments including MCLE, Membership and Dues Processing, Texas Lawyers Care, Research, Computer Services, Occupational Tax Processing, and Probono. Some SQL Server (databases, stored procedures and triggers), some Visual Basic 6.0, lots of VBA, some ADO, lots of DAO. Interview clients, gather user requirements and support for applications. NT and Novell platforms.
9/99 to 2/00 - Tidy Techs: Risk Management/Southern Union Gas (Austin, TX) – Contract - Access Developer - Access 2.0 conversion to Access 97; Risk Management database upgrade, including new development: built-in user and object level security and automated security maintenance from multi-user runtime networked environment, utilizing Windows API calls, VBA, setup wizard, DAO, import/export, references, OLE, ODBC. Created a powerful and extensive report filtering utility that utilizes 10 basic detail/costs reports to create 1,200 different filter possibilities. Also created a Readme file (which includes detailed installation instructions, contact and technical information) and bmp files for Startup and About forms. Application is utilized for tracking Worker's Comp, Vehicle, and General Liability Claims detail, costs and employee information. Also includes Texas Worker's Compensation "Employer's First Report of Injury or Illness" reports (Rule 120-2), and OSHA reports. All reports available for each claim type and/or all claims, grouped by Insurance or Company, and filtered by user selections from 10 preset filters. Prepared extensive admin documentation, including screen shots and code.
9/99 to 11/99 - Tidy Techs: ENERGY worldnet (Austin, TX) – Contract - Technical Lead/Programmer/User Support - Support and maintenance for client/server OQrms Database (Access 97) and Total OQ (SPICE courseware), AuthorPower LinX and Macromedia Authorware, and other support functions. Handled all installations and support out-of-town. Created user manuals and provided one-on-one training for OQRMS Database. Edit courses to make generic - graphics, conversion, Mockingbird (TERMS) Linx macroscripting, create CD sets, test and distribute. Troubleshooting and problem resolution for customers and on-site network and workstation installs and one-on-one user training. Provided software updates to licensed customers.
3/99 to 9/99 - Romac/Southern Union Gas (Austin, TX) – Contract - Programmer/Analyst - Access Developer - Projects include the client/server Total OQ OQrms Database and OQrms Demo project. (Energy WorX – used for tracking data related to Federal regulations concerning test scores and qualifications of employees with related jobs, tasks and evaluations). Finish DAO and Visual Basic development of Access Database for distribution. Fix DAO and Visual Basic code and make enhancements according to client specifications. Create install routine for runtime multi-user secured environment. Also wrote VBA code to refresh tablelinks to backend database, refresh references, restore data integrity using transaction processing, commit and rollback. Developed Access database for Demo with 30 day expiration and created fullblown secured Version 1.0 release (disabled SHFT key, included security workgroup file, built-in security forms for adding/deleting users and adding/deleting users to groups, changing passwords, etc.), restricted toolbar and menu, runtime, and object level security. Built-in, customized, automated import/export processes. Included Windows calendar, open/save dialog, browse for file, browse for folder, API calls. Added code to resize forms and/or objects on forms to fit display resolution. Edit Mockingbird (TERMS) Linx macroscripting. Other database troubleshooting for SUG including the T.E.S.S. One Call application (tracking calls about underground gas lines, locations, and service techs by assigned areas) and ABEP application (Benefits) conversion from Access 2.0 to Access 97.
4/98 to 2/99 - Eurosoft/Center for Rural Health Initiatives, State of Texas (Austin, TX) – Contract - Programmer Analyst/User Support - Access 97 Developer for State Agency. Client applications to automate record keeping for State sponsored rural health care programs. Most extensive development - Outstanding Rural Scholar Recognition Program (scholarship program for students enrolled in health care academic programs). Data normalized by academic session and current academic year based on student status. Application included historical data (archive) and links to other databases, and over 100 Word merge documents incorporated to automatically activate and merge from Access queries (OLE). Extensive scope of project, data analysis, development and automation of business systems [event driven -- VBA] (using Office 97). Data conversion from WordPerfect, Excel, and FoxPro (Dos) 2.6. Created 9 Access 97 databases including: ORS, Central Mailing System (FoxPro 2.6 Dos conversion), Medically Underserved Communities, Health Find/Pro Find, Texas Health Service Corps, HotJobs!, ACES, and Physician Assistant Loan Reimbursement Program. Provide user support and one-on-one Word merge training.
9/97 to 2/98 - XXCAL/Dell Computer Corporation (Austin, TX) – Contract - Programmer/Analyst/Trainer – Visual Basic/Access Developer for IT department. Client/server application for Human Resources Adhoc reporting and Dell University metrics reports. development of approx. 50 reports in Crystal Reports and Access97 using ODBC drivers to link to Oracle Data Marts in SAP Transition project. Also design and development of Visual Basic 5.0 code to create extracted text files for import into Access97 adhoc databases for HR. Installed InterSolv ODBC drivers on approx. 50 PC's. Created training documentation and conducted classroom training (6 users per class) for power users (about 30 users) for Full Adhoc Reporting using ODBC drivers to connect to the Data Marts using Access97. Used PL/SQL to test queries against Oracle Data Mart tables. Assisted with the HR DirectView Employee Profile internet application user acceptance testing. Access 2.0 and 7.0 database conversions to Access97 and Office97 upgrades. Provided one-on-one user training and support. Assisted with cross-reference metadata and mapping from HR1 legacy system (Advanced Revelations) to (SAP) Data Warehouse and (Oracle) Data Mart.
7/97 to 9/97 - XXCAL/Dell Computer Corporation (Round Rock, TX) – Contract - Project Lead for Sales Force Automation project for several marketing and sales groups within Dell Computer Corporation, which includes Global, Enterprise, Large Corporate Accounts, Education, State and Local. Project consisted of requirements gathering, scope of project, development, training of contact management, forecast management and account management applications using Target Account Selling methodology. Outlook/Exchange customization, ACT! and Opportunity Manager. Design screens, forms, reports, queries, and links to the Internet and Email addresses, using VBA and VB Scripting. Other sales groups have requested an off-the-shelf application that will involve customization of the TAS methodology and uses an Oracle database back-end. Job tracking in MS Project 95.
4/97 to 7/97 - PDS Technical/Texas Rehabilitation Commission (Austin, TX) – Contract - Lotus Smartsuite (Approach) LotusScript developer. Develop client/server data warehouse Human Resources Application for Client Services Development Department. Customized reports, forms, macros, scripts and queries to automate system. ODBC linked to Informix 7.2 database Employee table. Prepared detailed Visio flow chart for database documentation and created user training manual. Designed custom menus.
3/97 to 4/97 - ID Systems, Inc. (Houston, TX) – Contract - Clean up, customize, and test scouting program for major football team. Development using Access 7.0. Edit existing macros to VBA code. Fixed existing queries, customized forms and reports, and created new code to standardize various forms and reports properties. Prepared documentation.
2/97 to 3/97 - General Employment/BCI Corp. (Houston, TX) - Contract - Assisted Foxpro Developer to create runtime application (program to teach English as a 2nd language [front end Access 2.0/back end Pascal). Used Access 2.0 SDK and InstallShield to create setup.exe for 16bit and 32bit installs. Customized forms and code for runtime errors.
8/96 to 2/97 - Hestair/Compaq Computer Corp. (Houston, TX) – Contract - Programmer/Analyst/User Support - Applications Developer/MS Access and Excel Win95 - Runtime application development project to replace manual preparation of metrics reports prepared in Excel and PowerPoint to automated system that included OLE from Excel to Access. Develop Metrics Database, involving over 60 reports linked to Excel 7.0 data sheets and charts. Developed VBA code to automate system and used Access SDK to create setup program for installation and distribution. Developed documentation for database admin and users. Designed Excel 7.0 workbooks, data sheets, charts, dialog pop-ups, historical data, and macros to automate charting. Designed Access forms for OLE Excel reports for printing, created links to forms, reports and Excel workbooks. Provided one-on-one user training and support to over 70 users, including admins, managers and supervisors in FS&O. Research Impact Office97.
12/95 to 8/96 - Staffware/Dow Chemical (Lake Jackson, TX) – Contract - Data Migration Specialist/MS Access Applications Developer - Windows 95 and NT roll-out team for over 26,000 users at DOW Texas in Freeport. data migration, development and testing for Windows 95 client/server and desktop applications during NT rollout. Conversion of legacy database data, restore data integrity, normalize tables and