Post Job Free

Resume

Sign in

Test Cases Data

Location:
Naperville, IL, 60540
Posted:
January 12, 2016

Contact this candidate

Resume:

Srinivas Manikonda

acs22g@r.postjobfree.com

Phone: 630-***-****

OBJECTIVE:

Seeking a challenging career as Sr. QA Tester/Analyst in the field of Information Technology.

QULIFICATIONS SUMMARRY:

Over 15 years of experience in design, development, implementation and testing of both UNIX and Windows based Client/Server applications

Strong Experience in Database testing for ETL solutions.

Actively participated in SCRUM meeting representing QA in defining the scope and bring the issues and resolving them to the satisfaction of all the stake holders in Agile Environment.

Experienced as a QA Analyst working in Agile/Scrum environment and reviewed user stories.

Thorough understanding of Scrum methodology and worked in sprints to meet the deliverables.

Extensively worked in in Test Planning, Requirement analysis for test cases design for Database solutions.

Expert knowledge in testing Qlkview Dashboards generated from ETL Solutions for Business Analysis

Expertise in testing the Applications Manually (Black Box and White Box Testing) Test Director, and Quick Test Professional.

Strong Experience in working in multiple plat forms like Grid (Parallel Processing), Open Systems (Unix TRU 64),

Strong Experience in testing the applications using Manual and Automated Testing Tools using Mercury Interactive tools Load Runner and Test Director/QTP

Extensive experience in Manual Testing, Automated testing and quality assurance of Client/Server and Web Applications using both Black Box and White Box testing techniques.

Extensively worked on SOAP UI in testing Web Services Rewards program portal.

Extensively worked and used Process based Test management tools and created Test Plans, Test Cases, System Specification Analysis Documents, record results and test reports.

Maintained and updated Test cases and Test Scripts using Test Director and CARS (Compuware Application Reliability Solution)

Diverse work experience on Unit Testing, Functionality Testing, Integration Testing(IT), GUI Testing, System Testing (ST) and Regression Testing User Acceptance Testing (UAT).

Extensive experience in client/server and web application testing using System Testing, Functionality Testing (White & Black Box), Integration Testing, Regression Testing, GUI Testing.

Extensive work experience in in testing Web Portals in Multiple Browsers

Strong experience in coding using SQL, PL/SQL using SQL Assistant, DB visualizer, TOAD.

Strong Proficiency in writing test plans test scenarios, test cases and test reports using.

Effectively worked with different teams in V-Modal, Water fall, Agile (SCRUM teams) Methodologies.

TECHNICAL SKILLS:

Operating Systems: Unix (Solaris, AIX, HP-UX), Linux, MVS, WindowsXP/NT/98/2000/XP/Vists.

Architecture: Client-Server, Parallel Processing, Grid Processing, ETL, SOA.

Languages: Koran shell Scripts, JCL

RDBMS: Terra Data, Oracle11G/109 Netezza SQLServer 7.0

ETL Tools: Datastage, AbInitio Informatica

Tools: MS Word, MS Excel, MS Power Point UltraEdit, vi

Browser Internet Explorer 7/8/9, FireFox3.1/4.0, Google Chrome, Safari

Testing Tool: SOAP UI, Win Runner 7.0/6.5, Test Director 7.0, and Load Runner, Xrunner and Quick Test Pro, JIRA

Methodologies: SDLC, Waterfall Model, V-model, Agile Test/Scrum Test methodologies

EXPERIENCE:

Follett Higher Education Group, Westmont, IL Mar 2012 – Current

Role: Integration Test Engineer

Systems: OneFee, POS systems (Win/DSS and COREPOSE), RIM, SODA, eFollett.

Modules: Student Adoption Matching (SAM), Master Catalogue, Course Materials,

Order Routing, Win/DSS (Distributer Store System – POS); Migration to COREPOS. Integration of POS systems (COREPOS and Win/DSS) with Internal systems RIM (Rental Management system)CARP (Customer Accounts Receivable and Purchases) FHEG gift cards and External Systems like Apple, Datatel accounts BHN Branded and Non-Branded gift cards and

Description:

FHEG provides Text books and other educational course materials for the Higher Educational Institutions in US and Canada at store Level and on Internet for students to buy or rent. FHEG has multiple Desktop, Online (eFollett) and POS (Win/DSS and COREPOS) solutions which are integrated to streamline the business process, Win/DSS, COREPOS and OneFee project are few of many single point solutions of FHEG where a student can buy or rent course materials at the time of Course registration

Responsibilities:

FHEG projects was Planned, Designed and implemented in Agile. Represented as a stake holder Integration team in SCRUM meetings. Actively participated in requirements (Stories) analysis for testable and non-testable requirements with business analysts. Responsible for Test Planning Test cases creation, review and baseline, setup Test Data working with development and DBAs, Design test Transactions from course setup to Order fulfillment, Test execution, Document test transactions and test results, Touch Paper, SLIK was used for Defect management and resolution, Represented QA during product deployment to production and production support.

Allant Group, Naperville, IL, Oct 2011 – Feb 2012

Role: QA Test Analyst

Project: Subscriber DB and Impressions and Response DB

Client: Comcast

Description:

IRDB and SDB are in ETL solutions for generating Qlikview Dashboards for Comcast based on viewer interactions with the campaigns run by the customers. Multiple internal and externals source files file are processed to gather information on the subscribers to generate ready to use data in oracle Data warehouse for the qlik view dashboards.

Responsibilities:

Test Planning, Requirement Analysis for Testable requirements, test case creation test case review with stakeholder in the release. Actively participated in SCRUM meetings to interact and coordinate with other stakeholders of the project in meeting the project deadlines in Agile environment. Used SQL extensively in querying the Oracle DW for the data integrity during test case execution using TOAD. Used JIRA Test to post the Test documents like Test plans and test cases and Requirement Traceability Matrix (RTM). Defect management was performed using JIRA.

Intelisense/Dysis, West Dundee, IL May 2010 – Sept 2011

Role: Quality Test Analyst - Consultant

Project: Sears Online Business Unit (OBU); Shop Your Way Rewards Program (SYWR portal)

Client: Sears Corporation

Description:

Sears Online Business Unit (OBU) is IT wing of Sears Corporation responsible in providing Retails services to the SEARS customers and other sister stores like K-Mart, The Great Indoors, Craftsman, Mygofer, Land End etc customers thru it web sites sears.com and the SEARS' sister company sites . Shop Your Way Rewards (SYWR) is rewards program offered by SEARS corporation to all the SEARS and Stores customers to accumulate and redeem the points when customers shop on SEARS site. SYWR portal is highly visible tool integrated into stores sites and SEARS.com to give a fulfilling experience to the online SEARS customers.

Responsibilities:

Analysis of Requirement for Test Case Creation with Business Analysts following

Agile Methodology and represent the QA in SCRUM meetings defining the QA scope, Issue resolution in short release cycles to the satisfaction of all the stake holders in the release.

Test Plan and Test Cases Creation and review for each release in SCRUM teams based on Business Requirements, Wire Frames, HTMLs. Involved at various stages of the AGILE Methodology SDLC & Scrum to the project and prepared Test plan and cases. Worked in sprints to meet the daily deliverables and to track the project status.

Created Test Plans and Test Cases for Business critical projects like SYWR Financial pages (FSP), Holiday Points and reviews them with stake holders of the Change Requests and Upgrades to the SYWR portal to test functionalities and Lead the team during Integration of the portal into the WCS store sites.

Data Set up in test environment to execute the functional test cases for multiple releases like Financial pages, integration of Craftsman club member rewards into SYWR program.

Performed Test lead duties in coordinating the test execution onsite and offshore testing resources.

Performed extensively Regression Test, Smoke test for SEARS site, WCS stores sites and SYWR Portal's for site integrity and performance in short testing time spans..

Tested SYWR portals' web services using SOAP UI when necessary.

Performed the Data Validation Testing in Epsilon Database for customer profile.

Analyzed Poster Order (PO) transactions for missing transaction on customer profile. Extensively worked with Data stage logs in tracing them on Unix environment. Queried to Oracle Database for using DB visualizer for the pulling data from table.

Defect management was handled thru JIRA. Worked thru Developers and QA environment Team in resolving the Defects.

Supported the Deployment teams at the time of going live in to production.

Actively worked with production team to support the issues that came out during the Production run of the solution.

Developed a process to complete the Requirement Traceability Matrix (RTM)to track testable and non-testable requirements.

