Vikas Jadhav
********@*****.***
. Around 8 years of professional experience in functional testing in
BFSI domain of web based, mainframe and client server applications.
. Worked on different investment banking product like Goldensource,
Ascendis CSH (Broadridge) InvestOne (Fund Accounting - Sungard),
Treasury product like Mercury Fx (Forex Product), Ideal Fx (Forex
Product), Quadryx, (Derivative Product), Ideal bank in Credence
Analytics
. Well conversant with Financial Market products like- Equity, Derivative,
Forex, MBS, Agency, Treasury Fixed Income Security, Mutual Fund, Money
Market Instrument.
. Having experience in reference data testing for Security Master and
Pricing Module in Goldensource product, Fund Accounting in Sungard
InvestOne product and other trading platform for different instrument
like equity, derivative, forex etc in Credence Analystics.
. Proficient in functional testing, reference data testing, test plan, test
scenario, mainframe testing, database testing, regression testing, test
data set up, preparation of user manuals and relevant knowledge transfer
to resources within and outside the team (the business resources),
resource management, effort estimation and experience on Quality Center
. Having experience in automation tool - QTP, VB Script, Shell Script, QC
. Experience with Agile (Scrum) and Waterfall iterative development
methodologies
. Strong experience working on Windows and UNIX environments
. Strong communication, documentation, analytical and interpersonal
skills with leadership quality and problem solving skills.
2 EDUCATIONAL QUALIFICATION
. Master of Business Administration from PUMBA Pune University, India
. Bachelor of Engineering BVCOE Pune University, Pune, India.
3 CERTIFICATIONS
. NCFM Certification (Capital Market and Derivative Market Module)
4 TECHNICAL SKILLS
Operating Systems: Windows 98, Windows XP, Windows 2003 Server, Windows
Vista, Windows 7, MS DOS, UNIX, Linux
Testing Tools: Quality Center, QTP, TOAD, Bugzilla
Databases: Oracle 10g
Scripting Languages: VBScript, Shell Script
Packages: MS Office, MS Project, AS/400, TSO/E, ISPF/PDF, JCL
5 PROJECT EXPERIENCE
Synechron, New Jersey, USA
Aug 10 till date
1. Project: Goldensource (GRDS)
Aug 10 till date
Client: Broadridge
Role: Lead QA- Testing
Description:
GRDS manage services which Aggregates and normalizes data from multiple
vendor feeds and client proprietary feeds. Broadridge applies client and
service bureau level rules to identify exceptions, cleanse data, and
generate a client specific "Golden Copy". BR Supports real time
distribution of reference data. Allows for complete distributed data
model for driving enterprise risk applications, MIS reporting and ad hoc
queries
Responsibilities:
. Complete responsibility of QA activities includes Test Planning and
Preparing Estimates, Test Summary, Test Strategy, Test Cases, Test
Scenarios, weekly Test Status report, Generate traceability matrix,
Generate defect reports, Test statistics, defect density using
Tools such as Quality Center in various environments QA/UAT Phases,
regression, and end-to-end testing.
. Analysis of issues found by client
. Requirement gathering from client
. Verify different reports on daily basis
. As a backend tester, worked extensively on Golden`s Reference Data
using Oracle PL/SQL packages and databases to validate the data in
generating the winning Price by applying the Vendor Hierarchies
(Multi Tolerance Check) and Golden Price Tolerance Check (Current
Winning Price vs. Previous Winning Price) in accordance with Market
Consensus and considering the Allowable Stale Price Age and
Tolerance Threshold with different Price Frequencies and price
ranges.
. Involved in data base testing using Oracle SQL Developer and
Expertise with SQL Queries.
. Writing and Testing SQL queries involving table joins and other
statements.
. As an application tester worked on Golden Source-Broadridge UI
validations and web monitor tools (Golden Source Workbench) for all
feed.
. Involved in monitoring the Golden Source Workbench workflows to
check generation of the Request Files, Response Files generation,
calculating the Golden Winning Price.
. Created Test input requirements and prepared the test data for
testing
. Troubleshooting if there is a data mismatch based on the Rules-
Multi tolerance vendor Check, Golden Price Tolerance check.
. Worked with the SQL statements to extract data from Oracle tables
and verify the output data of the reports-Artio - Equity Tolerance
Report, Artio - Fixed Income Tolerance Report, HSBC - Distress
Funds Broker Compare Report, HSBC - Emerging Funds Bank Loans
Compare Report, CSP Price Detail Report, CSP Summary Report,
Stale/Missing Report
. Worked on the assets/ issue types: Bank Loans, Collateralized
Obligations & MBS-MTG Backed, Corporate Bonds, Corporate
Convertibles, Government Bonds, Inflation Index Linked Notes,
Municipal and Provincial Bonds, Notes deposits & Commercial Paper,
Cp`s and Bank deposits.
. Worked on Security Master module for asset classes like - Treasury,
MBS, Agency
. Environment: JAVA, J2EE, XML, Oracle 10g, Web Service- Java web
service on web logic, File Zilla Client, SQL Developer, Putty
2. Project: Ascendis CSH
May 11 till date
Client: Broadridge
Role: Lead QA- Testing
Description:
The application consists of the automated processing of outgoing ACH, Check
and Wire requests and the automated treasury processing of incoming
wires. The objectives of the Cash Management Ascendis Application are to:
Concentrate through a single channel all on-demand and systemic requests
for outgoing requests via ACH, checks and wires
Process through a single interface request disbursement requests generated
by systems
Automate most of the margin/credit procedures
Automate most of the treasury processing as well as the interfacing with
existing systems and banks
Generate notifications on processing exceptions, failures as well as
successful execution of requests transfers
The application will employ user-defined processing rules and parameters to
automate the margin, credit and treasury processing of outgoing requests
and incoming wires. However, Ascendis will redirect exceptional requests
for manual reviews and analysis based on parameterized business rules. No
automatic system actions will be taken in these cases.
Responsibilities:
. Preparing Test Strategy/Plan & test cases. Execution of test cases in
QC
. Provides effort estimates for assigned work packages
. Data set up activity for functional testing
. Support development team
. Ensures deliverables are internally reviewed.
. Provides support to offshore resources and client testing activities
as required.
. Reported problems in debugging and isolating the root cause of
errors.
. Track problem reports and resolutions.
. Regression testing in QTP
. Mainframe testing
. Testing SP candidate
Environment: Mainframe, Sybase, DB2, Weblogic Application server,
Sungard, Pune
May 08 to July 10
Project: Investone
May 08 to July 10
Role: Senior Engineer- Testing
Description: InvestOne Enterprise is one of the industry's most trusted
investment accounting and reporting solutions. Processing more than $12
trillion in assets, InvestOne Enterprise helps meet the needs of a range of
global financial institutions, including many of the world's largest banks
and financial services companies.
A real-time, multicurrency system supporting straight-through processing,
InvestOne Enterprise helps organizations account for virtually any kind of
security held in nearly any kind of fund-from hedge funds and funds of
funds to pension funds, mutual funds, bank commingled funds, offshore
trusts, and more specialized funds.
Investone is based on core engine which is developed on mainframe platform
and later UI like Apollo, enterprise is developed to connect to engine for
data retrieval from engine. In engine core accounting calculation has been
done while all kind of report and other modules has been developed on
Apollo or enterprise.
Responsibilities:
. Reviews requirements, specifications and other deliverables for
testability and to assist scoping testing effort.
. Preparing Test Strategy/Plan & test cases. Execution of test cases
. Provides effort estimates for assigned work packages
. Contributes to metrics gathering
. Write test scenario using tool like Mind Map
. Data set up activity for functional testing
. Support development team
. Ensures deliverables are internally reviewed.
. Provides support to onshore resources and client testing activities as
required.
. Reported problems in debugging and isolating the root cause of
errors.
. Track problem reports and resolutions.
. Regression testing
. Mainframe testing (Having knowledge of JCL, job run)
. Testing SP candidate and hotfixes.
. Giving training of functionality to automation team and new joiner in
testing team
. Write the regression script for automation team in keyword driven
format.
. Configuration Audit on quarterly basis
. Visit onsite to Lombard, Chicago office for five weeks duration to
get training on various modules
Environment: Mainframe, Sybase, DB2, Weblogic Application server,
Goldensource, Mumbai July 07 to May 08
Project: Enterprise Data Management (EDM)
July 07 to May 08
Description: EDM is used by a major financial company to map the data from
different sources like Reuters, Bloomberg to database. Hence engine is made
for mapping the data. Over engine as per client requirement framework has
been given for all financial component.
In UI side there are different link available for all Securities,
Customers, Transaction and Report.
Responsibilities:
. Write test cases according to the functional requirements.
. Execution of test cases
. Automate the script using Rational Clear case tool
. Support development team reported problems in debugging and isolating
the root cause of errors.
. Track problem reports and resolutions.
. Regression testing
. Service pack testing
Environment: Websphere Application Server, MQ Series, Oracle 10g
Auditime Information System Pvt. Ltd.
Oct. 06 to July 07
Client: Credence Analytics
1. Project: Mercury Fx
Oct. 06 to July 07
Description: Mercury Fx is a browser-based application provided for online
reporting of forex transactions carried out at various branches and
streamline the rate giving process. It provides all the security features
required for financial transactions with secured user management and
provides audit trail for all the activities.
Responsibilities:
. Requirement Gathering and Analysis
. Preparing the functional documents
. Responsible for developing test cases as per the SRS
. Problem tracking and reporting.
. Update Test procedures according to data obtained from random results,
client feedback and changes in requirements.
. Support development team in isolating the root cause of errors.
. To provide functional assistance to team member
Environment: Oracle, UNIX servers.
2. Project: Ideal Fx
Oct. 06 to July 07
Description: Ideal application is provided for reporting of forex
transactions carried out at various treasury and branches level. It
provides all the security features required for financial transactions with
secured user management. Transaction like interbank and merchant can be
done. Transaction type like forward contract, export bills, import bills,
outright transaction, Swap can be done.
Responsibilities:
. Requirement Gathering and Analysis
. Preparing the functional documents
. Responsible for developing test cases as per the SRS
. Problem tracking and reporting.
. Update Test procedures according to data obtained from random results,
client feedback and changes in requirements.
. Support development team in isolating the root cause of errors
. To provide functional assistance to team member
Environment: Oracle, UNIX servers.
3. Project: Quadryx
Oct 06 to July 07
Description: Quadryx is a derivative product. All swap transaction like
interest rate swap, currency swap and option like plain vanilla, lower,
upper barrier option etc all this transaction has been provided by Quadrys.
Also system support accounting, settlement, risk management and report
Responsibilities:
. Requirement Gathering and Analysis
. Preparing the functional documents
. Responsible for developing test cases as per the SRS
. Problem tracking and reporting.
. Update Test procedures according to data obtained from random results,
client feedback and changes in requirements.
. Support development team in isolating the root cause of errors
. To provide functional assistance to team member
Environment: Oracle, UNIX servers.
4. Project: Ideal bank
Oct 06 to July 07
Description: Ideal Bank is provided for treasury level transaction of bank.
Transactions carried out at various branches can investment in equity,
derivative, fixed income security. It provides all the security features
required for financial transactions with secured user management and
provides audit trail for all the activities.
Responsibilities:
. Requirement Gathering and Analysis
. Preparing the functional documents
. Responsible for developing test cases as per the SRS
. Problem tracking and reporting.
. Update Test procedures according to data obtained from random results,
client feedback and changes in requirements.
. Support development team in isolating the root cause of errors
. To provide functional assistance to team member
Environment: Oracle, UNIX servers.
J.J. Placement Dec 04 to Sept 06
Client: BCone Pune
1. Project: Mutual Fund Investment System
Jan 05 to Nov 05
Description: MFSI is developed for the mutual fund agents to keep the
clients investment record on finger tips. This system has all the details
like Asset Management Company information, Mutual fund Schemes, NAV,
Dividend announcements, Investment literature, customer information,
portfolio tracking of the client etc.
Responsibilities:
. Responsible for developing test cases as per the SRS
. Problem tracking and reporting.
. Update Test procedures according to data obtained from random results,
client feedback and changes in requirements.
. Support development team in isolating the root cause of errors
. To provide functional assistance to team member
Environment: Websphere Application Server, Oracle
2. Project: Asset Liability Management
Dec. 05 to Sept. 06
Description: Housing Finance Company (HFC), is exposed to credit and market
risk in view of the asset-liability transformation. HFCs operate in a
fairly de-regularized environment and are required to determine on their
own interest rate on advances and deposits, subject to the ceiling on
maximum rate of interest they can offer on deposits. The management of HFCs
base their business decision on a dynamic and integrated risk management
system and processes driven by corporate strategy. HFCs are exposed to
several risk in course of their business - credit risk, interest rate risk,
liquidity risk and operational risk.
Hence to address these risk in a structured manner they have to upgrade
their risk management by adopting more comprehensive Asset-Liability
Management (ALM) practices. The system is concerned with management of risk
and provides a comprehensive and dynamic framework of measuring, monitoring
and managing liquidity and interest rate risk by uploading the data for FD
(Fixed Deposits), Bank Loans, Housing Loans and Consumer Finance.
The fundamental objectives of an ALM function must include :-
> To preserve and enhance the net worth of the institution.
> To quantify the various risks in the balance sheet.
> To streamline and manage regulatory capital.
> To provide liquidity management within the institution.
To actively and judiciously leverage the balance sheet.
Responsibilities:
. Requirement Gathering and Analysis
. Preparing the functional documents
. Responsible for developing test cases as per the SRS
. Problem tracking and reporting.
. Update Test procedures according to data obtained from random results,
client feedback and changes in requirements.
. Support development team in isolating the root cause of errors
. To provide functional assistance to team member
Environment: Oracle, UNIX servers.