Business Analyst

Location:

Albany, NY

Posted:

January 03, 2020

Contact this candidate

Resume:

Priyanka Shyam Kumar

******************@*****.***

518-***-****

SUMMARY

•9+ years of as a business Analyst with hands-on experience in Business Process Modeling, UML Modeling, Prototype design, JAD sessions workshops facilitation and Quality Assurance.

•Lead in user story backlogs, grooming, Release, sprint planning, retrospectives, daily stand-ups, scrum ceremonies, Task Management and Tracing etc.

•Proven ability to partner with cross-functional teams to develop & execute projects plans to deliver high impact results.

•Experience in all areas of project life cycle in a highly structured change management environment using both proprietary methodologies, Agile Techniques, Waterfall methodology and Rational Unified Process.

•Skilled in the areas of writing Business Requirements Document (BRD), Functional Specifications Document (FSD), Test plans and Test cases.

•Identify and extract business requirement documents after meeting with customers or Project Stakeholders.

•Experience in full life cycle Business Intelligence implementations and understand all aspects of implementations.

•In-depth knowledge and experience in the documentation of specifications, design and development of use case scenarios.

•Experience in working as a full-time technical resource for examining and evaluating IT projects.

•Expertise in creating visualization with Tableau desktop, Tableau Server and Tableau Reader in various version of Tableau 10.5, 9.x and 8.x.

•Hands - on with creating solution driven views and dashboards by developing different chart types including Heat/Tree/Geo Maps, Line/Bar/Pie Charts, Scatter Plots, and Bullet Graphs in Tableau Desktop versions 10.5.

•Experience in Business and system analysis including design and development and requirements gathering.

•Creating and tracking user stories and bugs using JIRA.

•Experience in scripting and documentation of Information Technology specifications like technical and Functional design documents along with review of Training manuals.

•Quality assurance testing and developing user acceptance documents.

•Experience in identifying inefficiencies and glitches in documentations and business processes and effectively communicating solutions to team.

•Development of Business requirement documents including use cases, flow charts, screen designs, prototypes, swim lane diagrams and report mock-ups.

•Possess excellent skills in Manual Testing and Automated testing.

•Expertise in using HP ALM Quality Center to write, execute and validate test results and open defects.

•Performed the role of Quality Analyst; experience in creating, maintaining and executing test cases in HP ALM Quality center. Validating and documenting Test results consistently. Promptly logging, tracking and communicating defects to the development team.

•Experience in creating Program design User Interfaces and editing for on line help and providing step by step instructions by creating, importing and Filtering information.

•Experience in testing and using SQL queries for accurate report and development and business requirements.

•Experience in development of end user training materials.

•Hands on experience with HP Unified Functional Testing (UFT) for regression testing and quality assurance of the existing applications.

•Experience in writing Test scripts in parallel to business environments and specifications in an Agile and Waterfall environment.

•Experience in preparing Use case diagrams, activity diagrams and class responsibility collaborators using MS Visio and tools of Project management, tracking status of project and software management like Microsoft Word, Excel, SharePoint and visual basic.

•Excellent documentation skills. Involved in creating technical and functional document in the capacity of Business Analyst. Helped in creating Training Manuals.

•Good understanding of all aspects of Testing such as Unit, Regression, White-box, Black-box.

•Expertise in testing the Data Warehouse and Business Intelligence applications.

•Always worked in a team environment, contributes to quality releases data and products.

•Strong leadership and team-building skills and possess a positive attitude.

•Quickly master and enjoy learning new technologies, methodologies and responsibilities.

•Excellent organizational skills and ability to prioritize workload.

TECHNICAL SKILLS:

Primary Skills

Business Analysis and Design, SDLC Methodology implementation, User Acceptance Testing, User Stories, Use cases, Test plans, Test Scripts, Bug tracking, Facilitating scrums, Project management in Microsoft ITSM.

BI Applications

Business Objects 6.5

Databases

MS SQL Server, Access, Oracle 10g/11g, MS SQL

Methodologies

RUP- Rational Unified Process, Agile Modeling, Waterfall

Operating Systems

Windows 10, Vista/XP/2000/NT/98/95, Red Hat Linux

Other Tools

Requirements Management – Rational RequisitePro,

UML-Rational Rose, Balsamiq V2.2,

MS Visio/Word/Excel/PowerPoint, QTP, Quality Center 11, Rational Clear Quest, Putty, TOAD, Text Pad, Win Merge, MS Office(advanced excel), MS Project, ITSM (Information Technology Service Management), SOAP, JIRA.

PROFESSIONAL EXPERIENCE:

End- Client: Office of Information Technology Services (AGS Cluster)/ Department of Civil Service, Albany, NY

Role: Expert Business Analyst

Duration: February 2017- Current (34 months)

Responsibilities:

•Identify and extract business requirement documents after meeting with customers or Project Stakeholders.

•Worked on understanding the new feature requests from business and triage through requirements and Use cases for applications like Identity Management.

•Extensive use of MS-Excel for data manipulation, reports etc. Leveraged workbench for data and system analysis.

•Experience in updating project status and reports in ITSM.

•Worked on creating documents on Knowledge based articles (KB) and Security related documents.

•Successful troubleshooting and performance tuning of issues in Tableau Server.

•Hands on experience and understanding of reporting objects like Facts, attributes, Hierarchies, filters, sets, groups and parameters in Tableau.

•Worked on creating business requirement documents for projects like Exam System Modernization, Identity Management, Procurement.

•Converted business requirements into functional requirements by creating Use Cases.

•Working closely with UAT personnel to both ensure that their needs are met, and prepared user manual to provide enough understanding for the UAT test teams to own the automated system by the end of the project

•Experience in functional analysis of the current software system and documenting functional requirements documents including business models, user stories, interface and data conversion requirements.

•Own data integrity, business rules, reporting, and analysis responsibilities.

•Experience executing processes to analyze the quality of data imported from legacy systems into COTS systems; establishing and using business rules and analyzing the errors. Experience in assessing and evaluating potential COTS applications

•Analyzed the current process and prepared Business Requirements Document for the future process.

•Written and executed complex SQL queries using SQL server management for back end data validation testing.

•Creating and tracking user stories and bugs using JIRA.

•Assisting as a technical resource in examining the project and specifications and evaluating step by step process.

•Working with Development and QA teams to design and develop test plan, test cases to perform User Acceptance Testing (UAT).

•Served as a primary interface between the developers, testing team, and the project managers on system issues and change requests.

•Have promptly identified inefficiencies and glitches in documentations and business processes and effectively communicated solutions to team.

•Excellent Team player to work in conjunction with other testers, developers and other team members in validation and testing complex scenarios and projects and in the maintenance of Quality Standards in Projects.

•Excellent written, communication, interpersonal skills, proven team player with an analytical bent to problem solving and delivering solutions under high stress environment.

•Worked closely with change management team in analyzing and prioritizing the new requirements.

•Good working knowledge of Microsoft Office Suite including - Word, PowerPoint, Excel, Outlook.

Environment: Agile methodology, SQL Developer, MS PowerPoint, MS word, MS excel, MS Outlook, MS Visio, ITSM.

End- Client: Division of Criminal Justice and Services, Albany, NY

Role: Expert Business Analyst

Duration: November 2015- January 2017 (15 months)

Responsibilities:

•Identify and extract business requirement documents after meeting with customers or Project Stakeholders.

•Worked on understanding the new feature requests from business and triage through requirements and Use cases for applications like Pre- Sentence Investigation, Public Safety Document Repository.

•Extensive use of MS-Excel for data manipulation, reports etc. Leveraged workbench for data and system analysis. Furnished reports for Pre- Sentence Investigation submitted by Counties.

•Converted business requirements into functional requirements by creating Use Cases.

•Own data integrity, business rules, reporting, and analysis responsibilities.

