Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Brian Johnston

Senior Business Analyst
Chatsworth,CA

Summary

Accomplished Senior Business Analyst with a proven track record at AmeriHome, enhancing company analytics through utilization of SQL, JIRA, Encompass, PowerPoint, and Excel. Demonstrated leadership in project management and team development, significantly improving data integrity and operational efficiency. Skilled in fostering collaboration and driving innovative solutions. Numerous years of experience in project collaboration, requirements gathering, testing new functionalities, interface development and product implementation.

Overview

17
17
years of professional experience
1
1
Certification

Work History

Business Data Analyst

AmeriHome Corporation
03.2023 - Current
  • Role is to utilize different platforms like SQL, JIRA, Excel, HTML, CSS and PowerPoint to generate analytics and reporting
  • Weekly tasks consist of building reports, writing queries in SQL, analyzing data, and collaborating on projects
  • Produce PowerPoint slides using graphs and bullet points which are presented by executives
  • Proficient in Microsoft Excel to create formulas, Lookups and build tables to implement project requirements
  • Used problem-solving skills to assist with complex functionalities related to my team’s tasks
  • Proven team player, I’ve used knowledge sharing to enhance the betterment of our department
  • Automate processes to enhance efficiency for the company
  • Made recommendations to management to create documentation on process flows for JIRA tickets
  • Technical and communication skills are crucial to bridge the gap in requirements between stakeholders and different interfaces like Encompass, CLEAR, Azure.

Senior Business Analyst

AmeriHome Corporation
02.2021 - 03.2023
  • Promoted to a Senior Business Analyst due to my experience, knowledge, training and passing the CCBA exam through IIBA
  • Used analytics and technical skills to design, develop, and implement changes based on the needs of the organization
  • Served as a critical part of the Underwriting Self-Employed system control development where I researched logic, efficiency, and availability of our data from various systems
  • Worked as a project manager where I run the operations to ensure tickets are completed by specific departments, recaps are sent to our Executive team and collaborate on potential gaps
  • Utilized JIRA, SQL, Encompass, and Confluence on a weekly basis to execute task completion and satisfy our stakeholder’s needs
  • Managed a team where I train them on daily tasks and projects while also offering mentorship for their growth and development to flourish
  • Used innovation to drive change related to projects being implemented on time
  • Validated accuracy of alert logic, tested business rules in UAT before production development
  • Worked with stakeholders on numerous projects like Escrow Holdback, Whitelisting Reduction, Non-QM and Buydowns
  • All of these projects involved communications skills, collaboration and building trust to complete a large workload.

Business Application Analyst

AmeriHome Corporation
10.2018 - 02.2021
  • Completed projects using in-depth analysis, research, creating logic and writing alert descriptions
  • Ticket creation, troubleshooting issues, delegation of tasks and analysis of code are daily tasks
  • Learned to interpret and translate C-sharp for predicate logic analysis to provide stakeholders a clear explanation of its purpose in LMS and Encompass
  • Utilized JIRA to build confluence pages
  • The documentation trained future team members how a task is completed, the process flow is created and overall importance to our organization
  • Project management skills are required to develop templates, which assist in delivering product updates to executives
  • Collaborated with cross-functional teams to gather requirements and design solutions
  • Conducted User Acceptance Testing (UAT) and facilitated successful system implementations
  • Agile methodology was critical in utilizing “outside of the box” thought processes, flexibility on collaboration, responding to change with a prepared strategy.

Operations Analyst

AmeriHome Corporation
11.2016 - 10.2018
  • Became a proven team player, answered an estimated 800 questions from PPR, Funding and upper management as the SME around Encompass as a new interface
  • Knowledgeable on new functionalities around Encompass implementation including how to fix DTI issues, assess alerts, run tests, and clear predicates
  • Developed an ARM guideline that was used by numerous departments including management
  • Helped implement the CLD Operations feedback form, used to improve quality with detailed feedback for reviewers on potential systemic gaps in our interfaces
  • Created numerous alerts in Encompass by providing in-depth analysis with alert name, logic and a detailed description that are used currently
  • Assisted in building forms in Encompass using innovative and creative ideas
  • Traveled to facilitate training sessions in Dallas to train employees
  • My job was to produce innovative techniques for employees to use Encompass as a new platform, build confluence pages on the material, work on my communication skills and instill process improvement.

Loan Review Analyst

AmeriHome Corporation
10.2015 - 11.2016
  • Reviewed mortgage loans for conditions required, specialized in TRID to validate loans are closed in accordance with CFPD guidelines
  • Daily workload consisted of Conventional, Non-Conventional, FHA, VA, 203K and Texas A6 loans
  • Maintained an overall monthly production of over 100%, with a deficiency rate of less than 2%
  • Ranked and acknowledged as a top 3 PPR producer for 2016 by upper management
  • Received two “recognition awards” for excellent quality and production.

Workout Specialist

Bank of America Corporation
09.2009 - 06.2015
  • Audited loan modifications and loss mitigation practices to ensure State & Federal guidelines were met
  • Learned how to become detail oriented, analytical, and excel as a customer service representative
  • Built internal and external relationships with investors and underwriters
  • Specialized in State and Federal foreclosure laws
  • Research involved validating procedures were followed, with respect to foreclosure sale, post-sale confirmation SCRA and Bankruptcy guidelines
  • Worked on systems analysis including AS400, LAMP, LPS, Iportal and AACER.

Insurance Agent

Crusader Insurance
06.2007 - 09.2009
  • Trained to work with agents to increase sales and overall customer satisfaction
  • Reviewed files and analyzed data to confirm the risk was alleviated when a sale was completed
  • Negotiated property and corporate insurance to match the needs of our clients
  • Built relationships with clients and business owners
  • Developed insurance packages based on their needs
  • Sold various types of insurance plans primarily related to property coverages.

Education

Bachelor of Arts (B.A.) in Marketing -

California State University Northridge
Northridge, CA

Skills

  • Requirements Elicitation

    • undefined

    Certification

    IIBA - CCBA (Certification of Capability in Business Analysis) Credential ID 26279474

    Timeline

    Business Data Analyst

    AmeriHome Corporation
    03.2023 - Current

    IIBA - CCBA (Certification of Capability in Business Analysis) Credential ID 26279474

    12-2021

    Senior Business Analyst

    AmeriHome Corporation
    02.2021 - 03.2023

    Business Application Analyst

    AmeriHome Corporation
    10.2018 - 02.2021

    Operations Analyst

    AmeriHome Corporation
    11.2016 - 10.2018

    Loan Review Analyst

    AmeriHome Corporation
    10.2015 - 11.2016

    Workout Specialist

    Bank of America Corporation
    09.2009 - 06.2015

    Insurance Agent

    Crusader Insurance
    06.2007 - 09.2009

    Bachelor of Arts (B.A.) in Marketing -

    California State University Northridge

    Similar Profiles

    CREATE PROFILE
    Brian JohnstonSenior Business Analyst