Juan Orellana Email & Phone Number

Sydney, New South Wales, Australia

Actively participated in a Property Analysis project to gather and analyse data from multiple sources, transform it, load it to a Data Warehouse and create visualizations to present meaningful insights for stakeholders. Used SQL Server Management Studio 19 and Visual Studio 2022 (SSIS) to manage loading, transformation and extraction of data with queries and stored procedures. Used SSRS and Power BI to create reports and visualizations to represent data analysis.

Australia

Manage day-to-day operations of the Company's Service Centre and lead the team of technicians to achieve overall objectives. Monitor the activities to ensure all tasks and service levels committed are met and exceeded. Manage relationship with internal and external clients of the Service Centre. Manage effective warehouse and stock management, support to technical staff and act as a first point of contact for reporting. Report on KPIs and customer service metrics directly to the Service Manager… Show more Manage day-to-day operations of the Company's Service Centre and lead the team of technicians to achieve overall objectives. Monitor the activities to ensure all tasks and service levels committed are met and exceeded. Manage relationship with internal and external clients of the Service Centre. Manage effective warehouse and stock management, support to technical staff and act as a first point of contact for reporting. Report on KPIs and customer service metrics directly to the Service Manager and Managing Director. Strong knowledge of a broad spectrum of well known MFD’s, wide format and printers brands such as Fuji Xerox, Epson, Canon, Konica Minolta, Toshiba, HP, OKI, Lexmark, among others. Ensure adherence to standard pre-run processes and customers’ special instructions. Elaborate and maintain users and technical documentation. Carry out repairs, device maintenance, testing, troubleshooting, firmware updates, hardware installation, machines installation and configuration at customer’s premises. Show less

New South Wales, Australia

Worked at FXA ANZ Hub at DB Schenker facilities.After one year, I earned sound knowledge to prepare, initialize and configure a wide range of Fuji Xerox and Lexmark MFD's following standard pre-run procedures and customers’ special instructions. Successfully surpassed the average number of pre-run MFDs per day, increasing productivity KPIs daily.Became one of the most trusted and experienced technicians in the workgroup with sound understanding of the operational processes, being… Show more Worked at FXA ANZ Hub at DB Schenker facilities.After one year, I earned sound knowledge to prepare, initialize and configure a wide range of Fuji Xerox and Lexmark MFD's following standard pre-run procedures and customers’ special instructions. Successfully surpassed the average number of pre-run MFDs per day, increasing productivity KPIs daily.Became one of the most trusted and experienced technicians in the workgroup with sound understanding of the operational processes, being recognised by Supervisor and Technical Manager for working effectively and collaboratively in a fast-paced environment.Assigned to new responsibilities in the workshop such as MFDs troubleshooting, training new technicians, preparing and maintaining reports.Created guidance documentation for new MFDs that helped to reduce 5 minutes of the whole pre-run process. Show less

Lima, Perú

Expert member of the Network Integration team. Superintended and successfully executed various Integration projects across Latin America and North America by integrating sellers’ systems (ERPs) with Ariba Network platform to facilitate supply chain management and procure-to-pay processes with assigned customers. Efficiently worked along with Development, Supplier Enablement and Customer Engagement teams within Buyer-Seller Integration programs. Built, developed, and… Show more Expert member of the Network Integration team. Superintended and successfully executed various Integration projects across Latin America and North America by integrating sellers’ systems (ERPs) with Ariba Network platform to facilitate supply chain management and procure-to-pay processes with assigned customers. Efficiently worked along with Development, Supplier Enablement and Customer Engagement teams within Buyer-Seller Integration programs. Built, developed, and maintained productive relationships with key organisations by liaising with sellers, customers, and third-party teams when discussing technical matters. Followed standard procedures to effectively approach sellers and educate them to understand the integration process with Ariba. Provided support and guidance through the project timeframe – Demos, Kick Offs, Integration meetings, follow-up meetings, weekly reports, testing, support post Go-live. Sound knowledge of Ariba Platform rules and configurations, cXML/EDI/xCBL formats and SQL database queries.Acknowledged by team for aiding North America region in surpassing targeted number of successful integration project implementations in 2016 and 2017. Achieved this by partnering with clients such as MetLife, Holiday Retirement, Patheon (USA), Grupo LALA, Tetra Pak (Mexico), among others. Show less

Lima, Perú

Engaged with customers to understand and discuss their needs according to e-Invoicing & e-Archiving legal regulations in countries such as Mexico, Colombia, Chile, Brazil, Italy, UK and Hungary.Analysed, gathered requirements, and designed functional specifications to develop, enhance and/or apply requested changes to our solution. Performed demos to present our solutions to customers and obtain their interest in preparing and issuing legal electronic invoices integrated with our supply… Show more Engaged with customers to understand and discuss their needs according to e-Invoicing & e-Archiving legal regulations in countries such as Mexico, Colombia, Chile, Brazil, Italy, UK and Hungary.Analysed, gathered requirements, and designed functional specifications to develop, enhance and/or apply requested changes to our solution. Performed demos to present our solutions to customers and obtain their interest in preparing and issuing legal electronic invoices integrated with our supply chain system.Successfully managed and implemented major changes to both global Legal e-Invoicing & Legal e-Archiving solutions for Quadrem (former SAP Ariba company) customers in the mentioned countries.Liaised with third-party e-Invoicing providers as well as external development teams. I contributed particularly to partner with an accredited Mexican e-Invoicing provider for a full integrated solution for our customers in Mexico.Managed legal e-Invoicing requirements through the Quadrem Release Cycle, influencing team members to implement at least 80% of our prioritised requirements.Performed tests alongside stakeholders to verify and meet acceptance criteria.Introduced proposed new features and enhancements to reduce redundant steps and increase security within both solutions. Show less

Lima, Perú

Performed Quality Assurance of the following Bank’s core systems: ALS (Advanced Loan System), Home Banking and Clients Network.Analysed functional and technical documentation to elaborate Quality Assurance specifications, control plans, test strategies, resources definition and test cases. Actively participated in several projects along with management, functional and development teams across different branches of the Bank. Successfully supported Go-live implementations by executing… Show more Performed Quality Assurance of the following Bank’s core systems: ALS (Advanced Loan System), Home Banking and Clients Network.Analysed functional and technical documentation to elaborate Quality Assurance specifications, control plans, test strategies, resources definition and test cases. Actively participated in several projects along with management, functional and development teams across different branches of the Bank. Successfully supported Go-live implementations by executing and validating test cases. Post projects go-live monitoring and customer support. Show less

Lima, Perú

Performed Quality Assurance on ALS (Advanced Loan System), one of the Bank's core systems according to functional and technical specifications.Actively participated in several ALS projects by successfuly testing new changes and implementations to the system.Post projects go-live monitoring and customer support.Key Successes:Performance recognition and requested to be a formal employee of Banco de Credito.

Graduate Diploma Of Information Technology, Computer/Information Technology Administration And Management, With Honours

Business Analysis Diploma, Business Analysis, Diploma

Systems Engineer, Computer Software Engineering