SUMMARY:

• Senior Business Intelligence consultant/developer/analyst with 19 years experience utilizing the Confidential BI Stack. Expert T - SQL/SSAS/SSRS/SSIS/Power BI architect & developer. Skilled at redesigning & optimizing SSAS OLAP cubes and data warehouses for performance & the most effective user experience.
• Talented and experienced in the transformation of raw data into actionable business intelligence across the entire BI lifecycle, from requirements gathering to coding to presentation layer, enabling users to more effectively drive new & existing business initiatives across the enterprise. Strong proponent of self-service business intelligence.
• Tableau Desktop 10 Qualified Associate Certification
• Expert at developing KPIs & metrics to a) accurately measure an organization's business and b) provide actionable intelligence.
• Expert at report performance enhancements (for speed & accuracy), as well as dashboard/scorecard/report layout redesign for maximum readability and usefulness.
• Effective communicator with Director level experience comfortable interfacing with all levels of an organization, from CxO & VP executives to middle managers to individual contributors.
• Confidential SQL Server Reporting Services (SSRS) 2016 - 2000 (BI & BISM Stack)
• Confidential Excel 2016 - 95 (DAX, pivot tables, advanced analytics, external data connectivity, rapid adhoc development)
• Confidential Power BI, Power BI Desktop, PowerView, PowerQuery, PowerPivot, Azure SQL
• Tableau 10/8.1/8/7/6 (including development for iPad & Android dashboards) - Tableau Desktop 10 Qualified Associate Certification
• Pyramid Analytics (bioXL, bioPOINT, bioWRITER)
• Cognos ReportNet & PowerPlay
• Crystal Reports & Enterprise 11 - 6.0
• Xcelsius Workgroup & Professional
• Confidential PerformancePoint - Planning / Monitoring & Analytics (M&A)
• Confidential Access 2016 - 95 applications (full self contained applications with forms, reports, data connectivity, email, VBA)
• Confidential SQL Server 2016 - 97
• Integration Services (SSIS) & Data Transformation Services (DTS), complex ETL transformations
• Analysis Services (SSAS) - OLAP cubes & Tabular Models up to Petabyte size, Galaxy/Star/Snowflake/Hybrid schemas
• Confidential Sharepoint Integration - SSRS, PowerView, PowerPivot model development & deployment
• Cognos Transformer (including pass through connections to SSAS OLAP cubes)
• Cognos Query Studio
• ETL Architecture (Slowly changing dimensions, normalization/denormalization, star/snowflake schema, DW/Datamart)
• Kimball & Inmon methodologies
• Third party data broker integration (Dun & Bradstreet, Experian, Harte-Hanks)
• T-SQL expert, query optimization, highly complex stored procedures, CTE/subquery/temp tables
• Azure COSMOS DB SQL
• MDX & DAX, VBA
• OLEDB/ODBC/ADODB/Jet drivers
• SCOPE (for COSMOS)
• SOQL for Salesforce
• OData for Restful API
• HTML/CSS
• PHP (SQLSRV & pdo MySQL data connectivity)
• JSON, Properly formatted XML
• Business Intelligence/IT Director & Manager
• CRM, Business Intelligence & Data Warehouse Manager
• Senior developer and team lead
• Requirements gathering
• Metrics development
• Database documentation & data dictionary development
• Datamart development & deployment
• Data & report migration & conversion experience between systems, versions, applications, departments
• (MSSQL upgrades, Access, Sybase, MySQL, Oracle → SQL Server, Cognos, Microstrategy, Excel → SSRS) to MS platforms
• Data hygiene & validation
• Agile & Scrum
• High tech (software industry, 10+ years within Confidential as an employee & consultant)
• Aerospace
• Biotech & health care
• Real Estate (builder, broker)
• Nonprofit
• Manufacturing
• Operations & Logistics
• Sales (leading and lagging KPIs, trending, forecasting, YoY, MoM, QoQ, heat maps, geographic analysis (GIS), P&L)
• Marketing (campaign management & analysis, ROI, competitive analysis, audience segmentation, HTML email automation)
• Customer Relationship Management
• Human Resources
• Confidential BI Stack (SQL 2016, SSIS, SSRS, SSAS, PowerPivot, PowerView, BISM, Sharepoint integration)
• Confidential Dynamics (CRM, GP) data extraction for reporting
• Confidential Project Server 2013 data extraction for reporting
• ERP: NetSuite, JD Edwards, Confidential Dynamics, Oracle EBS 11 reporting (AP/AR/GL/OM/PAY/PER)
• MySQL, Navicat, SQLPro
• Accela Land Management (Civic planning & permitting)
• VitalAxis LIS/LIMS
• Orchard Copia LIS/LIMS
• Onyx CRM
• Siebel CRM (6 - 7.8)
• Lawson ERP
• JD Edwards
• Axapta (Pre- Confidential Dynamics AX)
• Ceridian HR/Payroll
• ADP
• Peregrine/Remedy
• Pyramid Analytics
• Quickbooks
• Sage Peachtree
• Nuance Outbound/Varolii (Automated communications)
• Confidential /Outerwall/Redbox (Retail, Redbox, Prepaid, Coin Op, Business Intelligence management & development)
• Matsushita Avionics/Panasonic (Repair management, airline support, report development, database development, CRM management (Onyx))
• Smiths Industries Aerospace (Avionics repair management, report development)
• Gates Foundation (report development)
• Delta Dental (report development)
• Various contract & subcontract projects (all business intelligence reporting & data warehousing)

