Post Job Free

Resume

Sign in

Manager Sql Server

Location:
Columbus, OH, 43085
Posted:
February 09, 2011

Contact this candidate

Resume:

Barkha M.

Dallas TX

860-***-****

abhu5g@r.postjobfree.com

Professional Summary:

Primary Skills: VSTS 2008, TFS 2008/2010, QTP 9.5/10.0, Quality Center

9.5/10.0, SQL 2005/2008, C#, HTML, VBScript, JavaScript

* More than 6+ years of IT Experience specializing in Web Technologies

and Software Quality Assurance.

* Proficient with testing tools such as Visual Studio Team System, HP

Quality Center, Team Foundation Server 2008, Quick Test Pro, Win Runner,

testing client/server and web based applications.

* Extensive experience in Software Development Life Cycle (SDLC) using

Waterfall Model, RUP (Rational Unified Processing), Agile(Scrum) and

CMM methodologies.

* Good Knowledge of UML, Object Oriented Programming (OOP) concepts.

* Extensive experience testing Web-based applications developed in

J2EE (Java) & .NET framework.

* Experience in developing High level Test Strategy and Test plan documents

ensuring that the product is meeting the Business requirements

* Experience in Planning & Conducting Functional, Database, GUI, Sanity,

System, Integration, Regression testing, and User Acceptance Testing.

* Extensive experience in developing, implementing and validating Test

Plans and Test Scenarios for Client-Server and Web-Applications.

* Strong Knowledge of Web Services and SOA(Service Oriented Architecture).

* Good Knowledge of testing web services with SOAPUI tool.

* Good working Knowledge of HL7 (Health level Seven) & NON HL7

transactions.

* Strong Experience with MS SQL Server, Oracle, MS Access database.

* Experience Working with UNIX OS, Commands and Shell Scripting.

* Extensively worked on technologies like C#, VBScript, HTML, CSS, XML

languages.

* Solid Experience in creating database T-SQL scripts, stored procedures,

triggers, views, tables, and constraints using SQL SERVER 2000/2005/2008.

* Experience with defect tracking and analysis using different defect

tracking tools such as TFS (Team Foundation Server), Quality Center.

* Participated in design reviews with the development and Business Analysis

team and the SME(Subject Matter Experts).

* Excellent Communication and Documentation Skills.

Technical Skills:

Operating System: Windows 2003 Server, Windows XP/2000/NT/98, Unix,

MAC

Testing Tools: QTP 9.5/10.0, Visual Studio Team System 2005/2008,

TFS 2008/2010, Load

Runner, Quality Center 9.5/10.0, SOAP UI

Programming Language: C#, VB.Net, ASP.Net, Visual Basic 6.0, Java

Reporting Tools: Ms-Access Reports, SSRS, Crystal Reports, Data Reports

Scripting : JavaScript, VBScript

Markup Languages: HTML, DHTML, XML, CSS.

Database: MS SQL Server 2008, Oracle, MS Access

Tools: Word, Excel, PowerPoint, Access, MS FrontPage,

SharePoint Designer 2007,Ms Project, MS Visio

Protocols: TCP/IP, HTTP, HTTPS, SOAP, FTP

Web/Applications: MS Internet Information Server

Work Experience:

IMPACT SIIS (Statewide Immunization Information System)( Feb 2010- Till

Date)

Ohio Department of Health (ODH) Columbus Ohio,

Role: QA Engineer

Project Description: IMPACT SIIS is a centralized data repository used to

collect and maintain Immunization records. A web-based application

developed using classic ASP, HTML, JavaScript, using Interfaceware's

Chameleon HL7 parsing engine, for batch HL7 and dynamic HL7 file

processing, and data loading & uses a .NET application for non-HL7 batch

file processing and data loading. IMPACT provides a repository for storing

the Patients data and maintain Provider's Vaccine Inventory data, create

Vaccine/Immunization forecasting for individuals, also helps in creating

Practices, Clinics and Providers for each Practice, and generating

Reminder/Recall notices for upcoming Immunizations. IMPACT also provides a

web interface for uploading the Batch Data from Practices, Manage Care

Organizations in form of HL7 (Health Level 7) & Non-HL7 files.

Responsibilities:

* Quality Engineer responsible to Coordinate and perform functional,

data-related and System testing of IMPACT SIIS Application.

* Responsible for writing High level Test Scenarios, Test Plan and Test

Cases based on the Functional and Technical Specifications.

* Performed GUI, Functional, Regression Testing, System Testing, and

User Acceptance Testing.

* Created and maintained Test Scripts and Test Cases based on High Level

Functional Requirements Document (FRD) utilizing Visual Studio Team

System (VSTS) 2008, Team Foundation Server (TFS), for manual,

automated(Functional & Regression), and performance/stress testing.

