SUMMARY:

• 7+ years of experience as a Business Analyst with solid understanding of Business Requirement Gathering, Business Process Flow, Business Process Modeling.
• Strong knowledge of Software Development Life Cycle (SDLC), Rational Unified Process (RUP) methodology, and Project Life Cycle.
• Strong subject matter expertise in Fixed Income, Derivatives, Equities, Bond Pricing, Mortgage Backed Securities (MBS), Annuity.
• Strong knowledge in Automated Clearing House (ACH), Bank Clearing System, Electronic Funds Transfer (EFT). General understanding of Accounting process including general ledger and account reconciliation.
• Strong experience in conducting User Acceptance Testing (UAT) and documentation of Test Cases.
• Extensive experience in conducting JAD sessions - participated in varied roles ranging from facilitator, preparing visual aids, setting goals and objectives, providing read-ahead materials to participants, etc.
• Knowledge in Project Management i.e. Project Scoping, Planning, Estimating, Scheduling, Organizing, Directing, Controlling, Budgeting and Drafting Remedy Procedures
• Experience in writing SQL queries and optimizing the queries in Sybase, Oracle and SQL Server 2008.
• Configured the Data mapping between Oracle and SQL Server 2008.
• Well conversant with scripting languages like Java Script, VB Script, HTML, DHTML, and XML.
• Written Use cases and have produced Use Case Models, creating Behavioral diagrams (use case diagram, Activity diagrams and Sequence diagrams) based on UML Methodology & Business process flow diagrams.
• Proficient in the use of tools like Telelogic DOORS, Rational Rose, Requisite Pro, Rational ClearCase, Telelogic System Architect and MS Visio.
• Extensive experience in documentation of business requirements and system functional specifications, including BRD, FRD, and FSD
• Utilized a combination of business knowledge, technical skills, and strategic analysis to provide solutions and creative insights to critical business problems.
• Effective in multitasking and effective management of assignments according to work schedules with strong project management orientation.
• Capable of forming and maintaining positive and productive working relationships in internal, external, independent and team environment.

TECHNICAL SKILLS:

Business Modeling Tools: Rational Rose, Rational Enterprise Suite, MS Visio, Telelogic System Architect

Reqmts. Management Tools: Rational Requisite Pro, Telelogic DOORS

Change Management Tools: Rational ClearCase, Rational ClearQuest

Project Management Tool: MS Project

Analysis / Modeling tools: UML, JAD, RUP, RAD

Testing Tools: Loadrunner, Test Director,Mercury Quality Centre

Operating Systems: MS Windows NT/98/95/2000, 7 UNIX

Languages: SQL, UML, JAVA

Database: Oracle, SQL Server2008,2012, MS Access

Utility: MS Office Suite Word, Project, Excel, Visio, PowerPoint, Adobe Acrobat Suite

PROFESSIONAL EXPERIENCE:

Confidential, Buffallo, NY

Senio Business Analyst

Responsibilities:

