SUMMARY

• Around 7 years of Software Quality Assurance (QA) experience performing Manual, Automated, Functional, Regression & UAT Testing on Web and Client - server applications using leading tools & software testing techniques.
• Having experience in Performance, Automation using Load Runner.
• Worked and reviewed along with Business Analysts and Functional Team members to translate Business requirements into ETL technical specifications.
• Worked in multiple responsibilities such as reviewing of ETL architecture, ETL design, and analysis and ETL technical specifications.
• Extensive testing ETL experience using) Informatica PowerCenter 9.5/9.0/8.5. x/7.x, (Source Analyzer, Warehouse Designer, Repository Admin console, Mapplet Designer, Mapping Designer, Repository Manager, Workflow Manager, Workflow Monitor and Informatica Server)
• Having good experience in Software Automation using QTP.
• Proficient in various Defect tracking tools like Quality Center, ALM, Bugzilla, and Test Director.
• Proficient in Functional Testing tool Quick Test Professional (QTP/UFT) and the various frameworks in QTP/UFT.
• Solid Back End and Front End Testing experience by writing and executing SQL Queries
• Experience in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
• Worked on restful API web services.
• Having experience in White box testing methods for performance increase.
• Expertise in QA Testing in distributed Unix/Windows Environment and Oracle databases as back end, Performed end-to-end testing.
• Proficient in Oracle 11g/10g/9i/8i/7.3, PL/SQL Development Toad, WinSQL, PL/SQL Developer, SQL Navigator, Perl, UNIX and Korn Shell Scripting.
• Experience in using Oracle Databases and SQL Server.
• Proficient in writing advanced DML and DDL SQL Queries like to retrieve data from databases for Backend Testing using tools like TOAD to check and analyze data integrity and validation.
• Strong skills in Back-end testing using SQL queries, triggers and DTS tools.
• Experience in Defining Testing Methodologies; creating Test Plans and Test Cases, Performing Functional Testing, Regression Testing, System Testing, Verifying and Validating Application Software and Documentation based on standards for Software Development and effective QA implementation in all phases of Software Development Life Cycle (SDLC). Involved in all phases of Testing Life Cycle.
• Knowledge of various software testing methodologies like waterfall, iterative and agile (Scrum).
• Good hands on experience working on functional and business work flow validation.
• Experience in Writing Test Summary Report, Preparation of Bug Severity Chart.
• Contributed in designing core testing documents like Master Test Plan, Test case design and System Test Report.
• Proficiency in Testing Client-Server and Web Applications.
• Good communication skills and interpersonal skill and consistently being organized by management and peer for producing high quality works.
• Ability to communicate effectively with onsite/offshore teams.

TECHNICAL SKILLS

QA/Testing Tools: HP Quality Center / ALM 11, 10.x, 9.x, TestDirector, HP QTP

Version Control Tools: Rational Clear Case, CVS, TFS, Rally, GitHub, Jenkins

RDBMS (Databases): Oracle 11i/10g/9i/8i, MS SQL Server 2003/2005/2008 , MS Access, DB2, Teradata

RDBMS Query Tools: SQL*PLUS, Query Analyzer, TOAD, Oracle SQL, SQL Navigator

Programming Languages: PL/SQL, C, C++, Java, .net

Scripting Languages: SQL Scripts, UNIX Shell Scripts

Web services: Soapui, Rest API Calls

Operating Systems: Microsoft Windows Family, UNIX - Sun Solaris, HP-UX

MS Office: MS Word, MS Excel, MS PowerPoint, MS Outlook

Scheduling Tools: Autosys, Control-M

ETL Tools: Informatica 9.5/9.0

PROFESSIONAL EXPERIENCE

Confidential

Sr QA Analyst

Responsibilities:

