SUMMARY

• A Senior Business Analyst wif over 9 years of experience in Business analysis wif experience in technical data analysis in teh Financial and Capital markets 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 teh Rational Unified Process (RUP) methodology in all areas of teh 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.
• Experience in AFS application implementation Data Model tables and reference/lookup structure to support business needs.
• Good Knowledge of various financial products like Stocks, Bonds, Mortgage-Backed Securities (MBS), Collateral Mortgage Obligation (CMO), and Fixed Income Instruments.
• 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 teh logical models.
• Experience wif designing and verifying databases on Oracle and SQL Server RDBMS using Entity-Relationship Diagrams (ERD).
• Excellent noledge of teh 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.
• Knowledge of Capital Markets: Loans, including Operations, Deal Structure, Loan Types, and teh various businesses dat support Loans
• 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 teh Informatica/ ETL (Extract, Transform and Load) of data into a data warehouse/date mart and tools like Business Objects Modules.
• Excellent noledge in Dimensional Data Modeling and analyzing teh 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 teh Rational Unified Process.
• Experience working as Joint Application Development (JAD) facilitator and meetings coordinator wif excellent interpersonal skills.
• 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 subject matter expertise in Credit Card Industry, Retail/Investment Banking, Stocks, Bonds, Derivatives, Risk Analysis, Mortgage Loan Origination, Processing and Loan Servicing.
• Strong understanding of Loan Origination Systems (LOS), Home Mortgages, Credit Loans, Auto Loans, Commercial Loans, Home Loans, Investment banking.
• Experienced in multiple servicing software systems including MSP, Empower and Black Knight Financial Services (Loan Sphere/BKFS).
• Extensive Knowledge in E-lending and Black Knight Financial Services (BKFS) platform for teh loan and mortgage processing program.
• Responsible for conducting root cause analysis in teh System of Record (SOR) and federally mandated reporting.
• Tasked wif providing tactical and strategic solutions for teh loan origination, servicing, CCAR reporting groups.
• Performed Gap Analysis to check teh compatibility of teh existing system infrastructure wif teh new business requirements.
• 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 teh calculation of teh Critical Success Factor (CSF) of teh project.
• Experienced in Process Improvement, Requirements Gathering, Design, Development, Change Control Process, Quality Assurance Testing, User Acceptance Testing (UAT) &Training.

PROFESSIONAL EXPERIENCE

Sr. Business Analyst

Confidential - Buffalo, NY

Responsibilities:

• Gathered business requirements through interviews, surveys and UI analysis of teh existing system.
• Performed Gap Analysis by defining teh As-Is & To-Be states of teh 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.
• Worked in assistance wif teh 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 teh Merger / Integration projects, performed SQL querying, XML and C# research and data analysis for teh 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).
• Identify teh Loan IQ transactions for regression testing for upgrade to version 7.4.
• 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 as a Business Analyst, leveraging teh noledge gained for migrating teh Commercial Lending Process from existing AFS Application to teh new application platform Loan IQ, mainly focusing on teh Commercial Lending Servicing process.
• Worked on documenting teh 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.
• Involved in designing screen mockups to specify teh User Interface of teh 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 teh 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 teh team on analyzing teh implementation of regulatory measures for custom mortgages on AFS Commercial Loan System and documented teh configuration of customization setting for billing and Invoicing.
• Worked wif teh team on using Black Knight Financial Services tools (Passport and MSP) to perform data conditioning activities.
• Formulated a Test Plan and Test Cases dat comprehensively tested these critical aspects of teh loan origination system and teh loan lifecycle.
• Analyzed several Data Net queries and developed Loan IQ SQL to support upgrade from Loan IQ v6 to v7.4. Analyzed and Developed User Metrics Report for Agency Services. Prepared Loan IQ Data Net and Model Training.
• Worked as a liaison between line of business and Black knight financial services.
• Assisted in teh performance of end to end data conditioning activities such as identifying/ exporting loans from Oracle, creating transaction templates in Black Knight Financial Services Passport, modifying and loading of loan data via Passport, validation of successful batch cycle and presence of conditioned loan data in MSP, etc.
• Worked on Jira for creating user stories and issues, tracking teh project progress, and bug tracking.
• Interacted wif teh ETL team to perform Data Mapping procedures for loading data into teh new system.
• Provided ad hoc data analysis and reporting using SQL, Excel and Tableau.
• Conducted weekly meetings to decide teh Policies and Procedures to be followed while constructing new sites. Tested Loan IQ operations related to teh commercial loan trading system.
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for theSSAScubes.
• Worked on deploying SSIS packages, SQL scripts, SSAS cubes into Production environment and supported them for new enhancements or fixes.
• Worked on Loan Origination System (LOS) application for teh defects and enhancements for teh releases.
• Involved in creating XML Data Files, Schema Files (XSD), and imported XML Data into Excel to perform Data Analysis.
• Worked on Mortgage Processing Services based on a platform of Black Knight Financial Services MSP/LSP.
• Worked on performing Source to Target mapping of data retrieved from disparate sources related to teh Mortgage services.
• Participated in End to end testing during version upgrade of Loan IQ from V6 to V7.4.
• Worked on identifying various data sources from where teh data had to be extracted for teh new platform.
• Involved in designing and developing Use Cases, Use Case Diagram, Activity Diagrams and Data Flow Diagrams.
• Worked closely wif teh architect, database administrator and technical team during Data Mapping and Data Integration.
• Played a key role in teh planning, testing, and implementation of system enhancements and conversions.
• Worked wif Internal Controls department to ensure teh system is SOX compliant.
• Prepared Test Plans and managed Test Cases using teh 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 teh data centralized by various Mortgage applications) by applying Filters and presented business metrics & KPIs as per user requirements.
• Worked on developing Tableau dashboards and reports by blending data and using different visualizations.
• 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 teh application development for better understanding of teh business and IT processes.
• Worked on developing Lessons Learnt document at teh end of each iteration by assessing teh experiences and considering them in subsequent iterations.
• Performed backend testing using SQL to verify teh integrity of business data.

