Muhammad Affaan

Experience

• 

  KSoft Islamabad, Pakistan

  Apr 2000 - Mar 2003

  System Engineer

  - Development of embedded systems using 8051 microcontroller.- Programming using Pinnacle for measuring exact volume of fuel in Underground tank.- Calculating net weight of load on truck using load sensors with microcontroller.

• 

  Federal Urdu University of Arts, Science & Technology, Islamabad.

  Feb 2004 - Aug 2006

  Research Assistant

  Worked on Grid/Distributed system technologies. Developed prototypes using CoGs APIs. Simulated Grid Infrastructure using JAVA based simulator known as GridSim.

• 

  EnterpriseDB

  Sept 2006 - Oct 2007

  Software Engineer

  - Data migration from other RDBMS to EnterpriseDB using Replication Server. It employed publisher-subscriber model having both batch as well as incremental replication.- Worked on SQL Parser component of distributed database query engine.- Development of scripts for the reconciliation of migrated data.

• 

  Stafona

  Jan 2008 - Jan 2008

  Software Engineer

  Involved in design and developement of multi tier social network application.www.7thbillion.com

• 

  Digident Solutions

  Mar 2008 - Jul 2008

  Senior Consultant

  Worked on Oracle UCM APIs.

• 

  Du

  Jul 2008 - Nov 2010

  System Architect

  - Real time querying the HLR for customer care to provide them subscriber service details.- Dashboards development to provide statistics of sites fluctuation. Drilled down starting from RNC to site cell.- Real time streaming of log data from HP servers to help administrator for troubleshooting.- Automatic SMS notification in case of critical issues.- Customer Data Analysis of port utilization.- Data integration by designing consolidated schema based on business use case. Show less

• 

  Xichlo Mobile FZE

  Nov 2010 - Sept 2011

  Software Analyst

  - Data Analysis and generating reports for billing.- Gathering and Analyzing requirements for developing applications that provide support to SMS Gateway Server.- Enhancement of SMS Gateway server.- IBM Server administration.- Linux/Unix Shell scripting for taking data backup automatically (RSYNC, Remote Mounting).- Integration of HLR lookup with SMS Gateway server.- Analysis and development of billing application.- Providing training to junior team members.

• 

  Sybase Middle East

  Nov 2011 - May 2014

  Solutions Architect (Mobility Data Solutions)

  Responsible for analyzing client requirement to integrate our solutions with client SAP implementations.- Continuous having in depth eyes on technologies offered by SAP for Mobility.- Focused on Hybrid Apps Analysis using Cordovo, JQuery and HTML5- Designing Android App Templates for different industries. Designing integration layer to communicate with backend information systems. Purpose of such designs is to cope the future changes with minimal or no effort.- Act as Mobile Middle ware Technology specialist. Show less

• 

  ISYX Technologies

  Jun 2014 - Apr 2018

  Open Source Solution Architect(Big Data Analytics)

  - Active participation in development and implementation of platform architectures as per data analytics requirements.- Creating documentation describing the data specifications, schema and analytical reporting requirements.- Coaching the team members ahead of project execution phase.- Utilizing Big Data technologies for producing technical designs based on customer business requirements.- Evaluating Business use cases for Lambda Architecture (Solution for managing Batch and Stream Data).- Evaluating and documenting use cases and building proof of value.- Provisioning HDInsights on Azure Cloud and creating data pipeline from source to data lake.- Preparing strategy for migration of on premise SQL Server Data warehouse to Azure Cloud with minimum downtime.- Evaluating the data for three Vs (Variety, Velocity and Volume) to help customer deciding the feasibility of big data.- Evaluating Open Source Solutions to use in Solution Architecture for customers.- Leading development teams for end to end implementation.- POCs for IoT using No-SQL DB, Time-Series DB, MQTT Brokers, Springs and Dashboard APIs.- Arduino integration with Open source IoT Platforms.- IoT Data Analytics. POCs for ML Algorithms on public data.- (Linear, Logistic, Batch, MiniBatch and Schostic) Regression. - Support Vector Machine.- K- Means- Evaluation of BigData supported solutions Flumes, Kafka, Spark and Hadoop with respect to data ingestion and processing scenarios.- Producing reference data architectures based on Enterprise Integration patterns, Data warehousing ETL and Big Data ecosystems.- Mapping client's Mobility requirements with SAP Mobility products (SMP 3.0, SAP Mobiliser) Show less

• 

  RAK Ceramics

  May 2018 - Dec 2018

  Enterprise Data Architect

  Contractual Assignment: Leading the Data Management initiatives.- Mentoring internal SAP resources and providing them guidance on ETL strategies.- Data warehousing requirements elicitation.- Data Warehousing Cost/Benefit analysis.- Advising Data Governance program.- Identifying data issues and proposing cost effective solutions.- Evaluating data technologies from different cloud and data integration vendors and leading development of corporate data warehouse.- Designing roadmap for Industry 4.0 followed by digital transformations.- Managing Data Warehousing POCs from different vendors. Show less

• 

  EnterpriseDB

  Jan 2019 - Sept 2023

  Data Solution Architect

  - As part of connector's team, looking for issues internal and external faced by customers around edb-jdbc driver with Hibernate framework and with respect to SSL enabled EPAS(PostgreSQL based database system).- EDB Postgres Replication Server (EPRS) has been re-architected to meet growing data integration challenges and enable fast data movement to meet today’s enterprise high-availability requirements. The major architectural change is the use of Apache Kafka as the data streaming backbone to faciliate data flow across a variety of data sources and targets including traditional databases and non-structured data stores.- R&D on Kafka Connector for Oracle as an initiative bringing multiple source and target data sources in the roadmap of data replication product.- Performance analysis of NEX-Gen replication using PGBENCH on OpenStack to advise recommended deployment architectures for customers.- Design and implementation of additional demanding features based on customer requirements.- Exploring research oriented aspects of Kafka usage in data replication solution.- Involved in setting up BI platform for measuring company's KPIs. Show less

• 

  Self-employed

  Oct 2023 - now

  Data Solution Architect - Contractor

  Project Planning: Developing detailed project plans outlining key milestones and deliverables for transforming the raw data.Stakeholder Communication: Maintaining clear and consistent communication with all stakeholders to ensure alignment with project objectives and expectations.Risk Management: Identifying potential challenges in data transformation and implement proactive strategies to mitigate risks.Data Consultancy Specialist:Offering expert data consultancy services to diverse industries, like healthcare accounting departments. Transforming intricate raw data into a format conducive to effective reporting.Social Media Analytics:Specializing in analyzing social media metrics to extract valuable insights. Utilizing advanced analytics techniques to decipher trends, user behaviors, and engagement patterns.Data Solution Architect:Leading comprehensive data requirement analyses, tailoring optimal data solutions aligned with the client's technological infrastructure and budget constraints. Ensuring a strategic and efficient approach to meeting data needs.Data Engineering:Mastering the art of data engineering to mold raw data into structures that meet the preferences of data scientists and analysts. Crafting data frameworks that enhance accessibility, usability, and overall efficiency in the analytical process. Show less