Employment History 

• Power BI Developer

  Colaberry Inc

  November 2020 - Present

  • Spearheaded the design, development, and deployment of Power BI dashboards, aligning with the data management principles and best practices of the firm, enhancing executive-level decision-making.
  • Advanced the firm’s data analytics capabilities by creating analytical dashboards that highlight critical KPIs, such as Income, YOY percent change, and PTI ratio, enabling stakeholders to forecast and pinpoint improvement opportunities.
  • Proficient in dimensional and relational data modeling, adept at employing star schema and snowflake patterns as well as managing fact and dimension tables to structure vast datasets effectively.
  • Honed expertise in T-SQL, developing and optimizing Tables, Stored Procedures, Views, Indexes, Triggers, and User-defined Functions for robust database management on SQL Server platforms.
  • Improved query performance and stored procedure efficiency using execution plans and data profiling, leading to faster data retrieval and report generation.
  • Utilized Power BI Gateways to maintain report freshness, and implemented Role Level Security for nuanced data access control across the enterprise.
  • Collaborated across departments to ensure a comprehensive inventory of data and reporting assets, assisting in the establishment of governance for reporting, data transfer, and storage standards.
  • Streamlined data extraction, transformation, and loading processes from various sources, including SQL Server databases and flat files, ensuring clean and reliable datasets for reporting.
  • Leveraged DAX to craft calculated columns, measures, and complex formulas, thereby enhancing report interactivity and analytical depth for users.