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
    August 2021 - 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 AND SSRS 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.
    - 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.

  • SQL/Power BI Developer

    WebTPA
    June 2020 - August 2021

    Power BI Expertise:
    - Applied advanced techniques such as data blending, intricate joins, and optimizing table relationships to create compelling reports and dashboards.
    - Utilized Power BI\'s capabilities to generate actionable filters, parameters, groups, and hierarchies, enhancing dashboard interactivity.
    - Created reports from the Data Warehouse utilizing Power BI, adapting to various reporting requirements.

    SQL Server & Database Management:
    - Developed reports leveraging T-SQL queries, user-defined functions, stored procedures, CTEs, temporary tables, and views, consistently improving SQL query performance.
    - Analyzed and troubleshot reporting issues, including data discrepancies, performance bottlenecks, and incorrect report outputs.

    SSIS & SSRS Expertise:
    - Partnered closely with analysts and department leaders to design, construct, and customize reports using SQL Server, SSIS, SSRS, and Power BI.
    - Designed, developed, and maintained robust SSIS packages with error handling procedures to ensure accuracy and reliability.
    - Created reports from the Data Warehouse utilizing SSRS and Power BI.

    Collaboration:
    - Collaborated with business users to gather and document reporting requirements, ensuring reports provide actionable insights and support decision-making.

Digital Credentials  

Schedule an Interview