Scott Altman Email & Phone Number

Arlington, Va, Us

Arlington, Virginia, United States

As the owner of Altman Data Innovations, I serve as a business automation/data analysis/business intelligence consultant to multiple small and medium-sized companies. I serve clients in various sectors including insurance, professional services, retail, and food & beverage supply. Services I provide:- Automate business processes using no-code platforms (AppSheet, Make, and Airtable), as well as VBA within Microsoft Office products. - Analyze data to understand business trends and solve problems, including utilizing data stored within enterprise data warehouses (Snowflake and BigQuery). - Create and maintain business intelligence dashboards (Looker, Looker Studio, and Power BI).

- Led development of a data processing platform- Managed BigQuery Data Warehouse and developed ELT pipelines

-Built data models in Snowflake data warehouse using dbt and SQL.-Built reporting and dashboards in Looker-Data Analysis using Python and R

Greater Chicago Area

Ricondo is an aviation consulting firm. I was responsible for providing support throughout the company for data related efforts, such as simulation pre/post processing, air service analysis, passenger forecasting, and internal project monitoring. To facilitate these efforts, I developed tools and templates using Excel, Access, VBA, Python, SQL, Power Apps, and Power BI, depending on project needs.

ConSysTec is an Intelligent Transportation Systems consulting firm, specializing in Systems Engineering for ITS. Some work I performed while at ConSysTec:-Served as the technical lead for an effort to build a statewide public transit schedule data repository in the industry standard GTFS format, consisting of 120 public transit agencies. Coordinated team operations, conducted training/outreach with transit agency stakeholders, developed software tools to facilitate project work, managed data quality, and used performance metrics to track overall progress.-Led the specification design and testing of a public transit real-time information data feed using both industry-standard (GTFS-Realtime/SIRI) and custom APIs.-Developed Systems Engineering documents including Concept of Operations, System Requirements, and Data Specifications for multiple systems that played a role in transportation data sharing and analytics. -Developed regional ITS architectures, which serve as high-level system integration roadmaps for intelligent transportation systems. -Supported development of ITS communications standards including NTCIP standards. -Developed and delivered technical training webinars for USDOT’s ITS Professional Capacity Building Program on the topics of the GTFS and GTFS-realtime specifications used for public transportation information data sharing.

Assisted management by logically organizing and assembling a database of contact info on prospective clients. Gathered data by researching the internet and contacting individuals directly. Also worked this position from July, 2009 - August, 2009 and December, 2009 to January 2010.

Assisted faculty and graduate students by assembling and organizing data to be used in a logistics project. Obtained data by analyzing newspaper articles. Organized database of collected data.