* Used the Data bounding feature to bind the dataset to test different

scenarios based on different inputs.

* Prepared Test Plans for Administration, Patient & Contact, Vaccine

Management, Single Sign ON Modules by referring the Business

Requirement Documents.

* Prepared Test Plans for HL7 & NON HL7 File formats(Lead File,

Cleveland File, Medicaid File).

* Tested the HL7 File formats received from different Vendors &

validated the parsing and Data Loader( BizTalk, SSIS Process)

functioning using SQL Statements in the backend.

* Verified the data on the HL7 file & NON HL7 Files to match with the

XML schema.

* Performed data validation of Non HL7 Files processed by SSIS Packages.

* Performed Data Migration Testing from Oracle DB to the SQL 2008, by

writing SQL Queries in the backend and comparing the Records

* Created Complex SQL Queries to Pull out Claims data from database

using SQL server 2005 Studio.

* Performed Backend testing of Reports generated using SSRS, and

performed Fields & data validation by comparing Onscreen reports with

the Background Reports.

* Performed Cross browser testing to ensure compatibility of the

application on IE (7.0,8.0), Firebox(3.5) and Google Chrome.

* Used TFS 2010(Team Foundation Server) for bug tracking, Work Item

Tracking and published test results in TFS to share with the team

members.

* Used SOAPUI for testing Loader Web services.

* Used Windows SharePoint services for maintaining and uploading the

Project Documentation(Requirements, Test Plan, Test Cases etc) and

reporting the Weekly status report to the SharePoint Portal.

* Extensively used Microsoft Office Suite of products for documentation

and data interpretation .

* Involved in meetings with the SME (Subject Matter Experts), Technical

Lead, Project Managers and presented the test findings to upper level

management.

* Interpreted different performance counters, participated in analysis

of load test results and mentor others in troubleshooting issues with

Visual Studio Team Test.

Environment: Visual Studio Team System 2008(VSTS), Team Foundation Server

2010(TFS), BizTalk Server 2006, SharePoint 2007,SOAPUI, WSDL, SSIS, SSRS,

C#, ASP. Net, XML, SQL Server 2008, Oracle, Windows XP/Vista/Win 7,Mac,

Agile(Scrum), Internet Explorer 8/7, Firebox, Google Chrome, MS VISIO,

Outlook,MS office, 7Edit, Notepad ++, Text Pad.

Integrated Talent Management System (ITMS) (Dec 2008 - Nov 2009)

Wayne County Airport Authority (Detroit, MI)

Role: Software Test Engineer

Project Description:

The ITMS is a Intranet Web based Recruitment and HR software used by

recruiter, hiring manager, on boarding coordinator, and employee relations

manager. It helps to reduce Cost-per-Hire, Time-to fill through automation,

used for resource mapping & keep track of needs, requests, and other

information related to the candidates. It helps in Job management,

Candidate Management, User Access, On-Boarding, Self Service Portal,

Reporting, and Talent Platform streamlining and manages the entire talent

lifecycle in one easy-to-use recruitment and HR software application

framework.

Responsibilities:

* Involved in preparation of Test Plan, Test Cases, Test Scripts, and

Test Scenarios

* Involved in the review of requirements with functional manager and

technical specialists

* Performed Functional, User Interface, GUI and Database testing of the

application.

* Experience in Test First Development and Agile software development

methodology.

* Performed Web Test and Load Test using VSTS and used QTP 10.0 for

testing other Apps.

* Developed SQL Query script to test Stored Procedures, Triggers, and

Functions.

* Worked during the full phase of SIT, E2E and UAT efforts

* Defect Detection, Reporting and Tracking using TFS & Participated in

Bug-Review meetings and also used Quality Center 10.0 for other Apps.

* Involved in the internal meetings of the QA team and reviewing the

ongoing testing process and updating the team with current status of

testing.

Environment: Windows 2003/XP/2000, .NET, C#, Quality Center 10.0, QTP 10.0, VSTS 2008, TFS, SQL Server 2008, TCP/IP, HTTP, Microsoft Office, MS

Project, MS Visio, Agile Methodology, IE, Firefox, Netscape, Outlook, MS

Visio

File Transformation Delivery System(Oct 2007- Nov 2008)

Hartford Insurance(Connecticut)

Role: QA Analyst

Project Description:

This is the generic application used for delivery mechanism for lot of

application, which is used to send their data in the customized format to

Credit unions by E-Mail, SFTS (secured File Transfer Service), FTP, SFTU

(secured File Transfer Unit) and send the Automated Email Notification to

the client through BizTalk Process and maintain the delivery status and

Updated Process Status and updated into database. FTD Includes Four

Processes: Process Controller, Transformation Process, Construct Delivery

Conductor, and Delivery Conductor .All the above four processes used

