SUMMARY:

• QA Engineer with 15+ years of combined experience in automation testing and data analysis. Very focused on attention to details and experienced with front and back end systems.
• Excellent interpersonal skills, both verbal and written, to create strong relationships with testers, developers and management.
• Outspoken when needed to challenge team members to ensure the highest level of quality is implemented within the products.
• Very detailed, organized and thorough with documentation.
• Able to escalate issues to achieve prompt resolution, to ensure work performed conforms to the scope of work as directed by the product owner and customer.
• Strong analytical skills to identify and perform root analysis of issues, correcting and preventing problems/defective services.
• 8+ years Scripting Language Experience (Java, Ruby, Python, Bash). Conversant with SQL queries.
• Experienced working closely with the Manager to develop Risk Analysis, Mitigation Strategies Test Plans, Test Schedules, and Time Estimates for testing activities. These activities include system validation through test preparation and test execution of system, integration, and regression testing.
• Experienced writing and executing manual (in JIRA’s Zephyr) and automated test cases (in Selenium / HP’s QC and QTP) to verify and validate the user stories.
• Experienced working and leading in a fast pace environment: coordinated all testing activities involved in the migration of the functionality from the existing platform to the new platform. Coordinated all test case reviews with the product and DEV teams.
• Experienced reviewing documentation and providing comments and recommendations.
• Experienced interacting with multidisciplinary project team members and Government personnel.
• Experienced with JIRA.
• Familiar with methods and standards for continuous process improvement.
• Experienced in prioritizing test cases and assessing requirements for testability and risk assessment to develop risk mitigation.
• Experienced in handling critical business issues alongside support teams to ensure complex test issues are resolved in a timely manner
• Experience with databases with millions of records.
• Experience with documenting using SVN.
• Experience designing and developing SSIS packages.
• Experience with SSIS and SQL Server 2008 Management Studio.
• 5+ years Automation experience with commercial/open source tools (Selenium, WATIR, HP’s Mercury)
• API testing
• .Net Test Framework
• Web services testing

TECHNICAL SKILLS:

Knowledge: web applications, web services and XML - based technologies.

Tools: SQL queries using SquirreL, MariaDB, SQL Server 2005 and 2008.

UI automation using: Java, Ruby, Selenium, Cucumber, Rspec, Python, VBScript, HP QC, QTP, CQTM

Defect tracking and reporting: JIRA, Remedy, Microsoft Excel (pivot tables, macros).

Documentation tracking: SVN, GIT hub.

Operating Systems: Windows Server, Windows 7, Linux

PROFESSIONAL EXPERIENCE:

Lead QA Engineer

Confidential, Alexandria

Responsibilities:

• Worked in a very fast paced agile environment where meetings were held daily, and on a weekly basis we dealt with items from the backlog. We had 1 month sprints.
• Established earlier on a reputation for reporting critical and high severity issues and gained the respect and trust of the developers.
• Successfully tested the GA 2.0 and GA 3.0 releases of the company, which are becoming Fishbowls’ flagship products
• Automated the testing of the UI for key features using Java and Selenium and database data retrieval using jdbc libraries. The automation is used to give early warning of the daily reports for 11 clients, to check performance and to provide comparisons with backend values. The automation is now kept by the India team.
• As QA lead within the QA organization, volunteered to share information as it relates to test or project progress. I challenged the team members when it comes to efficient testing practices. Asked thought provoking questions on platform features and functionality in order to gain a deeper insight into the inner workings of the GA platform.
• Became a valued asset to the product team as well.
• Provided my opinion and expertise to designing the functional requirements for GA, ensuring the QA perspective gets cross to the various stakeholders within FB.
• Provided daily feedback to the team on the current status and the progress on the issues found
• Mentored two junior QA engineers pointing out places where they can improve and strengthening the team in India by empowering and supporting their decisions.
• Made frequent use of communication tools such as join.me and skype (chats) to keep abreast of the quick changes.
• Communicated daily with my manager to get her advise on issues ranging from technical to people relations. She trusted in my judgement and I appreciated her insights and intuitive grasp of challenging situations.
• Became well versed in the GA Data Model as it relates to its implementation within the MariaDB and Hadoop stack.
• Created complex SQL queries to validating the complexity of the data model.
• Traveled to Sta Clara (Silicon Valley) office to get trained in Hadoop/Drill. I met with the engineering team and got to build strong relationships with them.
• From net sales to discounts to promotions and campaigns, I tested and learned the ins and outs of the analytics for restaurants. The data is managed in a hadoop farm with many nodes and edge nodes and it also relies on Maria DB and MS SQL.
• Tested tagging which is a way to select a group of members and to send email / SMS: I verified that the oozie job runs on schedule and in synch with the ms sql job and that the members actually get the email / SMS.
• I verified that the tables in the dimensional model have integrity by running a set of queries written by the data architect that look for Primary Key errors, KPI errors. In doing so we detected several cases of duplicates that escaped the UI testing.

