Mon expérience

Voir plus

INGJanuary 2014 - Présent

Laying the foundation of the data lake project for ING Netherlands and Belgium. Designing and implementing a storage / analytics platform based on Hortonworks HDP, Using automation for cluster provisioning and the security layers. The main goal is to migrate an existing DWH system into a Hadoop cluster based ETL system.
Automation of delivery with Ansible and Terraform ; plan for scaling, tuning and maintenance of Hadoop clusters. 

2020 update:

Migration of the on-premise HDP stack towards Google Cloud (GCP) and MS Azure platforms.
Took part in the security and cloud risk management committees (internal and vendors), leading teams towards completed "risk appetite'' documents and procedures (BIA, DPIA, DRA, OSB, EBA and DNB regulations, NFRC approvals).
Built CI / CD pipelines (Azure/GCP) for automated provisioning of data science models foundations.

Enhancement of currently running models mainly using Python, Nifi, Spark, Hive, HDFS and Yarn.
Special emphasis on OpenShift deployments (OKD 3): application design, scalability, integration with HDFS and Hive.

Voir plus

OrangeJanuary 2013 - January 2014

Big Data POCs are held for Actiview's clients under my technical leadership;
Analyzing current ETL flows and BI reporting methods, mapping possible areas for big data analysis within existing data marts and EDWs, Hadoop cluster configuration and setup (4 - 15 nodes), initialization and development.
With large telecom customers involved (100 TB - 2 PB), a typical use case is CDR loading into Hadoop for BI analysis and reporting. 

Tools involved:
Back End: Hadoop ecosystem - Cloudera CDH4, HBase, MapReduce, Hive, Pig, Hue, Oozie, Flume and Sqoop.
Front end tools: Tableau, Splunk, BOXI.

Voir plus

Asset ControlJanuary 2011 - January 2013

Asset Control's Product suite are a set of tools for financial data management solutions; as they are database intensive, my role as an architect was to approach the general product's database touch points, define and analyze its design patterns and maintain the database architecture across it, from logical to physical modeling.
The product suite integration with Big Data vendors POCs were under my technical leadership. 

Tools tested: MongoDB, InterSystems Caché, Hadoop (Cloudera CDH4).

Voir plus

ActiviewJanuary 2010 - January 2011

As an architect of Amdocs' first enterprise data warehouse \ BI platform, I'm a part of the decision making steering committee for the logical and physical model , back-end \ front-end business terminology, architecture and strategies.
Defining tool selections, technologies, and guideline system, infrastructure, and DBA teams for compatibility with the data warehouse and business needs is a major aspect of the role.
Voir plus

Israeli Legal Execution OfficeJanuary 2009 - January 2010

Leading large-scale, legal oriented business logic, data migration project from ALPHA/VMS/Oracle RDB legacy systems with DataStage 8 as an ETL tool over SQL Server 2008 and Building work plans, writing low level designs and code review for a team of 3 developers.
Voir plus

Matchpoint ITJanuary 2007 - January 2009

Design, develop and troubleshoot data warehousing processes within the DWH/BI department. Extensive usage of Informatica Powercenter 8.6.0 and PL/SQL on Linux OS and Oracle 10g DB. Reporting, Universe building and guidelining for CRM/ERP end-users with Business Objects 5, and tuning existing SQL reports performance.

Proficiency in writing KShell / CShell scripts for Linux.
Voir plus

Aman ComputersJanuary 2006 - January 2007

Developing and maintaining end-to-end ETL batch processes (Informatica PowerCenter 7.1.3) for Amdocs Israel (Ra'anana Site), from high level and detail design to production.
Projects involved - AT&T Enterprise USA: AT&T, Bellsouth, and Cingular (AT&T Mobility).

All projects involved were migration / data-loading oriented with Informatica (XML files,CSV and database tables) with special emphasis on performance and efficiency. I served as a single ETL person, thus handling all Informatica / Database aspects of the project.
Special Accomplishments: "Employee of the year 2007''

Voir plus

''MTS'' - Mer Telemanagemant SolutionsJanuary 2005 - January 2006

Administrating Oracle 9i - 10g Databases within 24/7 DBA team. Common tasks: SQL tuning, writing PL/SQL procedures, backup and recovery, instance performance tuning, DRP planning, installation and versions/patches control, implement and maintain the database design and maintaining tables, indexes, etc.

Write database procedures, functions and triggers, assist DWH / BI developers with database activities, tune database queries, monitor application related jobs and data replication activities.

Voir plus

Human Resources, Ltd.January 2001 - January 2005

Planning and administrating several MSAccess and Oracle databases, and producing reports for the account management department. Vast usage of BI and reporting tools (Brio Intelligence, Crystal Reports, MSAccess) and writing complex SQL queries.

Mes compétences

Languages

SQL, XML, Oracle PL/SQL

Analysis methods and tools

Physical Modeling, Design Patterns, Logical Data Modeling, DevOps

Environment of Development

Openshift

Middleware

Jenkins

Databases

Intersystems Caché, DB2, Database Administration, Redis, MongoDB, Oracle, PostGreSQL, NoSQL, Oracle 10g, Microsoft SQL Server, Oracle 9i

ERP&CRM

Oracle CRM

Application servers

Elastic Stack, Apache Web Server

Big Data

Hadoop, Spark, Oozie, Big Data

IT Infrastructure

CentOS, Azure DevOps, Virtualization, Git, Linux Red Hat, Docker, Sun Solaris, Google Cloud Platform (GCP), Linux, Unix

Protocols

Kerberos

Technologies

Solr, ElasticSearch, HDFS, MapReduce, Artifactory

Others

Logstash, Kibana, Database Design, Analytics, Troubleshooting, Team management, Continuous Integration, Data Migration, Continuous Delivery

Business Intelligence

ETL, Informatica, Hyperion Intelligence, Oracle Data Integrator, Cognos Impromptu, SQL Server Integration Services, Business Objects

Mes études et formations

Master DBA Oracle - Hi-Tech training Center

Cloudera Developer - Hi-Tech training Center

B. Sc, Computer Science - Clark University2010 - 2012

Software Practical Engineer - Tel-Aviv University2000 - 2002