SUMMARY:

• Over 9+ years of experience in Quality Assurance and Information Technology, involving analysis, Manual and Automation testing of data warehousing applications, web services and web applications.
• Strong knowledge of Software Development Life Cycle (Requirements Analysis, Design, Development, Testing, Implementation, Support)
• Expert knowledge in creating Test Plans, Test Cases, Test Scenarios and Test Strategies, Defect Management to ensure Quality Assurance and to test all the business requirements.
• QA Automation for Web and mobile applications Testing using tools like Selenium, Cucumber, JUnit, TestNG
• QA Automation for REST API Testing using tools like SoapUI and java third party libraries
• QA Automation for ETL Testing using tools like SSIS, Talend, Selenium
• Writing complex SQL and NoSQL queries for Data Quality and ETL Testing
• Experience in Business Intelligence testing in various reporting tools like Business Objects, SSRS.
• Good team player with team leader experience in delivering multiple projects, interacting with Project Managers and Technical Lead to help create project plans using tools like Jira and SmartSheet, communicating all development and test requirements to ensure a proper project delivery.
• Fluently speaking English and French

TECHNICAL SKILLS:

Testing tools: Selenium, Cucumber, Capybara, JUnit, TestNG, Talend, SSIS (Visual Studio SSDT), Oracle Dataload, Testrail, ALM, Charles Proxy, jMeter

Programming: SQL, Java, Ruby, C#, VB, JavaScript, Apache Hive, Sqoop, HTML, XML, XPATH, Shell Scripting, Swift, PHP

Data Tools: Talend for Big Data, SSIS, SSAS, SSRS, SAP Business Objects, Oracle Discoverer, Excel, Tableau

IDE: Toad, Oracle SQL Developer, SQL Server Management Studio, Microsoft Visual Studio, Eclipse, Talend Open Studio, MySQL Workbench Android Studio, node.js

Verticals: Pharmacy, Laboratory, Supply Chain, Manufacturing, Asset Management, Telecom, Zoology

Database: Oracle 11g, SQL Server, MySQL, MS Access, PostgreSQL, Hadoop, HBase, SQLite, DynamoDB

Office Tools: Visio tools, MS - Word, Excel, Access, PowerPoint, Outlook

WORK EXPERIENCE:

QA Automation Engineer

Confidential, Greenwood Village, CO

Responsibilities:

• Responsible for testing the spectrum.net applications
• Writing and maintaining test plans, test scenarios and test scripts for regression testing documentation in TestRail
• Performing both manual and automation testing
• Developing and maintaining the QA Framework based on Selenium RC
• Writing automated tests using Java and Selenium RC
• Executing the automated test using a Jenkins based environment
• Cross browser testing and testing multiple platforms with BrowserStack
• Maintaining test data to fulfill the development need.
• Using GIT to merge the codes, and deploying new features in the QA environment
• Maintaining the QA environment in node.js and Angular.js setting using Docker.
• Performing manual API testing using Postman and the developer tools
• API test automation using Rest Assured
• Validating API data against a NoSQL database
• Using Charles Proxy and developer tools to help the testing effort
• Logging and reporting the automated test results to TestRail through API calls

Environment: Selenium WebDriver, Java, JavaScript, Ruby, Jira, TestRail, Jenkins, Postman, GIT, NoSQL, SQL, XPath, CSS, Mac OS, Windows, Linux, iOS, Android environments, Browserstack, node.js

Senior Automation Engineer

Confidential, Minneapolis Area, MN

Responsibilities:

• Responsible for Web Applications quality
• Developing the QA Framework using Selenium WebDriver from scratch.
• Writing unit tests for our C# .net application
• UI Testing automation using Ruby and cucumber
• Integration of Jira with Cucumber
• Maintaining the test scenarios using Gherkin
• Using bamboo to deploy the new codes in the test server and for test automation execution
• User interface data validation through API calls
• Writing SQL queries for data quality validation in SQL Server.
• Performance testing using jMeter
• Leading the QA team for conducting manual and automated testing
• Actively participated in the transition from manual to automation testing while the company was introducing the agile methodology.

