SUMMARY:

• 7+ years of extensive experience in Quality Assurance testing of SQL, Data, ETL and Business Intelligence processes, Web Based and Client/Server applications.
• Excellent knowledge in implementation of different QA methodologies/policies, strategies and plans in all stages of SDLC.
• Excellent knowledge in test planning, coordinating, execution and leading the testing process.
• Experience performing all types of testing like smoke, system, integration, regression, and User acceptance retesting.
• Extensive experience performing Root cause analysis on defects and conducting review meetings on defects for open defects.
• Excellent knowledge of defect management and tracking using Quality Center, JIRA and Mission Control
• Tested various ETL processes developed using ETL tools like Informatica Powercenter, Ab Initio and Datastage.
• Tested various reports generated by Business Objects, Hyperion and Cognos.
• Proficient in querying various databases like Oracle, Teradata, DB2, SQL server, MySQL, MongoDB, Hadoop and Flat files. Excellent knowledge of defect management and tracking using Quality Center.
• Adept at backend testing and data validation testing using SQL queries
• Experience in performing data validation and preparation of test da in UNIX environment using various UNIX commands and editors.
• Excellent Domain Knowledge in Financial, Retail, Healthcare and pharmaceutical. Hands on experience in Waterfall, Agile and adaptive delivery methodologies.
• Coordinated testing efforts and effectively managed Off - Shore teams.
• Self-conscientious starter, strong team skills and ability to lead a team toward achieving organizational objectives

SKILL:

Testing Tools: HP ALM/Quality Center, Test Director, QTP, JIRA, Mission Control

Environment: Windows 98/2000/NT/XP, IBM Mainframes, Unix, Linux.

Languages: SQL, PL/SQL

RDBMS: Oracle 8i/9i/10g/11g, SQL Server 2008/2012/2016 , Teradata, Sybase, DB2, Hadoop

ETL Tools: Informatica PowerCenter, DatastageAb Initio, and SSIS

BI Tools: Business Objects XIR2/XIR3, Cognos, Microstrategy, SSRS and Hyperion

Programming Frameworks: .NET 4.5/4.0/3.5/2.0/1.0 , C#, python, Ruby, .net, HTML, JavaScriptVBScript, SQL, Shell scripting, PL/SQL, PowerShell. Build Tools Ant, Maven

EXPERIENCE:

Confidential, Santa Barbara, CA

QA Engineer

Responsibilities:

• Responsible for managing the entire test lifecycle for the test service requests from the respective functional Area by coordinating with offshore Test Leads and Test Analysts.
• Experience in writing test cases, test scripts, test plans and execution of test cases reporting and documenting the test results using Quality Center/ALM and performing end to end testing and created Reports.
• Extensively used ETL methodology in testing for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL solution using ETL tools like Informatica.
• Ensured that the mappings are correct and Conducted data validation testing. Worked with business analyst and developers in setting up test data
• Created and maintained test documentation and test plans. Development and Execution of Test Cases for Informatica ETL components.
• Worked in Agile methodology with developers and testers for development and testing on timely manner.
• Extensively test the reports for data accuracy and universe related errors. Used Toad for query Oracle, SQL Management studio for SQL Server.
• Data migration of raw data to excel documents for clients. Participated in defining and executing test strategies using agile methodology
• Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Responsible for collaborating with the subject matter experts to understand the business/functional aspects of the system in scope and analyzing/reviewing the requirements for testability and providing estimates to the Service Delivery Lead - Testing.
• Involved in extensive DATA validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.
• Responsible for collaborating with the deployment team and ensuring the test environment readiness and coordinating with the development teams and tracking the defects to closure.
• Responsible for defect management and test management.
• Responsible for consulting with teams on set-up and maintenance of HP ALM/Quality Center projects and administer team access to applicable Quality Center/HP ALM projects

Environment: ETL Informatica PowerCenter, ALM/HP Quality Center 11.0, Agile, SQL, PL/SQL, XML, XSLT, Oracle, UNIX, Toad for Oracle, MS Office, QTP, UNIX.

Confidential, Freeport, ME

ETL QA Engineer

Responsibilities:

• Analyzed the Business Requirements Specification Documents and Source to Target Mapping Documents and identified the test requirements.
• Tested Informatica mappings, and also the data from different sources whether it was formatted, Cleansed, summarized, aggregated, transformed and loaded into target database
• Attended daily Scrum Stand-ups for QA updates and defect status.
• Tested the ETL process that loaded the data into target database after performing all the transformations according to the business requirements.
• Writing complex SQL queries for checking the counts and for validating the data at field level. Prepared sample test data by inserting data into staging tables.
• Tested the format of the reports according to the specifications provided and also compared the data in the reports with the backend Datamart through SQL and also using excel for data comparison.
• Was involved in running the Informatica jobs from UNIX box for loading the test data into the target and also modified the shell scripts for scheduling purposes.
• Co-ordinated with the offshore counter-part for testing needs and also gave KT sessions on the business requirements.
• Was responsible for maintaining all the test cases and defects in HP Quality Center for all the team members to review. Prepared all the test scenarios and shared across the team. Involved in testing all the reports that were generated through Business Objects
• Was the point of contact for the QA team for escalations and lead the bug triage meetings.
• Validated the production tickets assigned and once confirming the defect assigned it to the developer for fix.

