Business Intelligence Data Analyst
Aptec - an Ingram Micro company
Total years of experience :14 years, 7 Months
Daily Tasks:
1. Descriptive Analysis
2. Data visualization and dashboards
3. Business analytics
4. Reports Modelling
5. Querying Data
6. Business data insights and decision making support
7. Predictive Analysis
Software and Apps used :
1. Excel: Complex Equations- Graphs - Pivot table - Data Lookups and Match - Data Analysis Packages - Power Query- Conditional Format - Macros
2. Power BI: Data Querying - Tables Relationships - Dashboards - Calculated Columns - DAX Complex Equations
3. Business Objects (SAP): Querying Data Objects - Complex Equations - Dashboards - Subqueries - Report and Visuals Filters - Report Data Inputs
Daily Tasks:
1. Collect, extract, clean, and analyse data
2. Design reports models
3. Create visually impactful
4. Create KPIs from work-flow and structured data.
5. Design forms in M Access for data with high quality.
6. Train Secretaries and Data entry personals to supply us higher quality of data.
7. Testing hypotheses for research
Software and Apps used :
1. Excel: Complex Equations- Graphs - Pivot table - Data Lookups and Match - Data Conditional Format - Macros
2. Power BI: Data Querying - Tables Relationships - Dashboards
3. SPSS: Variable identification - normality test - T-test - Nonparametric test - Graphs- Crosstabs - linear regression ….
4. Business Objects (SAP): Querying dates - refresh reports - extract data
Administration Assistant at Children's Cancer Hospital in Egypt CCHE - Research Department, It's kind of similar to my job at Glenmark but also I use my statistical skills in a limited way using SPSS, I contribute administrating in Scientific Advisory committee in the hospital, IRB Committee concerned about research ethics and also administrate in medical web conferences, I also had a fine experience in communications with other different departments and how to have a vision and organize my mission in a scientific way.
Sales Consultant in Asio African Co. for Commercial Trade and Decoration. It's a job requires the talent of getting people convinced of the idea you present and also making them buy it, also requires to know how to deal with all different kinds of human bean and all different kinds of situation, I should be creative to deal with all of that and also to be very well organized and being aware of the atmosphere around the market and the products which related to my product and the whole atmosphere around my clients and the clients I haven’t get.
Administration Assistant at Glenmark Pharmaceuticals Egypt. It's a job that requires a good computer skill, fast thinking, being well organized, being reliable and have good English (writing and speaking) as it's a multinational company. This job has been giving me the opportunity to have a close vision to many specialties such as Finance, Sales, H.R, Registration & Management and taught me how to deal with different classes of human been and also taught how to be a trouble shooter.
Statistics Diploma in Statistics and Research Institute- Cairo University.
Faculty of commerce, Statistics department.