JAY
SUMMARY:
Quality Assurance Analyst with extensive experience testing in Finance,
Trading and Banking industries. Extremely competent in exercising Quality
Assurance activities; defining Test Plan, Test and Defect Management
Strategy; creating test specifications, test cases; conducting manual and
automated testing using HP, Rational and open source testing tools.
Performing system testing including functional testing and performance
testing of client-server and web applications. Extensive working knowledge
in generating test cases, and ensuring testing coverage. Experience in
analyzing business/user and technical/functional requirements and UML
models. Possess invaluable inter-personal, team management, multi-tasking
and problem solving skills.
TECHNICAL SKILLS:
Testing Tools: HP Quality Center, HP QuickTest Pro,
HP LoadRunner
Databases: DB2, Oracle, MS Access
Operating System Win 98/NT/XP/Vista, UNIX, Linux
Web Technologies: HTML, XML, CSS, SOA
Requirement Manage Tools: Rational Requisite Pro
MS Office Tools: MS Excel, MS Word, MS PowerPoint, MS
Project
Programming Languages: C/C++, Java, Perl
EXPERTISE:
. In-depth knowledge of various SDLC methodologies, such as Agile, RUP and
Waterfall model.
. Familiar with current industry standards, such as FIXML, ASC X12 and PCI
DSS.
. 3+ years of experience in developing test scripts then enhancing with VB
using QuickTest Pro.
. 2+ years of experience in using UNIX operating system and command line.
. Hands on experience with Order Management System in Equity Trading fund.
. In-depth knowledge on equities market, front/middle/back-office flow,
market data, trade exchange, DMA and trading decision.
. Conducting design review meetings and provided inputs on requirements
testability with design team.
. Proficient in reviewing the detailed use cases, functional requirement
specification and system design specification, UML models to understand
the system.
. Hands on experience in creating Test Plan, including test objectives,
test timeframe, test environment and entrance/acceptance criteria.
. Utilizing HP Quality Center to document and manage testing processes
including requirement management, planning, executing test cases, and
defect management.
. Performing black-box testing in manual and automation including
functional testing, performance testing, GUI testing and regression
testing on web-based and client-server applications.
. Ability to report and manage Test Metrics and Defect Metrics Report for
Management.
. Mentored QA team members on testing techniques and methodologies.
. Adept in data validation by executing SQL queries against the database
using multiple tools.
. Knowledge of Programming in Visual Basic, C/C++ and Relational Database
such as Microsoft SQL and Oracle on UNIX and Window Platform.
. Ability to meet aggressive deadlines efficiently and effectively.
. Ability to work on multiple project tasks simultaneously
. Working experience on presenting complex information in a clear and
concise manner to a variety of audiences
. Possessing attention to detail, committing deadlines under tight
schedules, quick learner and team player.
PROFESSIONAL EXPERPIENCE
Sr. QA Analyst
Option Clearing Corporation, Keller, TX
Nov'2009-Present
OCC, the world's largest equity derivatives clearing organization,
providing central counterparty (CCP) clearing and settlement services to
exchanges and platforms for options, financial and commodity futures,
security futures and securities lending transactions. OCC actively invents
and improves its clearing services on all areas, includes Product, Account,
Collateral, Data Distribution, Trade Process, etc.
. Worked with project team throughout the Lifecycle to assist and support
the analysis, design, development, and implementation of developed
systems/applications.
. Worked with QA team members to develop test strategy, approach and test
plans.
. Created test strategy to insure completeness and accuracy. Conducted
cross team review of this documentation and independently follows up on
any feedback received.
. Conducted standards, functional, cycle and regression testing on newly
designed or modified applications/systems.
. Followed agreed upon SDLC procedures to ensure that all information
system products and services meet both the explicit and implicit quality
standards and end-user requirements.
. Thoroughly analyzed, tested, and documented software quality to ensure
proper implementation.
. Tracked test requirement coverage, discrepancies, metrics, and issues
using an automated defect-tracking tool for problem resolution.
. Worked closely with HP and other outside vendors to customize and enhance
HP Quality Center
. Contributed in researching, defining and improving Quality Assurance
Methodology processes.
. Monitors and updates defect reports as needed to ensure timely problem
resolution.
. Performed risk analysis and recommends quality improvements.
. Assisted in the development and implementation of test automation where
applicable.
. Supported Production Department by testing time sensitive defects and
advises on system functionality.
. Contributed in the coordination of testing environment - code deployment,
Data Restore, Environment Shakeup.
. Provided weekly project status reports to management.
. Audited test strategy and test case coverage.
. Created regression test plans and conducts cross training based on
expertise.
. Conducted user review to present the functionalities of the newly
developed system to end-users.
. Provided input on performance appraisals for staff members.
Environment:
Java, C++, HTML, FIXML, UNIX, DB2, UC4, Quick Test Pro, Quality Center, MS
Project
Sr. QA Analyst
Metro Bank, Harrisburg, PA
Dec'2008 - Oct'2009
Metro Bank (formerly Commerce Bank/Harrisburg), a regional financial
service retailer based in central Pennsylvania. The bank was in the process
of large scale conversion of 17 legacy systems into new Fiserv family
products. The business areas impacted by the transition including IVR,
Loan, Deposit, Customer Record Item Processing, Cash Management, EFT/Cards,
Online Banking, Collection and Fraud.
. Training business users of testing methodology and procedures.
. Assisted the test manager in defining testing scope, schedule and
strategy by identifying different kinds of testing that needed to be
conducted; identified testing risks, entrance and exit criteria.
. Hosted group discussion with multiple business areas, to create master
system workflow charts and detailed transaction workflow charts.
. Facilitated Data Verification and prepared UAT test data with business
groups and outside service providers
. Created test cases and reviewed test cases developed by other testers,
and facilitate the documents sign-off.
. Worked with Fiserv Support Team, the Bank IT and Information Security
departments to setup testing environment as well as test account..
. Developed the defect report template and defect tracking processes for
Data Verification and UAT.
. Built Access Database to track the test documents status.
. Facilitated the execution of test cases, worked with business team leads
to allocate testing resource and time.
. Created Super Test Cases which includes bank daily routine transactions
across all business areas, coordinate the running of the Super Test
Cases.
. Designed and created 5 daily status/issue reports and 2 weekly problem
reports to inform senior management the testing status.
. Managed and maintained Program Management SharePoint site, published
projects related and testing documents.
. Developed Defects Logs on SharePoint, effectively communicates testing
defects within the bank as well as with system vendor.
. Assisted project manager to create system Conversion Playbook.
. Worked with Marketing and Online Banking department on testing Bank's
front-end customer facing website.
. Communicated frequently with bank internal audit and compliance
department, ensure all testing processes are under Federal regulations.
. Coordinated release management meetings with business unit to interpret
360 items in the Fiserv Signature Core Banking System major release.
Identified customer impact, training issue and regression test cases.
. Conducted testing planning and execution for Fiserv Online Bank product's
monthly releases
. Actively involved in building Program Management Office.
Environment:
Microsoft Access, Microsoft SharePoint, Fiserv Signature, Fiserv VRU (IVR
product), VQN collection, InMatrix, Laser Pro, Fiserv Banklink, Fiserv
Corillian, Fiserv MarketView, Fiserv DataWarehouse, AS400
Sr. QA Analyst
JKL Investments, Los Angeles, CA
Jul'2007 - Nov'2008
JKL Investment is an equity trading fund which has USD 7 billion under
management. Portfolio Manager Workstation (PMW) is the decision-support and
Order Management System by which equity traders propose and submit trades.
Re-platform the PMW application from Visual Basic into a JAVA web-based
system initiated this project. New modules which helped the traders
analyzing the market trend and historical data will also be added.
. Reviewed requirements specifications including activity diagrams, use
cases to formulate test scenarios.
. Created test scenarios/test cases to ensure complete requirements
coverage.
. Interacted with business users/ SMEs to review the test scenarios/ test
cases and get approval before the start of testing.
. Conducted manual functional testing to exercise smoke testing and ensure
the stability of the environment followed by execution of remaining test
cases.
. Performed end-to-end testing to validate the Business
workflows/processes.
. Analyzed front-end XHTML codes to ensure no mal-format, missing link and
broken link.
. Performed inventory data validation on back-end product database on UNIX
servers.
. Interacted heavily with developers and SMEs for quicker turn-around/ETA
for open defects.
. Verified FIX message flow between the OMS and brokerage firm system.
. Assisted in the development and execution of the change management and
mitigate/assess the impact of change/modification requests.
. Executed SQL queries using TOAD to query UNIX database server to perform
data flow and data table validation between PMW and upstream financial
service provider.
. Assisted performance engineer in creating performance test plan/strategy
and test cases after reviewing Non-Functional Requirement Document with
QA lead and Business Analyst.
. Analyzed and categorized performance testing results, and participate in
system performance tuning.
Environment:
Agile, HP Test Director, HP QuickTest Pro, J2EE, XML, MS Visio, Oracle,
Windows, UNIX, FIX
QA Analyst
PNC Financial Services, Pittsburgh, PA
Jan'2006-May'2007
PNC Financial is a U.S.-based financial services corporation, with assets
of $101.8 billion. PNC operations include a regional banking franchise
operating primarily in eight states and the District of Columbia. The
project is about to improve PNC Financials commercial loan and mortgage
processing system. It includes implementation of Datacap Taskmaster loan
processing system and also improvement on the loan handling business
workflow.
. Reviewed the project plan, business requirement document and design
specification, and interact with BA to understand the requirements.
. Analyzed UML use cases and activity diagrams to understand business
processes.
. Assisted QA Lead in defining QA team work division strategy, and
delegating tasks and devising test plan including test strategy.
. Assisted the QA lead to identify testing entrance / exit criteria,
testing lifecycle, functions need to be tested, testing approach, to be
included in the test plan.
. Identified test data needs to support test execution; verifying
environment readiness for system testing by interacting with release
engineering.
. Used HP Quality Center to document and maintain test cases, test
execution history, defect management and traceability.
. Manually performed black box techniques including smoke testing,
functional/end-to-end testing, GUI testing to validate system features on
different builds.
. Compared the rendered pages against PNC templates to ensure that any
changes to the CSS or underlying HTML don't have any adverse effects.
. Identified regression test cases, and created automation scripts in HP
QuickTest Pro.
. Defined Schema-level triggers in PL/SQL to validate the inventory
database, including After Creation, After Alter, Before Drop and Before
Logoff.
. Delegated tasks to testing team; chaired defect meetings with team
members, developers and AC/SME to get timely updates and resolution for
defects.
. Held weekly meeting with project team and business users to report the
testing status and problem occurred.
. Generated test result report, included the result summary, testing
coverage metrics including test case pass rate and pending defects.
. Coordinated UAT sign-off; created UAT test plan and test scenarios,
identified UAT test data and assisted in furnishing deployment/technical
cutover plan to build production environment.
Environment:
RUP, HP QuickTest Pro, HP Quality Center, Oracle, XML, J2EE, MS Visio,
TOAD, UNIX, Rational Requisite Pro, Perl
Automation Engineer
WachoviaBank,Charlotte,NC
Aug'2004 -DEC' 2005
To maintain its market leadership, Wachovia Bank needed to change its
banking system. The new solution implemented FISERV Core Banking System,
which improve visibility, control, and efficiency while serving as a
foundation for good governance and consistent growth.
. Created use cases from user requirements and defined traceability between
user requirements and use cases.
. Documented technical requirements to illustrate the prototype to the
business users/SMEs.
. Reviewed requirements specifications including activity diagrams, use
cases to formulate test scenarios.
. Assisted the test lead in defining testing scope, schedule and strategy
by identifying different kinds of testing that needed to be conducted;
identified testing risks, entrance and exit criteria.
. Created test scenarios - defining test conditions, test data, test steps
and expected result, and documented in HP Test Director.
. Validated the Wachovia's cash management workflows,
including remote check deposit, inter-bank wire transfers, balance and
transaction reports.
. Conducted manual testing on user interface testing and screen-flow
testing.
. Programmed PL/SQL procedures and raised user-defined exceptions.
. Used Quick TestPro to create and maintain test scripts for keyword driven
testing (parameterization), GUI testing and functional testing.
. Enhanced Quick TestPro scripts to read data from excel files;
incorporated exception/error handling in the scripts by using Visual
Basic.
. Inserted various checkpoints in the scripts to verify Object properties.
Environment:
XML, FISERV Application, HP QuickTest Pro, HP Test Director, Rational
Requisite Pro, MS Visio, Oracle, Visual Basic
EDUCATION:
Master in Computer Science
Bachelor in Electrical Engineering