Cesar Salgado Email & Phone Number

Bogotá, Bogota, Co

Distrito Capital, Colombia

Distrito Capital, Colombia

Database Management:Oversee the efficient administration of databases, ensuring data integrity, security, and availability.Implement optimization strategies to enhance the performance and efficiency of databases.Dashboard Development:Develop intuitive and customized dashboards using advanced data visualization tools to provide key insights to leadership teams.Collaborate in identifying and tracking relevant KPIs to assess operational and strategic performance.Process Automation:Design and implement automation solutions that significantly improve operational efficiency and reduce errors in processes.Utilize automation tools to streamline repetitive tasks, allowing for a more strategic focus on decision-making.

Miami, Florida, Estados Unidos

• Data Extraction and Preparation: Extracting data using SQL, and using Python for cleaning and transforming the data.• Data Analysis and Visualization: Analyzing data with Python libraries, performing statistical analysis, and creating visualizations using tools like Matplotlib.• Reporting and Dashboard Creation: Creating reports and interactive dashboards with Power BI, incorporating data from SQL and Python analysis.• Data Quality Assurance and Documentation: Ensuring data accuracy and consistency, performing data quality checks using Python and SQL, and documenting analysis processes and assumptions.

Haikou, Hainan, China

• Successfully identified and extracted 300 potential customers from E-commerce local websites throughout China through web scrapping, speeding the process by 100%, identifying best potential markets in the country.• Developed and maintained a comprehensive PostgreSQL database of jewelry, including detailed information on features and location, improving decision making and logistic process time by 50%.• Take the initiative by propose innovative technological strategies using Python for the supply-demand classification process, leveraging cutting-edge data analytics and machine learning techniques, improving new client searching time by 80%• Demonstrated expertise in customer relationship management (CRM) practices, effectively tracking and managing new client acquisition.

Bogotá, Distrito Capital, Colombia

Responsabilities:• Implementation of inventory PostgreSQL database, improving decision making and logistic planning by 35%.• Proactively conducted outreach and maintained relationships with potential customers through targeted search and frequent in-person visits.• Successfully expanded the client database by 20% through effective relationship building and strategic sales initiatives.• Provided crucial support for the planning, organization, and execution of two major events, as well as numerous tasting experiences.

Bogotá, Distrito Capital, Colombia

• Analyze and clean data sets using SQL throughout several projects, resulting in a 30% reduction in data errors and improved data accuracy for decision-making processes.• Collaborate with cross-functional teams to identify trends and patterns from data, resulting in a 20% increase in identifying actionable insights to support business goals and objectives.• Assist in developing and implementing data visualization dashboards and reports with Power BI, resulting in a 40% improvement in data presentation and communication to stakeholders.• Support the creation and maintenance of data models and databases, resulting in a 25% increase in data integrity and security measures to ensure data quality and confidentiality.

Bogotá, Distrito Capital, Colombia

Plan, establish, and manage the business with a focus on creating and selling high-quality craft beers, including market research, developing a business plan that outlines the brewery's goals, financial projections, and marketing strategies, securing funding and resources to start and operate the brewery, overseeing the brewing process and quality control, managing sales and distribution channels, building and maintaining relationships with suppliers and vendors, and ensuring compliance with regulations and licensing requirements. Additionally, leading the team, overseeing branding and marketing efforts, and staying updated with industry trends to drive innovation and business growth.

Bogotá, Distrito Capital, Colombia

• Conduct a comprehensive analysis of government data on public schools in the towns around Bogota, Colombia, to identify the current state of bilingual education programs, including the availability of resources, curriculum, and teacher training.• Identify gaps and challenges in the implementation of bilingual education programs in public schools, based on government data, to inform the development of targeted interventions and strategies to improve bilingual education outcomes.• Develop evidence-based goals and objectives for the project, to ensure alignment with the needs and priorities of the local communities and stakeholders.• Collaborate with local schools, teachers, and administrators to implement bilingual education programs that are culturally responsive and inclusive, to promote equitable access to high-quality bilingual education for all students.• Monitor and evaluate the progress of the project using government data and other relevant indicators, to measure the impact of interventions and make data-driven adjustments to improve the effectiveness and sustainability of the bilingual education programs in public schools.

Bogotá, Distrito Capital, Colombia

Responsabilities:•• Conducted extensive research utilizing specialized search engines and SQL to gather relevant scientific articles to be analyzed.• Demonstrated exceptional organizational skills by meticulously planning and overseeing the execution of academic events.• Developed scientific standard visualization for magazine publications using Advanced Excel• Contributed to the academic community by publishing an indexed scientific article that focused on the innovation processes within Colombian SMEs.

Ingeniería Industrial, Gestion De Tecnología E Innovación

Especialización, Finanzas Y Negocios Internacionales

Advanced Google Analytics, Analisis De Datos

Introduction To Beer Brewing Manufacturing, Engineering

Google Data Analytics Certificate, Data Analytics

SQL, R, Tableau, Spreadsheets