DAVID DAYAN

Managed SAS/FM migration from SAS 9.4 to SAS/Viya for Gottfried Schultz, ensuring data integrity and system compatibility across platforms.

Collaborated with financial analysts to develop customised Data Marts for complex financial data requirements, improving reporting accuracy and accessibility.

Developed and automated loading processes of accounting, financial and risk data for SAS/SLAM and SAS/IRM modules, streamlining risk reporting workflows.

Developed and supported the EPO proprietary SAS Data Warehouse, finance Data Marts and ad-hoc reports on Linux and mainframe platforms.

Developed and automated data load processes for the accounting Budget/Planning system, advancing phase 2 delivery and operational automation.

Led ETL efforts and coordinated SAS/DI developers to populate an ODS on Oracle Exadata and integrate with Salesforce in an Agile project.

Implemented a new SAS Data Warehouse consolidating global corporate data and built OLAP cubes for ad-hoc reporting to headquarters.

Implemented ETL jobs and SAS portal front-end to automate accounting logic and load financial data for Budget/Planning processes.

Implemented loading processes and SAS/FM reports for financial reporting, preparing FINREP per EBA specifications to support regulatory submissions.

Developed monitoring applications and managed SAS configuration, tuning and support across HP-UX and Windows Server for performance and user management.

Optimized performance of SAS/AF CRM marketing applications and led migration from z/OS to Windows Server to improve maintainability.

Implemented risk aggregation and Risk Capital calculations for Solvency II, and migrated FM architecture to improve risk reporting accuracy.

Migrated thousands of batch programs and JCL from SAS v8.2 on z/OS to SAS v9.2 on UNIX, modernizing batch processing infrastructure.

Automated import of risk data from complex Excel files and performed risk aggregation for Solvency II to support Group-level capital calculations.

Developed batch programs and SAS/DI jobs to support financial data processing and reporting for banking operations.

Built batch processes to generate OLAP cubes for ad-hoc reporting and automated data pipelines for reporting teams.

Implemented SAS/FMS tools for quarter and annual closings, forecasting and disaggregation based on FM rules to support corporate reporting.

Developed SAS data warehouse, web applications and dynamic OLAP-based reports to support regional reporting needs.

Maintained a web reporting application and supported reporting operations for enterprise users.

Implemented cost allocation applications and client/server tools to manage finance data across networks for the finance department.

Implemented new functionalities for SAS modules (Research Analyst, Access to SAP) and led strategic projects including budget and cost allocation modules.

Developed SAS/DWH, OLAP, AF applications and trained customers; delivered BI and reporting solutions for pharma and other industries.

Developed batch and transactional mainframe programs in COBOL/CICS and maintained DB2/DL/I systems supporting commerce operations.

Developed office automation and general ledger applications for the chemical industry on MS-DOS and HP 3000 platforms.

Diploma in Accounting and Computer Science from ITC Cattaneo in Milan, focusing on accounting and IT fundamentals.