SUMMARY

• 9 years of IT industry experience as Business Analyst/ Scrum Master/Tester.
• Developed Test cases, Test plans, Test Analysis Reports and Test Strategy to ensure quality.
• Conducted and administered several types of testing for instance User Acceptance testing (UAT), Regression testing, Integration testing (SIT), Black Box testing, Smoke testing and Sanity testing.
• Successfully elicited requirement using analysis like As - Is and To-be, Must Have and Good to Have, GAP analysis, SWOT analysis, Impact analysis and Cost Benefit Analysis.
• As a Skilled Scrum Master ensured adherence to INVEST (Independent, Negotiable, Valuable, Estimable, Small and Testable) Criteria and SMART (Specific, Measurable, Attainable, Realistic and Timely) Model. Skilled in managing requirement churn.
• Evaluated Statistical Data and executed Data Mining for large data sets using MS Excel, & SAS.
• Gained comprehensive knowledge from working in several Software Development Life Cycle (SDLC) processes such as Waterfall and Agile methodologies. Acquired hands on experience in XP, Scrum-Waterfall (Hybrid), and Scrum
• Significant roles included developing Key Performance Indicators (KPIs) to precisely examine client needs, assisting Project Manager to document Work Breakdown Structure using MS Project, conducting Feasibility Studies and Risk Management plan.
• Involved with company’s internal and external client interactions and altered business functionalities into Service Oriented Architecture (SOA) models across diverse IT environments.
• Worked around Three-Tier architecture, Web Services (SOAP, REST), Client-Side or Server-Side Validation and Cloud technologies. Conceptual knowledge of WSDL, WADL and UDDI.
• Used ERwin Tool for creating ER (Entity Relationship) Diagrams and Enterprise Architect Rational Rose and MS Visio for creating UML 2.0 (Unified Modelling Language) Diagrams.
• Experienced creating workflow analysis and design, data flow diagrams, Business process modeling and process flow modeling.
• Prepared Responsible, Accountable, Consulted, and Informed (RACI) Matrix as per Project Plan.
• Effectively interacted and networked with business users at several levels in addition to organizing, ducting and facilitating elicitation sessions such as survey/questionnaires, focus groups, interviews, brainstorming, requirement workshops, document analysis, Job Shadowing, JAD/RAD.
• Documented artifacts such as Business Requirements documents (BRD), Use-Case Specifications and System Requirements Specifications (SRS), Functional Specification Document (FSD), Requirement Tractability Matrix (RTM), Data Mapping Documents and data dictionary Documents.
• Proficient with Unified Modeling Language (UML) diagrams including Use Case Diagrams, Activity Diagrams Sequence Diagrams, Object Diagram Data Flow Diagrams and Class Diagrams.
• Proficient in writing SQL Queries to fetch data from multiple tables and check for data integrity.
• Worked in all stages of Integrated Data Warehousing and Data Migration projects.
• Thoroughly understanding of Data structures, Database Normalization and Denormalization, Schemas (Star and Snowflake), Data Marts and OLAP operations such as Roll-up, Drill-down, slice, dice.
• Generated Ad hoc Reports as per Business Users requirement.
• Collaborated with data Architect to develop Conceptual and Logical Data Models using MySQL workbench, assisted in creating Physical data models.
• Led cross functional and self-organizing teams to develop custom built Business Intelligence (BI) Tools.
• Conducted workshops for estimation techniques such as Planning Poker, T-Shirt Sizing and relative mass evaluation and various prioritization techniques such as Walking Skeleton, Validated Learning, Business Value based, MoSCoW and Kano.
• As an Experienced Scrum Master incorporated Sprint Ceremonies (Sprint Planning, Daily Standup, Sprint Review, Sprint Retrospective) and Backlog Grooming session or story times.
• Demonstrated strong analytical, problem solving, communication skills (both oral and written) with leadership, time management and interpersonal skills.

TECHNICAL SKILLS

SDLC Methodologies: Agile-Scrum, Waterfall, SDLC, Waterfall-Scrum Hybrid

Front End Tools: JIRA, Rally, MS SharePoint, MS Project, Informatica

Design Tools: MS Visio

Databases: My SQL, SQL Server 2008/2012, Oracle 8i, 9i,11g,12c and MS Access

