Mark Brandon Email & Phone Number

St Louis, Missouri, Us

Develop Visual Dashboards utilizing Tableau and Teradata to track, analyze and display key data metrics at the Line of Business and Enterprise level.Accurately maintain, update and provide monthly Executive reports to management and business partners.Design, develop and deploy ad-hoc and recurring reports by sourcing data from various databases utilizing sql and business intelligence tools to meet business partners needs across various lines of business.Gather business requirements; develop and maintain business required documents and procedures.Perform quality control and testing on various projects and reporting initiatives to ensure data quality measurements.

San Francisco, California, Us

-Lead meetings with key stakeholders across different lines of business and documented process requirements for all Risk and Regulatory reports; developed and provided key insights in PowerPoint presentations for the conversion team to mitigate data gaps during system migration. -Performed data analysis and developed Tableau and Excel reporting dashboards for status updates and presentations.-Designed and provided (Visio) system and data lineage flow charts for IT conversion team, key stakeholders and senior management.

Charlotte, Nc, Us

-Designed data models, data mapping, use cases, process flows, specifications, diagrams and charts to provide direction to developers, designers, and vendors.-Provided clear communications to multiple groups including business partners and technical teams to support efficient development.-Created technical documents and manuals relating to application development.-Maintained and updated tasks, goals and milestones and provided weekly progress summary reports to key stakeholders. -Created and modified issues in JIRA.

Charlotte, North Carolina, Us

-Effectively collaborated with data stewards and data architects in gathering, researching and maintaining business terms for the enterprise data dictionary repository.--Evaluated large data sets; identified, compared, and resolved data quality issues.-Provided expertise in business and data analysis to drive data governance change where necessary.-Created visually impactful dashboards in Tableau and Excel; facilitated key metrics with management and business partners.-Developed SQL queries utilizing SQL server to extract data; perform data analysis and created informative dashboards for key stakeholders and management.

Charlotte, Nc, Us

-Collaborated with business stakeholders to develop and document policies and procedures surrounding Data Governance.-Served as a liaison between business departments and within the IT organization to offer technical solutions to automate applications contributing to savings and increased efficiencies.-Provided support of system applications, including making enhancements, performing upgrades and resolving coding issues.-Maintained and enhanced the risk modeling application tool utilized to aggregate and document the assessment of client portfolio performances, risk rating accuracies and overall credit process effectiveness during Credit Review examinations and monitoring reviews.

-Performed oversight of loss mitigation loan modification data serviced by third party vendors, ensuring accurate data quality measurements; properly mapped fields, transformed and uploaded data to the internal system of record.-Developed and implemented an automated expense management system utilizing MS Access that monitored and tracked third party vendor expenses; produced automated exception reports that identified over $3.1M in overpaid expenses for the company.-Managed data extraction, transformation and load( ETL) process from various sources; streamlined manual processes and increased productivity.