Test Cases Management

Soumya Tiwari

Email: ******.**********@*****.***; Contact: +1-682-***-****

Objective: Business Analyst.

An experienced seasonal facilitator between Business Systems and Information Technology with 7+ years of experience across the IT, Retail, Aviation and Banking industry with a focus to design, develop and implement business processes and system solutions with the addition of an in-depth domain understanding of the entire operations and IT support systems. TECHNICAL EXPERTISE

EDUCATION

University of Dallas, Irving, TX

Masters in Information Technology and Management Aug 2016- Apr 2018 Mithibai College, University of Mumbai

Masters in Commerce July 2013- May 2015

Kirori Mal college, University of Delhi

Bachelors in Commerce July 2010- May 2013

SPECIFIC EXPERTISE

• Excellent skills in Business Analysis, Data Analysis, Requirement Analysis, Business Modeling and Use Case development using UML methodology.

• Extensive experience in Business Modeling using MS Visio and MS Excel to create Data Flow Diagrams, Use Cases, Activity Diagrams and Sequence diagrams.

• Experience in requirement gathering techniques like JAD Sessions, Interviews, Story Boarding and Structured Questionnaires.

• Experience working with business users to analyze and document business requirements and system functional specifications.

• Experience in conducting quality assurance User Acceptance Testing (UAT) and Defect Tracking.

• Knowledgeable about preparing Requirement Traceability Matrix (RTM) documents.

• Strong knowledge of UML, ClearQuest and Jira.

• Proficient in creating Use Case, Sequence and Activity Diagrams using MS Visio.

• Experience in working with QA testing teams, while interacting with business users and gathering user’s requirements to develop necessary Test plans, Test Cases and Test script.

• Risk Analysis, Securities and their valuation, Asset Management- risks and returns. Languages SQL, Python, C++, HTML, XML

Databases MS SQL, Oracle, DB2

Operating System Microsoft Windows, Mac

Business/ Data Modeling Tools Visual Studio, SharePoint, BluePrint, HP-ALM/QC, JIRA, TFS, Clarity MS, SQL Server Management studio

Testing Tools HP Quality Center

Business Intelligence Business Objects, Crystal Reports, Cognos Methodologies RUP, Waterfall, Agile SCRUM

Project Management Tools TFS, MS Office (Word, Excel, SharePoint, PowerPoint, Visio, Access), MS Project

• Performed banking systems unit and integration testing and reported results.

• Ensured the Bank policies, service indicators and regulations were considered in the implementation of new projects.

• Provided banking systems support functions, both technical and operational, to different business units to guarantee proper controls and accuracy.

• Involved in requirements management, change control, use case creation, data modeling and mapping.

• Involved in requirements analysis, system analysis, design, and testing phases of Software Development Life Cycle (SDLC) and in RUP, Agile-SCRUM and Project Management Life Cycle.

• Worked extensively on performing ‘AS IS’, ‘To BE’, and GAP analysis.

• Proven ability to quickly learn and adapt to software, systems, and IT processes used across an organization.

• Proficient in Project Management involving, Project Charter, Risk Assessment, Scope Assessment, Communications Plan and Change Management.

• Extensively experience on Access, Excel, Word, PowerPoint, SQL, and MS Project.

• Hands on experience with SQL server reporting services and other Business Intelligence tools such as Informatica.

EXPERIENCE

J.P Morgan Chase, Lewisville TX Sep 2015 – June 2017 Business Analyst

J.P.M.C is one of the largest financial institute in the Unites states. I was working as a Business Analyst at the default branch of mortgage banking for the company. The project was about Supporting internal ETL applications and Chase Online Offer Management. Responsibilities:

• Developed a thorough knowledge of the inherent systems to have a clear understanding of the business processes and associated system workflow.

• Worked with TFS for requirements management and to create Requirements Traceability Matrix

• Organized and lead show and tells for each sprint.

• Monitored and assisted in designing and development of Use Cases, Activity Diagrams, Sequence Diagrams, OOAD using UML.

• Lead the Sprint planning sessions to make sure prioritized user stories are included in upcoming sprit cycles.

• Implemented Agile methodology in the operations.

• Worked on JAD (Joint Application Design) as per the technical specifications of the application.

• Involved in GAP analysis around the identification of business rules, business and system process flows

• Worked as a User/Customer advocate and negotiated with user as well as with developers and management staff to resolve any requirement conflict to bridge the gaps between IT and business.

• Coordinated and took ownerships of multiple projects related to Mortgage banking applications to enhance originations, servicing and offer management operations.

• Participated project scheduling and resource management under the agile process.

• Involved with the application development team to create technical design document detailing the communication flow and data integration of multiple applications.

• Developed Business Requirement Documents (BRD) from business into Functional Specification Documents (FSD) for development effort purposes after conducting technical analysis and addition of detailed technical specifications.

