Jason Larson Email & Phone Number

Buffalo, Ny, Us

Buffalo, Ny, Us

Williamsville, New York, Us

- Developed a Governance and Maturity Plan for Microsoft Power Platform and executed on a successful deployment. Created ALM and Environment strategies. Coached teammates on Low Code usage. Produced re-usable data assets and acted as Technical Lead on IT-sourced Solutions.- Designed, planned for and implemented Evans first ever Enterprise Data Warehouse as part of project team. Performed install/configuration of SQL Server. Creation of SQL Maintenance Plan, centralization of ETL scheduling using SQL Agent. Configuration and testing of data cleansing and linking tools. Creation and implementation of indexing and performance monitoring. Coaching team on ETL pipeline creation. Perform R&D on best practices and technical journey to potential Azure deployment.- Designed initial governance structure for Power BI at Evans, taking into consideration cloud security concerns, Power BI administration, change management, and best practices based on the Power BI Enterprise Deployment Guide. Provided guidance, architecture information, documentation, and best practices information to project team.- Collaborated with vendor staff and internal team to launch Evans initial Docusign deployment. Work on Center of Excellence buildout for the organization, and provided technical help for API integrations with other third party products.- Created API catalog based on core system specifications to leverage bidrectional realtime functionality with vendor core system, including a full Online Banking integration and ancillary functionality.- Developed a custom Wire Management module for the bank's use, leveraging the vendor API to assess fees, post transactions to core, parse Fedwire format and produce PDF reporting. - Principal technical SME and IT support analyst for the company on every major technology conversion initiative: Online Banking, Mobile Banking, General Ledger, Commercial and Consumer LOS, Legal Doc Generation, Wire Management, Online Account Origination.

Williamsville, New York, Us

- Installed and configured VMWare ESXi hypervisor and partitioned it into VMs requested by the team for use by newly proposed general ledger, profitability and reporting systems.- Converted a general ledger system from an in-house system to a best of breed vendor product. Created ETL pipeline using SSIS to ingest general ledger data from core system and third party insurance product. Created extracts used to reconcile core system subledger data to the general ledger.- Developed a custom request management system for IT department use, using SQL Server and ColdFusion to track time reporting, request and project status information, documentation storage and PDF reporting.- Created ETL piplelines using SSIS to feed various third party systems, including positive pay, profitability management tooling and others. Collaborated with vendor technicians to validate data transformations and file structures.- Served as principal support analyst and company technical liaison for several of the company's vendor products including OLB, Bill Pay, Mobile, General Ledger, Positive Pay, NACHA Origination.

- Enhanced a custom Online Banking application using SQL Server and ColdFusion. Developed API interfaces to RSA Adaptive Authentication and Symantec VIP using SOAP. Created functionality for Cash Management, including SSO integration to a third party positive pay system. Various enhancements to reporting tools.- Created front end Windows software functionality for a custom banking core system using Visual Basic. Primary work was done in enhanced account reconciliation and NSF tracking.- Developed front end Windows software features for a custom NACHA file origination system using Visual Basic. Work was done to add new SEC codes and associated parsing mechanims to the system.- Administered OLB and Bill Pay servers, including SQL Server and an IIS web server. Created SQL and maintained SQL Server Maintenance Plan. Used third party tooling to monitor disk, cpu and network usage as well as other critical services. Made ad hoc emergency fixes to the environment as needed. Researched, planned and performed upgrades as needed to the hardware and software.- Assisted vendor banks with DR planning and DR testing on a yearly basis.

- Maintained custom development framework curated by the Lead Developer. Created unified UI to be shared among all AMS products, with developer tools to facilitate development.- Produced enhancements to a course evaluation tool used by over 50 schools, including group communication tooling and a module to create customized reports.- Developed analysis and reporting tools as part of a college graduate student application system used by a local university to process over 10,000 yearly applications.- Served as main support and technical contact for the graduate student application and curriculum vitae software produced by the firm.

- Constructed a centralized accounting system as a member of a team for a global paper company. Wrote accounts receivable tools and regional reports for invoicing analysis using SQL stored procedures and ASP.- Created a web based task management, time reporting and billing analysis system used by all FTA employees on a daily basis to track project progress. Created using SQL stored procedures and ASP.- Designed SQL database and stored procedures for a B2B portal for a large distribution firm. Development was focused on shopping cart, reporting and customer portal.