Led the design and development of Informatica BDM, seamlessly integrating data from a spectrum ofsources including databases, APIs, and diverse file formats.• Orchestrated the seamless migration of a Parallel Data Warehouse (PDW) system using SSIS, effectivelytransitioning and optimizing data workflows to Hive.•Migrated the ETL flows from an out of support SSIS server to Informatica BDM.

Sccessfully designed and executed the data migration strategy for Pakistan's second largest bank'score banking system, while also spearheading the development and implementation of the entirepipeline using Informatica BDM

• Led the Asset Liability Management ETL development using Informatica for the Second Largest Bank in Pakistan.• Developed Data Models and Pipelines to migrate the customer profitability report to Teradata’s Financial Services Data Model using Informatica while using Hadoop Data Lake for the Second Largest Bank in Pakistan.• Implemented the Customer Segmentation use case for a Bank.

Working on IBM infosphere tool suite:- IBM data architect for designing database and warehouse models.- IBM DB2 database for query writing.- IBM framwork manager for linking DB2 database to cognos for reporting purpose.- Infosphere datastage for ETL Development - Infosphere qualityStage for data quality maintenance.- Cognos for Business Intelligence reporting.- Infosphere metadata asset manager for metadata and repository management.-Infosphere information governance catalog for management and monitoring of the activities. - BRD, SMX and RMX for mapping fields while bringing new source system to the model or maintaining record for existing table fields.

Responsibilities include:-Automated control testing of applications at Securities and Exchange Commission of Pakistan.-General IT controls testing of areas including access security, program change, data center & network operations and IT governance.-Financial support audit includes JE Testing and data analytics particularly using ACL (Audit Command Language), Microsoft Excel. SQL and Python-Auditing as per the standard work programs & ISAE 3402 of applications, operating systems and database such as Oracle EBS, SAP and CC&B's application, database i.e. AS400, DB2, Oracle, MySQL and operating system i.e. AIX, Linux, Windows and UNIX of entities such as Securities and Exchange Commission Pakistan, UBL-FM, Pakistan Stock Exchange, State Bank of Pakistan.-Data Leakage Prevention for State Bank of Pakistan.-Information security management system ISO 27001 internal audit of Yousuf Adil Chartered Accountants;-Gap Assessment and Development of IT Policies and Procedure against CoBIT, ITIL and ISO 27001 for entities such as UBL Bank;-Tool based vulnerability assessments, penetration testing and configuration reviews of financial institutions and holding companies using Nessus, Acunetics, Nipper and Burb Suit.