Christopher Lee Email & Phone Number

Jacksonville, Fl, Us

• Acted as team lead for all reporting analysts. Responsibilities included training and education of new employees, subject matter expert on systems and best practices and providing reviews for new hires to management team.• Designed and created Executive Scorecard Dashboard from our data warehouse using TSQL and Crystal Reports.• Served as lead developer for all data warehouse reporting.• Worked with database team on creating new client extracts using TSQL and SSIS.• Designed… Show more • Acted as team lead for all reporting analysts. Responsibilities included training and education of new employees, subject matter expert on systems and best practices and providing reviews for new hires to management team.• Designed and created Executive Scorecard Dashboard from our data warehouse using TSQL and Crystal Reports.• Served as lead developer for all data warehouse reporting.• Worked with database team on creating new client extracts using TSQL and SSIS.• Designed and created all client dashboards available through Business Intelligence.• Worked extensively with TSQL and Crystal Reports for all senior management reporting as well as client reporting. Show less

• Created new AR reports using TSQL to be run against SQL Server 2000 and 2005 databases.• Created new reporting structure to use SSRS instead of prior implementation of MS Access reporting. This includes the conversion of all previously created access reports.• Documented all AR reporting procedures to be used in the transfer of reporting responsibilities to corporate office.• Provided AR analysis of the data provided including recommendations on whom to target for collection on… Show more • Created new AR reports using TSQL to be run against SQL Server 2000 and 2005 databases.• Created new reporting structure to use SSRS instead of prior implementation of MS Access reporting. This includes the conversion of all previously created access reports.• Documented all AR reporting procedures to be used in the transfer of reporting responsibilities to corporate office.• Provided AR analysis of the data provided including recommendations on whom to target for collection on outstanding AR.• Provided solutions and determined reasons for discrepancies between outstanding AR and billed amount for all internal and external clients. Show less

• Managed team to oversee the day to day maintenance and support for all systems and network infrastructures.• Designed, planned and managed multiple projects concurrently. This includes the assigning and overseeing of projects to direct reports as well as working with LendingTree IT staff on corporate initiatives as a project lead.• Assisted upper level management with strategic IT initiatives through recommendations, purchasing and implementation to increase corporate efficiency.•… Show more • Managed team to oversee the day to day maintenance and support for all systems and network infrastructures.• Designed, planned and managed multiple projects concurrently. This includes the assigning and overseeing of projects to direct reports as well as working with LendingTree IT staff on corporate initiatives as a project lead.• Assisted upper level management with strategic IT initiatives through recommendations, purchasing and implementation to increase corporate efficiency.• Consolidated the location of user and company data into one location to promote SOA for future applications and simplified backup and recovery.• Wrote ETL programs using SSIS to populate a new data warehouse with data that we received via secure FTP from our web-based off-site operational software. Packages would receive a text files and XML files and process them into the correct tables via bulk inserts, data transformations, and Visual Basic scripting.• Designed new SQL Server Reporting Services site to contain on demand reporting and dashboards from the warehouse created above.• Developed numerous SQL Server databases and Visual Basic.Net/BIDS applications to access information according to operational needs.• Provided Windows Server 2003 setup and administration for all users at the Jacksonville location. • Served as senior developer and administrator for our Helpdesk ticketing system for our five largest lending companies.• Served as database administrator for the SQL Server DB that housed the Magic ticketing system. Includes query writing, table and procedure development and upgrading of DB from SQL Server 2000 to 2005.• Developed training and procedural documentation for distribution to the IT team as well as operational employees Show less

• Worked with RELS-IT network administrators to perform initial setup of Window servers for the new Pittsburgh office. Upgraded initial servers from Server 2000 to Server 2003.• Teamed with lead software developers to design primary order tracking software wrote in Visual Basic.Net. • Participated in committee to help in the design of the RELS Companies new web based reporting structure using SQL Server Reporting Services.• Wrote a DTS package to populate a SQL Server 2000 DB with… Show more • Worked with RELS-IT network administrators to perform initial setup of Window servers for the new Pittsburgh office. Upgraded initial servers from Server 2000 to Server 2003.• Teamed with lead software developers to design primary order tracking software wrote in Visual Basic.Net. • Participated in committee to help in the design of the RELS Companies new web based reporting structure using SQL Server Reporting Services.• Wrote a DTS package to populate a SQL Server 2000 DB with information from our AIM operational software. Wrote multiple Visual Basic.net applications for our Policy Production and Quality Control departments that both interfaced with the same DB.• Administered all user accounts through Active Directory. Included access to mailboxes, user account security and group policy.• Implemented a backup procedure for mission critical information on server.• Improved local security of computers by limiting what properties users are allowed to edit on local machine and forcing updates down to PC via automatic updating using WSUS.• Upgraded switches to Cisco Catalyst. Rewired entire office including workstations, switches, router and server. Show less

• Worked extensively with Microsoft Access redesigning existing databases and creating new applications developed in Visual Basic. • Designed and improved Microsoft Word macros using Visual Basic for Applications to retrieve data from Access and Oracle into the final policies to be sent to the customer.• Provided NT Server Administrator duties for all NT 4 servers running service pack 5.• Managed daily backups of NT files using the software ARCSERVE.• Provided Microsoft Exchange… Show more • Worked extensively with Microsoft Access redesigning existing databases and creating new applications developed in Visual Basic. • Designed and improved Microsoft Word macros using Visual Basic for Applications to retrieve data from Access and Oracle into the final policies to be sent to the customer.• Provided NT Server Administrator duties for all NT 4 servers running service pack 5.• Managed daily backups of NT files using the software ARCSERVE.• Provided Microsoft Exchange Administrator duties for all email account including the adding and removing of accounts and account size limitations Show less

• Worked extensively with Microsoft Visual Basic and Microsoft Access developing client-server applications.• Provided Microsoft Access security architecture and administration for their employee database.• Developed a strong working knowledge of using API calls within Visual Basic programs.• Applied Collaboration Data Objects to send automated emails using Visual Basic and Microsoft Access.• Designed and developed a Visual Basic program to monitor the status of various networks… Show more • Worked extensively with Microsoft Visual Basic and Microsoft Access developing client-server applications.• Provided Microsoft Access security architecture and administration for their employee database.• Developed a strong working knowledge of using API calls within Visual Basic programs.• Applied Collaboration Data Objects to send automated emails using Visual Basic and Microsoft Access.• Designed and developed a Visual Basic program to monitor the status of various networks and send out distress pages if the networks were not functioning properly. Show less