SUMMARY

• Over 8+years of Experience in Software Quality Assurance and Testing in different environments and platforms.
• Solid Back End Testing experience by writing and executing SQL Queries
• Excellent testing experience in all phases and stages of Software Testing Life Cycle and Software Development Life Cycle (SDLC) with good working knowledge of testing methodologies, disciplines, tasks, resources and scheduling
• Expertise in creating Test Plan documents and developing test strategy documents and preparing the Traceability Matrices
• Expertise in designing the test scenarios and scripting the test cases in order to test the application
• Expert in PERL, UNIX Shell Scripting & SQL writing for several technology needs
• Involved in Developing Data Marts for specific Business aspects like Marketing & Finance
• Creation of test data and Automation of test cases for system and analyzing bug tracking reports
• Expertise Shell Scripting experience on UNIX, Linux and Windows environment
• Extensively strong on databases including Oracle, MS SQL Server, and Teradata
• Strong in testing Stored Procedures, Functions, Triggers and packages utilizing PL/SQL
• Good experience in Data Modeling using Star Schema and Snow Flake Schema and well versed with UNIX shell wrappers, KSH and Oracle PL/SQL programming
• Involved in generating Test Scripts using Quick Test Pro (QTP) for different transactions to execute Functional Testing, Regression Testing and Acceptance Testing
• Experience in testing and writing complex SQL, T - SQL and PL/SQL statements to validate the database systems and for backend database testing

TECHNICAL SKILLS

Languages: SQL, PL/SQL, C and C++ Concepts, PERL, Test Script Language (TSL),CSS, HTML, VBScript, JavaScript, Shell Scripting

Databases: Oracle 10g/9i/8i, MS SQL Server 2008, MS Access 2008, Teradata V2R6, DB2 UDB 8.2/8.1, Informix

Reporting Tools: Business Objects XIR 2/6.5.1/6.0/5.1. x/4.0 (Supervisor, Designer, Reporter), Cognos 8.0 Series, Crystal Reports, Hyperion Reports 7.x/2.x

Tools: TOAD, Win SQL, Teradata SQL Assistant, BTEQ, XML Spy 2008

Operating Systems: Windows (95, 98, 2000, NT, XP), UNIX

Tools: MS-Office suite (Word, Excel, Project and Outlook)

Testing Tools: Mercury (Quality Center, Win Runner, Load Runner, Quick Test Professional, Performance Center, VU Scripting, Business Availability Center) Rational Test Manager, Rational Robot, RequisitePro, RUP, UML, MS Project, MS Visio & Visual Source Safe

PROFESSIONAL EXPERIENCE

Confidential, Scottsdale, AZ

Sr. QA Tester

Responsibilities:

• Involved in understanding Logical and Physical Data model using Erwin Tool
• Prepared the guides for UAT
• Prepared Execution procedure document format to prepare the Test cases based on mapping document.
• Expert in Waterfall Lifecycle, AGILE and Iterative project testing methodologies
• Implementing logical and physical data modeling with STAR schema using Erwin in Data Marts
• Ensured that the mappings are correct and Conducted data validation testing
• Worked with PERL control structures & Regular Expressions for substitutions based on matches
• Worked with business analyst and developers in setting up test data
• Configured and Tested Medicaid/Medicare Contracts, Benefits and Claim modules inQNXTsystem on a daily basis, and other multiple modules such as, Sponsors, Carriers/Programs and Reference table modules as neededResponsible for Regression Testing of products using Quick Test Professional
• Extensively test the reports for data accuracy and universe related errors
• Worked on notices and validated PDF notices after executed in RQM
• Used T-SQL for Querying the SQL Server database for data validation and data conditioning
• Tested several dashboards and deployed them across the organization to monitor the performance
• Used SQL tools to run SQL queries and validate the data loaded in to the target tables
• Validated the data of reports by writing SQL queries in PL/SQL Developer against ODS
• Involved in user training sessions and assisting in UAT (User Acceptance Testing)
• Written extensive UNIX Shell scripting for error logging, cleanup, data archiving & job scheduling
• Preparing manual test cases and test data for Scenarios
• Reviewed documents related to the ACA and Configure Medicaid Benefits and contracts within the QNXTclaim processing systemExtensive experience of manual and automated testing of application and use of HP Quality Center, HP Quick Test Pro, Test Director.QTP
• Web services testing (SOAP, REST) using SoapUI and Valium tool
• Execute the Unix Shell Scripts to Know the Backend Batch Jobs Status
• Implemented SDLC, QA methodologies and concepts in the Project
• Responsible for testing Business Reports developed by Business Objects
• Experience in creating UNIX scripts for file transfer and file manipulation
• Ran SQL Queries for generating member demographics, member medical condition, Lab data and Member Provider extract fromQNXTand data martCreated and executed Test scripts for system validation and user acceptance testing (UAT)
• Did database backup and recovery mechanism using PERL
• Tested multi browser application manually and executed in RQM
• Involved in extensive DATA validation using SQL queries and back-end testing
• Tested Analytical Data Mart (ADM) of Oracle system and Stored Procedures
• Tested Operation Data Store process of ODS/DWL product
• Used workflow manager for session management, database connection management and scheduling of jobs

