About
Inquisitive data analyst with hands on experience using Microsoft BI Stack (SQL Server, SSIS, SSRS) and Power BI for data visualization. In Power BI proficient in creating DAX queries to perform complex calculations, create measures and calculated columns. In SSIS, experience loading data from various sources and creating a staging environment to clean, validate, and perform error handling on data. Experience in automating packages to run on schedule through SQL Server Agent and troubleshooting control flow and data flow. In SQL, experience with query optimization, troubleshooting and maintaining Stored Procedures, tables, and views. In SSRS, experience creating reports utilizing charts, gauges, maps, tables, matrices, and sub-reports, with drill-through and drilldowns capabilities, and cascading parameters. Experienced maintaining program website and database, and hands on experience using Google Analytics to identify and analyze trends to inform management.
Looking for Full-TimePortfolio
Tuberculosis Burden By Country
Tuberculosis – commonly known as TB is caused by a bacterium and usually attacks the lungs, but TB... ... More
Employment History
-
Business Intelligence /Power BI Developer
Colaberry Inc
January 2019 - Present
• Collaborate with senior management, subject matter experts and IT teams to define business
requirements.
• Design, develop and publish Power BI reports and dashboards according to business requirements and
ad hoc.
• Create DAX functions for various fact calculations for efficient data visualization in Power BI.
• Generate score cards with executive summary dashboards to display depicting industry KPI’s in Power
BI.
• Utilize Power BI gateway to keep dashboards and reports up to-date with on premise data sources.
• Design, develop, and test the ETL strategy to populate data from multiple sources.
• Utilize SSIS packages to perform ETL data messaging operations: data cleaning, validation, and error
handling
• Create, maintain, and troubleshoot existing tables, views, and stored procedures.
• Schedule jobs and alerts using SQL Server Agent
• Develop SSRS reports for business analysis.
• Utilize agile scrum methodology frameworks and Software Development Life Cycle (SDLC).