Hi, I'm Sop, a Software & Data Engineer from Houston, TX.

ABOUT ME

I am a software and data engineer leader with 20+ years of experience heavily specialized in data management, data integrations, and data services.  All technical solutions run on data. It is the area that on average consumes about 80% of the work and costs, yet gets taken for granted. I usually get called in for 2 things: To simplify and solve a complex data problem, or to clean up an unsuccessful data solution aka "a mess."

I can: 

• Design and architect

• Build and deploy

• Manage and maintain

Currently, I freelance short-term projects through Squared Info LLC.  On the side, I help support as a principal consultant for my previous technical consulting firm called OPASOL.  

AREAS OF EXPERTISE

Industry: Energy SaaS
Client: ComboCurve
Work: Vice President of Engineering, Integrations and Data.  Scaled and managed a team of software engineers, data scientists, data consultants, architects, Security Ops, and I.T. to accommodate the rapid growth of its flagship software, new product lines, and data service offerings.  The headcount more than doubled from 30 to 65 in six months, internal and external.  Acted as the lead architect in the software, cloud, data and integrations facets. Met with clients from small and big (Fortune 50) to provide support and explain the technology to all units and levels of the business. Mentored and coached junior to principal engineers. Created career and succession paths. Developed 1 year, 2 year, and 5 year engineering and technical roadmaps.  Facilitated more structure and metric driven execution including more agile tactics, devops, triage, disaster recovery, business continuity, team structures. Was the central Data expert internally and externally. Created a lean data ops team to integrate client data into the cloud software. Addressed technical debt, stability, performance, quality, and work prioritizations.  Reviewed and audited new technologies and potential acquisitions. 
Technology: GCP, AWS, Microsoft Azure, OpenWells, P2 Merrick, Quorum Land Suite, ComboCurve, Landmark Aries, IHS Harmony, Quorum Mosaic, ValNav, Tibco Spotfire, Power BI, Enverus, IHS, TGS, MongoDB, PostgresDB, Windows Servers, Docker, Kubernetes, Redis, Snowflake, Datalake, Change Data Capture, REST API, Microservices, Big Query, Synapse, Redshift, Data Share, Jira, Salesforce

Industry: Upstream Oil and Gas
Client: Confidential / Permian operator
Work: Architect and build of entire data and cloud service, including infrastructure,  for operated and non-operated streams. This includes lift-and-shfit of data, live ingestions, transformations, reporting, analytics, and data management. We digitalized unstructured data (pdfs, excels, csv, ascii, LAS, etc) and normalized it to a central repository. 
Technology: Microsoft Azure, OpenWells, P2 Merrick, Quorum Land Suite, ComboCurve, Petrel, SLB Delfi, Office 365, Landmark Aries, Tibco Spotfire, Power BI, Enverus, IHS

Industry: Oil and Gas / Manufacturing
Client: Confidential
Work: Ingested live data from the drilling rigs, then processed, analyzed, and applied proprietary algorithms and advanced analytics to stream into visuals.
Technology: Microsoft Azure, Apache Software Suite, WITSML

Industry: Upstream Oil and Gas
Client: Equinor
Work: Migrate and integrate upstream data including subsurface, land, reservoir, well construction, production, and financial to the cloud for centralization, advanced processing and analytics.
Technology: Microsoft Azure, Aries, Cisco Information Server, OpenWells, P2 Merrick, Quorum Land System, Energy Navigator, Energy Link, IHS, DrillingInfo, Petrel, SAP, PDFs, Enersight, Cygnet, Reltio

Industry: Energy software
Client: Confidential
Work: Designed and built custom cloud solution to integrate well construction plans, estimates, field costs, and invoices into a unified cost data model in order to achieve auto-reconciliation and detect, predict and prevent cost overruns and leakages.
Technology: Microsoft Azure, Power BI, Rimbase, DSOUpstream, Enertia, SAP R3, OpenWells, WellView, Enersight, AFE Navigator

Industry: Upstream Oil and Gas
Client: Statoil
Work: Build and lead US Onshore data governance, quality, reporting, and advanced analytics and visualizations.
Technology: Microsoft Azure, Tibco Spotfire, Power BI, SAP BW, SAP HANA, Oracle RDMS, Master Data Management, PPDM

Industry: Upstream Oil and Gas
Client: Statoil
Work: Procure, deploy, integrate, and maintain various oil and gas line-of-business software suites. Migrated and/or retired solutions after acquisitions.
Technology: Landmark EDM, P2 Energy, DSO Upstream, AFE Navigator, Energy Components, SAP R3, ServiceNow, DiscoveryWell, PDS, Data Scavenger

Industry: Upstream Oil and Gas
Client: Devon Energy
Work: Lead data and application services. Designed and built custom line-of-business solutions for business areas like HR, Procurement, Exploration and Drilling, Master data management, Records management, legal, enterprise search. Successfully ran $30M SAP conversion sub-project of major SAP roll-out with Accenture. Migrated, merged, and retired solutions from 27 acquisitions.
Technology: Microsoft SQL, .NET, Oracle RDMS, SAP, Tobin P2, WellView, Informatica, Opentext

Industry: Upstream Oil and Gas
Client: Cimarex
Work: Build custom approval for expenditure system.
Technology: Microsoft SQL, .NET, Opentext 

Industry: Upstream Oil and Gas
Client: Southwestern Energy
Work: Build custom approval for expenditure system and records management system.
Technology: Microsoft SQL, Bengal AFE, Opentext

Industry: Refinery / Factory
Clients: Shell, Huntsman, BP, Nova, Lyondell Basell, DOW, Hershey, Arizona Public Services, Air Liquide
Work: Designed and built SCADA, alarm processing, and historian solutions for the offshore rigs and chemical processing refineries.
Technology: OSIsoft PI, AspenSoft, Emerson DeltaV, Cygnet

RANDOM PROJECTS / FREELANCE WORK

• PDF scrapper for drilling, completions, and production volumes reports

• Dental practice management software and analytics

• MMORPG bot

• Various Excel and MS Access "programs"

SPEAKING ENGAGEMENTS

Get in touch at sopm@squaredinfo.com