Gregg Harris Email and Phone Number
Gregg Harris work email
- Valid
- Valid
- Valid
- Valid
Gregg Harris personal email
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.
-
Data EngineerNational Exchange Carrier Association, Inc Feb 2019 - PresentDenver Metropolitan Area -
Senior Solutions Architect / Project LeadMerck Aug 2014 - Mar 2018SCOPE - 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. -
Project Consultant / Software DeveloperNational Exchange Carrier Association, Inc May 2016 - Dec 2016Greater Denver AreaNECA 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.
-
Principal Trainer / Advanced Microsoft ExcelBinary Alembic Jan 2014 - Apr 2016Greater 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. -
Co-FounderGo4 Made In America Llc Jan 2012 - Dec 2014Go4 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.
-
Principal Systems Developer / Project LeadMerck Jun 1995 - Aug 2013Financial 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. -
Systems Developer / Project LeadMerck May 2000 - May 2010Clinical 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. -
Principal Systems Developer / Project LeadSan Diego Gas & Electric Aug 2010 - Dec 2011Fire 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. -
Senior Systems DeveloperSempra Energy May 2005 - Dec 2011Energy 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. -
Systems Developer / Team LeaderIntel Corporation Oct 1992 - Sep 1999Worldwide 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). -
Software Developer / ConsultantKaiser Permanente Feb 1997 - May 1997• Created automated solution for account mapping system; uses complex logical and mathematical algorithms. -
Software DeveloperBank Of America Jan 1995 - Feb 1996Client/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. -
Software DeveloperMcgraw-Hill Higher Education Oct 1994 - Feb 1995SRA 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. -
Software DeveloperApple Nov 1992 - Feb 1995Cupertino, CaProject 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. -
Financial Systems AnalystApple Feb 1989 - Sep 1992Cupertino, CaWorldwide 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
Gregg Harris Education Details
-
Finance
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
Cincinnati, Oh2aol.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 EntrepreneurGreater St. Louis3alexahomeloans.com, lendercity.com, lendercity.com2 +131460XXXXX
-
4mail.com, hotmail.com, ttb.org, att.net
8 +194939XXXXX
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
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.
Start your free trial