Ravi Ranjan Gupta

(ad3xm6@r.postjobfree.com)

732-***-****

Professional Summary:

Tier 4- public trust position clearance with the Federal government through DHSS (Dept. of Human and Health Services)

Domain Knowledge of Medicaid, Medicare, HR systems, Insurance, Financial instruments, Health Care, and Federal Govt projects

Accomplished hands-on strategic and creative Software Quality Assurance leader with over 15+ years of diverse and successful experience in managing and delivering software testing services for high-visibility, mission-critical large-scale implementations and scalable infrastructural platforms aligned with enterprise goals and objectives

Over 20 years of experience in ETL testing, highly skilled in SQL queries and expert in testing data migration from legacy to cloud-based environment.

Experienced in the complete life cycle of project development (SDLC): System Analysis, Design, Development, Testing, Deployment, and End User Training.

Strong experience in Business Scenario Testing, System Integration Testing, Manual Testing, Automated Testing, Regression Testing, Functionality Testing, Performance Testing, Defect Management and supporting UAT testing in Data Warehouse, Front End, ETL & BI applications.

Expert in analyzing Business Requirements, Use Cases, Stories, and developing Test Strategy, Test Plans, Test Designs, Test Scenarios, Manual Test Cases, and End to End Business Test Scenarios.

Well versed with data modeling- referential integrity, normalization, and indexing, proficient in logical and physical relation between facts and dimension tables (OLAP) as well as tables in OLTP Systems.

Extensively used ETL methodology for testing and supporting data extraction, validation, enrichment, transformations, and loading process, in a corporate-wide-ETL Solution using Informatica, Ab Initio, Data Stage, and SSIS.

Proficient in Ab-Initio TDM, control Center, Control M files, Psets, graphs(.mp) & XFR’s.

Expert in data quality testing for accuracy, completeness, consistency, timeliness, validity, integrity, and conforming to business rules using SQL and Excel. Very proficient in SQL.

Experience in testing XML files and validating the data loaded to staging tables.

Extensively used SOAP and REST APIs for testing

Very proficient in Backend Testing and Data Integrity Testing using complicated SQL and PL/SQL.

Extensive experience in generating test data, test data mining, and masking/deidentification of data.

Extensively used JIRA, Test Director/Quality Center for requirements tracking, defect tracking, results, and status reporting.

Experience in data retrieval methods using Universes, Personal Data files, Stored Procedures, and freehand SQL.

Proficient experience in different Databases like Oracle, SQL Server, DB2, Sybase, and Teradata.

Extensively Used Quality Center, PVCS Tracker, Rational Clear Quest for Test Case, and defect tracking management.

Successfully coordinated off-shore and On-shore Test resources.

Communicated daily, weekly and monthly status to higher management and escalated risks and issues to the appropriate team as required.

Experienced in providing knowledge transfer to fellow team members based on lessons learned after completion of each project.

Problem Solver with good analytical & communication skills, detail-oriented, and ability to work independently with minimal supervision and also perform as part of a team.

Over 3 years of experience on PRPC Pega RULES Process Commander as design Testing, and PRPC workflow experience

Worked for BCBS New York and BCBS Georgia through IBM

Technical Skills:

Domain Knowledge

Finance – KYC, mortgages, payment, settlements, financial statements; Property and Casualty (P&C) Insurance, Health Care, Medicare/Medicaid, Financial Reporting, Bonds and Fixed Income, Regulatory reporting, Syndicated Loan and Government Projects

Testing Tools

Quality Center 10, JAMA, IBM Rational Clear Quest/Clear Case, Bugzilla, JIRA, QTP, QTest, LoadRunner

Programming Languages

HTML, XML, XSD, VB, T-SQL, PL/SQL, SQL, Shell Scripting, PERL, Web Services

RDBMS/Database

Oracle 11g/10g/9i, Teradata V2R6, DB2 9.0 (Mainframe), SQL Server 2012, Sybase 12.5, MongoDB, Studio3T

ETL/DW Tools

BI Tools, TDM

Informatica, DataStage, SSIS, Business Objects XIR4, Cognos 8.4, Ab Initio, Pega 5.4, 5.5, 6.1,7;Salesforce/CRM-360, AWS; SoapUI/Postman/ReadyAPI, Informatica IDQ, IBM Infosphere Optim; DataLake; CDC pipeline

Software

