Sreevidhya Gayathri K.R

**** ***** ****, *** ****, Charlotte NC 28262

Email: adkckm@r.postjobfree.com Mobile: 704-***-****

PROFESSIONAL SUMMARY

Techno Functional Onsite Lead with expertise in requirements gathering, analysis, architectural, component and interface design with emphasis on Quality Assurance & Software Testing

11+ years of experience in Data Warehousing/ETL Test Data Management on varied environments of Oracle, SQL Server, Informatica TDM, IBM Netezza

Business strategist - Manage Projects, aligning business goals with technology to drive Solutions with hands on functional knowledge on various domains like Finance & Banking on ETL/Database management

End to End Test Lead for testing and reviewing data maps/requirements across all stages of Software Testing Life Cycle (STLC)

Hands on experience in Test Automation using Selenium Web-Driver with Java and QTP and automation frameworks: Data Driven, Keyword Driven, Hybrid

Hands on experience in Web-service tools: SOAP UI, Solace Xpath and IBM MQ

Charles River’s (CRD) Trading – order and execution management solution with hands on experience on

-Executed Portfolio Manager and Trader End to End workflows in PM, Trader, OPS blotters

-Verified and validated Trade workflows in CRD for Portfolio Manager and Trader covering Equity, Futures, FX and Bonds asset classes, FIX message protocol

-Validation of placements, fills, executions, allocations covering multi dimensions like Funds, strategies, Execution brokers, Clearing Brokers, Prime Brokers

-Good understanding of CRD SQL schema and tables

-Working knowledge of CRD’s Security Master, Compliance, Blotters, Placements, Fills, Allocations, FIX connectivity

Charles River Anywhere (CRA) module, considerate knowledge of below

-CRA’s - Accounts, Compliance and Orders module/tab

-Creation and monitoring of compliance alerts and events

-Management of compliance rules pertaining to Regulatory rules, client mandates, manual, PM specific

-Creating managing asset allocation

-Assess exposure as per asset class, country, region

-Impact of proposed orders on Account or Fund exposure

-Create view edit order details and allocations

In-depth knowledge of Agile methodology, Software Testing Life Cycle, which includes requirements gathering & analysis, test planning, test execution, defect reporting and root cause analysis

Expertise in creating HP ALM report for the project management

SKILL SUMMARY

Databases

Oracle 10g, Teradata, MS SQL Server and z/OS, IBM Netezza, Google Cloud Platform console

ETL

Informatica TDM, Oracle Warehouse Builder (OWB)

Languages

PL/SQL, Unix, HTML, Java, JavaScript VBA Scripting with Excel Macros, C

SQL Tools

Toad Data Point and Toad for Oracle, Oracle 10g PL SQL developer, Teradata SQL Assistant

Testing & Reporting Tools

HP Quality ALM, Eviware Soap UI 2.2, IBM Rational Service Tester, IBM Rational Functional Tester, Eclipse 3.1.1, Informatica ILM

Domain

Capital markets, Commerical Banking & Financial Services, Credit Space, Anti Money Laundering & Fraud, CRM – Account Management

Functional

Agile & Iterative based Software Testing Life Cycle, End to End Test Lead (DIT, SIT, UAT and Change Management)

Certifications

Oracle 9i

ISTQB - Foundation level

Informatica Certified – ILM

IBM Certified Solution Designer - Rational Functional Tester for Java

IBM Clear Quest

General Banking & Financial Services

PROFESSIONAL EXPERIENCE

Test Coordinator, Aetea (AAA insurance client)

Sep 2020 – Till date

Lead Quality Control, Synechron

Nov 2016 – August 2019

IT Analyst, Tata Consultancy Services

Dec 2008 – Nov 2016

ACHIVEMENTS

1.TCS Star perfomer in team quarterly basis for 3 times

2.TCS On spot award (monthly basis) for 2 times

3.Synechron Surpass award winner (Quarterly basis)

4.Synechron On spot award (monthly basis)

Projects, Roles & Responsibilities

ADW/ EDW dataset in Google cloud platform

Client : AAA midatlantic,PA

Employer: Aetea

Role : Test Coordinator

Project Date: Sep’2020 to Till date

Technical Platform: Google cloud platform, SQL server, Jira

AAA midatlantic club membership moving data from SQL server to google cloud platform for creating dashboard & reports on market analytics campaigning.

The project is aimed to achieve complete migration of legacy applications used in market analytics campaigning into google cloud platform

Test Functional Lead - Resource Estimation, Test Plan & data review, Requirements Gathering and test execution traceability, review the same with Senior Management/Project Manager for approvals.

Review & Create functional, regression & smoke test for the data migration from SQL server to Google cloud platform

Tracking test coverage and traceability for the technical stories in the JIRA

Participating in the creating acceptance criteria for the JIRA stories

Creating and publishing test scripting/ execution status with project team and involved in defect triage meeting

Analysis of test requirement and automation feasibility

Liaison with Business Analyst Teams and Technology teams to understand the business/test requirements

Prepare Testing Artifacts – Test plan, test execution report, test summary and entry/exit document, user acceptance test scenario

As part of Integration with membership, D3, epic, vast and other systems coordinate with respective stakeholders and conduct End to End testing across the systems

Address any issues faced by UAT team which include but not limited to test data, business requirements and non-functional aspects

Charles River Investment Banking Services – CRD & IDS Support GUI

Client : Wells Fargo, Charlotte, NC

Employer: Synechron Inc

Role : Onsite Test Lead

Project Date: Jun’2017 to Aug’2019

Technical Platform: PL/SQL developer, Toad, HP Quality Center ALM

Wells Fargo Advisory group is building a customized tool for handling/maintaining day to day trading/settlement, accounting, asset & security management. Investment operator using trust system for performing trading and WDM for maintaining wealth asset.

The project is aimed to achieve complete migration of legacy applications used within the Investment Banking trading platform to a new tool - Charles River (CRD and CRA).

Business Functional Lead - Resource Estimation, Test Plan & data review, Requirements Gathering and test execution traceability, review the same with Senior Management/Project Manager for approvals.

Review & Create functional, regression & smoke automation test scripts using Selenium Webdriver java scripting and reporting using TestNG

Creation and maintenance of vendor automation framework customized to business needs

Creating and publishing automation scripting/ execution status with project team and involved in defect triage meeting

Analysis of test requirement and automation feasibility

Liaison with Business Analyst Teams and Technology teams to understand the business/test requirements

Prepare Testing Artifacts -

As part of Integration with trust, WDM and other systems coordinate with respective stakeholders and conduct End to End testing across the systems

Address any issues faced by UAT team which include but not limited to test data, business requirements and non-functional aspects

Track defects to closure in Quality Center

GE Capital Finance - My Accounts

Client : Wells Fargo, Charlotte, NC

Employer: Synechron Inc

Role : Onsite Test Lead

Project Date: Dec’2016 to Jun’2017

Technical Platform: PL/SQL developer, Toad, HP Quality Center ALM

Wells Fargo acquired GE Capital Financing Mar 2016. The project within the bank is aimed to achieve complete migration of legacy application of GE. Failure to adhere to this would result in non-compliance to Wells Fargo standard.

Lead a team of 8 members (Onsite & Offshore) to migrate 120 application used by GE Capital Financing to Wells Fargo .

Creation of functional, regression & smoke automation test scripts using Selenium Webdriver java scripting and reporting using TestNG

Creation and maintenance of vendor automation framework customized to business needs

Creating and publishing automation scripting/ execution status with project team and involved in defect triage meeting

Analysis of test requirement and automation feasibility

As part of Integration with ePay, ISM and other systems coordinate with respective stakeholders and conduct End to End testing across the systems

Track defects to closure in Quality Center

CCAR (Comprehensive Capital Analysis and Review)

Client : Bank of America, Charlotte, NC

Employer: Tata Consultancy Services Ltd

Role : Onsite Test Lead

Project Date: Nov’2015 to Nov’2016

Technical Platform: Informatica TDM, Unix Autosys, PL/SQL developer, Toad, HP Quality Center ALM

Comprehensive Capital Analysis and Review (CCAR) is a regulatory framework introduced by the Federal Reserve in order to assess, regulate, and supervise large banks and financial institutions - collectively referred to in the framework as Bank Holding Companies

The project within the bank is aimed to achieve complete compliance within the Stress Test Environment. Failure to adhere to this would result in non-compliance.

Singlehandedly managed conversion of data from an external Credit loan Oracle system to an internal CCAR compliant database.

Liaison with Business Analyst Teams and Technology teams to understand the business/test requirements

Prepare Testing Artifacts - Estimation, Test Plan, Test data creation, requirement and test execution traceability and review the same with Senior Management/Project Manager for approvals

Migrating Prod Data to QA environments by masking client indicative data and encrypting data based on business requirements on Informatica ILM

As part of Integration with credit system AFS and document repository VV, ECF, CREF EF, coordinate with respective stakeholders and conduct End to End testing across the systems

Address any issues faced by UAT team which include but not limited to test data, business requirements and non-functional aspects

Track defects to closure in Quality Center. Attending Scrum meeting and tracking & reviewing user stories

Metadata Portal

Client: Bank of America, Charlotte, NC

Employer: Tata Consultancy Services Ltd

Role: Onsite Test Coordinator

Project Date: Apr’2015 to Nov’2015

Technical Platform: Unix Autosys, PL/SQL developer, Toad, HP Quality Center ALM

MDP is centralized hub of all business objects used across GCCIBT applications.

Metadata refers to the capturing and maintaining of information about critical data including business and technical definition, business rules for quality and integrity, controls to which the data is subjected to across its life cycle, accountability for the data across the organization, and how it moves across the environments.

Significant Value Add: Developed Java code to convert XML extracts into excel for data conversion

Liaison with Business Analyst Teams and Technology teams to understand the business/test requirements

Prepare Testing Artifacts - Estimation, Test Plan, Test case, requirement and test execution traceability and review the same with Senior Management/Project Manager for approvals

Develop and Review Test cases in Quality Center for ETL Test cases and functional test cases

Migrating Prod Data to QA environments by masking client indicative data and encrypting data based on business requirements on Informatica ILM

