Maciej D. - UiPath Development & Business Analysis for the Energy Industry | IT Service Provider & Consultant

Go to Website

Herford, Germany

Experience

Feb 2024 - Jun 2024

5 months

Germany

Business Analyst

Dekan-IT

Project: Test automation of internal processes
Industry: agriculture sector
Task: Business analysis
Tool: SAP
Tool: Camunda
Tool: OBS Studio
Tool: Microsoft SharePoint
Tool: Microsoft Teams
A leading agricultural trading company in northern Germany planned to introduce UiPath technology, mainly to digitize and test existing SAP processes.
Specifically, tests of the SAP processes were to be carried out after release changes or when integrating new companies.
In the role of Business Analyst, I acted as a link between the agricultural company's staff and the RPA developers.
The main tasks included capturing and modeling the processes and process chains using BPMN: during regular coordination meetings with the SAP-MM, SAP-SD and SAP-FICO departments, information on existing processes was recorded via video recordings.
This capture specifically covered the individual steps when executing the transactions as well as any associated reversal processes.
This allowed analysis of objectives, stakeholders, steps, resources, and potential issues or bottlenecks.
The collected information was then documented to provide a clear understanding of process development.

Jan 2024 - Feb 2024

2 months

Project Manager

Dekan-IT

Project: annual consumption billing
Industry: energy sector
Task: project management and coordination
Task: project analysis
Tool: SAP
Tool: Excel
Management and control of the process chain for the annual consumption billing in SAP for about 23 utilities (team of up to 30 people).
The annual consumption billing is the final invoice to the end customer, e.g. in electricity, gas, water, wastewater, and heat.
The actual amount of energy/services consumed is determined based on meter readings or a flat rate, and reconciled with the previously paid monthly advance payments in the final invoice.
The project implementation starts with creating conceptual documents for each municipal utility and customizing based on change requests, such as scheduling control in SAP IS-U.
The next step is capturing consumption so that the actual billing and invoicing for all municipal end customers can take place.
Finally, the invoice is printed and sent to the municipal end customers either on paper or by email.
At the end of the project, an optimization list is evaluated, documenting improvement suggestions and errors from the completed annual consumption billing, to initiate improvements for future billings.

Jan 2024 - Jan 2024

1 month

Digital Twin Development with 360° Camera - Car Dealership

Dekan-IT

Project: development of a digital twin using a 360° camera – car dealership
Industry: automotive sector
Task: capturing 360-degree images
Task: editing and optimizing the captured images
Task: integrating the captured data into the Matterport platform
Task: defining navigation paths and hotspots
Task: integrating virtual reality elements
Task: publishing and sharing
Tool: Matterport
Tool: Ricoh Z1
First, the space was precisely captured using a 360-degree camera.
The recorded images and data were processed and prepared for spatial calibration.
After that, final work followed, such as defining navigation paths, setting up hotspots, and publishing the project.

Dec 2023 - Dec 2023

1 month

Digital Twin Development with 360° Camera - Pharmacy

Dekan-IT

Project: development of a digital twin using a 360° camera – pharmacy
Industry: healthcare sector
Task: capturing 360-degree images
Task: editing and optimizing the captured images
Task: integrating the captured data into the Matterport platform
Task: defining navigation paths and hotspots
Task: integrating virtual reality elements
Task: publishing and sharing
Tool: Matterport
Tool: Ricoh Z1
First, the space was precisely captured using a 360-degree camera.
The recorded images and data were processed and prepared for spatial calibration.
After that, final work followed, such as defining navigation paths, setting up hotspots, and publishing the project.

Sep 2023 - Feb 2024

6 months

RPA Developer

Dekan-IT

Project: setup of EEG installations for EEG billing
Industry: energy sector
Task: implementation of a robot with UiPath
Tool: SAP
Tool: Excel
Tool: UiPath
Conversion to the specific data and settings for EEG billing while retaining the 'old' data.
Involved transactions:
ES31 – change installation
EG70 – maintain tariff data
The project starts with redesigning the feed-in installation.
From January 1, 2024, a new tariff type is planned to be stored in transaction ES31.
Then the tariff data is also updated on the meter to the new tariff type.
The next step is to create a generation unit with the corresponding data and assign it to January 1, 2024.

May 2023 - Jun 2023

2 months

RPA Developer

Dekan-IT

Project: Anonymization of business partner master data for S4HANA
Industry: Energy sector
Task: Implementation of a robot with UiPath
Tool: SAP
Tool: Excel
Tool: UiPath
An energy sector IT service provider planned to introduce the new system to its customers as part of the migration to S4HANA.
To avoid data privacy issues and present anonymized data to customers, personal information like last names, first names, and addresses had to be anonymized.
All types of business partners were to be considered, including companies and married couples.

Apr 2023 - Apr 2023

1 month

RPA Developer

Dekan-IT

Project: Update budget lists, extract evaluations from SAP
Industry: Energy sector
Task: Implementation of a robot with UiPath
Tool: SAP
Tool: Excel
Tool: UiPath
Every day, it was necessary to create lists to use later for comprehensive evaluations.
Involved transactions:
IW73 – Order list processing
KOB2 – Line items -> Order line-item commitments
Y_D00_24000066 – Program budget / order budget / commitment / actual
Update Excel files
In transaction IW73, a variant was selected, followed by creating two lists in Excel format.
File names and the path were predefined, and specifying the correct file extension was required.
Similarly, in transaction KOB2 a variant was chosen and then two lists in Excel format were created.
Here, the file names and path were already set.
However, it was essential to consider the company code.
In transaction Y_D00_24000066, various budget lists were retrieved for the respective year and saved with file names and path specified.
It was required to transfer all created files to the client's server.

Nov 2022 - Nov 2022

1 month

RPA Developer

Dekan-IT

Project: Migration of customer data
Industry: Energy sector
Task: Implementation of a robot with UiPath
Tool: SAP
Tool: Excel
Tool: UiPath
On January 1, 2023, four municipalities from a neighboring district were added to the client's district.
From that date, the client was responsible for waste disposal there.
For this, about 1,500 customers had to be created in the client system by the end of November at the latest.
Involved transactions:
FPP1 – Create business partner
ES55 – Create connection object
ES60 – Create consumption point
ES30 – Create installation
The robot had to create the business partner data using transaction FPP1.
In the following steps, the connection object (ES55) and a consumption point (ES60) were created and extended using previously created templates.
Through transaction ES30, the installation was created, taking into account a reference date, the previously created consumption points, and the tariff types chosen by the customers.
Based on the previously created connection object and the consumption point, the device location was created.
Afterwards, a collection was scheduled and one or more containers were installed.

Aug 2022 - Aug 2022

1 month

RPA Developer

Dekan-IT

Project: Robot for maintaining heat prices
Industry: Energy sector
Task: Implementation of a robot with UiPath
Tool: SAP
Tool: Excel
Tool: UiPath
Once per quarter, the new heat prices must be entered into SAP.
The robot had to use transaction EA90 to bring in the price and price type from Excel, the validity period (from - to), maintain the quantity basis and price amount, and then save.

Jul 2022 - Jan 2024

1 year 7 months

Trainer

Dekan-IT

Project: Training new employees in UiPath
Industry: Energy sector
Task: Onboarding a new employee
Tool: SAP
Tool: Excel
Tool: UiPath
A new employee was to be trained in UiPath.
The onboarding included conceptual thinking and gathering as well as capturing customer requirements.
Configuring the UiPath Orchestrator according to requirements/needs.
Robot implementation and subsequent testing.

Jul 2022 - Feb 2023

8 months

Project Manager

Dekan-IT

Project: Annual consumption billing
Industry: Energy sector
Task: Project management and coordination
Task: Concept design
Task: Conducting workshops
Task: Administration and management
Task: Project analysis
Tool: SAP
Tool: Excel
Management and control of the process chain for the annual consumption billing in SAP for about 23 utility companies (team of up to 30 people).
The annual consumption billing is the final billing to the end customer, for electricity, gas, water, sewage, and heat.
The actual consumed energy/service quantity is determined based on meter readings or a flat rate and reconciled with the previously paid monthly installments in a final invoice.
The project implementation starts with creating conceptual documents for each municipal utility and subsequent customizing for change requests such as scheduling control in SAP IS-U.
The next step is recording consumption so that the actual billing and invoicing for all municipal end customers can take place.
Finally, the invoice is printed and sent to the municipal end customers either in paper form or by e-mail.
At the end of the project, an optimization list is evaluated, documenting improvement suggestions and errors from the completed annual consumption billing to initiate improvement measures for future billing runs.

Jun 2022 - Jun 2022

1 month

RPA Developer

Dekan-IT

Project: Robot for assigning profiles to installations
Industry: Energy sector
Task: Implementation of a robot with UiPath
Tool: SAP
Tool: Excel
Tool: UiPath
At a client of the vendor, profiles were missing on the installations in the sales client.
The profiles needed to be assigned in bulk.

May 2022 - May 2022

1 month

RPA Developer

Dekan-IT

Project: Adjustment of reading unit labels
Industry: Energy sector
Task: Implementation of a robot with UiPath
Tool: SAP
Tool: Excel
Tool: UiPath
At a client of the vendor, the reading unit labels in the sales client only had a number; the street names were missing.
The labels needed to be extended with street names.

Apr 2022 - Oct 2022

7 months

RPA Developer

Dekan-IT

Project: Entering meter readings into customer portals
Industry: Energy sector
Task: Implementation of a robot with UiPath
Tool: SAP
Tool: Excel
Tool: UiPath
Tool: Web input
A client of the vendor wanted to automate entering meter readings into customer portals.
Starting situation: Meter readings from municipal customers were sent by e-mail to the customer center and manually entered into the customer portal.
Goal: Process automation.
The project scope included requirements gathering, feasibility study, and implementation.
The requirement was later extended to include archiving e-mails in the archive system.
Process: The data in customer e-mails was retrieved by the robot from the inbox via a secure connection and matched with master data in SAP.
If the data matched, the robot logged into the customer portal and entered the determined meter readings.
Afterwards, the retrieved e-mail was stored in an archiving system.
The project was fully implemented but had to be stopped due to too many input discrepancies from end customers.
Often the SAP master data did not match the end customer inputs, which led to frequent errors.

Apr 2022 - Apr 2022

1 month

RPA Developer

Dekan-IT

Project: Adjustment of the REF Framework
Industry: Energy sector
Task: Implementation of a robot with UiPath
Tool: SAP
Tool: UiPath
At the client, the REF Framework had to be adapted to the latest SAP standards and new requirements.

Mar 2022 - Jun 2023

1 year 4 months

Trainer

Dekan-IT

Project: Onboarding new employees into UiPath
Industry: Energy sector
Task: Training a new employee
Tool: SAP
Tool: Excel
Tool: UiPath
A new employee was to be trained in UiPath.
The onboarding included conceptual thinking as well as capturing and gathering customer requirements.
Configuration of the UiPath Orchestrator according to requirements/needs.
Robot implementation and subsequent testing.

Jan 2022 - Aug 2022

8 months

Project Manager

Dekan-IT

Project: EDM: Maintaining the release status
Industry: Energy sector
Task: Project management
Task: Test execution
Tool: Word
Tool: Excel
Tool: SAP
Integrated SAP-EDM is used periodically and per order at the client's site.
The expansion of the EDM functionalities on the client's template was done independently of specific orders.
For example, a client who introduced the integrated EDM in 2013 has a different EDM version than a client who introduced it in 2017.
The project's goal was to equalize the differences between individual clients, as well as to record and implement customer requests and suggestions for improvements.

Jan 2022 - Jan 2022

1 month

RPA Developer

Dekan-IT

Project: Robot for changing advance payment schedules
Industry: Energy sector
Task: Re-implementation of a robot with UiPath
Task: Bug fixes
Tool: SAP
Tool: Excel
For a client of the service provider, a robot was already implemented that, after completing billing, modified the advance payment schedules according to specifications, recorded a customer contact in CIC0, and printed the amendment letter on the customer's printer.
Due to SAP enhancements and new requirement specifications, changes were made in the implementation and adapted to the latest standards.

Dec 2021 - Dec 2021

1 month

RPA Developer

Dekan-IT

Project: Deletion of SEPA mandates
Industry: Energy sector
Task: Implementation of a robot with UiPath
Tool: SAP
Tool: Excel
Numerous SEPA mandates had to be deleted in the sales client for the service provider's customer using the robot.

Aug 2021 - Oct 2021

3 months

Tester

Dekan-IT

Project: Format change
Industry: Energy sector
Task: Test execution
Tool: SAP
Tool: Excel
The deadlines for the format change in market communication (MaKo) are April 1st and October 1st – all market participants are required to make the necessary changes to their IT systems and processes by these dates.
On the occasion of the MaKo deadlines, energy suppliers or their service providers work twice a year to implement the requirements in a market-compliant way.
Market communication contents include, among others, 'Business processes for supplying customers with electricity' (GPKE), 'Market processes for generating market locations for electricity' (MPES), 'Switching processes in electricity metering' (WiM Electricity), and 'Market rules for carrying out electricity balancing group accounting' (MaBiS).
In addition, EDIFACT specifications (Electronic Data Interchange for Administration, Commerce and Transport) and data exchange guidelines for writing and signing data formats must be followed.
The activities in the recurring projects mainly involved test execution of the EDM department.
The affected segments electricity and gas are usually tested.
Test execution is done for the network and the sales client.
The activity included, among others, performing balancing, creating and modifying various types of profiles (SLP, formula profiles), as well as assigning new values to existing profiles.
Monitoring weather data import.
Assigning load curves to a meter.
Creating and modifying balancing units.
Defining template profiles for balancing parameters.
Creating and modifying selection variants.
Creating and sending balancing documents.
Monitoring import (electricity) including ZFA.
Creating and modifying balancing areas.
Creating, activating and modifying MaBiS metering points.
Creating and activating MaBiS time series.
Sending time series versions.
Sending supplier clearing list.
Sending balancing group assignment list.
Sending standard load profiles or profile sets.
Defining and maintaining profile sets.
Sending profile definitions.
Assigning profiles to installations.
Testing interfaces to external EDM.
Creating allocations with preliminary and final calorific values.

Jul 2021 - Present

