Experience

ServiceMac, LLC

• United States
• Financial Services
• 200 - 300 Employee

• Data Reporting Analyst

  • Jul 2022 - Present

  WFH



Homepoint

• United States
• Financial Services
• 700 & Above Employee

• Senior Default Reconciliation Specialist.

  • Feb 2021 - Present



Health Care Service Corporation

• United States
• Hospitals and Health Care
• 700 & Above Employee

• Technical Reportin Analyst II

  • Mar 2019 - Feb 2021

  Responsible for participating in business analysis activities to gather requirements AND translating requirements into specifications that will be used to implement the required solution; developing single source data and reporting solutions; defining and executing test scenarios / cases; providing triage support for production issues or change requests to include root cause analysis and proposed resolution; under supervision, implementing production-ready solutions.



TEKsystems

• United States
• IT Services and IT Consulting
• 700 & Above Employee

• IT Security Reporting Specialist

  • Nov 2017 - Nov 2018

  Irving, Texas Provide high-level support to management in Global Technology and Operations department at Bank of America identifying third-party applications and making sure the user right grants match that of the centralized database. Responsibilities include pulling data from tableau, SQL and DB2 and using tools such as excel and access to manipulate data into a usable form. Then we use the data to extrapolate the story that the data tells us and provide the guidance to the administrators in how to correct… Show more Provide high-level support to management in Global Technology and Operations department at Bank of America identifying third-party applications and making sure the user right grants match that of the centralized database. Responsibilities include pulling data from tableau, SQL and DB2 and using tools such as excel and access to manipulate data into a usable form. Then we use the data to extrapolate the story that the data tells us and provide the guidance to the administrators in how to correct the user’s rights in the third-party application so that it matches that of the centralized database. Responsible for data integrity in cycle end reporting, spending time verifying data from SharePoint to excel was correctly entered and correcting where possible.  Part of teams that would reconcile thousands of third-party application users’ rights  Created SQL quires to pull User rights from DB2 and verify against the provided data from the application manager.  Created all the reporting for each reporting period to monitor gains in improved Risk  Created SQL queries to verify data entry into excel spreadsheet that uploaded into DB2  Verified Data Quality of reporting to vendors via their submission  Created exception reports to verify missing data or uncompleted forms and disbursed to team daily to be worked.  Created dashboards in Tableau and automated reports. Show less



TEKsystems

• United States
• IT Services and IT Consulting
• 700 & Above Employee

• External Reporting Analyst

  • Sep 2016 - Sep 2017

  Lewisville Texas Provide high-level support to project management in chase finance department, identifying business cases for projects and verifying scoping. Responsible for requirements gathering, data analysis (30,000+rows in MS Excel via VLOOKUPs and Macros), results validation, and documentation update. Provided recommendation to senior-level management. Responsible as the last line of validation so all reports were to be verified before the Go/No GO meetings were produced.  Part of remediation… Show more Provide high-level support to project management in chase finance department, identifying business cases for projects and verifying scoping. Responsible for requirements gathering, data analysis (30,000+rows in MS Excel via VLOOKUPs and Macros), results validation, and documentation update. Provided recommendation to senior-level management. Responsible as the last line of validation so all reports were to be verified before the Go/No GO meetings were produced.  Part of remediation teams that would remediate millions of dollars depending on case  Team point of contact for all remediation, consolidated and tracked cases using the JIRA tracking system.  Create SQL codes and verify the validity of data and that it represented the data requested in the BRD before the go/no go meeting. We were the last line of validation.  Responsible for the data integrity of the report, vetting data results via the expected retunes. Show less



Fannie Mae

• United States
• Financial Services
• 700 & Above Employee

