Bahareh Ahmadi Gohari

. Design the data pipeline architecture for new product using SSIS, Python and TSQL. . Ingested data from data sources: SQL, MongoDB, MySQL, Oracle, flat files . Design and manage databases and data warehouses and data lakes. . Working with GitHub for synchronizing project among team members. . Utilizing typical data quality functions involving standardization, transformation, rationalization, matching. . Experience in python for automating data cleansing, data re-formatting, data transformation.

. Create complex database reports and Business Intelligence dashboards using data visualization tools such as Power BI and Tableau. . Implementation of Extraction, Transformation and Load (ETL) flows using SSIS. . Creates complex queries, stored procedures and SQL scripts to implement business logic for ETL processes. . Expertise in data warehousing (based on Kimball ) & Data Integration - dimensional modelling, facts, dimensions, helper tables, SCD concepts . Experience using SSAS to develop OLAP cube.