Rimpal Gupta

(ac3444@r.postjobfree.com)

908-***-****

Professional Summary:

* + years of IT industry experience in Software Quality Assurance in Data Warehouse, Front End, ETL & BI applications.

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.

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

Well versed with the data modeling to understand the logical and physical relation between facts and dimension tables (OLAP) as well as tables is 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.

Strong technical Knowledge of UNIX Utilities, shell Script to automate process.

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

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

Extensively used 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 free hand 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 appropriate team as required.

Experienced in providing knowledge transfer to the fellow team member based on lesson learnt 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.

Technical Skills:

Testing Tools

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

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,SQL Server 2012

Sybase 12.5

ETL/DW Tools

BI Tools

Informatica, DataStage, SSIS

Business Objects XIR4, Cognos 8.4, Ab Initio

Data Modeling

Erwin 7.0, ER Studio

Methodologies

Agile, SDLC

Experience:

Verizon Wireless, Warren, NJ April 2017 – Present

Senior Quality Assurance Engineer

Domain Knowledge of telecom processes/concepts such as Offers (maybe and what if) and Order, Billing, OCC (Overage Charge Credit) and Customer retention.

Responsibilities:

Worked on ACSS, POS, NetAce, Omni Indirect and Retail, OnePos East and West

Strong testing activities on PEGA 7 (Designer Studio, Run Strategy, Proposition Managements)

RTD Portal for PEGA 7 testing with updates according to stories assignments

Run Smoke test after every build, twice a day about Offers and Compass flow

Testing Erules and Vrules with test propositions and verify that updates available in Testing tools

Erules testing for CMA codes updates

Performed tests by examining XML files generated during handoff to other systems

Start Dates and End dates updates in PRP's according to Proposition Matrix

Created and executed Test cases in ALM

Opened, tracked and Verified Defects in ALM

Extracted reports from ALM for reporting purpose for team management

Provide updates and get status of team in Morning Standup Call

Documented and Updated the Stories in JIRA for all team acknowledgement

Environment: HP ALM, Oracle 11g, SQL, PL/SQL, Pega 7, UNIX, TOAD,

AT&T through IBM, Middletown, NJ April 2016 – March 2017

Senior Quality Assurance Engineer

Domain Knowledge of telecom products such as Managed Internet Service (MIS), Virtual Private Network (VPN), Business Voice over IP (BVOIP), IPFR/IPTF and other strategic business offering. Familiar with design, pricing, proposal, electronic contracting, provisioning, service delivery and billing. Knowledge and experience working in mobile platforms like iOS, Android etc.

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

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

American International Group (AIG), Berkley Heights,NJ April 2014 – April 2016

Senior Quality Assurance Engineer

Domain Knowledge of Insurance, Risks- market, credit and operational; Risk Aggregation, Scenario Analysis, Risk-adjusted performance measurement, Policy, Position, Endorsement, Coverage and Counterparty Operational data.

Responsibilities:

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

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 walk through 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 potential 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

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

Standard & Poor’s, NY Jan 2014 – April 2014

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 scenario’s 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

State Street Corporation, Princeton, NJ June/2007 – Sep 2013

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.

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: MS in Science (LUCKNOW UNIVERSITY, LUCKNOW, U.P, INDIA)

Post Graduate diploma in computer application (MCA – Masters in Computer Application)

Status: US Citizen

Contact this candidate