PROFESSIONAL EXPERIENCE:

• Around 7+ years of professional experience in Software Testing as Software Quality Assurance Engineer on different platforms and environments
• Strong knowledge in loading the flat files, xml feeds, data from IMS mainframes into databases
• Expertise in Analyzing Business Specifications and develop Test Plans, Test Cases and Test Scripts and execute them.
• Validation, transformations, and business rules.
• Experienced with automated software testing tools Quick Test Professional (QTP)
• Experience in working with ALM/HP Quality Center 11 for test management and defect tracking.
• Excellent analytical and logical programming skills with a good understanding at the conceptual level and possess excellent presentation, interpersonal skills with a strong desire to achieve specified goals. Excellent written and verbal communication skills including experience in proposal and presentation creation.
• Experience leading medium sized Teams spread across multiple time zones and countries
• Experience in all phases of Software Development life cycle.
• Expert in writing complex SQL queries and worked on SQL scripts to load data in the tables.
• Experience working with huge volumes of data, analyzing record sets for Data Quality, Data Validation and Metrics using SQL and / or PL/SQL
• Comprehensive knowledge of mainframe programming, test plan, regression testing, and techniques
• Strong understanding of technical mainframe testing strategies
• Excellent knowledge and working experience in test planning, test execution and test result analysis.
• Worked with technologies like WSDL, SOAP,SOAP UI, XML, XPath and Web Services
• Has expertise in Test Case Design, Test Tool Usage, Test Execution, and Defect Management.
• Knowledgeable on Dimensional Data Modeling using Star and Snow Flake Schema.

TECHNICAL SKILLS:

Databases: Oracle 11g/10g/9i/8i, MS SQL Server 2008/2005, DB2 8.x, Teradata 12.0

BI/OLAP Tools: OBIEE, Cognos 8.0/7.0/6.0, Business Objects XI R3/R2/6.x/5.x

Languages: SQL, PL/SQL, Unix Shell Script, Visual Basic, XML, PERL

Tools: Toad, SQL* Loader, WinSQL, Teradata SQL Assistant

Operating Systems: Windows 2003/2000/NT, AIX, Sun Solaris, Linux

Testing Tools: Quality Center 10.0,QTP, WinRunner, LoadRunner, Test Director, Rational Clear Quest

Version Control: Rational Clear Case, CVS, VSS, PVCS

PROFESSIONAL EXPERIENCE:

Confidential, Columbus, OH

QA Tester

Environment: Oracle 11g, Unix Shell Scripting, POS,MVS, ISPF, JCL, VSAM, Mainframe, DB2, SQL, PL/SQL, Toad for Oracle, ALM/HP Quality Center 11,Ab Initio, SOAP, SOAP UI, QTP, MicroStrategy, Agile, Unix, MS Office, Data Profiling, Excel

Responsibilities:

• Experience in migrating data from the Database by generating the SQL from the Pivot table
• Performed dynamic pivoting by using dynamic SQL by dynamically building the pivoting query
• Worked on creating a custom SQL query on the DB to test the query, and then put the query inside an Excel pivot table in order to display the data.
• Test execution in accordance with test strategy and test schedule, review; issue identification and data mining exercises in accordance with project plan timelines.
• Executed scenarios to verify the   POS   reporting features and interfaces to inventory details
• Used Quick Test Pro generated various scripts for performing functional testing
• Manipulating, cleansing & processing data using Excel, Access and SQL
• Writing SQL scripts to manipulate data for data loads and extracts.
• Used Tivoli to schedule and run Ab Initio Jobs and Unix to monitor ETL execution and logs.
• Extensively used Ab Initio GDE for mocking data using continuous flow graphs.
• Experience in writing scripts for loading data into the Databases
• Writing test cases to compare the data between source and target databases
• Writing complex SQL queries to check the Views built on the source tables and to compare data between source and target
• Tested   POS  system software for data validation, data verification.
• Worked with Mainframe MVS environment for accessing VSAM Files.
• Involved in testing all the reports that were generated through MicroStrategy.
• Validated various MicroStrategy reports such as ad hoc, grids, graphs.
• Quality Center used for Test Case Management, Test execution status, and Defects Management.
• Performed browser compatibility testing on   Ecommerce   application
• Conducted the Functional, System, Integration, Regression, performance, UAT and Smoke Tests for various phases of this application
• Performed Web Service testing using HPService Test and SOAP UI.
• Worked with SQL Queries using joins to facilitate the use of huge tables for processing several records in the database.
• Performed Testing web applications and software for   E - Commerce    
• Performed data validation and mainframe testing in interactive mainframe environment
• Attending defect triage meetings
• Tested several JCL's for several data movement projects and migrated the same to UNIX Shell Scripting.
• Participate in the creation of Test Scenarios & Test Cases with the UAT Team and the Business Analysts.
• Performed Functional, Regression, System Integration, User Acceptance and Configuration testing for web-based   E-Commerce Application .  
• Managed and executed the test process, using Agile Methodology.
• Developed stored procedures to validate the data obtained.
• Testing the source data for data completeness and data correctness.
• Performed Functional, Regression, System Integration, User Acceptance and Configuration testing for web-based   Ecommerce Application .  
• Checking the PL/SQL procedures that load data into the target database from standard tables.
• Testing flat file data in Unix environment by using complex Unix commands
• Coordinating with offshore team for testing purposes.
• Assigning tasks to all testing team members.
• Developed Test Estimations to develop test cases and execution.
• Worked with both offshore and onsite and co-ordinate with business teams and technology team
• Performed browser compatibility testing on   E-Commerce   application
• Verified the execution of business checks & rules in   POS  software and defect reporting
• Creation of automated test scripts using QTP.
• Tested the functionality and performance of web services using SOAP UI.
• Testing the universe for report generation.
• Reported the defects in ALM/Quality Center and documented the report.
• Worked with running JCL jobs for many business scenarios.
• Testing and resolving loops and contexts to ensure the correct results from the query.
• Testing the universe structure to ensure the tables are properly updated.
• Performing end to end testing once the individual processes were tested.
• Performing Regression testing
• Participating in the requirements gathering meetings, sprint planning meetings and defect review meetings.

Confidential, Atlanta, GA

QA Tester

Environment: Oracle 10g, SQL, PL/SQL, T-SQL, POS, Teradata, SOAP, SOAP UI, Agile, Mainframe, SQL Assistant 12.0, XML, XSLT, XML Spy, SQL *Loader, Windows 2000, Informatica, TOAD 10.6, MS Excel, Flat files, UNIX, DB2, Autosys, Cognos, HP Quality Center 10.0

Responsibilities:

• Reviewed the Business Requirement Documents and the Functional Specification.
• Developed Test cases, Test plans, and Test procedures using MS Word and MS Excel.
• Conducted source-system data analysis to understand current state, quality and availability of existing data.
• Defined testing criteria, planned, created and executed test plans in a mainframe environment.
• Responsible for Initial data migration testing (Initial Load) from different sources to MDM Database.
• Executed SQL Queries to check the data table updates after test execution.
• Created and executed test cases/scripts for database validation using SQL, PL/SQL in oracle and Sybase and SQL server for interface validation.
• Tested Informatica ETL mappings that transfer data from Oracle source systems to the Data Mart.
• The Company's data come from different operational sources like Oracle, SQL Server, and DB2 is loaded into the claims Data Warehouse built on Oracle using Informatica.
• Verify the source to target data movement and verify the target data by writing SQL queries
• Identify the primary key (logical / physical ) and put update or insert logic
• Deleting the target data before processing based on logical or physical primary key
• Design and execute the test cases on the application as per company standards
• Experience in Data integration of various data sources with Multiple Relational Databases like Oracle, SQL Server, MS Excel, MS Access and Flat Files.
• Worked on Cognos Report Studio to prepare reports. 
• Accessing mainframes and validating the data
• Tested   POS   application reports for reports of daily transactions, receipts of the goods purchased.
• Ran SQL queries to verify the number of records and validated the referential integrity rules as per the design specifications.
• Involved in testing Web based e-commerce Applications and performed Security Testing to ensure the authorization and authentication on web-applications.
• Performed Testing web applications and software for   Ecommerce    
• Created test scripts for the application which uses SOA, Web services, SOAP and WSDL.
• Responsible for executing and maintaining scripts in mainframe applications.
• TOAD is used to perform manual test in regular basis. UNIX and Oracle are using in this project to write Shell Scripts and SQL queries.
• Responsible for testing the E-commerce solution of shopping cart software at front end.
• Hands on experience of developing test plans and strategies of testing web applications and E-commerce solutions.
• Participated in defining and executing test strategies using agile methodology.
• Performed testing in mainframe environment
• Traceability Matrix and Integration Test activities.
• Tested data migration to ensure that integrity of data was not compromised
• Walked through and certified all unit test case execution and performed code review with all the developers prior to exiting the construction phase.
• Performed other essential job responsibilities as required under the instructions of lead mainframe tester
• Tested XML files using Soap
• Worked in creating and executing test scenarios for   POS (Point of Sale)
• Tested Autosys JILS to automate daily and quarterly batch jobs.
• Involved in system Integration testing (SIT), System Verification Testing (SVT) and User Acceptance Testing (UAT).
• Involved in testing Web based Ecommerce Applications and performed Security Testing to ensure the authorization and authentication on web-applications.
• Performed black box system testing from Autosys to validate system functionality and business rule validation with the data analysts.

