Sofia Azhar Email & Phone Number

Ontario, Canada

Highly experienced and detail-oriented Senior Software License Specialist with extensive expertise in managing Oracle, Java, Salesforce, and Slack licensing. Proficient in license compliance, usage reporting, and contract optimization. Known for developing robust licensing baselines, creating effective licensing position (ELP) reports, and coordinating remediation plans to ensure organizational compliance and cost efficiency. Passionate about leveraging data-driven insights to support strategic decision-making and maximize software ROI. Oracle Licensing Asset Management- Risk Evaluation, Audit, Remediation, Compliance.Oversee licensing management for Oracle, Java, Salesforce, and Slack, ensuring compliance with software agreements and optimizing asset utilization.Lead the creation of licensing baselines and provide recommendations to organizational leaders, aiding in strategic decision-making.Develop Effective Licensing Position (ELP) reports in Excel, clearly outlining compliance risks and opportunities for cost savings.Utilizing Excel-based Effective License Positions (ELPs) to enhance reporting capabilities within Power BI dashboards, facilitating impactful insights that support informed business decision-making.Coordinate PULA remediation efforts, partnering with business owners to address compliance gaps and updating stakeholders via Power BI dashboards.Manage licensing and usage reports for Slack, calculating usage percentages and conducting in-depth analysis to support cost-effective renewals.

1 Pcc Circle, Brampton

• Conduct VMS and SAP audit processes to capture any freight cost difference in TMS System.• Processing AR, SAP, AR SAP Audits. • Extract reports for management to analyze offshore vendor’s freight cost. • Facilitate National Transport Pricing (NTS) process.• Coordinate with Freight rate negotiation team, CDM, CCS and TMS to process and manage new freight rates into TMS system.• Maintain AR Master/VMS Master File and process ad hoc mega rate conversions and updates on VMS master file.• Expedite freight rate update process as per category and business requirement.• Extract and process west DCs Load tracker, Depart Notes, WUC, PCO processing, and Cube reports to coordinate daily freight management between Load Planners and 3PL Carriers. • Using JDA and Loblaw cost override application to process pending BOLs.• Reports Data Analysis. • Automation of various Logistics and Supply chain reports, using SQL Developer software and SAS Enterprise Guide.• Develop Formulas, Macros and VBA scripting for report automation purposes. MicroStrategy Reports development for Supply Chain and Logistics TeamsPower BI Report development for Various Teams to Provide better insight of Data hence providing better Business solutions.

1 Pcc Circle, Brampton

• Manage and implement Vendor Pickup Agreement VPA contract compliance.• Conduct semiannual audits for carrier compliance to NSC.• Coordinated with operations and category managers in case of non-compliance to NSC and proceed with remedy compliance process to support careers to achieve desired NSC rating.• Posted weekly, monthly and quarterly National fuel and send out fuel notification to the business.• Conduct Semiannual Carrier Profile and Insurance compliance audits.• Posted and uploaded P&G weekly fuel updates.• Managed and facilitated Carrier Hiring and Contract award process. • Coordinate with category managers, merchants, FGP team, CDM, CCS and TMS to flow Carrier hiring process.• Manage Ocean Carrier Contracts.

1 Pcc Circle, Brampton

• Negotiated FOB, FGP, and COGS transport cost with vendors.• Managed and conducted freight rate conversions process as per business need.• Maintained weekly and monthly cost benefit score card.• Identify potential cost benefit vendors based on historical data. • Coordinate with Senior Category Manager, CDM, CCS, TMS, and vendor compliance team to on board existing and new vendors• Extracted Reports to obtain historical data using bi query application.• Using Biceps, JDA, Bi query, VMS and TMS systems to validate data. • Conducted Fuel conversion projects as per business requirement. • Send out effective rate negotiation results to relevant internal and external stakeholders.

Cambridge, On

• Assisting and supporting process for Store Managers in terms of Replenishment • Assisting the Buyers in Supply Chain and Distribution, as needed• Updating databases-Bi query, Biceps and TMS System.• Processing Distros. • Running reports• Administrative duties as required

Mississauga

• Update spreadsheet of Ocean Freight Rates for different ports; advise supplier which career to ship with. Double Check freight rates prior to shipping. • Check for discrepancies and approve PO against Sales Confirmation.• Check shipment status from suppliers, update arrival dates and quantity changes promptly in Streamline to update CSR team.• Ensures documents arrive in time for customs clearance and forward to broker.• Arrange container deliveries without incurring storage and/or demurrage charges.• Arrange delivery of direct container shipments to customers.• Follow-up ETA, ETD, ETA VAN dates with assign FF Company. • Construct Profit Margin, Costing Reports and Sample Labeling.• North American Shipments- Follow-up status of shipment with suppliers ensures updated NAFTA certificates are on file. • Other Duties- Update Catalogue and Page number info in Product Master, Update discounts in Visual Stream. Participate in Saturday rotation as cashier.