# Mitchell Vanbeekum > Software Engineer at Canfield Scientific Location: Hopatcong, New Jersey, United States Profile: https://flows.cv/mitchellvanbeekum IT professional with 20+ years of extensive experience as a SQL Server Developer. Demonstrated expertise in designing, developing and deploying ETL solutions using SSIS. Dedicated to building customized technical solutions in alignment with operational needs and objectives. Critical thinker, analyst and problem solver known for continuous delivery of quality products across diverse business environments. ## Work Experience ### Software Engineer @ Canfield Scientific Jan 2023 – Present | United States ### Database Developer II @ Weichert, Realtors Jan 2007 – Jan 2023 | New Jersey, United States Database Developer II • Design, maintenance, ETL and normalization of data imported into SQL databases from 200+ real estate MLS data feeds via API, RETS or flat file. • Creation and optimization of stored procedures and functions in standard and dynamic SQL. • Database performance enhancements - improvement of SQL performance and CPU usage by monitoring and optimizing queries, creation and defragmentation of indexes, monitoring and avoiding deadlocks, and timing of job scheduling. • Creation of custom outbound feeds for vendors and divisions of the company - providing data dumps through XML, flat file or data migration. • Creation of custom email reports and statistics. • Designed, coded and implemented solutions improving efficiency, including: ---- Hybrid publishing process for MLS listings in which inbound feeds would download and refresh data once an hour, incrementally based on modification dates providing weichert.com with new/updated data faster than our competition. ---- Image true-up solution for real estate photos to stay current on ever-changing MLS listings based on modification dates. ---- Automated mapping of real estate listing features, property types and styles to cross-reference tables using fuzzy logic. • Provision of internal and external helpdesk support. • Part of on-call rotation involving troubleshooting failing jobs after hours and on weekends. ### IT Quality Assurance Analyst (Champion Mortgage) @ KeyBank Jan 2004 – Jan 2006 | New Jersey, United States System integration / user acceptance / regression testing of business application software (loan origination system, corporate website, loan servicing, account management, interactive voice response); tracking, reporting, scheduling and documentation of multiple product releases across multiple product lines; interact with development and line of business to create & review product requirements; identify, manage, track, and follow through on issues/software bugs; management of all project related tasks including requirements, technical specifications, dependencies, and software testing; development of high level test cases; management of project portfolios, priorities and timelines by line of business across multiple initiatives; implementation of repeatable quality assurance process; ensuring project alignment to business objective; coordination of end user testing / implementation; obtaining stakeholder approvals and providing project visibility to management; providing support to helpdesk. ### Compliance / Document Management Team Leader (Champion Mortgage) @ KeyBank Jan 1998 – Jan 2004 | New Jersey, United States Management of small team providing preparation, coordination, formatting, legal language research and updates of upfront disclosures and closing documents for 32 states; design and maintenance of Microsoft Access mail-merge database; providing support to title companies & attorneys using the document application, user acceptance testing of compliance related loan origination application change managements o Achieved “Champion of the month” honor in March 2003 o Successfully helped implement, coordinate and test business rules for new loan origination platform, and document management system o Designed and maintained company intranet ## Education ### Network and System Administration/Administrator Metropolitan Technical Institute ## Contact & Social - LinkedIn: https://linkedin.com/in/mitchell-vanbeekum-167569271 --- Source: https://flows.cv/mitchellvanbeekum JSON Resume: https://flows.cv/mitchellvanbeekum/resume.json Last updated: 2026-04-13