SUMMARY:

• Business Systems Analyst professional with over 8 years of extensive experience in requirements gathering, Analysis and Communication with SME, Stakeholders (technical, non - technical), business process analysis, Solution Assessment & Validation, documenting project artifacts and Testing/Maintenance operations.
• Expertise in creating project artifacts such as Business Requirements Document, Use Case Documentation, Requirements Traceability Matrix, Business Rules Spreadsheet, Functional Requirements Document (FRD), Data Mapping Document, Systems Requirements Specification (SRS) and GUI Mockup Screens.
• Excellent domain knowledge and experience in Finance (Mortgage, Loan Origination), Online banking/web applications, E-Commerce, Inventory Management.
• Experience in analyzing the business requirements for Enterprise Resource Planning (ERP) software and coordinating with the ERP development team to manage purchase, shipping, marketing, and inventory.
• Proficiency in leading/conducting Requirements gathering processes and techniques using different elicitation methods such as client interviewing, requirements workshops, Interface Analysis, Prototyping, Survey/Questionnaire, Focus groups, job shadowing, document analysis, Observations.
• Conducting Joint Application Development (JAD) sessions for deriving functional/non-functional requirements.
• Extensive experience in Business Process Modeling using Visual modeling tools with professional expertise in MS Visio, IBM Rational Rose, Adobe Photoshop, Adobe Illustrator, Corel Draw 12
• Experience in conducting GAP, Impact, SWOT, SIPOC, Cause & effect analysis, Root cause, Cost-benefit analysis, Feasibility studies, Risk analysis, ROI analysis tools and techniques.
• Extensive experience in UML Modeling like Activity Diagrams, Sequence Diagrams, Use case Diagrams, Process work Flow Diagrams, Interaction overview Diagrams, Timing Diagrams and Class Diagrams.
• Experience in conversion of business process functionality into System Requirement Specifications.
• Professional experience in all phases and methodologies of System Development Life Cycle (SDLC) including Waterfall, Agile/Scrum, RUP with over 5 years of Scrum Master Experience.
• Professional expertise in working with multiple teams on different levels of Scaled Agile Frameworks (SAFe model)
• Facilitation of Scrum Ceremonies and adoption of agile related techniques (MOSCOW technique, Planning Poker)
• Mastery in the use of Agile/Scrum related tools such as JIRA Greenhopper, Rally to document and visualize stories, tasks, and measure performance through burn down charts/velocity charts
• Extensive implementation Knowledge of Databases, Data Table Structures, Data Warehousing, Schemas, Data Marts, Data Entity Relationships and OLAP operations like rollup, drill down, slicing/dicing, using BI tools.
• Proficiency of business Intelligence reporting using SQL Server services like SSRS, SSIS, SSAS
• Knowledge in SQL Querying and expertise in generating DDL, DML and DRL queries in SQL.
• Excellent skills in analysis, design, development, and implementation of ETL and reporting components.
• Involvement in Data /dimensional Modeling, Data Extraction/ Transformation/ Loading (ETL) and Business Intelligence Reporting using Tableau Desktop 8.2, IBM Cognos, Informatica Power Center.
• Coordinated with architects in various architectural designs such as conceptual designs and logical designs.
• Extensively interacted with the designers, developers to ensure functional implementation of business requirements and the QA Team in executing Test Plans & Test Case scenarios, Test Logs, Test Objectives.
• Knowledge and experience in conducting User Acceptance Testing (UAT) and the creation of Dummy Data.
• Excellent communication, problem-solving, Public Speaking, critical thinking, conflict resolution, facilitation, and documentation skills
• A Proactive and dedicated team player, with a proven track record in producing high quality work under tight deadlines and in multi-tasking to meet business goals

TECHNICAL SKILLS:

Modeling Tools: Rational RequisitePro, HPALM,UML, MS Visio, BPMN, Rational Rose, Rational Clear Case, Adobe Photoshop CS3, Corel Draw 12, Adobe Illustrator

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

Database: MS SQL Server 2012/2008/2005, My SQL Work bench V5.2, MS AccessBI Reporting Tools: Tableau, Tableau Desktop 8.2, 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 Greenhopper, HP Load Runner, MS Test Manager 2013

Documentation Tools: MS Office Suite, SharePoint 2010/2013

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

