Alice Ruzindana

Designed, developed, and maintained various business and analytical reports for over fifty users across departments using Power BI and SSRS

• Used Power Automate and Logic Apps for automation of recurring tasks
• Generated, scheduled, and monitored data pipelines with Azure Data Factory to streamline data processing.
• Created, maintained, and set up schedule refreshes of Power BI datasets
• Provided level 1 support to Power BI users
• Wrote and optimized SQL statements to assist business intelligence practices.
• Collected data from wide-ranging sources: Excel, SQL database, SharePoint, etc.
• Collaborated with stakeholders to identify business needs and data sources.
• Updated and developed scripts and queries to extract and analyze data from multiple sources.
• Designed and developed data pipelines to acquire, clean and process data in Azure Data Factory.
• Generated ad-hoc reports to evaluate specific business requirements.
• Provided technical support for troubleshooting analytics and reporting issues.
• Generated standard and custom reports to provide insights into business performance.
• Created data models to support decision-making processes.
• Developed customized reports, summarizing and presenting data in visually appealing format.

• Developed and deployed SSRS reports for more than fifty users across departments
• Built and maintained SQL scripts and queries for data analysis and extraction
• Produced monthly reports using advanced Excel spreadsheet functions.
• Generated ad-hoc reports to evaluate specific business requirements.
• Analyzed data to identify root causes of problems and recommend corrective actions.
• Designed and implemented TSQL queries for reporting and complex solution development.
• Maintained complex T-SQL queries, views and stored procedures in multi-database environment with little supervision.
• Developed custom database objects, stored procedures and delivered application support.
• Analyzed existing SQL queries to identify opportunities for improvements.

• Responsible for a Decision Support system (DSS) that had more than fifty (50) different applications/programs
• Interacted with clients to understand their reporting needs, evaluated their requirements and researched required data
• Cleaned and Prepared data for Analysis
• Designed and developed OLAP Cubes using Cognos Transformer to allow users to perform predictive and multidimensional analysis
• Created and maintained ad-hoc reports using Cognos ReportNet