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.
• 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.

• 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.
• 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

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.

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.

• 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.
• 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.
• 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.
• 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.
• 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