SUMMARY

• Business system analyst, over 8+ years of industry in the domain of Finance Service Industry like Mortgages, Investment Proposal, ‘Banking and management’, E - commerce, Insurance and Data Warehousing. Have good understanding of gathering Business Requirements, Business Process flow, and Business Process Modeling.
• Certified Scrum Master (CSM) wif 3 years of proven ability to work wif self-organizing and cross-functional teams in a wide spectrum of Portfolio, Mortgages and financial sectors. Have hands on Experience on Waterfall, Agile Scrum and Hybrid of Waterfall and Agile methodologies.
• Extensive experience in Business process re-engineering, business process improvements, Data Reports Analysis accompanied by active participation in discovery sessions, interviews, prototyping, document-reviews, plan setup, plan configuration wif customers.
• Experience in conducting GAP and impact analysis of AS-IS and TO-BE systems, SWOT analysis, Feasibility study, Cost benefit analysis, Risk Analysis and ROI analysis.
• Have extensive experience wif the entire Software Development Life Cycle (SDLC) dat included Requirement Elicitation, Gathering, Analysis, Design & Development and change management.
• Extensive experience in requirements gathering, Analysis and Communication wif SME’s, Stakeholders (technical, non-technical), business process analysis, Solution Assessment & Validation, documenting project artifacts and Testing/Maintenance operations.
• Proficiency in gathering SMART (Specific, Measurable, Attainable, Realistic, Timely) requirements and transforming them into functional specifications focusing on workflow/user interface analysis and design.
• Expertise in creating project artifacts such as Business Requirements Document (BRD), Use Case Documentation, Requirements Traceability Matrix (RTM), Business Rules Spreadsheet, Functional Requirements Document (FRD), Data Mapping Document, Systems Requirements Specification (SRS) and GUI Mockup Screens.
• Extensive experience in Business Process Modeling using Visual modeling tools wif professional expertise in MS Visio, IBM Rational Rose.
• Extensive experience in UML Modeling like Activity Diagrams, Sequence Diagrams, Use Case Diagrams, Process Work Flow Diagrams, Timing Diagrams and Class Diagrams.
• Good knowledge of database relationships and concepts; worked on RDBMS like MySQL and MS SQL server.
• Excellent skills in analysis, design, development and implementation of ETL tools like Informatica Power-Center, SSIS and reporting tools like Tableau, Qlikview, IBM Cognos and SSRS.
• Skilled wif Data Analysis concepts of Data Modeling, Data Dictionary, Data Mapping and Normalization.
• Good Understanding and hands on experience in creating Entity Relationship Diagrams (ERDs).
• Organized and facilitated Joint Application Design (JAD) sessions & interviews, brainstorming sessions, questionnaire, focus group, implementation requirements, project status report and resolving issues/conflicts.
• Comprehensive understanding of Web-Services like WSDL, SOAP using XML and REST using internet protocol suite like HTTP under Three-Tier Architecture and Service Oriented Architecture (SOA).
• Comprehensive knowledge of web services related concepts such as XML, WSDL, HTML, Ajax, SOA, API and Web Architecture. Comprehensive knowledge of business engines and XML schemas.
• Experienced in writing User stories and handling the Requirement Churn by conducting impact and Risk analysis
• Proven expertise and experience in handling and conducting various Scrum Ceremonies like Sprint Planning meeting, Daily scrum meeting, sprint retrospective meeting, Sprint review meeting and backlog refinement meeting and adoption of agile related techniques (MOSCOW technique, Planning Poker)
• Efficient in performing, prioritizing and using techniques such as Panning Poker, Moscow and T-Shirt Sizing.
• Mastery in the use of Agile/Scrum related tools such as JIRA Greenhopper, VersionOne Rally to document and visualizes stories, tasks, and measure performance through burn down charts/velocity charts.
• Documented and created Test Plans, Test scenarios, Test Objectives, Test Cases, Test Logs and Run Books. Experience in conducting User Acceptance Testing (UAT) and verified performance, reliability and fault tolerance issues.
• Experience wif ClearCase for repository management, ClearQuest for change management and handling change requests and proposals to Change Control Boards (CCBs).
• Highly motivated team player wif excellent communication, presentation and interpersonal skills, always willing to work in challenging and cross-platform environment.
• A proactive and dedicated team player, wif proven track record in producing high quality work under tight deadlines and multi-tasking to meet business goals. Experience in scheduling meetings, negotiating and co-ordination wif Developers, Application Architects, Subject Matter Experts, business users and senior executives.

