Flexible hard worker ready to learn and contribute to team success with excellent research, technical and problem-solving skills. Detail-oriented and able to learn new concepts quickly.
Overview
4
4
years of professional experience
Work History
Power BI Engineer
ITICSYS
Marrakech, Marrakech-Safi
01.2020 - 09.2022
Requirement Analysis:
- Collaborated with stakeholders, including business analysts and end-users, to understand their reporting and analytics requirements.
- Translated business needs into technical specifications for Power BI development.
Data Modeling:
- Designed and implemented data models using Power BI Desktop, defining relationships between tables, creating calculated columns, and optimizing data structures for performance.
- Worked with various data sources, including databases, Excel files, and online services, to import and transform data into usable formats.
Report and Dashboard Development:
- Developed interactive and visually appealing reports and dashboards using Power BI Desktop.
- Implemented advanced features like drill-throughs, bookmarks, and custom visuals to enhance user experience.
- Ensured consistency and adherence to design principles in creating a cohesive and intuitive reporting environment.
Power Query and Data Transformation:
- Utilized Power Query to clean, transform, and shape raw data into a format suitable for analysis.
- Applied data cleansing techniques, handled missing or inconsistent data, and performed data enrichment as necessary.
DAX (Data Analysis Expressions) Formulas:
- Created complex DAX formulas to derive new calculated columns and measures, addressing specific business metrics and key performance indicators (KPIs).
- Implemented time intelligence functions for date-based analysis.
Data Integration and Automation:
- Integrated Power BI with various data sources, including SQL Server, Azure, Excel, and other third-party applications.
- Automated data refresh and scheduled report generation to ensure that information was up-to-date.
Data Analyst
Mercure IT
Casablanca, Casablanca-Settat
01.2019 - 12.2020
Data Collection and Cleaning: Collecting relevant data from various sources, including internal databases, external data providers, and APIs. Cleaning and organizing data to ensure accuracy and consistency.
Data Exploration and Analysis: Conducting exploratory data analysis to identify patterns, trends, and anomalies. Utilizing statistical methods to analyze customer behavior, financial transactions, and other relevant data points.
Reporting and Visualization: Creating dashboards and reports to present key findings to stakeholders. Using visualization tools such as Tableau or Power BI to make complex data more accessible and understandable.
Risk Management: Analyzing credit risk, market risk, and operational risk by examining historical data and developing models to predict potential future risks.
Customer Segmentation: Utilizing data to segment customers based on various criteria such as demographics, transaction history, and behavior. This segmentation can inform targeted marketing strategies and personalized customer experiences.
Fraud Detection: Developing and implementing algorithms to detect suspicious activities or potential fraud within financial transactions. This involves building models that can identify unusual patterns and anomalies.
Predictive Modeling: Building predictive models to forecast financial trends, customer behavior, and other relevant metrics. These models can assist in making informed decisions and strategic planning.