Ephrem Arega

Ephrem Arega

Senior Power BI Developer

Alexandria, Virginia, United States.


With proven experience in SQL and Data Visualization, encompassing the full software development life cycle (SDLC), I bring a dynamic skill set to drive effective data strategies. Known for goal-driven and energetic contributions, I am a fast learner who excels in collaborative team environments. My proficiency extends to performance tuning and processing, ensuring optimal database functionality. Adhering to Agile Methods, I bring assertive leadership skills that align with a one-team, one-goal philosophy. I am eager to leverage my expertise to enhance your organization's data capabilities and contribute to its success.

Hours Available / Wk - 40 hrs

Watch Video Pitch

Employment History 

  • Senior Power BI Developer

    Colaberry Inc
    November 2020 - Present

    • Build complex DAX functions in Power BI for data insight.
    • Write useful calculated columns, measures in my dataset and display in visuals including KPIs.
    • Successfully plan, define, and design database based on the business requirement to increase efficiency.
    • Produce applicable dashboards, Tabular reports, Matrix reports, Charts and Graphs as per customer/ Business requirements for data analysis using Power BI and SSRS.
    • Present weekly updates to the business users about the reports, status, and take note of changes they wish to be made.
    • Construct database and Tables (DDL, DML, DCL), perform database tuning, SQL tuning, and performance planning.
    • Carefully configure both Report Servers to manage paginated reports, mobile reports and KPI’s, allowing clients to consume them using a web browser, mobile device or as an email in their in-box.
    • Participate in Project Management and Software Development Life Cycle (SDLC) including analysis of business function, testing, and documentation, and planning for redesign or transition to another platform.
    • Working as a contact person with clients to work on projects requirement and to apply changes needed.
    • Lead junior team members on Medium to smaller projects
    • Create Dataflows and Data Pipelines.
    • Present the Dashboard functionalities for end user.

  • Business Intelligence/ SSRS Developer

    Colaberry Inc
    September 2018 - October 2020

    • Transform complex business logic into database design and maintain it by using SQL objects like Stored Procedures, UDFs, Views, T-SQL scripting, and jobs.
    • Design SSIS packages to validate, import and transform data between databases and external data sources using various transformations like Data conversion, File system task, Row counts, OLE DB Command, Merge Join, Look up, Sort, Data flow task.
    • Designed & developed SSRS dashboards, Identified and worked with multi-value parameterized reports.
    • Experience in using T-SQL for developing complex Stored Procedures, Tables, Views, User-Defined Functions.
    • Generate Sub-Reports, Drilldown, Drill-through, and Parameterized reports using SSRS.
    • Created and maintained Database Objects (Tables, Stored procedures, functions) in SQL.
    • Scheduled, maintained, and supported the distribution and access to reports at Server level.
    • Configured and maintained Report Manager and Report Server for Power BI Gateway and SSRS.