Raphael Guzmán Email & Phone Number

Houston, Texas, Us

Houston, Texas, Us

Houston, Texas, Us

Houston, Texas, Us

- Designed, developed, and deployed a SaaS product: DataJoint Playground. It is a scalable, interactive compute environment supporting 430+ users. 𝑲𝒖𝒃𝒆𝒓𝒏𝒆𝒕𝒆𝒔, 𝑫𝒐𝒄𝒌𝒆𝒓, 𝑱𝒖𝒑𝒚𝒕𝒆𝒓, 𝑶𝑰𝑫𝑪, 𝑴𝒚𝑺𝑸𝑳, 𝑷𝒚𝒕𝒉𝒐𝒏, 𝑱𝒂𝒗𝒂𝒔𝒄𝒓𝒊𝒑𝒕, 𝑨𝑾𝑺- Designed, developed, and maintained a CLI utility: kube. It is a Kubernetes cluster provisioner and common cluster interface that abstracts the underlying infrastructure. 𝑩𝒂𝒔𝒉, 𝑫𝒐𝒄𝒌𝒆𝒓, 𝑨𝑾𝑺, 𝑲𝒖𝒃𝒆𝒓𝒏𝒆𝒕𝒆𝒔- Principal maintainer for the DataJoint open-source framework. It is a framework for scientific workflow management. 𝑷𝒚𝒕𝒉𝒐𝒏, 𝑴𝑨𝑻𝑳𝑨𝑩, 𝑴𝒚𝑺𝑸𝑳, 𝑺3, 𝑫𝒐𝒄𝒌𝒆𝒓, 𝑮𝒊𝒕𝑯𝒖𝒃 𝑨𝒄𝒕𝒊𝒐𝒏𝒔, 𝑵𝒐𝒔𝒆𝒕𝒆𝒔𝒕𝒔, 𝑺𝒑𝒉𝒊𝒏𝒙- Designed, developed, and maintained a MySQL OIDC PAM. It allows authentication into a MySQL database to be coordinated with an OIDC authority service. 𝑹𝒖𝒔𝒕, 𝑴𝒚𝑺𝑸𝑳, 𝑫𝒐𝒄𝒌𝒆𝒓, 𝑶𝑨𝒖𝒕𝒉2, 𝑷𝒚𝒕𝒉𝒐𝒏- Designed, developed, and maintained DataJoint LabBook: a graphical user interface to facilitate working with DataJoint computational pipelines. 𝑹𝒆𝒂𝒄𝒕, 𝑻𝒚𝒑𝒆𝒔𝒄𝒓𝒊𝒑𝒕, 𝑷𝒚𝒕𝒉𝒐𝒏, 𝑷𝒚𝒕𝒆𝒔𝒕, 𝑴𝒚𝑺𝑸𝑳, 𝑫𝒐𝒄𝒌𝒆𝒓, 𝑺𝒑𝒉𝒊𝒏𝒙, 𝑮𝒊𝒕𝑯𝒖𝒃 𝑨𝒄𝒕𝒊𝒐𝒏𝒔, 𝑮𝒊𝒕𝑯𝒖𝒃 𝑷𝒂𝒈𝒆𝒔

San Ramon, California, Us

