Manager Data
Resume:
Sreevidhya Gayathri K.R
**** ***** ****, *** ****, Charlotte NC 28262
Email: ******************@*****.*** 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