Venkata Nukarapu

847-***-****

SUMMARY

. Over 10 years of experience in Test strategy, Test Planning, Test

execution, UAT and Implementation support for enterprise level Web,

Client/Server, and Batch applications.

. Extensive working experience in Agile (Scrum) and waterfall

methodologies.

. Experience in testing applications in diverse domains such as Finance,

Banking, Mortgage, Staffing, Product, Health Insurance and Auditing.

. Experience in Complete Software Development Life Cycle (SDLC) from

Business Requirements through Implementation and QA involvement in

different phases/Gates.

. Experience in writing Test Cases, developing and maintaining test

script based on business, technical and functional requirements.

. Experience in Test Data creation based on requirements, Test Case

execution, generation and documentation of Test results.

. Analyzed Business Requirements and built scripts with different

scenarios.

. Experience in using test and automation tools such as Mercury

Interactive Tools (Win Runner, Quick Test Pro, Test Director) and

Rational Suite Enterprise (RequisitePro, Test Manager, Robot and Clear

Quest).

. Good knowledge in Performance Management tool Load Runner.

. Strong Skills in coordinating and executing Integration, GUI, System,

Functional, Regression, Performance, and Stress Testing.

. Strong Experience in writing complex SQL, PL/SQL Queries for Backend

Testing.

. Experience in testing using ETL and Reporting tools such as

Informatica, Business Objects.

. Expertise in MS Office Suite (Ms-Word, Ms-Excel & Ms-Access).

. Specialized in Testing UNIX, Windows and Peoplesoft Environments.

. Worked in close coordination with Analyst, developers and other team

members in testing complex projects and in the overall enhancement of

software product quality.

. Ability to manage multiple projects simultaneously in a team

environment.

Strong interpersonal skills and excellent communicator who works well

independently and as a team and can work efficiently in fast-paced

environment while prioritizing responsibilities to meet management

deadlines.

EDUCATION: Bachelor of Egg from JNTU University - India

STATUS: US Citizen

CERTIFICATION: Oracle 9i (Introduction to SQL)

Technical Skills

Operating Systems: Windows 7/ XP 2000/98/95/NT, UNIX, MS-DOS,

Intel, Perl

Testing Tools: Mercury Quality Center 10.0, QTP 10.0,UFT

(QTP 11.0), ATC,AQT,WinRunner 7.0, LoadRunner 7.0,

Quick Test Pro, Silk, SQA Robot, Rational Test Suite,

Rational Rose.

Service Tool: SOAP Sonar

Defect Tracking Tools: Quality center 11, Test Director 7.01,

Clearquest

Version Control Tools: Rational Clear Case

Languages: Visual Basic V.B (6.0), C, C++, PL/SQL

Data warehousing Tools: Informatica 6.2, Business Objects XI,

Abinitio.

Data Bases: Oracle 9i/8x/7.3, SQL Server, MySQL, MS Access 2000,Sybase.

GUI Tools: Toad, PL SQL developer, DB VIsualizer, Research Browser, View

Notes, Research Print, Co-Insite, TPS, Apex screen,

Analyst Assignments,JIRA, Rapid SQL.

ERP: People soft HRMS/FIN 7.5, 8.4, 8.8, EPM 9.0

PROFESSIONAL EXPERIENCE:

FIMT(Asset Management),Raleigh NC Aug 2012 -

May 2014

Sr.QA Engineer

NGR Publishing and Approval process is being rewritten to address the

business needs for a simple and robust process of creating and publishing

research and managing approvals, more configurable and flexible publishing

system, more integrated workflow, quicker time to market for enhancements,

reducing technology support and maintenance costs, and improving the cross-

organizational sharing of research data and its quality. The new system

will leverage MS office features, will be coded in .Net. It will also

leverage shared services and database components developed by Common

Research Services (CRS), and CDE. For data it will reference Oracle CDE and

ODS.

Responsibilities

. Responsible for Sanity, System, UAT, Integration and Performance

testing for all the Process.

. Performed testing for all Templates across different advisors Equity,

High Income, Fixed Income,Global Asset Allocation and Counter party

domains.

. Performed End-End testing based on cusip's, securities,tickers,