4 years 4 months

Project Manager

Dekan-IT

Project: Annual Consumption Billing
Industry: Energy sector
Task: Project management and coordination
Task: Concept design
Task: Conducting workshops
Task: Administration and management
Task: Project analysis
Tool: SAP
Tool: Excel
Led and managed the process chain of the annual consumption billing in SAP for around 23 utility companies (team of up to 30 people).
The annual consumption billing is the final invoice to the end customer, e.g. in the areas of electricity, gas, water, sewage, heat.
The actual consumed energy/service quantity is determined based on meter readings or a flat rate and settled in the final invoice against the previously paid monthly installments.
Project implementation starts with creating conceptual documents for each municipal utility, followed by customizing for change requests, e.g. appointment scheduling in SAP IS-U.
The next step is consumption recording so that the actual billing and invoicing for all municipal utility end customers can be carried out.
Finally, the invoice is printed and sent to the municipal utility end customers either in paper form or by email.
At the end of the project, an optimization list is evaluated in which suggestions for improvement and errors from the completed annual consumption billing are documented to initiate improvement measures for upcoming billings.

Jul 2021 - Sep 2021

3 months

Market Area Consolidation

Dekan-IT

Project: Market Area Consolidation
Industry: Energy sector
Task: Definition of balancing units
Tool: SAP
Tool: Excel
Tool: Word
A balance group change, including generating master data changes in the sales client, had to be performed for all relevant market locations.

Mar 2021 - Jan 2022

11 months

RPA Developer

Dekan-IT

Project: EEG billing implementation
Industry: Energy sector
Task: Processing requirements in EDM
Task: Developing a robot with UiPath to carry out device removal
Tool: SAP
Tool: Excel
Tool: Word
Tool: UiPath
Based on the SAP EEG billing solution combined with IDEX-GENF, the client developed a billing solution for feed-in installations in IS-U.
In addition to the legal requirements for billing, the requirements of the Federal Network Agency (BNetzA) for data exchange among market participants and the requirements of the Federal Environment Agency were also taken into account.
The rollout of the EEG billing solution in IS-U applies to the feed-in installations.
In addition, a rollout of the data exchange processes for feed-in installations and HKNR under IDEX-GENF must be carried out.
Configuration of the reporting system for TSO notifications based on the SAP standard.
The cut-off date migration of the currently existing feed-in installations into the new data model should be completed by 01/01/2022.
The project scope included support in SAP EDM.
All constructs had to be checked, among other things, for missing profiles as well as missing or incorrect balancing units.
The results were provided to the client's customers for correction.
After going live, old balancing units and the balancing at the old measurement points had to be delineated to avoid possible double balancing.
Finally, a robot was implemented that removed the old devices in bulk.

Jul 2020 - Feb 2021

8 months

Project Manager

Dekan-IT

Project: Annual Consumption Billing
Industry: Energy sector
Task: Project management and coordination
Task: Concept design
Task: Conducting workshops
Task: Administration and management
Task: Project analysis
Tool: SAP
Tool: Excel
Led and managed the process chain of the annual consumption billing in SAP for around 23 utility companies (team of up to 30 people).
The annual consumption billing is the final invoice to the end customer, e.g. in the areas of electricity, gas, water, sewage, heat.
The actual consumed energy/service quantity is determined based on meter readings or a flat rate and settled in the final invoice against the previously paid monthly installments.
Project implementation starts with creating conceptual documents for each municipal utility, followed by customizing for change requests, e.g. appointment scheduling in SAP IS-U.
The next step is consumption recording so that the actual billing and invoicing for all municipal utility end customers can be carried out.
Finally, the invoice is printed and sent to the municipal utility end customers either in paper form or by email.
At the end of the project, an optimization list is evaluated in which suggestions for improvement and errors from the completed annual consumption billing are documented to initiate improvement measures for upcoming billings.

Feb 2020 - Jan 2021

1 year

Project Manager

Dekan-IT

Project: EDM: Maintenance of the release version
Industry: Energy sector
Task: Project management
Task: Test execution
Tool: Word
Tool: Excel
Tool: SAP
Integrated SAP EDM is used periodically and on a project-specific basis at the client.
The extension of the EDM functionalities on the client's template was done independently of specific projects.
For example, a client who implemented the integrated EDM in 2013 has a different EDM version than a client who implemented EDM in 2017.
The project's goal included equalizing the differences between individual clients, as well as collecting and implementing clients' requests and suggestions for improvements.

Jul 2019 - Feb 2020

8 months

Project Manager

Dekan-IT

