Joyce John Email & Phone Number

Nashville, Tn, Us

Nashville, Tennessee, United States

ATI: Innovation and ArchitectureWorkstreams: E2E Looker dashboard for Claims Appeals/Denials/ Overturn/ Write-off overview dashboard, Payor Matrix, Case Management, Claims Appeals, Clinical Summary (Abstractor dashboard and exports), GHR Recruiting Application (New Hire Dashboard, Portal, Recruiter and Candidate Experiences)Responsibilities:• Lead all aspects of data analysis and validation, as well as application functional and automated testing activities across multiple projects, over healthcare and financial domains supporting multiple code bases. • Provided leadership, managing and mentoring in Quality Control and setting testing benchmarks within clinical or LOB areas. • Assisted project team with high-level design and/or integration considerations. • Lead, mentored and coached Consultant Test Analysts, Technical Test Analysts II Test teams.• Extensive experience in database querying in Sequel Pro, Oracle PL/ SQL, MS SQL server, PostgreSQL, GCP cloud platform• Data quality and mapping from EMR systems (Meditech, MT Expanse), EDW layer, HIN, HDE, FHIR to Front end UI • DB layer: GCP, PostgreSQL, Cloud based db testing), AWS Cloud Enterprise Workflow, Azure • Backend Services: Postman, Swagger, AI Prompt, LLM• Middleware and dataflow connectivity, Data transformation testing from Source to FE applications• Ensuring Architectural and design robustness. • Identifying design or data gaps using end to end data flow unit testing and data mapping gap analysis.• Data quality and mapping from EMR systems (Meditech, MT Expanse), EDW layer, HIN, HDE, FHIR to Front end UI • Ensuring Architectural and design robustness. • Extensive knowledge in EDW data warehouse, Claim lifecycle (Appeals/Denials/Overturn/Writeoff), HIN, EDW databases, HL7 and HIPAA compliancy• JIRA, Azure, Confluence, MS office tools for Test Documentation• VS code, GCloud SDK Terminal for Unit testing

Nashville, Tn

DPX: Digital Patient Experience:Workstreams: Portal and App Testing, Orchestration, UI and services validation, Team LeadershipProjects: PO (Patient Object), MHO (UX and Mobile), Messaging Platform, Online Patient Registration, Surgical Symphony, Nursing InterfaceResponsibilities:• Worked on multiple applications as the Lead Technical QA.• Providing Team Updates to Leadership on deliverables, drafting risk mitigation plans, project roadmap.• Leads, mentors and coaches Associate Test Analysts, Technical Test Analysts I & II, Automation Teams.• Documenting and triaging issues with Dev and BA/PA team to minimize downtime and quick turnaround time.• Executing Local/ Unit testing, System Integration Testing, multiple browser, SSO integration and OS compatibility test• Creating data for use cases for various projects and troubleshooting data flow/ HL7/ ADT issues with DB team using Meditech 5.6.7, Biztalk, Initiate, DB and Swagger API• Daily sync with other Leads (Architectural, DB, Services, UX) on sprint deliverables, project roadmap, content management, application support and during deployments.• Providing production support as a QA Lead and managing the team’s test suites, delegation of tasks per capacity and reporting on progress. • Working with offshore Lead to ensure collaboration for continuous and iterative product improvement.Technical Highlights:Web Application UI testing, API testing, Mobile Application, Device Integration testing, Web service, Multi Browser, Data flow and orchestration testing using:• Microsoft SQL SSMS 15.0, Meditech 5.6.7, Initiate, Cosmos DB, Cassandra Shell scripts for database testing• Swagger, Postman for API testing• JIRA, Azure, Confluence, MS office tools for Test Documentation• Browserstack, Leapwork for multiple browser, OS testing• Perfecto, Experitest for multiple device testing• VS code, GCP Cloud shell Terminal for Unit testing

Nashville, Tn