Issuer groups,Issues data.

. Validated Templates by assigning Security information through Analyst

assignment,Apex screen tools.

. Responsible for testing regression and smoke testing by coordinating

with developers for every old(prod) and new release to ensure that

system processes are running from end to end and validate the system

is ready for full scale testing.

. Validated all templates for scenarios Launch template, Save draft,Reopen draft, Publish,Edit financials, Model capture, Periodic

Items, point In time Items, Text sections, Ratings(5pt&6pt),

Beneficial Interest, Benchmark Index, Fact set chart, Market

data,Publishing summary,Attachments.

. Validated published notes are process through synch and make sure they

are processed through CRS Payload .

. Validated all published notes in down stream applications: Research

browser, View notes, Even Notification.

. Validated various Sources, Targets, and developed ATC scripts for

making sure stored proc's are running as expected.

. Responsible for checking the config files before testing and make sure

all the source and target files are correct in UNIX.

. Validated for comparing source and target tables for data Quality

using Advanced Query tool.

. Responsible to schedule and Monitor service Jobs through site scope.

. Responsible for monitoring all the services are up and running through

Fiddler.

. Validated all NGR,CDE and other services through SOAP Sonar Tool.

. Tested End to End Process through Informatics ETL, UNIX and Toad.

. Created different SQL and PL/SQL Scripts for different process and

Reports and tested them in back end using Toad.

. Tested PL/SQL Stored Procedures to check the status of the target

database before moving records into it.

. Validated Automation scripts through QTP for version 10 and UFT 11.0.

Environment:

VB.Net, Oracle10g/11g,PL/SQL Developer, Sybase, SOAP Sonar,ATC, Windows

XP,WIN7, Xen machines, Blade, Virtual desktop, Mercury Quality center

10.0,MS-Word, Excel, View Notes, Research Browser, Template Launcher Add

In, Model Capture, Total Packing system, Research Print services, Domains:

Equity(Company, General, Industry, IPO, Sovereign, Em-Corportate),

HI(BLDaily, Daily, General, QuickNote,HIREDaily,HIRE

General),FI(Security,Legal,Structured),CRA,EWS,Techpublisher,share point,

Ribbit, JIRA, Event Notification

Fidelity Investments, Raleigh NC

Aug 2011 - July 2012

ETL Tester

This application is about Customer warehouse Enterprise (CWE). CWE is a

collection of databases, data marts, business rules, and data movement jobs

which together provide the central repository for Retail customer, prospect

and member data. Various functions which were performed are daily update

and data aggregation, Identification of unique Individuals, marketing

household profiling, campaign targeting, management & measurement,

operational and collaborative empowerment through modeling & decision

support enablement.

Responsibilities

. Responsible for Sanity, System, UAT, Integration and Performance

testing for all the Process.

. Responsible for testing Dry Run by coordinating with developers for

every new release to ensure that system processes are running from end

to end and validate the system is ready for full scale testing.

. Validated various Sources, Targets, and developed Transformations

using Informatica Power Center Designer.

. Responsible for checking the config files before testing and make sure

all the source and target files are correct in UNIX.

. Validated for comparing source and target tables for data Quality

using Advanced Query tool.

. Responsible to schedule and Monitor the Jobs through Control M

scheduling utility.

. Tested End to End Process through Informatics ETL, UNIX and Toad.

. Created different SQL and PL/SQL Scripts for different process and

Reports and tested them in back end using Toad.

. Tested PL/SQL Stored Procedures to check the status of the target

database before moving records into it.

Environment: Oracle 10g, Toad for Oracle 9.6, AQT, UNIX, Mercury Quality

center 10.0, Informatica, Clear case, Control -M

Capital One, Richmond,VA

Sr.QA Tester/Analyst Feb 2011 - July 30

This application is about different mobile devices (Iphone, Andriod,

Legend, Tatoo, Nexus, Black berry) for different versions of WAP and App

and testing these devices for Online Financial Transaction process of COB

(Capital one Bank) cards .The different process of transactions through

card are Pay bills, Accts, Find Branch/ATM, Mobile banking FAQ and through

Bank are Pay bills, Transfer, Accts, Find Branch/ATM, Mobile banking FAQ.

