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.

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.

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