Bryan Byers Email & Phone Number

Charlotte, NC, US

Detroit, MI, US

Charlotte, NC, US

Contract Data Analyst supporting Anti-Money Laundering (AML) within the Global Financial Crimes Technology group. Working within and Agile team using a JIRA Kanban board to manage tasks. Analyzing data on multiple database platforms including: Teradata, Hadoop and Oracle. Create metadata documentation capturing business element code values, data lineage.

Stamford, Connecticut, US

Performed as a contract hybrid data analyst and business analyst within supply chain management. Worked within and Agile team using a JIRA Kanban board to manage tasks. I utilized SQL within a SQL Server environment with SSRS reporting for business partners. Collected business requirements from partners regarding data sourcing or data reporting. Modified.

Charlotte, NC, US

Worked in a Wholesale regulatory reporting data group supporting 14Q and IFRS-9 reporting. Collaborated with regulatory reporting stakeholders to understand their requirements to remediate data gaps for 14Q and IFRS-9 reporting. I utilized my SQL skills daily to analyze data available in approved data sources.

San Francisco, California, US

Business Analyst supporting the LUCAS wholesale loan servicing platform utilizing SQL Server for data management.

Contract Data Analyst within the Balance Sheet and Capital Management Technology group. Worked within an Agile methodology team to convert a regulatory reporting database from Teradata to Netezza utilizing Informatica for ETL. Utilized SQL and Informatica skills to perform analysis and reverse engineer existing ETL and reporting SQL to create requirements.

Worked as a contract Business Analyst within the Mortgage Technology group. Analyzed business requirements for configuring a vendor based loan origination system to meet TRID requirements.

Charlotte, North Carolina, US

• Customer Web Technology - Retail Programs
• Worked with business partners to prioritize their requirements for enhancements to the public and authenticated areas of Duke-Energy.com.
• Authored business requirements to be used by the development team for estimates and technical designs.
• Supported product development for residential energy efficiency programs by developing business cases to show financial viability.
• Created Requests for Proposal (RFP) to inform prospective vendors about the business and technical needs of a new or existing program.
• Managed vendor development of tools to be used in the public website.

Charlotte, NC, US

• Enterprise Credit Risk Technology (ECRIS/BASEL) – Hadoop and Teradata Warehouses
• Managed two Agile SDLC Scrum Masters that led the development efforts for the conversion of the existing Teradata warehouse to the new Hadoop data warehouse.
• Managed two Waterfall SDLC Project Managers who led the development efforts for the existing Teradata warehouse.
• Worked with the Credit Risk business partners to prioritize funded initiatives and changing regulatory requirements for the consumer credit risk data warehouse.
• Provided weekly status report presentations to executive management and business partners.
• Utilized JIRA for story management and burn down reporting.

Charlotte, NC, US

• Corporate Investment Technology – Corporate Investment Data Warehouse (CIDW) – Oracle
• Created detailed Business Requirement Documents and JIRA Stories for new requests.
• Worked directly with the developers to create data mapping and lineage spreadsheets for the Extract/Transform/Load (ETL) logic in Informatica Power Designer.
• Assisted with the writing and execution of test scripts utilizing Oracle SQL scripts for Quality Assurance testing in the Systems Integration Testing (SIT) and production environments.
• Tracked and reported development and testing status to management, business users and other impacted teams.
• Coordinated User Acceptance Testing (UAT) and provide SQL scripts and test data for business users to review data quickly and provide signoff.

Charlotte, NC, US

• Corporate Investment Technology – Mortgage Data Mart (MDM) - Oracle
• Worked with business partners to write the Business Requirements Document (BRD) and High Level Design (HLD) document for building a new Mortgage Data Mart after the Countrywide acquisition to replace the data mart I.
• Created the Low Level Design (LLD) document to capture source to target mapping, transformation logic and business descriptions for 135 target tables and over 6,000 fields to be built in the new data mart. This.
• Worked directly with the developers to create data mapping and lineage spreadsheets for the Extract/Transform/Load (ETL) logic in Informatica Power Designer.
• Tracked and reported development and testing status to management, business users and other impacted teams.
• Assisted with the writing and execution of test scripts utilizing Oracle SQL scripts for Quality Assurance testing in the Systems Integration Testing and production environments.

Charlotte, NC, US

• Enterprise Credit Risk Information System (ECRIS/BASEL) - Teradata
• Led the Software Development Life Cycle for monthly system releases on a Teradata database to insure requirements, development, testing and Change Advisory Board approval was completed on time. This included.
• Managed numerous data sources within the ECRIS platform supporting Retail BASEL reporting. This included Mortgage loans and Home Equity Lines of Credit, Commercial Loans, International and Domestic Credit Cards.
• Utilized HP Quality Center to lead the defect management process to correct over 400 defects in 12 months to prepare for BASEL parallel testing.

Charlotte, NC, US

• Corporate Investment Technology – Mortgage Data Mart (MDM) - Oracle
• Authored the Business Requirements Document and High Level Design document for the Mortgage Data Mart (MDM) database.
• Created the Low-Level Design document to capture source to target mapping, transformation logic, and business descriptions for over 800 fields to be built in the new data mart.
• Worked directly with the developers to create Extract/Transform/Load (ETL) logic in Informatica PowerCenter Designer.
• Used SQL query tools to perform research and compare data from the Mortgage Servicing Platform (MSP), SBO application, the “W” and WLM data warehouses.
• Reported development and testing status to management, users and other teams.

• Managed enhancement projects and maintenance releases for the HSBC Mortgage Services web site.
• Employed Risk Based Project Management tools to communicate business and functional requirements to the technology services and web design group.
• Utilized Mercury Test Director to manage test scripts and report defects during website Quality Assurance testing.
• Performed User Acceptance Testing (UAT) for system upgrades to the vendor provided mortgage servicing platform, Mortgage Serv.
• Collaborated with Product Managers and Directors from other lines of business to enhance the external customer experience and reduce the cost to service.

Charlotte, NC, US

• Managed projects and daily operations of the Bank of America mortgage servicing website. The site was hosted by a vendor and serviced over 600,000 retail mortgage customers.
• Worked with the cross sales and retention team to promote the site and retain current mortgage customers.
• Created monthly site usage reports for business stakeholders.
• Managed enhancements and daily operation for MSP Passport and Scorecard, two web-based mortgage servicing reporting tools. Provided support and training coordination for 150 internal Passport and Scorecard users.
• Utilized Microsoft Access, Microsoft Excel, Oracle Discoverer, Visual Basic, SQL and Fidelity Information Services Passport to generate monthly and ad-hoc reports for financial analysts in Consumer Real Estate.
• Accomplishments: Updated the servicing website site to be in compliance with the Americans with Disabilities Act (ADA) for website accessibility; implemented a new user interface; provided a duplicate tax form 1098 via.