Project: Annual consumption billing
Industry: Energy sector
Task: Project management and coordination
Task: Concept design
Task: Conducting workshops
Task: Administration and management
Task: Project analysis
Tool: SAP
Tool: Excel
Leading and controlling the process chain of the annual consumption billing in SAP for about 23 utilities (team of up to 30 people).
The annual consumption billing is the final invoice sent to the end customer, for example in electricity, gas, water, wastewater and heat.
The actual amount of energy/services used is determined by meter readings or a flat rate and settled in a final invoice against the previously paid monthly advance payments.
The project starts with creating concept documents for each utility and then customizing based on change requests, such as scheduling control in SAP IS-U.
The next step is capturing consumption so that actual billing and invoicing can be done for all utility end customers.
Finally, the invoice is printed and sent to the utility end customers either on paper or by email.
At the end of the project, an optimization list is reviewed, documenting suggestions for improvements and errors from the completed annual billing to implement improvement measures for future billing cycles.

Jun 2019 - Dec 2019

7 months

Tester

Dekan-IT

Project: Format change
Industry: Energy sector
Task: Test execution
Tool: SAP
Tool: Excel
The deadlines for the format change in market communication (MaKo) are April 1 and October 1 - all market participants are required to make the necessary changes to their IT systems and processes by these dates.
On the MaKo dates, energy suppliers or their service providers work twice a year to implement the guidelines in a market-compliant way.
Market communication contents include, among others, the "Business Processes for Supplying Customers with Electricity" (GPKE), the "Market Processes for Generating Market Locations Electricity" (MPES), the "Switching Processes in Electricity Metering" (WiM Electricity) and the "Market Rules for Performing Balance Group Accounting Electricity" (MaBiS).
In addition, EDIFACT specifications (Electronic Data Interchange for Administration, Commerce and Transport) and data exchange guidelines for writing and signing data formats must be followed.
The activities in these recurring projects mainly involved test execution for the EDM department.
Usually the affected segments electricity and gas are tested.
Testing is carried out for the network and sales client.
The tasks included things like performing balancing, creating and changing various profiles (SLP, formula profiles) and updating existing profiles with new values.
Monitoring weather data import.
Assigning load profiles to a meter.
Creating and modifying balancing units.
Defining template profiles for balancing parameters.
Creating and modifying selection variants.
Creating and sending balancing documents.
Monitoring import (electricity) including ZFA.
Creating and modifying balancing areas.
Creating, activating and modifying MaBiS metering points.
Creating and activating MaBiS time series.
Sending time series versions.
Sending supplier clearing lists.
Sending balance group assignment lists.
Sending standard load profiles or profile sets.
Defining and maintaining profile sets.
Sending profile definitions.
Assigning profiles to installations.
Testing interfaces to external EDM.
Creating allocations with preliminary and final calorific values.

Mar 2019 - Aug 2019

6 months

Project Manager

Dekan-IT

Project: EDM: continuation of the release level
Industry: Energy sector
Task: Project management
Task: Test execution
Tool: Word
Tool: Excel
Tool: SAP
Integrated SAP-EDM is used periodically and on a project basis at the customer site.
The expansion of the EDM functionalities on the client's template was done independent of specific orders.
For example, a customer who introduced the integrated EDM in 2013 has a different EDM version than a customer who introduced the EDM in 2017.
The project goal was to align the differences between individual customers and to collect and implement the customer's requests and suggestions for improvements.

Feb 2019 - Jun 2020

1 year 5 months

Project Manager

Dekan-IT

Project: SAP EDM implementation at a client: electricity and gas divisions in the network and sales client
Industry: Energy sector
Task: Project management
Task: Test execution
Task: Master data setup
Tool: Word
Tool: Excel
Tool: SAP
A client of the provider aimed for fully integrated EDM mapping in SAP IS-U in the network and sales client.
Only the client-specific functions in the respective roles (network operator, supplier, etc.) were relevant.
The scope included creating new and extending existing master data like adding meter group extensions, importing and loading dynamic data like SLP profiles and load profiles, or extending the system with calculation formulas.
The setup needed to support complete balancing for each client, including synthetic TSO balancing or EEG balancing.
Additionally, the existing market communication should be expanded with new data exchange functions in MSCONS, UTILMD, or ALOCAT format.
The project also included setting up a weather data interface.

Jan 2019 - Sep 2019

9 months

Subproject Manager

Dekan-IT

Project: Migration to HANA database (DB) - identifying and developing customer benefits
Industry: Energy sector
Task: Subproject management
Task: Identifying customer benefits
Tool: Word
Tool: Excel
Tool: SAP
Due to licensing requirements, the database behind the SAP system had to be changed from Oracle to HANA.
The migration was treated as an investment subproject.
Within the subproject, significant customer benefits were to be identified and developed.

Aug 2018 - Oct 2018

3 months

Project Manager

Dekan-IT

Project: EDM: initialization of the release version
Industry: energy sector
Task: project management
Task: testing
Tool: Word
Tool: Excel
Tool: SAP
Integrated SAP EDM is used periodically and on an order basis at the customer.
The expansion of the EDM functionalities on the client’s template was carried out independently of specific orders.
For example, a customer who introduced the integrated EDM in 2013 has a different EDM version than a customer who introduced it in 2017.
The project goal was to balance the differences between individual customers, and to collect and implement the customer’s wishes and suggestions for improvements.

