Ahmed Wagih
Senior Data Analyst at Rubikans- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Credentials
-
SQL (Basic)
HackerRankSep, 2023- Nov, 2024 -
SQL (Intermediate)
HackerRankSep, 2023- Nov, 2024
Experience
-
Rubikans
-
Egypt
-
Software Development
-
1 - 100 Employee
-
Senior Data Analyst
-
Jun 2022 - Present
• Analyze user behavior and product usage data to inform product development and feature enhancement decisions. • Maintain data pipelines and ensure data quality and accuracy for analytical purposes. • Analyze user segmentation to optimize product features and improve user engagement. • Utilize SQL, Excel and Query to extract, clean, and manipulate large datasets, ensuring data accuracy and consistency. • Develop and implement advanced data analytics strategies to provide actionable insights and recommendations to senior management. • Collaborate with product managers and engineering teams to define key performance metrics and develop dashboards for real-time monitoring. • Collaborate with cross-functional teams to define data requirements, gather and preprocess data, and design custom analytics solutions tailored to business needs. • Create interactive data visualizations and reports using tools like Google Looker Studio and Power BI, effectively communicating complex findings to non-technical stakeholders. Show less
-
-
-
DEVARTLab
-
Egypt
-
Pharmaceutical Manufacturing
-
300 - 400 Employee
-
Data Management Analyst
-
Jun 2022 - Present
-
-
Senior Sales Analyst
-
Jan 2019 - Jun 2022
• Analyze sales data, including product performance, and sales trends.• Identify key factors influencing sales, such as seasonality, customer behavior, and competitor activity.• Develop and maintain sales forecasts to help the company anticipate market demand and optimize inventory levels.• Collaborate with cross-functional teams to align forecasting with production schedules.• Create and maintain regular sales reports and dashboards for senior management.• Provide timely and accurate sales performance reports to sales teams, helping them track progress toward goals.• Segment customers and analyze their buying behavior to tailor sales strategies and marketing campaigns.• Assess the performance of different products in terms of sales, profitability, and market share.• Analyze the impact of promotional campaigns, discounts, and incentives on sales performance.• Provide recommendations for effective sales promotions.• Use data visualization tools such as Power BI or Excel.• Track actual spending against budgets and identify areas for cost optimization.• Collaborate with marketing, product management, finance, and sales teams to align strategies and achieve common goals.• Present findings, recommendations, and insights to senior management and stakeholders.• Monthly sales analysis.• Rank medical reps, supervisors, and area managers.• Incentive for medical reps and supervisors.• Compare sales per month and week: Total company / Line / Product / Area manager/ Supervisor/ Medical rep.• Monthly Sales Effectiveness: Total company/ Area manager/ Supervisor/ Medical rep.• Analyze IMS Data by Product, Area, Specialty, and Market• Excel sheets designer Using Query, Power pivot, Formulas• Power BI Visualization Using Query connected with SQL Server Database Show less
-
-
Assistant sales analysis
-
May 2015 - Jan 2019
• Daily sales analysis.• Weekly sales analysis.• Monthly sales analysis.
-
-
-
DEVARTLab
-
Egypt
-
Pharmaceutical Manufacturing
-
300 - 400 Employee
-
Key Account Sales Specialist
-
Sep 2014 - Mar 2015
-
-
Education
-
Ain Shams University
Accounting