Gregg Harris

Gregg Harris Email and Phone Number

Solutions Architect / Project Lead / Principal Trainer (Microsoft Excel®) / Data Engineer @ National Exchange Carrier Association, Inc
Whippany, New Jersey
Gregg Harris's Location
Denver Metropolitan Area, United States
Gregg Harris's Contact Details

Gregg Harris personal email

n/a
About Gregg Harris

I am a professional software developer/systems architect, and was Principal Trainer at Binary Alembic (a computer software training company). I have implemented solutions for companies of all sizes including Sempra Energy, Merck & Co. Inc, Bank of America Corp., Apple Inc., McGraw-Hill, Intel Corporation, SDG&E, and others. I have compiled and synthesized user requirements, created implementation plans, managed project progress and delivered functional solutions for projects large and small. I have worked closely with all levels of users, from executives to individual contributors; defining, creating, and deploying effective decision support systems. Special note: If your company uses Microsoft Excel®, I can help you leverage its inherent power and functionality by implementing the Container / Alembic paradigm: 1) Refine data to its essence (alembicate), 2) Host it within a secure, SQL-compliant database (in-house or cloud-based), and 3) Programmatically serve it to populate structured, Excel-based templates (containers). This methodology facilitates information sharing, flexible report generation and multi-user accessibility while eliminating redundancy and enforcing data security. It combines the practicality of Excel with the convenience of a data warehouse. ________Other annotations:• I created the CornerStone® development platform used by several Fortune 100 companies (e.g. Intel, Merck, Sempra Energy) to host enterprise-level applications.• I have helped companies save (or generate) millions of dollars by implementing systemic solutions to difficult data problems.• I have led developer groups defined by locational (office building / cube farm) or virtual proximity.• I have planned, organized, and delivered dozens of solutions to complex problems for both inward-facing (internal company use only) and outward-facing (consumer) projects, including a cloud-based iPhone app (Go4 USA) available on the App Store.

Gregg Harris's Current Company Details
National Exchange Carrier Association, Inc

National Exchange Carrier Association, Inc

