Sandeep Chowki

Data Analyst @Ford Motor Company

MI, US

Data Integration & Transformation:• Extracted, integrated, and cleansed data from multiple sources, including SQL Server and Oracle, into Power BI using SSIS and Power Query, ensuring comprehensive and high-quality data for analysis.• Developed and maintained complex SSIS packages for ETL processes, ensuring accurate and efficient data integration and migration.Data Visualization & Reporting:• Developed and published comprehensive reports and dashboards using Power BI, enhancing data visualization and decision-making processes for business users.• Created various data visualizations such as Pie Charts, Bar Charts, tree maps, and Line Charts, and developed KPIs and performance metrics, providing a complete business overview.• Designed and deployed interactive reports using SSRS, Excel services, and Power BI, fulfilling business requirements and improving data accessibility.• Installed and configured Power BI Report Server, enabling seamless report generation and distribution.Database Management & Optimization:• Designed and developed primary database objects (views, indexes, etc.) based on logical design models, user requirements, and physical constraints, streamlining data storage and retrieval processes.• Utilized SQL Profiler to troubleshoot, monitor, and optimize SQL Server and non-production database code, enhancing system performance and efficiency.• Wrote and optimized T-SQL queries, stored procedures, and DAX expressions, resulting in efficient data manipulation and reporting.Security & Governance:• Implemented robust data security and governance measures within Power BI, creating user roles and groups to safeguard data integrity and access control.Support & Troubleshooting:• Provided production support for Power BI reports, troubleshooting and resolving issues promptly to maintain report availability.

Trine University

Master of Science