toptal.com
Contact us: +1.888.604.3188
Paul B. Felix, Data Warehousing Developer in Austin, TX, United States
Paul B. Felix

Data Warehousing Developer in Austin, TX, United States

Member since January 21, 2016
Paul has over 17 years of experience building business intelligence and data warehouse solutions. He is a SQL Server platform expert and has implemented many business intelligence and data integrations solutions across a variety of industries. Paul is the founder and creator of the LeapFrogBI SaaS Agile data warehouse automation platform.
Paul is now available for hire
Hire Paul

Portfolio

  • LeapFrogBI LLC
    SQL Server DB, SSIS, SSRS, SSAS, .NET, Azure, Power BI, LeapFrogBI, O365
  • Catapult Systems
    SQL Server, .NET, LeapFrogBI, SSIS, SSRS, SSAS Tabular, Performance Point...
  • MeLLmo (SAP Owned)
    iOS, SQL Server DB, SSRS, SSIS, SSAS, OBIEE, QlikView, Kapow, Cognos...

Experience

  • Business Intelligence (BI), 17 years
  • Dimensional Modeling, 17 years
  • ETL, 17 years
  • Data Warehousing, 17 years
  • Microsoft SQL Server, 15 years
  • T-SQL, 13 years
  • Agile Software Development, 12 years

Location

Austin, TX, United States

Availability

Part-time

Preferred Environment

Windows, SQL Server, .NET, TFS

The most amazing...

...product I've created is the LeapFrogBI data warehouse automation platform.

Employment

  • Data Warehouse Architect

    2010 - PRESENT
    LeapFrogBI LLC
    • Designed and developed the LeapFrogBI Platform; data warehouse automation targeting SQL Server.
    • Implemented numerous data warehouses and business intelligence front-end solutions for small and large organizations across many subject areas.
    • Provided dimensional modeling training, architectural reviews, and ad hoc support for LeapFrogBI clients.
    • Created cloud BI and data warehouse environments using Azure and Amazon Web Services (AWS).
    • Developed an Agile data warehousing methodology which seeks to reduce costs while speeding development.
    Technologies: SQL Server DB, SSIS, SSRS, SSAS, .NET, Azure, Power BI, LeapFrogBI, O365

  • Senior Consultant - BI/DW Architect

    2012 - 2013
    Catapult Systems
    • Created a data warehouse and business intelligence solution for a healthcare client.
    • Managed a team of analysts, ETL developers, cube developers, and report creators.
    • Served as a data warehousing subject matter expert for numerous projects.
    • Provided dimensional modeling training.
    • Implemented SSAS tabular model cubes to support operational and financial analytics.
    Technologies: SQL Server, .NET, LeapFrogBI, SSIS, SSRS, SSAS Tabular, Performance Point, Excel Services

  • Product Manager

    2010 - 2012
    MeLLmo (SAP Owned)
    • Served as Microsoft BI stack subject matter expert.
    • Implemented mobile BI solutions using the Roambi Server Platform.
    • Created automated data collection processes using Kapow.
    • Designed solutions which interface with numerous APIs.
    • Created data models suited for mobile BI visualizations sourced from OLTP and ad hoc data sources.
    Technologies: iOS, SQL Server DB, SSRS, SSIS, SSAS, OBIEE, QlikView, Kapow, Cognos, Business Objects

  • Senior Consultant - BI/DW Architect

    2009 - 2010
    LiveLogic
    • Served as Microsoft BI/DW subject matter expert.
    • Managed a small team of Houston, TX based consultants.
    • Implemented BI and data warehouse solutions for consumer cosmetics supplies organizations using SQL Server stack.
    • Implemented BI and data warehouse solutions for consumer packaged goods organizations using SQL Server stack.
    • Created predictive models using SSAS data mining and R capable of predicting customer churn.
    Technologies: R, SQL Server DB, SSAS, SSRS, SSIS, Performance Point, SharePoint

  • Senior Consultant - BI/DW Architect

    2008 - 2009
    Freelance
    • Provided end-to-end freelance BI and DW consulting services.
    • Implemented Panorama Software dashboard solution for Healthcare client using SSAS cube source.
    • Created OLAP solution for healthcare clients using clinical OLTP source systems.
    • Provided ongoing support for existing client BI solutions implemented using the SQL Server stack.
    • Troubleshot complex SQL Server performance issues and implemented appropriate solutions.
    Technologies: MS SQL, SSAS, SSIS, SSRS, Panorama Software

  • Solutions Architect

    2008 - 2008
    Panorama Software
    • Provide BI consulting services focused on OLAP based dashboarding using Panorama Software solutions in USA and London.
    • Developed numerous SSAS cubes designed to support risk management and forecasting analytics.
    • Serviced clients across many industries with a focus on insurance, healthcare, and banking services.
    • Supported business development as a sales engineer.
    • Implemented dashboard solution for manufacturing organization using SAP info cubes and Panorama Software.
    Technologies: Panorama, SQL Server, SSAS, SAP, SSIS

  • BI Solution Architect/Traffic Engineer

    2004 - 2008
    Sprint Nextel
    • Designed SQL Server data warehouse with over 3TB of storage.
    • Provided subject matter expertise for OLAP design and development.
    • Designed and developed engineering related dashboards using SQL Server DB and SSAS cube sources.
    • Managed capacity related costs by implementing predictive analytics techniques capable of predicting future demand trends.
    • Created ETL solutions which collected data from numerous source systems and consolidated data into a operational data store.
    Technologies: Oracle, MS SQL, SSAS, SSIS, SSRS, Classic ASP, .NET

  • Branch Manager

    2002 - 2004
    Edward Jones
    • Managed a broker office with over 12 million in assets.
    • Served as series 7 and 63 licensed broker/dealer representative.
    • Focused on products including stock, bonds, notes, mutual funds, and trusts.
    • Prospected for new business leads and maintained the sales pipeline.
    • Conducted group seminars and training, consistently exceeding my sales quota.
    Technologies: Access

  • BI Developer/Traffic Engineer

    1997 - 2002
    Nextel
    • Created original Nextel executive scorecards.
    • Designed and developed an engineering based reporting solution using classic ASP.
    • Create data warehouse using Oracle nested tables. Source systems included call detail records and operational measures.
    • Created a rules engine based performance automation solution credited with saving over 10 million dollars in hardware costs.
    • Monitored & maintain telecom capacity related service levels using Unix source systems.
    Technologies: Informix, Unix, Oracle, MS SQL, Access, Excel, Classic ASP

  • Sergeant - MOS 0331 Machine Gunner

    1992 - 1997
    United States Marine Corps
    • Operated as company level machine gunner attached to 2nd Battalion 5th Marines.
    • Deployed with Marine expeditionary unit (special operations capable).
    • Provided combatant support in operation Restore Hope (Mogadishu, Somalia).
    • Trained Royal Saudi Arabia Marines in operation Red Reef V.
    • Served as presidential guard at White House Communications Agency.
    Technologies: M60, 9mm, M16

