Jon Schmidt Email & Phone Number

Phoenix, Arizona, United States

Phoenix, Arizona, United States

Phoenix, Arizona Area

Tucson, Arizona

Developed automated ETL processes for Pima County Address/Parcel/Owner (APO) data using MS SQL Analysis Services Data requiring data conversion, and integration of multiple data sets. Responsible for developing a mix of relational database design, modeling, and support across a variety of database platforms that include the Geographic Information Systems (GIS), Assessor, and Treasurer database systems.Designed and developed the database and ETL architecture for Inspection Routing and Tracking system to be used for public use.Participate and lead the development of Data Mart database requirements, design specifications, transforming database models and entities into database objects, and refining conceptual requirements into detailed technical designs for Pima County IT.Developed dimension and fact tables from the APO data as well as Accela Automation data.Coordinated implementation and deployment of database objects and data base replication with Pima County database administrators to multiple environments including the production environment.Develop and deploy reports with MS SQL Reporting Services to be used for the Accela Automation portal.Gather requirements for report data warehouse specifications with customer interaction.Prepare specification documentation pertaining to reporting, database systems, and business applications.Have functional level knowledge of the Accela Automation platform, with experience with reporting and record type configuration and developing reports, letters, invoices, and receipts for the Pima County Development Services Department (DSD) and Department of Environmental Quality (DEQ).

Tucson, Arizona Area

Direct and coordinate activities in the I.S. Development, Data Operations, and I.S. Planning departments that include requirements gathering, systems design, development, testing, deployment, and support. Coordinate and facilitate I.S. development projects throughout several departments and functional units within Clinical and Business Operations.Coordinate and facilitate I.S. development projects throughout several contracted service providers and government stakeholders. Responsible for maintaining a 24/7 enterprise information system operation for transaction processing, data mart maintenance, and web application support. Manage claim and membership transactions for over 100 providers with responsibility to build strong relationships with Comprehensive Network Providers, hospitals and corporate internal departments. Restructured the I.S. Department to better address the needs and requirements of the company. Enhanced procedures to improve the Quality Assurance and Development process of the Software Development Lifecycle that includes Agile Software Development methodologies. Develop transaction processing reports to ensure data integrity, identifying issues with submissions, and compliance tracking. Facilitate monthly meetings with stakeholders, and monitor provider transaction processing performance.Streamlined day-to-day data processing procedures to improve request response time.Staff augmentation using contractors and software implementation consultants to provide necessary uplift to improve core system platforms.

Tucson, Arizona Area

Consistently achieved goals to maintain compliance for all State requirements for healthcare system enhancements within deadlines. These were achieved through the coordination of requirements gathering, systems and database design, development, testing, and implementation of deliverables. Responsible for the documentation of functional requirements, technical design, and unit testing. Integrated stand-alone business systems into core information systems. Experience in coordinating the development of Business Intelligence platforms including the use of dynamic key performance indicators (KPI), dashboards, and interactive drill-down reports. Implemented, managed, and maintained the development and test systems to simulate the production system.  Developed the Software Development Lifecycle policies and procedures.  Experience in coordinating and facilitating project teams in through the Software Development Lifecycle. Developed and enforced code requirements, unit testing, and peer review policies. Designed, implemented and maintained the data warehouse used by the utilization and financial analysts. Hired the necessary personnel to develop and maintain core business applications. Served as the primary technical liaison for the company and Pharmacy Benefit Manager (PBM). Developed a prescription system that retrieved hourly batch files from several providers and displaying the information through a web application. Developed an automated process for extracting pharmacy information and submitting pharmacy claims using the NCPDP Telecommunications standards.

Tucson, Arizona Area

Developed tracking systems and ETL processes.

Tucson, Arizona Area

Developed and automated financial reporting for the Finance department.

Tucson, Arizona Area

Responsible for fiscal budgeting and determining monthly provider payments.Provided analysis for pharmacy claims processing for financial and medical management reporting.

Tucson, Arizona Area

Kalamazoo, Michigan Area

Ms, Computer Information Systems

Courses focused on project management, operating systems, database design, network development, software engineering and quality.

Bba, Finance/Computer Information Systems

Activities and Societies: Delta Sigma PIFocus on courses that pertain to financial analysis, portfolio/asset management, and banking.