Customer Service Engineer

RAJAN (RYAN) GUPTA

**** ******** *****, *** # ***, Dublin, CA. 94568

Cell 650-***-****

****.*****@*****.***

Summary

I have 15 years of experience as Software Quality Assurance Lead focusing

on Application Support, Oracle PL/SQL, Quality Assurance, Reports Testing,

Financial Management, Problem Tracking Management, and Business Analysis

and Reporting. My background includes Full-cycle Software Testing, Black

Box Testing, Regression Testing, Functionality Testing, Iphone 3G Testing,

and Application Support. I possess end-to-end business functional knowledge

within traditional and specialized communications, biotechnology, health

care and transportation industry environments including customer care,

billing, accounting, finance, sales planning, marketing, and operations.

Professional Experience

CSC / KAISER PERMANENTE, PLEASANTON, CA

06/12 - PRESENT

Lead ETL SQA Engineer

. Lead test teams composed of software application and ETL testers on

strategic technologies projects

. Source to Target data transform validation between Teradata clarity

database, Oracle staging and DataMart

. Validate Data in Cognos Reports by writing back end queries in

Datamart.

. Testing Informatica code by inserting, updating and deleting (DML)

rows in a table, executing Informatica workflows, and validating the

results using sql queries.

Kaygen / Experian, Costa Mesa, CA

01/12 - 06/12

Senior Reporting SQA Engineer

. Test Plan and Test Cases for UK Mobile Rendering Project

. Test Plan and Test Cases for Web Patrol Data Services Project (ROOT)

. Test Plan and Test Cases for Identity IQ Project

. Validate Cognos Reports Data by writing queries in SQL Server

Management Studio (SSMS)

. Scheduling, Coordinating, Estimating UK Reporting testing timelines

and activities

. Execute Production Launch Plan for reporting tickets deployed in

Procuction

Insight Global / Kaiser Permanente, Pleasanton, CA

02/11 - 12/11

Lead ETL SQA Engineer

. Lead test teams composed of software application and ETL testers on

strategic technologies projects

. Develop test plans, test cases, and scripts from approved requirement

and design documents

. Host test plan review meetings with project team members

. Source to Target data transform validation between Teradata clarity

database, Oracle staging and DataMart

. Executing Clarity Database Macros and validating results against

approved requirements

. Validate Data in Cognos Reports by writing back end queries in

Datamart.

. Manage QTP Automation resource for data validation and Informatica

workflow management projects

Tek Systems / Genentech, inc., South San Francisco, CA

10/10 - 01/11

Lead SQA Validation Engineer

. Authored XFS, Operational Quality, and Product Quality test cases for

GCTD application

. Executed test cases for GCTD (Genentech Common Technical Document)

application

. Authored protocol deviation documentation and their resolution

disposition

. Engaged, interacted, and negotiated effectively with IT, QA,

validation and business project team members

. Developed SQL queries to troubleshoot defects and issues affecting the

GCTD application

. Developed GCTD SQA Test Plans, Specifications and Project Scheduling.

. Assisted the Manager of Quality Assurance and other team members in

the development of Test Procedures, Test Scripts, and SQA lab

standards and tools requirements

SQA Solution / Genentech, South San Francisco

10/09 - 09/10

Senior SQA Engineer

. Imany Government Pricing front end functionality testing

. Government Pricing back end data validation testing

. SAP to Government Pricing interface integration testing

. Data Validation of GP integration for Roche and Genentech

. Integration Testing and Data Validation of ValueTrack application

. Saleforce.com front end functionality, and back end data validation

. Salesforfce.com Reports validation testing

SQA Solution/LA Times, Los Angeles

11/08 - 10/09

Lead Web SQA Engineer

. Develop Test Plan, Test Scripts for web based Zetabid (Auctions and

Foreclosure website)

. Lead, coordinate and participate in daily meeting for defect

resolution

. Develop Regression, Release/Version/Build based automated test scripts

using Selenium IDE

. New features and functionality website testing based on business

requirements

. Validate website data to backend MS SQL Server tables using SQL

queries

Tek Systems / Blue Shield of California, San Francisco, CA

08/08 - 10/08

UAT - Test Data Manager

. Work with business SMEs and UAT testers to identify appropriate test