Testing Tools: HPALM, HPQC and SOAP UI

Reporting Tools: Tableau 9.0, SQL Server Reporting Services (SSRS), SAS

Other Tools: MS Office Suite (MS Word, MS PowerPoint, MS Excel), PowerPivot

Languages: SQL, PL/SQL, HTML, XML

Graphical Tools: Wireframes, Mock-up Screens, MS Visio

Operating Systems: Windows XP, 7, 8, 10

PROFESSIONAL EXPERIENCE

Confidential, NEW YORK, BROOKLYN

BUSINESS ANALYST

Responsibilities:

• Work with MIS staff (e.g., managers, senior programmers, support staff, product manager) to plan program code implementation, enhancements and changes. Design reports, audit trails/logs, security mechanisms.
• Analyzing the frontend system called POS (Paperless Office Management System) and monitor the enhancements along with detailed examination of quality assurance aspects.
• Provide assistance to MIS technical support staff when they are unable to resolve an issue by trying to analyze the root cause by conducting and administering several types of testing for instance User Acceptance testing (UAT), unit and smoke testing.
• Developing structured diagrams and updating technical specifications of communication systems such as Model office/Kiosk for routing customer tickets.
• Eliciting detailed requirements using techniques such as brainstorming, document analysis and majorly Job Shadowing to get a better perspective from seniors who have been working on the earlier version of the system for years.
• Part of the responsibility covered observations of on-site/centers where as an analyst there was a need to understand the problems faced by JOS workers, note down where program freezes in certain situations, allocate data and requirements for enhancements that can be used to further improve client interview experience and increase the effectiveness of the application.
• Document all the processes and create data dictionaries with versions of the application also create and update Use Case Diagrams, Activity Diagrams Sequence Diagrams and Object Diagram Data Flow Diagrams.
• Develop and prepare documents for the general design of solutions that meet system requirements, including the selection of alternative approaches.
• Assist, comply and document the meeting minutes regarding project changes and updates on assigned projects.
• Develop operational and installation procedures for the systems concentration on guidelines to upgrade techniques of new procedures for the support of databases, hardware systems, operating systems software, network systems software, and client server systems.
• Write release notes for client presentation by carefully analyzing and summarizing the updates, modifications and error handling based specifications that the team worked on for the last year.

Confidential, FRAMINGHAM, MASSACHUSETTS

SR. BUSINESS ANALYST / SCRUM MASTER

Responsibilities:

• Held meetings with observers, developers & Subject Matter Experts (SME’s) like Market Analysts and Content Marketing manager for thorough understanding of what kind of reports they needed on the dashboard.
• Assisted data analyst in examining our enriched data in Data warehouse, conduct data mining aspects to help identify attributes & data variables required to aid predictive analysis required by marketing team using WEKA.
• Created Mock-up Screens and Wireframes using UI Components such as Radio Buttons, Drop-down list, Checkboxes to communicate Business Intelligence Team in understanding the look and feel of the analytical dashboard as per the requirement given by market analysts.
• Gathered the Business rules from respective stakeholders & applied the transformation logics on the data.
• Assisted the data analyst to map data from different sources to the target data-mart and examined data mapping documents created by Junior B.A.
• Examined Use-case scenarios and Sequence Diagrams using MS Visio for Client authentication.
• Took comprehensions with participation in Artifact reviews, plan setup, plan configuration and incorporated them in Business process re-engineering, Business process improvements, Business process modeling using activity diagrams and swim-lane diagrams.
• Helped the Product Owner to prioritize the Product backlog items (PBI’s) for developing Sprint tasks by taking suggestions from the cross-functional development team.
• As a SCRUM Master, time-boxed and facilitated the SCRUM ceremonies. Also Created and maintained Sprint Burn-down Chart, Sprint Burn-up Chart and Product Burn-Down Chart to keep the track of the team’s progress and the team’s velocity for better estimation of the sprint life cycle.
• Conducted Scrum Workshops to coach the development team about Agile and Scrum methodology.
• Administered test cases, test plans, and test scenarios depicted in documented requirements and traceability matrixes for User Acceptance testing (UAT). Worked with Product Owner to review the working emo of Potentially Shippable Product Increment (PSPI) in review meeting and helped deciding which features are done and satisfies the acceptance criteria.
• Designed Conceptual and Logical Models to capture the entities their relationships and attributes and collaborate them with existing system using E-R Diagrams, keeping in mind the business requirements.
• Assisted creating Dimensional Models and assisted the architect to select from different types of dimensions i.e., thereby converting user stories into dimensions.
• Used JIRA for drafting the User Stories and managing the requirements and document impediments.
• Reviewed Business Rules written for middle tier and validated XML schema for system data documentation including the requirement data document.

ENVIRONMENT: Scrum, Wireframes, Mockup Screens, MS Office (MS Word, MS Excel, and MS PowerPoint), MS Visio, WEKA, UML, JIRA 5.2, Informatica 9.1, Oracle 11g, Web Services, SOA, REST & SOAP, XML, HTML, CSS, JavaScript, HTTP.

Confidential, COLUMBUS, OHIO

BUSINESS ANALYST & SCRUM MASTER

Responsibilities:

• Analyzed and documented the system specifications, Business Requirements and detail design of the software for full understanding of business.
• Assumed responsibility for collecting, understanding, and transmitting the business requirements for the project into functional specifications.
• Conducted Cost benefit analysis, Risk assessment, and SWOT analysis.
• Assisted in the creation of the Product Backlog, and provided clarification on prioritization when required by the Product Owner.
• Met with users and stakeholders to thoroughly grasp the scope of the project.
• Provided key input in defining functional requirements and system requirements/ specifications.
• Acted as Scrum Master for Product team with a focus on guiding the teams towards improving the way they work.
• Assisted in the facilitation of JAD sessions, to ensure the technical requirements are clarified.
• Utilized Visa, MasterCard payment gateways to enable online payments of premiums from the website.
• Facilitated all scrum ceremonies: Sprint Planning, Backlog Grooming, Sprint Review, Sprint Retrospective and the Daily Standups.
• Also facilitated the Backlog Grooming as and when needed or requested by the Product Owner.
• As Scrum master facilitated the scrum as well as coached them on scrum methodology.
• Assisted the Product Owner in prioritizing the Product backlog items (PBI’s) and documenting Sprint tasks by taking suggestions from the cross-functional development team using Kano model and Walking Skeleton Technique.
• Facilitated meetings with observers, developers and Subject Matter Experts (SME’s) for pre-analysis and requisites of the project.
• Coordinated with the product owner to frequently analyze the loan to value ratio.
• Ensured that the User Stories meet the INVEST (Independent, Negotiable, valuable, Estimable, Small, Testable) Criteria.
• Worked with the Product Owner to analyze and decompose the Product Backlog items
• Created and maintainedSprint Burn-down Chart, Sprint Burn-up Chart andProduct Burn-Down Chartto keep the track of the team’s progress and the team’s velocity for better estimation of the sprint life cycle.
• Assisted JAD session for business and technical user group.
• Made extensive use of Unified Modeling Language (UML) to create use case diagrams, activity diagrams, sequence diagrams and collaboration diagrams.
• Worked with other business analysts to design and document needs assessment, workflow, data maps, business requirements, business rules, policies and procedures.
• Created use case, use case diagrams, activity diagrams and sequence diagrams.
• Responsible for handling requirement churn.
• Interacted with developers to resolve the technical and implementing issues
• Worked with technical team to gather and elicit requirements.

Environment: Scrum, MS project, MS office Tools, MS Visio, UML, AJAX, JAVA 2EE, Oracle 11g, JIRA, Informatica v9x, Blue pay, JDBC/ODBC, RALLY

Confidential, MICHIGAN

BUSINESS ANALYST

Responsibilities:

• Created Data Mapping template and assisted in creating Data modeling.
• Developed Conceptual and Logical Data Models using Erwin.
• Created Data Dictionary for the data models.
• Worked with QA team to design and develop Test Plan and Test Cases to perform User Acceptance Testing (UAT), Functional Testing and Regression Testing.
• Identified Source systems for Financial data profiling of Billing and Budget processes.
• Integrated various OLTP to the OLAP by using SSIS/SSAS as an ETL tool and used SSRS as reporting tool.
• Assisted in increasing Data Integrity by performing Data Normalization and adding Data Verification and Validity to maintain accuracy and effectiveness of data,
• Performed Data Mining to find correlation and pattern in existing data and constructed SQL queries.
• Played a key role in the planning, testing, and implementation of system enhancements and conversions.
• Used ETL to map data and assemble data repository and created data marts.
• Used Data Center for Integrating Legacy systems and supporting in decision making.
• Assisted in creating Data Hub with Bus Architecture.
• Assisted in increasing Data Integrity by performing Data Normalization & adding Data Verification and Validity.
• Assisted in the implementation of Enterprise Data Warehouse with individual data marts to address areas of business interest.
• Assisted with SNOW-flake schemas in the Dimensional model architects to providing business rules.

Environment: SDLC, Waterfall, MS project, MS office Tools (Word, Excel, PowerPoint and Visio), MS Project, MS SQL 2008, SSRS, SSAS, Payroll Consolidation, Application Designer.

Confidential, DALLAS, TEXAS

SCRUM MASTER

Responsibilities:

• Assisted in the creation of the Product Backlog, and provided clarification on prioritization when required by the Product Owner.
• Met with users and stakeholders to thoroughly grasp the scope of the project
• Provided key input in defining functional requirements and system requirements/ specifications.
• Acted as Scrum Master for Product team with a focus on guiding the teams towards improving the way they work.
• Assisted in the facilitation of JAD sessions, to ensure the technical requirements are clarified.
• Utilized Visa, MasterCard payment gateways to enable online payments of premiums from the website.
• Facilitated Sprint Planning, Backlog Grooming, Sprint Review, Sprint Retrospective and the Daily Standup meeting.
• Also facilitated the Backlog Grooming as and when needed or requested by the Product Owner.
• As Scrum master facilitated the scrum as well as coached them on scrum methodology.
• Assisted the Product Owner in prioritizing the Product backlog items (PBI’s) and documenting Sprint tasks by taking suggestions from the cross-functional development team using Kano model and Walking Skeleton Technique.
• Facilitated meetings with observers, developers and Subject Matter Experts (SME’s) for pre-analysis and requisites of the project.
• Ensured that the User Stories meet the INVEST (Independent, Negotiable, valuable, Estimable, Small, Testable) Criteria.
• Worked with the Product Owner to analyze and decompose the Product Backlog items
• Created and maintainedSprint Burn-down Chart, Sprint Burn-up Chart andProduct Burn-Down Chartto keep the track of the team’s progress and the team’s velocity for better estimation of the sprint life cycle.
• Communicated the status of the Product Backlog Item to product Owner and external stakeholders on a regular basis.
• Time Boxed daily stand up meetings to ensure the productivity of the team daily.
• Effectively organized the Task Board and activities involved in it.
• Created and maintained Sprint Burn-down Chart, Sprint Burn-up Chart and Product Burn-Down Chart to keep the track of the team’s progress and the team’s velocity for better estimation of the sprint life cycle.
• Worked with Product Owner to review the working demo of Potentially Shippable Product Increment (PSPI) in review meeting and helped deciding which features are done and satisfies the acceptance criteria.
• Used JIRA for drafting the User Stories and managing the requirements and defects track.
• Reviewed Business Rules written for middle tier and validated XML schema for system data documentation including the requirement data document.
• Effectively involved in conducting Planning poker technique for estimating the User stories.

ENVIRONMENT: Waterfall-Scrum Hybrid, Wireframes, MS Office (MS Word, MS Excel, and MS PowerPoint), MS Visio, UML, JIRA 5.2, IBM Cognos Data Manager v10.2, Oracle SQL 2008, Web Services, SOA, SOAP, XML, HTML, CSS.

Confidential

BUSINESS ANALYST / SCRUM MASTER

Responsibilities:

• Analyzed the prior documentation and business processes for full understanding of the project. Interviewed area experts, asking detailed questions and carefully recording the requirements in a format that can be reviewed and understood by both business people and technical people.
• Developed good knowledge of Asset Allocation, Commodities, Bond Pricing, Corporate Bonds, Fixed Income, Credit Risk, Market Risk.
• Gathered Business Requirements, through constant interaction with the Product owner, SME’s, Designer and Developers to get a better understanding of the business processes.
• Analyzed and optimized the complete process and prepared Business Requirement Document (BRD) and Functional Requirement Document (FRD).
• Coordinated and conducted Joint Application Development (JAD) and walk through sessions involving business unit stakeholders, and technical analyst utilizing strong interpersonal, oral and written communication skills.
• Performed Gap Analysis of business rules and system process flows to define current processes and determine future business requirements, creating As Is/To Be mapping for all new enhancements.
• Experience capturing all aspects of Wealth Management through Use Cases & Process Flow Diagrams using MS Visio and UML modeling diagrams such as Activity Diagram, Class Diagram, Sequence Diagram using IBM Rational Rose.
• Helped developers in making the application more live by putting more dynamic content by using Java Script.
• Provided technical assistance in identifying, evaluating, and developing systems and procedures that were cost effective and met business requirements.
• Worked with Project Management resource, Revenue Planning, Budget Allocation, Work Breakdown Structure (Monitoring and Reporting Progress).
• Conducted Stand-Up Meetings and created Sprint Burn-Down Charts to understand the remaining work and calculated the Velocity to make sure teams involvement in the work.
• Identified and created User Stories and Use Cases from requirements for the better understanding of the team.
• Coordinated and prioritized outstanding defects and system requests and prepared Requirement Traceability Matrixes (RTM) to track such requirements.
• Extensively worked on the SharePoint application and managed the enterprise content and document management.
• Assisted ETL developers mapping the extracted data from source system and load into the target system after applying required transformation. Requirements.
• Created SRS to capture functional and non-functional GUI and regulatory requirements.
• Created GUI screen visual aspects using Mockups and wireframes for development team and business users.
• Actively involved in the creation of Test Plan, Test cases and involved in User Acceptance Testing (UAT).

Environment: Agile-Scrum, JIRA, SQL Server, Informatica, MS Office, SharePoint (2010), MS Project, MS Visio, HP QC, XML, Oracle, IBM Rational Rose

Confidential

BUSINESS ANALYST

Responsibilities:

• Interacted with the customers and internal stakeholders to gather user requirements and their expectations from the system.
• Involved in analyzing Business Requirements and developing System Specifications.
• Analyzed monthly/quarterly performance against plans and forecast and recommended corrective actions.
• Assessed business priorities, and advised business units on risks and Cost-Benefit analysis.
• Used MS Visio to generate various UML Diagrams.
• Organized cross training of team members and users to become more responsive.
• Participated in the development and preparation of the Test Plan with the testing team as well as ensuring testability, reliability, usability, maintainability and performance of the application.
• Involved in incident reporting and change and configuration management procedures.
• Ensured that the modifications suggested by the users were incorporated into the application.
• Formed a bridge between the Project Manager and different teams with effective presentations.
• Performed SQL queries using joins and nested queries to fetch data from MS SQL Server.

ENVIRONMENT: Waterfall Methodology, MS Office 2007 (MS Excel, MS Word, MS PowerPoint), MS Visio 2007, MS Project 2007, Mock-Up Screens, UML, SharePoint 2007, MS SQL Server 2005.

Confidential 

JUNIOR BUSINESS ANALYST / SQL DEVELOPER

Responsibilities:

• Interviewed Subject Matter Experts (SME’s) and carefully recorded the requirements in a format that could be reviewed and understood by both business and technical people.
• Facilitated JAD sessions to embrace a problem’s dimensions, possible causes, requirements, to propose alternative solutions.
• Developed and elicited Business Requirement Documents (BRD), Functional Specifications Documents (FSD), Vision of document, and use case documents.
• Determined client visions through client engagement throughout the development of the project.
• Created document for data flow to support the project once it implemented in production and mapped new functional and business requirements.
• Analyzed business requirements and segregated them into high level and low-level Use Cases, activity diagrams using Rational Rose according to UML.
• Articulated business requirements from user interviews and then converted the requirements into technical specifications.

ENVIRONMENT: Waterfall Methodology, MS Office (MS Excel, MS Word, MS PowerPoint), MS Project, MS VISIO, Mock-Up Screens, UML, SharePoint 2007, MS SQL Server 2005.