•Analyzed the current process and prepared Business Requirements Document for the future process.

•Performed the role of Quality Analyst; created, maintained and executed test cases for Pre- Sentence Investigation, Public Safety Document Repository, COMPAS and Integrated Probation System in HP ALM Quality center. Validated and documented Test results consistently. Promptly logged, communicated and tracked defects to the development team.

•Written and executed complex SQL queries using SQL server management for back end data validation testing.

•Assisting as a technical resource in examining the project and specifications and evaluating step by step process.

•Worked on creating Training Manuals for Sentencing Minutes Applications.

•Served as a primary interface between the developers, testing team, and the project managers on system issues and change requests.

•Have promptly identified inefficiencies and glitches in documentations and business processes and effectively communicated solutions to team.

•Excellent written, communication, interpersonal skills, proven team player with an analytical bent to problem solving and delivering solutions under high stress environment.

•Worked closely with change management team in analyzing and prioritizing the new requirements.

•Good working knowledge of Microsoft Office Suite including - Word, PowerPoint, Excel, Outlook.

Environment: Agile methodology, SQL Developer, SOAP UI, HP ALM Quality Center and UFT, MS PowerPoint, MS word, MS excel, ITSM.

End-Client: Office of Children and Family Services, Albany, NY

Role: Senior Business Analyst

Duration: August 2014 – October 2015 (15 months)

Responsibilities:

•Worked on understanding the new feature requests from business and triage through requirements and use cases

•Extensive use of MS-Excel for data manipulation, reports etc. Leveraged workbench for data and system analysis.

•Preparing Use case Diagrams, activity diagrams and class responsibility collaborators using MS Visio and keeping project updated with Microsoft Word.

•Experience as a technical resource in examining and evaluating activities to assure efficient operations and compliance with policies.

•Identify and extract business requirement documents after meeting with customers or Project Stakeholders.

•Own data integrity, business rules, reporting, and analysis responsibilities.

•Analyzed the current process and prepared Business Requirements Document for the future process.

•Experience in scripting and documentation of Information Technology specifications like technical and Functional design documents along with review of Training manuals.

•Experience in creating Program design User Interfaces and editing for on line help and providing step by step instructions by creating, importing and Filtering information

•Working closely with UAT personnel to both ensure that their needs are met, and prepared user manual to provide sufficient understanding for the UAT test teams to own the automated system by the end of the project

•Have promptly identified inefficiencies and glitches in documentations and business processes and effectively communicated solutions to team.

•Writing test scripts in parallel to business environments in an Agile environment.

•Converted business requirements into functional requirements by creating Use Cases.

•Served as a primary interface between the developers, testing team, and the project managers on system issues and change requests.

•Written and executed complex SQL queries using SQL server management for back end data validation testing.

•Prepared data element table and mapping documents for system generated templates.

•Creating and maintain metrics, standards and policies required by the business processes.;

•Established a standard process for flow diagrams and created a template to document requirements.

•Hands on experience with HP Unified Functional Testing (UFT) for regression testing and quality assurance of the existing applications.

•Performed the role of Quality Analyst; created, maintained and executed test cases in HP ALM Quality center. Validated and documented Test results consistently. Promptly logged, communicated and tracked defects to the development team.

•Worked closely with change management team in analyzing and prioritizing the new requirements.

•Excellent written, communication, interpersonal skills, proven team player with an analytical bent to problem solving and delivering solutions under high stress environment.

Environment: Agile methodology, Rational Requisite Pro, HP ALM Quality Center and UFT, MS Visio, MS word, MS excel, ITSM.

Client: Carestream Health Inc., Rochester, NY

Role: Business Analyst

Duration: January 2013- July 2014 (18 months)

Responsibilities:

Interacted with business users to gather requirements and analyzed the feasibility of their needs by coordinating with the project manager and technical lead.

Assisting as a technical resource in examining the project and specifications and evaluating step by step process.

