Ali B.-Domain Architect Data/IT & AI

Projects: Assessment, Migration, Modernisation, Strategy, Principles

• Leading the assessment of the current database landscape across different Tata-steel IT/OT factories
• Aligning with the strategy and developing data principles for use across the enterprise by all factories to improve quality
• Simplifying the data landscape by reducing the number of tools used for extraction, transformation and analysis
• Leading the review of current data governance tools and the selection of data governance tools
• Proposing the right solution for the Drones use case to store and integrate data on-premises for OT, as well as AI in the cloud
• Brainstorming with OT departments on how to position historians as fit for purpose within OT and IT
• Examining Oracle UELA with Procurement and guiding executive stakeholders in decision-making
• Leading the sizing and cost assessment with Procurement for Oracle ExaCC for the coming years
• Creating a roadmap for Domain Data & IT for the next two to five years to present company-wide
• Setting up the migration strategy and identifying Oracle candidate databases to migrate to Oracle Exacc
• Guiding Solution Architects towards a solution using the principles created for the TATA DNA Platform
• Providing the strategy for on-premises and cloud backup and archiving using IBM Prospect, Azure and OCI
• Creating a standard reference architecture for data environments and tools for ETL and reporting for advanced analytics

Key Technologies: Oracle, Sequel Server, IBM DB2, Github, SAP, Databricks, Azure, Beaver, Oracle ExaCC, Spotfire, Azure Purview, ETL Tools, PowerBI, Tibco DataVirtualization, TIBCO spotfire, DataBricks, Azure Edge Apache Airflow, Sql server, Azure Data factory, Azure Blob Storage, logic apps, power-apps, Azure File Synch

Projects: Assessment, Advisory

• Assessing the current Kafka cluster
• Gathering requirements for the current Kafka cluster setup
• Guiding the implementation of security for the current Kafka cluster using TLS 1.2

Key Technologies: Kafka cluster, Azure

Projects: Assessment, Sap IOT Global Integration

• Reviewing the current Kafka cluster implementation in the SAP landscape for IoT devices
• Guiding different teams by providing insights into the optimal configuration for high sensor data throughput
• Assessing the current design of Producer-API, Consumer-API, Connect-API and streams-API
• Advising on improvements and selecting open-source monitoring tools for the Infrastructure Team

Key Technologies: Kafka cluster, Grafana, Kibana, Prometheus, Lens, Data lake, Python, kubernetes, SAP, Agile, Helm, Ansible

Projects: Migration Data-Lake, Historical Data

• Leading the Requirements Gathering Team for Historical Data when it comes to Migration of Finance and Supply Chain
• Company matrix wide support of all technology and processes by leading high impact, complex IT projects
• Liaising with Enterprise Architects when presenting the Solutions within Maintenance, Repair and Overhaul
• Designing REST, SOA, Big Data, Meta Data, BI, Data Lake Hybrid Cloud Solutions in respect to the reference A.D.
• Designing global integration solutions within Maintenance & Engineering for Aircraft, Engines and Components
• Produced and Presented an integration solution for Business glossary and advised a data governance vision
• Engaged with the Joint Architecture Committee to present and evaluate for enterprise-wide projects
• Clarifying Data Classification Risks and raising security concerns in cross domain data exchange with CISO
• Agreeing on Service Level and Support level with infrastructure & Operations for the given solution
• Making use of the reference Architecture within KLM and Airfrance for Migration
• Contributing to the PSA in relation to the migration solutioning used for the migration

Key Technologies: Power Point, Excel, Word, EA, REST, SOAP, Talend, Data Lake, SAP Hana, SAP MDG, BPM 2.0, Archimate, Kafka cluster, Data lake, Prometheus, Lens, Python, Kibana, Apache Airflow, kubernetes, SAP FICO, Agile, IAM, Databricks

Projects: KYC Data Warehouse

• Proposing the solution of the Integration model for B2B, designing and leading global technical teams to implement it
• Together with the Business Architect and Solutions Architect created the first draft of the Strategic KYC Solutions ERD Conceptual DATA Model
• Used different communication channels to engage with executive Stakeholders to explain and review the Data Models
• Proposed the first level of data standards draft extracting it from KYC standards
• Involved in requirements gathering from the KYC standards and articulated it in entities to be validated by the business
• Led workshops to clarify and agree on understanding of providing the right KYC DATA and responsibilities
• Reporting to and handling C level executive stakeholders by giving a helping hand in making decisions for DM
• Engaged with the Data Governance council team to extend and agree on the proposed Data Standards to use as reference architecture

Key Technologies: Excel, PowerPoint, Visio, Word, IBM Mega, Hadoop, Conceptual Datamodel, BPM, Agile, Archimate

Projects: Migration, Change Management

• Managed the scope and alignment of the Data Migration Strategy with all parties involved
• Evaluated several POCs using trending technologies such as AWS, Hadoop, Spark and Cassandra for the usability portfolio
• Contributed to the PSA by creating the migration solution within the technology stack
• Created an Architecture for Migration in close communication with the Enterprise Architect
• Built infrastructure for DATA extraction from different legacy SAP environments
• Contributed to planning the cutover sequence for the migration objects
• Gathered Business DATA requirements and translated them into action points for the IT department
• Developed and implemented a process to integrate data from different sources
• Coordinated the mapping of legacy data to the SAP structure using the FIT GAP method
• Documented data migration templates covering definitions, formats and manipulation, thereby creating Data Standards
• Led a team of professionals to prepare the first draft of the Data Governance Frame Work
• Tracked DATA-related issues against open business decisions and provided stakeholders with greater transparency
• Prioritized and escalated deadline-sensitive issues, ensuring smooth and timely delivery
• Requested and provided resources to support the deliverables of IT projects
• Set up configuration in the Central Management Console and measured performance in the MC
• Established workarounds and new agreements with third-party service suppliers to support the migration
• Used Information steward to measure quality by applying quality rules in Data Insight
• Held weekly calls with Architects who reported their activities and issues to me
• Motivated and supported my team to help them address their impediments
• Set up bi-weekly meetings to share knowledge within the Team and invited industry-leading speakers to share their success stories
• Planned evening outings and dinners to improve team building, trust and unity, while having fun