Jul 2018 - Feb 2019

8 months

Project Manager

Dekan-IT

Project: annual consumption billing
Industry: energy sector
Task: project management and coordination
Task: concept design
Task: conducting workshops
Task: administration and management
Task: project analysis
Tool: SAP
Tool: Excel
Management and control of the process chain for the annual consumption billing in SAP for around 23 utilities (team of up to 30 people).
The annual consumption billing is the final billing to the end customer, e.g. in electricity, gas, water, wastewater, and heat.
The actual energy/service consumption is determined based on meter readings or a flat rate and offset against the previously paid monthly installments in a final invoice.
Project implementation starts with creating conceptual documents for each municipal utility and then customizing for change requests such as scheduling control in SAP IS-U.
The next step is consumption recording so that the actual billing and invoicing for all municipal end customers can take place.
Finally, the invoice is printed and sent to the municipal end customers either on paper or by email.
At the end of the project, an optimization list is evaluated, documenting suggestions for improvements and errors from the past annual consumption billing to initiate improvement measures for upcoming billings.

Jun 2018 - Apr 2019

11 months

Project Manager

Dekan-IT

Project: SAP EDM implementation for a customer of the client: electricity and gas divisions in the network and sales tenants
Industry: energy sector
Task: project management
Task: testing
Task: master data setup
Tool: Word
Tool: Excel
Tool: SAP
A customer of the client aimed at a fully integrated mapping of EDM in SAP IS-U in the network and sales tenants.
Only tenant-specific functions in the respective roles (network operator, supplier, etc.) were relevant.
The scope of functions included creating new and extending existing master data such as expanding meter groupings, importing and entering dynamic data like SLP profiles and load curves, or extending the system with calculation formulas.
Complete balancing should be possible on the respective tenants, e.g. synthetic grid operator balancing or EEG balancing.
In addition, the existing market communication was to be extended with new functions in data exchange in the MSCONS, UTILMD, or ALOCAT formats.
The project also included setting up a weather data interface.

Mar 2018 - Apr 2018

2 months

Project Manager

Dekan-IT

Project: update of service pack 09 (SP09)
Industry: energy sector
Task: project management
Tool: Word
Tool: Excel
Tool: SAP
SAP provides service packs to implement (pro)active program improvements or changes (e.g. tax regulations).
The expansion at that time served as a basis for future projects.
The update was to be carried out on existing system landscapes (development, test environment, production environment).
Additionally, the test scripts were completed, the test execution was coordinated, and potential improvements were identified and documented.

Dec 2017 - Jun 2018

7 months

Project Manager

Dekan-IT

Project: SAP EDM implementation for a customer of the client: electricity and gas divisions in the network and sales tenants
Industry: energy sector
Task: project management
Task: testing
Task: master data setup
Tool: Word
Tool: Excel
Tool: SAP
A customer of the client aimed at a fully integrated mapping of EDM in SAP IS-U in the network and sales tenants.
Only tenant-specific functions in the respective roles (network operator, supplier, etc.) were relevant.
The scope of functions included creating new and extending existing master data such as expanding meter groupings, importing and entering dynamic data like SLP profiles and load curves, or extending the system with calculation formulas.
Complete balancing should be possible on the respective tenants, e.g. synthetic grid operator balancing or EEG balancing.
In addition, the existing market communication was to be extended with new functions in data exchange in the MSCONS, UTILMD, or ALOCAT formats.
The project also included setting up a weather data interface.

Oct 2017 - Dec 2017

3 months

Coordinator

Dekan-IT

Project: Migration of a customer to another service provider
Industry: Energy industry
Task: Internal/external coordination
Tool: Word
Tool: Excel
Tool: SAP
A client of the customer planned to switch the EDM service provider on 01.01.2018.
Therefore, the EDM-specific market communication should be switched to the new provider by 01.12.2017, but no later than 01.01.2018.
Incoming messages from the market were to be provided by the customer on an internet-accessible SFTP server with certificate-based authentication and a storage area (separate subdirectories for test and production) for temporary storage of the messages.
The new EDM provider supplied the certificate needed for access.
Only messages currently routed to the external EDM were extracted from the emails and immediately stored as text files with the original filename on the SFTP server.
The new EDM provider retrieves the files from the SFTP server and then deletes the file on the server.
The new EDM system was responsible for responding to the messages (including CONTRL and APERAK messages).
Outgoing messages to the market were to be communicated by the new EDM system and EDIFACT documents to be sent were to be emailed (encrypted) to a technical mailbox of the customer (separate for test and production).
The customer extracts the EDIFACT documents from the email and forwards them to the email address of the market partner stored in the customer's central market partner database.
Market partner identification is based solely on the ILN of the recipient in the EDIFACT document.
The dispatch is thus carried out exactly the same way as messages sent from SAP.
(In the test environment, sending is suppressed.)
For outgoing CONTRL and APERAK messages, the message is linked to the original message.
All existing interfaces were deactivated at the request of the customer's end client, no later than 31.12.2017.

