Daniel Peñaranda Email & Phone Number

Cali, Valle Del Cauca, Colombia

Cali, Valle Del Cauca, Colombia

Responsibilities - Extract and cleanse data from public sources for loading into the local database, supporting the development and maintenance of data pipelines for unstructured data.- Transform and analyze data to size market and potential users, developing and suggesting solutions and strategies to business challenges.- Organize and present information using data visualization techniques, like dashboards, to measure performance in areas such as marketing.Achievements - Included to the business database information from public data to increase the scope and scalability of the analysis to the whole country, enriching the information for decision-making in business launching, through BI and Big Data based analytics solutions in favor of digital transformation.- Developed a dictionary for easy interpretation of the information collected, decreasing analysis and search times and increasing the clarity of reports for decision-making.- Built functions to facilitate the cleaning and loading of future data with a similar structure to those already worked, facilitating the acquisition and growth of the same, from the transformation of the company's data, stored in different sources such as Databases, EXCEL files, flat files, on platforms and other sources.

Responsibilities - Extract, clean and enrich data for use in running projects, as well as research and analyze valuable data sources to contribute to process modeling.- Perform pre-processing of structured and unstructured data, contributing to the creation of predictive models and machine learning algorithms for fitting user profiles to known categories.- Preparing visualization dashboards for monitoring the behavior of predictive models. Organizing and presenting information using data visualization techniques to develop and suggest solutions and strategies to the challenges presented. Achievements - Developed dense neural networks to predict user deterministic variables, with an accuracy of 96% which allowed me to condense the variables to be used for the required analysis.- Built a library of functions to plot in Dash the reports to be visualized from Python with minimal input from the front-end team.- Implemented NLP, especially sentiment analysis and topic categorization for quick classification of user issues, allowing for agile complaint assignment from automation.- Generated a matching algorithm for users and service entities that would decrease user abandonment rate.

Responsibilities:- Measure process control variables to ensure efficient use of resources to achieve optimum output and maximum utilization of resources.- Verify proper functionability of production traceability system, reporting discrepancies between actual inventory and database inventory.Achievements- Automate the method of measuring and reporting descriptive variables of sucrose crystals, decreasing the time per measurement from 1 hour to 15 minutes, changing the sampling from a few hundred individuals to at least two thousand per sample, through the use of image capture software.- Reviewed large amounts of data to discover trends and patterns in the relationship between minimum crystal size and significance between depletion.- Created equipment performance diagnostic models, using advanced Excel techniques, allowing for analysis of equipment usage trends, positively impacting the planning of timely maintenance of equipment for peak performance.- Found discrepancies between actual production and that reported in the database, allowing us to identify a faulty sensor that impacted barcode reading and internal records.