Sean Pu

• Lead and participate DSCIS projects Curam v8.x upgrades, Azure AD, TPON ETL data migration, PowerBI/Cognos BI Reporting and SIS-A scoring new engine sprint grooming, SAMS web service integration in between MCCSS and Equifax/MTO/MOH/Justice Solgen incarceration/Service Ontario death registration/IRCC immigration/OSAP Education/CRA batch jobs as well as CM01 SADA application user stories manual testing, test cases/script establishment, test data generation to validate business requirement/user stories/technical specifications and defect tracking/triage at JIRA Agile scrum project management, business demo and sprint retrospective with Oracle 19C environment
• Develop SAMS integration projects web service API Restful JSON and SOAP protocols XML SOAPUI/ReadyAPI Groovy scripting and Postman JavaScript data driven framework automation test suite/script collections from the scratch, customize report, integrate get/post/put/delete method API response to backend DB SQL query automation validation, Jenkins/Newman CI/CD
• Design and develop DSCIS Curam dynamic CRM Case Management application Selenium Web driver Java Maven Cucumber BDD UI web page screens automation framework from the scratch, establish reusable Java method library customization for page object model element (CSS Selector

/Relative XPath) and web driver registration, JSON parameterization and environment variables coding and debugging, Azure CI/CD version control and Java code review and execute Selenium BDD Java code

• Organize WCAG2.1 DSCIS projects web accessibility AODA case study, defect analysis, manual and automation analysis (WAVE, Axe) and Assistant tools (JAWS, NVDA and color contrast analyzer)
• Advise and provide QA expertise and technical innovative insights to product business workflow constructions, not only from requirement enhancement during the testing process, but also from business prototype design, backend data model and development logic implementation designs

Project: DSCIS Curam CRM v8 upgrade, IAM Azure AD, OneKey and GoSecure security, TPON ETL data migration and SIS-A scoring engine replacement, Azure DevOp, Oracle DB

Project: SAMS web service API integration to Equifax, MTO, MOH, Justice, CRA, MGCS, Education

• Transformed Test requirement and manual test scenario/cases into automation scripts, identified legacy testing data complexity by SQL complex queries and conducted data cleaning, staging, transformation, reconciliation, conditioning and archiving associated to data modeling schema
• Lead and participated manual testing (test case/scenario, test plan/strategy, test report and scripts) for each Sprint user story and production support, guided and mentored outsourcing QA members
• Developed Intraday Liquidity (backend ETL automation from the scratch) Java Maven Selenium web driver BDD Cucumber framework for Swift Payment gateway Conform Job, Event Monitoring and LCM Simulation automation code from the scratch, BitBucket version control and Jenkins CI/CD pipeline
• Designed and Wrote Autosys batch Job ETL process automation testing and Restful web service API SOAPUI/Postman automation delivery with Oauth2.0 protocol
• Customized BDD Cucumber advanced testing pdf report Extent Report by framework configuration

Project: Banking Intraday Liquidity project, JIRA and Confluence, SqlServer, Oracle and NoSQL MongoDB

• Delivered test estimation, test plan, test solutions and drive the acceptance of user stories. Analyzed business requirement documentation including use cases, functional and non-functional specification, participated in sprint planning user story grooming meetings, defect triage meetings, scrum meeting, walkthrough meeting and recommend business workflow improvement
• Specialized in PowerBI healthcare system data modeling, correlated hospital Surgery/Diagnostic Imaging and Alternative level of care Wait Time System HL7 integration to business intelligence technical level SQL complex queries
• Conducted manual and automation system integration level testing in terms of Azure TFS cloud GIT and Azure CI/CD DevOp environment
• Represented the test team during project UAT team meetings, identified and analyzed technological impacts of proposed changes, contribute to risk assessments by evaluating the risk associated with application changes, applying risk factors and recommending appropriate test approaches

Project: Cancer Care Ontario Surgery/Diagnostic Imaging and ALC WTIS (Wait time information system) project, HL7 pipeline, C# .Net Azure DevOp, Selenium web driver Java

