SUMMARY:

• 7+ years of Professional experience in ETL Testing, Manual testing on Web based, Client/Server and Data Warehousing applications and Business Intelligence processes .
• Experience using query tools for querying various RDBMS like Teradata, Oracle 12c/11g, DB2 and MS SQL Server 2012/2008 to validate business reports and troubleshoot data quality issues.
• Solid Back End Testing experience by writing and executing SQL Queries.
• Experienced in both Waterfall and Agile Development Methodology and building Agile Test Processes .
• Experience in integration of various data sources such as flat files, ASCII, EBCDIC files, legacy data, and heterogeneous RDBMS.
• Experience in working on Hadoop components like Hive, Sqoop, PIG and Hive.
• Proficient in Functional, Negative, Regression, System, Integration, Security, Usability and compatibility testing during the various phases of the development of the application
• Performed Black box testing, white box testing, and ETL/ELT data flow testing.
• Experience in writing automated tests using Informatica DVO tool.
• Experienced in working with Business Users, Business Analysts, IT leads and Developers in identifying and gathering Business requirements to further translate requirements into functional and technical design specifications.
• Involved in Reports testing Validated the data derived in the target table is adhering to the standards and business rules. Played major role in Test Data Creation and Maintenance. Verified if there are any downstream impacts in the warehouse.
• Comprehensive knowledge of Ralph Kimball’s data modeling concepts including Dimensional Data Modeling and Star/Snowflake Schema Modeling.
• Experience in Business Intelligence testing in various reports using Cognos, OBIEE, SAP Business Objects, Tableau and Crystal Reports.
• Excellent Domain Knowledge in Financial, Banking, Telecom and Healthcare.
• Has expertise in Test Case Design, Test Tool Usage, Test Execution, and Defect Management.
• Excellent knowledge of defect management and tracking using HP ALM and Quality Center .
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate - wide-ETL Solution using Informatica & Ab Initio.
• Good experience in Microstrategy, Cognos and Business Objects for report testing.
• Expertise in Testing complex Business rules by creating mapping and various transformations.
• Experience in testing XML files and validating the data loaded into staging tables.
• Experience in testing and writing SQL and PL/SQL statements.
• Coordinated testing efforts and effectively managed with offshore teams.
• Excellent Analytical, Decision-making and Organizational Skills along with effective Interpersonal and Communication.

TECHNICAL SKILLS:

Platforms: UNIX, Linux, Windows (NT, 2000, XP, 2003, Vista, 7, 10), Macintosh, MS-DOS

Programming languages: C/C++, SQL, PL/SQL

Database systems: MySQL, Oracle 12c/11g, Microsoft SQL Server 2012/2008, Teradata, DB2

Big Data Tools: HIVE, PIG, SQOOP, HBASE

Tools and Utilities: SQL Navigator, Toad for DB2/Oracle, SQL Developer, Teradata SQL Assistant

Defecttracking/Test management software: JIRA, HPALM 11.0/HP Quality center 10.0, TFS

ETL Tools: DataStage, Informatica 9.6/9.1, DVO, Ab Initio GDE & Co>op 2.14, SSIS

BI Tools: Microstrategy 9.2.1, OBIEE 12.x, Cognos, Tableau, SAP BW/Business Objects XIR2/XIR3

PACKAGE MS Office: Word,Excel,Power Point, Outlook, Acces

PROFESSIONAL EXPERIENCE:

Sr.etl qa

Confidential, BOSTON, MA

Responsibilities:

• Responsible for writing Test plan and created Test cases based on BRD/Mapping docs etc.
• Performed Functional Testing and Back-end Testing using the database comparable results Manually
• Tested the messages published by Informatica and data loaded into various databases
• Tested the data load process using the Informatica Power Center 9.6.
• Validating the data that is processed and stored in Hive tables by running Hive queries.
• Generated/Tested reports using free-hand SQL which had complex Business Logics for testing environment.
• Was involved in analyzing scope of Testing the application.
• Validated the archived jobs using DVO (data validation tool)
• Expertise in Creating Adhoc and Complex Reports in Microstrategy Desktop using features like templates, custom groups and consolidations.
• Expertise in gathering requirements from business users to build future application as per defined Micro Strategy standards.
• Involved in validating various SSIS and SSRS packages according to functional requirements.
• Loading Flat file Data into Teradata tables using Unix Shell scripts
• Updated the status of the testing to the QA team and accomplished tasks for the assigned work to the Project Management team regularly.
• Created the test data for interpreting positive/negative results during functional testing.
• The reports that were created in Business Objects were testing by running the SQL statements against the tables in the Oracle Database.
• Implemented Data Validation Option (DVO) for understanding on how to run tests, and evaluated the test results.
• Used HP ALM 11.0 for Bug Reports and Defect Tracking.
• Involved in weekly Defect review meetings and performed Risk Analysis based on Defect Severity and Priority.
• Developed test scenarios for testing Enterprise Data warehouse and Credit Data Mart data in Oracle Environment.
• Wrote SQL scripts in TOAD for Oracle and Teradata SQL Assistant for Teradata
• Worked autonomously within a team of Data Analysts, to analyze, review, update, edit, clean, translate and ensure accuracy of customer data.
• Worked with Data Extraction, Transformation and Loading (ETL).
• Performed System Integration Testing and Integration Testing between different modules.
• Heavily involved in interacting with UNIX Shell scripts.
• Performed data validation and preparation of test data in UNIX environment using various UNIX commands and editors.
• Exclusively used Analysis Studio and Report Studio to test the Tableau Reports.
• Analyzed Business Requirements and Developed the Test Plan, Test Scripts and Test Cases
• Developed Test Plan and Test Cases for the entire module of Data mart.
• Ran test cases for the warehouse in Oracle.
• Worked with drill down, prompts, hierarchies, calculations, formulas, sorts, drop down list, breaks etc. in reporting and validated the same.
• Worked with business team to test the reports developed in Business Objects.

Environment: HP ALM 11.0, Informatica 9.6, DVO, Microstrategy, Teradata, Tableau, SSIS, Pig, Hive, HBASE, Oracle 12c, UNIX, SAP Business Objects, QTP, SQL, Agile, Toad for Oracle, MS Office, XML

ETL QA

Confidential, PHILADELPHIA, PA

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 PL/SQL procedures that were developed to load the data from temporary tables in staging to target tables in the data warehouse
• Worked on DVO data validation tool to validate the data accurately.
• Tested the ETL with XML as source and tables in the data warehouse as target.
• Provided support to offshore QA team by giving them knowledge transfer and helping them with closure of the defects.
• Used Datastage as an ETL Tool for Developing the Data Warehouse.
• Performed data validation on the flat files that were generated in UNIX environment using UNIX commands as necessary.
• Experience in MicroStrategy Report development, Report testing, Report tuning, Ad-hoc, scheduling report delivery and Alerts and also experienced in maintain and modify existing projects, applications and reports as required.
• Experienced in MicroStrategy Report Services, Dynamic Dashboards, Freeform SQL, Query Optimization, Project Schema, and Micro Strategy Server Administration.
• Responsible for different Data mapping activities from Source systems to Teradata
• Tested customized and OBIEE reports with Metrics and Filters for Business analysis using Desktop intelligence with features of Drilling options drill up, drill down and drill anywhere .
• Wrote Automation test cases and executed it according to the application.
• Wrote very complex SQL to validate several BI Reports. Involved in testing data migration.
• Involved in User Acceptance Testing (UAT).
• Involved in Teradata SQL Development, Unit Testing and Performance Tuning
• Tested the XMLs feeds received from another source which is a third party for data consistency.
• Performed the functional testing, integration testing, system testing and regression testing on the application thoroughly executing the manual/automation testing scripts/test cases.
• Tracked defects to closure by coordinating with the dev team.
• Tested source data for data completeness, data correctness and data integrity.
• Performed End to end testing starting from the source to the report.
• Executed SQL queries for validation of data and used TOAD for SQL Server to write SQL queries for validating constraints, indexes
• Tested Complex Reports in OBIEE functionalities like Slice and Dice Drill down Functions Cross Tabs Master/Detail and Formulae
• Conducted and coordinated integration testing and regression testing.
• Participated in business requirements gathering and in modifications of the requirements based on the scope
• Worked with the DATA team to understand the source to target mapping document and accordingly helped them to clean the source data to decrease the defects and to ensure that final data matches with the data warehouse standards.
• Prepared test data to cover all the test scenarios.
• Maintained all the test cases in HP ALM and logged all the defects into the defects module.

