Harish Vatadahosahalli

Sr QA Analyst

Summary:

•Solutions driven QA Analyst with more than 16 years of experience.

•Result focused and customer-oriented professional with expertise in capturing Requirements, designing Implementation strategy, estimation for large & complex projects

•Worked in Financial, Banking and Mortgage, Credit Cards, Compliance, Real Estate and State project domains.

•Proficient in preparation of Test Plans, Test Strategy and Test Closure documents.

•Proficient in Data Analysis using SQL & data tools like Tableau, Power-Query

•Strong understanding of QA Principles, QA Process, Use Cases, and Software Development Life Cycle - Agile and Waterfall

•Rich Experience in working in with Agile Test Management tools like JIRA, Rally, TestRail, ALM & Clearcase

•Proven ability to lead complex projects from initial conceptualization through implementation in Global Delivery model with testing team based both onshore and offshore

•Extensive experience in validating functionality of ERP systems ex. Salesforce

•Extensive test coordination with stake holders like Business Analysts, UAT users

•Extensive experience in requirements gathering, documentation and delivery process

•Strong Experience in working with Databases - Oracle, SQL & Tools (TOAD)

•Conduct negotiations between stakeholders and analyze requirements and schedules.

•Managed wide variety of projects including Web Applications, Workflows, Content Management, Database Migrations, Data Quality, ETL Projects (MS SQL, Informatica), Data Maintenance, Data Quality, Data Management

Skills:

Database

Oracle, MS-SQL, MYSQL, TOAD & DB2

QA Tools

HP-Quality Center, ALM, JIRA, Bugzilla

Environments

Delphi, JAVA, VB, Oracle, UNIX

ETL Tools

Informatica (Testing data migrations), MS-SQL

Third Party Tools

GRC OneSumX, QRM, Actimize, Postman

Mobile Devices

IOS & Android

Data Analysis

Tableau, Genesis

Business Tools

JIRA, MS-Visio, Rally, Clearcase

Configuration Mgt.

VSS, Clearcase,

Key Accomplishments:

•Implemented requirements collection and analysis models for Capital Markets

•Implemented defect triage procedures for Enterprise-wide data consolidation project.

Education:

•MBA in Finance, Karnataka State Open University, Mysore, India - 2003

•Bachelor of Commerce, University of Mysore, Mysore, India - 1999

Training

Diploma in Systems Management –NIIT Bangalore – 1996

Experience:

CapSpecialty, Hartford, CT (Remote) Jun 22 – Present Sr.QA Lead

•Validation of HUBCAP Application covering business for Insurance Domain.

•Performing QA testing on assigned tickets in JIRA.

•Participating in Daily Scrum Calls and providing updates.

•Responsible for providing test execution results per established test execution process

•Coordinating with Development team in resolving automated scripts issues

•Working with development team on triaging the defects found

•Verification of reports generated using Tableu

•Version management using Clearcase

•Providing Testing metrics to the team.

•Creation of Test scenarios using JIRA Test Management Framework (JTMF)

•Providing UAT Test Cases and data to the business to perform Holistic Testing

Dexcom, Irving Tx, (Remote) Jul 21 – May 2022 Sr. QA Lead

•Validation of requirements for Dexcom App in Mobile devices.

•Creation and maintenance of Requirement mapping to test coverage artifacts.

•Establishing inter- app connectivity requirements for Connected Apps

•Analysis of data shared with origin app to consuming apps.

•Coordinating with Development team in resolving automated scripts issues

•Working with development team on requirements and

•Providing Testing metrics to the team.

•Working on JIRA tool to create Test Plan & Test Strategy documents

•Identified challenges in client deliverables and provided solutions with supporting data

Citibank, Irving Tx, (Remote) Jun 20 – Jun 21 Sr. QA Analyst

•Actively involved in conducting reviews, walkthroughs to get consensus on business requirements.

•Analyzed and assessed client requests to create quality deliverables in form of dashboards and reports.

•Used Genesis tool to validate data and provide management reports to stake holders

•Validation of Financial data in each stage of Data movement from source to destination.

•Performed validations of data & provided test results provided by testing teams.

•Responsible for Data Management related to Bank’s data sourced from Front office

•Providing requested data to Key Stake Holders of Data Governance

•Investigation of Data issues and providing resolution to business users

•Coordinated SLA Commitment initiatives with project stake holders

•Provided analyses for large datasets with actionable insights for decision making

•Assisting Business Analysts in preparation & review of user stories in JIRA

•Assisted QC teams to ensure requirements are translated to executable Test Plan and Test Strategy documents.

•Working with business users to prepare UAT Test Data and Scenarios for acceptance.

Tools :Aginity SQL,Techtia, HP-ALM, UNIX, Selenium JIRA,

