Juan Daniel Lopez Lizcano Email and Phone Number
Ingeniero Ambiental con especialización en análisis de datos y sólida experiencia en entornos corporativos y startups. Experto en Python, SQL, Excel, Power BI, Jupyter, Google Colab y Anaconda, enfocado en la optimización de campañas y la toma de decisiones informadas. Hábil en la creación de dashboards y seguimiento de KPIs para mejorar el rendimiento y la eficacia operativa. Bilingüe y con experiencia en atención al cliente, con capacidad para transformar datos en soluciones estratégicas.
Publicis Global Delivery (Pgd)
View- Website:
- pillowpartners.co.uk
- Employees:
- 4319
-
Senior Data AnalystPublicis Global Delivery (Pgd)Bogotá, Bogota, Co -
Data AnalystColegio Anglo Colombiano Sep 2024 - PresentBogotá, Distrito Capital, Colombia -
Digital Data AnalystPangea Digital Marketing Jul 2024 - Sep 2024Bogotá, Distrito Capital, Colombia•Analyze client accounts, delivering actionable insights and recommendations on digital marketing campaigns.•Conduct in-depth tracking and performance analysis of campaigns on a daily, weekly, and monthly basis.•Design, develop, and maintain dashboards in Looker Studio, tailored to meet specific client objectives and needs.•Integrate and analyze data from various sources, including Google Sheets, Excel, Facebook Ads, TikTok Ads, Google Ads, Google Analytics, Google Video 360, and both programmatic and external media sources.•Develop comprehensive reports and dashboards from inception to implementation, ensuring they provide clear and valuable insights.•Analyze trends, patterns, and behaviors across different campaigns to uncover actionable insights.•Provide guidance to account leaders on dashboard functionalities and data interpretation, enhancing their ability to make strategic decisions.•Manage multiple accounts simultaneously, delivering detailed and tailored reports based on client specifications. -
Data Reporting AnalystOptum Jan 2024 - Jul 2024ColombiaDevelopment of executive reports in Power BI: Using my Power BI skills, I created highly visualized executive reports for key leaders in the company. These reports effectively provided summarized strategic information, facilitating quick and informed decision-making.Analysis of complex data using SQL: I utilized advanced SQL queries to analyze complex data and extract relevant information from databases. These analyses enabled the identification of patterns, trends, and accurate forecasts to support strategic planning.Collaboration with multidisciplinary teams: I effectively interacted with leaders from key areas of the company, as well as multidisciplinary teams. This facilitated understanding of the analytical needs of different departments and contributed to the generation of customized reports and analyses for each area.Automation of report generation processes: I implemented automated solutions using tools such as Power BI and Excel to streamline and optimize the report generation process. This saved time and resources, improving operational efficiency and enabling faster decision-making.Optimization of data quality: I performed data analysis and cleansing using tools like Excel and SQL to ensure the quality and reliability of data used in reports and analyses. This contributed to better decision-making and the generation of more precise and reliable insights for each area's leaders. -
Senior Customer Service ExecutiveOptum Aug 2022 - Jul 2024Bogotá, Distrito Capital, ColombiaFacilitated comprehensive support to UnitedHealthcare Group members regarding their medical and prescription insurance plans, ensuring clarity and satisfaction.Handled user complaints with empathy and professionalism, resolving issues promptly to enhance member experience and satisfaction.Educated members on plan benefits, coverage options, and policy details to empower informed decision-making.Collaborated closely with healthcare providers and insurance specialists to expedite claim processing and resolve coverage-related inquiries.Maintained accurate records of member interactions and issue resolutions to track trends and improve service delivery. -
Data And Customer Service AnalystServ® App - Espacios Impecables Oct 2021 - Jul 2022Bogotá, Distrito Capital, ColombiaEfficient Database Management: I led the administration and maintenance of complex databases, ensuring fast and accurate access to information. I utilized tools like Excel to create and optimize tables, queries, and data manipulation, improving operational efficiency and enabling informed decision-making.Strategic Reporting Generation: I developed periodic and customized reports using Excel and other data analysis tools. These reports provided key insights for senior management, contributing to the identification of growth opportunities, resource optimization, and overall business performance improvement.Effective CRM Management: I oversaw the comprehensive management of the Customer Relationship Management (CRM) system, ensuring the quality and updating of customer data. Additionally, I supervised its proper utilization by the team, resulting in enhanced effectiveness of sales and marketing strategies, as well as improved customer satisfaction.Team Leadership and Customer Service Operations: I guided and supervised a team of 5 professionals in delivering exceptional customer service. I established clear goals, provided continuous training and support, and fostered a collaborative environment that led to increased customer retention and significant improvement in satisfaction metrics.Process Optimization and Continuous Improvement: I identified and implemented solutions to optimize processes related to database management, Excel usage, report generation, and customer support. These improvements increased productivity, reduced response times, and generated significant cost savings in operational expenses. -
Customer Service Agent24-7 Intouch Oct 2020 - May 2021Bogotá, Distrito Capital, ColombiaProvided tailored advice to clients while ensuring compliance with established performance indicators.Managed travel arrangements in accordance with customer specifications using specialized travel management tools and software, and based on individual customer profiles.Delivered detailed updates on travel status and provided expert advice on products and services to enhance customer experiences and satisfaction. -
Customer Service And Technical Support SpecialistAmazon Feb 2019 - Mar 2020Bogotá, Distrito Capital, ColombiaProvided specialized technical support and customer service, including basic troubleshooting and guiding members on connecting devices through an app and configuring them.Tracked purchase orders, managed billing, and monitored shipment tracking to ensure accurate and timely deliveries.Offered detailed information on purchasing status and provided expert product advice to customers.Ensured customer satisfaction through proactive follow-up emails and personalized technical support tailored to individual customer needs. -
Asistente De InvestigaciónUniversidad De La Salle Aug 2017 - Dec 2017
Juan Daniel Lopez Lizcano Education Details
-
Ambiental
Frequently Asked Questions about Juan Daniel Lopez Lizcano
What company does Juan Daniel Lopez Lizcano work for?
Juan Daniel Lopez Lizcano works for Publicis Global Delivery (Pgd)
What is Juan Daniel Lopez Lizcano's role at the current company?
Juan Daniel Lopez Lizcano's current role is Senior Data Analyst.
What schools did Juan Daniel Lopez Lizcano attend?
Juan Daniel Lopez Lizcano attended Universidad De La Salle.
Who are Juan Daniel Lopez Lizcano's colleagues?
Juan Daniel Lopez Lizcano's colleagues are Daniel Mantilla Ochoa, Andrea Teresa Sarmiento Sánchez, Gautam ., Andres Ledesma Cardozo, Clara Lorena Aponte Ariza, Christopher Hannelas, Madhu Tiwary.
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