Juan Camilo Gereda Email & Phone Number

Bogotá, Bogota, Co

Bogotá

My primary role in the company is to provide timely information about websites and generate general reports related to customer loyalty programs using databases. My main responsibilities include:-Maintaining, developing, and updating a snowflake-type data warehouse to provide timely data in Power BI Dashboards through data modeling, generating reports on registrations, loyalty, and sales on the website.-Conducting queries and timely data retrieval through MySQL for analysis and creation of reports on the performance of the loyalty program.-Updating web forms for various activities developed by the program.-Generating KPIs and key metrics to measure customer-generated sales.-Constantly creating detailed reports for clients.

Bogotá, Distrito Capital, Colombia

As a Data Analyst at Omega Energy, I focused on optimizing data processes to enhance decision-making and identify market opportunities for the company. My role involved leveraging advanced tools and statistical methods to ensure effective data management and visualization.- Optimized the collection, cleaning, and analysis of market information, enabling the company to identify strategic opportunities and make data-driven decisions that aligned with business goals.-Implemented powerful visualization tools such as Power BI and Looker Studio to automate dashboard creation, facilitating real-time insights and improving data accessibility across departments.- Conducted statistical analysis using Python to uncover patterns and trends within the data, providing actionable insights that supported strategic initiatives and enhanced overall operational efficiency.- Developed and led a data governance project aimed at establishing a standardized approach to information management within the company, ensuring that data practices were consistent, accurate, and effectively utilized across all departments.

Bogotá, Distrito Capital, Colombia

At Fantasy Farms LLC, I served as a Data Analyst, playing a crucial role in managing and analyzing data to optimize the company’s operations. My responsibilities included generating key reports, forecasting supplies, and automating processes to enhance efficiency and accuracy in decision-making.- Generated weekly KPI reports for management and performance analysis, providing detailed insights that enabled business leaders to make informed decisions to improve operations.- Designed monthly supply projections for the flower production farm, helping the company maintain an optimal balance between supply and demand, reducing the risk of overproduction or shortages.Managed and analyzed stored data to generate performance reports in Qlik, offering a clear and objective view of operational performance and identifying opportunities for improvement.- Automated data handling processes using macros, significantly improving efficiency in report generation and reducing the time spent on repetitive tasks, allowing for a more strategic focus on data analysis.

Bogotá, Distrito Capital, Colombia

As a Technology Project Consultant at IBM, I played a role in improving business processes and implementing technological solutions. My focus was on the integration of agile methodologies and optimization techniques to ensure efficiency in technology projects, collaborating closely with cross-functional teams to meet client and company objectives.- Utilized various consulting tools, including JIRA and Trello, to monitor project development, track progress, and ensure compliance with established deadlines and objectives, facilitating effective communication and accountability within the teams.- Actively participated in cross-functional teams using Scrum, Agile, and Design Thinking methodologies, fostering an environment of innovation and flexibility in technology projects. This approach enabled the team to respond quickly to changing requirements and enhance project outcomes.- Provided administrative support by preparing productivity reports using Excel and Power BI, which included automating data analysis through macros optimizing Talent Acquisition processes, leading to greater efficiency in recruiting interns.