Aera TechnologyApplication Developer
Jan. 2018 - Apr. 2022Bucharest, RomaniaWe are developing a self-driving supply chain solution, named Aera, that provides beside business
charts and reports, a forecast and recommendation system.
What I’ve worked on:
- create the connections necessary to extract data from several source systems
- create the extraction processes
- create the fact tables and the populating scripts
- add new business measures
- map all the attributes and measures in UI and create the reports and
dashboards
- organize the populating processes of dimensions and facts into integration groups and schedul
them
- developing a full web application for each of our customers, using Aera's Developer and UI Builder
tools, including charts, reports components, end-to-end functionality. I had to implement corelated
filters on the entire page content which would dinamically change their set of data based on the
choices selected. Also, the tables were editable, meaning that you could change a value and after
that all the measures were re-calculated real-time in order to show a business simulation.
- create Skill processes (using the internal tool) - these processes have also javascript and java
behind, interfaces that interogate the database, IF/WHILE nodes and an UI layout - similar to
Informatica ETL Tool
Beside the technical tasks, I am working closely with the clients in order to create an optimal
solution, as a BA and Solution Architect role.
Tech&tools:
SQL, Exasol columnar database, DWH – Star Schema architecture standard and Data Vault, MySql
Server, Filezilla for SFTP server AWS, Python, Java, Javascript
Work methodology: Agile
Oracle Developer at DB Global Technology
June 2015 - January 2018 (2 years and 7 months)