Post Job Free

Resume

Sign in

Sql Server Engineer

Location:
Redmond, WA, 98053
Posted:
August 28, 2010

Contact this candidate

Resume:

Prashanthi Bodicherla

**** ***** *** **, *******, WA 98053 954-***-****

ablpq7@r.postjobfree.com

Summary

* ***** ** ********** ** a Lead Software Test Engineer, writing and executing test plans and test cases in highly

structured and loosely structured development environments and performing all types of testing (functional, installation,

acceptance, device compatibility, load, stress, performance, volume); several years of experience managing software QA

programs. Extensive experience writing and executing automated testing scripts (primarily with web based and RFID

technologies). Provides timely and consistent communication to partners concerning future release schedules; coordinates control

runs to ensure flawless rollouts. Swiftly comprehends the “big picture” and executes the boldest of organizational visions.

Superior communicator easily interacts with executives, regulatory agencies, clients, vendors and staff. Core competencies:

Vendor Management Superb Presentation Skills Leadership skills to manage team

Automation testing Excellent People Skills Cross-Functional Experience

Education

in Computer Science, Florida Atlantic University, Florida, USA.

anagement Certification Training

Skills

GUI Visual Basic 6.0/5.0, Oracle Developer/2000, Crystal Reports

6.0/5.0, Reports 2.5, Graphics 2.5, FrontPage 2000, Visual Interdev 6.0

Languages C, C++, COBOL, HTML, XML, Visual Basic, VBScript, JavaScript,

Java, JCL, AJAX, PHP.

OS Windows XP/2000/98/95/3.1, MS-DOS, UNIX, Exceed (Humming

Bird), Informix, IBM Mainframe, Windows Server 2003 Enterprise, Windows Server 2000, Win CE

6.0.

Databases SQL Server 2005, MS-Access 2000, Oracle 8.0, Informix, VSAM

DB2.

Others Active Server Pages 2.0, Lotus 1-2-3, WinWord, MS-Office (MS-

Word Document, MS-PowerPoint, MS-Excel), Rational Unified Process, UML Models, OOAD,

Command Center Tool, RDBMS, ASP.NET, VB.NET platforms, RFID Languages (PGL, ZPL), Six Sigma

training, VMWARE 6.0 Workstation, VM ESX Server, VM GSX Server, Microsoft Exchange Server.

Testing Skills Microsoft Visual Test 4.0., Mercury Test Director 8.0i, Win

runner 7.0, Load Runner,

J-Unit, Rational Test Studio, Rational Robot, Compuware Test Suite,

Quick Test Pro, HP Quality Center.

Configuration Management Clear Case, DTTS, Exceed, Visual Sourcesafe 6.0, Microsoft Document

Library, CCA (Change Control Access tool), Star Team (Borland tool), Caliber RM (requirements

management), Microsoft Sharepoint portal.

Hardware RS-232 (Serial Connections), DB9, RJ11, Smart 485 Converters,

RFID Readers, RFID Omni wave Antennas, mini Antennas, European Shielded Metal Box Antennas,

Oscilloscopes, TCP/IP Networking, Wireless Technology for RFID Devices and EAS Devices, Handheld

RFID

Work Experience

Ciber, Inc

Client: The Boeing Company

Title: Consultant (Product Test Focal)

Duration: 12/08 – 03/09 Seattle, WA

Project: Airplane Health Management (AHM), Situational Awareness (SA), ELB and other integrated systems.

Product(s): Gold care - Commercial Aviation Services –software

Environment: Java, EJB, Oracle Enterprise 11i, Web sphere, SOAP, XML, XSD, Quality Center (Test Director), QTP,

Clear case, Clear Quest, SharePoint.

Role:

1. Managed component verification and validations for different CAS clusters.

2. Responsible for functionality verification of messaging Queues between 10 different integration clusters.

2

3. Working closely with Program management team on scheduling, budgeting, test procedures and participated in software

requirements review to see which features are feasible for a good product.

4. Working as a Product Test Focal for their different test environments handling the verification and validation for the Integration

Clusters (or components) throughout the SDLC lifecycle.

5. Responsible for writing the Test Plans –P750s (Macroscopic Standards Followed), Test Cases and used Quality center for

automation and defect tracking purposes (CMMI Level 3 standards and lean six sigma followed at Boeing).

Tyco International, Ltd

Duration: 11/04 – 07/08 Boca Raton, FLORIDA

Title: Lead Test Engineer

Product(s): 1. Device Commander System Software that manages RFID Readers health (Radio Frequency Identification)

2. Extended Operating Software that runs on top of the Linux Kernel of the RFID Devices (or Readers)

3. Launch Package – that handles encoding of the RFID EPC Codes on the LABELS

4. Printronix System Software – that handles RFID Printers for encoding the EPC Codes

5. Local Device Manager System Software that manages LDM II hardware devices for EAS (Electronic Article Surveillance)

Engineering Products (like sensors, controllers, people counters, alarm counters etc) developed using WinCE Operating system.

Environment: Windows 2003 Enterprise and Standard Servers, Windows 2000 Server, Windows XP, Win CE 6.0, Solaris Server,

Red Hat Enterprise Linux Server, SUSE Linux Enterprise Server, SQL Server 2000, SQL Server 2005, Star Team (Change Control

Server), Caliber RM, Defect Tracking System, RFID Tools, Zebra Programming Language, Printronix Graphic language (for

RFID Printer Products), Shell Programming, VB.NET programming for Test Scripts, Ethereal (TCP/IP Packets traffic).

H/W: RS-485 remote Connections, RS-232 Serial Connections, RJ11, DB9, Power Packs and other hardware.

Role: Managed the whole team and acted as a single point of contact by leading the testing activities for different test

environments to do the validations on different RFID System Software that validates the Identification of Electronic Product

Codes encoded on RFID TAGS using the wireless RFID Readers(devices) and Antenna hardware set up. Responsible to verify the

Wireless Device Drivers are functioning properly using different Kernel software and the Firmware on top of them on Win CE

Platform.

Managed and was part of the whole team by leading and acting as a point of contact for all different team coordination and also

managed the Windows Administration setup for the Test LAB Configurations and operation purposes by configuring the DNS,

DHCP, FTP, SMTP, NTP Servers and automation Test Tools Server Setup.

• Responsible to work with Vendor relations. Work with Vendors to make sure all Tyco requirements are

implemented according specifications. Worked with Tier 1 RFID vendors, Agile, Impinj etc.,

• Responsible to train and develop world class Software QA team to address entire development team.

• Responsible for ensuring timely, within budget delivery of testing activities across RFID device lab.

Defining and executing QA strategy to all Tyco Electronics RFID applications. Tested and analyzed lots

of data from the backend side using SQL Server 2005 and Oracle by writing queries, transact-sql

procedures, triggers etc.

• Point of contact to interact with development, Product line, sales and distribution channel teams for

all RFID mobile device issues.

• Managed the team to help validate the Win CE product called Local Device Manager that manages 31 different devices

for the Electronic Article Surveillance group and it collects data through the backend server using advanced DB SQL

Server 2005 usage files to store people counts, alarm counts, deactivation counts and detacher counts etc. Retrieved lots

of Reports from the databases. Tested and worked with device drivers for EAS and RFID embedded mobile

communications devices using Win CE Kernels and Linux Kernels by debugging some of the code for memory leak

issues.

• Lead team to develop scripts using Test Partner (Compuware Automation Tool) to test RFID mobile device

data with live information.

• Lead all tasks on educating and researching on the RFID Printronix Products for the group. As part of my duties I was

helping the technical support group for these Printronix Products when the live customers had issues with the PGL and

ZPL languages in programming the RFID LABELS. Live customer support was given for the issues with respective

RFID Front-end GUI software and hardware as needed by assisting the technician explaining the correct procedures to

collect the data.

• Performed several automation tests using VB.NET Scripts and other shell scripts in linux on different RFID

Readers (like Agile 2, Alien, Symbol and Impinj), Antenna’s that can collect lot of different data for

Warehouse storage pallets and item boxes that contain different store related products using different

environments with many platforms using the system software called Launch Package .

• Performed several tests using oscilloscopes inputting different variations and scenarios to verify RFID Reader frequency

measurements. Used lots of XML configuration files for these devices to verify the setup of the devices done

appropriately.

• Responsible to study and research the RFID products to understand the methods of the products within few weeks and

handled all the projects that were assigned.

• Responsible for Creating Test Plans, Test Scripts using Compuware Test Automation Tools (QA Center, Test

Partner, CARS Workbench – used for Project Planning and Risk Estimates).

• Responsible for performing various System and Product Integration Tests and Stress and Performance tests using Load

Runner, Test Partner tools with VB.NET and XML for configuration files for RFID Devices.

• Responsible to perform reporting the Defects that were tracked using Borland Star Team Software.

• Responsible for extensive Regression Testing to deliver quality RFID and EAS products.

• Responsible to play a multi – role in handling 2 to 3 projects at a time.

• Responsible to use Star Team tool for the Change Control process.

• Responsible to implement the automated QA process and the Compuware Test Tool Suite with the group.

• Responsible for customer interaction in trouble shooting RFID printers. (Customers include Wal-Mart. Target, Liz

Claiborne, CASIO etc.)

Mortgage Systems International Sunrise, FLORIDA

Client worked for was ABN AMRO MORTGAGE

Duration: 08/03 – 08/04

Title: Software Test Project Lead

Project(s): Underwriting Work Queues, Universal Memo Pad, CLOSER (Loan Origination System)

