Publicis Global Delivery (PGD)

Developed and maintained data fows for a Leading Appliance Manufacturer in the
direct-to-customer (DTC) area, ensuring accurate and efcient data management in the lower
funnel.
Designed and created a comprehensive Looker dashboard from scratch, displaying performance,
budget pacing, and insights for multiple lines of business and brands across search, social, and
programmatic channels.
Analyzed data from various sources, including Google Sheets, and inputted them into BigQuery for
further processing and integration with other relevant tables.
Collaborated with cross-functional teams to support spend forecasting and ad hoc analysis,
providing valuable insights to drive decision-making.
Continuously monitored and evaluated data quality and integrity, identifying areas for
improvement.

Data Analyst

Dogpack Foundation

Professional Volunteer

Shambala Comunidades Ambientales

I played a pivotal role in the development of a robust dashboard using Power BI. My responsibilities included:
Extracting and integrating data seamlessly from MongoDB.
Collaborating closely with the database development team to ensure data accessibility and accuracy.
Designing and constructing an interactive and insightful Power BI dashboard.
Providing actionable insights that supported data-driven decision-making within the organization.
This experience allowed me to contribute directly to the start-up's data-driven growth strategy by harnessing the power of visual analytics and efficient data integration.

Business Intelligence Analyst

NetApp

I combined technical expertise with a customer-centric approach to deliver exceptional support. My commitment to proactive monitoring, rapid incident resolution, and client empowerment contributed significantly to the success of our team and the satisfaction of our clients.
•	Identify potential health issues, relying on various logs and diagnostic tools to perform in-depth analysis, pinpoint root causes, and develop comprehensive action plans for service recovery.
•	Part of my role involved educating clients on self-service options, documentation, and streamlined processes. By sharing knowledge, I enabled clients to address routine concerns independently. 
•	My responsibilities extended to configuring and verifying volumes, aggregates, and ensuring optimal functionality in both source and disaster recovery systems. I also validated SMTP and HTTPS/HTTP communications to facilitate seamless connections with various support tools and third-party applications for remote management. 
•	I validated the configuration of system-generated reports, covering critical areas like Autosupport, HA (High Availability), DNS (Domain Name System), LIFs (Logical Interfaces), among others. Ensuring these configurations were accurate and functional was vital to the overall performance of the systems.

Technical Support Engineer

Nueva Clinica El Barzal

I have successfully designed and developed interactive dashboards using Excel, Power BI, and SQL, enabling real-time visibility into critical business metrics. I have leveraged advanced Excel functions and data analysis techniques to derive key insights that have informed strategic decision-making, resulting in revenue growth and cost reduction.
• Designed and developed a suite of interactive dashboards using Excel and Power BI to provide real-time visibility into critical business metrics, resulting in a 30% reduction in time spent on data analysis and reporting.
• Conducted in-depth data analysis using advanced Excel functions, such as pivot tables, to identify trends and patterns that led to key business insights and informed strategic decision-making.
• Developed and implemented a data cleansing process to ensure data accuracy and integrity, which improved data quality by 25% and reduced the incidence of errors in reports.
• Collaborated with cross-functional teams to identify business requirements and design data models that enabled data-driven insights, resulting in a 20% increase in revenue and a 15% reduction in costs.

Unisys

• Provided outstanding support as part of the level 1.5 service desk, expertly identifying and resolving a wide range of incidents and requirements related to software and hardware issues.
• Developed and analyzed proactive reports to guide service management decisions, providing valuable insights that improved overall performance and effectiveness.
• Conducted in-depth diagnostic analyses to identify and address issues, leveraging a variety of techniques to quickly identify and resolve problems, while also making recommendations for long-term solutions.

IT Support Technician

Rappi

• Demonstrated proficiency in data analysis, experimentation, and data visualization tools such as Google Sheets, SQL, and Power BI. By identifying opportunities for revenue optimization and churn reduction, I have implemented successful experiments and maintained performance dashboards to track their impact.
• Led continuous improvement efforts in CPC pricing through data analysis and experimentation.
• Developed and maintained dashboards in Power BI to monitor CPC performance and track the impact of the experiments.
• Collaborated cross-functionally for aligned communication of results and recommendations.
• Managed and monitored large datasets for data quality and accuracy.

Data Analyst (Operations Analyst)

Zimmer Biomet

•  Contributed to process optimization efforts, mentored interns, and automated manual tasks using Excel macros and queries. My expertise in IT management, team leadership, and project management has driven measurable improvements in accuracy, efficiency, and overall business performance.
• As the Subject Matter Expert (SME), designed and optimized the DCS Item Master Processes resulting in significant improvements in accuracy and efficiency.
• Played a key role in supporting and mentoring Interns, contributing to their professional development and growth.
• Maintained and updated critical international customer data in multiple ERPs, ensuring accurate and up-to-date information for business operations.
• Led cross-functional teams in implementing process improvements, methodologies, and tools that delivered measurable business performance improvements.
• Designed and developed Excel macros and queries to automate manual processes, streamlining operations and improving productivity.

Master Data Lead (Global Customer Operations Specialist)

Kuehne+Nagel

• Streamlined supply chain administration, ensuring timely monitoring of sea freight imports and managing relationships with 3PL, customs agents, and land carriers. Presented management indicators to demonstrate process performance.
• Contributed ideas for process improvement and supported the implementation of new processes, resulting in enhanced business performance.

Operations Specialist LCC

DHL Global Forwarding

• Provided global clients with Ocean Freight LCL and FCL quotes for shipments to/from US, Canada, and Chile.
• Analyzed KPIs and Hit Rates to generate weekly/monthly reports and account projections.
• Led internal process, methodology, and tool improvements to enhance business performance.

Program Analyst

Data Analyst | Business Intelligence | Logistics | Supply Chain | IT | Power BI | Tableau | Python | SQL | ADHD

As a Bilingual Data Analyst with extensive experience in logistics, SCM, IT, marketing, and retail across startups and multinational companies, I offer a unique combination of analytical expertise and process optimization capabilities in various industries.

My background in industrial engineering, along with my hands-on experience in logistics and supply chain management, provides me with a comprehensive understanding of end-to-end operations, enabling me to analyze complex data sets and deliver actionable insights.

I am highly proficient in a wide array of tools and technologies, including Excel (VBA and Power Query), SQL, Power BI DAX, Tableau, Python, SAP, and more. My strong analytical skills, continuous improvement mindset, and exceptional problem-solving abilities empower me to address complex challenges and drive operational excellence.

I am seeking new opportunities to leverage my diverse skillset and contribute to data-driven decision-making, process optimization, and business success. My goal is to make a meaningful impact and drive innovation in a dynamic, technology-driven environment.

My email:
alozano93@hotmail.com

Taplio

Andrés Felipe Lozano Osorio's Linkedin Analytics

Andrés Felipe Lozano Osorio

Want to drive more opportunities from LinkedIn?

Taplio

.css-1jgreyo{background-image:linear-gradient(284deg, rgba(39,43,72,1) 0%, rgba(33,47,183,1) 100%);color:transparent;-webkit-background-clip:text;background-clip:text;}Andrés Felipe Lozano Osorio's Linkedin Analytics

Andrés Felipe Lozano Osorio

Want to drive more opportunities from LinkedIn?

Andrés Felipe Lozano Osorio's Linkedin Analytics