Mark Nichols

Citrus Heights, CA *****

https://www.linkedin.com/in/mark-e-nichols/

Desired Job Title: Data Entry Operator

More than 30 years of experience in IT, beginning as a database programmer/analyst designing and maintaining billing systems, insurance claim systems, county assessor and county legal transaction ETL applications. Competent in creative tool-building aspects of data quality work and have successfully delivered desired results in numerous different technologies.

Developed and documented data quality measurement tools and methods to ensure database integrity

Identified and resolved data quality problems for large volumes of data

Trained offshore employees in the use of SQL data quality measurement and validation tools

Worked in user support for desktop PC users

Delivered award-winning improvements to month-end billing systems by elimination of outdated tools and developing new billing department/database interface system

Performed updates to commercial websites as an independent contractor

Professional Skills

Programming languages and tools: Microsoft Office Suite (Access, Word, Excel, PowerPoint), SQL, Visual Basic for MS Applications, PHP, HTML, COBOL, dBASE III+, Clipper, Magnum

OS Environments: Windows, IBM Mainframe, Linux.

Employment History

Medical Environmental Technologies, LLC, El Cajon, CA

Medical Waste & Document Destruction Delivery/Pickup Driver 04/2022 – 11/2022

Serviced medical waste and document destruction customers in the service areas of Chico, the Sacramento metropolitan area, Woodland, Yuba City, Stockton, Vacaville, Fairfield, and numerous East Bay cities.

Performed data entry of customer waste quantity pickup information into a web application to generate customer invoices.

Corelogic Inc./First American Real Estate Solutions, Sacramento/Rancho Cordova, CA

Data Quality Analyst / ETL Specialist 04/2006 – 06/2019

Performed lead data quality analyst role for electronic file transaction data conversion project for two years. Provided feedback to other onshore and offshore ETL analysts to correct data errors.

Designed feedback mechanism (using MS Excel spreadsheets) and MS Access tools as part of lead data quality role. Documented method for scoring data quality of Electronic File Xfer data, which was provided to offshore teams.

Designed and built MS Access routines and tables for parsing and organizing historical legal name data for use in verification of current legal name data.

Analyzed requirements docs for in-house ETL software and created test data for updated applications prior to installation.

Became proficient in the use of the in-house developed ETL tools based on MySQL and Java technology.

Prepared documentation for processing of multiple counties using the same data file organizations and layouts for use by offshore analysts using in-house ETL systems.

Designed and modified data transformation jobs and “ad hoc” subroutines running under the control of IBM’s Ascential DataStage product. Converted essential routines for use in in-house software as DataStage was being phased out.

Independent Contractor, Various web sites

Programmer Analyst 11/2006 – 5/2014

Created successive versions of tournament scoring and reporting pages for a Folsom, CA bass fishing tournament club’s website (manually created web pages, a PHP-Nuke CMS), which was later converted into a multiple-menu WordPress plugin using a modified WP MySQL database of my design as part of the implementation.

Enhanced other pre-existing LAMP commercial websites, incorporating new database and administrative functionality to simplify site maintenance.

Re/Max "A" Team Network Admin/Independent Contractor, Riverside, CA (telecommuter position)

LAN Technical Support Specialist 01/2005 – 04/2006

Installed and upgraded various browser, email, anti-virus, anti-spyware, instant messaging and office productivity packages on office servers and employee workstations of the "A" Team in Riverside, California Re/Max offices (2 locations) via remote PC access software.

Debugged and removed infected software from employee workstations with aid of various debugging utilities; administered regular backups of Re/Max office client database files on company file server.

Performed LAN administration tasks, such as setting up new workstation user IDs on the LAN and adding new IDs to the Microsoft Exchange (email) and local ICQ servers.

Other Relevant Experience

West Teleservices, Independent Contractor, Omaha, NE (telecommuter position)

Inbound Sales Representative

Argonaut Insurance, Menlo Park, CA

Technical Specialist

Platinum Technology, Inc, Menlo Park, CA

Contract Programmer/Analyst

MCI, Rancho Cordova, CA

Senior Technical Specialist

McDonnell-Douglas / BT North America / MCI, San Jose, CA

Senior Technical Specialist

Tandy Corporation (Radio Shack), San Jose, CA

Computer Marketing Representative

Tymshare, Inc., Cupertino, CA

Programmer/Analyst

Education

Heald College, Roseville, CA - completed Cisco Networking Academy CCNA classes 1 through 4, in anticipation of obtaining a CCNA (Cisco Certified Network Associate) certification, and Microsoft MCSE certification preparation courses.

Oracle Training Center, Roseville, CA - PL/SQL classes.

Onsite Oracle Training, Menlo Park, CA - Developer 2000 Forms Build class.

West Valley College, Saratoga, CA – Accounting, Computer Science courses

Self-taught: Microsoft Visual Basic, MS Excel, MS Access, MySQL, SQL for MS Access, PHP, Javascript, Linux, HTML, and WordPress Plugin coding techniques.

Contact this candidate