SUMMARY

• A Senior Business Analyst with over 9 years of experience in Business analysis with experience in technical data analysis in the Financial industry.
• Successful in translating business requirements and user expectations into detailed specifications employing Unified Modeling Language (UML) using Rational Rose & MS Visio.
• Expertise in using Rational tools for creating use cases, version control, and defect tracking and monitoring and used the Rational Unified Process (RUP) methodology in all areas of the software development life cycle (SDLC).
• Vast experience in performing SDLC tasks - Requirement gathering, Analysis and Feasibility, Creating Business Requirement Document (BRD), Transforming BRD to Functional Specification Documents (FSD), High Level and Low-Level Design documents etc.
• Good Knowledge of various financial products like Bonds, Mortgage-Backed Securities (MBS), Collateral Mortgage Obligation (CMO), and Fixed Income Instruments.
• Have in-depth knowledge of Software Development Life Cycle (SDLC) methodologies, assisting and working as Scrum Master on several projects, vast experience working in Agile, Waterfall, RUP methodologies. Primarily in Agile methodology. Handling Scrum team offshore and onsite.
• Experience managing vendors, building and fostering strategic relationships with hiring managers, department managers, and VMS/ MSP partners on a regular basis to assess business needs, requirements, performance and overall satisfaction.
• Good understanding of Mortgage Loan origination systems like Encompass 360 and Black Knight Financial Services Empower.
• Experienced in conducting Requirement Analysis, Use Case Design, Designing Test Plans and developed database schemas based on the logical models.
• Experience with designing and verifying databases on Oracle and SQL Server RDBMS using Entity-Relationship Diagrams (ERD).
• Experience and understanding of Agile with flavors of scrum, lean, Kanban, Hybrid implementations and traditional processes like Waterfall methodologies and ITSM; and blended methodologies.
• Excellent knowledge of the Misys Loan IQ Batch Execution Framework and Expertise in development with Misys Loan IQ APIs.
• Expertise in underlying Misys Loan IQ data model and components.
• Experienced in writing Test Plan and Test Cases and aggressively involved in Regression Testing and Performance Testing using automation tools like Win Runner, Load Runner, Test Director, Quick Test Pro and using SQL
• Knowledge in the Informatica/ ETL (Extract, Transform and Load) of data into a data warehouse/date mart and tools like Business Objects Modules.
• Excellent knowledge in Dimensional Data Modeling and analyzing the Data Warehouse by building multi-dimensional cubes using SQL Server Analysis Services (SSAS).
• Experience in optimization of cubes for better query performance.
• Experience with banking services, Loan Monitoring, Loan Origination System and Assets Management.
• Ability to gather business and Technical Requirements from both formal and informal sessions utilizing a variety of software methodologies including, Use Cases and the Rational Unified Process.
• Experience working as Joint Application Development (JAD) facilitator and meetings coordinator with excellent interpersonal skills.
• Knowledge of Mortgage Loan Origination, Loan Originating Systems (NLS, VITA, Oracle), Servicing, Closing, Mortgage-Backed Securities (MBS), Loss Mitigation, Loan Modification.
• Experience working in various complex IT projects dealing with Loan Origination systems, Trading, Mortgage & Credit Card related Web/Client-Server applications, ERP applications, and Investment Banking operations.
• Strong understanding of Loan Origination Systems (LOS), Home Mortgages, Credit Loans, Auto Loans, Commercial Loans, Home Loans, Investment banking.
• Well-versed with leading industry tools like Jira, Version1, Caliber, MS Visio, MS Word, MS Excel and MS PowerPoint to develop various project deliverables.
• Expertise in broad range of technologies, including business process tools such as Microsoft Project, MS Access, MS Visio, technical assessment tools, Data Warehousing concepts and web design and development.
• Strong Communication and Presentation Skills substantiated in past assignments with developers, project managers, subject-matter experts, stakeholders, system implementers, and application end-users.
• Creative and Enthusiastic Self-Starter with integrative thinking skills, capable of forming and maintaining positive and productive working relationships in internal, external, independent, and team environments.
• Expert in conducting User Acceptance Tests (UAT), GAP analysis and Impact analysis to aid in the calculation of the Critical Success Factor (CSF) of the project.

