Sign in

Manaul QA Tester

Denver, Colorado, United States
Market Rate
May 17, 2019

Contact this candidate



QA Tester



Overall 7+ years of Experience in Data warehousing/ETL/QA testing with extensive usage of SQL, UNIX, shell scripting.

Involved in all the phases of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC) and testing methodologies

Familiar with standard Software Engineering processes including hands-on knowledge and experience on the UML methodologies.

Good experience in data sources, data profiling, data validation, developing low level design patterns based on the business and functional requirements.

Expertise in understanding the business process from taking a requirement from a system record to a centralized warehouse.

Very good understanding of Data warehousing concepts, Data Analysis, Data warehouse architecture and designing.

Strong expertise in Data analysis, Data Cleansing, Data Scrubbing, Data mapping, Data modeling and development of Databases for business applications in client/server applications and Data warehouse environments

Experience in dealing with different data sources ranging from Flat files, SQL server, Oracle, My SQL, MS Access and Excel.

Solid experience in Back-end testing experience in writing and executing SQL Queries.

Extensive experience in creating and maintaining source to target data mapping documents.

Experience in designing the database and data elements associated with the database.

Worked on managing large and complex data sets, extracts, clean and format data for Data Analysis using MS Excel, MS SQL etc.

Extensive Working experience in applying Relational Database concepts, Entity Relation diagrams and Normalization concepts.

Involved in the ETL processes where in the Organizations were using Data Stage, Informatica, and Autosys tools.

Automated and scheduled the Data loading jobs for Informatica using UNIX/Shell scripting.

Experience in testing Business Intelligence reports generated by various BI Tools like Cognos and Business Objects

Experienced in gathering requirements, creating Use-Case design and analysis and specifications, Scenarios, Workflow diagrams, process flows and technical documentation, using Unified Modeling Language (UML), MS Office Suite, and Rational Suite.

Expertise in writing, maintaining, and executing test plans, test cases and test scripts, analyzing bugs and interacting with team members in fixing the errors.

Experience in business Data modeling, Data warehousing, Software requirement analysis, Process modeling, Process flow and Quality assurance skills using different methodologies, mainly OOA, OOAD and UML SDLC: In depth strong working knowledge of the Software Development Life Cycle (SDLC) phases such as Planning, Analysis/Design, Development, and Testing for the software/system development process.

Extensively worked on MS Access, MS Excel, Power Design, MS Visio, MS PowerPoint, MS Project, and SQL.


SDLC Methodologies

RUP, Agile, Hybrid

Requirement Management Tools

Rational Requisite Pro, MS Project


SQL Server 2008/2005/2000/7.0/6.5, Oracle9i/8i, DB2, MySQL, MS Access,

Teradata, Sybase

Data modeling tools

CA ERwin 4.O, Sybase Power Designer, Rational Rose, MS Visio

Version control System

Rational clear case, PVCS, Power Point, VSS

Operating Systems

Windows95/98/00/XP and NT, Linux, Unix, Mac OS

Rational Tools

Rational Clear Quest, Rational Test Manager and Rational SODA

Testing Tools

Test Director, Mercury Quality Centre, QTP (Quick Test Professional), Win Runner, Load Runner

Reporting Tools

Crystal Reports, Business Objects XIR2, Cognos 8.0 Series (Cognos Configuration, Framework Manager, Cognos connection, Query studio, Report studio)

Web Technologies and Servers

HTML, AJAX, XML, PHP, APACHE, MS IIS, Web Logic 8.0, IBM WebSphere7.x


IBM Watson Health, Denver, CO Nov 2018 -Till Date

Sr.QA/UAT Tester--- BI Tester


Extensively worked on Report studio to build different kinds of reports like Grouped list reports, crosstab, chart, Drill through reports, burst reports, Dash boards with multiple tables.

Worked on Query studio for adhoc reporting.

Involved in testing the report against the database.

Set up the Security at the package level, query subject level and the query item level. Customized data by adding prompts, Filters, Calculations, Summaries and Functions.