WORK HISTORY:

SENIOR BUSINESS INTELLIGENCE CONSULTANT/ARCHITECT

Confidential, Redmond, WA

Responsibilities:

• Create consolidated Revenue/P&L architecture utilizing internal sources: MSSales (Amazon/Crymea), MARS/Mercury and proprietary profit center mapping tables
• Re-architect existing SSAS 2014 OLAP cube (60 feeds, 70 fact tables, 120+ dimensions)
• Design & develop SSAS 2016 financial analytics cube/ SQL 2016 data warehouse for Omni-channel retail store reporting
• Migrate on-premises data warehouse & cubes to Azure cloud environment
• Prepare and distribute confidential high visibility dashboard

SENIOR BUSINESS INTELLIGENCE CONSULTANT

Confidential, Seattle, WA

Responsibilities:

• Sole responsibility of maintaining & enhancing all aspects of Confidential Business Intelligence Stack corporate infrastructure
• Rapidly develop complex SSRS reports from customer description, modify existing reports
• Develop and modify existing extremely complex SQL code (parameterized stored procedures, schema-bound views, table variables, temp tables, CTE, linked servers)
• Design and develop SSIS packages utilizing data from SQL Server, SalesForce, RemedyForce, .csv, Sharepoint, Active Directory)
• Create & manage Odata connections between Confidential Azure and Varolii SFDC instance for data integration
• Design & develop Excel pivot tables & PowerPivot tables for quick data requests and report mockups
• Work with network team to troubleshoot domain migration issues
• Serve as MSSQL point for migration to Oracle corporate ERP system
• Integrate Oracle downstream ETL feeds into existing MSSQL data warehouse
• Assist financial team with monthly revenue reconciliation and troubleshoot outliers (rapid adhoc queries, adhoc pivot tables, analysis, issue resolution)
• Function as SQL DBA for all security and operational maintenance (database backups, migrations, permissions)
• Support SOX compliance procedures and audit requests

BUSINESS INTELLIGENCE CONSULTANT

Confidential, Massachusetts & Georgia

Responsibilities:

• Integrate 2 laboratory information systems into data warehouse without a formal project plan
• Migrate Microstrategy, Excel & SSRS reports to Tableau
• Reverse engineer reports from static JPG images, recreate SQL, validate data, duplicate report formats in Tableau
• Rapidly develop Excel 2013 pivot tables for user feedback, create final production report in Tableau
• Develop complex Tableau reports (user filters, hierarchies, calculations, parameterized stored procedures for performance)
• Create data dictionary and rapidly develop datamart architecture from undocumented databases
• Create ETL (SSIS) and jobs to transform data from productions systems to de facto data warehouse & datamarts
• Develop plan & run pilot project to enable self-service BI to relieve reporting bottleneck at a manufacturing corporation
• Identify knowledge gaps in current reports across 5 departments (accomplished in 5 days)
• Rapidly develop PowerPivot models, publish BISM to Sharepoint for analysis & feedback, promote final version to SSAS tabular model
• Develop Pyramid Analytics analytic workbooks from SSAS tabular models
• Develop PowerView dashboards for Sharepoint
• Train staff on use of PowerView & PowerPivot

SENIOR BUSINESS INTELLIGENCE ARCHITECT

Confidential, Redmond, Washington

Responsibilities:

• Daily use of new SQL Server 2012 BI Stack features: PowerView, Tabular Models, SQL Server Data Tools, Report Designer, Columnar Indexing for superior performance
• SSIS ETL to transform .csv/Feedstore/SQL/OLAP cube/COSMOS/Project Server database feeds into DW & datamarts
• Enhance existing BI infrastructure (SSIS packages, SQL queries, SSRS reports, SQL database performance)
• Quickly develop ad-hoc SQL & MDX queries from undocumented data sources
• Quickly design & develop ad-hoc & production pivot tables
• Quickly troubleshoot and resolve ETL job errors
• Develop Excel 2013 PowerPivot reports to enable customer self-service
• Develop adhoc Access 2013 databases for formatted data capture
• Create threshold validations to capture potential inaccuracies
• Modify existing scorecard and dashboards
• Work with upstream and downstream feeds to resolve ETL concerns and problems

BUSINESS INTELLIGENCE CONSULTANT

Confidential, Nevada, Missouri & Michigan

Responsibilities:

• Develop SQL Server database architecture to support Crystal Xcelsius Dashboards for clients
• Quickly create SSIS packages to onboard new ETL feeds
• Create properly formed XML output from parameterized SQL stored procedures
• Work with web host to deploy database changes
• Troubleshoot ETL issues between database and web front-end content
• Architect & develop OLAP cubes to feed Cognos Query Studio & Report Studio
• Develop Cognos ReportNet dashboard & reports via SSAS OLAP connections
• Travel to customer sites for sales support and requirements gathering

SENIOR MANAGING CONSULTANT, BUSINESS INTELLIGENCE

Confidential, Redmond, Washington

Responsibilities:

• Various business intelligence projects at Confidential within Confidential, corporate finance, Zune, MS Surface and Windows groups
• Designed & developed scorecards for various organizations (including Steve Ballmer’s executive team)
• Developed complex SSIS packages to transform flat files & SQL database feeds into data warehouse and datamarts
• Developed MSAS OLAP cubes to feed PerformancePoint, SQL Reporting Services and ProClarity reporting interfaces
• Worked with multiple terabyte databases with billion+ sized recordsets
• Redesigned 500+TB Confidential Customer Intelligence OLAP cube for better performance, faster processing, friendlier dimensional design
• Served as the senior mentor/problem solver for the SQL, Integrations Services, OLAP & Reporting Services developer teams

REPORTING ANALYST

Confidential, Redmond, Washington

Responsibilities:

• Created SQL 2005 Reporting Services reports for group dashboard
• Transitioned reports from Excel & ASP to SQL 2005 Reporting Services
• Created Confidential Access 2007 applications to capture formatted data, synchronize into remote master for centralized analysis
• Created SSIS packages to denormalize data into consumable format
• Developed stored procedures to dynamically feed SRS reports
• Designed flexible ODBC Excel pivot table mock ups for signoff before SRS development investment

BUSINESS INTELLIGENCE MANAGER

Confidential, Bellevue, Washington

Responsibilities:

• Managed team of 5 database administrators, report developers and a data warehouse architect, 4 contractors.
• Daily interaction with executives in all departments to develop dashboards & reports, and to assist in their interpretation
• Architected & rolled out Confidential ’s first data warehouse using Cognos ReportNet based on MS OLAP cubes
• Designed & developed corporate and divisional dashboards for all revenue generating groups
• Designed and developed “what-if” analysis tools for all cost center groups to help control costs
• Migrated corporate reporting from Cognos to Confidential SQL 2005 Reporting Services
• Created, deployed & managed 200+ high-quality (charts, collapse/expand, drilldown) SRS reports over a 9 month period
• Created a user-friendly data dictionary, enabling customers to understand the data much more effectively
• Integrated historical data from acquisitions, directed ETL process to provide nightly updates from the field
• Developed first comprehensive slice & dice analysis of all revenue & partner/customer payments
• Provided OLAP tool to empower marketing management to analyze campaign success both regionally & nationally
• Integrated marketing intelligence from Trade Dimensions (similar to D&B) allowing strong insight into geo & retail patterns

CRM DATABASE PROJECT MANAGER

Confidential, Redmond, Washington

Responsibilities:

• Created multiple dynamic scorecards & dashboards using a variety of BI stack and cutting edge technologies
• Developed, shared & consulted on code development for Global Marketing Platform Customer Intelligence tool
• Primary responsibility performing all technical functions related to monthly internal CRM Scorecard production
• Worked with regional subsidiaries to reconcile corporate CRM metrics with local regional variations
• Enhance existing components of CRM Scorecard both aesthetically and from a data quality standpoint
• Assist CRM Analytics Database Project Manager into research and understanding of fluctuations in the CRM Scorecard
• Recommend new metrics & reports based on needs of the customer, knowledge of CRM and data mining findings
• Perform quick, accurate ad-hoc analysis into SQL Server, Siebel, Epiphany datamarts and generate understandable results
• Specify technical requirements and build ad-hoc data capture mechanisms using available Confidential technologies
• Quickly developed expert understanding of Confidential 400GB customer database schema and data quality considerations & caveats
• Trained 2 contract resources on the MSO database schema and business logic behind published team metrics

BUSINESS DATA ANALYST

Confidential, Seattle, Washington

Responsibilities:

• Perform mapping & conversion role in new Legal application implementation (Mitratech CLMS to MitratechTeamConnect Enterprise)
• ODBC link to Oracle database to retrieve old & new values
• Import XML data from vendor tool to assist in list (lookup) value mapping from old to new
• Create final mapping data document for vendor to perform
• Developed Confidential Access 2000 “friendly” application to allow non-technical legal personnel to assist in mapping process

SENIOR PROGRAMMER ANALYST

Confidential, Seattle, Washington

Responsibilities:

• Transform dental data from 13 member Delta Dental plans from a variety of formats into SQL Server via DTS packages
• Create, validate & feed OLAP cubes for subscription clientele
• Report via Crystal Enterprise, Office Web Components, native ASP
• Create Access front end to allow simple, quick, repetitive SQL query for non-technical dental personnel (epidemiologists)
• Troubleshoot clientele issues to resolve reporting errors (ODBC, connection)
• Quickly develop complex ad-hoc reports at customer request

REPORT DEVELOPER

Confidential, Seattle, Washington

Responsibilities:

• Analyze & understand custom Remedy implementation
• Review management report requests, design & build 20 new Crystal Reports (8.5 & Enterprise) for Remedy IT Support tool
• Repair 12 nonworking existing Crystal Reports

DIRECTOR OF INFORMATION TECHNOLOGY, BUSINESS INTELLIGENCE MANAGER

Confidential, Bellevue, Washington

Responsibilities:

• Created interactive executive and management level reports for HR, Payroll & Finance via Access/Excel/SQL Server ODBC
• Decreased corporate benefits billing time from 30+ man hours per month to one-click Confidential Access 2000 application
• Initial hire primary responsibility of creating functional reporting solutions for HR & Accounting departments
• Promoted after 4 months to rebuild entire corporate reporting structure & executive dashboard
• Secondary responsibility of end-user support for training/problem resolution with front end Ceridian/SUN products
• Awarded prestigious President’s Award for enabling access to corporate data across the organization