Randall Thomson

Randall Thomson Email and Phone Number

Senior Data Engineer - Senior ETL Developer @ American Public Media Group | Minnesota Public Radio | Southern California Public Radio @ American Public Media Group
Randall Thomson's Location
Greater Minneapolis-St. Paul Area, United States, United States
Randall Thomson's Contact Details

Randall Thomson personal email

n/a

Randall Thomson phone numbers

About Randall Thomson

Experienced Senior Data Engineer currently in the non-profit broadcast media industry. Exceptionally passionate about solving problems for the customer and the business. Greatly mission oriented in my work. Creative and thoughtful.Expertise: 14 years experience with ETL development • MS SQL Development • Transact SQL • Microsoft SSIS • Microsoft SSRS • Cognos Analytics • General Accounting and Payroll Knowledge • Business Processes Proficiencies: MS SQL Server Administration • Infor Process Flow Automation • ERP administration (Infor Lawson S3 Administration) • UKG Ultipro and Kronos WFC HR System Administration • Non-Profit CRM Knowledge • Salesforce Administration • Remedyforce Administration • PowerShell • XML • JSON • Python

Randall Thomson's Current Company Details
American Public Media Group

American Public Media Group

View
Senior Data Engineer - Senior ETL Developer @ American Public Media Group | Minnesota Public Radio | Southern California Public Radio
Randall Thomson Work Experience Details
  • American Public Media Group
    Senior Data Engineer At American Public Media Group
    American Public Media Group Oct 2009 - Present
    Saint Paul, Mn, Us
    Primary support for MSSQL based business data integrations and MSSQL database administration at APMG. I specialize in SSIS ETL development, MSSQL development, Infor Process Automation, and Salesforce Integrations. I've developed and maintained numerous integrations spanning CRM related systems: (Springboard, Salesforce Sales Cloud, Salesforce Marketing Cloud, Shopify, Enterprise, Visual Traffic) HR Systems: (Ultipro, Kronos) and Financial Systems: (Lawson S3 V10 Financials). I also administrate the company's Infor Lawson Financials ERP, Kronos Workforce Central, and Remedyforce Service Desk Software. In the past I had administered AKG Ultipro, Act! CRM software and Remedy AR System Server.Select Accomplishments: • Developed ETL processes and tools to integrate a cloud-based 3rd party fundraising with our existing systems to replace many on-premises payment and manual data entry operations. A major milestone at the company.• Developed MSSQL ETL to tally listener preference indicators across 3 CRM systems and consolidating those into a data warehouse reporting.• I developed new requisition approval workflow using Infor Process Designer. It reduced a complex and time-consuming business processes saving purchasing approvers and requesters ample time.• Technical lead of Infor/Lawson upgrade from version 9 on-premises to Cloudsuite version 10. • Primary technical lead in migration from Kronos Workforce Central to Ultipro. I transformed payroll data spanning many companies, years, GL formats, and org structures into UKG Ultipro.
  • American Public Media Group
    Programmer Analyst At American Public Media Group
    American Public Media Group Mar 2007 - Oct 2009
    Saint Paul, Mn, Us
    Designed MSSQL based ETL processes for all data coming into and out of our HR and Financial systems. Administrated Kronos Workforce Central Suite and Lawson Infor S3 Financials. Tasked with converting Kronos to a new general ledger in advance of a shift from Great Plains to Lawson Financials. I headed of migration of HR and Financial reports to Cognos from IBI and crystal reports. Responsible for IT Business Applications Group's windows server administration.Select Accomplishments: • Technical lead in migration from Great Plains to Lawson S3 ERP. I was brought into this project after implementation was far past due. I was able to get past technical roadblocks and got the product implemented by the new target date. • Developed MS SQL scripts to convert our existing payroll system’s general ledger into one compatible with Lawson saving 100K we were quoted in consulting fees for the same work from a consultant.
  • American Public Media Group
    Information Technology Support Analyst
    American Public Media Group Mar 1999 - Feb 2007
    Saint Paul, Mn, Us
    Hired into this role after a working at the Minnesota Public Radio as a contractor through TEKsystems. I administrated the companies seventy-plus Macintosh workstations. I specialized in broadcast studio OSX digital audio workstation setup and support. Transitioned into PC workstation and server support soon after taking this role. I was the administrator of software licensing across the organization. I was an administrator for Act! CRM software and Tapscan/Qualitap ratings and demographic software.Select Accomplishments: • Enabled our first remote system management for the companies Macintosh OSX devices.• Planned and implemented remote DAW installations for the companies major building expansion
  • Teksystems
    Network Support Technician
    Teksystems Sep 1997 - Mar 1999
    Hanover, Md, Us
    I provided contracted technical support Amclyde Engineered Products, Fairview-University Medical Center, and American Public Media Group. Apple, UNIX, and Windows workstation support. Mainframe operations support. GroupWise and Netware 3.1 LAN support. Network infrastructure trouble-shooting and maintenance.

Randall Thomson Skills

Database Administration Microsoft Sql Server Ssis Business Intelligence Ssrs Databases Kronos Wfc Data Warehousing T Sql Stored Procedures Remedy Ar System Daw Software Documentation Stored Procedures Sql Server Management Studio T Sql Etl Cognos Salesforce.com Administration Remedyforce Administration Infor Lawson S3 Ls Kronos Timekeeping Administration

Randall Thomson Education Details

  • University Of Minnesota
    University Of Minnesota
    Composition And Theory.
  • Saint Paul College-A Community And Technical College
    Saint Paul College-A Community And Technical College
    Computer Network Engineering Aas Degree Program
  • University Of Minnesota
    University Of Minnesota
    Music Theory And Composition

Frequently Asked Questions about Randall Thomson

What company does Randall Thomson work for?

Randall Thomson works for American Public Media Group

What is Randall Thomson's role at the current company?

Randall Thomson's current role is Senior Data Engineer - Senior ETL Developer @ American Public Media Group | Minnesota Public Radio | Southern California Public Radio.

What is Randall Thomson's email address?

Randall Thomson's email address is rt****@****dia.org

What is Randall Thomson's direct phone number?

Randall Thomson's direct phone number is (651)-290*****

What schools did Randall Thomson attend?

Randall Thomson attended University Of Minnesota, Saint Paul College-A Community And Technical College, University Of Minnesota.

What skills is Randall Thomson known for?

Randall Thomson has skills like Database Administration, Microsoft Sql Server, Ssis, Business Intelligence, Ssrs, Databases, Kronos Wfc, Data Warehousing, T Sql Stored Procedures, Remedy Ar System, Daw, Software Documentation.

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.