John Bogart Email & Phone Number

Salt Lake City, Utah

Salt Lake City, Utah

I write and maintain complex and ever-changing SQL scripts, functions, procedures, views, etc. for the University of Utah Development Office in order to produce reports for fundraisers and senior leadership, including in Salesforce and Tableau. I am also embedded in the University Business Intelligence team, acting as a liaison for ETL and database integrations. Our team has been implementing Salesforce for the last couple years and I have become increasingly involved in both Salesforce administration and ETL. I'm excited to continue expanding both of those skill sets.✔ Design, document, code, test, and debug programs (views, materialized views, procedures, packages, functions, etc.) using PL/SQL to generate reports which will be used by fundraisers and senior management of University Advancement.✔ Develop and maintain operational reports in Tableau for data analysis, campaign effectiveness and fundraiser metrics.✔ Develop, run, update and export Salesforce reports, analytics and dashboards to support fundraisers and management.✔ Test, review and provide feedback to reports developed by team members. ✔ Constant interaction and collaboration with senior management and fundraisers to analyze and review report/data requests to ensure reporting needs are being met.✔ Liaison between the University Development department and the University Business Intelligence department to facilitate ETL and database connections.✔ Currently studying for the Salesforce Certified Administrator certification.✔ Currently studying for Jitterbit certification.

Greater Salt Lake City Area

As a Production Planner for the Demand Planning team in Global Prepaid, I was responsible for demand planning, demand forecasting, purchasing, quality assurance, and order fulfillment in the US and Canadian B2B Direct to Consumer Prepaid Products. I also lead and supported multiple projects across all Prepaid Gift channels. I have experience with ERP systems, including Infor Visual and SAP. I am skilled with SQL and databases. I used MS Access extensively and took advanced level courses, which I leveraged to build and maintain several databases to track and analyze information about stock levels, sales, shipping, and forecast data. I also became an expert with MS Excel for data analyses and reporting, including macros, formulas, vlookups, pivot tables, etc.I am familiar with Six Sigma processes. I have taken the Green Belt certification coursework, though I did not take the certification exam.Some of my accomplishments include:✔ Incorporated seasonality into demand forecasting software, improving inventory turns✔ Improved WIP process for two large customers to reduce stock-outs and save $63,000/year✔ Recognized repeatedly for excellent communication, especially in difficult situations✔ Developed and implemented master plan for Mall channel✔ As lead of Travelers Cheque Resupply team, decreased man-hours by 80% and decreased reported issues by 82%✔ Analyzed extensive shipping data to identify cost drivers and educate decision makers✔ Determined root causes and corrective actions for several production and system issues

Greater Salt Lake City Area

I developed and lead a quality audit of all current Prepaid Gift Card products. I created the tools and trained 20+ employees across multiple departments and business units to complete the audit. As a result of my strong performance, my contract was extended and I assisted in other projects, including a peak season issues review and coordinating the documentation of all current department procedures and processes into a single manual.

Houston, Texas Area

As a business analyst for a respected Oil & Gas insurance company, I performed analyses and provided operational support for the Zurich Global Energy Underwriting team. I planned and completed multiple short-term projects for the Operations department and worked closely with many facets of the company, such as finance, underwriting, and administration.This position required strong data and operational analysis skills, including using SQL and Crystal Reports to gather and analyze data. I also showed the ability to handle and prioritize a large number of competing projects and priorities. I gained experience with the oil and gas industry, the insurance industry, as well as finances and compliance in a heavily regulated industry.Relevant accomplishments include:✔ Planned and completed multiple short-term projects for the Operations department✔ Headed project to update the collateral database to comply with all requirements✔ Developed Houston office business continuity plan, including actionable step-by-step plans

Houston, Texas Area

I was originally hired as a temporary position to provide simple data entry support for a limited time. However, I took the initiative to volunteer for additional duties and I impressed the team. I was hired on full-time after only two months.

Greater Salt Lake City Area

As a research assistant in the Psychology department at the University of Utah, I trained and supervised a coding group of four undergraduate students, I was responsible for monitoring the team's coding quality. I also performed complex statistical analyses of data and reported on the results.I was able to leverage the contacts and skills I learned in this position to successfully complete my own independent research project, including publication of the results.I clearly demonstrated statistical and analysis skills. I also learned a lot about supervising others by conducting ongoing training, providing support, and monitoring performance of my team of four. At the end of the process, I helped the professor write letters of recommendation for three of the four coding team members.

Greater Salt Lake City Area

I was responsible for coordinating the release of shipments in the Portland, OR and Vancouver, BC ports. I coordinated with Port Authorities, US and Canadian Customs, railways, trucking companies, and Accounts Receivable to ensure that all requirements were met before releasing shipments. This position required working closely with professionals and customers. It also required extensive documentation and processing to ensure compliance with multiple agencies.I learned a lot at Hanjin Shipping about shipping and warehousing. My experience coordinating shipping schedules and working with trucking and rail companies sparked my interest in Supply Chain and Logistics, as well as CRM and ERP systems.

Greater Salt Lake City Area

I was the floor supervisor for the Electronics department at Office Max. I supervised a team of up to four employees and I was responsible for customer service as well as maintaining and stocking the Electronics department. I also supported the Receiving Manager in accepting shipments into storage and getting stock out onto the floor.

West Palm Beach, Florida Area

I interviewed software developers and other departments, then assisted in translating that information into user manuals for the end users. I was heavily involved in formatting, editing, and layout for the user manuals. I helped create and update layout and style guides and I wrote and designed the training manual for documentation department. I also created and presented several PowerPoint documents for internal and external presentations.In this position, I learned about communicating effectively in writing and face-to-face conversations. I also gained extensive experience with MS Word and PowerPoint, as well as various graphic design and desktop publishing software.