Post Job Free

Resume

Sign in

Quality Assurance Clinical Data

Location:
Buffalo Grove, IL
Posted:
December 26, 2023

Contact this candidate

Resume:

NAJMA ARAKKAL SHAMSUDDEEN

Buffalo Grove, IL – ***89 – 503-***-****

ad18fd@r.postjobfree.com

QUALITY ASSURANCE

Expert Quality Assurance

Efficient Business Analysis

Productive Communication

Technical Troubleshooting

Effective Public Speaking

Taking Initiative

Strong Organizational Skills

Fostering Collaboration

Over 17+ years of Quality Assurance experience in Healthcare/PBM/Specialty and Information Management domains.

Over 5 years of experience in Data Analysis on Clinical data to help build report for the manufactures and Trade companies.

Proficient in ETL testing using DataStage, Talend and SSIS

Proficient in requirement elicitation and identification, process documentation as well as creating business requirements and functional specifications documents.

Excellent cross-team collaboration skills with very good logical reasoning ability and strong interpersonal communication ability.

Fast learner and creative in work

professional summary

Highly proficient in Test Planning, Test Strategy preparation, Test Case creation and capturing the Test execution results.

Part of Azure transformation testing for the vendor-based application.

Performed Internal/External Integration Testing for digitalization (with Mobile apps) of the application involving Kafka queues/Micro-services.

Well versed in analysis of clinical data for creating reports in Tableau.

Highly proficient in various types of Testing including System Testing, System Integration, Regression Testing, Web services testing and UAT testing approaches with testing tools like Quick Test Professional, Soap UI for testing RESTFUL web services, POSTMAN, Unix, SQL Developer, Microsoft SQL Server and Test Director /HP Quality Center/ HP ALM . Good understanding on Automation concepts like Selenium and Cucumber.

Very skilled in writing SQL queries and Database Testing

Highly experienced is in directly communicating with business to gather the requirement.

Experience with Data Migration project using the ETL tools DataStage and Talend.

Acted as liaison between client and offshore QA teams for Requirement’s translation and responsible for Project delivery on time under stringent timelines and high pressure.

Proficient in requirement analysis to identify gaps and provide inputs to functional team and Business team to help define much clearer requirements.

Good knowledge in Pharmacy Benefit Management domain and Healthcare domain with Specialty drugs.

Excellent verbal & written communication and presentation skills

Efficient in Defect tracking and conducting Defect Triage Calls

Well proficient in collecting and maintaining QA Matrices and Traceability Matrix.

Unix scripting to create batch jobs.

Benchmarks & Milestones

Provided instrumental expertise in developing complex business requirements including scope definition and objectives for new consumer facing application at Walgreens Pharmacies.

Closely collaborated with Clinicians in Walgreens to design the programs for patients in Specialty Drugs.

Effectively worked with business and development teams in an agile environment to define system scope and objectives for Specialty projects.

Introduced new processes in the project to handle multiple Specialty Drug programs.

Introduced QA to the Configuration team and which enhanced the quality of work.

Implemented Jira X-ray in the project to work effectively in Agile environment.

Certified Scrum Master

Introduced new tools to the team like SOAPUI, POSTMAN etc.

Key resource in implementing NCPDP D.0 in pharmacy benefit claims in Walgreens.

Key resource in implementing ICD-10 codes in electronic health record in Walgreens.

Created a handbook on application for the new joiners.

Career Progression

Centene St. Louis, MO 2023-Now

Project 1: End to end testing for ESI migration project

THE PBM business is moving from CVS Caremark to Express scripts.

Sr.QA Analyst:

Represent QA team in the requirement meetings with Architecture team, Functional Workstream team and Partner team.

Review Architectural diagram that includes more than 15 workstreams and understand the flow of PBM data/ PBM data pre-requisites end to end to build Test Strategy and Test Scenarios.

Created Test Strategy for the ESI Migration project program and conducted review with Business team.

Closely work with all the workstreams and identify/create and review test scenarios/prioritization of test cases

