Tools Worked :-

Platinum Cognizant Tool , SSRS,Microstartegy, Quality Center

Confidential

Confidential

Role

Test Engineer and Test Lead Offshore

Domain

Liquidity Management Systems

Project Description:

The LMS Project was basically designed to optimize the funds of the Citi Bank. The Citi Bank accounts are categorized by different regions and are formed into a Structure . This Structure was mapped with a set of protocols and rules to form an Arrangement . Every Account is set with a strategy to transfer its part of money to the other account daily at the End of the Day EOD . And every account participated in such a sweep has to pay interest based on the Interest calculation done. This Interest Calculation is done at each Start of Day SOD . Any Sweeps missed/failed/improperly swept during the process will be processed later through Recovery Modules. The complete system was called Global Concentration Engine GCE which in turn interacts with the Downstream Systems Flexcube Citichecking for any End of Day runs and generates outputs to these systems. Roles and Responsibilities included:

Requirement Analysis

Reviewed Business requirements, IT Design documents and prepared Test Plan for all the End of day runs of London along with the Recovery.

Involved in testing the new functionalities based on Test Cases and coordinated with development team in fixing the issues.

Ensured that all Test Cases are updated in Quality Center along with Master Test Plan

Involved in Release Support Release to UAT Team, Production analysis, testing the Release process.

Involved in Backend Database Testing in Oracle using SQL in TOAD and Aqua Data Studio.

Defects were tracked, reviewed, analyzed and compared using Quality Center Team mentoring

Confidential

Confidential

Role

Test Lead Offshore

Domain

Liquidity Management Systems

Project description:

• The Existing customers in partner systems namely ZBA Zero Balancing account and CC Citi Checking need to be migrated to GCE Global Concentration Engine . The loading of data from Partners to staging area and migration from there to main systems were validated for exact mapping and test for data integrity is done manually :
• Requirement Analysis
• Mapping Analysis
• UAT Support
• Validation of data
• Test Case and Test Scenario Building
• Test Execution

Confidential

Confidential

Role

Test Lead Offshore

Domain

Capital Markets

Project description:

• The functional solution for the PCF process requires the configuration of FTP sites, AutoSys jobs, and OLE extracts to receive, transmit, and store files. The above activities do not require incremental builds of new systems or processes, only the establishment of new instances, access rights and processes supporting new instances of these pre-existing tools. Incremental technology development will be required to support processing and calculation processes of files within the PCF process. This will primarily be accomplished through the development of the ETF Core Processing Module. Interfaces and connectivity between this new development and existing tools and processes such as AutoSys, FTP sites, and File Directory storage sites will be required. Functional changes to existing BAU processes occur are currently being investigated by Operations in testing scenarios involving the timing of the InvestOne basket and fund interaction process. Roles and Responsibility included:
• Requirement analysis
• Test cases and test Scenarios
• Test Execution
• Co-ordination with Consultants

Confidential

Confidential

Role

Test Lead Onsite and Offshore

Domain

Capital Markets

Project description:

• Equity Trading and Compliance project is aimed at replacing the existing Trade Management System with the new product from Charles River Trading System. This project will include:
• Implementation of Charles River IMS v8.1.3.1, which includes the following modules:
• Manager Workbench
• Trader
• Compliance
• Establishing specific automated Interfaces between Charles River IMS and:
• Ameriprise's legacy upstream/downstream systems
• External service provider systems
• Market data providers
• The interface layer, which will provide coordination between Charles River IMS and other system, will be called as
• ETC Interface Layer. The Equity Trading and Compliance Project will replace some functionality currently available
• from the internally-built Trade Management System TMS and provide additional functionality to support multi-
• Currency, T 1 trade settlement, additional security types, electronic connectivity to brokers and ECNs.

Roles and Responsibility included:

• Requirement analysis
• Test cases and test Scenarios review
• Test Estimation
• Enterprise testing Execution
• UAT support
• Defect Coordinator
• Volume testing Coordinator

Confidential

Confidential

Role

Test Lead Onsite

Domain

Capital Markets

Project description:

• Migrate the Investments owned assets accounting system, PAM application from MDC to St. Louis/Lexington.
• Additionally, the scope of the project included additional architectural configurations like
• Upgrade the database from SQL 2003 to SQL 2008
• Migrate the schedule from Jobtrac to TWS
• Migrate all the FTP's to MFT based file transfers
• Decommission ISS Mailers and instead send mails through SMTP
• Access to PAM Application in Lex/ ST Louis servers.
• Batch Schedule is done through TWS.
• Mainframe dependencies will be removed.
• PAM Application will MFT the feeds to destination server.
• PAM Application will send the mail via SMTP.
• Business user will be having access through the Citrix similar to as-is.
• Citrix LAN will be a file share in LEX.
• Roles and Responsibility included:
• Requirement analysis
• Test cases and test Scenarios review
• Test Estimation
• Enterprise testing Execution
• UAT support
• Defect Coordinator
• Volume testing Coordinator

