Home

SUNIL KUMAR - QA Lead - 16+ Exp

[email protected]

Location: Houston, Texas, USA

Relocation: YES

Visa: H1B

Sunil Kumar Rasakatla QA Lead Email: [email protected] Phone: +1 913 828 3021 Professional Summary: Currently working as a Lead Quality Analyst for an oil and gas-based client. I have 16+ years of Information Technology Software experience across various domains such as Oil & Gas, Utility, Retail, Health care and various technologies across multiple projects. Extensive background in leadership, project management, business analysis, software development management, resource management, and documentation. Expertise in project planning/prioritization, road map development, creation of work plan, risk analysis, risk mitigation, envisioning solutions, and technical writing. Liaison between Business, Technical, Quality and Vendor groups in coordinating, negotiating and motivating stakeholders, support of project timelines and deliverables throughout the project life cycle. Worked on various phases of SDLC from Risk Assessment, Requirement Analysis, Test Planning, Design, Execution, Test Reporting and Closure. Extensive experience in developing all testing deliverables including Validation Plan, Master Test Plan/Approach, Test Specifications, Test Cases, Test Reports, Validation Reports, Risk Assessment, Exceptions, Observations, and Requirements Traceability Matrix (RTM). Experience in Azure cloud technologies by using azure services like data factory and data bricks. Worked on data orchestration in azure data factory by pulling the data from various sources. Refactored the python scripts in azure data bricks to make sure the data has been placed in the appropriate format in the destination tables as per the client requirements. Worked on Unity Catalog by creating metastore in datalake gen2 and connected the SQL warehouse through access connector for databricks. Infused the principles of ETL process by identifying the various sources and cleansing & standardized the data to load by using full and incremental load with scheduled triggers to the destination. Maintained data pipeline up-time of 99.8% while ingesting streaming and transactional data across 3 different primary data sources using PySpark. Guiding the offshore team with clear understanding of the requirements by conducting regular workshops and team calls and tracking the assigned work to its competition. Experience in developing functional flow charts, organizational charts, business process diagrams with MS-Visio Worked on data orchestration in azure data factory by pulling the data from various sources. Refactored the python scripts in azure data bricks to make sure the data has been placed in the appropriate format in the destination tables as per the client requirements. Experience in configuring the azure services like Azure App Registrations, Azure Key Vaults, Azure Resource Groups, and Azure Active Directory services. Worked on running the ADO pipeline to push the modified python scripts of data bricks to the respective environment. Identified the time-consuming manual processes and replaced with the automation process by increasing the efficiency within the team skills. Scaled up to the current industry standards by aligning with the development and operations team and implementing the DevOps and CI/CD practices. Good experience in automating functional test cases using automation tools Selenium and API test Automation using Rest Assured and SOAP. Use of postman to perform API testing. Involved in utilizing the AWS applications including creating EC2 instances, configuring S3 storage, Enabling SQS and focusing on high availability and fault tolerance features. Experience in explanatory testing the migrated applications from on-premises to AWS cloud. Experience in Agile Scrum methodology was coach for the organization to implement the scrum in projects. Experience with TDD, Behavior Driven Development and Automated Testing Frameworks Evaluated the existing tools and recommended the appropriate test management tool by reducing the spent by 30% on the test management tools. Adopted to a stringent and result oriented test practices by ensuring the defect slippage to the production is less than 0.5% of the organizational standards. Focused more on defect prevention activities by shifting left rather spending on defect detection activities. Increased the process-oriented utilization of the test management tool by 20% across the organization by training the teams and explaining the benefits of appropriate usage of ALM tool. Optimized the license utilization of the tools by reviewing the configuration settings with the best practices from the industry. Snapshot of the areas of expertise by role based: Quality Assurance Lead: 12 years of experience in testing the software applications of various domains like oil & gas, retail, energy & utilities, automobile, and health care and managing both manual and automation teams. Business Analyst: 4 years of experience in analyzing the requirements and creating the user stories for an oil & gas domain. Test Automation: 2 years of experience in testing on SOAP and REST calls using SOAP UI and automating regression suite with Selenium tool. Data Engineer: 3 years of experience in Data Engineering by using tools like Azure Data Factory, Databricks and Python in the project. Test Centre of Excellence Consulting: 3 years of experience in external consulting by driving the quality initiatives at on-site and experience as a scrum master Tool Support Role: Played role as administrator for ALM (Application Life Cycle Management) and Rally Dev (Agile Project Mgmt. Tool). Pre-Sales Activities Role: Conducted TCoE workshops to bring the awareness of industry best practices to the clients, prepared RFPs, proposals and RFI s. Technical Expertise: Languages: Visual Basic Cloud Technologies: AWS, Azure Databases: MySQL, Oracle, Data Factory, Data bricks Documentation Tools: MS Word, MS Excel, MS Project, Version Control Tools: Visual Source Safe 6.0 Test Management Tools: ALM12.2, RallyDev, JIRA, Bugzilla, API Testing Tools: SOAP UI Automation Tools: Selenium Quality Frameworks: TCoE, ISO 9001, CMM, CMMI, TMMI, ISO 27001 Educational Qualification: Master of Computer Applications (M.C.A) from Osmania University completed in 1998 Certifications: Certified AWS solution architect associate Certified AWS cloud practitioner Client profile: Chevron Role: Quality Assurance Lead Duration: Nov 2019 Till date Location: Houston, TX, USA. Description: Chevron is the leading integrated energy company involved in exploring, producing and transporting crude oil & natural gas, refining, marketing & distributing transportation fuels and lubricants. Manufacturing and selling petrochemical products, generating power and producing geothermal energy, investing in profitable renewable energy and energy efficiency solutions and developing future energy sources. Project Description: The purpose of the Logistics and Transport Management System (LTMS) project is to manage the job cards in the application that helps FLEC users to schedule the trucks at right place and at the right time. Activities performed during the engagement: Determining and authoring the most appropriate testing strategy for projects within the constraints and operational requirements of the organization. Created Integration scripts and System test scripts. Created SQL queries to extract the data from the database and to check the data flow through the frontend and backend. Perform Manual, Automation and Functional testing, DB Testing, Regression testing, and Black Box Testing. Preparation of test data by extracting required data from the database through joins and other complex queries. Setting up the environments for azure data factory and data bricks Responsible for data migration from Pi database to application database with the updated data format Migrating the EAM data and formulate the data for the predictive values and help the business in creating automatic job cards in the application. Modify the data orchestration in azure data factory for implementing the enhancements. Re-factor the existing python notebooks for the new enhancements in the application Worked with DevOps team in streamlining the pipeline for multiple environments and making sure all the environments are in sync. Worked on continuous Integration model for all products, includes complex integration of process. Assuring that testing is conducted in accordance with the test strategy defined. Developed detailed test plans, specifications and test procedures as required based on risk and prioritization and ensures they integrate into QA&C work packages and overall project requirements. Validated that all project requirements are sufficiently covered by the test scope and that a requirement traceability matrix has been prepared. This includes both functional and non-functional testing. Client profile: Direct Energy Role: QA Lead Duration: Nov 2014 Oct 2019 Location: Houston, TX, USA. Project Description: Client is a global market leader in retail energy industry sectors by providing services across North America and Canada. Client combines its industry knowledge and expertise to provide cloud-based, mobile and on-premises solutions that allow its customers to successfully engage with them, Direct Energy is a regulated gas and electricity provider in Alberta, operating under the Direct Energy Regulated Services brand. It also offers deregulated service in the province, operating as Direct Energy. Activities performed during the engagement: Determining and authoring the most appropriate testing strategy for projects within the constraints and operational requirements of the organization. Created Integration scripts and System test scripts. Created SQL queries to extract the data from the database and to check the data flow through the frontend and backend. Performed webservices testing using SOAP UI Pro for the SOAP and REST calls. Perform Manual, Automation and Functional testing, DB Testing, Regression testing, and Black Box Testing. Preparation of test data by extracting required data from the database through joins and other complex queries. Worked on continuous Integration model for all products, includes complex integration of process. Assuring that testing is conducted in accordance with the test strategy defined. Developed detailed test plans, specifications and test procedures as required based on risk and prioritization and ensures they integrate into QA&C work packages and overall project requirements. Validated that all project requirements are sufficiently covered by the test scope and that a requirement traceability matrix has been prepared. This includes both functional and non-functional testing. As part of the cloud migration testing validated the below areas o Validated the IAM services for the users migrated from on-premises to cloud. o Validated the appropriate storage has been implemented. o Validating how the data is accessible. Ensuring the response time implications and scalability factors are met after moving to the cloud. Validating the appropriate notifications triggers has been set in cloud watch. Validating the implementation of the application instances to restore automatically during hardware failures. Managed access rights and customized SharePoint for the project requirements. Conducted an assessment on infrastructure needs for QA tools and ensure upgradation of tools to latest versions in elaboration with external vendors (Micro Focus) & internal infrastructure teams. Provided guidance, coaching & training to project teams on effective utilization of QA tools. Developed excel based test summary reports supported with macros by pulling the data from ALM. Guided team in identifying the appropriate tool for the API testing and make sure API testing is being performed with complete coverage. Identified the regression suite and developed the automation scripts in TOSCA. Client profile: A Retail industry in United States of America - Micros Role: QA Lead Duration: Jan 2014 Oct 2014 Location Test Lead: Hyderabad, India (Offshore Support) Project Description: Client is a global market leader in the hospitality and retail industry sectors by providing leading enterprise-wide applications, services and hardware for the hospitality and retail industries. Client combines its industry knowledge and expertise to provide cloud-based, mobile and on-premises solutions that allow its customers to streamline operations and successfully engage them. Activities performed during the engagement: Requirements gathering, Scoping, planning for applications. Creation and execution of Test plan, understanding documents, Test scenarios and Test cases. Creation of regression test beds for the Risk applications. Estimate and provide target milestone dates for all the three streams (Manual/Automation/Performance testing). Extracted test data with complex SQL queries from the database. Performed functional database testing along with the exhaustive explanatory testing. Identify, coordinate and obtain access requirements for Application/Tools/DB instances/Project Repositories. Maintain, Publish Query Log and Ensuring all the queries are addressed and closed. Identify test data requirement, Obtain Test Scenario/ Test Case sign off from the Application Team. Identify Test Readiness - Deployment, Test Schedule, Test Environment etc. Defined Metrics and Measurement Framework. Developed dashboard and provided required trainings on the collection of metrics data to the project teams Evaluated Test Management Tool (JIRA) and provided recommendations for the efficient usage of the tool Implemented Scrum practices for the project and provided trainings on Agile methodologies to the project teams. Defined process for Defect Management and implemented Defect Life Cycle. Client profile: A large automobile industry in United States of America - Toyota Role: Test Process consultant Duration: June 2012 to November 2013 Location: Los Angeles, CA, USA Project Description: Client looking for upgrading the legacy technologies by migrating around 79 applications to Oracle Identify Manger for implementing single sign-on system, client is also looking for the QA strategy and process approach for establishing test methodology for the migration. Activities performed during the engagement: Performed AS-IS assessment to identify the gaps in test processes. o As a part of assessment conducted interviews to the identified personal. o Did reviews for project documentation and process documentation. o Conducted surveys to gather data for analysis. o Did analysis on all identified gaps and provided recommendations for continuous improvements. Provided recommendations for improvements in various test areas. Provided QA strategy for establishing test process for migrating applications from legacy system to the new system. Given Road Map for implementing recommendations. Performed migration testing with given best practices. Validated exhaustive data mapping with respective to front end application and database as part of regression testing. Validated applications single sign-on systems. Client profile: A major health care industry in United States of America Express Script Role: Test Process Consultant Duration: May 2011 June 2012 Location: New Jersey, USA Project Description: Client is the major health care company in United States; they provide pharmacy benefit services for private and public employees, health plans, labor unions, government agencies, and individuals served by Medicare Part D prescription drug plan. Activities performed during the engagement: Performed As-Is assessment for the existing QA process of campaign testing. Presented identified gaps in the test process and recommendations along with the benefits to senior management. Enhanced requirements management process by addressing the gaps and improving the communication among the team. Provided solution for the issues in change management process. Developed metrics dashboard for senior management to view the campaign process execution status. Facilitated for casual analysis and resolution for the identified critical production defects by brainstorming along with the business, development and QA teams. Client profile: A major airline industry in United States of America- United Airlines Role: Test Process Consultant Duration: Nov 2009 May 2011 Location: Hyderabad, India (Offshore support) Project Description: Client is the major airline industry located in Chicago, United States of America, looking to establish Quality Center of Excellence (QCoE). QCoE model has been developed to help achieve testing objectives and solve the challenges faced by the client. This engagement allows identifying and planning to adopt best practices, processes and technologies. The objective is to map vision and objectives for the testing function and identify the gaps during assessment phase to provide short- and long-term recommendations. Activities performed during the engagement: Performed assessment and identified the gaps in testing practices. Compiled customized survey questionnaire based on role and consolidated questionnaire survey response(s). Performed document review to identify gaps in current quality processes. Conducted interviews and consolidated feedback to validate survey responses and identify areas of improvement. Establish & monitor the processes and standards suitable for the project dynamics. Prepared scorecard for each manager based on findings to determine the maturity level, strengths and areas of improvement. Coordinate with the team and get the process artifacts ready for review & approval. Guide the team leads to prepare the Test Metrics in certain interval and present to customer. Generate reports to measure the process compliance and publish to senior management. Provided trainings to the team members in bringing the awareness on the established processes. Performed role as a HP QC 9.2 administrator for the entire account. o Creating users o Creating projects and roles o Generating reports by writing queries o Training the team on HP QC Client profile: A major retail industry in United States of America- Louis Vuitton Team Size: Individual contributor Role: Process Consultant Duration: July 2007 Nov 2009 Location: Bangalore, India (Offshore support) Activities performed during the engagement: Maintaining Iteration Backlog and Product Backlog Participating in the requirement workshop and Iteration Planning Updating the daily status of the defects, and Iteration Burndown charts Conducting Retrospection meetings Conducting DPCA Meetings and participating in the Root Cause Analysis of the Defects Collection of Metrics at the end of each Iteration and preparing Metrics Dashboard for the Iteration Client profile: Information Technology Services (SAIC India) Team Size: Individual contributor Role: Process Consultant Duration: July 2005 June 2007 Location: Bangalore, India (Offshore support) Activities performed during the engagement: Collect Metrics on a Monthly basis. Prepare QPM for the collected metrics. Re-Visiting Risk Log and Issue Logs on an alternative week with the status meetings Conducting Process audits for the program to check the program is sustained with all the process areas of the CMMI Level 5 Conducting Reviews for the Project Documents Encouraging the team members in contribution of the lessons learnt, best practices. Participating in the Root Causes Analysis and preparing Causal Analysis Report and sending it to the organization Repository Assisting the SQA in preparation of the QPM for the program which gives a statistical indication of the program strengths and weakness. Discussions with Program Manager for the issues come up in the audits and QPM and escalate the issue to senior management along with the corrective actions to be taken. Client profile: Apex Covantage Team Size: 12 Role: Process Quality Group Leader Duration: Nov 1999 June 2005 Location: Hyderabad, India (Offshore support) Activities performed during the engagement: Defining the processes for maintaining the data quality Ensure the data accuracy by inspecting the sample data. Perform reviews on the defined processes. Encouraging the team members in contribution of the lessons learnt, best practices. Train the data analyst to follow the organization policies. Participating in the Root Causes Analysis and preparing Causal Analysis Report and sending it to the organization Repository Keywords: cprogramm continuous integration continuous deployment quality analyst user interface sthree database information technology hewlett packard microsoft California Texas