Qazi Osama Jamil Email & Phone Number

Islamabad, Pk

Bahrain

Working as Consultant for STC Client on behalf of BTCDevelop Collection Allocation Data Marts

Islamabad, Islāmābād, Pakistan

Islamabad, Islāmābād, Pakistan

-> Organizational Responsibilities• Aid to establish and maintain strong client relationships, acting as a trusted advisor on data analytics solutions.• Collaborating with business stakeholders to understand their data analysis requirements and translate them into effective BI solutions.• Aid in Analysis, architecture, design, and development of ETL, Data Warehouse and provide end-to-end deployments of BI solutions. --> PROJECTS <---> MyGolfSpy - Canada• Developing and overseeing Extract, Transform, Load (ETL) and Extract, Load, Transform (ELT) pipelines.• Implementation of the semantic data model with ad-hoc reports and dashboard development on tools like Tableau.• Design and Development of Semantic layer to optimize BI reporting by means of Talend Open Studio.• Reverse Engineering BI Dashboard to custom SQL.• Monitoring data pipelines and conducting log analysis to identify areas for improvement.• Streamlining SQL queries to optimize data processing speed and retrieval efficiency.• Optimizing BI reports and dashboards for performance and responsiveness, ensuring efficient data retrieval and visualization.-> Pharma USA - Azure EDW• Translate business requirements into data models (conceptual, logical, and physical).• Designs logical enterprise-wide data models, Provides support formaster data management, logical data, quality system development,implementation, and maintenance.• Designed and developed standalone data migration pipelines inAzure Data Factory (ADF) to retrieve and populate data from various sources to MS SQLSERVER.• Automate backup by means of azure functions.-> SAB Bank - Riyadh,KSA-> Designa and develop BI dashboards and python based ETL pipelines.-> Performed detailed analysis of facts and figures being presented to COO of the bank and ensure quality standards,consisstency and accuracy of data.

Riyadh, Saudi Arabia

-> SAB Bank - Riyadh,KSA-> Design and develop BI dashboards using Tableau.-> Develop python based ETL pipelines for development of Semantic layer.-> Understand and implement technical business strategies in designing system to meet the requirements.-> Performed detailed analysis of facts and figures being presented to COO of the bank and ensure quality standards,consistency and accuracy of data.-> Aid other team members in finding possible gaps in project workflow.-> Ensure defined standard and policies to be refelcted along the whole project workflow.

Islāmābād, Pakistan

->Organizational Responsibilities• Help design and develop data warehousing solutions.• Project planning (Agile) and preparation of technical documents including Application Requirements, Report Matrix, Semantic-to-EDW Mapping (SMX), and Source-to-Target Mapping (UMX).• Help Establish and maintain strong client relationships.-> Vodacom South Africa- Microservices• Design and Development of integration layer which acted as asource to different web micro-services provided by vodacom.• Develop and test ETL jobs incorporated with refined ETL logics anddata transformations using Azure data factory.• Modifying and developing SQL procedures to develop automatically generated daily and monthly recon reports in MS SQL Server.• Investigating hidden issues effecting the performances of ETL jobsand fine tuning queries by writing adequate SQL scripts.

Islāmābād, Pakistan

• Create Tableau dashboards with interactive visualizations, trendsand drill-downs, along-with user level security.• Prepared effective story telling dashboards.• Perform data cleaning and tidying to improve data quality.