Faheem Ashiq

Experience

• 

  Punjab University College of Information Technology,Lahore

  Oct 2016 - Sept 2020

  Student
• 

  Techlogix

  Nov 2020 - now

  Responsibilities:- Worked as OFSAA (AML, TBML and KYC) Consultant for Bank of Punjab and MCB Islamic Bank Pakistan- Created Anti Money Laundering (AML) Scenarios from Scratch using SQL and FCCM configs- Configured and Implemented Oracle's out of box AML scenarios as Bank's requirements- Developed customized AML scenarios to identify money laundering activity as per requirements- Developed and Configured Data Ingestion Scripts (SQL and Bash Scripts) for data ingestion from Core Banking Systems to OFSAA FCCM- Implemented end to end Oracle's pack of TBML (Trade Based Money Laundering) for Bank of Punjab, Pakistan- Created and implemented customized scenarios for monitoring Trade Based Money Laundering- Built Data Pipelines from Core Banking System to FCCM for TBML pack implementation using SQL and SSIS.- Built customized JAVA modules for Techlogix's Trade Based Money Laundering monitoring application for Bank of Punjab, Pakistan- Supported and Resolved Multiple bugs/issues in FCCM for AML, TBML and KYC packs of OFSAA- Involved with Oracle Support and Development Teams to resolve multiple issues in FCCM Show less

  • Senior Software Engineer

    Mar 2023 - now

  • Software Engineer

    Nov 2020 - Mar 2023
• 

  Gulf International Bank

  Dec 2021 - now

  ETL/BI Developer

  Responsibilities:- Working as ETL and Reporting Developer in GIB- Designing and developing ETL flows using SSIS, SQL Server and Oracle SQL databases- Working on huge data transfers and transformations from various banking systems to the Staging Area and data warehouse using SSIS and SQL. - Developed various data pipelines for daily EOD data flows between multiple operational and reporting systems using SQL functions, stored procedures and views. - Works on OBIEE and BI Publisher Reporting for various functions and departments of the bank for daily reporting. - Involved in the support of existing ETLs and Banks' Reports- Part of development and support for different Regulatory Projects being implemented in GIB- Working on daily Ad-hoc data transformation and provision requirements for Business departments- Developing complex SQL queries for multiple OBIEE reports using SQL server and Oracle SQL- Efficiently troubleshooting and correcting the EOD ETL/Data Transformations failures, gaps and anomalies to serve accurate and on-time reporting Show less