Project Test Cases

REKHA SHIVKUMAR

GREEN CARD HOLDER

Ph-408-***-****

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

Cupertino, CA

https://www.linkedin.com/in/rekhashiv01

Accomplished IT Business Systems Analyst Professional with several years of diverse and strong experience in Information Technology with emphasis on Business Analysis, Systems analysis, and Business Reporting, gathering Business Requirements, Business Process flow, Business Process modeling, and related technical knowledge. Possess excellent client interaction and relationship management skills.

EXPERTISE

●Experience in Business Systems Analysis for Data Warehousing,E-Commerce, Web 2.0, B2B, B2C, Web Applications, Infrastructure and Operations.

●Proficient in business requirements into functional specifications, focusing on Business process workflow analysis and design, business process re-engineering, user interface design, portal design, and process flow modeling & documenting use cases using Agile tools.

●Comprehend, apply, and mentor fully the areas of software development life cycle (SDLC) and documentation carried out through multiple methodologies such as Agile, classic waterfall,Iterative models.

●Experienced in writing SQL Queries and joins for data analysis and data validation and performed complex data mapping.

●Experience with Reporting tools like Tableau,worked extensively in Data warehousing and BI Reporting environments .

●Extensively worked with teams using Agile /Scrum and Waterfall methodologies.

●Versatile team player with excellent communication and interpersonal skills. Quick learner with ability to quickly master new concepts and technologies

EDUCATION:

●Bachelors in Technology (Computer Science) from University of BC, Canada.

CERTIFICATIONS:

●Project Management Professional (PMP) from PMI.

●Certified E-commerce Webmaster (CIW)

TECHNICAL SKILLS

Operating Systems:

Windows 98/2000/XP/VISTA,Unix (Fedora, Free BSD), Linux and Mac

OS

Modeling Tools

MS Visio,ERWIN Data Modeler

Database:

ORACLE 9i/10g/11i, MS-SQLServer2000,MySQL

Web Design:

Web 2.0, XML, HTML, Dream weaver MX, MS Front Page 98,

Java Script

Front End Suite

MS Visio, MS Project,MS Office suite

Software Development

Methodologies:

Agile/Scrum,Waterfall, RAD and Prototyping.

Other Tools:

Tableau 8.1/8.0,SAP Business Objects – Web Intelligence Reporting,

Dashboard Designer, Rally,JIRA, Bugzilla, SharePoint portal.

PROFESSIONAL EXPERIENCE:

Wells Fargo Inc. San Francisco, CA May 2016- Nov 2017

The Data & Analytics team is a large scale analytics & marketing environment.It has a historic view of all WF customers, products & relationships .Multiple data sources contribute to the data warehouse based on business partner requirements.

Role:Business System Analyst

Responsibilities:

●As a lead Analyst for the project team, instrumental in gathering complex business requirements and translating them into technical functional specifications and documenting them.

●Collaborating with Business partners & project stakeholders via meetings,interviews & workshops to gather specific requirements for the project

●Expertise with banking applications,worked on multiple fraud related projects in an end-end SDLC project life cycle environment, driving the project from beginning to completion. Discuss and sort out project issues with the business team and technical team.

●Working with the technical development team,translating business needs to technical terms and acting as a bridge between both the groups.

●Writing Test plans,test cases and system testing of the actual project application after development is complete.

●Extensively performed SQL data analysis in Teradata database to gather information about current state of the system, also familiar with client tools like SQL assistant & SQL Query Analyzer.

●Connected to various other databases like SQL server & Oracle from Teradata to perform data analysis, complex mapping & validation using SQL Assistant.

●Familiar with reporting tools like Microstrategy & Tableau,performed data validation using the tools.

●Expertise in working on Agile/Scrum methodology and used tools like JIRA,Sharepoint,Confluence for project collaboration.

Autodesk Inc. San Francisco,CA July 2015 – Feb 2016

Portal Services comprises of different services of the Autodesk customer portal, which include

Reporting, Billing & Order Management. This part of the portal handles customer experience during View/Edit/Adding Payment profiles to an existing order and renewable, recurring subscriptions.

IAE Customer portal offers the customers of Autodesk access to downloads, updates & add-ons for the products they purchase or rent .It comprises of different parts like User management, Products & Services, Usage Reports & Billing /Order management.

Role: Business System Analyst

Responsibilities:

•Analysis current system, and based on current & new requirements, designing use cases /test cases, setting up Test environment & test data needed.

•Coordinating with different teams,following up regarding impediments, action items with team and cross functional teams and off shore teams

•Leading /coordinating Daily standup meeting for Portal services & Condor teams,discussing task status & impediments with team members

•Writing test cases using Agile tools like Rally, performing Functional, Regression & Acceptance testing of the new & existing UI /backend API pertaining to the Updates & Add-on modal on dev, stage environments & Sanity tests on production environment for BFRs.

•Performed data analysis for analyzing metrics using Tableau, SQL related to sales, product & orders to help Production Support team make decisions regarding type of issues/queries coming from their customers.

•Coordinating UAT, writing UAT Test Plan/test cases for the product feature releases and gathered feedback from business stakeholders in the form of defects/feature enhancements.

•Good team player with excellent communication, leadership & people skills, flexible in taking up different assignments for the projects

PayPal Inc., San Jose, CA May 2013 – June 2015

