Scott Olson Email & Phone Number

Santa Maria, California, Us

Created departmental Power BI dashboards. By collaborating closely with key stakeholders, I ensured that these dashboards effectively answered business-related questions using the data already available in our business systems, which is updated daily to provide timely insights. Surfaced those insights that supported progress toward yearly goals set by the Credit Union's Board.I spearheaded the transition from outdated text-only reporting methods to modern SSRS reports and Power BI dashboards, utilizing data from our ARCU and EDS data warehouses. To date, we have successfully converted over 300 Episys core reports, We have replaced OpCon in our production environment with these reports and other automations driven by our development staff for additional cost savings and more importantly much higher quality reports that leverage our data warehouse investment.I also led the implementation of integrating our Meridian Link data into the ARCU data warehouse, making it available for next-day analytics in both Power BI and SSRS reporting. This initiative has significantly enhanced our data analysis capabilities, providing valuable insights to support decision-making processes.

Santa Maria, California, Us

Oversaw the upgrade of our security platform to include Microsoft Sentinel with full integration of O365. Presided over 2 NCUA/DFPI audits that produced no findings for the Technology group. Lead the effort to measure what matters and produce monthly reporting on those measures which aligned with best practices for IT Governance.Lead effort to modernize Symitar Core system development and adopt modern PowerFrame Docs and institute best practices for Development and Core team integration and separation of duties per best practices

Santa Maria, California, Us

Lead online banking conversion project to the NCR DI platform with emphasis on business banking functionality. Provided technical oversight for our Meridian Link re-discover to upgrade all of our systems to utilize this platform to add new products to leverage this platform for consistency and speed.

Santa Maria, California, Us

Design, Build and Maintain Business Intelligence (Data Warehouse, Power BI, SQL Server and SSRS objects) to enable data driven decisions across the enterprise. Also implementing Master Data Management.Built end to end Auto analytics Power Bi interface for consumer lending department that helped increase profitablity of the Auto Portfolio by 50% and reduce charge-offs by 30% within 4 years.

Santa Maria, California, Us

Data Warehouse and Data Visualization Architect. Power BI Developer. Master Data Management. Project Management.Built out end to end data warehouse utilizing core data and automated daily ETL process.Oversaw the integration of the Jack Henry ARCU and EDS data warehouses into the CoastHills ecosystem and further integrated existing daily ETL processes to supplement those systems.

Los Alamos, Nm, Us

Manage Enterprise Projects for 3rd largest bank in New Mexico. Project Manager, Sr. Software Engineer .Net, C#, SQL and data architect for internal customers and external vendors

Los Alamos, Nm, Us

Developed Linked Server to Sybase Bank Core to facilitate ETL for external vendors, data analytics, automated reports and data dashboards for internal customers.Created Custom Data Mart to develop several web based applications for various business needs

Enterprise Architect | Project Management | Software Development..Net, SQL, C#, VB.netTwo Large Projects of Note during this time:Project leader for rewrite for the state of South Dakota’s tax collection system. A four-year, $4 million project. Led a team in converting an old AS400 terminal application to a modern Windows.Net application utilizing MS SQL Server for the data layer. Normalization of approximately 100 million rows of data in 400 tables from the old database to similar rows and 120 tables in MS SQL Project lead for state of South Dakota’s Voter Registration system. Helped created web based application to record and report all voter registrations (built to Federal guideline and reporting standards from published specifications). A two-year project that normalized 40 million rows of data across 40 tables with published schemas that forced referential integrity that supported data reporting efficiencies. This application was implemented in all 66 County Auditor offices in South Dakota.

Database Architect | Application Architect (SQL Data Conversion and Web Front End Development)During this phase of my career, I worked to convert approximately 20 Access and dbase applications to MS SQL data with Web Based UI.I started with asp development and then moved to Visual Studio and ASP.Net

Converted dbase applications to modern relational databases (MS Access). During this time I gained valuable experience by normalizing approximately 50 applications (from flat file to relational architecture) and was a manager to 4 other junior developers.. I became a skilled data/application architect during this phase of my career.I also developed sophisticated BI solutions for approximately 25 of the applications developed during this time.