Programmer Analyze Resume
Cedar Park, TX
Software Experience:
Database Design and Development:
- SQL Server 6.5, 7.0, SQL Server 2000, SQL Server Express 2005
- SQL Navigator, SQL Query Analyzer
- MS Access (all versions VBA, DAO, ADO, ODBC, ActiveX, Security, SQL, ADP)
- 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, CSS, FTP
- (web hosting, shopping cart, 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, 2007
- Visio 2000, 2003, 2007
- 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, Vault
- File Magic 5.0 and WTI Fortis 1.12 Document Imaging Software
Confidential - contract Access 2007 programmer; analyze performance issues in existing application; split database into frontend/backend; added menu and set startup options; established batch file release process; wrote admin instructions for maintaining batch file release process; added “Flag Alert” process for Manufacturers’ and Builders’ for those registrants who have enforcement actions pending; created Decals Monthly Report Import Tool (DMRIT) application to import Excel data and verify manufacturer reported decals and verification of manufacturer reported serial numbers; wrote Statement of Work with recommendations, findings, and work completed details.
Confidential - contract Visual Basic programmer; analyze approx 50+ Visual Basic projects for existing systems including Parts Description, Sensor Scan (2 versions), Hydraulics, TempComp, Quality, and various applications written in Visual Basic 6.0. Produce Visio data flow charts, and data analysis. Test re-compiles on multiple projects with dependent ActiveX components. Edit existing code: add polynomial transformation equation to calculate the difference between linear coefficients and quadratic coefficients for Sensor Scan (test stand) software; fix errors in code; revise GUI;make enhancements for ease of use; edit and add code to write to/read from DCSC board on unit under test. Edit stored procedures (SQL Server 2005). Re-compile and re-install (including register and unregister ActiveX component files) for 50 users due to a server name change. Write code to read from/write to XML. Software used: Vault (similar to Visual SourceSafe), SQL Server 2005; Visual Basic 6.0; Visio; MS Access 2003; FoxIt Reader; FarPoint Tab Pro.
Confidential - contract Access 2003 database developer; extensive data analysis to create development plan and statement of work; database enhancements and revisions, add Pregnancy Stats for frozen cycle; add IVF Fert Stats for fresh cycle for Austin IVF Lab; add new tables and data entry forms for Texas Fertility Clinic
Confidential- contract Access 2007 database developer; create import parsing process for Schedules, Jobs and Special Calendars text files from Maestro; create data parser; combine data; create csv exports to integrate in VBR/BDR system for reporting. Create ASP page for HTML output of data generated from parsing.
Confidential - contract Access 2003 database developer: extensive data analysis to determine state of existing stand alone POS Application; enhancements including changing from stand alone single user to networked multi-user application, automation of the processing of POS data received from various Distributors; includes EDI, Excel, csv, and text files; custom import and export processes. Develop custom design directly to system tables to automate the creation of import specs. Also includes login system, and reports. Provide Visio documentation, user documentation, and administrative documentation.
Confidential Beaumont, TX (telecommute via Citrix and VPN) - contract Access 2003 database developer: enhancements to Case Law System database including search screens (build pass-through queries (SQL Server 2005)) for search “My Cases” and search “Calendar” items based on logged in user. Perform form and query audits; troubleshoot performance issues and SQL syntax errors; edit existing forms/queries; create new reports.
Confidential Austin, TX – Create runtime MS Access database tool to in corporate into Electronic Flight Bag software (GENESYS). Display selected airport with JPG and Flash movies created from AVI files. AVI files encoded and imported into Flash as Flash Video format, with additional JPG animation. AVI files created utilizing Google Earth, Google Maps, FRAPS, Virtual Dub, and ImTOO Encoder. Flash movies detail zoom and rotated views of the runways for 10 Special Use Airports. Runtime installation created using MS Office MS Access Extensions SDK Package Wizard.
Confidential, Austin, TX – Access 2003 database enhancements; add new reports; add new data entry and edit forms; create search forms; add new tables
Confidential 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
Confidential (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
Confidential (Medisun Consulting, Austin, TX) – Visual Basic Programmer – edit existing VB 6.0 project for DTS processing code to SQL Server 2005; write code to process DTS functions via ADO; code file system objects to copy Access MDB database files for import into SQL Server 2005; Web Application using ASP.NET 2.0 and VB Studio.NET 2005 to display data from a SQL Server 2005 database into an editable DataGrid; analyze queries using SQL Navigator and SQL Query Analyzer.
Confidential (Austin, TX) – HTML programming – edit ASP.NET aspx for HTML content
Confidential (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
Confidential(Austin, TX) – create data dictionary for Agresso Accounting System tables to utilize in Excel Excelerator SQL query tool for reporting purposes (3 week project).
Confidential (telecommute – Houston, TX) – 3 mo contract MS Access 97 - VBA to update database revisions (updating fields, tables, queries, and VBA code for import/export processes; add security update forms).
Confidential (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 Confidential, Confidential, Confidential, and Confidential using Access 2000 database and Dreamweaver. Also provide web hosting and website development services to Confidential, Confidential, Confidential, Confidential, Confidential, Confidential, and Confidential 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 Confidential Provide back-up Access database development support to Caterpillar staff developer. Provide web hosting and development (including shopping cart maintenance for product updates), FTP and email support, as well as Flash and database development (Access 2000) to Confidential Provide database support to Confidential (NASRA) using Access 2003.
Confidential, LP (Houston, TX) – Programmer III/Tech Liaison providing Access database development for Collections/Default Technology department. Develop/maintain 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/maintain Collect database and Collection Letters databases (42+); design/support Loss Mitigation database; provide support for Research database. 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. Design data interfaces to support process data warehouse processes and letters (collection letters, reminders, repayment plans) processing; Design/implement queries to extract specific data from relational data sources into data warehouse; Establish controls to ensure the accuracy and consistency of data; Report Development & Deployment. Meet with department heads and end-users to gather reporting, data entry, data validation, and user interface requirements; Analyze requirements to create/revise forms and reports; Develop key complex business reports. Troubleshoot/maintain scheduled processes for MS Scheduler for Access databases on multiple servers. Create batch file release process for frontend/backend installations. Provide co-worker training; serve as Technical Lead within department. Create EOM credit reporting for 600,000+ loans to conform to Metro2 format. 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, MS Scheduler, and Rational ClearQuest. Trained in FCRA, RESPA, Metro2 standards, and Introduction to Project Management.
Confidential (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; created 352 tasks to automate export task schedule; create interface for custom reports, report filtering, and Excel export process.
Confidential(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.
Confidential(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.
Confidential(Austin, TX) – Design and develop metrics tracking database for Software Licensing group using MS Access 2003. Created Excel import/export process to create Lead Time Calculator report in Excel; simple security included (not using workgroup file; using table for assigning members, member groups and security levels); 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.
Confidential (Austin, TX) – 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.
Confidential (telecommute – Pittsburgh, PA) – Foxpro Placement Manger program (DBF files) and imported into Access 2002; database system for tracking student information, attendance, grades, follow-up and loan account information. 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. Researched SQL Server conversion and SQL Server replication to the web. ASP’s to view all of the data submitted for an applicant from multiple table sources; converted, imported and normalized data, cleaned up naming conventions from multiple DBF files into Access 2002. ASP’s for reports (Access database backend), using column head sorting and CSS (FTP processing uploading, downloading database files and ASP’s). 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. ASP's to display data (from multiple tables) for selected applicant. Visio Data process flow.
Confidential (part-time telecommute – Georgetown, TX) – Support for Public Fund Survey and Providers Access 2002 databases and website; web site development and maintenance developed Visio process flow (showing multi-tier logins) and access to all ASP’s; converted to HTML for customer online viewing. Created add/edit ASP forms for NASRA Roll Call of the States and 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).
Confidential (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.
Confidential (part-time telecommute – Pittsburgh, PA) - Convert Allicance, DART, WIU, and AIU9798 databases from Access 97 to Access 2002; edit tables for data normalization and naming conventions; consolidate all tables, queries, forms and reports into one database. 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); queries to manipulate exported data to Excel (EDI export for monthly AIU Export Report)
Confidential (Austin, TX) - VBA Developer – 1 week project for DHS, Special Nutrition Program to add/edit Word macros in VBA for multiple Word merge documents.
Confidential (Bryan/College Station, TX, Austin, TX, Georgetown, TX, Fort Worth, TX, Pittsburgh, PA) – (Part-time telecommute) 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 database (ASP financial reports -, 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 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.
Confidential (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. New code to restore data integrity using transaction processing, commit and rollback; wrote code for all forms to store user information. Detailed data analysis, Visio process flow, forms, modules, SQL and reports development, with security. Confidential (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. Document imaging interface to open, query, and view scanned historical documents (File Magic) for current participant and/or payee from EPPS application, print/email options. Research File Magic 5.0 document imaging software for Batch Indexing process and DDE code. In corporate Crystal Reports 7.0/True DB Grid 5.0 ActiveX controls. Confidential (Austin, TX) – Contract Programmer Analyst - CAO Database Conversion from FileMaker Pro to MS Access – 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. Confidential (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. Confidential (New York, NY) – 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/export and submit form using Php3 (Perl), Javascript, Vbscript, and HTML. Designed ODBC connectivity with MySQL and ASP’s. Submit form (to update MySQL tables) for customer requests; Two runtime installations for Centers Database and Call Center Database to track Center Information and New Patient Information. Report filtering and sychronization of data. Created custom icons and background, refreshlinks code, Internet Transfer Control code, workgroup file, readme files; burned CD’s. Confidential (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 - Hospital, CaseMix, Nurses TILE, Physicians, PurposeU), converted VBA code from DAO to ADO, solved issues with the Access 97 databases for multiple client sites, multi-user, networked and linked databases. Investigated NT server performance issues, database issues, THHSC one-on-one staff training, and support. Provided support for Ombudsman FY 2001 Clipper program upgrade and installation, 28 AAA’s, and created export for Access 97 database to extract text file for import (Texas Dept on Aging (TDOA) Fiscal Tools to USAS). Provide Access security (setup wizard, package and deploy wizard, queries, report/form filtering, and data normalization) for NHIC program. Provide Documentation to Utilization Review Dept (Visio 2000). Develop Access 2000 database and import/export process for Medicaid Exclusion website; created ASP search engine for Access 2000 database. Provided support/training and database revisions for Early Childhood Intervention (ECI). Gather requirements, design Access 2000 Ombudsman FY2001 to replace Clipper system; data entry user training and support; converted historical data. Confidential (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, workgroup security for runtime. Confidential (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. Confidential (Austin, TX) – Contract - Access Developer - Access 2.0 conversion to Access 97; Risk Management database upgrade, new development: built-in user and object level security and automated security maintenance from multi-user runtime networked, utilizing Windows API calls, VBA, setup wizard, DAO, import/export, references, OLE, ODBC. Report filtering utility 10 basic detail/costs reports to create different filter options. Created a Readme file (detailed installation instructions, contact and technical information) and bmp files for Startup and About forms. (Worker's Comp, Vehicle, and General Liability Claims detail, costs and employee information, Texas Worker's Compensation "Employer's First Report of Injury or Illness" reports (Rule 120-2), and OSHA reports). Admin Documentation. Confidential (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 - graphics, conversion, Mockingbird (TERMS) Linx macroscripting, create CD sets, test and distribute. Troubleshooting and on-site network and workstation installs and one-on-one user training. Provided software updates to licensed customers. Confidential (Austin, TX) – Contract - Programmer/Analyst - Access Developer - Client/server Total OQ OQrms Database and OQrms Demo project. (Energy WorX –tracking Federal regulations concerning test scores and qualifications of employees with related jobs, tasks and evaluations). Finish DAO and VBA in Access for distribution. Fix code errors. Create install routine for runtime multi-user secured environment. VBA code to refresh tablelinks to backend, refresh references, restore data integrity using transaction processing, commit and rollback. Developed Access database for Demo with 30 day expiration and created secured Version 1.0 release (disabled SHFT key, included security workgroup file, built-in security forms for adding/deleting users and 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. Code to resize forms and/or objects on forms to fit display resolution. Edit Mockingbird (TERMS) Linx macroscripting. Troubleshooting for SUG re 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. Confidential (Austin, TX) – Contract - Programmer Analyst/User Support - Access 97 Developer for State Agency. Client applications for State sponsored rural health care programs. 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. Historical data (archive) and links to other databases, and over 100 Word merge documents incorporated to automatically activate and merge from Access queries (OLE). Scope of project, data analysis, automation of business systems. 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 one-on-one Word merge training.Confidential (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. 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. Training documentation and 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. PL/SQL to test queries against Oracle Data Mart tables. Assisted with the HR Direct View 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. Assisted with cross-reference metadata and mapping from HR1 legacy system (Advanced Revelations) to (SAP) Data Warehouse and (Oracle) Data Mart.
Confidential (Round Rock, TX) – Contract - Project Lead for Sales Force Automation project for marketing and sales groups within Dell Computer Corporation (Global, Enterprise, Large Corporate Accounts, Education, State and Local). Requirements gathering, develop scope of project, database development, training contact management, forecast 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. Job tracking in MS Project 95.
Confidential (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. Prepared detailed Visio flow chart for database documentation and created user training manual. Designed custom menus.
Confidential (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.
Confidential (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 exe for 16bit/32bit installs. Edit code for runtime errors.
Confidential (Houston, TX) – Contract - Programmer/Analyst/User Support - Applications Developer/MS Access and Excel Win95 - Runtime application (for metrics reports prepared in Excel and PowerPoint) to automated system (OLE from Excel to Access. Develop Metrics Database). Develop 60 reports linked to Excel 7.0 data sheets and charts. 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, created links to forms, reports and Excel workbooks. Provided one-on-one training to 70 users, including admins, managers and supervisors in FS&O. Research Impact Office97.
Confidential(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. Conversion of legacy database data, restore data integrity, normalize tables and develop application GUI. Convert Lotus spreadsheets to Excel and convert Lotus macros to Excel VBA. Testing and conversion also included MAC files to IBM format, converting client/server and desktop database applications from Access 2.0, Dbase III, Clipper 5.0, Approach, FileMaker Pro, DataEase, Lotus 2.2, and Excel 4.0 to Excel 7.0 and Access 7.0. Applications testing for WIN95. User assistance/training; Access 7.0 development using VBA.
Confidential (Houston, TX)– Contract - LAN/PC Roll-out for 400 users. Conduct interviews, inventory old PC's, new PC's, and software. Backup local drives, install network cards and drivers, install standard load (DOS 6.2, Windows for Workgroups 3.11), install standard network load (MS Office 2.0, MS Project, in-house apps, virus protection, WINstall, and Rumba), network/mainframe connectivity), install software exceptions, customize desktops, setup modems, CD ROMs, and tape drives for laptops, setup network printers and drivers, tear down/setup equipment, format drives.
Confidential (Amerada Hess) (Houston, TX)– Contract - Help Desk/MS Access - User support for 400 users to resolve intermediate/advanced issues re mainframe, printing, Windows 95, Excel, Word (merges, style sheets, templates, auto numbering, tables, using OLE), WordPerfect 5.1 DOS and 5.2 Windows, and Lotus 123. Troubleshoot network printing.
Confidential (Houston, TX) - Contract - Network Admin and MS Access: Troubleshooting network, printer, and hardware problems; general network maintenance; conversion from Skiltrak (DOS Dbase IV) to Staffsoft ( FoxPro 2.6) using MS Access 2.0 to import/export to FoxPro 2.6. Import files from Sharkware into Staffsoft.
Confidential (Law Firm Houston, TX) – Contract - End User Support and Training: Assist Training Specialist and Network Administrator; user support; one-on-one training. Troubleshoot software and hardware. Provide one-on-one training and support for WordPerfect 6.1 for Windows and WordPerfect 5.1 for DOS, and for PC Docs. Convert and rewrite macros. Backup word processor. Set up templates, forms, merge documents, and configure PC's.
Confidential (Houston, TX) - LAN Administrator: Managed Novell NetWare networks; assisted Systems Analyst; performed daily backups on 21 file servers using ARCserve; supervised software/hardware inventories and SPA audit. Set up Access 2.0 database; organize software, registration and licensing, Assisted with installation of MS Mail, Windows NT, and D&B SmartStream.
Confidential (Houston, TX) – Contract - Help Desk Support Level II. Level II troubleshooting, installation/configuration PC's and software. Troubleshoot and install Lotus Smartsuite applications (Lotus 123 v. 4.01, Lotus Approach, AmiPro, Lotus Organizer, Freelance Graphics, cc:Mail and cc:Mobile.
Confidential (Reading & Bates Houston, TX) – Contract - MIS Administrator: Approx. 173 users. On-site liaison for network admin, software inventory, installation, configuration, troubleshooting, user training (cc:Mail, X.400, Windows 3.1, Lotus 1-2-3 R.4.0, WordPerfect 5.2, WordPerfect 6.0 and 6.0a, MS-Access V.1.1 and 2.0, Freelance Graphics, AutoCAD R.12, Primavera, and AS/400 new users). Assistant Hypertext Admin (HTML, VBA Help Text Compiler and AmiPro). Coordinate IS/delegate off-site network admin, PC techs, systems analysts, and communications admin. Setup help desk Access DB. Developed runtime applications (MS Access 1.1) w/ security; develop network/software license policies and compliance plans; system audits. Set up classes for self-paced CBT. Assisted QAQC Auditor with Btrieve conversion to Access SQL
Confidential (Houston, TX) - Independent Computer Consultant: Perform hardware/software maintenance, repair/upgrades, installation, configuration, troubleshooting and one-on-one software training (MS Office, Lotus Smartsuite, and Perfect Office. Also performed word processing and bookkeeping services. Installed and configured Russian OCR/translation software and Cyrillic fonts for major law firm; small office design, installation of equipment/software; prepared 36 page quarterly newsletter for High School Band using WordPerfect 5.2 and 6.1, CorelDRAW 3.0; MS Access 2.0, 7.0 troubleshooting.
Confidential (Houston, TX) - Network Administrator/Word Processing Supervisor/Trainer: Maintain Novell NetWare LAN network, 45 WS and 9 printers. Set up users, installed network cards, peripherals, software. Provide support/training in WordPerfect 5.1 DOS, AskSam, Windows 3.1, and Lotus 1-2-3. Installed HP Scanjet and OmniPage Software. Provide support and software proficiency testing. Supervisor of word processing for 14 attorneys, 4 paralegals and 15 secretaries. Performed 2 system upgrades (Novell, and ) Trahan & Partners, Houston, TX Word Processor 1 yr.
Hughes, Pelz, Leach & Clikeman, Denver, CO Legal Word Processor 2 yrs.
Cole & Daugherty, Houston, TX Legal Assistant 2 yrs.
Word Travels, Amarillo, TX Word Processor 4 yrs.
Town of DeBeque, DeBeque, CO Town Clerk 1 yr. Education Metro2 Credit Reporting – CDIA Seminar – May 2006
Introduction to Project Management - Global Knowledge – November 2006
XtremeLearning.com (Online Courses – XML Programming Part1, Introduction to E-Commerce) Sept 2002
Microsoft Web Tech Ed (InterDev, OLE DB, ADO) June 1998
C-TREC November 1993 (NetWare 4.x System Administration)
Microsoft Access Beginning and Intermediate February 1995 (MS Access V.1.1, 2.0)
Microsoft Seminar, Windows 3.1 June 1992
Quest Seminar July 1992 (Troubleshooting, Upgrading and Maintaining PC's, Introduction to Microcomputing and DOS)
Edutech Houston, Texas October 1991 (NetWare 3.11 System Administration)
Santa Rosa Junior College Santa Rosa, California (Major: Arch.Const. Tech. Minor: Graphic Illustration)