SUMMARY

• Around eight Years of IT Experienced in Prepared documentation such as business requirements and functional specifications based on business needs and used the information to develop detailed comprehensive test strategies to verify system changes to meet the needs of the client.
• Good testing experience in healthcare and banking domains.
• Expertise on OLAP/BI tools like Tableau, Cognos, Business Objects, Microstrategy, and OBIEE.
• Experience in Data Analysis, Data Validation, Data Modeling, Data Profiling, Data Verification, Data Mapping, Data Loading, Data Warehousing/ETL testing and BI Reports Testing
• Good understanding of Data warehousing, ETL in SSIS to perform Source to Target testing.
• Having Experience in building visualizations and Dashboards using the various versions of Tableau suite like Tableau Desktop, Server, Public and Reader.
• Having good Experience on ETL code optimization, ETL performance enhancements and code reviews.
• Experience in Extraction/Transformation/Loading of the legacy data to Data Warehouse using Informatica.
• Validated reports developed in OBIEE, Tableau.
• Involved in development of Hybrid Test Framework using Selenium WebDriver and TestNG.
• Performed Back End Testing by executing SQL queries.
• Involved in maintaining Test Matrix and Traceability Matrix and performed Gap Analysis
• Performed User Acceptance Testing (UAT) manually.
• Good Documentation and Process Management skills with an ability to effectively understand the business requirements to develop a quality product.

TECHNICAL SKILLS

TESTING TOOLS: Load Runner, QTP, Web Services, SOAPUI

BUG REPORTING: HPALM/Quality Center, CQTM, JIRA

REQUIREMENT MGMT TOOLS: Rational Requisite Pro

PROGRAMMING LANGUAGES: SQL, TSL (Test Script Language), VB Script

RDBMS: Oracle, MS Access, SQL Server, DB2

DATABASE TOOLS: Data Warehouse, ETL, Informatica, Cognos

OPERATING SYSTEM: Windows, UNIX/LINUX

WEB TECHNOLOGIES: J2EE, JAVA, HTML, XML,.NET, ASP.NET, HTML, BEA WEBLOGIC, BEA WEBLOGIC PORTAL FRAMEWORK

PROFESSIONAL EXPERIENCE

Confidential, Arlington, TX

Sr. ETL Data QA

Responsibilities:

• Responsible for testing of complete life cycle of OBIEE reports, testing OBIEE repository at three layers (Physical, Business model and Presentation Layers), Interactive dashboards and drill down capabilities using global and Filters and security setups, Data Mart.
• Performing web analytics, data extraction, data analysis using SQL and Tableau software for visualization
• Involved in testing the OBIEE reports by writing complex SQL queries
• Extensively involved in Developing Test Plans, Test Scenarios, Test Strategies and Test Cases with inputs from the assigned Business Analysts.
• Manage all tech OBIEE releases across the business unit
• Daily support, troubleshooting, monitoring, optimization and tuning of server and SQL server environments across entire system
• Involved in PL/SQL code review and modification for the development of new requirements.
• Created batch files that execute the ETL scripts which invokes SSIS packages.
• Designed and developed several data stage jobs to extract data from Epic Clarity source system (Oracle) and load to highly normalized EDW (DB2) (built using IBM Atomic Warehouse Model AWM) with intermediate steps landing data as - is from source, staging the data in a format that is similar to AWM model.
• Perform Catalog migrations as part of OBIEE releases.
• Performance and Tuning on MS SQL Server. (Optimization of Queries and Server itself)
• Analyze, design, develop, code, test, and maintain Business Intelligence reports and Dashboards using Oracle Business Intelligence Enterprise Edition (OBIEE), Google analytics and Tableau that enables fact-based decision making, analysis, and insight generation.
• Designing and Modifying Materialized Views, Views with preferred granularity of the data and aggregating data needed for Tableau Reports and producing executive level tableau dashboard visualizations for senior management.
• Responsible for testing packages using Informatica (ETL) to verify data completeness, data transformation, data quality, integration testing, UAT & regression testing.
• Develop and design data modeling concepts using OBIEE tools
• Low/mid-level SQL code review and querying
• Work with the team to Increased software speed through SQL Server optimization.
• Use SQL server management studio for data analysis and SSIS tool for ETL on a daily basis.
• Used T-SQL scripts in Oracle database to validate functionality.
• Performed Back office SQL code review on written stored procedures and functions Additional and secondary responsibilities
• Manage multiple contract tracking worksheets and reports generation through Excel and Tableau
• Converting Data to export into SQL Server using SSIS
• Implemented Write back functionality to update or insert the data into the tables in the database in OBIEE.
• Used senior level SQL query skills (Oracle and T-SQL) in analyzing and validating SSIS ETL database data warehouse processes.
• Reviewed Tableau visualizations and dashboards using interactive filters from different data sources
• Responsible for validating reports in OBIEE and TABLEAU by writing complex SQL queries in TOAD.
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
• Executed parallel browser testing on various machines using Selenium Grid and performed cross browser testing.
• Designed and built Selenium Automation framework using Page Object model
• Wrote Complex SQL queries to validate the standard reports, Dashboards and Business objects Universes.
• Use T-SQL to write ETL processes to import data from various sources into MS SQL Server tables.
• Involved in validating SSIS and SSRS packages according to functional requirements.
• Involved in testing designing and development of Data warehouse environment.
• Worked on Tableau BI tool to create dashboards for client analysis.
• Tested the report generated by OBIEE and verified and validated the reports using SQL.
• Validated the Insurance claims data using SQL queries in Backend Testing