Environment: QNXT XML, Agile,XSLT, XPath, XQuery, SQL Server 2008, ALM/Quality Center 11, DTS, SSIS, T-SQL, SQL, Teradata 13.0, Oracle 11g, PL/SQL, IBM DB2, Rational Quality Manager (RQM), PERL, Business Objects XI3.1, MS Access, Flat Files, Korn Shell Scripting

Confidential, Atlanta, GA

QA Tester

Responsibilities:

• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center 9.0
• Created test data for testing specific Membership functionality
• Extracted certain column of data from a number to files using PERL
• Used PERL for automating all the types of modules at a time
• Worked with PERL control structures & Regular Expressions for substitutions based on matches
• Worked with PERL for file manipulations, text processing, data parsing and Converted SQL queries results into PERL variable
• Tested the functional process to identify the discrepancy members between QNXT and Care advance and populate it into staging table
• Knowledge in testing and validating XSD, XPath Syntax, MQ, REST, HTTP and SOAP Messaging
• Document all the findings/results/defects in UAT in ALM (Application Lifecycle Management). Work towards the quick resolution and resumption of testing.
• Highly proficient in automating tests using QTP and modifying the test script code by parameterization, standard checkpoints, and output - value checkpoints using VBScript.
• Extraction of test data from tables and loading of data into SQL tables
• Extracted certain column of data from a number to files using PERL
• Used PERL for automating all the types of modules at a time
• Well versed with various types Software Development methodologies- Water fall, Agile, RUP, Iterative and extreme Programming
• Wrote complex SQL syntax using case, having, Group by etc
• Written several complex SQL queries for validating Cognos Reports
• Responsible for Data mapping testing by writing complex SQL Queries using WINSQL
• Experience in creating UNIX scripts for file transfer and file manipulation
• Validating the data passed to downstream systems
• Worked with data validation, constraints, source to target row counts
• Used OLED source task, derived column and lookup to read the data from the member coverage & eligibility reconciliation Staging table and update the discrepancy records in Care advance and delete the member eligibility /coverage /member PCP records in Care advance which are not there inQNXTInteracted with QA and Development Engineers to learn about work flow, analyzed the test process, and helped develop strategies for testing products and services in an agile environment
• Wrote and ran Unix Scripts for batch jobs.
• Provide the Business Users with all the required details/tools, user manuals & guides, related information to conduct their UAT
• Performed regression testing against the various builds of the application and executed manually in RQM to perform through testing.
• Used data conversion to Protect the data and prevent data loss
• Strong in writing sql queries and makes table queries to profile and analyze the data in MS Access
• Created macros to automate the process of refreshing the data in MS Access
• Provided technical support and coaching to team members about functionality of MS Access
• Involved in testing data mapping and conversion in a server based data warehouse
• Involved in testing the UI applications
• Strong knowledge of Jmeter and SoapUI for automation and performance testing
• Upon completion of UAT with no outstanding issues, convey the message of successful UAT session to the Project Team and the Senior Managements for obtaining Approvals and Signoff.
• Managed and executed the test process, using Agile Methodology.
• Involved in Security testing for different LDAP roles
• Worked with business team to test the reports developed in Cognos
• Used Microsoft excel and Word 2003 to document the test status reports and the Test Data
• Used Quality Center to track and report system defects
• Involved in testing the XML files and checked whether data is parsed and loaded to staging tables

Environment: Agile, QNXT, Informix, DB2, Java, Cognos, SQL, SQL Server 2008, PERL, Teradata 12, XML, XSLT, XML Spy 2008, IBM AIX 5.3, UNIX, Shell Scripting, QTP,WinSQL, Ultra editor, Rumba UNIX Display, Quality Center 9.0

Confidential, NYC, NY

QA Tester

Responsibilities:

• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements
• Written complex SQL queries for querying data against different data bases for data verification process
• Performed UAT testing information in Quality Centre. Worked in expert view of Quick Test Pro, Configured Quick Test Pro (QTP) with Quality Centre (QC) and Maintained the project .
• Conducted the Functional, System, Integration, Regression, performance, UAT and Smoke Tests for various phases of this application
• Worked on Parasoft SOAtest for API integrity and testing
• Involved in Webservices testing using SOAPUI tool. Validated Request and Response XML.
• Involved in other test planning meetings and submitted test metrics daily to the management
• Designed the data flow diagrams using VISIO
• Prepared the Test Plan and Testing Strategies for Data Warehousing Application
• Preparation of technical specifications and Source to Target mappings
• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security
• Written test cases to test the application manually in Quality Center and automated using Quick Test Pro
• Analyzed SQL code to ensure Business Objects queries the correct data from the database
• Defects identified in testing environment where communicated to the developers using defect tracking tool Mercury Test Director
• Developed scripts, utilities, simulators, data sets and other programmatic test tools as required executing test plans
• Performed Functional Testing of the Web services using Soap UI and ITKO LISA
• Developed and Executed Test cases for EWS (Enterprise web services) /XML and Restful Services using SOAPUI tool
• Setting up, monitoring and using Job Control System in Development/QA/Prod
• Conducted functional walkthroughs, User Acceptance Testing (UAT) sessions, and assisted the development of User Manuals for customers
• Extensively worked with flat files and excel sheet data sources. Wrote scripts to convert excel to flat files
• Created test automation best practices and developed automation scripts using QTP (QuickTestPro)
• Participated in defining and executing test strategies using agile methodology.
• Scheduling and automating jobs to be run in a batch process
• Effectively communicate testing activities and findings in oral and written formats
• Reported bugs and tracked defects using Test Director 6.5
• Extracted data from various sources like Oracle, flat files and SQL Server
• Worked on issues with migration from development to testing
• Extensively tested several Cognos reports for data quality, fonts, headers & cosmetic

Environment: PERL, Agile, UNIX Shell Scripting,QTP, SQL *Loader, Cognos 7.0 Series, Oracle8i, SQL Server 2000, Erwin 3.5, QTP,Windows 2000, TOAD 7, PL/SQL

Confidential, Baltimore, MD

QA Tester

Responsibilities:

• Analyzed the Business Requirements of the system. Worked with the development team to review project plans, requirements specification, design documents, and computer software.
• Analyzed the Functional requirements using Scenarios & DDD(Detailed Design Document)
• Ran SQL queries to verify the number of records from Source to Target and validated the referential integrity, Time variance, Missing records, Nulls/Defaults/Trim spaces rules as per the design specifications.
• Performed data validation testing forQNXTbackend tables and ran queries for allQNXTModules
• Worked with XML feeds from multiple sources systems and loaded the same into Enterprise data warehouse.
• Used UNIX to verify the session log files for error and warning details.
• Executed the Test Scripts in TOAD and documented the results in RTM.
• Imported data from tables in one schema to CSV files and exported to tables from another schema using SQL* Loader.
• AssistedQNXTnew implementations, upgrades, assessments, and system integration.,
• Performed UAT, Usability, Cross-Platform and Regression Testing during different stages of the application development
• Tested the reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae etc.
• Responsible for testing Business Reports developed by Business Objects XIR2
• The reports that were created in Business Objects were testing by running the SQL statements
• Wrote Test cases for Enterprise Data Warehousing (EDW) Tables and Data Mart Staging Tables.
• Compared query result sets from different database systems using UNIX diff command.
• Verified correctness of data after the transformation rules were applied on source data.
• Coordinated execution of User Acceptance Testing, regression and integration testing with multiple departments.
• Maintained the batch processes using Unix Shell Scripts
• Defect logs were created in Quality Center and coordinated with Development team in fixing the defects.
• Responsible for TestingQNXTGroup Member Premiumconfigurationset up and maintenance
• Worked with development team to ensure testing issues are resolved on the basis of using defect reports.
• Wrote complex SQL s to validate target data based on the business requirements.
• Used PL/SQL programs for performance testing.
• Used SQL and PL/SQL scripts to perform backend database testing.

Environment: QNXT, Business Objects XIR2, Quality Center, SQL, PL/SQL, DB2, PL/SQL, Teradata, UNIX Shell Scripting, Toad, Oracle, XML, Autosys, TSO, JCL, VSS, Windows

Confidential

QA Tester

Responsibilities:

• Involved in Design and development of test plans based on high-level and detailed designs
• Analyzed the use cases given by the business analysts and developed test cases using them
• Responsible for complete manual testing of application under test (UAT)
• Written complex SQL queries for data validation and to verify the extract rules
• Performed black box/functional testing, regression testing on Application Under Test
• Performed manual testing on various modules of the Application
• Generates functional test cases that capture actual code behavior as a deployed application is exercised
• Did extensive backend testing using SQL, UNIX and PL/SQL
• Written PERL scripts for text processing, database connectivity & data parsing
• Written complex SQL queries for data validation and data verification
• Executes the test suite to identify regressions and unexpected side effects
• Parameterizes test cases for use with varied, controlled test input values (runtime-generated, user-defined, or from data sources)
• Monitors test coverage and achieves high coverage using branch coverage analysis
• Tests individual methods, classes, or large, complex applications
• Tracks how test results and code quality change over time
• Conducted performance and load testing using Load Runner
• Analyzed, reported and kept track of defects using Test Director

Environment: Windows NT, Shell Scripting, MS-Office Tools, SQL, PL/SQL, XML, XSLT, Web Services, SOAP, Manual Testing, Test Director, Load Runner, Oracle, Java, Servlets and Java Script