Awais Aslam, Data Developer in Carlsbad, CA, United States
Awais Aslam

Data Developer in Carlsbad, CA, United States

Member since June 2, 2022
Awais is a data engineer and advanced data analyst with 14 years of experience in consultancy and in-house development. He's been working on data engineering and advanced analytics projects. Awais has architected and developed big data clouds and data warehouses that handle billions of rows as a data engineer. He has led a data analyst team of up to eight developers and worked extensively with consumer packaged goods (CPG), construction, semiconductor, and medical device industries.
Awais is now available for hire

Portfolio

  • Alphabold
    Azure AutoML, Azure Cosmos DB, Azure Data Factory, Azure Data Lake...
  • Xavor
    SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS)...

Experience

Location

Carlsbad, CA, United States

Availability

Part-time

Preferred Environment

Microsoft Power BI, Azure Data Factory, Azure Cosmos DB, Azure Synapse, Azure Auto ML, Azure spark pool

The most amazing...

...projects I've worked on were featured as case studies on the Microsoft website.

Employment

  • Principal Data Architect

    2018 - PRESENT
    Alphabold
    • Designed and built a data platform capable of holding 240 billion rows in a data warehouse (DWH) and doing real-time or batch analysis of those rows. Implemented data-driven culture for more than 15 clients using Power BI and the Azure Data Platform.
    • Managed client meetings and requirement gathering phases of projects as well as business analysis, business process re-engineering, and information management practices and protocols.
    • Conducted a number of webinars on big data analytics. Published four branded case studies with Microsoft. Collaborated with Microsoft's sales team.
    Technologies: Azure AutoML, Azure Cosmos DB, Azure Data Factory, Azure Data Lake, Azure SQL Databases, Azure Analysis Services, Azure SQL Data Warehouse (SQL DW), SQL Server Integration Services (SSIS), Microsoft Power BI, Data Engineering, Big Data Architecture, Big Data, ETL, Data Warehousing, Data Warehouse Design, Data Cleaning, Data Quality, Data Matching, Cloud Architecture, Data Analysis, Data Flows, Dataverse, Microsoft Power Apps, Data Visualization, Healthcare Services, Data Science, Dashboards, Healthcare, Data Analytics, SQL, Team Leadership, Architecture, Microsoft Power Automate, Microsoft Excel, APIs, Data-level Security
  • System Architect

    2010 - 2018
    Xavor
    • Oversaw a business intelligence team that worked with various clients, created custom product lifecycle management (PLM) solutions for them, and designed and implemented native SQL Server 2016 DBA applications.
    • Created large-scale DWH solutions, including SSIS packages, stored procedures, SQL Server Agent jobs, and native DBA jobs, to administer and maintain DWH in production. Set up SSAS cubes that aggregated millions of rows for the SSRS analysis.
    • Worked with Fortune 100 companies around the world and conducted a number of workshops on SQL Server services.
    Technologies: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Server 2008, Azure SQL Databases, Oracle Agile PLM, Java 9, C#.NET, Application Architecture

