SUMMARY:

• Software QA experience in numerous areas including data quality, ETL, automation, integration, report, performance and API testing
• ETL/Data Quality testing in Data Warehouse in the online advertisement industry
• Created automation test framework for Web Application using JUnit and Selenium integrated with Jenkins
• Leadership QA role in multiple projects
• Excellent team worker, well organized, detail - oriented and strongly committed to make things happen

TECHNICAL SKILLS:

Programming: Java, AWS SDK, AWS CLI, SQL, Bash script, JavaScript, Ruby on Rails, XML, cron, JSP, HTML, C++, T-SQL, PL/SQL, Stored Procedure

Operating System: UNIX, LINUX, Windows, Mac

Databases: Redshift, MySQL, Greenplum, Oracle, Sybase ASE, SQL Server, IBM DB2

Test and Automation: Selenium Webdriver, JUnit, TestNG, JMeter, Astra QuickTest, Win Runner, JRun, Gomez

QA ant Tool: TestLink, JIRA, Bugzilla, Mantis

Big Data: AWS (Redshift, S3, Data Pipeline, Athena, EMR), AWS CLI, Pentaho, Datadog, Tableau Desktop, Tableau Server

Other Software/Tool: Apache Ant, Jenkins, Git, WebLogic, ATG, SQL Workbench, Postman, Oracle SQL Developer, iPlanet LDAP, XML Spy, VITRIA Businessware, FitNess, VMWare, Eclipse, Star Team

PROFESSSIONAL EXPERIENCE:

Confidential, San Francisco

Senior Software Engineer in Test

Responsibilities:

• Back End and Data QA
• Conducted ETL and Data verification by writing and executing SQL on System developed on Pentaho and AWS
• Created Regression Test for ETL using SQL and Tableau Report, and send daily test result/alert
• Conducted Data QA by monitoring data using tools such as Tableau and Datadog
• Reviewed, analyzed and validated ETL logics to satisfy business requirements by working closely with Developers and Product Team
• Created Java Libraries to control data in S3 and Redsfhit using Amazon AWS SDK
• Verified Data, Data Aggregation and Reporting System developed on Greenplum and Ruby on Rails
• Conducted Ad delivery testing on Advertisement Delivery
• Tested ETL developed on Data Pipeline(AWS) with EMR in AWS by manipulating test dataset and result set using SQL and AWS CLI
• Exposed in testing Hive and Hadoop
• Front End, Report and Integration Testing
• Planned and conducted manual and automation functional testing on In-House Web Application for Advertisement Purchasing and Insertion Order Console
• Verified functionalities, calculation logics and data in Tableau Report and Tableau Data Source
• Verified Reporting System developed with Ruby and Rails and Greenplum
• Conducted integration testing, and debugging multiple applications by digging into Code and analyze logs
• Automation Testing
• Developed, managed and executed Selenium Webdriver Automation scripts for Advertisement Console
• Migrated the framework written in Windows’ environment to Linux
• Integrate the automation framework with Jenkins for daily execution
• Wrote scripts to automate data test setup and execution
• QA Leadership role and Quality Sessions
• Managed and schedule the sprint commitment for team members
• Managed offshore team members and reviewed their work
• Mentored team members by reviewing their work as well as having sessions to discuss data test methodologies to promote test quality
• Coordinated Dev and Product Managers with requirements clarification and test plan agreement
• Discussed with Dev and Architect about application designs and implementations
• Discussed and defined tests requirements conducted by Developers for Report Development on Tableau
• Promoted TDD for ETL testing to QA team, and supported the test case and execution

Confidential, San Francisco

Quality Assurance Engineer

Responsibilities:

• Introduce and build frameworks for automated regression testing using JUnit and Selenium
• Introduce JMeter as a performance test tool. Manage the creation and execution of test scripts
• Develop and execute manual functional test cases for the store catalog system, web sites, and its ATG-based backend system
• Conduct various tests for backend jobs including shell scripts and PL/SQL
• Develop QA automatic build script in corporate with an existing build system using ANT
• Conduct Session Failover testing for a new web server
• Involved with web application design discussion with product managers to identify customer needs
• Contributed in a fast-paced Scrum style project in conjunction with development operation, project management, DBA, and business owners throughout the Sprint to identify and resolve bugs in new features
• Test the mobile version of the website on iPhone and Android

Confidential, San Francisco

Sr. Quality Assurance Engineer

Responsibilities:

• Conducted manual testing of Web applications
• Conducted backend testing on SQL Server database
• Developed and executed test cases based on Requirement Documentation
• Documented and reported various software problems found during the test and entered them into the Bug Tracking database

Confidential

Applications and Analyst Software Engineer

Responsibilities:

• Summarized and prepared requirements document for development, testing, and maintenance of software application systems after direct negotiations and discussions with End Users
• Conducted black box and white box testing of new or modified software modules
• Coordinated full User Acceptance Tests of software applications between Developers and Users
• Planed, designed, created and maintained database models for software application systems
• Migrated required data between various systems for mandatory application data quality management
• Conducted various data update and transferring, and other in house application modification requested by users
• Maintained existing database related shell scripts.
• Implemented and tested middleware interfaces using Vitria Businessware and XML technologies including, XML, XSLT, SOAP that connect various databases such as Bond systems
• Documented and reported the implementations of middleware projects. Also created test plans and results

Confidential, San Francisco

Investigative Software Engineer

Responsibilities:

• Investigated, verified, fixed, and tested Confidential portal product, pure Java application) issues including clustering defects reported by customers
• Created and sent patches to customers with instructions: put the fixes into build
• Implemented new features for Confidential upon customers’ request
• Developed and executed test plans and test cases for new features or fixes
• Working closely with DevOps, customer support, other engineers and product management teams to solve these issues
• Contacted customers directly for rush requests

Confidential

Java API Analyst / Tester

Responsibilities:

• Designed and implemented JUnit Test Harness, an in-house API testing application, using Java with Swing and multi-threading. This application executes all of the API Unit Test scripts in any order
• Developed, executed and maintained Unit Test plans and Unit Test scripts with JUnit for entire Confidential API