Justin Cummings Email & Phone Number

San Francisco, California, Us

Boston, Ma, Us

---Led Indigo’s Strategic Business Analysis function; responsibilities included crafting and ruthlessly prioritizing a roadmap of strategic projects, developing and owning stakeholder relationships, managing and coaching a lead analyst, and delivering actionable insights that were used to answer challenging business questions and drive mission-critical business decisions---Performed a comparative return on investment analysis covering all of the Technology organization’s 2023 annual operating plan initiatives; advised the Vice President of Financial Planning & Analysis on how to best allocate Tech’s $100M+ budget---Produced an in-depth customer retention and churn analysis for Indigo’s Carbon offering, which the Commercial Operations, Product Management, and Product Marketing teams leveraged to achieve a YoY customer retention level of 90%; shared the quantitative and qualitative findings and data-driven recommendations in an extensive report and presentation package---Collaborated with the Head of Carbon Partner Management to structure, implement, and measure the effectiveness of acreage enrollment incentives for partner-based farmers; these incentives resulted in a 25% increase in acres enrolled in the program---Constructed a dynamic Excel model that forecasted 2023-2027 acreage and revenue projections for Indigo’s Carbon offering; baked in the functionality to assess the impact of various customer attribute and business funnel conversion rate assumptions---Fostered an environment of inclusivity, belonging, and openness by leading and acting with empathy, curiosity, and honesty

Boston, Ma, Us

---Managed a high-performing BI unit focused on balancing quality with speed to support Indigo’s rapidly growing business offerings; delivered 10 Looker dashboards that collectively averaged 1000+ views and 100+ unique users each month---Drove process improvements that reduced the time required to compile key operating metric updates for the quarterly Board of Directors meeting from 5 days to 2 days; published a RACI framework for all metrics and used Jira to manage the process---Quarterbacked a cross-functional, executive-sponsored initiative to build a “daily flash report” Looker dashboard that showed the performance vs. target of Indigo’s top 10 operating metrics; project manager responsibilities included creating a project timeline with milestones, delegating tasks, monitoring progress, and presenting updates to the executive sponsor committee---Partnered with the Commercial Operations, Product Management, and Software/Data Engineering teams to coordinate the recurring process of defining new data and reporting requirements for the business, surfacing the necessary structured and formatted data into governed data marts in Snowflake, and standing up centralized, scalable performance reporting in Looker---Acted as a data evangelist, promoting a data-driven culture and empowering stakeholders to leverage data in decision-making---Resolved dashboard breakages and data quality issues in a timely manner to ensure minimal disruption to business operations

Boston, Ma, Us

---Architected a network of financial reporting SQL tables in Snowflake using a star database organizational structure, enabling the accurate, on-time delivery of monthly results, and reducing the time required to compile results from 3 days to 1 day---Teamed up with the Commercial Operations squad to create 4 Salesforce dashboards that displayed the health and status of the customer sales pipeline across each of Indigo’s offerings, which consisted of 500+ active customer accounts---Supported the annual operating plan forecasting process by creating an Excel model that streamlined the aggregation and presentation of results, which accounted for hundreds of full-time employees and millions of dollars in revenue and expenses

Boston, Ma, Us

---Managed and mentored a group of 4 analysts with the collective team goal of leveraging financial and operational data to make thoughtful supplier pricing decisions that ensured a healthy balance of profitability and business growth---Worked with the warehouse Industrial Engineering team to brainstorm, scope and implement various cost savings initiatives across the North America distribution network, resulting in a 25% reduction in per unit fulfillment economics---Teamed up with the business development and account management leadership teams to identify opportunity areas to expand market share through creative pricing strategies that drove CastleGate penetration and overall Wayfair sales---Partnered with Finance to compile the monthly CastleGate P&L and analyzed the results to uncover key strategic insights---Owned the CastleGate 5Q forecast, projecting over $100M in services revenue across 10 warehouses and 500 suppliers---Collaborated with the business development and account management leadership teams to identify opportunity areas to expand market share through creative pricing strategies that drove CastleGate penetration and overall Wayfair sales---Volunteered to take on the workload and headcount (2 analysts) of the CastleGate/Warehouse Strategic Operational Finance team for 4 months while leadership in that organization worked to fill an open director role

Boston, Ma, Us

