SUMMARY:

• Skilled Sr. Quality Engineer/ with proven leadership, communication, project management experience and problem solving skills, detail oriented, adept in building strong working relationships with peers, business users and in all levels of the organization, highly resourceful and quick learner.
• Skilled in doing functional regression, systems and integration and UAT testing using testing tools such as Microsoft TFS, MTM, Jira, Confluence, Zephyr, HP Quality Center
• Skilled Business Analyst coupled with project management and testing.
• Skilled in Agile, and Waterfall Software development cycle
• Skilled in creating diagrams such as Flow Charts, USE Cases, Process flow, Functional Decomposition using VISIO
• Used Microsoft TFS and MTM applying the use of Agile Methodology for user story and test cases development and execution.
• Used Confluence and Jira in QA testing activities
• Over 3 years of experience doing business analysis on business intelligence
• Over 9 years of testing experience on data warehousing
• Expert in testing (functional, regression, integration and UAT) on an application implementation
• Skilled in data analysis, data quality control, users training
• Skilled in testing Healthcare Application messaging in patient Eligibility and MedHistory, Electronic Prescriptions, Electronic Prescriptions of Controlled Substances (EPCS), Electronic Prior Authorization (ePA)
• Skilled in testing Insurance, HealthCare, Transportation, Logistics and POS.
• In depth experience in testing Business Intelligence, ETL using SSIS, ABInitio and DataStage
• Skilled in testing data warehousing / testing of Formulary File Processing such as loading, translation and distribution of (Coverage, CoPay, Alternative and Formulary)
• Skilled in testing Healthcare application
• Skilled in testing Electronic Health Record (EHR)
• In - depth working experience in SQL scripting using databases SQL Server, Oracle, and DB2
• Self-motivated team player demonstrating effective leadership, complex data analysis, and results oriented solutions
• Experience in testing Web Services and REST API using SOAP UI
• Completed online training on SOAP UI automation
• Completed online training on Selenium and TestNG using Eclipse

TECHNICAL SKILLS:

Database & Tools: SQL Server 2012, SQL 2014, Toad, Oracle, DB2, AccessDB

Operating Systems: Microsoft Windows Server 2008, 2012, Unix - IBM AIX, Sun Solaris, HP U/X

Programming Language: Java

Development Tools: Eclipse, SQL Server Management Studio, SSIS, SSRS

Project Management: Over 5 years in project management, project lead, QA Team Lead

Project Methodology: Experienced in the use of Agile/Scrum, Waterfall, UML, USE Case etc.

Testing & SQA Tools: Microsoft Test Manager (MTM), Microsoft Team Foundation Server (TFS), HP Quality Center 10, 9.2, Mercury Testing Tools Suite (Load runner, Test Director, Win runner), JIRA, Confluence, Selenium, TestNG, SOAPUI, Eclipse

Others: Visio, Microsoft Office, Microsoft Project - Microsoft Office, Toad, Unix, VI editor

PROFESSIONAL EXPERIENCE:

Confidential

IT Contractor - IQ Engineer

• Team Lead and responsible in testing end to end HealthCare Insurance application implementation that covers Claims - Pre-Authorization, Claims Adjudication, Provider, Enrollment and Eligibility verification and Billing. Testing and verification of EDI file such as 837, 835.
• Delivered results to project team of the data analysis and data profiling of Provider, Claims (Claims
• Processing/Claims Adjudication) Prior Authorization, Member and Eligibility during UAT testing.
• Delivered data comparison of partners Claims Historical data and Claims data that were loaded at UAT database using SQL Server, Excel Pivot table and Access Database during data integration testing.
• Delivered QA reporting metrics on a project implementation. Metrics are updated at Confluence on a daily basis for management consumption. Used Jira, SQL Server, Access DB and Excel Pivot table

Confidential

ETL QA Engineer

• Delivered, executed and analyzed complex test cases and perform end to end systems testing
• Analyzed and replicated defects using SQL Server SSIS and SSRS on time
• Delivered, created, executed detailed ETL test plans and ETL test cases using Microsoft TFS and Microsoft Test Manager.
• Exhibited in depth knowledge on relational and dimensional model, data analysis, modelling and design

