SPARSH ARORA

Financial District Hyderabad, India

Phone: 91-789*-***-*** ada1z0@r.postjobfree.com

QA Manager & CA-Lisa Solution Architect

Expert in Automation & Service VirtualizationQA Manager with full system development lifecycle experience, including designing, developing and implementing test plans, test strategy, test cases and test processes fueling swift corrective actions, significant cost savings and fault-free audits.

Qualifications include Ten plus years of software engineering, testing and software virtualization experience.

Excellent Leader experienced in building and managing of onsite and offshore quality teams.

Experienced in end-to-end management of QA & Development tasks for different SDLC (Agile, Iterative, Waterfall) for the concurrent enterprise level system development

Capable in developing of test strategy & test plan based on customer requirements, project constrains and risk analysis and delivering high quality products.

Hands on in Functional Test Automation using CA-LISA, QTP, Tests preparation knowledge within the Keyword driven Framework and data driven framework.

Holds a very good exposure and knowledge towards CA-LISA Product Suite on basic testing and Virtualization concepts, successfully developed and implemented the automation & virtualization of web services and other middle tier on various applications.

Hands-on developing new and improving existing Automation Frameworks using CA-LISA.

Handled various RFPs and did project estimations for new proposals.

SKILLS SUMMARY

SQA Testing & Methodologies

Test Plans, Cases & Processes Functional Requirements

Scripting & Documentation

Virtualization & SOA Testing

Regression & Negative Testing

UI & Compatibility Testing

Data Interface & Migration Testing

Performance/Load/Stress Testing

Testing Automation

Defect/Bug Tracking

Test Strategies & Coverage

QA & QC Standards

TECHNICAL SKILLS:

Architectures

Object Oriented (OOAD), Web, Three Tier, N-tier, Agile, Client/Server (Rich Client), Web Services, SOAP Microsoft.NET Framework, COM, Design Patterns, WCF, WWF, WPF, LINQ

Languages

C, C++, C#, VB.NET, VB Script, Java Script, XML, UML, jQuery, Cobol and PL1.

Operating Systems

Unix, Linux & Microsoft Windows (Windows 10, Windows 8, Windows 7, Windows Vista, and Windows XP).

Databases

SQL Server 7.0/2000,2005, MS-Access

GUI

Visual Studio 2005, 2008,2010 and 2015, ASP.NET, AJAX, C#.Net, Crystal Reports, Web Parts, Web Services

Framework

ASP.Net 1.0, 2.0, 3.5 and 4.0

Servers & Version Control

IIS, SharePoint Portal, MOSS 2010/2007. Visual Source Safe 6.0, Team Foundation Server and PVCS

Business Modeling/Designing

Microsoft Visio, IBM Rational Rose

Quality Control, Tools & Utilities

FXCOP, SQL Comparison Tool, SQL Profiler and Analyzer, Code Analyzer, HP QTP, HP-QC, Selenium, CA LISA (DEV TEST) CA RALLY, SOAP UI.

Domain Knowledge

Banking,Insurance, Telecom and Retail

PROFESSIONAL EXPERIENCE

Capgemini India Pvt Ltd, Hyderabad

CA-Lisa Consultant & QA Manager August-2018 to Till Date

Project: Euroclear CSD

Client: Euroclear ODC India, Hyderabad

Description:

Euroclear CSD provides the CSD and banking services across the Europe and worldwide.

Euroclear is a Belgium-based financial services company that specializes in the settlement of securities transactions as well as the safekeeping and asset servicing of these securities.

As a global provider of Financial Market Infrastructure (FMI) services, Euroclear is making a global platform making it easier for settling domestic and cross-border securities transactions and safekeep the investments.

The global solution will be delivered using agile methodology and enhance our market performance and customer centricity.

Role: Senior Consultant & Virtualization Expert

Responsibilities:

Involved in Requirement Analysis, Creating Technical Solution Design and Service Requirement Specifications, High Level and Detailed Design of Euroclear CSD application.

Creating Technical Solution Design, Service Requirement Specifications, High Level and Detailed Design of CSD and banking application and solution

Involved in writing and maintaining program code to meet system requirements, system designs and technical specifications in accordance with quality accredited standards.

Involved in writing the automation scripts and virtual services for the test scenarios of CSD, Easy-way and SSE application.

Involved in designing and building the interface specifications and automation of the modules.

Involved in creating the Virtual service of the 3rd party banking application involved in the development and creation of the automation suite to run the regression cycles.

Strong in system study, conceptual design, detail design, requirement gathering, prototyping, analysis, data modelling, database design, development, implementation, testing, documentation, test plans and test strategy, preparing deployment packages, deploying and maintenance

Involved in identifying technology limitations and deficiencies in existing systems and associated processes, procedures and methods and based on this creating the Virtual services using the CA DEV TEST tool and providing the parallel testing and development to the various project teams.

Deployment and support of client applications to different environments like system integration testing, system testing and production.

Involved in writing, updating and maintaining technical program, end user documentation and operational procedures

Configuration Management and version control activities using Microsoft TFS (Team Foundation Server), Tortoise SVN, GIT HUB and CA Agile central Rally tool.

Involved in development and Testing of integration applications, debugging, diagnosing and correcting errors and faults in an applications programming language within established testing protocols like HTTP/S. IBM MQ, REST and SOAP.

Involved in virtualizing and automation of the Mainframes applications using the Cobol and PL/1 languages for the script creation of virtual services and using the Copybook Protocols and CICS.

Writing SQL statements, Stored Procedures, Functions and Installation of SQL Server 2000/2005 databases.

Tools / Technology: CA-LISA, CA Agile Central, FXCOP, SQL Comparison Tool, SQL Profiler and Analyzer, Code Analyzer

Languages: Java Script, XML, UML, jQuery, Cobol and PL1.

Databases: SQL Server 7.0/2000,2005, MS-Access

Telstra Corporation India Pvt. Ltd, Hyderabad

Senior Technology Specialist Nov-2017 to Aug-2018

Client Engagement - Telstra Corporation

Involved in Requirement Analysis, Creating Technical Solution Design and Service Requirement Specifications, High Level and Detailed Design of OM-Fulfilment application and Solution.

Involved in writing and maintaining program code to meet system requirements, system designs and technical specifications in accordance with quality accredited standards.

Involved in writing the automation scripts and virtual services for the test scenarios of OM-FUL application.

Responsible for understanding the Business requirements and plan for application Integration

Involved in defining approach/Process/preparation of Test cases/scripts, test plan and test strategy.

Involved in QA Effort Estimations

Deployment and support of client applications to different environments like system integration testing, system testing and production.

Involved in writing, updating and maintaining technical program, end user documentation and operational procedures.

Involved in development and Testing of integration applications using Asp.Net 2.0/1.1 (VB & Java Scripting), C#, VB.Net, HTML/DHTML, XML/XSLT and features such as Ajax.

Writing SQL statements, Stored Procedures, Functions and Installation of SQL Server 2000/2005 databases.

Virtualization and automation of Order management fulfillment and provisioning of telecom services

Tools / Technology: CA-LISA, CA Agile Central, FXCOP, SQL Comparison Tool, SQL Profiler and Analyzer, Code Analyzer

Languages: Java Script, XML, UML, jQuery.

Databases: SQL Server 7.0/2000,2005, MS-Access

Hitachi Consulting India Pvt. Ltd, Hyderabad

Senior Consultant & DevTest Expert July-2015 to Nov-2017

Client Engagement - Toyota, USA - TFS Core Receivables EIP Project

Responsible for understanding the Business requirements and plan for application Integration.

Involved in Requirement Analysis, Creating Technical solution Design and Service Requirement Specifications, High Level and Detailed Design of client application and solution all TIBCO interfaces

Involved in defining approach/Process/preparation of Test cases/scripts

Involved in QA Effort Estimations.

