Margus Lehiste

Experience

• 

  CorrectNet, Hauppauge

  Jun 2003 - Dec 2003

  Projects

  • CorrectNet: Financial reports from Excel, PDF, TXT, and DBs using XML, XSLT, XPATH, JS, CSS, and XDB Infipoint. • Manhattan Community Center: Razor’s Edge DB data entry & accounting reports in Excel. • Hearts and Minds: Website development & fixing various computer and network problems.

• 

  MicroPower Computer Institute

  Jan 2004 - Nov 2005

  Instructor / .Net Programmer

  • Instructor: Oracle DBA, Web / SQL Developer, MS Office & Access, MCSD.net, E-commerce, C++, CCNA.• VB6 to .Net upgrade of company intranet applications, billing & invoice system setup for government grants.

• 

  US Condo Exchange LLC (Condo.com, Houses.com, Property.com)

  Mar 2006 - Jun 2016

  Lead Programmer

  • Search: Development Team Leader for the project which queried over 3 million records average of under 0.2 seconds and helped to increase traffic/leads over 20 times. Designed a spatial database for every US city, state, zip, neighborhood on the map & all major international cities; GIS geocode mapping and matching properties. • Content Management & Reporting: Created Lead Management system that allows forward leads to broker emails, partner websites, web services, or their custom solutions. Created over 30 reports in ASP.net and in SQL Server Reporting Services in various areas including Revenue, Leads, Billing/Transactions, Users, Feeds, and Listings; Market Data report – aggregates listing and sales data for locations & shows trends on a chart. • Data Aggregation: SQL Server Integration Services packages/jobs to import over 500,000 properties (3 million+ images) valued over $150 billion daily. Daily maintenance & reporting of 23 MLS and 20 partner import packages. Different formats (XML, text-based, Excel, Zip files, RETS – mls real estate format, HTTP scraping) and different secured methods (FTP download/ upload, HTTP with certificates, Web services). • Syndications: Programs to export Condo.com listings to major domestic and international partners in various formats (XML, text, Custom; FTP, HTTP, Web service) – over 30 different websites served by Condo.com. • Custom data import/cleaning & reporting solution: ETL import from major Miami newspapers. Show less

• 

  EU-Supply Holding AB

  Jul 2016 - Jun 2017

  ETL BI Developer / C# Programmer

  • Business contracts ETL integrations for the new markets & solving complex problems (chunked transfers).• Agile Development & DevOps for EU-Supply the leading supplier in CTM Complete Tender Management Systems.

• 

  Condo.com

  Jul 2017 - now

  Database Administrator / ETL BI Developer

  • Implemented standardized deployment procedures, optimizing processes and boosting platform reliability by advocating for the adoption of CI/CD and automated workflows.• Attained a sub-10-minute ingestion latency (Postgres->Elasticsearch) by offloading more processing-intense ETL to separate AWS infrastructure, a 10x increase in capability for a similar cost.• Ensured consistent data replication and integrity by implementing robust automated synchronization mechanisms, conducting regular data quality audits, and developing failover protocols to guarantee uninterrupted data availability. Show less