John Fulmer Email & Phone Number

Seattle, Wa, Us

Prime Decision Sciences - Global Prime

Seattle, Wa, Us

Prime Decision Sciences - Global Prime

Seattle, Wa, Us

Global Prime

Seattle, Wa, Us

Global Prime• Rearchitected the Prime Member Spend Insights (PMSI) data pipeline (+35TB) to reduce data size by 11% and monthly cost by 82% while incorporating engineering best practices in ETL design, data retention, and database management. Aligned teams on the new source of truth and deprecated the legacy PMOPS pipeline to provide stakeholders with consistent metrics. Identified and corrected data quality issues resulting in a 6-18% adjustment in spend metrics.• Developed a Prime Downstream Impact (DSI) Tableau dashboard to automate +150 hours of annual manual effort which has more than 1,900 views by +155 unique users since 4Q 2020.• Created a scalable Prime subscription stacking Authoritative Supporting Document (ASD) to align what the Prime business recognizes for revenue with what is booked to the General Ledger and identified +$13MM in missing invoices as well as gaps between source systems.• Standardized engineering excellence within Prime BI and DE teams by outlining best practices, developing a change management process, and acquiring support from peers and leadership.• Developing an automated DSI workflow by leveraging SQL, Python, Andes, and Redshift to eliminate +312 hours of annual manual BI effort and increase the frequency in which stakeholders can consume an analyze data from annually to monthly.

Seattle, Wa, Us

Global Prime• Served as the technical POC for Per Member Order Product Sales (PMOPS), one of the more complex data pipelines involving 8 tiered aggregation tables with a combined size of over 279 billion records. Supported in identifying and correcting data quality issues and ensured timely responses to S-team requirements.• Led the development of Prime Downstream Impact (DSI) generation and brought this workflow in-house through directly using APIs and AWS technologies. Rearchitected prior DSI calculations and introduced new dimensions based on benefit usage and plan change events to guide investment decisions. Developed a DSI roadmap to help prioritize future DSI improvement opportunities.• Simplified Prime Benefits monthly business review reporting by reducing code required by half and expanded reporting to provide additional insight though introducing business relevant data cuts including Tenure Bucket, Program, and new groupings of Benefit engagement.• Analyzed the impact of the Prime Insider newsletter on customer purchase behavior, which resulted in a statistically significant impact to outputs such as Units, OPS and Frequency of Purchase and helped the marketing team justify investment.

Seattle, Wa, Us

Amazon Air• Lead the development of network financial metrics for daily, weekly, monthly, and quarterly business reviews, and present the commentary on behalf of the finance team to business leadership• Created 50+ ETLM jobs, 30+ Redshift data tables, and 28+ automated Tableau dashboards to take the team from not having any automated reports to having automated reports for all key metrics• Developed a linear regression model to predict 3P baseline costs, which is used to estimate cost savings during special operating periods and understand the financial impact of package mix

Arlington, Va, Us

Lead Analyst, Fuselage Industry Assist & Boeing Defense ForecastingTeam Lead, Employee Recognition Team (14 Members)*Responsible for leading the organization, planning, and execution of group events and recognition activities for the 100+ person 777X Finance teamMember, Business Skills Rotation Program 777X Financial Operations• Engage with Scheduling, Engineering, and various other business partners to develop and manage monthly $M R&D forecasts and the reporting of variance analysis to executive decision makers• Reduce CSPR system errors by 92% to improve the capture and validity of Earned Value Management metrics and variance analysis for the non-recurring cost of Fuselage SOW• Develop and implement new weekly metrics to increase the visibility of financial performance, areas where help is needed, and upcoming deliverables to better manage R&D expenditures• Utilize EFBI Cognos to provide real-time automated reporting of R&D expenditures to improve management of the 777X Long Range Business Plan and mitigate issues before becoming serious• Prepare educational material and facilitate the weekly training of EFBI Cognos for 9 analysts to improve and automate reporting processes and improve the skillsets of employees• Coordinate with Accounting and Supplier Management to manage the quarterly accruals of supplier costs and various other purchased services costs

Arlington, Va, Us

