Ashfaq Ahmad

Product: Afiniti SATMAP - AI-based software pairing call center agents and customers. Created ETL Pipelines in Azure Data Factory Which Ingest data into Azure Data Lake from Azure Blob Storage and HTTP source, transform and cleanup the data by using Azure Dataflows, performs complex Aggregation as per the Business Logic of SATMAP using PySpark in Azure Databricks Cluster and further Loads the production ready data in Azure SQL Database and Azure Data Lake for BI and Data Science teams respectively.

Products: 1) Compliance Link Application - Automating assessment of money laundering risks by screening 500K+ accounts and 1M+ transactions daily. 2) Financial Crime & Compliance Management (FCCM) - Customized Oracle product to meet financial crime challenges. Built SQL scripts which extract data from the Central Data Repository of the bank and perform sanction operations to analyze fraud and anomalies in digital transactions. Created customized reporting for the sanctioned and unsanctioned Transactions.

Project: E-KYC - “Know Your Customer” process by which banks obtain info about the identity/address of customers to prevent criminal and money laundering activities. I built the KYC within the scope of Oracle Flexcube using SQL and JavaScript. Now this system is used by 1.200+ branches. Prepared ETL process to capture the data of a newly created account from the central data repository of the bank. Calculated financial risk of the customer on a scale of Low/Medium/High.

Product: Insurbi - German Business intelligence and Data Analytical Tool, currently used by European FinTechs for data visualization (Bar Graph, Pie charts and Detailed Tables). Wrote SQL queries to fetch customer data and deliver graphical results

Project: TheWorkGenies Built this web-based job portal in Python and PostgreSQL database from scratch to connect job seekers and employers to finalize their employment. Created separate dashboards for job seekers and employers where job seekers can put up their profile and employers can search the best fit candidate for their company.