Confidential

Sr. Quality Engineer

• Team Lead and responsible in testing Builds in QA, and provide QA support in Production environments
• Tested EMR functions. Data Abstraction, patient eligibility, medication history, patient historical information and Prior Authorization
• Used Microsoft TFS and Microsoft Test Manager to build and execute test cases. It was also used to create user story backlogs, epic stories to categorize user stories. As user stories are categorized, it is then broken into smaller functions, prioritized and then assigned to a sprint.
• Delivered and completed end to end testing QA test results of EHR Enterprise. Test activities are as follows;
• Data Profiling, Loading and Data Integration (Staging of Formulary data up to distribution to different Electronic Health Records - EHR application)
• Data Profiling, Testing of Data Loading from partners, data translation and data distribution of formulary data using SSIS and SQL Server 2008, 2012, 2016
• Test and verified data integration /data quality processed from EHR’s Enterprise Application
• Testing of Enrollment/Prescriber application - Prescriber and Account Enrollment
• Functional testing of data integration with partner Surescripts
• Testing of ePA Processing/data integration to Formulary database of Electronic Prior Authorization information
• EHR transactions such as Eligibility and Medication History and Rx Prescriptions and Electronic Prescriptions of Controlled Substances (EPCS)
• Test Messaging of XML to EDI/EDIFACT and vice versa doing a business to business transactions with partners
• SIG Loading and Processing
• Data Profiling and testing of SIG data loads and verified data quality before distribution to EHRs (Electronic Health Record) application
• Argus Member Loading to EHR enterprise
• Testing of Argus data loads and verified data quality before distribution to EHRs (Electronic Health Record) application
• Delivered QA test results in testing Hub Prescriptions Messaging (NewPrescriptions, Refill and Response) transactions
• Lead and delivered QA testing results in Formulary Processing of CoPay, Alternative, Coverage and Formulary which include testing of formulary distribution to different Electronic Health Records clients such as eRX, TW and ProEHR. It includes testing of data coming from different partners - (Medispan, Argus, Surescripts, ESI)
• Lead and delivered QA testing results Electronic Prescriptions of Controlled Substances (EPCS) on EHR applications eRx (ePrescribe)
• Lead and delivered in testing Electronic Prior Authorization (ePA) on EHR applications
• Delivered results in testing Prescriber Enrollment applications
• Lead and delivered QA testing results in testing middleware applications (Transaction Hub) on patient Eligibility and Medication History transactions. These include testing of XML, X12 messages that was sent by EHR applications to transaction hub and transaction hub to the partner (Surescripts) and vice versa
• Delivered and completed QA test results in Eligibility Request and Response / Medication History upgrade of ICD 4010 to ICD 5010
• Delivered and worked with partners (EEHR team, Surescript) in the completion of Certification
• Testing of Electronic Prescriptions, patient Eligibility and patient Medication History, Electronic Prior Authorization (ePA)
• Delivered QA test results and worked collaboratively with internal and external partners (application team) EEHR (TW, ProEHR, eRx) and (Surescripts) in doing compliance and certification testing in Formulary, Eligibility and Prescriptions
• Subject Matter Expert in testing Formulary processing (Coverage, CoPay, Alternatives and Formulary), patient Eligibility and Medication History messaging, Prescriber enrollment application, Electronic Prescriptions messaging (NewRx, RefillResponse) and Electronic Prescription of Controlled Substances (EPCS) messaging
• Adept in Agile methodology / processes.
• Used Microsoft Test Manager to build and execute test cases
• Used Microsoft Foundation Server to document bugs, create user stories, linked bugs to user stories, linked test cases to user stories and validated Acceptance Criteria per user story.
• Managed and maintained QA Test Servers - SQL Server DB - 2012 and 2016
• Used SOAP UI in testing Web Services and Rest API

Confidential

IT Consultant - Quality Engineer

