Yamini Jyoshna Kothala
Professional Experience
Overall 10+ years of experience in Quality assurance with extensive knowledge of automated and manual software testing techniques, Data analysis and Data governance with good knowledge of Data warehousing & Business Reporting environments tools, methodologies, and approaches.
Experience in BI-DW/ETL on various data warehousing initiatives, data source analysis, architecture, tools, data stewardship, data governance and data integration
Experienced in creating test scripts using python for file’s handling and creating validations.
Experience in validating the data with Business Intelligence Reporting applications such as Business Objects, MicroStrategy reports.
Experiences in creating SQL’s and debugging stored procedures in Teradata and Oracle scripts.
Experience with quality assurance domain and automation scripting.
Experienced in manual execution of Test cases and maintaining Traceability matrix (RTM).
Experienced in developing BDD framework using JBehave and implementing feature files using selenium WebDriver in java.
Experience with Git version control system for code management.
Experience in various SDLC methodologies – Agile/Scrum and Waterfall.
Extensive work experience using tools like JIRA, Rally for defect tracking.
Experience working individually, with minimal supervision & as well as a team. Enjoy working collaboratively with functional teams, developers, and other team members in coordinating complex projects and in the overall enhancement of project deliverables.
Good team player and loves to network with all teams to get job done.
Education:
Bachelor of Technology in Information Technology (IT), Andhra University, India.
Professional Certifications:
Oracle Database 11g: SQL Fundamentals Certified.
Technical Skills
Databases/Database tools : Oracle, MySQL Server, PostgreSQL, SQL Developer, MySQL, Teradata
Business Intelligence Tools : Spotfire, Business Objects, Informatica
Programming Language : Python,Java 7,and SQL,
Project Management Tools : HP ALM, JIRA.
Build /Integration Tools : Maven, ANT, Jenkins.
Bug Tracking Tools : JIRA, HP Quality Center, HP ALM
Scripting languages : CSS, HTML5, VB Script and JavaScript.
Web servers : Apache web server,JBoss AS, Microsoft IIS,IBM Web sphere
Operating Systems : Windows(7, 8, 10), Linux, Unix
Web Service Tool : SoapUI, Postman
Version Control System(VCS) : SVN, Git
Reporting tool : MicroStrategy
Automation Tools : Selenium IDE, Selenium WebDriver.
Project Summary
Python data Analyst 08/2018- Present
Spectrum/Charter, St Louis, MO
Inbound Retention is about retaining customers and PSUs (Primary Service Units: Video, Internet, and Telephone) using Customer Interaction tracking tool where the call agent selects a sale or disposition that characterizes the call outcome. This information is used for performance management and operational planning.
Responsibilities:
Work with Business Partners to collect the requirements and create Business Requirements Document (BRD).
Performed Data Analysis, Data Mapping and Data validation by writing python scripts and SQL’s.
Work with Technical team to communicate the user requirements and coordinate /resolve issues within the team.
Created Test scripts using python to transfer data from excel files.
Created python test scripts ad hoc SQL to validate data in various environments like DEV/UAT and PROD.
Validate Micro strategy Reports attributes and metrics logic in various reporting environments and track issues in JIRA/tracking tools.
Create and maintain Key Objects definitions reporting environment and track master objects list for quick reference across the teams.
Experience with creating Automation SQL Scripts in Stored procedures to enforce data quality within the Data marts.
Worked in agile environment on report development and tracked requirements to reports objects and validations in MicroStrategy report.
Environment: Business Objects, Teradata, SQL Developer, JIRA, MicroStrategy, One automation tool.
QA Automation /Analyst 02/2017- 08/2018
Master Card, St Louis, MO
Master pass is a digital wallet that simplifies the checkout process with one secure account. . Purpose of the project is to automate both Standard and express checkout flow through a Test portal configured with all merchants.
Responsibilities:
Understand and analyze Business requirements, Functional documents and maintain them.
Create Test scenarios in line with business reporting requirements.
Creating and executing manual test cases.
Developing automation scripts using selenium web driver in java following BDD framework.
Performed API testing using Postman.
Performed Data Analysis, Data validation by writing SQL queries.
Experience with creating Automation SQL Scripts in Stored procedures to enforce data quality within the Data marts.
Sauce labs used to run automated test suites.
Report various key metrics to department executives about transaction volume, check out KPIs, etc. T
Performed dry run of scripts developed.
Worked in agile environment and scheduled demos to stakeholders to make sure we met their requirements.
Environment: Business Objects, SQL Developer, JIRA, Toad, HP ALM, Git.
Business Analyst/QA Automation Tester 03/2016 – 05/2017
Prospect Infosys Inc., MO.
The purpose of Healthhawks.com is to further educate patients about acute and chronic medical conditions through health education videos made my local physicians. In creating these videos, Healthhawks plans to address misunderstood or unheard discharge instructions of patients and answer frequently asked questions patients have following visits to their providers. It has different modules like Forums, Specialties, SampleVedios, Home, Articles, and Registration.
Responsibilities:
Followed agile methodology-scrum processes-with three weeks sprint.
Create test Cases in Zephyr (JIRA plugin) and associate with the corresponding user stories in JIRA.
Defined, documented, analyzed, scripted, and executed automated tests for a new, Web-based software that:
Enabled me to rapidly identify and document defects
Discussed undiscovered and potential bugs in demo version and created preventative adjustments resulting in a overall better demonstration and very positive reception from physicians and potential clientele as evidenced by overall 80-90% positive comments/reviews in the questionnaires handed out
Generate detailed logs using Extent Reports for automated test scripts.
Performed Rest API testing using Postman.
Configured Jenkins to improve efficient reduce test time
Developed SQL scripts to validate relational database tables using JDBC and provide data summary/Metrics reports to management.
Running selenium scripts.
Environment: Selenium WebDriver and GRID, Agile, JIRA, MySQL, Selenium GRID, Java, TestNG, Maven, PostgreSQL.
QA Automation Tester 01/2015 – 02/2016
Wolters Kluwer, New York.
JDE is the backbone of CLS (corporate legal services) IT-architecture. One world is an enterprise resource planning (ERP) application meant for seamlessly integrating different sets of activities performed in the different departments of the organization. The Wolters Kluwer online e-Store application enables smooth flow of information across the organization, thereby improving the quality of services offered and better customer satisfaction.
Responsibilities:
•Understand and analyze Business requirements, Functional documents and maintain them with the changes.
•Execute the manual test cases and responsible to track and log the defects using HP ALM.
•Identify and develop the test cases for automation.
•Implement the Page Object Model design pattern with page factory using selenium web driver in java with TestNG.
•Maintained the selenium automation code and resources in SVN over the time for improvements and new features
•Performed web services testing using SOAPUI tool.
•Involved in Junit framework for existing selenium scripts.
•Used SQL commands to validate the database and test its integration with the front end.
•Integrated with Continuous Integration tools Jenkins for running test on weekly basis.
•Validate the Business Objects reports with the data coming from ETL process and work with developers to fix the issues
Environment: HP ALM, MySQL, PostgreSQL, Oracle, Java, Selenium WebDriver, Selenium IDE, SoapUI, Jenkins, Informatica, Kettle, Business Objects.
QA Analyst 06/2012 – 12/2014
BCBS (Blue Cross Blue Shields), FL
Next Generation of Health Care (NGEN) is an extensive effort across BCBS and its subsidiaries to revamp their retail (individual) business to meet the changing needs of their customers, position BCBS as a leader in the future retail market and help the company fulfill their purpose. NGEN Program includes various modules like Member Enrollment, Member Maintenance, Payment Processing & Plan calculation, Invoicing, Data Management, Reporting, Administration, Customer Service Requests, Web Self Service (Blue Access).
Responsibilities:
Understand and analyze Business requirements, Functional documents and maintain them.
Contributed in Test plans and created Test Scenarios, Test Cases, Test Data, RTM and Defect Reports In QC.
Perform functional, integration, Usability testing on applications using Automation testing process.
Identified automated test cases and implemented TestNG framework.
Used Log4j to generate logs for automation test scripts.
Perform Functional and Regression testing to check the compatibility of new functionality with the existing
Functionalities of the application using Selenium.
Perform the batch processing using the scripts by keeping functional and regression suites in testng.xml file.
Parameterize the scripts to avoid code redundancy and hard coding of frequently changing values in Selenium.
Used QC to report bugs, keep track of bugs.
Participated in weekly QA meetings and defect triage meetings with the Dev and QA teams.
Validate the BI applications data in the reports against the data in the data mart applications
Environment: Selenium WebDriver, TestNG, SQL, QC, Junit, Log4j, Oracle, PostgreSQL, Informatica.