Scott E. Johnson Email & Phone Number

United States

Work with Business and TechnologySME's to assess available data fromtechnology production systems andmodel that data into structures thatreflect and allow easy analysis andreporting.• Use multiple datasets in concert toimprove data compleness, accuracy,and actionability.• Develop efficient ETL patterns forloading small-to-large amouints ofoperational data.• Identify and remediate performancepain points as necessary.Troubleshooting, analysis and supportof data integration processes andreporting solutions.• Ensure appropriate indexing is inplace to optimize performance ofreporting applications fed from teamdata repositories.• Create/Enhance automated systems forimproved analysis and reporting.

Minneapolis, Minnesota, United States

Job functions: - ETL Data integration design and development.- Database design and support.- Worked with business partners to develop system automation and reporting solutions.- Troubleshooting, analysis and support of data integration processes and reporting solutions.Key Projects:Primary integration developer for hosted benefit/payroll systems.- T-SQL/SSIS- FTP ScriptingDev/Support/Analysis and Troubleshooting of company wide Field Reporting System- T-SQL/SSIS/SSRS based system- Integration between Reporting database (SQL Server), back office systems (IBM iSeries) and Data - Warehouse (SQL Server).- Supported and enhanced Reports as requested by business.- Improved efficiency and stability as needed.Coded and supported predictive analytic scheduling system- T-SQL/SSIS- SQL Server Embedded R scripting- Project goal: to reduce unnecessary payroll hours in stores. Based on past ticket history and average service times.- 1st year savings estimated at $12 million

Associate Of Science - As, Software Development

Associate Of Arts - Aa