Mario Serrano Email & Phone Number

Guadalajara, Jalisco, México

Guadalajara, Jalisco, México

• Project Lead: Focused on automating data analysis processes to enhance efficiency and enablingseamless visualization through BI platforms in order to making decisions in real time.• Dynamic Reporting: Developed dynamic reports and dashboards using Power BI, Power Query,VBA, SQL, and Advanced Excel to facilitate data-driven decision-making.• Process Automation: Analyzed and improved internal manual processes by creating automationsolutions using Advanced Excel and VBA Macros.• SCRUM project: Automated the internal Walmart program "Aportaciones" by developing a tool toextract information from SQL Teradata Databases, generate Excel files, and send automatedemails based on analyzed data.• Training and Development: Led training sessions on Microsoft tools and automation, coveringExcel (Basic to Expert), VBA (Basic to Advanced), and Power BI (Basic), to enhance team skills.• Candidate Evaluation: Conducted interviews with a focus on evaluating candidates’ Excelknowledge and practical application.• Tech Writer: Created comprehensive documentation for Supply Chain Processes using SAPEnable Now tool to standardize procedures and improve efficiency.

Guadalajara Y Alrededores, México

• Regional Sales Analysis: Analyzed sales opportunities across various regions in the UnitedStates to identify trends and growth areas.• Stakeholder Recommendations: Delivered insights and recommendations to enhance salesperformance for 6 Directors across different markets in North America.• Ad-hoc Reporting: Built ad-hoc reports based on sales analysis to provide actionable insights for strategic decision-making.• Knowledge Improvement: Led the Excel+ project, improving the Excel proficiency of 300 peers in Mexico, India, and China to streamline processes and increase efficiency.• Tool Development: Developed tools using Excel Macros as part of Excel+, assisting peers with general Excel issues, and serving as a trainer for key Excel capabilities for Sales Analysts.Internal Achievements:-Recognized as Innovator of the Month in July 2018 for implementing a file that resulted in a cost savings of $15,000 USD.-Member of the Innovation Team project for the Center of Excellence in SMS Guadalajara, achieving 1st place in the Administrative Departments at Guadalajara IBM.-Participated in the Excel+ project, focused on Internal Consultancy, Training, and tool development using Excel VBA.

Tlaquepaque Y Alrededores, México

• Inventory and Revenue Reconciliation: Responsible for financial inventory accounting and reconciliation, as well as revenue accounting reconciliation for USA, Canada, and Brazil, ensuring accuracy and compliance with financial standards.• Process Improvement: Implemented Macros, formulas, and templates to improve efficiency and accuracy in inventory and revenue reconciliation processes, resulting in time savings and enhanced team achievements.• Process Auditor: Conducted process audits to identify inefficiencies and recommend improvements for daily operations, optimizing workflows and enhancing productivity for peers.• Training and Development: Provided training to peers on Financial Excel usage, including advanced techniques and best practices, to improve data analysis and reporting capabilities within the team.• General Ledger Analysis: Analyzed inventory booking and revenue reconciliation in the general ledger to identify discrepancies and ensure financial data integrity.• Excel VBA Development: Developed Excel VBA tools to automate repetitive tasks and streamline data processing, increasing efficiency and reducing errors.

Tlaquepaque Y Alrededores, México

-Bank accounts reconciliations. -Analysis of bank transactions to correct postings in the system Administrative SAP. -Identification of nature of accounting transactions (banking and system) to solve any problems and always be zero balance accounts. -I work as a team with colleagues from different countries to gain better control at my account responsabilities. -I get control 100% of accounts that was in charge, taking in all currently an appropriate balance as the nature of the account marks -I implemented improvements in formats that were set to reconcile using macros to achieve better efficiency in terms of time in manual and repetitive processes. -I made other formats automation for processing bank statement having just the data that they were need.

Guadalajara Y Alrededores, México

-Training to new branch managers y and shift managers at operational and administrative jobs -Significat Increase at sales and obtaining goals steadily - Development and improvement of administrative procedures for greater efficiency in filling formats. - Analysis of sales of machines to raise productivity - Development of administrative Audits to Branches - Development of Operational Audits to Machines (error detection and theft prevention) - Rapid growth in the company (Assistant Manager at Operations Activities) - It was possible to motivate employees in branch offices with communication problems

Guadalajara Y Alrededores, México

- Analysis of Sales from ERP and from databases. - Take Decision of sales negotiation tactics and collection activities - Development and improvement of procedures - Preparation of Management Reports, Statistics and graphs results - Portfolio review - Reconciliation of charges to customers - Reception and monitoring of payments - Bank deposits - Training to Employees - Analysis of customers for lending - Monitoring of overdue balances - Negotiating with credit customers - Concrete Delivery release - Invoice Verification and validation

Several Branches

- Job growth within the company- Sales increases- Improvement in the development of procedures to time, dependability and accuracy- Decrease in administrative and operating expenses- Stability inventory (avoid shortages and oversupply of goods)- Organization, planning and proper display of merchandise.- Growth of personnel in charge (training and motivation

Zapopan Y Alrededores, México