Business Analyst

Confidential - Salt lake city, 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 teh project documents and facilitated review sessions as per teh in-house SDLC methodology in compliance wif teh corporate and audit regulations.
• 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.
• Worked wif QA testing team to design test methods to verify teh application's functions of consumer loan, home equity, refinance, commercial loan activities.
• Involved in teh design and implementation of data mart, facts, dimensions and OLAP cubes using dimensional modeling standards in SQL Server dat maintained data. Involved in teh complete data warehouse development life cycle. Actively supported business users for change requests.
• Worked on gathering Business Requirement and documenting teh Technical Design Sessions for converting Commercial Loan's legacy systems to AFS.
• Worked on Using Data modeling concept to define legacy applications and design interface plans wif AFS.
• Analyze and designed teh test cases for teh following modules wifin Loan IQ: Rates, Non-Accrual, Borrower/Guarantor, Fees, Syndicated Agent, Deal, Facility, Sub Limits, and Amendment.
• Prepared Business Requirement Documents (BRD's) after teh collection of Functional Requirements from System Users dat 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 teh bank.
• Worked wif a new vendor to help build an email referral system dat could track existing clients and teh 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 teh project teams. To drive efficiencies in our Agile work streams, led to teh development of processes to ensure a successful project plan was in place.
• Met wif Sales & Bankers to understand their business duties and made necessary adjustments to their business processes. Would shadow them weekly to understand different sales scenarios to help drive new technology enhancements.
• Responsible for assist in training new hires on Loan IQ and Syndicated Large Corporation procedures.
• Communicated teh most TEMPeffective way to utilize teh 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 teh Loan Origination System. Formulated a Test Plan and Test Cases dat comprehensively tested these critical aspects of teh loan life cycle.
• Data migration and document mapping to Consumer Loan Origination System (CLOS), requirement and process flows for next set of projects.
• 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 Confidential &me data, and ACH transactions.
• Validated business objects, Loan IQ and IBS Congnos reports using SQL queries.
• Worked on getting teh 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 teh solution into technical design.
• Extensively worked on system architecture. Used UML to create use cases, used case diagrams, classes & sequence diagrams.
• Worked on developing UML Use Case models using Rational Rose, workflow and Screen Shots for teh application.
• 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 - Charlotte, NC

Responsibilities:

• Designed teh business requirement collection approach based on teh 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 teh 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 teh requirements for project to enable teh collection of Government Monitoring Information for Home Equity Loans.
• 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
• Acted as a liaison between teh businesses, design and development teams during translation of requirements specifications into software solution.
• Worked on creating Screen mockups to model teh 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.
• Involved in preparing teh project documents and facilitated review sessions as per teh in-house SDLC methodology in compliance wif teh corporate and audit regulations.
• Participated in weekly meetings wif teh management team and conducted documentation walkthroughs.
• Involved in creating & maintaining issues and risk documents and followed up wif teh individual owners to ensure teh timely response/completion of teh action items.
• Maintained teh Traceability Matrix to ensure dat all Functional Requirements are addressed at teh Use Case Level as well as teh 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 teh backend database to ensure teh correctness of teh 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 teh available organizational templates & thoroughly analyzing them for teh impact on teh 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 teh development, testing and design units to develop a cohesive functional plan.
• Reviewed and signed teh test strategy, test plan, test cases and educate thebusiness testing partners on teh test strategies.
• Coordinated UAT of teh product wif Business Users, QA and developers.

Business Analyst

Confidential - San Francisco, CA

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 teh Requirements of teh end Users/Business Analysts and Developed Strategies for ETL processes.
• Have been assisted by teh seniors to gather additional requirements from teh users in order to describe teh business needs in terms of teh system being created.
• Responsible for completing weekly project status reports.
• Participated in conducting interviews wif key business users to collect requirements and business process information.
• Gained noledge 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 teh benefits of teh new system and generated workflows.
• Have been assisted on designing and developing teh Test plan and Test case documents.
• Obtained noledge in retrieving Data using SQL queries and performed Data Mapping and Data analysis.
• Worked wif teh team developing documentation templates, specifications and schedules for technical writing deliverables.
• Involved wif teh team extensively using pivot tables and v lookup for reporting.
• Have analyzed and interpreted teh 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 wif business users from various departments Data Architects and developers.
• Interacted wif all teh levels in PMO for reviewing, regular modifications, change management and Traceability Matrix.
• Acquired noledge in performing Gap analysis of teh reports by identifying existing technologies, documenting teh enhancements to meet teh end state requirements.
• Involved in defining testing objectives and verify requirements are testable.
• Worked wif teh 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 teh test results from QA teams using Performance Studio Analysis to create various scenarios.
• Worked wif users to document teh test scripts correctly and ensured dat all data is tested.