PROFESSIONAL EXPERIENCE

Sr. Business Analyst

Confidential -Troy, MI

Responsibilities:

• Worked on Loan Origination System (LOS) application for the defects and enhancements for the releases.
• Gathered business requirements through interviews, surveys and UI analysis of the existing system.
• Performed Gap Analysis by defining the As-Is & To-Be states of the Deposit and Loan platforms.
• Translated ambiguous business requirements into Agile User Stories and Technical specifications.
• Participated in frequent agile team meetings to provide guidance to an agile product development process.
• Involved in analyzing requirements for loan request, loan process, loan origination, member services, processing and portfolio management.
• Analyzed popular VMS system Field glass, People click, Zero Chaos, Pro Unlimited, IQ Navigator with subject matter expert team and developed product backlog.
• Worked in assistance with the technical team in writing high-level design document.
• Conducted highly interactive JAD sessions with project stakeholders to identify and resolve issues. Ensured consensus between Line of Business and IT Teams.
• Worked on the Merger / Integration projects, performed SQL querying, XML and C# research and data analysis for the Misys Loan IQ database and Loan IQ downstream interfaces.
• Worked on creating Test Cases/Plans, Test Scenarios and Test Scripts for Test Execution as described in BRD (Business Requirements Document) and FRD (Functional Requirements Document).
• 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 program document creation and maintenance such as the MSP operations manual, VMS training guides, VMS quick reference guides, vendor FAQs, and VMS configuration guide.
• Involved in creating general regression scripts in Loan IQ for use in major software upgrades.
• Worked on complete loan origination system (LOS) requirements and developed Use Cases with narratives.
• Worked on leveraging the knowledge gained for migrating the Commercial Lending Process from existing AFS Application to the new application platform Loan IQ, mainly focusing on the Commercial Lending Servicing process.
• Worked on documenting the projects through final phase Implementation for development of new Financial History Utilities to add information from current Automated Financial System (AFS) Commercial Loan System.
• Developed Use Cases, Business Process Models and Data Flow diagrams using Microsoft Visio.
• Worked with risk management tools for mortgage loan servicing, commercial & residential mortgage, and risk analytics for MBS.
• Collaborated with external service partners with the configuration requirements for Blend LOS, DOCUTECH. Validating the solutions using API’s and Payload XMls requests and Response.
• Involved in designing screen mockups to specify the User Interface of the Mortgage LOS application.
• Involved in scope management and assessing dependencies, potential issues, and risks.
• Involved in performing manual testing on Admin, Authorization, Closing and Funding modules of the Loan Origination System.
• Worked on gathering requirements for multiple lines of business resources for AFS Commercial Loan System, Data Warehouses and Client digital website.
• Involved with the team on analyzing the implementation of regulatory measures for custom mortgages on AFS Commercial Loan System and documented the configuration of customization setting for billing and Invoicing.
• Formulated a Test Plan and Test Cases that comprehensively tested these critical aspects of the loan origination system and the loan lifecycle.
• Analyzed and Developed User Metrics Report for Agency Services. Prepared Loan IQ Data Net and Model Training.
• Worked on Jira for creating user stories and issues, tracking the project progress, and bug tracking.
• Interacted with the ETL team to perform Data Mapping procedures for loading data into the new system.
• Provided ad hoc data analysis and reporting using SQL, Excel and Tableau.
• Conducted weekly meetings to decide the Policies and Procedures to be followed while constructing new sites. Tested Loan IQ operations related to the commercial loan trading system.
• Performed user working sessions for requirement gathering, designing, implementation and testing of all the integration feeds back and forth between Confidential resource management systems and Fieldglass. This includes feeds: user, org structure, funding and firm spend plan, building/city, entitlements, time entry, open Job Postings, Invoice and their payment status.
• Assisted the Fixed Income and Equity Departments in opening accounts of stocks, futures and bonds included in the portfolios of asset management projects.
• Responsible for evaluating the current VMS and MSP systems to help created an integrated system.
• Involved in creating XML Data Files, Schema Files (XSD), and imported XML Data into Excel to perform Data Analysis.
• Worked on identifying various data sources from where the data had to be extracted for the new platform.
• Involved in designing and developing Use Cases, Use Case Diagram, Activity Diagrams and Data Flow Diagrams.
• Worked closely with the architect, database administrator and technical team during Data Mapping and Data Integration.
• Interacted with the user community & SMEs to enhance understanding of the Asset management and portfolio management.
• Played a key role in the planning, testing, and implementation of system enhancements and conversions.
• Worked with Internal Controls department to ensure the system is SOX compliant.
• Prepared Test Plans and managed Test Cases using the Jira add-on, Test Rail.
• Conducted JAD sessions with SMEs, business users and other stakeholders; documenting change requests.
• Worked on creating interactive dashboards and reports on Tableau (using the data centralized by various Mortgage applications) by applying Filters and presented business metrics & KPIs as per user requirements.
• Conducted functional testing and coordinated UAT sessions to sign-off project to subsequent phases.
• Worked as a Liaison between QA team and Business Units involved in the application development for better understanding of the business and IT processes.
• Worked on developing Lessons Learnt document at the end of each iteration by assessing the experiences and considering them in subsequent iterations.
• Performed backend testing using SQL to verify the integrity of business data.

