Learn Data Skills
Beta
Daniel Alejandro Sanchez-Martin

Daniel Alejandro Sanchez-Martin

Data Analyst

Bogota City Hall

Technologies

My Portfolio Highlights

My New Track

Data Analyst

Data virtuoso, orchestrating symphonies of information.

My Work

Take a look at my latest work.

course

Introduction to SQL

course

Intermediate SQL

course

Time Series Analysis in Power BI

Power BI

My Certifications

These are the industry credentials that I’ve earned.

Other Certificates

Digital House Data Analytics

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

My Work Experience

Where I've interned and worked during my career.

ELESTABLO COLOMBIA | Sep 2021 - Sep 2022

Senior Business Analyst

• Implemented RFM analysis (Recency, Frequency, Monetary) to understand customer behavior using Power BI, positively influencing business decision- making and increasing sales by approximately 20%. • Designed and implemented a client loyalty system and data capture tools utilizing IoT, resulting in a 7x increase in the number of clients captured and systematized through Power BI and Excel within the first three months. Achieved an average monthly growth rate of 10%.
Show More

Alcaldía Mayor de Bogotá | May 2020 - Present

Senior Data Analyst

• Designed and implemented strategies and KPIs to improve the entity's management and investment, resulting in a 10x increase in citizen participation within the first year. Successfully established a collaborative management model involving the private sector, community, university, and mayor's office, impacting over 200 local enterprises. • Developed a data capture instrument for investment projects, enabling the creation of a baseline for monitoring and controlling their impact. This achievement marked the first time the beneficiary population was characterized at the local level.

Freelance | Jan 2019 - Present

Senior Business Analyst

• Collaborated with an e-commerce company to enhance their inventory management system by conducting thorough ETL processes and SQL- based data analysis. Developed insightful Power BI dashboards for effective data visualization, resulting in a 15% reduction in stock holding costs and a significant improvement in order fulfillment speed. • Partnered with a healthcare provider to create a data-driven predictive model using Excel, and Tableau. Crafted interactive and informative Tableau dashboards, enabling them to anticipate patient needs and allocate resources more efficiently. This approach led to a 20% decrease in patient wait times and a 10% increase in overall patient satisfaction.

Kumon Colombia | Apr 2013 - Apr 2020

Head of Business Intelligence

• Designed and implemented institutional improvement tools using Excel models to automate processes and generate visualizations in Tableau for data-driven decision-making. This resulted in a 3x increase in the number of subscribers within the first eight months.

Fundación Hagamos País | Dec 2015 - Dec 2017

Head of Business Intelligence

• Managed information on recyclable material collection, routes, workforce availability, and frequencies in two municipalities in Cundinamarca-Colombia using Excel models. Generated financial and logistical KPIs on operations, resulting in the waste collection of 30 tons per month after the first six months of operation. • Defined the organization's social impact stages based on data analysis with Excel, leading to international recognition from President Barack Obama's White House through the Young Leaders of the Americas Initiative (YLAI) program.

Blue Star Recyclers | Oct 2016 - Nov 2016

Business Analyst

• Participated in a month-long exchange visit sponsored by the White House as a YLAI (Young Leaders of the Americas Initiative) Fellow, analyzing the host company's business model and providing recommendations based on financial, logistical, and HR data.

Davivienda | Mar 2012 - May 2013

BI Analyst

• Designed and developed advanced Excel models to streamline the preparation of periodic reports for the CEO of the company. • Utilized Microsoft Access to effectively manage and analyze large amounts of data, providing actionable insights to decision-makers mainly by monitoring data from HSBC Central America (Costa Rica, El Salvador, and Honduras) organizations acquire by the bank.

Davivienda | Jul 2011 - Jan 2012

BI Intern

• Developed a comprehensive database of payroll clients using Excel and VBA, providing valuable insights and facilitating informed decision-making. • Created the first credit risk report for the payroll segment, revealing previously untapped opportunities and enabling C-level executives to better understand and manage risk.

Grupo Bolívar S.A. | Jul 2010 - Jan 2012

BI Intern

• Developed data models in Excel for various departments at Davivienda (the third largest bank in Colombia), significantly improving reporting efficiency by at least 2x for immediate managers and C-level executives.

Universidad Externado de Colombia | Jun 2010 - Jun 2011

Research Assistant, Stochastic Calculus Applied to Finance

• Conducted literature research to support a Stochastic Calculus investigation applied to financial markets in Colombia. Reviewed MSc Finance handbooks for relevant information.

Universidad Externado de Colombia | Sep 2010 - Mar 2011

University Outreach and Marketing Associate

• As a University Outreach and Marketing Associate, I effectively promoted the university's academic programs to prospective students at various fairs and events. Averaging 50 prospects per event and leveraging communication skills and deep knowledge of the institution's offerings to provide insights into the university experience and the advantages of choosing the institution.

My Education

Take a look at my formal education

MSc in Business IntelligenceUniversidad EAN | 2023
PGCert in Management of Quality and Innovation ProcessesUniversidad EAN | 2020
BA in Business ManagementUniversidad EAN | 2014
BSc in FinanceUniversidad Externado de Colombia | 2011

About Me

Daniel Alejandro Sanchez-Martin

Bilingual Senior Business Analyst with a Master's degree in Business Intelligence, offering a strong background in data analysis and project leadership across diverse industries.

Powered by

  • Work
  • Certifications
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free