Sinan Bekdogan Email & Phone Number

Los Angeles, California, Us

Los Angeles, California, Us

Los Angeles, California, Us

Designed a month-end shipping recap process with Power Query. Increased the level of detail & accuracy of accruals. Reduced the process turnaround time by 3 daysSuccessfully managed the master data migration (vendor, item, BOM, PO) project from Finale to HighJump WMS in 2019 H1Spearheaded the design of all WMS explores in Looker & actively used LookML to design new views, dimensions, measuresDeveloped executive dashboards in Looker to give immediate visibility of production & fulfillment ramp up after HighJump WMS go-liveDesigned & deployed 200+ operational reports (Looker Dashboards & Looks) to support Transportation, Fulfillment Center, Customer Service, Order Management, Quality Assurance teamsDesigned the monthly deck for the Operations Team & presented Shipping, Warehouse, Customer Service KPIs to the Executive Team Provided SQL & Looker training to all new Analyst hires in the Operations Team. Onboarded them to FabFitFun's systems and data warehouse (Redshift).Trained & mentored the 1st intern in the Operations Team who supported us with product data validation, cleanup & PO maintenance in Finale Inventory System.

Chino, California, Us

Led the creation of reporting & BI tools for internal teams, improved their results by providing access to information in the ERP via Qlikview or Excel/SQL based solutions: - Trained Customer Service users in Qlikview, cloned/modified existing reports based on department’s needs- Partnered with IT and deployed a Distribution Center dashboard after new ERP go-live, providing 1st time visibility of outbound fulfillment operations (loads, shipments, invoices)- Designed a query to flag missing item costs across 3 ERP systems. Eliminated cost related delays in PO receipts.- Created a weekly report to monitor inaccurate sold-out-flags in the item master. Maximized inventory availability- Introduced an automated variance report to compare 3PL stock snapshot vs ERP, saving 4+ analyst hours per week - Designed & maintained a dashboard for the CFO to review month-end inventory positions along with key metrics: Days On Hand, Turns, Aged Inventory, Inventory Cost per Unit, Retail Inventory per Store- Built a tool for the Distribution Center to compare on-going physical count to on hand inventory data at the EOY 2016 physical inventory. Provided variance reports and expedited the recount process, saved 80+ warehouse labor hours during the project- Designed an Excel based application to monitor past 12 months raw material receipts & consumption. Identified $1M+ worth of inactive raw material inventory at the end of 2016. Implemented a quarterly clean up process with the Domestic Production Team & disposed of $700K+ obsolete inventory over 8 months- Created a true inventory aging report in Excel/SQL to monitor core inventory levels based on PO receipts. Worked closely with Sales to dispose of aged units and move slow SKUs out of core. Reduced core levels by 17% - Improved the Salesman Samples Forecasting process by automating data needs using SQL. Reduced the forecast turnaround time from 8+ work days to 5 days.

Vernon, Ca, Us

Spearheaded the salesman samples (SMS) operations: budgeting, forecasting and analysis of transactional data:- Partnered with the VP of Ops in mid-2014 to implement policies and savings initiatives for the SMS budget ($4.4M)- Built a forecast model to monitor monthly SMS receipts, expenses & shipments to distributors across all 3 brands- Presented all the analytics for SMS operations to CFO, COO and VPs at monthly OPEX meetings- Provided on-going visibility of SKUs, lines, units produced which led to $800K (18%) of savings by the end of 2015- Created a master SKU plan to drive 2016 budget ($4M+) and established a monthly process to reforecast financials Redesigned raw materials warehouse operations & systems. Managed a team of 5 during this 8 month long project.- Established guidelines to streamline the communication and work flow (from Domestic Production to Warehouse)- Implemented a WMS module (scanners, locations, LPNs) tailored to the needs of fabric operations & inventory - Executed a mid-year physical count project for Fabric inventory on time and 20% under budget- Partnered with IT team members to map the redesigned Fabric fulfillment processes to Trims inventory- Modified the WMS to accommodate both operations under one application with minimal changes in the software.Designed the inventory roll-forward model providing visibility of inventory movement across all 3 channels and brands- Gathered & manipulated data from 3 ERP systems using SQL to efficiently compile this model on a monthly basis- Forecasted month-end on hand inventory positions with 93-97% accuracy at the channel level- Highlighted strategic issues for the Executive Team: late returns from Retail to WS, increasing OP inventory levels

Los Angeles, Ca, Us

Streamline is an eCommerce agency specializing in growth strategy, marketing and operational consulting, enterprise platform development and implementation.

Vernon, Ca, Us

Operations & Process Analysis:Built the KPI program for Dutch’s Distribution Center (DC) from ground-up:- Designed data gathering forms, processes and spreadsheets- Supervised the data entry process into MS Excel Data Tables- Analyzed and reported performance data to VP of Operations, DC Directors & Leads- Provided day to day visibility on metrics such as cost per unit, units per hour, labor activity breakdown, labor hours & overtimeAnalyzed and documented the existing standard operating procedures (SOP) within the distribution center- Redesigned and improved processes in MS Visio for various departments and warehouse functions such as picking, packing, receiving, returns processing, value added services (VAS)- Updated standard operating procedures (SOP) and trained end users and personnel in the DCEvaluated systems (Warehouse, IT) and daily operations to identify and address inefficiencies:- Executed time studies on key processes in the distribution center in order to evaluate the labor performance- Provided recommendations to DC Directors, estimated cost savings and managed projects from start to finishData Analysis, Reporting & IT:Developed practical IT solutions to optimize the existing processes in the distribution center and to provide visibility to senior management- Designed and maintained Excel VBA applications with built-in SQL queriesSupported the VP of Operations, DC Directors and other departments with ad-hoc data analysis and internal reporting:- Customized the existing reporting tools in the ERP system- Built SQL queries in MS Query & manipulated query data through MS Excel for end users- Converted time consuming manual reports into automated daily reports using Excel Macros

El Segundo, California, Us

Internal Operations, Inventory, Supply Chain & Logistics: - Established guidelines to improve daily processes and the communication between Warehouse & the Sales Department.- Acted as the liaison between Production and Warehouse teams: Scheduled and monitored transfer orders, work orders and QC projects- Managed Manduka’s Mat-Wash product line: Forecasting demand, generating purchase orders for raw materials, submitting work orders for in-house production and monitoring finished-good inventory levels- Assisted the Logistics Team with getting quotes, scheduling shipments and fulfilling key account orders (Amazon, Zappos, Sports Authority, REI, Hayneedle etc.)- Worked closely with the Warehouse Inventory Supervisor to execute inventory adjustments and investigate inventory inaccuracies and issuesEnterprise Resource Planning (ERP):- Supported the ERP implementation project: Reviewed, mapped and transferred the master data from QuickBooks to NetSuite- Configured and enhanced the new ERP system based on the needs of other departments by preparing customized reports and searches in NetSuite- Maintained the item master and UPC databases for the whole organization (1000+ SKUs)- Managed all the receiving processes within the ERP system, the flow of information from the Warehouse team into NetSuiteFacilities & IT:- Coordinated and supervised the relocation project for the entire company including 2 office locations and 2 warehouses- Managed various internal/external parties including vendors, utility providers, contractors, warehouse associates to timely address facility projects under tight deadlines and budgets

Los Angeles, Ca, Us

Graduate Teaching Assistant for IOM 455: Project Management (Spring 2011)

Troy, Ny, Us

Munich, De

Certificate, Data Science

Certificate, Data Analytics

Master Of Science - Ms, Engineering Management

Certificate, Optimization And Supply Chain Management

Bachelor Of Science - Bs, Mechatronics Engineering