Testing, debugging, diagnosing and correcting errors and faults in an applications programming language within established testing protocols, guidelines and quality standards to ensure programs and applications perform to specification

Involved in Interface (Web service)/Tibco Testing

Involved in automation & virtualization of EIP (TIBCO) services using CA-LISA tool

Involved in creation of Virtual services for Request Response pairs for MQ message type & Web Services Virtualization.

Writing SQL statements, Stored Procedures, Functions and Installation of SQL Server 2000/2005 databases.

Tools / Technology: Siebel UCM 8.0, Siebel 7.8, Trillium12, Windows 7, Oracle 11g, UNIX, CA-LISA, Rational Team Center, and HP-QC.

Languages: VB.NET, VB Script, Java Script, XML, UML, jQuery.

Databases: SQL Server 7.0/2000,2005, MS-Access

Capgemini India Pvt Ltd, Pune

CA-Lisa Consultant August-2013 to July-2015

Project: Global Testing-GSP Feb/2014 – July/2015

Client: HSBC GLT India, Pune

Description:

GSP stands for Global Service Platform used for banking transactions between 57 countries such as Internet banking; Debit card, Credit card transactions.

The Global Services Platform (GSP) aims to converge existing varied RBWM Internet and mobile banking capabilities onto a common platform. This will drive global cost savings by removing inefficiencies across local RBWM Internet and mobile offerings. The global solution will be delivered using agile methodology and enhance our market performance and customer centricity.

Role: CA-Lisa Consultant& Virtualization Expert

Objective:

Understand developer scenarios through Business Requirements, Copybooks, and Request Response pairs for different services.

Creating Technical solution Design, Service Requirement Specifications, High Level and Detailed Design of client application and solution.

Involved in designing and building the interface specifications

Understand MQ message type transactions. Create Virtual services and deploy to VSE, Virtual services responses same like live server with dummy data .It helps Developer in Unit testing and Testers in Regression testing whenever live environment is not available.

Create VSI, VSM & MAR file through RR pairs and Copybooks for single transaction. Deploy VSM file to Virtual service environment so that Developer can hit the service and test his code for Unit testing.

Prepare test data for different variations for different services, fetch data into LISA, create different variations in VSI file for different scenarios and deploy.

Provide Developer and Testers Virtual environment for testing their code and test cases in case of live application is down.

Provide testing team LISA environment for functional testing and regression testing

Functional testing of application by automating test cases using LISA for different releases.

Reduces time, cost, manual testing effort, and dependency on live environment of the project.

Responsibilities:

Managed Testing and Development teams for creating Virtual services

Communication with Client and Developers, understand there requirements in term as of which business layer LISA comes into picture and implement.

Created Virtual services for Request Response pairs for MQ message type.

Prepared workflow diagrams and release note for different releases

Developed proof-of-concept prototypes to evaluate application architecture.

Quality Checked the created VSI and VSM’s against the assigned test cases for the team.

Accessing the VMs and HUBs system to create the services and deploying them on VSEs

Providing the VSIs & VSMs to the testing teams so that parallel testing and development can happen smoothly.

Involved in development, maintaining program code and Testing of integration applications using Asp.Net 2.0/1.1 (VB & Java Scripting), C#, VB.Net, HTML/DHTML, XML/XSLT and features such as Ajax

Lead automation & Virtualization QA teams.

Chair scrum/defect review meetings with project team stakeholders to discuss issue found during testing and their current statuses.

Reviewed the daily and weekly status reports

Tools / Technology: Windows 7, XML, JAVA, IBM-MQ, CA-LISA, Rational Team Center, Selenium, HP-QC.

Languages: C, C++, C#, VB.NET, VB Script, Java Script, XML, UML, jQuery.

Databases: SQL Server 7.0/2000,2005

Project: Mobile 1.5 Aug/2013 – Feb/2014

Client: HSBC GLT India, Pune

Description:

Mobile 1.5 is the mobile application version of the HSBC’s banking across the world which deals with the various transactions related to internet banking so that the complete banking can be done on the smart devices using the mobile 1.5 application.

The same works on the different OS like android, iOS available in the market of latest smartphones and phablets.

Mobile 1.5 provides the complete banking solutions on the smartphones and tablet devices. The complete end to end banking is now mobile and provides the complete solutions to their customers by providing end to end internet banking on the mobile devices.

Role: CA-Lisa Consultant& Virtualization Expert

Responsibilities:

Responsible for creating the virtual services for the mobile applications.

Created the virtual services using the Unix Box and command line manager.

Created Virtual services using HTTP/S protocol

Accessing the VMs and HUBs system to create the services and deploying them on VSEs

Providing the VSIs & VSMs to the testing teams so that parallel testing and development can happen smoothly

Lead automation & Virtualization QA teams.

Chair scrum/defect review meetings with project team stakeholders to discuss issue found during testing and their current statuses.

Automating the End-to-End test cases using iTKO-LISA tool through UI & APIs.

Accountable for the quality of test services during all stages of SDLC.

Tools / Technology:

Windows 7, XML,JAVA,MS SQL Server 2008, iTKO-LISA,SEE TEST,Rational Team Center, QC,UNIX Box, Putty.

Mahindra Satyam Ltd, Hyderabad (A.P).

Senior Software Engineer & Automation QA Analyst March-2010 to July-2013

Project: OSS- Austin Sep/2012 – July/2013

Client: CA Technologies Hyderabad

Description:

Austin solution provides fully automated self-service capabilities for service provided to on-board their new tenants.

The solution will drastically reduce the time required to onboard new customers. Austin solution provides pre-integrated and fully automated end to end process flows for on-boarding new Tenants and their customers.

The solution helps services provides on-board customer across multiple domains covering fulfillment and assurance and other platforms as they get added to the solution.

Role: Sr. Software Engineer & Automation Consultant

Responsibilities:

Lead automation QA teams and Development teams

Involved in Requirement Analysis, Creating Technical solution Design and Service Requirement Specifications, High Level and Detailed Design of client application and solution.

Involved in designing and building the interface specifications

QA point of contact for the company leadership and cross-functional teams.

Own test plans and documentation that communicates the standards and procedures of QA teams.

Chair scrum/defect review meetings with project team stakeholders to discuss issue found during testing and their current statuses.

Lead automation activities within the automation framework using CA-iTKO-LISA tool.

Automated the End-to-End test cases using iTKO-LISA tool through UI & APIs.

Implement, gather, and report team and project metrics which demonstrate business value and showing continuous improvement in an agile environment.

Accountable for the quality of test services during all stages of SDLC.

Manage setup and maintenance of test environments.

Support customers in troubleshooting exercises.

Tools / Technology:

Windows 7, C++, C#, ASP.NET, JavaScript, XML, HTML, MS SQL Server 2008, iTKO-LISA, SOAP UI, Rational Team Center.

Project: Apple IS&T Finance Virtualization May/2012 – Sep/2012

Client: Apple Inc. USA

Description:

Apple is an American multinational corporation that designs and sells consumer electronics, computer software, and personal computers.

Unix Box (UIB) application provides a thick client application to access the inbox of the various applications configured. The user can have a single interface for capturing user actions (like approve/reject/cancel/withdraw) in various participating applications.

The primary goal of this project was to virtualize systems so as to achieve parallel development and early testing.

Role: Sr. Test Analyst & Virtualization Expert

Responsibilities:

Lead automation teams.

Involved in Requirement Analysis, Creating Technical solution Design and Service Requirement Specifications, High Level and Detailed Design of client application and solution.

Creating Technical solution Design, Service Requirement Specifications, High Level and Detailed Design of client application and solution.

Involved in designing and building the interface specifications

Understand the client system architecture and scope of Service Virtualization.

Suggested the possibilities of Service Virtualization in the architecture.

Created virtual service models & images for various systems using WSDLs & through UI.