Aug 2017 - Sep 2017

2 months

Tester

Dekan-IT

Project: Format change
Industry: Energy industry
Task: Test execution
Tool: SAP
Tool: Excel
Deadlines for the format change in market communication (MaKo) are April 1 and October 1 – all market participants are required to make the necessary changes to their IT systems and processes by these dates.
On the MaKo dates, energy suppliers or their service providers work twice a year to implement the requirements in a market-compliant way.
Market communication content includes, among others, the "Business Processes for Electricity Customer Supply" (GPKE), the "Market Processes for Electricity Generating Locations" (MPES), the "Switching Processes in Electricity Metering" (WiM Electricity) and the "Market Rules for Electricity Balancing Group Settlement" (MaBiS).
In addition, the EDIFACT specifications (Electronic Data Interchange for Administration, Commerce and Transport) and data exchange guidelines for writing and signing data formats must be followed.
Activities in the recurring projects mainly included test execution for the EDM specialist area.
The tested segments are usually electricity and gas.
Test execution is performed for the network and sales clients.
Activities included, among others, performing balancing, creating and changing profiles of different types (SLP, formula profiles), and updating existing profiles with new values.
Monitoring of weather data imports.
Assigning load profiles to a metering point.
Creating and changing balancing units.
Defining template profiles for balancing parameters.
Creating and changing selection variants.
Creating and sending balancing documents.
Monitoring import (electricity), including ZFA.
Creating and changing balancing areas.
Creating, activating, and changing MaBiS metering points.
Creating and activating MaBiS time series.
Sending time series versions.
Sending supplier clearing lists.
Sending balancing group assignment lists.
Sending standard load profiles or profile groups.
Defining and maintaining profile groups.
Sending profile definitions.
Assigning profiles to installations.
Testing interfaces to external EDM.
Creating allocations with provisional and final calorific values.

Jul 2017 - Feb 2018

8 months

Project Manager

Dekan-IT

Project: Annual Consumption Billing
Industry: Energy industry
Task: Project management and coordination
Task: Concept development
Task: Conducting workshops
Task: Administration and management
Task: Project analysis
Tool: SAP
Tool: Excel
Leading and controlling the process chain for the annual consumption billing in SAP for about 23 utilities (team of up to 30 people).
The annual consumption billing is the final settlement with the end customer in areas such as electricity, gas, water, wastewater, heat.
The actual consumed energy/service amount is determined based on meter readings or a flat rate and offset against the previously paid monthly installments in a final invoice.
The project implementation starts with creating conceptual documents for each utility and then customizing for change requests, such as scheduling in SAP IS-U.
The next step is consumption recording so that the actual billing and invoicing for all utility end customers can take place.
Finally, the invoice is printed and sent to the utility end customers either on paper or by email.
At the end of the project, an optimization list is evaluated, where improvement suggestions and errors from the completed annual consumption billing were documented to initiate improvement measures for upcoming billings.

Jul 2016 - Feb 2017

8 months

Project Manager

Dekan-IT

Project: Annual Consumption Billing
Industry: Energy industry
Task: Project management and coordination
Task: Concept development
Task: Conducting workshops
Task: Administration and management
Task: Project analysis
Tool: SAP
Tool: Excel
Leading and controlling the process chain for the annual consumption billing in SAP for about 23 utilities (team of up to 30 people).
The annual consumption billing is the final settlement with the end customer in areas such as electricity, gas, water, wastewater, heat.
The actual consumed energy/service amount is determined based on meter readings or a flat rate and offset against the previously paid monthly installments in a final invoice.
The project implementation starts with creating conceptual documents for each utility and then customizing for change requests, such as scheduling in SAP IS-U.
The next step is consumption recording so that the actual billing and invoicing for all utility end customers can take place.
Finally, the invoice is printed and sent to the utility end customers either on paper or by email.
At the end of the project, an optimization list is evaluated, where improvement suggestions and errors from the completed annual consumption billing were documented to initiate improvement measures for upcoming billings.

Jul 2015 - Feb 2016

8 months

Project Manager

Dekan-IT