Environment: Windows 2003 Std Server, Windows XP, Windows 2000, ASP.NET, VB.NET, XML Parsers, SQL SERVER 7.0,

Microsoft Document Library (SharePoint Portal Server), Test Director 8.0 (Enterprise Version), CCA (Change Control Access)

Tool, Quick Test Pro.

Role:

• Responsible to study and research the CLOSER product to understand the business rules within 4 weeks and handled all

the projects that were assigned.

• Responsible to handle extensive back-end testing using SQL Server 2000 to verify if the data is stored appropriately.

Used lots of Queries, Transact-SQL to verify the front-end software.

• Responsible to Create Test Plans, Test Cases using Test Director 8.0.

• Responsible for System and Integration Testing tasks and did some data testing using XML Parsers.

• Responsible for Defect Tracking and reporting through Test Director 8.0 tool.

• Responsible for performing extensive Regression Tests on the Front-end to deliver quality products.

• Responsible to multi tasking handling 3 projects at a time.

• Responsible to use Microsoft Sharepoint Document Library tool for the change control.

• Lead team to implement and administer the automated QA process using Quick Test Pro and the Test Director tool in the

company along with the team.

JM Family Enterprises Inc., Deerfield Beach, FLORIDA

Duration: 02/01 – 07/03

Title: QA Analyst

Projects: BDG Consumer Website

FWS Online Pricing (Fidelity Warranty Services Online Pricing System)

Streamline Suspense Queue

Janus Release 1

Environment: Windows 2000, Windows NT, BEA Web logic Server 6.1 SP2, Sun JDK 1.3.1_01, Siteminder ASA Agent, EDF

1.3.9, Win Scripting 5.6, IIS 5.0, FWS DB2 Database, MS XML Parser 3.0 SP2, Netegrity Web Agent, Test Director 7.0i,

Winrunner 7.0 IBM Mainframe Programs, Visual Sourcesafe 6.0, MS-Project 2000, Visual Basic, VSAM, DB2, Crossplex (a

4

middle Layer), Test Director 7.0i, Winrunner 7.0,IBM Mainframe Programs, J-Unit, Visual Interdev Tool, Rational Unified

Process, UML and OOAD Design, Business Object Models.

Role:

• Responsible for preparing the Project Plan using MS Project 2000.

• Worked with lots of OOAD Design models and Business Object Models and RUP Process.

• Responsible for writing system test plans and Validation and Error Handling test cases.

• Responsible for System and Integration Testing for Web and Client Server Applications and did compatibility testing for

different browsers like Firefox, IE different versions, Safari, Opera etc.

• Responsible for both black box testing and regression testing.

• Responsible for Defect Tracking and reporting through Test Director 7.0i tool.

• Responsible to communicate with Project Managers, Developers and the Team members to report the Defects.

• Generated automation test scripts using Win Runner.

• Used J-Test to test Java based scripts for unit testing.

• Responsible for writing and generating some automation test Scripts using Winrunner 7.0 tool with Terminal Emulator

add-in for Mainframe scripts.

Motorola Inc.,

Project: Unit Personality Data (UPD) Boynton Beach, FLORIDA

Duration: 03/00 – 01/01

Title: Software Test Engineer

Environment: JSP, HTML, JavaScript, IE5.0, UNIX Shell Programming, Exceed Informix, DTTS, Test Director 6.02, Winrunner

6.02, Chainlink *IS Integrity tool, Clear Case tools.

Role:

• Responsible for attending the formal reviews to Review all the Requirement Documents for all the six packages and also

responsible for reviewing all the Detail Design Documents, ERD Documents, Preliminary Design Documents to give the

comments if any change was required.

• Responsible to Interact and communicate with the UPD development team in Harvard (IL) as well as Boynton Beach to

suggest the changes required in all the documents wherever necessary.

• Responsible to test the two Integrated systems globally one in Harvard, IL and one in Boynton Beach, FL for the

Generation and Rework Packages.

• Responsible to Write the Test Cases, Validation Test cases and Error Handling Test cases

• Clear case tool is used for the version controlling of Test cases and Test documents.

• Responsible to do the System/Integration Testing as well as the Regression Testing.

• Responsible to attend all the formal reviews for the test cases written for the Backend.

• Responsible for the Integration/System Test Execution using UNIX, Informix, and Sequel Queries to check the UPD

driver and also executed the interfaces provided with JSP as front-end using web browser.

• Used PL/SQL and UNIX extensively verify that the updates to the database are made properly.

• Responsible to start and use the active brokers adapters and request processors on the UPD Testing Instance box before

testing.

• Responsible to use the Chainlink *IS Integrity tool which is an internal tool to fail the UPD Code.

• DTTS tool to log the defects, which were found as soon as we find the defects at the time of execution.



Contact this candidate