LinkedInAmbrus Vancso

Ambrus Vancso

Cognos TM1 Consultant at Cubewise

Location
Gent Area, Belgium
Industry
Information Technology and Services
Current
  1. Cubewise
Previous
  1. IFUA Horvath&Partners,
  2. Social networking startup
Education
  1. Budapest University of Technology and Economics
Recommendations1 person has recommended Ambrus
Websites
223connections

Join LinkedIn & access Ambrus's full profile

Join LinkedIn & access Ambrus's full profile. It's free!

As a LinkedIn member, you'll join 300 million other professionals who are sharing connections, ideas, and opportunities.

  • See who you know in common
  • Get introduced
  • Contact Ambrus directly
223connections
Cubewise

Cubewise

IBM Cognos TM1 Consultant

– Present

View full profile

Background

Summary

Experienced and passionate Business Intelligence consultant supporting primarily the office of finance. Covers the full lifecycle of projects focusing on delivering what and how the business requires. Capable technical project manager, experienced and certified developer, strong IT skills.

Industry experience:

* Financial Institutions (banking/insurance/leasing)
* Aviation
* Transport
* Utilities

Solution experience:

* planning, budgeting and forecasting applications
* financial reporting
* sales analytics
* profitability analytics
* cash flow forecast and simulation
* capacity models
* salary and HR planning
* Activity Based Costing

BI expertise:

* data mart and data warehouse design and development
* ETL (extract, transform and load source data)
* dimensional modelling, OLAP Cubes
* proficient in SQL

Specialties:Corporate Performance Management solutions
IBM Cognos TM1 (certified developer)
Microsoft SQL Server (data warehousing experience)

Experience

IBM Cognos TM1 Consultant

Cubewise
– Present (4 years)

Cubewise, 'IBM Business Analytics Global Business Partner of the Year for Mid Market', is a professional consulting firm that specialises in the design and implementation of custom business planning, reporting and analytical applications using IBM Cognos technology.

Recent projects:

* Global Planning Solution at Consumer Goods Giant headquartered in Switzerland - details see below
* Euroports, an international harbour corporation: Cash Flow Forecasting. For details see [case study](http://ambrusvancso.wordpress.com/2011/09/18/case-study-cash-flow-forecasting-at-euroports/).
* International media industry group: Budgeting (80 budget owners), Month-End Management Reporting support and HR module development.

Business Intelligence Consultant

IFUA Horvath&Partners
(4 years)

Horvath & Partners is an independent, international management consultancy, a pioneer of Management Accounting & Controlling.
As consultant engaged in the full lifecycle of Business Intelligence projects including presales, architecture design and project management. Lead consultant in every listed project, responsible for the complete solution. Member of the Financial Industries Competence Center and BI Knowledge Center.

Key projects:

* Strategic Planning System for regional universal bank: analysis, design, implementation and ongoing support of a consolidated strategic planning system for the parent bank and its international subsidiaries (8 legal entities) using Cognos TM1 on top of SAP BW. Integrated TM1Web into the SAP intranet portal. Extended the system to support operational monitoring and valuation.

* Data Warehouse for leading European discount airline: analysing, designing and managing the development of flight ticket sales reporting and analytics using Microsoft SQL Server (SQL, SSIS, SSAS, SSRS).

* Financial applications at Vienna centered regional bank, Oracle environment: various projects using TM1, covering the development of capacity planning, HR planning, Employee Performance Review and Bonus Calculation models. Supporting operational planning, cost and income models.

* ABC and product profitability model at subsidiary of leading European leasing focused institution: designing and implementing Activity Based Costing and Product Profitability models using TM1.

* Business Intelligence Rollout at subsidiary of Dutch financial institution specialized in mortgage loans: end-to-end Business Intelligence solution starting from scratch, Analysis, design and implementation of corporate data mart using Microsoft SQL Server. Using Cognos TM1 for executive dashboard and KPIs, NPV planning and cash flow simulation. Transitioned from lead consultant to a mentor role to facilitate the knowledge transfer and support building an in-house competence center.

Entrepreneur

Social networking startup
(3 years)

Engaged in an innovative Hungarian social networking website (osztalytarsam.hu) as shareholder and developer.

Projects

Global Planning Solution at Consumer Goods Giant

Complex Financial Planning Solution with 120+ users spanning various subject areas and linking to existing corporate solutions like SAP BW, etc.
Employed an agile methodology and continuous mentoring to ensure fast and best possible results during the project and to make sure business retains the agility in the long term.

Honors & Awards

Colleague of the Year in Europe

Cubewise

Education

Budapest University of Technology and Economics

MSc, Bankinformatik

Budapest University of Technology and Economics

MSc, Engineering and Management

Activities and Societies: Thesis about decision support systems and a pilot data mart at Hypotheken Bank in Essen AG.

Tampere University of Technology

scholarship, Engineering and Management

Languages

  1. English

    Full professional proficiency
  2. German

    Professional working proficiency
  3. Hungarian

    Native or bilingual proficiency

Skills

  • Cognos
  • TM1
  • SQL Server
  • OLAP
  • Project Management
  • Controlling
  • Business Analysis
  • Performance Management
  • Business Intelligence
  • Financial Planning
  • Financial Reporting
  • Financial Modeling
  • Microsoft SQL Server
  • Analysis
  • Business Intelligence...

View Ambrus's full profile to...

  • See who you know in common
  • Get introduced
  • Contact Ambrus directly

Not the Ambrus Vancso you're looking for? View more

Insights


People Also Viewed

LinkedIn member directory:

  1. a
  2. b
  3. c
  4. d
  5. e
  6. f
  7. g
  8. h
  9. i
  10. j
  11. k
  12. l
  13. m
  14. n
  15. o
  16. p
  17. q
  18. r
  19. s
  20. t
  21. u
  22. v
  23. w
  24. x
  25. y
  26. z
  27. more