Data Developer in Carlsbad, CA, United States

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.

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.

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.

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.

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).

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.

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.

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.

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.

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.