Technical Expertise:• Sequel Pro 1.1.2 for database testing• JIRA, Confluence, Testpad, MS office tools for Test Documentation• Browserstack for multiple browser, OS and device testing• VS code, Terminal for Unit testing• Gitlab, Postman, Mocha, Chai for Automation Testing and Black Duck Testing for open source vulnerabilities• Worked on multiple applications as the Lead QA• Documenting and working to resolve problems to ensure quick turnaround time ensuring quality, performance and project goals are met• Participating in design walkthroughs and requirement analysis to ensure test coverage• Creating Test Scripts/Cases, Data and writing and. Executing queries that are in line with defined business processes and requirements• Executing Local/ Unit testing, System Integration Testing, multiple browser and OS testing and proper test documentation• Worked with Data Services and Data migration team to perform backend-testing using SQL.• Reviewing requirements, user stories, creating high-level scenarios from the functional specifications, and creating RTMs (Requirement Traceability Matrix).• Worked with Accounts during reroll or enrollment period for ensuring configurations are met as per Client specification and meeting Internal and External UAT deadlines.• Working with other Team leads while performing content management, application support and deployment team.• Providing production support as a QA Lead and leading the team’s Smoke and Regression test efforts. • Provided knowledge transfer to junior team members on Sequel backend validation process and applications• Coordinating and taking builds to ensure testing team is on schedule during the Sprint cycle.

Brentwood, Tn

• Worked on multiple Scrum teams as the Lead QA (Portal and mobile platform redesign, adding journeys and engagement stream to enhance user interaction, Coaching platform redesign, migration of a major client from Ruby to .NET, Challenges, Connections and Incentives.)• Interacted with the offshore team to receive updates and meet Scrum deadlines.• Conducted Defect triages and worked with the BA and Dev teams to ensure deliverable deadlines were met.• Provided testing estimates and Involved in Design, Execution and updating of Test Cases for Functionality Testing.• Worked with the offshore automation team to get full test coverage of the Smoke and Regression Test Suites.• Worked with Data Services and Data migration team to perform backend-testing using SQL.• Reviewing requirements, user stories, creating high-level scenarios from the functional specifications, and creating RTMs (Requirement Traceability Matrix).• Worked with Accounts during reroll or enrollment period for ensuring configurations are met as per Client specification and meeting Internal and External UAT deadlines.• Working with other Team leads while performing content management, application support and deployment team.• Providing production support as a QA Lead and leading the team’s Smoke and Regression test efforts.

Greater Nashville Area, Tn

Technical Expertise:Database : MS SQL Server 2008/2012, Oracle, TOAD.Tracking Tools : Quality Center 10.0, ALM 12.0, Sprinter AgentDocumentation Tools : MS office tools (MS Word, MS Excel, MS PowerPoint, MS ProjectServer and MS Visio) Testing : CodedUI and Selenium Automation TestingOthers : Visual Studio 2012, TFS, IBM ALM, FileZilla (SFTP), Edifecs, SpecBuilder, UltraEdit etc.Certifications:● Course Completion Certificate of SQL Server 2012 Querying (70-461) Part 1 & SQL Server 2012 Querying (70-461) Part 2 from Pluralsight● Course Completion Certificate of Agile Development, Quality, and Testing Practice from Pluralsight

Greater Nashville Area, Tn

Greater Nashville Area, Tn

TennCare InterChange (Web service testing and web application UI testing) using:• Oracle PL/ SQL DBMS and TOAD for database testing.• MS Office suite for documentation.• QC/ ALM/ Sprinter Agent for generating test plan, test cases, execution of test cases and defect tracking.• Edifecs for testing the XML output and correctness of Edifecs maps and SNIP edits.• UltraEdit and SpecBuilder for checking the X12 input and checking for SNIP edits before processing.• SFTP using FileZillaTechnical Expertise:Database : MS SQL Server 2008/2012, Oracle, TOAD.Tracking Tools : Quality Center 10.0, ALM 12.0, Sprinter AgentDocumentation Tools : MS office tools (MS Word, MS Excel, MS PowerPoint, MS ProjectServer and MS Visio) Testing : CodedUI and Selenium Automation TestingOthers : Visual Studio 2012, TFS, IBM ALM, FileZilla (SFTP), Edifecs, SpecBuilder, UltraEdit etc.Certifications:● Course Completion Certificate of SQL Server 2012 Querying (70-461) Part 1 & SQL Server 2012 Querying (70-461) Part 2 from Pluralsight● Course Completion Certificate of Agile Development, Quality, and Testing Practice from Pluralsight

Master'S Degree, Chemical Engineering

Bachelor Of Technology (B. Tech) Engineering, Biotechnology