Mark J. Heimstaedt, MCTS
Professional Realtor at Keller Williams Real Estate- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Mark was brought into a very complex project as a Data Analyst with several others. He shortly separated from the crowd as the go to SQL developer, building a great infrastructure and working with others to build off of what he created with success. I can't say enough about his contribution to a very challenging situation. I would recommend Mark anytime!
Even though Mark and I did not work directly on the same projects together, we were both in the same I.T. department. When I had a question or an immediate need for programming, he was always there and willing to help out any way he could. Mark was very detail oriented and could always be counted on to "get the job done". He was very professional and would be a great asset to any employer.
Mark was brought into a very complex project as a Data Analyst with several others. He shortly separated from the crowd as the go to SQL developer, building a great infrastructure and working with others to build off of what he created with success. I can't say enough about his contribution to a very challenging situation. I would recommend Mark anytime!
Even though Mark and I did not work directly on the same projects together, we were both in the same I.T. department. When I had a question or an immediate need for programming, he was always there and willing to help out any way he could. Mark was very detail oriented and could always be counted on to "get the job done". He was very professional and would be a great asset to any employer.
Mark was brought into a very complex project as a Data Analyst with several others. He shortly separated from the crowd as the go to SQL developer, building a great infrastructure and working with others to build off of what he created with success. I can't say enough about his contribution to a very challenging situation. I would recommend Mark anytime!
Even though Mark and I did not work directly on the same projects together, we were both in the same I.T. department. When I had a question or an immediate need for programming, he was always there and willing to help out any way he could. Mark was very detail oriented and could always be counted on to "get the job done". He was very professional and would be a great asset to any employer.
Mark was brought into a very complex project as a Data Analyst with several others. He shortly separated from the crowd as the go to SQL developer, building a great infrastructure and working with others to build off of what he created with success. I can't say enough about his contribution to a very challenging situation. I would recommend Mark anytime!
Even though Mark and I did not work directly on the same projects together, we were both in the same I.T. department. When I had a question or an immediate need for programming, he was always there and willing to help out any way he could. Mark was very detail oriented and could always be counted on to "get the job done". He was very professional and would be a great asset to any employer.
Credentials
-
MCTS : SQL Server 2008, Database Development.
MicrosoftDec, 2011- Oct, 2024 -
Texas real estate sales agent
TRECJun, 2019- Oct, 2024
Experience
-
Keller Williams Real Estate
-
Real Estate
-
300 - 400 Employee
-
Professional Realtor
-
2019 - Present
CEO, CTO, & founder, Jon Morton Properties. Exhaustive ongoing market investigations & consultations for buyers, sellers, renters, landlords, investors, ... potential & current.Expert negotiations. Allied vendor referrals. Residential land, realty, leases, investing, income properties, around greater Houston & the Hill Country. CEO, CTO, & founder, Jon Morton Properties. Exhaustive ongoing market investigations & consultations for buyers, sellers, renters, landlords, investors, ... potential & current.Expert negotiations. Allied vendor referrals. Residential land, realty, leases, investing, income properties, around greater Houston & the Hill Country.
-
-
-
-
Director of Database Architecture
-
2015 - Present
Data mart / Database architecture design & development for this orthopedic surgical clinic & biomedical engineering R&D firm. Develop clinical billing & collections data marts & Data Quality routines for department analytics. These department analytics exposed $300,000 / year in unbilled charges & unnecessary vendor fees. Develop KPI dashboards designs for marketing, finance, billing, & collections departments. EHR – clinical systems integration. Clinical DSS / Medical Expert Systems database development. Microsoft SQL Server 2008r2, 2012, 2014. NextGen 5.8. Provations. Oracle. MySql. VMware. Linux.
-
-
-
-
Sr Business Manager - REMOTE
-
2011 - Present
Investigation & project management for biomedical engineering & medical device manufacturing venture. Evaluated six SQL2008-based DB systems for medical diagnostics and for biomedical engineering ERP. Researched & prepared N.I.H. Small Business Innovation Research grant application for surgical devices. Developed S.B.A.-compliant business process analysis & plans for medical engineering labs. Researched & established telepresence solution to connect Houston & Hermosillo engineering labs. Using SQL2008, created presentation to Kenya Medical Minister for healthcare training pilot programs.
-
-
-
Epiq
-
United States
-
Law Practice
-
700 & Above Employee
-
Data Analyst / Lead SQL Developer
-
2013 - 2015
Led team, set best practices, & developed SQL2012 & SQL2008 SP-based client data & middleware conversion projects, for a global data services firm focused on complex legal claims administration. * Analyzed 500+ custom legacy ETL programs that were stream-driven & implemented with row-based logic. * Developed DB framework & solutions to replace these, using Microsoft technologies & with set-based logic, thus saving $870,000 / year in software fees. * Led 6 junior to midlevel SQL developers in solutions construction. * Performed performance and query optimization on RAM-constrained servers.
-
-
-
-
Sr. Systems Analyst (contract) - REMOTE
-
Oct 2012 - Dec 2014
Analysis, investigation, consultation, & development for defense contractor & aviation equipment manufacturer. Developed costing systems to accommodate integrated outside operations.Developed enterprise-level purchasing reporting system for Federal SBA eSRS reporting systems. Developed SBA vendor contract qualification system to feed biannual SSR & ISR eSRS reporting requirements. Customized company's Inventory, Lot & Location, Shipping, Receiving, Mfg., SFC, United Way Pledge & Volunteer systems. DB2SQL, IBM System i, RPG, Infor ERP XA R9, Infinium, Enterprise Integrator.
-
-
-
-
Aplcns Devt Project Leader
-
2006 - 2010
DB & Datamart development at engineering firm, via Microsoft SQL Server 2008.Maintain & enhance Infor XA (Mapics) ERP software. SQL2008, SQL2005, IIS, SSIS, SSRS, BIDS.IBM System i, SQL, Infor ERP XA, RPG, ACOM. DB & Datamart development at engineering firm, via Microsoft SQL Server 2008.Maintain & enhance Infor XA (Mapics) ERP software. SQL2008, SQL2005, IIS, SSIS, SSRS, BIDS.IBM System i, SQL, Infor ERP XA, RPG, ACOM.
-
-
-
Braxton-Reed
-
Software Development
-
1 - 100 Employee
-
SQL Data Analyst & Developer
-
2005 - 2006
SOX-compliant contract consulting, data analysis, & applications support for client firms. Diagnosed & customized EDI data & middleware, saving the client from large non-compliance fines. Troubleshot & enhanced ERP software & databases & maintained their interfaces. SQL, IBM iSeries, Inovis TrustedLink EDI, Movex(Lawson), Infor XA, Infinium, RPG/400. SOX-compliant contract consulting, data analysis, & applications support for client firms. Diagnosed & customized EDI data & middleware, saving the client from large non-compliance fines. Troubleshot & enhanced ERP software & databases & maintained their interfaces. SQL, IBM iSeries, Inovis TrustedLink EDI, Movex(Lawson), Infor XA, Infinium, RPG/400.
-
-
-
-
Programmer Analyst
-
2001 - 2005
Designed Imrex to IBS-ASW database conversion for this home décor manufacturer /wholesaler. Developed database interfaces between ASW and legacy systems. Automated trade show data collection, greatly reducing order process time & cost.Created EDI customer interface applications, to avoid EDI chargeback costs. Analyzed, designed, & converted commission, A/R, G/L, & invoice systems. SQL, iSeries, TrustedLink, IBS-ASW, SSI, Zebra Technologies, RPG/400/ILE, ACOM Designed Imrex to IBS-ASW database conversion for this home décor manufacturer /wholesaler. Developed database interfaces between ASW and legacy systems. Automated trade show data collection, greatly reducing order process time & cost.Created EDI customer interface applications, to avoid EDI chargeback costs. Analyzed, designed, & converted commission, A/R, G/L, & invoice systems. SQL, iSeries, TrustedLink, IBS-ASW, SSI, Zebra Technologies, RPG/400/ILE, ACOM
-
-
Education
-
-
Arizona State University
MBA, business administration -
-
University of Illinois at Chicago
BS, Math, Computer Science -
-
Loyola University Chicago
-
-
College of DuPage
Pharmacy Technician/Assistant -
-
Northwestern University
Mathematics
Community
