Marcela Lizarazo Email & Phone Number

Toronto, Ontario, Canada

Bogotá, Distrito Capital, Colombia

• Designed and pioneered the new role of Campaign Data Analyst from scratch, establishing guidelines, responsibilities, and key performance indicators to drive the department’s growth and efficiency.
• Led a data-driven recovery effort for 17,000 previously unaccounted-for promissory notes that were undelivered to the bank's escrow area. Through diligent effort, careful planning, and utilizing tools like Excel and.
• Led a data-driven recovery effort for 17,000 previously unaccounted-for promissory notes that were undelivered to the bank's escrow area. Through diligent effort, careful planning, and utilizing tools like Excel and.
• Restructured retail banking digital campaign reports, reducing delivery time from 60 to 15 days. Utilized Excel, SQL, and Power BI to standardize data, automate dynamic dashboards, and improve reporting efficiency by.
• Co-led nationwide retail banking campaign management tool development using Excel, SQL, and Power BI. Provided real-time insights into 30+ monthly campaigns, defined KPIs, and optimized campaign funnels for.

Bogotá, Distrito Capital, Colombia

• Optimized the extraction, transformation, and loading (ETL) processes for 25 monthly prospect client databases with 15,000 records on average each. Leveraged analytical skills and Excel, and SQL tools to automate data.
• Created monthly Power BI dashboards to monitor and visualize campaign-specific performance and… Show more
• Created monthly Power BI dashboards to monitor and visualize campaign-specific performance and efficiency KPIs, as well as conversion funnels. These dashboards provided critical insights, enabling the refinement of.

Bogotá D.C., Colombia

• Designed and pioneered the new role of Junior Analyst Payroll Loan product from scratch, establishing guidelines, responsibilities, and key performance indicators to drive the department’s growth and efficiency.
• Structured and managed the logistics of events and trade programs nationwide. This achievement had a significant impact on the organization as it contributed to a substantial increase in payroll loan disbursements with.
• Managed the… Show more
• Managed the purchasing process and suppliers of POP material and advertising pieces for the logistics of events and commercial programs throughout the country with an annual budget of CAD $63,000.
• Designed a dashboard for national zone managers to monitor event completion compared to targets and cost allocation in relation to disbursement. Implemented key performance indicators (KPIs) for performance and.

Bogotá D.C., Colombia

• Monitored the status of the commercial plant of the sales force across the country, which was outsourced, with the objective of ensuring that at least 95% of the employees' plant remained complete. This helped to.
• Ensured the 100% activation and deactivation of executive codes in the bank's platforms. This allowed active sales… Show more
• Ensured the 100% activation and deactivation of executive codes in the bank's platforms. This allowed active sales representatives to make the necessary queries for their sales and reduced the risk of identity theft or.
• Supervised and ensured the complete utilization of the budget allocated for commercial travel expenses, thus facilitating, and supporting their sales activities. Furthermore, to review in detail the necessary.

Bogotá, Bogotá D.C., Colombia

• Mitigated the risk of fraud in Payroll Loan credit applications by implementing security policies and conducting a thorough analysis of the credit application documents for potential customers.

Big Data Analytics, Post Graduate

Big Data Analyst responsible for analyzing large and complex datasets to extract information for analysis and decision-making through the.

Economist, Economics, B.Sc. Economy

Economist with the ability to apply theoretical and practical knowledge in the analysis and solution of economic problems in national and.

Business Management Technologist, Business Administration, Technologist