Luis S.

Developed regression, classification, and time series models using Python (Pandas, Scikit-learn), achieving RMSE < 48 for demand forecasting and delivering actionable operational insights. Cleaned and transformed large datasets while creating reusable Jupyter Notebooks that enhanced data readiness and accelerated analysis workflows by 35%. Employed feature engineering techniques, including one-hot encoding and scaling, to prepare categorical and numerical variables for machine learning models, thus improving model accuracy and stability. Generated compelling visual narratives of complex data results using matplotlib/seaborn, facilitating informed decision-making for stakeholders. Created interactive dashboards in Power BI/Tableau with financial, sales, and churn datasets to monitor key performance indicators such as revenue, margins, and churn rates, enhancing insights presentation for senior stakeholders.

Managed end-to-end accounting records involving CFDI issuance, payroll, and income/expense entries, ensuring adherence to Mexican tax regulations and IFRS principles. Conducted monthly bank reconciliations and journal entries to facilitate month-end closing, resolving discrepancies to maintain accuracy in financial statements. Implemented ETL-style workflows in Excel to extract information from bank statements and client systems, including ERP environments like SAP/NetSuite, transforming it into reconciled financial reports. Handled AP/AR records effectively, streamlining processes and reducing processing time by approximately 40% while enhancing internal controls. Assisted with tax declarations, variance analysis, and provided audit support across multiple client portfolios to uphold compliance and deliver reliable reporting.

Optimized the invoicing process, transitioning from batch processing to instant point-of-sale delivery, thereby removing a 3-hour lag and saving 5–6 hours daily while handling around 30 complex invoices. Oversaw AP/AR workflows, ensuring the issuance of CFDI, following up on collections, and validating vendor invoices to bolster financial compliance and enhance internal controls. Executed reconciliations for AP/AR, supplier payments, and VAT records, promptly identifying and addressing inconsistencies across various sources. Supported the tracking of monthly revenue and financial reporting by contributing reconciled data for variance analysis and aiding management decision-making. Collaborated with vendors and clients to resolve invoice discrepancies, contributing to timely documentation and minimizing payment delays. Utilized ETL-style workflows in Excel to enhance reporting accuracy and efficiency by extracting, transforming, and consolidating sales and purchase data. Digitized and organized sales and purchase data from spreadsheets into structured financial reports, ensuring accuracy and facilitating management decisions. Compiled analytical reports by product line and customer, elucidating cost structure and variances against expected margins to inform pricing and purchasing strategies. Analyzed discounts and pricing conditions for key customers, aiding management in understanding their impact on revenue and margins across different product lines.

Established solid client relationships by assessing needs and delivering customized technical solutions for electrical and plumbing installations. Contributed to a 50% increase in business revenue through personalized service and successfully closing significant sales. Handled a high volume of sales transactions accurately, managing cash and card payments to ensure the accuracy of daily financials.