Muhammad Khan Email & Phone Number

Sydney, NSW, AU

Parramatta, New South Wales, Australia

Working for Cognizant consulting company and their client QBE Insurance.Data Engineering and Data Consulting in Python, Azure Databricks, SAS, SQL etc.

Sydney, New South Wales, Australia

• Currently working as Data Consultant Developer and Team Leader at QBE Insurance. Working at the senior most level currently on Project North.Responsibilities:
• Engaging with multiple departments to identify data and reporting needs.
• Team Leader in QBE's highly technical Project North
• Crafting advanced SSIS packages for data integration and automation.
• Extensive usage of SQL, SSAS and Writing MongoDB queries for data normalization and SSIS compatibility.
• Facilitating cross-functional team collaboration for platform development.

Australia

The founder and Executive Director of ANY Enterprises Pty Ltd.An IT consulting company working primarily in Data Science, Software Solution Engineering, Web 3.0 & Data Migrations.Takes on both long-term contracting and short term solution development.

Sydney, New South Wales, Australia

• Responsibilities:
• Spearheading the migration of two decades of environmental data into accessible formats.
• Mapping complex data source tables to a SQL data mart for enhanced analysis.
• Utilizing a blend of Excel, SQL, and R for sophisticated data analysis projects.
• Documenting intricate data models and their interrelationships for cross-departmental clarity.
• Developing interactive Tableau and Power BI dashboards to visualize environmental insights.Achievements:

Sydney, New South Wales, Australia

• I could not continue this role for long due to severe outbreak of COVID-19.Responsibilities:
• Liaise with users to gather data/reporting requirements
• Develop PowerBI reports and dashboards.Achievements:
• Developed PowerBI dashboards.
• Developed BI reports based on TM1 views.
• Developed TM1 views for consuming data by BI reports.

Sydney, New South Wales, Australia

• Responsibilities:
• Orchestrating the development of analytical applications to support large-scale customer data migrations.
• Producing a diverse range of reports leveraging Power BI, Tableau, Spotfire, and SAS.
• Pioneering data mart designs based on Stallion and Orion systems for extensive reporting capabilities.
• Leading initiatives for actionable insights from historical life claims with extensive data cleansing and analysis.
• Conceptualizing and modelling claims behaviour and duration using advanced statistical methods.

Sydney, New South Wales, Australia

• Responsibilities:
• Conducted statistical analysis on retail and wholesale data to inform supply, demand, and pricing models.
• Developed comprehensive reporting solutions across sales, manufacturing, and finance departments.
• Served as the Database Administrator for SQL Server 7/2000 and 2005.
• Oversaw data cleansing and migration for the ERP system and implemented a SQL Server-based Data Warehouse.Achievements:
• Generated consistent sales, inventory, budgeting, and forecast reports for over 12 years, utilizing VBA for automation and distribution within the company and to the Coles Myer group.

Sydney, New South Wales, Australia

• Responsibilities:
• Conducted statistical analysis on retail and wholesale data to inform supply, demand, and pricing models.
• Developed comprehensive reporting solutions across sales, manufacturing, and finance departments.
• Served as the Database Administrator for SQL Server 7/2000 and 2005.
• Oversaw data cleansing and migration for the ERP system and implemented a SQL Server-based Data Warehouse.Achievements:
• Generated consistent sales, inventory, budgeting, and forecast reports for over 12 years, utilizing VBA for automation and distribution within the company and to the Coles Myer group.

• Responsibilities:
• Curating a vast collection of SAP BO reports and dashboards tailored for law enforcement analytics.
• Enhancing and maintaining SSAS cubes and SSRS reports to support data-driven policing.
• Streamlining management reports with advanced SQL Server 2005 techniques.
• Managing UAT processes and maintaining SharePoint sites for internal operations.Achievements:
• Significantly improved data reporting mechanisms, affecting over 100 Crystal Reports and management reports.

Sydney, New South Wales, Australia

• Responsibilities:
• Identified, extracted, cleaned, and validated crucial data from enterprise systems based on DB2 and Oracle databases.
• Conducted comprehensive time series analysis using SPSS and Excel, integrating VBA for automating processes, to project future water demand.
• Analysed factors affecting water demand and developed corresponding water consumption curves.
• Engaged in the development of water demand management policies through extensive data analysis.Achievements:
• Implemented a Data Warehouse solution on SQL Server 2005, significantly improving data extraction, cleaning, and validation processes.

Sydney, New South Wales, Australia

• Responsibilities:
• Tasked with reconciling data discrepancies across multiple database systems, including building access, telephone log-on, and employee data systems.
• Developed SQL Server Integration Services (SSIS) packages to consolidate data into a central repository.
• Employed complex VBA routines for anomaly detection and data standardization.Achievements:
• Streamlined the data cleansing process, integrating data from SQL Server, Oracle, and Lotus Notes, among others, into a unified format for analysis and reporting.
• Developed advanced data manipulation functions using Excel 2007, VBA, and Access, enabling record selection and matching based on multiple criteria.

Sydney, New South Wales, Australia

• Responsibilities:
• Created DTS/ETL routines for data extraction from UNIX systems, cleaning the data for statistical significance.
• Performed in-depth statistical analysis on extracted data.
• Built robust forecasting models based on data analysis to predict customer call patterns.Achievements:
• Authored multiple ETL routines using Symba ODBC interface and SQL Server Integration Services, with a focus on data quality and integrity.
• Developed an automated forecasting model using Excel VBA, leveraging statistical functions from SAS, SPSS, and Statistica.

Sydney, New South Wales, Australia

• Responsibilities:
• Authored and refined stored procedures for the data warehouse built on SQL Server 2005.
• Crafted new reports utilizing SQL Server Reporting Services, Excel, and Pivot Tables.
• Engineered self-maintaining solutions for data verification and cleansing using Visual Studio 2005.
• Developed new dimensions and cubes for enhanced data analysis.Achievements:
• Introduced a range of custom functions to improve data processing capabilities.

Sydney, New South Wales, Australia

• Responsibilities:
• Developed and maintained interfaces between applications, including Oracle Financials, CPWerx, DB2, and SAP.
• Ensured data integrity across ERP systems and conducted UAT.
• Provided application usage training to staff.Achievements:
• Engineered complex data integrity solutions between general ledger, orders, and sales using Access and Excel with Oracle as the backend.
• Developed spreadsheet solutions for validating business information within CPWerx and broader ERP systems.

Sydney, New South Wales, Australia

• Responsibilities:
• Developed new dimensions and cubes for financial and sales departments.
• Reconciled general ledger data between ERP systems and GL/Sales cubes.
• Authored self-maintaining reports for ERP and GL/Sales data reconciliation.Achievements:
• Debugged and corrected over 100 ETL routines, ensuring accurate data mapping and resolution of discrepancies.
• Extracted and reconciled GL and Sales data from

Armidale, New South Wales, Australia

• Responsibilities:
• Delivered tutorials for the subject of Statistics, ensuring student understanding of complex statistical concepts.
• Enhanced the coursework by integrating computer tools, specifically Excel 97, for data analysis and reporting.
• Provided academic support, facilitated discussions, and graded assignments and exams to assist students in their learning journey.Achievements:
• Significantly reduced the time and cost of study and research for students by introducing practical computer-based analysis techniques.
• Improved student performance and engagement in the subject through the use of technology and innovative teaching methods.

Masters Of Economics, Econometrics And Quantitative Economics

Master Of Economics, Econometrics And Quantitative Economics

Bachelor Of Science (Honors) - Bsc, Agricultural Economics