Hisham Parol

Data Engineer @Dee Set: Complete Retail Solutions

Communicated effectively with stakeholders to understand business requirements and built data pipelines to ingest data from various transactional sources such as SQL Server, Azure Cosmos DB, Blob Storage, and FTP Servers. Worked in a team environment, shared knowledge, and designed transformation and orchestration jobs on ETL tools such as Matillion and Azure Data Factory. Designed data architecture including Staging, Persistent Staging Area, Fact, Dim, and bridge tables for various business units and stored data in Snowflake clusters. Created SQL views based on Fact and Dims for PowerBI reporting, collaborated with business teams to identify key metrics and transform data into actionable insights. Managed data quality checks and ensured that data pipelines are accurate and reliable. Optimized data pipeline to improve performance and reduce computation cost by 20%. Experience in Snowflake data warehouse, creating schema, views, clones, time travel and assigning roles and privileges for users from various departments. Built and managed Python scripts that run on a remote server fetching order files, sales trait, and inventory data from internal FTP and client web servers that automate the work of the fulfilment team. Worked with Supply Chain team to build and manage Python scripts that automate the creation of reports for pick and pack process in the warehouse, saving manual processing time by 95%.