PRADEEP KOTHAMACHU
Cell: 480-***-****
Email: **********@*****.***
EXPERIENCE SUMMARY
** ***** ** ******** ********** in Software Quality Assurance
Very highly proficient in Set up, debug & maintenance aspects of Merchant tools, Administration & Storefront of Demandware
Good Working knowledge with MS Visual Studio (TFS) & experience with VSTT to Automate 1000+ manual Tests
Experience in leading Off-shore QA teams, introducing QA Processes and developing QA templates in start-ups and hiring QA Personnel
Set-up and Administration knowledge of Bug Tracking Tools like Mantis, Jira
Experience in using Rational ClearQuest and Rational ClearCase
Working Knowledge of Load Testing tools such as Apache JMeter
Good experience in using SOAPUI for Testing Web Services
Good working knowledge of Agile/SCRUM concepts
EDUCATION
Master of Science, Computer Science, Arizona State University, Tempe, AZ
Bachelor of Engineering, Computer Science and Engineering, Siddaganga Institute of Technology, Tumkur, India
COMPUTER SKILLS
Bug Tracking Tools: Jira, Rational ClearQuest, HP ALM Languages: SQL, PostgreSQL
Web Development: JavaScript, JQuery, HTML, DHTML, XML
Design Patterns: MVC, Front controller, Session facade, Data access object
Databases: MS Access, Oracle 9i, Postgres
Logger: Splunk, DynaTrace
Operating Systems: Windows 95/98/2000/XP/7/10, UNIX, LINUX
Other: VMware, Demandware, ServiceNow
CERTIFICATIONS / ONLINE COURSES
Completion of Instructor led – Demandware Developer course
Completed Course work: Apache JMeter, Junit 5, Selenium
WORK EXPERIENCE
PetSmart Inc, Phoenix, AZ (Aug’14 – Present)
Quality Assurance Analyst
Major Contributions:
Identify gaps in the BRDs, Test Cases provided by external vendors
Resolution of Service Now tickets that are reported by Customers, Store associates, internal users as part of Operation/On-Call Support role
Performed Functional testing ISPU (StoreNet) / AOS before being launched into 1300+ Stores across US / Canada
Validated various Feed Data such as Item, Price, Store, Navigation etc that is coming from SAP is in the right formats & is successfully ingested into Demandware platform
Resolved CIQs by debugging issues in ECP Manager when SKUs, Prices, Promotions go offline
Written Test Cases, Test Scripts & performed functionality of PetSmart.com across various hardware & software environments
Verified changes that are part of monthly planner are implemented in petsmart.com both in Desktop & Mobile versions of the Site
Performed functional testing of PetSmart.com across various hardware & software environments for both US & CA versions
Tested functionality of web service using SoapUI
Demandware Application Analyst
Major Contributions:
Maintenance of PIG, SIG instances based on the scheduled / unscheduled updates from Demandware through Control Center.
Monitoring the successful completion of daily scheduled jobs related to Product, Store, Inventory, Price, Navigation Catalogs etc.
Performing On-Call Support duties resolving issues related Payments, Checkout, Order flows to Order Management System, Subscription Orders etc.
Monitoring Site24x7, Splunk alerts and resolve issues accordingly
Resolving & researching Customer issues using logs in Splunk, Dynatrace, LogCenter
Checking & maintaining the integrity of the JavaScript files in Release branch vs latest deployed Code Version.
Validating the Set-up & Functioning of Coupons, Promotions, Campaigns etc.
Update & maintenance of Certificates and Security Protocols.
Resolve issues related to deployment & usage of new Content Slots, Assets, ismls, templates etc.
Working with 3rd party vendors for upkeep & maintenance of site such as: payeezy, JanRain, InstartLogic
Maintenance of Payment instruments for Audit purposes.
Resolution of Service Now tickets that are reported by Customers, Store associates, internal users as part of Operation/On-Call Support role
Create & Resolve Incidents based on the Feedback provided by Customers through Medellia.
Created Google Tags for various events on different pages of the Site
Update & Create Store information such as Store Hours, Service Hours through Azure
Environment/Vendors: Demandware, Jira, Confluence, Zephyr, eBay V11, StoreNet, UsableNet, HP ALM 11.52, ServiceNow, ECP Manager, CIQ, ExactTarget, Bazaarvoice, OMS, Splunk, JanRain, Payeezy, Medellia, InstartLogic, Site24x7, ResponSys, Google Tag Manager, Azure, SoapUI 5.2.1
Project: V 11
The eBay supported Platform for PetSmart.com. The platform supported InStore Pick Ups, Ship-To-Home orders, Associate Orders etc. The Mobile version of website is developed to support all Tablet & Mobile device transactions.
Environment/Vendors: eBay V11, StoreNet, UsableNet, HP ALM 11.52
Accomplishments:
Performed Functional testing ISPU (StoreNet) / AOS before being launched into 1300+ Stores across US / Canada
Written Test Cases, Test Scripts & performed functionality of PetSmart.com across various hardware & software environments
Performed thorough Regression of the Site during Database migrations
Logged defects in HP ALM & worked with appropriate vendors towards resolution
Project: Operations & Site Maintenance
As a part of the Operations team worked in general maintenance of PetSmart.com as well as resolution of ServiceNow tickets
Environment: ServiceNow, ECP Manager, CIQ eBay V11, StoreNet, UsableNet, HP ALM 11.52, SiteSpect, 24 x 7
Accomplishments:
Resolution of Service Now tickets that are reported by Customers, Store associates, internal users
Verified changes that are part of monthly planner are implemented in petsmart.com both in Desktop & Mobile versions of the Site
Resolved CIQ by debugging issues in ECP Manager when SKUs, Prices go offline before their end of promotions
Maintained StoreNet/AOS applications during iOS upgrades
Project: Digital Platform Replacement [DPRE]
This is Demandware supported Platform for PetSmart.com. The DPRE project involved the successful transition of the website from eBay’s V11 to Demandware based PetSmart.com.
Environment: Demandware, Jira, Confluence, Zephyr
Accomplishments:
Written RTMs & Test Scripts uploaded to Zephyr for execution
Performed functional testing of PetSmart.com across various hardware & software environments for both US & CA versions
Validated various Feed Data such as Item, Price, Store, Navigation etc that is coming from SAP is in the right formats & is successfully ingested into Demandware platform
Logged defects in Jira & worked with appropriate teams such as SAP, ESB, OMS, Business towards resolution
Fathom, Phoenix, AZ (Jun’12 – Jul’14)
QA Lead
Major Contributions:
Creating Test Plans & Test Cases for the entire fathom 1.0 project
Updating Test Execution Matrices & communicating results with Development Manager
Converting Manual Tests into Automated Test Scripts using Record & Play tools
Developing SQL scripts to query billing related data.
Environment: C#, .Net, Jira, SQL Server, Agile Scrum, Share Point, Microsoft VSTT
JP Morgan Chase, Phoenix, AZ (Mar’11 – May’12)
UAT Test Lead
Major Contributions:
Guided Testers across distributed environment to convert their manual scripts into Automation Scripts
Devlope
Developed Test Strategies for multiple projects and worked with Testers in various locations towards the successful execution of Test Cases
Performed Admin activities for HP Quality Center tool providing User Access
Provided multiple training sessions on using HP Quality Center
Provided UAT Project Metric Reports on various projects to the concerned teams and these reports have provided information on the overall UAT Status of the projects
Worked on several projects and provided complete UAT support. Projects such as: Audit Relations Databases, SPO Tool Enhancements – Phase III, IONC Database Rewrite, CRRU Payoff Quote Improvements, OCC Consent, Tango and WMMSC Distribution Report
Department: Home Lending
The Department has several IT initiatives such as: Audit Relation Databases, Ginnie Mae Issuer Number
Environment: HP Quality Center 10
US Airways, Tempe, AZ (Nov’09 – Feb’11)
Quality Management Engineer
Major Contributions:
Developed numerous Regression Suites for many projects with-in USAirways.com
Learned about Regular Expressions and written numerous Regexes that helped in Automating previously not-automatable work items
Developed plug-ins that have proven to be invaluable in Functional Testing
Code Reviewed Peer’s work and provided necessary input
Acted as a Development Quality Assurance Lead during major product releases performing sanity checks using Load Runner & TFS
Project: www.usairways.com
The website has very high user activity 24/7. The site is rich with Flash, Ajax and several User Interactive applications.
Environment: MS Visual Studio 2008/2010, Team Foundation Server 2008/2010, C#.Net 3.5/4.0, Load Runner
Accomplishments:
Worked the QA Automation Lead during multiple product releases
Developed Regression Suites for multiple APPs
Developed extensive working knowledge of authoring robust Webtests using VSTT
Completed a week-long C# .NET training & obtained certificate aimed for fine-tuning Developers
Merchants Information Solutions, Inc. Phoenix, AZ (May’08 – Oct’09)
Sr. Performance Engineer
Major Contributions:
Recommended use of new tools such as Shareware Teamviewer 4 & Freewares Apache JMeter & WebLink Validator
Developed expertise in writing VB scripts using QTP 9.2
Lead Internal Clients in developing Client Expectations Criteria and performed UAT along with Internal Clients
Project: Resident Insight v2.0
This is a Web-based application that is used for accessing credit, criminal and eviction history of potential tenants. The application interacts with credit bureaus for getting credit reports.
Environment: Windows XP, Rational ClearQuest, VB Script, Rational Functional Tester, Rational ClearCase, QuickTest Pro, Quality Center, Vantage DB, IIS, C#.Net, TeamViewer, Load Runner
Accomplishments:
Recommended & used Freeware WebLink Validator
Used Shareware TeamViewer 4 for off-shore meetings
Used Load Runner for Load Testing
Developed generic automation scripts in VB using QTP 9.2
Scripted reference guidance to perform BETA testing & UAT
Monitoring resources through successful completion of BETA Testing & UAT
Logged defects using Rational ClearQuest
Linked all the defects to the requirements
Created Test Cases in Excel
Written Test Matrices in excel & maintained in ClearCase
Project: Identity Advocates v2.0
This is a Windows based application that connects with SQL Server to retrieve data. The application allows Users to add, delete and access data.
Environment: Windows XP, SQL Server 2008, Rational ClearQuest, Rational ClearCase, Rational Functional Tester, QuickTest Pro, Quality Center, Excel
Accomplishments:
Functionality Testing of the application using Rational Functional Tester
Logged defects using Rational ClearQuest
Authored and executed GUI Test Scripts in Excel
Reviewed Design & Requirement documents
Project: Identity Theft Educational Website v2.4
The website had information about ID Theft related issues. Flash was used develop the Quiz portion of the website.
Environment: Windows XP, IE 6.0, Firefox 2.0, WebLink Validator
Accomplishments:
Recommended & used WebLink Validator
Verified Look & Layout of the website
Tested cross-browser functionality using Rational Functional Tester
Checked for broken links, grammatical errors using WebLink Validator
Built Regression Test suites in VB script using Quick Test Pro
Maintained Data Sheets in Mercury Quality Center
Optimized QTP scripts for Regression Testing the application with various data sources and data types
Created Reusable Actions used Global Data Sheets and Local Data Sheets for running those modules
Mapped custom objects to standard objects and inserted GUI, Bitmap and Text checkpoints to compare the current behavior of the application being tested to its behavior in the earlier version using QTP
Parameterized the fixed values in checkpoint statements, created data tables for the parameters and wrote Functions for the parameters to read new data from the table upon each iteration i.e; performed Data-driven Testing.
Maintained Test Finding Documents in Excel
Authored and executed GUI & XML Test Scripts
Performed Keyword driven testing.
TSYS Acquiring Solutions, Tempe, AZ (Jul’07 – Apr’08)
Software Quality Engineer
Project: Vital Express
This is the core application of TSYS Acquiring Solutions. The application is used for setting up new Banks, Merchants & Terminal information. The application has features to support various Hardware/Software and Credit/Debit Types.
Environment: Windows XP, IBM Websphere 6.1, Oracle, SQuirrel, Rational ClearQuest, Rational ClearCase, Rational Functional Tester, QuickTest Pro 9.2, VB Script, Quality Center, Excel
Accomplishments:
Testing XML Web Services via Web Services portal by sending individual jobs
Executing multiple jobs via Batch Server and analyzing the result sets of received through Batch Server
Occasionally acted as a liaison between QA Lead Manager and the off-shore team
Involved in process of the conversion of the product from legacy environment to newer platform
Reviewed Design documents & participated in Enhancement meetings
iCrossing Inc., Scottsdale, AZ
(Sep’05 – Jun’07)
System Test Engineer
Major Contributions:
Conducted Off Shore QA meetings and reported Testing Findings to the top management
Lead 3 different off-shore product QA teams
Involved in developing Templates for QA documents such as: Test Plan, Test Case documents, Test Case Traceability Matrix, Pre-Testing Acceptance Criteria Email, Post-Testing Results Email
Interviewed and hired QA personnel for the QA department.
Laid out Bug flow Process during the entire SDLC
Outlined Bug escalation process with in the QA team
Defined Bug description steps for the QA Team
Involved in purchasing in new hardware (QA Sand box, different platforms) and software (VMware) for the QA department
Responsible for introducing Jira (Bug Tracking Software) to the Team
Project: Interest2Action (I2A)
The application track user activity starting from their ‘search query’ in the search engine all the way to up to final purchase. The application provides more than 20 different reports about user behavior.
Environment: LINUX, Perl, Tomcat, JDK 1.5, Postgres, pgSQL, Mantis, Load Runner
Accomplishments:
Used shell scripting to check the status of the Interaction URLs
Responsible for functional testing of three different versions of the application – I2A R5.1, I2A R 5.2 and I2A 5.2.5
Involved in purchase of sand box used for Testing
Tested applications in Beta, Pre-Production, Production environments during new releases and patches
Involved setting Client Acceptance Testing criteria and verifying the application against the criteria
Conducted weekly meetings with off-shore QA Team and informed executive team about the QA progress
Performing data validation of the report data against its sources such as search engines and other internal products like Bid2Action
Introduced Load Runner to the project for Load Testing purposes
Used Shareware TeamViewer 3 for off-shore meetings
Verifying the application adherence various data integrity checks
Outlined Bug escalation process
Developed email templates such as Pre-Testing Acceptance Criteria Email, Post-Testing Results Email
Project: Bid2Action (B2A)
The application serves as a platform for an User to create keywords & ads, set bidding prices and transmit this data to search engines. All these activities can be done individually or in bulk by using a spreadsheet.
Environment: LINUX, Perl, Tomcat Server, JDK 1.5, Postgres, pgAdmin III, pgSQL, Mantis, VMware, Excel, Load Runner
Accomplishments:
Developed templates for various QA documents such as: Test Plan, Test Case Document and Test Case Traceability Matrix
Responsible for analyzing the need and introducing VMware to the QA process
Involved in purchasing new software and hardware required for the product
Introduced Load Runner to the project for Load Testing purposes
Developed System Test Plans based on Requirement Documents for various versions of the product from B2A R1.3 to B2A R1.7
Tested applications in Beta, Pre-Production, Production environments during new releases and patches
Conducted weekly meetings with off-shore QA Team and informed executive team about the QA progress
Put together a Regression Test Checklist in Excel that could be executed for intermediate releases
Performed data validation between the data in the application against the data in search engines
Performed User Acceptance Testing for B2A R1.7 that was developed off-shore
Used Shareware TeamViewer 4 for off-shore meetings
Defined Bug Description steps and outlined Bug flow process
Used shell scripting to check the status of the daily bids
Project: BrandShadow
The application spiders through the web and collects data from millions of websites and blog sites based on User entered keywords and brand names.
Environment: LINUX, Perl, PHP, Postgres, pgAdmin III, pgSQL, Mantis, Excel
Accomplishments:
Developed System Test Plans & Test Cases for 3 different versions of the application : R1.0, R1.1 & R1.2
Executed Test Cases and tracked progress in Test Execution Matrix
Verified validity of statistical formulae
Project: iCrossing Estimated Monthly Searches (ICEMS)
The application collects estimated monthly searches data from Trellian, a keyword tool. The application was upgraded to Trellian from previously used Y!MS (Yahoo! Monthly Searches). The data collected EMS was used internally in other applications and was also used in company published reports.
Environment: JSP, Servlets, XML, HTML, MS Access, 8 ball plug-in, Excel
Accomplishments:
Maintained Test Findings in Excel
Lead internal clients in performing UAT
Validating the keyword data across Trellian, 8 ball and icems
Project: OASIS
The application is a repository of iCrossing’s internal users, external users, client information, applications and access rights to applications.
Environment: LINUX, Perl, Tomcat Server, JDK 1.5, Oracle 9i, MySQL, Eclipse 3.0, EMMA, JUnit, HTTPUnit, MockStruts, Jupiter plug-in, Quantum DB
Accomplishments:
Lead off-shore QA team during the development phase
Performed User Acceptance Testing
Project: Merchantize
The application serves as a platform for a User to create keywords & ads; set bidding prices and transmits this data to search engines.
Environment: Macintosh, JDK 1.5, MySQL, Jira
Accomplishments:
Responsible for introducing Jira to the QA team
Conducted weekly meetings with off-shore QA Team and informed executive team about the QA progress
Performed functional testing
Logged & tracked bugs in Jira
Written & executed SQL scripts
Project: Audience Engine
The application serves the most effective ads that will suit customer needs based upon his information.
Environment: LINUX, Perl, Oracle 9i, MySQL, JUnit, HTTPUnit, Struts, Hibernate, Spring
Accomplishments:
Analyzed design documents and recommended design suggestions
Created System Test Plan
University of Phoenix, Tempe, AZ
(Apr’05 – Aug’05)
Software Quality Engineer
Project: Apollo Interactive Marketing System (AIMS)
The application serves the most effective ads that will suit customer needs based upon his information. Different mathematical engines are used to sort out the most effective Ads from the least effective ones. The application will eventually help in bringing down the ‘lead cost’ and increasing the ‘lead-to-enrollment’ conversion.
Environment: Windows XP, Tomcat Server, JDK 1.5, Oracle 9i, MySQL, Eclipse 3.0, EMMA, JUnit, HTTPUnit, MockStruts, Jupiter plug-in, Quantum DB
Accomplishments:
Responsible for implementing ‘Measurement Logic Subsystem’
Writing Ant test targets
Implementing EMMA for code coverage of Unit & Integration tests