Steve Hicks Email & Phone Number

California, United States

BI Architect & executive business analyst responsible for leading deployments of entire BI Stack via SAP BusinessObjects and Qliktech, and Tableau.• ENTERTAINMENT • Created SAP BODS Data Warehouse, Universe, & Webi Reports containing over 100 million records and billions of dollars. Trained over 60 business users via webinar. Achieved a 35%-75% weekly user adoption rate. Deployed Mobile BI to iPhone and iPad. Created Teradata DW with Tableau Security Model & Datasources exposing hundreds of millions of records to 240+ Creators, Explorers, Viewers. • HUMAN RESOURCES • Deployed Tableau & created data warehouse & visualizations. Correlated rising Tableau user-adoption directly with a dozen lead-measure KPIs for 45k employees.• ENERGY • Technical Lead for team of DBA's, Analysts, and SME's to create SAP Dashboards with supporting Smart Meter database with millions of records. Embedded QaaWS and location based Centigon Gmaps to provide Technician, Operator, and Supervisor end-users with visually stunning, interactive visualization tools for locating, diagnosing, and troubleshooting Residential, Commercial, and Industrial electrical grid issues. • CONSUMER STAPLES • Grew 4 person team to 11 SAP dashboard developers. Standardized Dashboard SDLC development methodology for a Business Warehouse (BW) based data set using BEX queries.• DEFENSE • Analyzed business processes and diagramed workflows of multiple executive reporting methods for the US ARMY. Converted existing word, excel, and powerpoint reports containing 0% structured-data into SAP BusinessObjects reports containing 100% structured-data. Created interactive SAP Xcelsius dashboards for weekly and monthly executive briefings. Xcelsius/BEX query visualizations. Counseled IT dept. on CAC SSO integration.• AUTOMOBILE • Created in-memory interactive Qlikview dashboard referencing 3,000,000 nation-wide sales records for a major automobile manufacturer. Created zoom-able sales heat-map integrated with Google Maps.

• DEFENSE • Responsible for recruiting and hiring professionals skilled in business intelligence and managing technical aspects of the organization.

• DEFENSE - US NAVY • Developed and deployed BI solutions for fleet preparedness, manufacturing, repair, parts tracking, and performance analysis.

Responsible for the financial health, marketing, and mission capability of a non-profit medical organization staffing two doctors, three nurse practitioners, medical staff, & 18 volunteers. • Clarified and updated mission statement and core marketing message & materials • Defined and improved separation of duties among Directors. • Hired additional physician, acquired donated building for second facility in another city. • Reestablished newsletter lifecycle and reorganized fundraising tracking procedures. • Generated hundreds of new donors.• Awarded $11k non-profit license for Salesforce.com SAAS. • Engaged 18 regular volunteers and by creating clearly defined roles and procedures.

Responsible for Defining, Measuring, Analyzing, Improving, and Controlling business processes for the service industry by leveraging Business Objects and Crystal Xcelsius tools. Enable decision makers to flexibly visualize key performance indicators (KPI) and financial metrics. • Deployed interactive Xcelsius™ Flash™ dashboards for a California inland fire department• Deployed proof-of-concept Business Objects Enterprise Performance Management (EPM) dashboards for Water Utility division of a major east-coast US city.• Drafted Requests for Proposal to government and military clientele

• TELECOM • Responsible for leading small cross-functional teams in reducing waste and implementing process-variation reduction methodologies to business process improvement projects; evangelizing Lean/Six Sigma.• Completed Six Sigma project “Improving Audit Consistency”, thus reducing cycle time and variation with projected cost savings of $500,000/year.• Applied Lean/Six Sigma methods to waste reduction project by creating process visualization dashboards and increasing throughput from 20,000 to 50,000 units per month.

• TELECOM • Developed standard internal and client-facing reports; administering and upgrading BusinessObjects servers; evangelizing Business Intelligence; developing universes, BI curriculum; coaching hundreds of end users via live, video, and webinar trainings.• Created dozens of Standard Operational Reports; hundreds of Ad-hoc reports; and several executive and management Dashboards, including 42 inch wall-mounted video displays.• Administered and upgraded BusinessObjects servers supporting hundreds of users.• Trained over 400 end-users via webinar, via video, or person. Developed and delivered BI Course Curriculum to Chief Telecom Analysts, CIO’s, CFO’s and their delegates at Fortune 500 companies resulting in 20% heavy BI users plus 15% mod/light BI users.• Performed over 30 BI demonstrations to Fortune 100 companies with high percentage of wins.

• HEALTHCARE • Responsible for monitoring and auditing the data warehouse import (ETL) cycle for McKesson clinical/financial decision support system processing 20,000+ patient record updates per month for 330-bed hospital and outpatient facilities.• Empowered decision-makers with in-house technical documentation; provided technical support and troubleshooting for end-user data mining projects.• Quality assurance of three major and several minor Sybase data warehouse version upgrades.

Responsible for maintaining oracle-based telecom billing and customer care system; designing telecom trend-analysis, financial, management, and marketing reports; developing and documenting procedures for revenue data collection, report requests, and database change requests.• Created in-house CABS billing software to generate bills inter-exchange carrier resulting in $50,000 per month in cost recovery.• Lead cross-functional team to track and resolve issues resulting in $600,000 cost recovery.• Migrated $200,000 per month of ISP Acquisition accounts within 6 weeks start to finish.

Responsible for programmers and operators in the analysis of long-distance switched telecom traffic, weekly call detail cost reporting, validating carrier invoices, generating AP disputes, and identifying potential fraud.• Prepared daily country/city specific least-cost routing reports for CEO, and dozens of weekly reports contributing to annual cost savings estimated in the millions of dollars.

Bs, Cognitive Science

High School, High School Diploma