View
Solutions Architect / Project Lead / Principal Trainer (Microsoft Excel®) / Data Engineer
Whippany, New Jersey
Website:
neca.org
Employees:
92
Gregg Harris Work Experience Details
  • National Exchange Carrier Association, Inc
    Data Engineer
    National Exchange Carrier Association, Inc Feb 2019 - Present
    Denver Metropolitan Area
  • Merck
    Senior Solutions Architect / Project Lead
    Merck Aug 2014 - Mar 2018
    SCOPE - System for Clinical Out of Pocket Estimation• Created a cost forecasting system for over 6k clinical projects that have a cumulative value of more than $4.5 billion (USD).• Enables users to track ~250 separate Activities summarized into dozens of distinct Cost Units.• Allows for detailed cost forecast estimates over a fifteen-year time horizon (two years monthly and thirteen years annual).• Provides forecasts based on complex algorithms using milestone dates, estimated costs, and percentage distributions with the ability to offset start and end dates.• Includes Budget, Forecast and Actual data to ensure reliability and accuracy, and provides variance comparisons for all relevant combinations.• Has unlimited customized Scenarios that allow users to create and store forecast drivers for enhanced "what if" analysis.• Incorporates date-based Patient Enrollments, for both US and INTL locations, allowing endless patient visit/budget combinations.• Flexible reporting options for both Standard and Variance reports include myriad filtering options and pre-defined summary rollups.• Fully integrated Administrative options allow for system customizations, multi-level user type definitions and security authorizations, full table maintenance and control, etc.• Data housed in Microsoft SQL Server database.
  • National Exchange Carrier Association, Inc
    Project Consultant / Software Developer
    National Exchange Carrier Association, Inc May 2016 - Dec 2016
    Greater Denver Area
    NECA Cost Allocator & Forecast Model• Conducted a comprehensive review of NECA Cost Allocator & Forecast Model.• Evaluated and corrected compatibility issues of the model with Microsoft Excel 2013.• Evaluated SQL statements for querying data into the model and created more efficient, sophisticated, and accurate queries.• Identified and updated inefficient or unsupported VBA code related to workbook navigation including menus, toolbars, user forms, user preferences.• Reviewed and implemented VBA/Oracle database interactions to increase efficiency & accuracy of data transmission from the model to Oracle.• Evaluated existing Oracle database tables currently populated by the model to eliminate redundancy.• Identified and removed redundant ancillary data within the model to decrease overall file size. • Provided recommendations for enhancing PDF report output functionality.
  • Binary Alembic
    Principal Trainer / Advanced Microsoft Excel
    Binary Alembic Jan 2014 - Apr 2016
    Greater Denver Area
    • In addition to being lead instructor, I am also a professional Excel/VBA developer who specializes in turning raw data into clear and concise business information. Over my 25-year career I have implemented solutions for companies of all sizes including Sempra Energy, Merck & Co. Inc., Bank of America Corp., Apple Inc., McGraw-Hill, Intel Corporation, SDG&E, and many others.• As a principal trainer I have organized and conducted instructional seminars throughout the country for both in-house applications and enterprise-level software installations. A key component of that instruction has always included in-depth Excel training for key user groups and corporate development teams.• I developed the CornerStone® software development platform (and accompanying CornerStone® developer tools) based on MS Excel/VBA. I am an expert in complex model creation, structured VBA development (object-oriented programming, UDFs), systems integration, and rapid application development, employing Excel professionally since Version 2.
  • Go4 Made In America Llc
    Co-Founder
    Go4 Made In America Llc Jan 2012 - Dec 2014
    Go4 USA Mobile App• Co-developed mobile cloud-based application for iPhone / iPad; created back-end database using MySQL (SQL-compliant relational database) and all accompanying middleware using PHP (server-side scripting language). Customized web services connect the mobile device to cloud server via Wi-Fi or 3G/4G/4G LTE; response time is lightning fast. • Created Excel-based client to manage all database data using VBA automation. Reporting, data analysis, pivot tables, extracts, inserts/updates/deletes all performed through the Excel interface. Uses Microsoft XML libraries to transfer data using POST, and utilizes other Shell controls to transfer files via FTP protocols, all using the Excel front-end through VBA automation. • Built ad-hoc query tool within Excel that allows creation of tables/views and stored procedures, and allows the user to manipulate and store sophisticated SQL queries and database management scripts. Also supports automated connections to Oracle, MySQL, SQL Server, and Sybase. • Database contains millions of records and supports concurrent connections for thousands of users, both mobile and desktop.
  • Merck
    Principal Systems Developer / Project Lead
    Merck Jun 1995 - Aug 2013
    Financial Forecasting System• Client/server implementation (Excel/VBA/Oracle; MS Office); planning/reporting/budgeting financial system, with real-time processing; employs complex Excel-based models used for financial tracking and forecasting. • Supports ~300 concurrent user-analysts managing over 1700 departments (60% domestic, 40% foreign) for Merck Research Labs; tracks $6 billion (USD) in research spending (managed daily) with over 125 different currencies presently supported. • The system supports 10,000 employees/contractors in headcount-related financial tracking (salary, bonus, internal, external, contract labor, etc.), including real-time payroll forecasting. • Fully customized MS Excel interface includes menus, toolbars, user forms, color schemes, context-sensitive shortcuts, user preferences, and security access.
  • Merck
    Systems Developer / Project Lead
    Merck May 2000 - May 2010
    Clinical Grants Planning System • Client/server application tracks and manages over 1100 research programs including clinical trial data, program phases, clinical studies, and compounds ($2 billion USD). • Client models are built on-the-fly from Oracle-housed data. • Full interface customization.
  • San Diego Gas & Electric
    Principal Systems Developer / Project Lead
    San Diego Gas & Electric Aug 2010 - Dec 2011
    Fire Litigation Tracking System• Created custom application using an Excel/VBA-based client interface with data hosted on a secure, custom built Oracle database. • Used to manage $2 billion in plaintiff demand data for litigated fire claims (attorney group: Quinn Emmanuel LLP); includes mediation scheduling, insurance offsets, document transfer, claim tracking, etc. for over 3500 residential, commercial, and government plaintiffs.
  • Sempra Energy
    Senior Systems Developer
    Sempra Energy May 2005 - Dec 2011
    Energy Risk Management System• Developed MS Excel-based client for automated Risk (VaR, credit) reporting using charts/graphs, pivot tables, ad-hoc data extraction and reports; sits on Oracle-based data platform used for enhanced Risk-based reporting and analysis. • Created all tables and associated data structures in Oracle. Developed user-controlled dashboard for batch processing and event logging; created processes for XML-based price record imports (including forward price curve generation and smoothing). • Used latest technical tools for data security, manipulation, and storage (including VBA, custom DLLs, MS Office products); supports automated connections to Oracle, SQL Server, and Sybase. • Created sophisticated SQL queries for data processing, table/view creation, and report generation; fully versed in data input/output processing.
  • Intel Corporation
    Systems Developer / Team Leader
    Intel Corporation Oct 1992 - Sep 1999
    Worldwide Manufacturing Planning System (Integral) • Developed client interface (entire code base sits on CornerStone®); worldwide distribution for just-in-time manufacturing planning, using MS Excel/VBA. • Application contains robust data validation, reporting, wildcard-based SQL query operations, progressive record updates, task-centered interfaces, on-line help, product routing, and manual order mapping capabilities. • Customized Excel interface includes menus, toolbars, user forms, user preferences, and user-based security access (UserId/password validation, etc.). • Interacts with SQL-compliant database systems (Oracle).
  • Kaiser Permanente
    Software Developer / Consultant
    Kaiser Permanente Feb 1997 - May 1997
    • Created automated solution for account mapping system; uses complex logical and mathematical algorithms.
  • Bank Of America
    Software Developer
    Bank Of America Jan 1995 - Feb 1996
    Client/Server System • Excel-based commercial loan analysis package. • Used the latest Excel Structure methodology to create an entire Excel VBA-based solution for approx. 3000 users. • Utilizes common data to allow evaluation of commercial loans, with the goal of saving BofA $7-10 million per year.
  • Mcgraw-Hill Higher Education
    Software Developer
    Mcgraw-Hill Higher Education Oct 1994 - Feb 1995
    SRA Technology Training, McGraw-Hill Companies, Inc. • Computer-based training course created using MS Visual Basic. • End-user training application contains over 390 screens with complete error-checking and validation, context-sensitive user feedback, and full color graphics. • Designed for consumer distribution.
  • Apple
    Software Developer
    Apple Nov 1992 - Feb 1995
    Cupertino, Ca
    Project Tracking System• Used by Apple R&D to identify project costs by employee, department, project, and design center; provides reporting by week, quarter, year or any combination thereof broken down by headcount, hour, or dollar projections. • Departmental information is rolled into a consolidated view while maintaining either full detail or optional summarizations; in addition, full straight-line or weighted allocation options are available for headcount and hour/dollar-costing reports and charts.Management Report Distribution System• Transforms raw server-based financial data into finished management reports, and includes multiple formats, workstation-specific print optimization routines, and user preferences.
  • Apple
    Financial Systems Analyst
    Apple Feb 1989 - Sep 1992
    Cupertino, Ca
    Worldwide Consolidations• Responsible for the technical consolidation of all monthly financial data for more than one hundred legal entities, which data was then used for all corporate reporting both internally and externally (10K, 10Q, other quarterly and annual reports). • Also responsible for consolidation of all hierarchical account rollups and the integration of new and acquired financial systems.

