Post Job Free
Sign in

Manager Sql Server

Location:
Valley Stream, NY, 11580
Posted:
October 27, 2010

Contact this candidate

Resume:

Javed Chowdry (Jay)

Cell: 646-***-****

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

OBJECTIVE:

Over seven years of experience in design, development and implementation of

software test requirements, test strategies, test procedures, testing

needs, test plans, and test cases for various projects utilizing GUI tools

and UNIX . Also documented web based client/server environment methodology

for successful QA Testing, planning, implementation, and management. Have

strong knowledge about manual testing as well as automated testing. Well-

organized, articulate, and motivated person along with excellent

communication skills. Excellent follow through and troubleshooting skills.

Results oriented, with ability to work in a dynamic fast-paced environment.

Abstract:

. In depth knowledge in Software Development Life Cycle (SDLC).

. Extensive knowledge of performing Business and Requirements Analysis,

JAD (Joint Application Development), RUP (Rational Unified Process)

methodology, Business Process Modeling.

. Comprehensive knowledge of business analysis, modeling, designing and

implementing Internet based business systems in Financial and Telecom

sectors.

. Creation of Use Cases, expertise in Rational Rose, Visio, UML, MS

Access.

. Conducting feasibility analysis and Risk Assessment for all the

projects undertaken.

. Business modeling, software prototyping and wire frame generation.

. Substantial experience in writing and executing Test Cases and Test

Scripts, mentoring customer's staff, working with overall team to meet

project goals.

. Experience in RDBMS like Oracle, MS Access, and SQL Server.

. Knowledge in Mercury Interactive QuickTest Pro, LoadRunner,

TestDirector, WinRunner, Rational Requisite Pro, ClearCase,

ClearQuest, Test Manager, Robot. IBM File Net

. Knowledge in C/C++, Visual Basic, Java, SHELL scripting, PERL

scripting, VB scripting, TSL scripting, VUGen scripting, developing

web pages using HTML, DHTML, PHP, MYSQL, JavaScript, PL/SQL and

Weblogic

. Proficient at creating integration solutions in a multi-platform,

multi-operating system environment.

. Excellent technical communication, documentation, interpersonal and

reporting skills.

. Ability to work independently and in a team environment, with a

minimum amount of supervision.

. Handle to effectively manage multiple assignments simultaneously.

TECHNICAL SKILLS:

Systems Windows 9X/NT/2000/XP, Sun Solaris, AIX, HP-UX.

WebLogic, WebSphere, Oracle, Mac OS X

Testing Tools Quick Test Pro, WinRunner, LoadRunner, and Test

Director/Quality Central, Rational Team Test Suite,

Etest Suite, Astra Fast Track, Clear Quest, and PVCS

Tracker. Mashups by Serena

Web Design Flash5, Fireworks, Dreamwaver4, html and CSS

Languages Visual Basic, VB Script, TSL, C++, CGI Scripts, HTML,

Java, Java Scripts, SQL, XML.

MS Office, Track for Windows, MS Source Safe, PVCS, SQL

Explorer, WS_FTP Pro, IE 6.0, Netscape 6.2, Java Web

Start, Q-Basic, Assembly Language, C++, JAVA, MySQL

Database MS-Access, Oracle, and Sybase

Microsoft Office (Word, Excel, Visio and Power Point)

and SQL server 2000.Toad

Networking Issues Network Topology, Transmission Media, MAC Protocol,

LAN, MAN, WAN, Ethernet, ATM, Fast Ethernet, Gigabit

Ethernet, Fiber Channel, FDDI, ISDN, B-ISDN, Protocol

architecture, TCP/IP, OSI, SNA, Intranet, Client-Server

Architecture, Lotus Notes

EXPERIENCE:

KPMG, Montvale, NJ

07/2010 to Present

QA Tester

KPMG is a global network of professional firms providing Audit, Tax and

Advisory services. KPMG operates as an international network of member

firms offering audit, tax and advisory services. KPMG work closely with

clients, helping them to mitigate risks and grasp opportunities. Audit is

an independent service that enhances the reliability of information used by

investors and other stakeholders. Attitudes to tax are changing.

Organizations of all sizes are ever more exposed to new trends in tax

regulation, not just locally but globally. Advisory works with clients to

tackle challenges in transactions and restructuring, performance and

technology and risk and compliance.

Responsibilities:

. Responsible of creating QA Compline Cheaklist, Track Plan, Test

