We provide IT Staff Augmentation Services!

It Business Analyst/scrum Master Resume

Austin, TX

SUMMARY:

  • Business Analyst/ Scrum Master with nearly 6+ years of experience in IT environment working in various domains and projects.
  • Experience in requirements gathering through different elicitation techniques like JAD sessions, interviews and workshops with clients, developers and QA analysts.
  • Experience in different Software development life cycles (SDLC) like Agile and Waterfall.
  • Experience in Data Analysis using Access and SQL.
  • Experience in writing and understanding complex queries for DB2 SQL in Advanced Query Tool
  • Experience in developing dashboards and reports using analytics, interactive dashboard actions and best practices. knowledge in wire framing.
  • Experience in creating Unified Model Language (UML) diagrams like Use case diagrams, Sequence Diagrams, Activity Diagrams, and Class Diagrams.
  • Experience in SQL, Business Intelligence, Data Warehousing and Business Architecture and data mining.
  • Experience in Involving and analyzing the ETL processes and data mapping from source to target data marts using Informatica Power Center Designer.
  • Experience in Data model, Data visualization, Data warehouse, Data reports.
  • Experience in applying information systems solutions to business problems.
  • Experience in system testing, validation, problem resolution, and .
  • Experience in Managing detailed project plans which included resources planning, tasks planning, budgeting, milestones set - up, and performed Gap Analysis, Impact Analysis, SWOT Analysis, Cost Benefit Analysis and Risk Analysis, data Source mapping.
  • Experience in report generation and creating dashboards using SAP Dashboard Designer and SAP Crystal Reports.
  • Experience in Ability to work both independently and as part of a team to meet objectives. Possess outstanding communication skills and ability to motivate a team towards successful completion of project milestones.
  • Familiar with current industry standards, such as HIPAA, SOX, ISO, Six Sigma, and Capability Maturity Model (CMM).
  • Experience in Rational Unified Process (RUP), risk engineering; data modeling and mapping, and design using UML, Rational Rose, and Visio.

SKILL:

SDLC Methodologies: Agile (Scrum), Waterfall

Domain knowledge: Banking, IT systems upgrade, Clinical research, Healthcare and Insurance claim management

Documentation: RFP, RFI, BRD, FRD, TSD, SOW, RACI, RTM, UAT Plan, Test PlanCommunication Plan, Risk Management Plan, Project Plan, Project CharterProject Status Report

Project Management Tools: MS Project

Requirement Management Tools: JIRA, Easy Agile, TFS, Blueprint

Business Modeling Tools: MS Visio, Enterprise Architecture, Wireframes, SharePoint

Content Management Tools: Confluence, MS SharePoint

Document Management Tools: MS Office Suite (Word, Excel, Outlook, Publisher, PowerPoint, OneNote)

Testing / Bug tracking tools: JIRA, Rally, HP Quality Centre

Statistics analysis software: SPSS

Environment: Oracle, SQL server, .NET

BI/ Reporting Tools: Crystal reports, SSRS, Cognos, Business Objects

Data Warehousing Tools: Informatica Power Center, TOAD, Data Stage, Query Express, Advanced Query Tool

Database and Server: Oracle, MS SQL Server 2008/2012

Languages: C++, Java, HTML, CSS, SQL

EXPERIENCE:

Confidential, Austin, TX

IT Business Analyst/Scrum Master