Acxiom Corporation, Downers Grove, IL Jul 2006- Apr 2010

Role: Test Analyst

Project: Prospect Pool Database

Client: Capital One

Description:

Prospect Pool is (Data warehouse solution interacting with Multiple Applications (Processes) like PCMI, CBAS, FF(Fulfillment Process) RTPM providing the latest information of an individual (Prospective Customer) to the client. The deliverables for the client was required via monthly releases. The process of delivering the enhancement to the Prospect Pool EDW and interacting processes had tightly controlled process right from ideation of an enhancement (Change request) thru implementing the enhancement in the production. The process include gathering business requirements, deriving technical requirements, High Level Design. Detail Design, System Test Planning and reviewing and System Test Cases creation and reviewing, Test Execution, Defect tracking, Defect fixing, Defect testing, Test results documenting and reviewing and deployment of the enhancement in the production.

Responsibilities:

Worked on Technology Upgrade Programs (TUP) TUP-M (Migration of FF), TUP-L (Migration of Promotion History to Grid), TUP-I (Production of Bureau and Non-Bureau Sample Flat Files on the Grid) project where the Data processing was migrated from TRU64 Unix platform to Acxiom Grid. Main responsibilities were actively participating Requirements processing, Test Plan creation, Test Script creation Test Case execution. Defect creation and their pursuing for a successfully resolution.

Setting up data for FF processes using Korn shell scripts.

Execution of Data Stage Jobs on the grid to run the Fulfillment processes using web-based Acxiom Orbiter tool.

Developed Ab Initio Graphs in Test Environment and Regression Environment to verify the records and they layouts and the Data.

Worked on variety for Change request projects (IPODs) in tight schedules to meet the deadlines for timely delivery of the solution to client.

Extensively used Unix Commands to verify the files on Open Systems as well as Grid.

Extensively used and wrote SQL queries to setup (backup and restore), modify (update and delete) and verify Test data to execute test cases,

Actively worked with production team to support the issues that come out during the Production run of the solution.

Developed a process to complete the Requirement Traceability Matrix (RTM) to track testable and non-testable requirements.

Mahindra-British Telecom (MBT) June 2005- April 2006

Project: Customer Information Assignment (CIA)

Role: Test Lead (PPOC)

Client : SBC-ATT, Hoffman Estates, IL

Description:

CIA is a group of telecom applications which is intended to provide a common customer definition regardless of the region, affiliate, or business unit with whom they do the business. This group of applications in CIA project allow in unifying the multitude of diverse legacy customer identification method into easily understood and used reference source. This group of applications consists of CDR ( Customer Data Repository), SDR (Strategic Data Repository), MOCHA ( Management of Customer Hierarchy Assignment), Central Repository of Emails Management for the Enterprise and others. This group is also called CIM Core.

Responsibilities:

In addition to Team Lead role, Performed and Co-Coordinated System Test Execution for CDR (Customer Data Repository) and SDR (Strategic Data Repository) at Offshore.

CDR: CDR is DB2 data base running on the UNIX. It consists of customer data and it has layers of applications, Data Stage and Quality Stage which are run in order perform hard match and soft match process to create a unique customer. There are multiple sources of data being fed into these applications.

SDR: SDR is Data Store and resides on EDW (Enterprise Data Warehouse). The Data sources for SDR are both internal and external systems to CIM core. The data in SDR is processed by running JCLs on MVS system.

Team Lead, Develop Test strategies, Schedule System Testing, Co-ordinate Test team efforts with other teams like, Design, Development, Deployment.

System Test Plan and Test execution CDR (Unix DB2 and Data stage jobs) and SDR (MVS JCLs IMS) and Terra Data.) Attend Business Requirements, Technical Requirements, High level Design and Detail Design review meetings. Conduct Peer Review meetings for System Test Plans Conduct and Systems connectivity review meetings with onsite and offshore.

Extensively used Unix Commands to verify the files on Open Systems as well as Grid.

Extensively used and wrote SQL queries to setup (backup and restore), modif (update and delete) and verify Test data to execute test cases

Environment: Win Runner 6.0, Load Runner6.0 Manual testing (Black Box), C++, X-motif, Oracle, Sun Solaris, Frame Maker.

EDUCATION:

Masters degree in Industrial Management

South Dakota State University.



Contact this candidate