• Lead and participated in Curam CRM CPIN CM web-based/FM Oracle eBs payment gateway client-server application release business requirement gathering and user workflow epic identification in project user story grooming, designed SIT and UAT manual and automated test scenarios(cases) from product use cases and functional user stories
• Involved CPIN new release SIT/UAT testing activities to hand on QA testing defect tracking, continue integration user story quality assurance and business user story implementation and enhancement activities
• Built testing environment, automation data reconciliation, GoSecure PKI access, testing report generation and analysis, including functional and non-functional cross platform, cross browsers testing
• Maintained and customized UFT hybrid (data driven+ function library) description programming advanced framework, as far as more than 500 self-defined functions library, complex environment variables, XML/Excel data driven methods and object repositories
• Built Restful protocol web service SOAPUI/ReadyAPI/Postman data driven test automation script, customized reports and DevOp continue integration
• Delivered automation codes to IBM RTC (rational team concert) for version control and testing environment transformation

Project: Curam Social service CPIN from release 1.13 to release 2.1, Curam CRM Financial Management Oracle eBs Accounting OPCS project

Curam CRM platform/ Oracle Financial Management eBs Accounting AP/AR/GL/FA, Java application, Websphere, OpenText CMS, Oracle19c DB, UFT 14.53, HP/ALM, ReadyAPI and RTC 6.03

• Strategized and Led quality assurance projects assigned by Project Manager and SDC manager, create test plans, test scenarios and test cases for all SDC team’s product offerings
• Proactively managed test deliverables/activities/methodologies among backlog grooming, sprint backlogs preparation, user story rating, task execution, defect triage, business requirement enhancement suggestions, demo and sprint retrospective
• Identified defects, questionable functions, deviations from coding and other standards and inconsistencies across programs and documentations by using team foundation server Azure DevOp
• Designed and implemented legacy system data migration/Ingestion/Anomaly log quality ETL SMIS import and BI reporting testing environment, data mock-up and testing strategy guidelines thoroughly to bridge business and developers
• Provided SIT testing leadership, training and oversight in support of MTO downsview location development resources to accomplish all sprint user stories project timelines and backfilling for UAT project coordinator when needed
• Built up and executed Java/C# Selenium web drive automation testing (page object model framework + Maven dependency +Git version control) subject to product stabilization and AODA from SIT/UAT to production deployment and Selenium web driver regression automations Azure pipeline CI/CD
• Designed and developed web service API ReadyAPI automation testing in conjunction to database reconciliation

Project 1: Ministry of Child Transfer Payment Risk Assessment - 2016/2017 Ministry Amethyst Award Phase1/2 SMIS data import ETL BA+QA+DA/Mobile Web Workflow and GoSecure government security implementation

Project 2: Highway Corridor Management - 2017/2018 Ontario Public Work Association Award Phase1/Phase2 permit submission/permit change, cancellation and renewal; Accounting payment process/delinquent lifecycle/daily reconciliation; Microsoft PowerBI reporting Cube data conditioning, database data analysis, E2E testing specifications, Legacy data migration

C# .Net and Java projects, Oracle and SQL Server DB, WCAG2.0 level A+AA AODA testing (Wave/aXe, Compliance Sheriff, JAWS, NVDA), SOAPUI/Postman web service API automation (Oauth2.0), Selenium java/C# web driver page object model framework, TFS Git version control and Azure cloud pipeline CI/CD

• Led QA artifacts in the CAA and AAA web application service tracker project system integration and UAT .Net application testing: including ESB portal console Restful web service oAuth2.0 security, mobile web Json web service testing by using SOAPUI automation tool, web UI , database , system compatibility testing, and system non-functional performance testing
• Participated in P&C Guidewire ACE project use case analysis, business requirement intakes and sign-off, attended agile scrum sprint backlogs’ grooming, product model and insurance premium rating developing design walkthroughs, defined state of art functional and non-functional manual, automation and fulfillment/integration test plan/strategies, design and execute end to end test scenarios, traceability matrix, test suites/cases/scripts, test result reports and defects triage heads-up
• Played a key role in CAA ACE Guidewire project with policy centre, billing centre, claim centre and web service integration testing, products comprise of Auto/Property/Valuables/Umbrella product model, Rating table and Billing, Claim testing artifacts
• Accountable for P&C Guidewire and Travel Medical Insurance .Net application EDW data warehouse ETL reporting data warehouse mining and business intelligence, wrote complex queries to extract concrete and valid testing data to support business scenarios analysis, provided testing evidence for Microsoft SSIS/SSAS/SSRS cube ETL reporting logic animations
• Wrote, executed and maintained Java Selenium web driver testing scripts in terms of Guidewire policy center rating E2E scenarios and claim center whole workflows