Business Analyst

Confidential -Sandy, UT

Responsibilities:

• Involved in Analysis of gathered requirements data for Loan IQ Data Model verification of requirements and creation of business requirement specifications (BRS).
• Prepared the project documents and facilitated review sessions as per the in-house SDLC methodology in compliance with the corporate and audit regulations.
• Involved in implementing process for implementing clients and suppliers into the IQN MSP or VMS program from the sales phase thru the interface design, onboarding of the client and suppliers and go-live.
• Worked on creating an end-to-end framework for a loan origination lifecycle.
• Lead JAD sessions to brainstorm requirements from business users to initiate systems development process.
• Worked closely with various line of business finance team on model transition, model updates, performance tracking, scenario testing, and liquidity impact analysis; businesses include Home Equity, Home Loan, and Payment Network.
• Involved in designing and manually produced accrual report with data extraction using SQL within Fieldglass for monthly accruals bookings for NA, EMEA, APAC regions.
• Drafted functional specifications for a customized internal controls and fixed asset management solution, supporting the client's strategy to improve financial reporting quality.
• Worked with QA testing team to design test methods to verify the application's functions of consumer loan, home equity, refinance, commercial loan activities.
• Involved in the design and implementation of data mart, facts, dimensions and OLAP cubes using dimensional modeling standards in SQL Server that maintained data. Involved in the complete data warehouse development life cycle. Actively supported business users for change requests.
• Worked on gathering Business Requirement and documenting the Technical Design Sessions for converting Commercial Loan's legacy systems to AFS.
• "Hands-on" with a blend of strong design and data flow skills.
• Build Platform features, user stories, and maintain backlog with priorities, using Rally and JIRA platforms; Drive HLD, Low Level, and Integration (SOAP, REST, JSON, XML etc.,) Designs.
• Worked on Using Data modeling concept to define legacy applications and design interface plans with AFS.
• Involved in analyzing and designing the test cases for the following modules within Loan IQ: Rates, Non-Accrual, Borrower/Guarantor, Fees, Syndicated Agent, Deal, Facility, Sub Limits, and Amendment.
• Gathered and refined business requirements for a new auto loan origination implementation project.
• Prepared Business Requirement Documents (BRD's) after the collection of Functional Requirements from System Users that provided appropriate scope of work for technical team to develop prototype and overall system.
• Involved in creating custom monthly report whole sales and retail banking (First lean mortgage, Home equity loans, Auto loans, Small business loans and other consumer loans) for different loan services used by the bank.
• Worked with a new vendor to help build an email referral system that could track existing clients and the friends they shared their referral code with. This new product included a completely new layout of tables and processes.
• Involved in implementing necessary processes for the project teams. To drive efficiencies in our Agile work streams, led to the development of processes to ensure a successful project plan was in place.
• Responsible for assist in training new hires on Loan IQ and Syndicated Large Corporation procedures.
• Communicated the most effective way to utilize the Loan Origination System, (LOS) to satisfy business requirements, which may be a combination of both standard and/or custom functionality.
• Performed manual testing on Admin, Authorization, Closing and Funding modules of the Loan Origination System. Formulated a Test Plan and Test Cases that comprehensively tested these critical aspects of the loan life cycle.
• Data migration and document mapping to Consumer Loan Origination System (CLOS), requirement and process flows for next set of projects.
• Facilitated Joint Requirement Planning JRP sessions with SME's in understanding the Requirements pertaining to Loan Origination to Loan Processing.
• Worked on using Loan IQ to create new Deal, and Loan Facilities, process new loan and LC draw-downs according to Agent Bank requests.
• Involved in testing of different functionality of Loan IQ such as Acquired loan indicator, entering different types of loan based on M&I data, and ACH transactions.
• Validated business objects, Loan IQ and IBS Cognos reports using SQL queries.
• Worked on getting the requirements for documents for Home Equity and Auto Loans.
• Translated business requirements into technical specs. Requirements analysis led to user stories. Grooming backlog and creating wireframes and prototypes. Sprint planning and measuring success on a sprint.
• Extensively involved in gathering business requirements and system requirements and specifications.
• Provided conceptual solution and translated the solution into technical design.
• Extensively worked on system architecture. Used UML to create use cases, used case diagrams, classes & sequence diagrams.
• A balanced blend of Business, IT and Project management skill with strong in-depth and breadth of experience with multiple industry, technologies, frameworks and processes.
• Worked on developing UML Use Case models using Rational Rose, workflow and Screen Shots for the application.
• Solely analyzed all the email notifications existing within Fieldglass and customized them for MS users.
• Assisted QA team in executing Test plans and wrote Test Cases
• Worked to review Test Procedures, defining Test cases, reviewing and maintaining Test scripts, analyzing bugs, interacting with team members in fixing errors and User Acceptance Testing (UAT).
• Prepared test cases, test plans, test strategies, traceability matrix for QA team.

Business Analyst

Confidential -Lake Forest, CA

Responsibilities:

• Designed the business requirement collection approach based on the project scope and SDLC Methodology.
• Facilitated and managed meeting sessions with committee of SMEs from various businesses
• Developed business process models in RUP to document existing and future business processes.
• Performed extensive requirement analysis including Data Analysis and Gap Analysis.
• Responsible for creating the Business Requirements Document (BRD) and Functional Specifications Document (FSD).
• Designed and developed project document templates based on SDLC methodology.
• Designed and developed all Use Cases and UML models using Rational Tools.
• Worked on the requirements for project to enable the collection of Government Monitoring Information for Home Equity Loans.
• Serve as a point of contact for the client’s stakeholders and provided customer support in addition to team building with on and off shore agile teams.
• Involved in conducting VMS program steering committee meetings with the VMO, VMS program sponsors and Confidential executives. Also served as a member of the VMS program Change Control Board that reviewed all program change requests, VMS enhancements and new releases.
• Developed UML Use-Cases and Use-Case diagrams after accessing the status and scope of the project and understanding the business processes using Rational Rose. Facilitated Joint Requirement Planning JRP sessions with SME's in understanding the Requirements pertaining to Loan Origination to Loan Processing.
• Lead JAD sessions to brainstorm requirements from business users to initiate systems development process.
• Worked on requirements for home Equity, HMDA reporting, new/used auto, visa/visa platinum rewards credit cards, boats, RVs.
• Involved in designing and coordinating implementing with Fieldglass team all custom reports user within the firm as per user needs.
• Facilitating priority meetings with stakeholders to help business understand the impact of the JIRA in prioritizing them.
• Acted as a liaison between the businesses, design and development teams during translation of requirements specifications into software solution.
• Worked on creating Screen mockups to model the screen, which met user defined requirements and company standards.
• Involved in analyzing business requirements and segregated them into Use Cases. Created Use case diagrams using MS Visio.
• Analysis of Mortgage Processing workflow. Developed business process flows, Use Cases, and other documentation for expansion loan servicing, securitization, and trading model while coordinating with Development Team.
• Involved in preparing the project documents and facilitated review sessions as per the in-house SDLC methodology in compliance with the corporate and audit regulations.
• Participated in weekly meetings with the management team and conducted documentation walkthroughs.
• Involved in creating & maintaining issues and risk documents and followed up with the individual owners to ensure the timely response/completion of the action items.
• Maintained the Traceability Matrix to ensure that all Functional Requirements are addressed at the Use Case Level as well as the Test Case Level using Requisite Pro.
• Assisted QA team with Test Plans, executing Test Cases and facilitated defect triaging.
• Performed data mapping by executing SQL scripts at the backend database to ensure the correctness of the test results.
• Involved in reviewing Test Procedures, defining Test cases, reviewing and maintaining Test scripts, analyzing bugs, interacting with team members in fixing errors and User Acceptance Testing (UAT).
• Handled Change Requests by capturing them in the available organizational templates & thoroughly analyzing them for the impact on the existing requirements.
• Used MS Office Suite extensively (which included MS Word, MS Excel, MS Power Point, MS Visio) for requirements, process documentation and maintained quality control.
• Worked closely with cross functional teams like the development, testing and design units to develop a cohesive functional plan.
• Reviewed and signed the test strategy, test plan, test cases and educate thebusiness testing partners on the test strategies.
• Coordinated UAT of the product with Business Users, QA and developers.

Business Analyst

Confidential -Reston, VA

Responsibilities:

• Analyzed Business Requirements and prepared Test Plans and Test Cases
• Helped in conducting release backlog, attended scrum meetings, conducted sprints and UAT in Agile methodology.
• Involved in understanding the Requirements of the end Users/Business Analysts and Developed Strategies for ETL processes.
• Involved in developing vendor metrics for the VMS program and provided program performance reports to the VMO and vendor companies participating in the program.
• Have been assisted by the seniors to gather additional requirements from the users in order to describe the business needs in terms of the system being created.
• Responsible for completing weekly project status reports.
• Worked as a part of scrum team, in an agile methodology with sprint cycles, daily stand ups and story implementation. large cross functional project and support teams.
• Participated in conducting interviews with key business users to collect requirements and business process information.
• Gained knowledge in documenting requirements associated change requests with requirements and connected requirements with Use cases in Requisite Pro and created different traceability views.
• Performed and evaluated the benefits of the new system and generated workflows.
• Have been assisted on designing and developing the Test plan and Test case documents.
• Obtained knowledge in retrieving Data using SQL queries and performed Data Mapping and Data analysis.
• Worked with the team developing documentation templates, specifications and schedules for technical writing deliverables.
• Created Business Flow, Risk Management, Test scripts, Business Requirements for larger system enhancements for multiple systems KSN, Fieldglass, PeopleSoft, KES, AESOP.
• Involved with the team extensively using pivot tables and v lookup for reporting.
• Have analyzed and interpreted the technical information in order to compose User Manuals.
• Participated in writing several test cases for UAT and regression testing.
• Have been assisted in facilitating Joint Application Development (JAD) sessions and White Board Sessions with business users from various departments Data Architects and developers.
• Interacted with all the levels in PMO for reviewing, regular modifications, change management and Traceability Matrix.
• Acquired knowledge in performing Gap analysis of the reports by identifying existing technologies, documenting the enhancements to meet the end state requirements.
• Involved in defining testing objectives and verify requirements are testable.
• Worked with the leads planning and let UAT process by setting up weekly status and planning meetings with users, handling UAT scrums, UAT touch point meetings.
• Worked on analyzing the test results from QA teams using Performance Studio Analysis to create various scenarios.
• Worked with users to document the test scripts correctly and ensured that all data is tested.