case data and then with IT load the test data into the appropriate

source and downstream applications

. Identify, create, and load appropriate test data for the GMAPD project

. Co-ordinate and schedule meetings for test data to be inserted into

source applications to support UAT testing

. Co-ordinate and schedule test data extracts to be loaded into

downstream applications

Tek Systems / Blue Shield of California, San Francisco, CA

08/07 - 07/08

SQA ETL Lead

. Manage; and Coordinate offshore team for testing and validation of

data warehouse projects such as BAFA Bill Allocation, Benefits

Capture, Geno_RTMS, Claims, and CAPS

. Running Power Exchange 8.1.1 process to populate real time data from

legacy mainframe to Pre-Stage oracle tables

. Data Validation between legacy mainframe (RTMS) system and data

captured by Informatica Power Exchange

. Compare data row-by-row and column-by-column between two databases

using DBLink based on Primary Key column join condition

. Coordinate with Offshore ETL to help them understand ETL flows and

develop mappings, sessions and workflows Informatica Power Center

. Analyze data in the source system by running complex SQL in TOAD

. Managed efficiently one onsite and six offshore QA resources

. Flat files management using UNIX commands, executing PERL & Shell

scripts in UNIX

. Researching and troubleshooting log and error files to isolate errors

created by informatica processes

Opalsoft / Genentech Inc., South San Francisco, CA

05/06 - 08/07

SQA Team Lead

. Sales force report transformation: data validation and testing sfrt

(sales force report transformation) data warehouse, functionality

testing of business objects reports (webi and xcelcius) reports

. Sql queries for validating data between sales force reports and

backend oracle 9i database using toad 8.0

. Develop master test plan emphasizing its objective, scope and test

deliverables based on available resources and time frame

. Analyze/plan work needed to be done, document and discuss with other

team members and assign work to other group members. Responsible in

writing and executing detailed test scripts, and high level business

cases

. Performed functional, build acceptance, security, regression, smoke,

positive and negative testing

. Conducted bug fix meeting and coordinating with other developers,

business analysts, and dba's to resolve issues in a timely and

efficient manner

. Validated base tables (star schemas) by writing complicated sql

statements and data in webi, and xcelsius reports. Bo (webi and

xcelsius) functionality testing

. Genentech date warehouse: testing implementation of change requests in

the Genentech data warehouse (gdw).

. Source to target data validation of affected tables using sql toad 8.0

and informatica design center 7.13

. Testing scrubs, models, reports, pricing and validating back end data

tables to the Imany GP pricing generator

Aames home loans, Irvine, CA

11/04 - 05/06

Quality Assurance Lead

Develop test plans and test cases for loan origination application

(unifi and loanaforce), develop test documentation from requirement

documentation, execute manual test and analyze test results

Monitor high-level changes to production systems.

Maintain defect and quality metrics reporting to staheholders

Unifi and loanforce production support.

Software regression testing after new release or patch applied to

application.

Charles Schwab, San Francisco, CA

06/04-11/04

Software Quality Assurance Consultant

. QA testing of the eagle star investment portfolio accounting

application

. Creating Star panels test case, test scripts and test execution

. Data validation of transactions sent through the message center.

. Development of test cases, test scripts and test execution of

voluntary and mandatory corporate actions

. Test execution of issues cashiering including calls and put options

Brandes Investment Partners, San Diego, CA

06/03-06/04

Quality Assurance Lead Consultant

Historical dataload lead: manage 2 QA consultants, sql queries to compare

large volumes of data, validating data against the source system and

development specifications, point of contact on assigned projects,

communicate issues and or changes to meet targeted project plan dates,

testing of historical dataload/conversion from Informix to eagle sql server

database

Develop system test plan. Notify team when deliverables and QA

milestones are met and report progress at regular status reporting

meetings

Client reporting lead: manage 3 QA consultants, testing of client

reporting using actuate front end and ms sql server queries, validate

data and report data discrepancies between actuate and Informix

reports, management and troubleshooting defects in PVCS tracker,

provide daily and weekly status report to project managers

Review data specifications, business requirements, and functional

specifications

Client reports smoke test automation using quick test professional

Review testing progress and applicable SCR's

AT&T Wireless, Arlington, VA 01/00-05/03

