Amr Arous
Verified Expert in Engineering
Data Modeling Developer
Dubai, United Arab Emirates
Toptal member since May 10, 2017
Amr is an accomplished professional with over 14 years of expertise in data management, data strategy, data modeling and architecture, and data governance across different industries such as telecommunication, banking, and the public sector. He's recognized as a data expert with a proven track record in delivering mega projects, overseeing end-to-end data lifecycles, and optimizing data architectures for scalability and performance to drive business growth.
Portfolio
Experience
- SQL - 15 years
- Business Intelligence (BI) - 13 years
- ETL Implementation & Design - 12 years
- Oracle PL/SQL - 10 years
- Data Modeling - 10 years
- Erwin - 6 years
- Data Visualization - 5 years
- Tableau - 2 years
Preferred Environment
Data Modeling, Business Intelligence (BI), ETL, Snowflake, Data Architecture, Python, Azure Data Factory (ADF), Data Governance, Azure, Databricks
The most amazing...
...and challenging thing I developed was a data migration project for 20 source systems into one big data solution through well-defined, integrated data pipelines.
Work Experience
Lead Data Engineer
Commonwealth Financial Network
- Worked on a data migration project from the legacy Microsoft SQL Server system to Azure and Snowflake. Key accomplishments include successfully extracting, transforming, and loading terabytes of data into the target cloud platforms.
- Used technologies such as Azure Data Factory and Snowflake (Snowpipe). Seamless data pipelines handle 500+ ETLs in five workflows.
- Completed the project within the timeframe and budget. Data volume emphasizes the scale of the migration (terabytes), and data quality highlights the focus on data integrity and accuracy.
Data Architect
IBM
- Translated requirements and generated and developed a roadmap utilizing the best practices for the project with comprehensive and obtainable milestones.
- Developed and deployed dashboards, visualizations, and autonomous and dynamic reporting interfaces to be distributed to stakeholders via the BI reporting platform.
- Optimized report distribution, execution, and scalability of all reporting solutions so they are autonomous and dynamic.
- Worked with the data team to create conceptual, logical, and physical database design, data modeling, and mapping.
Data Modeler | Data Architect
Teradata
- Interacted with business analysts and end-users to understand and translate business needs into data models supporting long-term solutions.
- Created conceptual, logical, and physical data models using best practices to ensure high data quality and reduced redundancy using Erwin.
- Created a standard abbreviation document for logical, physical, and dimensional data models.
- Reversed engineered physical data models from databases and SQL scripts.
Senior Business Intelligence Analyst
Vodafone
- Delivered daily and weekly ad-hoc reports with speed and high quality.
- Designed and developed dashboards to monitor major KPIs on an hourly, daily, weekly, and monthly basis.
- Led coached and influenced other team members.
- Participated in the financial monthly and yearly closings.
- Built user interactive universes and reports to enable self-driven BI for customers.
- Implemented company policies, technical procedures, and standards for preserving the integrity and security of data, reports, and access.
- Designed strategic plans for component development practices to support future projects.
ETL Specialist | ETL Team Lead | Data Modeler
Data Gear
- Designed, implemented, and operated comprehensive data warehouse systems to balance optimization of data access with batch loading and resource utilization factors, according to customer requirements.
- Developed data warehouse process models, including sourcing, loading, transformation, and extraction.
- Created and implemented metadata processes and frameworks.
- Created plans, test files, and scripts for data warehouse testing, ranging from unit to integration testing.
- Created supporting documentation, such as metadata and diagrams of entity relationships, business processes, and process flow.
- Designed and implemented warehouse database structures.
- Developed and implemented data extraction procedures from other systems, such as CRM, billing, and CDRs.
Web Developer
Eknowledge
- Created website layout and user interfaces by using standard HTML and CSS practices.
- Integrated data from various back-end services and databases.
- Gathered and refined specifications and requirements based on technical needs.
- Wrote well-designed, testable, efficient code using best software development practices.
- Created web models or prototypes that include physical, interface, logical, or data models.
Experience
Data Integration of Ericsson-IN to Oracle Communication Data Model
The scope of integrating Ericsson-IN with OCDM is feeding and integrating Ericsson-IN as a source of calls, recharges, and subscriptions transactions CDRs with OCDM.
Technologies: Oracle PL/SQL, Oracle ODI, Oracle OBIEE, Erwin, SAP BO
Teradata Reports Migration to Oracle Business Intelligence Enterprise Edition 11g
Technologies: Oracle PL/SQL, Oracle ODI, Oracle OBIEE, Erwin, SAP BO
GID Case Management Solution
School Management System
Technologies: ASP.NET 3.5, Microsoft Visual Basic .NET,
LINQ, Microsoft Visual Studio 2010, Microsoft SQL Server 2008 R2
Telecommunication Business Intelligence Project
Technologies: Microsoft SQL server 2014, SSIS, SSAS, SSRS, CDC, Erwin
Education
Diploma in Big Data and Data Science
Nile University - Egypt
Bachelor's Degree in Computer Engineering
Ain Shams University - Egypt
Skills
Libraries/APIs
PySpark, LINQ
Tools
Microsoft Power BI, Tableau, Erwin, Git, AWS Glue, Microsoft Excel, Oracle Business Intelligence Enterprise Edition 11g (OBIEE), Visual Studio, Cognos Analytics 11, Oracle SQL Data Modeler, Kafka Streams, Apache, Power BI Desktop, Claude, Terraform, Apache Sqoop, IBM InfoSphere (DataStage), Apache Impala, Oracle GoldenGate, SAS 9.3
Languages
SQL, Python, SAS, Transact-SQL (T-SQL), Snowflake, JavaScript, C#, Scala
Frameworks
Data Lakehouse, Hadoop, Spark, Delta Live Tables (DLT), ASP.NET, Apache Spark
Paradigms
ETL, Business Intelligence (BI), ETL Implementation & Design, Oracle ODI, Agile, Model Context Protocol (MCP), Automation
Platforms
Windows, Azure, Oracle, Azure SQL Data Warehouse, Azure Service Fabric, Linux, Apache Kafka, Amazon Web Services (AWS), Databricks, Microsoft Fabric, Azure Synapse, Reltio
Storage
Data Pipelines, Microsoft SQL Server, Oracle PL/SQL, Database Modeling, Databases, Data Integration, Relational Databases, PL/SQL, Database Architecture, Google Cloud SQL, Teradata, PostgreSQL, SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), Apache Hive, HBase, MySQL, IBM Db2, Google Cloud, Database Backups, HDFS, Azure SQL, Oracle SQL Developer, SAS SQL, Neo4j
Other
Data Architecture, Informatica, Data Warehousing, Data Engineering, Data, Data Warehouse Design, ETL Development, Data Modeling, SAP BusinessObjects (BO), ETL Tools, Business Intelligence Architecture, Data Analysis, Architecture, Reports, Dashboards, Finance, Change Data Capture, Database Schema Design, Star Schema, ETL Pipelines, Data Orchestration, Financial Data Analytics, System Architecture, Data Warehouse Implementation, Data Mesh, Data Migration, Data Virtualization, Data Visualization, Business Analysis, Azure Data Factory (ADF), Big Data, Data Governance, Data Analytics, ELT, API Integration, Data Cleansing, Amazon RDS, Big Data Architecture, Data Vault 2.0, Oracle BI, APIs, Data Build Tool (dbt), Reporting, Analytics, Data Quality, Technical Leadership, Microsoft Azure, DI, Azure Data Lake, Data Marts, IBM InfoSphere Data Governance, IBM InfoSphere Information Governance Catalog, SAS Visual Analytics, erwin Data Modeler, Financial Services, Requirements, Business Rules, Profisse, Azure Databricks, Artificial Intelligence (AI), AI Pipeline
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