TECHNICAL SKILLS

Business Modeling Tools: Rational Requisite Pro, HPALM,UML, MS Visio, BPMN, Rational Rose, Rational Clear Case, Adobe Photoshop CS3, Adobe Illustrator.

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

Requirement Management: MS Office, JIRA, RALLY, Confluence, HP ALM 11.5 and Rational Rose

Database: MS SQL Server 2012/2008/2005 , My SQL Work bench V5.2, MS Access

BI 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), Micro strategy reporting system, Spotfire, Qlikview, Simio, Minitab, Precision Tree 6, Marketing Engineering

Programming Languages (Exposure): Asp.net, Java, JavaScript, Ajax, .net, C++, C#, Python

ETL Tools: Data stage, Informatica, IBM Cognos, IBM Infosphere, Infosphere Information Services

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 MiningSlicing/dicing, Drill Down/Roll Up, MDM

Languages: HTML, CSS, XML, SQL

Project Management Tools: MS Project professional, MS Project Server, MS SharePoint 2010SharePoint Designer, JIRA, RALLY, Version one

Finance: Mortgage Loans, portfolio management (Derivatives, Bonds, Mutual Funds, Equities, Fixed Income, securities, foreign exchange, SweepsSwaps, Pricing, Brokerage, Stocks, and Bloomberg Data).

PROFESSIONAL EXPERIENCE

Confidential, Columbus-OH

Sr. Business system Analyst/Scrum Master

Responsibilities:

• Involved Pre-analysis and conducted feasibility study, Cost-Benefit and Risk analysis.
• Generated a streamline process to understand the various steps in the Home loan lifecycle and desired functionality of the new system by interacting wif users, management, SME (Subject Matter Expert), stakeholders, lenders, underwriters.
• Interviewed business users to gather requirements and analyzed the feasibility of their needs by coordinating wif the project manager and technical lead.
• Identified, researched, investigated, analyzed, defined opportunities for business process improvement, documented business processes and initiated efforts to make improvements.
• Contributed to the definition of scope, performed extensive requirement analysis and defined functional specifications.
• Elicitation of Functional/non-functional requirements and Conducting the functional requirements/user requirement specification reviews and walkthroughs wif designers, developers, SME’s and stakeholders.
• Worked closely wif 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.
• Facilitated JAD sessions wif technical/non-technical team, SME’s to clarify business rules & solve impediments.
• Performed GAP analysis to further identify deltas between legacy and new application.
• Facilitated in incorporating Content Management system(CMS)
• 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.
• Responsible for identifying and documenting business rules and creating detailed diagrams including Use Cases, Use Case diagrams, Business Flow diagram, Creating process models, Data flow diagrams.
• As a Scrum Master me facilitated Scrum events including Backlog refinement, Sprint Planning, Stand up meeting, Sprint Review and Sprint Retrospective.
• Highly proficient in writing and prioritizing user stories in Product Back Log wif Product Owner.
• Proven experience in identifying epics and breaking them down into smaller User Stories
• Analyzed the Iteration Burn Down charts and reviewed defects.
• As experienced Scrum Master anticipated and removed Impediments from project team’s path and pushed them to deliver quality results based on schedule.
• Coached and mentored team to adopt agile practices, adopted agile games (Coin game, chair game, marshmallow challenge, ball game) and various practices to ensure team understand agile practices and values.
• Used JIRA for issue tracking, user stories management and requirement traceability.
• Assist wif User Acceptance Testing, developing and maintaining quality procedures, and ensure dat appropriate documentation is in place. Assisted in Black box, UAT and Regression testing.
• Assisted the project manager to construct a project plan dat included Project Schedules, Milestones tracking, and Meeting minutes using MS Project.

Environment: Waterfall/Scrum, Windows 98/XP/7/Vista/8, MS Office Suite (Word, PowerPoint, Excel, Outlook), MS Project, Visio, UML, SharePoint 2013, Java, JavaScript, SQLServer Services, Tableau, JIRA, Mockup Screens.

Confidential, Smithfield-RI

Sr Business system Analyst/Scrum Master

Responsibilities:

• Understood SEC, FINRA, DODD FRANK ACT rules and regulations.
• 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 wif the end customers to meet business partner’s needs.
• Participated in various meetings/discussions, wif Product Owner, SME, Lead Business Analyst, and Project Manager, to discuss and consolidate the business requirements.
• Assisted wif evaluation, customization and system integration. Conducted GAP analysis around the identification of business rules, business and system process flows, user administration, requirements and assumptions.
• Analyzed problems, including automated and manual business process flows, and identified, researched and investigated, defined and documents business processes.
• Facilitated JAD sessions wif tech leads, development team and QA team.
• 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.
• Used mockup screens to convey the look and feel of the GUI screens for the end users to developers.
• Extensively interacted wif data analysts during the ETL operations in identifying the source files/databases from OLTP systems and implementing the transformation logic.
• As a scrum master coordinated wif the Product owner in prioritizing the user stories in the product backlog and breaking Epics into smaller user stories.
• Tracked the performance and progress of each sprint cycle wif burn down chart identified burn down velocity
• Facilitated the sprint plan, daily scrum meeting & retrospective meetings in each sprint cycle and removed Impediments as and when they are raised.
• Lead the daily scrum meetings and identified the impediments faced by team members and updating competed tasks
• Communicated the feedback by other stakeholders from scrum framework meetings to the scrum team.
• Coordinated wif Project Manager to create Work break down structure (WBS), manage schedules, deadlines, resources and the project tasks using MS Project.
• Documented Test Plans, Test Scripts, Log Defects, and Requirements and uploaded to HP Quality Center for future follow up and bug fixing purposes.
• Coordinated the execution of Unit Testing, System Integration Testing (SIT), Performance & Service level testing and User Acceptance Testing (UAT).
• Successfully established Key performance indicators (KPI) for the performance measurement in a specific functional area of the organization.

Environment: Waterfall/Scrum, Windows 98/XP/7/Vista/8, MS Office Suite (Word, PowerPoint, Excel, Outlook), MS Project, Visio, UML, SharePoint 2013, Asp.net, C#, SQL Server Services, Tableau, Informatica, Mockup Screens, Rally

Confidential, Tampa-FL

Business system Analyst

Responsibilities:

• Understood Consumer Protection Financial Bureau (CPFB) and FHA rules.
• 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.
• Acted as a liaison between management and Data Warehouse development team.
• Extensively interacted wif data analysts during the ETL operations in identifying the source files/databases from OLTP systems and implementing the transformation logic for achieving data uniformity in operational data store (ODS).
• Facilitated JAD sessions wif various stakeholders and project team to discuss about various topics related to the project.
• Coordinated wif the DW architects and developers to identify appropriate dimensional modelling (identifying dimensions/facts/referential integrity) and Data Modelling measures (additive/semi-additive/non additive), and sizing (in terms of number of columns, records per dimension and fact table).
• Gathered business requirements using appropriate elicitation techniques like user observation, brainstorming, client interviewing and document analysis.
• Used Mockup screens to convey the look and feel of the GUI screens.
• Successfully analyzed the functional/non-functional requirements of the data warehouse for generating BI reports and communicated the same wif architectures and developers.
• Involved in identifying and suggested the different dimensions (slowly changing dimensions/rapidly changing dimensions) required for generating the reports and OLAP cubes to facilitate the multi-dimensional view of the data to generate slicing/dicing, roll-up/drill-down reports.
• Established Requirements Traceability Matrix (RTM) using Rational Requisite Pro to trace the completeness of requirements.
• Developed high-level and low-level documents like Business requirements documents (BRD), Functional requirements documents (FRD) and assisted in creating 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.
• Used various SQL commands like Create, Delete, Update, and Inner, Outer, Left, and Right joins to update the database and retrieve data for data analysis and validation. Assisted Data analysts in Data Modelling.
• 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.
• Excellent experience in design and development of data warehousing solutions and generation of OLAP reports.
• Extensively interacted wif the designers, developers to ensure functional implementation of business requirements and QA team in executing Test Plans, Test scenarios and Test cases.
• Facilitated the User acceptance Testing (UAT) after performing Unit Testing, System Integration Testing (SIT), Performance & Service level testing.
• Involved in Project Management activities like defining / managing project scope, schedule management,
• Creating project plans, tracking and communicating project status, deliverables, and milestones.

