Professional Summary

• 7 years of extensive experience as a Business Systems Analyst with expertise in Mortgage and finance Domain with complete understanding of Software Development Life Cycle, involved in various phases such as Requirement Analysis, Requirement Communication, and requirements elicitation, Design, Development, Risk Management and Testing.
• Ample experience in Business Requirement gathering, Functional Specification Documentation, Business Process Flow and Analysis, Data Mapping and Modeling and also Project Management.
• Expertise in Software Development Life Cycle SDLC , Business Process Modeling Notation BPMN , Object-oriented Analysis and Design, Rational Unified Process RUP , Agile and Quality Assurance QA Methodologies.
• Extensive experience working on data analytics confirming data quality standards and data validation.
• Competent in creating Unified Modeling Language UML diagrams such as Use Case Diagrams, Activity Diagrams, Class Diagrams and Sequence Diagrams. Expertise in implementing scrum methodology for business analysis including User Story creation.
• Experienced in writing user stories based on the business requirements in Agile Methodology.
• Experienced in elicitation techniques like interviewing, questionnaires, brainstorming, focus groups, prototyping, cost/benefit analysis, SWOT analysis, risk analysis and conducting User training.
• Experienced in performing GAP Analysis by identifying existing processes and documenting enhancements to meet end user expectations.
• Expertise in performing impact analysis on existing processes in relation to changes pertaining to banks regulatory requirements and developments.
• Proficient at all rational tools including Rational Rose and Rational Requisite Pro.
• Experience in Creating and Maintaining the Requirements Traceability Matrix RTM , Leading JAD/JAR sessions to reduce time spent in moving information between stakeholders and team members. .
• Experience with RDBMS such as Oracle, MS SQL Server and MS Access.
• Experience in Java/J2EE Based Web applications.
• Skilled in using MS office applications for day to day activity, MS Visio for creating flow diagrams and MS Project for prioritizing and managing individual tasks.
• Experienced in documentation defined as per Sarbanes Oxley SOX compliance.
• Involved in Test Planning, Test Preparation, Test Execution, Issue Resolution and Report Generation to assure that all aspects of a Project are in Compliance with the Business Requirements.
• Strong experience in conducting User Acceptance Testing UAT and documentation of Test Cases. Expertise in designing and developing Test Plans and Test Scripts.
• Expertise in Creating and executing automated tests cases for web systems, using HP Quality Center 10.0.

Technical Skills:

Professional Experience:

Confidential

Role: Sr. Business Analyst

Description: Primary function of the project was to Confidential Origination Process beginning with the customer initiation to title transfer. The system performs all the business functions of the loan process such as set-up Account Information, New Loan set-up, Escrow Analysis, the Appraisal, Credit history, income and Title functionalities. All the systems were integrated in to one system. Followed Enterprise Service Bus ESB integration model.

Responsibilities:

• Worked as business analyst to support the integration of the TCF Mortgage Management System.
• Developed strategic partnerships with the business unit to develop a solid knowledge base of the business line.
• Extensively involved in the development of Reporting Data Warehousing System
• Used ESB integration and created a centralized system that would talk to other sub-systems like Account Information, New Loan set-up, Escrow Analysis, etc.
• Created FSDs for interfaces between components, assemblies, subsystems, and systems in detail.
• Assisted Business Analysts, Developers and customers' resources with integration process.
• Designed and developed project document templates based on Agile methodology.
• Conducted interviews with key business users to collect requirement and business process information
• Designed and developed all Use Cases and UML models using Visio.
• Developed Sequence/Activity Diagrams, OOD using UML
• Designed and implemented basic SQL queries for QA testing and report / data validation using TOAD.
• Wrote SQL queries to analyze Data Warehouse environment.
• Performed User Acceptance Testing UAT
• Played a key role in the planning, testing, and implementation of system enhancements and conversions.
• Functioned as the primary liaison between the business line, operations, and the technical areas throughout the project life cycle.
• Developed requirement reports for day-to-day retail banking needs for opening account online
• Partnered with the technical areas in the research and resolution of system and process problems.
• Analyzed research on operational procedures and methods and recommend changes for improvement with an emphasis on automation and efficiency.

Environment: MS Office Suite, MS Visio, Lotus Notes, UML, Microsoft Project, AWS, Agile, Windows 2000/XP, Rational Rose, SQL Server.

Confidential

Role: Business Data Analyst

Description: The project was to create a Loan Origination System for the Confidential. The Loan Origination System allowed users to complete their loan applications, which in turn would be gathered and verified by the system to allow the application to undergo the loan application, processing, underwriting, and closing processes. This system allowed the company to collect and consolidate user data for verification and remediate failed applications, thus streamlining and increasing the efficiency of the company in dispersing loans to various clients.

Responsibilities:

• Played key role in System Development Life Cycle SDLC Process consisting of: Design and Gap Analysis, Business Requirements, Systems Requirements, Test Criteria and Implementation to have the output of project.
• Knowledge of Mortgage payment risk, Risk Analytics for MBS, Loan Servicing, Foreclosure, Loan Origination, MBS, CMBS, and Secondary Mortgage Market.
• Conducted Joint Application Development JAD sessions with development and other IT teams to define the requirements and supported developers in the use of Change Management and Change Control tools and procedures.
• Interfaced with SMEs to prepare BPR documents.
• Performed data analysis and generated Ad hoc reports with outliers and data anomalies.
• Experience co-coordinating project activities for multiple releases across the cluster.
• Various versions of the documents generated during the project were maintained and managed using Rational Clear Case and performed defect tracking using Rational Clear Quest.
• Involved in detailing project mission, data process flow diagrams, and timelines.
• Worked with SQL queries for data manipulations.
• Involved in Requirement Management, Doors Testing Team to determine RTM in traceability
• Created Requirement Traceability Matrix linking Business Requirements to Functional requirements and thereby to Systems Requirements.
• Assisted Business Intelligence team by building reports using Crystal reports.
• Performed Data mapping between source systems to Target systems, logical data modeling, created class diagrams and ER diagrams.
• Planned and defined Use Cases created Use Case diagrams, Scenarios and Use Case Narratives using the UML methodologies.
• Developed User Accepting Testing UAT plans and test cases based on the business requirements/System Requirements.

Environment: Rational Enterprise Suite Rose, Clear Case, Clear Quest , RUP, Tera data, Visual Basic, SQL, SQL Server, C , PL/SQL, HTML, Unix, Agile/Scrum, MS Visio, MS Office.

Confidential

Business/System Analyst

Description: Confidential automates monthly borrower payment and financial accounting for fixed rate and adjustable rate mortgages. The system generates monthly forecast to compute the cash flow for the service organization. Based on the actual payment, the system computes the allocation of the monthly borrower payment towards scheduled, delinquent, reinstatement, prepayment, curtailment, skip payment, other fees and adjustments. It presents the payoff value during any time of the loan term and generates invoices and opt-in alerts for the borrower. The payment distribution module generates reports to account payments due to the service organization, primary mortgage, secondary mortgage and investors. The system allows borrower users to make payments by automated ACH, internal users to view loan information to provide customer service and management staff to generate scheduled reports.

Responsibilities:

• Developed the scope and vision document that defined the primary goals, objectives and features of the Loan Servicing system.
• Conducted and participated in user interviews to understand and document business requirements and functional specifications.
• Identified and developed process flow diagrams for various business processes and validated the flows with Subject Matter Experts SMEs .
• Worked as a liaison between business users, testers and application development team.
• Assisted in process modeling conducted and participated in JAD sessions with system users helped with design walkthroughs with stakeholders for base lining architecture.
• Assisted in developing help documentation and user manuals in accordance to the client's documentation guidelines.
• Created business rules with calculation examples for borrower payment options.
• Researched and validated SOX Requirements for Internal Auditors.
• Documented requirements in DOORS.
• Analyzed data using SQL to produce portfolio summary report the information is used by the system to analyze returns on equity and fixed income portfolios.
• Analyzed business requirements and segregated them into high level and low level Use Cases, activity and State Diagrams using Rational Rose according to UML methodology.
• Used Quality Center 10 to upload the data requirements and use the application for managing change control and issue tracking.
• Assisted the QA group in developing and documenting test cases, system testing and User Acceptance Testing.

Environment: MS Visio, RUP, JAD, UML, Rational Rose, Windows, MS Office, Visual Basic, SQL, SQL Server DOORS.

Confidential

System Analyst

Responsibilities:

• Worked throughout SDLC, including requirements, specifications, design, analysis, testing using RUP methodology.
• Analyzing the User/Business requirements, Use Cases and Functional specification documents.
• Supported Full life cycle financial software development and analysis.
• Prepared use case models based on Business Requirement documentation.
• Facilitated Process Modeling/Mapping and implemented scenario and what-if analysis.
• Involved in performing Database testing. Used SQL queries for this purpose.
• Wrote SQL statements to extract Data from application backend and to verify it with frontend results during End-to-End stage.
• Involved in Developing and handling the PL/SQL Packages, Procedures and Database Triggers.
• Performed Gap Analysis to check compatibility of the existing system infrastructure with new business requirements.
• Participated in various meetings and discussed Enhancement and Modification request issues.
• Interacting with the users and business relationship managers and implementing changes.
• Involved in designing and documenting Test Plans, Test Cases, Test Scenarios, and Test Strategies based on business requirements, Use cases and other specifications.
• Involved in QA testing, Failover and Recovery testing. Prepared the Test data for testing activities and for UAT and Performance testing.
• Reported bugs using Quality Center.

Environment: Windows 2000/XP, SQL Server , Business Process, Rational Requisite Pro, Reports, Rational Rose, RUP, Informatica, MS Office, MS Visio, C , PL/SQL.