Albert Chandra Email & Phone Number

Jakarta, Indonesia

Singapore

San Bruno, CA

• Analyzed weekly forecasted and actual shipping costs using Tableau dashboard to monitor shipping expense rate, assess financial risks, and find operational opportunities; identified a potential annual savings of $8.
• Led User Acceptance Testing (UAT) sessions, made development recommendations to product manager, engineers, and senior management, communicated product features during implementation, and evaluated feedback for further.
• Identified inaccurate shipment data and worked along with Audit, Engineering, FP&A, and Accounting team to do root cause analysis, create a temporary mitigation plan to avoid under-accrued shipping expenses, improve.
• Developed a comprehensive standard operating procedure to maintain vendor relationship and improve third-party order fulfillment practices, and delegate the execution to an offshore team of 4 people while managing.
• Established an internal foundation for shipping carriers’ account management in order to gain better control over shipping expenses and on-time delivery performance
• Maintained and improved shipping invoice data integrity to ensure reliable reports; achieved 5% in improvement of LTL data accuracy

San Bruno, CA

• Led data integration efforts to provide vivid visibility to $1.1 billion outbound transportation budget through coordination with internal teams of software engineers and product managers, delivery services providers.
• Recovered $550 million missing data by closely monitoring data flow across systems and built a comprehensive KPI sheet that assessed and exposed operational and financial risks due to the issue
• Provided monthly close and forecast costs per package and partnered closely with Finance and Accounting teams on account management and reconciliation of expenses hitting P&L $90 millions per month
• Owned vendors’ cost management to drive shipping cost reduction of $500k annually by proactively working with vendors to refine order fulfillment practices and reduce shipping upgrades of top vendors by 16% while.
• Heavily analyzed data impacted by internal data clean-up efforts which were aimed for improved system efficiency in order to identify any risk as early as possible
• Validated auditor’s reports and communicated reporting discrepancies to Accounting team and the auditor to ensure high level of accuracy and assess financial risks

San Bruno, CA

• Designed a visual Excel dashboard and created a process to track and forecast space utilization on network, facility, and item level
• Revamped and maintained a Tableau dashboard on a daily basis to monitor inventory allocation across fulfillment centers
• Monitored overstock and aged inventory, and identified root causes of their fluctuation to influence sales strategy and warehouse management decisions
• Generated weekly data integrity report and analysis to streamline inbound flow execution
• Examined correlations among item characteristics to redefine item classification and improve facility efficiency

Greater Los Angeles Area

• Determined optimal route and order quantity of healthy products worth $15,000-$70,000 from various states in the US to export to Colombia while balancing trade-offs between lead time and costs
• Created a user-friendly dashboard to easily manage inventory of the exported products, and report order, shipment, and sales of the products using Microsoft Excel
• Prepared and monitored order shipments as well as regularly kept track of inventory level of various products
• Helped the marketing team to promote products by suggesting topics for social media posts and implementation of new flyers
• Prepared a set of professionally designed PowerPoint slides that has helped to successfully close deals with 2 hotels in Mexico and several grocery stores in California
• Presented the results of the projects to the company management

Los Altos Hills, CA

• Assisted students during teaching and learning process in the classroom by answering questions
• Helped to organize collected worksheets and homework

Los Altos Hills, CA

• Served students at the stockroom counter
• Prepared classes’ experiments equipment
• Maintained the stockroom, laboratories, and laboratory glassware

Los Altos Hills, CA

• Assisted students to earn highest potential grade in mathematics
• Provided creative problem solving for students
• Generated problem sets for further practice purposes

Los Altos Hills, CA

• Helped students with learning disabilities
• Provided a special approach for creative problem solving
• Gave problem sets for further practice

Bachelor Of Science - Bs, Industrial Engineering And Operations Research

Activities and Societies: Pioneers in Engineering Berkeley Indonesian Student Association UC Berkeley Institute of Industrial Engineers.

Engineering, 3.98

Activities and Societies: Foothill Indonesian Club Treasurer, Asian Pacific Islander Planner Committee, Foothill International Night 2013.