Summary
Overview
Work History
Education
Skills
Certification
Software
Work Availability
Languages
Work Preference
Quote
Domains
Interests
Websites
Timeline
Generic
David Julian Lopez

David Julian Lopez

Sr Business Analyst
Mexico City

Summary

Sr Business Analyst and Emerging Product Manager

With over 27 years of experience in the IT industry, I have developed a diverse skill set through roles such as Technical Consultant (SQL/PLSQL), Account Manager, Product Consultant, and Software Development Lead. For the past decade, I've focused on business analysis, particularly in utility, e-commerce, and payments projects.

Expertise:
* Extensive domain knowledge in charge generation, billing processes, billing notes, billing claims, collections, and BSS functionalities.
* Skilled in e-commerce checkout processes, ensuring seamless transactional experiences.

I am known for my dedication and accountability, consistently aiming to meet and exceed stakeholder expectations. My goal is to ensure that our products fulfill both investor needs and deliver exceptional value to customers.

Additional Roles and Responsibilities:

* Acted as a Proxy Product Owner / Product Manager, overseeing product development from conception to delivery.
* Managed continuous product improvements and updates.
* Prioritized feature development based on business and customer value.
* Created and maintained the product roadmap.
* Served as the main contact point for internal and external stakeholders.
* Communicated updates and outcomes to key stakeholders.

I am passionate about driving innovative solutions and contributing to successful project outcomes. I continuously seek opportunities for professional growth and collaboration in product management.

Overview

27
27
years of professional experience
8
8
Certificates
2
2
Languages
5
5
years of post-secondary education

Work History

Sr Business Analyst

Globant Mexico
8 2023 - Current

e-commerce client (El Palacio de Hierro), Salesforce Commerce Cloud

  • Implemented organized templates for Epics and User Stories, refining clarity and increasing efficiency by 6 user stories/session.
  • Streamlined planning with pre-planning sessions, reducing duration by up to 40%.
  • Collaborated with Product Owners and stakeholders to gather requirements and define functional specifications for eCommerce projects.
  • Managed stakeholder expectations with transparent communication and timely updates, aligning project deliverables with business objectives.

Sr Business Analyst

Endava Colombia
07.2022 - 05.2023

Payments Xcelerator Project (Internal Product), Java

  • Established final data model and redesigned recurring payments architecture, achieving minimum viable product in eight sprints.

Retail Client Project (Lululemon), iOS

  • Created high-quality features and user stories, resulting in three sprints with zero carryover and 45% reduction in QA incidents.
  • Implemented pre-refinement sessions to enhance backlog quality, following INVEST criteria and covering three sprints ahead.
  • Introduced pre-planning sessions with Scrum Master, reducing planning duration by up to 50%.
  • Collaborated with Product Manager to prioritize PI planning within SAFe train, generating backlog for upcoming quarter.

Ssr Business Analyst

Globant Colombia
07.2021 - 07.2022

ESPN Project

  • Automated user story creation by 80% using Word and Excel merge options, significantly streamlining the process.

EY Project (Data Bricks, Power BI)

  • Managed 70% of backlog items for the VAT Adjustments project, ensuring smooth execution.
  • Achieved a 7% reduction in rework and a 10% increase in software quality by generating detailed technical specifications in user stories and backlog spikes.

Sr BSS/CRM Product Consultant

Open Systems Colombia SAS
11.2018 - 06.2021

EPM Medellin (Colombia), Version Upgrade Project (Smartflex 8x)

  • Identified and resolved gaps in the billing module, achieving a 5% time savings in analysis.

City of Fort Collins (USA), Software Implementation Project (Smartflex 8x)

  • Configured the Debt Collection module, optimizing management processes by 5% through dynamic notifications.

SUBACE (Mexico City, Mexico), Software Implementation Project (Smartflex 7x)

  • Modeled and trained users on the CRM module, enhancing pre-sales and post-sales flows, reducing estimated effort by three months.

CNT EP (Quito, Ecuador), Consultancy and Training Project (Smartflex 6x)

  • Trained 25 users on CRM, OSS, and BSS, improving IT productivity by 7% following on-site sessions.

Software Development Leader

Open Systems Colombia SAS
09.2016 - 10.2018

Business Analyst
Various Clients / Different Countries (Smartflex 7x and 8x, HTML5, Oracle PLSQL, Java)

  • Enhanced analysis, design, and construction skills within team of 6 engineers through peer review and coaching, leading to 15% increase in productivity over three months.
  • Increased up to 20% of technical and functional guidance to engineers, ensuring they had support needed for successful task execution.
  • Reduced quality incidents in development projects by 20% through robust peer review processes and promotion of unit testing.
  • Led negotiation sessions up to 70% of meets with key clients to improve project timelines and scope, resulting in successful outcomes and strengthened client relationships.

Account Manager

Open Systems Colombia SAS
08.2013 - 09.2016

CNT EP (Quito, Ecuador), Smartflex 6x and 4x (Oracle PLSQL, SQL, .NET)

  • Resolved client-reported incidents within timelines that exceeded Service Level Agreements (SLAs).
  • Facilitated sessions with stakeholders and product owners to understand business areas, analyze feasibility, and define functional requirements, leading to well-structured backlog.
  • Managed support and maintenance contract, ensuring smooth operations and high-quality service delivery.
  • Provided technical consulting to client's product team, offering insights to enhance strategic decision-making and optimize product performance.

Senior Product Consultant

Open Systems Colombia SAS
05.2009 - 07.2013

Various Clients / Different Countries (Smartflex 6x, Oracle PLSQL, SQL, .NET, Delphi)

  • Implemented BSS (Business Support System) modules for multiple clients, including Car Security (Buenos Aires, Argentina), Open Mobile (Guaynabo, Puerto Rico), and CNT EP (Quito, Ecuador).
  • Executed technical consulting and process redesign in PL/SQL, enhancing performance and efficiency, along with SQL statement tuning for optimized database operations.
  • Provided on-site technical consulting to client's product team, delivering valuable insights and recommendations for improvement to ensure effective collaboration and knowledge transfer.

Previous Experience

Multiple Industries
05.1997 - 05.2009

This information is available in LinkedIn profile:

  • Axede, Senior Software Engineer, Aug/2008 - May/2090
  • Carvajal SA, Senior Technical Consultant, Sep/2005 – Jul/2008
  • Comfenalco valle, Junior software engineer, Mar/2005 – Aug/2005
  • Tecnoquimicas SA, Software engineer, Feb/2003 – Feb/2005
  • Open Systems Colombia SAS, Software engineer, Feb/1998-Sep/2002
  • Banco de Occidente, Internship student, May/1997 – Dec/1997

Education

Bachelor of Science - Engineering Technology

Universidad De San Buenaventura
Santiago De Cali, Valle Del Cauca, Colombia
06.1992 - 06.1997

Skills

Communication Skills

Certification

User Stories Foundations Certificate

Software

Plsql

SQL

JIRA

ADO

Trello

MIRó

Bizagi

Drawio

Confluence

Slack, MS Teams, Zoom, Google meet

Work Availability

monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse

Languages

Spanish
Bilingual or Proficient (C2)
English
Upper intermediate (B2)

Work Preference

Work Type

Full Time

Work Location

RemoteHybrid

Important To Me

Career advancementWork-life balanceFlexible work hoursPersonal development programsHealthcare benefitsPaid time off401k match

Quote

To raise new questions, new possibilities, to regard old problems from a new angle, requires creative imagination and marks real advance in science.
Albert Einstein

Domains

  • Charging, billing, and payments process.
  • Debt financing and installment payments process.
  • Debt Collection management for utilities and telecommunications companies
  • Shipping, Checkout and payment on e-commerce platform for retail companies.
  • Recurring payments platforms

Interests

Product Management

Business analysis

Product development

Timeline

Product Management

10-2024

Career Mentoring Match (Colectivo23)

07-2024

Sr Business Analyst

Endava Colombia
07.2022 - 05.2023

Ssr Business Analyst

Globant Colombia
07.2021 - 07.2022

User Stories Foundations Certificate

06-2021

Kanban Essentials Professional Certificate

04-2021

Scrum Master Professional Certificate

04-2020

Scrum Product Owner Professional Certificate

04-2020

Scrum Foundation Professional Certificate

04-2020

Sr BSS/CRM Product Consultant

Open Systems Colombia SAS
11.2018 - 06.2021

ITIL OSA (Operational Support and Analysis)

10-2018

Software Development Leader

Open Systems Colombia SAS
09.2016 - 10.2018

Account Manager

Open Systems Colombia SAS
08.2013 - 09.2016

Senior Product Consultant

Open Systems Colombia SAS
05.2009 - 07.2013

Previous Experience

Multiple Industries
05.1997 - 05.2009

Bachelor of Science - Engineering Technology

Universidad De San Buenaventura
06.1992 - 06.1997

Sr Business Analyst

Globant Mexico
8 2023 - Current
David Julian LopezSr Business Analyst