Diego Andres Naranjo Rios
About
Detail
Data Engineer | AWS Cloud Practitioner | Software Developer |
Bogotá, Colombia
Contact Diego regarding:
connect_without_contact
Finding mentors
groups
Networking
Timeline
work
Job
school
Education
flag
Award
Résumé
Jobs
verified_user
12% verified
- AFrelance Backend Developer public Remote experienceAbove ZeroDec 2022 - Mar 2023 (4 months)- I migrated all the data from ads servies to a Redshift service in AWS cloud using Databricks and Apache Spark. Furthermore, we create different pipelines that allows the client write this information into this service. Above Zero is a digital media operations company focused on help clients reach their business goals. this thanks to its specialization in digital media and helping to launch campaigns with measurable success. Some of my achievements so far have been: - I helped with the migration of ads data acquisition and ETL processes from Google sheets and app scripts to AWS using services like Glue, S3 and Redshift. This migration together with the AWS Glue features allows an automatic execution of the ETL process avoiding the daily in
- IData Engineer public Remote experienceItelDec 2022 - Current (2 years 5 months)- Improve the cost of storage in S3 buckets by auditing each bucket and implementing data lifecycle rules. currently, we are improving the cost of storage by 20%. - Using design patterns, OOP and AWS, we developed a tool that allows us to create data pipelines by recycling code and just with the creation of a template in JSON format. - Design, create and improve databases for different purposes. Some of them are transactional databases oriented to applications and others are more focused on analysis and reporting. We are currently developing 2 database schemas for internal applications. In this process, we are more rigorous in creating a star schema for data analysis for future data ingestion into reporting tools. - I am part of a team that
Freelance Python Developer public Remote experienceSimplicitaJul 2022 - Sep 2022 (3 months)- I organized AWS roles and policies for collaborator - I designed the architecture of the main application to transform it from a monolith to microservices based application. - I Developed different data pipelines to improve the ETL process to optimize new product development and internal control reports. - I Created different automations focused on data acquisition from different government platforms. This using web scraping techniques and automatic web browsing using the selenium library. - I collaborated with the reporting team for product development. I provided technical advice on the development of Powe BI dashboards and audited them to ensure the integrity of the data presented.- MPython Developer - Data Engineer public Remote experienceManpower - DXCMay 2022 - Aug 2022 (4 months)- Through Agile Frame we develop solutions for a client that seeks to unify their information systems. Thanks to AWS, we create different serverless tools that consume data from SOAP and Rest services. Some of the information was transformed with Pytho Through Agile Frame we develop solutions for a client that seeks to unify their information systems. Thanks to AWS, we create different serverless tools that consume data from SOAP and Rest services. Some of the information was transformed with Python and all data was temporarily saved in RDBM or DynamoDB and uploaded to a centralized tool.
- Data Scientist - Python Dev. verified_user Verified experience public Remote experienceTeleperformance SpainFeb 2021 - May 2022 (1 year 4 months)- I created a web application platform with Django, FastAPI and AWS that helps the social media team extract tweets from specific topics and use different types of filters. This reduced the process time from several days to a couple of minutes their re - I worked with a team focused on creating a product to track objects on the desktop. Using OpenCV, AWS and a webcam, we helped different accounts track objects on the desktops of customer service specialists. It is currently helping some accounts keep I was a member of the innovation lab, most of my time I work with different areas creating solutions based on AI, machine learning, data extractions, unstructured data organization, AWS cloud solutions or automations through RPA with Python. So
- BI Analyst public Remote experienceTeleperformance SpainSep 2020 - Mar 2021 (7 months)- I have created an ETL process and text processing pipelines that extract surveys from MS SQL and provide information for analysis in a PowerBI dashboard. That Python development reduces the text extraction process from 3 business days to 3 hours, wh - With the operations team, we created a GUI with scripts and guides to solve common problems that customer service specialists often have with the end customer. As a result, this account increased its C-SAT by 1.3 points. I worked with NPS KPIs and customer surveys to perform text mining and find / understand the main shortcomings of the operation areas. Much of my work was focused on generating ETL with python and analyzing the results of the data to display it with Power BI or Tableau. Part
- Management Control Analyst - BI AnalystDerco S.A.Jan 2019 - Sep 2020 (1 year 9 months)- Creamos Dashboards y KPI para diferentes áreas internas con el fin de supervisar su funcionamiento y eficiencia financiera I lead a team focused on financial analysis and ETL at Derco Colombia. We created dashboards and KPI's for different internal business areas in order to monitor their operation and financial efficiency. Each month we had to consolidate the SAP transaction and supplier databases to generate the income statement and market scorecards. In addition, we consolidated market data from different sources for business managers and leaders.
- Maintenance and Product EngineerKiwi CampusMar 2018 - Dec 2018 (10 months)- Supervisé el área de mantenimiento en la base de Berkeley. DebÃa mantener en funcionamiento una flota de robots de reparto y actualizarlos con nuevas mejoras (hardware y software). En mi periodo en Kiwi, conseguà actualizar el 100% del software - KPI's creation for operation and maintenance efficiency. - OS Debug and Hardware maintenance. - Process monitoring.
- InternHenkel S.A.Jan 2017 - Jul 2017 (7 months)- generate data for water and electricity consumption analysis - Data acquisition. - KPI's creation. - Process monitoring. - Mechanical Design.
Education
verified_user
13% verified
- UMaster's Degree in Software Engineering public Remote experienceUniversity of Los AndesIJan 2023 - Current (2 years 4 months)
- DS4A public Remote experienceDS4AMar 2022 - Jul 2022 (5 months)- Honorous degree DS4A / Colombia is a 13-week training program open to all Colombian citizens who are interested in strengthening their data science skills & joining the growing AI ecosystem in Colombia.
- Maths public Remote experiencePlatziJan 2022 - Mar 2022 (3 months)
- Science - Formation Program public Remote experiencePlatziJan 2021 - Apr 2021 (4 months)
- Backend Development with Python and Django public Remote experiencePlatziJan 2021 - Aug 2021 (8 months)
- Data Science - Formation program public Remote experiencePlatziAug 2020 - Apr 2021 (9 months)
- FData Base Administration Diploma public Remote experienceFundacion Carlos SlimMay 2019 - Jan 2020 (9 months)
- Mechanical Engineering verified_user Verified experienceAndes UniversityAug 2012 - Dec 2017 (5 years 5 months)
Awards
verified_user
0% verified
- Derco ValuesDerco S.A.Oct 2019
- EETL automation