Marisa D. Thompson

***** **** ****** **., ******, TX 77346, 713-***-****

SUMMARY

Over 20 years of experience working as a Systems and Data Analytics Consultant. Experience supporting multiple business groups including Project Controls, Petroleum Engineering, Oil & Gas Law Function, and OG&C Procurement. Demonstrates leadership and teamwork skills with the ability to accomplish various tasks under minimal supervision. Provides data integration support for Enterprise data environments to extract, transform and load production data from disparate sources.

TECHNICAL SKILLS

MS Power BI Desktop v2.93, SAP Business Warehouse, TOAD for Oracle 12.8, DataBroker 2.3, Informatica 5, 7, MS Data Transformation Services, SQL Server Report Builder, Crystal Reports, Cognos Impromptu, Embarcadero ER Studio, SharePoint, Remedy Help Desk Ticketing System, MS Office 365 ProPlus, MS Viso

PROFESSIONAL EXPERIENCE

TC Energy, Houston, TX July 2019 – Apr 2022

Program Analyst

•Develops Power BI reports for GPMC West stemming from the Capital Program analysis.

•Builds forecast and variance data for monthly Power BI reports during WD performance reviews.

•Assists management through a wide variety of reports and data requests regularly and on an ad-hoc basis.

•Works closely with U.S. Gas Projects Leadership Team and Project Technical Services to analyze project forecast data, expenditures and progress components of the Capital portfolios and projects.

•Collaborates with GPMC West Project Controls team members, providing reporting support as needed.

•Participates in program team meetings assuring project progress, expenditures, forecasts, and variance analysis is presented to program management personnel.

•Participates in program and portfolio reviews and partners with individuals to accomplish objectives.

•Responsible for creating monthly WD PowerPoint presentations for GPMC West Director, while maintaining Power BI reports and data integrity.

Bechtel Oil, Gas and Chemicals, Houston, TX July 2011 – Feb 2019

Sr. Systems Analyst

Cricket Valley Energy Project, Dover Plains, NY (Nov 2018 – Feb 2019)

Pennsylvania Chemicals Project, Houston, TX (Jul 2018 - Nov 2018)

Bechtel OG&C Global Projects, Houston, TX (Nov 2017 - Jul 2018)

Corpus Christi Liquefaction Project, Corpus Christi, TX (Sept 2015 – Nov 2017)

Sabine Pass Liquefaction Project, Houston, TX (July 2011 – Sept 2015)

•Supported Bechtel Procurement System’s suite of applications and Oracle production database used by Engineering, Procurement and Construction departments.

•Working closely with Procurement Project Manager, provided ad-hoc SQL reports to support management’s daily decisions.

•Created ad-hoc SQL reports for all Procurement functions as needed.

•Worked closely with Procurement Project Manager, Engineering, Materials Manager and GE subcontractor to validate Shipping Bill of Material against Aconex drawing documents.

•Successfully managed all GE SBOM data communication, transfers and uploads between GE subcontractor and Bechtel’s receiving team.

•Application troubleshooting and resolution of all BPS technical issues, taking corrective action in a timely manner.

•Troubleshooting and resolution of high-priority Accounting issues derived from BPS Insevo technical report.

•Created ad-hoc SQL reports for Procurement personnel as needed for decision making.

•Created and maintained SSRS reports for Project Procurement Dashboard using MS SQL Server Reporting tool.

•Ran Oracle database procedures to update BPS with weekly Spool Status, MTO, and MRR Report from Yanda contractor.

•Created and maintained database tables and views supporting BPS suite of applications.

•Loaded external material requisition data via TOAD for Oracle from multiple Engineering disciplines.

•Trained end users via Skype across BPS OGC global projects as needed.

•Granted system access to all users to BPS application and Active Directory.

Devon Energy, Oklahoma City, OK Dec 2009 - Dec 2010

Business Systems Analyst (contract)

•Assisted Project Managers with requirements gathering for several Shared Services projects as part of Devon’s U.S. and Canadian consolidated IT functions including Visual Source Safe to TFS 2010, Citrix Consolidation, Oracle 10.2.0.4/SQL Server 2008 database upgrades.

•Interacted with business users to conduct needs assessments, gather systems requirements, identify application solutions, and determine integration strategies for all responsible projects.

•As the liaison between the Database Administrators and Business Units, responsible for the coordination and scheduling of all Oracle database upgrades.

•Interacted with stakeholders, Systems Administrators, Application Developers, and Database Administrators through interviews to document project requirements, used for testing procedures.

•Maintained all project-related documents on SharePoint shared site.

•Created and maintained MS Access database of company applications with related owner and business information to run queries for assistance with project-related statistics.

•Created ETL method to extract, transform and load legacy data from disparate Access databases for SAFE Project.

•Extracted and transformed legacy data from ProAct database to load to new SAFE database.

•Interacted with the EHS business users to conduct needs assessments, gather systems requirements, and identify application solutions.

•Provided daily support to Devon Corporation Incident Management System (DCIMS), MS SharePoint department shared sites, Web Publisher department sites, and document changes.

Anadarko Petroleum Company, The Woodlands, TX May 2009 - Aug 2009

