SUMMARY:

• A result oriented Business Analyst with over 7+ years of experience in Mortgage, Banking, Financial Services domains with extensive exposure to gathering & analyzing user requirements, business modelling, process simulation and data analysis.
• Exceptional strategic communication skills focused to interface between business and technical needs.
• Strong business, communications, written and presentation skills written (reports, implementation requirements, project status reports, oral presentations, e - mails), update executive staff and team members with goals, project status, with expertise in conflict resolution.
• Project environment support, scope and planning utilizing waterfall based methodology
• Ability to define timelines for prioritizing work.
• Sound knowledge of concepts like Gap Analysis, Impact Analysis.
• Excellent Business writing skills in writing Business requirements document, USE Case Specifications, Functional Specifications.
• Strong Knowledge of Iterative Methodologies such as Agile SDLC Practices & Principles.
• Thorough exposure of conducting JAD sessions and interviews with Subject Matter Experts (SME) and data stewards to understand the business process, business rules, and data requirements.
• Expertise in Agile, SCRUM, Waterfall SDLC (Software Development Methodologies).
• Knowledge of Sarbanes Oxley (SOX) Act, Section 404 key controls as implemented through project management methodologies.
• Ability to prepare RTM (Requirements Traceability Matrix) & performance requirements analysis & design.
• Good understanding of Data Warehousing and OLAP concepts
• Expertise in creating Data Mapping Documents and Source to Target Transformation documents.
• Functional knowledge of SSIS to extract and transform data from a wide variety of sources such as XML data files, flat files, and relational data sources, and then load the data into migration end database.

TECHNICAL SKILLS:

Modeling Tools: Rational RequisitePro, HPALM, UML, MS Visio, BPMN, Rational Rose, Rational Clear Case

Methodologies / Frameworks: RUP, Agile/Scrum, SDLC, Waterfall.

Database: MS SQL Server 2012/2008/2005, MS Access.

BI Reporting Tools: Tableau, Microstrategy, Crystal Reports, Cognos 10 (report & Query studio), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Microstrategy reporting system.

ETL Tools: Data stage, Informatica, IBM Cognos.

QA Testing Tools: HP QC, JIRA, Load Runner, MS Test Manager 2013

Documentation Tools: MS Office Suite, SharePoint 2010/2013, PEGA 7.

Data Warehousing: Data Marts, OLTP, OLAP, ROLAP, DOLAP, MOLAP, HOLAP, Query/Reporting,Multidimensional Analysis, Data Mining, Slicing/dicing, Drill Down/Roll Up, MDM

Finance: Fixed Income, Pension & retirement, Securities, Mortgage Loans, Mortgage Backed Securities(MBS), Derivatives, Bonds, Mutual Funds, Equities, Sweeps, Swaps,Pricing, Brokerage, Stocks, Bloomberg Data

Project Management Tools: MS Project professional, MS Project Server

PROFESSIONAL EXPERIENCE:

Confidential, VA

Sr. Business Analyst

Responsibilities:

• Worked with the Business sponsor and Project Manager to create Project Charter, which covered project need, business scope, Resources and constraints of the project.
• Worked heavily with Data Architects to resolved mapping issues using the Conical Data Model and understanding event models.
• Wrote system requirements for the Rules MISMO Management for the Data Translation Service for Legacy codes using DOORS and SDLC Methodology
• Extensively worked with Project Manager, Architects and business users to understand business requirements.
• Conducted JAD sessions and one to one interviews with business users, management, SME, other stakeholders of the project.
• Created Business Requirement Document, Functional Requirement Specifications and used DOORS to maintain the requirements.
• Documented all the discussions, stored the requirements and tracked the changes maintaining the versions of document.
• Analyzed business needs and created Application Use Case (AUC) documents.
• Leaded business initiatives including brainstorming on new functionality for current system.
• Conducted Functional Requirements reviews and walkthroughs with designers, developers and stakeholders.
• Helped document the rational and requirements behind the XML architecture that encompasses data origination, secondary market and servicing data for implementing MISMO standards.
• Analyzed Requirements and created Use Cases, Use Case Diagrams, Activity Diagrams, data flow diagrams using MS Visio.
• Created data mapping document worked with data modelers in the creation of logical and physical data models and data base design using System Architect based on the business rules produced.
• Understanding of SOA and worked with XML.
• Performed GAP analysis and maintained documentation.
• Created requirements in Iteration development and waterfall method.
• Documented and maintained Requirements Traceability Matrix (RTM) to validate that all requirements have been tested.
• Wrote standard and complex SQL queries.
• Extensively worked on Access, Excel, Word, Visio, PowerPoint, SQL, MS Project
• Implemented the full project lifecycle phases including requirements gatherings, development and quality assurance.
• Developed Test plans, Test cases with QA team and helped to develop test scenarios for system testing and performance testing.

Environment: MS Office, MS Project, MS Visio, CaliberRM, Oracle, MS Visio, DOORS, Axure Pro RP, RUP/Agile, Rational Suite, Windows NT, LINUX, ERwin, Loan IQ system

Business Systems Analyst

Responsibilities:

• Worked with the business Stakeholders and SME’s to define business requirements and analyze the functional requirements
• Responsible for Requirement gathering, Business Process flow, Business Process Modeling and Business Analysis with Document and Records Management
• Facilitated JAD sessions with management, users and other stakeholders to define the project and also to reduce the turn-around time of deliverables
• Prepared and presented Business Requirement Document (BRD) and Functional Requirement Document (FRD)
• Experience with end to end loan origination process, Basel and Dodd-Frank act
• Managed day-to-day project activities and coordinated tasks with other teams
• Defined requirements for all workflow activities including analysis, design, testing, and implementation for mortgage lending and loan origination systems (LOS).
• Worked closely with the UI team to model the screens for android, iPad and iPhone applications.
• Worked with Brand Management team on developing content and UI for Mobile Application
• Lead research project “Banking with social media and smart phone technology”.
• Performed Gap analysis by identifying existing technologies, documenting the enhancements to meet the end state requirements
• Reviewed prototypes, solution blueprints, and project scope to ensure that the needs of the business are being met
• Used Waterfall, Agile (SCRUM) & combination of the two Methodology on the projects
• Translated the requirements to the IT and web production teams to facilitate their HTML builds for the projects
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data
• Analyzed business requirements and segregated them into Use Cases. Created Use case diagrams using Rational Rose following the UML methodology
• Created Screen mock ups/prototype/wireframes to illustrate new requirements and alignment around project scope using MS Visio
• Involved in identifying and documenting the process of implementing MISMO standard as a Web service to our current clients which included three steps: creating the XML data set according to the standard definition, Organizing the XML data set so that it will be created or consumed consistently and then writing WSDL, Web services description language.
• Responsible for managing the documented System Requirements and Requirements Traceability Matrix using Rational Requisite Pro
• Responsibilities also included Quality Assurance Test Planning, Test Case development and test script execution for Integration, Regression, Performance, Functional and System Testing
• Involved in creating detailed test plans and testing strategies and ensure these are executed extensively, which includes executing SQL queries to retrieve data and test
• Provided support for User Acceptance Testing with UAT cases and resolved issues with the users

Environment: MS Visio, SharePoint, SQL, UML, Waterfall, Test Director, MS Paint, HP Quality Centre, MS Word, MS Power point, Wire frames

Business Analyst

Responsibilities:

