David Pelaez Velasquez
About
Detail
Business manager
Bogotá, Bogota, Colombia
Résumé
Jobs
verified_user
40% verified
Product Data AnalystStanley Black & DeckerDec 2023 - Current (2 years 9 months)Responsibilities. ●Deployed various ETL data pipelines using Alteryx to centralize information, standardize data for Snowflake ingestion, and reduce manual checks by over 2 hours. ●Contributed to redesigning product hierarchy to meet stakeholder requirements and ensure compliance across various countries. Achievements ●Leveraged Alteryx to connect to Snowflake's data warehouse and build data pipelines, streamlining manual processes and enabling users to identify rebranded SKUs more easily. ●Designed Alteryx workflows that automated data preparation tasks, enabled live report generation through Power BI integration, and saved collaborators over 2 hours per report, improving their efficiency. ●Contributed to a cross-functional initiativ- kInsurance Analyst. public Remote experiencekarstensfinancialDec 2022 - Current (3 years 9 months)Responsibilities ●Gathering information from users to create the best strategies for business development. ●Compile and analyze market information to provide the best options to our users. ●Developed specific metrics and KPIs to track performance for high-value clients with portfolio growth exceeding $100,000 in premiums. Achievements ●Leveraged market research and customer data to improve customer retention and satisfaction. ●Utilized market analysis and an Alteryx workflow to identify high-cost policies and implement cost-saving alternatives for our clients.
- UReporting Analyst.Universidad UTPNov 2022 - Dec 2022 (2 months)Responsibilities. ●Develop a user-friendly dashboard that seamlessly integrates data from Excel, surveys, and SQL Server, providing a single source of truth for end-users. Achievements ●With valuable feedback and insights from teachers and university representatives, the project secured approval. ●Developed a Power BI report with key performance indicators (KPIs) for budget, completion rate, and student reach by area, enabling project stakeholders to make informed decisions.
- Junior Data Analyst verified_user Verified experiencePROTECCIÓN S.A.Jun 2021 - Jan 2022 (8 months)Responsibilities ●Developed KNIME workflows to segment customers and extract actionable insights for targeted marketing campaigns. ●By analyzing databases and generating insights presented in Power BI reports, I contributed to business development across the organization. These reports focused on the most relevant KPIs for our area. Achievements ●Contributed to a team effort that streamlined workflows using KNIME, saving 15% on budget costs and reducing manual processes by 10 hours. ●My internship project, leveraging Power BI and KNIME, received recognition for its impact on internal processes and data visualization. It mapped the customer journey using data analysis in KNIME and showcased improvement areas with clear visualizations in
- Eafit University verified_user Verified experienceEAFITJun 2018 - Dec 2022 (4 years 7 months)
Education
verified_user
0% verified
- platzi educationPlatzi masterDec 2022 - Current (3 years 9 months)
- platzi public Remote experiencePlatzi masterDec 2022 - Current (3 years 9 months)Courses and routes achieved
- Administrador de negociosEAFITJan 2018 - Nov 2022 (4 years 11 months)
- EAFIT- Project management coursesEAFITJan 2017 - Dec 2022 (6 years)
Projects (professional or personal)
verified_user
0% verified
- CCustomer successDec 2022 - Current (3 years 9 months)
- UTP databaseUTPDec 2022 - Jan 2023 (2 months)
- BBI and customer experienceJun 2021 - Jan 2022 (8 months)
- EAFIT UniversityEAFITJun 2018 - Dec 2022 (4 years 7 months)
Awards
verified_user
0% verified
- cconsultancyJan 2022 - Current (4 years 8 months)
- One of the best internship projects ( Experiments and constant improvements )Pensiones y Cesantias Protección S.A.Jun 2021 - Jan 2022 (8 months)
Publications
verified_user
0% verified
- pplatzi