Business Data Analyst – Mortgage Insurance Claims
Coppell, Tx
• Developed and maintained MS Access database with click button Dashboard for daily, weekly, monthly, and quarterly management reports• ODBC setup to various sources including Oracle 10g, 11i, and MS SQL Server for use with MS Access to collect, compile, and analyze data for adhoc reporting. Very basic SQL knowledge with limited Oracle SQL Developer and TOAD exposure• Lead analyst for mapping codes and translation of dataset at cell level from LPS to RealServe and from FiServe to RealServe software platforms• Functioned as an Individual Contributor to the team, but with daily team interaction• Daily communication with offshore teams via teleconferences, GoToMeeting, individual calls and emails• Department go-to person for questions and issues related to platform changes and OS upgrades, Citrix profile migration, and network migration• Collaborated with 3rd party software development team for UAT beta testing software deployments• Documented new and streamlined processes using Standard Operating Procedure (SOP) guidelines, training associates as required