Environment: Selenium WebDriver, Java, Ruby, JavaScript, Gherkin, Capybara, Jira, Jenkins, Bamboo, from SVN to GIT, SQL Server, XPath, CSS, Windows, Linux and mobile environment.

QA Analyst

Confidential, Portland, ME

Responsibilities:

• Designing, developing, tuning and maintaining the QA framework using Selenium, Cucumber, Talend and SSIS packages.
• Designing and developing tables, stored procedures, functions, views, triggers to be used in the QA framework.
• Optimizing and enabling the transformation process to run almost in real time to improve the customer experience
• Performance testing and rewriting long running queries to improve the execution performance
• Performing data profiling to design a data cleansing strategy and data validation
• Performing integration testing and identifying data quality issues
• Generate test data for all ETL mapping rules to test the functionality of the transformation package.
• Automating the RESP API using Java Rest Assured library
• Unit test of the java classes using JUnit.
• Preparing Test Strategy, developing Test Plan, Detailed Test Cases, writing Test Scripts by decomposing Business Requirements, and developing Test Scenarios to support quality deliverables and to ensuring an accurate coverage of requirements and business processes.
• Developing and maintaining the test framework for the store admin and storefront applications (magento)
• Leading a team of one onsite QA and five offshore members
• Working closely with the Project Manager handle the QA team sprint tasks and setting the team goals

Environment: ETL testing tools: Talend, SSIS (Visual Studio SSDT), Selenium, Cucumber, Postman, Testrail

Programming: SQL, Java, C#, JavaScript, Apache Hive, Sqoop, HTML, XML, XPATH, Shell Scripting, REST API

Data Tools: SSIS, SSAS, SSRS, Talend for Big Data, Excel

IDE: SQL Server Management Studio, Microsoft Visual Studio, Eclipse, Talend, MySQL Workbench, Windows & MAC OS & Mobile, Amazon Web Services (RDS, EMR, EC2, SQS, Workspace)

Verticals: Pharmacy

Database: SQL Server 2012/2014, MySQL, Hadoop, HBase

Database QA Engineer

Confidential, Westbrook, ME

Responsibilities:

• ETL testing for our analytical and transactional databases.
• Performing Integration, End-to-End, system testing, functional & regression testing of the LIMS (Laboratory Information Management System)
• Developing and maintaining the Automation Framework for the LIMS (Laboratory Information Management System) using Selenium
• Testing web screens using JSF (primefaces), HTML, XHTML and CSS using Selenium
• Unit testing of the mapping between relational database tables and object oriented java objects using Hibernate.
• Testing Hibernate concepts such as inheritance, lazy loading, dirty bit checking, optimistic locking, and transactions.
• Integration testing of LIMS components with a REST based web service
• Made proficient use of JSON and XML files
• Wrote JUnit test cases for every java class
• Automating a RESP API using SoapUI with Groovy
• Data quality for the Image Data Management
• Performing data mining and data analysis from Hematology, Chemistry and Urine analyzers to identify data application problems
• Automating SQL reporting
• Using Selenium and SSIS to test data from an Oracle database and a JSON files, serving the analytical for reporting
• Performing data mining and analysis tasks: Analyzing and resolving data application problems of high complexity
• Testing reports under SQL and BI tools (SAP Business Object)
• Supporting the product development with various reporting and analysis about the data quality issues
• Performing Software development testing using Selenium and Java programming

Environment: Selenium, Rest api, Talend, SSIS, Data Analysis, SQL queries, Business Object reporting, Software Testing

Business QA Analyst

Confidential, Lewiston, ME

Responsibilities:

• Participate in the design of the Requirement analysis document
• Manual and automation testing
• Conduct UAT with the end users during the implementation of Oracle E-Business Suite (Manufacturing and Supply Chain Applications).
• BI report testing
• Data migration (ETL) testing from legacy system to an Oracle database
• Providing developer Support and maintaining testing materials
• Leading a team of one member and mentoring the junior analysts