---Planned and crafted an Excel and SQL based pricing model from scratch as part of the low price point goods expansion initiative, unlocking new product categories and increasing annual outbound unit volume by over 100% in less than a year---Spearheaded a successful standard cost assumptions update for the entire Wayfair business, cross-functionally communicating and collaborating with a wide variety of teams, including Industrial Engineering, Finance, and Technology---Trained new CastleGate team members of all seniority levels (including the General Manager) on the basics of the Business Planning & Analysis group, carefully walking them through all relevant models, tools, and reporting

Boston, Ma, Us

---Developed dynamic financial self-service tools for fulfillment pricing, management reporting, and cost allocation---Controlled the monthly invoicing approval and accounts receivable tracking processes for over 200 suppliers ---Worked with the accounting control team to compile and submit quarterly Sarbanes-Oxley (SOX) documentation

Boulogne-Billancourt, Île-De-France, Fr

---Headed the development and implementation of a manufacturing cell for the Limitamp ArcRes product line that reduced the total fabrication cycle time of standard customer orders from an average of 30 days to 5 days – an 83.33% decrease---Collected and analyzed daily production data using Excel and utilized the results to drive process improvements such as reducing WIP levels and machine downtime---Supported the day-to-day manufacturing operations to maintain a customer service level above 95%---Facilitated the movement of over $500,000 worth of customer orders through fabrication to assembly---Completed daily inventory counts on lighting panel front levels and ran financial reports on the data---Performed a detailed time study analysis and created optimal production schedules with the planning office based on the results---Managed and updated the master production Gantt chart and presented it to management each day---Supervised the documentation of inventory in the shipping area during physical inventory week---Ran production meetings with the plant manager and operations manager every morning--Worked collaboratively with managers and hourly employees to manage the flow cell--Designed more efficient transfer carts to ensure that parts in the same order remained together

Washington, Dc, Us

---Worked together with clinical and non-clinical staff to make changes to the bed cleaning process on one of the hospital's busiest wards that reduced the cleaning process time from 2 hours to 1 hour---Gathered and analyzed time study measurements on the bed cleaning process before and after implementing changes and presented findings to management in a formal written report---Applied data mining skills to examine a large Excel database of Medicare reimbursement information from the Ophthalmology clinic and discovered that thousands of dollars in additional reimbursement could be made if staff started billing for basic CPT codes that they had previously been overlooking---Assisted IT with the creation of an Access database for care nocturnists to use to track and update patient information such as important medication and treatment schedules---Developed an Excel tool for doctors and nurses to use to document and review patient status pre- and post-surgery ---Created and distributed surveys to patients in the blood drawing lab that helped area staff to discover ways to improve patient satisfaction and care---Improved facility signage and designed maps to make it easier for patients to navigate the building---Rearranged the Hematology/Oncology patient waiting area to make it more accessible and friendly for patients

New Brunswick, Nj, Us

---Studied the molding, casting and pouring processes and created Best Practice and Job Safety Analysis Sheets in Excel to show machine operators how to safely, productively and efficiently perform various tasks in the foundry---Coordinated the fabrication, testing and installation processes for the pour pot guarding safety system---Completed various Lean improvement projects, such as reorganizing workspace layouts on the manufacturing floor and conducting weekly 5S Audits---Identified Environment, Health and Safety issues during weekly walkthroughs and corrected them---Improved the process by which hourly employee time sheet information was tracked and analyzed---Supported day-to-day manufacturing operations and helped to resolve any issues that arose---Performed quality checks on parts using a Coordinate-Measuring Machine (CMM)---Monitored the quality of the wax used for the molding process by heat testing it each day

Middleboro, Massachusetts, Us

---Completed viscosity and stress tests on various samples using Brookfield™ viscometers---Analyzed results of tests using software such as Microsoft Excel, Rheocalc™ and Capcalc™---Compiled test results into detailed reports for the Viscosity Laboratory Supervisor---Performed quality checks and administered recalibrations on laboratory equipment

---Assisted special needs children in participating in various activities, including swimming and music---Engaged the children and aided in their development of social and behavioral skills---Utilized teamwork and leadership skills to work with other staff members to set daily schedules, mediate conflicts and handle emergency situations---Volunteered as a counselor and helped out with a special needs sports league prior to being hired

Bridgewater, Ma, Us

---Completed various tasks around campus, such as cleaning and painting student facilities

Bachelor Of Science In Industrial Engineering; Minor In Business Administration

High School, General Studies