Perform requirements gathering for Medicaid claims, process and review Medicaid claims to identify the billing practices.

Handle the tasks of identifying UAT testers and managing resource plan by coordinating with business stakeholders

Created public folders, private folders, personalized pages and custom views on the Cognos connection portal.

Distributed the reports to the users via Cognos Connection.

Created and executed test cases, test scripts based on ETL Mapping document.

Involved in Data migration from Data stage to Informatica.

Page explorer, query explorer and variable explorer were used to manage the content of the reports

Performed various calculations on the Report Studio Reports.

Extensive use of complex SQL Queries in writing test scripts using multiple joins, case statements.

Performed ETL Data Validation, Testing functionality of mapping by preparing test data for all ETL mapping rules by loading data from various sources using Informatica Power Center.

Tested ETL process (Data Loading, Extraction and transformations) using Informatica.

Tested/Found the defects in Backend DWH staging tables, Facts and Front-end Cubes and reports.

Created cascading prompts in some of the reports to meet the functional requirement.

Create mapping using Informatica Data Quality to cleanness data and feed into tables.

Responsible for developing UAT test process and monitoring SIT execution phases

Worked with Department Medicaid stakeholders to gather requirements in JAD session identified them As Is and To Be processes. Identify and Create Test Cases and Scenarios

Written several shell scripts using UNIX Korn shell for file transfers and clean up process

Wrote unit test (SQL queries) queries and unit tested the reports using SQL Navigator to check the validity of the data.

Reported defects using HP ALM Verified fixes and closed bugs during regression testing.

Prepared manual test scripts covering different scenarios and documented in Mercury Quality center

Involved in extensive DATA validation using SQL queries and back-end testing.

Extensively used SQL queries for Database testing and Validation

Involved in all business meetings for understanding all the business logic.

Tested the entire data reconciliation process for multiple source and target systems.

Used HP ALM to Report, track and, monitor defects.

Handle the tasks of ensuring that the Pre-UAT activity is performed accurately and efficiently

Written SQL scripts to test the mappings and extensively used Cognos for report generation

Extensively tested several Cognos reports for data quality, fonts, headers & cosmetic.

Involved in testing Cognos Reports and closely worked with operations, and Release teams to resolve the production issues.

Involved in conducting extensive User Acceptance Testing (UAT)

Involved in testing the Cognos reports by writing complex SQL queries.

Prepared extensive set of validation test cases to verify the data.

Environment: HP ALM, SQL, PL/SQL, UAT, SOAP UI UNIX, Cognos, Linux, IBM AIX 5.3, IBM DB2 8.2, Oracle 11g, SQL Server 2008, XML, XSD.

State of Mississippi, Jackson MS Jun 2017– Oct 2018

QA BI Tester


Analyzing business process requirements and business scenarios and created the User profiles review and involved in the Users requirements discussions and technical documentation review

Tested and validated the cube data, ensuring that the data is correct by comparing the data results to comparable source system reports or by querying individual transactions and forms.

Performed Verification, Validation, and Transformations on the Source data before loading into target database.

Validated by checking that the summary records in the cube equal the total of the detail records in the report when queried using the same parameters.

Tested several complex reports generated by Cognos including Dashboard, Summary Reports, Master Detailed, Drill Down and Score Cards.

Tested PL/SQL Programs to prepare and clean Data for data migration and to retrieve data from the database to compare against the input sets

Reported defects using Jira and verified fixes and closed bugs during regression testing.

Written complicated of SQL queries for data validation and data verification based on data mapping document.

Focused on Data Quality issues / problems that include completeness, conformity, consistency, accuracy, duplicates and integrity.

Performed data validation by writing SQL queries and creating ad hoc reports using desktop intelligence and web intelligence.

Used Jira to Report, track and, monitor defects.

Used SOAP UI for checking the correct transmission of data and to test web services

Created test cases and test scripts for UAT

Involved in creating the test data for generating sample test reports before releasing to production