• Worked with the business users to define business requirements and analyze the possible technical solutions.
• Analyzed Business Requirements and segregated them into high level and low level Use Cases, Activity Diagrams / State Chart Diagrams using Rational Rose according to UML methodology thus defining the Data Process Models.
• Conducted user interviews, gathered requirements, analyzed, and documented Business requirements based on the analysis of the workflow model.
• Conducted workflow, process diagram and gap analyses to derive requirements for existing systems enhancements.
• Gathered requirements and modeled the data warehouse and the underlying transactional database
• Used MS Visio for Process modeling and Business Process flow diagrams.
• Worked on mapping of MSP Webservices to Enterprise Interface Partners and coordinated with FIS on MSP Web Services environment access and connectivity related tasks/issues
• Migrated Data from MS Excel to SQL Server Reporting Service Using DTS and SQL loader utilities.
• Worked with multiple project teams of technical professionals through all phases of the SDLC using technologies including Oracle, Erwin, Data Stage, Data Warehousing, Websphere and Cognos.
• Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.
• Involved in testing all the data elements in RSIs Mortgage Account Inquiry Service, which is called by CCW to obtain Mortgage loan data from MSP.
• Facilitated and managed meeting sessions with committee of SMEs from various business areas including Mortgage Servicing, Loan Monitoring and Asset Management.
• Identified and validated high potential business opportunities for stakeholders and developed customized business strategies that are aligned with corporate strategic objectives for legacy system.
• Conducted Gap Analysis of client requirements, generated workflow process and necessary documents for the project by interacting with mortgage processing specialists, stakeholders, and valuable customers.
• Gained acknowledgement for providing software modules for MSP and automating data filtering for non-performing loans
• Conducted interviews, meetings and JAD sessions during the process of Requirement Gathering.
• Facilitate JAD sessions involving the management, development and user teams for clarifying requirements and facilitating better communication.
• Uses UML to produce AS IS and TO BE models
• Developed several detail and summary reports including line and pie charts, trend analysis reports and sub-reports according to business requirements using SQL Server Reporting Services (SSRS).
• Worked extensively with MS Excel and MS Access to create Ad Hock reports
• Analyzed the Business and System Requirements of the application.
• Created and maintained traceability matrix in MS Excel
• Designed and developed project document templates based on SDLC methodology.
• Co-author business requirements document with project teams. Extracted, discussed, and refined business requirements from business users and team members
• Facilitated and managed meeting sessions from business areas including Mortgage Origination, Loan Processing.
• Assisted the testing team in developing the Test plans for quality assurance based on functional requirements.
• Prepared Business Process Models that includes modeling of all the activities of business from conceptual to procedural level.
• Performed User Acceptance Testing (UAT) for various web based and database related applications.
• Interacting with the development and testing teams to improve overall quality of the software.
• Developed Use case, Functional, Object diagrams using Rational Rose.
• Analyzed user problems, including automated and manual business processes and identified, researched, investigated, defined and documented business processes
• Act as a resource in understanding how IS systems carry out business functions and assists in ensuring the timely and effective implementation.
• Worked under sprint Iteration model and gained expertise.
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database
• Worked extensively with the QA team for designing Test Plan and Test Cases for the User Acceptance Testing.
• Verified the Business Scenarios on new builds to allow extended testing by the QA team.

Environment: MS office 2013, Enterprise Architect, Crystal reports MS Project, LPS - MSP, Rational Test Manager, Data Stage.

Confidential, Wilmington, DE

Business Analyst

Responsibilities:

• Responsible for documenting business specifications from the client, users, developers, designers and Subject Matter Experts for complete understanding of the business process and application so as to transform them into meaningful technical specifications and functional specification for the software development
• Incorporated the best practice methodologies as advocated by the Rational Unified Process to develop a structured approach during the overall Software Development Life Cycle.
• Analyze business requirements and segregate them into high level and low level Use Cases, Activity Diagram
• Implemented RUP methodology across different phases in software development lifecycle.
• Responsible for writing Functional Requirement Specifications (FRS) and User Requirement Specifications (URS). Conducted JAD sessions with various stakeholders to develop design and architecture of the application based on the business requirements, discuss and resolve open issues, discuss change requests and document them in orderly fashion.
• Identified Use Cases from the requirement and wrote Use Case Specifications.
• Created business process workflow diagrams based on Rational Unified Process.
• Streamlined Closing process for Empower loans through system workflow
• Provided leadership for Operational work streams for BKFS Empower system.
• Created clear Operational Business requirements aligned to target objectives.
• Supported Operational change in Business Support Model.
• Supported new Operational implementations of BKFS Empower system Partnered with Compliance and Finance teams for requirements management from project initiation through implementation to empower technical teams to produce the best possible solutions.
• Monitored stakeholder expectations through involvement and communication throughout the lifecycle of the project, educate clients and stakeholders on the benefits and risks associated with the project
• Defect tracking, assigning, getting defects resolved, submission, documentation and change requests
• Managed and resolving data issues on using Teradata SQL Assistant.
• Used Output Delivery system (ODS) facility to direct SAS output to RTF, PDF and HTML files.
• Performed SAS analysis using the customer database to monitor portfolio pricing.
• Built summary reports after identifying the customers, their occupancy period and the revenue generated using PROC SUMMARY, PROC MEANS, PROC FREQ and GCHART.
• Automating and Scheduling the Teradata SQL Scripts in UNIX using Korn Shell scripting.
• Developed customize templates and report formats in Excel using VBA, Macros, pivot tables and charts.
• Hands on experience in setting up data warehouse, understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Setting up Enterprise Data Warehouse (EDW) and associated ETL service to generate business reports.
• Performed Data Profiling of current state of data in the Data Warehouse by doing Data Analysis using advanced SQL Queries and Microsoft Excel, finding Gaps in Data and formulating solutions for the same
• Created data model that visually represents the nature of data, business rules governing the data, and how it will be organized in the database.
• Formed advanced SQL Queries and used Microsoft Excel to investigate data issues in the Data Warehouse and worked with the Users and Technology Team to formulate a solution to resolve the issue
• Assisted the team members to develop Service Oriented Architecture (SOA), and data warehouse system (EDW) to utilize data mining for data analysis.
• Presented Weekly/Monthly Project Status reports describing the status to date, impact of issues and changes in requirements necessary to the clients and getting sign off from them for the same.
• Involved in preparing Test Plans based on User Requirements Document and prepared the Test Cases
• Interacted with the developers to resolve the technical and implementing issues. Involved in User Acceptance Testing with the users.

Environment: Requisite Pro, MS Visio, UML, XML, SQL Server, MS Project

Confidential

Business Systems Analyst

Responsibilities:

• Gathered business requirements by conducting detailed interviews with business users, stakeholders and Subject Matter Experts (SME’s). Defined the scope of the project, financial projections and Cost/benefit analysis.
• Used report mock-ups to establish the content and purpose of the reports
• Implemented the entire Rational Unified Process (RUP) methodology of application development with its various workflows, artifacts and activities.
• Conducted JAD sessions with management, SME, vendors, users and other stakeholders for open and pending issues.
• Worked on mortgage servicing platform (MSP), which is an application that automates loan servicing, including loan setup and ongoing processing, customer service, accounting and reporting to the secondary mortgage market, and federal regulatory reporting.
• Worked with MSP to automate all areas of loan servicing. MSP was used because of the need to support various loan products like fixed rate mortgage, adjustable rate mortgage, construction mortgage and home equity loans.
• Responsible for understanding as well as making the clients and customers understand the analytics and transmission of fixed income, equity, real estate, mortgage, and derivatives and alternative investment related attributes and business.
• Constructed web layouts and GUI specifications using MS front page
• Worked on modeling the logical database
• Responsible for converting the business requirements into functional and non-Functional requirements.
• Used UML and BPMN guidelines to document the existing and future process flows
• Used mock-ups, user interaction list and additional documentation must provide enough information so that a developer can build the report.
• Conducted GAP analysis to understand the shortcomings of the existing system and evaluated the benefits of the new system
• Categorized report mockups
• Extensively used Rational Requisite Pro to gather and manage requirements. Created and managed project templates, use case templates, requirement types and tractability matrix in Requisite Pro.
• Worked on report layouts and Mockups
• Identified and developed Use Cases from the requirements. Followed the UML methodology to Create UML Diagrams including Use Cases Diagrams, Activity Diagrams, Sequence Diagrams, Collaboration Diagrams, Data Flow Diagrams (DFDs), ER Diagrams using Rational Rose and MS Visio and thus defining the Business Process Model and Data Process Model.
• Extensively involved in RAD session to converge early toward a design acceptable to the customer and feasible for the developers.
• Validated report specifications and Mockups
• Scheduled meetings with developers, system analyst and testers to collaborate resource allocation and project completion using MS Project.
• Created Mock-up forms in MS Access for better visualization and understanding of the software solution.
• Functioned as the primary liaison between the business line, operations and the technical areas throughout the project cycle.
• Worked extensively on Business Requirements, Functional Specification, Data-Integration, Data Mapping, and Data Warehouse access using SQL and Crystal Reports, ETL process, use cases modeling (UML) using MS Office (Word, Excel, Access, Visio) and dashboards
• Worked closely with the Quality Assurance team and developed test cases using the developed use cases as the platform, and conducted User Acceptance Testing (UAT).
• Created SQL queries for reporting details on derivative trades as a part of Dodd-Frank framework
• Involved in developing use cases for the functional specification.
• Designed and developed Use Cases, Sequence and Activity Diagrams, Conceptual models and process flow diagrams to help explain the process to the developers and analyze the project using MS Visio
• Performed Feasibility, Adaptability and Risk Analysis to identify the business critical and high-risk areas of the application.
• Monitored version control and defect tracking activities using Rational ClearCase and Rational ClearQuest.
• Extensively involved in writing test cases and test plans and reporting bugs using TestDirector.
• Performed User Acceptance Testing (UAT).