Payments will be processed through swept jobs. Once the transactions are

processed needs to be validate in OLB, EOS and the database.

Responsibilities

. Setup of Test environment for both manual and automated.

. Created Functional Test scenarios for CMS and ATM Process

. Responsible for Sanity, UAT, System, Integration and Performance

testing for each Release.

. Developed system test strategy, System test cases and traceability

matrixes.

. Responsible for testing Dry Run by coordinating with developers for

every new release to ensure that system processes are running from end

to end and validate the system is ready for full scale testing.

. Responsible for testing different mobile devices (Phone, Android,

Legend, Tattoo, Thunder bolt, Nexus, Black berry) for different

versions of WAP and App and testing these devices for Online

Financial Transaction process of COB(Capital one Bank) cards

. Validated logs and database as per to the Input File Transactions

through swept Job.

. Validated Data Migration Files data by comparing the Input and

Expected output given by capital one Reports and Batch posted Files.

. Validated once the address changes are migrated in Nightly batch

cycles and cross checked whether those changes are updated to the

accounts in Mainframes (IM).

. Responsible for Testing Financial Transactions for Cards and Bank

(Playbills, Transfers, Account details, Branch ATM, Zip code, Current

Location, Mobile Banking FAQ,) for different Regions Operating system

devices.

. Validated these Transactions in IM (Mainframes) in different regions

as Memo-post and Hard post based on the Receipt date, time,sequence

number, account number should match the Transactions posted in

Mainframes.

. Responsible for Testing the de-convert files (Strip and Hold, CMS,

Input Balancing) through Issuer direct and validated data in

Mainframes (IM).

. Responsible for Testing Reports weekly, weekends, Holidays and Monthly

reports in Acquire and Issuer direct for capital one cards.

. Responsible for Testing GL Update Process all the data is posted to

General Ledger .Validated these Process through Reports.

. Execution of Test Scripts and Test Summary Report and Tracked defects

in Mercury Quality center.

Environment: Oracle, Toad 9.5, Ms-Excel 2003, UNIX, Mercury Quality Center

10.00, QTP 9.2, Reflection (Mainframes), Knowledge Link, Share point

New Corp, Columbia MD

Aug 2010 - Feb 2011

Sr.QA Analyst

NEW is a Authorized Installation or service provider application which we

can access Online through service bench .Service bench is an advanced,

fully automated scheduling, dispatching and reporting system to make Job

faster and easier. Service bench contains different modules like Warranty,

Claims, Payment Processing, Orders, Electronic documents Product

Registration and Warranty Analysis Module. Service bench application is

handled by different clients like NEW,NEW-DI,NEW-WARLOC,NEW-

SG,GOODMAN,CARRIRER,IBM,LOWES,BESTBUY,UTILIPRO.

Responsibilities:

. Responsible for testing major Process for different work streams in

System, Integration and IP (Production).

. Created Test Plan, Test Scenarios, Test cases Various work streams

Clients (NEW,NEW-DI, NEW-War loc, Good Man, NEW-Shipping gateway)

. Testing different SQL and PL/SQL Queries for different work streams

using Toad.

. Responsible for preparing data and testing different client process

through XML for system, UAT and Pre prod.

. Application Engine and EDI (Electronic Data Interchange) into Excel

sheets and then dumping the data into particular Oracle database

schema through SQL Loader.

. Tested ETL's for system validation process in UNIX box during System

and Preproduction.

. Developed and tested for aggregating the amortization amounts by

preparing Schedules, SQL, PL/SQL Queries and HTML Reports for

different work streams.

. Responsible for testing and validating various Processes like Product

Registration, Servicer Registration, Auditing of Bank Accounts,

Warranty, Claims, Imports (BMS, RTI), XML.

. Tested End to End Process through Excel, UNIX and Toad.

. Tested Application from Front End (UI) and back end through Batch

Process for System Testing.

. Responsible for creating Test scenarios based on Functionality for

different Clients.

. Created Automation Test scripts for UI Test cases Using QTP 9.2 Tool.

. Tested different reports through service bench application in Front

End and back end through Oracle.

. Created Test Summary Report which summarizes total number test,

executed test, open tests and open defects.