• Completed QA testing activities such as smoke, functional, system integration, End to End testing and UAT testing of an Electronic Data Interchange (EDI) 4010A1 messaging of patients eligibility request (270) and patients eligibility response (271), patients drug history and patients
• RxPrescriptions on the following web based medical applications, ePrescribe, and Enterprise
• Electronic Health Record (EEHR), Professional Health
• Record, ProEHR) and MyWay medical application
• Troubleshoot and diagnosed EDI messaging generated on hub switches used using Microsoft
• Biztalk Server
• Determined and validated messaging transformation of data from XML data to HIPAA 4010A1
• X12 compliant message
• Used SQL Server 2005, 2008 to validate messaging routed (inbound and outbound messaging) Developed SQL scripts to keep track of the inbound/outbound message routing Developed SQL scripts to trap errors and validate business rules if it were processed successfully, Used Biztalk Administration to monitor switch hubs errors and implementation of the EDI messaging components Conducted validation of field to field mapping of XML, EDIFACT and NCPDP data format of all
• Inbound and outbound EDI messaging for Eligibility, Drug History and Rx Prescriptions
• Used ePrescribe and Enterprise Health Record functionalities to validate full cycle of EDI messaging as it is routed from consumer to the different trading partners
• Developed RxHub Switch Test Plan / Test Cases using HP Quality Center 9.2
• Executed test cases on Rxhub Switch Test Plan / Test Cases using HP Quality Center 9.2 Managed and logged defects at Colabnet Created Project Schedule Testing
• Worked with different trading partners such as SXC, Aetna, Surescripts Minnesota, Surescripts
• Virginia, Argus, Perse and eRx.
• Verified end to end testing of Electronic Data Interchange (EDI) 4010A1 messaging with different trading partners such as SXC, Aetna, Surescripts Minnesota, Surescripts Virginia, Argus, etc.. Used SOAP UI in testing Web Services

Confidential, Delaware

Business Systems Analyst - Data Warehouse

• Worked with different Business groups/users to understand the Business Requirements for the project.
• Worked closely with the business users to understand the current state and target state business processes
• Worked with different IT & Business groups to understand and determine the Impacts to the
• Data Warehouse and/or Data Marts for different projects
• Documented Functional Requirement Specification/FRS for the Data Warehouse and/or Data
• Worked collaboratively with Architects, DB Admin to determine Logical/Physical Data Models
• For Data Warehouse and/or Data Marts
• Worked closely with the business users and development team to validate if Technical design specification meets the business requirements
• Reviewed Test Plans/Scripts to ensure adequate coverage for the proposed design
• Used Ab Initio for ETL extraction tools Used Business Objects for Business Intelligence Reporting Tools Used HP Quality Center 10.x to keep track of production issues, manage production issues and document issue resolutions.

Confidential

Sr. Business Systems Analyst / Project Lead

• Provided end/user support and training during application implementation
• Worked with business users to gather information and document test requirements as well as analyzed existing documentation on their business to come up with the test plans, test cases, and test strategies
• Identify, documented and validated with the business user’s testable requirements
• Analyzed and defined business gap
• Documented test cases on HP Quality Center and test scripts
• Created and executed smoke, regression, functional and integration testing
• Managed and documented bugs, defect at HP Quality Center
• Collaborated with business users and developers on bugs, defect and issues identified

Confidential

Sr. Business Systems Analyst / Project Lead

• PDE record is a summary record that documents the final adjudication of drug dispensing event. Plans must submit PDE records to the Centers for Medicare and Medicaid Services (CMS) every time a patient fills a prescription record under Medicare Part D insurance. Confidential Health Solution (WHS), as a Pharmacy Benefit Manager (PBM), processes the claims from pharmacies for its Clients (insurance companies, e.g. Aetna, Blue Cross). WHS generates the PDE Reports for its Client and transmits them to CMS for payment calculation and reconciliation. The objective of this re-engineering project is to facilitate faster processing of PDE records and submission to CMS, faster turn-around time when technical issues or problems are identified and empower business users of the application.
• Worked with business users and developer in documenting user requirements using Use Case (UML)
• Worked with business users to design PDE Drug Event Processing document,
• Worked with business users and developers in documenting, executing test plans, test cases, and staging data extraction using Excel and Oracle
• Worked with business users and developers to come up with test cases and test scripts. Executed Systems batch testing using Data Stage