Franz Carstens
Data Engineer at ACNSF- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
-
English Full professional proficiency
-
Spanish Native or bilingual proficiency
-
Portuguese Professional working proficiency
Topline Score
Bio
Credentials
-
edX Verified Certificate for Linux Commands & Shell Scripting
edXMay, 2022- Nov, 2024 -
edX Verified Certificate for SQL Concepts for Data Engineers
edXMay, 2022- Nov, 2024 -
Certificate for Relational Database
edXApr, 2022- Nov, 2024 -
Certificate for SQL for Data Science
edXApr, 2022- Nov, 2024 -
Python for Data Engineering Project
edXMar, 2022- Nov, 2024 -
Python for Data Engineering Project
edXMar, 2022- Nov, 2024 -
Certificate Python for Data Science
edXFeb, 2022- Nov, 2024 -
Certificate for Data Engineering Basics
edXFeb, 2022- Nov, 2024 -
Data Engineering Basics
edXFeb, 2022- Nov, 2024 -
Python Essentials
edXFeb, 2022- Nov, 2024
Experience
-
ACNSF
-
Brazil
-
Religious Institutions
-
1 - 100 Employee
-
Data Engineer
-
Sep 2017 - Present
Using RDBMS GUI, MySQL Workbench or phpMyAdmin Web interface and SQL statements to create and manage the tables in a relational database and populate them with data. Improve the integrity of the data by including the use of Primary and Foreign keys to define relationships, indexes, normalization, and relational model constraints. Performing advanced SQL operations within a database using table joins, stored procedures, views, ACID transactions. Creating an Entity Relationship Diagrams (ERD) for a specific use case that serves as the blueprint for the implementation of a database. Involving new tools and technologies for querying, manipulating, and processing data: Python, Power BI Dashboards, RDDMS MySQL, PostgreSQL and IBM DB2. Working with ETL tools such as PENTAHO Data Integration.
-
-
-
SLB
-
United States
-
Technology, Information and Internet
-
700 & Above Employee
-
Sr. Automation Engineer / HMI & PLC Programmer
-
Oct 2008 - Sep 2017
Design electrical schematics, wiring diagrams, assemblies and components using software tools (AutoCAD, Meridian). Developing of Process Control Systems using OMRON PLC / Programming Research and Analysis of product specifications & technical information of all major power electrical equipment including transformers, circuit breakers and motors. Design and instrumentation for drilling machinery (Mud Pumps, Drawworks, Top Drive and Rotary Table). Engines Control System / Woodward governors ECS1200 / ECS1100 Developing of Human Machine Interface (HMI) Application using Industrial Software: WonderWare/InTouch. Developing of Process Control Systems using OMRON PLC / Programming. Developing and Design of HMI Application for Omron NT31/31C/631/631C Programmable Terminals using Software NT-Series Support Tool. Design of Networking Communications between HMI Application and OMRON’s PLC using Industrial Software: Omron FinsGateway, SMC (Archestra System Management Console) and IndustrialSQL Server Historian. Ethernet and Controller Link Network Communications. Communication Protocol: Suite Link (Ethernet-TCP/IP) Network Hardware: Routers, Ethernet Switches, Copper and Fiber Ethernet Cable, Copper and Fiber Controller Link Cable, Controller Link PCI Cards Omron’s PLC Software: CX-Programmer, CX-Configurator, CX-Simulator. Projects: Atwood-Aurora Off-Shore Drilling Rig. Brownsville, TX. USA Atwood-Aurora Off-Shore Drilling Rig. Corpus Christi, TX. USA Goober-Land Drilling Rigs 32, 33, 34, 35 & 36. Stillwater, OK. USA Goober-Land Drilling Rig 40. Mansfield, LA. USA H&P- Land Drilling Rig, Type Flex4S++. Greens Port Industrial Park. Houston, TX.
-
-
-
Gables Engineering
-
United States
-
Aviation and Aerospace Component Manufacturing
-
100 - 200 Employee
-
Automation Engineer
-
Nov 2005 - Sep 2008
Assembled electrical and electronic Board applied to Avionic Control Panels and prototypes according to engineering data and knowledge of electrical principles, using hand tools and measuring instruments. Experienced working with engineers on component-level testing, troubleshooting and production of microcircuits. Technical skills include analog and digital electronics, schematics (reading and drawing ) , oscilloscopes, function generators ,rectifiers, network analyzers, transistors , local oscillators, JFET, capacitors , microscope-level testing , MOSFETS, diodes, prototyping and hardware configuration. Software: OCDemon flash programmer, Altera, HyperTerminal, Bus tools - ARINC 429, Quartus II Programmer. Performed acceptance testing and measurements on electronic components and assemblies to verify system compliance.
-
-
-
-
Electronic Engineer
-
Nov 2003 - Oct 2005
Circuit-board test and inspection systems and military/aerospace test instrumentation. System of production electronic assemblies (Electronic Boards) Handled testing/troubleshooting of microcircuits to component level. Analog electronics, digital electronics, schematics, oscilloscopes, function generators, rectifiers, network analyzers, AC/DC power supply and meters. - Electrical Industrial (ELINSA) Maracaibo, Venezuela Circuit-board test and inspection systems and military/aerospace test instrumentation. System of production electronic assemblies (Electronic Boards) Handled testing/troubleshooting of microcircuits to component level. Analog electronics, digital electronics, schematics, oscilloscopes, function generators, rectifiers, network analyzers, AC/DC power supply and meters. - Electrical Industrial (ELINSA) Maracaibo, Venezuela
-
-
-
ELINSA Industrial Electrical
-
Maracaibo, Zulia, Venezuela
-
Project Control Engineer
-
Jan 1997 - Sep 2003
Production of electric control panels for Industrial control Designing, engineering & development services Allen Bradley PLC programming custom control panels and automation control panels, Mechanical & electrical panels for process systems & electronics. PLC & motor control systems, remote PLC I/O systems, system programming & pneumatic systems Capabilities include system integration according layout & schematics, total system checkout, installation, calibration, documentation & startup Scheduled Projects working with a staff of more than 15 workers
-
-
Education
-
Yacambu University. Engineering School
BS, Electronic Engineering