Jon Carpenter Email & Phone Number

Tucson, Az, Us

Tucson, Az, Us

• Led planning, budgeting, implementation and administration of all Business Intelligence and Data Integration and Warehousing tools including: Azure Data Lake Storage, Snowflake, SAP Business Objects, Power BI, and Qlik Data Integration.• Led the modernization of Pima County’s Enterprise Data Warehouse and Business Intelligence platform resulting in an annual savings of $1M year over year in software and infrastructure costs.• Led team of data engineers and analysts who re-designed 500+ reports and dashboards with no service interruption.• Directly supervised team of devOps and 11 data engineers that managed data pipelines from 30 distinct sources.• Owned Pima County’s data and analytics and govenernance strategy from a technological perspective.• Evaluated, selected, and procured software for analytics, data warehousing, data governance and data integration.• Responsible for the creation and maintenance of standards, procedures and development methodologies.• Collaborated with managers/directors across the county to understand BI and reporting needs and pain points, managed and prioritized work to address those needs.

Tucson, Az, Us

• Served as project manager for SAP Business Objects, Qlik Data Integration implementation projects. • Designed reporting architecture and platform configuration requirements for historical and operational reporting.• Led project management and execution efforts to convert over 200 financial reports to SAP Web Intelligence.• Responsible for SAP Business Objects, Data Services and SSRS administration, including system configuration, security and lifecycle management.• Evaluated data acquisition and monitoring software products and provided recommendations to management.• Responsible for ongoing system maintenance strategies and system upgrades to ensure minimal impact to County staff and Constiutents. • Identified and escalated project issues and risks and successfully implemented risk mitigation strategies. • Mentored staff on the use of modern analytics tools, data architectures, and technical processes.• Responsible for the design and implementation of reporting design standards across the County. • Gathered, analyzed, and documented functional requirements and data specifications for data models and dashboards.• Developed functional and technical testing plans for reports and dimensional models.

Tucson, Az, Us

• Acted as Scrum Master for multiple implementations, including financial reporting, financial data warehousing, Tax Assembly, CRM, and SharePoint.• Served as Project Manager for Business Objects 4.1 implementation while successfully meeting project deadlines.• Designed reporting architecture for AMS, Maximo, Performance Budgeting and Fleet Management systems. • Modernized financial reporting throughout the County by implemenating a financial data warehouse built on SQL Server.• Analyzed processes/procedures and created process maps and documentation for Finance and Fleet Services.• Created high-level architectural design documentation for financial reporting and Fleet Services systems.• Implemented new reporting architecture and security model for Fleet Services applications.• Gathered, analyzed and documented functional requirements and data specifications for reports and data models. • Create web application for a SQL data dictionary that included database metadata from 1400 County database servers.

Tucson, Arizona, Us

• Served as Project Manager and Analyst for IT related projects.• Worked with IT leadership to develop a project management and business analysis mythology in line with best practices and industry standards.• Created project management and business analysis templates/forms for use by the Project Management Office.• Designed and implemented a custom project management system built on SharePoint 2010.• Analyzed and documented databases in preparation for disposition and archival.• Analyzed processes and procedures to create process maps and documentation.• Interviewed customers to gather functional requirements and define scope, goals and deliverables.• Evaluated software to determine a match with customer needs.• Analyzed UAccess systems to identify opportunities for the college to replace outdated shadow systems and processes.• Drafted training materials for use with SharePoint and ArizonaMed Online.• Developed testing scripts and coordinated all testing for the College of Medicine’s curriculum management system (ArizonaMed).• Managed and maintained project schedules, status reports, and deliverables, and regularly updated Project Sponsor and IT management.

Tucson, Arizona, Us

•Designed and implemented entire organizational document management system built on a SharePoint foundation.•Worked with stakeholders to gather functional requirements and define scope, goals and deliverables.•Developed technical specifications for software projects. •Developed project plans and baselines.• Tracked and monitored project milestones and reported status.•Analyzed processes and procedures and created process maps and documentation.•Identified areas for improvement within existing project management methodology and implemented solutions for use by project management team.

• Gathered technical and non-technical requirements for IOS coupon application.• Developed technical specifications for application.• Participated in negotiations with major food retailers.• Collaborated with technical staff to insure product was developed within time, scope and budget.• Created five-year financial projections and budget requirements.• Researched market conditions to determine best product placement.• Pitched company to potential investors and subject experts.• Created a five-year business plan.

•Provided fiscal, strategic and operation leadership to improve profits, while revamping procedures and controls to improve data-driven decision making. •Developed/implemented computer cost tracking system for $2 million savings over four years.•Increased revenues 25% by expanding client base to local and state governments. •Led company to receive Raytheon Missile Systems 2004 Contractor of the Year Award for simultaneous execution of three complex projects.

•Led preparation of proposals and contract negotiations, oversaw contract administration and process change orders, and handled customer interaction to provide proper contract acquisition and fulfillment services.•Supervised and approved estimates of material, equipment services, production costs, performance requirements, and delivery schedules to ensure accuracy and completeness. • Led all aspects of bidding process, including specification preparation through progress reporting.•Drafted, negotiated and managed contracts for construction, services and materials.•Administered change orders ensuring legal/contractual compliance and rapid dispute resolution.•Increased profits by $100,000 annually by developing and implementing a new method of multi-project cost tracking, exceeding budgetary constraints and meeting customer expectations.•Designed and implemented corporate safety plan in accordance with OSHA regulations.

Mba, Management Information Systems

Certificate, Entrepreneurship

Bachelor Of Science, Economics

Education record