Plan, Test Cases, Test Scenarios, Test Matrix, Pre-condition data,

Status Report for multiple projects such as DRMS, CLEAS, Adobe

Connector, E-Audit, FileSite. Involved with the Business and

Technology teams to help define the requirements for new projects and

verify that the testing process and mythology meet the functional

requirements. Work with Product team, technical writers, developers

and scriptures to define new projects to extend and enhance company's

proprietary applications.

. Analyze, tests, and certifies application-specific software and

performs ambiguity reviews of business requirements and functional

specification documents. Provide assistance in identifying,

evaluating, and resolving complex test problems.

. Generated, executed, and enhanced the test scripts with QTP. Performed

and executed the GUI part of the application with QTP and tested the

functionality of the Application with multiple Data (positive as well

as Negative), multiple times using Data Driver Wizard. Inserting

checkpoints. Execute the test cases and test procedure against the

business requirements. Test different Modules and their functionality.

Performing black box testing Business Functionality, Build

verification test, Integration test.

. Work closely with developers to ensure that test cases and test

scenarios are covered all necessary steps of testing. Perform various

types of tests along with the regression test to identify any issue,

bug or gaps. Attend business meeting with the developers to discuss

relevant to any issues/bugs. Attend weekly QA meetings to discuss test

progress and issues.

. Created SQL queries (MS SQL Server) for use in manipulating and

verifying test data and Input data in the database is correct.

Responsible for submission of defects, tracking of defects and

subsequent bug fix testing and modification requests through Quality

Center

. Responsible of leading five QA testers for DRMS project. Set up

peer review, Weekely status meeting, meeting with the client, setup

a phone sccrening every morning to review with the technical

writers, testers, managers and off shore team to see how many bugs we

found the previous day and which bugs get more priority so

application can be released with no major defects.

Environment: Windows 2000, Windows Vista, MS Sql Server, ASP.Net, MS

Visio, Quality Center, and QTP (Quick Test Professional)

Cablevision

Bethpage, New York 11/2008 -

06/2010

Cablevision System is a leading telecommunications, media and

Entertainment Company. This world-class system connects residential and

business customers in the country's top market to Cablevision's Optimum

branded communications services: iO Interactive Optimum digital television,

Optimum Online high-speed Internet and Optimum Voice digital voice. In

addition, Cablevision's Optimum Light path meets the communications needs

of larger companies as a leading provider of integrated business

communications solutions. The company's telecommunications system also

delivers the award-winning News 12 Networks a local-news leader and iO

exclusive.

Responsible:

. Reviewed Business requirement documents and the Technical

Specification. Analyze the system specifications to design the Test

plan and developing Test cases extensively based on the business

requirements using Quality center.

. Review and analyze the Functional requirement documents for scripts

and find the best methodology for automation scripting. Write high-

level workflow test case and run the workflow test cases manually

before it goes for automation scripting. Performed integration,

system testing manually and regression testing using QTP.

. Create detailed test scenarios and implement them to serve as

acceptance test criteria for new functionality. Update the testing

progress status an every hour in real time using the application

called Mashups (by Serena) to track the testing progress as well as

how many issues or defect were found and submitted. Co-ordinate with

the team lead to make sure that testing in progress and none of the

projects are haulted.

. Working in different projects as needed to deliver the projects on

time. Such as IDA, Oracle 10G upgrade, Session Intiation Protocol

(SIP), ELT, Cable Data. Prepare pre-conditioned data for testing the

application. Responsible for status reports of the team and

participate in business meetings. Report to QA Manager in daily basis

to insure him that that all the testing process and procedure are on

the right track.

. Provisioned the account for user with different available programs

cablevision offer to their residential customers as well as business

customers. After creating the account, verify the backend database and

Trio application to make sure that account is created with the given

programs user requests and update the information for technician to

install the order.

. Upon Completion orders verify that optimum voice user has dial tone,

Optimum Online users are able to go online and IO users are able to

access the TV. Also modify, update or delete the order to see the

application is working and performing according to the account setup.

. Verify that ported in or ported out telephone numbers feature working

according the functional requirements. Used SQL queries to perform the

Back-end testing to verify the data input in the database is correct

and processed to the appropriate table.

Environment: Linux, Windows 2000, Oracle 10G, Oracle 9I, Weblogic, Java,

C++, VB scripting, MS Visio, MashUps, Quality Center, and QTP (Quick Test

Professional)

DDS, New York, NY

07/2008-11/2008

