Kais Jedidi

– Technologies used: Azure Data Factory, T-SQL, DAX, Synapse Analytics, Azure Analysis Services, Azure Devops, GIT

– Implemented a solution for collecting and analyzing expense reports: – Encrypt/Decrypt PGP files – Ingest files from S3 – Transform Data – Graph API – Implemented a DWH for tracking training and completion rates: – Data modeling – Data Ingestion: ADF – Data Serving: Power BI & DAX – Implemented a DWH for tracking Yammer usage statistics: – Yammer API – Graph API – Run and support sales AAS Cube – Architecture and Infrastructure: – Deployment of infra in Terraform – Azure PowerShell (Enable/disable locks on resources, Copy Azure DB...) – Copied transfer files and S3 statements > SFTP Accor and SFTP Accor > S3 using Python – Technologies used: Azure Data Factory, ADF dataflows, Azure functions, Graph API, AAS, Yammer API, Terraform, PowerShell, Lambda Python, S3, Cloudwatch, KMS

– BI revamp project / Data Modernization / Digital Transformation – Technologies used: Azure Datalake Store, Azure Data Factory, Azure Function, Terraform, Azure DevOps, Azure Synapse, Azure Analysis services, Power BI, Azure functions, PowerShell, API Rest

– POC SNOWFLAKE on the vendor bonus calculation part – Technologies used: Azure Datalake Store, Azure Databricks, Snowflake, Azure Function, Event Grid, Azure Storage, Azure DevOps, Terraform, SPARK/SCALA, SSAS Tabular, Power BI

– Modernization of a donation collection solution for large retailers – Implemented a cloud solution to load any flow via JSON and dynamic SQL configuration – Facilitated business workshops and gathered requirements – Proposed target architecture: – Storage: Bucket CGP – DWH: PostgreSQL – Orchestration: Talend – Costing and budgeting – Wrote technical specifications (Business rules, Data normalization and enrichment, rejection rules...) – Implemented line-by-line and mass automated tests – Monitored developments (1 developer) – Technologies used: CGP, PostgreSQL, Talend

– Implemented a Data Hub in AZURE – Created Azure resources – Created and orchestrated pipelines in Azure Data Factory – Defined and created the data model, developed stored procedures, SQL functions – Created a SCALA notebook on Databricks for matching nurses – Used Azure SQL Data Sync for data synchronization – Created Logic Apps for monitoring – Created ARM templates, CI/CD pipelines – Wrote Technical specifications and data dictionary – Technologies used: ADLS Gen2, Azure Databricks, Azure Data Factory, Azure Function, Azure DevOps, ARM, Azure SQL Database, Power BI

– Implemented a Data Platform in Azure / Digital Transformation project – Audited existing systems and various audience data sources: – Multiple API Rest – AWS S3 Bucket – OpenData – Facilitated Data Delivery workshops, project follow-up points – Proposed target architecture – Created resource groups, storage accounts, Azure Server and database – Implemented CI/CD pipeline – Prototyped and built Power BI audience dashboards – Technologies used: Azure Datalake Store, Azure Databricks, Azure Data Factory, Azure Function, Azure DevOps, ARM, Azure SQL Database, Power BI

– Technologies used: SQL Server 2012/2016/2017, T-SQL, SSIS, SSAS, SSRS, Visual SourceSafe, Git, TFS, Powershell, C#, .NET, Access, Excel, Power BI, Datazen

– Designed and developed: Prepared workshop materials, Facilitated design workshops, Gathered requirements and wrote CRs, Wrote SFD and STD, Created report mock-ups, Designed data models, UML diagrams, and data dictionary, Supported development team during implementation and testing phases, Developed SSIS, SSAS, SSRS, and Excel Services – Technologies used: MICROSOFT BI SQL SERVER 2012, SSIS, SSAS, SSRS, TFS, Excel Services, DAX, Power BI

– Technologies used: MICROSOFT BI SQL SERVER 2014, SSIS, SSAS, SSRS, Oracle, MySQL, Web Service

– Technologies used: SQL Server 2008, SSIS 2008, SVN, Oracle, MySQL, Excel, Neolane, Omniture

– Technologies used: SQL Server 2008, SSIS, SSAS, TFS, MDX

– Data migration between Dynamics CRM and Dynamics NAV: Managed contract signatures via web service, Integrated clients, contacts, orders, and contracts, Migrated parameter entities to Dynamics CRM, Integrated invoicing – Designed and implemented: Technical specifications, Migration flow design and CRM integration to NAV, Developed SSIS, SQL, Set up technical architecture, Functional & technical testing, Developed Web Services for CRM parameter entity integration, Monitored versioning via TFS – Technologies used: BI SQL Server 2012 Suite, BDD SQL Server 2012, SSIS 2012 catalog, TFS, Microsoft Dynamics CRM

– Project: Migration of SAS platform to SQL Server 2008 R2 – Functional domain: Insurance – Key functionalities: Implemented Datawarehouse and activity reporting: Commercial monitoring (monthly portfolio, breakdown of insurer premiums, provision calculation...), DSR statistics (claims settlement, claims delay tracking...), Customer satisfaction, Quality control, Supplier statistics – Designed and implemented: Data warehouse feeding under SQL Server 2008 R2 and SSRS report development, Translated SAS macros to SQL/SSIS, Technical specifications, Designed & developed business dashboards (Analysis, design, and development) – Technologies used: Microsoft SQL Server 2008 R2, SSIS, SQL, SSRS, Excel 2010

– Project: Project E-Burma – Key functionalities: Implemented a decision-making and budgeting tool for Administrative, Financial, Management Control, and HR departments – Designed and implemented: Gathered functional requirements, Analyzed existing reports and data sources, Incorporated new interfaced data, Wrote detailed functional and technical specifications, Designed and developed data flows, Prepared integration test scenarios, Oracle BI Reporting – Technologies used: OBIEE, Oracle, PL-SQL

– Project: Developed dashboards and management reports for the market department (projects, calls for tenders, and submissions). Monitored project evolution. – Designed and implemented: Gathered requirements, Developed decision model (KPI, Dimensions, Stars Models), Wrote general functional specifications, Developed SSIS Packages – ODS, DWH, DTM, Developed Cubes under SSAS, Designed and developed SSRS reports, Deployed reports under SharePoint – Technologies used: SQL Server 2008 R2, SSIS, SSAS, SSRS, SSMS, SharePoint 2005, Oracle