Identify and extract business requirement documents after meeting with customers or Project Stakeholders.

Experience in scripting and documentation of Information Technology specifications like technical and Functional design documents along with review of Training manuals.

Refined the existing use cases and non-functional requirements documentation

Prepared Business Requirement Documents (BRD) and used Requisite Pro to manage, analyze, and convert business requirements into functional specifications.

Conducted JAD or group facilitation sessions with SME’s for requirement gathering.

Documenting existing AS IS business processes and created TO BE process models.

Created workflow models in WBM 6.1 Advance, to generate the Business Process Execution Language (BPEL) using WID for service development for SOA implementation.

Established a process for functional/domain decomposition and identifying candidate services from individual tasks/activities modeled in WBM for business process reengineering by following SOA implementation process.

Test scripts written in parallel to business requirements development activities in an Agile environment.

Experience in functional analysis of the current software system and documenting functional requirements documents including business models, user stories, interface and data conversion requirements.

Working with Development and QA teams to design and develop test plan, test cases to perform User Acceptance Testing (UAT).

Worked on creating Packages, Stored Procedures & Functions in Oracle using PL/SQL and TOAD. This clearly separates the Business Logic from the Backend access to the Database and the Front-end Presentation layer.

Successfully established a process to create a team share WBM modeling environment in ClearCase.

Established along with the modeling unit head of an enterprise process modeling standard document to be used for modeling across organization for SOA implementation.

Performed the role of Quality Analyst; created, maintained and executed test cases in HP Quality center. Validated and documented Test results consistently. Promptly logged, communicated and tracked defects to the development team.

Preparing Use case Diagrams, activity diagrams and class responsibility collaborators using MS Visio and keeping project updated with Microsoft Word.

Established a template to capture metrics for business process model development and service identification for reporting.

For the architect board of DOL captured all business items in the form a catalogue before modeling the process.

Prepared user guide for internal staff on working on WBM 6.1 Advance to generate BPEL from process models for SOA implementation.

Worked closely with change management team in analyzing and prioritizing the new requirements.

Review the existing use cases to identify the business items. Successfully created the same as a deliverable from the modeling unit.

Created logic using the truth tables and crated data element tables.

Assisted in designing test plans, test scenarios and test cases for integration, regression and user acceptance testing (UAT)

Environment: Rational Unified methodology, Agile Methodology, advance 6.1, Rational Requisite Pro, Quality Center, MS Visio, MS word, MS excel, MS Outlook, Oracle 9i

Client: Strides Arco Pvt Ltd, Bangalore India

Role: Business Analyst- Intern

Duration: July 2009- July2012 (36 months)

Responsibilities:

•Worked with the business users to define business requirements and analyze the possible technical solutions.

•Conducted Gap Analysis of the As-ls and To-Be processes to derive requirements for existing systems enhancements.

•Developed many reports/dashboards with different analytics views (Drill-Down, Pivot table, Chart, Column Selector, and Tabular with global and local filters).

• Extensive experience in writing and tuning complex sub queries, SQL, PL/SQL stored procedures, functions, and triggers.

•Interviewed key users and facilitated brainstorming sessions to gather business requirements and acted as a liaison between key users and technical teams.

•Created a System Test Plan, Test Cases, and procedures for System Testing.

•Organized and documented different requirements documents including User Requirements Specification (URS) and User Stories.

•Created technical specifications documents that documents the changes to the User Interface and workflow in the form of technical requirements.

•Prepared use case diagram, activity diagram and class responsibility collaborator models using MS Visio.

•Documented and tracked Change Requests and coordinated with the Change Control Board (CCB).

•Creating and maintain metrics, standards and policies required by the business processes.

•Performed task decomposition, delegated tasks and monitored project milestones using MS Project.

•Coordinated meetings with the business partner, tech and QA teams to bring everyone on the same page and maintain working relationships.

Education:

Bachelor of Commerce in Foreign Trade, Osmania University, Hyderabad, Andhra Pradesh

Contact this candidate