𝐏𝐫𝐞𝐝𝐢𝐱 𝐓𝐢𝐦𝐞 𝐒𝐞𝐫𝐢𝐞𝐬 𝐀𝐝𝐦𝐢𝐧 𝐓𝐨𝐨𝐥𝐬 (3 𝐝𝐢𝐫𝐞𝐜𝐭 𝐫𝐞𝐩𝐨𝐫𝐭𝐬)- Led development efforts of a web app solution for administration of Time Series data on GE PaaS, Predix.- Deployed using Cloud Foundry hosted in AWS connecting to data source via JSON REST calls in Node with UAA support.- Extracted data was synchronized with Postgres under a modular API architecture to provide new functionality unavailable in original RESTful services.- User management provided by UAA service deployment with session authentication and token mitigation.𝐒𝐨𝐮𝐭𝐡32 𝐌𝐢𝐧𝐢𝐧𝐠 𝐂𝐨𝐦𝐩𝐚𝐧𝐲 ($2𝐌𝐌)𝘔𝘰𝘣𝘪𝘭𝘦 𝘈𝘴𝘴𝘦𝘵:- Developed and deployed a Python program to stream mobile asset data into Predix Time Series for machine and equipment health evaluation.- Connected to SQL via JDBC to publish on MQTT topics awaiting RESTful processing.- Supports auto-backloading and collection at a sampling rate of every 10 sec.- Configured Predix Machine to subscribe to topic messages and send on a Web Socket river into Predix Time Series.𝘍𝘪𝘹𝘦𝘥 𝘈𝘴𝘴𝘦𝘵:- Using Confluent, configured Kafka, Zookeeper, Schema-Registry, and Connect servers to support messaging stream collecting at a sampling rate of every sec.- Added custom JDBC source connector and StreamReactor MQTT sink connector to provide a river to MQTT topics.- Wrote a protocol adapter to operate as an iProcessor to integrate REST response with GE Predix Machine product as an array of objects and use storeforward in the event of connection drops.𝐀𝐧𝐚𝐝𝐚𝐫𝐤𝐨 𝐏𝐞𝐭𝐫𝐨𝐥𝐞𝐮𝐧 𝐂𝐨𝐫𝐩𝐨𝐫𝐚𝐭𝐢𝐨𝐧 ($5𝐌𝐌)𝘗𝘳𝘰𝘷𝘪𝘴𝘪𝘰𝘯 𝘚𝘦𝘳𝘷𝘪𝘤𝘦:- Developed and deployed a .NET C# Windows service to manage 5MM tags and 600M assets collecting at a sampling rate of every 30 sec.- Connected customer SCADA system (CygNet) via ODBC to both SQL DBs and to Historian: a proprietary GE Time Series DB.- Developed audit, monitoring, admin, and client tools for validation and increased customer confidence.

Houston, Texas, Us

𝐖𝐞𝐛 𝐀𝐩𝐩 – 𝐎𝐫𝐛𝐢𝐭: 𝐃𝐫𝐢𝐥𝐥 𝐁𝐢𝐭 𝐀𝐧𝐚𝐥𝐲𝐬𝐢𝐬 𝐓𝐨𝐨𝐥 𝐟𝐨𝐫 𝐃𝐞𝐬𝐢𝐠𝐧 𝐎𝐩𝐭𝐢𝐦𝐢𝐳𝐚𝐭𝐢𝐨𝐧𝘐𝘯𝘵𝘦𝘯𝘵:- Solve complex drilling mechanics problems accommodating large levels of inputs specified by client via dynamic iterative modelling ran on a server called upon instance of client session in Orbit.𝘍𝘶𝘯𝘤𝘵𝘪𝘰𝘯𝘢𝘭𝘪𝘵𝘺 𝘤𝘰𝘮𝘱𝘳𝘪𝘴𝘦𝘥 𝘰𝘧 𝘵𝘩𝘦 𝘧𝘰𝘭𝘭𝘰𝘸𝘪𝘯𝘨 𝘤𝘢𝘵𝘦𝘨𝘰𝘳𝘪𝘦𝘴 𝘧𝘰𝘳 𝘶𝘴𝘦𝘳 𝘮𝘦𝘵𝘳𝘪𝘤𝘴:- Iterative FEA on Cutting Structure Force/Torque response upon formation engagement, Nozzle Hydraulics Optimization, Structural Evaluation, and Heat Generation Management.𝘎𝘜𝘐 𝘊𝘰𝘯𝘵𝘳𝘢𝘤𝘵𝘰𝘳 𝘔𝘢𝘯𝘢𝘨𝘦𝘮𝘦𝘯𝘵 (𝘚𝘰𝘧𝘵𝘞𝘢𝘺 𝘚𝘰𝘭𝘶𝘵𝘪𝘰𝘯𝘴, 𝘈𝘎𝘐𝘓𝘌, 7 𝘱𝘦𝘰𝘱𝘭𝘦):- Created documentation, collaborated on UI/UX, assisted in middle tier architecture, attended weekly status meetings, and tested/validated all work.- Consisted of a light local user database on RAM/Hard Disk (display response).- Implemented a complete handshake between Orbit and iDM (Creo Custom Plug-In).𝘔𝘢𝘵𝘭𝘢𝘣 𝘗𝘳𝘰𝘥𝘶𝘤𝘵𝘪𝘰𝘯 𝘚𝘦𝘳𝘷𝘦𝘳 (𝘔𝘗𝘚) 𝘢𝘭𝘨𝘰𝘳𝘪𝘵𝘩𝘮 𝘥𝘦𝘱𝘭𝘰𝘺𝘮𝘦𝘯𝘵 / 𝘱𝘳𝘰𝘵𝘰𝘵𝘺𝘱𝘪𝘯𝘨:- Communicated to client via C# calls from web application.- Consisted of a dedicated solver utilizing static libraries available on HPC (incorporating higher cores, parallel computing, multi-threading, queue management procedures, and user account management).𝘜𝘴𝘦𝘳 𝘙𝘦𝘢𝘤𝘩: 𝘔𝘢𝘹𝘪𝘮𝘶𝘮 𝘰𝘧 100 𝘰𝘯 𝘥𝘦𝘱𝘭𝘰𝘺𝘮𝘦𝘯𝘵.𝐏𝐓𝐂 𝐂𝐫𝐞𝐨 𝐂𝐮𝐬𝐭𝐨𝐦 𝐓𝐨𝐨𝐥𝐊𝐢𝐭 𝐀𝐩𝐩 – 𝐓𝐢𝐩 𝐏𝐫𝐨𝐟𝐢𝐥𝐞 𝐆𝐞𝐧𝐞𝐫𝐚𝐭𝐨𝐫 (𝐯𝐢𝐚 𝐢𝐃𝐌) 𝐟𝐨𝐫 𝐃𝐫𝐢𝐥𝐥 𝐁𝐢𝐭 𝐃𝐞𝐬𝐢𝐠𝐧 𝐀𝐮𝐭𝐨𝐦𝐚𝐭𝐢𝐨𝐧- Intent was to automate Drill Bit CAD design development by allowing end user to specify relevant parameters rather than designing each feature in order to indirectly (via several iterations) converge on the desired result.- Designed and wrote algorithms for geometric CAD manipulation in C++ VS environment.

Houston, Texas, Us

- Rotated through various technical roles. (SC-CON, TSE-RMD, DSE-OKC, ME-CON, PLE-CON)- Attended diverse training modules wrt land and offshore drilling practices.- Suggested, designed, created and implemented a DSE benchmarking tool (OptiBit) via Excel VBA. Ultimately it became a new NOV global field standard for analyzing and presenting offset bit run data.- Designed and analyzed cutting structures utilizing CFD and HYDI.

Houston, Tx, Us

- Conducted time studies for night shift assembly and testing areas.- Analyzed procedure in order to identify steps that would improve process flow.- Worked hands-on with technicians and passed on their suggestions to management.

Houston, Tx, Us

- Gave an hour-long technical presentation covering an overview of Measurement Systems products and their sales market behavior in Latin America (Pittsburgh, PA – Latin American Conference 2012)- Researched and presented market indicators for V&M (oil rigs, gas prices, etc.)- Saved approximately $16,000 by assisting in the construction of an updated pricebook including our most recent discounts and quotes for developing meter skids for Linco Metering Solutions

- Assisted in the preparation of proposals for government projects- Prepared spreadsheets for materials required for each project- Assisted in the development of marketing strategies

Houston, Tx, Us

- Developed a method for rapid prototyping of microfluidic channels- Researched and evaluated past methods and journals- Conducted experiments on fabrication and flow of microfluidic channels- Wrote technical reports and presented results