correlations set to maintain status of the each process and Delivery status

of the data to the client in the customized format

Responsibilities:

* Responsible for writing the Test Plans, Test Cases and Test Scenarios

based on the Functional Specification and technical Specification and

documented in Test Manager.

* Developed test cases and scripts for Functionality, Security and GUI

Testing.

* Database integrity testing by executing SQL statements.

* Involved in the review of requirements with functional manager and

technical specialists

* Generated Test Scripts in Quick Test Professional(QTP) for Functional

and Regression testing for automation of multiple modules in the

environment.

* Used checkpoints, applied the concepts of regular expressions,

parameterization using VB Scripting changes in QTP.

* Performed GUI and Functionality testing, using Quick Test Pro to ensure

conformance to requirements.

* Performed Data Driven, Keyword Driven testing to test application with

unique test data.

* Recorded and enhanced scripts with different Checkpoints.

* Used HP Quality Center for writing Test plans and Test Cases

* Created and Tracked Defects in HP Quality Center following the CMM

standards

* Participated in weekly IRB (Internal Review Board) meetings to prioritize

the defects logged to developers and to resolve the issues

* Extensively used Microsoft Office Suite of products for documentation and

data interpretation

Environment: Windows Vista, Unix, HP Quality Center 9.5, Quick Test

Professional(QTP) 9.5, Load Runner, IIS 6.0, .NET Framework 2.0,BizTalk

2006/2004, XML, SQL Server 2005, VBScript, JAVA, HTML, SSRS, MS Project,

Visio, TCP/IP protocols.

West2India(Aug 2006- July 2007)

Absolute Software Solutions, Mumbai

Role: Test Engineer

Project Description: This is an e-Commerce website used to sell Indian

religious items in Majorly in USA, it consists of a persistent database

driven shopping cart, category management, user management, multiple

Payment Gateway selection options, and Order & Invoice generation.

Responsibilities:

* Participated in Requirement Analysis.

* Involved in preparation of Test Plan, Test Cases, Test Scripts, and

Test Scenarios.

* Performing Functional, Integration, System, Regression and User

Acceptance Testing (UAT).

* Conducted BAT (Build Acceptance Testing) after each Build is deployed

in QA.

* Developed and executed SQL Queries to perform backend database

testing.

* Carry out day-to-day tasks of Software Development Life cycle.

* Made use of Quality Center to log Defects.

* Participated in Defect Review Meeting with Project Team after each

Test Cycle to discuss the issues, based on the Severity.

Environment: Windows 2003/XP, ASP. Net,JavaScript, SQL Server 2005, HP

Quality Center, Microsoft Office, Outlook, MS Visio

Human Resource Management System (Aug 2005-June 2006)

Gharda Chemicals Ltd.

Role: VB Developer

Project Description: The Human Resource Management System handles all Human

resource and Payroll Maintenance system for Gharda Chemicals Ltd. Can

handle data from Attendance recorders, Handling of Missed & Mismatch

Punches, Handling of Late Comings, Handling of Early Leavings, and Dynamic

Allocation of Allowance & Deduction, Automatic Monthly Loan deductions,

Automatic Shift Maintenance, Automatic Leave Maintenance, Maintenance of

Yearly Holidays, Handling of over Time Details, Handling of Medical

Reimbursement, Handling of Leave Travel Allowance and the statutory reports

for PF& ESI.

Responsibilities:

* Involved in unit testing of Application

* Screens Design, coding and Played an active role in Deployment process

of the project

* Development of Loan Module, OT calculations, Shift Allocation for

Employees,

* Developed business logic using COM objects for Loan Deduction, Shift

Maintenance and also Leave Details of All the Employee

* Developed Various Reports like Monthly Salary Statement, Monthly

Salary Consolidation Statement, Form 3A, Form 6 and other statutory

reports using Crystal Reports

* Supported postproduction by fixing the bugs.

* Review of code

* Updating the process checklist

* Participated in various meetings and discussed Enhancement and

Modification Request issues

Environment: VB 6.0, Crystal Reports, SQL Query Analyzer, Visual Source

Safe, Win 2000

Student Information System 2004

Role: Jr. Developer

Project Description: This is a integration application used to Record &

Maintain Student records, such as student details, course details, fees

details, etc.

Environment: VB 6.0, MS Access, MS Office

Inventory Management System 2003

Role: Jr. Developer

Project Description: This is a integration application used to Record &

Maintain inventory records.

Analyzing User needs & developing user requirements. Creating a detailed

functional requirement document specifying the user & the system

requirements.

Environment: VB 6.0, MS Access, MS Office

Educational Qualification:

Bachelor in Computer Science (Mumbai University- 2003)

Diploma in Networked Centered Computing from NIIT.

Certificate Course in Basic Computing from NIIT.



Contact this candidate