Amir Ketata: Architect - Business Intelligence and Predictive Analytics
T:+1-514-***-**** /+1-613-***-**** a acxlpk@r.postjobfree.com h ttp://BIAmir.wordpress.com Objectives: R each higher levels in business optimization, project management, data architecture and advanced analytics. Strengths: B usiness Optimization, Data Architecture, Analytics, Advanced Analytics and Data Governance. Fluent Languages: E nglish - French - Arabic
Professional Experience
BI Architect Scientist-Tungsten Rev. Consultants[ 08/2014:11/2016]
Product Owner: analyzed & fulfilled business needs with C officers.
BI Adoption: Boosted adoption by demos, documentation & trainings.
Data Architect: Built a DW on SQL Server & Azure DBs.
Data Integration: Orchestrated ETL pipelines, Profiling, MDM, SCD, with SQL, SSIS, Azure Data Factory.
OLAP: Architected Cubes with PowerPivot, DAX, SSAS.
BI Technology Selection:D eployed analytics solutions: Qlik Tibco SpotFire, Pentaho, Tableau, SAS, Power BI, BO.
Analytics: B uilt dashboards on Power BI, Qlik Sense & QlikView.
Advanced Analytics:B uilt forecasts on SAS,R & Azure ML.
Data Governance: G overned BI security, SQL maintenance plans, MDW, quality, availability and performance tuning.
BI Project Manager: M anaged Agile projects in TFS, Jira and Trello
Peer Bonuses: Highest in TRC company.
Methodologies
Kimball Dimensional - Inmon EDW - Data Hub - Data Volt. UML Agile - Scrum + XP Lean Six Sigma RUP ERD. BI Developer. Raymark-Mi9 [ 5Y: 07/2009:06/2014]
Developed BI & C# with VS and SQL Server 2008-12.
Developed BI dashboards on: SSRS, PowerPivot, Dundas, DevExpress, QlikView and Performance Point/Share Point.
Trained clients, developers, marketers, & managers on BI.
Produced SSAS Cubes and & Data Mining models.
Developed a recommendation system, and SQL and MDX query builders and web services with C#, SQL,WFC, DMX.
Produced R&D projects and white papers, saving 300K$+.
Developed & optimized ETL on SSIS, tables, triggers, SPs.
DBA: Produced maintenance plans, permissions, replications, backups, linking servers, jobs, and tunning.
I built entities, reports, & customizations on Dynamics CRM. Data Scientist-Predictive Analytics. Concordia[ 2.5Y: 01/07:04/2009]
R&D Improving clustering and personalization of web data.
Developed ETL & ML on C++, SQL Server & Access.
Published 2 papers (1 on IEEE-SSCI 2009) and a thesis. Database Development trainer. Concordia [ 5M: 01-05/2008]
5 months as database trainer at Concordia.
Tutored a Database course design and on SQL and MySQL.
Analyzed and evaluated hundreds of tasks and projects. Education
M .Sc. Computer Science Data Mining (GPA:4.1/4.3) Concordia University, Montreal [09/2006 - 05/2009]
M aster 1, Informatics
INSA de Lyon and University of Aleppo [09/2005 - 07/2006]
B .Eng. Information Systems & Software Engineering University of Aleppo, Aleppo [09/2000 - 05/2005]
Technologies
Business
Analysis -
Architecture
MS Office LucidChart Visio Mind
Miester Sybase Power Designer
Rational Rose DB Designer.
Projects MS Project TFS Jira Toggl Trello G.Docs Data
Data: SQL Server 2012/2014/16 SSAS
MS Access Oracle MySQL SAS.
BigData: Hadoop Spark HDFS Hive Pig
DW - ETL SSIS Azure Data Factory Rapid Miner
BO
Machine
Learning
SQL PL/SQL XML MDX DMX DAX R
SAS Azure Machine Learning. Rapid
Miner Excel Matlab
Analytics
Power BI Qlik Tableau
SSRS BO Cognos Analytics
Pentaho Tibco Spotfire
DevExpress Dashboard
Dundas Perf./Sharepoint.
Dev V isual Studio 2010-2015 Sun NetBeans Eclipse. Web H TML C# ASP.NET IIS JavaScript CSS Apache