JONATHAN LABIJA

Queen Creek, AZ *****

480-***-**** ac57cl@r.postjobfree.com

Career Summary

10+ years of progressive supply chain, logistics and data analytics experience with proven track record of driving high growth through senior level executives and highly functioning teams. I have built reports that have influenced strategic business decisions leading to decent return on investment. Adept at customer relations, communication, business partnership, operations, risk scenario analysis, and statistical analysis background.

Core Competencies

Multiple years of building and maintaining crucial financial models to drive investment management, portfolio strategy and executive decision-making process.

Working data analysis and reporting experience using Tableau, PowerBI and Excel

Intermediate – Level experience using Excel formulas and functionalities e.g. V-Lookups, Pivot Tables, Index, Match, Pivot Charts

Continuous improvement in managing supply chain and logistics by using data-driven analysis to identify trends, influence decision makers, develop KPIs and highlight performance to executives, prioritize activities, and proactively recommend ideas for improvements.

Area of Expertise

T-SQL

SQL Server

Scrum/Agile

Microsoft Excel

Tableau

Sap Erp/Crm

PowerBI

Data modelling

Professional Experience

Eklipse Consult 01/2017 – Present

Business Intelligence Analyst (Consultant)

Utilized Server SQL 2014, Excel, PowerBI and Tableau to develop operational, tactical and strategic reports for external clients. Utilized advance formulas and functionalities with Microsoft Excel to design and implement robust reporting and analytical solutions. Provided data cleansing and validation support to ensure accuracy.

Developed and maintained Dashboards and Reports using Excel, Tableau and PowerBI

Led efforts to identify key performance indicators and metrics that facilitated reporting and analysis

Performed root cause analysis using SQL to uncover underlying data issues in reports and dashboards

Developed processes to extract, transform and aggregate data from multiple sources into PowerBI for reporting and analytical purposes.

Created, produced, and managed daily reporting for financial data across multiple management levels using PowerBI and Tableau

Provided meaningful insights (analysis) into data trends and outliers for decision making.

Prepared and delivered Excel based weekly and monthly company accounting and financial data

Identified and corrected exceptions and inconsistencies in business data and continuously enhanced data quality based on requirements gathered from business units

Created and maintained documentation related to report development platform guidelines, methods and standards

US FOODS 11/2016 – Present

Data Analyst/Pricing Data Reporting Analyst

Performed competitive pricing analysis with Excel; evaluated contract compliance and united states business regulations; performed medium to complex data transformation using excel formulas (VLOOKUP, MID, CONCAT, POWER PIVOT, POWER BI, TABLEAU etc.)

Built excel based pivot table and charts that provides comparative price analysis across major competitors; report shows how US foods stacks in the pricing market

Extracted, Transformed and consolidated data from disparate sources and built excel reports that is uploaded to SOX for auditor review

Reviewed and Audited products pricing loaded on the system and sent to customers to ensure accurate pricing are sent to avoid or reduce bill back from customers, and boost customer confidence to enhance continuous business relationship.

Provided detailed analysis and evaluation of business contract from vendors, suppliers, and third parties to ensure effective compliance with the terms and conditions on the contract to foster effective customer service, and company compliance.

Followed-up with vendors and suppliers to negotiate proper products pricing to avoid loss from US Foods as well as maintain business relationship with vendors and suppliers effectively.

Coordinated with pricing managers on a weekly basis to ensure products pricing are maintained as shown on the market trend to keep US Foods competitive on the market.

Designed effective communication strategy with vendors, suppliers, and third parties to enhances and maintain business relationship, and foster new modality to improving compliance of United States business laws and regulations.

Collaborated with Contract manager designed new contract for new customers and vendors to boost profit margin for US Foods, and increase customer base around the United States, and Canada.

Hanjin Shipping LLC, Chandler, AZ 2014 – 2016

Data Analyst /Supply Chain

Designed a dynamic effective communication strategy that enhanced business relationship between Hanjin Shipping and its VIP clients such as Wal-Mart Logistics, JC Penny’s, Samsung, Nike, Abercrombie & Fitch Clothing Company, and DHL Global Forwarding USA and Canada Region

Performed competitive pricing analysis with Excel; evaluated contract compliance and united states business regulations; performed medium to complex data transformation using excel formulas (VLOOKUP, MID, CONCAT, POWER PIVOT, POWER BI, TABLEAU etc.)