Tableau 9.x, Power BI, Qlickview 11.x, Flexcube 7.x, Business Object (BO), Oracle Financials 11i (11.5.9, 11.5.7) – GL, AR, AP, CM, Informatica, Rational Tools, HP ALM

Project Domain

Business Intelligence, Machine Learning, Big Data, Systems Integration, content management, AI/Machine learning, Performance Improvement, Business Process Re-engineering, Application Development

Data Modeling

Erwin 7.0, ER Studio

Cloud

AWS, Azure

Methodologies/Practices

Agile, SDLC, DevOps, CI/CD pipeline

Experience:

Penfed, Washington DC November 2023– February 2024

Tester

Domain knowledge in Loan Origination, Loan management and servicing

Project involved data migration from legacy system to new cloud system. This includes new data dictionary, data de-normalization and merger, and new regulatory and financial reporting.

Performed ETL testing for the data movement from legacy to the new cloud system.

Developed and tested complex automated queries for data quality and regression.

Drive Defect Triage meetings and work with development on defects

Prepare Test Results and perform close-out activities for audit purposes.

Work with team on RTM (Requirements Traceability Matrix) and peer review test scripts

Environment: JIRA, SQL Server, Snowflake, Hue; DevOps – CI/CD; Data Lake; CDC, AWS.

Human and Health Services - HHS (through Deloitte, through Pinnakle) December 2022– present

Quality Assurance Specialist

(Surge Resource, still with Deloitte through Pinnakle, project from April to May 2023, July to September 2023)

Domain knowledge in Claims, Oracle Financials, Procurements, Pricings and Settlement

Project was initiated to integrate new government invoicing module across internal and external vendors and test order creation, Account receivable and account payable creation, settlements, General Ledger creation and reconciliation, payment advice to treasury and financial, accounting, and regulatory reporting.

Performed ETL testing for the data movement from legacy to new cloud system.

Design SSF Project requirements, Test scenarios/cases in ALM and build test scripts/ labs for all the Change requests for IT and UAT testing

Work with functional testers closely during IT phase for proper documentation and minimize any gaps in the test scripts and create defects and link test cases accordingly.

Conduct Defect review meetings and work closely with the functional team for Oracle SR’s mapped against the defects and follow up on CR’s and requests for patch analysis and deployment to DEV and IT instances

Work on Oracle SRs and provide supporting evidence for further troubleshooting.

Drive Defect Triage meetings and work with development on defects

Analyze UAT issues and work/follow up with the needed teams for quicker resolution.

Prepare Test Results and perform close-out activities for audit purposes.

Work with team on RTM (Requirements Traceability Matrix) and peer review test scripts

Environment: Rally, JAMA, Oracle SQL Developer, SSIS, Oracle Financials 11i (11.5.9, 11.5.7) – GL, AR, AP; Agile; DevOps – CI/CD; Data Lake; CDC, AWS.

Everest Reinsurance, Warren, NJ September 2016– Dec 2022

Tester

Domain Knowledge of Insurance, Claims, Policies, Customer, Property and Causality Insurance, Life Insurance, Mortgage Insurance, Submission, Underwriting, Reserving, Accounting, and Finance.

Responsibilities:

Created Test Strategy, and test cases, performed testing, raised defects, and report status to management using JAMA tool.

Defined and implemented CI/CD processes (DevOps) for automated sanity, smoke, and regression test runs.

Performed hands-on smoke, functional, data migration, regression, integration, API, E2E (End to End) testing and data quality validation

Performed data quality validation, data reconciliation, and data profiling using SQL and Excel

Provided support to business stakeholders during UAT test cycles by utilizing automated regression tests and sharing test artifacts/test coverage matrix

Experience in writing complex SQL queries to support ETL, Data Warehouse (DW), and, BI (Cognos)Reports testing and GUI (front end) testing.

Able to understand complex mapping between source to target and translates into SQL queries.

Review specifications and Business Requirement documents and provide feedback from Test Perspective.

Performed work item sizing and other planning activity

Nurtured high-caliber talent, promoted a knowledge-sharing environment that showcased teamwork, respect, and collaboration, and provided individualized performance reviews.

Able to handle multiple assignments and get them ready for the release

Steered monthly achievement discussions and planning activities with department heads and C-level management.

Successfully transitioned from onsite to nearshore/onsite to offshore practice resulting in overall cost reduction and extended testing support.

Devised and implemented formal test lifecycle processes used by test team along with status/progress reporting to stakeholders.

Monitor End-to-end test management (initiation to closure) for system integration as well as user acceptance testing

Environment: Rally, JAMA, Oracle SQL Developer, MOVEit, box, Cognos, SoapUI/Postman/ReadyAPI, JIRA, SSIS, IBM Infosphere Optim; Oracle Financials 11i (11.5.9, 11.5.7) – GL, AR, AP; Agile; DevOps – CI/CD; Data Lake; CDC, AWS.

MOODY’S CORPORATION, New York City, NY June 2014– August 2016

Tester

Domain Knowledge of Bonds, Ratings, Fixed Income Securities.

Responsibilities: As

Successfully tested Legacy Data Warehouse to Teradata migration project with IR/ETL Informatica

PowerCenter/Teradata/Cognos/Tableau Report for sixteen financial domains – No UAT defects found

Lead Tester for Ratings Data Modelling project involving Data Migration, New calculation engine, new Datawarehouse using Mainframe/ETL Informatica /IR/MongoDB/AWSAPI/UI/Cognos

Performed smoke, functional, regression, integration, GUI, feature data, role-based and data validation testing

Performed high level and deep dive data quality tests.

Performed functional, regression, GUI, feature data and role-based test validation.

Managed requirement change control and requirement/test traceability compliance

Defined test planning/test estimation processes, quality gates, metrics, KPI and governance, including continuous evaluation of test data and associated trends for potential process improvements.

Successfully migrated manual excel test harness to within Quality Center Framework to enable repeated test execution and eliminate redundant manual work.

Promoted and continuously evaluated quality management initiatives and programs to monitor effectiveness and initiate improvements as necessary.

Performed smoke, functional, regression, integration, and data validation testing

Developed Test Strategy and Plan, Test cases, Defect summary report for higher management.

Escalate all test-relevant topics, participate in conflict resolution in the test environment

Coordinate and educate test teams regarding proper test procedure, review techniques for test basis testing, test case definition, use of Quality Center, test automation principles, load and performance tests principles

Performed Load testing

Environment: QTEST/JIRA/DB Visualizer/Studio3T, Informatica Power Center/Teradata/Cognos/Tableau Report, Mainframe (QSAM, VSAM), MongoDB/AWS AP, Salesforce/CRM-360, .Net

CITI BANK, New York, NY May 2010 – May 2014

Test Lead

Domain Knowledge of Know Your Customer (KYC), loan syndication and origination, Anti Money Laundering (AML) process, KYC/AML alert generation and Security/Access Testing, Trading, Treasury Funding, Settlements, Payments, Interest and Fees calculations, Mortgages, Product Setups, Basel II risk reporting, Position calculations, FX impact, Adjustments, Mark to Market calculations.

Responsibilities:

As test lead, responsible for managing many projects simultaneously, coordinating with offshore team (19 members), development of Test Strategy, Test Plan and reporting to the management team.

Reviewed and understood various features, functionalities and coordinated Knowledge transfer between off-shore and on-shore resources.

Reviewed Business requirements and ensure the testability of these requirements.

Developed Test Scripts and performed Functional, Data Integrity, System Integration, GUI Testing and ETL testing

Ensured high quality data validation through data profiling.

Used OPTIM to generate test data for QA and UAT instance.

Define and implement QA process to align with regulatory/audit requirements

As lead, successfully tested IVR (Interactive Voice Response) system and its integration with mainframe, sales force, and Oracle Database

Supported production defects by gathering user feedback, assigning defect to the right team, managing defect fix and testing final fix.

Coordinated and participated in generating the test data, test data mining, masking/deidentification, required for various test activities.

Designed excel programs for defect tracking and test result/progress reporting.

Identified issues, logged them within ClearQuest and revalidated those issues.

Generate QA progress reports on a daily, weekly, and monthly basis.

Communicated risks and escalated issues to supervising manager as required.

Perform automated QA reports using Quality Center and Start Team dashboards

Environment: HP ALM, Oracle 11g, SQL, PL/SQL, UNIX, TOAD, IBM Infosphere Optim, Oracle Financials 11i AP

MERRILL LYNCH/BANK OF AMERICA, New York City, NY September 2009 - April 2010

QA Analyst

Domain Knowledge of Investors, deals, Financial Statement, and Dashboards.

Responsibilities:

Reviewed and understood various products, features, web services and end to end product lifecycle.

