Quality Assurance Information Technology

Raja Dhanekula 630-***-**** Certified Sr. BA/QA LEAD ****.***@*****.***

PROFESSIONAL SUMMARY:

Almost 12 years of diversified experience in Information Technology both Business Analysis and Quality Assurance which includes Manual and Automated testing including Functional, Unit, integration and Regression testing for complex software projects in distributed Client/Server, Web-based and also Cloud based applications. Specific testing experience includes writing test plans, test cases, test scenarios, analyzing test results and finding performance bottlenecks using different tools. Certified in ISTQB with 90 percentile.

●Proficient in all phases of Software Development Life Cycle (SDLC) Requirements, Analysis/Design, Development, and Testing including test strategy preparation, test plan development, test case creation, test execution and bug tracking

●Capability to apply wide technical and practical skills to manage and execute functional, GUI, integration, performance, UAT, and Mobile Testing.

●Experience in different types of testing Build verification, Functional, Regression and System testing

●Experience in Test Strategy, Test Plans, Creating Test Scenarios, Test Cases, Test Data Set Up, Test execution, Defect Management, Test Reporting and Test Closure activities

●Extensive Experience and good hold over creating and managing comprehensive test plans and test cases using ALM Octane, HP Application Lifecycle Management, Microsoft Test Manager, qTest

●Conducting front-end and back-end testing of applications in both UAT and Prod

●Experience in both unattended and attended automation like NICE and RPA

●Extensive knowledge on ACSR(CSG), ICOMS and CRM billers

●Experience in Salesforce and its tools like Sales Cloud and Service Cloud

●Experience in using large complex SQL queries to verify the data in both UAT and Prod environments

●Experience in banking systems and payments like ACH, eChecks, EFT and Wire Transfers

●Experience in Web Services API testing using SOAP UI and Postman in UAT and Prod

●Testing Apps in IOS and Android and Blackberry devices

●Experience in using Fiddler to debug and monitor the api calls

●Experience in using AppDynamics to monitor the web api calls and Solarwinds for monitoring the performance

●Experience in using Locust for performing the Load testing for the application

●Experience in using Kibana to query the logs

●Expertise in validating the Business Objects and Power BI reports

●Experience in Testing and validation of ETL Data loads

●Document, implement, monitor, and enforce all processes and procedures for testing established as per standards defined by the organization in UAT and Prod

●Escalate the issues in the application to the Client and entered defects in HP ALM, MTM and Jira

●Experience in leading and managing teams as a Lead and also handled multiple roles –Automation Developer and Software Tester

●Experience in working on Business Process Testing (BPT), Data Driven and Hybrid Automation framework in QTP.

●Execution of automation test scripts by using HP Quick Test Professional tool, Selenium and manual test cases by using management tool ALM Octane and HP Quality center ALM in UAT and Prod

●Strong leader with unsurpassed interpersonal skills and experience managing small and large projects.

●Excellent research and mentoring skills. Ability and enthusiasm to learn new tools and technologies along with presentation and self-organizing skills.

●Lead and Interact with multiple Offshore teams independently on daily basis at different levels of system testing life cycle for several applications

TECHNICAL SKILLS:

Languages

C, C++, Java, Apex, ASP.NET, C#, HTML, SQL, KQL

Business Intelligence Tool

Business Objects, SQL Server Integration/Analysis/Reporting Services, Crystal Reports, Power BI

Databases

Oracle, SQL Server, MS Access, SAP HANA, Mango DB

Operating Systems

MS Windows, iOS, Android

Testing Tools

ALM OCTANE, HP Application Life Cycle Management, Quick Test Professional(Automation), Selenium(Automation), Test Director, Rational Test Manager, Test Partner, Microsoft Test Manager, Zephyr, qTest, TFS

Billers

ACSR(CSG), ICOMS, CRM

CRM

Salesforce

Web services and Debugging Tools

SoapUI, Postman, Fiddler

Monitoring Tools

AppDynamics, SolarWinds

Load Testing Tool

Locust, JMeter

Defect Tracking Tools

ALM OCTANE, HP Application Life Cycle Management, TFS, Test Director, Bugzilla, Jira

Design Tools

Microsoft Visio, Microsoft Teams

Collaboration Tools

MS Office, Confluence, Chalk

CERTIFICATIONS:

ISTQB Certified Tester Certification# 00254558 and scored 90 percentile

Salesforce.com Certified Force.com Developer Certification# 1901833

EDUCATION:

Masters in Computer Science, University of Illinois at Springfield, Illinois USA.

Bachelors in Computer Science, Nagarjuna University, INDIA.

PROFESSIONAL EXPERIENCE:

Charter Communications, Saint Louis, MO Jun 2019 – Till Date

Role: Sr. BA/QA Lead

Charter Communications, Inc., is an American telecommunications and mass media company with services branded as Spectrum. With over 26 million customers in 41 states, it is the second-largest cable operator in the United States by subscribers, just behind Comcast, and third-largest pay TV operator behind Comcast and AT&T. Charter is the fifth-largest telephone provider based on number of residential lines. Currently working as a Sr. QA Lead, maintaining the test suites and leading the overall testing efforts for NICE and CCM applications and also helping other applications like Creditcalculator, RPA and TMS.

Roles & Responsibilities

●Gathering and analyzing the Business Requirements with the business analysts.

●Analyze the Stories created in Jira and discuss the requirements with the business owners

●Attend the Design sessions with Architect and the dev team to derive the development plan

●Participate in Story Grooming Sessions and Estimate the Story Points for all the stories added to the sprint

●Attend the Planning meeting to derive the capacity of the team and allocate the resources accordingly

●Created ALM folder structures across multiple applications like NICE, CCM, Credit Calc, TMS and RPA

●Assist the team in creating the test scenarios and the test cases for all the business stories in UAT and Prod

●Manage the test plans, test scenarios and test cases in ALM OCTANE for all the stories added in each and every sprint for both NICE and CCM applications in UAT and Prod

●Maintain and update the Master Regression suite after every Release for both NICE and CCM applications

●Perform Master Regression suite review with Business twice a year and make the necessary changes to the suite

●Review the test cases created by the team and make the necessary changes to the test cases and also advice the team on the changes that are done in UAT and Prod

●Evaluate the observations found by the team and advice the correct solution depending upon the requirement

●Schedule a meeting with the business owners and review the test cases for all the requirements added to the sprint in UAT

●Create the test suites for functional, regression and also for the smoke testing

●Assist the team in the test data analysis for all the test scenarios in UAT and Prod

●Create and assist the business analysts for their data reporting.

●Create the test data and provide it to the team depending on the business requirement

●Query the vantage tables using large complex SQL queries and provide the data to the team for both UAT and Prod environments

●Gather the data also by quering the External API logs in UAT and Prod

●Query the kibana logs using the KQL queries to filter the elastic search data

●Provide the test data to other teams like TMS, UCC, Credit Calc, RPA

●Test the front-end GUI for the billers ACSR(CSG), ICOMS and CRM using NICE in UAT and Prod

●Executed test scripts using selenium for the TMS application.

●Support, test and provide sign off to the activities happening across the organization

●Assist the team in solving the critical biller errors encountered while testing the billers

●Test the billers ACSR(CSG), ICOMS and CRM across different companies like CHTR, TWC and BHN in UAT and Prod

●Validate various NICE callouts like informational, questionnaires and the hardstop callouts

●Test the monitor values and also the webservice responses displayed in the NICE monitor

●Tested AOS application and also validated the payment functionality for customers which also includes past dues in UAT and Prod

●Test and provide sign off to all the changes for both NICE and CCM

●Validate the reports by querying the NICE database using SQL Server

●Create the defects and also triage them with the dev team

●Troubleshoot the loading issues for the NICE toolbar

●Attend the meetings with NICE support team if there are any issues with the NICE toolbar

●Support the maintenance activities for the NICE toolbar and CCM

●Test the Web Services API using SOAP UI and Postman in UAT and Prod

●Test and support the end-to-end testing for CCM application for different portals like Collector, Dispatcher and Supervisor in UAT and Prod

●Test and validate the Payments and the processing through ACH, eChecks, EFT and Wire Transfers on different portals

●Test and support the testing for CCM APK on Android device for all the portals in UAT and Prod

●Test and validate the payments and it’s processing on the APK.

●Experience in using Fiddler to debug and monitor the api calls in UAT and Prod

●Create and send the Testing Status Reports and get the approval from the PMO for the code deployment to the production

●Schedule the demo meetings with business and demonstrate the newly launched features and also provide the relevant screenshots pertaining to those features

●Attend the meetings with Live agents to troubleshoot the issue they encountered for NICE and CCM

●Test specific Use cases requested by business and provide the screenshots to them from UAT

●Create and manage the smoke test suites for different adhoc test requests by various teams in UAT

●Train and share the biller knowledge across multiple teams in the organization

●Attend the Retrospective meetings and provide the updates related to the past release

●Attend the meetings bi-weekly to provide the updates to the higher management related to the application

●Lead and Interact with multiple Offshore teams independently on daily basis at different levels of system testing life cycle for several applications

●Executed the API automation suite for both Regression and smoke in UAT

●Used Locust for performing the Load testing for NICE application in UAT

●Attend the meetings with offshore teams to help and answer the questions and also solve the roadblocks/observations encountered by the teams

●Assisted the Prod operations team always by sharing the feature knowledge when needed on any of the releases

●Attended the RCA meetings and explained the details of the feature that caused the issue to the fellow team members and participated in making some recommendations

●Received appreciation from all the teams Dev, PMO and Business. The same appreciations were added to the spark portal

Centene Corporation, Saint Louis, MO Mar 2018 – May 2019

Role: Sr. BA/QA Lead

Centene Corporation is a large publicly-traded company and a multi-line managed care enterprise that serves as a major intermediary for both government-sponsored and privately insured health care programs. Worked on Testing and leading the efforts for the Client Server applications, Cloud and .Net/Java legacy applications, Various Insurance portals and also provided timely updates between Business users and many QA teams.

Roles & Responsibilities

●Analyzed Functional and Business requirement documents, Design documents, Data model, Use cases, project timeline and prepared Test Plans for all assigned project releases

●Create the business requirement documents as per the business owner request and discuss the same with the teams

●Involved in testing the new functionalities Test cases and coordinated with development team in fixing the issues in UAT and Prod

●Managed and participated in creating of Manual Test Cases and automated Test Cases for various types of Testing, as per the application demand and assisted in Preparation of test cases in HP ALM, QTP, MS MTM/TFS, qTest.

●Testing client server, .Net/Java web applications and utilizing Software Test Methodology in UAT and Prod

●Conducting front-end and back-end testing of applications utilizing complex SQL and Mongo queries.

●Creating test files with test data member information that are needed to be processed and approved.

●Validating the upgraded databases using SQL/Mongo queries

●Customized and tested several Validation Rules, tasks, Workflow rules, Triggers, Apex classes and validated according to the business functionality.

●Validated objects like Accounts, Contacts, Leads, Opportunities, Campaigns, Cases and Customer interactions both in Sales Cloud and Service Cloud.

●Validated the profiles on user’s access related to Objects Permissions, Field Permissions and other settings.

●Running baseline tests, validating the applications using the legacy code vs. legacy DB.

●Validating the applications against upgraded database - New code vs. New DB.

●Validating the applications against Client's test environment - New code vs. Legacy DB.

●Creating and updating JIRA user stories accordingly.

●Attending daily standup, Team meetings, Designer review meetings, product support, Sprint Closeout, Retrospective meetings and all meetings happening during product release.

●Performing Regression tests, Smoke, Integration and UAT Testing

●Executed the automation suite for both Regression and smoke using Selenium

●Extensively involved in Defect detection, Defect reporting and defect tracking.

●Schedule Defect Triage meetings with the team

●Participating in Requirement kickoff and Exit reviews.

●Train and schedule KT sessions for the new team members.

●Used AppDynamics to monitor the web api calls and Solarwinds for monitoring the performance.

●Used Powershell scripting to automate couple of the batch jobs.

●Lead the Offshore team’s daily activities, helped them as needed and monitored the status of the tasks assigned.

Nestle Purina, Saint Louis, MO May 2015 – Feb 2018

Role: Sr. BA/QA Engineer

Nestlé Purina Petcare is a St. Louis, Missouri-based subsidiary of Nestlé. It produces and markets pet food, treats and litter. It is the second-largest pet food company globally and the largest in the United States. Worked on leading the Testing efforts for the Client Server applications, Cloud, Reporting applications, Power BI applications, ETL Data Loads also the legacy applications.

Roles & Responsibilities

●Analyzed Functional and Business requirement documents, Design documents, Data model, Use cases project timeline and prepared Test Plans for all assigned project releases

●Discuss the business requirement with the teams and collaborate with the product owners to get the requirements.

●Involved in testing the new functionalities on Test cases and coordinated with development team in fixing the issues in UAT and Prod

●Managed and participated in creating of Manual Test Cases for various types of Testing, as per the application demand and assisted in Preparation of test cases in HP ALM/MS MTM/TFS in UAT and Prod

●Validated crucial data of Business Objects reports, for Nestle Vice President and received award for outstanding performance.

●Validated the Contacts, Leads, Campaigns across various channels using Sales and Service Cloud.

●Played vital role in updating the statuses of multiple projects to the project managers by Creating Dashboard using VSTS.

●Used Extensive SQl for back end data validation

●Played a key role in Report testing with SAP HANA backend.

●Validated Crucial and Complicated Formula Specs for Pet Foods and its Packaging, thoroughly tested company’s customized .NET applications and also used handheld devices for barcode validations.

●Participated in Database migration of company’s Crucial Applications data from native databases to SAP HANA.

●Validated and tested various Universe and Database changes using BW queries

●Thoroughly tested Migration of OS from Win 7 to Win 11, for its impacts pertaining to all the Crucial applications of Nestle Purina

●Played a vital role in testing the E-Commerce websites for Nestle Purina business and also tested these websites in various IOS and Android devices

●Conducted Browser Compatibility Testing in various browsers like Internet Explorer, Mozilla Firefox and Safari.

●Validated and tested the ETL data loads

●Testing and verifying XML, IDOCS and PSV/CSV files.

●Coordinated the efforts between QA teams, Business stakeholders and Project teams.

●Played a crucial role in timely deployment of the projects by resolving the issues due to insufficient requirements and volatile testing environments.

●Created Efficient logistics for the accurate testing efforts.

●Prepared Foolproof documents for the testing process like Test estimates, Test activities, Test closure reports and Test tracking documents.

●Maintained balanced environment by resolving the issues between the resources during the testing phases.

●Planned the resources efficiently as per the project requirements by using company standard methods and documents.

●Coached the Team Members on formal testing principles and practices.

●Involved in Testing and coordinating with Offshore teams for testing.

●Participated and managed the communications between the project managers and the testing team regarding Testing status, Bug status through emails and TFS task updates.

●Generated Visual Metrics regarding the Test Progress and its Status, Bug Status on a regular basis.

●Extended my efforts not only in coordination but also in participation of Interface Testing between Legacy Applications and SAP systems for monthly data dumps into production environment, which plays a key role in the company’s progress.

●Trained and guided new resources as needed.

●Trained and lead the Offshore team accordingly.

Sann IT Solutions, Herndon, VA Nov 2013 – Apr 2015

Role: Salesforce Developer/Tester

SIS Inc has a strong reputation as a business and information technology consulting company. We assist enterprises, organizations and government agencies maximize their corporate information in their database using best in breed, best in class Business Intelligence software solutions. Worked on developing and testing the new Apex classes and visual force pages for different applications.

Roles & Responsibilities

●Worked on various objects like Accounts, Contacts, Leads, Opportunities, Campaigns and Cases.

●Created and tested Custom Objects and defined lookup and master-detail relationships on the objects. Also created junction objects to establish connectivity among objects.

●Created and tested workflow rules and defined related tasks, time-triggered tasks, email alerts and field updates to implement business logic.

●Customized several Validation Rules, tasks, Workflow rules, Triggers, Apex classes to achieve the complex business functionality.

●Managed different cases on the console using Sales and Service Cloud.

●Responsible for the creation of custom Apps, and Reports using the Salesforce CRM cloud computing model.

●Created and tested page layouts, search layouts to organize fields, custom buttons, custom links, related lists, and other components on a record detail and edit pages.

●Managed users, Public Groups, Profiles, and Roles within the Salesforce CRM designating access to the applicable user within the user hierarchy.

●Designed, developed, tested and deployed Apex Classes, Controller Classes, Extensions and Apex Triggers for various functional needs in the application using the Eclipse IDE.

●Developed and tested Visual Force Pages, Visual Force Custom Controllers Components, Advanced Search Functionality, Custom Objects, Analytic Snapshots, Tabs, Tags and Components.

●Developed SOQL & SOSL with consideration to Governor Limits for data manipulation needs of the application using platform database objects.

●Implemented WSDL in the application for access to data from external systems and web sites using Force.com web services API.

●Load/Manage the data using Apex Data Loader.

●Performed Data Migration from legacy system to Force.com with knowledge of Data Mapping.

Roanoke Trade, Schaumburg, IL Apr 2013 – Oct 2013

Role: Junior Application Developer

Roanoke was the first company in the United States to serve the needs of customs brokers and their clients. The company’s missions has always been – and continues to be – to set the industry standard in delivering quality insurance, surety and risk management services to those businesses involved in importing, exporting or transporting goods. Worked on developing and testing the web application for creating the bonds and carnets.

Roles & Responsibilities

●Developed Web Application using Asp.Net 4.5, C# and CSS.

●Used MVC4 design pattern to develop web application.

●Created ASP.NET User Controls to reduce the complexity of user interface design.

●Designed and developed ‘Web Services’ to synchronize data from remote application database to online database using C#.Net, ASP.Net, Visual Studio .Net.

●Worked on Entity Framework to communicate with the databases by creating entities to View, Insert, Update and Delete data in the databases.

●Used ASP.Net and C# for the front-end presentation and Server Side Processing.

●Developed Oracle Server Connections using Entity Framework entities and Queries.

Contact this candidate