Automated the End-to-End test cases using iTKO-LISA tool through UI & APIs.

Demonstrated the flow of data between the actual and virtual services.

Manage setup and configuration of Virtualization test environments.

Tools / Technology:

Windows 7, Java/J2EE, EJB, Web Services, XML, iTKO-LISA, Web Logic 8.1

Project: TNZ Inc. Jan/2012 – April/2012

Client: Telecom New Zealand, New Zealand

Description:

TNZ has a standard practice to test each system in isolation and then go in for a SIT towards the end of the project. This often means limited test coverage in ST and Vendor Testing and poor quality entering SIT.

Virtualization of two major end-to-end test scenarios was undertaken to instantiate the concept of virtualization and to remove the isolated stubbed environment.

Role: CA-Lisa Test Analyst & Virtualization Expert

Responsibilities:

Understand the client system architecture and scope of Service Virtualization.

Design and developed Test cases, which were more, inclined towards the functional integration and Virtualization.

Created virtual service models & images for various systems using WSDLs & through UI.

Created & worked on virtual images using HTTP/S and MQ Protocols.

Bundled up the SIs created to act as one single end to end test case flow and work in lieu of the original system.

Tools / Technology:

Siebel 8.1, Web Services, SOA Testing, iTKO-LISA

Project: VTaaS – Virtualization Testing as a Service on Cloud Nov/2011 – Dec/2011

Clients: Mahindra Satyam & Tech Mahindra

Description:

Under the CA Mahindra research center banner, we jointly started a product offering called VTaaS – Virtualization Testing as a Service. This will comprise of several things around test automation eventually. But the current focus is to bring Service virtualization on the SaaS model

Role: CA-Lisa Test Analyst & Virtualization Expert

Responsibilities:

Setup the Cloud Lab for Lisa Server & Workstation for Creating the Virtual Service images & models and deployed those on cloud server for further testing.

Watched over the entire process of lab setup and ensured the running and deployment of application as well as tools on cloud

Tools / Technology:

CA-Lisa Server, Workstation, VSEs & Cloud Lab

Project: Optus Inc. - Virtualization of Front-end Apps, Servers & Adapters July/2011 – Oct/2011

Clients: Optus – Australia

Description:

At Optus, the standard practice is to build and System Test (ST) each application in isolation, and integration test (SIT) towards the end of the project. This often means limited test coverage in ST and Vendor Testing and poor quality entering SIT. While the impact is limited for projects with simple integration scope, it tends to generate fundamental integration defects during SIT for large integration projects.

System is built on web-based interfaces, using technology like Java, EJB, Corba and Oracle. Main aim was to virtualize the server and backend layers. Optus aims to do a holistic testing at the mid layer and integration layer to verify the application, middle layer and database layer works as expected.

Role: CA-Lisa Test Analyst & Virtualization Expert

Responsibilities:

Understand the client system architecture and scope of Service Virtualization.

Involved in Requirement Analysis, Creating Technical solution Design and Service Requirement Specifications, High Level and Detailed Design of client application and solution.

Creating Technical solution Design, Service Requirement Specifications, High Level and Detailed Design of client application and solution.

Involved in designing and building the interface specifications

Developed proof-of-concept prototypes to evaluate application architecture.

Design and developed Test cases, which were more, inclined towards the functional integration and Virtualization.

Created virtual service models & images for various systems using WSDLs & through UI.

Created & worked on virtual images using HTTP/S, JAVA & JDBC Protocols.

Coordinated with various stake holders (i.e. development team, support team, network team) for catering the testing requirements, and produce detail reports.

Tools / Technology:

Web Services, SOA Testing, iTKO-LISA

Project: DowJones Mar/2011 – June/2011

Clients: DowJones

Description:

Satyam’s engagement with DowJones will be to deliver services to company as part of System Integration Testing, System Testing, Regression Testing and Acceptance testing of the full suite from service layer and later e2e from presentation to backend systems via service layer.

