GEETHA CHALAMANI

* ********** ***,

Hopkinton, MA 01748

Mobile: 617-***-****

Email: adjkx3@r.postjobfree.com

Profile

●Over 14 years of experience in QA and analysis domain and as a Technical Test Lead and Technical Test manager

●ISTQB Certified tester

●9 years of QAT leadership on ETL testing

●Strong background in QA processes and methodologies

●Work with product development, in coordination with Director of QA to define, iterate, document and enforce QA procedures

●Extensive experience in smoke, functional, migration, integration, user acceptance and regression testing

●Excellent analytical skills business technical requirements

●Exceptional database skills including ETL

●Experience in web and mobile application testing

●Experience in various test automation tools

●Strong technical trouble-shooting skills

●Hands on experience in Agile software development methodologies

●Good domain knowledge of financial, banking, retail industries

●Self-motivated, very well organized, comfortable working in a multi-tasking and fast-moving project environment, and known as a "highly organized and productive employee"

●Excellent verbal and written communication skills

Technical skills:

Databases: Oracle 9i, 10G, SQL Server 7.0, MS-Access, DB2 Main frames

Database tools: Oracle SQL Developer, Aqua Data Studio, Toad, Query Analyzer SQL Server 7.0, MS-Access, SQL Server management studio and Informatica

Test automation Tools: Mercury tools, Quick Test PRO, Load Runner, Selenium, Junit, Fit Nesse, BI tester tool, Perfaware

Operating Systems: Windows, Linux, UNIX

Defect Tracking Tools: ALM, Quality center, TestRail, Jira, Confluence, JIRA, Clear Quest, Bug tracker and Peregrine

Other: Data Lake, Java Web services, J2EE Web services, XML, Business Intelligence Micro strategy tool, Informatica, Postman, Swagger, git, bitbucket, Rapid SQL, Jenkins, CRM Admin tool, Investor 360 message, Journaling mailbox

Education: Bachelors in Computer Science

University: Sri Venkateswra University, AP, India

Certifications: FICO, ISTQB and Oracle 9i DBA level 1 from Boston University

References: Will be provided as needed.

Experience:

Advisor 360, Weston, MA from Dec 2019 to Current

Advisor360 is the only SaaS platform that has it all—CRM(Customer relationship management), performance reporting, financial planning, trading, model management and rebalancing, operations and workflow, analytics, and document imaging. Advisor360 is the unified platform that drives advisor productivity and satisfaction

Key Responsibilities:

Developing Test plan, Test cases and review with Business

Functional & Integration validation for CFN & MML clients

Functional validation of creating Primary,Additional Business users on CRM Admin tool

Functional validation of creating Investor360 messages and comparing with Journaling mailbox and mobile app

Creating SQL queries for both client’s data comparison with front end functionality

Test case execution on TFS

Lead Prod releases for CFN & MML clients

Execute automation scripts on Jenkins

Leading a team of off-shore QA engineers and coordinate

Test case and SQL queries review which created by on site and offshore QA

Review test results and defects generated by offshore and on site QA team before project then to client

Triaging defects with all stakeholders

Key Achievements:

Mentored onsite and offshore team on creating and executing test cases and organizing

Improved Defect life cycle process across multiple teams

Improved quality of BA documents by finding invalid DB table's info

Experience:

Citizens Bank, Cranston, RI from June 2013 to Nov 2019

Position: Technical Test Lead and Technical Test Manager

Projects worked on:

Real Time Payments: RTP is expected to drive significant market change through innovative features such as 24/7/365 money transfers

Key Responsibilities:

●Building a team of off-shore and on-site QA engineers

●Working with product managers and business analyst to gather and analyze functional requirements

●Creating test plan, test strategy and test cases for smoke, functional, regression and user acceptance tests

●Review test plan, test strategy and test cases with Business

●Execute them on ALM for data validation after ETL job runs in SIT environment

●Gathering and managing test data for large scale projects like data warehouse

●Data analytical and Interfacing testing for multiple domains on Finance and Banking

●Tests data movement based on the Data Lake Mapping Requirements

●Creating and executing SQL queries for data validation between source and target

●Data validation between Data Lake and Source tables

●Validation of structured/semi-structured/unstructured, raw data from End to End based on Validation and Reconciliation Rules

●Creating defect reports and running daily triage with business, technology stakeholders

●Send daily status report to management team

Commercial Profitability Relationship: The CPR Dashboard is a platform providing an integrated solution that links Wholesale customer and account information

Key Responsibilities:

●Review business requirements and create test plan, test strategy documents

●Working in Agile model creating backlogs, stories, estimations and prioritization

●Create Jira stories for QA documentation and assign to test team

●Creating test cases for smoke, functional, regression and user acceptance tests

●Get the review done with Business for test plan, test strategy and test cases

●Upload them in to ALM and execute them for data validation

●Creating SQL queries based on mapping doc for data validation source vs target tables after ETL job runs in SIT environment

●Validation of web-based applications on Java environments in QA and UAT

●Data validation of

●Validation of web services testing to check request and response using Postman

●Validation of request and response on database tables

●Hands on Mobile experience on Android, iphone, ipad and mac devices

●Daily coordination with offshore Dev and QA team

●Creating Jira stories for Defects and assign them to dev team

●Send a detail defect report to management and dev team before triage meetings

●Send daily status report to management team

●Demo’s on defects to user before the fix and after the fix

●Generate a QA completion report before each release and send it to dev, management team

●Proposing and implementing best practices towards process improvement

●Lead, direct and motivate a culture of quality improvement across program and business teams to eliminate inefficiencies/defects and drive root cause analysis, lesson learning

●Mentoring junior testers

CRM (Customer Relationship Management):- The CRM Dashboard is a platform providing an integrated solution that links Wholesale customer and account information obtained from the bank’s various source systems with the key credit risk management functions primarily to perform ratings, tracking, profitability measures and other services of commercial loan portfolios for the bank Salesforce.

Key Responsibilities:

●Review business requirements and create test plan, test strategy documents

●Creating test cases for smoke, functional, regression and user acceptance tests

●Get the review done with Business for test plan, test strategy and test cases

●Upload them in to ALM and execute them for data validation

●Creating SQL queries based on mapping doc for data validation source vs target tables after ETL job runs in SIT environment

●Validation of web-based applications on Java environments in QA and UAT

●Send a detail defect report to management and dev team before triage meetings

●Send daily status report to management team

●Generate a QA completion report before each release and send it to dev, management team

●Proposing and implementing best practices towards process improvement

●Lead, direct and motivate a culture of quality improvement across program and business teams to eliminate inefficiencies/defects and drive root cause analysis, lesson learning

●Mentoring junior testers

Loss Data Implementation (Wholesale and Retail): - LDI is to provide available loan loss data to CFG analytic modeling and forecasting Groups.

Key Responsibilities:

●Based on requirements creating test plan, test strategy documents

●Creating test cases for smoke, functional, regression and user acceptance tests

•Test case traceability with business requirements and Execute them through a test plan

●Creating SQL queries based on mapping doc for data validation after ETL job runs in SIT environment

●Data validation source file to stage and stage to target tables

●Review test results and defects generated by off shore and on site QA team before project then to client

●Daily coordination with off-site QA and dev teams

●Creating defect reports and running daily triage with business, technology stakeholders

●Mentoring junior testers

Treasury Data Platform: - TDP is responsible for providing the customer and account related risks arising out of the mix of loans, deposits, securities, debt, financial derivatives managed by Citizens bank.

Key Responsibilities:

●Analysis of Business requirements and create test plan, test strategy

●Creating test plan, test strategy and test cases for smoke, functional, regression and user acceptance tests and review with Business

●Test case traceability with business requirements and Execute them through a test plan

●Creating SQL queries based on mapping doc for data validation after ETL job runs in SIT environment

●Data validation source file to stage and stage to target tables

●Daily coordination with off-site QA and dev teams

●Test case and SQL queries review which created by onsite and offshore QA

●Review test results and defects generated by offshore and onsite QA team before project then to client

●Creating defect reports and running daily triage with business, technology stakeholders

●Mentoring junior testers

Compass: - Accurate downstream reporting and differentiation of the US Bank accounts requires that CFG identify accounts that are held for sale.

Key Responsibilities:

●Creating test plan, test strategy as soon as business requirements review is done

●Creating smoke, functional, regression test cases for QA

●Test case traceability with business requirements and Execute them through a test plan

●Creating SQL queries based on mapping doc for data validation

●Data validation source file to stage and stage to target tables after ETL job runs in SIT environment

●Daily coordination with off-site QA and dev teams

●Test case and SQL queries review which created by onsite and offshore QA

●Review test results and defects generated by offshore and onsite QA team before project then to client

●Creating defect reports and running daily triage with business, technology stakeholders

●Mentoring junior testers

Trading desk: - This will be the current loan sale and purchase activities conducted by Capital Markets, with the assistance of Commercial Loan Operations.