Project 1: CAA ERS Service Track (won InfoTech 2014 project first prize award and US AAA best reputation project appraisal): ESB portal web service, .Net and mobile web application, Test Manager/Team Foundation Server defect tracking

Project 2: CAA ACE Guidewire project: Java application, Tomcat application server, TFS defect tracking

Project 3: Guidewire/TMI EDW SSI Java/.Net application reporting project

• Wrote and executed test strategies, test scenarios, test cases at Rally for Workforce Now web service API development, participated in walkthroughs and stand-up meetings to make contributions to all lines of business, provided and supported Sprint demos to illustrate project progress to management level
• Automated SOAPUI web service API data-driven and event driven test suites by XML/Json Java Groovy scripts and generated testing reports to scrum master, testing faucets include functional, security testing and non-functional load testing
• Presented professional consultant level technical training and knowledge transfers to different team stakeholders, including offshore resources

Project: ADP workforce Now web service API project, J2EE and .Net multi-tie platforms, Rally and ClearQuest defect tracking

• Defined and implemented test strategies and planning for all projects, including Microsoft TFS test designs, executions, documentations and test suites maintenance
• Took a leadership role in offshore IOC .Net CAA web testing. Worked with the development team to determine the appropriate solutions for addressing production ticket software anomalies or implementing improvements, types of testing include functionality, integration ESB web service SOAPUI/WCFClient, performance automation, security, fail-over, security, front end usability testing and backend MRM batch job, SQL server database testing
• Played a key role in CAA multi- tiers iOS, Android and Windows OS mobile testing projects: CAA Bike app, CAA Emergency Roadside Service application, Call Tracker, CAA National application, Telematics Guidewire UBI Insurance and Travel Medical Insurance. Test faucets include ESB wrapper web service SOAPUI/WCF Client unit testing, mobile application UI testing, mobile .Net web integration testing, backend SQL server database modelling testing
• Developed and maintained performance Neoload test plan, scripts, executions as well as functionality Selenium Java automation and QTP 10

Project: CAA IOC web, Telematics P&C Guidewire UBI/ETL SQL server 2010 database testing/Fulfillment SharePoint and web service testing /SSO web/ESB portal MQ, CAA Emergency Roadside Service MC65 Windows mobile, CAA Bike Application (iOS and Android), CAA Mobile National Application, Call Tracker, Travel Medical Insurance web shop, MRM and AXIS upgrade

• Designed functionality/ performance test plan, workload model, test scenarios and budget control
• Executed Loblaw store POS Loyalty file loading testing within Windows and Sco Unix environment, traced log files, PMON analysis, SOAPUI web service testing within C# .Net platform, QC defect tracking and project management
• Led Indian outsourcing team for test execution coordination
• Developed and executed SAP handheld application and jco java automation scripts and provided analysis reports and improvement solutions

Project: SAP Handheld Enhancement, POS Loyalty .Net application

• Developed and maintained performance test plans, cases, scenarios, and scripts, designed test data strategies, business workload model for LoadRunner load and stress test, contributed recommendations and assessments to ensure business and technical requirement and ongoing project reviews
• Performed test executions, monitoring, Introscope diagnostics, analysis, tuning, and reporting of results to identify and troubleshoot system performance issues and bottlenecks, designed and executed SOAPUI SOA testing as well as led the work of others and the review of performance-related work products and deliverables
• Wrote and maintained QTP automation test scenarios and cases for functional Sanity Regression testing, executed testing and maintained test environments
• Designed and executed manual test cases to reflect the test coverage of requirement for each release in terms of SIT and UAT environment. Generated the necessary test data for different stages of testing
• Executed ETL data migration backend testing from US .Net platform to Canada J2EE platform
• Adhered to defect tracking (ClearQuest) process and monitor defects so they progressed in a timely manner
• Worked closely with the development group to resolve defects, escalated issues to management, when necessary, made recommendations to release the code to Production

Project: Online banking project: account transfer, wire payment, file transfer facility, etc.

SIT and UAT environments J2EE web-based application: IBM http web server, webseal, portal server, Introscope, websphere, Oracle database

