آفاق علي اختر

Project :- Data management of Open Data, Cloud Data Migration and Metadata for Abudhabi Spatial Data Infrastructure of Government Entities


Client (Abudhabi Digital Authority) is a Government body Engaged in Digital Services and provide shared data services including open data platform, spatial data infrastructure. The client is engaged in sharing and collections of data


• Develop and implement a data governance framework that aligns with the organization's data strategy and meets relevant legal, regulatory, and industry requirements.
• Engaged in strategy to design and build country level Metamodel/ Metadata Management
• Successfully migration of SDI Application with DB (oracle to sqlserver) from on premises to G42 Cloud.
• Designed and Prepared Migration Strategy, Plan and execution of migration.
• Design Data Model for existing and new project and MetaModel for Data Governance.
• Metadata management, Data Governance, Data Management, Data Modelling and data profiling, Data Standardization, Data Analytics.
• Managing, Architecting, Designing services of various sources of data, Data Management, Data Enrichment, Data Cleansing.

• Data Strategy and Management, Data Modelling and data profiling, Data Standardization, Data Analytics, Dashboard and Reporting.
• Managing, Solutioning, configuring services of various sources of Covid data for Covid Analysis and dashboard.
• Data Modelling and Data pipeline, Ingestion processes.

• Data Architecture, Information Architecture, Technical Architecture, Data Modelling, Data Ingestion Architecture, Datalake, Data Mart and OLAP cube implementation for Interoperability and Data Standardization project of Government.
• Data Modeling of Hadoop Hive table and Data modeling of ETL/Data Mart using Erwin.
• Selection and suggestion on Machine Learning Algorithm to best fit the use cases.
• Worked with JSON, XM, TXT, CSV files format.
• Check and validation of design and implementation of project upto global standard.
• MDM implementation using Amazon EMR, Amazon S3, Amazon Redshift.

Project Briefs :- Indiabulls is Major in finance, lending and Investment Banking.
This Project is to design and develop a data mart for group companies’ customers for Marketing Analytics, A I and Predictive -Strategic analytics usage.
Work Description:
•Implementation of customer data mart and use of predictive customer intelligence using IBM PCI (SPSS Modeler).
•ETL and BI and Statistical Analytics development.
•Development of Business Intelligence in Strategically Marketing offerings using IBM SPSS/PCI and IBM Watson and IBM UNICA.
•Design of Data model of different financial product of groups to create a consolidated single data mart.

Project Briefs :- UBS is International Major in Investment Banking, Expert advice, Wealth management, Asset management.
Work Description: Support of Finance PNL BI system, In-house Datawarehouse in Oracle Advanced PLSQL, Sybase and Reports in TM1 & cognos. Risk management systems transactions of equities, Bonds, Derivatives and Various Financial Transaction load into inbuilt Data Warehouse and BI reports in cognos for finance PNL user.
Worked on Bigdata development review process related to Architecture, Design and Development of Big Data data Lake Platform. To Identify design enterprise grade large-scale data processing systems and help identify the best options for architecture. The Big Data design to match complexity of data and can have design systems and models to handle different variety of data with varying levels of volume, velocity and veracity.
Work Involved functional requirement complex query writing, Analysis, Performance tuning, Exchange partitions, compress data, co-ordination with stakeholders and Businesses located globally along with Intergroup Co-ordination. Working Environment is Agile Methodology.

• Develop DI Jobs for data cleansing & data enrichment and target Table Population.
• Analyzing Oracle PLSQL logic and create transformation code required.

• Scripting for complex functional processes using DI custom transformations

• Develop 50+ Data transformation Jobs to build DWH & Data marts

• 6 KPIs based Dashboards Designed (Cash, Sales, Bad Debt, Customer Base, Collection Rate, Missed Customers)

• Dashboard for overall Performance Overview
• Build business logic & functionality of modules and develop using PL- SQL
• Creating Unit Test Plans and preparing/updating Test Cases for every change
• Tuning of queries and the process as it can process large volume within hours
• Client Support, Responsible for the smooth development of the modules and the delivery to QC and client
• Creation of Configuration documents and Configuration Management.
• Delegation and coordination with team and Intergroup Co-ordination.
• Preparation of various metrics for business Understanding and to be used in development of product.