SUMMARY:

• Service provider in GTA for system analysis, QA analysis or test automation with: ver 20 years of leadership experience in business analysis, software design, QA and test automation in full SDLC staff system analyst in hospital information system architecture, design, integration and implementation leading in test automation framework design and implementation for 5 clients in QTP/UTF and Selenium familiarized business workflow and IT process of government, healthcare, insurance, financing, banking, capital markets, telecom, retails, warehousing, transportation and hospital management comprehensive technical strengths in negotiation and writing for BRD, SRS collecting first - class skills, capacity, efficiency and accuracy in system analysis and design, QA analysis and automation for Java/.Net/C++ for GUI, API, Web Service, ETL, ERP and COTS app proficient in methodologies of waterfall, RUP, Agile, OOAD, OOP, SOA and Object Oriented Testing skilled in black box and grey box testing for System, Integration, Function, Performance, Scalability and Security quickly acquired knowledge from any new business sector proactive technical advisor in troubleshooting, customer supporting, training, presentation and knowledge sharing

TECHNICAL SKILLS:

Testing Tools: Selenium WebDriver, Appium, Protractor, Robot Framework, Cucumber, Junit, AutoIt, SoapUI, Postman, Katalon Studio; HP Quality Center, ALM, UFT, Performance Center, Loadrunner, IBM RFT, Clear Quest, Quality Manager; MS Test Manager, TFS, VSTS

CASE tools: Visio, IBM Rational Architecture, Visual Modeler, Erwin, Oracle Data Modeler, Draw.io

Program Languages: VBScript, VBA, VB.Net, Java, JavaScript, Groovy, SQL, C, C#, HTML, XML, WSDL, UML

Operating systems: Windows, Unix, Linux, IBM AIX, AS400, Solaris, MS DOS

Database systems: Oracle11g/12c, DB2 LUW 10, DB2 iSeries v7, SQL Server 2014, Access2010

Servers: WebLogic, WebSphere, JRun, Tomcat, Apache, IIS, WebMethods, CA IAM

IDE: Visual Studio, Eclipse, NetBeans, XMLSpy, SQL Developer, WebMethods Developer

Other tool / app: Crystal Report, Cognos, BO, Win32API, Jaws, Achecker, RPA Express, SOATest, Sikuli X

PROFESSIONAL EXPERIENCE:

Confidential

QA Automation Expert

Responsibilities:

• Created Image-Based Test Automation Tool for POS Cash Register by using RPA Express, SikuliX and Win32API
• Created Java Client to Test RESTful API for CA IAM connector
• Created hybrid test automation framework with a friendly UI in Java, Selenium and Excel 2010 from scratch
• Developed web elements spy for IE and Chrome, captured object selector based on different spying strategy
• Managed test suites, test cases, test data in test automation center (TAC)
• Planed to implement test suite builder with AI assistant and Jira Test Integration
• Retrieved test story(s), test cases from Jira to TAC and linked with test run in test suite
• Added, removed and updated test scenarios by several clicks in TAC and run test suites
• Edited, debugged test suite by adding test cases combined with test input data, expected data in test flow
• Created a remote test agent which can be started by email notification or Jenkins Continuous Integration
• Generated test report based on test runtime log
• Implemented full web page screenshot in-house package by using Java ImageIO, Robot, JavaScript and selenium
• Executed smoke test and regression test for Agile project with two week sprint
• Shown TAC to SVP, PM, Dev Manager, Architect and QA team, planned to share with other project team

Confidential

Sr. QA Specialist

Responsibilities:

• Created test checklist for OCMS database migration by analyzing OCMS web app and SAP BO Crystal reports
• Verified database configuration and tested it in OCMS UI and queried by SQL Developer
• Performed smoke, function and regression test on business process, rules and roles for ESMS
• Collected test requirements by system analysis on ESMS, reviewing physical design document and user guide
• Proposed test plan in writing and peer reviewed by team, input user stories, designed test cases in Test Manager
• Executed test cases with well-designed test data in complex test scenarios to dig defects in ESMS
• Created Coded UI test scripts to accelerate test process
• Recorded and tracked defects in ClearQuest and communicated with dev team for bug-fixing
• Verified Content Accessibility with WCAG2.0 by using Achecker and Jaws
• Wrote another QA deliverables, such as test matrix, test report and sign-off documents
• Designed and implemented in-house tool for defect data migration from ClearQuest to VSTS

Confidential

Sr. QA Tester / ETL Developer

Responsibilities:

• Analyzed IP, MOM, ATG, POM and Vendor for data transformation with data assessment reports and ER diagram
• Utilized QA methodology and ETL knowledge to implement Automated ETL Testing Framework
• Installed Oracle 11g Express, SQL Server 2014 Express and DB2 Express-C 10.5 as test environment
• Setup ODBC connection among testing utility, test environment and production database by using ODBC drivers
• Trouble-shot JDBC driver configuration issue in DBeaver 7.x to get access to production database
• Created and managed DB user, table space, schema, table in testing by DDL, DCL an data query by DML
• Built ER diagrams from data dictionary of IP/ATG/POM/Vendor DB source data and RMS target data
• Re-assessed data source by using ER diagram, green screens and RPG source and run peer reviewing
• Wrote dynamic SQL statement to retrieve table’s metadata from IP, ATG, POM and Vendor DB
• Generated DDL scripts by using my ETL testing framework to create tables and constrains in test DB
• Extracted production data by using SSIS SQLCMD, SQLPLUS’ SPOOL, DB2 Export and IBM i 7.1 RXFERPCB
• Wrote control file for data loading used for Oracle SQLLDR by scripting
• Resolved code page issue during data extraction and imported data
• Executed delta data extraction for big data in daily basis
• Setup windows tasks for data extraction and loading by invoking VBScript in Remote Windows Server
• Developed VBA code in Excel to generate transformation scripts for each target table based on SRS and metadata
• Retrieved loading data by running transformation scripts in source data tables
• Loaded transformed data in target DB to verify data integrity based on data constrains (PK, FK, UK and Check)
• Supported data profiling, data quality and data cleansing

Confidential

Sr. QA Specialist

Responsibilities:

• Co-worked with BA, Developer and QA team to achieve our test goal and assignment for Panorama project
• Involved functional and non-functional system integration testing and production deployment verification
• Analyzed BRD and DDUCs, and provided inputs and updates for PEAR, IFIS, Inventory, Immunization, Admim, Work MGMNT, iTerms, Role and Permissions, Reporting, JOrg, IRIS, STIX, OIA, Provider and City Uploading
• Participated design review, walkthrough and status meeting
• Created and updated QA documentations and artefacts such as test plans, test cases and sign-off
• Searched and created test data for Panorama regression test, standard report function and performance test
• Created scripts for test automation by using selenium, RFT, VBScripts and Oracle SQL Developer4.x
• Validated ETL process for BI reporting in Cognos and Oracle database with automated test scripts
• Analyzed and diagnosed latent performance issue by mass data inquiry
• Created complex business scenarios and run ad-hoc test for trouble-shooting, figured out dead lock issue
• Executed deployment test in PROD and reproduced production ticket in QA for more detailed analysis
• Found latent defect of Inventory Product Requisition/Return process with multiple users
• Logged test results, defects with steps, test data and screen shot in Clear Quest and tracked them in SDL
• Verified Content Accessibility with WCAG2.0 by using Achecker and Jaws
• Coached co-op student with business analysis and QA analysis for trouble-shooting
• Participated project deployment at weekend

Confidential

Sr. QA Specialist

Responsibilities:

• Reviewed system migration plan, BRD and system test strategy for RUS Modernization project
• Created test plan, test strategy, test cases/scripts and test matrix for and ESDI web services
• Validated ESDI web services with dynamic data by groovy script in SoapUI4.x for test automation
• Uploaded test results and defects into QC by VBA in Excel2010

Confidential

Sr. BA/QA Consultant

Responsibilities:

• Reviewed project plan and walked through the initiation and transition phase for infrastructure migration project
• Created system requirement specification (SRS), detailed design and use case (DDUC)
• Developed test plan, strategy and scheduled test activities for system infrastructure migration
• Designed and run test cases and test scenarios with full test coverage in QC10
• Validated test result with web UI, DB2, Domino, file server and runtime log and data query
• Reported and tracked defects with detailed description, test steps and test data in SDLC

Confidential

Sr. BA/QA Consultant

Responsibilities:

• Worked on CMCIF, banking migration, personal and commercial banking projects with WebMethods and TIBCO
• Reviewed CRS, Blue Print and DRS, pinpointed the gap and provided updates to BA
• Run static test for system design and verified early defect
• Developed test plan and scheduled test activities in system test, guided test case design and test flow setup
• Designed, prioritized and executed manual test, and automated functional test and non-functional tests
• Analyzed test coverage and results, reported defect with detailed description, steps and test data
• Integrated QTP test scripts with QC/ALM, developed test automation framework3.0 with OOT for CMCIF
• Resolved technical challenge by using VBScript with DP/OR in QTP for .net, Ajax and Web2.0 application
• Created Virtual user script for an application of Java over HTTP protocol for performance test
• Designed and monitored load scenario in performance center
• Led and monitored QA activities, walkthrough meeting, status meeting
• Prepared QA deliverables and supported IT verification and GO/NO-GO decision with sign-off
• Supported QA manager, PM for QA/QC processing

Confidential

Sr. QA Analyst

Responsibilities:

• Worked on healthcare network, claim adjudication, and real-time claim project in WebMethods7.x and HL7
• Peer-reviewed BRD, SRS documents with BA, SA and QA and other stakeholders for healthcare network project
• Coordinated QA team for system test automation and day-to-day test process in SIT, UAT and PAT
• Supported continues improvement, efficiency and effectives of the system test for claim adjudication in agile team
• Maintained highest customer satisfaction with vendor, developers and BAs in Healthcare Network project
• Communicated with business and technical team to collect requirements for system test
• Created test plan, test case, risk analysis, coverage analysis, status report, and sign-off
• Implemented test automation framework2.x in QTP, VBScripts and Java for Web application and Web Services
• Recorded and updated virtual user scripts with manual correlation, parameters, text check and rendezvous
• Validated load test data by dry run in VUGen and/or controller
• Set up schedule, workload, runtime setting, rendezvous policy and monitors in load controller
• Analyzed results for performance/stress/capacity test, and diagnosed bottleneck issue for system tuning
• Validated ETL process and tested online reports with Oracle stored procedures
• Executed functional test for web services in WebMethods7.x Integration Server/developer
• Provided technical supports and recommendations for developers to resolve application issue
• Supported trouble-shooting in business process, testing tool, test coverage analysis, defect tracking and SQL

Confidential

Sr. Performance Engineer

Responsibilities:

• Supported process improvement for PCoE management and provided management tool with updates
• Collected business requirement, and verified function test scripts against business scenarios for 6 projects
• Set up test plan, created test case and prepared test data for load, soak, and peak test, based on BRD/SRS
• Created QTP test scripts for function test and performance test TD easy Web, TD Leads and others
• Recorded and enhanced test scripts in Virtual User Generator and dry run all data in all transactions
• Configured runtime settings, monitors and rendezvous policy for complex business load scenario in PC
• Monitored windows/Unix/DB server resources, network delay, J2EE and Citrix during run time
• Collated, analyzed and reported load test results in Load Analysis by using auto correlate, merge, overlay
• Provided diagnosis services information for performance, memory, network, DB connection issue
• Involved in performance tuning with other teams by deep analyzing response time in each http request
• Tracked performance defects in QC

Confidential

Sr. QA Analyst/Technical Advisor

Responsibilities:

• Led QA automation design, implementation and test execution for drug modernization project by using QTP, LoadRunner, SoapUI, WebMethods, Eclipse, XQuery/XPath, TSL, VBScript, C++, Java and PL/SQL
• Eexecuted static test for business requirement, SRS, detailed design and application code, and input updates.
• Participated all QA meetings and reported QA status to QA Manager in SDLC
• Built up QA templates of test plan, test requirement, checklist, test case, test report, sign-off and test matrix
• Prepared test plan, test strategy and created test cases for system integration test and performance test
• Normalized test case design in 4-step and designed test scenarios/flows in TestDirector8.x/Quality Center10
• Created and maintained test data in DB, XML file, flat file and spreadsheet
• Run manual test and automated test for system integration, regression, performance, stress, conformance, scalability, disaster recovery and failover in n-tier clustering environment
• Analyzed performance issue, pinpointed bottlenecks, memory leak and data connectivity by Analysis tool
• Validated and ETL process and BI reports
• Tracked defects in TestDirector8/Quality Center and analyzed test results and wrote sign-off for new release
• Supported developer for bug fixing, presales team for Healthcare Network project and customer in training
• Provided QA manager with technical advice for QA process enhancement, QA tools review

Confidential

Sr. BA/QA Analyst

Responsibilities:

• Verified the SRS; created test strategy, test cases, and automation scripts; created test scripts by using JUnit3.x for API unit test in white box and run system integration test by using WinRunner7.0 for PE.J’s UI
• Created SRS, test plan, test cases; developed and executed test scripts by using SilkTest5.x and Junit for ECare Products, BillPlex, and preKaibu projects
• Installed and maintained Windows/Novell network, IIS/Proxy/exchange/DB server, firewall, dev/QA desktop and day-to-day system supportCollected business requirement; prepared SRS, Use Case, process flow chart and data flow chart; analyzed and designed application
• Created and executed unit test scripts on key components of n-tier applications, healthcare network, eHospital, eHealth record, billing, payment, inventory, online reporting, data warehousing, ETL process and backend batch job for key components in white box and system integration test in black box

Confidential

Sr. System Analyst/Architect

Responsibilities:

• Developed several applications for ETR Information, inventory, billing and payment system
• Created test plan, test case, test scripts for system integration test in black box