We provide IT Staff Augmentation Services!

Senior Business Analyst/ Scrum Master Resume

Raleigh, NC

PROFESSIONAL SUMMARY:

  • Results - driven, detail-oriented and well qualified Senior Business Analyst, Business Systems Analyst&Scrum Masterwith 8+ years of industry experience in Business Development Process and System & Data analysis with solid understanding of Business Requirement gathering, Business Process Flows, Business Process Modeling, Case Tools, and Business Analysis.
  • Expertise in Software Development Life Cycle (SDLC) methodologies like Waterfall, Scrum-Waterfall Hybrid, Agile (Scrum, Test Driven Development, Kanban) in domains like Banking, Finance and Insurance.
  • Strong experience in tracing requirements throughout development life cycle by creating Requirement Traceability Matrix (RTM) using MS Excel & tools like JIRA and HPALM. HandledChange Requests by taking upon the role of Change Owner, Interacted with Change representatives,CCAB to review Impact Analysis and documented Change Request Form.
  • Acquainted with workflows and Unified Modeling Language (UML) diagrams including Use Cases, Activity Charts, Sequence Diagrams, Data Flow Diagrams, and ER Diagrams using MS Visio.
  • Created Business Requirements documents (BRD), Use-Case Specifications and System Requirements Specifications (SRS) accompanied by active participation in discovery sessions, interviews, document-reviews with customers.
  • Conducted GAP, Impact, SWOT, Cost benefit analysis, Root cause, Interface Analysis, Feasibility study, ROI Analysis, Impact analysis, Risk Analysis, and As-Is and To-Be business analysis.
  • Elicited requirements using techniques likeInterviews, Brainstorming, Focus Group, Document Analysis, JAD sessions, Survey/Questionnaires and documented Business Requirements Documents (BRD), System Requirements Specifications (SRS), and Functional Specification Document (FSD).
  • Decomposed Functional requirements to User Stories to meet INVEST criteria and then helped in prioritizing user stories using various prioritization techniques like MoSCoW and Kano Model. Assisted Product Owner in creating Acceptance Criteria and Definition of done for requirements. Used Planning Poker for estimation of user stories.
  • Extensive implementation knowledge of Databases, Data Table structures, Schemas (Star, Snowflake, Galaxy), Data Marts and OLAP operations such as Roll-up, Drill-down, slice and dice and pivot.
  • Working knowledge of Informatica MDM multi domain addition and ETL tools like Informatica Power center for Data Normalization &Data Mapping. Proficient in creating Entity Relationship (ER) models and dimensional models. Assisted in data profiling, data cleansing and data validation in Data Warehouse projects.
  • Experienced in Black-box Testing, System Testing, Regression Testing, Load/Stress Testing, and Performance Testing.
  • Worked with QA team to design Test plans, Test strategies, Test scenarios, Test Cases, Test scripts for User Acceptance Testing (UAT) using HP Quality center/ HP ALM. Also created Requirement Traceability Matrix (RTM).
  • Performed CRUD operations on databases using DDL, DML, and DCL along with select, joins, and stored procedures and exposure to various database platforms such as Oracle and Microsoft SQL Server.
  • Extensively used reporting tools like Tableau to create visual representation of Data Analytics using Dimensions and Measures. Used MS Excel and IBM Cognos for BI analytics and reporting.
  • Strong knowledge in Web Services, SOA Architecture using SOAP and REST APIs. Strong understanding of XML and JSON messages and also responsible for API documentation using MS Excel.
  • Designed the Test Cases in SOAPUI for API testing, Test Plans for documentation of all processes using Confluence.
  • Sound knowledge of Selenium IDE and used Cucumber for Behavior Driven Development (BDD). Good Understanding of Project Management activities, proficient with Project Management Tools, testing tools and defect reporting tools.
  • Efficient skills in Unix, SQL, Functional Test Planning-Preparation-Execution, HP Software (Mercury) - Quality Center, Zephyr, Test Automation using QTP and have knowledge of VB Scripting
  • Experience in developing Test Plans based on the user Requirement Documents, design requirement document and System Requirement documents for the Functional, Regression, Load, Performance, User Acceptance Testing
  • Expertise in implementing test approaches and test plans to test application enhancements and changes against documented business requirements and user stories and translate them to Test plans, Test scenarios, test scripts, test cases and executing them.
  • Excellent Analytical, Problem solving, Communication and Documentation skills. Dedicated & Self- motivated, Proven leadership capabilities and Time management skills. Communicated effectively across company contacts and clients, internal team about the project requirements, schedules and launches.
  • Having exposure to multi-cultural, diverse ethnic environments.