Lead Quality Assurance Engineer

. Testing the conversion of ho and BSCS application to Convergys Atlys

ver 8.0 (Convergys' billing, customer service and provisioning

application), liaison between business (AT&T wireless) and software

application vendor (Convergys) in the development and execution of

user acceptance testing, Atlys rate plan configuration, validating

referential data integrity by comparing data tables from BSCS and

Atlys

. Usage & billing testing; software regression testing; analyzing &

validating the accuracy of billing in Atlys. Developed detailed test

plans, test scripts, expected results; executed manual and automated

test scripts using Winrunner; and documented actual results

. Date warehouse seed feed, incremental feed and reports testing

. Lead tester of major account billing exchange logistical functionality

(Mabel) including Atlys front end functionality, business rules and

conversion testing

. Lead tester of telephone number inventory application (tni), this is

an AT&T created application to support the federally mandated wnlp

. Lead tester for aldiscon translator, this software converts logical

aldiscon sms records (files) to sema sms records (files) in hp-ux

platform; validate ztango downloadable format files converted

accurately to sema format by aldiscon translator

Sprint PCS, Irvine, CA

12/98 - 06/99

Application Systems Analyst

. Managed all system and billing operations for precedent 2000,

including generating production invoices, executing all system

processes, troubleshooting, and coordination with third-party vendors,

applying software patches, and testing

. Wireless telecom application support for precedent 2000 (billing,

customer service, and phone activation application system)

. Established billing system operational procedures for the following

areas: bill processing, lockbox and payment processing, tax software

updates, tax feed files, general ledger updates, collections, refunds,

call record processing and error handling, user access, and lerg

(local exchange routing guide) updates

. Performed business analysis and developed system procedures in support

of business requirements.

. Analyzed, resolved and documented the lifecycle of trouble tickets

from its initial entry into remedy (problem tracking software) to

vendor dependant stages, referential data in p2k and finally closure

of the trouble tickets

. Troubleshoot issues and drive the issues towards resolution by

communicating with vendors and user community

. Software regression testing in p2k executing Winrunner scripts, and

verifying all fixes performed in the p2k production environment

Cox PCS, Irvine, CA 08/97 - 11/98

Software Test Engineer

. Software verification and validation throughout software development life

cycle

. Develop detailed test scripts, executed functional test scripts, create

expected and actual results, and accumulated test report for the

developers

. Responsible for the rate plan configuration, testing and implementation

of new functional requirements including new product offerings, problem

fixes and enhancements

. P2k rate plan configuration for promotions and marketing programs, usage

and billing testing for bill review, created test approach, test scripts,

and actual results for the wireless billing application (p2k).

Referential data verification in p2k, problem tracking management, and

reporting defects to vendor (Convergys)

. Perform manual and automated operational testing of p2k application

. Conducted acceptance testing on p2k billing system

United Parcel Service ltd., Mississauga, Ontario

07/96 - 03/97

Strategic Financial Analyst

. Automated costing procedures for customer profitability and analysis

using activity based costing, developed customized applications and

solutions for costing individual customer accounts and performed zone

and lane profitability analysis

. Business cost plan integration into the cost ascertainment model

. Maintenance and updating of the cost ascertainment model, billing

information run through bid generator, and development of the cost

plan model

PUROLATOR COURIER LTD. - Mississauga; Ontario 12/90 -

05/96

Business Analyst (Consultant)

. Designed and implemented pricing and cost management model used for

pricing individual customers in SQL

. Aided in the development and implementation of activity based costing

application

. Developed computerized yearly budget model using FoxPro

. Development of Gantt charts by courier and depot for productivity

improvements

. Liaise with various sources to prepare, analyze and co-ordinate

monthly forecasts

. Developed interactive financial model for forecasting financial

statements

. Revenue per shipment, and shipments per day analysis

. Full time equivalency planning, reporting & analysis

. Analysis of proposed capital expenditures

. Courier wages/hours productivity analysis

. Customer profitability/pricing analysis

Education

UNIVERSITY OF BRIDGEPORT, BRIDGEPORT, CT

B.S. in Business Administration

. Major: Finance

. Minor: Economics

www.linkedin.com/in/ryangupta

Contact this candidate