Mario Serrano

Mario Serrano Email and Phone Number

Senior BI and Data Automation Analyst @ Ciena
hanover, maryland, united states
Mario Serrano's Location
Guadalajara, Jalisco, Mexico, Mexico
About Mario Serrano

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.

Mario Serrano's Current Company Details
Ciena

Ciena

View
Senior BI and Data Automation Analyst
hanover, maryland, united states
Website:
ciena.com
Employees:
7424
Mario Serrano Work Experience Details
  • Ciena
    Senior Inventory Analyst
    Ciena Aug 2024 - Present
    Guadalajara, Jalisco, México
  • Softtek
    Senior Data Analyst
    Softtek Jun 2019 - Jan 2024
    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.
  • Ibm
    Data Analyst (Sales)
    Ibm Feb 2017 - Jun 2019
    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.
  • Hewlett Packard Enterprise
    Data Analyst (Finance & Accountant)
    Hewlett Packard Enterprise Mar 2016 - Feb 2017
    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.
  • Hp
    Financial Analyst At Bank Operations Team
    Hp Oct 2015 - Mar 2016
    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.
  • Diversiones Galex
    Assistant Manager At Operations Activities
    Diversiones Galex Dec 2014 - Jul 2015
    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
  • Concretos Técnicos De México
    Credit And Collection Manager (Guadalajara)
    Concretos Técnicos De México May 2014 - Sep 2014
    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
  • Autoservicio La Playa
    Branch Administrator
    Autoservicio La Playa Nov 2008 - Apr 2014
    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
  • 7-Eleven México
    Branch Manager
    7-Eleven México Feb 2007 - Sep 2008
    Zapopan Y Alrededores, México

Mario Serrano Education Details

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 Oyster
    Mexico City
  • Mario Serrano

    "Si Lo Puedes Soñar, Lo Puedes Crear" - Walt Disney
    Monterrey, Nle
    1
    gmail.com
  • Mario Serrano

    Director De Marketing En Tigres De Quintana Roo
    Cancún, Roo
  • Mario Serrano

    Associate Professor
    Cuernavaca, Mor
    1
    unam.mx

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

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.