SUMMARY

• Excellent end to end understanding of SDLC methodologies such as Agile - Scrum, Waterfall, Hybrid, Incremental, Spiral, Rapid Application Development. Experienced in determining the appropriate software engineering processes like ATDD, TDD and BDD to be implemented for the user-stories.
• Facilitated various scrum ceremonies such as Sprint Planning, Daily Stand Up, Sprint Review, and Sprint Retrospective. Experience in writing, prioritizing and grooming Gherkin format User stories in product backlog while assisting the product owner.
• Worked closely with Product Owner and acted as Proxy product owner in gathering requirements, converting them into User stories and established Acceptance Criteria making sure they meet the Definition of Ready (DOR).
• Identified and trained other developers to work in an Agile environment. Coached team members on Agile principles and values. Spearheading effective communication between onsite and offshore teams.
• Experience with eliciting requirements using techniques such as Interviewing, Questionnaires /Surveys Questionnaires/Surveys, Document Analysis, Interface Analysis, JAD sessions, brainstorming sessions and Requirements Workshop.
• Experienced in Quantitative analysis, Qualitative analysis and maintaining the project quality also delivering the project within budget and time.
• Communicating with multifarious stakeholders for Requirement Gathering, managing Change Requests, performing Impact Analysis, Risk Analysis, GAP Analysis and 5 Why’s. Proficient with UML diagrams: Use case diagrams, Activity diagrams, Business Process Model and Notation (BPMN), Prototypes, Wireframes, Future state process map using Microsoft Visio and Lucid Chart.
• Hands on experience with creating artifacts like Business Requirement document (BRD), System Requirement document (SRS), Requirement Traceability Matrix (RTM), Functional Specification Document (FSD).
• Experienced in debugging the issue(bug), identifying the root cause by performing the root cause analysis of the problem and assigning the issue to the required team.
• Experienced in debugging the session using J-SON to identify the root cause of the problem.
• Experienced in creating Minimum Viable product - MVP and adding Tagging to generate reports on Visits, Progression and Conversion when a User Searches, Selects and books using our web application.
• Experienced in analyzing functional and non-functional implementation of business and system requirements are met by User Acceptance Testing, writing Test Plans and Test Case scenarios.
• Strong background in testing methodologies, including the development of Test Cases, and Test Scripts. Experienced in various testing methodologies such as Unit testing, Integration testing, System testing, Sanity testing, smoke testing, Interface testing, Regression testing, User acceptance testing-UAT.
• Experienced in Project Management, financial modeling and budget forecasting and T-shirt sizing for the incoming projects.
• Experienced in advanced Microsoft Excel - creating spreadsheets, VLOOKUP, Pivot tables, managing large data, creating Dynamic reports, financial analysis, Macros and Visual Basic of Application (VBA).
• Experienced in Front-End, Back-end and middle-ware development for the web application. Experienced in analyzing the API response and regression testing the web application. Experienced in the point of sale.
• Understanding of XML schemas for the Web Services, API’s and Micro Services while implementing SOA architecture. Engaged in enhancement mechanisms of existing SOA which involved the orchestration of the Web Services and Web Methods. Acted as source in identifying webservices and API in UDDI registry using WSDL and WADL files. Experienced in reviewing Test plans and Test cases in QA environments and facilitating UAT.
• Worked on developing SQL Database objects like Tables, Stored Procedures, Views, Indexes, Triggers, Constraints, Temporary Tables. Used SQL queries for retrieving data from different data sources.
• Strong experience in Data Analysis, Data warehousing, File transfers, Data Modeling with expertise in creating Star schema, Snowflake schema, Facts and Dimension tables. Worked extensively with slowly changing dimensions Type1, Type2, Type3.
• Experienced in working with ETL tool INFORMATICA POWER CENTER. Experience in Extraction, Transformation, loading (ETL) data from various data sources such as Flat Files, Oracle, XML and Teradata into Data Warehouse, Data Vault and Data Marts using Informatica (Repository Manager, Designer, Workflow Manager, Workflow Monitor).
• Experienced in Data Cleansing, Data scrubbing, Data Mapping and Data validation using ETL tools such as Informatica and SSIS.
• Experienced in Business Intelligence and Data mining tools such as Tableau, Spotfire, Power BI, SAP BO for Visualization and forecasting Data. Experienced in designing Tableau dashboards (tabs), filters, charts by extracting data from various dashboards.

