Melika Gerami

Melika Gerami

SQL / Power BI Developer

Irvine, California, United States.

About  

Teamwork-oriented and motivated data analyst with experience in Microsoft power BI designing, developing, deploying and visualizing business reports. Alongside data visualizations I’m also proficient in developing SSIS packages to Extract, Transform and load (ETL) data and also Microsoft SQL Server in OLTP and OLAP (Data warehousing) environments.

Hours Available / Wk - 40 hrs

Watch Video Pitch

Employment History 

  • SQL / Power BI Developer

    Colaberry Inc
    September 2018 - Present

    • Extract data from different sources like SQL server database, CSV, Excel, transform and clean the data in power query and load it to Power BI desktop.
    • Create dashboards, charts, graphs, tabular and matrix reports based on customers' requirements using Power BI and SSRS.
    • Generate drill down and drill up reports
    • Create KPIs using complex DAX functions and publishing reports in Power BI service.
    • Implemented row-level security to restrict data access.
    • Use agile methodology while working on complex projects and breaking them into sprints.
    • Working with Star schema and snowflake schema in data warehousing.
    • Use T-SQL to develop stored procedures, tables, user-defined functions, joins to optimize data loading into Power BI.

Digital Credentials  

Schedule an Interview