Implementation Consultant
Overview: Developed and deployed COTS application to manage DC Property Taxes while working in house with clients. As part of conversion team, determined best way to convert all data to modern web platform.• Utilized a mix of SQL scripts, proprietary VB.NET codebases and configuration changes in our web platform in order to facilitate conversion.o Alongside development, performed weekend data conversions and weekly meetings with clients to show them these mock ups and gather/implement… Show more Overview: Developed and deployed COTS application to manage DC Property Taxes while working in house with clients. As part of conversion team, determined best way to convert all data to modern web platform.• Utilized a mix of SQL scripts, proprietary VB.NET codebases and configuration changes in our web platform in order to facilitate conversion.o Alongside development, performed weekend data conversions and weekly meetings with clients to show them these mock ups and gather/implement feedback. With this feedback we were able to achieve a sub 1% error rate for all tax information converted. • Solely in charge of creating process for converting all non-operational data from legacy DBMS systems (like FoxPro) to a modern solution (DB2) and developing reports with this datao Process steps included figuring out how to copy billions of rows of data, developing SQL cursors to fix poorly formatted legacy data, and optimizing the process to ensure it stayed on our aggressive rollout schedule. Show less