Environment: Informatica 9.1, DVO, MicroStrategy, SSIS, HP Quality Center/ALM, UAT, Tableau, SAP BW, Oracle 11g, QTP, OBIEE, Java, SQL Server, PL/SQL, Teradata, TOAD, MS Office, Unix, SOAP UI, XML, SQL Developer

Database tester

Confidential, FOSTER CITY, CA

Responsibilities:

• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
• Clearly communicated and documented test results and defect resolutions during all phases of testing.
• Simulated several production cycles. Worked with data validation, constraints, record counts, and source to target, row counts, random sampling and error processing.
• Performed Testing, Data Integrity Testing and end to end testing
• Involved in Developing Test Plans and Developed Test Cases/Test Strategy with input from the assigned Business Analysts
• Involved in testing of source for data completeness from different data sources like Oracle/SQL Server.
• Worked with appropriate business and technology leads to determine the acceptable range for test results and performance.
• Used Microstrategy tool reporting and data analysis of data stored in relational database, multi dimensional and flat files.
• Tested the ETL process for both before data validation and after data validation process. Tested the messages published by ETL tool and data loaded into various databases.
• Worked on profiling the data for understanding the data in source and mapping document.
• Written PL/SQL procedure and functions to test certain patterns in data and then to update the data as per business rules
• Tested database & UNIX Scripts needed to meet the system requirements.
• Optimized SQL queries for better performance during testing.
• Tested several business reports including Score Cards, KPI's, Summarized, Master-Detailed and Drill Down reports developed by Microstrategy
• Performed day to day migrations of various Informatica objects using export-import option for testing of new functionality
• Written several UNIX scripts for invoking data reconciliation.
• Involved in extensive data validation using SQL queries and back-end testing
• Used SQL for Querying the DB2 database in UNIX environment
• Prepared and ran regression scripts, shell scripts and performed sanity tests and end-end testing.

Environment: SQL, PL/SQL, HP Quality Center 10.0, SSIS, SAP BW XML, QTP, UFT, UNIX, Data Centric Oracle 11g, DataStage, Microstrategy, DB2, SQL Navigator

quality analyst

Confidential

Responsibilities:

• Review the functional requirements and ensure the testability, SOX compliance for the same
• Developed the test strategy for ensuring QA of Pinnacle points advance reporting
• Review the mapping documents and develop test cases and test scripts accordingly
• Ran SQL queries to verify the number of records from Source to Target and validated the referential integrity, Time variance, Missing records, and Nulls/Defaults/Trim spaces rules as per the design specifications.
• Written complex SQL queries for several business scenarios to validate the data across source and target system
• Validate the data being transformed via (ETL) Ab Initio
• Developed SQL queries to verify the data loaded into the target tables.
• Work as part of the team in execution and defect life cycle process
• Develop QA progress reports, bug reports, analyze risks on a daily, weekly and monthly basis
• Responsible for coordinating off-shore and On-shore Test resources.
• Performed Unit, Integration, and Regression and UAT Test phases.
• Tracked QA process, reported defects and status of the defects in HP Quality center 10.0.

Environment: HP QC/ALM, UAT, Ab Initio, SQL, PL/SQL, Unix, Oracle 10g, JIRA, Teradata SQL Assistant, Cognos