Lead Analyst, 777X Program Business CaseLead Analyst, 777FX Preliminary Business CaseDeveloper & Presenter, Economies of Scale Cost ModelDeveloper & Presenter, Synergy Cost Model Team Lead, Employee Recognition Team (10 Members)*Responsible for leading the organization, planning, and execution of recognition activities for the 100+ person 777X Finance teamMember, Business Skills Rotation Program 777X Estimating & Pricing• Conducted ad-hoc analysis and led the monthly update of the 777X program business case, in addition to regularly presenting status changes and variance analyses to executive decision makers• Operated in an ambiguous environment while developing scenarios and forecasts for revenues, expenditures, and market sizes for the narrowly-defined 777X Freighter program prior to its launch• Conducted business case analyses for airplane configuration changes that improve cost, weight, or address other customer interests, and made recommendations to executive decision makers• Successfully reduced a widely-used business plan presentation and provided public speaking coaching to significantly save time and increase the confidence of teammates

Arlington, Va, Us

777X Development Program Estimating & PricingInformation carried over to and expanded in Financial Analyst II position.

Seattle, Wa, Us

• Warmly answer phone calls from SU students and affiliates to schedule a driver to pick up and drop off parties from on and off campus locations. • Quickly dispatch scheduled phone calls to on-duty drivers to ensure the most timely service• Safely and efficiently transport SU students and affiliates on and off campus with school-provided vehicles

Seattle, Wa, Us

• Dedicated 4 hours a week to coaching 8 children between the ages of 2 and 12• Educated children on the importance of water safety• Analyzed and critiqued stroke technique to improve swimming competency• Engaged with parents to understand the goals they had for their children's swimming ability

Arlington, Va, Us

• Improve analytical and communication skills through independently updating the recurring parametric estimate for the 777X program and presenting the results to executive decision makers• Demonstrate initiative by leading a basis of estimate validation exercise to ensure internal estimating compliance with the future audit of the 777X program• Exemplify adaptability through working with other 777X teams to lead, develop, and present various trade studies to managers and executive decision makers• Restructure the basis of estimate validation workbook to include additional information and increase the likelihood of compliance with the internal estimating audit of the 777X program

Started by two college students in the heart of the Pacific Northwest, Alder Street Apparel is your destination for high-quality and affordable apparel. Whether you want to represent this beautiful region we call home through our custom designs, or need us to print or design t-shirts for your own organization, Alder Street Apparel is here for you!• Designed graphics and sourced apparel of all types to fulfill orders from individuals, groups and clubs, and companies• Maintained book of accounts to track financial performance of the company and prepare documents for annual sales and business taxes• Conducted market analysis to ensure competitive pricing of graphic design services and apparel prices• Negotiated contract and partnership agreements with suppliers, customers, and members of the company http://alderstreetapparel.com/

Bellevue, Washington, Us

• Individually created a 60-minute presentation to be given to all new hires on the roles and responsibilities of the supply chain to promote effective cross-functional communication• Developed teamwork skills and business acumen by cooperating with a team of 12 specialists to improve supply chain planning and ensure optimum inventory levels at third party warehouses• Redesigned the process for the supply planning team’s service level tracking report through the data collection of various metrics to ascertain opportunities for improved customer service• Applied decision-making skills to verify the accuracy on purchase order confirmations regularly exceeding $150,000 to identify potential delays due to pricing and quantity discrepancies • Established stronger understanding of system management applications to include Onyx CRM, Microsoft Dynamics GP, Logility, and multiple ChemPoint proprietary databases• Advanced analytical skills through data-intensive projects concerning customer demand trends• Updated supplier costs and customer pricing tiers in corporate database to support accurate calculations of margins and reduce pricing errors on customer invoices

• Trained and evaluated 5 new employees to increase productivity in parts production• Collaborated with a team of 8 to assure the quality and efficient distribution of products• Multi-tasked in a fast paced environment by managing orders and assisting co-workers• Worked +40 hours/week and took initiative to complete customer orders and office tasks

• Trained 4 new employees on company policies and procedures• Participated in internal and external communications by talking to patrons, co-workers, and general inquirers in person and over the phone• Worked +20 hours/week and assumed greater levels of responsibility in short time• Established positive and enduring relationships with customers

Master Of Science (M.S.), Business Analytics, Concentration In Finance

Bachelor Of Arts In Business Administration Degree, Business Economics And Marketing

Associate In Arts (A.A.)