John Fulmer's Location
Greater Seattle Area, United States, United States
John Fulmer's Contact Details
John Fulmer work email
- Valid
- Valid
John Fulmer personal email
n/a
John Fulmer phone numbers
About John Fulmer
John values hard work, leadership, and accountability. He prides himself in the ability to conduct complex analysis and explain its results in a simple and convincing way to a variety of different audiences. The guiding force behind the decisions John makes both in his career and personal life is rooted in the desire to be uncomfortable, as that is where growth truly begins.PROFICIENCIES: Advanced SQL, AWS Stack (S3, Redshift, EC2, IAM, Glue, RDS, etc.), Shell Scripting, Linux, Visualization (Tableau, Quicksight, R Shiny), Advanced Excel, Machine Learning, R, Python, Database Management, Optimization.
John Fulmer Work Experience Details
-
Business Intelligence Manager IiiAmazon Apr 2022 - PresentSeattle, Wa, UsPrime Decision Sciences - Global Prime -
Sr. Business Intelligence EngineerAmazon Feb 2022 - Aug 2022Seattle, Wa, UsPrime Decision Sciences - Global Prime
-
Sr. Business Intelligence EngineerAmazon Dec 2021 - Feb 2022Seattle, Wa, UsGlobal Prime
-
Business Intelligence Engineer IiAmazon Aug 2019 - Dec 2021Seattle, Wa, UsGlobal 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.
-
Business Analyst IiAmazon Nov 2018 - Aug 2019Seattle, Wa, UsGlobal 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.
-
Financial Analyst IiAmazon May 2017 - Nov 2018Seattle, Wa, UsAmazon 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
-
PresidentSeattle University Graduates Of The Last Decade (Gold) Sep 2017 - Present
-
FounderHonest Balm May 2017 - Jul 2018 -
FounderAcculitics.Com Feb 2016 - Jul 2018 -
Business Analyst IiBoeing Aug 2016 - May 2017Arlington, Va, UsLead 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 -
Financial Analyst IiBoeing Apr 2016 - Aug 2016Arlington, Va, UsLead 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
-
Financial Analyst IBoeing Jun 2015 - Apr 2016Arlington, Va, Us777X Development Program Estimating & PricingInformation carried over to and expanded in Financial Analyst II position.
-
Night Hawk Safety EscortSeattle University Mar 2015 - Jun 2015Seattle, 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 -
Swimming InstructorSeattle University Sep 2012 - Jun 2015Seattle, 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
-
777X Estimating & Pricing Analyst InternBoeing Jun 2014 - Sep 2014Arlington, 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
-
Ceo And Co-FounderAlder Street Apparel Sep 2013 - Jun 2014Started 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/
-
Supply Chain Management Intern - Supplier SolutionsChempoint Jun 2013 - Sep 2013Bellevue, 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 -
Manufacturing And InstallingKdl Enterprises, Inc. Jun 2012 - Sep 2012• 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
-
Lifeguard And Office AssistantKent Swim And Tennis Club May 2012 - Sep 2012• 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
John Fulmer Skills
Leadership
Time Management
Public Speaking
Customer Service
Data Analysis
Microsoft Office
Communication
Research
Committed To Professionalism
Team Building
Analysis
Critical Thinking
Editing
Financial Analysis
Teamwork
Statistics
R
Python
Power Bi
Forecasting
Microsoft Word
John Fulmer Education Details
-
Seattle UniversityConcentration In Finance -
Seattle UniversityBusiness Economics And Marketing
-
Green River CollegeAssociate In Arts (A.A.)
Frequently Asked Questions about John Fulmer
What company does John Fulmer work for?
John Fulmer works for Amazon
What is John Fulmer's role at the current company?
John Fulmer's current role is Manager, Business Intelligence at Amazon.
What is John Fulmer's email address?
John Fulmer's email address is fu****@****zon.com
What is John Fulmer's direct phone number?
John Fulmer's direct phone number is +120630*****
What schools did John Fulmer attend?
John Fulmer attended Seattle University, Seattle University, Green River College.
What are some of John Fulmer's interests?
John Fulmer has interest in Education, Environment, Science And Technology, Arts And Culture, Health.
What skills is John Fulmer known for?
John Fulmer has skills like Leadership, Time Management, Public Speaking, Customer Service, Data Analysis, Microsoft Office, Communication, Research, Committed To Professionalism, Team Building, Analysis, Critical Thinking.
Free Chrome Extension
Find emails, phones & company data instantly
Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Aero Online
Your AI prospecting assistant
Select data to include:
Total price:
$0.00
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial