Sep 2014 – May 2019 · 4 yrs 8 mos

• During my time with OptumRX/Optum/UnitedHealth Group, I worked on multiple projects as a QA lead. The list of high-level responsibilities I had is shared below. For a more detailed outlook to the projects, I have worked on can be found in the projects section below.
• My latest project within UHG worked with the OptumRX data warehousing team to ensure QA on mailing EOB benefits to our customers. Due to constant changes in the benefits industry on a yearly basis, we had to analyze and test modifications to this very same data set. Along with these regular changes we were in the process of migrating our codebase from Informatica to the new Abinitio Platform.
• My primary responsibilities here were to identify existing production print files and compare them to the files generated by our Abinitio platform using Abinitio graph as well as Excel. Constantly coordinated with development teams to ensure data integrity between platforms in lower environments. Validated every complex field against AS400 screens along with writing and running SQL queries against a Netezza database and SQL Server to ensure data integrity. Conducted a continuous analysis of our data set while recording all discrepancies between the two platforms. Shared these with the project and developer teams to be fixed. Oversaw our offshore QA team for report builders and user report testing and assigned them different aspects of testing. Scheduled meetings on a daily cadence with the offshore team to accommodate them and help remove any roadblocks.
• To see other responsibilities and project work I have accomplished please view my project description below or I'd be happy to share my resume.

Nov 2006 – Aug 2014 · 7 yrs 9 mos

• Was presented with an opportunity to join UnitedHealth Care's team in OptumRx/Prescription Solutions a leading benefit manager recognized for its innovation, transparency and customer service which was serving the needs of more than 13 million Americans and that number has been rapidly growing.
• I started off my journey here as a Senior IT Quality Analyst where I worked on multiple projects and held many responsibilities. Please see a list of responsibilities I had during my time in this role. Please reach out to me if you would like to specifically learn more about my time within this role.
• Responsibilities:
• Continuously led various high priority data warehousing initiatives (IRIS, EDM Daily, EDM Monthly, CHP, EOB, PDE, Netezza Replication, Client Reporting, and PAS-OLR projects) to guarantee the quality of code to the end user by performing data analysis, validate ETL mappings, transformations, Micro strategy, and Crystal reports.
• Led these various initiatives in parallel with multiple offshore resources.
• Worked closely with the project team and provided clarifications to the QA testers during the test execution.
• Also, worked with IT Development (Project Managers and development staff) to ensure the feasibility of design and to clarify user requirements.
• Actively participated in understanding business and system requirements, created and executed test plans.
• Worked closely with development teams to ensure test results were communicated.
• Constantly developed SQL queries in order to validate the data completeness and its integrity.
• Extensively used ALM for defect tracking on all projects and continued to provide accurate QA estimates for projects.

Jun 2005 – Nov 2006 · 1 yr 5 mos · Pasadena, CA

• During my tenure at Kaiser Permanente, I had the privilege of working on a high profile project called TDS, an ETL application. It was a system that involved its partners and subsidiaries like receiving claim information from various systems. These interfaces ran on a daily and weekly basis to maintain up-to-date billing and claim information for customers. Below I have outlined a list of responsibilities I've had during my time with Kaiser Permanente.
• Responsibilities:
• Review all requirements that are entered in Caliber.
• Prepared and detail test cases for connectivity, field level, and negative testing.
• Also prepared test data for various interfaces according to the mapping document to receive the extract files from the various systems like PBM, PODS, POS, FS to DS and TDS to USCB.
• Load and extract files into tables and validate the data using Teradata SQL assistant.
• Write test cases and upload them into Quality Center.
• Log defects in Mercury Quality Center.
• Tested various claims exception reports and claim mismatch reports.
• To write valid SQL statements to validate the data against file outputs.
• Involved regression testing and black box testing.