David Thomas Email & Phone Number

Los Angeles, Ca, Us

• Microsoft Access Database and SQL Server database Creation and maintenance tasks. • Modifying legacy databases• Linking SQL Server database to Access database to put Access frontend forms and reports on SQL Server data. Process Monitoring• Desktop hardware support and printer issues

Development● Create, modify, or Repair MySQL and Access Databases.● Remove computer virus, Trojans, and Adware.● Create user interfaces and reports● Used multiple technologies to perform the work. SQL, VBA, HTML, CSS, JavaScript, PHP, Python, some Open-source freeware and Microsoft products.

• Created a database modification/task tracking database for developers to enter a database modification log. • Microsoft Access Macro conversion to Visual Basic Applications code for compliance with new network policy to remove all macros from network, converting the to a code format. • Speedup Slow running processes in existing Microsoft Access database.• Create new dynamic code in MS Access Visual Basic Applications code dynamic scripts using functions and Sub function stored procedure modules to create and link Databases and new tables, procedure calls to SQL Server tables. Use of updates, inserts, deletes, selects, and altering tables.• Helped another developer with an ASP\ VBX code for a console to put into Sharepoint. They liked the design but due to time constraints and my availability, the developer needed to work with another team, while I worked with the database projects. • Modifying and creating new data entry forms with multiple required fields, dropdowns, popups with customized access/vba error reporting code emailed to admin thru Microsoft outlook integration code in VBA. • After finishing the initial macro conversion request, was prompted to do an overhaul on the database to remove some errors and slowness. Some Task automation and modifying some of the Legacy script, removing errors, finding data code patterns that can be converted to looped functions calls when needed, and getting it to run more efficiently without hiding errors as it previously had been doing, as well as adding variable and looping technology. • Data validation in data spec spreadsheets, for each the main database and it’s form objects.• Attended Microsoft Teams meetings to discuss new functions and changes to forms and spreadsheets for the 2120 database. Worked on multiple revisions of the database a few of it’s from and its New Line New form. Work in progress as end of contract coming up.

Jacksonville, Florida, Us

Contract SQL Server Developer with SSIS package integration.

My Duties: T-SQL Programming within SQL Server 2008 and 2014 & HCC Manager.• Modifying and creating queries to pull and organize medical data for automated generation of patient correspondence letters, patient assessment forms/patient assessment reports with multiple clients and company logos. • Modified code that reported RAF scores, STAR measures/Quality measures and Patient data joined on Medi-span data tables. Worked in HCC Manager (an SSRS / Crystal Report like proprietary medical data reporting software) creating multi-layered reports and letters.• Created logos with transparent background in GIMP in order to be used in client letters and reports.• Created reporting prompts and conditional code to be executed for each prompt. • Created queries to lookup Case Managers in some of the dropdown prompts for the CM Letters and reports for each client.• Troubleshooting reports in T-SQL and in HCC Manager.• Communicated with Customer Service, other programmers, and the report/software testers.• Utilized Microsoft Office tools such as Word, Excel, Outlook, Paint, One Note, Power Point, and Visio. • From time to time went upstairs to get and replace sparklettes water bottles.-Websites: www.mdxnet.com

Menlo Park, Ca, Us

Robert Half International – Technology Division in Torrance, CA December 2012-March 2014Software Application Developer, Web Developer, Database Administrator My Assignments:Assignment 7: SQL Server and Perl Programming: Client: In Newport Beach, CA – SQL / Perl Programming ...request full resume for details.Assignment 6: Database Programming: Client: In Downtown, CA-Microsoft Access 2010/SQL Server –Worked with data from Covered California, Programmed VBA programs to import and export data. ...request full resume for details. Assignment 5: Database Programming: Client in Long Beach, CA - Microsoft Access 2010 – Created a small electrical power conversion database from a pre-existing Lotus 123 spreadsheet. ...request full resume for details.Assignment 4: Database Programming: Client: In Gardena – Microsoft Access 2010 – Created A product inventory tracking database with barcode scanning and barcode label printing from a pre-existing Excel multi tabbed spreadsheet file. ...request full resume for details.Assignment 3: Database Programming: Microsoft Access 2013 and SharePoint2013 within Office365 in the cloud. Client: In Santa Ana Microsoft Access 2013 and SharePoint2013 on windows 360 and Windows 8 Operating systems. Linking data tables from SharePoint 2013 within Microsoft Office360 on the Cloud to Microsoft Access 2013. Creating a database from ground up.Assignment 2: Database Programming: SQL Server/Visual Basic Software Development in Visual Basic. Client: In South Central Los Angeles Microsoft Access Database contract job. I fixed a corrupted database. ...request full resume for details.Assignment 1: Visual Basic Programming: Visual Basic Within Microsoft Excel Macro and also creating graphs. Client: Chino: Visual Basic within Microsoft Excel macro. ...request full resume for details. -Websites: www.RobertHalfInternational.com and www.RobertHalfTechnology.com