ETL Senior Tester

Confidential, Rockville, MD

• Testing the Pulmonary Function Tests Report that includes data from HL7 and db sources.
• Automating the performance testing of the PDF report downloads using Selenium with Ruby.
• Tested the Stem Cell Data Report project with data from multiple sources, verifying that the dimensional model is correct.
• Tested the Laboratory Report to ensure that the meta-data tables and the Entity Dictionary contain the consolidation by criteria specified in the business rules.
• Tested the Medications Report for a critical issue that was identified by the support team.
• Tested the migration from Cognos 10.1.1 to Cognos 10.2.2
• Created the Test Plan, Traceability Matrix and Test Cases for a fast pace project that is intended to bring Lab, Demographics and Questionnaire data into a database via spreadsheets. Interacted with the Validation and Verification team, the Coding Team, the ETL team, the Test team, the Project Manager and the client. Produced reports that show number of issues per round of testing. Used JIRA to report the issues.
• Used the traceability matrix to ensure all requirements were covered during the test.
• Created Level of Effort Estimates
• Tested a web page that is used to enter clinical trials results into clinicaltrials.gov. The test involved creating ruby scripts to automate multiple pages and repetitive actions. xml files were tested and transmitted to the Clinical Trials.gov web service

Mid-level ETL Developer

Confidential, Rockville, MD

• Implemented a SSIS package to extract data from the source. Three types of data were extracted according to the mapping document. The data set was loaded into Testing and tested by the QA Team. The final set was deployed in Production.
• Created a stored procedure to eliminate duplicated GUIDs for Events and Observations across different tables. Discussed and documented the approach with peers and management. Ran the procedure in Testing and communicated with the Test team to start the testing cycle.

QA Analyst

Confidential, Rockville, MD

• Analyzed and tested the BTRIS data warehouse, which uses different NIH Medical sources.
• Used existing queries to search for common database ETL errors such as Null values, inconsistent record counts, missing and duplicated data.

QA Analyst

Confidential, Vienna, VA

• Assisted the client with the User Acceptance testing effort for several versions of OTrak (Oversight Tracking System), which tracks government grants.
• Implemented a methodology for test automation using QTP.
• Trained two team members on how to use the Excel add-in to import Test Cases into QC.
• Contributed to clarifying the testing of a security feature requested by the client and to enhancing the stability of OTrak.
• Created test estimates for several FTA’s applications.
• As CM Manager, kept the client abreast of the schedule for publishing new releases.
• Participated in product definition sessions with the client in the FTA headquarters in DC.

System Test Lead

Confidential, Reston, VA

• Developed testing strategies, plans and test cases for a large IT system. Tested a four layered framework: ETL, Data Access, Processing, and Web Service. Created and populated large databases with ETL tools.
• Installed web-based and service-oriented architecture modules.
• Wrote a Test plan that includes Risk Assessment, Time Estimates, Software/Hardware needed, and Test Strategy.
• Tracked the configured test cases and defects found in ClearQuest TestManager.