Experience

• 

  Middle East Bank (MEBank)

  • Tehran, Iran

  • Data Warehouse and ETL Developer

    • Jan 2020 - Present
    • Tehran, Iran

    • Performed SQL statements optimization.• Designed and execute complex transactional business data models.• Created complex queries for support of data extraction and use.• Provided views and other structures to improve user query performance.• Designed the business data model of Pay Cheque and Instant Payment systems following the need of the Central Bank of Iran.• Created database objects like procedures, functions, and packages in accordance with Pay Cheque and Instant Payment systems.• Automated ETL processes across billions of rows of data using ODI, PL/SQL procedures, and Python

• 

  Tejarat Bank بانک تجارت

  • Tehran, Iran

  • Analyst, Designer, Oracle Developer and Oracle Apex Developer

    • Jan 2003 - Present
    • Tehran, Iran

    • Analyzed and designed Insurance and customer accounts systems. • Created Process Model, Function Hierarchy Diagram of the system. • Generated application and database using Oracle Designer. • Created database objects using Oracle Designer, based on Oracle CDM. • Developed some parts of the systems using Oracle Apex.

• 

  Novin Kish Informatics Services Corporation

  • Tehran, Iran

  • Data Analyst and Data Engineer

    • Aug 2017 - Jan 2020
    • Tehran, Iran

    .

• 

  Rayan Eghtesad Novin

  • Tehran, Iran

  • Data Warehouse and ETL Developer

    • Sep 2014 - Aug 2017
    • Tehran, Iran

    .

• 

  HEPCO (Heavy Equipment Production Co)

  • Tehran, Iran

  • Senior Oracle PL/SQL Developer and Oracle Apex Developer

    • Nov 2008 - Sep 2014
    • Tehran, Iran

    • Analyzed the systems' business requirements, business processes, and ERD using Oracle CDM and Oracle Designer.• Designed database and application of the systems.• Created database objects like procedures, functions, packages, and Materialized Views by Sales & Marketing systems.• Developed some parts of the systems using Oracle Apex.

• 

  Police Organization

  • Tehran, Iran

  • System Analyst, Designer and Developer

    • Apr 2002 - Dec 2003
    • Tehran, Iran

    • Analyzed and defined the requirement of the system using Oracle Designer. • Created a Process Model (PM) for the system. • Designed database and application of the system. • Developed system software application using Oracle Designer and Headstart Oracle Designer (Oracle Forms and Oracle Reports).

• 

  Islamic Azad University

  • Tehran, Iran

  • Senior Oracle PL/SQL Developer & Developer suite

    • Jan 1997 - Jan 2002
    • Tehran, Iran

    • Designed database and application of the system. • Developed system software application using Oracle Forms and Oracle Reports.