Muhammad Azam

Skills: SQL Server Reporting Services (SSRS) · Microsoft Power BI · Microsoft Azure · SQL Server Integration Services (SSIS) · Microsoft SQL Server · Azure Databricks · Python (Programming Language) · Transact-SQL (T-SQL) · Data Warehousing

Industry: Consultancy on Asset & Loan Management Projects - Modelling & Development of Data Integration ETL Pipelines - Working with complex SQL Queries, Views, Triggers & Stored Procedures - Data Validation & Data Analysis in MS Excel & SQL - Scheduling, Monitoring & Maintenance of Data Integration Projects

Major Responsibilities Include the following: - Modelling & Development of Data Integration ETL Pipelines with Talend - Working with complex SQL Queries, Views & Stored Procedures - Data Validation & Data Analysis in MS Excel - Development of Intuitive Reports & Dashboards in MicroStrategy - Scheduling, Monitoring & Maintenance of Data Integration Projects

In this Job, I have worked on complex data integration projects in which I have developed ETL data integration pipelines on a variety of data sources by using the tool named as “Talend”. In addition, I also worked on the deployment, scheduling, monitoring and maintenance of the developed Integration projects along with the management of databases.

In this Internship, I have worked on complex data integration projects in which I have developed ETL data integration pipelines on a variety of data sources by using the tool named as “Talend”. In addition, I also worked on the deployment, scheduling, monitoring and maintenance of the developed Integration projects along with the management of databases.

During this internship, I worked on the management of the MySQL reporting database, created the business dashboards on a Datapine data visualization tool, and worked with the Reporting API v4 when creating Google Analytics reports in Datapine.

Business Process Model of the company "IBL Operations" was developed. This company is operational in Pakistan.

A binary classification model was developed in MS Excel and it's performance was evaluated using ROC curve

It was developed to offer the facilities of job advertisements, rentals and business opportunities of the area

The main goal of this project was to develop Automata learning tool for universities that will be helpful in learning the course for students. It was done for checking the accuracy of the Automata machines, conducting online exams, evaluating exams, and building reports for analysis.

Decision Support System for 4 Campuses of FAST University was developed. ETL process was implemented and Data warehouse and OLAP layer was created. A front-end application was also built for analysis and reporting. Ad Hoc Query support was also provided.

Data Warehousing, Data Modelling, Data Visualization, Data Reporting, Data Integration, Requirements Engineering, Advanced IT Project Management

During my undergraduate studies, I strengthened my skills in databases, data mining, data warehousing and information processing techniques. I also got the opportunity to gain hands-on experience on the development of complex software applications in C ++ and Java