Malak Hassen
adi80e@r.postjobfree.com
Legally authorized to work in the United States, No Visa Sponsorship Required
CAREER OBJECTIVES
Highly analytical and process-oriented data analyst with in-depth knowledge of database types; and big data capture, curation, manipulation and visualization. Furnish insights, analytics and business intelligence used to advance opportunity identification, process reengineering and corporate growth.
Experienced self-motivated data analyst, looking for a challenging role to work on several Business Intelligence technologies and environments, and seeking to improve companies performance by utilizing my skills in data analysis and creative problem solving.
PROFESSIONAL SUMMARY
Over 2+ years of professional experience in building Data Analytics and Business Intelligence Infrastructure and solutions that led to increased efficiency in business operations.
Closely worked with different management levels from Product, Technology, Finance and Marketing Teams to understand the business requirements and analysis needs.
Attended daily standup meetings to discuss the tasks at hand and weekly meetings to present the status of tasks and reports.
Experienced in writing complex T-SQL queries: stored procedures, derived tables, CTEs, views, sub-queries, and multiple joins etc.
Proficient in main Business Intelligence tools such as Tableau and Power BI for creating dynamic dashboards and reports for various business functions.
Good Understanding of Visualization Techniques by creating summary and detailed reports using Drill Down and Drill Through techniques.
Extensive knowledge in various reporting objects such as Dimensions, Measures, Hierarchies, Filters, Actions, Calculated Fields, Sets, Groups, Bins, and Parameters etc. for summarizing and analyzing key analytics findings.
Proficient in design and development of various dashboards, reports on Power BI and Tableau Visualizations such as bar graphs, scatter plots, pie-charts, maps, funnel charts, lollypop charts, donuts, bubbles, etc. making use of actions and other local and global filters according to the end user requirement.
Expertise in designing and developing filter driven interactive Dashboards, trend based KPIs, summary and detail reports featuring parameters, sorting, expressions, drill down and drill through, etc.
Created summary and detail reports with drill down and drill through features using DAX functions.
Experienced in using Python for Exploratory Data Analysis (EDA) by analyzing data sets to summarize their main characteristics and then Visualization the findings using Jupyter Hub.
Experienced in using Python for Data Preparation, Feature Engineering, Model Building, Evaluation and Deployment.
Extensive experience in using Python Libraries such as Pandas, NumPy, Matplotlib, Seaborne,
SciPy and Scikit Learn.
Great leadership qualities and excellent communication skills. Can work independently or within a team, self-motivated, determined, optimistic, and willing to learn new technology.
Ability to stay calm in stressful situations and adapt to new surroundings quickly.
PROFESSIONAL EXPERIENCE
Data Analyst July 2018 – Present
Keen Psychics (www.keen.com)
About the Project: Keen.com is an e-commerce psychic readings platform operating in the United States and is one of the fastest growing platforms in the country.
Responsibilities:
Supported management team with reports generation and analysis using reporting and visualization on Power BI.
Worked with Management teams from various departments to create departmental KPI reports for marketing, finance, product etc. to translate numbers and facts to inform strategic business decisions.
Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports using Power BI by analyzing sales figures & financial figures.
Used Python for data cleansing and exploratory data analysis to help keen.me understand trends and its customers.
Created Customer Dive Dashboards to analyze buying patterns of the customers which helped the marketing department to retain the existing customers and bring in new customers to the platform.
Created a Psychic Deep Dive Dashboard for the Product department to help manage psychic performance and increase productivity.
Created customer churn analysis report and used predictive analysis techniques to predict customers who may drop out and created flags for the marketing department to send them offers to retain them.
Deeply analyzed customer satisfaction data to help improve customer satisfaction.
Created Financial Reports highlighting areas of Sales growth, Sales Trends, Direct Expenses and Profitability to help the finance department take informed decisions.
Used Power BI features to build and configure Hierarchical dimensions, Measure, Calculated Columns, KPI, Filter and Aggregations.
Created and developed Power BI visualizations for the Key Performance Indicator (KPIs) and trend analysis.
Generate joins and sub-queries for intricate queries involving multiple tables and fields.
Expertise in data storage structures, data mining, and data cleansing.
Established Logical and Physical database models to design source to target process.
Created Logical/physical Data Model in Power designer and have worked on loading the tables in the Oracle based Data Warehouse.
Used Common Table Expressions (CTE’s), Constraints, and Complex queries to fetch the data from different servers.
Created frameworks and processes for data security to keep customers and payments data secure and confidential.
Attended the project review meetings, daily/weekly status meetings and walkthroughs with project managers and leads.
Monitor and make sure that data extracts are being refreshed properly to benefit users.
Environment:
MySQL, MySQL Workbench, SQL Server, SSMS, SSIS, AWS, Azure, Oracle, Power BI, Tableau, Jupiter Hub, Slack.
TECHNICAL SKILLS
Data Analytics
Data Cleaning, Visualization & Normalization
Math & Stats
Probability, Correlation & Mathematical Modelling
Reporting Tools
Power BI & Tableau
Languages
SQL, TSQL & Basic Python
IDE
SQL Developer, SQL Server Management Studio, Jupyter
Python
Pandas, NumPy, Matplotlib, Seaborne, SciPy, Scikit Learn
Databases
MySQL, SQL Server, Oracle
Cloud Technologies
AWS RDS, Azure
ETL
SQL Server Integrated Services (SSIS)
Operating System
Windows & MacOS
Repository System
GitHub
Server
Tableau Server 2019.2 and 2019.4
EDUCATION & PROFESSIONAL CERTIFICATIONS
B.S in Pharmacy
Faculty of Pharmacy
Aleppo University
A 6-Month Comprehensive Data Science Bootcamp
Syntax Technologies