Marsel Amirov

2019 - 2024 Data Engineer

• Data migration. Building a pipelines to ingest data from on-primes using SHIR (ELT) and Google Drive using HTTP (ETL) linked services to Azure environment. Storing the raw data in ADLS gen 2. Maintained pipelines
• Data Cleaning. Using Databricks transforming raw data. Removing duplicates, Standardizing Data and Validating Data.
• Incremental Data Load. Weekly based using watermark.
• Optimized SQL queries to improve retrieve speed.
• Using API helped to build Sever Weather alert for assets based on the the route using data from TMS DB

2017 - 2019 Windows Server 2012 System Administrator & On Premise TMS Administrator

Windows Server 2012

• User Account and Permissions Management: Creating, managing, controlling user access to systems and resources.
• Security: Implementing and maintaining security measures, including firewalls, intrusion detection systems, and access controls.
• Backups and Recovery: Implementing and maintaining backup and recovery procedures to ensure data protection and business continuity.
• Troubleshooting: Identifying and resolving hardware and software issues, including system crashes and network problems.

TMS (Transportation Management System)

• Administration: Managing the TMS software, including user accounts, permissions, and security settings.
• Troubleshooting and Support: Resolving technical issues and providing support to users who are experiencing problems with the TMS.
• System Updates and Maintenance: Applying software updates, patches, and maintenance procedures to ensure the system remains stable and secure.
• Data Management: Ensuring data integrity, accuracy, and security within the TMS.
• Integration Management: Managing integrations between the TMS and other systems, such Drive Axle, Samsara.

• Coordinating Transportation
• Inventory Management
• Supply Chain Management
• Customer Service
• Process Improvement
• Budget Management
• Problem Solving
• Safety

• CNC Programming: the process of creating instructions and code that is used to control computer numerical control (CNC) machines. G-code and M-code
• Numerical Control (NC):
• Blueprint Reading:
• Milling:
• Caliper and Micrometer:
• Detail Oriented:

• Operating and Maintaining Extrusion Equipment
• Troubleshooting and Problem Solving
• Quality Control
• Production Records
• Blueprint reading