Shinhan Bank America, New York, NY Nov 19 – Mar 20 Sr. QA Analyst

•Formulated policies and procedures with AML (KYC, CDD & EDD) for Data Analysis & Governance

•Ensured that the defects found in KYC, CDD & EDD process are properly addressed from point of entry to closure by designing effective process using ALM Tool.

•Performing Extended Due Diligence (EDD) of High Risk customer cases and preparation of reports to be delivered to Review Teams.

•Carried out complex data analysis for KYC data and provided compliance data to the Bank

•Perform CCAR (Dodd Frank Stress Tests) analysis

•Assisting Business Analysts in preparation & review of user stories in JIRA

•Responsible for Data Management and Data Quality for felicitating audit function

•Responsible for EDD Data Analysis using BI Tool – Tableau

Tools : Aither (Banking Software), Oracle Mantes, Actimize, BAM Plus (MIS system)

Bank of America, Pennington NJ Jul 19 – Oct 19 Sr.QA Lead

•Collaborated with external vendors to identify opportunities for product integration.

•Validation of Third-party tool integration to the Identity project.

•Performed validations of data & provided test results using Black Box methodology to uses.

•Responsible for Data Management related to Branch Customer Details

•Maintenance of Automation Scripts using Selenium

•Preparation of Test Plan Documents

•Working with Business users to assist them in UAT testing

Tools :Oracle SQL, HP-ALM, UNIX, Selenium JIRA, Web Services, Mobile Apps & Device Testing

Automatic Data Process (ADP), Morristown, NJ Feb 19 – Jun 19 Sr.QA Lead

Summary: End to End validation of Actimize workflow implementation for Customer Due Diligence (CDD- KYC) and Watch List Filtering.

•Responsible for capturing requirements for Customer Data critical indicators

•Demonstrated key results to stakeholders on results of new changes to the code.

•Conducting hands-on CDD Data analysis, data validation and predictive model development.

•Participating daily Scrum calls and assisting scrum master in daily burn down chart updates.

•Validation of KYC Data received from Data sources through ETL processes.

•Investigating complex, sensitive, and/or significant AML data Analysis for issues arising in Production.

•Validation of data with integration with Salesforce (ERP)

•Preparation of Business Case test data to be validated via Postman (Web Services).

•Creation and maintenance of automation scripts using Selenium

Tools : TOAD, NICE Actimize, Oracle, JIRA, Web Services, POSTMAN, Rally

Bank of America, Jersey City, NJ Jul 18 – Jan 19 Sr. Data Analyst, Lead

Summary: ARCTIC Suite of applications – is a collection of data repositories receiving and enriching data related Credit Risk & Liquidity calculations, Trade data for the bank using ETL tools

•Performed Data Analysis for ETL data of Credit Risk by implementing test methods using SQL Queries

•Supporting business in validation of data by providing requested supporting data for validations performed

•Validation of Reconciliation reports for data received vs. Data Processed for Data Maintenance

•Preparation of Test Plan and Test Strategy Documents

•Responsible for creation of Test Plan & Test Strategy documents

•Preparation of test cases based on JIRA stories

•Assisting Business Analysts in preparation & review of user stories in JIRA

•Responsible for obtaining Sign offs from business & stake holders and Test Closure Documents.

Tools Used: MS Sql, Oracle – SQL, HP-ALM, UFT, JIRA, Selenium, Python

Verizon, Basking Ridge, NJ Mar 17 – Jun 18 Senior Data Analyst

Summary: Validation of billing data from external billing sources using SQL and ETL tools

•Gathered user requirements for mapping data flow process analysis

•Performed ETL data validations for Billing Data received through various billing systems

•Validated Billing data by verifying the accuracy in order to be sent for Data Warehouse

•Managed QA activities by preparation of concept document, test strategy, Test Scripts

•Validated Customer data with respect to KYC and customer onboarding

•Analyzed Functional requirements for Report Migration using Power-Query

•Performed Data Maintenance & Governance activities for Billing Data

•Used MS-Visio for data modeling

•Tested Data with SQL queries for maximum efficiencies.

Tools: TOAD, Web Services, JIRA, Oracle, HP-ALM, Power Query, POSTMAN,

State of New York, Albany, NY Aug 16 – Feb 17 QA Team Lead

Summary: Validation of Business Licensing workflow with UI, Database and Web Services. This project involved integration with existing functionality of NY State Website.

•Validation of business application to process new business license process workflow.

•Analyzed customer requirements and developed front end and back end test approaches

•Performed production deployment and the Business verification testing

•Execution of automation scripts with Selenium

•Participated in QA team and Bug tracking or Defect Review meetings.

Environment: OPT, ALM 11, Web Application, Web Services, Device Testing, MYSQL, MS-PHP

Prudential (PGIM), Madison, NJ Jan 16 – Jul 16 QA Team Lead

Summary: Validation of applications and data flows to calculate valuation of worldwide real estate assets for regulatory reporting

• Conducted a complete assessment of teams, processes and environment; defined issues and risks; and oversaw the design and test Management tools

•Responsible for UAT Test Management and post implementation validations.

•Testing Asset Evaluation Mobile Application in Mobile Devices.

•Responsible for creation of Test Plan & Test Strategy documents

•Preparation of test cases based on JIRA stories

•Assisting Business Analysts in preparation & review of user stories in JIRA

•Creation of Test scenarios using JIRA Test Management Framework (JTMF)

Environment: OPT, ALM 11, Web Application, Web Services, and Mobile Apps & Device Testing

Barclays Capital, New York Sep 14 – Dec 15 Senior Team Lead

Barclays implemented compliance tool ACTIMIZE to implement Risk Case Management. Also, to monitor Customer due diligence and Suspicious Activity Reports.

•Capturing requirements for Suspicious Activity Monitoring from business users

•Validation of data in ACTIMIZE tool for Suspicious Activity Monitor (SAM)

•Analysis of data for Customer Due Diligence (CDD) module.

•Responsible for validation of AML data validations

•Conduct CCAR Stress Tests

•Responsible for Identity Matching for Customers on-boarded to system

•Analyzed customer requirement, designed and implemented customized models on Anti-Money Laundering (AML) Customer Due Diligence (CDD)solution

•Assisting Business Analysts in preparation & review of user stories in JIRA

•Creation of Test scenarios using JIRA Test Management Framework (JTMF)

•Participated in QA team and Bug tracking or Defect Review meetings.

•Responsible for creation of Test Plan & Test Closure Documents.

Environment: QTP, ALM, ACTMIZE, JAVA, Informatica, MYSQL

JP Morgan Chase, Iselin, NJ Aug 06 – Aug 14 Senior QA, Delivery Module Lead

Summary: Experience with JPMC involves 8 years of journey as team member and Team Lead roles involving testing SMART suite of applications for Capital Markets & Investment Banking division. Managed the responsibility of testing and validations of short terms and Enterprise wide implementations.

•Managed Enterprise wide Application Quality Assurance Testing initiatives involving multiple teams involving multi layered integration methodologies

•Responsible for end to end data migration validation for Origination Data – EMITS and Servicing Data Voyager.

•Validation of downstream applications Asset Management System and Trade Management System using migrated data.

•Responsible of overall test management Activities including – Effort Estimation, Task Allocation, Test Summary Reports, Status Meeting, Traceability Matrix, Defect Management activities (Project Quality Analyst), preparing and publishing Daily and Weekly Status Reports.

•Analyzed requirements (FSDs and Mapping sheets) and perform RTM for all the functional Requirements.

•Carried out validations for Dodd Frank regulations. Analyzed data requirements and validated data elements for quality and compliance.

•Responsible for gathering and cleaning of datasets across multiple data sources

•Responsible for creation of Test Plan & Test Strategy documents

•Preparation of test cases based on JIRA stories

•Assisting Business Analysts in preparation & review of user stories in JIRA

•Creation of Test scenarios using JIRA Test Management Framework (JTMF)

•Responsible for getting sign off on all the testing activities internally as well externally from Business Partners before the code is pushed to production.

•Acted as the main Point of Contact (SME) of my application during End to End and System Integration testing and assist other team members with testing requirements.

•Tests performed - ETL (SSIS), SIT/End to End, System (MS Sequel Server), Database, and Regression.

Tools : TOAD, UNIX, Loan Origination, SQL, AutoSys, JAVA, DB2

Charles Schwab, San Francisco, CA Nov 03 – July 05 QA Analyst

Summary : End to End Validation of Trade Life Cycle

•Validation of trades of investment order placing and tracking systems

•Owned end to end validation of Equities Trading Tool involving Trade life cycle

•Responsible for creation of Test Plan & Test Strategy documents

•Assisting Business Analysts in preparation & review of user stories in JIRA

•Managed Trade Life Cycle Testing by validating end to end workflow systems

•Provided support for file transmission validations for FTP services

PERSONAL INFORMATION

First Name

Harish

Last Name

Vatadahosahalli

Name as In Passport /SSN

Harish Vatadahosahalli

Email

adzupu@r.postjobfree.com, adzupu@r.postjobfree.com

Phone

732-***-****

Birth Month & Date

04/17

Address

316 Michelle Cir, Edison, NJ 08820

Work Authorization

US Citizen

LinkedIn Profile

https://www.linkedin.com/in/harish-vatadahosahalli-84bb7051/

Skype ID

Harishv73

Contact this candidate