Quality Assurance Test Automation
Resume:
Sonali Chang
Chester springs, PA 267-***-**** ***********@*****.***
Principal SDET
About Myself:
An SDET with 15 years of testing and quality assurance experience in large scale projects. Highly motivated, self driven and aspire to work in a challenging environment. Executive Summary:
• Over 15 years experience in IT industry in large scale projects. This includes all the life cycles of testing (Test strategizing, planning, and execution), performed manual and automated testing using various tool, technologies and platforms.
• 10+ years of experience in Automation testing as SDET and Sr. SDET.
• Over 3 years of experience in working as business and functional analyst to create and analyze business and functional requirements.
• Extensive experience on Test automation framework design and architecture using BDD and TDD methodologies.
• 4 years of Mobile application test automation (iOS and Android) using Appium.
• Fluent in JavaScript, Typescript, Java, Python, NodeJS.
• Well versed with latest technologies such as Browserstack, Appium, Selenium, Cypress, GitHub. And Jira for project maintenance.
• Well versed with latest DB technologies such as Postgres, Aurora and Redshift.
• Extensively worked on creating continuous integration (CI) and continuous development (CD) frameworks for agile projects using GitLab, Travis, Jenkins.
• Well versed with overall AWS concepts along with microservice management, containerization and deployment processes using Docker, Kubernetes, Docker Swarm, Kafka, SQS, S3, EC2.
• Well versed with Cucumber, Gherkin syntax, Mocha.
• Extensive testing experience in Data warehousing, Data Migration and ETL frameworks built based on UNIX and Informatica.
• Extensively performed Test scripting, test strategizing and planning, test data preparation, test execution and data validation.
• Strong testing experience and knowledge in UNIX, Oracle, Java.
• Experience in automated testing using Java, JUNIT, Selenium, Python.
• Experience in user interface testing methodology and human interface guidelines
• Experience in testing using automated testing framework for COCOA based applications (RAFT) along with Python scripting.
• Experience in SOAP and REST WebService testing using SOAP UI.
• Good exposure to multiple relational databases including Oracle, DB2.
• Good knowledge of automated scripting using UNIX shell scripting, SQL query.
• Development experience in Java based application to automate defect tracking and reporting
• Strong experience in testing tools (QTP), test management tools (HP quality center, RADAR), and configuration management tools (VSS, SVN)
• Excellent analytical and problem solving skills. Good communication and interpersonal skills, with ability to interact with individuals at all levels. Capable of working independently, as well as a team player.
Certification:
• External Certification on Insurance domain
• LOMA 290 and LOMA 300
• Docker foundation professional certificate
Technical Skills:
Testing Tools: QTP, JUNIT, Appium, Cypress, Selenium Webdriver, HP Quality Center, RADAR, RAFT, Browserstack
Operating Systems: UNIX, MAC OSX/ iOS, Windows, Android Databases: Oracle 11g, SQL, Postgres, MongoDB
ETL: Informatica
Programming Languages: NodeJS, JavaScript, Typescript, Java, Python, UNIX shell script Data Modeling Tools: MS Visio, TOAD
Version Control Tools: GitLab, GitHub, VSS, SVN
Model: STLC, SDLC
Project details:
Caesars Digital, Jersey city, NJ (April 2022 – till date) Role: Sr. SDET
Project: Caesars Sportsbook, Betting RA
This project is to upgrade and maintain Caesars sportsbook app for digital betting. My roles and responsibilities includes:
• Web application test automation using Selenium WebDriver with TestNG. Using JavaScript.
• Mobile app test automation (iOS and Android) using Appium with JavaScript and TypeScript. Worked on designing this test framework architecture and implementing functional tests for features that impacts 80% of the customer base.
• Xcode for building iOS app on local environment.
• Backoffice Frontend automation using Cypress with JavaScript
• BDD Test framework design using Cucumber
• Test framework design using mocha
• Review design documents and user stories for new features and enhancements.
• Transfer business/product conversation/ requirements into test strategy to ensure parallel testing.
• Maintain CI/CD (in GitLab), communicate with devOps in case of issues.
• Automate integration tests and make sure they run as part of the GitLab CI/CD pipeline for each release.
• Maintain and review reports generated by Report portal and communicate with stack holders on test results.
• Troubleshoot and create bug tickets And follow up through the fix.
• Contribute to bug analysis and come up with strategy to catch bug earlier is the process.
• Interview and mentor new SDET
Sidecar Inc, Philadelphia, PA (Aug 2018 – April 2022) Role: Automation engineer (Aug 2018 – Dec 2019), Senior Automated Test Engineer (Jan 2020 – April 2022)
Project: Paid-search Automation
This project is to improvise the keyword generation, bidding logic and a better landing page solution to the retailers, my roles and responsibilities are -
• Designing and developing web application test framework in Cypress and JavaScript.
• Functional test scenario creation in each sprint
• Create a CI/ CD pipeline using Jenkins
• Automate integration tests and make sure they run as part of the Jenkins pipeline for each build
• Data analysis for keyword search using MS Power BI Environment: Jenkins for build / CI/CD, shell scripts, docker, Kubernetes, GitHub, Python, JavaScript with Cypress for test automation, Postgres, Aurora and Redshift DB, different Postgres tools for data setup, aws, Jira for project maintenance.
Sidecar Inc, Philadelphia, PA (Jan 2018 – Aug 2018) Role: Automation engineer
Project: Connect Data pipeline
As part of this project Sidecar created a robust data pipeline to ensure performance, maintainability and correctness to the different product performance reports And to the one stop user interface called Connect. My roles and responsibilities were -
• Test scenarios to test each functional point and integration points
• Automated test data setup solution
• Continuous integration and deployment using Travis, performance test. Environment: Travis for build / CI/CD, shell scripts, docker, GitHub, Python for test scripting, Postgres DB, different Postgres tools for data setup, AWS, Jira for project maintenance. Comcast – Noblesoft Inc, Philadelphia, PA (Aug 2014 – Jul 2015) Role: Quality Analyst
Project: Home Security Testing
As part of this project I was working as a quality analyst for Comcast’s leading Home Security system. This product is primarily designed for domestic and residential users. I was involved in testing framework design, test execution, initial analysis on problem tickets and coordinating issue fixes with development team.
• Build testing framework using Python script
• Test execution
• Dashboard preparation and Status reporting of testing progress
• Initial analysis on problem tickets
• Analysis on new enhancement requests and coordinate with Development team
• Rollout support
Environment: Oracle 11g, Python
Apple Inc - Infosys, Sunnyvale, CA (Mar 2014 – Jul 2014) Role: Quality Analyst
Project: HRT – UAT Project
I was working as quality analyst for HR module enhancement rollout. The project involved User acceptance testing for different HRT systems which involved Talent ratings and performance appraisal, Work Force Management and compensation, Annual bonus calculation for leaves etc. My primary responsibilities were below.
• Analyzing and Finalizing business requirement (involves FSD, E2E Flow diagram, BRD creation)
• Impact analysis of changes
• Analyze exception business scenario, preparing flow diagrams
• Preparation of functional test plan and performing UAT.
• Test strategizing and planning
• Activities also included defect triage meetings, defect prioritization and tracking, and go-live validation.
• User Acceptance testing on COCOA based applications developed for HRT systems.
• Testing and analyzing database (DDL on Oracle 11g)
• Mentoring offshore on a Selenium project.
Environment: COCOA, Java, Oracle 11g, Selenium
Apple Inc - Infosys, Sunnyvale, CA (Jul 2013 – Oct 2013) Role: Independent Quality Assurance lead
Project: Sonar X – Independent quality assurance
The project was aimed at restructuring the User Interface and Backend for Product Classification, PCI compliance and Aging Report for Sonar Application. Sonar is an internal application used by Apple Inc to report and track the issues / problems related to the Apple products. The different MiniTeams created to work on issues related to different Apple products / services, reports the problems to Sonar as a Sonar request and take them forward to closure by escalating the same to the correct teams. As a Test Analyst and Onsite Co- ordinator my responsibilities included below.
• Requirement analysis and review
• Test strategy and planning
• Activity planning for QA track and team management
• Leading the functional testing track which involves independent quality assurance, Integration and Regression testing
• Defect Prevention and quality Assurance activities
• Weekly and monthly defect status and project progress dashboard reporting and share with senior management
• Mentoring and leading offshore team
• Independent Quality Assurance on COCOA based applications – Sonar.
• Testing and analyzing database (DDL on Oracle 11g)
• Creating Test Automation framework for the application using RAFT and Python.
• Test Automation for related web application using Selenium, JUnit and Java
• Developing QA Dashboard for quick result reporting for this project, using core Java. Environment: COCOA, Java, Oracle 11g, Selenium, JUNIT, RAFT, Python Apple Inc - Infosys, Mangalore, India (Oct 2011 – Jun 2013) Role: Test Analyst
Project: Sonar 8.1 Maintenance and SonarX Re-design The project involves redesigning existing Sonar application in terms of usability, performance and added functionality. Automated request creation and tracking, correspondences, reporting and admin are some of the key modules of this application used by Apple to resolve its end-customer’s issues/queries. My primary responsibilities included below -
• Requirement analysis and review
• Activity planning for QA track
• Test strategizing and planning
• Leading the functional testing track which involves module testing, Integration testing and Regression testing.
• Defect Prevention and Quality Assurance
• Weekly and monthly defect status and project progress dashboard reporting and share with senior management
• Mentoring and leading offshore team
• Independent Quality Assurance on COCOA based applications – Sonar.
• Testing and analyzing database (DDL on Oracle 11g)
• Internal defect tracking using JTrac.
• Creating Test Automation framework for the application using RAFT and Python.
• Test Automation for related web application using Selenium, JUnit and Java
• WebService testing using SOAP UI
Environment: COCOA, Java, Oracle 11g, Selenium, JUNIT, JTrac, RAFT, Python, SOAP UI Northwestern Mutual - Infosys, Bhubaneshwar, India Mar 2008 – Oct 2011 Role: Test Engineer
Project: Field Management Compensation (FMC) – Current Income Phase I, II and Field Level Leaders The Vision of this project is to make the Network Office the best place to invest, aligned with Home Office and the main objective is to achieve 6% Premium Growth and 3% Growth for their Agent’s network. To accomplish this vision and to meet this objective Northwestern Mutual has introduced some new compensation programs as a part of Agent’s current income. As part of these projects ETLs were created in order to move selected data based on the business rules to the Data-Mart and dynamic reports are generated using the migrated data. My responsibilities in this project included below.
• Worked as a module lead for these 3 testing projects with NM
• Requirement Analysis: Worked with Application Analysts and Business Analysts to figure out the issues/ conflicts in the requirement
• Analysis the data migration based on the business logic
• Stage Data Validation Integration
• Report Validation for PI (Performance Incentive) and DEP (Development Enhancement Program)
• Database setup, Data analysis and validation using DDL and DML on Oracle, Sybase and UDB.
• Data migration script analysis – ETL testing using Informatica.
• Data validation automation using Unix script
• Defect Prevention and Quality Assurance.
Environment: Oracle, UNIX, UDB, Informatica
Education:
• Bachelor of Information technology from RCC Institute of Information technology, West Bengal, India
Awards and achievements:
• Star Performer award for FMC CI Phase 1 project (client : North-Western Mutual)
• Recognition from Client (North-western Mutual) for handling the project and delivering defect free module (PI) single handed for project FMC CI Phase 2.
• OREY award for Execution Excellence from North-western mutual client
Contact this candidate