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