TECHNICAL SKILLS

Methodologies: Agile/Scrum, Hybrid, Incremental, Spiral, Rapid Application Development, Waterfall.

Modelling tools: MS Visio, Lucid chart.

BI/ Data mining Tools: MS-EXCEL, TIBCO Spotfire 7.11, Tableau 9.0, Power BI, SSRS, SAP BO 4. X, SAS.

Agile Tools: JIRA, Confluence, Sharepoint2012/13.

Documentation tools: MS-Word, MS office suite and MS PROJECT professional.

Languages: VB, SQL, My SQL, PL/SQL, C, C#, Java, Python, HTML.

Web Technologies: HTML, CSS, JavaScript, XML, Web Services, API, SOAP, RESTful, AJAX, JSON, Angular JS, J2EE.

Testing Tools: SonarQube, SOAP UI, Postman, HP ALM, HP Load Runner, Selenium, cucumber, UFT.

Data warehouse: Data Marts, OLTP, OLAP, ROLAP, MOLAP, HOLAP, Multidimensional Analysis.

Databases: SQL Server, MySQL, MS Access, DB2, Oracle 11g/10g/9i/8i.

Operating System: Window, Unix, Linux, Mac OS.

ETL Tool: Informatica PowerCenter 10.1/9.5/9.1/8.6 , SSIS.

PROFESSIONAL EXPERIENCE

Confidential

Business Analyst

Responsibilities:

• Leading technical product team for complex, cross-functional projects involving multiple delivery teams while driving team velocity.
• Experienced in debugging the session using J-SON to identify the root cause of the problem.
• Experienced in creating Minimum Viable product - MVP and adding Tagging to generate reports on Visits, Progression and Conversion when a User Searches, Selects and books using our web application.
• Independently capturing and turn business requirements into user stories, epics and technical requirements and drive discussions among multiple technical teams to scope and schedule efforts.
• Working with the Design team to validate wireframe and prototype. Work with Project Management and Development teams to ensure that product backlog is healthy and remains current and aligned with business objectives.
• Manage communication and relationships with business, development, supplier and marketing partners. Work with architecture, Project management and Development to understand product development risks and mitigation strategies.
• Experience in the various Airlines fares - Insider fares, Private fares, Published fares, IAP fares. Experienced in Up-Sell and Down-sell methodology in the Airline booking strategy.
• Understanding of XML schemas for the Web Services, API’s and Micro Services while implementing SOA architecture. Engaged in enhancement mechanisms of existing SOA which involved the orchestration of the Web Services and Web Methods. Acted as source in identifying webservices and API in UDDI registry using WSDL and WADL files. Experienced in reviewing Test plans and Test cases in QA environments and facilitating UAT.
• Gathering the requirements from the stakeholders, breaking down the Epic requirements into User Stories and Acceptance Criteria to communicating the requirement that is understandable to the business and the technical team. Identify business rules and requirements and documenting them in a format that can be reviewed and understood by both business and technical people.
• Organizing various scrum ceremonies such as Sprint Planning, Daily Stand Up, Sprint Review, and Sprint Retrospective. Experience in writing, prioritizing and grooming User stories in product backlog while assisting the product owner.
• Providing the progress update, blockers update and status to the Stake holder on weekly bases.
• Debugging the issue(bug), identifying the root cause by performing the root cause analysis of the problem and assigning the issue to the required team.
• Used JIRA and Confluence for documentation and visualization of KPI’s, Burndown, Burnup charts and velocity trends. Supported the Product Owner in refining the Product backlog and prioritizing user stories.
• Facilitated Product Backlog Refinement, Iteration Planning, Daily Standups, Iteration Review and Iteration Retrospectives.
• Performed Gap analysis, Impact analysis, Cost benefit analysis, Risk analysis, ROI Analysis on the requirements. Performed requirement modelling using UML diagrams such as Activity, Sequence, ER and BPMN diagrams

Environment: Agile - Scrum, MS Project, Windows, IOS, JIRA, Confluence, MS Office Suite/ 365, XML, Flat files, Teradata, MS Excel, Oracle Database 11g, SQL Server, MS Visio, Lucid Chart, SQL Server Enterprise Edition, MS Visual Studio, Tableau, TIBCO Spotfire, Power BI.