Key Responsibilities:

●Creating test plan, test strategy based on business requirements and review with Business

●Creating smoke, functional, regression test cases and review with Business

●Test case traceability with business requirements and Execute them through a test plan

●Creating SQL queries based on mapping doc for data validation after ETL job runs in SIT environment

●Data validation source file to stage and stage to target tables

●Daily coordination with off-site QA and dev teams

●Test case and SQL queries review which created by onsite and offshore QA

●Review test results and defects generated by offshore and onsite QA team before project then to client

●Creating defect reports and running daily triage with business, technology stakeholders

●Mentoring junior testers

SAS Model: - Auto Loans and Home Equity as a result has requested RDP to store and populate some new data fields.

Key Responsibilities:

●Review business requirements and creating test plan, test strategy and review with Business

●Creating smoke, functional, regression test cases for QA and review with Business

●Test case traceability with business requirements and Execute them through a test plan

●Creating SQL queries based on mapping doc for data validation

●Data validation source file to stage and stage to target tables after ETL job runs in SIT environment

●Daily coordination with off-site QA and dev teams

●Test case and SQL queries review which created by onsite and offshore QA

●Review test results and defects generated by offshore and onsite QA team before project then to client

●Creating defect reports and running daily triage with business, technology stakeholders

●Mentoring junior testers

CRA: -The Commercial Platform Replacement Program will be utilizing the AFS Vision loan servicing system to replace the current SHAW loan servicing system.

Key Responsibilities:

●Review business requirements and creating test plan, test strategy and review with Business

●Creating smoke, functional, regression test cases for QA and review with Business

●Test case traceability with business requirements and Execute them through a test plan

●Creating SQL queries based on mapping doc for data validation

●Data validation source file to stage and stage to target tables after ETL job runs in SIT environment

●Daily coordination with off-site QA and dev teams

●Test case and SQL queries review which created by onsite and offshore QA

●Review test results and defects generated by offshore and onsite QA team before project then to client

●Creating defect reports and running daily triage with business, technology stakeholders

●Mentoring junior testers

GRDM Separation: - GRDM is the "golden source" for wholesale customer reference data for the entire group.

Key Responsibilities:

●Review business requirements and creating test plan, test strategy and review with Business

●Creating smoke, functional, regression test cases for QA and review with Business

●Test case traceability with business requirements and Execute them through a test plan

●Creating SQL queries based on mapping doc for data validation

●Data validation source file to stage and stage to target tables after ETL job runs in SIT environment

●Daily coordination with off-site QA and dev teams

●Test case and SQL queries review which created by onsite and offshore QA

●Review test results and defects generated by offshore and onsite QA team before project then to client

●Creating defect reports and running daily triage with business, technology stakeholders

●Mentoring junior testers

SOFI: - The Student Loan group within CFG has purchased student loans from SoFi on a quarterly flow basis.

Key Responsibilities:

●Review business requirements and creating test plan, test strategy and review with Business

●Creating smoke, functional, regression test cases for QA and review with Business

●Test case traceability with business requirements and Execute them through a test plan

●Creating SQL queries based on mapping doc for data validation

●Data validation source file to stage and stage to target tables after ETL job runs in SIT environment

●Daily coordination with off-site QA and dev teams

●Test case and SQL queries review which created by onsite and offshore QA

●Review test results and defects generated by offshore and onsite QA team before project then to client

●Creating defect reports and running daily triage with business, technology stakeholders

●Mentoring junior testers

Auto Securitization: - Risk Data Platform (RDP) to process ALS Auto loans identified as Held for Sale, Securitized, or Repurchased and provides.

Key Responsibilities:

●Review business requirements and creating test plan, test strategy and review with Business

●Creating smoke, functional, regression test cases for QA and review with Business

●Test case traceability with business requirements and Execute them through a test plan

●Creating SQL queries based on mapping doc for data validation

●Data validation source file to stage and stage to target tables after ETL job runs in SIT environment

●Daily coordination with off-site QA and dev teams

●Test case and SQL queries review which created by onsite and offshore QA

●Review test results and defects generated by offshore and onsite QA team before project then to client

●Creating defect reports and running daily triage with business, technology stakeholders

●Mentoring junior testers

Project Green: - Project Green is for Citizens Bank to partner with Apple to offer a frictionless interest free financing solution for Apple's “Hero” products.

Key Responsibilities:

Building a team of off-shore and on-site QA engineers

Creating test plan, test strategy and test cases for smoke, functional, regression and user acceptance tests and review with Business

Test case traceability with business requirements and Execute them through a test plan

Working in Agile model creating backlogs, stories, estimations and prioritization

Gathering and managing test data for large scale projects like data warehouse

Data analytical and Interfacing testing for multiple domains on Finance and Banking

Tests data movement based on the Data Lake Mapping Requirements

Creating and executing SQL queries for data validation between source and target

Data validation between Data Lake and Source tables after ETL job runs in SIT environment

Validation of structured/semi-structured/unstructured, raw data from End to End based on Validation and Reconciliation Rules

Validation of web-based applications on Java environments in QA and UAT

Hands on Mobile experience on Android, iphone, ipad and mac devices

Daily coordination with off-site QA and dev teams

Creating defect reports and running daily triage with business, technology stakeholders

Proposing and implementing best practices towards process improvement

Lead, direct and motivate a culture of quality improvement across program and business teams to eliminate inefficiencies/defects and drive root cause analysis, lesson learning

Mentoring junior testers

Key Achievements:

Managed QA cycles for large scale data movement between data lake and transactional databases and other sources

Developed validation scripts for structured and unstructured data validation

Managed QA cycles for data warehouse hosting core analytical and reporting data for Citizens bank

Improved QA processes with end-to-end traceability of defects

Mentored and integrated multiple off-shore teams in various projects

Experience:

Boston Private, Boston MA from May 2018 to Sep 2018

Position: UAT Technical Test Lead and UAT Technical Test Manager

Hyperion Reports: Migrated Reports to the new platform iVue in comparison against an existing Hyperion and to ensure that the migrated reports are exactly the same as in layout.

Key Responsibilities:

Off-shore team build for QA engineers

Leading the team to execute QA for various projects

Participate in business analysis to gather and analyze functional requirements

Create plan, test strategy test cases for smoke, functional, regression, UAT and review with Business

Validation of web-based applications on J2EE environments in QA and UAT

Test data collection and Performing functional, integration, regression testing in QA & UAT environments

Test case traceability with business requirements and Execute them through a test plan

Generating daily defect reports and having daily triage with all business and technology stakeholders

Generating status reports and updates project release plans

Work closely with technical and non-technical staff including dev, product management

Mentoring junior testers

Key Achievements:

Establishing a working model by making good relationship with client, despite of very weak processes at the client site

Within 4 weeks found more than 80 defects which has helped prove the effectiveness of Infosys and helped create good initial impression with the client

The Dev team has highly challenged on defects and process but I was able to defend and prevail with the right data and reports

Experience:

Fidelity Investments, Smithfield, RI from Jan 2012 to Apr 2013

Position: Technical Test Lead

Projects: FX Oversight, Latent Zero and Common Data Environment (CDE, hereafter)

FX Oversight: - FX Oversight is to provide an enterprise-wide solution to perform transaction cost analysis on FX trades executed by internal desks and custodian banks against several benchmarks.

Latent Zero: - LatentZero is buy-side suite comprising Minerva, Sentinel, and Tesseract.

Common Data Environment: - CDE project is being built to service the data needs of the asset management business.

Key Responsibilities:

●Analyzing the functional requirements and creating test strategy, test plan, test cases for smoke, functional, regression and user acceptance tests

●Review test plan and test cases with business

●Test data collection and Performing functional, integration, regression testing in QA & UAT

●Creating and executing SQL advanced queries

●Data validation after ETL job runs in SIT environment

●Work closely with technical and non-technical staff including dev, product management

●Daily basis interaction and reporting with client on progress of various QA activities

●Discussing and proposing best practices towards process improvement

●Mentoring junior testers

Experience:

Iron Mountain, Boston, MA from October 2011 to December 2011

Position: Quality Assurance Lead

Projects: DDA and FHFA

Document Delivery Application (DDA): DDA mainly focuses on retrieved ingested Loan and Supplemental documents.

Federal Housing Finance Agency (FHA): Convert designated loan file and supplemental documents into a standard media format that has a uniform and consistent naming convention, a standard format, which will be PDF.

Key Responsibilities:

Analyzing the functional requirements and creating test plan, test cases for smoke, functional, regression, UAT and review with business

Test data collection and creating and executing SQL advanced queries after ETL job runs in SIT environment

Performing functional, integration and regression testing on QA & UAT environments

Generating QA, UAT status reports and updates for project release plans

Work closely with technical and non-technical staff including dev, product management

Experience:

Commerce Insurance, Webster, MA from May 2011 to September 2011

Position: Quality Assurance Lead

