Etl Testing Resume
Houston, TexaS
SUMMARY
- 12+ years QA experience testing various .Net applications (Shipping, retail, private, front end, web sites, Web applications, middle ware (service layer)), Database Testing (Oracle, SQL Server), SAP applications (supply Chain, Big Data - HANA), Shipping (Stand-alone applications) and Mobile Applications on iOS (iPad & iPhone), Android,
- Windows & Blackberry native applications, Web applications and web sites
- Experience in performing Performance testing using Load Runner & JMeter
- Strong knowledge on C# coding using VS IDE, VS code, GitHub lab, GitHub Bash
- Experience in setting up Automation framework using selenium web driver
- Experience is writing Java Scripts (node.js, React.js) using Nightwatch automation Framework
- Experience in Gas and Oil Industries.
- Extensive experience in testing web based applications, data base testing and native apps.
- Expertise in developing the Test plans, Test Strategy, Test Schedules, Test Estimations, Test cases, Test reports and bug tracking management.
- Involved in Complete Software Development Lifecycle (SDLC) from Business Analysis to Development, Testing, Deployment and Documentation.
- Very good domain knowledge of working on Mobile Application (iPad, iOS Native applications and publishing the mobiles apps to App world.
- Testing software products on Macintosh OS and iOS.
- Expertise at gathering and analyzing software quality metrics throughout the software development life cycle.
- Developed and Executed Test Plans and Test Cases as per Business requirement followed by Bug Tracking and reporting.
- Familiar in Waterfall, V-Model, Agile/Scrum methodology.
- Experience in Building Microsoft.Net/C# automation Scripts by using Selenium, MS Visual Studio , MSTest, NUNIT, Spec flow, Coded UI, Azure and good expertise in using Annotations
- Experience in design and development of BDD framework from the scratch by writing Gherkin Features-Scenarios using SpecFlow and Cucumber.
- Good Experience in unit testing/White box testing the code developed by the developers
- Very good experience in work delegation and schedule preparation.
- Strong exposure on functional and non-functional testing methodologies- Installation Testing, Black Box testing, White Box testing (Smoke & Build Installation Testing), Regression testing, Integration Testing, System testing, usability testing, Compatibility testing, Data visualization testing (Tableau), UAT and End to End Testing
- Excellent knowledge with Defect Tracking using Mingle, HP QC/HP ALM 11.52 tools & TFS
- Successfully worked with different stakeholders of the projects like Development team, Unit Testing Team, Functional & Revenue Testing Customer Experience Team, Line of Business teams, BAs & Marketing Teams, UA Team, off-shore members & Management across multiple time zones that communicate often daily. Very good experience in Interacting with Clients and customers.
- Good knowledge of ISO and CMMI standards.
TECHNICAL SKILLS:
Operating Systems: Windows 9x/NT/2000/XP, Mac, Lion
Platforms/Domains: .Net applications ( Shipping apps, Corporate web sites, banking web applications), Database applications (database testing, migration validation, query retrievals), Mobile applications (iOS, Android, Windows, BB, Web apps), SAP (SD, S&OP, HANA, BPC, Integration), Salesforce
Mobile phone OS IOS (iPad & iPhone), Android, Blackberry & Windows Devices.
Testing Tools: QTP/UFT 11.52,HP QC/HP ALM 11.52, Mingle, JIRA
Reporting Tools: Tableau 7
Databases: MS SQL Server, Oracle SQL
Test Strategies: Smoke and Black Box testing, System, Integration, Regression, User Acceptance, UI Testing, certification testing
SDLC Methodologies/Continuous Integration Practices: Waterfall & V-model, Agile, Scrum
CI: DevOps using Visual Studio, C#, Spec Flow & Jenkins
DevOps Tools: /Automation Frameworks Cucumber & Spec Flow, Jenkins, Nightwatch.js
Testing layers: Font-end - Web applications, .exe applications, Mobile Native applications
Webservices or middle layer: - Database(ETL) testing, SOAP, Restful APIs, Security testing, XML request/responses testing
Backend/database layer: SQL queries, ETL testing, Documentum content testing
End: -to-End testing, Happy path testing, Certification testing
Scripting Languages: C# - Expert Java - IntermediateGherkin - ExpertJavaScript - Intermediate Node.js - Intermediate HTML - Intermediate
PROFESSIONAL EXPERIENCE
Confidential
ETL Testing, Houston, Texas
Environment: Salesforce, SQL server, SQL Server, MS SQL Server Management Studio 2017
Testing Methodology: Agile, Database testing, VSTS, FileZilla(sFTP server), Boomi Integrator.
Responsibilities:
- Preparing high level and detailed test plan for the project
- Writing Test cases, Review, Requirement traceability analysis during Test Design phase for the iteration
- Performing Data extracts to test the Vault & Dimension views for the newly added data elements for different Clients
- Writing complex SQL queries(Joins) to test data extracts, executing stored procedures to validate large volume data in ETL layer (Data Hub)
- Creating Test Data for Inbound Feature with the schematics provided as per the requirements
- Data validations of the Inbound and Outbound Data extracts (.CSV files) as per the requirements
- Integration testing via different layers: salesforce Data Hub Datawarehouse Boomi Salesforce
- Defects analysis and code debugging through Fact & Dim Tables
- Exposure to Health Care domain from Enrollment of a Patient to Triage & Dispense to Pharmacies
- Preparation of Test data and testing end to end from Salesforce front end (Connect Source) till reports through different data base layers: SFDC, Vault, Dimension, Data Hub, Reports
- Preparation of Test Reports on Weekly basis.
- Preparation & Execution of automation scripts for data loads
Confidential, Houston, Texas
Environment: .Net, C#, JavaScript, React.js, Node.js, Selenium Web Driver APIAutomation Framework: BDD on MVVM model, Nightwatch Automation Framework, HTML, JIRA
Testing Methodology: Agile, Sprint, DevOps using SpecFlow
Responsibilities:
- Working on Agile Methodologies ( Scrum ) by following regular Sprint cycles with active involvement in all sprint meetings with testers, developers, scrum master and product owner.
- Responsible for going through the User Stories and creating Test Cases based on the mock up’s provided in User Stories
- Involved in documenting the Test Plan, Test Cases, Traceability Matrix and defect reports
- Creating test scripts using C# and Selenium Web Driver for the functional test cases.
- Designed and developed BDD/TDD/ATDD framework by using the Spec Flow(Cucumber Specification) and added Scenarios in features files, Step Definitions .
- Written various Features, Scenarios, and Scenario Outline with Examples, Scope Bindings, Dynamic Tables and Hooks in Gherkin language for developing BDD framework.
- Developed Automation scripts in Microsoft Visual Studio and used NUnit framework
- Created, implemented and maintained Page Objects (POM) for each Webpage
- Involved in Hybrid Test framework to achieve Regression Testing and developed packages for the Driver scripts, Page Objects, Reusable Libraries, HTML Extent reports and Log files
- Implemented and configured NUnit, Selenium web driver from NuGet packages as build for adding all the dependencies
- Used JIRA as Project management and Bug tracking tool.
- Performed Data Driven Testing (DDT) using Scenario outline and Examples.
- Implemented logic to read data from the Excel to achieve functional testing with different data
- Performed mouse actions using Selenium Actions API. Implemented web element locators using Selenium WebDriver - By ID, Class, Name, CSS Selector, Xpath and Link .
- Documented all the scenarios of the test cases.
- Used SpecFlow for continuous integration and delivery in order to execute them automatically after every successful deployment.
Confidential, Houston, Texas
.Net/Mobile/SAP QA Lead
Environment: .Net front-end applications, Mobile apps testing (iOS, Android) manually & Automation using QTP & Selenium, SAP (Supply Chain & HANA module) & NON- SAP internal applications
Responsibilities:
- Preparing high level and detailed test plan for the project
- Writing Test cases, Review, Requirement traceability analysis during Test Design phase
- Test Execution (Smoke Testing, New Features, Regression, Integration, DB, UAT), Defect logging defects and follow ups (Defects re-testing) in HP ALM/ HP QC, TFS
- Writing complex SQL/PL SQL queries for database validations and reporting
- Creating test scripts using C# and Selenium Web Driver for the functional test cases.
- Designed and developed BDD/TDD/ATDD framework by using the Spec Flow(Cucumber Specification) and added Scenarios in features files, Step Definition
- Providing estimation for the UAT testing co-ordination activities
- Co-coordinating the UAT testing activities
- Preparing ALM instance for the project and creating test bed for regular UAT and Dress Rehearsal phase
- Uploading UAT test cases to HP QC/HP ALM
- Regression and New Features testing manually & on quarterly & Off cycle basis on iOS and Android devices
- Regression suite execution for mobile apps using Selenium, web services testing using agile/scrum methodology
- Developing automation Frameworks and writing complex automations functional scripts for regression and new features implementation.
- Training UAT users on HP QC/ ALM tool for testing
- Managing defect calls during UAT & Dress Rehearsal phase
- Publishing daily, weekly & monthly reports on Test Execution and Defects summary
- Co-coordinating with different stake holders of the project like CSL - Customer Support Lead, Developers, Project Manager and Business to accomplish the UAT testing
Confidential, San Francisco, California
QA Analyst
Environment: iOS (iPad & iPhone), Android and hands on blackberry & windows devices testing, Mac OS X Lion 10.7.4, Objective C, Automation testing, Manual Testing, HP QC/ ALM 11, Mingle (Defect tracking tool), DevOps: SpecFlow
Testing Methodology: Agile & Waterfall: Automation Frameworks: BDD/ATDD (SpecFlow), TDD, Data Driven, Keyword, Hybrid driven
Responsibilities:
- Leading a team of 6 QA Engineers (Regression project).
- Participating in the requirements analysis and design meetings with DEV, BIZ team for Review and facilitate in requirement freezing.
- Planning all the testing activities (Test Planning, Test Estimation and scheduling of QA activities, Test Strategy, Test Case Design, Requirements Traceability matrix, Review, execution and Reports)
- Planning and execution of Installation Testing, Smoke Testing, Functional Testing, Regression Testing, Integration Testing, System Testing, usability testing, Compatibility Testing, Business Reports Testing, Performance Testing and security testing.
- Implemented Agile methodology with Scrum framework as Software Development Life cycle with 2 weeks of Sprint cycles and coordinated well with team members, lead, project manager.
- Used C# as a programming language and Visual Studios as IDE for automating the Test Suite with Selenium WebDriver.
- Designed and developed Hybrid Framework using . Net, C# and NUnit .
- Used Page Object Model (POM) repository design pattern for storing all the web elements for code maintainability and reusability for Selenium automation
- Executing the test cases (manual and automated) and reporting the bugs in Mingle and QC/ALM.
- Worked on different kind of WebElement locators like ID, Name, CSS Selector, Xpath for identifying the fields
- Followed the Continuous Integration DevOps process using SpecFlow for building & production
- Mentoring and Monitoring the QA Team, troubleshooting any technical problems.
- Collaborating with development team and project managers in test execution and communicating all the issues.
- Generating project status reports/metrics and updating project plans and Tracking them.
- Coordinating and leading the reviews and inspections and follow up on ongoing test activities.
- Conducting QA status/Defect triage conference calls with Clients and reporting the status to QA Manager.
- Providing regular feedback/status on development and projects to Project Manager.
Confidential, Memphis, TN
Test Lead
Environment: Windows OS, .net Framework, Manual Testing - Functional Testing, win- frames, Automation testing using QTP/UFT, Load Runner
Responsibilities:
- Co-ordinate with Development team for Testing methodology and impacted Apps details
- Performed GUI objects testing
- Providing impacting apps details for Offline products when requested by TQAs for their respective ITGs
- Functionality testing of different platforms (CAFÉ, FXRS, GSM, FXI/A)
- Test Status Reporting to Confidential Manager & Client Test PMs, TQAs, Confidential Leads/Manager s including Functional Test Leads.
- Work with Offshore Team member’s w.r.t the offline products, which are under Test impact for specific Load and ITGs, during Test Design & Test Execution and provide project updates or clarification.
- Attend DTPS and WPR walkthrough, conducted by TQAs and provide inputs as and when required
- Attending Status meeting conducted by TQAs
Confidential
Test Lead
Environment: Windows OS, .net Framework, Manual Testing - Functional Testing, AUTOMATION - QTP, VB SCRIPTING, Load Runner - Performance testing
Responsibilities:
- Involved in Co-ordination between Development Team, Test PMs & Offshore Team with respect to Functionalities of the Product.
- Supported Development team with UNIT testing performing Smoke testing, Installation of the application, Build delivery.
- Involved in the creation of the architecture of Automation framework for the modular approach undertaken for automation (Smash Functionality)
- Attending SRS Walkthrough, Defect Call, TQA Call and Development Sync call.
- Involved in Scripting for the Functionality Features using Descriptive Programming.
- Executing & Debugging Test Scripts.
- Involved in Test Design activities like Estimation of Test cases referring to SRS, Test Case Preparation, Peer-Review, and Review and Revamping of Test cases according to the latest SRS available.
- Manual and Automation testing and logging defects in Quality Centre.
- Involved in New Installation, New Feature and Regression testing across the DASQA builds.
- Involved in System and Integration Testing.
- Involved in GUI, Functional and Smoke testing to ensure Build turnover to Functional Testing Team without any critical Issues.
- Adding requirements into Quality Centre, Mapping Requirements with Test cases.
- Documenting defects in Quality centre
- Performed data driven test-using QTP for functional testing
- Defect entry and Defect Validation logged by Functional and UAT Testers thus supporting Development Team to Fix the Issues.
- Co-ordination with the new team members and giving them insight about the Confidential .com domain
- Co-ordination with the onsite team, communicating with them on Weekly basis if needed for any clarifications on the product.
- Involved in maintaining Process Oriented documents like Test Plan, WSR updating to VSS, documentation of MOM (minutes Of Meeting) on weekly basis and Quality Reports like Casual Analysis Report, Test Metrics.
Confidential
TESTER
Responsibilities:
- Preparation of Test cases based on the functional Specification document.
- Involved in Functional New feature and Regression testing.
- Execution of Test cases manually and Test scripts using Win Runner.
- Test Management through Quality Centre
- Creation and execution of test scripts
- Reporting bugs using Icene Bug tracking tool.
- Involved in communication / coordination with client or onshore team
Environment: Quality Center, Windows XP, MS Excel, MS Word
