OBJECTIVE

• Dedicated and experienced Almost Eight years of professional IT development and testing experience with involvement in all stages of product development life cycle including requirement to analysis to development and complete functional testing with proven success with different projects. Seeking an opportunity to use my software development life cycle (SDLC) experience to serve the new position.

SUMMARY

• Experienced using Oracle Database 10g/11g/12c and experience using Sybase database
• Experienced in using SQL for data profiling, data quality checks
• Experienced working under Linux and Windows platforms
• Experienced performing Data Quality checks in SAS
• Experienced creating automating scripts using R to perform routine Data Quality checks
• Experienced using Katalon and QTP automation testing tool
• Experienced in manual and automated testing of web - based, Internet and Client-Server Applications.
• Worked in various facets of software development lifecycle (SDLC).
• Extensive working knowledge in Windows, Linux and Unix
• Proficient in Black Box Testing, System Testing, Integration Testing, and Regression Testing, User Interface Testing, and GUI Regression Testing.
• Extensive experience in testing Data warehouse/Data mart for business applications with healthcare and hospitality domain
• Extensively used ETL methodology for testing data extraction, transformation and loading process
• Hands on expertise in Data ware housing concepts and tools.
• Designed, Developed and Implemented Test Plans, Test Designs and Test Cases for various Applications.
• Experience in UNIX, Shell Scripting
• Supported business team in SIT, UAT and ad-Hoc Projects.
• Support UAT with End users or Business Users.
• End-to-end defect management of assigned projects. Identify defects, assess root cause, and prepare detailed information for developers and business stakeholders
• Experienced in Data Validation and Backend testing of databases to check the integrity of data.
• Good experience in SQL and PL/ SQL for data validation and manipulation.
• Excellent communication, analytical, interpersonal and presentation skills.
• Willingness and ability to quickly learn and adapt new technologies
• Highly motivated resourceful team player takes a positive approach to problem resolution.

PROFESSIONAL EXPERIENCE

Quality Assurance Lead

Confidential

Responsibilities:

• Develops, publishes, and implements test plans for complex, multi-tier, distributed, applications throughout the full life-cycle.
• Participates in all aspects of testing, including functional, regression, load and system testing.
• Assures the appropriate level of quality by the resolution of important defects by working with developers and/or engineers to ensure the software or hardware development process has an appropriate level of testing.
• Develops response strategies and processes for high-criticality and security vulnerability related bug notifications.
• Pro-actively investigates and finds potential security holes and attack vectors within both the existing and newly-developed code base.
• Follow up with the team to make sure everything is on track and update status on Jira so PM can track status of every item to avoid any confusion.
• Created and managed all the defects in Jira
• Performed Cross browser compatibility testing
• Created Test cases based on ETL Specs, BI Specs & Wire-frame documents.
• Monitor the ETL jobs and BI QA Dashboard Row counts and send email to team if job is failed or see discrepancies in row counts.
• Environment: Windows 7, Putty, UNIX, SAS 9.1.3, Tableau 2018.1.1, Oracle 11g, Sybase ASE 12.5.1.,SQL Developer 4.0, Jira 7.0.0, OBIEE 11g, WinSCP 5.5.6.

QA Analyst

Confidential, Henrico, VA

Responsibilities:

• Analyzed business requirements, system requirements, data mapping requirement specifications interacting with developers and QA Teams
• Verify the Source system data with target system data
• Tested ETL jobs as per business rules using ETL mapping design document
• Strong ability in developing SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirement including identifying the tables and columns from which data is extracted.
• Worked in an agile technology with Scrum.
• Attending the Scrum meeting and updating the testing status and knowing the current and upcoming changes from development team.
• Performed Black Box, UI Testing and analyzed the code to test the functionality of the applications
• Writing complex SQL queries for data validation for verifying the reports functionality as per the business Rules.
• Monitor the jobs in file log before deployed to promotion.
• Created Test Plan and Test Summary documents
• Created Test Design Strategies and Test scenarios to cover maximum test coverage
• Created Test Cases based on BRD, FRD, SRD
• Created Test Data to verify functional changes in integration before moving to acceptance and make sure implemented changes meet the user requirements
• Created Test Data to verify software functional changes in integration before moving to acceptance and make sure all the changes implemented as per test strategy and test plan.
• Created and managed all the defects in HP ALM
• Designed and developed QA Test Plan/Test Cases using Testing methodology with all possible Use Case to cover all testable function for Positive & Negative Testing.
• Preparing High-Level and Low-Level test cases based on Design documents & Requirement documents. Developed PL/SQL scripts for Business Rules
• Performed System integration testing on multiple upstream/downstream applications; communicated with upstream data warehouses and downstream users to ensure data consistency across multiple systems.
• Created and managed all the defects in Quality Center.
• Participated in weekly project the meetings, team meetings, CR and design review meetings and Defect review meetings.
• Environment: Windows 7, Putty, UNIX, Datastage 9.1, Selenium 2.40.0, Oracle 11g,, HP ALM Client 1.1.0.0,,Toad for Oracle 12.1, Jira, SAP Business Objects, WinSCP 5.5.6,FileZilla 3.9.0.6,Beyond Compare, TIBCO, DTF (Data Testing Frame Work)Developed PL/SQL scripts for Business Rules

Quality Analyst

Confidential, McLean, VA

Responsibilities:

• Participated in analysis of Business and functional requirements.
• Used Agile Test Methods to provide rapid feedback to the developers significantly helping them uncover important risks
• Developed test scripts and test cases for financial dashboards and reports being developed in OBIEE and BI publisher.
• All dashboards/reports are being built on top of an Oracle Financial Analytics BI application.
• Data validation is being performed at both the report and database levels.
• Validating against a PeopleSoft 9.1 General Ledger
• Developing test scenarios, test cases, and test scripts for all test phases (System, Integration, Performance, User Acceptance).
• IBM Rational Quality Manager for developing testing artifacts, executing test scripts, and recording actual test results.
• Wrote test procedures for back end validation via functional specifications
• Prepared SQL scripts for test data preparation for Back End functionality testing
• Prepared the Test Plan and Testing Strategies for Data Warehousing Application.
• Tested several Ab Initio graphs for each line of business and created test data for the same.
• Tested a number of complex ETL graphs, transformation logic for both full load and daily data loads.
• Creating test cases for ETL graphs and design documents for production support.
• Extensively worked with flat files and excel sheet data sources. Wrote scripts to convert excel to flat files.
• Scheduling and automating jobs to be run in a batch process.

Environment: Informatica, Quality Center 9.2, SQL *Loader, PL/SQL, SQL, Stored Procedures, Test Cases, Test Scripts, Test Plans, Unix,Oracle9i / 10G, DB2, Erwin 4.1, Toad 12.1 and OBIEE 10gR3