Amit Singh: Database

You are on page 1of 6

Amit Singh

Summary
• Result focussed and customer oriented QA lead with professional expertise in
designing test strategy, test planning, estimation, leading testing effort for complex
projects.
• Experienced QA Lead on-shore and off-shore teams, including hiring and mentoring
team members.
• Over 9 years of IT experience with more than 6 years in Banking and Financial
services domain specializing in Investment and Private Banking
• Good understanding of QA Principals, QA process, Use case and Software
development life cycle- Agile and V-model.
• Develop test plans, test execution plan and involved in preparation of Test
Completion report.
• Managed and led testing team in the planning, execution, and reporting of end-to-
end system integration testing (SIT) and user acceptance testing (UAT) activities.
• Coordinate test execution with project management, development, Business
stakeholders and other internal departments.
• Extensive experience in Datawarehouse, Core banking(Temenos T24, Murex), Web
Application and Functional testing.
• Hands on experience with Test management tools - Quality Center-ALM, JIRA,
JIRA-Agile.

Technical Skills

Database Oracle 10g, Oracle 11i

Temenos T24, Murex, JIRA, Agile JIRA, SPIRA, ALM(Quality


Tools and Utilities Center), UNIX (Putty), Control-M, TWB (Test management), AR Tool
(Remedy)
Skill set Data warehouse, Web Application and Functional Testing

Relevant Project Experience

Project Name BPT (Business Process Test)


(35 Months) Module OM: Order Management
(Duration from Dec 2009 till Oct 2012 )
Technology Siebel, TWB (Test management tool), AR Tool (Defect management
tool)

Project BPT is a company-wide business strategy used in T-COM and was


Objective designed to reduce costs and increase profitability. It has a regression
suite built for testing all the Regression test cases of all the entry
channels and call center application used by the employee of T-COM to
manage customers’ need in order to develop good relationship.

Project CRMT is a web-based application used by the telecom call center agents
Description for CRM. It consists of module called OM (Order management) used for
Service provisioning. It supports major business processes mainly
Provisioning for new/existing customer, change order, and
Cancel/Terminate order, Location change.
Roles • Requirement Analysis
• Reviewing of Test plan, involved in formulating Test strategies
• Created test data and Execution for Order Management
• Design of functional enhancements
• Verification of Business Processes of CRM-T
• Assist Test Manager with testing assignments and reporting up to
client management
• Providing resolution to Production issues
• Mentored and trained new team members

Relevant Project Experience

Project Name COMET


(28 Months) (Duration from November 2012 till February 2015)

Title Credit Suisse Investment Bank – Regulatory IT


Client Credit Suisse Investment Bank
Technology Oracle 11i, Oracle 11g, Control-M, UNIX
Domain Banking –Risk Management (Basel 2, Basel 3)

BASEL III represents the regulatory response of Basel Committee to the Financial Crisis of
2008. In response to these regulatory requirements CS launched a firm wide program
comprising of a CRO and CFO.
Roles • Analysed requirements and identified test scenarios
• Designed and executed test Cases for CR(Change requests).
• Coordinated with developers and business analysts located at
client side.
• Reported new problems found, debugged and provided detailed
information to development.
• Conducted extensive data analysis/verification by writing and
executing complex SQL queries.
• Validation of trades end to end flow in Comet engine.
• Processing and running of Scheduler Jobs through Unix and
Control-M UI.
• Validated datamart reports by cross verifying in database
systems.
• Active participation in weekly status calls, defect triage meetings.
• Prepared daily summary report, involved in preparation of Test
completion Report
Relevant Project Experience

Project Name E-Banking


(12 Months) (Duration from Mar 2015 till February 2016)
Client location - Switzerland (4 months) (Aug 2015 till Nov 2015)
Client UBS Bank
Domain Wealth Management
Project E-banking project involves testing under different platforms,
Description operating systems requested by key clients of the UBS bank. The
objective of the project is to ensure the internet banking application of the
UBS bank works successfully in different environments. The types of
testing involved are browser testing, compatibility testing, web testing and
performance testing. Important functions like payments, information on
cards, accounts are tested to ensure that the e-banking works as
expected.
Roles • Requirements Analysis, designed and executed test Cases and
updating the execution results in QC tool.
• Created test data in CCM tool for different types of contracts.
• Performed testing on various browser versions to check
compatibility of UBS e-banking site,
• Conducted testing on various Mobile devices and operating
systems (Android, iOS).
• Reported on project progress and communicate relevant
information to senior leadership through daily status reports via
email and weekly presentations.
Relevant Project Experience

Project Name Bank Julius Bär- JB 2.0 Asia (Duration from 01 Mar 2016 till now)
(29 Months) Client location - Singapore (8 months) (Mar 2018 till Oct 2018)
Client Bank Julius Bär
Domain Private Management
Technology Temenos T24, Murex, AMLS, JIRA, JIRA(Agile), Oracle 10g

Project Julius Baer Group is a Swiss private banking firm, its function consists
description mainly of asset management, wealth management, investment funds for
private and institutional investors as well as securities and foreign
exchange trading.
The JB 2.0 Asia program involves migration of core banking platform
from Olympic to Temenos(R16) for Asia region(SG and HK).
Testing for RLC project involves testing functionalities incorporated for
Risk, Legal and Compliance departments. All the relevant T24 modules
relevant to products used by bank are tested.
Roles • Oversaw and lead 4 member team from offshore and onshore for
testing of RLC applications (T24 RLC, AMLS applications)
• Prepared FSD for the requirements for newly added
customizations and the existing BRD
• Designed, developed and maintained list of risks, requirements,
and deliverables for change requests related to RLC.
• Reviewed the test cases written by team members. Conduced
peer review of prepared test cases by other testing teams.
• Prepared testing plan and schedule based on development
completion and project timelines.
• Liaison between development team, BA and users..
• Performed testing on AMLS (Anti-Money Laundering System)
application by inputting Securities and Cash transactions
• Created test data, developed and executed test cases for System
Integration, Regression, and User Acceptance testing for RLC
block changes in various T24 modules.
• Performed Blocks Testing on inception and events of Securities,
Cash, Credit, Derivatives, Structured Products carried out and
verified in T24.
• Verification and validation of migration readiness of RLC
applications
• Coordinated UAT of final product and provided customer support
by recreating customer-found problems and finding out root
cause.
Education

Title of the Degree with College/University Year of Passing


Branch
B.E. Mechanical Engineering Govt. College of Engineering 2008
Satara, Maharashtra

H.S.C. AEJC Tarapur, Palghar, 2004


Maharashtra

Certification

ISTQB (International Software Testing Qualification Board) Foundation level

Contact Details:
Mobile No: +91-9975713013
Email Id: [email protected]

You might also like