Advisory Consultant Resume

SUMMARY

19 years IT experience include 18 year as QA and 1 year as Oracle DBA.
Strong in HealthCare domain (11 years). SME on member enrollment.
Responsible and lead all membership / eligibility testing in the last 6 years include PPACA (Obamacare) with Facets, 834 EDI, flat text file, spreadsheet.
Experience with other Facets functions and 837, 835, etc.
Facets Business Associate Certification
SME on data analysis, data migration and SQL (Oracle & MSSQL)
Experience with waterfall and agile methodology
Experience with web portal, web service, API testing, etc.
Experience with technical QA lead role.
Superior analytical, problem solving and organizing skill. Fast learner and self - motivated. Able to work under pressure, meet deadlines and handle multiple tasks simultaneously.

PROFESSIONAL EXPERIENCE

Advisory Consultant

Confidential

Responsibilities:

Participation in full SDLC including: review requirements, test preparation and execution, create and verify defects, etc. HP ALM is used for requirements, test case and defect management.
Facets application testing
Responsible and lead all membership / eligibility testing include Obamacare (Affordable Care Act) with Facets, 834 EDI, flat text file, spreadsheet etc.
QNXT application testing
834 EDI testing 837, 835
Claim testing using Claim Test Pro (
Agile development methodologies
Test Lead

QA and Testing Senior Specialist

Confidential

Responsibilities:

Participation in full SDLC including: review requirements, create test plan, test cases, execute test cases, create defects, verify defect fix, test summary and UAT testing support. Mercury Quality center are used for requirements, test case and defect management. Responsible for:
Facets application testing (4.5 years).
Verifications of the ODS database, warehouse and related reports (ETL and Reports testing).
837 EDI Testing(Claim).
Web-based application and client-server application testing.
Modify and run QTP scripts.

Sr. QA Engineer

Confidential

Responsibilities:

Front End testing of all cricket applications including verification using the backend database.
Active participation in production day launches, with complete end to end testing in the production environment.
Responsible for advising on process formation for the QA team and contribution to lessons learnt meetings.
Responsible for generating reports for development and management teams

QA Engineer

Confidential

Responsibilities:

Participation in all project quality control and testing activities with the full SDLC. The projects included enterprise-level Web-Based applications (J2EE), Client-Server applications, CRM application (EnterpriseOne), Database conversion, ETL testing, Network applications (LDAP), GIS applications (ArcGIS), Agile project testing, etc.
Reviewing product plans, requirements and design documents and risk assessments.
Developed test plan, test case and test steps using Quality Center (QC).
Developed and executed automation script using QTP.
ETL testing (Oracle and MS SQL databases).
Setup test environments: client, server, database.
Projects test lead.
Defects management using Mercury Quality Center, TestTract Pro and Bugzilla.
Code version control using CVS system.

Oracle DBA

Confidential

Responsibilities:

Installed, upgraded, and/or configured Oracle8 and Oracle8i databases.
Monitored databases, hot backup and full export, checked Alert log files, troubleshooting, etc.
Managed database: created users, created, modified and custom designed database storage structures and objects, created synonyms, sequences, roles, database links, rebuilt indexes, resized tablespaces, redo logs and rollback segments, etc.
Imported and exported data using Oracle import and export utility, schema or table levels and loaded different formats data into Oracle database with SQL Loader.
Created procedures, functions, packages and triggers using PL/SQL: compared records in old database and new database, performed data integrity check, etc.
Performed SQL statement tunings: analyzed tables and indexes, checked chained and migrated rows, set up trace file and used TKPROF to analyze the trace results.