Developed tables, Views, Stored Procedures and Triggers using SQL Scripting.

Established Inner Join, Outer Join and created Indexes whenever necessary.

Responsible to meet the information demands of our business users by delivering timely, accurate, meaningful and standardized data and reporting.

Worked with reconciliation process for exact count on source, target and reject records.

Performed quality control analysis and validates results of conversion programs. Used extensive SQL query. Evaluated actual data load results. Involved with high volume testing.

Personalized Cognos Connection for specified display options for testing regional options and personal information.

Used Sybase Power Designer for relational database and dimensional data warehouse designs.

Involved in testing procedures, functions, packages and triggers as a part of backend testing using Toad

Used SOAP UI for checking the correct transmission of data and to test web services

Prepared the guides for UAT (User Acceptance Testing)

Day-to-day Cognos administration activities like monitoring Scheduled jobs like Cube refresh, Impromptu scheduled reports, Backup and recovery maintenance.

Worked on profiling the data for understanding the data and mapping document.

Prepared and ran regression scripts, shell scripts and performed sanity tests and end-end testing.

Functioned as the primary liaison between the business line, operations, and technical areas throughout the project cycle. Prepared project reports for management and others, assisted project managers in the development of weekly and monthly status reports, documented process flows, policies and procedures.

Environment: Cognos, SQL, Jira, PL/SQL, UAT, SOAP UI, UNIX, Linux, IBM AIX 5.3, Sybase, IBM DB2 8.2, Autosys, Oracle 10g, SQL Server 2008, SSAS, XML, XSLT, XSD, XML Spy 2008.

Barclays Bank, Wilmington, DE Apr 2016 – May 2017

QA Analyst

Roles & Responsibilities:

Tested the data and data integrity among various sources and targets. Associated with Production support team in various performances related issues.

Tested various facts and dimensions in the data mart including fact less facts, aggregate and summary facts.

Tested Target Load Order Plan and Constraint based loading for loading data correctly into different Target.

Have participated in Test planning, designing test cases, test execution, error reporting, analysis and error.

Have experience in developing tests in Eclipse to start and to stop the selenium server and to execute the tests in browser.

Element locators and Selenium Web Drivers are being used in order to create test cases.

Created Test Plans and Test Cases at different levels of testing to test the application using functional testing, unit testing, integration testing, regression testing, GUI testing, back-end testing, browser compatibility testing, and component testing on Windows.

Performed GUI validations on menu bars, toolbars, textboxes, radio buttons, checkboxes, drop down lists, combo boxes, list boxes using Selenium and Appium for both Web and mobile platforms.

Developed new and updated existing Automation test cases using Selenium Web Driver and TestNG, using SVN for java-based web application, using Maven as Build tool.

Responsible in Performance testing, debugging, executing, analyzing complex applications using HP Load Runner and HP ALM.

Coded UI using C# was used to develop Functional, UI and Regression test cases.

Used Jenkins as continuous integration server to run automated test suites.

Used TestNG framework for creating Selenium scripts with Data Driven Framework.

Used Quick Test Professional (QTP) for regression testing and running the automation suite.

Tested the backend database using SQL queries.

Executed SQL queries to verify the database for the relevant test cases.

Validating Web service modules using Soap UI tool (Preparing web service request and added authentication information in Soap Header) Possess understanding of WSDL, schema, XML documents for Web Service Testing.

Participated actively in the team meetings with the Developers for fixing the bugs.

Attended Daily Scrum meeting with team leads, managers, system analysts and business analysts to discuss the status, blockers and issues found during various testing process.

Environment: Selenium (WebDriver), Java, QTP, SQL, WebDriver, Quality Centre ALM, HTML, Cucumber, SQL, Maven, TestNG, SVN, SOAP, Restful, Appium, VB Script.

Infodat Technologies, India. Oct 2013 – Dec 2015

QA BI Tester

Roles & Responsibilities:

Develop test plans based on test strategy. Created and executed test cases based on test strategy and test plans based on ETL Mapping document.

