Project Test Cases

ABHISHEK SINGH

Phone# 609-***-**** Email: ac1th7@r.postjobfree.com

PROFESSIONAL SUMMARY:

Over 9 years of experience as a Sr. Business Analyst and QA Lead with expertise in the development and enhancement of new business processes in various domains such as Healthcare, Financial and E-Commerce.

Expertise with analytical reporting using Advanced Excel features like Pivot tables and charts.

End-to-End grasp of the entire software development life cycle (SDLC) including analysis, design, development and testing of software applications in both Agile and Waterfall methodologies.

Expertise in creating UML based Modeling views like Activity / Use Case/User Stories/Data Flow/Business Flow, Wire Frame diagrams using MS Visio.

Having worked on Agile Methodology; have experience in writing Stories, conducting Grooming Sessions, Prioritizing Stories, Conducting Pre-UAT approvals, Daily Scrum Standup and coordinated planning session with Scrum Master.

Prioritized Stories each Sprint and created Roadmaps every Quarter for Management..

Wrote Functional and Non- Functional requirements (NFR).

Hands on Experience in MS Visio for creating Flow charts.

Facilitated and attended Scrum ceremonies (grooming, sprint planning, retrospectives, daily stand-ups, etc.)

Experienced in writing Business Requirements Document (BRD), Functional Requirements Document (FRD), Request for Proposal (RFP), Statement of Work (SOW) and Standard Operating Procedures (SOP).

Initiated and Involved in Organizational Change Management (OCM) during migration from the old system to the new system.

Skilled in creating overall project schedule using MS Project.

Hands on experience in development and deployment of project management methodologies including policies, procedures and best practices and working on large-scale projects to develop and test new processes.

Excellent skills formatting and facilitating Joint Application Development (JAD’s) for eliciting data that support the business requirements and documenting data flow.

Writing SQL queries with various databases like Oracle, PL/SQL Developer.

Reviewed and coordinated Test strategies, Test plans, Test cases, developing and maintaining Test scripts.

Conducted User Acceptance Testing (UAT), interacted with team members in analyzing and fixing bugs.

Report Generation in Quality Center/ALM related to defect report and validated defects after bugs were fixed and performed Regression Testing.

Performed System Testing, Integration Testing, Functionality Testing, Negative Testing, Batch Testing, Multi Browser Testing and Devise Testing (Mobile App, Mobile Web).

Hands on experience with interacting with Onsite/Offshore team.

Experienced in creating step-by step user manuals to implement new processes and technology along with providing Training, mentoring and guidance to Team members.

Education:

Master of Business Administration (MBA)

Bachelor of Engineering in Electrical & Electronics

Technical Skills:

Operating Systems

Windows, Macintosh

Databases

SQL Server, MS Access, Oracle, My SQL

Defect Tracking Tools

Bugzilla, Rational ClearQuest, HP Quality Center

Requirements Management

SharePoint, Rational Requisite Pro, JIRA, RALLY, Version One

Project Design & Architecture

Microsoft Visio, Rational RequisitePro, Gliffy, Rational Rose, Paint, Axure RP, Blueprint Requirement Center

Other Tools

MS Office Suite, Toad, MS Project, MS SharePoint, Oracle WebCenter Content, IBM FileNet, Sterling Commerce

Agile methodologies

Scrum, Kanban, Safe

PROFESSIONAL EXPERIENCE:

SCL Health System, Denver, CO Sep 2014 – Till date

Sr. Business Systems Analyst

SCL Health is a not-for-profit organization sponsored by Sisters of Charity of Leavenworth and is a $2.4 billion health network. The project involves implementation of PeopleSoft CRM Sales application which includes Account, Lead and Work flow management. Allowing customer information to be updated rapidly as an institution engages with a potentially troubled account in real time. Work flow management was a key to the implementation as they had plenty of automated business rules.

RESPONSIBILITIES:

Worked on AGILE Environment with daily scrum meetings, grooming sessions, planning and sprint cycles.

Groomed stories effectively using OneNote as an effective tool and gathered business requirements through discussions and brainstorming sessions and conducted specification reviews and walkthroughs with the designers, developers and stakeholders.

Used JIRA as a tool to write stories updates, maintain and groom the backlog.

Created, developed and modified reports and queries to pull data and consolidate information from a variety of sources, e.g., PeopleSoft, Access, Excel and other applications.

Created Requirements Specifications, Use Case Diagrams, High Level and Detailed Process Flows, Robustness Diagrams and Domain Model as well as standardized a process that decreased requirements gathering and analysis time by 50%.

Proactively conducted interviews with all stakeholders elicited detailed requirements, modeling requirements in an organized manner.

