Scroll To View More
Hire the top 3% of freelance developers
toptal.com
Call us: +1.888.604.3188
Paul B. Felix, T-SQL Developer in Austin, TX, United States
Paul B. Felix

T-SQL 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

  • ETL, 17 years
  • Dimensional Modeling, 17 years
  • Business Intelligence (BI), 17 years
  • Data Warehouse, 17 years
  • Microsoft SQL Server, 15 years
  • T-SQL, 13 years
  • Agile Software Development, 12 years
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, VB.NET, C#, R

  • Tools

    SSAS, Microsoft Power BI, Visual Studio

  • Paradigms

    ETL, Dimensional Modeling, Agile Software 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 Warehouse, Business Intelligence (BI), Data Modeling, LeapFrogBI

  • 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
Hire the top 3% of freelance developers
toptal.com
Call us: +1.888.604.3188
To view more profiles, join ToptalJoin Toptal
I really like this profile
Share it with others