Tested various facts and dimensions in the data mart including fact less facts, aggregate and summary facts.

Tested Target Load Order Plan and Constraint based loading for loading data correctly into different Target.

Did Data integration testing on extracted data from various sources like Oracle, flat files and SQL Server.

Tested several complex ETL mappings, mapplets and reusable transformations for daily data loads.

Worked with ETL group for understating mappings for dimensions and facts.

Collaborated with the QA team to ensure adequate testing of software both before and after completion, maintained quality procedures, and ensured appropriate documentation is in place.

Prepares and submit the summarized audit reports and taking corrective actions

Responsible for planning, development, execution and management reporting of end-to-end and External Trading Partner test scenarios for Department Medicaid business.

Involved in Uploading Master and Transactional data from flat files and preparation of Test cases, Sub System Testing.

Involved in testing the Cognos reports by writing complex SQL queries

Document and publish test results, troubleshoot and escalate issues.

Involved in Relational modeling and Dimensional Modeling Techniques to design ER data models and Star Schema designs.

Support testing for the Enterprise with specific focus on ICD-10 testing for the end to end testing of the department of Medicaid.

Validated all the fields and values of all the submitted, uploaded and downloaded date in XML, XLS and CSV files to ensure the system has populated all data correctly in SOAP UI to reflect the Data Model

Tested universes for supporting ad hoc queries and Invoice reports according to business requirement

Tested several stored procedures.

Develop backup & restore scripts for SQL Server as needed.

Created Drill up/Drill down reports, Master Detail Reports and responsible for writing the queries and tuning the queries, Registered PL/SQL functions for using them in reports

Tested Simple reports Accounts by Category, Accounts by Products, Leads to Opportunities by Category, Opportunities by Product, Summary Quote, Print Quote Report, Service Request, Assets and leads report.

Identified the source tables, source columns, and referential joins in the entire Start Schema Model

Conducted UAT (User Acceptance Testing).

Environment: Oracle 9i, Cognos, UAT, Quality Center, XML, XSLT, XSD, XML Spy 2008, UNIX, Shell Scripting, IBM AIX 5.3, SQL, PL/SQL, MVS, COBOL II, JCL, ISPF, VSAM Files, XML Files, CSV, Data files.

Arise Software Solutions, INDIA Apr 2012 – Sep 2013

QA BI Tester

Roles & Responsibilities:

Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center

Performed Data Analysis of existing data through SQL.

Led & conducted JAD sessions to identify the flows and processes involved in the content.

Prepared project reports for management and others. Assisted project managers in the development of weekly and monthly status reports.

Involved in Data mapping specifications to create and execute detailed system test plans. The data mapping specifies what data will be extracted from an internal data warehouse, transformed and sent to an external entity.

Involved in Teradata SQL Development, Unit Testing and Performance Tuning

Created the test environment for Staging area, loading the Staging area with data from multiple sources.

Extraction of test data from tables and loading of data into SQL tables.

Written several shell scripts using UNIX Korn shell for file transfers, error log creations and log file cleanup process.

Written several complex SQL queries for validating Business Reports.

Validated cube and query data from the reporting system back to the source system

Responsible for Data mapping testing by writing complex SQL Queries using WINSQL

Experience in creating UNIX scripts for file transfer and file manipulation.

Validating the data passed to downstream systems.

Involved in testing data mapping and conversion in a server-based data warehouse.

Involved in testing the UI applications

Worked with business team to test the reports developed in Cognos

Tested whether the reports developed in Cognos are as per company standards.

Used Test Director to track and report system defects

Involved in testing the XML files and checked whether data is parsed and loaded to staging tables.

Worked on data quality, data organization and delivery.

Organized cross training of team members and users to become more responsive.

Environment: Oracle 9i, Cognos, Quality Center, XML, XSLT, XSD, UNIX, Shell Scripting, IBM AIX 5.3, SQL, PL/SQL, MVS, COBOL II, JCL, ISPF, VSAM, Data Profiler, Teradata V2R5.

Contact this candidate