Post Job Free

Resume

Sign in

Test Cases Customer Service

Location:
Denver, CO
Salary:
open
Posted:
June 22, 2015

Contact this candidate

Resume:

Jesai E. Sianipar

Professional Summary

Over *+ years of experience as Quality Assurance Engineer with focus on testing of Web-Based client/server applications.

Expertise in quality assurance, Manual and Automation testing, web based client/server application.

Extensively worked as a Quality Assurance and Test Engineer, understanding responsibilities in QA plan formulation, developing project plans, communication plans and implementation.

Very good experience in Manual Testing and Automation Testing by using defect management tools like Quality Center/Application Lifecycle Management (ALM), JiRA, Rally and Microsoft Excel.

Experienced in various implementations of different Software Development Life Cycle (SDLC) Methodologies, policies, plans and worked with Agile, Waterfall, RUP menthologies in projects.

Extensive experience with automation tools such as HP Quality Center/ALM, HP QTP (Quick Test Pro) / UFT (Unified Functional Test), HP Load Runner, Selenium, Eclipse, Intellij, MS Visual Studio, SoapUI & Rest (Web Service) and Ruby Watir Cucumber RSpec Capybara Calabash.

Hands on experience with Java Selenium ((Selenium IDE, RC, Web Driver) with Junit & TestNG Framework, ANT and Maven.

Hands on practice in C#.NET using MSVS Ultimate 2012/2013, CodedUI and NUnit framework with Selenium as a web driver automation tool.

Extensively involved in and performed Black-box testing, Smoke testing, Functional testing, Integration testing, Performance testing, Load testing, System testing, stress testing, Regression testing, and User Acceptance Testing (UAT).

Expertise in creating Bug Reports using tools like Test Director / Quality Center / ALM, Rally, JiRA and reporting for both Manual and Automated Test environment.

Hands on experience with Databases Oracle, SQL Server and writing SQL Statements for front end and back end testing.

Experience in Java, C# programming and detailed knowledge in Object Oriented Programming Techniques.

Excellent interpersonal skills and professional communication skills and have worked extensively in a team oriented environment.

Strong points include attention to details, commitment to work and results oriented.

Technical Skills

Functional Testing Tools

Quick Test Professional(QTP)/ Unified Functional Test (UFT), SOAP UI pro, Selenium, MSVS, VSTS, Coded UI, TFS

Test case Mgmt/Defect Tracking

Quality Center/ALM, Rally, JiRA, Bugzilla

Performance Testing

Load Runner, JMeter

IDE / Test Editor

Eclipse, MSVS Ultimate 2012/2013, QTP/UFT

Development skills

VBScript, Java, C#, VB Script, Groovy, Ruby

DB Programming

SQL Programming

Database servers

MS SQL Server 2008/2012, My SQL

Web Languages

VB.Net, Java Applets, HTML, ASP, JSP, Java Script, XML, XAML, CSS

Program Management Tools

MS Office 2003/2007/2010, Microsoft Project, MS Visio

Operating Systems

Windows XP/Vista/7, Windows2003/2008 Servers, Unix, Linux

Languages

C#, Core Java, Java Cucumber, SQL, XML, HTML, JSP, JavaScript, Servlet, JDBC

Browsers

Internet Explorer, Google Chrome, Mozilla Firefox

Work Experience:

HCA - Health Trust Aug 2014 – Feb 2015

Nashville, TN

Health Trust is a company who works on GPO (Group Purchasing Order) and Supply Chain. Health Trust is a sub company of HCA (Hospital Corporate of America) as the holding company and located in Nashville, TN. In this project, I worked on an application which name DMT (Data Management Tool). DMT is an application which used by Health Trust (Group Purchasing Order - GPO) to categorize spent that cannot be categorized by IMS (Item Management System) where the Spent cannot be filtered by Master Item. DMT has five rules such as Customer Item Category, GL Category, Item Description Category, Vendor Name Category and Vendor Only Contracts and are categorized by taxonomy (Segment, Department, Category and Subcategory). The input of DMT is the data from inFusion, EDW, EDV and the output of DMT is sent back into inFusion and Data Services which later on will be consumed for analytic system and inSight. This is a new application which we built from the scratch and I involved in this project since the first day and was built with agile method.

Responsibilities:

Actively join Backlog grooming meeting, Sprint meeting, Stand Up meeting, Code review meeting, Design meeting, Product review meeting, Retrospective meeting, Quarterly meeting

Design test scenario for every rules including View, Create, Update and Bulk Update

Develop test cases for testing according to user story of success criteria and work closely with BA (Business Analyst) and developers team

Create test data for functional testing including valid and invalid data (negative and positive testing)

Make debug report and status report

Test the data base using SQL statements and test the new tables that developers just built to extract data from EDV, EDW and HPG Data Services DB into DMT Categorization DB.

Actively involved in UI design and work with developers through all the code modules and the steps that developers team were developed such Design UI, Modify API, Unit Testing

Develop Test Script using C#.NET for automated testing using NUnit framework

Document the work flow and the progress of automation tests in Confluence

Leading 3 QA Engineers who worked offside. Distributed the QA jobs and make sure that manual and automation testing covered the user stories.

Environment: C#.NET, MSVS Ultimate 2013, Window Server 2008 R2 / 2012, SQL, HTML, Excel, Windows 7, Rally, JiRA, QC/ALM, CSS, XML, XAML, JavaScript.

HCA - Health Trust

Nashville, TN Feb 2014 – Aug 2014

In the same company, at this period, I worked for IMS (Item Management System). IMS is an application that handle the contracts from vendors with millions of items and it has links (input & output) from many applications such as RAFT (Rebate & Admin Fee), Catscan (member Catscan), HOME, VIRA (Vendor and Item Request Application), SMART, Genesis, Upside, RxCatalog, EDW, iCommit, KP, Facility Mapper. IMS has several modules such as Contracts module, Items, Uploads, Exports, Reports, Tax modules.

Responsibilities:

Actively join Backlog grooming meeting, Sprint meeting, Stand Up meeting, Code review meeting, Design meeting, Product review meeting, Retrospective meeting, Quarterly meeting

Created and updated Test Case based on the User Stories in the Product backlog periodically and met all the Sprint timelines without any delay.

Review the User Story with success criteria and issued the defect tickets

Develop test cases and test script using Selenium with data driven frame work JUnit and TestNG. Create data parameterization using Excel and database. Write scripts to test the applications to read, select, input /write of the object elements using Selenium Web driver using Java language.

Performed all phases of end-to-end testing which includes User Acceptance testing, Functionality testing, Regression Testing, GUI testing, boundary testing, negative testing, system testing, unit testing and Smoke testing of the Application, its interfaces and Client-Server Utilities.

Write test cases and using SQL to test IMS DB and execution of the scripts to test UI and back end testing

Create Data Driven framework using Junit.

Involved in Black Box Testing and analyzed the results to compare expected and Actual results.

Participated in bugs and enhancement review meetings, assigning the bugs and enhancement request to the developers and follow up. Tracked the issues, bugs with Rally and JiRA

Performed and Supported UAT (User Acceptance Testing) and coordinated testing activities and reported bugs

Drafted documents to create test cases, test results and test procedure as and when required.

Performed Backend testing by extensively used SQL to work on database for checking database integrity.

Performed positive and negative testing to test the applications for identification of bugs.

Made documentations for the progress of application and data work flow using confluence

Join QA automation meeting inter departments to share knowledge and problem solving for some issues

Test for Load Performance Testing with Load Runner (VUGen, Controller, Anaysis)

Leading 3 QA Engineers who worked offside. Distributed the QA jobs and make sure that manual and automation testing covered the user stories.

Environment: Selenium, Eclipse, Netbeans, J2EE, SQL Server 2008 R2, JiRA, Rally, QC/ALM, HTML, CSS, Excel, Windows 7, Linux, Load Runner, XML, XAML, JavaScript.

Emerging Health IT, Yonkers, NY May 2013 – Jan 2014

Emerging Health Information Technology is a leading provider of healthcare information management solutions for hospitals, integrated delivery networks and medical centers. It provides the right clinical, financial and business software solutions and services that improve patient care and streamline business processes and enhance operating efficiency across the entire patient care continuum. My primary role on this project was working on EMR (Electronic Medical Record) to test the application on blood pressure reading, vaccination, preventive visit, tracking data over time and prepares necessary supporting mapping/crosswalk documents as part of project deliverables.

Responsibilities:

Involved in the reviewing and analyzing the requirement specification documents with business analyst, QA manager and other team members for the application.

Participated in Daily Agile Scrum, bi-weekly Sprint Planning/Review and Retrospective meetings with Account Manager, Project managers, Scrum Master, Business Analysts, developers and QA Team.

Created and updated Test Case based on the User Stories in the Product backlog periodically and met all the Sprint timelines without any delay.

Develop test cases and test script using Selenium with data driven frame work JUnit and TestNG. Developed test data using Excel for tracking over time and table and Do parameterization using Excel and database. Write scripts to test the application including read and write the result using Selenium Web driver using Java language.

Performed all phases of end-to-end testing which includes User Acceptance testing, Functionality testing, Regression Testing, GUI testing, boundary testing, negative testing, system testing, unit testing and Smoke testing of the Application, its interfaces and Client-Server Utilities.

Involved in writing test cases applying the SQL scripts to the test database and execution of the scripts on the database.

Involved in Black Box Testing and analyzed the results to compare expected and Actual results.

Participated in bugs and enhancement review meetings, assigning the bugs and enhancement request to the developers and follow up. Tracked the issues, bugs with Quality Center/ALM.

Performed and Supported UAT (User Acceptance Testing) and coordinated testing activities and reported bugs

Drafted documents to create test cases, test results and test procedure as and when required.

Performed Backend testing by extensively used SQL/PLSQL to work on database for checking database integrity.

Performed positive and negative testing of the application for identification of bugs.

Environment: SQL Server, QC/ALM, Selenium, Eclipse, Netbeans, J2EE, JavaScript, AJAX, Junit, HTML, UNIX, Excel, Windows 7, XML, Excel.

EPay Payment System

Online Project for Automation Testing using SoapUI Nov 2012 – Apr 2013

EPay System Testing is an application which develops for SoapUI testing which is not depending on GUI (from end) instead using back end testing. There are a lot of operations inside the application such as Authorization, Capture, CashAdvance, CreateCustomer, CreatePassword, CreateRecurringTransaction, DeleteCustomer, EmailRecepit, ExportTransaction, ForSale, Level3MCRD, Level3VISA, Refund, Sale, SettleTransaction, StoreNForward, UpdateCustomer, UpdatePassword, Void and I need to test some of those functions.

Responsibilities

Prepare test scerios and test cases to test the functionalities for Delete Customer, ForSale, Refund, Sale, UpdateCustomer, UpdatePassword, etc.

Write test script using WSDL

Write script using Groovy language to hook up the script to database link

Create test data including parameterization

Make debug report and status report

Update the test plan and RTM

Test the data base using SQL statements

Environment: SQL Server, HTML, Excel, MS-Office, Windows 7, XML, XAML, CSS, SOAP UI

True Blue – Jet Blue

Online Project for Ruby Watir Cucumber RSpec Capybara Apr 2012 – Oct 2012

True Blue is an internal application which created for training purposes which content the simulation for cars (limousine) which serve customers for drop off and pick up from one destination to others. The application has some modules such as Home, About Us, Services, Contact Us, Rate Look Up, Reservations and Partner. There are two True Blue applications: Build 1 has a lot of bugs, but I and the team, fixed the application and update for Build 2.

Responsibilities:

Testing the function of authentication (log in) from negative and positive testing.

Testing for the modules “Rate Look Up” and “Reservations”.

Testing integration module between “Services”, “Rate Look Up” and “Reservation”

Testing the function ‘Select & Go”, “Submit” button

Develop test cases for testing

Develop automation test script using Ruby

Create test data including parameterization

Make debug report and status report

Update the test plan and RTM

Test the data base using SQL statements

Environment: SQL Server, Ruby on Rail, Ruby Cucumber, Notepad++, ALM, HTML, Excel, MS-Office, Windows 7, XML, XAML, CSS

Dean Health Clinic, Madison, WI Jun 2011 - Mar 2012

QA Engineer

Dean is one of the largest integrated healthcare delivery systems in the country. It offers primary, specialty and tertiary care for patients throughout southern Wisconsin. The project was the implementation of Portal (Web page) which integrated with some modules such as Doctors Module and Location Module. I also involved in the project to implement Electronic Health Record (EHR) system which generates the complete electronic record of a clinical patient encounter. It also included development and enhancements to other care-related activities directly or indirectly interfacing with patient, physician, laboratory, billing and health education web portals.

Responsibilities:

Analyzed use-case document and functional requirement specification document.

Prepared and maintained the Requirement Traceability Matrix to ensure completeness.

Created test cases and test data from the functional requirement specifications.

Primarily responsible for reviewing the approved Change in Requirements and analyzing and identifying the impact to existing test cases and scripts.

Primarily responsible for reviewing the approved Change in Requirements and identifying and preparing the new test cases and test scripts.

Involved in Black box, Manual Testing and prepared Test Suite for all the Test Cases.

Created different document and matrices like test log, test incident report, test coverage matrix, tractability matrix etc.

Generated test reports and test cases using QC.

Create Data Driven using Excel.

Develop Test Scenarios and Test Cases

Creating script using VBScript language and using QTP/ UFT.

Involved in detailed Functional and GUI testing and User acceptance testing (UAT).

Involved in writing SQL queries for Backend data verification, retrieving data from related tables and Testing.

Conducted End-to-End testing of the system.

Detected bugs and reviewed them with business and developers and classified them based on the severity.

Generated various Reports for PMO including Weekly Status Report and Open Defect Report using Excel.

Conducted the Regression tests for already reported Bugs and change requests to test whether fix has been applied or not and to test and ensure the fix does not cause a new problem or break existing functionality.

Environment: Windows XP/Vista, HP Quality Center, UNIX, Oracle, MS-Office, QTP/UFT

Delta Dental Insurance, Sacramento, CA Jul 2010 – Apr 2011

QA Analyst

The client is a leading Dental Insurance provider in United States. My role in this project was to do integration test, system test, compability test and regression test, end to end testing after some changes were made to the previous builds and some new functions/features added.

Responsibilities:

Review requirement and attend walkthrough meeting

Creating test cases and updated Requirement Traceability Matrix (RTM)

Test the application with positive and negative data from manual perspective

Preparation test data in excel for parameterization (data driven frame work).

Develop test script using Java language.

Creating script using Selenium RC Server and Web Driver using JUnit & TestNG.

Involved in detailed Functional and GUI testing and User acceptance testing (UAT).

Involved in writing SQL queries for Backend data verification, retrieving data from related tables and Testing.

Generated test reports and test cases using QC.

Involved in manual testing and automation testing using Quality Center to develop test cases, test scripts, executing the scripts and logging the defects.

Extensively performed end to end testing to ensure the quality of the software.

Report the bug and updated testing status report

Environment: SQL Server, Windows XP/Vista, HP Quality Center, MS-Office, Selenium, J2EE, Netbeans, HTML, XML, JavaScript.

AllState Insurance, Princeton, NJ Jun 2009 - May 2010

QA Analyst

Allstate's major business is private passenger auto and homeowners insurance, primarily offered through agencies. Allstate Financial segment provides life insurance, retirement and investment products, and voluntary accident and health insurance products. It also offers business insurance, consumer household insurance, Allstate dealer services and roadside services. I got an opportunity to develop an application for AllState Insurance. The application enabled the customer to get a free online quote instantaneously. This application also enabled the customer service agents of the company to view potential customers’ data. Application involved two modules: First module was ‘OQ’ (online quote) in which the customers could access online by filling a list of fields. The application enabled site personalization by customizing the user space. Second module was the ‘CSR’ module where a customer service representative had detailed information of the online application filled by the customer. The front-end was developed using HTML, ASP and Oracle was used for back-end. The system incorporated site personalization features by customizing user space.

Responsibilities:

Analyzed the Business requirements and Use cases to understand the application.

Developed detailed Test Plan, Test Cases and executed them.

Identified the test cases that are to be automated and those that are to be manually done.

Worked various Point of Purchase/Checkout applications for the retail client applications.

Documented Test Cases corresponding to the business requirements in Quality Center.

Developed requirements traceability matrix between requirements and test cases to ensure maximum coverage of the requirements.

Performed generation and maintenance of test plans, test cases as well as development of framework for QTP test automation as a part of integrated solution of Quality Center.

Responsible for execution of extensive data and functionality driven regression tests, development of test-data in accordance with predetermined standards as well as automation of stable components of the system.

Preparing test data in Excel for parameterization

Develop code for automation testing using VB script.

Performed negative and positive testing for the application

Conducted GUI testing, Functional Testing, Smoke Testing, Integration Testing and User Acceptance testing on the application.

Extensively used SQL for data integrity testing at the backend.

Coordinate with development teams in deciding what to automate in the regression and work closely with the automation staff to ensure efficient and stable builds.

Support staff in diagnosing problems and reporting bugs and enhancements to development.

Extensively worked on Mercury Quality Center for bug reporting/tracking.

Participated in Defect review meetings with both the stakeholders and developers developed defect summary report, test summary report, data dictionary, script status reports and defect status reports.

Environment: Quality Center, Windows XP, MS-Office, Visual Studio, XML, Java script, ASP, SQL Server, QTP, Excel

United Airline - Denver, CO 1998 – 2001

Programmer Analyst

Analyzed messages which come to Apollo system and other CRS, and gather asynchronous messages from other CRS for statistic purposes. Collected user requirements from users for Revenue Management purposes. Coded, did unit testing, integrated testing and involved in user acceptance test. Created programs to fix data corruption and PNR failure. Made some modification in 03-SSRA3-7 (Special Seat Request). Fixed defects from users testing, Inventory & seat selection, PNR chain modification.

Technology: IBM OS 390, MVS 370/390, TPF ISO C, JCL, SPM, Sabretalk, Assembly Language

Garuda Indonesia Airline - Jakarta, Indonesia 1993 – 1998

Software Developer

Joined the project for TPF migration from TPF 2.3 to TPF 3.1 and to TPF 4.1. Expand Passive Code Queue project for Passive Segment Notification from major CRS’s: Sabre (AA), Amedeus (1A), Worldspan (1P), Galileo (1G), and send the messages to proper queue for further robotic processing, Availabity function, Inventory and Schedule Change. Arhega (hotel reservation system of Garuda Indonesia) is a Central Reservation System (CRS) based: did maintenance and enhancement of the legacy programs and maintain the database.

Technology: IBM OS 390, MVS 370/390, TPF ISO C, JCL, PLI, SPM, Assembly Language

Education and Training

1992 Bachelor of Science, Mathematics - Institute Technology of Bandung

1993 - 1994 Programmer Course and System Analyst Course – Garuda Indonesia Airline

2005 - 2006 Business Analyst Training, SAP FICO Training

1998 - 1999 User requirements, TPF Database and Teletype - United Airline - Denver, CO

1995 - 1997 Database and Inventory Course I & II - Swiss Air - Zurich, Switzerland

1995 - 1998 IBM OS 370/390, TPF Dump Reading & Analysis Course - IBM

2007 - 2010 QA Analyst Training: Manual and Automation Testing (C#, Java, VB, Ruby

Cucumber, Eclipse, Intellij, HP QTP10/UFT11-12, HP QC/ALM11-12, HP Load Runner, JMeter, MSVS, TFS, CodedUI, Bugzilla, JiRA, SoapUI, HTML, CSS, JavaScript, JQuery)



Contact this candidate