As part of Integration with Adaptive UI and InfoPortal, coordinate with respective stakeholders and conduct End to End testing across the systems

Address any issues faced by UAT team which include but not limited to test data, business requirements and non-functional aspects

Track defects to closure in Quality Center

Credit Electronic Document Repository (CEDR) Implementation

Client: Bank of America, Charlotte, NC

Employer: Tata Consultancy Services Ltd

Role: Onsite Test Lead

Project Date: Aug’2014 to Mar’2015

Technical Platform: Unix Autosys, PL/SQL developer, Toad, HP Quality Center ALM, SOAP UI

A WBDR environment was proposed where all Clients’ Electronic Documents would utilize a common repository called Client Electronics Document Repository (CEDR). A Credit Integrated Platform would be utilized to do a Comprehensive search across the repositories (including the CEDR, CREB EF, ECF and Virtual Vault). Appian UI screen will have all Users’ Usability features for Comprehensive search, view client and document metadata and perform indexing along with security user entitlement.

Coordinate with the customer and the project team to understand the business/test requirements

Calculate test estimates from the business requirements depending on feature complexity

Validate CEDR data model to meet all high-level business/test requirements

Validate the ETL/web service and functional specifications to meet the business/test requirements

Create Test Plan and Test Strategy documents clearly stating the scope, assumptions and constraints involved

Co-ordinate with offshore test team to identify the high-level test scenarios and test cases

Support offshore test team during test execution providing necessary inputs wherever required

Conduct defect review calls and work closely with 10 upstream UI teams for End to End testing

Report consolidated status to Project Manager on a daily basis/SCRUM Calls

Legal Entity Onboarding (LEO) Implementation

Client: Bank of America, Charlotte, NC

Employer: Tata Consultancy Services Ltd

Role: Onsite SIT IV&V Test Lead and UAT Coordinate

Project Date: Jan’2012 to Jul’2014

Technical Platform: Unix Autosys, PL/SQL developer, Toad, HP Quality Center ALM, SOAP UI, QTP

Legal Entity On boarding - LEO has been deployed in a series of incremental projects (LEO 1.0 to LEO 4.0), replacing several legacy applications that performed Anti Money Laundering (AML)/Know Your Customer (KYC) legal entity on-boarding and were not well-aligned with BAC AML Policy. As a result LEO was created as a system of record (SOR) for AML/KYC data for GBAM and GCB

Significant Value Add: Developed an automated test script using QTP with excel framework to enable dynamic data capture from field values, resulting in saving 50%-man hours during regression testing

Coordinating with UAT test teams and clients to prepare UAT Test plan, test case assignment, test data set up and test case execution

Supporting APAC, LATAM, EMEA and AMER regions - user test execution

Preparation of Test Plan – Scope, Estimates, Schedule

Developing and Reviewing Test cases in Quality Center for ETL Test case and functional test case

Executing the Test cases in Quality Center Test Lab

Conducting the Daily meeting to review Current Day’s progress with respect to Previous Day’s Progress, Task plan for next day

Training and mentoring new resources at off-shore team and UAT user

Account Relationship Data Quality

Client: Bank of America, Charlotte, NC

Employer: Tata Consultancy Services Ltd

Role: ETL/Web Service Test Lead

Project Date: Apr’2011 to Dec’2012

Technical Platform: PL/SQL developer, Toad, HP Quality Center ALM, Netezza Squirrel client, Micro strategy reports

Significant Value Add: Manual Integration of Results with QC using a Java Program

Developed and Tested two separate schema’s – XRF (Account Cross Reference) and PAX (Party to Account Cross Reference);

Designed a comprehensive view of a party’s relationship to effectively manage regulatory, risk, sales and operational processes.

Enhanced the ability to see all accounts associated with a party along with the role that the party plays on that account (e.g., owner, co-owner, guarantor, etc.).

Streamline the XRF schema as subset of PAX to obtain comprehensive view (tree-based view)

Enterprise Client Data Management

Client: Bank of America, Chennai – India

Employer: Tata Consultancy Services Ltd

Role: Web Service Test Lead

Project Date: Dec’2008 to Mar’2011

Technical Platform: PL/SQL developer, Toad (DB2 and Oracle), HP Quality Center ALM, Netezza Squirrel client, SOAP UI, IBM RST

Bank of America Corporation’s (“Bank of America”) Policy on Money Laundering and Anti-Money Laundering Program (“AML Policy”) establishes a principle-based framework of minimum standards to comply with the applicable anti-money laundering legal and regulatory requirements in the jurisdictions in which Bank of America and its subsidiaries and affiliates (collectively “affiliates”) operate.

The KYCS 4.0 project consists of features aimed at enhancing application productivity through a variety of usability enhancements, by refining system and business rules logic and by addressing existing production concerns

Analyzing manual test cases and preparing backend test scripts for manual test cases

Debugging and maintaining the scripts

Peer review for DB test scripts and checking if the transformation rules are applied.

E D U CA TI O N

Year

Examination

Institution

GPA

2008

BE, Computer Science & Engineering

ACCET, Anna University

8.2 (Gold Medal)

Contact this candidate