Sharath K Mansanpally (Certified with ISTQB) QA Automation Architect/SDET Consultant

ad1ddx@r.postjobfree.com

361-***-****

Professional Summary:

• 18 years of experience in Software Testing the Client/Server, Web and Windows Applications under Windows, UNIX, Linux and Mac environments.

• 13+ years experience in leading QA teams of 8 personnel or more.

• Expertise in developing scalable and robust automation frameworks and maintain/Enhance frameworks.

• Designed and Developed Keyword driven, Hybrid, Dynamic DATA Driven, TDD, Environment driven and POM frameworks in tools like QTP/UFT, Selenium, Cucumber, Appium, UFT Mobile/UFT One – Mobile Add-in

• Instrumental in setting up CI/CD pipeline using tools like Cruise Control, Jenkins and integrating sanity test suite with the build deployment process.

• Proficient in developing test scripts using VB Scripting/java/javascript.

• Expertise in developing QTP scripts for testing using descriptive programming and parsing/reading data from XML files and verification.•

• Developed custom tools using VB and Java to support test data setup for automation.

• Extensive experience with Excel VBA and excel macros for various testing needs.

• Extensive knowledge in TDD, BDD, ATDD, Agile – Scrum and Kanban

• Extensive experience in automation using Cucumber/Gherkin and Selenium.

• Expertise in testing Web-Services using C#.Net, SOAPUI/ReadyAPI and HP Service test.

Setup Test Center Of Excellence, Defined testing process and Designed testing models using HP Quality Center now MicroFocus ALM

• Expertise in ALM administration, customization for new projects, upgrade and migration of projects.

• Proficiency in Application Lifecycle Management Synchronizer administration and integration with Rational Clear Quest.

• Extensive hands on experience in using relational databases like SQL and Oracle.

• Ability to write complex SQL queries and procedures in PL SQL for Backend and ETL testing.

• Expertise in Test Data Management and Oracle PL SQL development for test data setup.

• Ability to efficiently use the Quality Ceter API for integration with QTP for test automation execution and also bulk data manipulation.

• Expertise in ETL testing and Cognos reports/ Data warehouse verification/validation.

• Expert in writing, reviewing and execution of Test plans and Test Cases.

• Effort Estimation during all cycles of release like Feature, Unit, System, Integration, Regression and Performance Testing.

• Expertise in Defect tracking and reporting using Pivotal, Quality Center & Clear Quest.

• Acted as an SQA coordinator/Internal Auditor for the projects and have good knowledge on test processes and metrics being used.

• Ability to excel in a highly agile environment and work on multiple projects/tasks at the same time.

Education:

B.Tech in Computer Science and Engineering.

Certifications and Awards:

ISTQB (International Software Testing Qualifications Board) Certified professional

Received individual and team awards as Top Performer twice (recognized by Acresso)

Received CSI 4/4 continuously after taking over as a Point Of Contact.

Recognized, appreciated and regarded as go-to man by all project teams including and not limited to Development, DBA, Business, ETL/DW, Unix/Middleware,Configuration management teams

Technical Skills:

Operating Systems : All Windows OS, Linux, AIX, HPUX, Mac and Solaris

Database : MS SQL, Oracle 9i/10g, DB2, Informatica

App Server : IIS, Tomcat, Websphere, Weblogic

Automation Tools : VAPI-XP using QC 9/11,ALM 11, QTP 9.2/11, UFT 11.5,12.51,

Load Runner, SOAP UI, STAT, Selenium RC, WebDriver JUnit

Test Management Tools : Quality Center/ALM, Rational Test Manager

Bug Tracking Tools : Pivotal, Quality Center, Rational ClearQuest

Version Control : MS VSS, Perforce, ClearCase

Others : Akimbi, VMWare, VNC, Xplanner, Ethereal, Sharepoint, Shell

scripting, Outlook, Lotus Notes, MS Office, IBM WMB, MQ

Professional Experience:

QA Automation Architect/Lead @ SrivenSystems Inc

Client: Financial Information Services Agency, City of New York, NY June'11 - Tilldate

Office of Payroll Administration, City Of New York, NY June'09 – May’11

