OBJECTIVE:

Explore and identify challenges, implement solutions to minimize cost and raise quality.

SUMMARY:

• Experienced in Waterfall and Agile SDLC, System Testing Standards, validation, manual and automated testing of Web - based and Windows-based of financial, brokerage, pharmaceutical/biotechnology, telephony, utility and engineering applications. Knowledgeable of 21 CFR Part 11 and other FDA regulations. Experienced in end-to-end testing including white box testing, black box testing and database testing. Excellent experience with Workflow, Integration, Web Services, ETL, BI, Performance and Automation Testing. J2EE, .NET, AJAX, Data Warehousing concepts and API knowledge.
• Expert in test documentation: Test Plan, Validation Plan, Test Strategy, Test Cases, Test Scenarios, Bug Report, Status Report, Test Summary Report, IQ, OQ and PQ reports. Working knowledge with variety of software and testing tools. Understand applications from a technical, as well as business perspective; proven track record in on-time delivery and high customer satisfaction.
• Good judgment and analytical skills, self-starter, capable of independent action and decision-making and comfortable working both independently or as part of a team. Strong interpersonal skills and leadership skills.
• Quick learner. Creative, and can present ideas toward improving testing practices through use of automated test tools or modified test methods. Handle multiple priorities and sustain a high level of performance while under pressure. Able to excel in a fast-paced environment with a can-do attitude.

TECHNICAL SKILLS:

Operating Systems: Windows 10 and Earlier, LINUX/UNIX (SOLARIS), MacOS, MS DOS

Software: MS Office Products, Lotus Notes, Citrix, DBArtisan, Toad, SQLDeveloper, SQLTools, SQL Navigator, MyOra, AutoCAD, ClearQuest, ClearCase, SFDC, MS Visual Studio, MS Visual SourceSafe, Git, Perforce, MS Project, Primavera Project Planner, Remedy, QADB, StarTeam, Bugzilla, Jira, R22-Subscraber, TIBCO, SupportLogix, WebLogic Console, SNMP Console, SnagId, XMLSpy, VMware, WinSCP, Cygwin, putty, SSH, CyberDuck, Rally, Red Gate, Beyond Compare, Eclipse, Splunk, Kibana, Slack, Siebel, SAP, Denodo

Databases: Oracle, MS SQL Server, MySQL, DB2, UDB2, Sybase, PostgreSQL FoxPro, MS Access

Testing Tools: Visual Test, Rational Suite Performance Studio, QA Partner, SilkTest, SilkPerformer, WinRunner, LoadRunner, SiteScope, Dynatrace, Astra Quick Test, Astra Load Test, Test Complete, Quick Test Pro, Quality Center, Empirix suite (eTester, eLoad, eReporter, eMonitor, Bean-test), NUnit, JUnit, JMeter/BlazeMeter, Fiddler, Firebug, VisualVM, SoapUI Pro, Postman, Jenkins, MS Visual Studio Ultimate Load Test

Languages: C/C++, C#, JAVA, JavaScript, VB, COBOL, PL/SQL, HTML, XML, Perl, 4Test, TSL

PROFESSIONAL EXPERIENCE:

Confidential, San Francisco, CA

Senior Performance Test Engineer / Synthetic Data Development Team Lead

Responsibilities:

• Conducted API Load, Spike, and Stress, Volume and Endurance performance tests for AWS APIs, RESTFUL and SOAP Web Services. Led performance testing for PayPort, Pelican, A-Mart and PWS projects utilizing HP Performance Center (LoadRunner) and JMeter/BlazeMeter tools.
• Designed and executed UI Load, Stress and Endurance performance tests for BIC eStore, GUAC, Products’ Portal and SFDC applications hosted in AWS hybrid of private and public cloud using TruClient-Web and HTTP based protocols for script creation. Automated SAP performance test using SAP-Web protocol. Performed API functional test using Postman.
• Built Load and Stress tests for SFDC cloud databases, utilizing jMeter and Denodo with JDBC drivers.
• Created new, updated, and debagged existing performance scripts. Configured scripts and performance scenarios to run in Development and Staging environments. Converted LoadRunner scripts to JMeter scripts to be run in CI/CD Jenkins Pipeline.
• Created Stored Procedures and SQL scripts to generate testing data in Oracle and MSSQL databases.
• During the test run, monitored application and database servers using Sitescope or Dynatrace Monitoring tools and New Relic monitoring console for Ruby servers.
• Analyzed performance test results, abnormal servers’ behaviors, bottlenecks, performance related errors, and then generated performance reports with recommendations.
• Created data storage schemes to collect and manipulate Performance and Automation data for various projects. Created out of shelve APIs, templates and report-queries for End to End (User Experience) Performance test. Migrated data storage DBs from Ms.SQL Server to AWS Cloud Aurora MySQL DB engine.
• Led the Synthetic Data development team. Built framework and automation scripts for multiple data entry points: eStore, User Services, Order Services, Siebel, SAP, AOE, SFDC, PWS and etc. Created Audit database for Synthetic data promotion into the new Staging environment. Created automation scripts to validate data synchronization between SAP, Siebel, SFDC and LEM, and to verify data quality in staging environment after Synthetic data loaded into the databases.
• Using Synthetic Data blocks, imported Accounts with affiliated Contacts, Opportunities, Leads, Cases, Contracts, and Entitlements into SFDC employed Apex Data Loader.
• Developed Performance Test Plans, Test Strategy, Test Cases, and Summary Reports. Provided Testing Strategy Presentations to the Development teams. Submitted Weekly Progress reports to the management.
• Actively collaborated with Performance, Automation, and Data teams in Singapore and India.
• Created materials and gave actual to the junior members of the Performance team.

Confidential, Redwood City, CA

Senior Software Quality Engineer

Responsibilities:

• Created Functional, BI, and Performance Test Plans, Test Cases, Test Scenarios, Specifications, Summary Reports, OQ, PQ, Test Data and complex SQL scripts and stored procedures for variety of testing tasks. Sized projects and scheduled tasks for QE team members involved in project. Determined technical issues and solutions, convey bug reports, and project progress reports.
• Conducted black and white box test for Confidential Physician Portal. To cover for all passible data-related conditions, created multiple XML sample files to perform Requisition Stamping services’ testing. Performed Requisition Stamping Unit testing for all the Mappings using NUnit tool.
• Tested Integration between Physician Portal, SARP (CRM) and StarLims applications. Through Enterprise Service Bus performed test of data transactions round trip via web services between Physician Portal, SARP and StarLims applications.
• Involved in integration of SFDC platform for Requisition Order System (SARP) and StarLims applications. Tested SFDC data migration and crated testing mockup data when needed. Created Test Strategy for APIs and Component Performance Testing for integrations with SFDC.
• Tested newly created or/and enhanced ETL scripts, stored procedures and SSIS packages.
• Led the QA effort to test customer BI reports generated through SSRS to ensure the accuracy of the reports.
• Performed testing for database synchronization, data migrations and replication processes. Tested any database schema changes and performed regression tests for modules of applications affected by those changes.
• For better performance optimized query structure in BI reports, stored procedures, SSIS packages and added indexes when needed.
• Designed and implemented lab for performance testing. Evaluated performance tools for company use.
• Conducted scalability, load, stress and endurance performance tests for GHI Web Based applications and BI reports utilizing MS Visual Studio Ultimate Load Test and jMeter tools. Created stored procedures and SQL scripts to generate performance mockup data, backup/restore and cleansing data after the test. Collected performance and servers’ counters data during the test and then analyzed performance testing results and created reports for development and management.
• Based on performance results tuned the servers’ parameters to improve performance and gave recommendations to the development and database teams.
• Actively collaborated with project managers, sales, marketing and production data groups. Provided Production technical support as needed.
• Provided technical leadership and mentoring to QE team members. Gave presentations for performance testing to the management. Created materials and gave actual to the QE teams.
• Managed and coached offshore QE automation team of four engineers.

Confidential, Foster City, CA

Senior Software Development Engineer in Test

Responsibilities:

• Performed full range of SQA and Validation Testing activities for Smart Grid Billing Utility segment of Energy IP application.
• Promoted builds deployments into SQA environment. Verified that Billing Applications: Billing Export Module, Billing Loader, Billing Reads Processor, Billing Change Event Monitor, Billing XML File Import Adapter and Billing Import Adapter JMS are up and running and stable to be tested.
• Configured Billing Import Adapter JMS Properties in Energy IP System Console. Created in Siebel applications or in database and then configure attributes, parameters and properties for Data Delivery, Data collection, Energy Purchase, Retailer, Framing, VEE and Billing Services.
• Created Test Plan and Test Scenarios for Asset Validation, Meter Swap, Account Change, DDS-Measurements Profile change, Price Change, Rate Change and CTPT change Events. Created test scenarios for Interval, Start and End Registry Reads validation. Based on these scenarios and data model created SQL scripts to populated SID data using Toad and SQLTools.
• Using scenarios for End to End web service testing created multiple Billing and Assets’ requests files in .XML format to cover all possible data permutations and conditions.
• Perform automated function and load tests of SOAP based web services for JMS messaging layers utilizing SoapUi Pro tool.
• Automated test scenarios by using Shell scripts, Templates, config.yml, environment.yml, composits.yml, external SQL scripts and multiple flat files. Developed functions and scripts using JRuby and build them into existing Ruby on Rail framework. Executed automation scripts using Expertus while monitoring MQ TIBCO messages in R22. Maintain automation framework and install latest GEMs versions when required.
• Created materials for Applications Deployments, Manual and Automation scripts execution following sequence of applications execution flow.
• Actively participated in daily Scram and Sprint meetings. Created Stories, Tasks and sized the Tasks utilized Jira.
• Analyzed, investigated and reported application’s and database performance issues.
• Actively collaborated with development and SQA teams in Noida, Uttar Pradesh, India. Provided Production technical support as needed.

Confidential, Ross, CA

Senior SQA Analyst/Technical Lead

Responsibilities:

• Led a team of QA Engineers through the entire Project Life Cycle. Verified the project goals; met current and long term corporate objectives. Pioneered cross-functional programs to expedite workflow to simplify process and reduce operation cost.
• Coordinated QA team efforts for the assigned initiative. Estimated quality assurance effort on approved projects. Owned and managed test environments and processes. Prepared test strategy for each application release. Coordinated on project test planning and test execution schedule. Supported all quality initiatives that are implemented during each phase of the SDLC.
• Led QA "Best Practices" implementation effort. Created material for the latest software releases and enhancements.
• Actively participated in daily Scram meetings, "Playing Poker" and Sprint Planning meetings, From time to time took Scrum Master Role to Create Stories, Tasks, sized the Tasks for SQA and assigned the Tasks to the SQA team members utilizing Rally software. Worked daily with development and SQA teams onsite in Ross and offsite teams in New York NY, Edison NJ, Conshohocken PH, Austin TX, London GB, Tokyo JP and Bangalore India.
• Performed full range of SQA and Validation Testing activities for Medidata TPS and TSPD products: Medidata Designer, Grants Manager Planning, Grants Manager Analysis, CRO Contractor, Grants Manager Contractor, Quick Price Lookup, and Medidata Rave.
• For each release created Test Plans, Performance Validation Plans, Test Scenarios, Test Cases, Bug Reports, Validation Candidates Forms, Validation Summary Report, Manual Operation Qualification and Performance Qualification Reports.
• For Validation test created automated test scenarios in Cucumber/Watir/Ruby. Executed these automation scenarios in Columbo to generate validation screenshots in HTML format. Build Validation Portal segment for TPS products and maintained the portal for each release of TPS applications using CyberDuck server uploading software.
• Tested web services data transactions. Created multiple sample files in XML and JSON formats for testing to cover all data permutations.
• Build and then maintained Performance lab. Conducted Scalability, Isolation, Load, Stress and Endurance types of Performance tests. For a designer application that uses t3s protocols, created a custom performance test suite to run java emulators. Designed and created Perl and Shell scripts for custom test execution and reporting. For GMP and QPL applications created Performance test suite utilizing jMeter. For GMC application performance test suite utilized SilkPerfromer. For Web API, Web Services, Database performance tests used jMeter. Benchmarking and tuning WebLogick, NGINX (Ruby on Rails), Oracle and MySQL database servers. Monitored database performance using MyOra and then optimized the query for better performance.
• Performed database Normalization and Integrity test. Created Stored Procedures and PL/SQL scripts to create, update and delete testing data for all TSPD and TPS products. Exported testing data from local to on cloud databases.
• Activity collaborated with Sales, Marketing and Production data groups. When Provided Production technical support as needed.
• Provided technical leadership and mentoring to SQA team members. Interviewed potential staff members and provided feedback to management.

