Erwin Lopez Email and Phone Number
Experienced Data Analyst skilled in data extracting, cleaning, transformation, analyzing and visualization.Advanced proficiency with Power BI visualization, DAX, Power Queries; Microsoft Excel, VBA, business intelligence tools and dashboards.Highly adaptable to change and new ideas with experience working in a diverse and multicultural setting and fast-paced environment.Dedicated commitment to confidentiality, strong organization skills and high degree of accuracy and attention to details; can work independently with minimal supervision.Supervisory and team leadership experience with data analyst and order management (supply chain) teams.With over eight (8+) years work experience with Lexmark International in various positions and capacities including supply chain management and business analysis. Proficient in Power BI, DAX, Power Queries, SQL, MS Excel and SAP Business Objects (Web Intelligence, Analysis for Office and Lumira), Real Time Dashboards and Analytics.Exposure to Big Data Analytics.Career Highlights:Developed a Pre-Processes Production scorecard and KPI for bus manufacturing.Converted legacy Excel reports to real time Power BI reports and dashboards.Created automated (macro enabled) audit files for QA inspectors.Business Analyst for Lexmark Global Supply Chain Operations. Responsible for business analyses and performance metrics indicators. Team Lead for Lexmark Asia Pacific Order Management Team.SAP Super user and part of the SAP rollout project for AP.Project Lead and admin for Credit Order Workflow - a web based approval tool for credit issuance for Lexmark Asia Pacific.Lead for AP Order management Process Improvement projects.Lexmark Manager Appreciation Award recipient.Lexmark AP WOW award recipient.Lean thinking practitioner
Motor Coach Industries - Reliability Driven
View- Website:
- mcicoach.com
- Employees:
- 605
-
Data AnalystMotor Coach Industries - Reliability Driven Jul 2017 - PresentWinnipeg, Canada AreaResponsible for Daily Metrics Reporting, maintains Power BI Reports and daily reports to support QA activities, reports development and data analysis. Supports cross functional / team support for data analysis and reporting.Tasks and Responsibilities includes:- Extract data directly from Oracle, or through SQL and Power queries.- Develop, design Power BI Reports and Dashboards.- Pre-Processes production scorecards and KPIs- Reports development- Failure analysis on field claims.- PPM Supplier scorecard.- Spend and accrual analysis on warranty claims and campaigns.- Other Data analysis (including ad hoc requests).- Supports other QA tasks and works with external auditors (Deloitte) when needed.
-
Lead Business AnalystLexmark Apr 2016 - Feb 2017Lead Business Analyst, Global Supply Chain Operations (GSCO).Responsible for Business Practices Analysis, Performance Metrics Reporting, Data AnalysisDesigns and Dashboards, Supports and maintains Operational Performance Indicators for Order To Cash activities.Responsibilities includes:- Key User (Super User) for SAP Business Objects: Web Intelligence and BW HANA reporting- Design and develop Real time Dashboard (Analytics tool)- Generates data and analyzes metrics for senior executives.- Manages large quantity of data and analyze into trends / results- Develops, analyzes and manages GSCO Strategy Scorecard- Supports strategy and key Supply Chain initiatives- Manages and analyzes GSCO Key Performance Metrics (KPI)- Revenue reports for senior and corporate managers -
Business AnalystLexmark Jan 2015 - Mar 2016Business Analyst, Global Supply Chain Operations (GSCO).Responsible for Business Practices Analysis, Performance Metrics Reporting, Supports and maintains Operational Performance Indicators for Order To Cash activities.Responsibilities includes:- Key User (Super User) for SAP Business Objects Web Intelligence and BW HANA reporting- Generates data and analyzes metrics for senior executives.- Manages large quantity of data and analyze into trends / results- Supports strategy and key Supply Chain initiatives- Manages and analyzes GSCO Key Performance Metrics (KPI)- Revenue reports for senior and corporate managers
-
Team Lead - Ap Order ManagementLexmark Jan 2012 - Dec 2014Leads, supervise, coach, train, motivates and guide the order management team supporting Asean and South Asian country partners (ASA).Other key roles and responsibilities includes:- Reviews voice of customer survey and make sure key customer concerns are addressed. - Reviews the team's daily metrics on operations - speed and quality.- Making sure the purchase orders are processed and shipped on time and translate it to revenue (O2C).- Delegates job and work assignments when necessary.- Coordinate and intervene when necessary with warehouse and third party logistics to resolve shipment issues.- Facilitate problem solving and collaboration among the team and serve as escalation point.- Help the team develop their potential be it leadership role or individual contributor.- Initiates and find ways for Process Improvements and meeting customer satisfaction.- Working closely with China planning team on product availability.- Coordinating with Product managers on priority for allocation.
-
Sap Super UserLexmark Jul 2010 - Dec 2014SAP key user for Asia Pacific Order to Cash teamResponsibilities:- First level escalation for SAP issues from the users and O2C team across AP.- test and debug common SAP issues and coordinate with support team- Subject matter expert (SME) for for Order management and distribution modules in SAP for the AP team.
-
Team Leader - Apg Order Management / Ap PadLexmark Jan 2012 - Dec 2012Leads, supervise, coach, train, motivates and guide the order management team and product availability and allocation team on the day to day activities. Other key roles and responsibilities includes:- Making sure the purchase orders are processed and shipped on time and translate it to revenue (O2C).- Coordinate and intervene when necessary with warehouse and third party logistics to resolve shipment issues.- Facilitate problem solving and collaboration among the team and serve as escalation point.- Help the team develop their potential.- Initiates and find ways for Process Improvements and meeting customer satisfaction.- Working closely with China planning team on product availability.- Coordinating with Product managers on priority for allocation.- Run and review open order reports to maximize revenues.
-
Ap Pad SpecialistLexmark Jan 2011 - Jan 2012AP Product and availability team. Supports the AP planning team in product allocation. Prioritize stocks allocation base on customer demand and shipment schedules. Engages with the order management teams, planning team, sales team and logistics team with customer shipments.Responsibilities includes:- Product allocation- In charge of reservation orders in SAP.- Manual delivery creation, allocation and reallocation of stocks in SAP.- Monitors ATP rescheduling of SAP.Data analysis, which includes running of reports and data analysis for:- Maximizing of revenues, making sure all available stocks are allocated and shipped.- Reviews open customer orders, recommends actions to order management like making sure delivery blocks are cleared and checks the integrity of the orders.- Reviewing and data analysis for potential revenue shipments during month ends and provides recommended actions to maximize revenues.
-
Order Management SpecialistLexmark May 2008 - Jun 2010CebuOrder management of Asia Pacific accounts for Lexmark (Order to Cash team). Ensures that all customer purchase orders are processed and ships on time.Job includes: - Coordinate with Third Party Logistics and Hong Kong forwarders for shipment out of China to customers across AP.- Coordinate with sales team and other support teams (pricing, finance and AR) on purchase orders to fulfill shipments.- Prepares LC (Letter of Credit) presentations to banks.- Order entry of sales orders in SAP- Talk and coordinates to customers on their shipments- Intercompany PO processing.- Data analysis which includes running of reports . Reports includes daily Revenue and Dash Board for AP O2C teams and senior management, and Third party logistics.
Erwin Lopez Education Details
-
Electronics And Communications Engineering -
Don Bosco Technology CenterHigh School
Frequently Asked Questions about Erwin Lopez
What company does Erwin Lopez work for?
Erwin Lopez works for Motor Coach Industries - Reliability Driven
What is Erwin Lopez's role at the current company?
Erwin Lopez's current role is Data Analyst at Motor Coach Industries - Reliability Driven.
What schools did Erwin Lopez attend?
Erwin Lopez attended Cebu Institute Of Technology, Don Bosco Technology Center.
Who are Erwin Lopez's colleagues?
Erwin Lopez's colleagues are John Mallari, Dale Majury, Max Perry, Mario Jorge Ferreira, Kathy Nelson, Glenn Lembke, Ahmad Yunus.
Not the Erwin Lopez you were looking for?
-
-
2kidsafterhours.com, specializedengineering.com -
Erwin Lopez
Executive Director Of The Wesley Foundation At The University Of Central FloridaGreater Orlando -
Erwin Lopez
Dallas-Fort Worth Metroplex2mexico.com, deloitte.com
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