Data Test Cases

Rajyalakshmi Puli

Moncton, NB **********@*****.*** 506-***-****

OBJECTIVE

To obtain a rewarding full-time position with a forward-thinking organization which challenges my communication and interpersonal skills, technical abilities that offers professional growth while being resourceful, innovative, and flexible with focus on customer satisfaction and process improvement as a Tester.

SUMMARY

7+ years’ experience in Software Quality Assurance, Project Lead, QA Tester,Test Planning, Software testing in the areas of Gaming, Finance, Banking, Insurance, Healthcare, SAP, eCommerce and Data Processing for organizations like Tietoenator, IIC India Services Ltd,HCL AXON Technologies, Commonwealth Bank of Australia, Spielo, and GTECH,CGI .

QUALIFICATION AND CERTIFICATIONS

MCA (Master of Computer Application)

ISTQB Foundation Level Certified

Microsoft Quality Center Certified

Professional Profile

Seven years of extensive experience in software industry mainly in testing across different industries such as Telecom, Banking, Gaming, and Mobile.

Onsite Work Experience (Nokia, Finland, Tampere-Wireless Telecom) and Speilo (Canada) Australia (Sydney-ETL Testing).

Manage and direct onshore and offshore teams and coordinating tasks

Good working knowledge on Data ware house testing and relational Database testing by using the interface language SQL, PL/SQL, Oracle and the client tools such as Microsoft SQL server management studio, Teradata, Data stage director, Toad, Cognos.

Hands on experience with all phases of the Software Development Life Cycle (SDLC), Software Test Life Cycle (STLC), Bug Life Cycle (BTC).

Exposure to Waterfall, Agile process, and methodologies.

Extensive experience in formulating testing deliverables (including Test Strategy, Test Plans, Test Scripts, Requirement Traceability Matrix, Test Execution Schedules, Progress and Test Summary Reporting) to professional standards and providing the Inputs to test manager about the requirements testability for identifying resources and designing test schedules.

Executing test cases and recording the test results using the test case management tool

Recording, reporting, and tracking defects to accurately depict the status of the system with various defect tracking tools such as JIRA, Quality Center and Bugzilla.

Experienced in System testing, Usability testing Regression testing, Integration testing, End-to-End testing.

Actively participate in walk-throughs, inspections, review and user group meetings for quality assurance

Excellent communication and interpersonal skills with troubleshooting abilities, effective in working independently and an exceptional team player

Proficient in using Microsoft Office tools and well versed with Teradata building, and analyzing and testing complex queries

Experienced in reviewing the system requirements and clarifying the testing scope with the Business Analysts, Development teams and the Project manager

Developed SQL queries /scripts to validate the data such as checking duplicates, null values, truncated values and ensuring correct data aggregations.

Experience in performance tuning of Sources, Targets, Mappings and Sessions, data validation and data analysis

Basic knowledge of Unix, Linux,C and C++

PROFESSIONAL EXPERIENCE

Projects : Risk Data Aggregation-Retail LineOf Business

Duration : Oct 2015-Till Date

Company : CGI,Moncton

Client : CIBC, Canada

Environment Tools: Microsoft Visual Studio, Toad (Oracle client), Web App (ETL tool), Sharepoint, Quality Center,TFS,Toad

Created detailed Test plans to validate RLOB(Retail line Of Business -Risk Data ) requirements

Responsible for creating test cases templates to facilitate mapping rules, Standard Error/Warning Messages, Success, Failure Record counts

Mentoring Junior testers and coordinating the work across team members

Preparing test metrics, defect metrics

Executing test cases by converting ETL business mapping rules into SQL queries

Verify Data Quality – Validate Boundary Conditions, Validate Lookup Fields, Negative conditions, Record count, Business Rules, Source and target table column by column verification

Source and target table data model verification-Each column type, length, Nullability, Primary, unique, index key verification

Verification of Success/Failure record count through ETL tool