Software Application Developer -- My core duties: SQL Server/Visual Basic Software Development in Visual Basic • Modified Visual Basic programs connected to SQL server 2005, for both the Check Processing and the Mass client email program. • New client account setups.• Creating and modifying Crystal Reports and linking to SQL Server 2005 Additional workload: • Fix printing and PC issues on both the local printers and the networks big Minolta 1050 and 1200 printers.• PC setups with XP, Windows 2003 and Windows 8, and in house applications. • Blackberry setup with Telenav and Beamsuite software.• Replacing Optical Reader on HP 9080C Document Scanner. • Retransmitted legal documents for staff that did not transmit correctly into the system.

Brea, California, Us

Technical Support Specialist / NOC Web and Database Admin -- My core duties: • Monitoring Network and running batch job processes, addressing and escalating problems. Took over role as problem management. Receiving and transmitting client policy data, backups, restores, troubleshooting network issues. Using LINUX systems, Windows XP and 2003 systems, HP mainframe, TIVOLI job scheduler, AVAYA, Foglight, and ARGENT administrator console, PING, Tracert, and finger…***Additional workload As SharePoint, WEB and Database Developer/Administrator for NOC and Operations***• I programed and maintained Access 97, 2003, 2010 databases for Operations• I created and modify Visual Basic and VBscript to created user interfaces connecting to the databases and to execute scripts on the network shared drives, transfer and creating HTML change management summary table on the fly.• I administered, programmed, and maintaining websites, both in Share Point and standalone, for Mercury’s: Network Operations Center and Operations Command: Programmed in Dream Weaver and Microsoft Notepad to create a combination of HTML, CSS, PHP, ASP, and JavaScript to connect to and insert our daily tasks, documentation, and databases into the websites. • Maintained databases for the Material Damage Department Initial programming was done before hire while temping at Helpmates staffing.These databases utilize the SQL and visual basic programming language interfaces within the Microsoft Access Programming environment.- Website: www.MercuryInsurance.com

Irvine, Ca, Us

Senior Support II -- Temping for Mercury Insurance Group's Material Damage Department My duties included: • Microsoft Access database development (designing and programming graphical user interfaces to collect data and generate reports and organization charts). • Programmed SQL queries to create tables, to update tables, to delete data from tables, to compare data in tables, and to append data to tables, and created dynamically generated reports. • Programmed forms and reports that connected to these queries allowing both forms and reports to search for data and pull up similar records. • Creating monthly agent productivity reports and organizational charts within Microsoft Access using SQL and Visual Basic source code on the back end. These reports have been viewed by the senior executives at Mercury and lead to me being hired at Mercury Insurance and contributed to the promotion of my supervisor’s boss Mike Hall to regional manager for the West Coast. • Additional duties also included basic Local Area Network and PC troubleshooting, fixing printer issues, Microsoft Outlook issues as well as other technical issues. - Website: www.helpmates.com

Software Developer/Programmer -- Part time: Duties: • Designed and programmed databases and web pages for Dawn Enterprises clients. • Designed and programmed databases in Microsoft Access 97, 2003• Designed and programmed dynamic web pages in PHP / HTML with JavaScript and Macromedia Flash. - Website: www.Dawnenter.com

Round Rock, Texas, Us

Software Developer / Benefits Analyst -- Duties:• Helped administer a UNIX and Novell system. • Modified and created HTML, C programs, UNIX shell scripts that sorted and reformatted data to create monthly and weekly reports and data files for our clients in the healthcare industry across the United States. • Created and Modified Databases used for HIPAA compliance, monthly employee head count reports, and managing production task. • Assisted in designing and programming of a fully functional password protected Website on Apache server which connected to our Benefits data within our UNIX server. • Programming languages used while at Perot include UNIX shell scripts, C shell within the UNIX environment using the VI editor. Within Windows environment I programmed in Microsoft Visual Studio’s C/C++, HTML, JavaScript, SQL server, Visual Basic, VB for Microsoft Access, and SQL within Access. While at Perot I trained others in Benefits Service Unit (BSU) production processes for our clients (Tenet Healthcare, Blue Cross, CIGNA, VSP, and Merck Medco). While at Perot I have designed/programmed/modified databases, web applications, GUI - front-ends, created presentations, flow chart, and documentation using VISIO and Power Point. Also during my time at Perot I have setup workstations for users, setup exchange, and POP inbox profiles; I assisted users in configuring CISCO wireless leap and VPN connections.• Used the Exceed emulator and telnet to work in our IBM Sequent Unix server and Exceed FTP / Dos FTP to migrate data form the UNIX environment into the Windows Office environment in which macros were ran in Word and Excel for further formatting. **** PLEASE SEE ATTACHED RESUME OR REQUEST -- This field was not big enough****

Bachelor'S Degree, Computer Information Systems

Associate'S Degree, Libral Arts / Computer Science

Diploma

Education record

Education record