Terry Willis Email and Phone Number

Independent consulting.

• Provided analytical support to the Vice-President Legal Compliance Counsel in the form of Excel formulated spreadsheets, PowerPoint presentations/wireframes, data mining, file management, private shared drive set up, ETL/FTP data transfer, and facilitator for set up of Zoom video meetings working remotely from Houston, Texas. • Sunshine Act/Open Payments optimization to determine aggregate spend compliance of healthcare organizations & providers. Compiled spend activity reported to CMS.Gov (Centers for Medicare & Medicaid Services). • Accessed Coupa procurement, Concur travel & expense, Intacct payables, MedPro state licensing, 3rd party vendors.• Project Lead to build-out and implement the Tact Application software to improve the Salesforce/Veeva sales team customer relationship management to maximize sales revenue. Collaborated with legal compliance, sales, finance, IT, and counterparts in India. Statement of Work, System Integration Testing, User Acceptance Testing, Documentation, Go-Live.• Used Salesforce Veeva to determine email open rates, improve sales team process, monitor advertisement and legal compliance. Involved Logging Calls, Interaction Type, Discussion Topic, and Marketing Materials Used.

• Data mining and reporting of demographics and key performance indicators at the Dimmit County Migrant Emergency Intake Facility, a temporary holding site for illegal teenage children in Carrizo Springs TX. • Created Excel spreadsheets & graphs, PowerPoint presentations & flow charts, reported findings to the Director of Quality.• Process improvement of operations, enhanced standard operating procedures, and improved records management.• Created a flow chart to assist case managers with significant incident reporting, maintained the Youth Master Care Admin. Excel spreadsheet, and constructed a diagram of the emergency intake site process for human information management.

• Auditing and quality control verification of all freight received and shipped in the Inventory Control Center (ICC). • Using the Catalyst Inventory Control database, input, verify, correct and shelve thousands of items of merchandise to be shipped to more than 1,600 Dollar Tree and Family Dollar stores in Texas alone.• Daily slotting, problem resolution, inventory maintenance, and store order shipping at the distribution center.• Packaging, labeling, bill-of-materials, and bill-of-lading for trailer packets, truck routing and delivery.

• Created graphs and spreadsheets (macros, pivot tables, v-look ups, formulas) in Excel and presentations in PowerPoint for reports the Corporate HSE Director presented to the Board of Directors. Calumet partners with oil refineries.• The Director’s source to data mine, extract, graph and report HSE metrics, KPIs and management of change (MOC). • Implemented much needed organization by enhancing their SharePoint intranet site, set up a private shared drive of crucial computer data files and folders.• Used their OHM Safety database for the HSE Director’s reporting, metrics collection, and corrective action from oil refinery facilities. • Populated the monthly Scorecard with occupational, process, and environmental safety incidents, reported TRIR, LTIR, and Federal Spills. • Facilitated conference calls as the scribe to disseminate call notes from each plant facility. • SAP procurement and fulfillment of purchase orders.

Freelance technical consultant working with PHDWin reserve data on an "as needed" basis. Manipulate proved producing volumes, cash flow reports, Excel files, calculated gas shrinkage and modified production decline curve projections for client’s reserve reports in the Oklahoma and Texas regions.

Comprehensive engineering data management for the Latin America Business Unit (LABU) as part of the Center of Excellence (CoE) group servicing Brazil, Venezuela, Argentina, YPF, Columbia, & Trinidad. Supported D&C Managers and Engineers.• Set up a private shared drive, organized, and managed electronic files, distributed WellView and non-op drilling reports, tracked GO-113 personnel work orders, business documents, and recorded meeting action items for the LABU Profit Centers. • Managed shared drive security access collaborating with IT for user permissions.• Custodian of the Contingent Labor Management (CLM) human capital database to track and maintain consultant Engineer and Drill Site Manager information related to Well Control Certification, using Excel and SharePoint.• Member of the Business Continuity and Emergency Management team to prepare staff for disaster safety and recovery.• Apply technical assistance to Engineer’s frac study to load clusters and volumes into Excel to analyze in Spotfire.• Construct Organization Charts, PowerPoint presentations, Excel spreadsheets, and SharePoint document management for management of change (MOC).