Environment: Rational Rose, Rational Requisite Pro, UML, RUP, MS Office (MS Word, MS Excel, MS PowerPoint, MS Visio), Visual Basic, WinRunner, TestDirector, Windows 2000, Java, J2EE, Oracle 9i, User Acceptance Testing (UAT), JAD, GAP Analysis, Use Cases Diagrams, Activity Diagrams, Sequence Diagrams, Collaboration Diagrams, Data Flow Diagrams (DFDs), ER Diagrams

Confidential . Allentown, PA

Business Systems Analyst

Responsibilities:

• Extracted the Business Requirements from the end users keeping in mind their need for the application and prepared Business Requirement Documents (BRD) using Rational RequisitePro.
• Reviewed Design Documents, Requirements Analysis Specifications with Project Lead, Business Owners and the Technical Lead.
• Played key role in System Development Life Cycle Process consisting of: Design and Gap Analysis, Business Requirements, Systems Requirements, and Test Criteria
• Created and managed Project Templates, Use Case Project Templates, Requirement Types and Traceability Relationships in RequisitePro.
• Conversion of data from different database environments, while performing Back End Testing.
• Involved in creating automated Test Scripts representing various Transactions, Documenting the Load Testing Process and Methodology. Created meaningful reports for analysis and integrated the Performance Testing in the SDLC.
• Familiar with Financial Products Pricing, as well as Mortgage rate pricing strategies.
• Created dictionary of Fidelity Data (MSP) elements into Fidelity XML Elements (added new data elements)
• Worked on MSP system in various workstations like REO, Default, Loss Mitigation and screens related to them.
• Reviewed Stored Procedures for reports and wrote test queries against the source system (SQL Server) to match the results with the actual report against the Data mart (Oracle).
• Involved in gathering Business Level Requirements and reviewed manual testing methods
• Prepared Test plans which includes an introduction, various test strategies, test schedules, QA teams role, test deliverables, etc.
• Responsible for writing Test cases to cover overall quality assurance using Test Director
• Performed initial manual testing of the application as part of sanity testing
• Performed various tests such as positive, negative to check business functionality manually
• Performed Black Box testing and conducted Functionality and Regression testing on various phases of the Management software
• The tests also included GUI testing: Testing for validation and display of screens
• Developed and managed Project Plans and Schedules.
• Managed resolution of Project issues and conflicts.
• Conducted Functional Walkthroughs, User Acceptance Testing (UAT), and supervised the development of User Manuals for customers.
• Performed all necessary programming, testing and documentation for COBOL, DB2 batch programs and sub-routines.
• Worked as a User/Customer advocate and negotiated with user as well as with developers and management staff to resolve any requirement conflict to bridge the Gaps between IT and Business.
• Various versions of the documents generated during the project were maintained and managed using Rational ClearCase and performed defect tracking using Rational Clear Quest.
• Tested the final application for Usability testing to verify whether all the User Requirements were catered to by the application.