• Worked on different modules like Document Process and Plan Holder List, GPD, Source Prep Tool etc.
• Worked on Agile scrum environment.
• Worked on Rally - Agile Management Tool.
• Wrote test cases for the user stories under Acceptance Criteria.
• Ability to craft business requirements into positive and negative functional tests.
• Extensively worked on Rally for writing test cases, execution and defect reporting.
• Tested REST API web services by ingesting requests through POSTMAN.
• Worked Mongo DB queries to verify the JSON data.
• Extensively used SQL queries for back-end testing.
• Automated all REST API calls with SOAPUI, Wrote Groovy scripts. Created Automated Framework or Soapui Scripts library.
• Provided Weekly stats. HTML reports of Soapui Automation regression for each build.
• Participated in Integration of Soapui scripts with Jenkins integration tool.
• Maintained all automated scripts in GitHub repository. Worked with both GitHub shell commands and Desktop app.
• Prepared and validated test data using an internal web application.
• Regularly interacted with BA’s and Developers to discuss various problems and issues.
• Prepared weekly and monthly status reports.
• Attended daily scrum meetings, bi weekly sprint planning, demo and retrospective meetings.
• Good experience in handling multi-tasking.

Environment: POSTMAN, Rally( CA agent), Confluence, Java web services, Mongo DB 0.9.0-RC8, SQL Developer 4.1.3, Ready API (SOAPUI automation), GitHub.

Confidential

Sr.ETL PL/SQL QA Tester

Responsibilities:

• Involved in Business analysis and requirements gathering.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements. Extensively written test scripts for back-end validations.
• Responsible for testing and reviewing of ETL mapping and transformation specifications based on the business requirements from various teams and the business teams.
• Testing of ETL jobs that are scheduled for file transfers from Operational Data Stores to designated file systems/directories.
• Tested various Reusable ETL Transformations which facilitate Daily, Weekly & Monthly Loading of Data.
• Tested the performance bottle necks at sources, targets, mappings, and sessions and employed required measures.
• Used Toad and SQL Plus for testing execution of ETL Processes' PL/SQL procedures, packages for business rules.
• Extensively worked in Oracle SQL, PL/SQL, SQL*Plus, SQL*Loader, Query performance tuning, Created DDL scripts, Created database objects like Tables, Views Indexes, Synonyms and Sequences.
• Tested PL/SQL Procedures, Functions and Packages and used SQL loader to load data into the database.
• Created the PL/SQL packages, procedures, functions applying the business logic to update the patients' database
• Involved throughout the business solution Software Development Life Cycle (SDLC).
• Worked with Quality center to document test results and validate test scripts.
• Wrote Test Plans in MS Word for Manual Testing, System Testing, Integration Testing, Regression Testing & reviewed their consistency with the business requirements.
• Performed White Box, Black Box, and Usability Testing
• Wrote Test Cases in MS Excel for user registration, access to training material, and activity log-in, reviewed the test cases and finalized.
• Creating test scripts using Quality Center and performing regression testing on new versions of the software.
• Tracked and reported the bugs with Quality center.
• Tracked bugs using Quality Center/ALM and performed Regression Testing of the entire application once the bugs are fixed
• Managed and reviewed HP QTP scripts on HP Quality Center. 11.0
• Participated to execute HP QTP scripts for every releases of product
• Writing VB scripts for UFT-11.53. and QTP-11.0
• Tests developed in Eclipse to start and to stop the selenium server and to execute the tests in browser.
• Run tests by using Selenium remote control in different browsers.
• Designed and Developed Test Cases for automated testing using Selenium, JUNIT and Eclipse IDE.
• Created Validation documents for Business, Ensured that the mappings are correct and conducted data validation testing.
• Troubleshooting, resolving and escalating data related issues and validating data to improve data quality.
• Wrote SQL queries for Data Validation, Data Accuracy, Data Trending, Data Completion, Data Analysis and Data Profiling.
• Logged issues found on Jira for everyone to access
• Used Share Point to manage and define requirements and Data Quality Issues.
• Writing complex SQL queries using Case Logic, Intersect, Minus, Sub Queries, Inline Views, and Union in Oracle.
• Using Pivot tables for reporting and creating pivot tables for understanding data in detail.
• Written several complex SQL queries for validating and verifying the data across different databases including SQL Server 2008 and Oracle 10g.
• Tested the application by writing SQL Queries and creating pivot views as to perform back-end testing.
• Followed Agile Methodology for the project.
• Prepared test plans/test schedules with inputs from Project manager and development team.
• Coordinate offshore and onshore team activities.

Environment: Informatica PowerCenter 9.5 & 9.0, HP Quality center 11.0, HP QTP 9.2, HP ALM 11.0, HP UFT-11.53, Selenium Webdriver, UNIX Shell Scripts, Teradata V2R6, SQL Assistant 12.0, SQL server, PL/SQL, Rational Robot, Rational Clear Quest, Rational Test Manager, Rational Functional Tester, Rational Manual Tester, Rational Clear Case, IBM Mainframes, Oracle 10g, SQL Plus, ASP.Net, Agile, MS Access, MS Office, XML, XML Spy, SharePoint, Jira

Confidential

ETL PL/SQL QA Tester

Responsibilities:

• Participated in sprint planning and retrospective sessions.
• Test the complicated max load used was ‘100 million data set’ includes with hundreds of tables relations and constraints.
• Also wrote many functions and procedures as a PL/SQL developer to manage large data set which in turn helped the team a lot.
• Monitored different graphs like transaction response time and analyzed server performance status, hits per second, throughput, windows resources and database server resources etc.
• In depth knowledge of SDLC, Agile methodology and Quality Assurance methods.
• Tested various Reusable ETL Transformations which facilitate Daily, Weekly & Monthly Loading of Data.
• As part of QA team was involved in implementation of ETL best practices.
• Maintain, backup and restore the Informatica ETL repositories for the QA team.
• Tested data models and data maps (extract, transform and load analysis - ETL analysis) of the datamarts and feeder systems in the aggregation effort.
• As part of QA team was involved in implementation of ETL best practices.
• Created manual Test Cases in HP Quality Center/HP ALM for various User Stories based on Release and Sprint Plan
• Develop the Test Recommendations for each test pass and Test Results.
• Experience working in Windows and UNIX Environment.
• Involved in the testing of claims module and Network module of Facets.
• Worked on different modules of Facets such as Members/subscriber, commissions, provider, billing, plan and Case management.
• Used QTP to write the automated test scripts by using various actions and reusable actions.
• Worked in keyword view as well as expert view of Quick Test Pro.
• Configured QTP with Quality Centre and Maintained the project information in Quality Center.
• Called Win Runner scripts into Quick Test Pro.
• Migrated scripts from QTP 11 to UFT 11.5
• Developed automation test framework for HPT QTP / HP UFT, SoapUI
• Used Quality Center for bug reporting.
• Wrote complex SQL scripts using joins, sub queries and correlated sub queries.
• Tested the entire data reconciliation process for multiple source and target system.
• Provided input into project plans for database projects providing timelines and resources required.
• Wrote Pl/SQL scripts for the usage in Performance testing.
• Wrote SQL queries for Data Validation, Data Accuracy, Data Trending, Data Completion, Data Analysis and Data Profiling.
• Implemented Agile Development Methodology for quick solutions.
• Develop Test Plans from functional specifications as per the end user perspective and timely monitoring execution and assisting the team when they required.
• Escalate the issues about project requirements (software and hardware) to Project Managers.
• Preparing the metrics regarding Test progress.
• Planning and scheduling release Dates along with the Team Lead.
• Coordinated and assisted offshore team on day to day testing activities.

Environment: Informatica PowerCenter 9.5 & 9.0,HP Quality Center 10.0, HP QTP 9.2, HP ALM 11.0, UFT-11.5, UNIX, Shell Scripts, TOAD, SQL server, PL/SQL, Java, J2ee, Team Track, Silk Central, Visualvm, SQL.

Confidential

ETL QA Engineer

Responsibilities:

