Svitlana Lukhanina

Core Responsibilities:

• Company Overview: Integrate data across platforms such as SharePoint, Snowflake, Salesforce, resolving complex challenges related to data quality and consistency, and ensuring uninterrupted data flow;
• Build and maintain pipelines for data transformation in MS Azure Data Factory, ensuring efficient workflows;
• Developed scalable and optimized SQL code for automated customer data processing, ensuring real-time availability and accuracy;
• Design, develop, and debug Python ML scripts for integration with SharePoint, enhancing automation and optimizing data integration processes;
• Propose and implement automation solutions for business processes using automation tools to increase business value on Celonis (Bl tool) and Power Automate platform;
• Specialize in developing and implementing complex data models (P2P, AR, O2C) using data from SAP and other operational systems;
• Create and analyze complex KPIs and reports, providing clients with detailed insights to support informed decision-making;
• Collaborated as a key member of an Agile team, working closely with clients to design, negotiate, and implement tailored solutions.

Achievements:

• Created an automated system for monitoring and resolving errors during data extraction, ensuring the continuous operation of critical business processes without interruptions;
• Developed an automated reporting system that significantly reduces the time required for data search and analysis, streamlining the reporting process and improving efficiency
• Integrate data across platforms such as SharePoint, Snowflake, Salesforce, resolving complex challenges related to data quality and consistency, and ensuring uninterrupted data flow.

Core Responsibilities:

• Process Mining for several customers from different industries: distribution, manufacturing;
• Transformation of data from SAP and other business operations management systems;
• Creating SQL scripts for data transformation, finding ways for the most efficient use of space and time for data transformation;
• Building business process models i.e
• Purchase to Pay, Accounts Payable, Order to Cash - using knowledge of SAP tables, Basware, VIM and other data;
• Setting up integration with Sharepoint, Snowflake, Google Sheets;
• Creation of P2P, AR and O2C data models by connecting transformed tables into a single model;
• Creating reports for customers using transformed data, creating complex KPIs.

Achievements:

• Improved metrics such as late deliveries, late payments, duplicate documents, and rework activities by conducting end-to-end process analysis

Core Responsibilities:

• Communication with suppliers and representatives of retail chains by IP-telephony and e-mail
• Linking to clients' computers via remote access
• Setting up workflow software on the client side
• Analysis of documents sent by suppliers and retail chains (ORDER, DESADV, INVOICE, ORDRSP, UTD) for compliance with specifications
• Determination of the reasons for non-receipt of documents by end users
• Monitoring of the workflow process, server status
• Administration of servers that provide document exchange
• SQL-query execution via SSMS and elimination of document exchange failures
• Troubleshooting FTP connection, AS2 connector
• Working with the JIRA system.

Achievements:

• Improved customer satisfaction by quickly resolving document issues, both internal, related to servers and workflow, and customer-side document errors
• Reducing the company's expenses on fines due to late receipt of electronic documents from retail chains by stores

Core Responsibilities:

• Prepared detailed reports, ensuring accuracy and relevance to support decision-making processes;
• Development and maintenance of statistics;
• Communication with administrators;
• Creation of a new system of statistics and analysis of the company's activities using Google Sheet.

Achievements:

• Reducing the costs associated with errors in databases;
• Improved reporting accuracy and efficiency with a new analysis system.

Core Responsibilities:

• Working with databases, loading data, troubleshooting;
• Software installation;
• Office equipment repair