Aleksei Marchenko

Experience

• 

  Magenta Technology

  Mar 2016 - Aug 2019

  Chief Data Officer

  - Designed and implemented BI in the business with legal entities both in Russia and England.- Became a member of the Maxoptra Product board.- Implemented CRM that helped to cope with the 9x increase in the number of customers- Made the billing process scalable. The number of invoices has increased by 9 times, while the costs of serving the billing process have decreased due to optimization and automation of internal processes, customer payment terms changes, electronic document management implementation Show less

• 

  Haulmont Russia

  Aug 2019 - Aug 2021

  Project Manager

  Successfully managed the software development projects:- Loans and deposits back office software- ERP for non-commercial entities- Automation of replenishment of retail warehousesDeveloped ETL pipeline to integrate data from various cloud sources and built Power BI reports for:- Projects performance- Developer's KPI- Finance results

• 

  EPAM Systems

  Aug 2021 - Dec 2024

  Client: Worldwide Auto ManufacturingProject: Provide assistance with establishing Data Governance using CollibraDeliverables:- Developed the Data governance strategy (goals, user stories, guidelines for implementing the Data Governance with Collibra)- Designed Collibra operating model (asset types, attributes, relations, communities and domains, responsibilities, workflows) = Collibra solution architecture- Discovered the existing metadata sources and designed metadata enrichment in Databricks - Designed Collibra integration with the metadata in Databricks, ADLS, Lean IX, and Vehicle data ordering systems.Tools and Technologies:Collibra, Lean IX, Azure Databricks, ADLS, API Show less Client: Hospitality networkStarted a project to implement a Data Warehouse to centralize enterprise data paving the way to streamline data management and enable informed decision-making, advanced analytics, business intelligence capabilities and foremost data-driven, efficient and effective business operations that are client-centric and aimed at maximizing revenue and minimizing costs.Deliverables:In Business Analysis:- Business Glossary- Requirements elicitation and documentation (including Use cases, Prototypes, Presentations)- KPI\Dimension matrixIn Data Analysis: - Source data profiling- Data Catalog and Data dictionary- Conceptual and Logical data models- Technical solution definition for the semantic model and Power BI reports- Synthetic data generation with referential integrity- Data quality assuranceIn Power BI report development: - Customer behavior and Revenue centric reports- Visuals with dynamic measures and dimensions per user selection- Role level securityIn Quality Assurance: - Developed the QA strategy. - In charge of the code, data and BI reports QATools and Technologies:SQL, Python, Microsoft Power BI, Azure Databricks, Microsoft Azure Show less Client: Worldwide Retail & DistributionStarted the data product that enables foreseeing and anticipating potential Store Capacity Constraints (physical receiving space and processing labor hours) before planning orders and providing recommendations to tweak Store Constraints.In the scope of work:- Project and Data discovery- KPI calculations design- Data flow design- Source to target mappings- Data governance- Product roadmap- Requirements managementTools and Technologies:SQL, PySpark, Python, Tableau, Power BI, Great Expectations, Databricks Unity Catalog, Databricks, Collibra, Snowflake, Amazon Web Services Show less Client: Worldwide Retail & DistributionTook product ownership for a data product that provides visibility on: - How well the goods are delivered against the expectations (Store's Expected Delivery Date).- The level one route causes for not meeting the expectations: What was Planned \ Shipped \ Delivered not on time (late or early). - The deep dive into root causes for planning not on time (planning has the greatest impact on meeting the Expected Delivery Date). The provided reporting allows accountability and empowers actions to ensure stock availability at the right time.Estimated impact: if the number of units delivered on time increases by 10% - that will generate a revenue of 15M per month.In the scope of work:- Data discovery- KPI calculations design- Data flow design- Source to target mapping- Data governance. Played the role of the certified Collibra Data Steward: Was a part of the Data Governance office, implementing Collibra & Was in charge of the two Data products, the physical, logical, and business layers assets for them- Requirements management- User Acceptance Testing- Product supportTools and Technologies:SQL, Python, PySpark, Tableau, Microsoft Power BI, Great Expectations, Databricks Unity Catalog, Databricks, Collibra Platform, Snowflake, Amazon Web Services Show less Took full ownership over the data product "Company Product Discount" where the data on the employee purchases in digital and brick-and-mortar stores are processed to perform the proper taxation and prevent fraud. Made several data source migrations. Refactored the code to get better performance and maintainability.The following reports and functionality are provided:- Monthly emails sent to each employee with the year-to-date spending attached. Emails sent statistics are shown in the Tableau report.- Monthly emails with the individual promo code sent to each eligible employee. Emails sent statistics are shown in the Tableau report.- Transactions by employee, with the data for taxation (monthly and year-to-date aggregations) - consumed by the Payroll team.- Transactions by employee, with the details for the Tier 1 support.- Report to identify the subnormal employee transactions, get orders, payments, and billing details - consumed by the Loss prevention team.- Total sales converted to EUR, aggregated by Channel and Payroll country, drilled down to the Employee list - consumed by the HR team.In the scope of work:- Project discovery- Data profiling- Source to target mappings- Data dictionary- Tableau reports development- User Acceptance Testing- Product roadmap and backlog management- Support report usersTools and Technologies:Snowflake, Airflow, Amazon S3, Zeppelin, Amazon Athena, Oracle Database Platform, AWS.Database, Tableau Show less

  • Data Governance Architect

    Aug 2024 - Dec 2024

  • Lead Business Intelligence Analyst

    Jan 2024 - Dec 2024

  • Business Intelligence Architect

    Jun 2024 - Aug 2024

  • Business Intelligence Lead

    Apr 2024 - May 2024

  • Business Intelligence Lead

    Oct 2022 - May 2024

  • Business Intelligence Analyst

    Aug 2021 - Oct 2022