Conducted JAD sessions and gathered client requirements to translate into detailed project plans that met budgets and deadlines.

Assisted programmers and developers during designing, coding, testing, deploying, maintaining, and supporting client initiatives.

Administered infrastructure development by enhancing the scalability of the organization, allowing the proper systems and processes to be integrated with the business’ best practices ensuring consistency and stability.

Identified and communicated project risks and recommended solutions and communicated difficult/sensitive information tactfully to a diverse audience including executives, managers and SME’s when needed.

Collaborated with customers to identify business problems and future process improvements.

Established go-forward business requirements via industry standard techniques such as: site visits, user interviews, document analysis, requirement workshops, surveys, and scenarios.

Participated in technical design sessions, working with technical resources, to provide insight during solution development

Prioritized Production issues and assigned them to the Business Analysts. The effort enhanced the application and decreased time for the business depending on the issue.

Supported the migration of older database servers, web servers to newer technologies.

Interfaced with clients to scope projects, manage budgets and direct the development cycle from inception to completion.

Conducted User Acceptance Testing (UAT) and involved in different testing such as Integration testing, ADA testing, Multi Browser testing, Multi Device (Mobile App, Tablet) etc with the cross-functional business teams to ensure the system was aligned with the vision of the business teams.

Conducted reviews with QA team for Test Scenarios, Test plans, Test cases and analyzed Test results and involved in Defect management using ALM (Quality Center - QC) and made sure those defects are efficiently passed from one layer to another.

Organized and presented complex technical information effectively.

Defined business processes and functional requirements for PeopleSoft CRM applications.

Developed business cases, scope statements,and functional specification documents.

ENVIRONMENT: ALM (Quality Center), JIRA,Java, PL/SQL Programmer, Oracle, Version One, UNIX, QTP, MS Visio, Excel, Word, Power Point, SharePoint, OneNote, Oracle WebCenter Content

BOK Financial Corporation, Tulsa, OK Jan 2013 – Aug 2014

Sr. Business Analyst/QA Lead

BOK Financial Corporation is a $26 billion regional financial services company based in Tulsa, Oklahoma. They operate 7 bank subsidiaries in 8 states with more than 200 locations. The project focus was on process analysis and re-engineering Wealth Management service model transform from a static traditional approach to a dynamic one driven by client needs.

RESPONSIBILITIES:

Analyzed the Business requirements and flow of the business processes.

Createddocumentation for the Business Requirement Document (BRD) and translating it into detailed Functional Requirement Specifications Document (FRD).

Experience conducting Joint Application Development (JAD) sessions.

Fulfilled project management role and created extensive documentation, training manuals, proposals and presentations.

Developed operational training and support documentation, gather and organize information on problems or procedures.

Analyzed the data gathered and developed solutions or alternative methods of proceeding.

Provided end user support, training, and communication for various software applications.

Helped team members in designs, plan and coordination with work teams.

Developed technical specifications and diagrams using MS Visio.

Identified and created test cases in QC based on the requirements.

Involved in preparation of the Test Data by using QC to house test documentation.

Provide clarification to create data-driven tests in QTP to help test key features.

Involved in testing of desktop application by inserting checkpoints in QTP scripts for single or multiple objects/text.

Extensively used SQL queries and UNIX commands to first verify the data at file level and then at database level.

Wrote several test cases to ensure all OATS and SEC reporting is within specification.

Reported/tracked all issues and defects and logged them in Quality Center.

ENVIRONMENT:Quick Test Professional, Windows, Vista, XP, Macintosh, Java, .Net

Lowe’s Corporate, Mooresville, NC Jul 2009 – Dec 2012

Business Analyst/QA

Lowe's Companies, Inc. (NYSE: LOW) is a FORTUNE® 50 home improvement company serving approximately 16 million customers a week in the United States, Canada and Mexico through its stores and online. This project focus was on the modernization of Lowes.com Infrastructure, Self-Checkout software and hardware upgrade. This included the utilization of a struts-like application framework, extensive use of real time web-service based transactions, and the introduction of browser-side AJAX technology. Self-Checkout (SCO) machines provide a mechanism for customers to pay for the purchases from Lowe’s retail stores without direct input to the process by retail staff.

RESPONSIBILITIES:

Worked closely with Product Owner and Team lead (SME) in understanding existing system functionalities.

Worked closely with PO in effort to create Project Charter document and get sign-off from Business Owner.

Followed Scrum Methodology for appropriate planning and development process.

Functioned as the bridge between functional business units and IT.

Developed, implemented and documented software development and SQA processes.

Configured and administered VersionOne as the team's Agile management tool.

Provided VersionOne training to the software development team and business stakeholders.

Developed the product backlog along with Product Owners

Guide the development teams to break down large and complex user stories into simplified versions for execution

Test the user stories for accuracy and compliance to ensure undisputed acceptance and validation of stories

Coordinate project initiatives with software developers, stakeholders, project managers and software testers

Documented, coached, and elicited business requirements from subject matter experts by writing user stories resulting in a clearer, more detailed and more complete understanding of project deliverables.

Prepared, scheduled and lead meetings between enterprise business and technical resources and multiple vendors in preparation for demonstrations and site visits resulting in more efficient and productive meetings with fewer follow up questions and communications.

Conducted Grooming sessions, Participated in Planning session, and Daily Scrum Standup.

Participated on group discussion and JAD sessions with project stakeholders. (SMEs, PM & TL)

Map existing system features with new features using process-mapping technique. (Using MS Visio)

Elicit the Business requirements using existing system documents and group discussion with SMEs and prepared requirement artifacts.Used Lowes SharePoint site to manage all the requirement artifacts.

Planned and implement the integration of Sterling Commerce, Endeca, Taxware into the existing infrastructure.

Incorporated enhancements and feedback to the "Store Pickup" as customer’s shipping option (BOPUS) when an order is placed on Lowes.com or on the mobile app.

Reviewed and made necessary adjustments to test cases written for manual testing.

Assisted in the development of training materials (e.g., FAQs, user guides, workflow charts) and training delivery.

ENVIRONMENT: IBM Web sphere, Java, DB2 and SQL, Windows, Quality Centre, CIS browser, Service online channels, Version One, Sterling Commerce, Endeca, Taxware.

Sun Healthcare Group, Irvine, CA Feb 2008 - Jun 2009

Sr. Business Analyst

Sun Healthcare Group provides long-term, sub-acute, and related health care services at more than 200 inpatient facilities in 25 states (totaling some 23,000 beds) through its Sun Bridge Healthcare subsidiary. Sun Bridge’s facilities are primarily skilled nursing centers for seniors; it also offers assisted and independent living arrangements and behavioral health services.

This project was the One Health Plan System that would allow the members to access their profiles and information pertaining to insurance benefits, plan details, premium, claim status and also personal medical history. The application also facilitated the policyholders to go online and check availability for appointment with doctors, schedule and re-schedule an appointment as per their convenience.

RESPONSIBILITIES:

Gathered business requirements by interviewing the subject matter experts, asking detailed questions and carefully recording the requirements in a format that can be reviewed and understood by both business and technical teams.

Conducted a study of the current applications, and do analysis of business rules and practices in the area of Customer Information applications.

Acted as a liaison between stakeholders: system users, clients, and software development team.

Created detailed project plans specifying the major deliverables/ tasks along with the timeline and resources.

Planned for scope, budget as well as resources for all the projects and programs by coordinating with the higher management.

Initiated, planned, executed, monitored, controlled, and closed project work packages using best practices.

Conducted status meeting to keep track of the progress of the project and document the meeting minutes.

Liaison between senior IT management and development; instrumental in reporting the status of projects, identifying issues and assessing their impact, and proactively recommending solutions.

Designed UI screen mockups and prototypes for the proposed system, using Mockup Screens, to provide a user-friendly front end for the proposed system.

Developed the strategy for developing and implementing new EDI (HL7 and X12) interfaces and converting historical clinical and data.

Analyzed the functional requirements for the various HL7 system interface such as Patient Administration (ADTs), Orders (ORMs), Results (ORUs), Charges (DFTs).

Aided in monitoring ancillary data transactions and addressed problems with HL7 messages.

Participated in design sessions with Tech lead and developers to come up with a fully automated solution meeting all requirements.

Brainstorming, exploring options, weighing approaches and making decisions on which data and which decision support applications would be most beneficial.

Established an end-to-end requirements traceability matrix ensuring all requirements were addressed in design, development as well as testing stages.

Evaluated processes and on-going support structures to enable reuse and efficiency.

Investigating and resolving data issues across platforms and applications, including discrepancies of definition, format, and function.

Actively monitored and validated the database using SQL queries.

Enterprise Content Management using IBM FileNet Content Manager.

Actively involved in organizing team meetings and publishing status reports for the project team.

Managed work relationships through motivation, delegation, supervision, team building, conflict management, and other techniques.

Mentored the team members to attain the business goals on every part of the SDLC.

Work closely with the QA team and review test plans and test cases for various projects.

Facilitated User Acceptance Testing (UAT) with the stakeholders and the business users, and the errors discovered were fixed and then verified via regression testing.

ENVIRONMENT: Net, Oracle 10g, Business Objects, IBM FileNet Content Manager, Facets

Contact this candidate