Confidential

Confidential

Role

Test Lead Onsite

Domain

Capital Markets

Project description:

Fund of Funds Operation Consolidation is a project to consolidate the legacy River Source and legacy Columbia fund of funds operations to bring FOF Operations under Ameriprise umbrella It allows the comfort of the existing process/ operation steps to the respective portfolio managers to accomplish their fund of fund operation as it is The portfolios included are retail, and VP Funds. In addition to these, this project also focused on operation and execution of Institutional Mutual Funds. Fund of funds operation is dependent on various cross-commit systems viz. LVTS- the equity trading system, Aladdin- the fixed income trading system, TNM, TAs both internal and external , Custodian, DI/ETL, Accounting systems like Invest One, GIM, Allocators systems like MFIS, CITSS.

Roles and Responsibility included:

• Requirement analysis
• Test cases and test Scenarios review
• Test Estimation
• Enterprise testing Execution
• UAT support
• Defect Coordinator
• Volume testing Coordinator

Confidential

Confidential

Role

Test Lead Onsite and Offshore

Tools and technologies

Informatica,SQL developer and Unix

Project description:

• Money laundering is the process of disguising illegal sources of money so that it looks like it came from legal sources. Today, most financial institutions globally, and many non-financial institutions, are required to identify and report transactions of a suspicious nature to the financial intelligence unit in the respective country anti-money laundering software filters customer data, classifies it according to level of suspicion, and inspects it for anomalies.
• sudden and substantial increase in funds
• a large withdrawal
• Moving money to a bank secrecy jurisdiction.
• Smaller transactions that meet certain criteria may be also be flagged as suspicious.
• The software will also flag names that have been placed on government blacklists .
• Transactions involving countries that are thought to be hostile to the host nation
• Roles and Responsibility included:
• Requirement analysis
• Test Planning
• Test cases and test Scenarios review
• Test Estimation
• Test Execution
• UAT support
• Defect Coordinator
• Volume testing Coordinator

Confidential

Confidential

Role

Test Lead Offshore

Tools and technologies

Informatica,SQL developer and Unix

Project description:

Aztra Zeneca :- This is a life science account where the sales from different source channels are being migrated from source to Target

Roles and Responsibility included:

• Requirement analysis
• Test cases and test Scenarios review
• Test Estimation
• Enterprise testing Execution
• UAT support
• Defect Coordinator
• Volume testing Coordinator

Confidential

Confidential

Role

Test Lead Offshore

Tools and technologies

Informatica,SQL developer and Unix

Domain

Life Sciences

Project description:

• This is a life science account where the sales from different source channels are being migrated from source to Target. Below of the data sets involved
• Valuecentric data Latest file available from vendor will be leveraged
• DDD data Latest monthly snapshot of data will be refreshed from PROD database into TEST database
• Call Activity data Account level call data available in TEST database will be leveraged for this testing
• Account Master Latest version of published Account Master information will be loaded into DW and leveraged for testing
• MARS data Latest version of Spec. Sales Force alignment information will be loaded into TEST database and used for the data processing as a part of this UAT
• Product/Market info Latest version of IBD market information in TEST database will be leveraged for this UAT

Roles and Responsibility included:

• Requirement analysis
• Test cases and test Scenarios review
• Test Estimation
• Enterprise testing Execution
• UAT support
• Defect Coordinator
• Volume testing Coordinator

Confidential

Role

Test Lead Oniste

Tools and technologies

Informatica,SQL developer and Unix

Domain

Life Sciences

Project description:

• This is a Life science account where the sales from different source channels are being migrated from source to Target. Below of the data sets involved
• Build process to onboard de-identified patient service data from following providers via SHA:
• Epsilon CRM patient level De-identified data feed
• Epsilon Patient service data De-identified data feed
• OPUS Co-Pay Data Redemption patient level De-identified data feed
• Pharmacy solutions Pharmacy patient level De-identified data feed
• Specialty Pharmacy Pharmacy patient level De-identified data feed

Roles and Responsibility included:

• Requirement analysis
• Test cases and test Scenarios review
• Test Estimation
• Enterprise testing Execution
• UAT support
• Defect Coordinator
• Volume testing Coordinator