TECHNICAL EXPERTISE:

SDLC Methodologies: Waterfall, Agile-Scrum, Waterfall-Scrum Hybrid, Extreme Programming (XP), Spiral, SAFE, Kanban, Scrum-ban, Rational Unified Process (RUP).

Requirement Management Tools: JIRA, Rally, TFS, Version ONE, MS Project, Rational Requisite Pro, HP QC, HP ALM

Reporting Tools: IBM Cognos BI, Micro Strategy, Business Objects, Tableau, SQL Server Reporting Service, Microsoft Power BI, Spotfire.

Graphical &Modelling Tools: MS Visio, Balsamic, Rational Rose, UML, Mock-up Screens.

Databases: MS Access, MYSQL, Microsoft SQL (T-SQL), Oracle 9i & 10g (PL/SQL).

ETL Tools: SQL Server Integration Services, Oracle Warehouse Builder, IBM Cognos Data Manager, Informatica Power Center, Oracle Data Integrator.

Testing Tools: HP QTP, LoadRunner, Bugzilla, Selenium, SOAP UI, Oracle Application Testing Suite (OATS)

Microsoft Tools: MS Office Tools (Word, PowerPoint, Excel) MS Access, MS SharePoint, Outlook 365

Languages: SQL, PL/SQL, T-SQL, HTML, XML, C, C++, JAVA. .NET

Operating Systems: Windows XP, 7, 8, 10, Linux, Mac OS

PROFESSIONAL EXPERIENCE:

Confidential, Raleigh, NC

Senior Business Analyst/ Scrum Master

Responsibilities:

  • Performed requirements modeling and develop analysis diagrams, activity diagrams, sequence diagrams, state diagrams, data models, and use-case realizations using RUP tools in Agile.
  • Adjust workforce requirements based on changing/dynamic call volume patterns to manage work shifts.
  • Involved in interactions with Subject Matter Expert, Developers and the end-users in more than one JAD sessions. MS Project proved useful in coordinating activities with project manager and various other teams.
  • Analyzed the prior documentation and business processes for full understanding of the project. Documented Business Requirement Document (BRD) and Functional Requirement Document (FRD).
  • Manage changes to requirements through change control -clear case, MQC, Document.
  • Gathered requirements to upgrade the Time and Attendance system from a client server to a web-based application with three methods of time entry; Time Clocks, Web and Tele time IVR.
  • Develop complex standard and ad-hoc reports and queries for analysis, controls, and/or reporting using Workday HR/Payroll systems.
  • Analyzed UltiPro software features and developed high-level requirements and preliminary scope statement for customization of company UltiPro employee web portal.
  • Liaison with all Finance groups, Legal, IT, HR and Store Operation departments to maintain integrity of data and system setup to ensure pay and distribution accuracy.
  • Responsible and Accountable for providing statistical information from each call center site to Workforce Manager utilizing historical data and forecasting results.
  • Provides innovative methods to offer efficient and effective HRIS information and processes.
  • Manages all aspect of HRIS systems, including manual data entry and Manager/Employee SS.
  • Developed Enable strategy and capabilities including resource and capacity planning to grow the practice with expertise in Workday organically and through other models.
  • Manages and engages HRIS team. Provides and development processes.
  • Create a workforce management calendar to track mailings, large scope events and any significant event that impacts volume or capacity.
  • Identifies needs for HRIS systems and develops tools
  • Conducted periodic audits and testing of PeopleSoft system to ensure payroll calculations meet business and legal requirements
  • Participate in discussions and team meetings for improving the efficiency for data conversion and global template solution. end users for using the Workday HRIS system through workshops.
  • Works with key users and the HRMS Technical Manager to prioritize and schedule issues resolution.
  • Reviewed the Functional Requirements of the COTS products and evaluated the integration of COTS with the existing system.
  • Ensured information captured in Workday HR was calculating correctly.
  • Conducted UAT to confirm that all derivative products can be successfully processed through stages of the trade life cycle
  • Extensive knowledge of employee benefit laws and regulatory requirements; experience working with vendors to update SPD’s; experience administering FMLA, disability, and workers’ compensation leaves
  • Produced metrics which provide management insight into the requirements process, to include, status, size, volatility, quality, effort, etc.- Visio, Rational Tools, Traceability Matrixes.