Requirements Analyst/Tester

Donovan Data Systems is the leading systems and software provider to the

advertising industry. DDS application offers an exceptional range of

business solutions that brings operating efficiencies to clients working in

media agencies and marketing services companies. Each day DDS process

millions of transactions, supporting advertising agencies, media

specialists, broadcasting sales companies, advertisers, PR firms and

recruitment and direct response agencies around the world. DDS has remained

at the forefront of the advertising industry for its unequalled service and

support, innovative technology and long-term commitment to eBusiness.

Responsible:

. Involved with the Business and Technology teams to help define the

requirements for new projects and verify that the testing process and

mythology meet the functional requirements. Work with Product team,

technical writers, developers and scriptures to define new projects to

extend and enhance company's proprietary applications.

. Responsible for analyzing functional requirements and approve the

functional requirements before start to write One-Liners (Test case

Header). Arrange One-Liners approval meeting with product manager,

Programming Manager, QA scriptures, and Technical writers. Once One-

Liners are approved then write the detailed scenarios and execute them

manually before detailed scenarios goes for automation testing

. Developing detailed system test scenarios, including test procedures,

test data after One-Liners are approved by development, Product team

and technical writers. Performed black box, integration, system

testing as well as regression testing manually according to the test

plan as well as performed regrssion testing using Rational Robot as

automation testing tool

. Attend joint application development meeting/sessions (JAD) to address

features which will be includes in the future release and see how

those new features will fit into the application and find the best way

to implement them for future releases. Features added or enhanced are

discussed in depth on the JAD session to figure out the best possible

way to implement the features in the application. Any issues or

suggestions come from clients/users are discussed in the JAD session

to see if those input from users can be implemented into the

application, if so what are the criteria and obstacles are also

discussed in the JAD session

Environment: IBM Mainframe, Windows 2000, MS SQL Server, C++, Java, HTML

and XML, UML, Rational Team Test, Rational Functional tester, and Rational

Clear Quest

Eventra, Milford, CT

03/2006- 07/2008

QA Test Analyst/Specialist

VendorSite is Internet Based Supplier Relationship Management System that

is designed to link manufacturer who have complex product scheduling

requirements with their suppliers. VendorSite also brings together 100% of

manufacturer's supplier community by offering powerful benefits for those

who use the system. Web based Supply Chain Management application

(VendorSite) Review product specs and applies testing methodology ensuring

that performance meets business requirements. Working along with the Team

Manager to prepare test plan, testing strategy, test matrixes, test

scenarios and test cases.

Responsible:

. Extensively performed Regression Testing using QTP. Involved in stress

testing, which requires thorough understanding of the functionality of

the application. Modify and update the scripts according to the

testing needs. Establishing direction and coordinating the daily

efforts of the QA process.

. Analyze, tests, and certifies application-specific software and

performs ambiguity reviews of business requirements and functional

specification documents. Provide assistance in identifying,

evaluating, and resolving complex test problems.

. Created SQL queries (Oracle) for use in manipulating and verifying

test data. Input in the database is correct. Responsible for

submission of defects, tracking of defects and subsequent bug fix

testing and modification requests through Quality Center

. Create "Release Note" of every release (All the known issues are

clearly mentioned in this note, if any). Inform and communicate with

the QA Manager in daily basis to insure him that that all the testing

process and procedure are on the right track.

Environment: UNIX, Windows 98/2000, Oracle, Weblogic, Java, HTML, XML, VB

scripting, QTP (Quick Test Professional) and Quality Center

Keane INC. Danbury, CT

10/2004-02/2006

QA Analyst/Tester

The Project web application called Tank Leasing System (TLS). The main

objectives of this project are related to the operational needs of the

business. Concurrent with the deliver of this new tank leasing system, the

company is implementing a new network infrastructure to replace the current

TAL (Trans America leasing) network. The Technical architecture is 3-tiered

-Windows 2000. J2EE and Microsoft SQL Server database. Windows 95 running

IE 5.5 for external trading partner (Customer, Depot) access the M&R

protocol module, the TLS system will be on windows 2000 running on IE 5.0 &

5.5, and Netscape 6.2

Responsible:

. Established the QA process according to SDLC and setting the QA

environment according to Business Requirement. Utilized test

automation tools (E-Tester) and Responsible for setting up QA

environment, establishing direction and coordinating the daily efforts

and report to QA manger

. Performed Build verification test to make sure all change requests

(Modification Requests) and update/enhanced functionalities are

