David Ashton Email & Phone Number

Sacramento, California Area

Updating Data Engineering Skills• Currently enrolled in Udacity Data Engineering Nanodegree Program• Graduated in the Programming for Data Science with Python Nanodegree Program

Folsom, California

• Built an Executive Dashboard for high-level managers to show immediate sum of orders, sales, and shipments by geo, by customer, customer tier, date range, product division, shipments, scheduled shipments, % late shipments, or by several other dimensions and combinations of dimensions. I extracted data from Intel’s EDW (Enterprise Data Warehouse) and transformed it to fit a star schema model I created using SAP’s EIS (Executive Information System – forerunner of SAP Business Objects). I… Show more • Built an Executive Dashboard for high-level managers to show immediate sum of orders, sales, and shipments by geo, by customer, customer tier, date range, product division, shipments, scheduled shipments, % late shipments, or by several other dimensions and combinations of dimensions. I extracted data from Intel’s EDW (Enterprise Data Warehouse) and transformed it to fit a star schema model I created using SAP’s EIS (Executive Information System – forerunner of SAP Business Objects). I showed it to my manager, who showed it to his manager, etc up 4 levels to the executive suite.• Built Intel’s EMR (Enterprise Metadata Repository) – a relational data warehouse for data about all four areas of Intel’s business: Business, Data, Applications, and Technology Infrastructure. It was a team of four that conceived and built it. I designed and modeled the Data-area entities, the others each modeled the business, application and infrastructure-area entities. The EMR could show what business departments depended on what applications that used what data from what source or warehouse systems. I also built the automated ETL jobs to gather the metadata from operational systems to routinely load the EMR. It was also used to mark which data elements and data stores were under various levels of personal privacy regulation, eg., European PII standards. The team also built an EMART (Enterprise Metadata and Asset Reuse Toolkit) application for developers in any business line to query and find apps, reports, data, or servers that they could reuse resulting in $50 M annual savings in development costs. These were audited amounts from reuse events captured by EMART.• Conceived and managed the project to build an impact analysis application to alert downstream data and application targets about pending changes to source or warehouse data that will impact them. This could tell a business application owner which Microstrategy reports would be impacted by a change in an SAP source system. Show less

Albany, New York Area

• Part of a team to build and document an extensive Property & Asset Management System for the New York State Environmental Control Agency• Designed and built the change triggers for the Business Information Center Database, General Electric, Schenectady, NY• Part of a team to build data management and user interface screens for a mutual funds system, 1st Datacorp, Boston, MA• Certified and regularly taught a 3-day course on Logical and Physical Design for SQL Server Corp, Boston… Show more • Part of a team to build and document an extensive Property & Asset Management System for the New York State Environmental Control Agency• Designed and built the change triggers for the Business Information Center Database, General Electric, Schenectady, NY• Part of a team to build data management and user interface screens for a mutual funds system, 1st Datacorp, Boston, MA• Certified and regularly taught a 3-day course on Logical and Physical Design for SQL Server Corp, Boston, MA. Taught quant developers on Wall Street, other consultants in Boston, MA, and oil and gas developers in Edmonton, Canada, among others. Show less

Dhahran Al-Janoub Governorate, Saudi Arabia

• On a 3-person team to gather business data requirements in working group sessions with each business group in the oil E&P (Exploration and Producing) Division, to develop the logical models and build an E&P Data Warehouse using Model 204 RDBMS with ETL streams that would serve the combined and integrated data needs for the three major functions of the exploration side of the division: seismic shot point surveys and placements, seismic data from computer tape reels, and the subsequent… Show more • On a 3-person team to gather business data requirements in working group sessions with each business group in the oil E&P (Exploration and Producing) Division, to develop the logical models and build an E&P Data Warehouse using Model 204 RDBMS with ETL streams that would serve the combined and integrated data needs for the three major functions of the exploration side of the division: seismic shot point surveys and placements, seismic data from computer tape reels, and the subsequent underground smoothed-layer interpretations all tied in a 3-D grid to the shot point geo-coordinates and data at depths. It was the first of its kind and had the effect of showing for the first time the overall integrated business of the exploration business line.• Designed, modeled, and built an addition to the E&P Data Warehouse for borehole analysis data as further input to the interpretation of underground geology and composition. These tools were so successful that when the Saudi government finally opened new licensed areas for ARAMCO, they hit new oil reservoirs almost immediately. Show less

Greater Denver Area

• Developed applications to support various research projects such as keyword in context searches to retrieve documents from a National Solar Energy Information Data Bank, and digital models for testing Passive Solar Energy Construction designs.

Greater Denver Area

• Assisted developers in Ernst & Young Accounting firm to create applications for on-line financial, billing, and tax-shelter systems using APL language on STSC computers. Maintained these systems that they sold to their customers• Supported various packages such as a cost-accounting system for construction projects and an Inventory Tracking and Demand Forecasting package for manufacturing

Greater Salt Lake City Area

• Ran statistical studies to analyze the impact of certain medical policies and programs in the multi-state region• Helped medical personnel design a new patient record• Implemented on-line patient simulations for training medical doctors to ask the right questions and observe key exam symptoms to arrive at the correct diagnoses

Programming For Data Science With Python Nanodegree, Data Engineering

Master'S Degree, Computer Science

Bachelor'S Degree, Mathematics

Activities and Societies: University Orchestra Professional Musician - Teaching, Utah Symphony extra