Printing tool Download PDF

Ali Salem Al-Shehri

Big Data Engineer

Work History

Oct 2019Present

Big Data Engineer

Sejel Technology LTD.
  • Design and build data processing pipelines.  
  • Design and build ETL pipelines to automate ingestion of structured  data.
  • Design and Build pipelines to facilitate data analysis.
Dec 2016Oct 2019

Database Developer

Sejel Technology LTD.
  • Design, creating and managing structured objects such as: create tables, views, sequences, trigger, packages as well as Stored Procedures for External haj project and Tafweej project.
  • Make sure that all change requests were handled within the planned deadline.
  • Assure that all newly developed changes had been properly tested in the test environment.
  • Enhance performance and efficiency.
Mar 2016Dec 2016

Application Support Specialist Lv - 2

Sejel technology LTD
  • Work closely with business teams to come up with strategic solutions that support long and short terms business objectives.
  • work with the integration team to test the new integration guides with the other participants before moving to production .
  • Collaborate with quality assurance analysts to ensure testing efforts align with system deliveries and business processes.
  • Provide training for new employees in terms of technical & business perspectives.
  • Working with PL/SQL in daily basis while testing the new updates with the other participants and fixing bugs.
  • Generate reports from the database using iReport & jaspersoft on daily basis.
Oct 2015Mar 2016

Application Support specialist Lv - 1

Sejel Technology LTD.
  • Working with database for creating views and updating info.
  • Make sure we address all the requests for Ministry of Haj and Umrah and other third party.
  • Monitor and maintain systems in terms of data, system validations and integration.
  • Work closely with developers and quality assurance analysts to ensure requirements and design are completely in place.
Jun 2014Oct 2015

Technical Call Center Specialist

Sejel Technology LTD.
  • Contacting all Hajj Missions (Ministries) from all over the world regarding any technical difficulty in using E-Haj system.
  • Create a program in JAVA that can handle and classified the tickets response.
Mar 2014Jun 2014

Technical Costumer Support

Al-Jeraisy Electronic Services Company - Tawaf

Certifications

  • Certificate of proficiency in the python programming language
  • Oracle PL/SQL Developer Certified Associated.
  • Oracle Certified Associated, Java SE 8 Programmer.

• Memberships

    • Member of Student Council of the faculty of computers and information Technology. 2012 - 2014
    • Member of the Club of Communication Skills at King Abdul-Aziz University. 2013 - 2014
    • Member of Media Club at king Abdul-Aziz University. 2011 - 2014

Projects

  •  Pilgrims Reception Portal in The Ports of Entry

            In this portal the united agents office employee are checking the pilgrims and their passports and linking it with transportation method, then the system deduct the correct fees from the Haj missions or haj agents from the transportation balances  for each one and an electronic tickets are issued for each pilgrim, after that a full pilgrims list is issued for each bus.  

 - Design and create database tables.

 - Design procedures to make sure that all data is matching with business requirements.

 - Create action based on the values that provided from the agents for Pilgrims transportation lists.

 - Do the financial transactions from The virtual wallets on the Ehaj system using direct integration with banks.

  • The transportation of pilgrims between the cities and the final departure portal
    (Deportation order portal)
       Transportation requests are created for each pilgrim that contains the trip route, then ensuring the capacity of hotels or flights in the final departure, and ensuring that tickets are valid and there are enough balance on the Virtual wallet for each pilgrim.

 - Design and create database tables.

 - Design procedures to make sure that all data is matching with business requirements.

 - Create action based on the values that provided from the agents for Pilgrims transportation lists.

 - Do the financial transactions from The virtual wallets on the Ehaj system using direct integration with banks.

  • Tafweej Cycles

         Is a crowd management solution that controls the pilgrims flow with all the transportation companies on the Haj season, confirmation number is issued for each transportation request, each request is assigned to transport company based on each company quota.

 - Design the transportation schedule cycles.

 - Create a procedure for the crowd flow cycles and allocate transport quota for each transportation companies.

 - Create a procedure to close the cycles based on availability and move the remaining quota to new cycle.

 - Design procedures to make sure that all data is matching with business requirements.

  • Transportation Tickets portal

          A System that allow Hajj agents to purchase transport tickets for pilgrims or each pilgrim can buy his own transport ticket. Tickets are deducted form the virtual wallet.

 - enhance the performance of the financial operations procedure.

 - Create transport tickets for pilgrims.

 - Design procedures to make sure that all data is matching with business requirements.

  • Bank Guarantees

      Create a procedure for issuing bank guarantees for transportation and housing.

  • Housing and Food Contracts

      Create housing and food contracts and invoices for the Haj agents then send it for an approval from the owner of the facility, a deduction of the fees from the Haj agents balance is done, and the amount is transfer to the owner of the facility based on the agreed installments.

- Create a procedure to transfer fees of contracts from the virtual wallet of the Haj agents to facilities owner such as housing and food contracts.

  • Chatbot

       Create a Chat-bot Application using AIML.