Data Sql Server

Sreeni Garrepelly

Senior QA Lead

Phone: 775-***-****(Cell)

Email: **********@*****.***

Visa Status: Permanent Resident (GC)

Summary:

. Over 10 plus years of experience in Systems Analysis, Design/Development

and Quality Assurance Testing of applications in Mainframe, AS400,

Client/Server, ETL and Web based applications.

. Expertise in Analyzing Business Specifications and develop Test Plans,

Test Cases and Test Scripts and execute them.

. Extensive experience in Unit, Functional, Integration, Regression, User

Acceptance, System, Load & Stress Testing.

. Experienced in Manual Testing and Automation Testing.

. Good experience in Waterfall and Agile Methodologies (TFS & Rally)

. Experience in using Automated Tools like Load Runner, QTP

. Good experience in Infosphere, SFDC (SalesForcedotcom), iSeries and PEGA.

. Excellent working Experience of E-commerce Web and client/server

applications, Web Service Testing, GUI Testing, White box and Black box

which were developed in Object Oriented programming .NET, WebSphere, Biz

Talk server, VB, ASP and JAVA.

. Strong testing and development skills in PHP, .Net, HTML, XML, Java,

JavaScript, Oracle 8.0, SQL Server.

. Good experience on Data Ware House tools like Informatica, Data Stage,

Cognos and Business Objects.

. Strong experience on Data Stage ETL tool for Data Extraction,

Transformation and Load for QA & Analysis

. Experience in writing PL/SQL (Stored Procedures, Triggers, Cursors,

Functions) and SQL statements in databases like ORACLE, DB2, MySQL and

SQL SERVER.

. Ability to interact with developers and product analysts regarding

Testing Status and Defect & Change Tracking using Test Director & Quality

Center(ALM)

. Strong Problem Analysis & Resolution skills and ability to work in Multi

Platform Environments like Windows, UNIX & MVS.

. Worked on different projects as offshore/onsite coordinator

. Excellent Team Member with good Communication and Interpersonal skills

Technical skills:

HARDWARE OS/390, IBM-ES/9000, IBM 3090.

TESTING TOOLS Altova XML Spy, Load Runner 8.0, Quality Center 11,

QTP

(HP Unified Functional Testing 11.53), Selenium (IDE

& WebDriver),, N_Unit, Web service Studio, SoapUI,

Visual Studio Team Systems, Viasoft, Cobtest, Inter

Test, Microsoft Test Manager (MTM),

Opera Mobile Emulator, Rally &TFS (Agile Tools),

Smart Test and

and Bugzilla.

LANGUAGES COBOL, JCL, Java, C, VC++, PL/SQL, VB.Net, C#,

HTML, XML, ASP.net, JSP, Cold Fusion.

DATABASE DB2, IMS-DB, MS SQL Server 2008, Oracle 10g/9i/8i,

PL/SQL, VSAM and MS Access

SCRIPT UNIX Shell Script, JavaScript, and VBScript

ETL Tools Informatica Power Center 6/7 & IBM Data Stage

Reporting Tools Cognos 8.3 and Business Object.

OPERATING SYSTEMS Windows 7/2000/XP, OS/390,MVS, UNIX and AS/400

TOOLS/ APPLICATIONS Endeavor,Expeditor,VSAM,File-Aid,QMF/SQL,SPUFI,CA7,

COMPAREX,TOAD, Beyond Compare, Ultra Edit and

Performance Reporter, DbVisualizer 8.0.6, Apex data

loader 28.0

DOMAIN KNOWLEDGE Mortgage, Financial, Telecom, Health Care &

Government

OTHERS Microsoft Office, Microsoft Outlook, and Visio

Education / Certifications:

. Bachelors in Mathematics (B.SC), Kakatiya University India

. Masters in Computer Applications (MCA), Kakatiya University India

. Completed a training program in Mainframe systems

. Completed a training program in .Net technologies (APP.net, C#)

. Completed a training program in Data Warehouse tools (Informatica and

Data Stage)

. Completed a training program in Automation Tool Selenium (IDE &

WebDriver)

. Certification Course in Performing Advanced Query Techniques in SQL

Server 2008

. Certification Course in Quality Center Defect Management.

Professional Experience:

Bank of America, Plano, TX

08/11 - Present

Mortgage Servicing Technology

Role: Senior QA Lead

Bank of America Mortgage Servicing Technology is the major mortgage company

in USA. I worked on multiple projects in Architecture & Shared Services

division.

Architecture & Shared Services QA is the primary data validation group in

the MST (Mortgage Servicing Technology) and team is responsible for

verification and validation of several data migration and regulatory

compliance related reporting projects to Freddie Mac, Fannie Mae and the

Treasury

Responsibilities:

. Actively participated in each and every phase of project STLC.

. Prepared robust Test plans using HLD/LLD documents and as well as test

scripts.

. Performed functional and manual testing to identify various critical

level defects during the testing phase and delivered bug free code.

. Expert in System Integration testing (SIT), User Acceptance (UAT) and

Regression testing

. Experience in Traceability Matrix against the requirement specification.

. Expert in developing SQL queries to perform Database level testing.

. Interacted with developers and analysts to resolve application

defects/issues.

. Conducted various testing scenarios like positive and negative test

scenarios, conducted baseline testing, and generated reports.

. Responsible for Test plans and test scripts walkthrough to entire project

and application teams and get the approvals.

. Using UNIX commands to compare downstream data.

. Responsible for managing offshore team by assigning tasks, mentoring and

reviewing the tasks.

. As a lead, I am responsible for reviewing and approving the test plans

and test results written and tested by team.

. Expert in preparing testing Status reports with defect status and testing

Progress.

. Experience in training the new resources

. Web sphere portal Compatibility testing on all cross browser

. Tracked defects, which include adding defects, repairing open defects,

testing a new build of the application, and analyzed defect data using

Quality Center (ALM) and TFS

. Host weekly defect report meetings and update testing progress to team.

. Involved as part of automation team using QTP (UFT), developed test

scripts.

. Involved in web functional testing for Next Gen web applications (IR2,

SFDMS)

. Tested applications compatibility on Mobile Devices (iOS, Android,

Windows Phone) with Opera Mobile Emulator.

. .Involved in Performance test execution for Next Gen application (IR2).

Environment: Windows 7, MS SQL Server 2008, Visual Studio Team System, SQL

Server Reporting Services (SSRS), SQL Server Integration Services (SSIS),

Oracle 11g, XML, IBM Cognos Viewer, i-Series (AS/400), TOAD, Sales force,

Info Sphere DataStage and Quality Stage (ETL), IBM Web sphere, Tectia

(UNIX), Beyond Compare, Snagit, Ultra Edit, DbVisualizer 8.0.6, Apex data

loader 28.0, Rally, Team Foundation Server (TFS), Application Lifecycle

Management 11.00 (Quality Center ) and QTP (HP Unified Functional Testing

11.53)

Bank of America, Addison, TX

02/06 - 07/11

Credit Card Services

Role: Senior QA Analyst

Bank of America Credit Card Division (MBNA) is the major credit card

company in USA, CANADA and EUROPE. The File Maintenance (FM) application

supports the account maintenance function of the overall U.S MBNA

processing system. FM is the main posting and billing process for the U.S

Cardholder system. FM inputs, verifies, and applies all account activity

(monetary and non-monetary) and posts the valid activity to the appropriate

customer's account.

Responsibilities:

. Used tools including QMF and SPUFI for running and testing of programs.

. Prepared test plans as per the Business Requirements Document (BRD).

. Involved in STRESS/ Performance test for Core FM & Source.

. Performance & load testing of Core FM application with high volume of

production data and compared with Baseline data.

. Supported maintained test environments and platforms in 24/7 operation

supporting North America and Europe platforms.

. Running Batch jobs.

. Interacted with developers to resolve application defects.

. Manual testing of thin & thick clients that interface to residential

funding and Project data files validation, which is transferred via FTP to

mainframe environment.

. Used good debugging tools like Expeditor.

. Modified COBOL, DB2 application programs and tested all the applications

then put into production

. Validated System and system integration testing for card holder payment

website

. Create test cases for the user acceptance test and co-ordinate with the

users during UAT

. Tracked defects, which include adding defects, repairing open defects,

testing a new build of the application, and analyzed defect data using

Quality Center.

Environment: Windows XP, MVS, Windows XP, COBOLII, DB2, JCL, VSAM,

JavaScript, VB Script, Java, Loadrunner, Quality Center 9.2, SQL,Clarity,

Expeditor & Report generator.

GMAC, Minneapolis, MN

09/05 - 02/06

.Net Migration Project.

Role: .Net Migration Analyst

RFC-MEM is a migration project; the application was on migrated IMS DB/DC

platform. In order to accomplish the objectives of the migration, the data

store was moved from hierarchical IMS to relational Oracle structure and

the online user interface from IMS DC to a thin browser based interface in

a .net environment and architecture.

Responsibilities:

. Responsible for application development life cycle including analysis,

coding and testing.

. Involved in conversion process from Mainframe to .Net migration.

. Worked on the IMS/DB and Oracle databases.

. Responsible for conversion from JCL to C# objects.

. Involved in building XML web services and XML Schema validation.

. Worked on input and output validations and exception handling.

. Involved in creating business rules for business classes.

. Used Web Service Studio for unit testing.

. Used GUI testing to check for appearance of the website.

. Used The Microsoft Application Block for Event Logging.

. Tested applications compatibility on different platforms (Windows, Linux,

Mac OS), browser versions(IE,Firefox, Safari and Chrome)

. Used good debugging and comparison tools like Hex Edit and Beyond

Compare.

Environment: Windows XP, Microsoft. NET2003, ASP.net, VB.net, C#, .NET

Framework, XML, Visual Studio,SoapUI, Net COBOL MS SQL Server 2008, JCL,

IMS DB/DC, Hex Edit, Visual Source Safe, IIS and SQ

Verizon Data Services, Dallas, TX

09/04 - 08/05

Customer Ordering Services (COS)

Role: .Net Developer

These applications are written predominantly in CICS COBOL, and have been

modified to use a DB2 wrapper around the legacy systems. The Common

Ordering Services project is designed to provide a common set of web

services for these applications. These web services are being developed in

the .NET framework

Responsibilities:

. Involved in end-to-end COS web services.

. Used Visual Source Safe 6.0 during development that eliminated

multiple users from working on the same web method.

. Involved in analyzing the NOCV Mainframe Programs.

. Responsible for logically grouping web methods, which are in ERA and

NOCV Web

Services.

. Involved in building XML web services and XML Schemas.

. Installed, configured SoapUI to test web services using WSDL file

given by Development team.

. Involved in design and development of request and response schema

. Creating ASP.net pages using C#, used data caching features and

security features of .NET framework

. Build the different layers like Data Access Layer to manipulate the

Data and Error Layer

to Log the Errors, Business Layer to build the business classes for

the system using C#.

. Involved in creating business rules for business classes.

. Used Web Service Studio for unit testing.

. Works with functional users on programming issues and projects with

discussions as Business Analyst.

. Involved in Stress testing using Web Application Stress (WAS) Tool

. Involved in integration of East & West schemas on Integrated

Infrastructure for Ordering (I2O) project.

Environment: MVS/ESA, Windows XP, COBOLII, CICS, DB2, JCL, DB2 Connect,

QMF, SPUFI, ASP.net, C#, SOAP, Altova XML Spy, .NET Framework, VS.net, XML

Web Services, ADO.Net, Visual Studio,Visual Source Safe, Web Service

Studio, IIS and SQL

IBM Global Services, Boulder, CO

10/03 - 08/04

Role: Database Analyst

The System Measurements team for all reporting requirements from IBM

customers. Coordinating with all team members and accomplishing all

customer requirements on time.

Responsibilities:

. Used tools including QMF, SPUFI and DB2 Connect for running and testing

of programs.

. Responsible for application testing which involves receiving customer

requirements and

Processing SMF & VM data using TDS for OS/390 (Performance Reporter).

. Responsible executing and updating Test Cases for accounting modules.

. Developed Test Cases based on document.

. Reported the bugs using Test Director - the defect management tool

. Responsibility of SMF data collection processing and query/reporting.

. Validated Tables by inserting, deleting, updating records.

. Responsible executing and updating Test Cases for Accounting and Billing

modules.

. Tested and verified the Hourly report 7 days a week and Monthly reports.

Environment: MVS, AS/400, COBOL, DB2, JCL, VSAM, File Aid, SPUFI,

Performance Reporter, TDS for OS/390, Unix Shell Scripts, Test Director,

QMF and SQL

Lowest Bids, Carson City, NV

11/00 - 09/03

Role: Web Developer / Tester

Lowest Bids launches the world's first online auction site connecting

buyers to live sellers on demand. It is a real-time consumer auction site

that enables sellers to participate lives in their own auctions. It has a

unique system of updating its auctions in real time. It is the first

auction company to implement Bid Bar technology along with auto refreshing

auction.

Responsibilities:

. Created and Tested various Manager Systems that control the complete

operations of the the Auction website

. Tested shopping cart application that utilized third-party component for

credit-card validation and acceptance over the website.

. Performed Web Testing to check for broken Links in the Web Page.

. Tested on the Live Instant Help (web-based chat) using Java Applet

programming.

. Tested in other web sites namely Web Wide Advertising, Instant Web

Charge, and Accept Pay.

. Created SQL scripts for deploying from development to other environments.

. Developed Shell Scripts on Unix and Batch programs on Windows to automate

testing tasks.

Environment: Windows XP, ASP 3.0, VB 6.0, Java, JavaScript, Unix Script,

VBScript, SQL Server, Visual Source Safe 6.0.

Contact this candidate