FREDRICK LAPYEM

FREDRICK LAPYEM

Data Visualization Engineer

Lewisville, Texas, United States.

About  

I've built extensive knowledge and expertise in analytics, consistently transforming complex data into actionable insights that drive decision-making. I thrive in optimizing data processes and delivering impactful BI solutions. I’m confident that my hands-on experience and proven ability to quickly adapt and deliver results, will allow me to assimilate with ease into your team and immediately contribute to the ongoing success of your data operations.

Hours Available / Wk - 40 hrs

Watch Video Pitch

Employment History 

  • Data Visualization Engineer

    Colaberry Inc
    January 2020 - Present

    Power BI Development:
    - Design, develop, and deploy interactive Power BI dashboards and reports.
    - Implement data models, DAX calculations, and visualizations in Power BI to support business needs.
    - Optimize Power BI performance and ensure data accuracy and integrity.

    SQL & Database Management:
    - Write complex SQL queries to extract, transform, and load (ETL) data from various sources.
    - Manage and optimize database performance, including Azure SQL databases.
    - Collaborate with database administrators to ensure data security and compliance.

    SSIS, SSRS, and SSAS Expertise:
    - Develop and maintain ETL processes using SQL Server Integration Services (SSIS) for data integration.
    - Create and manage reports using SQL Server Reporting Services (SSRS) to meet business requirements.
    - Design and deploy OLAP cubes and multidimensional models with SQL Server Analysis Services (SSAS).
    Cloud & Azure Integration:
    - Leverage Azure databases and cloud services to build scalable and secure BI solutions.
    - Integrate cloud data sources with on-premises systems and ensure seamless data flow.

    Python Scripting:
    - Utilize basic Python programming for data manipulation and automation tasks.
    - Integrate Python scripts within BI solutions to enhance functionality.

    Microsoft Fabric:
    - Implement and manage data pipelines using Microsoft Fabric to support BI processes.
    - Collaborate with cross-functional teams to integrate Fabric with other Microsoft tools and services.

    Collaboration & Leadership:
    - Work closely with business stakeholders to gather requirements and translate them into BI solutions.
    - Mentor junior developers and provide technical guidance to the BI team.
    - Stay updated on the latest BI technologies and best practices.