Ashfaq Ahmad
Bis 2018, Software Engineer, Dominion Global Incorporation
Lahore, Pakistan
Suchst Du einen anderen Ashfaq Ahmad?
Über mich
I’m a Data Engineer with over 5 years of professional experience in creating data pipelines using technologies like MySQL, PostgreSQL, AWS, Azure & Big Data. Currently I’m part of an agile development team where I’m in charge of building highly scalable and reliable data pipelines using Python, Talend Data Integration Tool, Data Warehousing, PostgreSQL and MySQL. I love working with leading technologies in data engineering like ETL Pipelines | Python | SQL | Spark | Data Warehousing | Data Analytics | Data Migrations | AWS Glue | AWS S3 | AWS RDS | AWS Lambda | AWS DMS | Azure Data Factory | Azure Storage | Azure Databricks | Talend Open Studio | Power BI | Oracle OBIEE | Oracle Flexcube | Oracle FCCM | Microsoft Excel | Github. I’ve worked across various industries for European companies such as O2, T-Mobile, TIM and ENEL, all in highly scalable environments, and I enjoy delivering high quality work.
Werdegang
Berufserfahrung von Ashfaq Ahmad
Bis heute 3 Jahre und 3 Monate, seit Apr. 2021
Data Engineer
Afiniti
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.
1 Jahr und 1 Monat, Apr. 2020 - Apr. 2021
Data Engineer
Allied Bank Limited
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.
1 Jahr und 5 Monate, Dez. 2018 - Apr. 2020
Data Engineer
MCB Bank Ltd
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
1 Jahr und 1 Monat, Jan. 2017 - Jan. 2018
Software Engineer
Dominion Global Incorporation
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.
Sprachen
Englisch
Fließend