Ramyadharshini Vijayakumar ***, Woodward Street, Jersey City, NJ 07304 +1-201-***-**** ********@*****.***
CAREER
• 5+ years of experience in software development and testing for the Bank of New York Mellon in Banking and Securities domain.
• Over 2 years of experience as Technical Lead – QA in functional testing, preparing test plans and estimates, allocating and reviewing the artifacts, preparing metrics, resource management and team mentoring for Broker Dealer Clearance– A project for US Federal Reserve at the Bank of New York Mellon, 1 Wall Street, New York, NY – 10286.
SUMMARY
• Highly motivated, solutions-driven developer and QA tester with proven skills and experience in the Banking and IT domain.
• Proficient in software development lifecycle including test strategy preparation, test plan development, test case creation, test case execution and bug tracking.
• Experience in testing web applications in Waterfall and Agile development process.
• Expertise in UNIX scripting and developing test scripts for functional testing of various applications.
• Excellent Interpersonal and communication skills with the ability to remain highly focused and self-assured in a fast-paced environment.
EXPERTISE DETAILS
• Expertise in analyzing requirement specifications and developing test cases, test scripts and planning for QA methodologies in banking related applications
• Knowledge of software testing methodologies like Waterfall and Agile (Scrum).
• Software Testing and Documentation and review of Business Requirements.
• Expertise in preparing Test Summary Reports, Test Cases and Test Scripts for manual testing based on the User Requirements, System Requirements documents and UAT
• Knowledge and experience with the complete Software Development Life Cycle including requirements, design, development and testing.
• Excellent knowledge in RDBMS, Sybase and Oracle9i using Transact-SQL and SQL procedures for database backend testing.
• Ability to work on both Unix and Windows platforms
• Automation using Unix Shell and Perl programming to support testing activities.
• Exposure in coordination between onsite-offshore team and defect management.
• Ability to investigate technical problems and write clear and detailed reports.
• Possess excellent analytical skills with good communication and self-organizing skills.
• Ability to lead testing efforts with Business Analysts, developers, product owners, customers and offshore QA testers.
EDUCATION
Sri Krishna College of Engineering and Technology,
Anna University, Coimbatore, India.
Bachelor of Technology (Information Technology)
TECHNOLOGIES
Business Modeling Tools Rational Rose, Microsoft Visio, MS Project, UML, Caliber
Defect Tracking Tools Rational Clear Quest, Quality Centre
Microsoft Tools MS Word, MS Excel, MS PowerPoint
Reporting Tools Hummingbird BI Query
Operating Systems MS Windows 95/98/NT/2000/XP, Unix, Linux
Programming Languages C, Perl
Scripting Languages UNIX Shell Scripts
Databases Sybase, Oracle, SQL
Other Tools HP PPM (Project and Portfolio Management), SSR(Smart Stream Reconciliations), SMART, BMC Remedy, RFH Utils, RUMBA, IBM Maestro, SQL Advantage
PROJECT DETAILS
Project 1#
Project : Broker Dealer Clearance Application
Role : Quality Assurance Lead
Duration : Mar 2010 – Jan 2012
Company : Bank of New York Mellon
Team Size : 14
Technologies/Tools Used : Adobe Flex, Java, UNIX Scripts, QTP, Oracle, Quality Center, Caliber, Clear Quest, RFH Utils
Description of project : The Broker Dealer Clearance (BDC) Application provides clearance and settlement functionality for government securities for use by BNY Mellon. This project is a US Federal Reserve mandate to migrate the BNY Mellon specific systems, namely the Government Securities Clearing Exchange (GSCX) and the Clearing System of the Depository Trust Company (DTC) to the new BDC system. These existing systems run on the Open Virtual Memory System OS and will now port it to latest Java technology to improve maintainability and efficiency.
The intraday market is of the order of 3 trillion dollars and the agreements create a huge market in terms of dollars. Given the extraordinary nature and volume of data that it handles, the new system is required to be as efficient and robust as the current system. The project is extremely critical and important from the BNY Mellon point of view because of the importance given to it by the US Federal Reserve.
Responsibilities:
• Analysis of Use cases and design of Functional test scripts.
• Creation of Test cases for every sprint in accordance with the Agile Methodology.
• Resource allocation and Estimate planning for in-sprint testing for a 14 member team (onsite and offshore).
• Functional testing within the Sprint.
• Co-ordination with developers on in-sprint issues and deliverables.
• Onsite-Offshore Co-ordination.
• Live demo on sprint deliverables to Product owners and SMEs.
• Allocation and review of artifacts.
• Mapping of test cases to requirements in Quality Center.
• Preparation of Status Report and other metrics for overall release.
• Preparation of In-Sprint testing report to scrum master.
• Preparation of Business Understanding Document.
• Training to regression team on Sprint deliverables.
• Support and monitoring Regression Testing.
• Creation of Automation Test Plan.
• Execution of QTP automated test scripts.
Project 2#
Project : WINNAR
Role : Senior Applications Developer and Tester
Company : iNautix Technologies India Private Limited, A Subsidiary of Bank of New York Mellon
Duration : Jan 2007 – Feb 2010
Team Size : 10
Technologies/Tools Used : Perl, Shell, C, Java, Sybase, Quality Centre, Remedy, Rumba
Description of project : The WINdows Nostro Account Reconciliation (WINNAR) system was designed and developed to be a fully integrated reconciliation and investigations system for handling cash, securities and holdings. WINNAR uses the standards set by the Society for World-wide Interbank Financial Telecommunications (SWIFT) and requires that data be transmitted in this pre-determined format. The system converts Ledger information generated by BNY Mellon and statement information received from external sources such as correspondent banks, custodians, agents, etc. in SWIFT format. It reconciles Ledger information and statement information and stores the details in a pre-defined database. WINNAR also generates reports for the custodians from the database.
Responsibilities:
• Detailed analysis and design for the functions and sub-systems involved
• Development using Perl and Unix with Sybase Database as the backend
• Preparation of effort estimates for fast track projects, including resource requirements, high level impact analysis
• Prepare testing environments and data loading
• Creating test cases for unit testing and quality assurance testing
• Interact with the application users and prepare servers for testing
• Oversight and tracking of the project implementation
• Providing technical expertise and mentoring development team members
Project 3#
Project : Confirmations Matching System
Role : Senior Applications Developer
Company : iNautix Technologies India Private Limited, A Subsidiary of Bank of New York Mellon
Duration : Jan 2007 – Feb 2009
Team Size : 5
Technologies/Tools Used : Unix Shell scripts, C, Oracle, Quality Centre, Rumba, Maestro
Description of project : Confirmations Matching System (CMS) was designed and developed to perform reconciliation of three types of Society for World-wide Interbank Financial Telecommunications (SWIFT) confirmation messages, namely MT300, MT305 and MT320. It performs automatic matching of trade confirmations between BNY Mellon and its counterparties and/or confirmations from the broker. Its purpose is to automate the manual functions involved and to identify differences in a timely manner, to prevent subsequent compensation claims due to discrepancies in the trade/settlement details recorded by BNY Mellon versus the Counterparties. This project also enabled confirmation matching for the Wall Street System (WSS).
Responsibilities:
• Requirements gathering for functionality enhancements
• Redesign of application architecture for enhancements
• Analysis of UML diagrams and development of test scripts.
• Project time tracking, defect tracking and status reporting.
• Functional testing and system regression testing.
• Interaction with various business users for UAT testing.
• Lead a team of 5 members during the period of project execution.
• Project implementation and user-guide documentation.
Project 4#
Project : Hummingbird BI Query Reporting
Role : Senior Applications Developer & Tester
Company : iNautix Technologies India Private Limited, A Subsidiary of Bank of New York Mellon
Duration : Nov 2008 – Dec 2009
Team Size : 4
Technologies/Tools Used : SQL, Hummingbird BIQuery, Quality Center
Description of project : BI/Query is Graphical User Interface (GUI) tool. It is a windows-based, "point and click" application that provides a graphical gateway to the WINNAR databases. It gives business users and decision makers a way to turn raw data into useful information. The back end to the tool is the WINNAR database (A Sybase DB). WINNAR demands report creations through BI Query. It involves the creation of adhoc queries to gather the information as required by the BNYM users, located in 20 different WNR branches around the world. The result set obtained as a result of the query is to be converted into professional reports by formatting through BI Query.
Responsibilities:
• Requirements gathering and review with users and documentation.
• Design and development of reports from Transact - SQL.
• On-call user co-ordination during project implementation. Detailed documentation for installation
• Test cases review and testing co-ordination with BNY Mellon users
• Project time tracking, defect tracking and status reporting
• Subject matter expertise and provide guidance to report users
• Lead a team of 4 members and active knowledge transfer to them.
CERTIFICATIONS
• Completed PershingMind Certification on UNIX Shell Scripts.
• Completed PershingMind Certification on Securities Industries.
ADDITIONAL RESPONSIBILITIES
• Sound domain knowledge in Broker Dealer Services and Payment and Reconciliation Systems in Banking & Securities domain.
• Excellent customer service with sound oral and written communication skills.
• Determining the root causes of defects to prevent the recurrence of the same.
• Timely escalation of unresolved issues to appropriate personnel within Sprint in Agile process.
• Provide technical and applications level assistance to BNYM users across the globe over phone/mail.
• Detailed documentation of systems, in the form of Manuals and Wiki pages for knowledge management and future reference to describe program evaluation, testing and correction.
• Coordinating production moves, trouble-shooting production issues & fine-tuning applications.