Reviewed Business requirements and ensure the testability of these requirements.

Developed QA project plan, Test Plan, Test cases for each sprint.

Performed Functional, Regression, Data Integrity, System Integration and end to end Tests and helped in User Acceptance Testing including GUI testing

Supported production defects by gathering user feedback, assigning defect to the right team, managing defect fix and testing final fix.

Coordinated and participated in generating the test data required for various test activities.

Generate QA progress reports on a daily, weekly and monthly basis.

Communicated risks and escalated issues to supervising Manager as required.

Work with teammates to resolve inter and intra teammate issues without affecting the project timelines

Perform automated QA reports using Quality Center and Start Team dashboards

Conduct prerelease meetings and documentation approvals

Train users and help in conducting UAT

Using SOAPUI client tested SOAP based web services.

Understand the code base by looking at Ab-Initio Psets, graphs(.mp) & XFR’s

Used Control Center and Control M files extensively. Used TDM to mock up data

Environment: HP ALM, Oracle 11g, SQL, PL/SQL, Ab Initio, UNIX, TOAD, PVCS, Shell Scripting, Business Objects XIR3

IBM CORPORATION, Endicott, NY 2002 – 2009

Test Manager/Test Analyst

Domain Knowledge of Insurance, Financial instruments, Health Care, Medicaid, Medicare, HR systems, and Federal Govt projects.

Worked for 3 years with Human and Health Services (HHS) from 2002-2005

Worked with the Federal government (through PwC and IBM) from 1999 to 2005

Responsibilities:

Test Lead for largest Oracle Financial implementation in the world at Medicare/Medicaid (HHS) – AR/AP/GL and CM modules

Reviewed and understood the ETL processes.

Ran ETL jobs and performed test data setup, Quality check for test data -Transformation logic verification, RCA for defect found.

Reviewed Business requirements and ensure the testability of these requirements.

Developed QA project plan, Test Plan, Test cases for the QA Phase of the Global Data Warehouse.

Performed Functional, Regression, Data Integrity, System Tests and helped in User Acceptance Testing including GUI testing

Responsible for coordinating off-shore and On-shore Test resources.

Reported defects and status of the defects in Quality Center.

Validated the data transformation and enrichment logic developed in Ab Initio.

Developed complex SQL queries to verify the data loaded into the target tables. Validate the test data using MS Access, TOAD, UNIX shell script & MS Excel

As lead, successfully tested IVR (Interactive Voice Response) system, and its integration with client’s database ; made over 1000 test calls.

Writing test cases/scripts within PEGA PRPC and correct the according To the erroneous outcomes

Involved in debugging an application using Pega Tracer tool, performance testing using PAL tool

Involved in writing PEGA Use cases and also writing test case documentation

Pega Guardrails in implementation of the application.

Written several complex SQL queries to validate the Business Objects XIR3 reports.

Coordinated and participated in generating the test data required for various test activities.

Generate QA progress reports on a daily, weekly and monthly basis.

Communicated risks and escalated issues to supervising Manager as required.

Conduct walkthrough meetings with various teams in understanding the QA processes, bug life cycles, QA documentation

Gather feedback from the manager to incorporate changes as required for the QA process documentation

Work with teammates to resolve inter and intra teammate issues without affecting the project timelines

Escalate database downtimes and any issues that could potentially create hindrance to testing progress

Perform automated QA reports using Quality Center and Start Team dashboards

Conduct prerelease meetings and documentation approvals

Train users and help in conducting UAT

Constantly worked with Pega dev to deliver the user stories.

Worked closely with Product owners and a BSA and solved their Pega UI queries and provided them the solution for their requirement from the QA perspective

Environment: HP ALM, Oracle 11g, SQL, PL/SQL, Ab Initio, UNIX, TOAD, PVCS, Shell Scripting, Business Objects XIR3; Oracle Financials 11i (11.5.9, 11.5.7) – GL, AR, AP, CM

PRICEWATERHOUSECOOPERS LLP, Fairfax, VA 1999 – 2002

Lead Quality Assurance Engineer

Domain knowledge in Corporate/Sovereign/Public Finance Ratings, Indices/Benchmarks, Credit Risk Models, Financial Statement Analysis on Global Public and Private Companies, Syndicated bank loan market and Global Fundamentals.

Responsibilities:

Reviewed Test cases and scripts based on client requirements in Quality Centre

Reported and tracked the defects in Quality Centre