implemented into the application and performed regression test to see

the application is working accordingly.

. Developed and maintained the Test plan and Test Cases according to

business requirements document (BRD). Execute the test cases and test

procedure against the business requirements. Test different Modules

and their functionality. Performed Business functionality, black box

test, Integration test, System test, Positive / Negative test and

Regression Test.

. Used SQL queries to perform the Back-end testing to verify the data

input in the database is correct. Keep record of all the Bugs / issues

(Defect Management) using the bug tracking tool (Fast Track) and Logs,

tracks, and verifies resolution of software and specification

defects. Submit the status the report to QA Manger.

. Documents all phases of QA process to insure the quality. Researches

new products and industry methodologies and provide inputs in the

development of new concepts, techniques, and standards.

Environment: Windows 2000/95/98. J2EE, Microsoft SQL Server, Java, E-Test

and Astra fast track

Applied Information Sciences, Greenbelt, MD

03/2003-09/2004

QA Analyst /Tester

This was a Web application (UniAccessAuto) designed in Microsoft

Distributed Network Architecture (DNA). The project forecasts the European

Automotive Sales, Client and Inventory Maintenance. The GUI loads at

runtime based on the client regional setting to determine how the

application will present to its international users. Visual Basic 6

scripting was used to develop the application for the MTS objects and

ASP.net for the presentation layer.

Responsible:

. Set up the Test Environment according to Business Requirements.

Analyzed functional specifications and developing detailed system test

plans according to the functional requirement specifications. Created

and modified test plans, test procedures, test cases and executed test

plans, test procedures, test cases according to the business

requirements.

. Performed Functional Test, System Test, Integration Test, and User

Acceptance Test (UAT). Run the manual test cases as well as performed

Regression Test using automated testing Rational Robot (Rational Team

Test 7.1) to determine the quality of the application. Used SQL

queries to perform the Back-end testing to verify the data input in

the database is correct.

. Performed QA functional/ GUI Test during testing stages and

coordinating with Development team. Reporting and documenting the bug

using through Team track. Execution of User Interface testing to

validate so that the navigation of the application properly reflects

business functions and requirements.

. Review the test results and report day to day tasks to Manager. Report

Defects on a timely basis; perform troubleshooting and ensure defects

are fixed and tested within the test timeline and report the risks to

management. Estimate the different Test Phases.

. Prepare pre-conditioned data for testing the application. Responsible

for status reports of the team and participate in business meetings.

Report to QA Manager in daily basis to insure him that that all the

testing process and procedure are on the right track.

Environment: Unix, Windows 2000, MS SQL Server, ASP .NET, HTML and XML, MS

Visio, Rational Team Test and PVCS

NEBF, Rockville, MD

02/2002- 02/2003

QA Tester

The National Electrical Benefit Fund (NEBF) was established as a result of

an agreement between the international Brotherhood of Electrical Workers

(IBEW) and the National Electrical Contractors Association (NECA) in 1946

to provide workers in the electrical construction industry with a

retirement plan. The National Electrical Benefit Fund (NEBF) is a multi-

employer, defined benefit pension plan that provides retirement benefits

and related benefits to employees in the electrical industry. Participants

accumulate credit in NEBF based upon their years of Covered Employment.

Qualifications for benefits and the amount of those benefits are based upon

a Participant's years of service with Covered Employers, age at retirement,

type of benefit selected and the pension rate at time of retirement.

Responsible:

. Analyzing System specifications and developing detailed system test

plans, including test procedures and test cases

. Performed QA functional/ GUI Test during testing stages and

coordinating with Development team.

. Performed build verification, system, functionality, regression and

integration test

. Reporting and documenting the bug using through PVCS Tracker

. Performed the Regression test when new build is available

. Reports all the activities are performed during the week to the Team

Lead.

. Written test cases and performed Testing like Positive Testing and

Negative Testing and Regression Testing.

Environment: Windows 2000, MS SQL Server, VB Scripting, ASP .NET, HTML and

XML, Rational Team Test and PVCS Tracker

EDUCATION:

. B.S. from University of Chittagong, 1994

. Productivity Management training,Keane Inc, June 2002

. TeamTest Training, Real Time Technology Solutions,02/25/2000

. Delegation & Time Management Training, Keane Inc, June 2002

. Management and Effective Communication workshop, Lasco Group, 2000

. QTP Training by Lasco Group, NY, 2002

[pic]



Contact this candidate