Procurement Business Analyst & BI Manager
Etihad Airways
Total years of experience :15 years, 6 Months
Business Performance Analytics
* Manage Procurement Department KPI reporting by SAP & Ariba, and Performance Analytics Dashboard by Microsoft Power BI for Corporate Management Reporting.
* Liaise with research organizations and market data providers, develop market report in supporting category managers/end users with specific opportunity/project.
* Implement & maintain Ariba Spend Visibility & SAP BI Reporting Tool by liaising with external system partners and internal financial users.
* Responsible for Procurement Sourcing Projects reporting in different subjects to the Management in supporting sourcing strategy plan, budgeting & optimization of sourcing opportunities, and driving overall saving targets and cost avoidance realization
* Manage overall business spend data consolidation and analysis through multiple source of systems, build reports in supporting Procurement with spend transparency resulting in increased negotiation power and saving opportunities.
* Coordinate with system provider to optimize and enhance Ariba procurement system.
* Support Department Budget plan, & data support to Internal Audit and Government Audit organization.
* Knowledge transfer to train Procurement teams on Ariba Spend Visibility reporting, SAP BI Tools & Microsoft Power BI.
e-Commerce - Procurement
● Research the current OEM mobile devices market, study new technology & product. Analyze the market condition and future trend.
● Identify right products at right price and quantity, from right source at right time to achieve budget objective and maximize the profit for online retail.
● Conduct supplier meeting, negotiate deals & contract terms, review past performance in term of price, quality, replenishment consistency, delivery, warranty, payment and Marketing investment.
● Monitor products online performance, analyze market feedback, take prompt decision for promoting profitable products.
● Manage day to day stock replenishment and control inventory level at the most economic point.
● Work closely with key functions: Finance, Logistics, Marketing and RMA in finalizing commercial terms for oversea exclusive deals.
Designation Chronology:
• Jan 2012 - Aug 2013: Senior Operation Associate (Sourcing)
• Jun 2010- Jan 2012: eCommerce Service Advisor
Crafted an upward growth curve from the position of e-Commerce Service Advisor to the position of Senior Operation Associate, through exceptional performance.
Highlights:
• Spearheaded Supply Chain Alignment activities supporting B2C in the e-Commerce channel, managing and executing entire projects from supplier on boarding through analysis and modeling, and communication of insights and recommendations.
Key Responsibilities:
• Provided support to suppliers on B2C e-commerce platform during the supplier store setup and mobilization process to market goods and services, giving much broader penetration into the GCC market.
• Created new revenue opportunities for suppliers to leverage the internet power in driving innovation and opening up new markets, industries, and customers by supporting suppliers to source and upload product catalogs and information online
• Liaised with cross functional department including internal departments Sales, Customer Service, Marketing and Technology Center to optimize performance of supplier online store and continuously guiding them on building their ecommerce businesses.
• Engaged in B2C ecommerce, aided suppliers translates to greater profitability, the ability to reach a much wider consumer audience, and increased visibility within Dubai and internationally.
• Advised retailers by getting their e-Commerce on-board provided systems training to update and manage products inventory through online Merchant Central system.
• Delivered excellence rights from the suppliers store online onboarding process and provided ongoing support by handling all technical/ logistical issues that may be incurred by the supplier, ensuring better alignment and integration
with the business.
• Managed the day-to-day operations, including inventory, logistics, supply chain, and fulfillment, while maintaining strong relationships with suppliers for product specification, pricing, promotion, strategic sourcing and issue fixing as per customer service level.
Highlights:
• Enabled total alignment across the supply chain: Procurement, logistics, technology enablement and customer management and oversaw B2B online market including supplier registration, product database, business category, online transaction and bidding for tenders and auctions.
Key Responsibilities:
• Handled business development activities related to strategic sourcing improvement, category, vendor, and contract management across all Tejari Franchisee Branches in Oman, Kuwait & Pakistan.
• Represented the organization for all procurement needs/policy, provided active support to all functional areas and sourced suitable suppliers to bid the reverse auction created by e-Commerce buyer.
• Maintained requisite supplier database including business category and membership in files, manual e-filing systems, of vendors, procurement contracts and supplier records, and certifying compliance with all the terms stated in the contract.
• Ascertained smooth operations and instrumental in streamlining various business processes/systems/policies, conforming alignment to procurement policies of company.
• Focused supply chain management on delivery schedules, inventory levels, specification or quality of product and solved bidders’ issues related to online sourcing and system functionality in co-ordination with Sales Department and IT department.
• Managed other day-to-day functions like maintaining purchase order files and facilitated to communicate effectively with internal customers and service providers with accuracy of the information from Tejari trade assistance and suppliers bidding performance, ensure the maximum buyers satisfaction in strategic sourcing.
• Actively contributed and participated in supply chain systems improvements, responsible for running and managing various reports on customer relationships/accounts for management briefing.
Key Responsibilities:
Import and Export
• Efficiently managed the day-to-day activities for Import/Export Letter of Credit process in liaison with banks and buyers.
• Coordinated directly with carriers, customers, and agents, communicated with international suppliers for purchase order and consignment tracking.
• Prepared, updated and monitored customer status reports and distribute as needed, filed online application of e-Clearance/Duty exemption for Import and Certificate of Origin for Export.
• Monitored supply of materials, ordered construction hardware as per project request, prepared invoices for the completed projects and worked closely with Planning/Scheduling,
• Maintained files on all import and export transactions in compliance with government and organizational documentation retention policy requirements. Reviewed, checked and technically approved invoices for accuracy and completeness.
Logistics
• Provided efficient services relating to Logistics, ensured account management from the quotation to the booking for road freight.
• Secured necessary approvals and adapted professional procedures by maintaining updated knowledge of the UAE freight and logistics rules and regulations to ascertain the clearance and delivery of consignments from port to end customers.
• Handled day-to-day administration functions and reviewed all documents to ascertain precision and reported discrepancies to the management. Streamlined all project activities and resolved various issues to reduce lead time for import/export consignment.
Key Responsibilities:
• Liaised with accessories suppliers in China for import procurement of Fashion goods. Participated Manufactory Investigation in China, supplier selection and negotiation.
• Managed store inventory and goods distribution. Deal with retail /wholesale customer for domestic market.
Other Relevant Experiences:
• Jun 2008 - May 2010: Chinese Business Language Tutor, ETON &-Dubai International Academy, Dubai
• Oct 2004 - Dec 2006: Guest Service Representative (Part Time), Hotel Club Quarter, London
Felicitated as the Best Employee of the month consecutively for 3 months
• Jul 2001 - Jul 2003: Junior Engineer (CERIS, Beijing) - Central Engineering and Research Institute for Iron and Steel Industry
