Qa Test Engineer Resume
Columbus, OhiO
Professional Summary:
Primary Skills: VSTS 2008, TFS 2008, QTP 9.0, Quality Center, SQL 2005/2008, C#, HTML, VBScript, JavaScript
- More than 5+ years of IT Experience specializing in Web Technologies, Integration technologies and Software Quality Assurance (Automation, Manual). Includes testing interfaces developed on BizTalk, and .NET.
- 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 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.
- 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
Integration Technologies: Biz Talk Server 2009.
Testing Tools: HP Quality Center 10.0, QTP, Visual Studio Team System 2005/2008, TFS
2008, Quality Center
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: MS Word, Excel, PowerPoint, Access, MS FrontPage, SharePoint,
Infopath, MS Visio, Notepad++, Ultraedit
Files Format: TXT, CSV, Positional, XML
Database: SQL Server, Oracle
Protocols: TCP/IP, HTTP, HTTPS, SOAP, FTP
Web/Applications: MS Internet Information Server, WEBSERVICE
Work Experience:
IMPACT SIIS (Statewide Immunization Information System)
Confidential Columbus Ohio,
Role: QA Test Engineer
Project Description:
Confidential 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 thePatients data and maintains Provider’s Vaccine Inventory data, creates Vaccine/Immunization forecasting for individuals, also helps in creating Practices, Clinics and Providers for each Practice and generatingReminder/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 Integration, GUI, Functional, Regression Testing, System Testing, and User Acceptance Testing.
- Created and maintained test scripts 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, and Single Sign ON Modules by referring the Business Requirement Documents.
- Prepared Test Plans for HL7 & NON HL7 File formats (Lead File, Cleveland File, and Medicaid File).
- Tested with CSV, Positional, XML file formats.
- Tested Ordered delivery, Batch and real time data.
- 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.
- Extensively used BizTalk admin console for BizTalk artifacts.
- Verified the data on the HL7 file & NON HL7 Files to match with the XML schema.
- 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.
- Used TFS (Team Foundation Server) for bug tracking, Work Item Tracking and published test results in TFS to share with the team members.
- Used Windows SharePoint services for maintaining and uploading the Project Documentation (Requirements, Test Plan, and 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 2008(TFS), BizTalk Server 2009, SharePoint 2007/Infopath, C#, ASP. Net, XML, SQL Server 2008, Oracle, Windows XP/Vista/Win 7,Mac, Internet Explorer 8/7, MS VISIO, Outlook ,MS office, 7Edit, Notepad ++, Text Pad.
File Transformation Delivery System
Confidential
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, Quick Test Professional(QTP), IIS 6.0, .NET Framework 2.0 ,BizTalk 2006/2004, XML, SQL Server 2005, VBScript, JAVA, HTML, SSRS, MS Project, Visio, TCP/IP protocols.
File Transformation Delivery System
Confidential
Role: Business Analyst
Project Description:
The project involved in dealing directly with the clients and understanding the needs & communicating it to the technical team and helping to do the costing & also to develop the product according to the needs of the client.
Responsibilities:
- Analyzed the business needs of the clients and help identify business problems and propose solutions using the discipline of business analysis.
- Within the systems development life cycle domain I typically performed a liaison function between the business side of the enterprise and the information technology department or external service providers.
- Include communicating and validating requirements for changes to business processes, policies and information systems.
Environment: Windows Vista, BizTalk 2006/2004, MS Project, Visio, TCP/IP protocols.
Educational Qualification:
Masters in Environmental Sciences