Environment: Oracle 10g, Toad, XML, JAVA/J2EE, UNIX (Sun Solaris), Jeri,

Excel, QTP 8.2.

Capital One, Laurel MD

QA Analyst Dec 09 - July 2010

This Application is about Integration of Chevy Chase Bank with COB ATM

Machines, AP, AR, Receipts, Debit card Processing, Deposits Process. The

application will follow the guidelines and will be consistently enforced by

COB. This program will allow Customers to sign up for new cards, daily

Transactions, report modifications and report daily and monthly data for

Card Management, Data Migration files, Interface Files, ATM Transactions,

ATM Deposits, ATM Cash Management, Reports. The system shall record the

details of the existing and modified process and keep track if any changes

occur in ATM Transactions.

Responsibilities

. Setup of Test environment for both manual and automated.

. Created Functional Test scenarios for CMS and ATM Process

. Responsible for Sanity, UAT, System, Integration and Performance

testing for each Release.

. Developed system test strategy, System test cases and traceability

matrixes.

. Responsible for testing Dry Run by coordinating with developers for

every new release to ensure that system processes are running from end

to end and validate the system is ready for full scale testing.

. Responsible for testing Card Management System process ( Creating new

capital one cards, Changing Existing Chevy chase cards to Capital one

cards, Replaced broken cards, Replaced Stolen cards) for Business

check cards, ATM cards, Converted Chevy chase cards, capital cards,

Fifth third cards, Perm Debit cards.

. Validated New card / BIN Numbers, Replaced card / BIN numbers in the

database as per to the Input File.

. Responsible for Testing Data Migration files (CMS to FTPS, PBS to

PRISM, New PRISM, Historical data loads (Signature, PIN-POS, Charge

backs, Adjustments)) Files.

. Validated Data Migration Files data by comparing the Input and

Expected output given by Fifth Third Reports and Batch posted Files.

. Responsible for Testing Address changes for CMS and ATM Account

Transactions through Touch point.

. Validated once the address changes are migrated in Nightly batch

cycles and cross checked whether those changes are updated to the

accounts in Mainframes (IM).

. Responsible for Testing ATM Transactions ( Withdrawals, Stamps

purchase, Deposits, Transfers, Preferences, Mini-statements, PIN

Changes ) for different Regions ( Mid-Atlantic, North East, South

central ) for OSS1, OSS2,OSS3 and OSS4 ATM Machines.

. Validated these Transactions in IM (Mainframes) in different regions

as Memo-post and Hard post based on the Receipt date, time,sequence

number, account number should match the Transactions posted in

Mainframes.

. Responsible for Testing the de-convert files (Strip and Hold, CMS,

Input Balancing) through Issuer direct and validated data in

Mainframes (IM).

. Responsible for Testing Reports (Cash Management, ATM Transactions -

A,B,C,D) weekly, weekends, Holidays and Monthly reports in Acquire and

Issuer direct for different ATM Machines .

. Responsible for Testing GL Update Process all the data is posted to

General Ledger .Validated these Process through Reports.

. Execution of Test Scripts and Test Summary Report and Tracked defects

in Mercury Quality center.

Environment: Oracle, Toad 9.5, Natasha 5.6, Ms-Excel 2003, UNIX, Mercury

Quality Center 10.00, QTP 9.2, Reflection (Mainframes), Java, Acquire,

Issuer Direct, Touch Point.

THE HARTFORD Hartford, CT Jan 08

- Dec 09

ETL Tester

Hartford (Insurance Company).Reinsurance is automating their applications.

(What-If, RRS, Strategic) that must work together to apply several

Premiums, Adjustments, Consolidations and Losses related to Claims and

Policies. The objectives of the UAT, System, Integration and production

Testing are to validate that the Procede system properly extracts data from

sources (ODS,Procede,Informatica,Intel) and Store results in database.

Responsibilities

. Responsible for Sanity, System, UAT, Integration and Performance

testing for all the Process.

. Responsible for testing Dry Run by coordinating with developers for

every new release to ensure that system processes are running from end

to end and validate the system is ready for full scale testing.

. Validated various Sources, Targets, and developed Transformations

using Informatica Power Center Designer.

