K ENJ I T. HAG IWARA
*****.*.********@*****.***
**** **** ** ****** ****, Mountain View, CA 94040
Work Experience: S upply Chain Business Analyst I I I Safeway Inc: Pleasanton, CA J uly
2014 – Present
• Created an ETL and Excel visualization tool to extract and summarize 30 million records across 1,300 stores
f rom Teradata.
• Integrated two databases into an interactive dashboard that merged procurement and warehouse data across
13 distribution centers and over 30,000 unique product codes.
• Managed the end-to-end process to deliver business intelligence reports, views, and dashboards using SQL,
V BA, Crystal Reports and Qlikview for a team of: 9 Forecast Analysts, 129 Buyers, 18 Managers, 9 Directors
and 2 Vice Presidents.
• Collaborated with Senior Management across Finance, Procurement, Forecasting, and Logistics to gather
requirements, define problems, derive KPIs, build deliverables, and present data-driven insights.
Web Developer/DBA M RC 360: A Xerox Company: San Diego, CA Feb. 2014
– J uly 2014
• Demonstrated attention to detail and time management skills by creating customized data-driven reports for
t he CEO.
• Created f lexible SQL queries to cleanse the database, which automated an existing processes, saving 80 labor
hours.
• Designed, coded, and implemented cutting-edge web tools for the enterprise using PHP, AJAX, JSON and Web
APIs.
Supply Operations Systems - Business I ntelligence I n te rn Safeway: Pleasanton, CA May
2013 – Aug. 2013
• Utilized business intelligence tools and database knowledge to create dynamic drill-down dashboards for
managers to perform business process discovery, analyze t rends, pinpoint inefficiencies and create strategic
decisions in t ransportation.
• Created 5 dashboards across 8 divisions in a 6 week period within a fast-paced, ever-changing corporate
environment.
Demand Planning I nte rn Del Monte: San Francisco, CA May 2012 –
A ug. 2012
• Created a database that compared historical forecasts between the Demand Planning departments, to more
accurately predict future sales data and ultimately increase business efficiency and profits.
• Led cross-functional business meetings with Senior Management to discuss cost-benefit analyses.
• Conducted interviews to gather business and technical requirements to design IT infrastructure and business
requirements.
Education: California State University Chico Dec. 2013
Bachelor of Science, B usiness Administration
Options: B usiness I nformation Systems - S upply Chain Management Systems
Activities: P resident E nactus (formerly Students in Free Enterprise) a t California State University Chico A ug
2012 – Dec. 2013
• Selected to be the returning president of a globally recognized organization with 535 universities nationwide.
• Led organization to beat 12 top-tier universities and win the regional competition for the first time in 3 years.
• Saved a daycare from bankruptcy and doubled enrollment, led youth entrepreneur camp grossing over $1,000
i n revenue, raised 5,000 lb. of food for the homeless shelter, developed an interactive website, and helped create
a local music festival.
• Managed human capital, marketing, financials, operations and project management teams.
• Demonstrated r isk management, conflict resolution, team management, decision making, and communication
skills.
Business Advisory Board Officer E nactus a t California State University Chico A ug
2011 – May 2012
Coordinator for Senior Ci rcle P rogram Community Action Volunteers in Education (CAVE) a t CSU Chico
A ug 2011 – May. 2013
G roup Leader for Adopt-A-G randparent P rogram CAVE a t California State University Chico A ug.
2010 – May 2011
Volunteer for Adopt-A-Grandparent P rogram CAVE a t California State University Chico
Jan. 2010 – May 2010
Related Coursework: Systems Project Management, Enterprise Technology Integration, Database Application
Development, Database Design, Data Communication & Networking, Business Systems Analysis, Quality
M anagement, Operations Management
Applications: M icrosoft Office, SAP, Oracle7, Teradata, Qlikview, Tableau, Laravel, QMF, Crystal L anguages:
H TML, CSS, SQL, PHP