• Develop Test Plans from functional specifications as per the end user perspective and timely monitoring execution and assisting the team when they required.
• Provided input into project plans for database projects providing timelines and resources required.
• Utilized Quality Center for directing, tracking and outlining needs during a project SDLC.
• Worked with ETL group for understating mappings for dimensions and facts.
• Maintained documentation related to difficulties, complexities and anomalies that may arise during the ETL process
• Tested data models and data maps (extract, transform and load analysis - ETL analysis) of the datamarts and feeder systems in the aggregation effort.
• Used Toad and SQL Plus for testing execution of ETL Processes' PL/SQL procedures, packages for business rules
• Wrote Pl/Sql scripts for the usage in Performance testing.
• Designed and Created Database objects and Written PL/SQL Programming for data extraction and transformation.
• Written Stored Procedures using PL/SQL and functions and procedure for common utilities.
• Writing PL/SQL code using the technical and functional specifications.
• Wrote SQL queries for Data Validation, Data Accuracy, Data Trending, Data Completion, Data Analysis and Data Profiling.
• Documented the business requirements for the developers.
• Maintained and kept track of stakeholders requests for enhancements and changes using Rational Clear Quest
• Manually verified the validity of the failed test cases. Performed Positive, Negative and Black box testing on the application
• Create technical design documentation for the data models, data flow control process, metadata management.
• Worked on exporting data using Teradata.
• Wrote Test Cases in Quality center that would test various Test scenarios.
• Written test cases to test the application in Quality Center 10.0 and 11.0(ALM)
• Used UML notations for Object Oriented Design and Documentation.
• Interfaced with the development team utilizing ASP, JavaScript and Visual Basic and produced detailed user-interface prototypes and performed usability testing.
• Manually tested and GTS modules using Quality Center.
• Executed regression tests at each new build in QTP.
• Inserted Synchronization points in the script using QTP.
• Performed Data Driven Testing using QTP for testing the application for multiple data.
• Using QTP & UFT in automation testing based on waterfall mythology.
• Importing VB scripts to UFT and running test cases calling functions and procedures.
• Defect Reporting & Defect Tracking using Quality Center.
• Used SQL extensively to conduct backend testing.
• Created and added tables to SQL database when needed and extensively used SQL queries for data validation.
• Developed database tables using SQL. Loaded data to different databases using SQL scripts and maintained a repository for data loading scripts.
• Wrote and Executed SQL Queries to ensure data accuracy for the data.
• Written several complex SQL queries for validating and verifying the data across different databases including SQL Server 2008 and Oracle 10g.
• Prepared test plans/test schedules with inputs from Project manager and development team
• Monitored different graphs like transaction response time and analyzed server performance status, hits per second, throughput, windows resources and database server resources etc.
• Performing Functionality tests, System Tests, Regression Tests, and Compatibility Tests on different versions of Web WORKS Foundation.
• Configuring the Servers (Windows and UNIX servers) with the latest builds and make it ready for the use of team as required worldwide.
• Participated in Agile iteration meetings and QA activities for all releases of the Project.
• Manage onsite and offshore resources.

Environment: Informatica PowerCenter 8.6.1,HP Quality center 10.0, HP QTP 9.2, HP ALM 11.0, UFT 11.0, SQL server, PL/SQL, Oracle 10g, Java, J2ee, UNIX, Shell Scripts, TOAD, Team Track, and Silk Central, Agile, MS Office.

Confidential, Phoenix, IA

ET SQL QA Engineer

Responsibilities:

• Involved in User story walkthrough
• Client interaction for queries clarification
• Tested ETL process to push the transactional data from the normalized data structure into the data marts.
• Tested SQL scripts for verification of data at extraction phase to ensure, transformation phase and loading phase of the data to ensure correctness of the data and also verifying the ETL mapping rules
• Wrote data conversion and data migration scripts for ETL process
• Created ETL execution scripts for automating jobs.
• Designed and developed test cases for Smoke, Functional, Integration, Negative, Regression test suites.
• Reviewing the test cases and executing the same.
• Used Quality Center in routing defects, defect resolution and assigning business cases to business users.
• Managed Test cases Design, Defect Tracking and Requirements traceability in HP Quality Center.
• Writing QTP Scripts and running the tests. Created and Modified automation scripts using QTP
• Tracking the results of the tests.
• Analyze and if possible fix the defects raised on the XML files as well as the database level.
• Defect tracking and logging the defect with complete details.
• Created/Maintain CR document which contains test status with the path to the CR details and understand the CR and help the team to understand the same.
• Created requirement matrix
• Participated in discussions for prioritizing work, developing time estimates and work plans and assisting team members.
• Conduct client demo along with creating documents for the same
• Helping other project teams with inputs on domain knowledge
• Created a system flow document pertaining to different modules within the project that has greatly helped the team as whole and also received client appreciation for the same.
• Training for new comers on application, writing of appropriate test cases and execution of the same.
• Created and executed SQL statements to retrieve data for testing analysis and test case validations.
• Wrote complex SQL queries to validate Target and source data including identification of duplicate records and quality of data based on Mapping/Transformation rules.
• Performed backend testing using SQL queries, generated the reports to ensure the data integrity and validated the business rules.
• Extensively used SQL queries for data validation.
• Created and Maintained complex SQL queries.
• Verified Test data validity with SQL queries.
• Wrote and executed SQL queries to update and extract data from the back-end databases.
• Executed functional test cases for the application.
• Wrote SQL queries for database testing.
• Performed Database testing for performance
• Worked closely with Developers and Functional Architects by following the Agile (Scrum) Methodology.

Environment: Informatica PowerCenter 8.0,HP Quality Center 9.2, HP QTP 8.2, TOAD, Team Track, NET/Java, Rational Test Manager, SQL Developer,, Windows NT/2000, MS SQL, PL/SQL, UNIX, Manual Testing, XML, Agile, Scrum, IBM DB2, Test Director9.0/8.0, Win SQL, Test link, Bugzilla, Oracle.

Confidential

ETL Tester

Responsibilities:

• Reviewed and analyzed functional requirement specifications, workflow documents, and Use Cases.
• Preparation of High level design and ETL Technical specifications
• Maintain, improve and support current ETL and data integration processes
• Working with ETL team members to ensure efficiency and accuracy of mapping documents
• Extensively involved in ETL code using Informatica ETL tool in order to meet requirements for extraction, transformation, cleansing and loading of data from source to target data structures
• Ensure data integrity and verified that all data modifications and calculations were done correctly during database migration using ETL
• Used ETL Informatica mappings and other ETL Processes (DW Testing)
• Performed System Testing, Integration Testing, Functional and Regression Testing.
• Created Data Driven Tests to validate test scenario with different sets of data using parameterization.
• Closely worked with the Business Analyst, Developers and UI team to resolve the requirement issues, deployment issues, change management etc., during the course of the QA testing and actively participated in Review meetings and walkthroughs.
• Prepared test data to verify different types of scenarios.
• Created Manual Testing strategy and performed Database Testing using SQL Queries by retrieving data from Oracle Database
• Analyzed Manual Test Cases with QA Team for most important & high priority Requirements for conversion to Automated Test Scripts using HP Quickest Professional (QTP)
• Extensively used HP Quality Center as defect tracking system to log, close and generate reports and tracked through to resolution.
• Extensively involved in the Backend / Data base testing using SQL queries.
• Interacted with developers in resolving the defects found in the application during testing.
• Working closely with team members to ensure status and schedules are communicated
• Extensively performed manual testing activities using Quality Center.
• Participate in peer reviews of functional specification, application previews, and test plans/test cases.
• Create and execute SQL queries to fetch data from Oracle database to validate Data.
• Interacted with business analysts and developers to resolve the technical issues so as to meet the client’s requirement for a better quality software product.

Environment: Informatica PowerCenter 7.0,HP Quality Center 9.0, MS SQL, Oracle 10g, TOAD, HTML, XML, Windows. SQL Server.