RAJAT KHANNA
Lawrenceville, New Jersey https://www.linkedin.com/in/rajkhanna1/ ************@*****.*** c: 609-***-****
Summary
Technically astute, highly motivated, solutions-driven Professional with over 12 years of experience and versatility in handling roles such as Quality Assurance Engineer and Scrum Master. Strong hands-on experience with Front End, Database, SSIS, SSRS, AWS, API Testing. Excellent Analytical, Interpersonal and Communication skills with the ability to remain focused and self-assured in fast paced, high-pressure environments.
Education
University of Wisconsin – Milwaukee, Wisconsin BS - Electrical Engineering May 2008
Certifications
Certified Scrum Master License 000356786 Sept 2014
Technical Skills
Languages: Visual Basic, C++, SQL
Operating Systems: Microsoft Windows Mac OSX and UNIX
Virtualization Platforms: VMware (ESX/ESXi), Citrix Xen Server, Vagrant
CRM: Salesforce, CPQ, SAP, Oracle Sales Cloud
Bug Tracking Tools: JIRA, Quality Center
Technology ETL, SSIS, SSRS, AWS
Testing Tools: Quality Center/ALM, QuickTest Pro, MS Excel, Postman, Soap UI, REST client, SQL Server Management Studio, SQl Server Profiler, Azure Data Studio
Automation Tools Selenium (Web Driver), POSTMAN
Agile Tools: JIRA Agile, Pivotal Tracker
Other Tools BMC Remedy, Rational Clear Quest, EasyIP, NetBrain, Splunk, AppDynamics
Domain Knowledge Electric & Natural Gas, Telecommunications, Healthcare, Education
Professional Experience
Customized Energy Solutions – Philadelphia, PA July 2018 – Present
CES provides Retail and Wholesale services to Energy Companies offering Electric and Natural Gas services
Sr. Quality Assurance Engineer – FTE
Designed and Executed Test Cases for Web based application for Front-End and Back-End Testing.
Performed Functional, Black Box/Gray box, End to End Testing for Web-based application and Web Services
Performed API Testing for the Web based application’s API check points using POSTMAN
Automated the API Tests for Functional and Regression Testing
Performed ETL testing including data conditioning, identification of the source data, understanding of the business logic and data validation between source and target tables
Performed AWS, SSIS and SSRS testing
Collaborated with the Business Analyst on defining the requirements for User stories and identifying Test scenarios for QA and UAT Testing
Collaborated with the Development Team members on day to day basis for data conditioning, reviewing Test Results and providing feedback on the identified bugs.
As a Lead of the QA Team; Provided QA Best Practices, Application and DB training to junior members of the QA team
Provided regular guidance and feedback to QA Team members on identifying Test scenarios, reviewing and providing feedback on their test results on Sprint to Sprint basis
Worked simultaneously on projects using both Agile and Waterfall methodology
Created and Executed Test Plans for projects using Waterfall methodology
Worked closely with the Product Owner, Project Manager and Scrum Master to provide QA perspective during various phases of the SDLC
Provided guidance to the UAT Team on Test Data conditioning, Test scenario setup, during the UAT phase
Siemens Healthineers, Malvern – PA June 2017 – July 2018
A leader in medical technology, Siemens Healthineers is constantly innovating its portfolio of products and services in its core areas of diagnostic and therapeutic imaging and in laboratory diagnostics and molecular medicine.
Sr. Quality Assurance Engineer – Consultant
Project: SHAREVILLE
This project involves replacing the legacy system used by SIEMENS worldwide with the Implementation, Customization and Integration of Oracle Sales Cloud, CPQ and SAP.
Design Test Scripts for Functional, Integration, Data Driven and Regression Testing of Oracle Sales Cloud (OSC) and Configure, Price, Quote (CPQ)
Perform Functional, Integration, Data Driven and Regression Testing of OSC and CPQ and proactively work with Development on Defect Triage
Leading the testing effort for the company’s newly designed Pricing Engine.
Work closely with the Development Team in Europe on defining business requirements and various other phases of the SDLC
Worked with the Business SME’s on Test Plan approvals
Work with the Management on Testing timelines and Progress updates
Created & Manage Traceability matrix in QC and JIRA
Paternity Leave February 2017 – May 2017
Educational Testing Service, Ewing- NJ September 2016 – January 2017
As the world’s largest nonprofit educational measurement organization, ETS develops, administers and scores more than 50 million tests annually in over 180 countries, at more than 9,000 locations worldwide.
Scrum Master – Consultant
Led 2 Scrum Team of Onshore and Offshore Developers, BSA and BA’s for development work supporting GRE program
Worked closely with BSA’s and Developers on the RCA for the reported issues
Used Agile framework to investigate and remediate application defects
Helped Document procedures, fixes and workarounds
Helped set up an internal Knowledge Base (Wiki) for the team
Tracked team capacity and velocity metrics for planning purposes
Served as a liaison between the Team and Management
Tracked and Reported productivity and work load of the team on day to day bases
Used JIRA Agile to manage User Stories, Product Backlog, Sprint Backlog and Burn Down Chart
Worked with Product Manager to keep the product backlog groomed
NRG Energy, Philadelphia – PA June 2015 – September 2016
NRG is the leading integrated power company in the U.S., built on the strength of the nation’s largest and most diverse competitive electric generation portfolio and leading retail electricity platform.
Quality Assurance Lead - Consultant
Led the Philadelphia office QA team during the platform migration to SAP
Worked closely with the Development team on various phases of the SDLC, on day to day bases
Validated Production defects and Tested the bug fixes on day to day bases
Developed Test cases for Functional, Performance and Data driven testing
Spearheaded the testing effort for the companies new Pricing Engine app
Worked with Project Managers on Testing timelines and Progress updates
Provided Product Demo’s to the Business
Created & managed Traceability matrix in QC and JIRA by linking all requirements & test cases
Performed Functional and Regression Tests in Integration & System Test environments for Web-based applications and Web Services
Created & managed automation scripts using Selenium with Python for the regression testing
Liaison between the Business and Development
PJM Interconnections, Norristown – PA December 2012 – March 2015
PJM is a Regional Transmission Organization (RTO) that coordinates movement of wholesale electricity, providing power to 60 million people in all or parts of 13 states and the District of Columbia. PJM is working to enhance their suite of applications used internally & by external associates for compatibility with current browsers and has established a technology standard to make all the tools easier to use.
Scrum Master/ Sr. Quality Assurance - Consultant December 2013 – March 2015
Scrum Master for the ITS Infrastructure Support Department and Patch Management Team
Schedule, plan and facilitate collaboration per the Agile framework; Daily Stand-up meetings, Sprint Reviews and Planning meetings between the Team, Product Owner, and Stakeholders
Wrote User Stories and Acceptance Criteria in consultation with the Product Owner and the Scrum Teams
Used JIRA Agile to manage User Stories, Product Backlog, Sprint Backlog and Burn Down Chart
Work regularly with the Product Owner to keep the product backlog groomed
Ensure the team delivers on their objectives within accepted quality standards by facilitating a working definition of ‘done’ for agile stories within each team
Data management for the project
Used Remedy, an asset management tool to track the cyber assets.
Help keep the Team focused on the current Sprint and achieve the Sprint Goals
Facilitated meetings between key stakeholders across the organization in identifying risks and resolving issues
Track team capacity and velocity metrics for planning purposes
Serve as a liaison between the Team, Product Owner and Stakeholders
Support Team building by utilizing the abilities and skills of individuals and promoting a Feedback culture
Created Bi-Weekly Project Status Reports for Senior Management
Empowered the Scrum Team to adopt best practices with respect to quality, holding each other accountable for delivering a quality product and ensuring that quality is a joint responsibility.
Sr. Quality Assurance - Consultant December 2012 – December 2013
Documented Patch Management procedures on security patch deployments to Windows, Linux, AIX, Oracle, SQL and 3rd Party Applications for over 2000 cyber assets across PJM’s Technology Environments
Used Remedy, an asset management tool to track the cyber assets.
Worked with business analysts, business users, SMEs and product owners to define the requirements and create user stories as needed.
Worked with the team and the management to implement new procedures.
Maintain Patch Management’s database with the configuration of Servers, OS Versions, Applications, Current patch levels and scheduling/patching requirements to provide an accurate inventory of PJM’s cyber assets for patch deployments
Actively performed the duties of the team Scrum Master
Participated in preparation of Root Cause Analysis (RCA) documents
Created & managed manual Test Cases and Defects in HP Quality Center (QC 10)
Reviewed QTP scripts and worked closely with automation engineer for automated test scripts.
Created & managed traceability matrix in QC by linking all requirements & test cases
Comcast, Philadelphia – PA August 2011 – December 2012
Comcast is the country’s largest provider of cable services and one of the world’s leading communications companies focused on broadband cable, commerce and content.
Project: Workbench Evolution
This project involves replacing the legacy system used by the Business Services with the Implementation, Customization and Integration of multiple CRM’s like Salesforce, IBM-CPQ and Century.
Sr.QA / Business Analyst - Consultant
Identified client requirements, defined business solution and scope of the project
Conducted Joint Application Development (JAD) sessions, project meetings, reviews, walkthroughs and customer interviews
Acted as a liaison between the Business and the Development teams
Facilitated meetings between the Business and Test Team to get Test Plan Approvals
Identified test environment needs and coordinated with the Development team to create Test Environment that mirrored Production
Conducted application Demo’s for Business Leads, Testing teams, Methods and Procedures team and other Business stake holders
Carried out Manual Functional and Regression Tests in Integration & System Test environments for Web-based applications and Web Services
Developed Test cases for Functional, Performance and Data driven testing
Led a team of 3 onshore testers of the Business Acceptance Team (BAT)
Updated Sprint Tasks in JIRA
Participated in User Story Estimation, Daily Scrum Meetings, Sprint Planning, Mid-Sprint Planning, Sprint Reviews and Sprint Retrospectives
Filled in as a ScrumMaster and BA on an as-needed basis
Coordinated with the offshore System Integration Testing ( SIT) team during each release
Trained the Business Readiness Team (BRT) on new functionality for user demos
PHD Virtual Technologies Inc, Morris Plains – NJ October 2008 – May 2011
PHD Virtual is one of the leading software companies that provide Backup and Disaster Recovery solutions to Virtualized Environments for VMware and Citrix Xen Server platforms
QA Test Engineer
Tested several versions of the product to successful GA release
Prepared and set-up the environment for testing
Created test cases for different application modules
Reporting and Managing Defects using JIRA
Provided assistance and guidance to team members
Conducted Functional and Regression testing on the applications
Tested product on different Operating Systems and Platforms
Tested product with different revisions of VMware-ESX/ESXi servers and Citrix-Xen Sever
Recommending process improvements and best practices related to QA, Scrum and Software Development
Student Technology Services, University of Wisconsin – Milwaukee, WI October 2005 – December 2007
IT Help Desk - Consultant
Tested the universities online applications prior to launch
Created test cases for different application modules
Worked with a team of three testers for completing the testing phase of the project
Familiarized faculty members and students with the web based applications
Troubleshot computer problems (hardware and software related)
Provided computer related assistance to students and faculty members
United States Army – Reserves 2004 –2010
Veteran
Practice the values of Loyalty, Discipline, Dedication and Hard work to be successful in life
Highly adept in time management and organizational skills
Very comfortable and experienced in working in a team environment
Trained to lead in extremely stressful situations
Residency Status - US Citizen