. Validated and Monitored sessions using Informatica Server Manager.

. Responsible for checking the config files before testing and make sure

all the source and target files are correct in UNIX.

. Responsible to Execute and Monitor the Jobs through Autosys.

. Tested End to End Process through Informatica, Intel, UNIX and Toad.

. Created different SQL and PL/SQL Scripts for different process and

Reports and tested them in back end using Toad.

. Tested PL/SQL Stored Procedures to check the status of the target

database before moving records into it.

Environment: Informatics 6.2, UNIX (Sun Solaris), Oracle, Toad, Intel

(Windows XP), Rational Clear Quest, Ms-Excel, Autopsies; Win Runner, TSL

Scripting, Agile Methodology.

CitiGroup, Tampa FL Jan 07 - Dec 07

QA Analyst

Citi Group has implemented BICFS (Best in Class Financial System). The aim

of BICFS is to Implement Enterprise performance management (EPM) for

different countries (Mexico, Brazil, and Argentina etc.) to map GL and

Product systems data directly into Reporting Charts of Accounts. BICFS

consists of different Reporting applications such as Data Mart, Data Burst,

FRS (financial Reporting system), FDL (financial data load), STAR (shared

technology account reporting), GIMC (global Inter management

consolidation), GCMD (global consolidation management data), Local

Regulatory and Local Management. BICFS establishes traceability for

Reporting at different levels (Global, Country, and Local) and allows users

to start analysis at 4 entry points and drill down to lower levels for

details.

Responsibilities:

. Co-coordinating with off shore SQA team in developing system test

strategy, System test cases and traceability matrixes.

. Tested different Process like Instrument Ledger, Conformed Ledgers,

and Merged Ledger Process.

. Performed database level testing and assisted developers in

identifying problem queries for further tuning.

. Responsible for testing Data Upload and Download process through

Component Interface for FA, MA, Allocations, Instrument correction

process.

. Created different SQL and PL/SQL Queries for different process and

Reports and tested them in both front-end people soft (PS Query) as

well as back end using Toad.

. Tested in various environments with Positive and Negative data sets to

cross check the functionality of the different Modules, Work Flow

Process, and Reports.

. Responsible for testing reports using Business Objects.

. Created Requirements Trace ability Matrix (RTM) in order to map the

requirements to the test cases in the Mercury Quality center.

. Execution of test cases and generating bug report and Defect Tracking

through QC.

Environment: Oracle 10g, SQL Server,Unix, MS-OFFICE/Excel, Mercury

Quality Center 9.0,Load Runner, SQR Reports,Crystal Reports, People Soft

EPM, Business Objects XI.

FANNIEMAE, Herndon VA Oct 05 - Dec 06

QA Analyst/Tester

Fannie Mae (Mortgage Company) is restating its earnings for Fiscal Years

2002, 2003, 2004, 2005 and 2006. Restatement is a set of applications

(PDR, WLCBSL, SSL, GFABSL and FDW) that must work together to apply several

accounting policies related to Loans. The objectives of the UAT, System,

Integration and production Testing are to validate that the amortization

system properly extracts data from sources (PDR, WLCBSL, SSL, GFABSL and

FDW), and calculates amortization factors and stores amortization results

in amortization database.

HAMP (Home Affordable Modification Program) shall implement and enforce the

objectives of the Homeowner Stability Initiative. Loan Modifications for

all borrowers will follow the same guidelines and will be consistently

enforced. Once borrower successfully completes a trial period, the loan

modification shall become permanent. This program will allow servicers to

sign up, report modifications and report monthly data during and after the

trial period. The system shall record the details of the modification (at

the time of the original modification and the official modification),

accept and appropriately keep track of monthly reporting and transfer

funds, and provide the proper reports.

Responsibilities:

. Responsible for testing major Process for different work streams in

UAT, System, Integration and IP (Production).

. Created Test Plan, Test Scenarios, Test cases in Mercury Quality