Worked on the Payments/Platform team on different Agile Projects. Actively involved in the PayPal as a Service project (PPaaS) and to certify the different internal PayPal APIs to comply with the PPaaS rules . Supported the End-End Quality team from beginning to

end. Actively managed different components of the End –End Horizontal work stream like DCC, Authorizations and Switch component.

Role: Business System Analyst

Responsibilities:

•Actively involved in the Project right from the Planning phase and all the way till the Post-Execution support phases for the project.

•Based on the business & system requirements, prepared use cases/test cases for different feature workflows in the project using Agile tool Rally

•Worked extensively with Web portals (SharePoint, Intranet Wikis), managed project support community pages & tracked issues in the SharePoint web portal.

•Used MS-Visio for preparing Business process flow diagram and created wireframes to model high level business requirements for the project.

•Wrote multiple SQL queries & joins for end to end data analysis & validation of the data in the new system database in Oracle & SQL server environments.

●Lead & coordinated UAT activities with Business partners & drove the project to successful completion until implementation to support activities.

VISA Inc. Foster City, CA Jan 2011 – Jan 2013

Real Time Messaging (RTM) is a robust application portal through which Merchants of VISA (GAP) can create Campaigns, Offers and store Coupon repository for thousands of holiday Campaigns and Offers for their customers. When they shop at the Merchant location and swipe their VISA card, their customers will be automatically able to access the instant Offers and coupons at their favorite Shopping location. This project was aimed at increasing sales to customers via coupons and Offers created through the Merchant Service portal

Role : Business System Analyst

Responsibilities:

●Involved in the project from start phases till support phases of the project, gather feedback & requirements from stakeholders & product owners and documenting use cases.

●Expertise in preparing Business Requirement Documents, test planning and execution for the MSP application.

●Extensively worked with SharePoint Web Portal for MSP project and different features like creating webpages,adding different controls to webpages & publishing webpages.

●Used SQL Client tools like SQL developer & perfomed detailed end -end data analysis of the Merchant Campaign databases & supported the business team for adhoc query requests.

●Good experience in working on custom application development projects, UI/UX teams and Agile environments using tools like RALLY /JIRA

●Act as a resource in understanding how IS systems carry out business functions and assisted in ensuring the timely and effective implementation using GAP Analysis .

●Worked with many cross-functional teams including remote project teams and developed good work relations with various stakeholders.

●Managed workload, schedules and coordinated status review meetings with project managers, business managers and team members.

Yahoo Inc.,Sunnyvale, CA Jan 2010- Jan 2011

E commerce - Yahoo Video Ads

The goal of the project was to integrate and enhance the existing Yahoo! Video Advertising platform into a very dynamic advertising platform where advertisers book their campaigns through Yahoo APT or MME systems. It offers multiple video advertising solutions, some of the popular interactive video ads include Interactive Video Ads, Clickable Video Ads, and Overlay Video Ads. The enhanced system is fully web enabled when an advertiser logs in and places Ads by selecting from Ad Type template .

Role : Quality Analyst

Responsibilities:

●Conducted GAP Analysis of the As -Is system to identify key areas of concern and addressed them with the Business team. Documented the AS-IS and TO-BE processes.

●Organized Joint Application Developments (JAD) with end-user/clients/stake holders and the IT group to gather requirements in order to re-engineer the existing process.

●Prepared Business Requirements Documents and Use case diagrams for documenting the Requirements and use case scenarios for the project.

●Supported the Video Ads application on Mobile platform –Andriod,IOS phone and tablets .

●Responsible for preparing reports and graphs using Web Intelligence for the application,also expertise with MS Excel,MS Access

●Worked with SQL client tools like SQL Developer in the Oracle DB to conduct data analysis and reporting to excel and SAP Business Objects

●Set up test environment,created Smoke Test Plan & test cases, performed web services testing using Browser Add-on tools and validated test scenarios.

●Created a Master Test Plan for functional, regression, and user acceptance testing phases of the project.

●Utilized Mercury Quality Center to document all test cases, test scripts, defects, and business requirements.

●Created post implementation documents such as the Help desk support document and user manual.

Intuit Inc., Mountain View, CA Jan 2006 – Dec 2009

Intuit deals with tax and accounting software like TurboTax, QuickBooks and Quicken. TurboTax is the leading online tax calculation software used by many users worldwide. QuickBooks and quicken are widely used accounting software for fast growing businesses and by individuals. The goal of the project was to enhance the online product sales by enhancing the Ecommerce website for TurboTax and QuickBooks.

Role: Quality Analyst

Responsibilities:

●Involved from the start of the project life cycle and prepared Functionality Requirement Documents, user stories and assisted in preparing Test Plans for the project

●Good experience with Ecommerce workflows, Web 2.0 technology and well versed with IT Project Life cycle

●Used BO Tool Web and Dashboard Designer for Reporting in the application and presenting reports to the Management.

●Responsible for preparing various detailed reports and graphs using Excel for the application and hands- on experience with using Excel,Oracle and MS-SQL server

●Manage requirements from system users and transform business requirements into functional specifications, focusing on workflow analysis and design, business process reengineering, user interface design, portal design, and process flow modeling.

●Create mock ups and wireframes using Visio to help facilitate the conversion of business needs into functional requirements for the project

●Prepared & executed test cases for functional, regression & Integration testing scenarios for the application

●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

●Acted as a liaison between the development teams and Business Team and provided hands on support to the team.

Contact this candidate