Member of the Data and Analytics team.Participated in a data migration project for a major telecommunication company:• Mapping of source system data to existing DWH models, defining relationships between data elements in source and target systems.• Design of efficient ETL flows based on the understanding of business needs that align with existing complicated architectures and identifying opportunities for improvement.• Implementation of ELT flows (Oracle Data Integrator) incorporating any necessary business logic to transform data.• Optimization of ETL processes to handle growing data volumes.• Support of UAT process, deployment to production and error handling.

Data transformations with Microsoft SSIS importing data from files, moving data from one database platform to another (ORACLE databases, SQL Server)Prepare and test ETL processes, for deployment to productionDevelop and maintain SQL stored procedures to be used during the ETL process

• Reports for customers on annual basis (product category overview, price and promotional analysis)• Data manipulation• Visualization

My main responsibilities were customer service and sales (via online or physical store). Advised customer on type of equipment for specific purposes.Also, I was responsible for social media marketing. (creation of content in the main site and all of the social media profiles)