Data Quality Analyst (contract)

•Successfully created a methodology identifying parent/child well records within units flagged in well database.

•Used methodology to add new child wells currently not represented in well database.

•Responsible for the extraction and transformation of unit/lease wells from internal well database.

•Responsible for the extraction of data sets from IHS and state databases using TOAD, MS Access and Excel 2003.

•Wrote SQL queries and statistics on data to analyze the severity of data quality issues.

•Validated existing data to compare and identify problem records.

•Corrected invalid and incomplete data using state regulatory databases and/or well files.

•Removed duplicate records and safely merge data from different source/record IDs.

•Presented findings to client using Visio diagrams and descriptive flow charts.

Marathon Oil Company, Houston, TX Oct 2008 - May 2009

Data Quality Analyst (contract)

•Responsible for managing E&P data cleansing for drilling and completions including well header, drilling, production, and open and case hole log data.

•Wrote SQL queries and statistics on data to analyze the severity of data quality issues.

•Validated existing data using software applications such as WellView to compare and identify problem records.

•Corrected invalid and incomplete data using state regulatory databases and/or well files.

•Removed duplicate records and safely merge data from different sources/record IDs.

•Supervised findings and data solutions from research team and technical developers.

•Responsible for documentation of detailed procedures for research and development team.

•Responsible for MS Project timeline and detailed status reports describing progress of project.

•Wrote and applied business rules to assess data accuracy in source systems.

•Extracted, transformed and loaded various data sets using TOAD, MS Access and MS Excel 2003.

•Presented findings to client using Visio diagrams and descriptive flow charts.

•Verbal and written communication with internal IT Project Manager, Petroleum Engineers, DBA, IHS, Inc. and members of state regulatory body.

Aim Investments, Houston, TX Jan 2008 - Mar 2008

Informatica Developer/Database Analyst (contract)

•Successfully completed temporary assignment to deliver Source-to-Target mappings for Executive Reporting data warehouse and data marts.

•Retrieved data from major source systems including SQL Server 2000, Oracle 9i, Oracle 11i Financials, Siebel, and PeopleSoft.

•Provided production support of existing Informatica workflows as needed.

•Responsible for ETL production mappings and workflows using major Informatica transformations and reusable objects.

•Ran daily SQL Server and Oracle queries for data analysis, data completeness and elimination of data redundancy.

•Created detailed design documentation of source to target mappings.

•Used ER Studio to create SQL scripts to modify database objects for use in Informatica mappings and workflows.

•Use of Remedy Help Desk/Change Management system to request move of database and Informatica objects between development, testing and production environments.

Chevron, Houston, TX June 2001- Mar 2007

Data Integration Analyst (contract)

•Responsible for the development, migration and support of major data structures for Royalty Information System data warehouse.

•Conducted system analysis of legacy database schemas to determine migration feasibility.

•Worked with development team to design proposed RIS data warehouse architecture.

•Detail design of Informatica mappings and workflows to load historical and current financial, property/owner, well completion and marketing data from Chevron and Texaco distributed databases.

•Designed RIS Agreement mappings and workflows from Oracle stored procedures and scripts.

•Optimized Oracle queries for data analysis to resolve orphan data, verified data completeness and eliminate data redundancy.

•Monitored Informatica workflows during Evergreen Process to update RIS production database.

•Quickly provided resolution of interrupted Informatica workflows during Evergreen Process run.

•Provided documentation of mappings and workflows used for Evergreen Process run.

•Converted Oracle database objects to accommodate conversion efforts of source data from Premas to SAP/PRA.

•Provided application support of Introspect and Legal Advantage web applications.

•Wrote T-SQL queries used to created new users, adjust security groups and system privileges.

•A liaison between customer and L2/L3 support for the Introspect and Legal Advantage Web applications.

•Conducted training to land men on functionalities of ViaVista well application to provide legal land descriptions of production wells for litigation purposes.

•Conducted training courses to end-users of global Law Function group.

•Provided technical writing expertise for Law Function Information System training manual using MS Word, Visio, SnagIt, RoboHelp.

•

EarthAmerica, Houston, TX Jan 2000-June 2001

Application Developer

•Successfully converted customer and payment data from MS Access database to MSSQL Server database via Query Analyzer and Data Transformation Services (DTS).

•Used Crystal Reports tool for statistical and end-user reports that interfaced with the OS2K application.

•Successfully migrated classes and objects of SilverStream platform to upgraded version.

•Developed core modules of OS2K web application using the latest development tools: SilverStream Application Server, Macromedia Dreamweaver MX, ASP, VB Script, Java, HTML, and DHTML.

•Assisted in system and database design using Rational Rose UML tool and Microsoft Visio 2000 on a SQL Server database.

•Responsible for bug fixes and application enhancement after OS2K system roll-out.

•Provided system administration tasks including nightly rebuild of SilverStream objects.

•Monitored and bounced server as needed; adding users to security groups; reset passwords; resolved technical issues.

EDUCATION

University of Houston-Downtown, Houston, TX

Bachelor of Business Administration

Concentration: Computer Information Systems

Contact this candidate