Production Reporting Technician Resume

SUMMARY

I am seeking a position where my Operations Research, Mathematical Optimization, and Quantitative Analyst skills can be effectively utilized to improve operations. Applying mathematical programming to solve business needs, accelerate decisions, improve BI report, and contribute to the company profits

PROFESSIONAL EXPERIENCE

Confidential

Production Reporting Technician

Responsibilities:

Merrick System Analyst in the Engineering Operations Group
Support and training for inter - and intra- department on Production data, BI reports, and ETL of data volumes files
SME on complex SQL analytics projects on production data and facility setups (wells, tanks, meters, and equipment)
Lead on data transfer project of CygNet data files to Merrick to replace low performing DTS. Interface with system vender to resolve PowerShell error scripts and DTS setup aligned with business needs. Reduced one hour to few minute runtimes
Created Merrick BI reports tailored to business requests to replace troubled report. Applied new SQL, calculations, formatting, and parameters selection improving analytics and runtime from 1 hour to seconds

Confidential

Senior Engineering Technologist

Responsibilities:

Production Data Analyst in the Financial Planning and Reporting Team
Supported and trained on Production Data both inter- and intra- department (Leaderships, Operations, Finance, Engineer, IT, etc.). Worked closely with management on reporting integrity assurance and production/ resource optimization analysis
Lead on Spotfire BI visual Production KPI’s and Drill, Completion, Turn Over-to-Sales dashboards projects tailored to business requests to replace the manual analysis process. Applied mathematical optimization to data, automated assembly of structured SQL with unstructured Essbase data, and formatted the user-friendly charts, graphs, and tables
Reported daily KPI production to forecast analytics used by leaderships and business groups for effective decisions. Consulted with Field Engineers for explanations of wells (horizontal, vertical) status shifting production
Trained team on Drill, Completion, Turn Over-to-Sales well dashboard current to forecast data to draw appropriate actions of future costs, duration cases, and resource usage optimization from the various data visualizations
Worked with IT partners for well data projects for Engineering and Land requests. Identified and trained users on corporate resources (reports, database and SQL) to provide and understand the verified data
Transferred all of team’s Spotfire reports to centralize them onto the IT corporate network with user access privileges
Solved unique and long-term Spotfire issues (normalization, counting null fields, auto update of visual headers). Applied mathematical algorithms to normalized, Pivoting to convert null fields to fields. Partnered with Ruths.ai on advance coding

Confidential

Analyst

Responsibilities:

Production Systems Analyst in the Operations Applications Team
Support and training for Production data, ETL, and SSRS Reports both inter- and intra- department (Production Analysts, PI, Measurement Analysts, Field Automation, IT, etc). Worked closely with business owners to improve systems and data
Identified, initiated, and designed systematic SSIS tracking methodology to eliminate SCADA Production data issues. Worked with systems owners (Merrick, PI, Flow-Cal, InTouch) to update field setups and data for wells, tanks, and meters
Lead developer on SSIS projects, worked with system owners (Merrick, PI, Flow-Cal, IT) to replace troubled and slow ETL tasks. Improved data integrity, added schedule flexibility on IT’s MS Server, and reduced run times to few minutes. Applied multi-tasking optimization algorithms, SQL data merging, Coresight procedures, calculations, and errors checks
Worked with IT resources on business units requests on PAO’s SSRS Report Manager. Load and modify reports, set email subscriptions scheduling with parameters requests, and user access to site
Provided ad-hoc Merrick SQL data pulls for various projects with calculations requirements to draw appropriate conclusions

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship