SUMMARY:

• Seasoned Business Analyst with around 8 years of experience.
• Excellent Analytical skills in Data Mining, Performance Management and Project Management to support strategic planning, goal setting, strengthen accountability, enhance decision making, and improve customer service.
• Strong knowledge of SDLC, Project Life Cycle, and Project Management including Agile, Scrum, UML and RUP.
• Extensive experience in analyzing and documenting Business Requirements and Functional Specifications.
• Experience in writing queries/scripts for Data Analysis and Manipulation in MS Access and MySQL using SQL scripts.
• Proficient in creating Use Cases, Sequence Diagrams, Collaboration Diagrams, Task Diagrams, Flow Charts, Activity Diagrams and Class Diagrams.
• Good knowledge of Business Process Flows/Modeling, Case Tools, Business Re - Engineering, Business Intelligence, and Data Warehousing.
• Proficiency in conducting GAP Analysis, User Acceptance Testing (UAT), SWOT Analysis, Cost Benefit Analysis and ROI Analysis.
• Expertise in conducting Joint Application Development (JAD) sessions for requirement gatherings, analysis, design, Scrum, and Rapid Application Development (RAD) sessions.
• Experienced in writing complex and technical reports for a varied high caliber audience.
• Analyzed and defined business processes both “AS-IS” and “TO BE”.
• Excellence in designing and executing Test Strategy, Test Plan, Test Scenarios, and Test Cases based on the requirements for the applications.

WORK EXPERIENCE:

Sr. Business Analyst

Confidential, Dallas, TX

Responsibilities:

• Worked on Fixed Income, Bonds & Bond Trading Cycle, Equities & Equity Trade Cycle, Derivatives (Options & Futures), Portfolio Management, Wealth Management, and Sales & Marketing.
• Responsible for developing and supporting requirements for service flow of Corporate Actions, Corporate Actions Response, Currency, Free Movement, Mutual Fund Order & Execution, Non-Financial Transactions and Trading Operational Processing in Comerica's global wealth management platform.
• Conducted User Interviews and Work Shops to gather and discuss accurate Business Requirements.
• Served as a liaison between the business team and the technical team by identifying, understanding, and documenting their needs.
• Assisted in identifying and quantifying Credit Risk, Operational Risk and Market Risk.
• Analyzed requirements utilizing various methods. (e.g. sample data from SQL queries, screen shots, reports, prototype screens, sourcing information, and other data models).
• Assisted in splitting large user stories (Features, Epics) into smaller user stories using different techniques.
• Collected information and requirements about different Entities and attributes from FDS.
• Completed GAP Analysis in detail on all entities in CCL using Business Process Diagram.
• Designed and developed Use Case Diagrams, Activity Diagrams, and Sequence Diagrams, Class Diagrams and Webpage Mock-Ups using MS Visio and Balsamiq tools.
• Facilitated and managed requirements walkthrough sessions across various business areas including Mortgage Servicing, Loan Monitoring and Asset Management.
• Developed and implemented processes and tools for requirements gathering, analysis, planning, tracking and delivery.
• Designed and developed project document templates based on SDLC methodology.
• Assisted Project Managers on several project management artifacts.
• Collaborated with the QA team to ensure adequate testing of software both before and after completion, maintained quality procedures, and ensured that appropriate documentation was in place.
• Prepared questionnaire based on the System Analysis Performed for all entities.
• Conducted extensive Joint Application Development (JAD) sessions for all business-related issues.

Environment: Fidelity IMPACS, Fidelity Savings Time, Fidelity Finance Management, JCL, SQL, Agile, MS Office Suite, MS SharePoint.

Sr. Business Analyst

Confidential, Dallas, TX