Work with external partner (New PBM) to build the end-to-end test cases from membership to downstream application of the RX claims.

Identified the data requirement and coordinated with all the workstreams including external partner for the data creation.

Coordination with offshore team for Test execution, data creation, test result logging, Defect creation.

Prepare Test Execution Summary and share with stakeholders.

Walgreens Deerfield, IL 2015-2023

QA Analyst/Business analyst for Program configuration

Project 2: Specialty Release (SDLC and later evolved to AGILE)

Sr. QA Analyst:

Represented QA team in the requirement meetings during SDLC and in grooming/scrum call meeting during AGILE.

Deeply involved in Test planning, Designing including walkthrough with Business, Test Execution

Write complex sql queries for data validation.

Create automated batch jobs using UNIX scripting.

Guided the team to automate the test cases using QTP which later was changed to HP ALM

Constantly review of traceability Matrix in Jira Xray

Provide various matrix on Defect Leakage, Test Coverage Matrix, and Defect Density etc.

Co-ordinate with multiple integration partners for Integration Testing

Co-ordinate and maintain the Regression suite.

Project 3: SRx integration with vendor platform (AGILE) 2015 - 2023

The introduction of micro-services and RESTFUL web services to integrate the in-house application with a vendor platform.

Sr. QA Analyst:

Conducted Proof of Concept for multiple tools to understand the best fit tool for testing web services in Cloud.

Introduced SOAP UI and POSTMAN to client and actively used for testing web services.

Work with the team to add Assertions and re-use the test suite created in SOAP UI.

Data creation for testing the ETL jobs in Talend and validating the extract and transformations.

Write scenarios and test cases to test the transformation rules.

Write SQL queries to determine the best data for the scenarios.

Write test cases/capture test results in JIRA XRAY.

Work closely with Business on requirements and new workflows in the Vendor application.

Project 4: Electronic health records (SDLC) 2012 - 2014

Walgreens project with vendor based application

QA Analyst:

Worked with a team of 20 members both onsite and offshore

Co-ordinated the work between Offshore and Onsite

Designed test scenarios and test cases in QTP.

Provided business walkthrough.

Involved in both Manual and Automation testing.

Extensively used Unix scripting and SQL for testing

Created excel macros for data comparisons and validations.

Facilitated defect triage calls tracking progress of all systems and UAT defects across lifecycle.

Created and maintained the regression suites.

Co-ordinated and tested with Integration Partners.

Project 5: Pharmacy benefit System (Walgreens/CatalystRX/Catamaran) 2009 – 2011

QA Analyst:

Worked with a team of 15 members both onsite and offshore.

Co-ordinated the work between Offshore and Onsite.

Designed test scenarios and test cases in Excel.

Provided business walkthrough.

Created Unix scripts to generate patient data and claims data for testing.

Involved in both Manual and Automation testing.

ETL Testing using DataStage.

Extensively used Unix scripting and SQL for testing.

Created excel macros for data comparisons and validations.

Facilitated defect triage calls tracking progress of all systems and UAT defects across lifecycle.

Project 6: Business Information System (Dun and Bradstreet) 2005 – 2009

Production Support:

Understand the requirement from the client and incorporate the changes in the application.

Work on the high priority production tickets and resolve the issues.

Extensively used Unix scripting and SQL for testing.

Create status report and facilitate status call with Clients.

Create batch jobs using SSIS.

Technology Proficiencies

Languages:

SQL, HTML, VBScript, Core Java

Operating Systems / Software:

Wiki, SharePoint, MS Office Suite, Quality Center, JIRA, HP ALM, QTP, Oracle 11g, Microsoft SQL Server, SSIS, Talend, SoapUI, Postman, Datastage

Education and Certifications

Bachelor of Technology, Civil Engineering

Cochin University, India

Certifications and Awards

Above and Beyond Awards in Walgreens

Certified Scrum Master

Microsoft certified Professional (MCP) in SQL Server and .NET



Contact this candidate