Center for Various work streams (WL, Securities and Gfee's).

. Responsible for validating ETL's in System Testing and "Am" Engine

calculations through Schedules in User Acceptance Testing (UAT).

. Created different SQL and PL/SQL Queries for different work streams

using Toad.

. Application Engine and EDI (Electronic Data Interchange) into Excel

sheets and then dumping the data into particular Oracle database

schema through SQL Loader.

. Tested ETL's for system validation process in UNIX box during System

and IP.

. Developed and tested for aggregating the amortization amounts by

preparing Schedules, SQL, PL/SQL Queries and HTML Reports for

different work streams.

. Responsible for testing calculations for balances of Average balance

Calculations, Incremental, and Adjustments in ADB (Average daily

balance) calculations.

. Responsible for testing Dry Run by coordinating with developers for

every new release to ensure that system processes are running from end

to end and validate the system is ready for full scale testing.

. Responsible for testing and validating various Process like Contract

Registration, Servicer Registration, Loans, Auditing of Bank Accounts,

Auditing of PMMS Mortgage, Technical POC, Analyst dashboard, HAMP

Analyst to servicer.

. Tested End to End Process through Excel, UNIX and Toad.

. Responsible for preparing data for system testing through Altoona XML

Spy Tool.

. Tested Application from Front End (UI) and back end through Batch

Process for System Testing.

. Responsible for creating Test scenarios based on Functionality for

Trial and Officials, OMR Process.

. Created Automation Test scripts for UI Test cases Using QTP 9.2 Tool.

. Tested Internal Control Reports, Error and Exceptional Reports through

Business Objects in Front End and back end through Oracle.

. Created Test Summary Report which summarizes total number test,

executed test, open tests and open defects.

Environment: Black Box Testing, Oracle 10g, Rapid SQL, Business Objects XI,

JAVA/J2EE, Unix (Sun Solaris), Mercury Quality Center, Rational Clear

Quest, Business Objects XI, Abilities, QTP 8.2,Java.

SAFECO INSURANCE. Seattle WA Jan 05 - Oct 05

QA Analyst

Safeco Insurance Company focuses on providing the insurance products that

matter most to consumers - auto, homeowners and small business policies.

Safeco business helps people protect what they value and deal with the

unexpected Reasons. Safeco delivers products over a web-based sales and

service platform that enables our distribution partners to quote and issue

an insurance policy or surety bond in a matter of minutes. Safeco is making

Customizations in People Soft 8.8 Financial Modules on GL, AM, PO & AP.

Responsibilities:

. Responsible for developing Test plans for Batch, Security and

Integration Process, Test case customizations for GL, AM, PO, AP, Work

Flow, Batch Interfaces, Security.

. Worked with Safeco Main Important Process Change Control, Conversion,

Customization (EDI, High volume Transfer (HVT), Work Flow, Translation

Manager, FMS and Archiving of Tables), Integration, Issue Log,

Security and SOX Queries and Reports Process.

. Responsible for preparing Security, Work Flow Matrix for Testing.

. Developed Documents for Batch Jobs like PFN Close, PRD PFN Utility

Jobs, TAC GL Batch Jobs and PRD GL-AM-AP-PO batch Jobs.

. Tested Translation Manager, FMS and Archiving of Tables both in

Production database in People soft 7.63 and UAT, Integration Database.

Environment: Financial Modules (GL/AM/PO/AP), Application designer,

Application Engine, Process scheduler), Rational Tools, DRAT, Main frames,

HTML,XML, Windows 2000, Oracle 9i, UNIX, MS-OFFICE/Excel, MS- visio, Life

Insurance Application.

OSI INC Glastonbury, CT Aug 03 - Sep 04

QA Tester

Open solutions Inc is a provider of technology, software and services that

allow banks, thrifts

And Credit Unions to complete and service their customers like Provident

Bank, Patriot Bank,

First Savings Bank more effectively.

Responsibilities:

. Involved in writing business/ user requirement and technical

requirements.

. Created script files containing the test cases using Win Runner that

implement the tests described in the test plan.

. Used Win runner for Regression testing using on each new build of

Application Under test.

. Involved in writing UNIX shell scripts to check database integrity.

Environment: People Soft Financials 8.8 includes (Reqs, PO, AP, GL and AM)

Crystal Reports, PS n Vision, SQR, SQL Server, UNIX, Win Runner 7.0, Test

director 7.0, VB 6.0, Oracle 8i.

Contact this candidate