Mario Serrano Email and Phone Number
Dynamic professional with a proven track record in leading projects and driving results through data-driven insights. Proficient in developing BI dashboards using Power BI, enabling actionable decision-making. Intermediate proficiency in SQL for data extraction and analysis. Advanced expertise in Excel, including VBA Macros for automation and efficiency. Extensive experience as a Data, Financial & Sales Analyst, skilled in process analysis to identify and implement improvements and optimizations. Committed to leveraging analytical skills to enhance operational effectiveness and strategic decision-making.
-
Senior Inventory AnalystCiena Aug 2024 - PresentGuadalajara, Jalisco, México -
Senior Data AnalystSofttek Jun 2019 - Jan 2024Guadalajara, 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. -
Data Analyst (Sales)Ibm Feb 2017 - Jun 2019Guadalajara 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. -
Data Analyst (Finance & Accountant)Hewlett Packard Enterprise Mar 2016 - Feb 2017Tlaquepaque 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. -
Financial Analyst At Bank Operations TeamHp Oct 2015 - Mar 2016Tlaquepaque 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. -
Assistant Manager At Operations ActivitiesDiversiones Galex Dec 2014 - Jul 2015Guadalajara 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
-
Credit And Collection Manager (Guadalajara)Concretos Técnicos De México May 2014 - Sep 2014Guadalajara 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
-
Branch AdministratorAutoservicio La Playa Nov 2008 - Apr 2014Several 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
-
Branch Manager7-Eleven México Feb 2007 - Sep 2008Zapopan Y Alrededores, México
Mario Serrano Education Details
-
Average 9.6
Frequently Asked Questions about Mario Serrano
What company does Mario Serrano work for?
Mario Serrano works for Ciena
What is Mario Serrano's role at the current company?
Mario Serrano's current role is Senior BI and Data Automation Analyst.
What schools did Mario Serrano attend?
Mario Serrano attended Universidad Veracruzana.
Who are Mario Serrano's colleagues?
Mario Serrano's colleagues are Alirio Melgar, Vivek Aggarwal, Andrew Cathcart, Shivam Agrawal, Raúl Ramirez, Pulak Bansal, Alejandra Pane.
Not the Mario Serrano you were looking for?
-
Mario Serrano
Key Account Manager @Dock | Customer Success Manager | Cx Analyst Sr | Tech Support | Problem Solver | Ops Management | B2B | Ex Pomelo | Ex Uber | Ex OysterMexico City -
1gmail.com
-
-
1unam.mx
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial