Mainframe Analytics & Modernization

Project: RealKredit Denmark Datawarehouse- Developed data warehouse architecture to integrate RD data into Danske post-acquisition.- Implemented data warehouse using mainframe technologies & SAS.- Automated data loading process for data warehouse.- Created data marts for specific business units.- Developed data mining models to identify patterns & trends.- Created reports & dashboards to visualize data.- Developed and implemented data management processes to improve data quality.Project: Server Parameter Matrix- Designed and developed, and deployed an in-house ETL tool using F#, PowerShell, SAS & T-SQL.- Designed and developed a reusable Altyrex-to-SAS pipeline migration template.Project: Quantexa Financial Intelligence Unit- Created IIAC for Quantexa AML, improving data quality and reducing risk.- Created CI/CD pipelines for Quantexa AML, automating the deployment of changes.- Implemented data pipelines for Quantexa AML, integrating data from multiple sources.- Developed modules for Quantexa AML for entity resolution, network generation, and visualization.Project: Watson Financial Intelligence Unit- Created IT infrastructure and dataflows for Watson Fraud Analytics POC.- Developed dashboards and rules for Watson Fraud Analytics POC.Project: ORIS/Non-Financial Risk Management- Identified and deleted PII data per GDPR requirements.- Developed and implemented PII masking process for GDPR compliance.Project: Key Risk Figures- Calculated and reported key risk figures for credit, market, liquidity, operational, and regulatory risk.- Developed and implemented risk management processes and procedures.Project: Audit Legal & Compliance- Migrated Verification System workflow from mainframe to ServiceNow, saving 300 DKK/Year.- Created a reusable mainframe-to-ServiceNow migration framework, and process template

Project : Danske Bank – SAC∠ Designed and implemented an XML & JSON pre-processing subsystem to integrate web-scraped datainto the mainframe data warehouse.∠ Implemented dictionary-based checks for data validation in the mainframe data warehouse.∠ Replaced COBOL-based data wrangling with DFSORT & ICETOOL, improving efficiency by 35%.∠ Conducted statistical analysis to identify significant relationships between variables.∠ Shrink the size of the data warehouse by 30% by deduplicating data and compressing files.∠ Decrease the number of data errors by 75% by implementing a data quality assurance program.∠ Mitigate the risk of data loss by implementing disaster recovery procedures.∠ Ease the burden on the data team by automating data tasks.∠ Cut down on the number of data silos by implementing a data integration platform.

Project: Allianz Belgium - VIEG∠ Optimized the functioning of the VIEG subsystem by tracking defects and resolving issues promptly.∠ Successfully completed the rewrite of Easytrieve & FOCUS components to SAS & COBOL, in preparationfor the decommissioning of these languages in Allianz systems.

Project: New York Life – FUELS∠ Successfully migrated scheduler from Broadcom ESP to TWS OPC.∠ Rewrote the linked-list based Agent Payroll to IMS, improving system efficiency and integration withother subsystems.∠ Guided Team in implementing data governance framework Ensured compliance with regulations

Project: TEI UHGUS∠ Implemented a Caesar cipher data masking protocol for UAT, improving reliability & HIPAA compliance.∠ Implemented Q-Replication setup for maintaining reliable copies of data for UAT environment.∠ Automated manual data transfer setups for analysts using PowerShell.∠ Enabled Adoption of data quality standards and best practices Reduced data errors by 40%

Project : AT&T - CABS∠ Migrated CICS+QMF report generation system to ColdFusion+Teradata, enabling system integration withCustomer Access Billing System.∠ Created a mainframe-based SAS ETL system to feed into Teradata DWH, replacing existing DB2 storedprocedures and speeding up processing by 40%.∠ Reduced incident count for Customer Access Billing System by 83%.∠ Unified Data repositories and systems Consolidated data for improved accessibility

Project : International Masters Publishers (AB) Mainframe Migration∠ Successfully migrated a legacy application from IBM mainframe z/OS to Microfocus Unix server OS byredesigning COBOL, PL1, SAS, Easytrieve programs, and JCL procedures.∠ Reduced report generation time by 60% by translating 30+ module Easytrieve reporting subsystem toSAS & COBOL and optimizing the data flow.∠ Converted 50+ REXX scripts to OOREXX to execute seamlessly within the new Microfocus setup.

Project: American Express Tailor-made∠ Designed and implemented data pipelines using SAS and COBOL to extract, transform and load data from various sources into the data warehouse.∠ Performed data quality checks and validation using SAS procedures and macros to ensure accuracy and completeness of the data.∠ Optimized data processing performance and efficiency using DFSORT and COBOL utilities to sort, merge, copy and manipulate large datasets.∠ Developed and maintained data models and metadata using SAS Data Integration Studio and SAS Enterprise Guide to support business intelligence and analytics.∠ Collaborated with data analysts and business users to understand their data needs and provide solutions using SAS tools and techniques.