Engineer Data

Sabiha Sultana

Quality Analyst

Summary:

Application, Product, Database and ETL Test Engineer (Integration, Functional, System, Regression and User Acceptance) over8 years of work experience in the phases of Software Development Life Cycle (SDLC), Software Testing Life Cycle (STLC) and Product Life Cycle Management (PLM).

Experience includes establishing strategic direction, methodologies and procedures for testing, Gathering requirements, documenting requirements, understanding functional requirements, collecting test data, preparing and executing test cases and defect tracking.

Testing Client – Server, Web applications, Windows Applications developed on various technologies.

Testing experience in Health Care and Storage Retail domains.

Proficient in HEDIS testing and Good Experience inETL testing (Informatica, SSIS), Database testing (Toad and SQL Server), Reports Testing (BO, MSTR), Web services testing, Mobile Applications testing.

Proficiency in customization and implementation of ETL processes for various types of Sources and targets.

Good exposure with various Life Cycle Models like Waterfall, ‘V’ model,and Agile Methodology.

Experienced in developing cost effective, re-usable, maintainable test plans and test cases in bothWaterfall and Agile methodology projects.

Extensively worked in Integration, Functional, System, Regression, User Acceptance, Smoke, White Box and Black box and Data driven testing.

Expertise in Test Planning, Test Cases Design, Test Environment Setup, Test Data Setup, DefectManagement, Configuration Management.

Proficient in different phases of testing like Functional Testing, GUI Testing, Regression Testing,Integration Testing, System Testing, Performance Testing, and User Acceptance Testing.

Well experienced in test planning, documentation, defining and executing the Test cases.

Expertise in preparing reviewing, documentation of detailed test plan specifications, creation and execution of test scripts, test scenarios, test cases, analysis and reporting of test results for manualtesting based on the User Requirement Document and System Requirement documents.

Experience in testing Web services, XML, and WSDL

Experience in testing database applications of RDBMS in Oracle, MySQL and SQL Server byexecuting SQL Queries.

Experienced using HP Quality Center, Application Lifecycle Management (ALM) for test casemanagement and execution.

Strong skills with Quality Center, JIRA and TestRail Debugging tool.

Experience in web services Testing using SOAP.

Experienced in close coordination with development team, business team in reporting the identifieddefects and escalating the critical issues appropriately in order for them to be resolved on a prioritybasis.

Expertise in analyzing User Requirements, Functional and Technical Specifications.

Excellent troubleshooting, project management and problem solving skills.

Strong design, analytical, problem solving skills and meeting stringent deadlines.

Possess ability to follow industry standards and best practices and procedures, work with the businesscommunity to understand the testing needs of the project.

Proficient with the Microsoft Office suite including Word, Excel, PowerPoint and Outlook.

Strong experience in interacting with developers to analyze the user requirements, functionalspecifications.

Excellent problem solving skills with strong leadership and good interpersonal skills.

Education

Bachelor of Technology from Shadan Women’s College of Engineering and Technology

Technical Skills

Operating Systems

Windows, Unix

Languages

C, C++, .Net, VB script, SQL

Testing Tools

Quick Test professional,Quality Center/ALM, Bugzilla, JIRA

ETL Tool

Informatica, SSIS

Reporting Tool

SAP Business Objects, MicroStrategy Reports

Web services

SOAP UI

Database

Oracle, Toad for Oracle, SQL Server

Project Details

Carefirst BCBS US, MD Sep 2019 toPresent

QA Engineer

EBill initiative will provide single consolidated online bills and settlements that will include all lines of business for Large Group fully-funded accounts. The initiative will also automate the billing process, and enhance statement format. Typically automates the process of sending the Admin invoice and Claims invoices to the groups with automated ETL load and report generation.

Analyzing requirements during the requirement analysis phase of the project, track new requirements and change requests and incorporate them into the testing phase of the application.

Reviewing documentation to understand testing requirements, test environments and objectives.

Participating with the business team in creating SERD documents

PerformingEnd to end testing - ETL testing to load the invoices and creating test data set up for running the ETL jobs.

Validating that data loaded is transformed as per the business requirements mentioned.

Validating that there is no missing data at each level of the database. Verify the record counts of source, stage and target tables.

Responsible for analysis of business requirements for creating test cases and scenarios.

Working under Agile environment and attended daily Scrum meetings with Project Manager, BA,and Development Team for defects and test plans discussion

Attending Scrum meetings to report any defects and issues encountered in application with offshore and on site team members

Analyzing the requirements and designed high level test scenarios and detailed test cases inExcel.

Creating Test processing transactions, performed UAT, System and Integration testing, Smoke,Sanity, Functional, End to End, Positive, Negative testing and monitored the behavior of theapplications during different phases of testing

