Adel Khorramian

• Optimized OLAP data model for 12 banking modules, improving data accessibility. • Reduced manual data validation by 80% with an ETL log platform, boosting efficiency. • Built Oracle RDBMS ETL pipelines and improved processing 5x with Scala-based Spark. • Launched analytics projects for customer segmentation and recommendations. • Created interactive dashboards in Power BI and OBIEE for stakeholder insights. • Identified actionable insights from data trends, improving business metrics.

- Employed Oracle objects and advanced SQL queries to extract, cleanse, and transform data, resulting in improved performance and operational efficiency. - Developed an optimized OLAP data model for nearly 12 banking modules, alongside an ETL log platform. - Constructed Scala-based Spark ETL pipelines on Big Data platform. - Analyzed data to identify trends, patterns, and actionable insights, providing valuable recommendations to increase business performance.

- Contributed to the development of Case360, a Java-based engine, by implementing robust backends based on servlets and intuitive user interfaces leveraging JSP. - Implemented web services (SOAP-Rest) to enhance the capabilities of the java-based engine, ensuring interoperability with external systems. - Developed unit test and API test modules employing industry-standard practices to ensure the reliability and quality of software deliverables, resulting in robust and error-free applications.