Confidential, Hoffman Estates, IL

QA SQL Tester

Environment:, UNIX, Shell Scripting, Teradata V2R6, T-SQL, JCL, Mainframe, Teradata SQL Assistant 12.0, SAS/Base 9.1, SQL, PL/SQL, Quality Center 10.0, Agile, QTP, Oracle 10g, Business Objects XIR2, Impromptu, Report Studio, SQL Server 2008, CA Erwin 7.x, TOAD, WinSQL, Ultra Editor, XML Spy 2010, XSD, XML

Responsibilities:

• Written several shell scripts using UNIX Korn shell for file transfers and clean-up process.
• Lead several projects and worked with different work streams towards completion of testing, defect resolution, implementation, support.
• Executed SQL statements for data validation to check data integrity, error handling, data redundancy, and data consistency.
• Identified UAT and regression test scripts for each of the assigned modules.
• Written complex SQL statements for data reconciliation including comparing record counts between source data, data loaded to the warehouse and rejected records.
• Prepared Test data at design phase for both positive and negative scenarios and tested the boundaries for database limitations.
• Performed UAT, Usability, Cross-Platform and Regression Testing during different stages of the application development
• Maintained and tested hospital's mainframe within IT Department.
• Prepared Test Plan and Testing Strategy for the project.
• Wrote SQL and PL/SQL scripts to perform database testing and to verify data integrity.
• Tested different detail, summary reports and on demand reports developed by Report Studio.
• Reported bugs and tracked defects using Quality Center.
• Evaluated QTP for automation & created various GUI checkpoints using QTP.
• Involved in extensive DATA validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.
• Performed all aspects of verification, validation including functional, structural, regression, load and system testing
• Worked with clients to demonstrate Agile techniques for software development.
• Assigned the tasks of testing and evaluating mainframe interactions with distributed systems
• Built a library of test cases for regression testing and automated them using QTP(Quick Test Professional)
• Strong ability in developing advanced and complex SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted
• Applications OLTP environment with Business Objects for Business Intelligence reporting
• Tested the reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae etc.
• Conducted functional walkthroughs, User Acceptance Testing (UAT) sessions, and assisted the development of User Manuals for customers
• Tested ad hoc and canned reports for Business objects.
• Tested with Front-end functionality for the entire application
• Trained a team in using a data mapping tool and the basics of examining mainframe datasets.

Confidential

QA/SQL Tester

Environment: Business Objects XIR3, WinSQL, QTP 9.2, Quality Center 9.2, Agile, Teradata V2R6, TOAD, Teradata SQL Assistant 6.0, Oracle 9i/10g, PL/SQL, IBM DB2.

Responsibilities:

• Created test case scenarios, executed test cases and maintained defects in internal bug tracking systems
• Developed and executed various manual testing scenarios and exceptionally documented the process to perform functional testing of the application
• Debugging the SQL-Statements and stored procedures for various business scenarios.
• Developed advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted
• Loading Flat file Data into Teradata tables using Unix Shell scripts.
• Tested several BO Reports for several business needs including Dashboards, Drill-Down, Master-Detailed, Aggregated, KPI’s, Grouped List, Cascade and Web Reports.
• Tested and validated the BO reports by running similar SQL queries against the source system(s).
• Testing the source and target databases for conformance to specifications
• Design and execute the test cases on the application as per company standards and tracked the defects using HP Quality Center
• Developed Test Plan, Test Cases, Test Data and Test Summary Reports and followed Agile/Scrum process.
• Designed and prepared scripts to monitor uptime/downtime of different system components
• Participated in weekly meetings with the management team
• Involved in the Implementation of QA testing Process, and involved in documentation of Test Scenarios, Test Cases, and Test Scripts for Various Applications.
• Performed the back end testing by using SQL Queries and verified the data integrity.
• Coordinated with the developers to resolve defects.
• Involved in documentation in order to maintain and run scripts for future enhancements.