• Used Query Analyzer, Execution Plan to optimize SQL Queries

• Created all the functional stories and groomed them with QA and Developers in as a part of agile process.

• Created Impact Matrix documents to layout the high-level project scope impacts for various teams.

• Created detailed Use Cases with components such as, but not limited to Main Case Scenarios

(MCSs), Exception paths and Alternate paths – with a heavy emphasis on analysis

• Used HP ALM and JIRA to maintain traceability of requirements and defects

• Facilitate User Acceptance Testing (UAT) and production rollouts, and the defects detected were tracked and managed using HP Quality Center

• Created Systems Requirement Specification document by combining the functional and non- functional requirements.

• Worked as a bridge between the Stakeholders and the technical teams involved in the application development for the better understanding of the business and IT processes.

• Assisted on Data mapping for System Integration

• Also, worked with Change control support group and managed changes by reviewing, testing and incorporating compliance during various stages of SDLC. Environment: TFS, MS-Visio, UML, SQL, PL/SQL, MS Office, MS-Project. BESTBUY, Minneapolis Sep 2014 – Sep 2015

BUSINESS SYSTEMS ANALYST

BestBuy acquired partsearch.com in the year 2011. The project was to integrate partsearch.com with bestbuy.com. This was a multi-dimensional project involving UI enhancement of the existing partsearch’s website. It also included the enhancement of its backend office application (applets) to streamline the exchange of information between systems such as CRM and to optimize the reverse supply chain according to the new business rules.

Roles & Responsibilities:

• Utilized Agile SCRUM Methodology.

• Extensively worked with SMEs to completely grasp existing procedures and business requirements.

• Lead requirements gathering meetings such as JAD sessions with business users, technical staff and other stakeholders to efficiently define the project requirements, scope and limitations.

• Created Use Case Diagrams, Activity Diagrams and Sequence Diagrams utilizing UML methodology.

• Documented the GAP analysis between the new system and evaluation of current system.

• Created and updated the Business Requirement Document (BRD), System Requirement Document (SRD) and use case scenarios using MS Office suite and MS Visio.

• Generated the Release / Product backlog along with the product owner and collaborated with the SCRUM Team in gathering PBIs based on the requirement.

• Constantly updated the Sprint Burn down chart to ensure the system on time delivery.

• Elaborated Story boarding considering the entire Project Scope.

• Defined rules for the extraction of information from the database using XML format for transmission to bill partners.

• Tracked business and system requirements using TFS-MTM (Microsoft Test Manager).

• Documented and executed manual Test Cases.

• Authored test cases for User Acceptance testing of the new testing system. TCF Bank, Minneapolis Aug 2013 – Sep 2014

Business Analyst

E-Pay System (EPS) – Cash Management software that caters to invoicing and payment needs. This system decommissioned an existing system and upgraded the business functionality by automating and streamlines the process. This product enables a Biller, a business organization, to be able to present the invoices in electronic format to their payers. The payers are business organizations as well. The payers’ user will be able to view, dispute, avail discounts and make online payments. The EPS product will perform the ACH Payment processing on behalf of the billers. Responsibilities:

• Identified and documented business requirements including the applications capable of supporting those requirements. Collected and documented business processes as well as business rules for E- Pay System.

• Involved in requirement gathering and database design and implementation of star-schema, dimensional data warehouse using Erwin. Gathered requirements and modeled the data warehouse and the underlying transactional database.

• Experience in Software Analysis & Design, Gathering Functional and Business Requirements, Specifications, User Interface Specifications, Technical Design, Test Cases and Test Plans.

• Successfully conducted JAD sessions, which helped synchronize the different stakeholders on the objectives and helped the developers to have a clear-cut picture of the Invoice Generation, Dealer and Accounts setup, and payment authorization.

• Responsibilities included source system analysis, data transformation, loading, validation for data marts, operational data store and data warehouse. Identified system functionality, Use Case Scenarios and wrote Narratives Use Case for the Invoicing Module.

• Using RequisitePro monitored and documented requirements, integrating them with Use Cases as well. Conducted Requirement analysis and Design Walkthroughs with the designers, developers and management staff.

• Worked on the Flowchart and Process diagrams, in addition to creating and presenting PowerPoint presentations. Involved in Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data.

• Assist with user acceptance testing of systems (UAT), developing and maintaining quality procedures, and ensuring that appropriate documentation is in place.

• Generated Change Request for user requirements, which included Impact analysis and Cost Estimation.

• Coordinated and liaised with the Quality Assurance and User Acceptance Testing teams for bug and defect tracking, created test cases and assisted with test plans for the QA team. Environment: Windows NT, UNIX, C++, HTML, XML, DB2, WinRunner, Test Director 8.0, Rational Rose, Rational Requisite Pro, UML,Clear Quest, Clear Case, SQL, MS-Project, MS-Office. JetBlue Airways Corporation, Forest Hill, NYC Feb 2012 – Aug 2013 Business Analyst

