1. Power BI Visual Analytics & Documentation Management at Pratt & Whitney Canada:• 3 years of experience in Data Modelling, Data Visualization and Dashboard Preparation with Power BI desktop using the manufacturing and assembly units’ data of Pratt & Whitney Canada.• Monitored various KPIs related to Quality Notifications (QNs), Scrap Rework Repair (SRR) costs, Process Capability and Process Performance of manufactured engine parts.• Implemented ETL process by connecting various data sources including flat files, SharePoint files & folders, SQL server and transforming the data using Power Query Editor. • Extracted and manipulated necessary data from P&WC MySQL server using DML commands and Sub- Queries. Extensive knowledge in DDL, Aggregate Functions and Joins. • Built Table Relationships to create efficient Data Models following Snowflake/ Star Schemas.• Created Calculated Columns and Calculated Measures using DAX functions.• Built dashboards using available visuals and custom visuals. Leveraged other features including Bookmarks, Drill through pages, Advanced Tool Tips, Buttons, Slicers & Filters, Sync Slicers, Row Level Security, Performance Analysis and Custom Themes.• Published Reports onto the Power BI server & Power BI services. Leveraged other features including Mail Alerts/ Subscriptions and Scheduled Refresh.• Adopted Agile Methodology to ensure continuous working relation with the client in order to accomplish the tasks.• Implemented compliance matrices for QMSPs (Quality management system procedures) in accordance with AS9100 & periodic maintenance of engine related work instructions & procedures.2. Product design at Caterpillar:• 7 months of experience in 3D modelling of solid & sheet metal parts using CREO.