Environment: Agile-Scrum, Windows XP/2000, Oracle, PL/SQL, MS-Project, MS-Office Suite, MS Visio, Rational Requisite Pro, Clear Case, Clear Quest, MS Visual Source Safe, Test Director 7.6, Quick Test Pro (QTP)

Confidential, Stamford, CT

Senior Business Analyst/ Scrum Master

Responsibilities:

  • Gathered requirements through interviews, meetings, and existing documentation and conducted UAT.
  • Involved in gathering requirements for Mobile Application (IOS and Android app)
  • Analyzed the requirements for the project from DOORS requirements/version control tool.
  • Set up meetings, conducted Walkthroughs, JAD sessions with Management, SMEs (Subject Matter Experts), vendors, users and other stakeholders to resolve open and pending issues and to develop specifications.
  • Analyzed and managed projects for a large investment company to deliver information to customer's wireless devices including cell phones, pagers, mobile intranet devices and other internet applications.
  • Managed server to server project to deliver additional monitoring tools for support of server to server alerts sent to client investment companies
  • Produced Use Case, Domain Dictionary, UML Charts and diagrams. Assisting in developing object models from the functional requirements and architecture using UML methodologies and modeling tools knowledge (Rational Rose) (RUP Methodology).
  • Participate in discussions and team meetings for improving the efficiency for data conversion and global template solution. end users for using the Workday HRIS system through workshops.
  • Design and development of major “Dash Board” software application.
  • Identified internal and external system requirements, design and configuration set-up, also created User Documentation and conducted classes.
  • Used Visio to develop Use Case diagrams, Activity Diagrams and Sequence Diagrams.
  • Analyzed and discussed the business and functional requirements for the application under construction.
  • Worked with the quality assurance team so as to test different releases and to develop test plans and test cases.
  • Testing platform and the Workforce Management (WFA) system; allowing for the processing of both Local Service Request (LSR) and Access Service Requests (ASR).
  • Conducted sessions for the end users and documented various manuals.
  • Involved in the system workflow analysis and contributed to the overall work flow diagram for the website.

Environment: Agile- Scrum, ASP.NET, Windows NT /2000, SQL, MS Word, MS Excel, Ms-Visio, Cognos BI, MS Project, Clear-Quest, Rational Test Manager, Lotus Notes R6 client, Notes SAS.

Confidential, Tampa, FL

Senior Business Systems Analyst

