About
Highly skilled IT professional with over 3 years of experience in business analysis and development for major corporate clients. Proficient in designing, developing, and implementing Business Intelligence (BI) and Client/Server applications using Microsoft Suite, including SSIS, SSRS, SSAS, and Power BI. Demonstrated expertise in creating customized reports and dashboards, advanced Power BI features, and optimizing performance. Experienced in ETL migrations to Microsoft Azure and transforming unstructured data. Excellent communicator and team player with strong problem-solving skills.
I bring a unique combination of technical proficiency and business acumen, ensuring that solutions are not only technically sound but also aligned with business objectives. My ability to transform complex data into actionable insights helps drive informed decision-making and strategic planning, making me a valuable asset to any team.
Portfolio
Suicide Rates Overview (2010 to 2015)
The global mental health landscape has been significantly impacted by the rising issue of suicide, p... ... More
Employment History
-
SQL/Power BI Developer
Colaberry Inc
April 2021 - Present
Responsibilities
Dashboard and Report Development: Design and develop interactive dashboards and reports in Power BI based on business requirements. Create visualizations that effectively communicate data insights to stakeholders.
• Data Modeling: Develop and maintain data models to support reporting and analytics needs. Implement star schema designs for data warehousing.
• DAX Calculations: Create and troubleshoot complex DAX calculations and measures to provide custom functionality in Power BI applications.
• ETL Processes: Integrate data from multiple sources, using Power Query for data cleaning and transformation. Ensure data quality and accuracy before loading into Power BI.
• Performance Optimization: Optimize Power BI reports for performance, including efficient data modeling, query optimization, and visualization techniques.
• Collaboration: Work closely with business stakeholders, data analysts, and IT teams to gather requirements and ensure the effective use of Power BI for business intelligence needs.
• Data Integration: Implement data integration solutions using Power BI Gateway to ensure up-to-date data in reports and dashboards. Schedule regular data refreshes and manage data source connections.
• KPI and Metrics Development: Identify and define key performance indicators (KPIs) and metrics for various business processes. Create and maintain these KPIs in Power BI to support business decision-making.
• Training and Support: Provide training and support to end-users on Power BI tools and dashboards. Help users understand and leverage Power BI capabilities for their specific needs.
• Documentation: Document data models, report designs, and ETL processes to ensure transparency and reproducibility. Maintain version control for Power BI reports and datasets.