Participated in SRD (Software Requirements Document),BRD (Business Requirement Document),Defect,BTR (Business Transformation Rules), Data Model document review meetings

Developed Tractability Matrix which is a proof of document to ensure that all the specifications

As a QA Lead, participated in walkthroughs for the evaluation of the test plan with the design and development

Projects : E-Gaming Services

Duration : May 2015-Sep2015

Company : CGI,Moncton

Client : Atlantic Lottery, Canada

Environment Tools: Microsoft SQL Server Studio, Quality Center, Cognos, Jira, Sharepoint

Created detailed Test plans to check the functionality of Application

Responsible for creating test case templates to facilitate mapping rules

Developed Tractability Matrix which is a proof of document to ensure that all the specifications are been tested and has no defect

Planning and reviewing the Test cases for Functionality, Security, Performance, Database and User Acceptance

As a QA Lead, participated in walkthroughs for the evaluation of the test plan with the design and development

Performed manual testing on different Modules of the Application by executing the Test Cases

Projects : Video Lottery Game Testing

Duration : Oct 2012 to Till Date & APR-2010 to Mar 2011

Company : HCL Axon Technologies

Client : SPIELO (A Gtech Company), Canada

Environment And Tools : T-plan, Jira, Darius, SAS protocol (Communicating with VLT),Winscp, Putty RGS, Jackpot Simulator, Darius, TCE, Platform :Sensys, Sensys EP

Video Lottery is a product which provides an interactive and entertaining way to play games of chance for the opportunity to win small cash prizes. The Video Lottery offers a variety of games including line games, Poker games, and Keno games. This project involves development & testing of different reel games, Keno and Poker like “The Wild Life, Vegas Classic, Royal Spins, Lucky 8 Lines, and Greatest Game in the West, Dragon’s Spell across different markets worldwide.

Responsibilities:

Analyzing and understanding the Games Blueprint & product specifications, Paytable sheets, State diagrams, different markets gaming standards and Regulations.

Preparing Bonus Cheat testing document.

Develop the Test plan, Test Strategy and Test Scripts for video lottery games on SPIELO (lightening Framework).

Tested the games to check whether the game is paying the player correctly according to the pay table requirements.

Tested the games to check whether the game is meeting the market requirements like if it the game is developed for Italy, it has its own requirements and market standards.

As a tester, I had to test all winning and losing combinations. These combinations can be generated using various cheating tools (Company propitiatory tools.)

Perform statistical analysis of gaming device and game probabilities by verifying

Slot Accounting System (SAS) including Ticket In/Ticket Out system bonus and cashless gaming

Tested games and identified defects by paying close attention to quality, entertainment, visual, appeal, sound, environment and overall functionality.

Testing of gaming technology communication protocols such as SAS,G2S

Defect tracking and reporting, providing core dumps and other logs through putty with Linux and UNIX commands.

Actively Participated in Game Blueprint, Product Specification Document and Game Translation Document Reviews.

Projects : CBM-L3A, L3B BIM and commiz Reports

Duration : Apr2011-Sep 2012

Company : HCL Axon Technologies, (Sydney and Chennai)

Client : Commonwealth Bank of Australia

Environment / Tools : Teradata SQL Assistant 12.0, HP-Quality Center, Data stage Director, Microsoft SQL Server Management Studio, Unix, Winscp, Putty

CBM – L3A BIM extracts and transforms the data from SAP BI –Prod data/Audit Log data/Business Journal data load into ODS by applying a set of Business Rules and Transformation logic that has been defined by CBA and then transferred to the respective Servers as extract files. . BIM testing team focussed on testing the requirements from Vendor Specification documents (VSD) and/or Source to Target (S2T) specifications. The BIM BAs will produce the VSD’s/S2T’s based upon the requirements from DOORS

In L3b, the ‘Commercial Lending’ module for CBM migrated DDS products as Better Business Loans, Bills Matured Accounts and Business Lines of Credit into SAP. The GEMS common layer will provide monthly extracts of the Account and Master Contract files to GEMS. The account file will be enhanced to accommodate L3B products and functionality. GEMS system will be modified to accommodate the new products and functionality.

As a Test Analyst, I was responsible for:

Analyzing and Understanding the requirements including testability and verification of the reporting requirements can be catered to using the data available.

Developing and Reviewing Test scripts/cases to verify data transformations as per the business rules and extraction criteria.

Run the Test scripts to verify data mappings between the Source and target tables.

Performing Test Execution

Checking the availability of data in ODS tables.

Creating SQLs - Create SQL queries to fetch and verify the data from Source tables and views.

Count Validation - Record Count Verification/Reporting queries against source and target as an initial check.

Source Validation - Validation of the Source data after isolating the driving source tables/views and checking the data integrity between the various source tables and relationships.

Data Quality and Field Level Data Validation - Check for missing data, negatives and consistency. Field-by-Field data verification to be done to check the consistency of source and target data.

Document and Log defects in Quality Center tool and defect tracking till closure.

Perform End-to-End DWH testing and Regression Testing for all Product extracts.

Task allocation to the team and Liaising with team members to track the daily progress of testing activities as per plan.

Involved in Troubleshooting, resolving and escalating data related issues and validating data to improve data quality

Projects : Adaptive Payments

Duration : Sep2009-Mar2010

Company : IIC Services (India) Pvt. Ltd.(Hyderabad)

Client : Adaptive Payments (Florida)

Environment / Tools : Bugzilla, Test Director, PLSQL Server, Windows, HTML, .net

Adaptive Payments 1.0 will enable consumers to make internet purchases in a manner that reduces identity theft risk. We will leverage existing IVR and merchant payment technologies such that we don’t interfere with the merchant payment system or their acquiring technology, but rather, operate alongside the merchant and their acquirer. We intercept the transaction, and in the US, convert it from signature debit to a PIN debit transaction by authenticating the PIN through Asterisk IVR.

Responsibilities:

As a Test Engineer, involved in preparing test plan and test cases for all the modules (Web Server, Asterisk Server, Payment Server) of Adaptive Payments.

Manual Execution of test cases

Reporting Defects in bug reporting tool.

Manual Execution of database tables for all the three databases (Web database, Asterisk database and Payment database) using MySQL server.

Projects : REL -4 deployment -NSN DX-200 platform of MSS & MGW and EMP Mobile

Platform testing

Duration : Sep2009-Mar2010

Company : Tietoenator (Hyderabad and Finland)

Client : Nokia and Ericson

Environment / Tools : GSM, GPRS,UMTS

REL -4 deployment -NSN DX-200 platform of MSS & MGW:

• Installation, Commissioning, acceptance testing of NSN DX-200 platform of MSS and MGW for Release -4 features in Vodafone network including Complete Acceptance testing & Handover

EMP Mobile Platform testing:

• System test engineer in testing several Mobile Application suites of EMP U350 platform project for A300 2.0 project. & A300 V1.0 project

•Performed TAT, GCF conformance for Modem 2G & 3G in Ericsson Lab, Sweden and involved in 3G testing in Test labs

TECHNICAL SKILLS

Wireless Technologies : GSM, GPRS, UMTS

Data bases : SQL, MYSQL,

Testing : Manual, Mobile Handset, Automation(QC) testing, Data warehouse Testing,

Game testing

Scripting Language : PERL

Operating System : Windows 98/2000/XP, Unix.

Telecom Tools : Gremlin, Now SMS, Nokia Developer tool kit

Automation Tools : Test Director, Quality Center, Teradata SQL Assistant, Data stage Director

Bug Tracking Tools : Mantis, Bugzilla and Jira

Protocols : ISUP, SS7

Configuration Tools : CVN, SVN, P max, Document um, Alein brain

Contact this candidate