Environment: Informatica PowerCenter 9, Oracle, Unix, Business Objects, HP Quality Center, Toad for Oracle, MS Office, Windows XP

Confidential, San Francisco, CA

QA Engineer

Responsibilities:

• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center.
• Involved in developing detailed test plan, test cases and test scripts using Quality Center/ALM for Functional and Regression Testing.
• Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing) Written several complex SQL queries for validating Reports.
• Worked closely with developers and report planners/analysts to ensure that an acceptance criterion is complete and accurate for desired report capability.
• Extraction of test data from tables and loading of data into SQL tables.
• Used Quality Center for bug tracking and reporting, also followed up with development team to verify bug fixes, and update bug status.
• Conducted manual back-end testing on a reconfigured sales application system.
• Performed extensive Back-End testing by writing and executing SQL queries on the database-using SQL Query Analyzer.
• Performed periodic checks to run crosscheck against QA/SIT/PROD environments to ensure it is up and running.
• Provided the Test status to the Tech lead, Project lead and the team mates. Effectively communicated testing activities and findings in oral and written formats.
• Validated the reports to make sure all the data is populated as per requirements.

Environment: Informatica Power Center, Business Objects XIR3, SQL, PL/SQl, SQL Server 2008, QTP, Quality Center, Oracle 10g, UAT, UNIX and TOAD.

Confidential, Ashburn, VA

QA Engineer

Responsibilities:

• Created test cases and test plans for user acceptance testing and system testing based on functional specifications.
• Tested all the ETL processes developed for fetching data from OLTP systems to the target Market Data warehouse using complex SQL queries.
• Tested all the compliance reports generated using Business Objects BI tool by validating the data in the report against the database according to the requirement specifications using SQL.
• Performed data validation on the flat files that were generated in UNIX environment using UNIX commands as necessary.
• Tracked defects to closure by coordinating with the dev team. Tested source data for data completeness, data correctness and data integrity.
• Participated in business requirements gathering and in modifications of the requirements based on the scope.
• Prepared test data to cover all the test scenarios. Prepared UNIX scripts to run the Informatica ETL jobs from command line.
• Maintained all the test cases in HP Quality Center and logged all the defects into the defects module.

Environment: SQL, PL/SQL, HP Quality Center 10.0, XML, Oracle 10g Informatica 8.6, Business Objects XIR3, TOAD for Oracle

Confidential, Jacksonville, FL

QA Engineer

Responsibilities:

• Performed Back End Testing-using SQL queries, generating reports to ensure data integrity and validate the inserted and updated data
• ETL testing for validating the load process of ETL to make sure the target tables are populated according to the data mapping provided that satisfies the transformation rules.
• Automate QA scripts to test ETL loads and applications.
• Raised defects and assigned to Development teams with appropriate severity levels. Worked closely with developers to resolve the technical issues to meet the dead lines.
• Conduct backend testing using SQL queries to validate data and executing user specific test cases
• Identify & setup test data, establish test procedures, create test plan and acceptance criteria
• Use HP Quality Centre for writing test cases, updating results and defect handling
• Communicate & coordinate with teams to map out business requirements and technical specs
• Create & execute SQL queries to validate data and isolate issues in UAT & QA environments

Environment: SQL, PL/SQL, HP Quality Center, XML, Oracle 10g Informatica and TOAD for Oracle.

Confidential

Jr. Manual Tester

Responsibilities:

• Responsible for gathering Business Requirements, Functional Requirements and Design Documents.
• Performed Functional, Negative, Positive, Integration, Regression, End to End and User Acceptance Testing. Wrote manual test cases for smoke, functional, GUI and regression testing.
• Extensively involved in writing and designing templates for the Test Plans and Test cases
• Identified the Test Cases and documented them in Quality Center. Worked with the Developers and the Test Lead to verify the Test Cases.
• Designed and Analyzed Test case design document basing on the Functional Requirement Specifications to implement through testing process.
• Analyzed and Developed Test Plan, Test Cases, Test Scripts, Expected Test Results and Test Procedure from functional requirement for different modules in SAP
• Involved in creating the Traceability matrix based on Functional requirement in each module. Base-line and Regression tests were scheduled and performed on every Release and build.
• Supported End-to-end testing for downstream systems. Creation of Test Data for Member data's according to the scenarios.
• Involved in Task Creation, Task Estimation, Task Distribution, Task Prioritization and Communication among Onsite and Offshore Team Members.
• Regularly followed up with the development team to discuss the defects identified during Testing.
• Involved with Test Coverage Metrics and Defect metrics such as Defect Density, Delivered Defect Density, Defects by Severity, Number of Defects, and Defects per build, Defect Fix Rate, Test Case Utility, Test Effort and various other measurements.
• Interact with end users and investigate issues related to the QA. Coordinated user acceptance testing with final users. Prepared end user documentation for the new system
• Used Quality Center to store all testing results, metrics, implemented Test plan Document, created Test Cases, Defect Tracking & Reporting.
• Participated in status meetings to report issues. Communicated with developers through all phases of testing to prioritize bug resolution using Quality Center
• Expertise in generating the daily defect detailed report using Quality Center for the other project stake holders and the project Management. Maintained bug lists for critical issues using Quality Center.

Environment: Quality Center, SAP, HTML, MS Office, Microsoft Excel, MS Word, Internet Explorer, Microsoft outlook, PowerPoint and Visio