Technological support of the Production Manager and the Engineering team for Workover Expenses for work done in the North Dakota and Montana regions.• IT liaison for automation of reports accessing OpenWells for Well failure reporting, root cause analysis, and preventive action. Technical and business skills are used to partner with IT, the Engineering team, and Field Superintendents. • Design, document and implement automated software tools to extract Well failure data to display/analyze on one screen.• Taught new software tools to users during “Go Live” role out using hard copy and over-head projector presentations.• Created AFEs for Well work using the Enertia accounting system and daily interaction with the accounting dept.• Gathered and presented to management monthly Expense Accruals using the Enertia database, spreadsheets, other KPIs.• Ran queries of monthly Well inventory, days on location, wellbore equipment, cost, & LOE overhead, using Data Analyzer.• Maintained weekly Excel production volumes charts for budget vs. actuals variance reports reviewed by management.• PwC audits as a Control Performer to monitor internal controls processes of financial reporting and SOX compliance.• Extracted ARIES propnum data for budgetary, production, and reservoir purposes.

Worked on the Angola LNG Project supporting Engineers in process improvement and business analysis.•Trained Engineers to use SharePoint for efficient document control, assisted with Technical Specifications and metadata.•Introduced WellView to the team for future drilling and completion database management, procurement and reporting.•Created PowerPoint presentations for management and subject matter experts (SME) quarterly meetings.•Tracked work orders (GO-113s) and service requests liaising with the cost accounting and contracts depts.•Designed flow charts for the group to enhance the organization and improve processes.•Custodian for shared drive file management.

Responsible for QAQC of the OpenWells database specific to Well Interventions of domestic operations (Ok, Tx, GOM).• QAQC of the OpenWells database and reports using Data Analyzer queries and manual input and correction of entries.• Set up new Wells in OpenWells for workover, recompletions, and Well servicing purposes.• Interaction with Managers, Superintendents and Well Site Leaders to maintain OpenWells data quality. • AFE tracking and SAP invoice reconciliation in support of cost analysts and the finance dept.• Trained Well Site Leaders in-field in all areas of OpenWells.• Championed supply chain process improvement and document control via Tableau, Flow Charts, and SharePoint.

Research and recreation of historical Wells using OpenWells and Profile for the purpose of designing and generating engineering wellbore schematics. Populate missing data and correct errors from downhole activity performed on Gulf of Mexico Wells. File management and document control. Fulfilled short-term assignment to centralize data from older Wells.

• Solely responsible for data in and out of the Drilling Information Management System (DIMS/OpenWells) database. International drilling/completions details and cost captured and reported to senior managers. Brazil & Egypt exploration.• Member of Steering Committee & Planning Group for testing and implementing OpenWells/WellView at El Paso Corp.• Track performance and operations of operated and non-operated, onshore and offshore Wells.• Solely responsible for oil and gas volumes in and out of the TOW/eVin Production database for the purpose of international sales for daily accounting and management reporting. • Technology liaison that automated their production system developing a software tool to extract and display pertinent data for charts and reporting, thus realizing a $65,000 company cost savings. User acceptance testing and documentation. • Limited SQL to go into the editor to change the string to allow the daily report output when not functioning properly.• Business analysis support of production activities, input daily volumes from the field, report totals to management, audit volumes, database maintenance, quality control, feasibility studies, create charts and graphs using Excel and Powerpoint.• Facilitate daily team meetings as the WebEx Administrator involving network audio-visual technology to share electronic documents in real time with other team members located in international countries.

Responsible for global Programs and Systems support in the Health, Safety and Environment (HSE) department.• Compiled safety statistical analysis for worldwide HSE actuals and estimates and submitted reports weekly to the Corporate HSE Director and senior management.• Report safety issues related to recordable injuries, vehicle accidents, safety training, and environmental impact.• Created HSE graphs and charts per business unit - Excel, Word, Powerpoint, Email, PDF & ZIP files.• Worked HSE issues via email, phone, and Netmeeting/Tivoli remote control which includes:- First Alert - HSE database troubleshooting, set up, safety reports, statistics changes, printing, etc.- Citrix HS&E Trac - set up, transfers, additions, archives, edits, roll-overs, add offices, personnel training- Active Directory - application permissions and security

• Provided technical support to Harris County Justice System employees using Service Center/Peregrine call logging.• Problem solving and troubleshooting techniques in a Windows NT operating system environment.• Performed routine maintenance on computing hardware, software applications, system security and LAN connectivity.

• Troubleshoot in a Call Center for hardware/software fixes, networked printers, LAN/WAN connectivity issues, user security administration, email profiles, software upgrades, password resets, rendering a single-point-of-contact for resolutions.• Ping IPs (Internet Protocols) to determine connection activity and apply fixes.• Technical support using the Helpdesk Expert Automated Tool (HEAT) ticket managing system.• Helpdesk support of SAP users in installation, requisitions, purchase orders, goods receipts, budget transfers, and reports.• Helpdesk support of PeopleSoft users in installation, time & labor, benefits, payroll, reports, static/dynamic groups, codes. The Team Lead of the PeopleSoft group that was the go-to person, attended administration level meetings.• PC deployment to all teachers and administrators to over 300 schools within the district.