Rakesh G 814-***-****
*************@*****.***
SUMMARY:
A creative and professional team player with 6 years of experience in
Informational Technology and Quality Assurance worked with various clients
providing expertise, training, and support on the effective use of QA
tools, and practices.
QC ADMIN
. Around 5 years of experience as a Mercury Suite Admin with Installing,Configuring and customizing the Quality Center application with a
strong software testing and development experience
. Strong experience in administration of mercury suit and well
experience in installation of QTP, Load Runner and Quality centre
8.0,9.2, 10 & ALM 11 version on a clustering and load balancing
environment.
. Expertise in Integration between Quality Center & QC Dashboard
. Customizing Quality Center as per industrial standards.
. Experience in Migrating and upgrading from any version of Test
Director to Test Director or Quality Center.
. Experience in implementing LOG files to debug Test Director and SQL
trace for DB checkpoints.
. Experienced in setting parameters for Site Configuration
. Experienced in developing and using API(s) for Quality Center.
. Writing custom macros in Excel to import the Test Plan, Requirements
into Test Director.
. Customizing Quality Center as per industrial standards.
. Experience in installation of all types Automation tool, Add-Ins, and
3rd party connectivity tools.
. Setup the e-Mail system with SMTP or IIS SMTP protocols.
. Customizing Test Director/QC Defect tracking module using VB
Scripting.
. Expertise in Automate Business Process with Mercury & Compuware
testing tools.
. Hands-on experience using QuickTestPro, Win Runner, Quality
Center/Test Director, Load Runner.
. Experience in analyzing Business Requirements, Functional and
Technical Specifications.
. Solid experience in Develop, Review, Execute, and Maintain Test Plans,
Test Cases, and Test Procedures.
. Expertise in Manual and Automation testing Client / Server, Mainframe
& Web applications.
. Strong understanding of QA Principles, QA Process, Use Cases, and
Software Development Life Cycle.
. Experience in Data Driven testing and parameterize the Performance
Session Scripts. Proficient in the use of various testing tools such
as Mercury Interactive tools and Rational Suite.
. Extensively involved in White-Box, Black-Box and Full Life Cycle
Testing.
. Experience in tracking test coverage and providing Metrics to the
management.
. Involve in load balancing and identified the failures on the server
and maintain the system administration.
. Developed numerous Load Scripts based upon the functionality and to
perform the application.
. Responsible for test preparation, execution, reporting, and
supervising daily activities of team.
. Perform Smoke, Integration, Functionality, Performance, Load,
Regression, and System Tests.
. Experience in document Defects with high level of detail, accuracy,
and informative recreation steps.
. Experience in Software Verification, Validation and Testing
Methodology.
. Experience in Oracle, MS-SQL databases and Windows operating systems.
. Experience in using TOAD for querying Oracle databases
. Extensive experience in setup and maintenance of Test Environment.
. Strong experience in installation of various Software's and Tools
. Involved in providing training on new products and responsible in
preparing training documents.
. Knowledge in Six Sigma, ISO 9000:2000 standards, CMM, & Automated
Testing Life-Cycle Methodology.
TECHNICAL SKILLS
TESTING TOOLS : Mercury Interactive QuickTestPro
6.5/8.0/9.0, Win Runner
Test Director, Quality
center 9.0/10, Load Runner,
Track Record 6.0/5.0,
Mantis BT, PR Tracker, Test Track Pro, TRAC,
Fogbugz.
LANGUAGES : COBOL, SQL, TSL, Visual Basic
4.0//5.0/6.0, Crystal Reports.
PACKAGES : MS Office (MS-Word, MS-Excel, MS-Power Point, MS-
Access) and
adobe photoshop
OPERATING SYSTEMS : Windows 2000 Server & Professional, Windows NT,
Windows
95/98/ME, Unix, Linux
MIDDLEWARE TECH : Jboss and Web logic
DATABASES : SQL Server, Oracle, Mysql, MS Access.
PROJECT
AT &T Plano / TX
Oct 09 - PRESENT
Role: QC Admin.
Responsibilities:
. As a Technical Lead responsible for handling team and assigning tasks
to individuals.
. Scheduling weekly status reports and sending reports to business
sponsors.
. Responsible for requirements gathering and analysis.
. Responsible for creating documents in all the phases of the project
life cycle and training materials.
. As a QC Admin Responsible for Installing, and Configuring QC 10/ ALM
11 on clustering and load balancing on servers and installing Client
components on client machines.
. Responsible for migrating all the projects and its database schemas
from legacy servers to the DCC new servers.
. Validating weather all the users are properly migrated along with the
projects.
. Hp uses LDAP authentication as a login process for QC.
. Strong experience in setting up LDAP Servers.
. Developed the tools to upload attachments, Linked defects in to QC 10
and list manager tool to import the list values in to the QC.
. Developed the macros to migrate the data from legacy tool to the QC 10
. Migrate the users in to QC using bulk add user tool.
. Consolidated the projects from other instance of QC9.2 into MYQC
server in DCC.
. Working very closely with GDBA team in HP during the migration process
for any assistance regarding databases.
. As a QC admin created projects and customized the projects and the
fields as per the business needs.
. Experience in implementing LOG files to debug Test Director and SQL
trace for DB checkpoints.
. Experienced in setting parameters for Site Configuration.
. Writing custom macros in Excel to import the Test Plan, Requirements
into Test Director.
. Customizing Test Director as per industrial standards.
. Setup the e-Mail system with SMTP or IIS SMTP protocols.
. Customizing Test Director/QC Defect tracking module using VB
Scripting.
. Experience in installation of all types Automation tool, Add-Ins, and
3rd party connectivity tools.
Environment:
Windows 2003 Servers, Quality Center 10, ALM 11, Jboss, IIS, Oracle
10g2.
Walmart, Bentonville, Arkansas
Apr 08 - Sept 09
Role: Migration Consultant Lead/QC Admin
Responsibilities:
. As a Technical Lead responsible for handling team and assigning tasks
to individuals.
. Scheduling weekly status reports and sending reports to business
sponsors.
. Responsible for requirements gathering and analysis.
. Analyzed business and system requirements for all Integrations.
. Involved in documentation during various phases of product life cycle.
. Used MS Project for Project scheduling during the entire life cycle.
. Involve in preparing Test Plan, Analysis Documents and Involving in
identifying gaps.
. Responsible for Installing, and Configuring TD, QC and Client
machines.
. Migrating Team Track Issues in to Quality Center.
. Configure and implemented LDAP authentication to enable QC to login
using HP Group email address for secure authentication.
. Experienced in setting parameters for Site Config
. Experienced in developing and using API(s)
. Extracting the data from different databases (SQL Server,Mysql and
Oracle) using complex queries.
. Writing Stored Procedures and functions to retrive the data according
to the client requirements.
. Writing custom macros in Excel to import the Test Plan, Requirements
into Test Director.
. Customizing Quality Center as per industrial standards.
. Involved in analyzing System specifications, design, development and
execution of test plans and test Cases for manual testing and
Automated testing.
. Created criteria for data conditioning needed for Automated and manual
testing.
. Reviewed the Business Requirements document with the business and
development teams to understand the architecture and functionality of
the application.
. Debug the Test Scripts, created Batch tests, verifying the test
results and reporting the defects to Test Director.
. Wrote SQL, PL/SQL queries/procedures to access the data from the
database tables and crosscheck the results, also been used for
Automation Regression Testing.
. Documented bugs, questionable functions, errors, and inconsistencies
in application functions, outputs, and content.
. Develop Dynamic Reports using Macros developed in VB.
. Track test results for management, categorizing issues and
creating/distributing defect reports and managing defect database
using Test Director.
Environment:
Team Track, Mysql, Oracle, SQL, Unix, XML, Quality Centre 9.2, QTP
9.0.
Verizon, Irving, TX
Jan 07 - Mar 08
Role: QC Admin
Responsibilities:
. Analyzed Business/System requirements, Use Cases and proposed necessary
Project and Workflow customizations.
. Setup and upgraded the Quality Center Repository from earlier versions of
Quality Center to 9.2 and performed the necessary schema updates on the
backend database.
. Proposed and successfully implemented the revamping of QC domains to
efficiently maintain the business processes.
. Managed and migrated User, Vendor Software Lists, Versions, Licenses and
Contacts into internal software tracking tool.
. Involved in QC Migration and trained new QC people on Migration Process
. Guided QA team with QTP script creation and loaded automated scripts in
to QC.
. Involved in meetings with Business and converted their inputs to UI
changes in Quality Center 10.
. Guided and reviewed the Project customization and Workflow customization
in QC 9.2
. Completed Project and Domain Assignment and Authentication to different
users and teams.
. Developed custom interface with OTA API's to send high level QA data in
XML format for reporting purposes.
. Played as lead role and trained new hires and created user guides for QC.
. Involved in Test case Planning, Design and executing end to end test
cases.
. Managed as QC Administrator for both on-site and off-shore teams.
. Migrated requirement and defects data from legacy applications into
Quality Center.
. Successfully upgraded Quality Center from 9.0 to 9.2.
. Wrote VB scripts in script editor to enforce additional constraints
through workflow customization.
. Managed user connections and setup load sharing in Quality Center Multi-
Node environment.
. Successfully configured Quality Center with multiple DB Servers.
. Responsible for daily and weekly status updates showing the progress of
the testing effort and open issues to be resolved.
. Tested configuration changes in Site configuration section of Quality
Center.
. Involved in tracking, reviewing, analyzing and comparing Defects using
Quality center.
. Written different Queries in SQL for Quality Center.
. Involved in Quality Center Administration and Maintenance.
. Conducted and Participated in QC Review meetings.
Environment:
Windows 2003 servers, Quality Centre 9.0, QC 9.2, SQL, VB Script,
WIPRO INDIA
Jul 05 - Dec 06
Role: Developer
Description: The Project aims at providing mortgage loans for the
customers throughout central Texas. Online Loan Application is a web
application designed to help customers apply for a mortgage. Once applied,
customer can check current status of his/her application online through an
automating key number, which is generated and sent to his/her email.
Developed the application for calculating and estimating the refinance
payments as per the length of customer's loan. The system also accommodates
a processing/approval model through which aids the Finance and HR Team to
generate a report to keep track of loan approval process.
Responsibilities:
. Involved in developing various modules for the Mortgage System using
.NET technologies.
. Responsible for requirements gathering, analysis, design, development.
. Used UML diagrams for describing the structure and relationship
between the classes.
. Developed technical design documents by following functional documents
using Object-Oriented Methodology including use cases for testing.
. Designed and development of components using C#.NET and ASP.NET
Framework Classes.
. Designed Database and development of tables, views using SQL.
. Designed & development of presentation tier (Web Forms) using ASP.NET
2.0, XML, HTML, JavaScript and Jquery.
. Involved in developing the forms for mortgage refinance rates.
. Wrote the code for calculating the refinance payments by implementing
the refinance calculators.
. Used Validation Controls and JavaScript to perform form validation.
. Implemented business logic using C#.NET & backend connectivity using
ADO.NET.
. Used ADO.NET data objects such as Dataset and Data Reader to
manipulate data.
. Implemented application state using view state, session variables and
query strings.
. Developed various stored procedures, packages, cursors using SQL.
. Responsible for generating the reports using Crystal Reports as per
the client's day to day requirements.
. Developed various test case and test scripts for testing and
debugging.
. Responsible for deployment of the applications on IIS 6.0 Web Servers.
. Provided more enhancements to the application by adding more
functionality.
Environment: C#.NET, ASP.NET 2.0, ADO.NET, Visual Studio.NET 2008, UML,
XML, SOAP, HTML, DHTML, CSS, JavaScript, Jquery, IIS 6.0, SQL, Visual
Source Safe (VSS), Crystal Reports, Windows XP.