Environment: RUP, UML, SDLC, MS Office, MS Project, MS Visio, DOORS, Project Management, SQL, DB2, COBOL

Confidential, Boston, MA

Business Analyst

Responsibilities:

• Performed requirements gathering from the business users of the system while adhering to SDLC (Software Development Life Cycle) industry best practices. products like Mortgage Backed Securities, Asset Backed Securities, and Megas & Tranches Analyzed the system to be implemented for production to ensure that it handles incomplete and accurate data and performs default method of calculations for various mortgage
• Developed excel models to derive the amortization schedule for Whole loan products and Mortgage Backed Securities
• Involved in mentoring specific projects in application of the new SDLC based on the Agile Unified Process, especially from the project management, requirements and architecture perspectives
• Worked closely with LOS team members to improve Help Desk Empower technical documentation, Peregrine Service Center problem ticket standards, and reduce the number of escalated tickets.
• Interacted with Software development team and Business users as a liaison in helping developers to understand the business requirements thereby ensuring the proposed applications comply with the business specifications.
• Assigned tasks among development team, monitored and tracked progress of project following Agile/Scrum methodology
• Responsible for the quality of all changes to Empower, the mortgage loan origination system for the Retail branches.
• Prepared UML Diagrams like Activity Diagrams, Sequence Diagrams for the requirements, also prepared Business Process Model for the complete Online Mortgage Application processing System.
• Supported Loss Mitigation department in reducing risk and costs for the Bank
• Created and process modifications and other retention agreements
• Reviewed monthly/quarterly/yearly operational losses for the mortgage company in order to identify risks to the company and process gaps. Complete in depth research as needed into root cause in order to assist in development of new processes as well as implementing process improvements for current processes.
• Reviewed documents/templates to create BRD and implemented the RUP process, identified Gap Analysis and the AS-IS and TO-BE model
• Facilitated the User Acceptance Testing (UAT) with Pega System Administrators and Business Users, documented any issues or defects and eventually got sign off from the right parties.
• Conducted presentations to make users understand about the processes.
• Prepared project plan and defined different milestones.
• Involved in project management using MS Project
• Discussed different functional requirements and defined high level design and Use Cases.
• Developed process flow diagrams (flow charts) using MS Visio in an effort to identify and analyze process flows in the RBC Safe Deposit Box system.
• Migrated Data from MS Excel to SQL Server Reporting Service Using DTS and SQL loader utilities.
• Used MS Excel and MS Word to create a field-to-field data map that was used as a main specification document for the conversion program.
• Substantial report development experience utilizing SQL Server Reporting Services (SSRS), Cognos Impromptu, and Microsoft Excel
• Core responsibility involved complete manually testing of the User Acceptance Test (UAT)
• Developed traceability matrix for maintaining/updating system requirements using MS Excel.
• Elicited requirements and provided specific business and technical requirements guidance for the construction of the system. The requirements set comprised of Business Requirements Document (BRD), functional requirements, Business and System Use Cases.
• Lead Validation/Verification, SIT (System Integration Testing), Mock conversion on the system to ensure data accuracy and RBC Bank’s business needs.
• Conducted Joint Application Discussions (JAD), project meetings, reviews walkthroughs, client interviews and coordinating various technical team at off shore and managerial teams at all levels.
• Delivered and maintained extensive documentation for future extendibility of the system

Environment: IBM Personal Communications, SDLC, SQL, MS Word, MS Excel, MS Visio, MS Project, Windows XP