Ronald Schultz Email & Phone Number

Los Angeles, Ca, Us

Manage and provide technical oversight (SME) for UCLA Medical Financial Systems operations, including IT applications, financial systems infrastructure, and technical staff. Manage, develop and maintain applications, database / web servers, reporting and overall operations within Finance. Collaborate with Financial Systems team members, General Accounting, Payroll, Budget, General Ledger, Campus Data-warehouse / GCQ, PBS, ANSOS/Onestaff, Accounts Receivable, and Human Resource groups. Develop and implement change controls, vendor updates, enhancements, automation, and reports using SQL, UNIX shell, MS Visual Basic SSIS / Powershell scripts. Partner with Infrastructure teams including, data warehousing, IT OPS / server, Desktop, ID Management, Network, Firewall, and Security to maintain database, web servers, and card readers.• Develop automation for Payroll processes, install and configure web-based HBS Payroll and reporting systems.• Manage and process weekly Cashnet credit card payment transaction retrieval and reporting system between medical center and UCLA campus 3rd party Smartsource card processor• Develop reports for Payroll / Budget / Accounting dept management using: Business Objects / PowerBI, SSRS, SQL Server 2016, Oracle 11G.• Manage, mentor, motivate, collaborate, provide leadership and technical subject matter expertise. • Managed claims, remittance, and credit card payment transaction retrieval and reporting system utilizing 3rd party card processor. • Implement change control formal processes including documentation, templates, management sign-off and policies. • Developed and implemented high availability (HA), disaster recovery (DR) plan for payroll application and database servers. • Investigate Financial Systems production issues including applications, web and SQL database servers.

Administered, maintained and developed SQL Server 2008 R2, 2012 databases for UCLA Neurosurgery Department. Developed and managed applications, systems, installations, enhancements, tuning, backups, maintenance, and testing. Developed ETL data feeds (SSIS), stored procedures, and SQL reports (SSRS), for Neurosurgery Management (CFO, Chief of Neurosurgery, 10+ Residents). Developed SQL procedures / SSIS packages to read, parse, aggregate and report on patient demographic data from ADT System, OR Case Log from ORMIS, ICU Fluids from Essentris, clinic financial charges from FPG (Faculty Practice Group), and hospital charges from EPSI.• Managed and mentored work-studies projects, and approved time-sheets.• Troubleshot and managed GCQ brain scan / imaging system database application• Managed annual fundraising database marketing effort utilizing SQL Server ETL extracts• Provided 24 x 7 production support for multiple database servers and database versions of SQL Server• Developed, administered and maintained production, and testing environments• Tuned table indexes, implemented query modifications, partitioning and storage hardware optimization• Developed and maintained SQL Server backup/restore and disaster recovery / DR plans for production servers• Helped develop physician's notes application utilizing SQL Server full-text search.• Developed procedures to summarize / aggregate physician data for monthly Neurosurgery dashboard.

Thousand Oaks , California, Us

Worked directly with CCO (Chief Compliance Officer), CIO, department and trading desk managers to implement and integrate timely technology solutions. Managed applications development and deployment, reporting, disaster recovery, and automated compliance systems. Supported Compliance systems and management / analysis of issues. Gatherd requirements and specifications documentation for team members. Managed and delegated tasks for team members. Managed, directed and mentored Jones on and off site consultants for development and support. Managed and architect complete software and database (SDLC) systems for Back Office Systems Dept. Responsibilities included: interfacing with users in gathering and defining requirements, creating specifications, developing physical database models and schema, creating SQL Server stored procedures, developing WinForms (desktop) and Web-based (IIS Web server) n-tier applications. Developed web-based (IIS Server), and WinForm (Desktop) systems for the Finance, Compliance, New Accounts and Trading departments utilizing the following technologies: Excel, Javascript, Visual Studio 2008, SQL Server 2005, C# .Net, Windows Server 2003/XP, IIS, Visual Source Safe, MS Reporting Services (SSRS), Integration Services (SSIS), MS Project, Web Services, and SOA. Additional responsibilities include but not limited to: managing 3rd party OMS / Market Data Vendors (Bloomberg / Ipreo / Fidessa / Mixit / Pension) and clients (trading desk managers / clerks / department managers), and assigning projects for off-site contractors.

New York, Ny, Us

Managed and developed customized web-based and WinForm (desktop), trading, reporting, and OMS (order management system) integration projects for 30+ ITG West Coast and Canadian clients. Independently responsible for requirements, development, analysis, and management of complete (SDLC) of multi-platform (Win 2003 / SUN Solaris) customized trade order management, portfolio generation, and reporting systems. Created and gathered requirements and specifications; designed, tested, documented, integrated, installed, and supported web-based and desktop customized software solutions using: Sybase, SQL Server 2005, C#, Perl/Tk, Crystal Reports 8.5, Windows 2003, and SUN Solaris 2.6. Analyze and develop complete systems to fully automate portfolio generation, trading and reporting for external mutual and pension fund clients.

Developed, managed, and administered Countrywide Home Loan Marketing Department’s production data warehousing, decision support, ETL, and reporting systems. Provided DBA skills consisting of: utility scripts, backups, capacity planning, patches, upgrades, monitoring SQL jobs / contention. Utilized; SQL Server 7, AS400 DB2, Visual C++, Visual Basic 6.0, Cold Fusion, and Erwin database modeling software.• Responsibilities included database maintenance, general data extraction, transformation and loading (ETL), and monitored nightly SQL Server jobs in support of data warehouse. Created ad-hoc queries, and stored procedures in support of various marketing campaign solicitations.• Projects included Solicitation Data Mart, and Marketing Dept. “Do-not-solicit” (DNS) SQL Server database. This incorporated multiple Marketing Dept data sources; including Lotus Notes, telemarketing, government, replicated AS400 loan data and external solicitations. This system populated CHL’s DNS database, and responsible for decreased errant customer solicitations.• Managed, scrubbed, cleaned duplicates and supported externally purchased mailing lists for integration with mass marketing campaigns within CHLs data warehouse.• Developed, optimized complex SQL matching algorithms, stored procedures, functions, views, and tables for fast record indexing, manipulation, replication, and data cleansing of gigabyte databases in support of marketing campaigns, and intranet reporting.• Performed FTP download and database (ETL) loading of CHL 3rd party marketing lists. Interfaced with contracted external market data vendors regarding technical specifications and list types.

Masters, Information Technology

Bsae, Aerospace Engineering