CityTime is an automated pay rule management and time-keeping system. CityTime has automated all the complex Citywide Payrules and also various other payrules of different agencies of City Of New York.CityTime allows for the accurate recording of time and leave events – resulting in less pay errors – and will eliminate the need to collect time and leave data manually. The application is being used by 44 agencies of City Of NewYork including NYPD, FDNY, DOT etc. The major high-level functions of CityTime are - Records, tracks, and reconciles all employee Time, attendance, Overtime, and Leave data. Provides a review and approval process for collected Time. Submits approved Time and Leave data to PMS for payroll processing. Receives personnel data changes, which impact time keeping, electronically from PMS.

Responsibilities:

Responsible for the test automation effort involved in testing of web based time and attendance application using Keyword Driven Framework and descriptive programming with HP UFT, Selenium.

Developed a new automation framework called Data Mining to enable the automated scripts to select data dynamically from back end using complex SQL queries and procedures.

Instrumental in Planning, Design and completion of CI/CD pipelines using Cruise Control, Ant, and Selenium.

Worked on conversion the sanity test suite into JUNIT/SELENIUM test cases and integrated into CI/CD pipeline.

Developed a special automated test script to validate rollout of new release in PROD.

Developing keywords, actions,functions and objects for new screens and features.

Creating automation work books using the keywords developed.

Updating and maintaining the automation framework.

Lead the test data management effort for the entire project.

Identifying the data requirements, prepare and maintain data in shared location.

Develop and maintain custom tools using Java, VBA and excel macros to automate the test data setup.

Writing and executing complex SQL queries and procedures against Oracle database to validate data.

Responsible for testing the C#.Net application that connects to the biometric devices used to capture time in and time out of all the employees across city of New York.

Responsible for complete ETL testing and Cognos reports testing.

Identify the scope for each build and prepare the automation test plans.

Analyze the automation results, update QC with status.

Administer the Quality Center and customize as per the project needs.

Experience in creating scripts using QualityCenter API for bulk data manipulation.

Integrate Quality Center with rational Clear quest using QualityCenter Synchronizer.

Prepared test plan and successfully migrated QualityCenter from 9.2 to 11.0.

Coordinate with cross functional teams (java/sql/wmb developers, Mainframe team,DBAs etc) in resolving issues.

Logging defects and retesting them when fixed.

Prepare test plans for any infrastructure upgrade like IdentityManagement, QTP, QC, Cognos, Database. etc.

Environment: Java, J2EE, Windows, Linux, Oracle 10g/11i, QTP, UFT 15, UFT Mobile, UFT one – Mobile Add-in, Selenuim, HP Quality Center 9.2, ALM 11.0, VBScript, Selenium, VMWare, WebSphere, Excel, Word, Rational ClearQuest, Clear Case, Cognos

Lead QA Analyst @ Mutex Systems Inc Sep’08 – Jun'09

Enterprise Document Repository is the application developed for the ITS, CPG, Controllers, Corporate Secretary Departments to store, manage and retrieve the invoices and other confidential documents. Customized Webtop is used to view, manage, search and retrieve the documents. Web publisher has been used to templatize and maintain the local intranet and external websites for DTE.

OP5 Automation: The project is to develop customized workflows for automating the Contract review Process and eliminate the manual process. Enhancements are done to the existing workflow by adding legal and risk management sections. A custom workflow was developed for customer services department for tracking and resolving issues.

Responsibilities:

Lead a team of 5 QA personnel involved in the testing activities for the Documentum applications.

Worked closely with the developers to resolve the issues.

Analyze the business cases and gathered the business and functional requirements.

Design of High level test cases and detailed test cases as per the requirements

Written Test Cases, Traceability Matrix and Test Plans.

Involved in automated functional testing of the applications using QTP.

Manual test case execution, Bug reporting and verification.

Maintained test cases and defects using Mercury Quality Center.

Assisted in designing the business flow using BPM.

Involved in System, Integration, Regression and User Acceptance testing.

Coordinated with the users in performing User Acceptance Testing.

Involved in writing Queries for data mining and determining the data mining requirements.

Worked in a highly Agile environment with monthly releases.

Extensively worked on functional testing and the GUI testing of the publisher website.

