About
I specialize in delivering strong Business Intelligence solutions using tools like SSIS, SSRS, and Power BI. As a certified Power BI Developer, I excel at using tools such as Power Query, Power Pivot, Power BI Desktop, and Power BI Mobile to transform data from multiple sources into clear and actionable insights. I have a proven ability to create impactful KPI dashboards and reporting solutions that support data-driven decision-making and help teams achieve their goals efficiently.
Portfolio
Product Review Dashboard
This Project focussed on improving product quality and customer satisfaction based on customers rev...
Employment History
-
Power BI Developer
Colaberry
January 2021 - Present
• Designed and developed advanced T-SQL programs, including Stored Procedures, Triggers, Views, and Cursors, following best practices for execution plans and utilizing DDL & DML commands.
• Skilled in crafting complex DAX expressions in Power BI and Power Pivot for robust data analysis and reporting.
• Created calculated columns and measures in Power BI Desktop, employing advanced data analysis techniques to enhance visualizations.
• Optimized SQL queries, MDX scripts, and stored procedures to improve performance, ensuring faster report generation and consistent data in cubes.
• Developed SSIS packages utilizing tasks, containers, and transformations such as full load, incremental load, bulk inserts, aggregates, and slowly changing dimensions.
• Migrated data from diverse sources into SQL Server databases via SSIS, overcoming transformation constraints and ensuring data consistency.
• Built visual reports and dashboards in Power BI Desktop by integrating data from multiple sources.
• Created reports in SSRS to analyze data across different teams and timeframes.
• Wrote and maintained SSIS processes for importing data into the Data Warehouse from Excel files, Flat Files, and OLEDB sources.
• Developed and scheduled SSIS packages and jobs, implemented database backup and recovery strategies, and designed disaster recovery plans for critical databases.
• Proficient in Power BI Suite, including Power BI Desktop, Power BI Pro, and Power BI Mobile, for developing interactive and insightful data solutions.