Shankar Sharma
[Send email using form at bottom]
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
Mercury, 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: Mercury Quality Center, Mercury QuickTest Pro,
Mercury LoadRunner, Segue Silk Test
Databases: MS SQL server, 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 PowerPoint, MS Project
Programming Languages: PL/SQL, Visual Basic, 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 FIX, 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 Mercury 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 TOAD and WinSQL.
Facilitating User Acceptance Test (UAT) scenario to get go/no-go
decision.
Knowledge of Programming in Visual Basic, C/C++ and Relational Database
such as Microsoft SQL and Oracle on UNIX and Window Platform.
Effectively used time management skills for handling multiple tasks;
self-motivated and adaptable person with outstanding analytical and
organizational skills.
Possessing attention to detail, committing deadlines under tight
schedules, quick learner and team player.
EDUCATION:
Master in Computer Science
Bachelor in Electrical Engineering
PROFESSIONAL EXPERPIENCE
Sr. QA Analyst
Metro Bank, Harrisburg, PA Dec’2008 - Present
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, Mercury Test Director, Mercury QuickTest Pro, J2EE, XML, MS Visio,
Oracle, Windows, UNIX, FIX
QA Analyst
PNC Financial Services, Pittsburgh, PA
May’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 Taskmaste 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 Mercury 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 Mercury
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, Mercury QuickTest Pro, Mercury Quality Center, Oracle, XML, J2EE, MS Visio,
TOAD, UNIX, Rational Requisite Pro, Perl
Automation Engineer
Wachovia Bank, Charlotte, NC
Dec’2004 –Apr’ 2006
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 Mercury 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, Mercury QuickTest Pro, Mercury Test Director, Rational
Requisite Pro, MS Visio, Oracle, Visual Basic
Automation Engineer
National City Mortgage, Cleveland, OH
Oct’2003–Nov’2004
National City Mortgage looked for new methods to keep its team supplied with
tools that enhance efficiency and customer service. The company was making
adjustments to its IT infrastructure—including the implementation of a new web
portal based on Microsoft Office SharePoint Server.
• Reviewed business requirement document and the technical specification.
• Interacted with designers and developers to understand application
functionality and navigation flow.
• Involved in creating test plan to highlight testing scope, testing procedure,
and entrance /exit criteria.
• Created traceability matrix between requirement and test cases and document
the application, data, and specific functionality associated with each test
case.
• Performed white box testing in validating the rendered HTML page for valid
X/HTML, CSS, broken images and broken links
• Conducted positive, negative, data-driven testing and GUI testing to validate
system security, system functionality and system interfaces.
• Configured MS Excel Service to better support the SharePoint server.
• Worked with QA team to create performance test plan to define the scope,
environment, responsibilities and timeline and constructed performance test cases
according to the business requirement.
• Performed load testing and stress testing in LoadRunner 7.8 to find system
capability and exposed bottleneck.
• Monitored, analyzed and interpreted the VuGen’s scenario using LoadRunner
Controller and Analyzer.
• Used MS Word and Excel to document and manage the defects.
Environment:
Mercury LoadRunner , JavaScript, Visual Basic, .NET, MS SQL, MS SharePoint
Designer, MS Excel, C/C++
Developer / QA Analyst
Spark Capital, Los Angeles, CA
Apr’2003–Sep’2003
The Spark Capital is a venture fund that made investments in the media and
entertainment space. The company needed an application to help them to identify
the audience’s viewing pattern and a data management system to organize the
feedbacks from internet series.
Worked with business users to gather and interpret the user
requirements.
Made high-level system flow chart and communicated with the business
user to verify requirements.
Designed and implemented client-server data exaction application using
Visual Basic and MS Access database.
Developed data migration application using JAVA and SQL to synchronize
local and web-based database server.
Created a portal of web-based data management service, enabled users to
access the on-line database.
Formulated wireframes and mockup UI of the system and presented it to
the manager to get feedback.
Conducted unit testing, integration testing and system testing on the
application to ensure it meet the user requirements and expectations.
Presented, communicated the defects to QA and development teams.
Participated daily and weekly meetings with the development and SMEs to
and project status.
Gave business users training courses on the software application and
created user guide.
Environment:
HTML, XML, Visual Basic, JAVA, MS Access, MS Excel, SQL
|