My name is Jonathan Lewis, a certified Power BI and SQL professional with over 10 years of experience in database management and the configuration of SSIS packages and ETL solutions tailored to business requirements. My educational background is rooted in computer science, and I have applied my skills across various sectors, including online marketing, education, and healthcare, utilizing SQL versions 2012, 2014, and 2016 to the present. I possess extensive expertise in SQL, demonstrating proficiency in-defined and system functions, development and implementation of stored procedures, and the management of views, indexes, and triggers. I excel in maintaining both clustered and non-clustered indexes and unique to ensure effective database normalization My capabilities include integrating data from multiple sources through joins and working with OLTP and OLAP databases, along with a solid understanding of transaction management concerning logging and locking. Furthermore, I am adept in utilizing Common Table Expressions (CTEs) and have a keen understanding of data manipulation through temporary tables and variables, as well as query optimization and performance tuning using SQL Profiler and execution plans. In the realm of SSIS, I have acquired significant knowledge in ETL processes and have successfully developed complex SSIS packages employing various transformations and tasks, including Script Task, Data Flow Task, and Execute SQL Task. My experience extends to data consolidation and validation using Conditional Split and data conversion, as well as error handling, auditing, and logging within SSIS packages. I am skilled in package optimization and deployment, and I have a strong of integrating SQL Server, Oracle, flat file sources, IBM mainframe DB2. With respect to Power BI, I have a robust understanding creating complex reports that incorporate DAX calculations and functionalities such as bookmarks, drill down, and drill through. I experienced in developing a variety of visualizations, including gauges pie charts, bar charts, and maps, while effectively utilizing cascading parameters. I am proficient in data modeling and relationship definition, and I can implement color coding for KPIs to align with stakeholder expectations. expertise also includes cross-report filtering on dashboards, establishing QA, migrating SSRS to Power BI, defining row-level security (RLS) per report, creating applications to house enterprise-level Power BI reports.