Real Estate Sql Server
Resume:
MARK T. LEWIS
Madison Heights MI 48071 *******@************.***
SUMMARY
A dedicated computer and database programmer/analyst with extensive experience. Excellent at solving problems and making improvements to existing computer programs and databases.
Technical Skills
Databases: PostgreSQL, Microsoft Access, Microsoft SQL Server,
Languages: Visual Basic .NET (VB.NET), Visual Basic 6 (VB6) Prime Information (PICK) BASIC
Operating Systems: Windows, UNIX
PROFESSIONAL EXPERIENCE
Remine, Vienna VA June 2017 – January 2025
Database Programmer/Analyst
Program in a Visual Studio Visual Basic environment updating SQL Server, PostgreSQL and Microsoft Access databases.
Create programs to update data from delimited and fixed width formats exported from Counties and municipalities to update standard database export tables.
Programs load value, tax, and land information like addresses, owner names, legal descriptions and property classes.
Load programs are from MI, IL, & TX counties.
CORELOGIC, Southfield MI (Corporate Headquarters - Irvine, CA) 1994 – December 2016
(Through a series of acquisitions, mergers and a spinoff the entities I have worked for since 1994 were known as Amerestate, Transamerica Intellitech and First American Real Estate Solutions)
DATA SYSTEMS TECH CONSULTANT (Previous titles: Senior Programmer Analyst, Programmer Analyst II)
Maintained, enhanced and used Visual Basic programs and processes that normalized real estate data received in many file formats into a standard Microsoft Access database structure. Verified normalized data for data quality. Trained CoreLogic staff to use the normalization programs.
Developed programs and databases to normalize raw real estate data received from MI counties/municipalities to a standard database format.
Automated the Michigan county data loading and delivery processes, resulting in a major reduction of time and effort needed to process a county. All of the 83 counties in Michigan were processed.
Improved and maintained a Microsoft Access database application that loaded raw New Hampshire real estate data received in many file formats into a standard database format.
Developed a laptop data recording system that included a laptop application program to record real estate data and a posting application program to load the recorded data into the main storage database.
Created utility programs to extract data out of text reports and load the data into Microsoft Access databases.
Created computer programs to load raw real estate data from counties/municipalities into a CD database application product database structure.
Converted and merged the data from a Prime Information real estate database system into a Microsoft Access real estate database system.
Used an ETL system written by CoreLogic to load MI normalized data into production databases.
Received the Kennedy Excellence Award (KEA) in June 2014 which is an internal CoreLogic award for contributions to the company.
EDUCATION
M.S., Computer Science and Engineering, Oakland University, Rochester, MI, Rochester, MI, 1997
B.S., Electrical Engineering, Wayne State University, Detroit, MI, Detroit, MI, 1986
Associate of Applied Science, Data Processing, Oakland Community College, Farmington Hills, MI, Farmington Hills, MI, 1987
Contact this candidate