Wrote very complex SQL to validate several BI Reports.

Reviewed and understood Business Requirement, Functional Specification & identified test requirements and coverage

Developed test strategies, test plan, test conditions/test scenarios and test scripts.

Created User Stories, test requirement, test cases and scripts in Quality Centre

Managed and conducted Functional Testing, System testing, Integration testing and Regression Testing.

Worked on SQL scripts using tools like TOAD to load data in the tables in Test environment.

Wrote SQL queries to verify the Data Quality to compare with Frontend and Backend applications.

Tracked defects using QC tool and generated defect summary reports.

Prepared status summary reports with details of executed, passed and failed test cases

Interacted with Developers, PMO team, Business & Management Teams and End Users.

Participated in regular project status meetings related to testing and coordinated with off shore team.

Worked with Agile Methodology projects, attended Scrum meetings and Sprint Show cases.

Reviewed Functional Specification Document and prepared traceability matrix.

Reported status to higher management and reviewed the progress with client on a daily basis.

Train users and help in conducting UAT

Identified risks and issues and tracked and monitored it to resolution.

Performed Issuing of Go-No Go Form, QA sign-off on Regression testing in QA and UAT Environment before moving the code to Production.

Environment: HP ALM, Oracle 12c, SQL, PL/SQL, UNIX, TOAD, PVCS, QTP, Shell Scripting

TATA CONSULTANCY SERVICES, New Delhi, India 1995 – 1997

QA Tester

Domain knowledge in Equities, Fixed Income, Derivatives, Mortgage Backed Securities (MBS), FX, Commodities, Alternative Investments and Global Markets, trade life-cycle, Front-office trading systems and Investment/Commercial Banking, Clearing & Settlement, Custody, Fund & Investment Accounting, Local Custody and Sub-Custody processes, Trade & Transaction Processing, Securities settlement, Cash management, Record keeping, Pricing Security Valuation, Corporate Actions / Income Processing accounting, Compliance and Supervision, etc.

Responsibilities:

Review and understand the ETL processes, functionality & identify test requirements and coverage

Reviewing Test cases and scripts based on client requirements in Quality Centre

Reporting and tracking the defects in Quality Centre

Tested various reports developed in Business Objects

Wrote very complex SQL to validate several BI Reports.

Involved in testing data migration.

Developed Test Plans, Test Cases, and Test Scripts for SIT.

Created Test Cases and developed Tractability Matrix and Test Coverage reports.

Managed and conducted System testing, Integration testing and Functional testing.

Extensively used Teradata and Putty for the entire project.

Worked on SQL scripts to load data in the tables in Test environment.

Used the Informatica monitor to schedule the jobs, validating and debugging its components, and monitoring the resulting executable versions.

Running of ETL jobs and test data setup, Quality check for test data.-Transformation logic verification, RCA for defect found.

Used SQL tools like TOAD to run SQL queries and validate the data loaded into the target tables

Tracked the defects using QC tool and generated defect summary reports.

Using SOAPUI client tested SOAP based web services.

Validated the data movement and transformations are done correctly

Worked with Data Warehousing developers who extensively used Informatica, to design

Mapping to move data from source to target database using Stages to do the functionality.

Testing of Data Mapping documents between source and target databases as per the transforming logic

Prepared status summary reports with details of executed, passed and failed test cases

Interacted with developers, Business & Management Teams and End Users.

Participated in regular project status meetings related to testing

Reviewing Functional Specification Document and preparing traceability matrix with the test case mapped.

Sending status report and reviewing the progress with client on a daily basis.

Reviewing Test cases and scripts based on client requirements

Manual Functional, User Interface test and Regression test.

Involved in Execution of test cases to verify actual results against expected results.

Prepared bug and defect reports

Preparing the SQL script to verify data and validating data from source and target Through Toad 9.0.1

Train users and help in conducting UAT

Environment: Oracle 11g, SQL, PL/SQL, Informatica 9.x, BRIO Portal, Altova XML Spy 2013, UNIX, TOAD, XML Files, QTP, VSAM Files, XSD, DTD, HP Quality Center 10, Shell Scripting, Business Objects XIR4, Crystal Reports

EDUCATION

Certified Scrum Product Owner – Scrum Alliance

M.B.A., Finance and Information Technology, University of Maryland, College Park

B.S., Chemical Engineering, Indian Institute of Technology (IIT), India

Contact this candidate