• Interacted with various members at the management level to understand business processes, decision models, and analysis needs and created functional and non-functional requirements using Rational Requisite Pro.
• As support to the Project Manager defined eBusiness processes, analyzed and documented requirements, identified gaps, evaluated requirements and change requests, managed scope and transferred knowledge.
• Facilitated JAD sessions, conducted interviews, Q&A sessions with business users, SMEs to solicit business requirements relative to proposed functionality.
• Partnered with the business stake holders, process owners, users to identify their requirements, produced detailed specifications, planned the project deliverables with the software development team
• Created business vision and scope definition and business requirement presentations using Microsoft Power Point.
• Entered requirements into Caliber Requirements Management Tool.
• Developed Use Case diagrams by analyzing the business process followed by activity diagrams and sequential diagrams, work/process flow and data flow diagrams using MS Visio and ERwin.
• A combination of RUP/Agile methodologies were used wherein the RUP six best practices for iterative and incremental development were incorporated into the system but with quick prototyping and deployment time boxes. Planned all the iterations and documented the artifacts throughout various phases.
• Analyzed, collected and prepared user requirements, definitions, scope and expectations for deliverable plans.
• Used UML for Visual modeling and created detailed Use-Case Specification to describe the interaction and functional requirements of the system.
• Used Axure Pro RP for GUI based front end prototype and simulation.
• Analyzed and evaluated all the information gathered from multiple sources, reconciled conflicts and decomposed high-level information into details.
• Abstracted up from low-level information to a more general understanding, distinguished user requests from the underlying true needs, and distinguished solution ideas from requirements.
• Used SSIS for ETL data from a wide variety of sources such as XML data/flat files and relational data sources, and then loaded the data into multi-destination databases.
• Formulated customized dimensional data reports using SSRS.
• Led the Sarbanes Oxley (SOX) Act, Section 404 key controls implementation, compliance and security standards within the system.
• Used Rational ClearQuest as the change request management tool to track and manage all defects and enhancements.
• Documented the defects and their trailing history in the Test Director and helped developers recreate defects by executing the related scenarios in order to identify the root cause of defect.
• Developed On-Demand User Training Webcasts and conducted e-learning sessions using Adobe Acrobat ConnectPro.

Environment: MS Office, MS Project, MS Visio, CaliberRM, Oracle, MS Visio, DOORS, Axure Pro RP, RUP/Agile, Rational Suite, Windows NT, LINUX, ERwin, Loan IQ system

Business Systems Analyst

Responsibilities:

• Gathering requirements from Business Line Mangers and SME’s for Transamerica.com (New Website), Customer Database and to Digitalize the Transactions
• Perform system and document analysis to understand the current systems
• Develop Business Process Model (BPMN) and detailed Business Policies and documenting the same in Business Requirement Document as per PMO Guide lines.
• Prepare High Level Process Flow Diagrams and Business Process Flow diagrams for TA.Com functionalities in Visio
• Develop Use Case diagrams, Use case Narratives and User Stories.
• Prepare Wireframes, Prototypes and Mock up screens for different web pages
• Develop Customer Database Mapping Document, Digital Transactions Mapping Document to map all Policy Administration Systems and Business Rules Mapping Document
• Identify the required fields for Customer Database (Data Warehouse) from Customer extracts and Contract extracts from different Policy Administration Systems
• Performing Data Profiling for the Extracts received from the Admin Systems.
• Coordinate with offshore team in documenting the gathered Requirements in to BRD’s and FRD’s
• Developed Traceability matrix that traces to Functional Requirements in the Business Requirements
• Coordinate with SDL Tridion (Content Management System) developers while gathering the requirements for the Content of the New Transameirca Web application
• Interact with SOA architects for developing Integration Service Bus(ISB) & Enterprise Bus Service(ESB)
• Develop WebService Mapping Documents to map UI Literals to Administration Systems
• Help developers understand Business Requirements and design for Graphical User Interface (GUI), Customer Database and Digitalize Transactions
• Coordinate with QA team to determine and develop Test Plans, Test Cases and methods for Unit Testing, Integration and Functional Testing based on testing requirements
• Participate in User Acceptance Testing (UAT) and developed Training Manuals
• Perform data validation using SQL queries and run ad-hoc queries to show data to the business users
• Perform XML schema validation using SAOP UI
• Used Agile/Scrum methodologies throughout the project
• Worked on Java platform for TA.Com and DotNet Platform for Web Services

Environment: Agile/Scrum, Windows (98/XP/7/Vista/8), .Net Framework (VB.NET, ASP.NET), MS Visio, Rational Requisitepro, HPQC, SQL / SQL Server, MSOffice suite, MS Project Professional, Mockup screens, HTML, XML.