Responsibilities:

  • Derived the requirements from interviews with customers and creating system requirements documents based on the Interviews.
  • Created Many Interview data and consolidated into a report.
  • Created many data models according to the requirements.
  • Assisting with the understanding of additional business processes from disparate applications and how to in corporate them into the requirement.
  • Eliciting requirements using document analysis, requirements workshops, business process descriptions, use cases, scenarios, business analysis, task and workflow analysis, and/or viewpoints.
  • Involved in analyzing the existing mapping documents for data marts.
  • Created new mapping documents for the target data marts.
  • Analyzed the existing data flow mappings from source to target in Informatica Power Center Designer to understand data flow and relationship of data among tables.
  • Involved in understanding and creating of BRDs.
  • Using development specification, creating detailed use cases, data flow diagrams using Microsoft Visio.
  • Involved in creating the high-level design diagrams for the existing data mappings using Visio and leverage them for creating the low-level design for the new system.
  • Worked closely with other Business Systems Analysts, Process Owners and Development Teams as required.
  • Worked with project team in establishing deliverables and estimating work effort involved in the design and implementation of the required consolidated reports.
  • Participated in the review of current business processes and demonstrate improved processes through recommended changes to the Application
  • Responsible for analysis and translation of user stories into IT requirements, obtaining approval of requirements.

Environment: MS Visio, Data warehousing, Data analysis, MS Office, SharePoint, JIRA

Confidential, San Antonio, TX

IT Business Analyst/Scrum Master

Responsibilities:

  • Involved in the Gap analysis on the existing IDW (Integrated Data Warehouse) to ensure what data we need for each work stream with in IDW and the data marts.
  • Involved in the JAD sessions with the business team to understand the requirements.
  • Assisting with the understanding of additional business processes from disparate applications and how to in corporate them into the Application.
  • Eliciting requirements using document analysis, requirements workshops, business process descriptions, use cases, scenarios, business analysis, task and workflow analysis, and/or viewpoints.
  • Involved in analyzing the existing mapping documents for data marts.
  • Created new mapping documents for the target data marts.
  • Analyzed the existing data flow mappings from source to target in Informatica Power Center Designer to understand data flow and relationship of data among tables.
  • Involved in writing and understanding complex queries for DB2 SQL in Advanced Query Tool
  • Involved in analyzing the data using Advanced Query Tool.
  • Involved in understanding and creating of BRDs.
  • Prepared Source to Target mapping documents to help ETL team in extracting and processing the data before loading to the target database.
  • Using development specification, creating detailed use cases, data flow diagrams using Microsoft Visio.
  • Involved in creating the high-level design diagrams for the existing data mappings using Visio and leverage them for creating the low-level design for the new system.
  • Underwent on Blue Print tool for assistance in business requirement management phase.
  • Involved in creating Interface agreements to ensure the transfer of data occurs in an agreed format and timeframe.
  • Assessing existing data flows and recommending solutions to development team.
  • Participated in the review of current business processes and demonstrate improved processes through recommended changes to the Application.
  • Worked closely with other Business Systems Analysts, Process Owners and Development Teams as required.
  • Worked with project team in establishing deliverables and estimating work effort involved in the design and implementation of the Software Application.
  • Participated in the review of current business processes and demonstrate improved processes through recommended changes to the Application
  • Responsible for analysis and translation of user stories into IT requirements, obtaining approval of requirements.
  • Worked with development teams to resolve design issues discovered during testing phases and communicated software issues to the development teams and participated in User Acceptance Testing (UAT).
  • Assisted the testing team during the preparation of Test Cases and reviewed test scripts to ensure all functional requirements are being tested.

Environment: MS Visio, IBM DB2, Advance Query Tool, Informatica PowerCenter Designer, Data warehousing, Data analysis, Blue print, MS Office, SharePoint, IBM Work scheduler, JIRA

Confidential, Cary, NC

Business Analyst/Scrum Master

