John Fitzpatrick Email & Phone Number

Chandler, Az, Us

Chandler, Arizona, Us

Specializes in solving problems for a diverse customer base through the use of emerging technologies. Heavily focused on automation processes through the use of cloud platforms.

Worked with many clients to automate data flows, create advanced analytics processes and solve performance issues.- Developed all ETL processes for Indiana State COVID-19 Contact Tracing. In 1 week created Power BI report for all state & Local health department personnel to access patient & contact data

- Created, received global approval for and led a pilot project utilizing Microsoft PowerBI as a business wide decision support system. Successfully merged 8 departmental functions into a single automated dashboard.- Automated the integration of SalesForce, Oracle, SAP and other enterprise data sources for real-time monitoring including alerts and predictive / prescriptive analytics.- Developed material and trained more than 50 co-workers on PowerBI, PowerQuery and PowerPivot. Provided coaching and mentoring to 10+ developers who designed and built real-time tools which monitor production, workforce alocation, supplier compliance, inventory management, accounting, service and quality.

- Created a warranty accrual model using information from all pertinent data sources to accurately predict 10+ years of field failures for over 2 million shipped products based upon historical failure rates. The model was a major contributor to the Power-One acquisition by ABB ($1B) with ≈1% variance from actual field failure rates. The accrual model also passed 3 external audits from Deloitte and Ernst & Young with high praises.- Direct company interface for all customer quality issues. Led weekly meetings with senior quality leadership at 4 top-tier customers. Wrote and submitted over 100 customer Root Cause / Corrective Action reports.- Global Project Lead for the Early Warning System (EWS), a BI tool using over 60TB of mixed data to identify key issues in real time to resolve issues and provide automated customer, product, and regional analysis.- Created processes to automate the ETL and data quality cleaning from multiple sources (Oracle, SalesForce, MySQL, factory test equipment, etc.), which automatically populate quality reports (failure trends and pareto analysis) and distribute the reports via email and web-based dashboards to globally distributed teams.

- Created a data warehouse using three MySQL instances to extract information from more than 10 data sources.- Used Pentaho Data-Integration for automated ETL jobs, data quality analysis and to export multiple reports providing near-real-time access to metrics which previously required 80+ man hours per month to compile.- Designed and developed five global dashboards for quality monitoring and gap analysis. Empowered multiple departments to identify problem areas, create solutions, and monitor their effectiveness.- Quality project manager for global projects in the development and implementation of the Agile PLM Product Quality Module as the company’s global Quality Management System and Best Practices tool. ($600k+ Budget)- Responsible for Global Quality department SharePoint Administration. Created themes, workflows, lists, pages, and processes; managed all permissions; and created training materials for the global team of more than 60.

- Tracked over 400 personnel records, ensuring timely evaluation and recognition of achievements.- Maintained all regulations, instructions, correspondence, and the command budget of more than $7 million.- Planned over 100 Distinguished Visitor itineraries for travel to the Chinhae area, including the Secretary of Defense, Secretary of the Navy, Chief of Naval Operations, and Commanders, U.S. Forces Korea and 7th Fleet.- Served as the Base Commander on numerous occasions when the Commanding Officer was not available.- Initiated a monthly meeting with U.S. and Korean Naval officers for integrated planning opportunities.- Developed and participated in eight one-week-long English immersion classes for Korean sailors. Earned an award from the Chief of Naval Operations, Republic of Korea, for the Command’s role.- Extra duties: Installation Webmaster, Public Affairs Officer, Training Officer, Protocol Officer, Senior Watch Officer, and served for two months as acting Executive Officer.

- Planned operational exercises and responses to various wartime scenarios, and led the command response in six Tier I Joint / Combined Exercises, ensuring effective mission capability for the U.S. Navy in South Korea.- Requested funding ($8M+), helped design, and oversaw set-up of the Regional Maritime Operations Center.

- Published a weekly news story in the local newspaper highlighting different base departments or events.- Scripted, filmed, produced and edited a weekly news story for the local news station. Put together a multi-national team, and developed an 88-item checklist based upon 14 regulations the U.S. Government, Department of Defense and U.S. Navy have adopted regarding publicly accessible websites. - Re-coded the command website to ensure 100% compliance with all applicable regulations.

As the First Lieutenant, I was in charge of all deck operations on the ship (painting, line handling, small boats, search and rescue operations, underway replenishments, preventative maintenance, safety, training, and many other tasks). As an officer on the ship I qualified as the Officer of the Deck, and was trained as the Electronic Warfare Officer. I also volunteered to take care of the commands website but it has been changes since I left the ship.- Supervised 46 Sailors in the performance of seamanship functions and evolutions. Prepared work schedules, directed mooring, docking, anchoring, fueling, towing and transferring of personnel and cargo at sea. - Directed operations and maintenance of deck machinery, arranged for cargo handling, assigned boats and boat crews, maintained readiness of boats and survival equipment. Directed the preservation of weather decks, ships exterior, running gear, ground tackle and boatswain's stores.- Designed and maintained the ship's public website.

- Developed and managed a system to track all incoming freshmen's attendance at all training activities. - Designed and maintained the Intranet and Internet websites for all summer training. Led the merger of over 280 web servers into 1 to bring the U.S. Naval Academy web presence in alignment with Department of Defense policies.

As Regimental Midshipmen Information Systems Liaison Officer, was responsible for all computer issues for over 850 students. Designed and maintained the Regiment website and provided tech support.

- Managed 68 Sailors. Was responsible for ensuring all maintenance tasks were completed according to procedures. Ran the engine room's Quality Assurance program.- Was placed in charge of the Main Reduction Gears (worth over $50M).

Bs, General Engineering

Education record