Environment: SQL Server optimization, T-SQL, Business Objects, Quality Center/ALM, Rational Clear Quest, Rational Clear Case, SQL SERVER, SSIS, XML, Toad for Oracle, ORACLE, Unix, Autosys, Hyperion, DB2, Teradata, Windows, MS Excel.

Confidential, Cranston, RI

ETL QA Analyst

Responsibilities:

• Wrote complex T-SQL queries to validate the ETL process and verify the accuracy of data loads into the Data Warehouse
• Building drill down dashboards, detailed tabs, spark line trends for weekly, monthly and creating SLA charts like bar chart, Crosstabs and using powerful visualizations in tableau, meeting the business needs.
• Used Hybrid Framework of Selenium to get data from Excel.
• Assisted in SQL Server optimization including indexing and query optimization
• Responsible for testing all new and existing ETL Data warehouse components.
• Effectively utilized Tableau features like parameters, calculated fields, filters to provide efficient data visualization solutions to the customer.
• Quality Assurance - T-SQL Code Review and Analysis
• As a member of QA team, participate in change management approval process including SQL code review.
• Extensively used Informatica power center for extraction, transformation and loading process.
• Extensively tested several ETL Mappings developed using Informatica.
• Used Tableau desktop to perform Data Acquisition and Data Profiling by identifying various different data sources
• Designing and creating SQL Server tables
• Worked with data analysts to implement Informatica mappings and workflows, shell scripts and stored procedures to meet business requirements.
• Successfully implemented automation using Page Object Model design pattern to reduce the test script.
• Created Test Plans and Scenario which describes the features and functions to be tested.
• Detected, reported and tracked defects using ALM/Quality Center.
• Arranged meetings with the Project Teams to discuss the test approach used for the Data Conversion and ETL modules
• Created ETL test data for all ETL mapping rules to test the functionality of the Informatica Mapping
• Worked with the components of Data Warehousing like components model, ETL tools.
• Tested the different sources such as Flat files, Mainframes Legacy Flat Files, DB2 and Oracle to load into the Oracle Data warehouse.
• Tested the ETL Ab Initio graphs and other ETL Processes (Data warehouse Testing)
• Actively participated in the weekly Project Status Meetings.
• Involved in writing Test scenarios, Generic tests cases, detail Positive and negative test cases for ETL also Preparing ETL and SQL routines/code for performing ETL testing (system and integration testing) and Documenting the test results
• Execute the Selenium Scripts through Spec Flow framework and shared the results across the stake holders

Environment: Java, J2EE, .NET, C#, Cognos, Oracle, Enterprise Data warehouse, ETL, SSRS, Informatica, SQL Server, PL/SQL, XML, ALM Quality Center, QTP, Etc.

Confidential, Dayton, OH

QA Tester/Data Ware House Analyst

Responsibilities:

• Analysis of Business requirements & Design Specification Document to determine the functionality of the ETL Processes.
• Participated in Manual and Automated testing of the various modules of the software application program for efficiency and MicroStrategy BI Reports.
• Created test plans, conditions, scripts, and test data; performed product testing, user acceptance, remote user testing, usability standards validation, and performance testing; and resolved system defects.
• Responsible for testing all new and existing ETL Data Warehouse components.
• Developed mappings in Informatica to load the data from various sources into the Data Warehouse
• Performed various types of testing such as Functional, Regression, SIT, UAT, Back end etc.
• Performed Data Validation of the data flow from the front-end to the back-end by executing SQL scripts.
• Performed Data Profiling of current state of data in the Data Warehouse by doing Data Analysis using advanced SQL Queries and Microsoft Excel, finding Gaps in Data and formulating solutions for the same
• Performed query operations to do database validation. Used standard SQL functions and commands
• Used SQL queries to validate the data between the back end and the front end

Environment: Oracle, ETL, Informatica, Data warehousing, Teradata, Toad, SQL Server, PL/SQL, XML, Quality Center, Etc.