Anil Kumar Arandkar
Email: adizkk@r.postjobfree.com
Mobile: +91-703*******
Professional Summary:
12+ Years of work experience as HP Quality Center, HP ALM and SmartBear QAComplete Administration in IT industry.
Integrated QAComplete Project with JIRA projects using the OpsHub interface.
Intergrated ALM 12.01 with TFS using ALM Sychronizer.
Expertise on installation of lastest patches and setup of HP Quality Center 9.2, 10.0, ALM 11, ALM 11.52 MF ALM 12.01, ALM 12.55 in Clustered Environment for global organization with huge user base.
Expertise on upgrade and migration of Quality Center Projects from Legacy versions and servers.
Expertise on customizing Quality Center projects as per user requirements.
Expertise on Integrating Quality Center with other third party tools.
Expertise on writing Scripts using OTA API.
Experience of working in second level support.
Good knowledge of Software Testing Life cycle.
Academic Qualification:
B.Tech (CSE), from JNTU, Telangana. (India).
Higher Secondary (Intermediate) from Learners’ Land High School, Telangana.
High School (SSC) from Learners’ Land High School, Telangana.
Skills Summary:
Operating Systems : Windows 10, Windows 7, Windows XP, Windows Server 2003, Windows Server 2008, 2012 and Sun Solaris.
Tools : HP Quality Center 9.2, 10.0, HP ALM 11.00, 11.52, MF 12.01, 12.55, 12.60, JIRA, Smart Bears QAComplete, Worksoft (Basic), TOSCA(Basic) and SQL Developer
Languages : Java (Core), Microsoft Visual basic 6.0
Scripting Languages : VBScript (used Quality Center script editor).
Databases : Oracle 9i and 10g, and Microsoft SQL Server 2005, 2008, 2012
Integrations : Smartbear QAComplete With JIRA and MF ALM with TFS.
Experience Summary:
Organization
Designation
Duration
Location
Birlasoft (India) Ltd.
Software Engineer(Emp Id: 58145)
July 2008 to Dec 2011
Noida/Bangalore.
Hexaware Techonolgies
Sr. Software Engineer (Emp id: 23326)
Dec 2011 to May 2013
Bangalore.
CapGemini India Ltd
Consultant (Emp Id : 050998_IN)
June 2013 to Aug 2015
Bangalore.
NTTData
Testing Engineering Specialist (106590)
Aug 2015 to Feb 2020
Hyderabad.
Birlasoft India Ltd
Project Leader (70256)
Feb 2020 to till date
Noida
Project Experience:
NTTData
1. HP Quality Center Administrator
Description
Client: Exxon Mobil
Role
Production Support
Skills
Quality Center 12.01, SQL database.
Contribution
1.Administrating and maintaining of ALM Production, Acceptance and Development Server.
2.Installed patch 5 on current MF ALM 12.01.
3.Migrated ALM application and DB servers from Windows Server 2008 to Windows Server 2012
4.Upgraded 150+ projects from ALM v12.01 to ALM v12.60
5.Creating Project, users, assigning user permission based on their roles.
6.Custom report based on user request.
7.Resolving day to day user issue, which logged in the issue ServiceNow.
8.Generate Custom Excel report using OTA to extract QC entities as per user request.
9.Implementing the workflow code as per user requests on specific projects.
10.Providing Training to users on Project metrics creation using Business views and Project templates.
11.Modifing the default project templates and business view as per user request.
12.Working on Integration of TFS with ALM 12.01
13.Develop an utility to extract Run and Step level attachments for provided Test Lab folder path.
Start Date
April 2018
End Date
Feb 2020
Team Size
2
2. HP Quality Center Administrator
Description
Client: Whirlpool
Role
Production Support
Skills
Quality Center 11.52, QC 12.55, SQL database, JBOSS application server.
Contribution
1.Upgraded 700+ project from QC 11.52 to 12.55
2.Administrating Quality Center Production Server and responsible for maintances of ALM servers.
3.Creating Project, users, assigning user permission based on their roles.
4.Custom report based on user request.
5.Resolving day to day user issue, which logged in ServiceNow.
6.Generate Custom Excel report using OTA to extract QC entities as per user request.
7.Take part in weekly calls with client on change requests and ALM tasks.
8.Working with Verification and Validation team to approve the Change request as per the client process for testing task.
9.Provided training to end users on project reports creation using Business views and Project templates.
Start Date
Aug 2015
End Date
April 2018
Team Size
1
Capgemini India Pvt Ltd.
1. Quality Center Administrator
Description
Client: Societe Generale Global Solution Center,
Role
Production Support
Skills
Quality Center 11, Oracle database, Weblogic server.
Contribution
1.Administrating Quality Center Server.
2.Creating Project, users, assigning user permission based on their roles.
3.Training to end users.
4.Project Migration from other server in SG to our Server based on the management requirement.
5.Custom report based on user request.
6.Take part in daily status calls with Paris team on progress of Tasks assigned.
7.Resolving day to day user issue, which are logged in the issue tracker.
8.Basic knowledge on QTP Scripts execution.
9.Generate Custom Excel report using OTA to extract QC entities on user request.
Start Date
June 2013
End Date
Aug 2015
Team Size
2
Hexaware Technologies
1. Smart Bear QAComplete Administrator
Description
Client: Russell_IPC_FSTD_CapitalMarkets_BFSI
Role
Production Support
Skills
SQL server 2008, QAComplete 9.7
Contribution
1.Administrating the Russell IPC Project.
2.Customization of IPC Project.
3.Creating the Workflow for the Requirements Test Management and Defect Modules.
4.Preparing the Training PPT for the end users on the QAComplete Tool.
5.Worked on integration of QAComplete and JIRA.
6.Resolving the End users issues regarding the QAComplete Tool.
Start Date
Dec 2011
End Date
May 2013
Team Size
1
2. Smart Bear QAComplete and JIRA Integration.
Description
Client: Russell_IPC_FSTD_CapitalMarkets_BFSI
Role
Administrator for QAComplete and Opshub Server
Skills
SQL server 2008, QAComplete 9.7 and JIRA 5.0
Contribution
1.Administrating the Russell Projects.
2.Integrating JIRA project with QAComplete Project using the interface.
3.Monitoring the OpsHub Server, interface used to integrate JIRA and QAComplete.
4.Worked to Support Team to make the integration run Smooth.
Start Date
Aug 2012
End Date
May 2013
Team Size
1
Birlasoft India Ltd
1. HP Quality Center 10.0 Support.
Description
Client: GE HEALTHCARE HCIT
GE HealthCare HCIT Quality Assurance department with a user base of 2000+ uses Quality Center 10.0 for the requirement management, test management and defect tracking activities.
Role
Production Support Analyst
Skills
Oracle 10g, Quality Center 9.2 & 10.0, VBScript, SQL. Java Scripting.
Environment
Server: 4 Sun Solaris Zones connected with F5 Load Balancer.
Database Server: Oracle 10g
Application server: Jboss Application Server
HP Quality Center Client Machine: Windows XP/7
Contribution
1.Supporting of QC involves providing access, creating projects, customizing different modules (Requirements, Test Plan, Test Lab, Defects) project entities, various troubleshooting steps etc.
2.Installation of patches in Development, Staging and PRODUCTION environments.
3.Creating and Executing Operational Qualification documents in the staging environment to ensure the correctness of upgrade as per the System Test Plan and System Test Cases.
4.Communicating with 2000+ users.
5.Handling Service requests received from the Clarify and Users. Creating Matrix Documents and Knowledge base for Team.
6.Interaction with HP support in handling issues related to Quality Center.
7.Managing Servers and performing operational task like monitoring of logs, archival and recovery of QC projects.
8.Backup and restoration of Quality Center Projects.
9.Coordinating with Server, Network and Database operation teams to restore and maintain QC service.
10.Migrating Projects from Production Environment to Staging Environment on a regular basic.
11.Migrating Projects from different instances with different databases to centralized Server.
Start Date
Nov-2008
End Date
NA
Team Size
6
2. Ziest Migration (TD 8.0 to QC 10).
Description
Client: GE Healthcare HCIT
The Ziest team of GE Healthcare in the other parts of geographical regions decided to move to GE Healthcare HCIT Centralized servers. The Ziest Team was using the Older version of Quality Center i.e. Test Director 8.0. In their current environment, they were using SQL Server 2000 as database server with MS Visual SourceSafe. The centralized Quality Center server is having Quality Center 10.0 with Oracle 10g database server. Migrated the Test Director’s Microsoft Version enabled Projects to Quality Center 10.0 inbuilt versioning.
Role
Production Support Engineer
Skills
Test Director 8.0, Quality Center 9.2, Quality Center 10.0,VBScript, OTA API, SQL Server 2000, SQL server 2005
Environment
Source :
Server : Windows 2000 Professional
Database : SQL Server 2000
VSS : MS Visual SourceSafe
Version: Test Director 8.0.
Destination:
Server : Sun Solaris
Database : Oracle 10g
VSS: Quality Center 10.0 inbuilt versioning with oracle database.
Version: Quality Center 10.0.
Contribution
1.Creating Migration Plan and Setting required intermediate Servers.
2.Restoring Databases and projects and upgrading them to target version.
3.Creating Scripts for User Creation, importing common settings.
Start Date
Dec-2009
End Date
Jan-2010
Period
2 months
Team Size
6
3. HP Quality Center 10.00 Upgrade.
Description
The objective of this project was to upgrade HP Quality Center 9.2 to HP Quality Center 10.00. The entire project completed in two phases: Upgrade of HP Quality Center in on two Zones (Clustered Environment)and later Upgrade remaining two zones.
Role
Production Support Analyst
Skills
Oracle 10g, HP Quality Center 9.2 and 10.00. VB Script, OTA API.
Environment
Servers: 4 Sun Solaris Zones Connected using F5 Load Balancer.
Database : Oracle 10g
Contribution
1.Created Technical Installation Plan for QC10.00
2.Installed QC10.00 on clustered environment.
3.Performed installation verification step for QC10.00
4.Created Technical Installation Report for QC10.00
5.Wrote Test Cases for validating QC10.00
6.Executed test cases for validation
7.Migrated QC9.2 Projects into QC10.00 environment.
Start Date
Aug-2009
End Date
Nov-2009
Period
6 Months
Team Size
6
4. eApproval Solution Validation Project.
Description
There are two types of Testing Projects in GE Healthcare (and in other health care companies) - Validated
- Non Validated
What does Validate Project Mean?
Development of a Service or a Product which directly/indirectly affects the health of a patient is categorized in Validated Project. Validated Projects are regulated and monitored by drug regulated authorities hence the process of development and testing for a validated project is different than that of non-validated projects.
Out of the box Quality Center is not fit for handling Validated Projects ( Capturing Signatures ), thus there was a requirement to
- Apply eSig functionality in QC to approve Requirements, Test cases and Test Results within Quality Center itself.
- Validate the eSignature functionality
Role
Production Support Analyst
Skills
VBScript, Quality Center Harmonization
Environment
Server Machine: Sun Solaris
Client Machine: Windows XP service pack 2
Database Server: Oracle 10g
Application Server: JBoss
Application: Mercury Quality Center 10.0
Contribution
1.Harmonizing the Projects with eSingature Template project.
2.Creating Validation documents for changes in the workflow of eSignature.
3.Creating Installation Documents for the Harmonization.
4.Creating Training materials for end users on the Workflow specific roles.
5.Demonstrating eSignature functionality to the Project Owners.
6.Giving Online Training to the users to get comfortable on Complex Workflow.
7.Prepared Test Cases based on new requirement document
8.Prepared various Change control forms and Incident Request forms
Start Date
Jan-2011
End Date
Dec-2011
Period
12 Months
Team Size
6
Personal Information:
Name: Anil Kumar Arandkar
Date of Birth: 07-Jan-1986
Gender: Male
Citizen: Indian
Current Address: #16-2-836/1 & 4, Ashirwaad Luxary Apartments, Flat # 204,
Saidabad Colony, New Malakpet, Hyderabad, Telangana – 500059.
Permanent Address: #16-1-551/1, S.R.R Thota,
Kareemabad, Warangal, Telangana.
Mobile No: 91-703*******
Passport: Yes
Relocate: Yes
Notice Period: 2 Month
Place: Hyderabad Anil Arandkar