Christopher Pettigrew Email & Phone Number

• Assist our offshore vendor partners in obtaining and maintaining access to necessary software systems. Onboard and offboard vendor partner users. Run and export SQL reports for various departments. Create documentation for processes. Create monthly Excel scorecard to keep track of vender’s performance. Create bill inventory reports daily and assign them to vendor partners.

Research merchandise for purchase and resale on ebay

Tucson, Arizona, United States

Research, create, and validate court affidavits for the Recovery department

Tucson, Arizona, United States

Researching and purchasing merchandise to resell on eBay. Also selling my house and relocating from Sahuarita AZ to Tucson AZ.

Oro Valley, Arizona, United States

Supporting the Quality department of aerospace industry in their goal of reducing over $1,000,000 in lost revenue by researching and analyzing complex data systems to create a “big picture” of what is happening.Quickly learned SAP data system to extract complex data about supply chain and manufacturing to develop visual scorecards to give management an easy to understand picture of what was happening and why.Laid off due to Covid crisis affecting the airline industry.

Tucson, Arizona Area

Develop, schedule, modify, and automate reports for various departments within Coventry Workers Comp division of Aetna.Experience with BI Launch Pad, BI Query, BI Launch Query Builder, Crystal Reports, R Studio, Oracle PL/SQL, Oracle SQL Developer, COGNOS, Power BI, Data Warehouse, Microsoft Excel, Microsoft Access, and Microsoft Office in general. Laid off due to company restructuring from sale of Workers Compensation division. Applied White and Yellow belt certification in Aetna equivalent of Six Sigma to creating a “Voice of the Customer” survey resulting in a significant change to our report request intake form that increased our quality, decreased our turnaround time, and increased our customer satisfaction. Assisted in creation of the team's SharePoint site and request intake form resulting in better tracking of the team's work.Trained a small group of 5 people how to use a GUI data reporting program to help them be able to get more information that would help with their positions.

Audited various operations within all of Workers Comp Operations to identify areas of potential improvement. Become familiar with Kaizen and DMAIC models. Assisted with off-shore transition project by consolidating raw data into a usable format and loading that data into our audit processing software, then assigning the correct types and amounts of audits to the correct parties.Worked with a team of 5 using the DMAIC process to identify causes and possible solutions to get the turn around time (TAT) for bill processing within contract specifications of 3 days. We managed to streamline certain processes enabling the processing department to stay well under the 3 day TAT by cutting out approximately 30% non productive procedures.

Tucson, Arizona Area

Corporate Quality Auditor - Strategy & Process Audited a full sample range of processed Workers Comp bills for procedure and payment accuracy. Assisted with special projects. Maintained and exceeded quality standards of 99.5% Procedural, 98.8% Financial, and 99.1% of Payment. More than once obtaining 100% in all three standards. Was promoted to newly formed Performance Improvement Team in charge of auditing various operations to identify areas of potential improvement for all of Workers Comp Operations.Coventry Health was purchased by Aetna, so continued to work for same company afterwards.

Tucson, Arizona

Process workers comp insurance claims. Chosen solely to work with 3rd party pricing vendors Qmedtrix/Qmedworx. Trained others in 3rd party pricing due to being promoted from there to head a quality control team. Lead a team of 3 doing implant pricing (from Clinical Validation) and high dollar ($50k+ per claim) quality control.

Medical Insurance Coding Specialist/Coder

I have 16 years in medical insurance claims. Processing, auditing, process improvement, and analyzing/reporting. Currently becoming.

License, Church, A

Licensed Minister. Can legally perform marriages and funerals.

Business Administration And Management, General