Key Technologies: Excel, PowerPoint, Visio, Oracle, Business Objects & Data Services, Hadoop, SAP, LSMW, ETL, Agile, Power BI

Projects: Migration, Reporting, Quality, Data Warehousing

• Gathered requirements from the business, analysed processes and reviewed current WEBI reports
• Used WEBI 4.0 rich client and Dash-Board Designer to create monthly, quarterly and annual figures for the BSC(Balanced Score Card) indicator slots to measure the implementation of the Strategic Plan
• Provided transparency by scheduling WEBI reports in Infoview for monthly refreshes
• Improved performance indicators in collaboration with Quality Officers, thereby improving historical figures
• Migrated WEBI reports from version 3.2 to 4.0, added filters and formulas, and performed quality control through data validation (correctness, completeness, data integrity)
• Created the technical design and delegated tasks to the IT Team to create aggregated tables
• Worked on ad hoc requests to create WEBI reports for the presidency, OD Directors and other internal and external stakeholders, providing more insight into business performance
• Performed detailed analysis of data streams across different Business processes and presented the results in a WEBI
• 4.0 report, thereby creating values for performance indicators that had not been reported before
• Independently and creatively solved technical problems that could prevent delivery of the WEBI report and cause missed deadlines
• Reviewed the Data Governance and Data Management Process together with a team of Five professionals
• Introduced and proposed changes to the Data Standard policies for integration into the Data Governance standards
• Used BOIS to apply quality rules and provide insight into different SAP systems
• Used the data tracking option in WEBI 4.0 SP5 to capture, analyse and track inconsistencies in collaboration with the back-end IT team
• Liaised with stakeholders to discuss performance indicators and provide insight, supporting better-informed decisions
• Used the OHIM reference architecture for trades registration

Key Technologies: Excel, PowerPoint, Visio, Oracle, Business Objects Information Stewart, HANA

(Marketing)

Projects: DataWareHouse, Migration, Quality, Reporting

• Analysed the client's customer care process and created a Business Process Model and entity models for customer orders
• Recommended adjustments to the customer care process and proposed the customer conceptual model
• Proposed Data definitions policies and clarified the Entity Description to an acceptable level
• Managed a team of Analysts and DBA, bringing them together in workshops to improve performance
• Created local, central and profiler repositories in SAP BusinessObjects Data Services Repository Manager
• Created new Job Servers and associated repositories in BusinessObjects Data Services Server Manager
• Imported data from VARA CRM into a suitable readable format for reporting and analysis
• Extracted customer information from an Oracle database with SAP BODS 3.1 and sent it to flat files
• Analysed data using Profiling, including Column and Relationship, on tables
• Configured the Data Stores, Local Repository and its Connections in BODS 3.1
• Used Dashboards in Data Services Management Console to measure Job execution and duration
• Performed Job Validation, Syntax checks and Dry Run to assess errors, execution time and bottlenecks. Used the Debugging function, adding Breakpoints, Try and Catch block
• Loaded CRM and Retail data to estimate job run time and Performance Statistics; optimized and fine-tuned the job; used Push Down where needed
• Participated in System Performance tuning, focusing on database, data model and data loading performance
• Programmed a workflow with Syncfusion Libraries as a WPF component for the ETL tool for campaign Management
• Generated and hosted WCF services for reading and writing files using the NET-TCP/IP protocol(1.2 SOAP)
• Used Java SDK to retrieve all Users and Groups with a specific GroupID
• Extracted data from VARA ORACLE Retail DB to provide insight into purchasing
• Used a prompt to mount the ORACLE DUMP and ran PLSQL statements on it
• Programmed an unzip tar tool to unzip files and migrate them to the server
• Wrote and read XML configuration files for connection details and user credentials
• Maintained documentation, building case-sensitive context functionality and libraries MADCAP

Key Technologies: Excel, PowerPoint, Visio, Oracle, Business Objects Data Integrator

Projects: Data Warehouse, Data Modeling, Architecture, Reporting

• Created functional and technical models and entity-relationship diagrams for the churn process
• Tuned the generated N-tier .NET ENTERPRISE SOLUTIONS
• Integrated churn reports with the web application and created a central view for dashboards
• Created and customized stored procedures to extract data from the data warehouse
• Built weekly, monthly, and quarterly reports, as well as yearly churn graphs, for management in the web application
• Used Crystal Reports to create complex reports for management
• Created technical documentation, including use cases, technical diagrams, and data and process flow diagrams

Key Technologies: Excel, PowerPoint, Visio, SQL Server

Projects: Migration, Documentation

• Built an ETL application to extract logs from different folders and migrate them to a single database
• After extracting files from different folders, assigned priority statuses to the logs in the database
• Created use cases and technical diagrams for a structured and clear approach to the solution
• Updated the tables in SQL Server 2000
• Created Excel reports to provide insight by tracking development progress

Key Technologies: Excel, PowerPoint, Visio, .NET, SQL SERVER