Role: Automation Test Analyst

Responsibilities:

Worked as a MTM Admin where allocated projects, created user groups & generated reports.

Design, developed & executed Test cases, which were more, inclined towards the functional integration and automation using Microsoft Test Manager

Created Data Driven framework using Microsoft Coded-UI (automation tool).

Performed End to end automation testing of entire application.

Tools / Technology:

MS-SQL, HP-QTP, Microsoft Test Manager & VSTS Ultimate-2010

Project: SWISSCOM Mobile CRM Testing Oct/2010 – Mar/2011

Clients: SWISSCOM (SCHWEIZ) AG

Description:

Satyam’s engagement with Swisscom is to deliver services to Swisscom as part of System Integration Testing, System Testing and Acceptance testing of the full suite from service layer and later e2e from presentation to backend systems via service layer. Swisscom Mobile CRM Testing was done for a project representing a convergent CRM program of Swisscom Mobile and Swisscom Fix net to brought their CRM to one common platform which was Siebel.

Role: Test Analyst

Responsibilities:

Design, developed & executed Test cases, which were more, inclined towards the functional integration and automation using QTP

Created Data Driven framework using HP-QTP

Performed End to end testing of entire application which includes the testing of Siebel CRM, Billing and Rating processes.

Tools / Technology:

HP-QTP, SIEBEL Business works 5.5, Designer5.4 EMS 4.3, Quality Center, and Oracle 9i

Project: Small World Automation May/2010 – Sep/2010

Client: GE

Description:

The POC involved automation testing of Small-world Applications.

Role: Software Engineer

Responsibilities:

Design, developed & executed Test cases & created test scripts for the functional integration and automation using QTP

Created Data Driven framework using HP-QTP

Created and registered the Dll’s for calling the Small-world interface methods in QTP.

Tools / Technology:

HP-QTP, VB Scripting and MYSQL

Nokia Siemens Networks, Noida

CORE Engineer-Tools & Development Team April/2009 – Mar/2010

Project: SMS CORE

Client: Bharti Airtel

Period: April/2009 – Mar/2010

Description:

Operation and Maintenance of BSS-AM created for 8 circles of BHARTI AIRTEL services all over the country

Role: Team Lead

Responsibilities:

Analyzing, developing, interpreting and evaluating complex network design and architecture specifications, data models and diagrams in the development, configuration and integration of Network systems for major telecom giant.

Researching, analyzing, evaluating and monitoring network infrastructure to ensure networks are configured to operate at optimal performance.

Worked on Operation and Maintenance of BSS-AM created for 8 circles of BHARTI AIRTEL services all over the country as a Team-Lead.

Configured the automated tools like Auto-SMS, clear-code and health-check for BSS & NSS Team.

Testing, Troubleshooting & debugging the faults in the GSM network along with diagnosing the different units at BSS & NSS levels.

Installed, configured, tested, maintained new and upgraded networks, software database applications, servers and workstations for various circles across the country.

Provided network programming in support of specific business needs and requirements.

Prepared procedures for network inventory, and recording diagnosis and resolution of network faults, enhancements and modifications to networks, and maintenance instructions

Resolved network traffic issues, and activity, capacity and usage to ensure continued integrity and optimal network performance.

Tools / Technology:

Citrix, VS2005, MS Word 2007, Excel 2007, Power Point, Oracle 9i, MySQL, C, VB Script.

EDUCATION & CREDENTIALS

University of Rajasthan — Jaipur, Rajasthan.

B.E. (Electronics & Communications) 2004-2008

ISTQB Certified

Sparkle quarterly awards for consecutive quarters for automation and virtualization of 500+ TIBCO interfaces.

Star Performer of the year for 2 consecutive years in Mahindra Satyam.

Presented paper on “Smartcards” at a National level Competition (SPANDAN-2005) held at Engineering College, Ajmer (RAJ).

Presented paper on “Artificial Photosynthesis” at a National level Competition held at Engineering College, Sikar

Contact this candidate