Uday O

Bi Sql Developer @TELUS

Toronto, ON, CA

Developed stored procedures for maintenance, such as rebuilding/reorganizing indexes based on fragmentation percentage and updating statistics daily by triggering them via SQL job when the daily download is completed.• Developed and designed the trigger, queries, views, and stored procedures needed to support SSRS reports.• Monitored database activity, integrity, security, deadlock, session resource use, capturing long-running SQL statements, fine-tuning SQL queries, and troubleshooting locks for high availability.• Proposed technical feasibility solutions for new functional designs, as well as suggested options for improving technical item performance.• Involved extensively in the creation of new and updated existing cubes with multiple fact tables and dimension tables, as well as the creation of calculated columns in SSAS.• Developed interactive Power BI Dashboards, KPIs, and Reports for Monthly Metric Analysis to replace traditional Excel reporting and to automate data refresh using Power BI On-Premises Gateways.• Forecasting or predictive analysis using DAX in Power BI based on historical data. • Published reports via the Power BI service, managing them through app distribution and monitoring usage/data refreshes using Gateways/security access.• Designed and created tabular data models in SSAS to meet business requirements and conduct data analysis.• Use SQL Server Agent to schedule SSIS packages daily.