• Analyzed novel Google Android dual-screens smart-phone new features/requirement in the software system platform release and developed test scenarios and documentations for various test phases/activities
• Worked with in-house development and business design teams to develop test cases, API test code, test applications and test architectures
• Conducted test acceptance testing with offsite outsourcing development groups to provide JIRA projects testing analysis, technical peer reviews, demos and testing trouble-shooting
• Executed test cases and supported project related post-test root cause analysis for Android phone API applications issues (including Email, Phone, Messaging, Contact, Calendar, Gallery, Music, Browser, ThinkFree office, Market, MapQuest and Nero RocketSync iTune and cloud applications)
• Performed integration epic and patch testing, SOAPUI web service API testing, system testing and UAT testing
• Performed the following testing: system dual screens WPC, system stability and reliability, usability, performance as well as functionalities, demoed the application with users
• Wrote test plan, test cases, test scripts, test result reports and bug reports by using QC and JIRA

Project: Imerj dual-screen Google Android smart-phone project is a large mobile application SW/HW project: Java, SQL lite, Linux kernel

Mobile application: email, messaging, phone, contact, gallery, music, browser, calendar, MapQuest Windows and mobile application: Nero rocketsync iTune and iCloud

• Defined software validation process, guidelines, standards and methodologies
• Participated in the definition and design of new systems and enhancements. Recommend efficient design approaches
• Contributed to test estimates and resources scheduling, provided project status reports to manager
• Conducted web service testing by using SOAP UI tool (WSDL) manually and automatically.
• Wrote automation test scripts by using QTP for web application and Python for client server applications
• Executed the load testing, volume testing, stress testing and performance testing by writing automated testing scripts
• Executed Databases Verification and Validation and create XML files for testing
• Performed unit testing, integration testing, system testing and helped user UAT testing
• Walkthrough FRS, the design architecture, the high-level design document and the detail design documentations, report the document issues to QA manager
• Found out the bottleneck of application by trouble-shooting skills
• Performed the following testing: reliability, usability, portability, compatibility and consistency as well as functionality, demo the application with users, write SQL scripts to initialize Data Base.
• Project management and maintenance for Cardis, developing web base application for Genie

Project 1: Cardis is a large financial project, client/server and web-based application. .Net and Java, DB2, Jboss, Mysql

Project 2: Loyalty Center is a large financial project (using in product), web-based application. J2EE, DB2, IBM Websphere Server, MQ

• Developed fiber sensor specifications and computer software simulations
• Conducted product laboratory testing according to experimental design requirement, analyzed measurement resultant data and figured out improvement suggestions
• Implemented cost-effective test equipment set-up and home-made opto-electronics components
• Customized demodulation DAQ system software with VB and labview
• Developed JPEG, MPEG-4 algorithm application programs associated with the ARM micro- processor hardware-software embedded system co-designs and system on programmable chips
• Customized Linux operating system and system configurations with eclipse IDE

Project: Embedded system design long gauge fiber sensor design, Cavity ring-down LPG chemical spectroscopy, Ocean seismic network instrumentation

• Involved in the establishment of testing standards, methodologies, process and procedures
• Analyzed test risks, provided testing deadline and testing standards
• Wrote and executed QTP functionality automation scripts (descriptive programming and object repository) and LoadRunner C performance testing scripts
• Assisted and collaborated in the overall scheduling of resources, allocated project resources effectively, trained QA team members
• Participated in client meetings, business development activities, and other client facet activities
• Wrote project requirement checklists, test plan and test case checklists
• Designed and executed integration testing, system testing, regression testing and user acceptation testing, tested GUI/OO designs and stress performance
• Performed Verification testing, Validation testing (VV&T), security testing, white box testing and black box testing, designed traceability matrix
• Reviewed all kind of documentations, including requirement documents and design documents

Project included Online Banking, CRM .Net application, Online Cargo and flight booking. Test tools: WinRunner, LoadRunner and TestDirector (TD)

• Provided project management and capital budget, contract deadline controls
• Created design documentations, designed data structures, built database and wrote code
• Executed code review, inspection and unit testing, SIT and UAT test verification and validation
• Established functionality automation test scripts, performance testing workload model and test scripts, analyzed test results and provided solutions to QA manager
• Designed LAN system topologies, installed new network software and hardware system and tested network system

• Communicated with user, analyzed project specifications and coordinated system development
• Installed and configured telecommunications devices, conducted testing and troubleshooting
• Gained excellent working knowledge on network devices including: SDH/SONET, DWDM system, Cisco routers and LAN system devices. Deeply understand architecture of telecommunication network, include backbone and access network.