Ilya M.
Senior Data Architect at amal.com- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
-
English Full professional proficiency
-
Russian Native or bilingual proficiency
Topline Score
Bio
Ahmed Al-Ghamdi
I had the pleasure to work with Ilya on a meridium upgrade project, it was a critical project at that time since we haven't kept the upgrade tracking on time. Ilya came to this project and did a great and smooth job. He was confident and do the job in a professional manner. He managed our team and his team remotely with ease. He is a great asset and committed to his customers and clients and I wish him all the best.
Dario Caccamo, CFA
I have been working with Ilya for 2 years and I have witnessed his thorough analytical mindset, he was an absolute reference in our group for relational databases technicalities and SQL querying solutions. Techincal skills a side, Ilya has great team working skills, amazing adaptability and capability of improving the working environment around himself. I would recommend him for any company.
Ahmed Al-Ghamdi
I had the pleasure to work with Ilya on a meridium upgrade project, it was a critical project at that time since we haven't kept the upgrade tracking on time. Ilya came to this project and did a great and smooth job. He was confident and do the job in a professional manner. He managed our team and his team remotely with ease. He is a great asset and committed to his customers and clients and I wish him all the best.
Dario Caccamo, CFA
I have been working with Ilya for 2 years and I have witnessed his thorough analytical mindset, he was an absolute reference in our group for relational databases technicalities and SQL querying solutions. Techincal skills a side, Ilya has great team working skills, amazing adaptability and capability of improving the working environment around himself. I would recommend him for any company.
Ahmed Al-Ghamdi
I had the pleasure to work with Ilya on a meridium upgrade project, it was a critical project at that time since we haven't kept the upgrade tracking on time. Ilya came to this project and did a great and smooth job. He was confident and do the job in a professional manner. He managed our team and his team remotely with ease. He is a great asset and committed to his customers and clients and I wish him all the best.
Dario Caccamo, CFA
I have been working with Ilya for 2 years and I have witnessed his thorough analytical mindset, he was an absolute reference in our group for relational databases technicalities and SQL querying solutions. Techincal skills a side, Ilya has great team working skills, amazing adaptability and capability of improving the working environment around himself. I would recommend him for any company.
Ahmed Al-Ghamdi
I had the pleasure to work with Ilya on a meridium upgrade project, it was a critical project at that time since we haven't kept the upgrade tracking on time. Ilya came to this project and did a great and smooth job. He was confident and do the job in a professional manner. He managed our team and his team remotely with ease. He is a great asset and committed to his customers and clients and I wish him all the best.
Dario Caccamo, CFA
I have been working with Ilya for 2 years and I have witnessed his thorough analytical mindset, he was an absolute reference in our group for relational databases technicalities and SQL querying solutions. Techincal skills a side, Ilya has great team working skills, amazing adaptability and capability of improving the working environment around himself. I would recommend him for any company.
Credentials
-
10.117: Dashboards and Data Discovery
MicroStrategyNov, 2017- Sep, 2024 -
The Data Scientist’s Toolbox by Johns Hopkins University
Coursera Course CertificatesJul, 2016- Sep, 2024
Experience
-
amal.com
-
United Arab Emirates
-
Internet
-
Senior Data Architect
-
Jan 2023 - Present
Establishing data and analytics IT infrastructure from scratch as a digital transformation; Python, Airflow, Big Query, Google analytics, sql, algorithms, AWS lambda, sqs, sns, s3, json, github, Docker, Google Suite, MS stack, Power Bi; Datalake and datawarehouse architecture, ETL, ELT, Data and analytics architecture, Data Management, Data Governance , Google analytics data normalisation, Data scraping from websites, Documentation and technical writing, Communication with the stakeholders and users, Mentorship for interns from UAE schools and high schools Show less
-
-
-
Al Ghandi Auto
-
United Arab Emirates
-
Motor Vehicle Manufacturing
-
400 - 500 Employee
-
Data Architect
-
Sep 2021 - Jan 2023
Digital transformation: on premises to the cloud Azure cloud services (PostgreSql, Files storage, Key Vaults, Image Registry, Container Services) SQL, Python, Airflow - customization and deployment, Docker BI (Power BI) Data analysis, data warehousing, data modelling, data governance, unit tests Business analysis of the existing reports Communication with the stakeholders Digital transformation: on premises to the cloud Azure cloud services (PostgreSql, Files storage, Key Vaults, Image Registry, Container Services) SQL, Python, Airflow - customization and deployment, Docker BI (Power BI) Data analysis, data warehousing, data modelling, data governance, unit tests Business analysis of the existing reports Communication with the stakeholders
-
-
-
Kitopi
-
United Arab Emirates
-
Food & Beverages
-
700 & Above Employee
-
Senior Data Engineer
-
Oct 2020 - Sep 2021
Supporting, refactoring, developing as well as managing Data pipelines: python, sql, dbt, airflow, docker, kubernetes, gcp, aws, kafka, snowflake, ms azure CI/CD Data warehousing, data analysis, data modelling: snowflake (rdl (data lake), odl, adl (data mart)) - fact, dimension, map; sql, looker Code optimization: sql, python Mentorship for interns from UAE schools and universities Supporting, refactoring, developing as well as managing Data pipelines: python, sql, dbt, airflow, docker, kubernetes, gcp, aws, kafka, snowflake, ms azure CI/CD Data warehousing, data analysis, data modelling: snowflake (rdl (data lake), odl, adl (data mart)) - fact, dimension, map; sql, looker Code optimization: sql, python Mentorship for interns from UAE schools and universities
-
-
-
dubizzle
-
United Arab Emirates
-
Online Audio and Video Media
-
200 - 300 Employee
-
Senior Data Engineer
-
Nov 2019 - Oct 2020
Data lineage, data governance, change data capture, data quality check automation (AWS Cloudwatch), CI/CD ETL (apache airflow, matillion, AWS Glue, jenkins), data warehousing / data lake (Redshift, Athena, SQL, python, snowflake), analytics (data modelling), visualisation (Sisense Periscope), data storage(AWS, S3, json), Gitlab, unit testing, reports design Communication with the stakeholders: interpreting tasks into technical descriptions Data lineage, data governance, change data capture, data quality check automation (AWS Cloudwatch), CI/CD ETL (apache airflow, matillion, AWS Glue, jenkins), data warehousing / data lake (Redshift, Athena, SQL, python, snowflake), analytics (data modelling), visualisation (Sisense Periscope), data storage(AWS, S3, json), Gitlab, unit testing, reports design Communication with the stakeholders: interpreting tasks into technical descriptions
-
-
-
Namshi.com
-
United Arab Emirates
-
Retail
-
700 & Above Employee
-
Senior Business Intelligence Engineer
-
Sep 2016 - Sep 2019
Digital transformation (from "on premises" to GCP), Data Engineering, Data warehousing, ETL, Data modelling (data marts), Data analysis, CI/CD; BI infrastructure design and development (system thinking); Data architecture (ddl, dml, sql, tsql, plsql; mysql, mssql, gcp big query, google sheets); Metadata design and development (facts, attributes, measures); ETL(SSIS, c#, python, jenkins, airflow, json, google cloud functions), troubleshooting; Data visualization - reports development (pivot tables, dashboards, bi tools graphics: tableau, power bi, microstrategy, google data studio, other bi tools); Data validation concept elaboration and tool development: google sheets, apache airflow, python operators, slack notification on a result; Prototyping, testing, uat, sql query optimization; Leadership, team management, principal point of contact for the Company data, analysis and business process related questions; Analytical data models - data marts design, development and optimization (tabular olap - ssas, sql, dax, mdx, google cloud platform bigquery): Marketing costs data model design and development, customer experience, acquisition, attribution, classification analysis for marketing, merchandising, warehouse, etc. Finance data modelling and reporting (vat, receivables, other erp data analysis) Show less
-
-
-
Meridium, from GE Digital
-
United States
-
Software Development
-
1 - 100 Employee
-
Technical consultant
-
Mar 2014 - Jul 2016
Technical support for the asset performance management (APM) software (sw) deployment, customization and version upgrade on- and off a customer site (EMEA region) Requirements, sw documentation and client's IT environment analysis; Direct communication with the stakeholders; Setting up sw IT environment and third-party components (network, security, applications, services, etc.); Setting up ETL (datastage, sap to mssql, talend); Sw business logic customization (SSAS, SSRS,vb.net, sql, t-sql, pl-sql, html); Analytics metadata deployment and customization: olap multidimensional cubes: hierarchies, measures, dimensions, kpi etc. Dashboard and graph data visualization development; Test plans design; User technical training and uat sessions delivery; SW client operational support; Testing the sw after a fix/script application. Technical software engineer consultant for Qatargas (Qatar), Sahara Petrochemicals (KSA) sw versions upgrades projects and SIBUR (Russian Federation) initiation of the APM sw deployment project. Show less
-
-
-
Nissan Motor Corporation
-
Japan
-
Motor Vehicle Manufacturing
-
1 - 100 Employee
-
Industrial Engineer and CAPEX Controller
-
Sep 2011 - Feb 2014
Departments' requirements and business process analysis; Plant shops headcount optimization application design and development (vb.net, asp.net); Data architecture design: ddl, dml, sql, tsql etc.; Design and development of a tree-view (drag and drop) visualization of production lines (conveyor) data; Prototyping, testing, uat; ETL tool design and development for data collection and procession; Data reporting/visualization tool design and development (ms sql, excel, vba, vb.net, open office): Design and development of analytics metadata: measures, dimensions, kpi; Financial control reporting and visualization (capex, actuals, purchasing (po, pr), etc.); Being central point contact for budget control and industrial engineering information systems; Creating user and training documentation, conducting formal user training; SAP (Budgeting (capex) and Purchasing) administration and user technical support; Software design documentation writing; Leading the projects for the department additional third-party software implementation. Show less
-
-
-
Avianova
-
Airlines and Aviation
-
1 - 100 Employee
-
CRM Project Manager
-
Mar 2010 - Oct 2011
Remote opportunity Development of the first on market integrated marketing communication with the current and perspective clients for the low-cost airline through social network: Requirements and business process analysis; Organizing teamwork to formulate and document the rules of the client communication; Collaboration with the airline PR & Marketing department and other stakeholders; Creating client FAQ list; Client first line support; Design and development of BI indicators to measure customers' behavior. Show less
-
-
-
Creat Studios
-
United States
-
Computer Games
-
1 - 100 Employee
-
Bi Developer
-
Mar 2011 - Sep 2011
Design and development of BI information system for collecting, processing, storage and visualization of an on-line social network games data. Stakeholder (of different levels) requirements analysis; Software documentation reading; Identifying and analyzing technology limitations and gaps in existing business processes (mysql, sql, tsql, python, postgresql, etc.); Data mining, cleaning and analysis (blanks, consistency, relevancy, etc.); Design and development of data architecture (ddl, dml, etc.); Data procession algorithms design, development and analysis (stored procedures. etc.); Design, development and customization of data structures for the bi tools (tableau) latency optimization (data-warehousing); Automation of the data procession (mysql events); Testing, debugging, analyzing and fixing errors; Data visualization for different management levels (Tableau): dashboards design, graph design; Writing and updating system documentation. Show less
-
-
-
JSC CONCERN TITAN-2 branch in Finland
-
Finland
-
Construction
-
1 - 100 Employee
-
Analyst Programmer
-
Feb 2010 - Mar 2011
Construction holding erp information system (budget, engineering documentation, purchasing, etc.) design, development and user support. Requirements and departments business processes analysis; Software and best practices documentation reading; Direct communication with the stakeholders (all levels); Alien code reading (vb.net, c#, vba, sql, tsql, etc.); Algorithms analysis and design (database, application); Business logic customization (tsql, vb.net, c#); Testing, debugging, analyzing and fixing errors; Test plans design; User technical training and uat sessions delivery. Show less
-
-
Education
-
2004 - 2009
Saint Petersburg State University
Master’s Degree, Computer and Information Sciences and Support Services -
2018 - 2022
Kutafin Moscow State Law University
Master of Laws - LLM, Continental law
Community
