SUNIL REDDY email:
abk0vi@r.postjobfree.com
Senior QA Automation Consultant mobile:
Summary:
. 10 years of experience in Software Development Life Cycle (SDLC) and
Software Testing Life Cycle (STLC).
. Experience in different stages in SDLC, like Analysis, Design,
Development, Implementation and Testing of business application systems.
. Domains: Experience in various domains like Insurance, Transportation,
Merchandising, Supply Chain Management, Payroll, Financial, and Mortgage.
. Analysis: Experience in analyzing Business Requirement Documents (BRD),
System Requirement Documents (SRD), Product Request (PR) Documents,
Change Request (CR) Documents.
. Design and Development: Experience in Designing and Developing Test
Plans, defining Test Cases, Developing and automating Test Scripts for
the various testing cycle of testing, like Unit, Integration, System (End-
to-End, Functional, Stress, Volume, Load, Regression), User Acceptance
Testing.
. Automation Tools (Functional & Regression-Testing, Load-Testing, and
Defect/Bug Tracking): Experience in using iTKO LISA, HP-Mercury
Interactive Tools (Quick Test Professional (QTP) 9.5, Win Runner, Load
Runner, Test Director, and Quality Center), Webload, Rational Clear
Quest, and JIRA (Atlassian).
. Back-End Testing / Database Testing: Expertise in writing stored
procedures, database triggers, DTS in MS SQL Server 2000/2005, MS Access
7.0/'97, and Oracle 10g/9i/8i database servers
. White-Box Testing: Experience in UNIT testing meaning White-box testing
meaning Code (VB.NET, C#, and VB languages) testing including Web
services and XMLs and also used unit test tool called NUnit.
. Other Testing types: Experience in various kind of testing like
Functionality, Usability, Compatibility, Interface, Performance, User
Acceptance, System..
. Integrated Design/Debugging Environment Tools: Experience in using Visual
Studio Team System 2008, VS2005, and VS2003
. Change Management Tools: Experience in using different Change Management
Tools such as SVN-SubVersion, Team Foundation Server (TFS), VSS, CVS,
Harvest, PVCS Tracker.
. Designing Tools: Experience in using Microsoft Visio, Telelogic System
Architect to design Functional flow-charts, sequence diagrams.
Education:
. Masters in Computer Science
. Bachelors in Computer Engineering
Technical Summary:
Testing Tools iTKO LISA, Quick Test Professional 10/9.5/9.0/8.2/8.0,
Win Runner 7.6/7.0, Load Runner 7.6/7.0, Quality Center
9.5, Test Director 7.6, Webload, JIRA.
Databases MS SQL Server 2005/2000/7.0, Oracle 10g/9i/8i, MS Access,
DB2
Environment Windows XP/2003/NT/98, IIS 5/4, HP-UX, Linux, MS-DOS 6.22
Programming Visual Studio 2008/05/03, VB.NET, C#, SQL, PL/SQL, C,
Java 2.0/1.1, HTML, PERL, COBOL
Framework NFX v1.5, ASP.NET v1.1/v2.0/v3.5, WCF and WPF.
GUI JavaScript, VBScript, HTML 4.0, Visual Basic 5.0,
Developer 2000
Source TFS (Team Foundation Server), Harvest (Computer
Controls Associate), MS VSS
Designing Tool System Architect (Telelogic), MS Visio
Project(s) Summary:
Fireman's Fund Insurance Company, Novato, CA
June'10-Current
Automation Engineer
ECM-R (Enterprise Client Management - Reengineering) is a project name
called for Release 1A. This is Personal Lines of Business.
Responsibilities:
. Deliver and review all project documentation with the testing team to
ensure complete understanding of project goals and requirements
. Prioritize test objectives and functions to ensure sequence of actions to
follow
. Create test plans and ensure detailed test scripts to cover all the
requirements accordingly
. Furnish traceability matrix for the test scripts, and process, test
tracking document, and test calendar
. Review test plans and test scripts with other systems/applications as
required to avoid overlapping of tasks
. Provide the release team with a daily work packet which contains
instructions and information regarding testing requirements, environments
and data availability
. Coordinate with application development/environment team to ensure all
the databases and mainframe environments are ready for all phases of
testing
. Ensure table and data availability in all 3 mainframe (i.e. test, prod
and dev) environments
. Identify new functionality and regression scripts to ensure testing
coverage
. In-charge in incorporating all the test scripts and test cases in Quality
Center
. Scheduled test scripts based on the events and cycles provided for the
initiative thru Quality Center
. Coordinate all communication and escalation of testing activities with
downstream applications to ensure that data flows correctly
. Provide overall status reports to the Release Management Team
. Completed an end to end documentation of the project that includes test
plans, scripts, data sheets, traceability matrix for project manager's
review and sign-off
. Developing test automation scripts using QTP for functional and
regression testing
. Developing test automation scripts using iTKO LISA tool for
virtualization, for services testing.
Environment: QTP 10.0, iTKO LISA, Sharepoint Portal Server, Quality Center
9.5, JAVA, Mainframe, IBM Personal Communications, Server 2005, DB2.
Nationwide Insurance, Des Moines, IA
May'09-June'10
Automation Engineer
Nationwide is one of the largest insurance and financial services companies
in the world, focusing on domestic property and casualty insurance, life
insurance and retirement savings, asset management, and strategic
investments.
Responsibilities:
. Prepared the Automation Plan using keyword driven framework for the
Application under Test.
. Participating in designing discussions and preparing the design flow
using MS-Visio.
. Implementing the design by creating the Automation scripts using QTP for
regression and functional testing.
. Regression testing performed on every new build of the application.
. Used the BPT scripts for regression testing.
. Reporting the Coverage status of test performed on the daily/weekly
basis.
. Involved in Project meetings and interacted to other team members in
order to resolve the problems.
. Developing the scripts for Web based applications and Mainframe
applications based on the manual testing scenarios and test cases.
. Used the temporary data as test data for execution of test scripts.
. Participated in the system testing and release testing for every month
releases.
. Involved in Project meetings and interacted to other team members in
order to resolve the problems.
. Performed System testing, User Acceptance Testing, Regression testing,
Usability Testing.
. Created tickets using Quality Center.
. Maintained the results in the Quality Center for next releases.
. Used SVN-SubVersion for version contol.
Environment: Quick Test Professional (QTP) 9.5, VB Script, Quality Center
9.5, JAVA, Mainframe, PASSPORT, Agent Center(Commerical Internet Quote),
Server 2005, DTS, MS-Visio, SVN-SubVersion, ClearCase, ExamDiff.
Publix Information Systems, Lakeland, FL
Nov'07-April'09
QA Analyst
Merchandise Planning System (MPS) initiative will allow Publix to generate
customized planograms (POGs) for logical groups of stores that optimize
product mix and the utilization of space. The grouping of stores will be
determined based on similar selling patterns. Product mix and the optimum
number of facings for each product will be determined based on
merchandising objectives and rules.
Responsibilities:
. Analyzing the SRD documents and prepared the GAP analysis document.
. Designed and developed Test Plans and Test Cases for the Unit level and
Integration and System.
. Developed QTP scripts for the AUT.
. Executed all the Test cases using Quality Center and maintained the
results.
. Expert in writing complex SQL Queries, stored procedures, using Oracle
and SQL Server 2005/2000 Database.
. Involved in Sanity Check test, whenever there is a new builds and was
responsible for communicating the results of new build to the team.
. Extensively involved in Back End testing, System testing & Regression
testing, User Acceptance Testing.
. Involved in White-Box testing using VisualStudio2008 IDE for VB.NET,
JavaScript and SQL Server 2005.
. Used DTS for data import and export from various sources and target
databases.
. Involved in migration of databases, by verifying the data flowing as
expected.
. Involved in design data flow/ functional flow Diagrams using Telelogic
System Architect tool.
. Used TFS and CA's Harvest for Version Control
. Created unit test cases.
. Executed Unit (white-box testing, using VB.NET code and C#. NET code)
test cases.
. Used defect tracking and test management tool Quality Center for tracking
defects.
Environment: Quick Test Porfessional 9.5, Quality Center, Visual Studio
2005/2008, ASP.NET 2.0/3.5, VB.NET, XML, SQL Server 2005, T-SQL, Oracle, PL
SQL, DTS, Teradata, SSIS, MS-Access, HTML, JavaScript, System Architect
(Telelogic), CCI (JDA - Channel Clustering from Intellect), Harvest Change
Manager (CA's), TFS (Team Foundation Server), IIS5.0.
Office of Payroll Administration, NY
Jan '07-Oct '07
Automation Developer
CityTime: OPA is the Office of the Payroll Administration division of New
York City that oversees payroll activities of 80 mayoral and other
agencies. CityTime is an automated time-keeping system that allows accurate
recording of time and leave events - resulting in less pay errors - and
will eliminate the need to collect time and leave data manually
Responsibilities:
. Developed Test Plans and Test Cases for the Unit level and Integration
and System.
. Executed all the Test cases and maintained the results.
. Expert in writing complex SQL Queries, stored procedures, using Oracle
and SQL Server 2000 Database.
. Preparing Automation Test Scripts using QTP.
. Involved in Sanity Check test, whenever there is a new builds and was
responsible for communicating the results of new build to the team.
. Extensively involved in Back End testing, tracking the status of the
order placed by connecting to different Legacy systems.
. Extensively involved in System testing & Regression testing, User
Acceptance Testing.
. Executed Integration Test Cases, System Test Cases, Regression Test
Cases.
. Used defect tracking and test management tool Quality Center for tracking
defects.
Environment: QTP 8.2, Quality Center, .NET 1.1/2.0, C#, ADO.NET, DTS, SSIS,
UML, XML, ASP.NET, VSS, COM, Java script, SQL server 2000, T-SQL,
Win2k/NT.
Electronics Data Systems (India) Ltd, Pune, India
CSR (DWP Account), UK
Dec'05-Nov'06
Information Analyst
Child Support Reforms, is a UK government project is existing in UK
government, this scheme is administered by the Child support Agency(CSA) is
a part of Department of Works and Pensions(DWP), which calculates child
maintenance, validate the information given by PWC(like who is NRP and
number of QCs) and ANRP(becomes NRP once accepts his/her parentage) and
collects payment if required, and enforces payment when appropriate.
Been to UK (onsite) for 4 months.
Responsibilities:
. Analyzing the LRA(Live Recovery Actions)
. Preparing the DSP(Defect Solution Plan) and Test Scenarios
. Preparation of Test Cases based on the Test Scenarios.
. Responsible for both Manual and Automated testing.
. Defined and documented test plans for applications and ongoing projects
. Performed functional, regression, performance and user acceptance testing
(UAT)
. Defects were Tracked, Reviewed, Analyzed and Compared using Test
Director.
. Using QTP, Win Runner and Test director tools for test automation.
. Implemented data-driven testing, synchronization points, checkpoints and
batch testing using Win Runner
. Verifying the Backend by giving SQL's through DB2 using either SPUFI or
CommandCenter from IBM.
. Worked closely with the business analysts and developers to identify the
processes that can be automated.
. Created Load Runner Scenario to- utilized Vuser scripts into real
Performance Test of claims.
. Set-up Multi-machine Load Test Environment using Load Runner.
. Documented the defects in Test Director and provided metrics to the
management based on the coverage's
. Participated scheduled meetings and maintained good relationship with
developers.
. End-to-End testing for each release.
. Preparation of Test Metrics
Environment: Accord Client, QTP8.0, Win Runner 7.5, Test Director 7.6, Load
Runner, JAVA, Main Frames, DB2, SPUFI, IBM Command Center, Windows XP,
Rational Clear Quest, AS/400
Aztec Software, Bangalore, India
Pervasive SQL, USA
Aug'04-July'05
Senior Test Engineer
Pervasive.SQL is data-management solution integrates performance,
embeddability and low total cost of ownership in a powerful, flexible and
scalable engine, the next generation of industry-leading Pervasive.SQL.
Responsibilities:
. Preparation of Test Environments/ Beds.
. Preparation of Test Cases and Test Plans using Test Director.
. Preparation in creating automation script and debugging.
. Created part of GUI map file, generated the test script using Context
sensitive mode and Analog mode.
. Created Load Runner Scenario to- utilized Vuser scripts into real
Performance Test of claims.
. Involved in Functionality and Regression Testing using WinRunner.
. Defect Reporting and Tracking the Bugs thru TestDirector.
. Preparation of Test Results.
. Preparations of Test Summary Reports, Bug Reports, Weekly/Monthly status
Reports
Environment: Tomcat, HTML, JSP, Servlets, Windows XP / NT / 2000, Linux,
Test Director, Winrunner
FOUR SOFT LTD, Hyderabad, India
Eagle Global Logistics, USA
Mar'01-Feb'04
QA Engineer
One of EGL's business objectives is to develop a logistics solution and
migrate all EGL stations from existing legacy systems to this solution.
This solution consists of integrating applications such as eTrans
(logistics solution) with Oracle Financials. The integration of data and
migration from legacy systems (Fastrack, CLASS, Worldport, PlusData, FAMS,
LIMS, and Universe) will occur in multiple phases.
Responsibilities:
. Preparation of Test Cases using Business Requirements.
. Preparation of Test Cases using change requests (CR) and product requests
(PR).
. Preparation of Test Plans.
. Testing key areas of customer's concerns like usability, performance, and
reliability.
. Test Execution and defect reporting thru JIRA.
. Partially involved in Automation testing using Winrunner for Functional
testing.
. Partially involved in Automation testing using Webload for Load testing.
. Preparing Test Summary Report.
. Preparation of weekly/ monthly/ quarterly status reports
Environment: Winrunner, Webload, JIRA (Atlassian), PVCS Tracker, VB.NET,
ASP.NET, XML, Oracle8i, and Windows 98/NT/2000, HP-UX.