Caterpillar Inc.Data Analyst
Jul. 2023• Consulted with leadership to deliver analytics that influenced strategic decisions, contributing to an improvement in operational efficiency.
• Normalized, cleaned, and consolidated data from 3+ distinct sources (on-site servers, cloud storage, CSV files), creating unified datasets that reduced report preparation time.
• Supported management teams by designing and generating regular and ad-hoc reports in Power BI, enabling timely insights for multiple business functions.
• Developed Sub-Reports, Drill-down, Summary, and Parameterized Reports using Power BI, increasing report detail and end-user engagement.
• Performed regression analyses for forecasting using Python (NumPy, Matplotlib) on datasets improving forecast accuracy.
• Created and maintained database objects (tables, views, stored procedures, triggers, functions) in T-SQL, optimizing query performance and reducing SQL execution times.
• Executed ETL operations via MS SSIS, moving and transforming data for reporting pipelines improved data pipeline reliability & reduced failures.