Muhammad S.

About Me

Muhammad has several years of in-depth experience in information management practice (data warehouse, BI, ETL, and data engineering) for enterprise-level clients in the US and Europe. In past projects, he’s served in pivotal roles on end-to-end implementations—starting from requirements gathering till going live. He's also led managed services for clients in regulatory compliance, pharmaceutical, telecommunications, and insurance industries.

Database

Databases T-SQL (Transact-SQL) Database Management SQL Microsoft SQL Server SQL Server BI

Other

Data Analysis Data Analytics Data Warehousing Data Engineering Microsoft Business Intelligence (MBI) Data pipelines ETL Business Intelligence (BI) Talend

Work history

360factors, Inc.
Principal BI/DWH Engineer
2018 - Present (7 years)
Remote
  • Modeled and implemented the data warehouse architecture, analytics data stores and reporting for a SaaS-based platform.

  • Developed target data models including data policies for sensitive data assets, security policies, back-up, and recovery specifications.

  • Applied techniques to optimize performances with large data sets at both the ETL and reporting levels.

  • Deployed and executed on the Linux platform.

  • Migrated the data from a client's existing running application to a newly deployed system for making their data operational and meaningful as per the new system.

LinuxTalendMySQLT-SQL (Transact-SQL) Microsoft SQL Server Data AnalysisData Analytics SQLSQL Server Integration Services (SSIS) ETLETL Development Data ArchitectureData pipelinesData ModelingData Warehouse DesignData Warehousing Database Modeling Star Schema Database ManagementDAX Database DesignDatabase Administration (DBA) Relational Databases MySQL Server Microsoft Business Intelligence (MBI) SQL Server BI PostgreSQLDatabasesETL Tools MySQLdb Microsoft Power BI
Afiniti
Senior ETL/DWH/BI Engineer
2016 - 2017 (1 year)
Remote
  • Worked closely with analysts and data scientists to develop meaningful data to model machine learning algorithms.

  • Verified the quality and integrity of data as part of this process (including the reconciliation of key metrics).

  • Assisted in both ad-hoc requests as well as regular reports for various business segments.

  • Collaborated with several teams to understand their business needs and translate them into actionable data analysis and reports.

  • Planned, designed, and streamlined ETL tasks along with verifying data quality and data integrity as part of this process.

TalendMySQLT-SQL (Transact-SQL) Microsoft SQL Server Data AnalysisData Analytics SQLSQL Server Integration Services (SSIS) ETLETL Development Data ArchitectureData pipelinesData ModelingData Warehousing Data Warehouse DesignDatabase Modeling Star Schema Database ManagementDatabase DesignDatabase Administration (DBA) Relational Databases MySQL Server SQL Server BI DatabasesETL Tools MySQLdb
Qordata (formally known as Streebo IM)
Senior ETL/DWH/BI Consultant
2014 - 2016 (2 years)
Remote
  • Led the team of consultants on different engagements of ETL and data warehousing.

  • Researched, wrote, and edited the documentation and technical requirements, including evaluation plans, test results, technical manuals, and formal recommendations and reports.

  • Developed from end to end various data-driven solutions, including the analysis, architecture, design, development, deployments, and maintenance.

  • Offered thought-leadership and proficiency in the architecture, design, and evolution of the data management system while interacting with business users to ensure BI data architecture and organizational needs are met.

  • Participated in organizational growth by providing in-house technical training, conducting interviews, and enhancing processes, standards, and other related activities that contribute toward operational excellence.

SQL Server Reporting Services (SSRS) SSASMicrosoft SQL Server T-SQL (Transact-SQL) Data AnalysisData Analytics SQLSQL Server Integration Services (SSIS) ETLETL Development Data ArchitectureData pipelinesData ModelingData Warehouse DesignData Warehousing ConsultingDatabase Modeling Star Schema Database ManagementDAX Database DesignRelational Databases Microsoft Business Intelligence (MBI) SQL Server BI DatabasesETL Tools
Streebo
Technical Consultant on ETL, Data Warehouse (DWH), and Business Intelligence (BI)
2012 - 2014 (2 years)
Remote
  • Designed and implemented various reports and prepare dashboards.

  • Engineered the process to extract data from multiple sources and performed data preprocessing using ETL tools.

  • Provided technical support in a database implementation and deployment.

  • Successfully performed load-optimization process for Kalido DIW, SSIS packages, and Microsoft SQL Server stored procedures for a worldwide assurance company.

  • Contributed to the POC of an MDM for a medical malpractice insurance company.

SpotfireDatastageMicrosoft SQL Server T-SQL (Transact-SQL) Data AnalysisData Analytics SQLSQL Server Integration Services (SSIS) ETLETL Development Data pipelinesData Warehouse DesignData Warehousing ConsultingDatabase Modeling Star Schema Database ManagementDAX Database DesignRelational Databases Microsoft Business Intelligence (MBI) SQL Server BI DatabasesIBM InfoSphere (DataStage) ETL Tools
Karachi University
Teacher Assistant
Present (2025 years)
Remote
  • Conducted practical labs on artificial intelligence to undergraduate students of software engineering.

  • Educated to implement the theoretical concepts of artificial intelligence in real life with examples using a tool called Prolog.

PrologT-SQL (Transact-SQL) Databases
Pakistan International Airlines
Intern
Present (2025 years)
Remote
  • Participated in an internship program for applying the classroom knowledge, concepts, and group effort with the professionals at Pakistan International Airlines.

  • Proposed a remarkable solution for transforming the provident fund management from traditional paperwork to an online web-based solution.

  • Documented the needs and importance of the proposed solution.

  • Analyzed the feasibility by reporting on the project implementation, project plan, and endorsing the best technologies to achieve the desired results.

.NETT-SQL (Transact-SQL) Microsoft SQL Server SQLSQL Server Integration Services (SSIS) ETL Development Database Modeling Database ManagementDatabases

Showcase

A Comparative Study of Data-mining Techniques for HCV Patients’ Data
  • The text describes a data-mining study focused on Hepatitis C patients.

  • The study's results were found to be superior to those of other research papers.

  • The text highlights the application of data-mining techniques to analyze data related to Hepatitis C.

ETL Migration from DataStage to SSIS
  • Migrated an ETL implementation from DataStage to Microsoft SSIS.

  • Ensured all business rules were intact during the migration.

  • Improved data integration using SSIS.

Reusability of Data Marts
  • Developed a generic data mart based on existing source system.

  • The data mart was deployed to multiple clients with minimal customization for reporting.

  • The focus was on meeting reporting requirements rather than extensive customization.

Managed Services
  • Led a team of consultants on a project focused on managed services for production monitoring of EDW loads.

  • The project involved nightly builds and resolving errors on level-1 and level-2 tiers.

  • The team's responsibilities included consulting and resolving issues.

Data Engineering for AI Models
  • Data engineering focused on optimizing data for machine learning models.

  • Implemented a mechanism for data gap and performance monitoring of AI models.

  • Designed data infrastructure to support AI model development.

Design and Implementation of a Data Warehouse for a SaaS Platform
  • Designed, developed, fixed bugs, and optimized the performance of a SaaS-based multi-tenant risk and compliance software.

  • The software includes a reporting feature on top of it.

  • The project involved research and understanding of a data warehouse for a SaaS platform.

Education

Education
Bachelor of Science Degree in Computer Science
University of Karachi
2008 - 2011 (3 years)