• Business Analyst II−Credit

  • Jan 2014 - Sep 2016

  Dallas Texas Interfaced with key stakeholders to automate reporting processes for evictions and redemption / confirmation processes in credit and loss mitigation department. Analyzed large sets of data of over 30,000 records, created and managed monthly scorecards for outsourced vendors over 15 different vendors, and completed regular quality assurance reports. Responsible to pull data from SQL to Excel and then verify the data pulled correctly and make corrections where possible. Pulling data in Business… Show more Interfaced with key stakeholders to automate reporting processes for evictions and redemption / confirmation processes in credit and loss mitigation department. Analyzed large sets of data of over 30,000 records, created and managed monthly scorecards for outsourced vendors over 15 different vendors, and completed regular quality assurance reports. Responsible to pull data from SQL to Excel and then verify the data pulled correctly and make corrections where possible. Pulling data in Business Objects and TOAD. Building Dashboards in Tableau to automate and visualize reporting.  Identified and set exception and ad-hoc workflow in reporting system to accommodate quick reaction to trending.  Created exception reporting via SQL to verify data integrity between LPS and SQL.  Created reporting to verify downloaded data from SQL to excel for scorecard reporting.  Created tableau dashboards for automated reporting and scorecard  Analyzed, updated, researched and resolved complex issues while maintaining the Vendor Scorecard Database.  Analyzed the data for discrepancies and corrected where possible Show less



Bank of America

• United States
• Banking
• 700 & Above Employee

• Business Support Manager

  • Aug 2010 - Jan 2014

  Plano Texas  Responsible for team of 10 analysts spread throughout multiple time zones.  We created real-time adhoc reporting via SQL Server per business specifications.  Responsible meeting with business to discuss reporting needs and to then address them by creating high level over view reports.  Responsible for making sure all reports are sent to the business timely and correct.  Created and maintained and delivered the FNMA/FHLMC foreclosure reports that are sent directly to the… Show more  Responsible for team of 10 analysts spread throughout multiple time zones.  We created real-time adhoc reporting via SQL Server per business specifications.  Responsible meeting with business to discuss reporting needs and to then address them by creating high level over view reports.  Responsible for making sure all reports are sent to the business timely and correct.  Created and maintained and delivered the FNMA/FHLMC foreclosure reports that are sent directly to the corresponding government agency.  Created a dynamic reporting database that held every report and all details pertaining to said reports.  Helped bring the LPS platform to Bank of America and helped create reports using LPS data dumps to our SQL Server.

• Servicing Team Manager - Pre Sale Foreclosure

  • Jul 2008 - Aug 2010

  Plano Tx Led geographically dispersed, 10-member, analysis team, supporting home loan division of the company. Monitored portfolio of reports in line with projects, deadlines, and business requirements and expectations. Responsible for ETL of data from nightly LPS drops to SQL for all of default servicing. Then comparing the uploaded LPS data to that in AS400 and correcting AS400 to match that of the LPS download so that both Systems using A400 macros so that they mirrored each other daily.  Created… Show more Led geographically dispersed, 10-member, analysis team, supporting home loan division of the company. Monitored portfolio of reports in line with projects, deadlines, and business requirements and expectations. Responsible for ETL of data from nightly LPS drops to SQL for all of default servicing. Then comparing the uploaded LPS data to that in AS400 and correcting AS400 to match that of the LPS download so that both Systems using A400 macros so that they mirrored each other daily.  Created several improvements and enhancements to reporting systems, including real-time ad hoc reporting via SQL Server, FNMA/FHLMC default and REO reports delivered directly to government agency, and dynamic reporting database for accurate storage and data sharing.  Create daily table from LPS extract to use to verify the validity of the data from LPS to AS400.  Created a suite of reports to verify the integrity of data that was uploaded nightly from LPS to AS400.



Countrywide Mortgage Services

• United Kingdom
• Financial Services
• 300 - 400 Employee

• Business Analyst REO Servicing

  • Nov 2005 - Jul 2008

  Plano Tx  Responsible providing data and report for monthly QA books.  Responsible for Reporting information regarding division matrixes  Used SQL Server to retrieve data for outside compliance reports.  Responsible for running and creating numerous adhoc reports.

• Bankruptcy Asst Team Leader

  • Feb 2003 - Nov 2005

  Plano Tx  Interviewed, hired and managed a team of 10 to 12 members.  Monitored my team for compliance.  Completed the Team Leader Certification Program.  Created several Access database reports to help drive day to day business.

• CFC Foreclosure Specialist

  • Feb 2000 - Feb 2003