Confidential

Business Analyst

Responsibilities:

• Gathered requirements from the clients by various requirements eliciting techniques such as Interviewing, Questionnaires /Surveys Questionnaires/Surveys, Document Analysis, Reverse Engineering, Interface Analysis and Requirements Workshop.
• Created and maintained User Stories by interviewing the business users to communicate the requirements to development and testing teams.
• Facilitated various scrum ceremonies such as Sprint Planning, Daily Stand Up, Sprint Review, and Sprint Retrospective. Experience in writing, prioritizing and grooming Gherkin format User stories in product backlog while assisting the product owner.
• Co-authored detailed Business Requirements Document (BRD), Business Requirements Specifications (BRS) and Functional Requirements Document (FRD). Provided As-Is and To-Be flow diagrams for different phases of the project.
• Created and maintained Requirements Traceability Matrix (RTM) to trace technical requirements to their business requirements and the test case requirements to their functional requirements.
• Hands on experience with creating artifacts like Business Requirement document (BRD), System Requirement document (SRS), Requirement Traceability Matrix (RTM), Functional Specification Document (FSD).
• Conducted highly interactive Scrum Workshop for the new cross-functional team members and emphasized on the importance of the scrum framework and ceremonies involved.
• Designed Use Case diagram and User Interface Diagram to illustrate the interaction of the Business owners with the Tableau Business Intelligence reports.
• Experienced in debugging the issue(bug), identifying the root cause by performing the root cause analysis of the problem and assigning the issue to the required team.
• Involved in importing data to Tableau reports from Oracle databases by using various joiner conditions. Also involved in naming conventions across the Tableau reports.
• Effectively communicated weekly project status, burn down charts to executive and business leadership. Facilitated all scrum ceremonies such as Sprint Planning, Daily Scrum, Sprint Review, Sprint Retrospective and Backlog Grooming.
• Assisted PO in writing user stories, use cases and managed Sprint, product backlog in JIRA, moving stories, tracking defects, impediments, retrospectives, monitoring burndown chart. Experience with tracking sprint progress from “To-do” “In-progress” and “Complete” using multiple information radiators.
• Incorporated Change Request from the product owner and smoothened the process without work interruptions.
• Played a pivotal role in setting up User Acceptance Criteria for user stories to help line of business. Made sure User Stories have met the invest criteria and tasks have met with smart criteria while assisting the Product Owner in prioritizing the Product Backlog Items (PBIs) using techniques like MOSCOW, Paired comparison. Worked with Product Owner on Artifacts Such as Product Backlog, Spring Backlog, Sprint and Release Burn down.
• Assisted in the designing and development of test case scenarios and developed test plans. Collaborated with the QA team to build the test cases for Regression Testing, Conducted User Acceptance testing with the Business Stakeholders for review and final approvals of product.
• Built a trustworthy and safe environment where problems can be raised without fear of blame, retribution, or being judged, with an emphasis of healing and problem solving.

Environment: Agile - Scrum, MS Project, Windows, IOS, JIRA, Confluence, MS Office Suite/ 365, XML, Flat files, Teradata, MS Excel, Oracle Database 11g,, SQL Server, MS Visio, Lucid Chart, SharePoint, SQL Server Enterprise Edition, MS Visual Studio, CRM, ERP, Power BI, Java, HTML, C, CSS.

Confidential

Business Analyst Intern

Responsibilities:

• Interacted with internal stakeholders to gather user requirements and their expectations from the system. Involved in analyzing Business Requirements and developing System Specifications.
• Analyze Business Requirement Documents (BRD) and Functional Requirements Documents (FRD) for test planning and scripting. Participated in Requirement Review Meeting with Business, Development Team Manager and SMEs.
• Created Use case models, UML/Use Case diagrams, Activity Diagrams using Rational Rose. Facilitated and participated in Joint Application Development (JAD) sessions, and conference calls to keep executive staff and the team members apprised of goals, project status, and resolving issues.
• Facilitated meetings with Subject Matter Experts (SMEs) to create the process requirements, process improvements and to proper explain the development team the flow of future data modules.
• Experienced working with call center and Customer relationship Management (CRM) and ERP tools to gain intelligence from the customer.