Managing defect tracking processes (bug tracking and fixing, issue tracking, prioritizing, verifying)using JIRA.

Performing functional and database testing of the types of front end portals available.

Validating Source to Target data load and testing the MSTR reports for data correctness.

Testing MSTR Reports and designed SQL queries to test the data in the reports are valid.

Designing Test Plan, Test Cases for Data validation and Reports.

Reviewing the Test plan and test cases and present to the client for approvals

Conducting daily DRB calls with the Development team, Client and business team to track the status of the defects.

Setting up UAT and working with UAT testers collaboratively to set up the UAT environment. Provide working sessions to support the UAT team.

Preparing release notes for every release and work on production issues in a fast paced environment.

Cotiviti Inc US, MD Nov 2018 to May 2019

QA Engineer

The Healthcare Effectiveness Data and Information Set (HEDIS) is one of health care's most widely used performance improvement tools. Employers and individuals use HEDIS to measure the quality of health plans. HEDIS measures how well health plans give service and care to their members.

Health plans collect data about their performance on certain services and types of care. For instance, the plan keeps track of how many children get immunizations. They report the data to the National Committee for Quality Assurance (NCQA), which rates health plans based on 81 measures across five areas of care. Health plans use HEDIS to see where they are performing well, and where they need to improve. Employers and consumers can also use HEDIS measures when deciding what health plan to choose. Plans that meet a certain HEDIS score may become "accredited."

Installed the in-housetools(Medmeasures, MedCapture) on various servers and run tests through them.

Designed, created and tested data as per NCQA standards.

Responsible to set up Claims, Members, Enrollment, RxClinical and Observation files in a format compatible with ETL tool (Medmeasures)

Restored database with the test data for each run and setup QME and Web Manager on App and web servers respectively.

Performed manual smoke testing on pre-development kits by implementing black and whitetesting on components (unit) and integration testing.

Implemented short sprint cycles of Agile models of Testing, including the need for fast feedback,high visibility, and alignment with customer need.

Loaded the data on to Measure Analysis, Ran the batches and validated the results per measure and verified the consistency of data across multiple in-house tools.

Validated the Denominator, Numerator, Exclusion count per measure in Measure Analysis.

Used SQL queries to create test data for each of the input file through the given input parameters from NCQA

Created Data driven test cases made sure all the measure criteria have total test coverage and helped assigned Measure through certification.

Tested a variety of Hedis Measures from different domains of Care.

Tested ECDS measures, with a high level of complexity.

Verified and validated the application with System Testing, Peer Reviews, and UAT testing.

Evaluated software, procedures, designs, and follow SDLC processes for multiple projects

Managed Software testing activities such as Requirements, Test Cases, Test Executions andDefects using Quality Center.

Provided test summary documentation and analyzed test results identifying trends and/or rootcauses of problems

Reported defects in JIRA and worked closely with developers to resolve issues based on priorityand severity.

Received the EDI Claims From customers and run the claims on Uber deck to certify measures.

Installed testing of MedReport and Medexport for every release and provided the instances to Product Owner.

Participated in daily scrum meetings which happen twice a day and updated measure specific status.

Worked in a tight monthly release schedule and always made sure assigned measure is certified on time.

Environment: ETL Tools, SQL Server, Jenkins, Fitnesse, Web/App Servers, JIRA, HP ALM

Department of Technology and Information US, DE Jun 2017 to Jul 2018

QA Engineer

This project is in the phase of the vision to make environmental information available to “anyone, anywhere, on any device.” The results of this will be an electronic repository, with many (currently) paper documents stored and available online.

Worked closely with business users to gather requirements, define project specifications, develop implementation and test plans for the projects and enhancements.

Designed, created and tested reports to meet business requirements.

Documented and maintained RTM to ensure that all requirements are traceable from top to bottom and to provide a basis for test plan.

Validated that there is no missing data at each level of the database.

Verified the record counts of source and target tables.

Validated the transformation rules as per business need based on the Source to Target Mapping.

Developed SQL queries for data validation for verifying the ETL Mapping Rules.

Used SQL queries and validate the data loaded in to the target tables.

Monitored the output in Informatica workflow monitor and track the logs in case of failures

Participated in functional testing of front end application.

Prepared Test Plan, Test cases and updating test cases with the requirement changes.

Created test cases, defects in Quality Center and incorporated the test cases with the new requirements.

Developed and executed functional/system test cases to ensure product meets functional and design specifications.

Participated in user training sessions and assisting in UAT (User Acceptance Testing).

Environment: Asp.Net, C#.Net, Oracle, ETL Informatica

iHealth Technologies Inc, US GA Mar2014 to Jan 2016

QA Engineer

The Rule Valuation and Analysis Program will provide decision support services to enable impact assessment for a new rule, rule edit, industry update, and client opportunity analysis. The solution will also provide downstream efficiencies in performing claims analysis, value exploration, and new product analysis.

Analyzed requirements during the requirement analysis phase of the project, track new requirements and change requests and incorporate them into the testing phase of the application.

Designed Test Plan, Test Cases for DataMart validation, Reports developed in BO and Web Services

ValidatedDatamart and ETLs developed to pull data from actual Claims databases into RVA databases.

Performed alidation of Daily and monthly ETLs and loading of Buffered and Cached Tables.

Validated that data loaded is transformed as per the business requirements mentioned.

Validated that there is no missing data at each level of the database. Verify the record counts of source, stage and target tables.

Analyzed functional requirements specification and develop test cases for each phase of the ETL process.

Validated Sampling and Re-partitioning of Cache.

Validated Web services through SOAP UI and validating the results with backend.

Tested BO Reports Write SQL queries to test the data in the reports are valid.

Validated the structures and layouts of the reports.

Environment: Soap UI, SAP Business Objects, Oracle DB, Quality Center

iHealth Technologies Inc, US GA Dec 2011 toMarch 2014

QA Engineer

iHT is pioneer in Payment Policy Management Solution. To remain abreast and even ahead of its clients, business partners, and competitors, IHT has to implement the conversion of 5010 codes in to new codes and apply the same to their Rules Engine to process the claims.

Analyzed requirements during the requirement analysis phase of the project, track new requirements and change requests and incorporate them into the testing phase of the application.

Provided the estimations for test design and execution phases based on requirement review for ETL Loaders.

Prepared the gap analysis document for the requirements and interacted with Business Analyst to streamline the scope.

Analyzed the source to target mappings and workflows with the functional specifications and identified the gaps.

Prepared the Test case document for ETL for all the Loaders and also prepared functional test cases for Application.

Verified the implemented ETL code against the corresponding mapping document and confirmed the data loads from source files into the target tables.

Validated the transformation rules based on the Source to Target Mapping.

Examined sample record sets for consistency, data corruption and over all data quality.

Validated structure of the Stage and Target Database as specified according to the Mapping Document.

Validated data load into the Target Database (MDM) based on the Release Notes.

Prepared the SQL queries to prepare test data and to test the data dependent business rules in different databases.

Validated the Transformation and Business rules in the Target based on the Data Mapping Document for data correctness and data integrity.

Monitored the output in Informatica workflow monitor and track the logs in case of failures.

Prepared Traceability matrix for ETL Testing to map the requirements with the test cases and calculate test metrics like test completeness, test coverage and test case density etc.

Executed systems and data quality testing to ensure all development deliverables are production ready.

Worked as a point of contact for the Dev team to provide clarifications on any of the defects raised.

Logged the defects in the Defect Tracking Tool QC and track the defect status.

Environment: Appian, Informatica, Oracle DB, Quality Center

iSpace Technologies, India Nov 2009 to Dec 2011

Junior Software Engineer

Public Storage is one of the largest self-storage companies in US, providing services to customers through various web based applications for storage rental. Self-Care Whitesite is a new website designed with newer technology and more customer friendly when compared to existing websites.

Single testing resource responsible to handle various applications of the client.

Understood client work environment, business domain knowledge and articulate into implementation.

Interacted with client on daily basis to gather requirements, clarifications on change requests and reporting daily status.

Prepared Test Plan, Test cases and updating test cases with the requirement changes.

Created test cases, defects in Quality Center and incorporated the test cases with the new requirements.

Used Element tool (Project Management Tool used by Client) for defect status tracking.

Performed Web Services testing, integration testing and end to end functional testing.

Performed the Backend Testing using SQL Server, by developing and executing SQL queries.

Tested data preparation from database by writing complex sql queries to fetch and analyze user specific data.

Tested the application compatibility in the versions of Firefox, Chrome and Internet Explorer browsers.

Participated in all defect meetings with the Dev Team, Business users to follow up the defects and resolve discrepancies and process issues.

iSpace Technologies, India March 2008 to Oct 2009

Client: CDPHP, Independent Health, US

Junior Software Engineer

Payer to Member (P2M) is an ispace mobile product which enables Health Plans to serve their Members better with dynamic content and improved outreach.

Developed and execute functional/system test cases to ensure product meets functional and design specifications.

Tested both native and web applications on smart devices like iPhone, HTC, Blackberry, iPad, tabs.

Worked with multiple mobile operating systems including Android, iOS, Blackberry, Windows Phone 7.

Tested the devices manually, on simulators, using Device Anywhere tool and Perfecto Mobile.

End to End testing project management/setting up the environment, test case creation and execution, reporting issues.

Performed Smoke and Installation testing on weekly builds followed by bug verification, clearing QA and escalating critical issues to the management in Scrum meetings.

Environment: HP QTP, HP ALM

Contact this candidate