Data Analyst 2
CurrentData Analysis, Data Gathering & Cleansing:• Analyzed data using Python in Databricks Notebooks to perform regression analysis and statistical analysis for predictive modeling of machine operations. This led to actionable insights which improved dealership sales by 24%.• Used R to analyze and transform raw data for data analysis and to identify trends which led to an improvement in data collection of operational metrics.• Developed KPI metrics to track performance using insights from analysis of more 18,000 machines’ data in Microsoft Databricks SQL.• Conducted quantitative analysis and correlations on machine data to forecast significant trends within the data and optimize resource allocation.• Extracted and transformed data from Oracle DBeaver and Azure Cosmos DB. Improving query performance by 35% through optimized use of SQL and stored procedures.• Gathered, cleaned and validated data using SQL and Python to ensure good data quality for reporting and data analysis in Databricks.Data Visualization & Reporting:• Created interactive PowerBI dashboards for stakeholders across the business, cutting report generation time by 56% by using DAX functions and M code.• Leveraged R to create custom visuals using ggplot and other libraries to convey analysis on the operational metrics of the machines.• Designed PowerBI dashboards to integrate real-time data and track the machine’s performance at dealerships using KPI metrics. Data Architecture:• Managed data warehousing for over 25 million data points in Microsoft Azure using SQL, ensuring the data storage is efficient and accessible to stakeholders.• Developed data infrastructure and aligned them with business goals, creating a secured and integrated architecture in Microsoft Databricks that supported data analysis projects.• Improved ETL processes in Microsoft Azure by scaling pipelines in Microsoft CosmosDB and Synapse and increasing processing efficiency by 46%.
