Josh Rosenstein

PETROLEUM ENGINEER, DATA ANALYST

BACKGROUND

My name is Josh Rosenstein I am a Petroleum Engineer, self-taught programmer, and an open-source contributor. I am passionate about tackling complex problems and transforming them into clean and simple systems by utilizing my ingenuity and programming skills. Currently seeking full-time employment related to Petroleum Engineering, Data Science and/or full-stack development.


Experience

Business Intelligence Engineer

WPX Energy

• Working within the Innovation Team and with the operational teams to develop and support custom business intelligence and analytics solutions using Python, R, SQL, JS, Spotfire and PowerBI.

• Review and analyze the accuracy and efficiency of existing business processes, systems and technologies and develop strategies for improving or leveraging these systems.

• Identify the need for interfaces and integration between application repositories to improve data sharing and analysis for business decisions.

• Worked on many optimization projects, new tool development, and built creative solutions for ad-hoc problems.

• Promote adoption of appropriate utilities and applications for business users that provide productivity enhancements and more accurate and timely business decisions.

Projects : InnRetro (Python-SQL-Spotfire-R-JS) • Aries Archiver (Python, SQL) • InnSpotty (JS-R) • DOSS (OpenWells-SQL-Spotfire-R-JS) • InnSpace (Python-SQL-Spotfire-R-JS) • InnFlow (SQL-Spotfire-R) • HzLander (Python) • Datavision 2.0 (SQL)


Python
R
SQL
Spotfire
JavaScript
Aug 2019 - Mar 2021

Learning Web Devlopment

Self

• Took time off from work to spend 100% focus on learning how to build modern applications

• Completed two fundamental golang courses from greatercommons

• Rewrote a utility library to strengthen fundamental functional javascript skills (204 exported functions)

• Contributed to open source projects

• Developed my own open source projects

• Comfortable with react API as of v16.8.+

• Began writing/learning typescript since 12/19

• No prefered state managment as of now, but familiar with Redux, Mobx and React hooks (local). Watching overmind & xstate


NodeJS
JavaScript
TypeScript
React
GO
Nov 2017 - Aug 2019

Production Lead RDO Engineer

Rice Energy

• Create processes and workflows to standardize, simplify and optimize standard techniques, procedures and criteria

• Research new techniques, technologies and/or methodologies to improve business performance.

• Develop new applications, insights while optimizing and improving current processes

• Provide enhanced workflows and applications to support engineered tasks/decisions

Projects : ShinyRosey Sever (R-Rshiny) • Production Month End Close Audit App (R-Rshiny-SQL) • Month End Forecast Workflows (Spotfire-Salesforce-SQL) • Production Water Forecast Insight (Spotfire-Alteryx-SQL) • D&C KPI's Insight (Spotfire-Alteryx-SQL)


R
Rshiny
SQL
Spotfire
Salesforce
Alteryx
Nov 2016 - Nov 2017

Drilling Development Engineer

Rice Energy

• Create processes and workflows to standardize, simplify and optimize standard techniques, procedures and criteria

• Assists in designing, preparing and performing drilling operations

• Assists in the planning and management of drilling operations by setting, implementing and tracking drilling goals.

• Provide enhanced workflows and applications to support engineered tasks/decisions.

Projects: Pason Web Scraper (R-Alteryx-Spotfire) • WellArc Survey Interpolation (SQL-R-Alteryx-Spotfire) • Smartsheet Glancer (Operation Schedule Insight) (SQL-Alteryx-Spotfire) • Automated Drilling Prognosis Tasks (Excel-VBA) • Automate Drilling Daily Report Spotfire (Wellview-SQL-Spotfire) • Bloogle - Wellheader Search Insight (Salesforce-Alteryx-Spotfire)


R
Alteryx
Spotfire
SQL
VBA
May 2016 - Nov 2016

Completions Development Engineer

Rice Energy

• Main objective was to direct, monitor, optimize, create and amalgamated processes across the completions department

• Create processes and workflows to standardize, simplify and optimize standard techniques, procedures and criteria.

• Conducts analysis on wells and fields.

Projects:NPT Tracker (Excel/VBA-Access/VBA) • Frac Performance Insight (Spotfire) • Custom Wellview Import Addons (Wellview-VB.NET) • Perf & Frac Design Tool (Excel/VBA) • Variable Rate Pump Design (Excel/VBA) • Bid Analyzer (Excel/VBA) • AFE Calculator (Excel/VBA) • AFE Brute Force Forecaster (Excel/VBA) • Drill out Performance Tracker (Excel/VBA-Spotfire) • Fiber Optics Analysis (R-Alteryx-Spotfire) • Enhanced Completions Daily Report (Excel/VBA)


Wellview
VB.NET
Spotfire
SQL
VBA
Acess
Excel
Feb 2015 - May 2016

Completions Engineer

Rice Energy

• Designing, preparing and performing well stimulations and workovers for new and existing wells.

• Assists in the planning and management of completions operations by setting, implementing and tracking completions goals.

• Monitor economic status of well fields, requests/reviews bids for work to be performed, and recommends contractor and equipment

• Provide recommendations that optimize completion design.


Excel
VBA
Aug 2014 - Feb 2015

Education

Petroleum Engineering

Texas A&M University

Bachelor's Degree
2009 - 2014

First Lieutenant Black Horse Troop

Culver Military Academy

High School
2007 - 2009

PROGRAMING & FRAMEWORKS

  • R

  • Python

  • SQL

  • Javascript/TypeScript

  • React

  • R Shiny

  • VBA

  • GO

  • VB.NET

  • Java

APPLICATION EXPERIENCE

  • Spotfire

  • Docker

  • Power Bi

  • Excel

  • Access

  • Wellview

  • Alteryx

  • Salesforce Dev

Contact