Bryan Cervantes

Ensuring the accuracy and reliability of the organization’s database by continuously maintaining clean and consistent data. Acting as the key user of our Azure Web App (.NET), handling ongoing maintenance and implementing new features to enhance functionality and user experience. Analyzing, processing, and presenting actionable data insights to support strategic decision-making and performance monitoring, using tools such as SQL, Power BI (DAX), and Python. Designing and implementing automated workflows through Microsoft Power Apps and Power Automate, streamlining daily administrative processes and boosting overall operational efficiency.

Managed end-to-end inventory lifecycle in AS400, executing material receiving, SKU registration, and system adjustments to ensure 100% data integrity. Resolved inventory discrepancies by performing root-cause analysis between physical stock and ERP records, executing precise write-offs and cycle count adjustments. Optimized outbound logistics by selecting shipping methods based on cost-benefit analysis, aligning company budgetary goals with client service-level agreements (SLAs). Streamlined shipping operations by coordinating vendor pick-ups and providing accurate freight quotes to the sales team to accelerate order fulfillment.

Served as the primary Subject Matter Expert (SME) for all intercompany modules, including Warehouse, Production, Cost Centers, Accounting, and Taxes, ensuring seamless cross-departmental transactions. Led the mapping of accounts for intercompany transactions during the ERP migration, safeguarding financial data integrity and ensuring accurate system-wide reconciliation. Designed and implemented a compliant "stamped invoice" workflow for non-commercial exports, enabling indefinite export regimes under Mexican regulations and significantly cutting costs from over-processing. Managed the inter-branch billing process and intercompany Accounts Payable, while leading budgeting and forecasting efforts for the intercompany cost center. Synchronized logistics planning with production and tax requirements, optimizing the flow of materials and financial records between international branches.

Provided accounting support by managing journal entries, P&L accounts, and bank reconciliations using Oracle EBS. Oversaw invoice allocation for CapEx projects, ensuring accurate cost tracking. Streamlined reconciliation processes, enhanced financial reporting accuracy, and optimized cost allocation methods for improved forecasting.

Built replenishment logic for a 200+ SKU catalog using demand, lead times, and stock targets. Executed purchases in SAP based on sales needs and stock levels to reduce stockouts. Analyzed supplier quotes and costs to support sourcing decisions and pricing. Monitored inventory against demand and recommended reorder actions to maintain availability. Coordinated with suppliers on delivery timing and purchasing priorities. Partnered with vendors to synchronize production schedules and delivery priorities, mitigating supply chain disruptions.

Support administrative tasks such as tracking project expenses, scheduling appointments, restocking office supplies, and recording policies.