Alejandro Moreno
Phoenix,AZ
Summary
Engineer with over 9 years of experience as coordinator and planner in Finance and Sales, and a great interest in applied analytical and technological solutions.
Industrial Engineer | MSc Finance | Tech Savvy: Certified Full Stack Developer / Macros VBA for Excel / SQL / Power BI
Overview
11
11
years of professional experience
Work History
Master Data Team
Freeport-McMoran
11.2023 - Current
- Support and guide buyers and planners across all job sites in Indonesia and NA on the update and maintenance of the product catalog and stock planning for new and existing materials. Oftentimes coordinating with suppliers to guarantee accurate and complete data.
- Designed Power BI dashboard to monitor the performance from each US plant, and results from our Master Data Team, while guiding monthly discussions surrounding given KPIs.
- Provide technical assistance to secure queries, databases and templates needed to support our team's daily operation.
Sales Planning Analyst
SUMCO Phoenix
02.2023 - 10.2023
- Understand the manufacturing process and plant capabilities surrounding the production of Epitaxial Wafers (Albuquerque Plant) and Polished Wafer (Phoenix Plant), and global semiconductor supply and sales dynamics, in order to lead the efforts of account managers and controllers to keep allocations according to capacity and strategy of the company.
- Serve as back up of the director of Planning & Cust Service in all processes relative to budget, forecast and allocation; reporting directly to VP of Sales.
- Developed SW app to keep track of backlog of the company in real time, eliminating daily work by one hour. Led IT project to further automate Allocation and FCST report
Software Developer
Datasolutions ETB
11.2020 - 01.2023
- Took part as Back and Front End Developer within the Channels and DevOps divisions of ETB. Programs used include but not limited: MongoDB, NodeJS, JS, JMeter, Swagger, SonarQube, Azure, Postman-SoapUI, .NET.
- See GitHub/LinkedIn with portfolio of Web and Mobile Apps
- Worked independent since I arrived in the US 01/22
Sales Ops Analyst - Financial Ops Management FP&A
Lexmark International
10.2015 - 10.2020
- Promoted to FOM 03/18: Oversaw the financial health of outsourced projects across North of Latin America and Caribbean (NOLAC) -circa 80 global and local accounts in 20+countries. Designed Control Dashboard in Power BI that served as model for other geographies. Closely monitored and took part in the elaboration and review of outlooks and results of installed units, revenue and cost per project.
- Sales Ops, performed as 1) Latam Coordinator: Observing end-to-end process of Extended Warranty sales, i.e., price lists, quotes, systems setup, reports. Coordinated efforts of shared serviced centers, customers, sales reps and internal personnel to deliver quality product on time. 2) Vendor Manager: Configuration, payment and financial review of tech providers.
Planning Analyst
Maximo - Pepe Ganga
10.2013 - 10.2015
- Took part as Business Analyst, leading strategic projects across the company: Intranet reports, IT deployments, look for new logistics partners.
- Oversaw the operation of the virtual store, increasing the attainment of SLAs to over ~99% and reducing monthly erroneous deliveries to ~0.
- Worked on monthly and ad-hoc reports including Rotation, SLA, Rebates, Budgeting, Operational Performance KPIs
Education
Bachelor of Science - Industrial Engineering
Pontificia Universidad Javeriana
09-2013
Master of Science - Finance
Universidad Externado De Colombia
08-2017
Skills
- Advanced Excel/Macros: Visual Basic VBA
- Business Intelligence: Power BI
- SAP ERP / SAP CRM
- Analytical - Numerical Thinking
- SQL NonSQL DB
- Certified Full Stack Developer: JavaScript - NodeJS React - Redux HTML-CSS Express API REST
- SCRUM Agile
- Leadership
- Communication
Timeline
Master Data Team
Freeport-McMoran
11.2023 - Current
Sales Planning Analyst
SUMCO Phoenix
02.2023 - 10.2023
Software Developer
Datasolutions ETB
11.2020 - 01.2023
Sales Ops Analyst - Financial Ops Management FP&A
Lexmark International
10.2015 - 10.2020
Planning Analyst
Maximo - Pepe Ganga
10.2013 - 10.2015
Bachelor of Science - Industrial Engineering
Pontificia Universidad Javeriana
Master of Science - Finance
Universidad Externado De Colombia