Eric Fan

Created API Testing framework for CDS and WAMS project using Parasoft, found and logged bugs in JIRA ticket. Lead a group of three QA members and gave guidance and monitored their works. Created the testing data from KYC web service calls and validated testing data from Broadridge and CIS system and validated the testing data in ADP upload files. Modified the testing data from Broadridge and checked the data in the KYC database the next day to make sure the ADP download process is correct. Created the testing data from KYC web service and worked with other team members and triaged the failure reason while doing the end to end testing . Created API Testing framework for CIS system using Customer web service , integrated with multi factor authentication, generated authentication token and passed to related API calls for security enhancement and fraud prevention.

Created API Testing framework for CDS and WAMS project using Parasoft, found and logged bugs in JIRA ticket. Lead a group of three QA members and gave guidance and monitored their works. Created the testing data from KYC web service calls and validated testing data from Broadridge and CIS system and validated the testing data in ADP upload files. Modified the testing data from Broadridge and checked the data in the KYC database the next day to make sure the ADP download process is correct. Created the testing data from KYC web service and worked with other team members and triaged the failure reason while doing the end to end testing . Created API Testing framework for CIS system using Customer web service , integrated with multi factor authentication, generated authentication token and passed to related API calls for security enhancement and fraud prevention.

Created testing framework for CRD middle office by using Java, Maven, TestNG, Rest Assure, Extent Test, tested whole functionally directly though middle office level, directly dropped message to Order message queue, captured the result directly from outbound message queue can validated against database, generated report by using ExtentTest. Created and executed testing framework for Olympus by using Ready API and Groovy script. Capture the difference between JSON messages and validate against the database, generate Excel output files. Created web application UI testing framework using Selenium, Rest Assure, TestNG, Extent Test, compare result from GUI to Service call, output difference to Excel sheet, generated Report and email to QA team.

Used Parasoft SOATest to create a test framework for testing REST API projects. Projects include: US ISS, CUBS, COS, COMS, ES&O, BBPro. Created payload based on the existing API docs for POST and PATCH operation. Used GET operation to retrieve the data for validation purposes. Analyzed and validated the result against Oracle, DB2 database and Mainframe AS400 by writing complex SQL query. Integrated Parasoft script into Jenkins and analyzed the result daily. Created customer assertion by using Java, Groovy script and integrating with Parasoft. Generated Oauth Token by using Selenium, Java, created an environment file for Parasoft environment reference. Created the whole testing framework while still in the development stage, created a mock response based on the RAML and schema files by using Parasoft Virtualization, added assertion and databank on the mock response, passed the captured value into the next step and generated an end to end testing scenario. Created the web applications framework using Selenium, Java and Cucumber, created the feature file using the cucumber. Worked in the Agile environment.

Created testing framework by using SoapUI, integrated with Java and Groovy for Self Distribution, Cross Distribution and DrugImage ETL. Analyzed and validated the result using IBM Message Broker Browser and SoapUI. Created user defined function using Java for automation purpose. Integrated Java assertion code and parsing files into SoapUI through Groovy. Created Groovy script to start up, shutdown message flow, clean message from message queue and integrated into SoapUI. Used RFHUtil and Message Queue Brower from IBM to browse the message from ESB and Gateways output queue. Start and stop channel to capture message from different transmission queue and output queue. Stop message flow or Execution group to check the input message for Invoice, Delivery Schedule, ASN, PO Service. Analyzed the result and filed the bug report.

• Created new test cases based on SRS documents. • Used ParaSoft SOA as test tool to test WCP/BAP 2012, USD_RSP at web service level. Analyzed the result and validated the result against Oracle database and Mainframe AS400. Manually Compare the result from GUI level and web service level. • Tested investment project (Order entry) which include online Order, Retrieve, Cancel for Stock, mutual fund, GIC, Options, and validate the result against the database. • Monitored outsource team and gave guideline for testing Transfer project at web service level. • Installed and configured WebSphere, deployed WCP, BAP web service into WebSphere and run regression test.

Function Role in CDMS project: • Created new test cases from using HPQC according to the architecture and design documents, executed test cases according to test plan and logged bug using HPQC. • Created EMR files according to the schema definition for testing purpose. Project Name: Matrix for TD Canada Trust (Version 1B) (November, 2010 - April, 2011) Function Role in CGI Matrix project: • Used ParaSoft SOA as test tool to test project at web service level. Analyzed the result and validated the result against Oracle database. • Consumed the web service by using Axis 2.1, created java client project to check the bottleneck for Add Entitlement service, iterated all the enumerated element value in order to generate an Excel spreadsheet with all kinds of combination and used in ParaSoft SOA for web service testing.

• Ten years of Software Quality Assurance in Pitney Bowes MapInfo Canada. Proficient in functional, negative, regression, black box, system integration (SIT), acceptance (UAT), and performance testing. • Expert in SOA testing, familiar with web service standard such as JAX-WS,WS-Security, JAX-WS,SOAP, XML Schema, WSDL. Proficient in using different testing metrology to test web service. Expert in testing client run time from different web server such as Web Sphere, Web Logic, Tomcat, Apache. Proficient using SoapUI to test SOAP API and REST API. • Seven years of part time DBA in Pitney Bowes MapInfo Canada: Oracle, Informix, DB2, SQL Server, MySql. • Programming languages: Java, C#, Groovy Script language, Korn Shell, Visual Basic. • Platform: Windows, Solaris, Linux, AIX, HP. • Proficient using Software quality assurance automation software: JUnit, NUnit, SoapUI, JMeter Plan, QTP. • Excellent problem solving skills and analytical skills with a strong technical background.