Experience

  • Microsoft Certifications (Other amazing things)

    MCITP - SQL Server 2005 BI Developer (2005)
    MCTS - SQL Server 2005 BI Implimentation (2005)
    MCTS - SharePoint 2007 Application Development (2007)
    MCTS - SharePoint 2007 Configuration (2007)
    MCTS - SQL Server 2008 BI Implimentation (2008)
    MCITP - SQL Server 2008 Database Administrator (2008)
    MCITP - SQL Server 2008 BI Developer (2008)
    MCTS - SQL Server 2008 Implimentation and Maintenance (2008)
    MCSE - SQL Server Business Intelligence 2012 and 2014 (2012)
    MCSE - SQL Server Data Platform 2012 and 2014 (2012)
    MCSA - SQL Server 2012 (2012)

  • Microsoft Exams (Other amazing things)

    .NET Framework Development Exam (2007)

  • Total Data Warehouse Institute (TDWI) Certifications (Other amazing things)

    CBIP - Certified Business Intelligence Professional (2008)

Skills

  • Languages

    SQL, T-SQL, MDX, HTML, Visual Basic .NET (VB.NET), C#, R

  • Tools

    SSAS, Microsoft Power BI, Microsoft Visual Studio

  • Paradigms

    ETL, Business Intelligence (BI), Dimensional Modeling, Agile Software Development, Database Development, OLAP

  • Platforms

    Azure, Amazon Web Services (AWS), Windows, SharePoint

  • Storage

    SQL Server Reporting Services (SSRS), Microsoft SQL Server, SQL Server Analysis Services (SSAS), Data Integration, SQL Server Integration Services (SSIS), SSAS Tabular, SQL Server Management Studio

  • Other

    Data Warehousing, Data Modeling, LeapFrogBI, Software Development, Power BI

  • Frameworks

    .NET 4, ASP.NET, .NET

  • Libraries/APIs

    NetSuite API, Salesforce API

Education

  • Master's degree in Business Adminstration
    2004 - 2008
    University of Phoenix - Texas
  • Bachelor's degree in Behavioral and Social Science
    1997 - 2001
    University of Maryland UC - Maryland

To view more profiles

Join Toptal
I really like this profile
Share it with others
Hire the top 3% of freelance developers TM