JAHAN MOHAMED
I have more than three years (UAE and Sri Lanka) of experience in a professional data analyst role. Motivated, teamwork orientated and responsible Data Analyst with Significant experience in increasing comprehension of reports and presentations by the average professional. Proficient knowledge in statistics, mathematics, and analytic. Excellent understanding of business operations and analytic tools for effective analyses of data. Page - 01
adwlaa@r.postjobfree.com
http://www.linkedin.com/in/jah
an-mohamed-a59736233
https://github.com/JahanMohamed
Power BI Developer
Work Experience
Summary
• Work closely with internal stakeholders to improve tender bids by analyzing trends and competitor analysis.
• Undertake tactical actions to hit KPIs and the maintenance of KPIs Tracking, updating reporting and provide internal stakeholders with recommended solutions.
• The ETL process builds on Power Query, MySQL and Python then does the data modeling used by the star schema method in Power BI.
• Creating DAX Queries to generate computed columns and measure & Share and Access, setup RLS, Scheduled/Incremental refresh, Subscription in Power BI Services.
• Create and maintain rich, interactive Power BI visualizations through data interpretation and analysis, with reporting components from multiple data sources.
• Create the Apps in Power BI Service and share the report on higher officials and clients.
• Sound knowledge in RDBMS such as MYSQL, Microsoft SQL Server and advanced SQL queries concepts.
• Basic understanding in SSIS, SSAS, Data warehouse, Azure concepts. Data Analyst (UAE)
Innovative Business Center. Aug 2021 - Jan 2023
• Identifying and analyzing the impact of marketing and product changes on customer acquisition & behavior, and retention.
• Generating MIS reports such as inventory report, revenue report, and profit/loss report on Excel and Power BI.
• Strong analytical skills with the ability to collect, organize and analyze the information with attention to detail and accuracy.
• Create data dashboards, graphs & visualizations using pivot table and essential function such as Xlookup, sumifs, countifs, index etc.
• Automate and validate newly created reports and develop corrective actions to improve data integrity and quality. Data Analyst (Sri Lanka)
AJN ENTERPRISES Jan 2020 - Jun 2021
Page - 02
Education
• Bachelor of Science (Physical Science)
(Mathematics, Applied Statistics)
South Eastern University of Sri Lanka.
IBM
• Databases and SQL for Data Science with Python
• Learning SQL Programming
• Power BI Mistakes to Avoid
• Data Visualization with Python
IBM
• IBM Data Analyst
IBM
Certification
Software Skills
• MySQL
• Tableau
• Plotly
• Power BI
• NumPy
• SPSS
• Python
• Seaborn
• Pandas
• Advanced Excel
• Matplotlib
• Jupyter Notebook
Technical Skills
• Data Collection
• Data Modelling
• Data Storytelling
• Data Transformation
• Data Cleaning
• Statistical Analysis
• Data Visualization
• Statistical Analysis
Languages
• Reading - 6.0 Score
• Writing - 5.5 Score
• Speaking - 5.5 Score
• Listening - 6.0 Score
Got 6 Overall Band Score in IELTS GENERAL TRAINING (International English Language Testing System)
• Database and SQL for Data Science
with Python
• IBM
Page - 03
Projects
• Used MySQL to combine the data and developed queries to analyze business insights.
• Connect the MySQL Database in Power BI then build some graphs and visualization.
• Technical skills Improved in MySQL and Power BI. Hotel Revenue & Car Parking Requirement Analysis
• Understanding Requirements and used Power query editor for Data Transformation and Cleaning.
• Used DAX function to measure some important calculations and create the dashboards.
• Technical skills Improved in Power BI, Data Modeling, and Data cleaning HR Analysis
• Developed SQL queries and find the customer’s Recency, Frequency and Monetary to detect the best customer.
• Connect the Power BI and Visualize charts.
• Technical skills Improved in Advanced SQL queries such as windows function, subqueries, etc. and Power BI. RFM Analysis
• Developed EDA Analysis used by Python Libraries such as Pandas and NumPy.
• Using Matplotlib and Plotly to create the graphs.
• Technical skills Improved in Jupyter Notebook and Python. Revenue and Customer Ageing Report
• Connect the Data Source and cleaning the data using power query editor then calculate the important measure through DAX functions.
• Using Power BI Desktop and Data Visualization then generate the Revenue and Customer Ageing Reports.
• Technical skills Improved in Power BI, Data Transformation. Video Games Sales Analysis