Projects: Tron Web, Customer relationship management

Tron Web: This project is designed for creating, maintaining for Home & Auto products.

Customer relationship management: CRM project is designed for Home and Auto insurance customer relationship management

Key Responsibilities:

Analyzing the functional requirements and creating test plan, test cases for smoke, functional, regression, UAT tests and review test plan, test cases with business

Release management and co-ordination

Planning, developing and maintaining test automation

Test case traceability with business requirements and test data collection and validation

Performing functional, integration and regression testing

Testing on different environments: QA & UAT

Creating QTP automation scripts and executing

Creating and executing SQL advanced queries

Generating status reports and updates for project release plans

Work closely with technical and non-technical staff including dev, product management

Experience:

New York Life Investments, Westwood, MA from April 2010 to April 2011

Position: Senior Quality Assurance Analyst

Projects: Plan Checkup Reporting and Data Warehouse Micro Strategy Reports

Plan Checkup Reporting: - Plan Checkup project contains aggregate Information about plans and participants that will be delivered in power point slides.

Data Warehouse Micro Strategy Reports: - Business users can to access information in one central location resulting in consistent information being used throughout the company.

Key Responsibilities:

Analyzing the functional requirements and Creating test plan, test cases for smoke, functional, regression and user acceptance tests

Review test plan and test cases with business

Create and execute advanced SQL queries to validate the data in QA after ETL job runs

Performing functional, integration and regression testing

Validate the participants Data from Store and Data Marts on BI Micro strategy tool

Running XML job and verifying data with Excel reports and data with database

Work closely with technical and non-technical staff including dev, product management

Documenting and generating bug reports and distribute to project management

Experience:

TJX Companies, Framingham, MA from Dec 2007 to Nov 2009

Position: Senior Quality Assurance Engineer

Projects: Planning Matrix, Store Profile, Ladder plan, Buyer’s work sheet, Week to Date.

Planning Matrix: - The Planning Matrix controls the structure of the departments

Store Profile: -The Store Profile application will be used to set up and maintain merchandising specific store and department information.

Ladder Plan Administration: -This Application, based on requests from the users, the administrator will create a maintain company and department.

Buyer’s work sheet: - Buyer Worksheet users to create a local email Address Book, and select multiple email addresses from the address book for Vendors.

WeekToDate: This application gives an info about this week and last week distributions.

Key Responsibilities:

Analyzing business requirements and creating test plan, smoke and functional test cases

Review test plan and test cases with BA and business users

Test data collection on performing functional, integration and regression testing

Create and execute advanced SQL queries for a data validation

Executing manual and automation test cases

Works closely with technical and non-technical staff including dev, product management

Performing web services testing using SOAP UI

Generating bug reports and distribute to project management

Experience:

Fidelity Investments, Boston, MA from Feb 2007 to Oct 2007

Position: Quality Assurance Engineer

Projects: Asset Management Tool, Performance Decoupling and Alternative Investments.

Asset Management Tool: - This is a family asset management tool and it allows customers to maintain their family finances in one place.

Performance Decoupling: - This is a report generating tool, a desktop application communicating with Oracle database.

Alternative Investments: - The Workstation gives to clients the ability to manage their alternative investments, including creating accounts, entering transactions and updating.

Key Responsibilities:

Participating in business requirements analysis

Creating and maintaining manual test plan and test cases in Mercury’s Quality Center

Test data collection to perform functional, integration and regression testing

Executing manual test cases and automation test scripts

Create Transactions to AI accounts, updating evaluations and generating the reports for AI accounts and Groups

Experience:

Investors Bank and Trust Company Boston, MA from Nov 2004 to Jan 2007

Position: Software QA Analyst

Projects: CCD-InvestSweep, Cash, Facts Pricing, ETL, ORACLE 9i to 10G migration and General Ledger Proof

CCD-InvestSweep: This is a desktop GUI application communicating with Main Frames (COBOL) DB2 and Oracle database.

Cash: This is a data warehouse project developed using ETL tool, Informatica.

Facts Pricing: This is a web-based application with a transaction processing module ORACLE 9i to 10G migration: This is a database migration from Oracle 9i to 10G.

General Ledger Proof: This is a desktop application developed by using Visual Basic.

Key Responsibilities:

Review business requirements and creating test strategy, test plans and test cases

Test data collection to Perform functional, integration, migration testing Oracle 9i to 10G

Developing reusable SQL scripts to verify the data transformation

Documenting bug reports and sends to management. Mentoring junior testers.

Contact this candidate