Datawarehouse & Analytics

1) Data Warehousing: * - TEAM (Team, Equipment Accountability Management) Project: DWH Project using Azure Technologies (Azure related services, Azure Data factory, ADSL, Azure DWH DB, ADSL, Key vault & Azure API, Power BI) which tracks Equipment movement (data from IoT devices), Equipment-Fleet management, weather conditions, field staff productivity and reports for improving process efficiency. *-EDW (Enterprise Date Warehouse) project: Building Enterprise Data Warehouse (using Azure Services like ADSL, Azure DWH DB, Key vault, Azure Data factory, Databricks,PySpark,Power BI)-Centralized repository of all of an organization’s data from multiple sources On-Prem systems & Cloud(Oracle Fusion) system - on Azure cloud. EDW gives current data, such as real-time feeds or the latest snapshots from source systems, as well as historical data for analysis, BI, and data-driven decision-making. Users (with privileges) across the organization can access and benefit from the data contained in EDW. 2) IoT Devices: SCADA-Worked on extracting data from Solar Inverters, using Raspberry PI device and using data for customer analytical reporting & forecasting. 3) Data Science: For Marketing, O&M Departments-Data Scraping, Data Cleansing, Text mining, Data preparation, Modelling, Machine learning (ML) and started working on Dashboard using R Shiny. Data Analysis using tools like Excel, R-Language, Python.