Confidential, South San Francisco, CA

Senior SQA Engineer /Technical Lead

Responsibilities:

• Performed full range of SQA Lead activities for Confidential ’s Sales Force Automation Systems - Confidential, TLX, MSA Payer Information applications. Was involved in Proof of Concept SalesForce.com application testing on PC and BlackBerry platforms. Provided hands-on support to SQA team members.
• Actively participated in requirements development, software code review, configuration and change control, and go-no-go decisions to understand and assess impacts from an SQA perspective. Provided technical direction to a Quality Assurance team towards implementation of the technical design. Coordinated QA effort and defined responsibilities, day-to-day planning of all activities related to testing. Developed new testing approaches to accommodate tight schedules and resource constraints. Responsible for QA resource assignments. Provided technical leadership and mentoring to team members.
• Responsible for white, gray and black box testing. Reviewed and debugged C++ and C# code. Performed Unit testing. Tested error handling. Created XML files for web service round trip data transactions. Responsible for testing database synchronization between PDA and PC versions; between PC and MS SQL Server, between MS SQL Server and third party applications with Oracle and Siebel back end.
• Conducted inbound/outbound data exchange testing between Confidential, gIRMS, Re:Source, TLX, Genie, Biogen, gCM, gDW, Stars and Novartis applications. Tested data transactions throughout ESB. Performed test design and SQL scripting for database schema conversion, database cleansing and migration testing. Identified, analyzed and reported database performance issues. Tested databases Normalization and Integrity.
• Created Test Plans, Test Cases, Test Scenarios, Bug reports, Test Summary Reports. Work closely with the project management, development and business teams to set and evaluate milestone criteria to ensure released products are on schedule. Analyzed and reported test result utilizing Rational ClearQuest Bug Tracking System. Conducted defect/triage meetings to monitor the progress of testing.
• Participated in software design reviews, testing, configuration control, reporting, and change control. Worked with project managers to set and evaluate milestone criteria to ensure released products are on schedule.
• Provided technical direction to a Quality Assurance team towards implementation of the technical design. Coordinated QA effort and defined responsibilities, day-to-day planning of all activities related to testing. Developed new testing approaches to accommodate tight schedules and resource constraints. Responsible for QA resource assignments. Provided technical leadership and mentoring to team members. Interviewed potential staff members and provided feedback to management.
• Worked actively with vendors, developers and testers from different departments to isolate bugs. Worked with release management to coordinate builds and install tickets, and with product managers to facilitate and resolve project related issues.
• Administrated Mercury Quality Center. Evaluated Automation tools. Automated data driven test for Replication/Data Sharing test using QTP. Designed and executed Performance and Load testing scripts for TLX application using LoadRunner.

Confidential, Menlo Park, CA

Senior SQA Analyst

Responsibilities:

• Participated in End-to-End testing for Confidential Direct Marketing Services online sites.
• Worked with business clients to determine the scope of testing, test strategy and approach.
• Responsible for establishing, maintaining and implementing methods and procedures necessary for the verification of business applications.
• Developed test strategies, Test Plans, Scripts and Scenarios.
• Analyzed and reported test result utilizing StarTeam bug tracking system. Created test summary reports. Took ownership of issues and ensured they are resolved in a timely manner. Participated in Java code reviews and applications debugging. Analyzed and investigated Java Exception code. Submitted merchant’s leads and verified data transactions in Oracle DB and email for Merchant and Clients.
• Tested Merchants keywords through variety of searching engines: Google, Yahoo, MSN and etc. Developed WinRunner automation test scripts for Functional and Regression testing. Designed and executed scripts for Performance, Load and Stress Testing using LoadRunner. Performed builds on both UNIX and Windows platforms. Promoted packages from DEV to QA environments. Maintained source code integrity by enforcing proper development processes such as check-in/check-out procedures, version control, versioning scheme and label definition, branch creation/code merges.

Confidential, San Francisco, CA

Senior SQA Analyst/Architect

Responsibilities:

• Designed, implemented and executed API tests for Confidential online Retail and Web Trading applications. Tested component API across multiple applications.
• Created business and user test data. Analyzed project/system requirements, functional and technical specifications, architecture and database schemas to determine scope, API test strategy and approach. Sized projects.
• Prepared Test Plans, Test Cases and Test Data. Set up UNIX environment to run SEntry test drivers. Verified that the SEntry Java source code for the project’s test drivers compiled and run. Made code modifications as required. Reviewed COBOL API/Business Services code. Designed and executed various SQL scripts used QMF, SPUFI tools.
• Responsible for the white box testing of data conversion with subsequent migration from Oracle to Mainframe DB2 for the Outside Holdings, Portfolio and “Questions and Answers” data in Advice Suite. Conducted component performance testing using LoadRunner. Tested web based enterprise applications deployed on J2EE App. servers on Windows and UNIX platforms. Performed white and black box testing for Help and Advice Retail applications and Schwab Private Client with Java as a front-end and Oracle, UDB2 and Mainframe DB2 as a back-end. Designed WinRunner automation test scripts for new project development support and regression testing.
• Documented and reported software problems and entered them into the ClearQuest Bug Tracking System. Worked with Developers to isolate bugs and verify bug fixes. Mentored junior team members on testing tasks and procedures.

Confidential, San Francisco, CA

Senior Performance Engineer/QA Performance Lead

Responsibilities:

• Designed, implemented and executed performance tests for Morgan Stanley online brokerage applications, supporting up to 6,000,000 users. Analyzed project/system requirements, functional specifications, architecture schemas and database schemas to determine scope, design performance test strategy and approach, develop Test Plan and Test Cases. Set up, installed and configured hardware and software for QA Performance Lab. Installed and upgraded performance tools. Configured Window 2000 and UNIX agents and controllers.
• Created Automated Visual scripts using Visual Basic. Executed scripts in eLoad for Performance/Scalability, Load, Volume/ Stress, and Soak tests. Benchmarking app. servers with the WebLogic property settings. Performance tuning and optimization for a multi-tier, J2EE based deployment. Tested WebLogic Clustering and Apache Resonate settings.
• Created virtual users defined profiles, designed scenarios in eLoad. Ran scenarios in eLoad for predefined number of users and monitored front end servers: Apache, WebLogic/Application, WebLogic/Trading, Quote and DB Servers using ServerStats, WebLogic Console, UNIX utilities top, vmstat, Summary SNMP. In WebLogic log check for java exception codes. Collected run time data for reports and graphs using eReporter.
• Worked with developers, architectures and DBAs groups to debug performance related issues. Developed and maintained automation test scripts for BAT and Functional tests utilizing Silk Test. Automated manual Test Cases for Research, Portfolio, and Trading segments of application.
• Tested database functional stored procedures. Created stored procedures and test data sets in Sybase and DB2 databases. Created SQL statements to retrieve data for functional test cases and retrieve timestamps for End-to-End trading transactions due to Performance tests. Created Performance scripts for DB2 optimization.
• Conducted black box testing for various online brokerage applications for “New Architecture”, Morgan Stanley - Dean Witter Integration, Conversion and International projects. Analyzed changes in brokerage Client/Server application to identify critical areas of testing. Documented and reported software problems. Prepared Test Summary Reports. Produced regular status reports to management. Coached and mentored more junior staff.

Confidential, Oakland, CA

Senior SQA Engineer/QA Team Lead

Responsibilities:

• Performed full range of Software Quality Assurance Lead activities for Paragon Project Management System.
• Conducted black and white box tests. Performed testing for client and server sides of application. Assigned, prioritized and scheduled all testing efforts for the QA group. Analyzed business requirements, general and detailed design documents to produce Test Strategies, Test Plan, Test Cases, and Test Scenarios. Prepared test data. Developed test scripts for Performance, Load and Stress tests using Rational Suite Performance Studio.
• Performed Unit, String, Integration, Positive, Negative, Boundary Condition, Portability, Compatibility, Security, Data Migration, Installation, Usability, Configuration, Computation, Documentation and System Tests. Executed Y2K Compliance Test. Tested Paragon Management System's reports. Tested web collaboration tools.
• Conducted black box testing for the company Website. Analyzed and reported test result utilizing Bug Tracking System. Ran Regression Test to verify bug fixes. Interviewed potential staff members and provided feedback to management. Trained new or more junior members; provided technical direction and assistance to team members.