Responsibilities:

  • Involved in the Gap analysis on the existing IDW (Integrated Data Warehouse) to ensure what data we need for each work stream with in IDW and the data marts.
  • Involved in the JAD sessions with the business team to understand the requirements.
  • Assisting with the understanding of additional business processes from disparate applications and how to in corporate them into the Application.
  • Eliciting requirements using document analysis, requirements workshops, business process descriptions, use cases, scenarios, business analysis, task and workflow analysis, and/or viewpoints.
  • Involved in analyzing the existing mapping documents for data marts.
  • Created new mapping documents for the target data marts.
  • Analyzed the existing data flow mappings from source to target in Informatica Power Center Designer to understand data flow and relationship of data among tables.
  • Involved in writing and understanding complex queries for DB2 SQL in Advanced Query Tool
  • Involved in analyzing the data using Advanced Query Tool.
  • Involved in understanding and creating of BRDs.
  • Prepared Source to Target mapping documents to help ETL team in extracting and processing the data before loading to the target database.
  • Using development specification, creating detailed use cases, data flow diagrams using Microsoft Visio.
  • Involved in creating the high-level design diagrams for the existing data mappings using Visio and leverage them for creating the low-level design for the new system.
  • Underwent on Blue Print tool for assistance in business requirement management phase.
  • Involved in creating Interface agreements to ensure the transfer of data occurs in an agreed format and timeframe.
  • Assessing existing data flows and recommending solutions to development team.
  • Participated in the review of current business processes and demonstrate improved processes through recommended changes to the Application.
  • Worked closely with other Business Systems Analysts, Process Owners and Development Teams as required.
  • Worked with project team in establishing deliverables and estimating work effort involved in the design and implementation of the Software Application.
  • Participated in the review of current business processes and demonstrate improved processes through recommended changes to the Application
  • Responsible for analysis and translation of user stories into IT requirements, obtaining approval of requirements.
  • Worked with development teams to resolve design issues discovered during testing phases and communicated software issues to the development teams and participated in User Acceptance Testing (UAT).
  • Assisted the testing team during the preparation of Test Cases and reviewed test scripts to ensure all functional requirements are being tested.

Environment: MS Visio, IBM DB2, Advance Query Tool, Informatica PowerCenter Designer, Data warehousing, Data analysis, Blue print, MS Office, SharePoint, IBM Work scheduler, JIRA

Confidential, Columbus, IN

Business Analyst/Scrum Master

Responsibilities:

  • Worked with software engineers and business units, assisted in formulating and defining system scope and objectives through research and fact-finding, combined with a basic understanding of business systems and requirements.
  • Conducted GAP Analysis and created AS-IS TO- BE chart from the results of the analysis.
  • Responsible for creating requirement artifacts like Business Requirement Document (BRD), Functional Requirement Document (FRD), System Requirement Specifications (SRS)
  • Managed risks/issues and provided weekly status to leadership.
  • Implemented data collection and analyzed datasets in excel using macros, VLOOKUP and pivot tables.
  • Validated BI reports and end-to-end results with DW/Data mart using complex SQL queries.
  • Used MS Visio to create Business Flow Diagrams and Work Flow Diagrams.
  • Maintained Requirement Traceability Matrix (RTM) and managed requirements.
  • Conducted and involved in User Acceptance Testing (UAT) sessions with Business Users and documented the defects.
  • Assisted the QA team in creating Test Cases, Test plans and Test Scripts.
  • Independently compiled business, functional & non-functional requirements.
  • Reviewed & assisted in the design of business processes
  • Collaborated to create deliverables for high level initiatives.
  • Designed interactive dashboards and reports using SAP Crystal Reports and SAP Dashboard Designer.
  • Assist Senior IT Project manager in managing actuarial assigning tasks, tracking status and documentation.

Environment: MS Visio, IBM DB2, Advance Query Tool, Informatica PowerCenter Designer, Data warehousing, Data analysis, Blue print, MS Office, SharePoint, IBM Work scheduler, OpenText, JIRA

Confidential, San Antonio, TX

IT Business Analyst

