Post Job Free

Resume

Sign in

Sql Server Management

Location:
Fort Lauderdale, FL
Posted:
June 22, 2013

Contact this candidate

Resume:

Sara

aby7ja@r.postjobfree.com Mobile: ***-***-

****

SUMMARY

Over 7 years of experience Quality Assurance with diverse roles in the field of Software testing,

Analysis and SDLC.

Excellent project management, written and interpersonal skills.

Worked with multiple projects, phased deliverables risk analysis, project planning,

requirements gathering and Manual as well as Automated testing of software on various

platforms.

Has good experience in writing complex/detailed test plans, release management, QA analysis

on all test documentation and improve test documentation process

Hands on experience on GUI, Functional, Regression and Load testing both Web and

client/server applications which were developed in Java, .NET, ASP, HTML, XML

Experienced in understanding Requirements, Test Scenarios and detailed Test Cases for

positive, negative & boundary testing

Experienced in Functional, Smoke, End to End, Compatibility, Load/Stress, Usability Testing

with Manual and some knowledge about Automated Testing tools.

Experienced in performing User Acceptance Testing (UAT) and keeping testing logs & cycles to

add to Software Testing Artifacts

Proficient in System Testing, Regression Testing process of a given software application for

different software releases, builds and patches

Excellent written and verbal communication skills to work with team members and clients in the

form of formal training, mentoring, and presentations.

Strong team player with the ability to work collaboratively with others, fast learner and flexible,

and able to adapt to new areas and technologies

Expertise in querying and testing RDBMS such as SQL Server using T-SQL for data integrity.

TECHNICAL SKILLS:

Operating Systems: Windows 95/98/NT/2000, MacOS,UNIX

Programming Languages: Java, C, C++, .Net, VBScript

Testing & Defect Tracking Tool: HP Quality Center, HP Quick Test Professional (QTP)

TFS

Web Technologies: HTML, JavaScript, Asp, Asp.Net, JSP, XML, CSS

Network Protocol & Database: TCP/IP, HTTP, FTP, Oracle, SQL, MS SQL Server

Microsoft Tools: MS Office, Word, Excel and PowerPoint, MS Visio

Browsers: IE 7/8/9, Google Chrome

PROFESSIONAL EXPERIENCE/PROJECTS

MethodOne, PA Mar’10–

till date.

QA Engineer

MethodOne is a Methadone clinic management software designed for end to end paperless system.

MethodOne is a fully integrated clinical and financial management system. It has various modules

like Admin, Front desk, Nurse, Doctor Etc.

Responsibilities

Analyzed business requirements, functional specification, and the required documents for

testing.

Performed Manual Testing of web-based and client-server enterprise applications

Involved in all Functional and technical discussions with the Users, Project Management,

Developers, Architects and Test Teams

Responsible for developing test scripts and cross checking with Business Requirements

Testing the other applications integration with the application

Created and executed test cases based on business testing requirements and test plans

Primarily responsible for Functional Test, System, Regression, Integration and User

Acceptance testing.

Created test scenarios and executed them in order to test a product from a user perspective.

Extensively worked on SQL Server scripts for backend testing

Analyzed the data mapping and developed test scenarios to verify the data migration from

different sources.

Create Test scenarios for claim selection, Generate claims and data validations

Worked on backend testing and has very good knowledge of writing SQL Queries to verify the

data.

Documented all test results, identifying and summarizing discrepancies.

Generated weekly Status Reports to the team manager.

Environment: Asp.Net, VB.Net, SQL Server 2008

Comcast, PA Jan’09-Feb’10

QA Analyst

This system will facilitate business users to create new Orders and manage the Orders for various Line of

Business’s like MetroE, ERate and CellBackhaul. This system has workflow capabilities to manage

the process between various cross functional domains (Engineering, Provisioning, and Project

Management).

Responsibilities:

Extensively worked on Commercial Order Management System.

Analyzed the Business and Test Requirements and developed a detail Test Strategy

Identified critical application areas and prioritized the Components and Test Cases.

Developed Test Matrix and Test Cases.

Executed the test cases and communicated the test results, defects, fixes and solutions with

development team.

Writing and executing Test cases for Functional testing, Integration testing, System testing and

UAT testing

Developed and Executed the SQL queries for the data validation of Reports.

Performed System Testing.

Reviewed issues, risks, status and gaps with team and consolidated them for reporting purposes.

