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.

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.

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.
• 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.

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.

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.

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