Ray Harris Email & Phone Number

Tulsa, Ok, Us

Software Engineer III October 2024 to PresentBOKF directly hired me to be a full-time developer on October 15, 2024

Tulsa, Oklahoma, Us

Inceed, LLC IT Developer III November 2021 to October 2024 (Part #1)Resigned my position at Commerce Bank in Oct 2021 to become fully remote and accepted a contractor position at Inceed, LLC three days later • Member of 5 person team at Bank of Oklahoma responsible for upgrading the legacy (25 years old) TrustNet application from classic ASP to modern C# .Net applications • The TrustNet application is used to track, manage and maintain all customer trust, wealth and investment accounts • Completed conversion of the first two programs performing ETL of Schwab customer data into the new database structure. Rather than have separate programs for each task, now use one program for all tasks, and use NInject to dynamically inject behavior (one class per task) via class name (strategy pattern) which is listed as a property in the app config file • Converted a legacy VB6 Gatekeeper application to modern C# in order to consolidate customer cash activity into output files for other BOKF groups to consume (e.g. Accounting/General Ledger) • Authored (and now maintain) many SQL Server SSIS packages to perform ETL of data from the new FIS/GlobalPlus database to the TrustNet/CoreBDW database • Due to security concerns for sending internal BOKF emails directly from SQL Server, authored a Windows Service to replace that process • To send customer transaction data to an external company STP (which calculates performance of customer accounts), assisted in converting and authoring 33 VIEWs and 32 SPROCs (Stored Procedures) to process data directly from the new FIS/GlobalPlus database • Authored and maintain many complex automated processing jobs in AWA (Automic Workflow Automation)A contractor AWA expert created a templating process to make running AWA jobs easier but left out CONSOLE applications. I created a Console Template to make running EXE jobs easier

Tulsa, Oklahoma, Us

Inceed, LLC IT Developer III November 2021 to October 2024 (Part #2) • Authored a C# console application to validate incoming GI files and third-party files according to many complex rules, and either send on to various BOKF departments if valid, or place into a reject folder • Authored a C# console application to process incoming FEE GL files, and convert and consolidate the data by adding summary transaction data, and then send to FIS • Converted and authored SPROCs to perform output of data for client delivery to customers: OK Treasury - Regis - Longview - Insignis - Integris - Bloomberg - Lexis-Nexus • Authored 3 SPROCs and processes to send data for account balance information, account activity information and daily positions information to our customer CITI • Converted a process used to send customer/user login data to the XSP-ETRAN group at FIS. Process compares accounts from day to day and outputs records showing new users, deleted users, and modified users. Converted the output from XML to CSV records • After all project development was finished, verified and validated through QA, assisted in migrating all new code and processes into the PROD environment. • Assisted with solving and fixing issues that were fallout from the PROD conversion

Kansas City, Mo, Us

Serving as a part-time (adjunct) faculty member at Penn Valley Community College teaching classes in C++, ASP.NET/C# and Java. Will launch a new PYTHON course in Summer 2017.

Kansas City, Mo, Us

Commerce Bank (Part 2) IT Developer III Dec 2019 to Oct 2021 • After being full-time for 10 months, was promoted to IT Developer III in December 2019 • Member of 10 person team at Commerce Bank responsible for supporting various retail accounts, commercial accounts and invoice processing accounts • Responsible for maintaining and enhancing software supporting those customers in the realms of data entry for all check transactions, high-speed scanning of all check/invoice/correspondence paperwork for those transactions, data storage, scanned image storage, data file movement and transmissions, data validation, data verification, and account balancing • Routinely perform emergency on-call duties for the Wholesale Lockbox and Retail Lockbox processig environments • Support and Maintain Java/Spring/Spring Boot applications for our Account Analysis department • Pioneered a new framework and methodology in the Web Extract Utility such that for any and all future SIMPLE customer extracts, the appropriate “behavior” is injected through reflection such that the format of the extract is all driven via parameterized values from database table entries. Thus, no actual additional code needs to be written • Authored a Windows Service to automatically detect errors and alert operators when a data file created by the high speed scanners get momentarily interrupted, and generates a corrupt file. Operators are now alerted within minutes, rather than finding out hours later • Authored a Windows Service to detect "negative seconds" interval errors resulting from anomalies during operators performing data entry for checks and invoices. Windows service also fixes those errors, so that the "audit reports" won't crash, and the daily "Image Cash Letter" (ICL) file creation won't crash • Maintained the Classic ASP (VBSCript) Incentive Plan web application. Added ability to perform profuse real-time logging to have visibility into database activity

Kansas City, Mo, Us

Commerce Bank (Part 1) IT Developer II February 2019 to Dec 2019Converted to become full-time at Commerce Bank • Member of 10 person team at Commerce Bank responsible for supporting various retail accounts, commercial accounts and invoice processing accounts • After being full-time for 10 months, was promoted to IT Developer III in December 2019 • Authored a massive Windows Service to process a brand-new “utilities” vendor – our largest Lockbox customer to date. It processes and manages all scanning activity and data transactions that are sent to our data processing vendor and keeps them from being overloaded. It process all DSS returns transactions sent back to us by the Fed, and send them to the Lockbox customer for processing. It also alerts us to error files resulting from bad scans. This service has been running quietly for two years with ZERO errors. • Repaired a utility that sends transactions to a “customer online lookup portal”. If an operator had made a mistake in deleting checks versus invoices in the scanning system – my repair automatically detects and fixes the “orphan record” condition, thus instantly fixing the problem rather than spending hours manually fixing it through an emergency configuration change process • Modified an existing web application named the Remit Connect Fast Add Tool, which was mostly "spaghetti code", with many cumbersome "if/else" statements. I parameterized the app, and cut the amount of code in half. Also removed the hard-coded paths and hard-coded connection string credentials, and now use the LSD Utility library I authored. All encrypted credentials and app parameters are now contained in the config file for easy access based upon the platform in which it is running

Overland Park, Kansas, Us

Contractor with Morgan Hunter Corporate Search, filling a Developer II position at Commerce Bank-- Member of 10 person team at Commerce Bank responsible for supporting various retail accounts, commercial accounts and invoice processing accounts-- Responsible for maintaining and enhancing software supporting those customers in the realms of data entry for all check transactions, high-speed scanning of all check/invoice/correspondence paperwork for those transactions, data storage, scanned image storage, data file movement and transmissions, data validation, data verification, and account balancing-- During third week in the position, enhanced a billing routine to secure revenue that might have been lost had the code not been patched. Secured $40K in just that single 1-month processing period-- During third week in the position, authored a GUI Powershell utility to allow for easier switching of processing environments, and custom DLL switching, for the OpenText OCR image processing software (invoice/check text recognition)-- Enhanced a departmental C# utility library to allow for easier encryption of database connection credentials-- Enhanced a departmental C# utility library to allow for much more dynamic and configurable logging capabilities to multiple destinations, including SMTP email, database tables, fixed files, rolling files and the Windows Event Log-- Added a new customer to a data extract utility in record time, to allow the customer to receive PDF/TIFF images and ASCII data for all their daily transaction activity-- Enhanced a departmental Account Reporting Utility to upgrade it from .NET 2.0 to a current version of .NET, and also a current version of Crystal Reports. Enhancement also included allowing for easier concatenation and grouping of customer data for simpler reporting and greater efficiency-- Development performed with Visual Studio 2013/2015/2017, TFS/Git, C#, VB.NET, ASP.NET 4.7, MVC 5/6, SQL Server 2012/2014

The "HVAC manufacturing" company directly contracted with me, through my own consulting company, Crucial Software Solutions, LLC-- Projects include creating new functionality within their licensed ERP system authored by VISIBILITY (http://www.visibility.com). The ERP system manages all their accounts payable, accounts receivable, order entry, engineering processes, inventory control, work flow, etc.-- Troubleshoot problems with the VB.NET VISIBILITY ERP web application, and recommend solutions-- Acting as their adhoc SQL Server Database Administrator (DBA)-- Create and modify reports, using the VISIBILITY custom reporting tools, using XSLT-- Continually troubleshoot and improve the efficiency of the VISIBILITY automated job processes-- Author Powershell scripts and Python scripts to automate manual VISIBILITY processes-- Authored Powershell and Python scripts to perform cleanup of the voluminous VISIBILITY report files and log files-- Authored Powershell script to detect when the IIS SMTP server is down, and restart it-- Created automated process to generate ACH files in NACHA format to pay accounts payable vendors. Data transformation and formatting is accomplished using XSLT-- Authored, and continually update, a User Guide document detailing all the customizations I've done which is now over 170 pages long

Currently a student (self-paced/online) at the University of Sedona/University of Metaphysics -- pursuing a Bachelors, Masters and Doctoral degree in Metaphysics (B.Msc, M.Msc and Msc.D). Will become a spiritual counselor, and spiritual/holistic worker. Currently am a Reiki Master/Teacher and a Certified Akashic Records practitioner.Completed Bachelor's Degree in May 2014. Completed Master's Thesis and received Master's Degree in May 2018.Currently working on PHD Dissertation to receive PHD.http://universityofsedona.com/bachelors/

Us

Performed subcontracting consulting work for CJK Software Consultants, through my own consulting company, Crucial Software Solutions, LLC1st Client: A Calibration Laboratory that calibrates various electronics and measurement equipment-- Coded a solution to solve a comm problem between test equipment, via an IEEE 488 Bus (GPIO), which was locking the intermediate ISAM files. Solved by installing SQL Server for data storage and retrieval-- Authored a new VB.NET desktop app to monitor a "temperate/humidity/ pressure" ASCII text file, and interface with a piece of test equipment over an RS-232 serial port, to provide latest environmental conditions2nd client: A consortium of 27 dental offices-- Continuing projects involve authoring SQL Server Reporting Services (SSRS) reports to assist with auditing dental office efficiency and compliance with various benchmarks regarding dental care accuracy-- Fixing a broken (PowerShell) nightly process (which downloads data from the SAM.GOV website), due to MS patch changing TCP/IP security-- Creating a new automated PowerShell process to create and manage Active Directory (AD) users, create associated SQL Server employee/user info, associate AD User objects with required AD groups, and create Office365 email accounts3rd client: A "manufacturing company" that creates HVAC equipment.-- Projects included creating new functionality within their licensed ERP system authored by VISIBILITY (http://www.visibility.com). The ERP system manages all their accounts payable, accounts receivable, order entry, engineering processes, inventory control, work flow, etc.-- Acted as their adhoc SQL Server Database Administrator (DBA)-- Enhanced the "Customer Facing" VIS website to add in data security-- Created and modified reports, using the VIS custom reporting tools, using XSLT-- Enhanced their Data Warehouse and SSIS packages by adding three new "dimensions" to include additional info not being tracked for historical reporting

KCWebpros provides education, information and lectures to IT professionals in the Kansas City area. We connect our attendees with our sponsors such as Riverpoint, LRS, Megaforge, Technisource, APlus.NET, GSI Hosting and Centriq. You can visit the site at : http://www.kcwebpros.com

The Kansas City Incubators group is a part of the Kansas City Web Professionals group. The KC Incubators mission is to help budding web professionals garner experience working together in project teams and ultimately become gainfully employed. Our process requires a team of three or more to work together on real or potentially real businesses. One main theme right now is working with small service businesses who want a presence on the web.

Kansas City, Mo, Us

Member of a 18 person team at a national company providing health services to employers and insurance companiesSecond Role included ASP.NET/C#, MVC5, JQuery, Windows Communications Foundation (WCF) Services, Microsoft Message Queue (MSMQ), Redis Cache, SQL Server 2008. Role involved:• Coded a new process to create a secondary/related customer order affiliated with the primary order, send this affiliated order to an embedded, internal back-end application and database via layered MSMQ and WCF services, then report results back to the portal• The head architect then asked me to determine what could be done to make the web portal more efficient and faster• Within 10 minutes I discovered that with every single button click to perform an action, the Web tier makes 11 calls through the App tier to actually query the database, to determine who you are, along with your roles and permissions, for authorization• I coded a new App Tier Caching methodology (using Redis Cache), such that the user / role / permission information is cached in the App tier to eliminate querying the database each time• This new solution, wherein I modified 214 C# files, brought the overall load on the portal, produced by these processes, from 3.2% down to 0.5%. This is verified by statistical reports from the Stackify software• For the previous VB6 team, I took the old .NET 2.0 job scheduling service, and its administrative website, and converted everything to the latest ASP.NET 4.6 environment, and enabled it to be coded and built using Visual Studio 2015.• I created 6 brand-new Windows 2012 Server virtual machines to implement this new Scheduling software: (a) DEV; (b) QA; (c) RELEASE; (d) and 3 PROD servers. I deployed the new Scheduling software to each of these new Windows 2012 server environments, to take advantage of the new .NET/server technology.• Created a new "reflection based Object Dumper" to troubleshoot how various objects were causing the PROD Portal to crash each day

Kansas City, Mo, Us

Member of a 18 person team at a national company providing health services to employers and insurance companiesFirst role included VB6 and SQL Server 2008. Role involved:• Originally hired to fulfill a fixed-end, 3-month Visual Basic 6 (VB6) contract to support converting a new client on to their data processing system• Finished the 3 projects/tasks in 2 weeks. They scrambled to find me more work to do to fill out the remainder of the 3 months• Repaired a VB6 process that was hanging and requiring the servers to reboot every morning.• Repaired a SQL Server stored procedure (for frequent updates to state sales tax information) which queried an Oracle database using embedded PL/SQL. Had to loop through the Oracle recordset due to a bug introduced with a Oracle driver update that limited the records produced by a linked query• Authored process to create XML file indexes for PDF file bundles containing signature images.• Helped derive a solution to batch create PDF files on servers, using custom software, due to prohibitively expensive Adobe licensing costs• The VB6 department only had one development workstation to develop a C#/.NET v2.0 Job Scheduling Service, along with its accompanying administrative web site, using Visual Studio 2005 (this was due to switching employee laptops to Windows 7). Created a work-around via a Windows XP Mode Virtual Machine such that any of the newer Win7 laptops could continue development for this .NET Service/Website• I completed 31 additional projects in the next 5 months, including tasks, projects and bugs that had lingered for up to 3 years• At this point, they did not want to let me go. They transferred me to their high-tech ASP.NET external web portal team

Overland Park, Ks, Us

Upgraded and enhanced two websites for a national insurance company. Technologies : ASP.NET, VB.NET and SQL Server.

Palo Alto, Ca, Us

The company I was a member and software architect for was acquired by VMWare Inc. Moving forward we will be combining the power of our analytic and benchmarking engine with their IT Business Management Suite of Services to create a financial management solution unparalleled in the industry.I was responsible for implementing new designs, modifying and enhancing existing functionality and integration of the ITHC Benchmarking Analysis Engine into the VMWare IT Business Management Suite of products.

KCWebpros provides education, information and lectures to IT professionals in the Kansas City area. We connect our attendees with our sponsors such as Riverpoint, LRS, Megaforge, Technisource, APlus.NET, GSI Hosting and Centriq. You can visit the site at : http://www.kcwebpros.com

Overland Park, Ks, Us

Taught classes in Oracle PL/SQL, DBA, Performance Tuning, Backup and Recovery, SQL Server T-SQL, SQL Server Reporting Services, C#, Java, XML/XSLT, HTML/CSS, Javascript and AJAX, Networking, PERL and Ruby

ITHC performs Cost & Efficiency Benchmarking: Any organization can benefit from assessing the cost, effectiveness and efficiency of their IT group. Traditional methods can take months to complete and can be cost prohibitive. Using a series of standardized web interface, our team gathers the necessary infrastructure, cost, staffing and complexity data to populate the models. Our solution eliminates the time, expense and subjectivity of analyst labor while providing for rapid analysis and detailed reporting within minutes of completing data collection. Our premier service is provided through our powerful online Automated Analysis EngineTM. This is an intuitive analytical system with a Web interface that allows users 24/7 access to their projects, data and history. The result: Laser focus into areas where your IT organization excels as well as insight into areas needing improvement. ITHC now also offers: Price Benchmarking, App Portfolio Benchmarking and H/W Reliability Benchmarking.

FairTaxKC is the Kansas City branch of the national organization: Americans for Fair Taxation (AFFT) - commonly known as the FairTax. You can visit their site at : http://www.fairtaxkc.com

El Dorado, Ks, Us

Taught C# Desktop Game Development Course

Senior Java and .NET Architect, architecting entire web solutions. Senior Java Architect/Developer on Suddenlink’s Customer Selfcare provisioning portal(http://home.suddenlink.net)• Suddenlink is a television, voice and high-speed data access cable company in the St. Louis area which provides coverage to North Carolina, West Virginia, Arkansas, Oklahoma, Texas and Louisiana• Provisioning website handles customer registration, email account administration, website administration, online bill payments, viewing of phone call detail records and McAfee Antivirus installs and integration• Architected and designed approximately 80% of the Selfcare Customer Portal. Authored approximately 80% of the system design documentation. Authored approximately 80% of the Selfcare Portal code base• Managed the effort to develop the email account provisioning code. Code uses the Novell LDAP library for integrating with the Openwave MX7 email server. All email accounts are managed by making LDAP calls to the Openwave LDAP directory• Architected, designed and developed the McAfee Anti-Virus Integration Project.• Conducted interviews and technical evaluations of other individuals to bring them on to the development team

Overland Park, Ks, Us

Senior/Lead .NET developer on HNTB Sophisticated Sales Approach (Momentum) intranet website (http://www.hntb.com). Project Lead and Lead .NET developer on Simon Malls Business Network website (http://www.simonbiz.net). Lead .NET developer on Wells’ Dairy’s website for Blue Bunny ice cream (http://www.bluebunny.com). Website uses templating approach to dynamically configure and create web pages using XML control files to load .NET user controls. Designed a 5-tier approach to separate and isolate web/business logic: domain object layer, service layer, persistence manager layer, database layer and web layer.Lead .NET developer on Wells’ Dairy’s website for Blue Bunny ice cream (http://www.bluebunny.com). Website uses templating approach to dynamically configure and create web pages using XML control files to load .NET user controls. Role includes:• Designed a 5-tier approach to separate and isolate web/business logic: domain object layer, service layer, persistence manager layer, database layer and web layer. • Business infrastructure uses O/R (object/relational) Mapping Framework, Objectz.NET by Mongoose Solutions to simplify business object code and database access as well as object caching for efficient web page loading. Developed the page templating approach. • Developed the user control/XML configuration file web page rendering approach. • Developed the user controls for dynamically displaying the category navigation tree and pageable product inventory display.

Kansas City, Missouri, Us

Adjunct instructor at Penn Valley Community College :: taught Microsoft Access, Beginning and Advanced Java, Novell Netware Administration, Advanced Linux Server Administration, Web Development, and Telecommunications and Networking Fundamentals

Contract for Hire to Ingenix (GeoAccess).Serving as a member of 10 person web development team maintaining over 350 websites used for medical doctor and dental provider lookups for member PPO / HMO benefit plans. Role included:• Completed 25 website upgrade projects ahead of schedule. Development involves Classic ASP, Server-side VBScript, client-side JavaScript and SQL Server 2000 Stored Procedures (T-SQL). All websites provide graphical travel routes and directions between the user and their chosen medical provider. Pioneered the development effort to use ESRI RouteMap IMS mapping software to bring the mapping capability in-house rather than using a 3rd-party leased mapping service• Modified and enhanced files for ProviderGuide (a proprietary Ingenix publishing and layout tool for PDF creation) used to dynamically create medical provider directories.• Developed techniques to detect and trap hacker efforts to “scrape data” from the websites using SQL injection

Overland Park, Kansas, Us

Member of 8-week contract, 4 member web development team at MHM/CBiz responsible for maintaining administrative (WinFlexOnline) and user (MyFlexOnline) websites used for managing and maintaining enrollment, plans and benefits in HMO/PPO plans. Role included:• Prepared for migration of sites from Classic ASP to ASP.NET with C# by documenting complete business process functionality and website flow across the two websites• Designed database upgrade to the WinFlexOnline and MyFlexOnline websites and migrated data to the new database for design and testing• Modified and upgraded 5 DTS packages responsible for sending data from the Corporate Database to the web database used by the WinFlexOnline and MyFlexOnline sites• Rewrote and converted the entire MyFlexOnline website from Classic ASP to ASP.NET with C#• Rewrote and converted several major portions of the Administrative WinFlexOnline website from Classic ASP to ASP.NET

Systems Engineer: Coded various applications on mainframe systems, client/server systems, and internet 3-tier systems. Authored entire MATRIX-ONE application to manage engineering drawings and blueprints for Honeywell Corporation.

Master'S Degree, Metaphysics

Bachelor'S Degree, Metaphysics

Msee, Electrical Engineering

Bsee, Electrical Engineering/Mathematical Sciences (Minor)