Mohamed Akram Aniss
Verified Expert in Engineering
Database and Software Developer
Maadi as Sarayat Al Gharbeyah, Maadi, Cairo Governorate, Egypt
Toptal member since April 15, 2022
Mohamed is a data analyst with over three years of experience working with SQL, Tableau, R, and Python in tech and telecommunications companies. He's been firefighting fraudulent activities and leakages, extracting relevant insights from large datasets, creating effective presentations and reports, and collaborating with cross-functional teams to improve business decision-making. Mohamed is seeking a challenging position where he can utilize and further develop his skills.
Portfolio
Experience
- SQL - 7 years
- Business Intelligence (BI) - 4 years
- Tableau - 4 years
- ETL - 3 years
- Python - 2 years
- R - 2 years
- Apache Airflow - 1 year
- Datastage - 1 year
Availability
Preferred Environment
Tableau, SQL, Python, R, DataStax, Apache Airflow, Excel 365, Data Analytics
The most amazing...
...thing I've revamped is a fraud detection framework for Careem Uber that decreased our leakages by 67% YoY.
Work Experience
Senior Data Analyst
Tamara
- Optimized Zendesk API integration to extract all fields, including custom ones, enhancing reporting and operational insights.
- Designed advanced SQL queries to flatten and transform JSON data in BigQuery, improving analytics efficiency.
- Built a dynamic ID mapping framework integrating external APIs, eliminating data discrepancies and boosting real-time reporting accuracy.
Tableau Data Visualization Specialist
Seiner Management, Inc. dba Jerry Seiner Dealerships
- Developed and optimized SQL queries to handle complex datasets, enabling efficient analysis and reporting for global clients.
- Created advanced data transformation scripts in Python, improving data reliability and delivering actionable insights to stakeholders.
- Built scalable data solutions and designed and implemented scalable ETL pipelines for diverse client projects, ensuring seamless integration and high-performance data processing.
Business Intelligence Analyst
Central Bank of Egypt
- Analyzed and visualized the Central Bank's confidential reports.
- Managed the data sources business analysis for data warehouse development and modeling.
- Tracked the bank's performance and created visualizations to detect reporting anomalies.
Fraud Data Analyst II
Careem Networks FZ
- Observed customer transactions to identify fraudulent activities, such as account takeover, friendly fraud, theft, and other similar risks.
- Identified fraudulent transactions and canceled them from further processing.
- Determined existing fraud trends by analyzing accounts and transaction patterns.
Data Modeler and Business Intelligence Developer
Vodafone Egypt Telecommunications SAE
- Modeled current production DWH to IBIS DWH hybrid model, Teradata CLDM, and IBM TDW.
- Acted as a technical focal point between Vodafone management, project managers, and vendors in the DWH transformation project.
- Led a transformation validation team in SIT and UAT.
- Reversed current engineering BI reports and jobs to conclude business logic to adjust and transform the new model accordingly.
- Oversaw new environment software installation, including DataStage, business object, and data migration.
IT Operations Data Analyst
World Food Programme
- Explored and applied new data visualization techniques to increase insight and visibility of data trends and associated policy-related opportunities, challenges, and priorities.
- Developed comparatives graphs and reports and trend analysis.
- Identified, acquired, loaded, cleaned, and managed data through tailored spreadsheets, templates and databases, to ensure the quality of the data produced.
Experience
DWH Transformation Project
Acted as a technical focal point between Vodafone management, project managers, and vendors in the DWH transformation project. I led the transformation validation team in SIT and UAT and reversed current engineering BI reports and jobs to conclude business logic to adjust and transform the new model accordingly.
Education
Master's Degree in Data Science
Cairo University Institute of Higher Education - Cairo, Egypt
Bachelor's Degree in Computer Science
Cairo University - Cairo, Egypt
Skills
Libraries/APIs
Complex SQL Queries
Tools
Tableau, Jupyter, BigQuery, Microsoft Power BI, Git, Stitch Data, Apache Airflow, Oracle SQL Data Modeler
Languages
SQL, Python, R, Python 3, Snowflake
Paradigms
Business Intelligence (BI), ETL
Storage
Databases, PostgreSQL, Database Architecture, Database Performance, SQL Server 2016, Data Pipelines, Data Lakes, Microsoft SQL Server, MySQL, Datastage, MariaDB
Platforms
HubSpot, Google Cloud Platform (GCP), Amazon Web Services (AWS)
Frameworks
Django
Other
Reports, Data Visualization, Dashboards, Data Analysis, Teamwork, Data Analytics, Reporting, Data Interpretation, Forecasting, Dashboard Design, Data, Data Engineering, Performance Optimization, Data Modeling, Key Performance Indicators (KPIs), Looker Studio, Google BigQuery, ELT, API Integration, Excel 365, Information Systems, Data Build Tool (dbt), Fintech, Data Science, SAP BusinessObjects (BO), Options Trading, Software as a Service (SaaS), Metabase
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring