Jason Earl Lopez, Data Analytics and Visualization Developer in New Berlin, WI, United States
Jason Earl Lopez

Data Analytics and Visualization Developer in New Berlin, WI, United States

Member since February 12, 2022
Jason is an experienced data and analytics architect specializing in projects involving the Microsoft BI Stack, Azure infrastructure, and a variety of data visualization tools. He has successfully implemented solutions in industries ranging from marketing and genetics to insurance and logistics. His curiosity and insight into business result in an intimate understanding of client needs and his technical expertise translates those needs into best-in-class products.
Jason is now available for hire

Portfolio

Experience

Location

New Berlin, WI, United States

Availability

Part-time

Preferred Environment

DevOps, SQL, Microsoft Power BI, Azure Data Factory, Azure Cosmos DB, Azure Machine Learning, Tableau, CI/CD Pipelines, Visio, Microsoft PowerPoint

The most amazing...

...project outcome I've had was when the results of at-risk member quality of life surveys improved by 20% through engagement driven by my analytics.

Employment

  • Enterprise Data Architect

    2020 - PRESENT
    Neugen Health
    • Promoted from SQL developer to lead data architect within three months.
    • Developed a methodology to support a new analytics practice, including standard request flows, user training, accepted data science methodologies, dissemination, and situation report designs.
    • Took ownership of database development due to API performance issues. Proposed a new design pattern, led the development efforts, and successfully implemented the newly designed assets under budget and before the initial deadline.
    • Integrated database development team seamlessly into SDLC.
    • Introduced the first organization analytics dashboard and Power BI data models.
    • Redesigned the entire database structure to support a member portal supporting up to 500,000 users.
    • Led data migration efforts and designed infrastructure to capitalize on Azure services.
    Technologies: Azure SQL, Azure Logic Apps, Azure Data Factory, Azure Service Bus, Infrastructure as Code (IaC), Azure Resource Manager (ARM), Azure Cosmos DB, Azure Machine Learning, SQL, SQL Server Integration Services (SSIS), Microsoft Power BI, Visio, Embarcadero RAD Studio, SQL Server Profiler, Memory Optimization, OLAP, In-memory Databases, OLTP, CI/CD Pipelines, Build Pipelines, GitHub, Process Flows, Microsoft PowerPoint, Data Modeling, APIs, DevOps, Dashboards, Microsoft SQL Server, Linear Regression, Data Science, DAX, Data Analytics, Analytics, T-SQL, SQL Stored Procedures, Scrum, Data Visualization, Architecture, Database Performance, Classification, Data Engineering, XML, ETL Tools, Healthcare Services, Healthcare & Insurance, Machine Learning, Azure, Database Design, Relational Databases, Databases, API Connectors, Best Practices, ETL, Data Migration
  • Business Intelligence Architect

    2020 - 2021
    Neighborhood Analytics
    • Analyzed the existing database, ETL, and analytics infrastructure and processes.
    • Presented stakeholders with assessment conclusions and a framework for implementing recommended changes within one year.
    • Interfaced with the development team, business users, and stakeholders to conceptualize three enterprise-level Proof of Concept (POC) addressing organizational data and analytics needs.
    • Assisted organization in identifying and prioritizing project work related to infrastructure and development required for analytics product implementations affecting 10 departments.
    • Designed complex process flows, infrastructure diagrams, and data models for a final executive-level architecture proposal.
    Technologies: Microsoft Power BI, SQL, Agile, Assessment Development, Risk Assessment, Findings & Recommendations Reports, Training, Proof of Concept (POC), Data Flows, Systems Analysis, Process Analysis, Project Estimation, Dashboards, Microsoft SQL Server, DAX, Data Analytics, Analytics, T-SQL, Team Mentoring, Coaching, Budgeting, Data Visualization, Data Engineering, ETL Tools, Machine Learning, Azure, Database Design, Relational Databases, Databases, ETL
  • Senior Analytics Engineer

    2020 - 2020
    Skyline Technologies
    • Developed short, medium, and long-term project goals that align with organizational strategic objectives.
    • Led the design and development of cloud-based solutions utilizing DevOps, Data Factory, Azure SQL, Azure Analysis Services, and Power BI.
    • Provided expertise and analytics to facilitate a well-informed decision-making process.
    • Developed presentations to explain and advocate for technical solution related to data and analytics.
    • Translated business requirements into technical specifications for project planning.
    Technologies: SSAS Tabular, Microsoft Power BI, SQL Server Integration Services (SSIS), Agile, DevOps, CI/CD Pipelines, BIML, Technical Requirements, User Requirements, Presentations, Architecture, Azure Data Factory, Azure SQL Databases, Dashboards, Microsoft SQL Server, DAX, Data Analytics, Analytics, T-SQL, Scrum, Budgeting, Data Visualization, Database Performance, Data Engineering, ETL Tools, Tableau Desktop Pro, Healthcare Services, Healthcare & Insurance, Azure, Database Design, Relational Databases, Databases, API Connectors, ETL, Data Migration
  • Lead Business Intelligence Engineer

    2017 - 2020
    GMR Marketing
    • Designed enterprise cloud (Azure) infrastructure including database, ETL, semantic layer and data visualizations (SQL, Microsoft Data Transformation Services (now SSIS), Azure Data Factory, Azure Analysis Services, Tableau, and Power BI).
    • Gathered business requirements as baseline for the design of an analytics infrastructure for a new line of business.
    • Designed and implemented an automated and fully managed cloud ETL infrastructure using BIML framework, T4 templates, Microsoft Data Transformation Services (now SSIS), Azure Data Factory, and Azure Integration Runtime.
    • Designed an enterprise data warehouse, Data Marts, and data models to facilitate analysis across multiple functional areas.
    • Established standards defining the Cloud-based semantic data layer attributes, data governance, and presentation methodologies.
    • Devised, documented and drove implementation of short, medium, and long-term strategic goals.
    • Managed team workflow and projects within an Agile framework.
    • Built infrastructure diagrams, process flows, relationship models, and other documentation for stakeholder presentations to ensure business continuity.
    Technologies: Azure SQL, Azure Data Factory, SSAS Tabular, BIML, Planning, Budgeting, Coaching, SQL Server Integration Services (SSIS), Presentations, Dashboards, Microsoft SQL Server, Linear Regression, Data Science, DAX, Data Analytics, Analytics, T-SQL, SQL Stored Procedures, Data Visualization, Database Performance, Classification, Data Engineering, XML, ETL Tools, Tableau Desktop Pro, Tableau Server, Funnel Analysis, Machine Learning, Azure, Database Design, Relational Databases, Databases, API Connectors, Best Practices, ETL, Data Migration

