Home

James Kancherla - QA Analyst

[email protected]

Location: Mountain View, California, USA

Relocation: CA

Visa: H1B

James Kancherla QA Analyst (848) 248-2427 [email protected] Mountain View, CA CA H1B Summary Over 12 years of experience in software quality assurance in domains like automotive, finance, banking, entertainment, and social media. Experience in end-to-end testing of projects: Smoke, Functional, System Integration, Regression, and User Acceptance testing (UAT). Adept at coordinating multiple project releases involving web services testing, database testing, user interface testing, and mobile testing. Effective leadership, teaming, and clear communication skills (coordinate client/customer interactions). Strong management of project plans and changes, including release details, backlogs, and bugs. Specific experience in leading UAT: providing solutions for enhancing UI and UX to the client. Experience working in all phases of the software development life cycle (SDLC). Particular experience in Agile and SCRUM. Experience with Black Box and White Box Testing in manual and automated environments. Good knowledge of RDBMS and SQL concepts. Experience in testing REST and Soap web services. Knowledge of WSDL, WADL, XML, and SOAP envelopes. Experience with automated testing tools such as SoapUI, Selenium, UiAutomator, and Espresso. Experience using Unix/Linux/Ubuntu operating systems Good knowledge of defect life cycle. Experience in defect tracking and reporting using Defect Management Tools (QC and JIRA). Skills Operating Systems Mac OS X, Ubuntu, Linux, Unix, Windows, Android, iOS Languages Java, Python, Golang, HTML, CSS, SQL, JSON, XML, GCL Database MYSQL, Oracle, MS-SQL Server 2005/2008. Network Protocol TCP/IP, HTTP, FTP Testing Tools Selenium, UiAutomator, Espresso, Mobly, Charles Proxy, SOAPUI Bug Tracking Tools ALM/Quality Center, JIRA Experience YouTube/Google, LLC. (via HCL) | Test Engineer Oct 2022 Present | San Jose, CA YouTube operates as one of Google's subsidiaries. It allows users to upload, view, rate, share, and comment on videos and hosts various user-generated and corporate media videos. Available content includes video clips, TV clips, music videos, video blogs, and such. Responsibilities As an on-site coordinator, coordinated project delivery schedule for the offshore team Liaised with stakeholders to ensure all aspects of the release cycle are completed on schedule such as regression, outstanding blockers, and Rapid build failures until rollout. Triaged incoming bugs for YouTube and forwarded to respective teams after stack trace analysis for issue resolution Oversaw integration of cherry picks based on Dogfood reports, bug severity and bug policies within the team and ensure the bug fell into the cherry-picking policy to remove regressions in the release candidate Tracked the release candidate and sent the build to QA for sanity testing verification, bug verification and issue resolution Worked with Engineering oncallers to asses bug severity, app reliability, and find ways to resolve specific bug before the release cut so the release can proceed as per the release schedule Tracked release schedules and staged rollouts on Rapid release tool Managed releases on the Rapid tool and ramped the release binaries to internal Google channels and to production subsequently Coordinated release schedules across various platforms, tracking bugs and features Worked to better the release process through workshops for continuous improvement Worked with various teams to obtain release signoffs in a timely manner Oversaw integration of cherrypicks based on Dogfood reports Provided periodic updates on feature releases across all platforms of YouTube Triaged auto-generated bugs to respective stakeholders across all platforms. Led the effort to optimize Java and Python code to function reliably in non-deterministic test scenarios Automated testing of various features and functions on mobile devices, desktops, and web browsers Employed UiAutomator, Espresso, and Selenium WebDriver to automate on the aforementioned platforms Authored automated tests in Java, Python, TypeScript, etc., in Linux and Mac OS environments Used UiAutomator and Espresso in tandem to leverage their features to solve automation challenges Refactored automated test suites to improve code efficiency and readability Shared weekly reports with stakeholders to identify failures and improvement plans to boost app reliability Configured the TestGrid tool using GCL to collect test results and generate bugs automatically Mentored new members of the team during their ramp-up process Google, LLC. (via HCL) | Test Engineer March 2020 Oct 2022 | Mountain View, CA ChromeOS (App compatibility on Chromebooks): The project entailed test automation, bug triaging, and application testing on Chromebooks to deliver a high-quality experience to end users. The project particularly focused on developing and executing automation scripts in Java, Python, and Golang, using test automation tools/frameworks like UiAutomator, Tast, etc. Tools like Buganizer and Test Tracker were used to create and execute test plans for various Android/Web/PWA (Progressive Web App) applications running on Chromebooks. Lastly, it offered one-pager document creation and sharing with app partners. Provided release signoffs for apps post-verification of compatibility Tested and certified apps as O4C (optimized for Chrome) quarterly Tested ARC++ apps for every release cycle on ARC-P and ARC-R Documented the test findings of each cycle and shared the same with respective app developers. Contributed and maintained tests for various Chromebook apps in the UiAutomator framework. Tested and certified the optimal functioning of PWAs on Ash and Lacros browsers. Filed and triaged bugs during every test cycle and linked them to test results in TestTracker. Worked on performance testing of gaming applications (including Vulkan-based games) on various configurations of Chrome OS and Chromebooks Documented launch times, fps, memory consumption values, and such during performance testing. Google, Inc. (via HCL) | Test Engineer April 2018 March 2020 | Sunnyvale, CA NBU is an initiative by Google to serve potential users in emerging markets by improving their existing product set as well as creating new products. This alligns with Google s mission to organize the world s information and make it universally accessible and useful everywhere. Built a test automation framework from scratch using Google s internal tools, Selenium WebDriver and Ui Automator. Created additional test automation (in Python) using the Mobly open-source mobile automation framework. Automated testing of various features and functions (over 90%) on mobile devices and mobile web browsers. Executed and maintained automated tests as daily jobs and documented the results Supported in creating automated solutions for other teams. YouTube/Google, Inc. (via i28 Tech) | Test Engineer July 2014 Mar 2018 | San Bruno, CA Worked on quality assurance for the Android mobile app of YouTube Provided release signoff for YouTube on Android every cycle Analyzed and consolidated key issues from user and Dogfooder reports for each release Automated testing of various features and functions on mobile devices, desktops, and web browsers Executed manual/automated tests and documented the results Maintained test suites manual and automated Triggered user and Dogfooder reports Wrote test plans and test cases from mocks and design documents Updated automation tests Executed regression tests and document regression test results Performed web proxy testing using Charles proxy Environment Linux, GCL, Java, iOS, Android, Python, Selenium WebDriver, Mobly, UiAutomator, Espresso, Safari, Chrome. Experian Consumer Services | Quality Analyst Aug 2013 March 2014 | Costa Mesa, CA Experian Consumer Services provides credit scores, credit reports, and identity theft protection services to customers through their various public websites and mobile applications. The company is also diversifying its offerings geographically by starting operations in Costa Rica, Brazil, etc. Responsibilities Clarified the requirement and UX design workflows with Product and Business groups Created test cases in TestLink for Billing and Payment Processing jobs workflow integration (for Brazil systems, MeProteja website). Executed various offline batch jobs using Control-M. Validated data in SQL Server database. Created SQL queries to validate Membership and Billing information. Analyzed Stored Procedures to create integration tests. Tested web service calls made to Brazil systems (SOAP, REST) Conducted Functional Testing of GUI at module level (HTML, CSS, JavaScript). Worked on testing the FreeCreditScore mobile and tablet apps (iOS, Android). Conducted cross-browser, cross-platform tests for mobile/web applications for maximum compatibility Participated in tracking SCRUM lifecycle processes in Rally (for sprint tasks) and Serasa TeamTrack (for ticket tracking). Environment Control-M, TeamTrack, TestLink, SoapUI, WSDL, REST, XML, HTML, CSS, JavaScript, MS SQL Server 2008, SQL, iOS, Android, Rally, XCode, SnagIt 7, Safari, Firefox, iExplorer. Nissan North America | Quality Analyst March 2013 July 2013 | Franklin, TN The DCS: Dealer Communication System is the dealer communication software being developed by Nissan North America to support the increasingly interdependent demands of sharing data amongst industry stakeholders including: NNA, Dealers, DSP s, and Third-Party Providers across the U.S. and Canada. The DCS environment is capable of expanding to meet the evolving needs of Nissan and Infiniti divisions. Once fully implemented, the dealers will be able to exchange transactions pertaining to vehicle sales, warranty claims, service parts orders, RDRs, and other such dealer-relevant data. Responsibilities Provided product improvement solutions to the client. Planned and coordinated activities of 4 Quality Analysts. Employed black-box and white-box techniques to test the DCS environment including back-end systems, web services and User Interface. Analyzed test coverage and ensured the timely establishment of the required test data. Validated Service Warranty Claims, Vehicle Inventory, RDR and Parts data in the back-end host system based on the business functionality. Tested Soap and REST-based web services with SoapUI; validated request and response messages. Ran Groovy-based automation test scripts in SoapUI. Tested batch processes in Unix for RDR. Co-led the UAT and UI test effort for the DBS application. Developed UI (User Interface) test cases for GUI testing and regression. Worked on integration of Selenium Web Driver with existing API to test framework. Identified issues and tracked their timely remediation by the vendor's offshore development team. Analyzed the inconsistencies and provided inputs to improve UI elegance. Performed Smoke Testing, System Testing, and Regression Testing. Filed defects, enhancements and generated daily reports in Quality Center. Assured language consistency of the application in English and Spanish. Environment | SOA, HP Quality Center, SoapUI, WSDL, REST, XML, HTML, SQL Server, DB2, Oracle 11g, UNIX, HTML, JavaScript, SQL . American Honda | Sr. Quality Analyst Sept 2012 March 2013 | Torrance, CA Next-Generation Telematics is an ongoing effort by Honda to introduce a telecommunication system in their cars, which lets customer communicate with their vehicle using a mobile device or the web. Honda developed, in partnership, with other tech/service provider companies a system of network to accomplish to and fro vehicle communication with a telematics device installed in the vehicle. Responsibilities Converted business requirements and design documentation into test Scenarios, test cases and test scripts. Used black-box and white-box techniques to test databases, web/mobile applications and web services. Led the team in the absence of the Team Lead for two months. Planned and coordinated day-to-day activities of the team and reported team status to client. Performed end-to-end testing: database validations, web services testing, and mobile app testing. Developed SQL queries for data extraction and ensured data accuracy and integrity in the back-end. Performed FTP processes using Putty and WinScp and ran shell scripts in UNIX. Tested REST API and parsed and validated JSON responses. Executed Groovy-based automation test scripts in SoapUI. Performed Data-Driven Testing in SoapUI to parameterize test scripts with MS Excel. Validated test results in the DB2 and SQL Server database after web service/application tests. Validated customer enrollment data and registration data in the back-end database using SQL queries as part of end-to-end testing. Provided product improvements and enhancements to client and worked on their implementation. Worked on black-box testing on iOS and Android platforms (on AcuraLink Connect and HondaLink EV apps). Used ADB and Eclipse to analyze crash logs in both Andorid and iOS devices. Performed GUI testing on the AcuraLink Connect and HondaLink mobile/web apps. Executed test scripts with Selenium and Java. Performed cross-browser testing and device compatibility testing of the apps. Performed Smoke Testing, System Testing, Joint Integration Testing and Regression Testing. Filed defects and functional failures internal to Honda systems in Quality Center. Used Quality Center to prepare test cases, procedures and Requirements Traceability Matrix. Documented project workflow technicalities, component details, and testing methods employed. Assured accuracy and consistency of user experience in English and French. Environment SOA, HP Quality Center, UNIX, Putty, SoapUI, WSDL, REST, JSON, SQL Server, DB2, QTP, Oracle 11g, DBVisualizer, SQL . JP Morgan Chase | QA Engineer Jan 2011 Aug 2012 | Wilmington, DE Chase Home Lending Originations Platform is a full replacement of the current systems and will be implemented in multiple phases. The present system employs a procedure that requires a minimum of 45 days to move a loan from 'Application Received' status to 'Closed' status and make them eligible for sale to the various federal agencies (Freddie Mac, Fannie Mae, and Ginnie Mae). The new system, once fully implemented, will do the same in 15 days, giving Chase Home Lending a considerable competitive advantage over other entities in the Home Lending/Mortgage Banking sector. Phase 1 was a pilot of the new platform and subsequent phases will include a gradual roll out of both CD and Retail Loan Origination system. Application is modeled using SaaS and SOA methodologies. Responsibilities Created/Developed Test Plans, Test Scenarios, and Test Scripts based on Business Requirements Documents and Functional Specifications Documents. Developed complex SQL queries for data extraction from Oracle and DB2 servers using Toad. Debugged and edited the existing SQL queries and optimized their performance. Verified the implemented ETL code against the corresponding mapping document. Worked with various file formats/layouts, including: XML, fixed-width, and delimited. Generated XMLs using Chase SMART Portal. Tested Data migration via XML parsing to Oracle Server Performed Automated Regression Testing on each build using Chase end-to-end Automation Suite and Excel Macros. Handled work in-take process and schedules and CCs (Change Controls). Tracked and reported the defects in HP Quality Center/ALM Read the WSDL and validated WSDL and SOAP messages. Created Test cases in SoapUI and Automated using Assertions to perform Regression. Used parameterization for SoapUI test cases using XML properties files. Asserted SOAPUI test cases using HTTP, XPATH, SOAP, Schema, and CONTAINS assertions. Verified in the UNIX environment if the text files received had the correct data to be transformed. Performed SFTP jobs in a Unix environment using SSH Coordinated testing with the offshore team. Environment: MS Excel, Oracle 10g/11g, RDBMS, IBM DB2, SQL, VBScript, UNIX, TOAD, XML, Quality Center, SOAPUI, SOA Education M.S. in Engineering Management | California State University at Eastbay, California | 2011 B.S. in Electronics Engineering | Jawaharlal Nehru Technological University at Hyderabad, India | 2007 Languages English (US and UK), Hindi. Keywords: continuous deployment quality analyst user interface user experience rlang information technology hewlett packard trade national microsoft California Colorado Delaware Tennessee