Finance: Mortgage Loans, Mortgage Backed Securities, E-Commerce (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, Warren NJ

Sr. Business Systems Analyst

Responsibilities:

• Elicitation of Functional/non-functional requirements and Conducting the functional requirements/ user requirement specification reviews and walkthroughs with designers, developers, SME’s and stakeholders
• Worked closely with end-users and stakeholders to develop a detailed understanding of the requirements and prepared comprehensive set of documents to define the specifications and business value of the systems and delivered them in the Business Requirements Document and the Functional Requirements Document
• Facilitated JAD sessions with technical/non-technical team, SME’s to clarify business rules & solve impediments.
• Performed GAP analysis to further identify deltas between the COTS application used and the desired state
• Developed solid documentation by analyzing current processes and design business processes modeling notification (BPMN) utilizing UML for object oriented design and documentation utilizing MS Visio, Adobe Photoshop
• Responsible for identifying gaps in the software between core functionality and user defined requirements. Created Process Flow diagrams, Use Case Diagrams and Class Diagrams using Microsoft Visio and Rational Rose.
• Defined and suggested SOAP, XML based web services and application programming interfaces(API’s) such as (C++, JAVA) compatible with the “as-is” and “to-be” state
• Designed and delivered Data Mapping Documents, Data Transformation rules and maintained Data Dictionary.
• Performed data modeling by creating logical and physical models using Erwin.
• Performed SWOT analysis to identify project strengths, weaknesses, opportunities and threats.
• Performed data analysis and data validation and wrote SQL queries to generate certain requirements and KPI’s
• Used HPALM for updating the status of all the Test Cases & Test Scripts that are executed during testing process.
• Provided estimate on change request for analysis, development and testing.
• Used HP Load runner for heavy user testing with assistance of VuGen to manage and coordinate the process
• Manual testing for checking the data flow of the application using SQL.
• Actively trained business users involved in User Acceptance Testing (UAT) and helped them understand UAT procedure

Environment: Waterfall/Scrum, Windows 98/XP/7/Vista/8, MS Office Suite, XML, SOAP, C++, MS Project, MS Visio, UML, Adobe Photoshop, SharePoint 2013, SQL Server Services, Tableau, Mockup Screens.

Confidential, St. Louis, MO

Sr. Business Analyst

Responsibilities:

• Gained insight about the structure, Business model, and current process workflow of the organization from existing artifacts.
• Performed requirements gathering using both formal and informal sessions through interviews, questionnaire, video conferencing, JAD sessions and conference calls.
• Analyzed, defined, documented and communicated business requirements to technical architects, developers by interacting with the end customers to meet business partner’s needs.
• Participated in various meetings/discussions, with Product Manager, SME, Lead Business Analyst, and Project Manager, to discuss and consolidate the business requirements, and clarify business rules further.
• Involved in identifying the problem definition as part of continuous process improvement using Define, Measure, Analyze and Improve to support the business continuity of the organization.
• Implemented Unified Modeling Language (UML) to prepare Use Cases diagrams, process flow diagrams, sequence diagrams from the gathered requirements and created diagrams using MS Visio, Adobe Illustrator
• Facilitated creation of “as-is” and “to-be” business Process Flow using Rational rose/MS Visio.
• Created Business Requirement Document (BRD), Systems Requirement Document (SRD).
• Successfully documented functional/ non-functional requirements and identified issues and assumptions to be made
• Created use cases, user stories, product documentation, user manuals and developed mockup screens to communicate GUI design with web app developers and help them clarify functional and non-functional requirements
• As a scrum master coordinated with the Product owner in prioritizing the user stories in the product backlog.
• Tracked the performance and progress of each sprint cycle with burn down chart identified burn down velocity
• Facilitated the Daily Scrum Meeting, Sprint Plan, Sprint Review & retrospective meetings at the beginning and end of each sprint cycle and used Sprint Burn-Down Charts and Velocity Charts to track progress
• Lead the daily scrum meetings and identified the impediments faced by team members, tracked sprint cycle progress and updated competed tasks on a day to day basis.
• Communicated the feedback by other stakeholders, SME’s from scrum framework meetings to the scrum team.
• Coordinated with Project Manager to create the Work break down structure (WBS), manage schedules, deadlines, resource allocation and the project tasks using MS Project.
• Participated in solution design sessions with the leads, designers, subject matter experts and developers.
• Involved in defining project specifications, implementation plan, user acceptance and functional testing.
• Responsible for identifying issues through feasibility, SWOT analysis and recommending changes in the application.
• Created consolidated status reports for the client and demonstrated the changes made.
• Conducted Business/technical Impact analysis to cater change requests made by the stakeholders.

Environment: waterfall/Agile/scrum, Windows 98/XP/7/Vista/8, MS Office Suite, Adobe Illustrator, XML, SOAP, MS Project, Visio, UML, SharePoint 2010, Mockup Screens, HPQC, Rational Requisite Pro, SQL/ SQL Server Services.

Confidential

Sr. Business Systems Analyst/ Scrum Master

Responsibilities:

• Involved in identifying the problem definition as part of continuous process improvement using Define, Measure, Analyze and Improve to support the business continuity of the organization.
• Gathered business requirements using appropriate elicitation techniques like Observations, brainstorming, client interviewing and document analysis, conducting JAD Sessions with various stakeholders and the project team.
• Established Requirements Traceability Matrix (RTM) to trace the completeness of requirements
• Developed high-level and low-level documents like Business requirements documents (BRD), Functional requirements documents (FRD) and System requirements specification (SRS).
• Conducted Business workflow analysis, process analysis, SWOT analysis, cost-benefit analysis and Gap analysis to know the condition of the current system in use and feasibility studies to decide necessary increments.
• Used Unified Modeling Language (UML) to prepare Use Cases diagrams, process flow diagrams, sequence diagrams from the gathered requirements and created diagrams using MS Visio, Rational Rose
• As a scrum master coordinated with the Product owner in prioritizing the user stories in the product backlog, facilitated the daily scrum meeting, sprint plan & review meetings at the beginning and end of each sprint cycle.
• Generated Burn down chart and velocity charts to track performance and the status of each sprint cycle.
• Handled the Credit/Debit Activities of the clients and inventory management using XML based web services.
• Performed Data Analysis and Data Visualization using BI tools such as Tableau Desktop 8.2& Tableau Server
• Used ER Diagrams, Class Diagrams and data flow diagrams to define Data Mapping parameters of the system
• Create logical and Physical data model for application database and Analytics data mart in big data.
• Coordinated with the Project Manager to create Work Break down Structure (WBS), manage schedules, deadlines, resources and the project tasks using MS Project.
• Involved in Project Management activities like defining / managing project scope, schedule management,
• Creating project plans, tracking and communicating project status, deliverables, and milestones.
• Maintained Data Requirement Artifact to identify the characteristic of data type that is entered into the GUI interface
• Coordinated with architects to create test plans &Test cases for system testing using different testing techniques.
• Developed and conducted the schedules, user manuals, UAT and trained the business/end users.

Environment: Waterfall/Agile/scrum, Windows (98/XP/7/Vista/8), MS Office Suite, MS Project 2010, Visio, Rational Rose, UML, SharePoint 2010, Tableau Desktop 8.2, Tableau Server, SQL, HTML, XML, Mockup Screen, HPALM, HPQC,SQL server services.

Confidential

Jr. Business Analyst

Responsibilities:

• Gathered Requirements Via formal meetings, brainstorming, interviewing and conducting JAD sessions with designers, developers, business users and subject matter experts (SME’s).
• Analyzed and documented the “as-is” and “to be” business process work flow in UML using MS Visio.
• Conducted Gap analysis of the current state of the system and future state of the system, SWOT analysis to identify the areas of improvement and a feasibility analysis of the proposed enhancements.
• Performed Requirements modeling and visualization using UML diagrams such as sequence diagrams, state diagrams, use case diagrams, Activity diagrams, data flow charts.
• Generated Mockup screens of Graphical user interface to capture the front end system requirements and to communicate them with the web application designers in order to further clarify functional requirements.
• Documented various project artifacts, Business Requirements document(BRD), Systems requirements specifications (SRS) including Functional and non-functional requirements, Use case document
• Developed system specifications as needed to support reporting, policy and claims systems.
• Involved in Process Management to enable the activities of planning and monitoring performances of a process.
• Coordinated with database administrators/ SQL developers in improving backend performance by participating in conceptual re-design and logical redesign of the existing database.
• Involved with Database Designers in facilitating creation of ER Diagrams, class diagrams, Data flow diagrams
• Prepared test cases and test scenarios and coordinated with other QA’s in executing the test plans.
• Involved in Project management planning activities of this project Scope management, creating work break down structure, schedule management, stakeholder management using MS Project professional tool
• Communicated directly with Clients to understand their business needs and to resolve business issues.
• This application was developed using Visual Studio.NET, VB.NET and ASP.NET.
• Conducted User Acceptance testing (UAT), beta testing and involved in code review sessions to ensure that the functionality of system aligned with the business requirements specified in the BRD.
• Worked with SQL queries to extract application data to perform application validations.

Environment: .Net Framework (VB.NET, ASP.NET), MS Visio, Rational Requisitepro, HPQC, SQL / SQL Server, MSOffice suite, MS Project Professional, Mockup screens, HTML, XML.

Confidential

Business Analyst

Responsibilities:

• Executed Software Development Life (SDLC) cycle from inception to deployment with regards to testing (Requirement Analysis, Test Planning, Test Cases, Script Development, Test Execution, Test Reporting, Test Result Analysis User Acceptance Testing and Defect Retesting)
• Developed complex SQL scripts to validate data integrity in the application, using DML and DDL commands.
• Used JIRA to track and follow-up on defects with the QA and developers in different builds.
• Participated in Requirement Review Meeting with Business, Development Team Manager and SMEs. Worked closely with the end users and technical team to ensure best practices in testing methodologies.
• Assisted Sr. QA Manager in conducting sessions with testing team to resolve open incidents and issues.
• Create Test Cases to conduct White Box Testing, Positive and Negative Testing of the application.
• Conducted Business/Technical Impact analysis for change requests and requirement walkthroughs and advised concerned Project Managers and Business System Analysts on the impacts of the changes.
• Wrote detailed Test Plans, Test cases, Test Scripts, specifying the step by step navigation, data input, and expected results, for Load Testing and other testing types and mechanisms like (regression, stress, and ad-hoc).
• Logged system defects in Rational Clear Quest and tracked the issues identified during Functional Testing.
• Assisted Lead Business Analyst in the creation of Use Case Diagrams, Process Flow Diagrams and GUI designs using UML modeling, Mock up screen designing tools such as Rational Rose, Adobe Photoshop.
• Participated in brainstorming sessions on Quality Analysis, Manual/Automated Testing and defect tracking.
• Gathered functional requirements and created vision, scope, and other artifacts during the inception phase.
• Participated in Business Requirement Definition (BRD) workshops along with clients and Subject Matter Experts.

Environment: SDLC, SQL, My SQL Work bench, UML, MS Visio, XML, HTML, Windows (98/XP service pack 2,3/vista/7/8), MS Office, MS Project, Rational Clear Case/ Clear Quest,, JIRA, IBM Rational Rose, Adobe Photoshop.

Confidential

Business Analyst

Responsibilities:

• Created Use Case Diagrams, Class Diagrams and Interaction Diagrams using MS Visio and Rational Rose.
• Prepared Process Flow Diagrams, Mockup screens and conducted Gap Analysis to compare the current state and proposed functionalities of the desired state using tools such as Corel Draw, Adobe Illustrator.
• Designed Meeting Work Plan and facilitated virtual project meetings to validate requirements with the concerned Subject Matter Experts (SMEs) and IT Team during the entire project.
• Reviewed test results and prepared Test Scenarios and for Performance, Usability, and Regression Testing.
• Conducted Joint Application Development (JAD), RAD and Interview sessions with the management and users to gather and communicate business requirements and understand the problems and challenges.
• Developed Business Case Document highlighting the need for a new system and its impact on the project scope.
• Conducted requirements gathering sessions with the business user to collect Business Requirements, Data Requirements, Non-Functional Requirements and User Interface Requirements.
• Managed UAT Testing; developed and reviewed QA Test Strategies and Test Plans for appropriate test coverage.
• Incorporated Rational Unified Process (RUP) to create Business Requirement Specifications using MS Visio.
• Analyzed and mapped the as-Is business processes, compared them to the To-Be state to define the Gap, and then created new Process Flow Diagrams using Unified modeling language (UML)

Environment: MS SharePoint 2007, MS Visio, MS Project, Rational Rose, Rational Requisite Pro, Windows 2000/XP, MS Visual Studio 2008, MS SQL Server R2, UML, Agile, RUP, Oracle 10g.