Quality Assurance Automation Engineer
Resume:
Sriram Mandavilla
******.***@*****.***
Having 16 + years of experience as a Senior Quality Assurance Consultant, Quality Assurance Engineer, Test Analyst, Test Engineer in testing software applications developed on various technologies. Rich experience in different domains such as banking and logistics and having good knowledge in various software testing tools makes it easy to work in different test environments. I am interested to work in both manual and automated testing of software applications. I am looking forward for a bright career in Software testing.
Education Summary:
M.C.A (master’s in computer applications) from India
Technical Summary
Software’s Tested on technologies
HTML, VBScript, C,C++, Java,J2EE, JavaScript, XML, Web services, SOAP and VB, Python
Servers – IBM Web sphere,
BOXIR2 Reports, SSRS, Tableau
Server-Side Testing
UAT Testing, Functional and Regression and System Integration Testing
Databases
SQL Server 2000/2003/2005, MySQL, Oracle9x/10g, SQL Navigator, TOAD and Rapid SQL, Sybase, Interactive querying Tool, Adept SQL Diff Tool, ETL Informatica, SPUFI, QMF, Netezza, AWS RedShift
Expertise on Testing Software’s
Mercury – Quick Test Professional 8.2,9.0,9.2,9.5(QTP), Win Runner 8.0, Load runner 9.0, HP Service Test, Business Process Testing, SOAP UI, Selenium, BDD CUCUMBER, Test Director 7.5, 8.2, Quality Center 9.0,SIR Tracker, JIRA, Star Team,VSS and CaliberRM, Rational Robot,Clear case, Clear Quest, Requisite pro, DOORS.
Area Of Specialization
Experience in testing (Manual / Automation) of Software applications in Client Server and Web Environment. Strong in Analyzing Business / Technical specifications scenarios
Excellent in preparing Test Strategies, Test Plans, Test Scripts, Test Reports and test documentation and can comply with your established processes, can maintain strict adherence to your guidelines, policies and procedures.
Rich in Web GUI eCommerce testing experience.
Knowledge and Experience in reporting Tool Tableau
Expertise in QA Methodologies, like TDD, Agile, RUP, SCRUM, Waterfall. Quality Assurance Life Cycle, Test Strategy, Test metrics. Worked on full Software Development Life Cycle (SDLC).
Perform quality assurance analysis and testing on an Enterprise-level web application and Client server applications
Experience in White Box Testing, Black Box Testing, Positive, Negative, Data Driven, Functional, UI, Backend, System, and Integration Testing and Regression Testing.
Experience in write effective SQL queries, review and translate the meaning of the results.
Domain knowledge of Logistics, Web based applications, Banking and Finance (Investment, Mortgages, and Core) and Health care and Insurance.
Excellent working Experience in UNIX Environment
Skills in back-end testing using SQL queries on database tables
Extensively used Test Director/QC, Rational Clear Quest, Team Track to report bugs
Knowledge and Experience in design and implementing automation framework using functional testing tools like Quick Test Professional (Mercury Interactive), Selenium, BDD like Data Driven and keyword driven
Rich Experience in handling Functional Libraries,Object repositories and Descriptive programming
Experience in Using and maintain of Actions and Reusable actions
Experience and handling in Check points depends on requirement.
Experience in Selenium and Cucumber Framework using Java/JavaScript.
Rich Experience in DW/ETL Testing
Experience in API Testing and Server-Side Testing for backend servers
Knowledge and Experience in Autosys for scheduling jobs
Rich experience in Web application testing
Experience in Project Management Activities like estimations, creation of project plan, planning and control, executing time bound projects, task recognition, setting deadlines and milestones, task assignment, task execution, resource management.
Well versed in configuration Management Tools like VSS and Star team.
Professional Experience:
Office of Attorney General (OAG)
Date From / To
Position
Project Location
Client
May 2023 / Present
QA Automation Engineer
Washington DC
Office of Attorney General
Hardware/OS
Windows, Unix
Environment
Force.com, Salesforce, JSON, Web services, AWS,
LINUX, Selenium, GitHub, Python, Jira, POSTMAN
Project Details
Office of Attorney General Child Support Services Division’s web application is launched to establish a Path for DC Constituents to Apply for Child Support Services Online with an objective to Reduce Manual Labor through Automation, Reduce Paper-based Documents and Processes, Eliminate Duplicate Applications entries and to Improve Accuracy and Completeness of Application Data.
Roles / Responsibilities
Designing Automation Framework to test Force.com Web and Mobile Application and its integration with Salesforce, and Legacy application using Java
Coding in java to support Automation framework for functional and regression test verifications and validations
Designing API Automation Framework to verify and validate internal API’s.
Executing Functional, Regression, Integration and End to End manual tests to verify and validate the web applications and mobile applications
Executing manual tests on different platforms (Window, IOS, Android, Mac, Linux) to test the functionality and compatibility of the application
Executing API Tests manually using POSTMAN and Rest Clients
Planning Regression and Functional and integration test cycles with Dev and Business Teams
Conducting application demos to the Business users and team management
Writing Test Plans, Test Strategies, Test Scenarios and Test cases for manual and automation tests
Developing QA Road maps to meet the future milestones, deadlines and releases.
Conducting training sessions to Business Users to perform UAT and documenting the feedback for a possible user story candidate.
Coordinated with Project Lead on daily basis to track the progress of Application Development and Testing efforts.
Debugging and analyzing production issues to see test coverage gaps in lower environments
Attending spring planning session, story grooming session, and daily scrum calls as a part of Agile process.
Fanniemae
Date From / To
Position
Project Location
Client
May 2014 / May 2023
SDET (UAT)
Herndon, VA
Fanniemae
Hardware/OS
Windows, Unix
Environment
Web Services, XML Spy, QC, Oracle 11g, Python, DOORS, Rational Clear Quest, TOAD 9.5, Informatica, Data validation Tool DTF (Internal tool), Netezza, AWS Redshift, Tableau, Selenium, Cucumber, Alteryx 2019.3, Rally, Jenkins, JIRA, SVN, Eclipse, AutoSys lambda, step functions, EMR
Project Details
Fanniemae is the country’s largest provider of Mortgage services - Hired in the capacity of a Senior QA Tester, responsible for requirement analysis and testing of various web services in SOA architecture for both manual and automation. Also responsible for identifying various deliverables, timelines and milestones by coordinating with internal parties in the project.
Roles / Responsibilities
Interacted with the Business Clients, Product Owners, Developers & QA Manager for clear exposure to trickle down the technical/functional User Requirements & Change Requests to Test Plans and Test Scenarios
Responsible for Business requirement Analysis, Test scenarios Preparation.
Telelogic DOORS is used for requirements definition and requirements management.
Maintain Test Cases and Test scripts in HP Quality Center.
Conduct Test case review meetings & obtain formal acceptance before starting execution.
Created and modified Test data for new and modified Functionalities.
Responsible all ETL validations as part of Migration On-prem to AWS
Developed SQL scripts using AWS RedShift
Validated all Tableau Reports in both On-prem and AWS, Compared data on-prem vs AWS
Responsible for Starting EMR cluster and executing lambda and validating data using Data testing framework (DTF)
Responsible for validating counts on staging vs target after batch jobs execution using AWS Redshift
Responsible for developing automation scripts using python to upload and download files from S3 Bucket.
Responsible for validating CloudWatch logs for publishing SNS and SQS
Responsible for executing CI/CD pipelines for publishing ques and messages.
Responsible for morning server shakeout on daily basis Unix and AutoSys jobs.
Developed python scripts using lambda to publish SNS and SQS notifications
Developed and executed YBYO pipelines for download and upload files.
Conducted end-to-end integration testing and assured software delivered met requirements and expectations
Manually tested End-to-End scenarios with respect to UAT.
Responsible for Testing and setup environment and test data in SIT, UAT and NHE.
Responsible for Identifying Data Scenarios to test Full refresh and Incremental loads.
Responsible for updating user stories in JIRA
Responsible for Developing, execution and maintaining Automation scripts in BDD Cucumber and Selenium framework.
Responsible for developing automation scripts for rest api calls
Responsible for Testing End to End Tableau Web reports from data population and data presentation and data validation using Data testing Framework.
Responsible for Testing cross browsers using Selenium Grid.
Responsible for Developing SQL scripts for validating tableau and BO report validation
Participate in design, walkthrough and defect review meetings.
Directly worked with the development team to resolve problems and provide technical content for product documentation.
Developed automated test scripts and enhanced the scripts with python script as necessary for functionality testing using selenium.
Developed Python Scripts to refresh Tableau Data sources and download CSV and PDF files for on daily Basis.
Integrated python scripts for Autosys scheduling jobs
Implemented Functional Libraries for Existing and newly developed scripts.
Fully automated all Regression Test cases using QTP.
Integrated All Automation Scripts in HP Quality center and maintained in data in spreadsheets.
Created Functional Libraries and Object repositories using QTP
Handled shared and local Object repositories as per application requirement for QTP
Implemented Hybrid framework for QTP regression bed.
Conduct System, Integration, Functional and Regression Tests.
Responsible for API validation in the Log entry for each test cycle of web service transactions.
Responsible for preparing production check list and also support production deployment support for QA
Perform database verifications using SQL queries to validate test data.
Running and executing UNIX scripts and verified log files to track issues.
Monitored Clear quest to close defects as and when developers provide fix.
Investigate software defects and interact with developers to resolve technical issues.
Responsible for Regression testing after bug fixes and verified those fixes.
NNS DW TESTING
Date From / To
Position
Project Location
Client
Oct 2013 / April 2014
Sr QA/Lead Tester
Arlington, VA
NRECA
Hardware/OS
Windows
Environment
ETL Informatica, SSIS, SSRS, JIRA, SQL Server 2005/2008, Oracle 10g, Adept SQL Diff Tool, QTP11, SharePoint, SOAP UI, GROOVY, Selenium
Project Details
The SSIS Migration project, that aims to replace informatica to SSIS, integrate and de-duplicate Insurance plans and data at an enterprise level, and to create and maintain a SSIS packages and replacing Informatica mappings of the most accurate, current, and consistent information.
Roles / Responsibilities
Participated in Requirements, Design, and Release Readiness review sessions.
Participated in the QA Meetings, Bug Review Meetings, Go/No-Go Meetings & responsible for updating & verification of the Project Checklist during the Deployments/Releases
Own the creation and ongoing maintenance of test documentation and test plans.
Responsible for the ETL (Informatica) build validation process on an ongoing basis
Worked with the development team to create a suite of test data (both input files and expected results) that fully exercises data validation (detecting and rejecting bad data) and actual ETL(Informatica) functionality (properly processing good data, i.e., transformations, calculations, and derivations)
Developed and reviewed test cases source to target mappings
Responsible for the running and validation of jobs in SQL Agent for ETL process of any additions / modifications to before release to production.
Write and execute SQL queries to validate actual test results match expected results.
Experience in extensive database testing and Back End Testing using SQL queries with SQL database Performed Manual Testing of the Application to determine ease of usability
Experience in write effective SQL queries, review and translate the meaning of the results
Developed SQL test scripts for Functional and Regression Testing
Developed SQL scripts for Comparing data in different databases on separate servers
Automated SQL scripts for taking row counts on daily basis for daily, weekly and Monthly tables
Tested databases DWP_Staging and DWP_Target for informatica and SSIS packages
Extensively used Adept SQL diff tool for comparing data for DWP_Target database
Developed flows for Daily, Weekly and Monthly for Informatica mappings to create same order of SSIS Packages
Experienced with informatica mappings and check the source and target table mappings.
Responsible for testing all FACT and LKUP tables at target level after SSIS packages deployed.
Responsible for testing and have to certify for good to go for daily, weekly and Monthly tables to replace Informatica to SSIS packages.
Identify and log defects if/when a test fails, if necessary, using SQL to narrow down the root cause of the problem for efficient investigation by the development team and log accordingly.
Developed automation frame work with SOAP UI using Groovy script.
Created and executed scripts for web testing using Selenium.
Developed QTP scripts to automate ETL Testing process for reporting.
Fanniemae
Date From / To
Position
Project Location
Client
Feb 2012 / Sep 2013
UAT Lead
Herndon, VA
Fanniemae
Hardware/OS
Windows
Environment
Web Services, XML Spy, QC, Oracle 11g, QTP 11.0, DOORS, Rational Clear Quest, TOAD 9.5.
Project Details
Fanniemae is the country’s largest provider of Mortgage services - Hired in the capacity of a Senior QA Tester, responsible for requirement analysis and testing of various web services in SOA architecture for both manual and automation. Also responsible for identifying various deliverables, timelines and milestones by coordinating with internal parties in the project.
Roles / Responsibilities
Interacted with the Business Clients, Product Owners, Developers & QA Manager for clear exposure to trickle down the technical/functional User Requirements & Change Requests to Test Plans and Test Scenarios
Responsible for Business requirement Analysis, Test scenarios Preparation.
Telelogic DOORS is used for requirements definition and requirements management.
Maintain Test Cases and Test scripts in HP Quality Center.
Manually tested all Business Rules as per BRD.
Conduct Test case review meetings & obtain formal acceptance before starting execution.
Created and modified Test data for new and modified Functionalities.
Manually tested End-to-End scenarios with respect to business.
Participate in design, walkthrough and defect review meetings.
Directly worked with the development team to resolve problems and provide technical content for product documentation.
Developed automated test scripts and enhanced the scripts with VB script as necessary for functionality testing using QTP.
Developed Automation scripts for web services using QTP.
Implemented Functional Libraries for Existing and newly developed scripts.
Fully automated all Regression Test cases using QTP.
Integrated All Automation Scripts in HP Quality center and Maintained in data in spreadsheets.
Created Functional Libraries and Object repositories using QTP
Handled shared and local Object repositories as per application requirement for QTP
Implemented Hybrid frame work for QTP regression bed.
Conduct System, Integration, Functional and Regression Tests.
Responsible for API validation in the Log entry for each test cycle of web service transactions.
Responsible for prepare production check list and also support production deployment support for QA
Perform database verifications using SQL queries to validate test data.
Running and executing UNIX scripts and verified log files to track issues.
Monitored Clear quest to close defects as and when developers provide fix.
Investigate software defects and interact with developers to resolve technical issues.
Responsible for Regression testing after bug fixes and verified those fixes.
DTA Testing
Date From / To
Position
Project Location
Client
June 2010 / Feb 2012
Sr.QA
Herndon, VA
Comcast
Hardware/OS
Windows, Unix
Environment
Web Services, Soap UI, HP Service Test, QC, Oracle 11g, QTP 10.0, XML
Project Details
Comcast is the country’s largest provider of cable services - and one of the world’s leading communications companies. Hired in the capacity of a Senior QA Tester, responsible for requirement analysis and testing of various web services in SOA architecture. Also responsible for identifying various deliverables, timelines and milestones by coordinating with internal parties in the project.
SSIS Migration
Date From / To
Position
Project Location
Client
Sep 2009 / May 2010
Sr.QA
Arlington, VA
NRECA
Hardware/OS
Windows, Unix
Environment
ETL Informatica, SSIS, Bug Tracker, SQL Server 2005/2008, Oracle 10g, Adept SQL Diff Tool, SharePoint, Agile,
Project Details
The SSIS Migration project, that aims to replace informatica to SSIS, integrate and de-duplicate Insurance plans and data at an enterprise level, and to create and maintain a SSIS packages and replacing Informatica mappings of the most accurate, current, and consistent information.
Walgreens
Date From / To
Position
Project Location
Client
Jan 2009 / Aug 2009
Sr.QA
Lincolnshire, IL
Walgreens
Hardware/OS
Windows, Unix
Environment
ETL Informatica 8.1.1, Autosys Job Scheduler, SOA, Web services, Oracle
10g, TOAD, Quality Centre, IBM Lotus Notes, XML, SOAP UI, QTP 9.5, QC 9.2,
BOXI Reports
Project Details
The Customer Data Integration (CDI) project, that aims to consolidate, integrate and de-duplicate Walgreens customer
data at an enterprise level, and to create and maintain a central repository of the most accurate, current, and consistent
information about a customer, CDI Phase 2 will build upon the foundation created in Phase 1 by implementing
integration components through Web Services, adding additional source data into the Customer Hub.
TRIZETTO
Date From / To
Position
Project Location
Client
Jan 2008 / Dec 2008
Sr.QA
Union, NJ
TRIZETTO
Hardware/OS
Windows, Unix
Environment
Java, QTP 9.2 and 9.5, VB scripting, Quality Centre 9.0, ORACLE, XML, Webservices (BEA Web Logic 8.1), SOAP UI, Agile Methodology
Project Details
The Facets is core product for Trizetto.it provides complete health care package it serves the payer market, comprised of
national and regional health insurance plans as well as benefits administrators. TriZetto's Facets Workflow takes claims
administration and customer service to higher levels of productivity and cost-effectiveness. This Java-based software
application automatically prioritizes and routes claims and customer service work items, based on rules that reflect
organization’s business, staffing and training needs. Through integration with Facets, the Workflow application enables
seamless, real-time delivery of claims and customer service items, eliminating bottlenecks, automating work and reducing costs while improving speed and accuracy
Contact this candidate