Larry Jokhan

Contract role - 6-month contracts, renewed 6 times ● Migrated SQL Server On‐Prem Workloads to Azure ‐ Successfully migrated legacy Excel/SQL Server On‐Prem dashboards to Power BI / Azure Synapse. Developed Synapse operational tables, views & stored procedures. Created Azure Data Factory (ADF) pipelines to load data. Designed star schema Facts & Dimensions within Synapse to populate Power BI semantic models for Marketing dashboards. ● Database Modeling ‐ Designed & implemented Goal Dimension & Fact table with Slowly Changing Dimension Type 2 for Marketing Power BI Dimensional Model. ● Database Modeling ‐ Implemented major upgrade to the Dimensional Model by adding 4 new Dimension tables and ~100 data points to enhance print, radio, TV, internet, e‐mail and direct mail reporting. ● Power BI Development ‐ Developed interactive Power BI monthly job failure report. Showed machines, days & 1‐hour intervals where machines were overloaded. Insights drove reduction in job failures. ● T‐SQL Development ‐ Replaced slow‐running database process for PCG Group with streamlined process which reduced report run‐time by ~50%. Analyzed query plans, redesigned T‐SQL code, added new clustered indexes & cached data. ● PowerShell Development ‐ Developed PS script to monitor reporting machines for hung processes. It logged all running processes every 5 minutes and killed applications with no CPU usage for 30 minutes. ● PowerShell Development ‐ Reduced legacy system jobs from running prematurely by developing SQL Server integration scripts. AdTempus jobs were modified to wait for SQL Server tables to load before running reports. ● SQL Server Installation ‐ Improved legacy reporting by installing 2 new instances of AdTempus reporting machines to support ~700 legacy reports. Installed SQL Server 2022 Express. Configured service accounts to work with adTempus software. ● Microsoft Access Developer ‐ Supported Microsoft Access databases & reports along with Microsoft Excel dashboards.

● SQL Server Performance Tuning ‐ Achieved ~50% performance improvement after my comprehensive analysis of indexes within Fidelity Data Warehouse. Added missing clustered indexes. Added non‐clustered indexes to support joins. Used 90% fill factor to reduce page splits. ● SQL Server Consolidation ‐ Retired 5 SQL Server VMWare machines by consolidating SQL Server databases & instances. This improved the performance of our VMWare subsystem – freeing RAM memory and SSD disk space. ● SQL Server Maintenance ‐ Created weekend automated jobs to rebuild fragmented indexes (with 90% fill factor to reduce page splits), restart dedicated SQL Servers & confirm the SQL services started successfully. ● SQL Server Integration Services (SSIS) Automation ‐ Saved ~10 hours of manual work per week by automating Social Security & Medicaid application processing using SSIS, PowerShell & WebVault. Developed SSIS packages to extract retail banking accounts & transactions for secure transfer outside the bank. ● SQL Server Reporting Services (SSRS) ‐ Installed & configured SSRS banking site with folders for each department (Lending, Retail Banking, Auditing, Call Center, Operations). Developed operational reports for each department. ● Python ‐ Improved performance of Python report scripts by creating a centralized Python environment on a dedicated server. Scripts were moved to file shares & scheduled using Windows Task Scheduler. Faster execution & reduced job failures. ● Crystal Reports Migration ‐ Mortgage Dept ‐ Reduced time spent on reporting by over 70% by replacing manual‐input Excel reports with a suite of Crystal Reports. ● Oracle 11g ‐ Developed PL/SQL scripts to query Fiserv’s Oracle retail banking database using Oracle SQL Developer. ● Microsoft Access Developer ‐ Developed tables, queries, screens & reports to support Commercial Lending Loan Originations Department.