 Developed confidential proprietary analytical tools and reports with Confidential Excel, and Power Pivot and Power Point. Created Reports using Charts, Gauges, Tables, matrix. Designing, developing and maintaining business intelligence solutions Identify different types of data that need tracking to improve business performance.  Develop and execute database queries and conduct analyses. Generate easy-to-interpret reports based on collected data.  Work with the management team to prioritize suggested changes to each business segment.  Work with the management team to prioritize suggested changes to each business segment. Presented data and conclusions to team in order to improve strategies and operations. Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution. Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables. Transformed complex business logic by using SQL objects like User Defined Functions, Views, T-SQL Scripting. Developed Excel PowerQuery and PowerPivot dashboards for data analysis  Created Parameterized Report, Dashboard Report, Linked report and Sub Report by Year, Quarter, Month, and Week. Created Drill Down Reports, Drill Through Report by Region.