Involved in scheduling and executing test sets, collecting test result, and analyzing the data using

Quality Center.

Reported defects using Quality center tool.

Coordinated testing process with QA Team, Development Team and Management.

Reviewed issues, risks, status and gaps with team and consolidated them for reporting to

management.

Documented existing and new proposed Functional changes in all releases

Environment: Asp.Net, C#.Net, SQL Server 2008

FedEx, PA Feb’08 -

Nov’08

QA Analyst

This system will facilitate business users to generate various kinds of reports like delivery status, package

tracking etc. With this tool users can generate various kinds of reports such as Daily, Weekly, Monthly

and yearly reports.

Responsibilities:

Analyzed the Functional and Business requirements, attended Change Request meetings to

document changes and implemented procedures to test changes.

Extensively worked on Testing Requirements and developed a detail Test Strategy to test the

application functionality.

Identified critical application areas and prioritized the Components and Test Cases.

Developed Test Scenarios, Test Cases.

Executed the test cases and communicated the test results, defects, fixes and solutions with

development team.

Developed and Executed the SQL queries for the data validation of Actuate Reports .

Documented existing and new proposed Functional changes in all releases.

Performed Regression Testing, Integration Testing, Functional and System Testing.

Maintained the Test scripts for new updates, releases and fixes.

Reviewed issues, risks, status and gaps with team and consolidated them for reporting to

management.

Coordinated testing process and procedures with Development Team and Management.

Environment: Java, Crystal reports, Sql Server.

Quadrant, HYD, India Jan’07-Dec’07

QA Analyst

Call Center Indicator: When a CSR receives a Screen Pop (Initial Contact Screen) they must

determine if the caller is in the correct Call Center for service.

Purge IC records: Old Initial Contact records will be automatically purged when the Status=”New”

and if the created date is greater than 30 days from current date

Archived SR’s: The user will view the last 6 months of Service Requests in the default Service

Request applets. In order to view any SR older than 6 months, the user will select a hyperlink to view

those older SRs

Responsibilities:

Analyzed the Business requirements and the site specifications

Interacted with the development team to understand the process flow, architecture and the

application's functionality

Developed detailed Testing Strategy for the entire application and developed Test Plans, Test

Scenarios, Test cases for Regression, Integration, System Testing.

Involved in the Manual/Automated Testing.

Maintained the Test scripts for new updates, releases and fixes.

Developed Test plan, with the Objectives of the testing.

Enhancements for Siebel Call Center:

Call Center Indicator: When a CSR receives a Screen Pop (Initial Contact Screen) they must

determine if the caller is in the correct Call Center for service.

Identifying the critical Scenarios for functional Testing

Setting up the Environment and executing a Base line test

Designing a Workload and distribution ratio of users for each Scenario

Monitored the server logs of web, application and database servers while executing the tests

Environment: Java, J2EE, HTML, Java Script, Oracle 8i, Window2000.

Apollo Hospitals, HYD, India

Aug’ 06 – Jan’07

QA Tester

HMS (Hospital Management System) is developed for Apollo Hospitals, India. This project simulates

a Hospital Management Information System. The Project's Primary task consists of automation of the

admission and discharge process of patients. Online information of general activities like Enquiries,

Appointments, charges and billing is readily available to administrative authorities.

Responsibilities:

Analyzed the business requirements and identified testing methodologies to group tests as

Functional Analysis, Boundary Value Testing, Exception Handling and Error Guessing.

Involved in writing the test plans, test cases and involved in the process of analyzing the expected

and actual results.

Gathering the Test Input data. Test Input data includes Pre-condition, Test Input, and Test Result

data.

Experience with writing and executing positive and negative test cases and executing them.

Execution of generated Test Cases and editing the test cases.

Performed UAT (User Acceptance Testing) and Regression Testing. Generate test records.

Modify scripts to do regression testing.

Validate the billing process and data updates to legacy application data repositories and the ETL

processes.

Verify the data cleaning process and interfaces to DW and legacy application databases.

Performed manual testing on Security Features that consisted of Super Users, Internal and

External Users.

Participated in Walk through and Defect report meetings periodically.

Actively involved in coordinating with development team in bug reporting and bug tracking.

Involved in various meetings and discussed Enhancement and Modification Request issues.

Used SQL statements and UNIX shell scripts to extract data from the tables to validate test results.

Environment: Informatica PowerCenter, C/C++, SQL Server, T-SQL.



Contact this candidate