Lynxus Solutions
Data analysis for outsourced logistics operations in Medellín
Overview
I joined Lynxus Solutions in Medellín as a Junior Data Analyst and was promoted to Data Analyst after 8 months. Lynxus runs outsourced operations for transportation and logistics companies.
Weekly Business Review
I owned the Weekly Business Review for our clients, the operational report on agent performance, marketing, freight and profitability. It went to their operations teams and decision makers, and to our own account managers.
Automation
Report prep was manual, so I replaced it with Python and SQL. That cut reporting errors by 30%.
Tools
Python, SQL, Power BI, Microsoft Office, Google Sheets, Looker now and then, Salesforce, HubSpot, Jira, Confluence, Asana, and the contact-centre tools Cisco and 3CX.
Numbers
- Reporting errors
- −30%
- Months to my promotion
- 8
Skills
Weekly Business ReviewsOwned for our logistics clients
Operational reportingAgent performance, marketing, freight and profitability
Stakeholder reportingClient operations teams, decision makers, account managers
Python and SQLReplaced manual report prep, with 30% fewer errors