linkedin.com/in/mohamedmutter/ 416-***-**** firstname.lastname@example.org
Victoria, BC V8Z5W1
Degree educated, highly capable and detail-oriented Data Modeler with strong analytical skills. Having experience of 4+ years in developing Business Intelligence and Data Warehousing solutions for Higher Education and Telecommunication industries. All credentials assessed to Canadian equivalency and currently registered in the Data Analytics Program at University of Victoria.
Languages: SQL, PL/SQL, Bash Shell Scripting, Python, C#
BI Tools: SQL Developer, Oracle Data Modeler, IBM DataStage, Informatica, IBM Cognos
Databases: Oracle, IBM DB2, PostgreSQL, Cassandra NoSQL
Operating Systems: Windows, Linux, Mac OS
Other: Business Statistics, Amazon Web Services (AWS), Microsoft Office (Word, Excel, Power Point, Access)
The American University in Cairo Cairo, Egypt
Data Warehouse Developer / Data Analyst March 2017 – June 2019
Built a state-of-the-art business intelligence platform from the ground up in a leading non-profit higher education institution along with my colleagues, founding members of the BI team.
Lead five successful projects to consolidate data from diverse source systems in two years.
Automated 90% of data analysis requests from decision makers.
Received “High Achievement Award” for proactively generating valuable insights, March 2019.
Duties and Responsibilities:
Gathered requirements from strategic and operational stakeholders to analyze business problems and elicit information needed to develop data models by following the Software Development Life Cycle.
Designed and implemented logical and physical data models that meet business’s KPIs and reporting needs using Oracle SQL Developer Data Modeler with data mapping from source systems to data warehouse.
Developed PL/SQL scripts and ETL jobs using IBM DataStage for pulling, cleansing and integrating data.
Created reports on IBM Cognos by constructing complex SQL queries and validating output with users.
Worked with data governance team on identifying and resolving anomalies in metadata and source systems.
Documented database architecture and all ad hoc analysis queries worked on for future references.
Coached newly hired members on business and data warehouse structure and managed them in projects.
Technical Environment: SQL, PL/SQL, ETL, SQL Developer, Oracle Data Modeler, IBM DashDB, IBM DataStage, IBM Cognos, IBM SPSS, Oracle, SAP, Jira, Windows Server 2012 R2.
Vodafone Smart Village, Egypt
Business Intelligence Analyst July 2016 – March 2017
Lead three successful deployments for the solution remotely on customers’ servers in other countries and conducted training sessions with the end users.
Developed PL/SQL scripts and Informatica ETL jobs for data extractions and transformations.
Developed and enhanced SQL queries and other features using C# in backend of Sentiment Analysis .NET solution while applying version control via Visual Studio Team Foundation Server.
Documented new developments and modifications.
Technical Environment: SQL, PL/SQL, ETL, Toad, Informatica Power Center, ASP.Net, C#, TFS, Red Hat Linux, Windows Server 2012 R2, HTML, JSON, Jira, Citrix.
Data Analyst January 2016 – June 2016
Worked in the Data Mining team on Customer Behavior Segmentation project.
Received almost 100 Million records for exploration, cleansing, and data transformations.
Built a model that classifies and organizes individuals into segments based on how they behave towards products and services, to have more targeted communication with the customers.
Algorithms used: Correlation Analysis, Hierarchical Clustering, ANOVA, Step-wise Regression, K-Means.
Technical Environment: SAS Miner, Oracle Database, IBM DataStage, SAP Business Objects.
Education & Professional Development
Information Technology Institute, Smart Village, Egypt 2016
Professional Diploma in Information Technology
Data Science and Big Data Analytics (Equivalent to a one-year postgraduate diploma from an Ontario institution, as determined by World Education Services in Toronto, ON)
Ain Shams University, Cairo, Egypt 2013
Bachelor of Computer and Information Sciences
Bioinformatics (Equivalent to a four-year Bachelor degree from an Ontario university, as determined by World Education Services in Toronto, ON)
Oracle SQL Fundamentals (1z0-051) 2016
AWS Certified Solutions Architect – Associate (Udemy) 2019
Introduction to Data Science in Python (Coursera) 2018
Data Science Math Skills (Coursera) 2017
Introduction to Big Data (Coursera) 2017