Juan R. Buenaventura

Senior Business and Financial Analyst

Home     Work Experience     Education     About me     Contact      
Smart decisions come as a result of preparation and experience
I have a wide background in my professional life, which gives me the ability to think strategically in order to design, implement and analyze information processes to help the organization make the right business decisions.
The following is my work history.

 
IBM       (Boston, MA)

September 2008 - present
Financial Analyst - Independent Consultant
  • Advised internally, developing business workflows, information maps and Excel tools for the migration of around 800 Cognos customers in the US to IBM reducing the quoting time and helping to release 5 people out of 9 from our team.

    ·    Partnered between the support renewal team and finance, researching data repositories and legal agreements to offer software alternatives to customers in the migration process from Cognos, in order to maintain and increase software support revenue from large accounts (>$100k/year), always exceeding the corporate goals

    ·    Developed expertise in Cognos Business Intelligence software including Performance Applications to help customers increase their perceived value in order to renew or upgrade

Website: www.ibm.com

 

Expense Reduction Analysts         (Bogotá, Colombia - Boston, MA)


December 2004 - September 2008
Managing Director 

  • Developed the business plan, obtained financing and started the Master franchise in Colombia. Designed and implement budget, periodic strategic plans and reporting tools including the balance scorecard to report to the board based on KPIs.

    ·    Built, lead and coached a team of 8 top tier consultants and analysts to achieve specialization in the consulting services. Sold 2 franchises and coached their teams, reaching 6 customers in 2 other cities and collecting 10% of the franchisee’s sales.

    ·    Attained 22 clients ($50 - $600 million in sales), dealing primarily with CFOs, achieving sales of $450k in my last year.

    ·    Planned and developed financial models and management reporting tools in Excel for customers as well as balance scorecards based on KPIs, structured within 5 dimensions: processes, suppliers, learning, customers and finance

    ·    Reviewed client procurement in utilities, shipping, telecommunications, card processing fees, duplicate payments and record management improving systems and achieved 28% average savings in over 30 projects. Documented supplier benchmarks

    ·    Designed, documented and implemented ABC costing for the largest law firm in Colombia

     

 

Article in ERA Global News (.pdf 1836kb)

 

Websites:

Expense Reduction Analysts www.expensereduction.com

ERA Colombia www.era-colombia.com

ERA Franchise www.franquicia-era.com   

 

Synergy Investments - Skandia        (Bogotá, Colombia)


January 1997 – December 2004 

General Manager

  • Developed the company’s sales, marketing and operational strategies, achieving over $50 Million AUM with corporate clients and high net-worth individuals. Conduct risk assessments and developed sustainability strategies teaming with fund providers Performed due diligence for several merge projects, one of them successful after my recommendation

  • Performed due dilligence for several merge projects, one of them successful after my recommendation

  • Analyzed CRM outputs and Excel databases to develop campaings targeting the right audience

  • Supervised 8-10 financial planners and attained 30 corporate plans, reaching over 4,000 clients

  • Pioneered Markowitz optimization models and Monte Carlo simulations in Excel to manage customer's portfolios

 

Corfes       (Bogotá, Colombia)


January 1997 - January 1998 
Financial Analyst

  • Corporate credit analysis
  • Sectorial Analysis 
 

Academic Experience

 

Assistant Professor of Financial Modeling in Excel, at Rosario University June 04 - June 05

Lecturer of Neuro Linguistic Programming (NLP) Seminars June 98 - June 05

    

 

 

 

 

 
Skills

Advance user of MS Office, Lotus Notes,  Cognos tools and MindManager

I speak write and read Spanish and English fluently.

 
Other

I was member of the Advisory Board of Centralsa S.A. (Insurance Broker) from March 2005 to June 2007

I co-founded a leadership program for entrepreneurs

I designed a 360° performance evaluation software