Environment: Java/J2EE, Visio, HTML, Quality Center, QTP, WindowsNT/2000, Excel, Word, Documentum 5.2.5sp2 /5.3/sp1, BPM, Webpublisher5.3/5.3 sp1, Tomcat 5.0.28, Weblogic 8.1 sp4, Linux, Aix 5.3.2, Oracle 10g, DFC, DQL, JDK 1.4.x, XML, XSLT, Windows xp, Windows 2000 server, Web Services

Senior QA Analyst /Point of Contact @ Applabs Inc, Hyderabad India Jul’05 – May’08

Client: Revenera/Flexera Software Inc. Formerly Installshield, Schaumburg, IL

Project : Flexnet Connect

FlexNet Connect enables individual ISVs to deliver targeted HTML messages, including news about new product releases and upcoming events, directly to customers' desktops. It is a solution to always keep the ISVs connected to their end users and update them about new releases/patches/hotfixes in the product.

Project : InstallAnywhere

InstallAnywhere gives software developers a quick and easy way to author professional installations for UNIX, Linux, Solaris, HP-UX, Mac OS X, Windows, and more. It saves time and cuts costs of software vendors by creating a single project file that generates reliable setups for each of the platforms you target.

Project: InstallShield Windows

InstallShield Windows is the world leader product in packaging software. A standalone application that allows the users to develop installers in all windows platforms with the facility to use custom actions and adding prerequisites to installers.

As a Point Of Contact:

Coordinating offshore team and making the offshore team work smoothly and getting the quality work from offshore on time.

Communicate with the client on daily deliverables and assigning work to the team.

Involve in conference calls, Daily Standup Meetings with developers (telephonic and video).

Estimation and Scheduling of the Project as part of Agile development methodology.

Prepared a Quality Assessment Report at the end of the release highlighting the vulnerable areas of the product.

Implemented induction plan and conducted KT sessions on the product for the junior team members.

Responsibilities:

Prepared automation framework which is approved by client and successfully implemented

in releasing hotfixes for the product.

Successfully implemented Environment Driven Framework for localization scenarios.

Developed automation scripts using QTP and VBScripting.

Used QTP and QC’s VAPI XP for developing test scripts in order to facilitate Regression

Testing.

Coordinated meetings with the off shore team to review and monitor the regression scripts.

Recording, Storing the QTP script in Quality Center, Scheduling and executing the script

using Quality Center.

Automated the test case execution using VB Scripting via VAPI XP of Quality Center.

Prepared Status report after execution of scripts from the quality center.

Experienced in preparing and reviewing the test plan.

Analyze the business cases and gathered the business and functional requirements.

Design of High level test cases and detailed test cases as per the requirements.

Experience in writing test cases for critical scenarios (complex, change request).

Implemented Agile methodology- SCRUM.

Review of the test cases based on the requirements from Xplanner tool.

Linking of test cases to requirements using Quality Center.

Manual test case execution, Bug reporting and verification.

Review and approval of bugs to be posted.

Involved in upgrade of QualityCenter (from TestDirector) and migration of projects.

Responsible for Quality Center Administration and customization.

Involved in Sanity, Adhoc and exploratory testing.

Automation of test execution using web services using .Net.

Involved in System, Integration, Regression and User Acceptance Testing.

Written sql queries using TOAD and DB Visualizer.

Installation and compatibility testing of the server and client applications on various Windows and Unix OS including Linux and Solaris.

Prepared a Quality Assessment Report at the end of the release highlighting the vulnerable areas of the product.

Documented the release check list and maintained it.

Managed the artifacts for Configuration Management.

Prepared the tracking charts to show the actual vs goal execution rate during the system

testing cycles.

Experienced in VSS and Perforce for version controlling for documents and software.

Effectively coordinated with the development team for resolving defects.

Documented a ‘Root Cause Analysis’ and ‘Lessons Learnt’ document based on the

experience in the project in CMMI format.

Took KT sessions for new members joining the project.

Environment: Java, J2EE, Windows 95/98/NT/XP/2000/2003/Vista/Longhorn, Linux – RHEL4, AIX, HPUX, Mac and Solaris 10,Oracle 9i, Oracle 10g, SQL Server 2000 and SQL Server 2005, QTP 9.2, HP Quality Center 9.2, Mercury Test Director, TOAD, DB Visualizer, VBScript, Xplanner, Akimbi, VMWare, C#.NET, XML, WebSphere, Tomcat, IIS, Excel, Word.

Contact this candidate