Experience

  • California Electricity Meter Data: Data Engineering and Analytics

    I designed and implemented a big data project to handle the daily ingestion of 240 million rows of data generated by electricity meters. Also, I created and developed a data warehouse on Azure Synapse that manages a total volume of around 430 billion rows. This solution has allowed business users to gauge electricity usage patterns to better forecast demand and generation of power and assist the organization in complying with California state laws.

  • Depletion and Shipment Forecasting

    Using the Prophet algorithm, I developed a forecasting AI model using Azure AutoML to predict depletion and shipments. It involves:

    • Data collection from SAP and VIP.
    • Feature engineering.
    • Forecasting model identification using AutoML.
    • Analytics on Power BI.

  • Drinking Event Identification From PPM Sensors Data Using AI

    We designed and built an AI model to determine whether or not a drinking incident occurred based on telemetry project portfolio management (PPM) data coming from wearable devices. This model eliminates all noises, such as sanitizer on the skin, perfume in the air, etc. The challenge was handled by applying classification models, labeling, and comparing values to breathalyzer results. The project also involved:

    • Gathered data in both controlled and uncontrolled contexts.
    • Information obtained from a breathalyzer and wearable devices.
    • It detects drinking episodes within a thirty-minute span.

  • Data Platform for Wearable Devices

    This mission-critical data ingress enables millions of pulse ingestion in Azure Cosmos DB. This is done by implementing a data platform to ingest telemetry data on alcohol levels in the blood from wearable devices and transmit this information to Azure Cosmos DB. On top of this data, near-real-time and batch reporting is available.

    For the near-real-time analytics, we employ analytical stores on collections and then consume these data through an Azure Synapse link, which subsequently displays information in Power BI. On the other hand, for batch analytics, we put in place archiving mechanisms that migrate data from Cosmos to hot or cold storage and finally to Azure Synapse data warehouse for reporting. Finally, all of the Power BI analytics were embedded in an ISV application built using Node.js.

  • Email Statistics and SLA Reports for Customer Support – Dynamics 365

    I implemented a data solution, which detects email threads and identifies spam in emails, received in Microsoft Dynamics 365 CRM. Based on the response time of emails, which can be both automatic acknowledgment or manual response, it calculates the percentage of emails and maps it to the defined service-level agreement (SLA).

  • NetSuite Analytics

    I created a Power BI connector for NetSuite to retrieve data from saved searches and workbooks. It was packaged with a number of reports, including:

    • A budget to actual variance analysis.
    • Commission calculation analytics.
    • Accounts receivable aging tabulated via an aged receivables report.
    • An aging inventory report.
    • An order summary report.
    • Portfolio management.
    • Warehouse management analytics.

  • Call Rotation and Campaign Analytics

    I implemented call rotation and campaign analytics to assess the impact of each campaign and the contribution of corporate social responsibility (CSR) to revenue generation. We used Power BI for analytics to get data from Microsoft Dataverse and perform transformations before presenting analytics for CSR performance.

  • Database Applications

    I created a comprehensive set of native database applications to monitor the massive warehouses and archival processes. These applications can:

    • Capture deadlock history, long-running connections, slow running queries, and space used by databases.
    • Back up and index management jobs.
    • Monitor and kill blocking sessions.
    • Utilize the Notification Framework.
    • Conduct the SQL Server Integration Services (SSIS) log analysis.

  • Data Warehouse for a Bank

    I participated in implementing the National Bank of Kuwait (NBK) data warehouse (DWH). I designed and implemented ETLs to populate various datamarts of DWHs as well as semantic layers for multiple business units for ad-hoc analysis and reporting on top of the data warehouse.

  • Analytics for Construction

    We developed a complete suite of analytics for the construction industry. Users can manage projects on the ground and monitor the performance of each project through Power BI dashboards. It also helps subcontractors and vendors manage their equipment and workforce on site. Power BI apps are available in Microsoft AppSource.

Skills

  • Languages

    Java, SQL, C#.NET, T-SQL, Java 9
  • Tools

    Microsoft Power BI, Microsoft Excel, Microsoft Power Apps
  • Paradigms

    ETL, Application Architecture, Data Science, Business Intelligence (BI)
  • Storage

    SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Azure Cosmos DB, Azure SQL Databases, SQL Server 2014, SQL Server 2008
  • Other

    Azure Data Factory, Azure SQL Data Warehouse (SQL DW), Data Warehousing, Azure Analysis Services, Power BI premium, Data Engineering, Big Data Architecture, Big Data, Data Warehouse Design, Cloud Architecture, Data Analysis, Data Flows, Dataverse, Data Visualization, Dashboards, Data Analytics, Team Leadership, Architecture, Data-level Security, Azure Synapse, Algorithms, Azure Auto ML, Azure spark pool, Data Cleaning, Data Quality, Data Matching, Healthcare Services, Microsoft Power Automate, APIs, Azure Data Lake, Azure AutoML, Dynamics CRM 365, NetSuite, Microsoft cognitive services, Oracle Agile PLM
  • Industry Expertise

    Healthcare

Education

  • Bachelor's Degree in Computer Science
    2005 - 2009
    Punjab University College of Information Technology - Lahore, Pakistan

Certifications

  • Designing a Business Intelligence Infrastructure Using Microsoft SQL Server (MCITP)
    FEBRUARY 2015 - PRESENT
    Microsoft
  • Microsoft SQL Server 2008 – Business Intelligence Development and Maintenance (MCTS)
    MARCH 2012 - PRESENT
    Microsoft

To view more profiles

Join Toptal
Share it with others