Abdul Basit Khan Email & Phone Number

Riyadh, Sa

Riyadh, Saudi Arabia

Riyadh, Saudi Arabia

Pakistan

My Job Responsibilities are Interaction with key stakeholders to Understand and translate business needs into data models supporting long-term solutions.• Designed data warehouse, database, tables and views, functions and complex stored procedures.• Define and implement data modeling standards and dimensional models in support of analytical requirements.• Development of Data Models (Conceptual, Logical and Physical), that answer all the business data needs and are flexible enough to facilitate future expansion. • Maintain conceptual, logical, and physical data models along with corresponding metadata.• Recommend opportunities for reuse of data models in new environments and projects.• Collaboration with different multi-cultural teams/staff/team members to get required data and information.• Writing Complex SQL queries and Dax.• Facilitate ad-hoc / on-demand, and customized reporting requests.• Managing and developing BI dashboards, and self-service BI Interfaces using industry-leading Tools such as Amazon Quicksight, Power BI and SSRS.

Rawalpindi, Punjab, Pakistan

My Responsibilities were ;• Designed data warehouse, database, tables and views, functions and complex stored procedures.• Define and implement data modeling standards and dimensional models in support of analytical requirements.• Ensured and monitored the Data Completed and Correctness by Daily Data Reconciliations.• Developed Daily, Weekly and monthly Data Completeness and Correctness Reconciliations and Periodical Audits and Controls• Involved in DWH Problem identification, Root-Cause Analysis, Resolution and future prevention• Performed ad-hoc requests using customized SQL queries and ETL to extract and format requested information from multiple sources.• Wrote Complex DAX and SQL.• Analyzing qualitative and quantitative even different format of the data.• Worked & Analyzed source system data to understand data structures, definitions and anomalies.• Worked on the SSIS packages and push the developed code• Collaboration with different multi-cultural teams/staff/team members to get required data and information.• Communicating with customers to gather and documenting reporting requirements.• Ad-hoc reporting in the form of visualizations to design dashboards on Reporting tools Power BI and SSRS.

• Communicated with customers to gather and documented reporting requirements. • Performed ad-hoc requests for clients using Excel and customized SQL queries/ETL to extract and format requested information.• Write Complex DAX and SQL to get required data.• Provide guideline and assistance in many projects.• Designed data warehouse, database, tables and views, functions and complex stored procedures.• Ad-hoc reporting in the form of visualizations to design dashboards on Reporting tools Power BI, SSRS and Tableau.