Resume

Sign in

Data Warehouse Developer, Data Analyst, ETL Developer

Location:
Victoria, BC, Canada
Posted:
October 07, 2019

Contact this candidate

Resume:

Mohamed Mutter

linkedin.com/in/mohamedmutter/ 416-***-**** adajb1@r.postjobfree.com

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.

Technical Skills

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)

Experience

The American University in Cairo Cairo, Egypt

Data Warehouse Developer / Data Analyst March 2017 – June 2019

Achievements:

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)

Certifications:

Oracle SQL Fundamentals (1z0-051) 2016

Online Courses:

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



Contact this candidate