Designed effective and efficient approach to optimize $20M annual revenues and achieved 65% reduction in claims from VIP clients. Influenced strong partnership with VIP companies, and improved quality of delivery implementing Total Quality Management concept.

Implemented effective collaborative approach that improved effective communication with senior executives in Hanjin UK

Drove analysis, interpretation and application of US COGSA law that led to drastic reduction in business liability pay-out for Hanjin Shipping. Result led to $3 million savings.

Provided claims settlement recommendations to the CEO of Hanjin for approval/disapproval

Technical advisor to Hanjin executives during communications with Wal-Mart Logistics, JC Penny’s, Samsung, Nike, Abercrombie & Fitch Clothing Company, and DHL Global Forwarding USA.

Collaborated with HR team to designed effective training curriculum for new employees on policies and procedures. Trained supervisors using power point presentation, excel and word on scope of the business, contracts, negotiations and new strategies for business growth and quality of services.

Assisted Financial team analyze organization’s business finance, and write report to the head office on a quarterly basis

Collaborated with Company legal team to analyze and drafts business contracts.

Independently managed logistics and shipping of 150 claims from Great Lake region of the United States.

Reviewed, analyzed contracts and evaluated $6M claims to effectively negotiate reductions with Tier 1 companies. Analyses led to 45% pay-out reduction for Hanjin Shipping.

Regularly supported customers service team to designing effective strategy for continuous business relationship improvement

Partnered with Hanjin Shipping business partners Canadian National Rail, Norfolk Southern to implement effective logistics approach to improve delivery services, and reduced claim costs from companies.

Collaborated with operations team to designed cost reduction strategy that resulted in drastic claim reduction, and improved cargo operation on terminal.

Avnet Logistics, Chandler, AZ 2010 - 2014

Senior Data Quality Assurance Analyst

Designed effective TQM strategic approach implementing statistical integrated test and statistical analysis that improved and reduced missed quality products delivered to customers. Approach resulted in $50 million savings. (VLOOKUP, MID, EXCEL FORMULA, POWER PIVOT TABLE).

Designed internal quality strategy with the application of Deming’s Total Quality Management methods to improve product quality in the programming center

Supervised inspection team to ensure defective are not missed and ensured adherence to quality policy compliance.

Fostered cross group teams’ collaboration to enhance effective mutual work relationship and actualizing quality goal.

Developed a comprehensive training program for 35 quality and inspection employees responsible for business quality compliance

Promoted quality improvement processes among programming, quality, and inspection teams. Process led to 65% improvement in clients’ satisfaction, while the team continuously met quality expectations.

Coach supervisors on new quality strategies, business process improvement using power point presentation, and monitor the application for effective implementation.

Trained supervisors using TQM business strategies to effective enhancement of customer relations, and policies.

Goodrich Turbo Machinery Chandler, AZ 2006 – 2010

Senior Quality Representative

Maximized the efficiency of quality control equipment and process sequence methodology through time management process utilization; Analyzed, modified, and managed implementation of quality procedure that resulted in $3M business contract renewal with the United States Defense Department.

Reviewed and provided detailed health and safety compliance procedure for management approval and resulted to 65% reduction cost of health and safety pay-out by the company.

Converted and developed a new product inspection process using statistical integration that improved product quality.

Designed effective training and communication process that resulted in improved work relationship among minority team members

Collaborated with health and safety manager to implement health and safety programs and improve health and safety compliance. Program led to $0.25M safety cost reduction for the company in the Mexico manufacturing plant.

Roger Corporation Chandler, AZ 2005 - 2006

Quality Representative

Provided quality integration support for $50M high business growth for the company that resulted to business expansion in China

Provided quality strategy that resulted to improved quality of mobile phone and lamp products

Improved team work loyalty and morale by designing and implementing a team work integration strategy to foster good work relationship.

Implemented costs reduction process, and team member performance recognition leading to quality improvements

EDUCATION

Master of Business Administration Operation/Supply Chain Management 09/2015

Colorado Technical University, Colorado Springs, CO

Bachelor of Science Supply Chain/Logistics Management 08/2012

University of Phoenix, AZ

Associates in Nautical Science 07/2002

Cork Institute of Technology Cork, Ireland

Contact this candidate