Data Analyst | Remote | SQL or Python

Описание

Aidos Aitmaganbet Data Engineer CONTACTS : 8 (702) 137 -90 -90 Kultegin 5, Astana, Kazakhstan aidos.aitmaganbet@alumni.nu.edu.kz O BJECTIVE : Driven and hardworking person with a strong logical mindset and a solid mathematical background, having achieved a good level of technical skills in a short time, with a need for constant learning and a passion for problem solving, currently looking for an interesting position in data engineering or data science that would allow me to use my full potential. EDUCATION : Nazarbayev University (2013 -2018) Bachelor degree in Mechanical Engineering In my student years, I was involved in many projects related to the programming of control systems, the development of various autonomous robots (like firefighting robots or obstacle avoidance robots), fire propagation, ventilation s ystems, earthquake -resistant structures, aerodynamics, etc. Kazakh -Turkish High School (2008 -2013) In my school years, I was the winner of the Regional Mathematics Olympiads for four years (2010 -2013). Twice I was the bronze medalist of the Republican Mathematics Olympiads (2012, 2013) and twice I was silver medalist of International Mathematics Olympiad (“Kolmogorov” 2011, “Tuymaada” 2012) . I was also finalist of several International Mathematics Olympiad such as “Silk Road”, “Asian Pacific ”, “Zhautykov”. EXPERIENCE: RYTE AI (December 2022 – June 2023) Data Engineer • Developed and optimized complex SQL queries, DataFrame API scripts and different kind of complex functions in order to ingest, extract, transform and load structured and unstructured data in different formats from diverse sources, ensuring high performance and efficient data retrieval. • Designed and implemented data pipelines using Azure services, including Azure Databricks, Azure Data Factory, Azure Synapse Analytics, Azu re SQL Database, Azure Blob Storage, Azure Data Lake Storage and Azure Log Analytics. • Developed web scraping solutions to gather data from various websites, utilizing Python libraries such as BeautifulSoup, Selenium, urllib, re, xml, json to automate the e xtraction process. • Integrated data from external APIs into the data ecosystem, leveraging Azure Logic Apps and Azure Functions to create seamless data ingestion and synchronization workflows. • Used Spark MLlib to create various models to clean, normalize, m atch, and improve data quality. • Collaborating with cross -functional teams I participated in the development of effective data models and schemas, in the creation of data dependency diagrams, in the implementation of best practices for optimizing data stora ge, retrieval and protection processes. • Studied new trends and advancements in the field of data processing, in order to find opportunities to improve existing systems. COURSES: In my free time, I try to take courses in various fields. Courses in the field of IT for the last year for which I received certificates: • Spark and Python for Big Data with PySpark • Introduction to Spark MLlib for Big Data and Machine Learning • Azure Databricks & Spark for Data Engineers • Azure Data Factory for Data Engineers • Azure Synapse Analytics for Data Engineers • The Ultimate Hands -On Hadoop • Supervised Machine Learning • Advanced Learning Algorithms • Unsupervised Learning, Recommenders, Reinforcement Learning • Web Scraping with Python • Introduction to Data Engineering • Introduction to Data Science, Data Science Tools and Data Science Methodology • Databases and SQL for Data Science with Python • Using Python to Access Web Data • Data -Driven Decisions with Power BI • Getting Started with Git and GitHub • Introduction to Containers w ith Docker, Kubernetes & OpenShift • Introduction to NoSQL Databases • Neural Networks and Deep Learning • Improving Deep Neural Networks Hyperparameter Tuning, Regularization and Optimization • etc. EXPERIENCE: Karachaganak Petroleum Operating (July 2021 – July 202 2) Rotating Equipment Mechanical Engineer Led many projects focused on IT, digitalization, and automation within the rotating equipment division such as: • Development of data visualization web system to track and analyze KPIs of equipment to enable proactive maintenance. • Creation and deployment of a mobile application for increasing operational flexibility in health and environmental safety. • Implementation of a new operating principal logic for high value equipment that resulted in reduced downtime, and improved safety. Using Python programming skills, I has been automating and developing strategies to optimize various processes such as: • Daily reporting of various employees of the company. • Gaining access to the fiel d and various hazardous areas, through verification through phones or face recognition. • Processes for determining material requirements for early ordering. I have also been involved in reporting and creating dashboards, creating strategies for equipment ma intenance, analyzing the feasibility of various projects, managing available resources (including work budget), negotiating contracts and many other things providing information and recommendations to top management of the company. Nazarbayev University (March 2021 – July 2021 ) Research Assistant • Created from scratch a unique 3D printer and programmed it in Python. • Participated in scientific projects "Designing a robotic arm" and "Creating a prosthesis". • Wrote scientific articles that were further published and was engaged in scientific experiments. AE TS (FGP Tengizchevroil) (November 2018 - December 2021 ) Manager Assistant • Assisted the manager in all tasks including allocating and scheduling resources, creating reports, creating strategies, and maintaining all types of documentation, etc. • Used Power BI and Python to create and automate visual reports and automate repetitive tasks. • Using SQL helped in the development, maintenance and retrieval of data from internal databases and di d many other tasks. KazZinc Holdings (August 2018 - November 20 18) Business Analyst • Assisted Analyzed data from digitized facilities of a large mining company, extracting insights to drive operational improvements and decision -making. • Utilized SQL to query and retrieve data from diverse data sources, including databases and data warehouses and maintained data pipelines to automate the extraction, transformation, and loading (ETL) processes, enabling efficient data processing and analysis. • Conducted in-depth data analysis, identifying trends, patterns, and anomalies in mining operations, equipment performance, and resource allocation using Power BI to create interactive and dynamic visualizations and did many other tasks. TECHNICAL SKILLS : • Microsoft Azure Cloud Platform (Databricks, Data Factory, Synapse Analytics, SQL Database, Blob Storage, Data Lake Storage and Log Analytics ) • Apache Spark (SQL, DataFrame API) • Python (P yspark , Pandas, NumPy, Selenium, Matplotlib , Seaborn , Beautiful Soup , RE , Work with APIs etc.) • Databases (MySQL, SQLServer , SQLite) • Git , PowerBI, Spotfire , Scrum framework, Planner, Jupyter, Visual Studio Code, Atom • AutoCAD, SolidWorks, Rhino, ANSYS, ProjectManage r, SAP , MS Office Tools that I got acquainted with during the course s, but for which I have no practical experience: • Apache Spark (Mllib ) • Python (S cikit -learn , TensorFlow, Scrapy, Asyncio, Pillow etc.) • Hadoop Ecosystem (HDFS , Yarn, MapReduce, Ambari, Pig, Hive, Hbase ) • Databases (MongoDB, Cassandra) • С++, MATLAB LANGUAGES : • English – fluent • Kazakh – fluent • Russian – fluent • Turkish – intermediate SOFT SKILLS : Industriousness, responsibility, attentiveness, proactiveness, fast learner, analytical mindset, time management, ability to communicate information in an accessible way, team player, empathy, leadership qualities.