SUMMARY:

• More than 8 years of experience in QA with Data warehouse ETL flows, Business Intelligence Reports and Salesforce testing using Manual and Automated testing tools.
• Experience in all phases of the Software Testing Life Cycle (STLC) and good exposure to Software Development Life Cycle (SDLC).
• Experienced in Salesforce Marketing Cloud Email Studio, Journey Builder and Automations studio
• Experienced in writing SOQL queries for data manipulation of the application using salesforce objects.
• Experienced in integration and regression testing of Salesforce Health Cloud Integration.
• Experienced in developing, reviewing, and Executing Test Strategy, Test Plans, Test Scenarios, and Test Cases/Script.
• Strong SQL experience.
• Proficient in SQL query and testing RDBMS such as SQL Server, Oracle, MySQL for data validation.
• Experienced in designing reports using SQL Server Reporting Services (SSRS) and Excel Pivot table based on OLAP cubes.
• Proficient in using SQL Queries using TOAD & SQL Plus to ensure data consistency of front - end and raw feed by developing and executed complex SQL queries for data base.
• Experience testing Cognos Reports.
• Experienced with ETL tools like Informatica, SSIS, Abinitio and Datastage.
• Responsible for creation and maintenance of SQL Server Analysis Services (SSAS) objects such as cubes, dimensions, and queries.
• Strong experience in testing ETL applications and BI reports.
• Experienced with Agile methodology.
• Excellent communication skills and team player.

TECHNICAL SKILLS:

Defect Tracking Tools:: HP Quality Center, HP ALM, SPIRA, Jira, Version One

ETL Tools:: Informatica 9.0/9.1/9.6/10, Data Stage, Ab Initio 1.15, SSIS

BI/Reporting Tools:: OBIEE, Business Objects, SSRS, SSAS, Crystal Reports XIR4, Cognos, Tableau

Operating System:: Windows 98/XP/2000, UNIX, Linux

Methodologies:: Waterfall, Iterative, Agile/Scrum, SDLC, STLC

Programming Languages:: SQL, Salesforce Object Query Language, PL/SQL, XML, Java, Salesforce Marketing Cloud

RDBMS/ Database:: SQL Server, Oracle, IBM DB2, Teradata 12.0, Salesforce Cloud

GUI Tools:: TOAD, Oracle SQL Developer, SQL* Plus, SQL server, PL/SQL Developer

PROFESSIONAL EXPERIENCE:

Confidential, IA

QA Analyst

Responsibilities:

• Created and executed Tested cases to ensure corresponding ETL code is developed as per Data Design Documents
• Managed defect reporting and tracking through resolution.
• Documented traceability of business requirements and technical specifications to test cases.
• Facilitated agreement on test plans or acceptance criteria with business partners and project team members.
• Analyzed defects to determine root cause.
• Reported QA progress to team leadership.
• Coordinated between onshore and offshore team members.
• Tested multi-dimensional data cubes used by business partners for data visualization.
• Tested report output to ensure it meets business requirements.
• Assisted in implementing improvements to testing identified through analysis of testing metrics.
• Designed and developed automated test scripts and halped define overall automation approach.
• Extensively used Informatica power center for extraction, transformation and loading process
• Executed testing, validated test results, analyzed, and reported discrepancies.

Environment: Informatica PowerCenter, MS SQL Server, Informatica DVO, Unix, SSRS Reports and Dashboards, Agile, JIRA

Confidential, MD

ETL Tester

Responsibilities:

• Performed functional testing, integration testing and regression testing.
• Created, maintained, and optimized Email Marketing campaigns using Salesforce Marketing Cloud.
• End to End testing of SFMC Journeys, Automations and Marketing Emails
• Tested various Salesforce Components and Community pages
• Wrote SOQL queries to retrieve and manipulate test data using workbench.
• Participated in user story mapping, sprint planning, estimation, and feature walk-throughs.
• Documented any defects found during the daily testing activities and track them until they are resolved.
• Participated in monthly release activities and in post release support activities.
• Performed tests in adherence to organization’s testing methodology and processes.
• Worked with the Developers, Testers and Analysts to understand the specific needs of the project/product for testing.
• Created level of effort (LOE) and duration estimates for own assigned work and proactively manage activities to meet those expectations.
• Assisted team by supporting the Continuous Integration (CI) environment
• Participated in user story mapping, project walk-throughs, sprint planning and estimation.
• Prepared Testing artifacts as needed, such as Test Plan, Test Strategy, RTM’s, etc.
• Communicated complex technical concepts effectively and in terms dat can be understood by all parties involved.
• Supported client operations by designing, executing, and reporting on B2B demand-generation campaigns.
• Worked with development team to translate marketing requirements into testing scripts.
• Worked closely with operations team to define and implement new functionality and product offerings.

Environment: Salesforce.com platform, SQL, SOQL Salesforce Marketing Cloud, Journey Builder, Automation Studio, Apex Classes, Reports, Dashboards, Agile

Confidential, IA

ETL Test Engineer

Responsibilities:

• Designed and Executed test plans and test cases for ETL and Ad-hoc reporting tool for The Centers for Medicare & Medicaid Services (CMS)
• Involved in testing the UI screens and reports related to OASIS, QIES and CLAIMS dat are used by CMS.
• Submitted and Validated data and reports for various CMS assessments like: MDS and IRF PAI
• Created, updated, and executed complex SQL queries in Star schema.
• Designed complex test scenarios for database validation and integration.
• Researched, analyzed, and tested star scheme data models.
• Created test data for all mapping rules to test the backend functionality.
• Used SpiraTest as repository for maintaining test cases, UAT test plans and tracking the defects.
• Extensively used Informatica power center for extraction, transformation and loading process.
• Used PL/SQL Developer to write and automate SQL queries for Data Migration and Data testing.
• Ensured dat migrated data is complete, accurate and correct from Oracle database.
• Worked closely with the application development and design and testing team to resolve technical issues and interacted with them to ensure overall quality of the software.
• Manually performed Back-End testing by writing SQL queries and validating the database using Complex SQL Joins and Functions.

Environment: Informatica 9.1/9.6/10, Oracle 11g/12c, HP Quality Center 10, SPIRA, PL/SQL Developer, QBIC, Flat files, XML

Confidential, IL

ETL/QA Tester

Responsibilities:

• Designed and executed various Test scripts for System testing based on the Functional Design Document.
• Assisted in gathering the business requirements, ETL test and design of the flow and the logic for various Data warehouse and Claims Projects.
• Conducted various system, Integration, and regression testing sessions for Salesforce Health Cloud Integration
• Wrote SOQL queries to validate data loaded into Salesforce Cloud.
• Wrote complex SQL queries between source and target for validating ETL jobs.
• Reported bugs and tracked defects using HP ALM/Quality Center.
• Automated and scheduled the Informatica jobs using UNIX Shell Scripting.
• Tested SQL queries to validate the data and performance of the database.
• Executed SQL queries using TOAD to query Oracle database. Prepared test strategy to validate Teradata reports against Oracle reports.
• Developed Data warehouse ETL test cases for various lines of businesses based on ETL mapping document.
• Participated to create Test Analysis reports (TAR) and stored them into the Quality Center.
• Updated RTM in daily, send status report and daily tracking report to test manager.
• Performed UAT testing in the UAT environment prior to notify to the customer to start performing UAT testing.
• Used DWH ETL for testing and supporting data extraction, transformations and loading processing in a corporate-wide-ETL Solution using Informatica.
• Wrote SQL Statements in database to make sure whether the data is populated in Data Mart/Data warehouse According to Business Rules.
• Coordinated with stakeholders to make sure testing criteria are met.

Environment: Informatica, Oracle 11g/10g, Salesforce Cloud, Salesforce Object Query Language, HP ALM/Quality Center 10, Sql server 2008, UAT, TOAD, SQL, UNIX, Agile, Cognos, Jira 1

Confidential

QA Tester

Responsibilities:

• Analyzed the Business Requirements and Rules and worked with business Analysts and Business Users in preparing Test Plans.
• Developed Test cases, Test scripts from the data mapping documents, functional Specification documents and mapped the test cases with the requirements for generating the Requirement Traceability Matrix (RTM).
• Closely went through and worked on all the stages of SDLC for this project and designed and executed Functional, Integration, Regression and System (End to End), UI Testing, Browser Compatibility, Backend (Database) Testing.
• Tested several packages developed using SSIS.
• Extensively worked on designing various output and management reports Using SQL Server Reporting Services (SSRS).
• Validated many SSAS cube data against the dimension and facts.
• Performed data analysis and data profiling using SQL and Informatica Data Explorer on various sources systems including Oracle and Teradata.
• Analyzed the data mapping and developed scenarios to verify the data migration. Validate the Data Mart tables to check the data TEMPhas been populated correctly.
• Tracked the progress of the defects till end of the defect life cycle, used HP Quality Center for defect tracking and maintained the workflows and trail history of bugs using HP Quality Center.
• Tested report Model on SSAS Cubes as well as changing default configuration on existing Cubes.
• Manually performed Back-End testing by writing SQL queries and validating the database using Complex SQL Joins and Functions.

Environment: Informatica 9.1, SSIS, SSRS, SSAS, Oracle 11g/10g, SQL Server, HP Quality Center 10, Sql server 2008, UAT, TOAD, UNIX, Agile,