Environment: Waterfall, Windows (XP/7/Vista/8), MS Office Suite (Word, PowerPoint, Excel, Outlook), MS Project 2010, Visio, UML, SharePoint 2010, SQL, HTML, XML, Mockup Screen, Java, JavaScript, SQL server services, IBM Cognos, Informatica.

Confidential

Business system Analyst

Responsibilities:

• Gathered Requirements Via formal meetings, brainstorming, interviewing and conducting JAD sessions wif business users and subject matter experts (SME’s) in focus groups.
• Analyzed and documented the “as-is” business process work flow and “to be” business process work flow 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 feasibility analysis of the proposed solution.
• Performed Requirements modeling using UML diagrams like sequence diagrams, state diagrams, use case diagrams, Activity diagrams, flow charts.
• Generated Mockup screens of Graphical user interface to capture the front end system requirements to communicate wif the web application designers.
• 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.
• Coordinated wif database administrators/ SQL developers in improving backend performance by participating in conceptual re-design and logical redesign of the database.
• Involved wif database designers in facilitating creation of ER Diagrams, Data modeler diagrams
• Involved in preparing test cases and test scenarios and coordinated wif other QA’s in executing the test plans.
• Involved in Project management planning activities of dis project Scope management, creating work break down structure, schedule management, stakeholder management using MS Project professional tool.
• Communicated directly wif Clients to understand their business needs and to resolve business issues.
• Conducted User Acceptance testing (UAT) and involved in code review sessions to ensure the functionality of system aligns wif the business requirements.
• Worked wif SQL queries to extract application data to perform application validations.

Environment: Waterfall, Windows (XP/7/Vista/8), .Net Framework (VB.NET, ASP.NET), MS Visio, Rational RequisitePro, HPQC, .net, C# SQL / SQL Server, MSOffice suite, MS Project Professional, Mockup screens, HTML, XML.

Confidential

Jr. Business Analyst

Responsibilities:

• Interacted wif users and stakeholders to identify business needs, worked wif SME’s of different groups to gain detailed knowledge of E-commerce shopping.
• Conduct JAD sessions.
• Assisted wif web portal development to enhance the functionalities of the system based on SOA and requirements collected for web architecture.
• Scrum was used in acute functionalities to design, document and manage User Stories throughout the life cycle of the project, including definition, design and testing phases.
• Identified all necessary Business Use Cases from requirements, created UML Diagrams.
• Worked as a team wif other team members to make an object oriented model and created use cases.
• Involved in preparing test cases and test scenarios and coordinated wif other QA’s in executing the test plans.
• Assisted in client-side validation and server-side validation on the data which was given or submitted by the client.
• Assisted in preparation of UAT test plan, testing cycle schedules, test scenarios and implemented them wif QA team

Environment: Scrum, MS Office, J2EE, JSP, MS Project, MS Visio, Clear Case, UML, HTML, SQL version 2008, HP QC

Confidential

Quality Analyst

Responsibilities:

• Analyzed requirements documents and Use Cases to prepare the detailed Test Plans and Test Cases
• Identification and development of test scenarios to test application against Functional Requirements
• Interaction wif client / Business Partners on Business Requirements, Change Requests and Defects
• Involved in discussions wif the Team on Quality Analysis, Manual Testing,Automated Test Toolsand Defect Tracking Tools, Root cause analysis, Conducted war room meetings on bug reporting and issue resolutions
• Involved in Analysis and Design of Functional Specifications to identify Test Requirements,Design Test Cases, Test Scripts, andTest Datawif expected output.
• 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.
• HP Quality center: Requirements upload, Test Case development wif Requirement mapping, Test Sets creation for each release, Capture Test Results and mapped raised defects to the test sets, generated various reports upon request.
• Supported testing, Creating test cases in dat would test various test scenarios.
• Involved in build validation, smoke testing, sanity testing, regression testing and Performed User Acceptance Testing for testing the usability and user friendliness of the application.
• Worked wif SQL queries to extract application data to perform application validations.
• Assigned problems to appropriate software development team for fixes.

Environment: Waterfall, HPQualityCenter / ALM, Share Point, JQuery, JSP, Java Script, Linux, JIRA, J2EE, GUI/UI, Apache, UML Telegence, Enabler, IBM, MS Office, MS Visio, MS Excel, MS SharePoint, SQL, PL/SQL, J2EE, HTML, XML, HP QTP/UFT