JetBlue Airways is an American low-cost airline. It is committed to bring the best customer service to its customers and motivate the customers to always come back to JetBlue. This was an enhancement project surrounding the Scheduler system which is a comprehensive, intuitive scheduling and dispatching software system for the aviation department.

Responsibilities

• Involved in creating GUI map for Flight Calendar – Executive view Feature, which will generate LOAD factor (the percentage of available seats or the percent of freight capability used).

• Developed and managed the formal SDLC implementation using the Lean/Agile Methodology.

• Performed requirements modeling and develop analysis diagrams, activity diagrams, sequence diagrams, state diagrams, data models and use-case realizations using RUP tools in Agile.

• Interacted with Business Users, Subject Matter Experts, and the management to understand the business process, identify enhancements and gather Business Requirements.

• Responsible for business system analysis of customizing the BPM (Business Process Modeling) Risk Management product with involvement through the whole SDLC.

• Used MS Visio for Process modeling, Process mapping and Business Process flow diagrams.

• Creating, Process Flow Diagram, Context Diagram and Activity diagrams using UML.

• Conducted UAT to confirm that all derivative products can be successfully processed through stages of the trade life cycle.

• Created relationships in Requirement Traceability Matrix linking Business Requirements to Functional requirements and Functional Requirements to Systems Requirements.

• Worked closely with the Quality Assurance team in creating test plans and test cases and analyzing test results as well.

Zomato, New Delhi, India Jan 2010 – Jan 2012

IT Business Analyst /Financial Analyst/Revenue Assurance executiv1 Zomato is a restaurant search and discovery service founded in 2008. It currently operates in 23 countries, including India, Australia and the United States. It provides information and reviews on restaurants, including images of menus where the restaurant does not have its own website. I spent my time over there working on our engineering and product teams, working on real, live projects that are a part of our development pipeline.

As IT Business Analyst:

• Utilized both Agile Scrum and Waterfall methodologies throughout the software development life cycle.

• Organized and facilitated meetings with the technical and business stakeholders

• Conducted requirements gathering sessions with the purpose of defining the Business, Functional and System requirements.

• Gathered requirements from users, customers, designers, developers, project managers and subject matter experts via JAD sessions, Surveys, Interviews and Prototyping to ensure end to end requirement coverage.

• Performing Cross Impact analysis to understand and define development impact on other applications within Zomato.

• Performed extensive Gap Analysis between the Company's Legacy System and the Proposed System.

• Drafted detailed Functional User Stories and utilized Team Foundation Server (TFS) to Manage User Stories, Defects/Bugs and Test Cases.

• Created Use Case Diagrams, Activity Diagrams and Sequence Diagrams utilizing UML methodology by utilizing MS Visio.

• Conducted Sprint Planning session with the Development teams and Business stakeholders to prioritize user stories for upcoming Sprint Cycle and to prioritize items for the ongoing Sprint Backlog.

• Working with the Program Manager to manage Business Change Requests in between a given Sprint Cycle.

• Acted as Liaison between Creative (Front-End), ETL(Informatica), Legal and Product Design teams(Business).

• Defining rules and SLA for the extraction of information from the database for Informatica ETL Control-M Jobs

• Writing manual Test Cases and Test Scenarios in Visual Studio (MDM).

• Executing Manual Test Cases and documented defects in TFS.

• Leading the Defect Triage meetings to prioritize defects for Product Backlog and Technical Debt Buckets.

• Authoring Manual Test Cases for User Acceptance testing.

• Working as a Release Manager for regular Sprint releases and HotFixes(Expedited release).

• Performing verification and validation in production environment to provide signoff post release. As Revenue Assurance Executive:

• Work with cross-functional teams in resolving financial and revenue related issues.

• Perform revenue analysis, calculations and reporting on monthly basis.

• Ensuring optimal security of company’s revenues and optimal prevention of fraud and leakages impacting company’s financials.

• Constantly implement and improve controls and checks in areas of RA&FM

• Perform regular reconciliation and (gap) analysis of revenue streams.

• Monitor bill payment/collection and fraud if any by multiple checks and balances in the system.

• Investigate, understand and document issues root causes Propose/suggest solutions to avoid occurrence of issues

• Continuously work to understand and mitigate losses to ensure the highest levels of loss avoidance and reduction

• Validate accuracy of reporting and data used to create fraud policies and strategies on a recurring basis Report on and improve metrics

• Provide support for any Regulator (CMC) inquiry and investigation in fields of RAFM Achievements on Job:

• Helped in the formation of the Business Intelligence Vertical with required algorithms for Fraud detection.

• Established the Revenue Assurance and Fraud Prevention department team.

• Preventing Frauds from Restaurants and Customers end.

• Overall management of a department which has a broad spectrum of responsibility from analysis

• and controls to automated data interrogation

Contact this candidate