Gregg Harris Skills

Web Services Oracle Microsoft Excel Visual Basic Software Development Php Mysql Vba Cloud Applications Microsoft Office Project Management T Sql Oo Software Development Rad Mobile Applications Sdlc Microsoft Sql Server Pl/sql Training Team Leadership Public Speaking Analysis Problem Solving Sql Databases Xml Data Warehousing Data Analysis Cloud Computing Sharepoint Visio Visual Basic For Applications

Gregg Harris Education Details

Frequently Asked Questions about Gregg Harris

What company does Gregg Harris work for?

Gregg Harris works for National Exchange Carrier Association, Inc

What is Gregg Harris's role at the current company?

Gregg Harris's current role is Solutions Architect / Project Lead / Principal Trainer (Microsoft Excel®) / Data Engineer.

What is Gregg Harris's email address?

Gregg Harris's email address is gh****@****pra.com

What schools did Gregg Harris attend?

Gregg Harris attended Brigham Young University.

What skills is Gregg Harris known for?

Gregg Harris has skills like Web Services, Oracle, Microsoft Excel, Visual Basic, Software Development, Php, Mysql, Vba, Cloud Applications, Microsoft Office, Project Management, T Sql.

Who are Gregg Harris's colleagues?

Gregg Harris's colleagues are Gregory Stevens, Susan Casareale, Angie Teten, Alan Schwane, Katie Rogers, Rupesh K, Hayley Hillman.

Not the Gregg Harris you were looking for?

  • Gregg Harris

    Helping Business Leaders With Human Capital, Hr And Compliance
    Houston, Tx
  • Gregg Harris

    Cincinnati, Oh
    2
    aol.com, trustaff.com
  • Gregg Harris

    Founder & Ceo @ Lendercity | Founder @ Direct To Consumer University D2Cu.Com | 27 Years Of Direct To Consumer Mortgage Lending Experience | 30-Year Seasoned Entrepreneur
    Greater St. Louis
    3
    alexahomeloans.com, lendercity.com, lendercity.com

    2 +131460XXXXX

  • Gregg Harris

    President & Ceo At Thru The Bible Radio Network
    Fallbrook, Ca
    4
    mail.com, hotmail.com, ttb.org, att.net

    8 +194939XXXXX

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.