Project: Annual Consumption Billing
Industry: Energy industry
Task: Project management and coordination
Task: Concept development
Task: Conducting workshops
Task: Administration and management
Task: Project analysis
Tool: SAP
Tool: Excel
Leading and controlling the process chain for the annual consumption billing in SAP for about 23 utilities (team of up to 30 people).
The annual consumption billing is the final settlement with the end customer in areas such as electricity, gas, water, wastewater, heat.
The actual consumed energy/service amount is determined based on meter readings or a flat rate and offset against the previously paid monthly installments in a final invoice.
The project implementation starts with creating conceptual documents for each utility and then customizing for change requests, such as scheduling in SAP IS-U.
The next step is consumption recording so that the actual billing and invoicing for all utility end customers can take place.
Finally, the invoice is printed and sent to the utility end customers either on paper or by email.
At the end of the project, an optimization list is evaluated, where improvement suggestions and errors from the completed annual consumption billing were documented to initiate improvement measures for upcoming billings.

Mar 2015 - Apr 2015

2 months

Tester

Dekan-IT

Project: Functional Meter Reading (FA)
Industry: Energy sector
Task: Distinguish legal requirements, system technical constraints and customer requirements.
Task: Test execution
Tool: Word
Tool: Excel
Tool: SAP
The technical fundamentals of the meter reading process were to be newly developed and reorganized.
Execution was carried out with a clear distinction between legal requirements, system technical constraints and customer requirements.
To support and ensure completeness, programs/functions were newly developed or existing applications updated along the entire reading process.

Jul 2014 - Feb 2015

8 months

Surplus and Deficit Quantity Process with Supplier Assignment

Dekan-IT

Project: Surplus and Deficit Quantity Process with Supplier Assignment
Industry: Energy sector
Task: Customizing.
Task: Creating master data.
Task: FI-CA account maintenance.
Task: Checking data exchange of EDIFACT messages.
Task: Creating test invoices.
Task: Performing billing.
Task: Recording consumption quantities in device facts.
Task: Test execution.
Task: Creating documentation.
Tool: Word
Tool: Excel
Tool: SAP
The processes for determining and billing surplus and deficit quantities in the electricity and gas segments were created as interactions between grid operators and suppliers for billing surplus/deficit quantities in standardized procedures and were to be created and sent as physical invoices to all suppliers per billing month.
The scope of tasks included, among other things, customizing and setting up an RTP interface, creating or extending existing master data for business partners, contract accounts, or contracts.
Generation of supply scenarios.
Creation of new balancing units and their assignment.
Generation of EDM profile values.
Creation of meter assignments in the profile roles.
The created constructs were checked and tested for accuracy before going live.
A test run of the entire process chain was carried out.
Each supplier was to receive a billing every month.
For this, the consumption had to be recorded in the device facts, billed, and test invoices created afterwards.

Jul 2014 - Feb 2015

8 months

Project Manager

Dekan-IT

Project: Annual Consumption Billing
Industry: Energy sector
Task: Project management and coordination
Task: Concept development
Task: Conducting workshops
Task: Administration and management
Task: Project analysis
Tool: SAP
Tool: Excel
Leading and controlling the process chain of the annual consumption billing in SAP for about 23 utility companies (team of up to 30 people).
The annual consumption billing is the final billing to the end customer, among others in electricity, gas, water, wastewater, and heating.
The actual consumed energy/service amount is determined based on meter readings or a flat rate and offset in a final invoice against the monthly advance payments previously made.
Project implementation starts with creating conceptual documents for each municipal utility and then customizing for change requests, e.g. date control in SAP IS-U.
The next step is consumption recording so that the actual billing and invoicing can take place for all municipal utility end customers.
Finally, the invoice is printed and sent to the municipal utility end customers either in paper form or by e-mail.
At the end of the project, an optimization list is evaluated, in which improvement suggestions and errors from the past annual consumption billing are documented to initiate improvement measures for upcoming billings.

Jul 2013 - Feb 2014

8 months

Project Manager

Dekan-IT

Project: Annual Consumption Billing
Industry: Energy sector
Task: Project management and coordination
Task: Concept development
Task: Conducting workshops
Task: Administration and management
Task: Project analysis
Tool: SAP
Tool: Excel
Leading and controlling the process chain of the annual consumption billing in SAP for about 23 utility companies (team of up to 30 people).
The annual consumption billing is the final billing to the end customer, among others in electricity, gas, water, wastewater, and heating.
The actual consumed energy/service amount is determined based on meter readings or a flat rate and offset in a final invoice against the monthly advance payments previously made.
Project implementation starts with creating conceptual documents for each municipal utility and then customizing for change requests, e.g. date control in SAP IS-U.
The next step is consumption recording so that the actual billing and invoicing can take place for all municipal utility end customers.
Finally, the invoice is printed and sent to the municipal utility end customers either in paper form or by e-mail.
At the end of the project, an optimization list is evaluated, in which improvement suggestions and errors from the past annual consumption billing are documented to initiate improvement measures for upcoming billings.

Summary

RPA development and consulting
SAP consulting
Project management
Business analysis
Utilities industry, especially electricity, gas and water supply companies, and the waste disposal industry
(Partial) project management