Responsibilities:

  • Coordinated with mortgage servicers, database team and business users to prepare new file templates and final list of as per CREFC’s Investor Reporting Package standard included in the framework of the MISMO.
  • Identified third party services, performed Feature Analysis and developed RFP document.
  • Liaised between the financial reporting team, business users, mortgage servicers and the development team.
  • Facilitated brainstorming sessions, conducted one-on one interview and JAD sessions with servicers and business users for eliciting new reporting and data requirements.
  • Documented the requirements in BRD and created the FSD .
  • Performed GAP analysis by creating the As-Is and To-Be business models.
  • Assisted the team and Product Owner by fluently translating the gathered requirements into User Stories as per the INVEST criteria and enforced Acceptance Criteria for the same.
  • Created and presented UIprototypes of the enhanced web portal and applications to the business users and concerned stakeholders, using Mockup screens and Wireframe.
  • Verified priorities and feasibility of the User Stories with the team and Product Owner during the Sprint Planning meeting and Backlog Grooming sessions.
  • Helped the team to properly decompose the User Stories into Tasks.
  • Coordinated with the team, business users and created the Data Mapping Document as per the requirements of the stakeholders, business users and financial analysts.
  • Updated the existing Data Dictionary.
  • Identified and analyzed data sources thoroughly before performing data profiling.
  • Worked with the Database team and DBAs to update the existing data models of the Enterprise Data Warehouse.
  • Assisted ETL developers in creating workflows and scheduling of batch processes using Informatica PowerCentre, based on Data Mapping Document.
  • Worked with data scientists and data analysts to integrate the Math Library containing algorithms for better analytics.
  • Documented overall business processes, data and information flow.
  • Provided ad-hoc query assistance to Data Warehouse users when required.
  • Aided during the creation of reports, cubes and datasets using MicroStrategyIntelligence and Web Services invoking the SDK.
  • Gathered and documented API requirements for integrating reports with JSP and accessing external and internalWeb-Services using JAX-RS(Java API for XML services) and AJAX(Asynchronous Java and XML).
  • Made provisions for user by creating and including documentation.
  • Created and maintained SharePoint sites for the Data Warehouse user community, containing models, mapping documents, and aids.
  • Created Test Cases and imported them to Informatica PowerCentre DVO to validate and test the loaded data.
  • Used Cucumber and HP ALM and worked with the QA team to create Test Plan, Test Scenarios and Test Cases for reports integrated with client web-portal and application.
  • Facilitated UAT sessions for testing web-applications and web portal functionalities.

Environment: Agile- Scrum, Ms Office tools (Word, Excel, PowerPoint, UNIX, JBoss EAP 4.3, Java EE 7, JSP, XML, XSD, JSON, AJAX, XMLSpy, HTML5, GIT hub v2.0, Oracle 11g, MS Visio v15.0, MS SharePoint v6.0, Cucumber v2.3.3, InformaticaPowerCenter 10.1, Informatica DVO, MicroStrategy 9.x, MicroStrategy Web SDK, R version 3.2.5, Eclipse, Swagger UI, JIRA v6.4, Confluence v6.0, Jenkins, HP ALM

Confidential, New York, NY

Business Systems Analyst

Responsibilities:

  • Identify and document Business Requirements for four major risk areas: internal controls, IT risk assessments, business risk assessments, and compliance risk assessments.
  • Created Business Requirement Document (BRD) and Functional Requirement Document (FRD) based on RUP and Agile framework.
  • Responsible for maintaining Project SharePoint site to facilitate document version tracking and user learning repository.
  • Created and maintained Use cases, Use case diagram, Activity diagram, and other flow charts and material for the GRC tool application.
  • Facilitated and conducted userinterview workshops with all SMEs to document their current state of risk assessment processes.
  • Performed Data Mining to find correlation and pattern in existing data and constructed SQL queries.
  • Assisted in the implementation of Integrated Data Warehouse with individual data marts to address areas of business interest. Used ETL to map data, assemble data repository and created data marts.
  • Strong knowledge in ETL tool, Informatica Power Center for Data Normalization (1NF, 2NF), Data Indexing & mapping using and Informatica Data Quality for Data Profiling and Data Integrity using Informatica DQ.
  • Documented all collected risk processes in MS Visio using business process modeling methodology.
  • Worked with SMEs to create mock-ups for various forms and workflows to be used in the GRC tool application.
  • Conducted data gap analysis sessions with various SME’s to document the various data requirements for the application including extracting Global Users list, Organization Structure Information and Risk Libraries for selection.
  • Identified and documented Gaps between Off the Shelf GRC tool application and desired future state by the client for customized configuration of the application.
  • Acted as a liaison between internal IT Department, Business and external GRC tool software vendor to track and report open issues, actions, risks & dependencies during the project.
  • Worked with the QA team using ClearQuest and HPQC for User Acceptance Testing and Defect tracking.

Environment: Hybrid,Microsoft Windows 10, HPQC, Clear Quest, Java, Microsoft SharePoint, Microsoft Project, MS Office Suite, MS Visio.

Confidential

Business Analyst

Responsibilities:

  • Gathered requirements on the online brokerage platform from stakeholders by facilitating JAD sessions and extensive meetings with SMEs. Conducted Gap Analysis and created AS-IS and To-Be Process Flows documentation.
  • Conducted data mapping & data indexing for retrieval of information from existing account systems & outlined security measures for accessibility and transmission of information using standard templates in MS Excel. Created Requirements Traceability Matrix (RTM) to track requirements and test cases using Rational Requisite Pro.
  • Assisted and worked with Project manager in creating and assigned task through Work Breakdown Structure (WBS).
  • Interacted with the customers and internal stakeholders in defining project scope boundaries and gather user requirements and their expectations from the system to create BRD, FRD and SRS.
  • Created business and functional requirement documents and prepared Use Cases models, Sequence Diagrams and Activity Diagrams using tools such as Rational Rose and MS Visio.
  • Worked with the QA team for designing Test Plan and wrote Test Cases for the User Acceptance Testing (UAT) and assisting the Automation Testers in System Testing, Integration and Regression Testing.
  • Developed plans for verification and validation of requirements at all levels so that developed software successfully fulfilled user expectations and business needs.
  • Worked closely with Project Manager for any change request and helped to do Impact Analysis.
  • Worked with Quality Assurance (QA) testing team in preparing the test cases, test plan and procedures for system testing
  • Used HPQC for allotting tasks, issue tracking and requirement traceability. Documented the cause analysis and final resolution to the issues. Designed and Implemented SQL queries for QA testing and reporting data validation.
  • Conceptualized and implemented a production issue management process for an Auto Claims Management System.

Environment: Waterfall, MS Visio, MS Office Suite, MS Access, SQL version, Rational Rose, HP Quality Center, MS Project, MS Visio, MS Office (MS Excel, MS Word, MS PowerPoint).

Confidential

Business Analyst

Responsibilities:

  • Conducted brainstorming and interviews with business heads to finalize the business requirements.
  • Documented requirements and created Project artifacts such as FSD, SRS and RTM.
  • Prepared Data Mapping Documents for the reporting documents generated by the system.
  • Led requirement elicitation & management, competently upheld business requirements on HP QC.
  • Created the mocks and UML diagrams such as Use Cases, Activity, and Sequence using MS Visio.
  • Performed extensive business process analysis including data analysis and GAP analysis
  • Assisted development team in creating prototypes based on requirements specifications.
  • Prepared Data Mapping Documents for the reporting documents generated by the system.
  • Integrated various OLTP to the OLAP by using Informatica as an ETL tool.
  • Schema design in Erwin and implement in database and preparing the technical design document for ETL.
  • Gathered requirements for Client-Side Validation, and Server-Side Validation. Gained understanding of three tire and n tire architecture, understanding of request and response flow.
  • Worked with QA team in creating a test scenario, test cases, test steps. Involved in software integration testing, regression testing, UAT testing and web services API testing using SOAP UI.
  • Prepared UAT test document and developed Test Scenarios for validating the Business requirements and Uploaded Test scenarios, mapped Business requirements to Test scenarios and updated defects and defect tracking in HP Quality Center.
  • Worked extensively with the QA team for designing Test Plan and Test Cases for the User Acceptance testing.

Environment: Informatica PowerCenter 9.0, Apache Tomcat, Oracle 10g, HP QC, Java/J2EE, XML 1.0, HTML MS Office, MS Project, MS Visio, UML2.2, SOA, SOAP UI

Hire Now