Scroll To View More
Hanee' Medhat, SQL Developer in New Cairo, Egypt
Hanee' Medhat

SQL Developer in New Cairo, Egypt

Member since May 13, 2016
Hanee' is a data expert who enjoys working on data analytics and segmentations in order to better target customers with campaigns. He is also an experienced Java developer who has built enterprise applications that interact with millions of customers daily. Hanee' also has some experience working with big data, Spark, and Python.
Hanee' is now available for hire

Portfolio

  • OBS-EG
    Hadoop, Spark, Elasticsearch, Cassandra, MongoDB
  • Etisalat
    Teradata, SQL, Java, Spring, IBM Streams, Campaign Management Tools
  • ADIB
    Business Objects, Crystal Reports, SQL, Sybase, MS SQL Server

Experience

  • SQL, 5 years
  • Python, 3 years
  • Big Data, 2 years
  • Apache Spark, 2 years
  • MongoDB, 1 year
  • Apache Kafka, 1 year
  • PostgreSQL, 1 year
  • Machine Learning, 1 year
New Cairo, Egypt

Availability

Part-time

Preferred Environment

OS X, Linux, Git

The most amazing...

...project that I've implemented is a platform that optimized campaigns scripts by analyzing user responses to identify the best way to interact with the users.

Employment

  • Big Data Engineer

    2017 - 2018
    OBS-EG
    • Handled and optimized the performance of the big data platforms.
    • Managed the Hadoop cluster with all included services.
    • Applied and deployed new changes and also fixed current incidents on big data platforms.
    Technologies: Hadoop, Spark, Elasticsearch, Cassandra, MongoDB
  • DWH and Campaigns Senior Analyst

    2014 - 2017
    Etisalat
    • Analyzed and segmented customer profiles.
    • Added new customer attributes on campaign management application.
    • Developed new platforms and applications that interact with the customers with different channels.
    • Built new ad hoc integrations between campaign management tools and new channels.
    • Created jobs for real-time campaigns to target users based on specific events.
    Technologies: Teradata, SQL, Java, Spring, IBM Streams, Campaign Management Tools
  • MIS Specialist

    2013 - 2014
    ADIB
    • Designed and implemented new database models for reporting purposes.
    • Developed extraction jobs and stored procedures.
    • Implemented Business Objects universes and developed Business Objects reports.
    • Developed custom Crystal Reports.
    • Performed data transformation.
    Technologies: Business Objects, Crystal Reports, SQL, Sybase, MS SQL Server
  • DWH Support Analyst

    2012 - 2013
    Etisalat
    • Deployed and fixed issues for production ETL jobs, data mining, and analytics models.
    • Developed new shell scripts for automatic monitoring and alarms for production issues.
    Technologies: Teradata, Oracle, SQL, Datastage, Teradata Warehouse Miner, Unix Shell Scripting
  • Software Developer

    2011 - 2012
    ITS
    • Developed new modules in core banking applications.
    • Performed a full migration of the trade finance applications from Sybase to a SQL server.
    • Implemented a full-service interface for a trade finance application.
    • Developed custom reports using Crystal Reports.
    Technologies: MS SQL Server, Oracle, Sybase, Java

Experience

  • Certified CCA Spark and Hadoop Developer (CCA175) (Other amazing things)
    http://certification.cloudera.com/verify/

    I gained a certification from Cloudera.
    License No: 100-019-596.

  • Big Data Development | Mastery Award for Professionals 2016 (Other amazing things)
  • Big Data Specialist with IBM BigInsights V2.1 Certificate (Other amazing things)

    I gained the certificate IBM Big Data Specialist in March 2016 with license # 0717-1458-8215-5644.

  • Introduction to Big Data Certificate (Other amazing things)
    https://www.coursera.org/account/accomplishments/certificate/CPH7HZ6TDEZN

    I completed this Coursera course from the University of California, San Diego.

  • Hadoop Platform and Application Framework Certificate (Other amazing things)
    https://www.coursera.org/account/accomplishments/certificate/Y6QNGTJMQFVV

    I completed this Coursera course from the University of California, San Diego.

  • Apache Spark Streaming Tutorial: Identifying Trending Twitter Hashtags (Publication)
    Social networks are among the biggest sources of data today, and this means they are an extremely valuable asset for marketers, big data specialists, and even individual users like journalists and other professionals. Harnessing the potential of real-time Twitter data is also useful in many time-sensitive business processes. In this article, Toptal Freelance Software Engineer Hanee' Medhat explains how you can build a simple Python application to leverage the power of Apache Spark, and then use it to read and process tweets to identify trending hashtags.

Skills

  • Languages

    SQL, Python, Java
  • Frameworks

    Apache Spark, Machine Learning, Spring
  • Tools

    Cloudera, Kibana, Apache Sqoop, Apache Impala, Apache Avro, Grafana, Crystal Reports, IBM Infosphere (Datastage), Tableau
  • Platforms

    Unix, Apache Kafka, Hortonworks Data Platform (HDP), Oracle
  • Storage

    Teradata, PostgreSQL, Apache Hive, MySQL, Sybase, Elasticsearch, HBase, MongoDB, Microsoft SQL Server, Datastage, Cassandra
  • Other

    Aprimo, Data Warehouse, Big Data, Business Intelligence (BI), Parquet, SAP BusinessObjects (BO), Apache Flume, Prometheus, Qliksense
  • Libraries/APIs

    Pandas, NumPy, Charts.js, D3.js

Education

  • Diploma degree in Business Intelligence and Software Development
    2010 - 2011
    Information Technology Institute - Cairo, Egypt
  • Bachelor of Engineering degree in Computer Engineering
    2005 - 2010
    Benha University - Banha, Egypt
Certifications
  • CCA Spark and Hadoop Developer CCA175
    DECEMBER 2017 - DECEMBER 2019
    Cloudera
I really like this profile
Share it with others