Looking for a job

ELIANA MESA SIERRA

@elianamesasierra

Message

Operations manager at OrganiCulture who built an internal ERP system to manage inventory and orders.

Colombia

Message

At OrganiCulture, I managed day-to-day operations and built an internal ERP system using Excel, Power Query, and VBA to manage inventory and orders. At Phone Cycle, I led the implementation of a new ERP system, translating operational requirements into functional specifications and coordinating testing and the transition from the legacy system.

At Stanley Black & Decker, I led operational improvement projects, including a kitting process redesign that brought operations in-house and saved approximately $500K annually. I also used SAP and WMS data to improve picking and replenishment, lowering operating costs by approximately $550K annually.

Experience

Work history, roles, and key accomplishments

Business Operations Analyst

Information Professionals Group

Sep 2021 - May 2023 (1 year 8 months)

Worked directly with Melton Council to understand reporting needs, determine data requirements, and develop dashboards and reports using Power BI, Excel, SQL, and SharePoint. Coordinated with stakeholders to clarify requirements and translate business needs into reporting solutions.

Power BI Excel SQL SharePoint Jira Atlassian Dashboard Development Requirements Analysis

Co-founder & Operations Manager

OrganiCulture

Feb 2021 - May 2023 (2 years 3 months)

Managed day-to-day operations, including product sourcing, purchasing, inventory, order management, and online store operations. Coordinated suppliers, purchasing activities, inventory requirements, and order fulfillment across multiple priorities.

Operations Management Inventory Management Order Fulfilment Supplier Coordination Excel Power Query VBA ERP

Operations Manager

Phone Cycle

Aug 2020 - Aug 2021 (1 year)

Led the implementation of a new ERP system, acting as the link between management and IT and translating operational requirements into functional specifications. Developed functional specifications, business rules, process requirements, and supporting documentation, including screenshots and system logic.

ERP Implementation Functional Specifications Business Requirements Process Improvement Project Scheduling System Testing Team Leadership

Inventory Supervisor

Stanley Black & Decker

Dec 2018 - Jul 2020 (1 year 7 months)

Led a team of 10 and multiple operational improvement projects across a distribution center with 25,000+ SKUs and 45,000+ warehouse locations. Redesigned warehouse layout and slotting, defined product placement rules, and coordinated implementation across the team.

Team Leadership Process Improvement Warehouse operations SAP WMS Data Analysis SOP Development KPI Reporting

Inventory Controller

Stanley Black & Decker

Apr 2018 - Dec 2018 (8 months)

Implemented inventory management practices and SOPs across ANZ warehouse operations. Developed cycle counting and stock discrepancy investigation processes to improve inventory accuracy.

Inventory Management SOP Development Cycle Counting Process Improvement

Purchasing Officer

Ego Pharmaceuticals

Oct 2016 - Mar 2018 (1 year 5 months)

Managed the printed packaging portfolio, including purchasing, inventory, stock rotation, DIFOT, and supplier requirements to support production. Led a packaging standardization and SKU rationalization project using QA information, demand forecasts, and SAP data.

Purchasing Inventory Management Supplier Management SAP Data Analysis Project Management

Purchasing Officer

Ultramix

Jan 2016 - Oct 2016 (9 months)

Managed raw material purchasing from local and international suppliers and maintained demand forecasts for the probiotics portfolio. Optimized inventory levels and supported purchasing decisions through historical data and demand analysis.

Purchasing Inventory Management Demand Forecasting Supplier Management Data Analysis