SUMMARY

• A Senior Business Analyst wif over 9 years of experience in Business analysis wif 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.
• Has 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 wif 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 wif designing and verifying databases on Oracle and SQL Server RDBMS using Entity-Relationship Diagrams (ERD).
• Experience and understanding of Agile wif 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 wif 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 wif 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 wif 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 wif 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 wif 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 wif developers, project managers, subject-matter experts, stakeholders, system implementers, and application end-users.
• Creative and Enthusiastic Self-Starter wif 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.
• Gatheird 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 wif subject matter expert team and developed product backlog.
• Worked in assistance wif the technical team in writing high-level design document.
• Conducted highly interactive JAD sessions wif 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 wif 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 wif risk management tools for mortgage loan servicing, commercial & residential mortgage, and risk analytics for MBS.
• Collaborated wif external service partners wif 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 wif 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 wif 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 halp 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 wif the architect, database administrator and technical team during Data Mapping and Data Integration.
• Interacted wif 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 wif 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 wif 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 gatheird 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 wif 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 wif 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 wif data extraction using SQL wifin 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 wif 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" wif a blend of strong design and data flow skills.
• Build Platform features, user stories, and maintain backlog wif 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 wif AFS.
• Involved in analyzing and designing the test cases for the following modules wifin Loan IQ: Rates, Non-Accrual, Borrower/Guarantor, Fees, Syndicated Agent, Deal, Facility, Sub Limits, and Amendment.
• Gatheird 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 wif a new vendor to halp build an email referral system that could track existing clients and the friends they shared their referral code wif. 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 wif 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&me 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 wif strong in-depth and breadth of experience wif 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 wifin 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 wif 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 wif 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 wif on and off shore agile teams.
• Involved in conducting VMS program steering committee meetings wif 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 wif 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 wif Fieldglass team all custom reports user wifin the firm as per user needs.
• Facilitating priority meetings wif stakeholders to halp 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 wif Development Team.
• Involved in preparing the project documents and facilitated review sessions as per the in-house SDLC methodology in compliance wif the corporate and audit regulations.
• Participated in weekly meetings wif the management team and conducted documentation walkthroughs.
• Involved in creating & maintaining issues and risk documents and followed up wif 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 wif 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 wif 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 wif 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 wif 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.
• Has 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 wif sprint cycles, daily stand ups and story implementation. large cross functional project and support teams.
• Participated in conducting interviews wif key business users to collect requirements and business process information.
• Gained knowledge in documenting requirements associated change requests wif requirements and connected requirements wif Use cases in Requisite Pro and created different traceability views.
• Performed and evaluated the benefits of the new system and generated workflows.
• Has 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 wif 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 wif the team extensively using pivot tables and v lookup for reporting.
• Has analyzed and interpreted the technical information in order to compose User Manuals.
• Participated in writing several test cases for UAT and regression testing.
• Has been assisted in facilitating Joint Application Development (JAD) sessions and White Board Sessions wif business users from various departments Data Architects and developers.
• Interacted wif 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 wif the leads planning and let UAT process by setting up weekly status and planning meetings wif 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 wif users to document the test scripts correctly and ensured that all data is tested.