Responsibilities:

  • Conducted JAD sessions with business users / SMEs to elicit and capture business and technical requirements
  • Worked on Texas project delivery frame work with the state strategic planning.
  • Worked on making many final recommendations on procurement decisions involving management of solicitations and contracts
  • Worked on the approvals of business case analysis, statewide impact analysis, project planning, and procurement planning results
  • Assisted QAT team for many contract completions.
  • Interacted with department heads to finalize business requirements, functional requirements and technical requirements and also created Business process model.
  • Managing projects end-to-end using scrum/agile approach to create user stories, product backlog, backlog prioritization, daily standups, removing impediments, sprint retrospectives, etc.
  • Conducted weekly review meetings with team to ensure deliverables were met.
  • Responsible for preparing business requirements documentation for various efforts
  • Created and maintained Narrative Use Cases (Business Use Cases, System Use Cases) and modeled Use Case Diagrams, Activity Diagrams, Data Flow Diagrams using MS Visio.
  • Co-ordinated/facilitated User Acceptance Testing (UAT) with both business user and vendors while documenting the necessary material.
  • Coordinated developing test scenarios, test cases and implemented test plan with QA team.
  • Managing projects end-to-end using scrum/agile approach to create user stories, product backlog, backlog prioritization, daily standups, removing impediments, sprint retrospectives, etc.
  • Performed extensive data analysis using MS Excel and PowerPivot to create pivot tables and charts with the data.
  • Created and used new SQL objects for the implementation of a business requests.
  • Designed Product Backlog Document, System Requirement Specification, and Interface documents.
  • Prepared technical-documentation for projects to explain technical work flow of all modules.
  • Assisted the testing team during the preparation of Test Cases and reviewed test scripts to ensure all functional requirements are being tested and participated in User Acceptance Testing (UAT).
  • Conducted Asset Management, Risk Analysis of the Requirements and Traceability focus areas of the various projects and worked with the project team to help them identify the high-risk areas.

Environment: MS Visio, IBM DB2, Advance Query Tool, UAT, Data analysis, Blue print, MS Office, SharePoint, IBM Work scheduler, RTC, HP Quality Center

Confidential

Business Systems Analyst

Responsibilities:

  • Involved in the Gap analysis on the existing IDW (Integrated Data Warehouse) to ensure what data we need for each work stream with in IDW and the data marts.
  • Involved in the JAD sessions with the business team to understand the requirements.
  • Assisting with the understanding of additional business processes from disparate applications and how to in corporate them into the Application.
  • Eliciting requirements using document analysis, requirements workshops, business process descriptions, use cases, scenarios, business analysis, task and workflow analysis, and/or viewpoints.
  • Involved in analyzing the existing mapping documents for data marts.
  • Created new mapping documents for the target data marts.
  • Analyzed the existing data flow mappings from source to target in Informatica Power Center Designer to understand data flow and relationship of data among tables.
  • Involved in writing and understanding complex queries for DB2 SQL in Advanced Query Tool
  • Involved in analyzing the data using Advanced Query Tool.
  • Involved in understanding and creating of BRDs.
  • Prepared Source to Target mapping documents to help ETL team in extracting and processing the data before loading to the target database.
  • Using development specification, creating detailed use cases, data flow diagrams using Microsoft Visio.
  • Underwent on Blue Print tool for assistance in business requirement management phase.
  • Involved in creating Interface agreements to ensure the transfer of data occurs in an agreed format and timeframe.
  • Assessing existing data flows and recommending solutions to development team.
  • Participated in the review of current business processes and demonstrate improved processes through recommended changes to the Application.
  • Worked closely with other Business Systems Analysts, Process Owners and Development Teams as required.
  • Worked with project team in establishing deliverables and estimating work effort involved in the design and implementation of the Software Application.
  • Participated in the review of current business processes and demonstrate improved processes through recommended changes to the Application
  • Responsible for analysis and translation of user stories into IT requirements, obtaining approval of requirements.
  • Worked with development teams to resolve design issues discovered during testing phases and communicated software issues to the development teams and participated in User Acceptance Testing (UAT).
  • Assisted the testing team during the preparation of Test Cases and reviewed test scripts to ensure all functional requirements are being tested.

Environment: MS Visio, IBM DB2, Advance Query Tool, Informatica PowerCenter Designer, Data warehousing, Data analysis, Blue print, MS Office, SharePoint, IBM Work scheduler, HP Quality center, RTC, Rational Rose

Hire Now