Experience

  • Neugen Analytics Practice Implementation
    https://drive.google.com/drive/folders/1FbheUTkSD_G8D6ph-dQuv-FEJwFHjJ3v?usp=sharing

    During this implementation, I was tasked with creating an analytics practice from the ground up. This included the design of the Software Development Life Cycle (SDLC), the creation of visualization standards, data modeling, CI/CD pipelines, and the implementation of Azure infrastructure.

  • Consumer Engagement Application & Analytics Initiative
    https://docs.google.com/presentation/d/1iJ-3ieLQSmGK_ek9XZN4R6Sz0-NoMkIL/edit?usp=sharing&ouid=101185391971638225920&rtpof=true&sd=true

    Designed an end-to-end solution to support a mobile application used to engage consumers to support the marketing funnel. The system included metadata-driven ETL via BIML, Azure SQL databases, Azure Data Factory pipelines, DevOps CI/CD, and an Azure Analysis Services tabular model. The result was a series of Tableau dashboards used to measure the results of A/B testing, provide insights into demographic-based marketing techniques, and manage the workflow of field marketing experts.

  • Waukesha County COVID-19 Reporting Assessment
    https://drive.google.com/drive/folders/1FproZMAtxVMh5dLLlRhFJaEUu-9ddfNs?usp=sharing

    An assessment of a local municipality's COVID-19 reporting infrastructure, including data warehouse architecture, ETL processes, Power BI reporting, and workflow processes. The results of this assessment were presented as a detailed set of recommendations supplemented with information about the criticality of each and the ROI expected from implementing the prescribed changes.

Skills

  • Languages

    SQL, T-SQL, BIML, XML, C#, R
  • Tools

    Visio, Microsoft PowerPoint, GitHub, Microsoft Power BI, Tableau, Azure Logic Apps, SQL Server Profiler, Tableau Desktop Pro, Azure Machine Learning
  • Paradigms

    Database Design, ETL, DevOps, OLAP, Agile, Scrum, Data Science, Best Practices
  • Platforms

    Azure
  • Storage

    Azure SQL, SQL Server Integration Services (SSIS), Azure SQL Databases, SQL Stored Procedures, Database Performance, Microsoft SQL Server, Relational Databases, Databases, In-memory Databases, OLTP, SSAS Tabular, Azure Cosmos DB
  • Other

    Azure Data Factory, Process Flows, Data Modeling, Presentation Design, IT Projects, Architecture, Data Visualization, Assessment Development, Findings & Recommendations Reports, Technical Requirements, User Requirements, Presentations, Analytics, Data Analytics, Dashboards, Data Engineering, ETL Tools, Healthcare Services, Healthcare & Insurance, Data Migration, CI/CD Pipelines, Memory Optimization, Build Pipelines, Azure Synapse, Proof of Concept (POC), Process Analysis, Project Estimation, Planning, DAX, Linear Regression, Classification, Tableau Server, Funnel Analysis, Machine Learning, API Connectors, Azure Service Bus, Infrastructure as Code (IaC), Azure Resource Manager (ARM), Embarcadero RAD Studio, APIs, Software Development, Power Shell Commands, Risk Assessment, Training, Data Flows, Systems Analysis, Budgeting, Coaching, Team Mentoring, Goal-directed Design, Agile DevOps, Research & Investigation, Value Analysis, ROI

Education

  • AASD in Software Applications & Programming
    2002 - 2004
    ITT Technical Institte - Greenfield, WI, USA

To view more profiles

Join Toptal
Share it with others