Senior Data Engineer at Pooya Co.

Spearheaded the design and launch of a comprehensive data architecture for Banking Fraud Detection and Financial Internal Audit systems, markedly elevating operational efficiency and strategic decision-making. Engineered a cutting-edge solution by blending batch and real-time processing, enabling real-time detection of fraudulent transactions and reducing risk by about 20%. Designed and implemented high-throughput ETL/ELT pipelines processing 31M+ daily records with high accuracy, integrating client and vendor data and ensuring data integrity. Documented workflows, performed data cleansing and wrangling to resolve quality issues, and delivered timely insights within the bank’s data warehouse environment. Collaborated with QA during SIT/UAT to validate pipelines and resolve test data issues. Optimized performance and scalability with Apache Spark to ensure high reliability and an availability rate targeting 97%.

DWH Engineer at Pooya Co.

Built data warehouses from scratch, guiding projects from concept to production. Leveraged in-depth banking system knowledge to collect, maintain, and aggregate data for analysis and visualization. Developed a customized data warehouse meeting the analytical needs of a major bank, with robust security, backup, and recovery strategies and strong support for ad-hoc queries.

Data Modeler at Pooya Co.

Entrusted with designing and implementing the OLTP data architecture for the Core Banking Application system, ensuring alignment with business requirements and objectives. Developed scalable enterprise data models, collaborated with business analysts, migrated data from legacy systems, and implemented backup, recovery, and archiving strategies to safeguard assets.

Software Developer at Pooya Co.

Designed and developed two major parts of the Core Banking System, delivering innovative solutions for complex banking processes. Achieved 97.5% system availability through clustering techniques and implemented performance optimizations and concurrency solutions. Led the design and development of the Letter of Credit subsystem and the SWIFT message generator subsystem.

Senior Data Engineer at Pooya Co.

Spearheaded the designing and launching of a comprehensive data architecture for advanced Banking Fraud Detection and Financial Internal Audit systems. Engineered a cutting-edge software solution blending batch and real-time processing, enabling real-time detection of fraudulent transactions and significantly mitigating risk by 20%. Designed and implemented high-throughput ETL/ELT pipelines processing 31M+ daily records with high accuracy. Collaborated with QA teams during SIT/UAT to validate data pipelines and resolve test data issues. Optimized system performance and scalability using Apache Spark to achieve reliable processing speeds and an availability target of 97%.

Data Warehouse Engineer at Pooya Co.

Built data warehouses from scratch, guiding projects from concept to production. Collected, maintained, and aggregated data across banking domains to support analysis and visualization. Documented data entity relationships using a hybrid Star/Snowflake OLAP approach and created optimized schemas for reporting. Optimized ETL/ELT processes to load a 120TB warehouse, implementing robust security, access controls, backup, recovery, and archiving strategies to ensure data integrity.

Data Modeler at Pooya Co.

Entrusted with designing and implementing the OLTP data architecture for the Core Banking Application, aligning the data models with business requirements. Developed scalable enterprise data models and optimized both logical and physical designs to improve performance. Migrated data from legacy systems during deployments and established backup, recovery, and archival strategies.