• Assisted Project Manager in creating Work Breakdown Structure and Project Charter using MS Project.
• Conducted extensive GAP Analysis by identifying AS-IS and TO-BE process models and process flows, where, how and how big the GAP to in turn help product owner to plan how to bridge the gap.
• Elicited requirements involving vast set of interactions with various stakeholders using JAD Sessions, Structured Interviews, Process Analysis and Business Rules Analysis.
• Analyzed feasibility of Business Requirements and defined scope, found out dependencies by interacting with Management Business Analysts, Subject Matter Experts, Product Owner, Project Manager and Technical Lead.
• Created a Macro Document incorporating components of Business Requirement Document and System Requirement Specification incorporating Business, Functional, Non-Functional, Data and GUI Requirements which would in turn serve as the centerpiece of the project.
• Created Use Case Diagrams and Use Case Narratives and incorporated them in Macro Document.
• Created User Stories and led the Planning Poker game to estimate them in Sprint Planning and Backlog Grooming meetings.
• Helped product owner in prioritization of Product Backlog Items (PBIs) including the process of breaking down EPICS into User Stories using INVEST criteria.
• Facilitated and time-boxed Scrum ceremonies. Helped negotiating commitments and assured parallel understanding of requirements and deliverables amongst all Stakeholders in Sprint Planning Meetings.
• Performed extensive prototyping using Mock-Up Screens.
• Handled requirement churn during the project by performing Impact Analysis.
• Checking the feasibility of Change in Requirement and maintaining the triple constraint.
• Used JIRA for allotting tasks, User Story Writing, Backlog Management, Issue Tracking, User Story Management and Forward/Backward Requirement Traceability.
• Created Spotfire Visualization and dashboards using Spotfire Professional.
• Analyzed using Spotfire Professional and provided recommendations to the product owner over the use of Business Intelligence (BI) tools.
• Created Structured Query Language (SQL) Queries for Portfolio Drill Downs to pull-out necessary data from the data sources.
• Created environment for self-organization and organized team engagement activities.
• Worked on service oriented architecture (SOA), REST, SOAP, XML, API.
• Created training curriculum and wrote training scripts.

Environment: Waterfall-Scrum Hybrid, MS Visio, Mock-Up Screens, MS Word, MS Excel, MS PowerPoint, JIRA 5.2, MS SQL Server, MS Project, Spotfire Professional, JAVASCRIPT CSS, AJAX, HTML, Java, Spring Framework 4.2.0.

Sr. Business Analyst

Confidential, Dallas, TX

• Analyzed User Requirement Document, Business Requirement Document (BRD), Technical Requirement Specification and Functional Requirement Specification (FRS).
• Implemented and integrated RUP solutions with complete line of traceability for all the artifacts of web development projects.
• Involved in requirement gathering including interviews, brainstorms and meetings with stakeholders and created requirement specification artifacts.
• Designed and implemented a data access layer to communicate with various services via Web services Access Gateway based on XML SOAP protocol.
• Created hash tables used for referential integrity and/or otherwise while transforming the data representing valid information. Used Query Analyzer, Execution Plan to optimize SQL Queries
• Followed the UML based methods using MS Visio to create Use Cases Diagrams, Activity Diagrams, State Chart Diagrams, Sequence Diagrams and Collaboration Diagrams.
• Developed Use Cases and Functional Specifications and provided UML Diagrams.
• Gathered requirements from JAD/JAR sections with developers and business clients.
• Developed Use Case Models using Rational Rose to depict Actor and Use Cases in various business processes and identification of basic/alternative flows and definition of preconditions and post conditions of the system.
• Performed GAP Analysis between source and target data elements and executed reports for different module such as Escrow, Fair Market Value, Real Estate Owned, Repurchases, Interest Income, Amortization, Home Equity line of Credit and Remittances.
• Worked with ETL team during the upload process.
• Designed and developed Quality Assurance standards and processes to all levels of project team.
• Performed GAP Analysis for the modules in production, Conducted Feasibility study and performed Impact Analysis for proposed enhancements.
• Verified the functional aspect as per the Business Process and validated interface with other systems and data conversion from the legacy system.
• Performed basic sanity testing via navigation and workflow of the application.
• Created PAD's in conjunction with System's architect to baseline system performance.
• Maintained and kept track of stakeholder's request for enhancements and changes using Unified Change Management Tool (UCM) such as Rational ClearQuest.

Environment: Visio, Win Runner, Test Director, J2EE, Excel, MS Project, MS Office, Lotus Notes Scripts, ODBC, LSX Team Studio, Sametime VB Script, PL/SQL DHTML, Windows NT/2000/XP, SQL Server/Oracle, ROMP, MS Access.

Business Analyst

Confidential, Allentown, PA

• Involved in all phases of the Software Development Life Cycle. Followed the RUP (Rational Unified Process) methodology for elicitation and representation of requirements.
• Contributed in defining the scope of the project and defined Functional Specifications.
• Analyzed and documented the System Specifications, Business Requirements; used the tool DOORS for documenting, tracking and analyzing the requirements.
• Used DOORS to link requirements to Test Cases, Business Rules, and Design Items to maintain traceability.
• Involved in the design of BRD, FRD, Use Case Diagrams and Activity Diagrams using MS Visio.
• Involved in gathering the requirement with the SMEs to get the maximum information about the work-stream including Mortgage Servicing, Loan Monitoring, and Asset Management.
• Used SQL to query the database and performed data analysis.
• Responsible for numerous decisions in respect to business policies, procedures, methods for implementation.
• Identified and resolved (or maintain accountability for ensuring the resolution of) issues identified during all phases of projects.
• Used UML to produce Use Cases, Use Case Diagrams and Activity Diagrams to explain Process Flows and Functional Specifications.
• Involved in identification of business rules, business and system process flows, user administration, requirements and assumptions.
• Regularly interacted with onshore and offshore teams to communicate requirements and review Test Cases and Test Plans.
• Worked closely with QA and Developers to clarify/understand functionality, resolve issues and provided feedback to nail down the bugs.

Environment: Windows XP, Oracle/SQL Server 2000, SQL, Telelogic DOORS 8.1, Telelogic System Architect 10.6, Mercury Quality Center, RUP, UML, MS Visio, MS PowerPoint.

Business Analyst

Confidential, Charlotte, NC

• Chaired Requirement Gathering Sessions (RGS), Joint Application Development (JAD) Sessions and Joint Application Requirement (JAR) Sessions.
• Gathered business and system requirements for developing application on handling HSBC's debit card reconciliation.
• Conducted Gap Analysis and created an AS-IS workflow to better understand the mechanics of the existing system.
• Generated reports as per Ad-hoc request from the client through Data Extraction, Data Mapping, Transformation, and loading through by using Informatica Tool.
• Worked closely with Client Services/Finance/Fraud & Risk team to gather requirements for designing the Data Warehouse model.
• Designed and implemented data warehouse architecture for corporate circulation data warehouse.
• Created Drill-down and Sub-Report using SSRS. Monitored the performance of the reports.
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
• Generated context filters and data source filters while handling huge volume of data.
• Delivered Data Flow Diagrams and Database Normalization Theory Techniques.
• Coordinated with QA team for Test Planning and Design & creation of traceability matrix for ensuring the consistency of test cases with the business requirements.
• Worked with Solution Architect team for establishing batch framework and scheduling.
• Delivered High-Level and Low-Level Requirements Documents, Functional Specification Documents and Test Plans.
• Maintained version control for documents through SharePoint.
• Prepared GAP Analysis Document to display current and future business process with MS Visio.
• Developed BRD's for enhancement requests from internal Stakeholders.
• Worked with various departments in preparing their Current State Process, gathered Business Requirements & Functional Requirements
• Prepared the support plan and engaged the Stakeholders in all of SDLC phases for their inputs and validations for data.

Environment: Agile, SharePoint, MS Visio, Azure, Informatica, MS Project, Rational CQ.

Business Analyst

Confidential, Charlotte, NC

• Conducted JAD sessions between the End Users and the Development Team.
• Worked with the Software Architects and Developers to ensure that the applications confirm to customer requirements.
• Used Rational Unified Process (RUP) for streamlining the team's development activities.
• Analyzed current formats for reporting Accounts Payable, Accounts Receivable and Reconciliation towards using some of the necessary fields in the new format too.
• Used MS Visio to create Wireframes.
• Gathered user requirements and directed developers for practical deliverables.
• Used the Agile (Scrum) methodology to carry out every step of the business modeling process.
• Created reports which forecasted numbers automatically from historical numbers using both trend analysis and data regression techniques.
• Followed the UML based methods using Rational Rose to create Use Cases, Activity Diagrams, State Chart Diagrams, Sequence Diagrams, and Collaboration Diagrams.
• Participated in testing and evaluation of projects at established integration points to assess progress and identify key functionality issues.
• Tracked UAT issues/bugs and prepared reports.
• Performed job of contact point for all Stakeholders (business, legal, compliance, development).
• Took approvals from Business Owners for business requirements.
• Documented monthly status reports for enhancement and modification requests for the development team to assist them in efficient tracking and monitoring of open issues of the project.

Environment: Rational Rose, ClearCase, ClearQuest, Visio, MS Project, Visual Studio .NET, SQL Server.