Data Warehouse Architect
2010 - PRESENTLeapFrogBI 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: Office 365, Microsoft SQL Server, LeapFrogBI, Microsoft Power BI, Azure, .NET, SSAS, SSRS, SQL Server Integration Services (SSIS)Senior Consultant - BI/DW Architect
2012 - 2013Catapult 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: Excel Services, PerformancePoint, SSAS Tabular, SSRS, SQL Server Integration Services (SSIS), LeapFrogBI, .NET, Microsoft SQL ServerProduct Manager
2010 - 2012MeLLmo (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: Microsoft SQL Server, BusinessObjects, Cognos 10, Kapow, QlikView, Oracle Business Intelligence Enterprise Edition 11g (OBIEE), SSAS, SQL Server Integration Services (SSIS), SSRS, iOSSenior Consultant - BI/DW Architect
2009 - 2010LiveLogic- 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: Microsoft SQL Server, SharePoint, PerformancePoint, SQL Server Integration Services (SSIS), SSRS, SSAS, RSenior Consultant - BI/DW Architect
2008 - 2009Freelance- 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: SSRS, SQL Server Integration Services (SSIS), SSAS, Microsoft SQL ServerSolutions Architect
2008 - 2008Panorama 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: SQL Server Integration Services (SSIS), SAP, SSAS, Microsoft SQL ServerBI Solution Architect/Traffic Engineer
2004 - 2008Sprint 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: .NET, Classic ASP, SSRS, SQL Server Integration Services (SSIS), SSAS, Microsoft SQL Server, OracleBranch Manager
2002 - 2004Edward 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: Microsoft AccessBI Developer/Traffic Engineer
1997 - 2002Nextel- 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: Microsoft Excel, Classic ASP, Microsoft Access, Microsoft SQL Server, Oracle, Unix, IBM InformixSergeant - MOS 0331 Machine Gunner
1992 - 1997United 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.