Mortgage Business Analyst Resume
4.00/5 (Submit Your Rating)
Phoenix, AZ
PROFESSIONAL SUMMARY:
- Over 8 years of diverse experience working with various domains which includes Banking, Financial and Insurance.
- Experienced in all phases of the Software Development Life Cycle (SDLC) including requirements gathering, design, development, testing and deployment.
- Competent in analyzing the current business process and creating future state business process flows using industry standard BPM notations
- Strong subject matter understanding in Risk assessment, Derivatives, Fixed Income Assets, Mutual Funds, Hedge Funds, Portfolio Analysis and Investment Banking.
- Domain Analysis, Data Analysis, Business Rules, Gap Analysis, Prototyping, developing/creating business process related documents with stronger affinity to financial services, investment banking, fixed income, equities, commodities, trade cycle, ETF, securities trade processing/clearing, asset management and mortgage. Diversified profile with client base ranging from investment banking to insurance to energy sector to digital imaging to retail banking to government services
- Successfully managed the production support team for mortgage servicing application.
- In - depth interaction with Primary markets, Secondary markets and mortgage backed securities and asset backed securities for requirement gathering
- Exceptional working experience in GAP analysis and understanding of the AS-IS and TO-BE business processes
- Expertise in conducting Stakeholder Analysis to define process stakeholders, and their roles & responsibilities towards the project.
- Financial Domain Knowledge with different types of investments including bonds/stocks/mutual funds diversified Investment portfolios, structured products and fixed income securities. Understanding of processes in Product Control and Financial Accounting.
- Gathered and refined business requirements for a new auto loan origination implementation project.
- AML/Sanctions compliance initiatives to support Bank and other business expansion. This includes managing end-to-end project initiatives, Risk Assessments, Actimize integration, and coordination with AML/Sanctions Directors and Business Unit Managers.
- Adept with different software development methods like Water Fall, Rapid Application Development (RAD), Rational Unified Process (RUP) and Agile (SCRUM) Method
- Implemented layouts for Suspicious Activity and Pattern analysis under AML regulations
- Issued the Test Plan Document, Test Planning, Test Design and Test Execution and was involved in the Testing Process which verified and validated all the defined business requirements and associated functionalities
- Familiarity with different Financial Markets like Capital Market, Derivative Market, FX Market with financial instruments like Cash Instruments, Derivative instruments, Securities Instruments. Financial Market risk management including Credit Risk/ Probability of Default Risk, Risk Weighted Assets and Value at Risk
- Skilled professional in analyzing Know your Customer (KYC) and Anti-Money Laundering (AML) requirements.
- Experience in developing clear, traceable requirements using interviews, document analysis, requirements workshops, surveys, site visits, business process descriptions, business analysis, task and workflow analysis, brainstorming, focus groups, prototyping
- Involvement in conducting Joint Application Development (JAD) sessions with the stakeholders, business users, and SME to obtain domain level information of projects. f Securitization Process, Collateral Mortgage Obligation (CMO), and Fixed Income Instruments.
- Expertise in Project Management i.e. Project Scoping, Planning, Estimating, Scheduling, Organizing, Directing, Controlling, Budgeting and Drafting Remedy Procedures.
- Extensive experience in Capital Markets, Corporate Banking, Financial Asset Management, Insurance/Mortgage Markets, and their Business Processes
- Involved in all phases of the company new Mortgage Origination system: Encompass and new line of mortgage product projects
- Proficient in writing Business Requirement Documents (BRD), Functional Requirement Documents (FRD), Technical Design Document (TDD), Functional Specification Document (FSD) and Requirement Traceability Matrix (RTM). Conducting various analysis GAP, Cost-Benefit, Risk and Impact, Feasibility Studies.
- Experience in writing and executing SQL Queries for Databases such as Teradata, Oracle, MySQL
- Excellent knowledge in data analysis, data validation, data cleansing, data verification and identifying data mismatch.
- In Depth understanding and performing GAP analysis between AS-IS and TO-BE business processes
- Excellent experience in Data mining with querying and mining large datasets to discover transition patterns and examine financial data.
- Experienced in Software testing life cycles, like developing Test plan and Test cases from functional and business requirements and writing and executing system and UAT test
- Knowledge of Bug reporting using HP Quality Center /ALM (Application Life Cycle management)
- Focused on development of integrated data environment with minimal Data Redundancy.
- Proficient in analyzing and creating Narrative Use Cases, User Stories, Story Boards, Use Case Diagrams, Activity diagrams, Data/Flow/Navigational flow diagrams using UML Tools like MS Visio
- Expert in writing detail system use cases, developing business test cases, and working with QA teams during testing phase thereby facilitating acceptance testing with stakeholders and business users
- Working knowledge of Change management and Release management
- Outstanding written and verbal skills with explicit attention to detail during requirements elicitation.
- Involved in of end users, documented Manuals for the new product release
- Excellent Interpersonal, and Analytical skills, with ability to handle challenges under pressure with ease.
TECHNICAL SKILLS:
Operating Systems: Windows, UNIX
Testing Applications: Rational Test Manager, HP/Mercury QTP, HPQC
Suites: Microsoft SharePoint, MS Project, MS-Office (Word, Excel, Power Point, Outlook, Adobe Photoshop)
Requirement and Document Tools: Rational Requisite Pro, Rational Clear-Quest, DOORS
Business Modeling Tools: Rational Rose, Enterprise Architect, Visual Paradigm, Microsoft Visio
PROFESSIONAL EXPERIENCE:
Confidential, Phoenix, AZ
Mortgage Business Analyst
Responsibilities:
- Communicated with Line of Business and created Business Requirements Document (BRD), High Level Diagram (HLD), and part of Low level Diagram (LLD).
- Analyzed Loan files XML Schema. If necessary, created elements and attributes with consultation from Line of Business (LOB), for passing loan file information from one service to another.
- Gathered requirements for a fully electronic auto insurance contract process
- Facilitated system maintenance and enhancement through design documents, process flow diagrams, use case diagrams etc.
- Understanding of Investment banking, Asset Management and other fund management functions including Front Office, Middle Office and Back Office operations.
- Execute day to day migration activities for Risk and Credit systems with success
- Used Macros in Excel to create and update data.
- Provided Capital Markets subject matter expertise to the IT team throughout the project. Reviewed development and test deliverables as needed
- Strong background in Mortgage software including: Empower, Black Knight, MSP
- Responsible for numerous decisions in respect to business policies, procedures, methods for implementation. Confidential Pre-payment risk, Risk Analytics for Confidential, Loan Servicing, Loan Origination, Confidential, CMBS, and Secondary Confidential Market.
- Responsible for the quality of all changes to Empower, the Confidential loan origination system for the branches
- Assisted with developing policies and departmental procedures for payment posting and billing
- Efficiently monitor project deliverables, milestones, and required tasks to successfully complete capital markets projects across multiple regions and stakeholders
- Always staying informed of emerging project management and Agile trends and best practices through contact with industry experts, peers, internal and external, and professional organizations
- Educate and reinforce scrum methodology and agile framework to team members and key stakeholders.
- Liaison with the business (Credit risk users and Finance controllers), the reporting team and the technology team for various reporting requirements for Data Quality Currently managing a Software Development project utilizing SDLC principles
- Involved in all phases of the company new Mortgage Origination system: Encompass and new line of mortgage product projects
- In-depth knowledge of a wide variety of financial instruments including Retail and Commercial Loans, Line of Credits, Mortgage, Equities, Fixed Income, Derivatives, Mutual Funds.
- Extensive practical knowledge on business process flow related to Conventional Insured, Conventional Uninsured(Fixed, ARM, FHA), VA, NACA, Sub-Prime Lending, HELOC Piggyback, HELOC Refinance, HELOANS, LIBOR and State Specific Mortgage Home Loans etc.
- Analyzed the system to be implemented for production to ensure that it handles incomplete and accurate data and performs default method of calculations for various mortgage products like Mortgage Backed Securities, Asset Backed Securities
- Worked extensively with Risk Management, Mortgage Loan Servicing, and Commercial and Residential mortgage, CMBS, MBS
- Played active role in file transferring and file processing from mortgage to banking Division
- Currently managing maintenance for a Software application utilizing Agile/Scrum methodology Currently managing an Infrastructure project to upgrade existing infrastructure to support upgrade
- SAS Viya release which involves the acquisition of 60 servers and the infrastructure components surrounding the installations
- Direct and monitor project activities for large, high risk, major technology-based projects through the
- Worked on GAP Analysis, Test Plan document, Project Plan, Traceability Matrix, User Acceptance Testing (UAT), and SWOT analysis.
- Prepare and test data for international metric including Wholesale credit, Investments, oil, gas, Libor, credit cards and commercial information
- Worked as a Senior Project Manager for multiple initiatives like Data Center Migration from Manhattan to Jersey City,
- Data warehouse hosting and Credit card analytics TD Bank relationship,
- Steer Middle Office and Front Office Technology teams to implement in-house XML conversion of Listed and OTC Derivatives to, XML, FPML and/or SWIFT protocols
- Proficient in creating User Acceptance Test (UAT) Plans and implementing and coordinating UAT.
- Collected, reported, and refined agile metrics to quantify and communicate team performance
- Attention primarily focused on capital markets and commercial lending in an effort to raise the bank’s domestic credit rating to meet regulatory compliance mandates.
- Requirements were gathered through interactions and meetings and periodic walkthroughs with loan analysts, credit analysts and other potential users of the application.
- Wrote complex sequential SQL queries and to generate statistics, and developed Excel pivot tables to report the results.
- Produced scheduled and on-demand risk management reports including building new reports and report delivery within defined time frames
- Effectively facilitates gathering, analysis, prioritization and categorization of complex business requirements & Business Rules for Elie Mae Encompass360, Loan Sphere Empower, Configurations, Customization and Enterprise wide setup.
- Designed screen layouts for proposed solutions, user interactions. Also, created screen mock-ups.
- Daily maintenance of credit risk application/credit batch; monitoring overage reports and breaches of counterparty credit limits, track bug fixes, Coordinate resources across various applications, operations or projects
- Assisted with drafting provider manuals and business requirements documentation concerning payment methodologies
- Tracked the project flow and acquired sign-offs from Business, System Development and Quality Analysis team.
- Wrote and tested Excel macros that significantly reduced the amount of time needed to reconcile accounts from Credit systems to the General Ledger on a daily, monthly, and quarterly basis
- Provided solution for database requirements by designing controls, data fields and data formats. Worked in legacy system migration from Lotus Notes to Oracle.
- Used different in-house software to track data flow, system interactions, system defects, service requests and responses.
- Created master specification for web services- their functionality, interaction with other web services, processing logic, input & output schema, and process flow with Logical Data Element.
Confidential, Lewisville, TX
Business Analyst
Responsibilities:
- Extensively involved in the deployment of Data System.
- Worked with the team in brainstorming sessions for understanding and developing the data transformation logics.
- Conducted interviews with key Business Users for better understanding of the requirement and business process information.
- Facilitated and managed JAD sessions with committee of SMEs from various business areas including Mortgage Servicing, Loan Monitoring and Asset Management.
- Developed business process models in Agile (Scrum) to document existing and future business processes.
- Developed Business Requirement Specification Documents as well as high-level project plan in collaboration with the other BA team members.
- Used Power Designer comprehensively during the entire project to facilitate conceptual, physical, and logical data model but not limited to Use Case, Activity Diagrams, Requirement Traceability Matrix and instant report generation.
- Played a key role in the planning, analyzing, testing and implementation of system enhancements and conversions.
- Streamlined business process documentation for Capital Markets Analytics team that allowed for easier on-boarding of new associates.
- Established and built the Equity Investment Risk Management team, as business owner of performance and risk analytical systems and reporting.
- Experienced in Web Service Calls configuration to and from Black Knight and MSP, working with multiple screens within MSP
- Played key role as founding contributor in the development and building of Global Performance & Risk Management
- Lightning is a web-based processing for fixed income capital markets which automates a range of processes, including, trading, sales, funding, accounting, risk analysis and asset/liability management
- Functioned as a primary liaison between the business line, operations and the technical areas throughout the project cycle.
- Facilitate all Agile Ceremonies including Retrospectives, Daily Stand Ups, Story Grooming, Demo/Review and Sprint Planning
- Performed extensive "Gap analysis" of the Wealth Management application to document existing business process flows and derive requirements for the proposed functionalities
- Assisted solution architects to develop technology solutions for the wealth management application and asset classes including Equities, Commodities and Fixed Income instruments
- Established company automation methodology, frameworks and tools
- Support agile team on the best way to refine backlog and create Healthy and Steady User Stories
- Ensure daily processing of travel agents commission payments were completed accurately and in a timely manner.
- Facilitated for quality assurance teams, UAT Team, and Line of Business on product enhancements and development
- Work in a SAFe scaled Agile for a while as it was newly introduced to organization, represented my team at the scrum of scrum meetings
- Specialties in Equities, Fixed Income Securities, Mortgage-Backed Securities & Securitization, Forwards (Equity, bonds, interest rate, currency), Futures (interest rate, stock index, currency), listed and OTC Options (Stock options, bond options, Interest Rate options on LIBOR)
- Implemented data staging for quality assurance and user acceptance testing (UAT).
- Enabled our department to receive payments in a timelier manner and reduce late payments received by customers.
- Worked with SME's to comprehend Risk Management concepts including Credit Risk, Market Risk and Operational Risk
- Experience working with windows OS, internal network, and cloud platform automation with PowerShell
- Analyzed the operational procedures/methods and recommended changes for improvement with an emphasis on automation and efficiency.
- Conducted User Acceptance Testing (UAT) and Post Production validations (PPV).
Confidential, Philadelphia, PA
Business Analyst
Responsibilities:
- Application of Simulation to understand the current system and identify problematic areas
- Used Simulation to verify the impart of Variability on the system and identified different levels of improvement
- Planned activities for the BA group and provide estimates for BA activities
- Worked in developing the wireframe and mock-ups for the prototype of the web-based portal application in MS Visio
- Extensive understanding & experience of migrating
- Created Process blueprints for Cost and Time estimates for migrating existing Savion Business Process Applications to IBM BPM.
- Create mapping documents for ETL implementation; Create mapping documents from data source to Teradata target tables.
- Analyzing and enhancing the sales and marketing strategy of a major US Property & Casualty Insurance company and providing business optimized solutions.
- Manipulate advanced Excel spreadsheets and data using intermediate to advance skill levels
- Excellent skill in creating Unified Modeling Language (UML) standard diagrams including Use Cases, Activity Diagrams, Data flow diagrams and Sequence diagram.
- Defined logic to correct many funds in AIS Dashboard for Master-Feeder Fund Structure for the fixed income instruments like Hedge Funds.
- Gathered business requirements for Auto Finance stakeholders.
- Scheduled and led requirements gathering through JAD sections for elicitation and documentation
- Document detailed business requires, Business rules, rating requirements, and coverage requirements
- Analyze surety Insurance forms and document forms requirements
- Compared actual and expected test results, discussed the defects in defect meeting with development team and then recorded/reported/tracked all Defects to Developers using a web-based tool called Rally (Bug, Issue and Project Tracking tool).
- Conducted JAD sessions and interviewed SMEs, asking detailed functionality aspects of Business Process (BPM) and carefully updating the information to the requirements in an easily understandable format.
- Worked closely with architect team to design solution to meet business needs
- Provided testing documents including test plan, test cases and verifications
- Performed GAP analysis and traceability matrix to trace missed requirement and variations in the actual results(As-is) as against the expected(To-be) software product states
- Used Rational Requisite PRO and DOORS in various P&C projects for requirements management and traceability among requirements, uses cases, business rules and test cases.
- Compared actual and expected test results, discussed the defects in defect meeting with development team and then recorded/reported/tracked all Defects to Developers using a web-based tool called JIRA (Bug, Issue and Project Tracking tool).
Confidential
Business Analyst
Responsibilities:
- A series of meetings / JAD sessions were conducted to gather requirements from business system users for reporting purposes.
- Developed SQL queries using SQL Navigator to extract data from the target tables to prove the data mapping.
- Identified the grain, key dimensions and facts for the star and snowflake design and developed logical/physical data modeling.
- Involved in design and development of standard and ad-hoc reporting using SQL.
- Involved in data management for Credit Risk, Liquidity risk and Market Risk data warehouse and create business rules for risk management systems
- Identify and document, business functions, activities and processes, data attribute and table meta-data, and general and detail design specifications.
- Created documentation and test cases, worked with users for new module enhancements and testing.
- Involved in making appropriate commitments through story selection, sizing and tasking
- Involved in Scrum Sprint Planning Sessions, Backlog Grooming Sizing, Sprint Retrospectives & Reviews, Daily Stand ups, User Stories and Acceptance Criteria
- Developed UML diagrams (use case diagrams, activity diagrams, sequence diagrams, and class diagrams) in order to validate entity data and verification of the customer records: legal name, address, business purpose legitimacy and analysis of transaction activity)
- Designed and implemented basic SQL queries for data warehouse, and did data profiling
- Created wireframes in order to help developers build the application in Visual Basic and held data modeling sessions by developing DFD
- Submit ideas through brain storming sessions and convert it to requirements and create user stories to be added to Jira backlog.
- Design, plan and program data conversion procedures from old to new databases.
- Coordinated bug fixing activities related to issues rose during end - User Acceptance Testing (UAT).