Menu

David JAYASEELAN

Paris

En résumé

Accumulating 10 years of BI experience, David had the opportunity to get involved in very varied types of businesses, including Aeronautics, Banking and Insurances, Telecommunication, Pharmaceutical and Food logistics.

His goal is to continue developing his team coordination skills and pre-sales needs in harmony with his technical knowledge.

Specialties:
• Microstrategy Certified Engineer and technical coordinator
• QlikView Certified Professional and technical coordinator
• Informatica PowerCenter
• Oracle and Sql Server Platform
• SAP BI

Mes compétences :
Informatica
MicroStrategy
Oracle
Qlikview
Business Intelligence
QlickView

Entreprises

  • TALAN - Solutions Manager Business Intelligence

    Paris 2016 - maintenant Presales and Consultant Management for Microstrategy Solution.
  • Airbus - Senior BI Consultant

    Blagnac 2012 - 2016 Airbus is a division of Airbus Group SE that manufactures civil aircraft. It is based in Toulouse Suburb with production and manufacturing facilities mainly in France, Germany, Spain and the United Kingdom.

    Main Tasks :
    Global Architect on Tactical Planning Reporting projects
    Conception - Analysis - Architecture - Development - Coaching
    Harmonized User friendly landscape Design
    Writing the Norms & Methods - Optimizing Process.
    Training Session for End users and Proof of Concept Realization in BI4.

    Aeronautics Domain:
    Industrial process
    Configuration management
    Manufacturing planning
    Quality

    Challenges :
    Convert time-consuming, unharmonized and unindustrialized solutions to evolutive and maintainable results.

    Client Benefits :
    Harmonized and new friendly user interface landscape
    Automation process in line with their requirements

    Technical background :
    SAP BW 7.3, SQL SERVER 2012, SAP BI 4.1
  • BNP Paribas Fortis - Senior BI Consultant

    PARIS 2010 - 2012 BNP PARIBAS FORTIS, the no. 1 bank in Belgium, offers the market a comprehensive package of financial services for private and professional clients, wealthy individuals, corporate clients, public entities and financial institutions. Today, it is organized around 4 core activities: Retail & Private Banking, Corporate & Public Banking, Corporate & Investment Banking and Investment Solutions. BNP Paribas Fortis supports its clients abroad with a unique pan-European network reinforcing the Group's worldwide positions.

    Operational Maintenance:
    -Execute DW maintennace Jobs - fast track, Credit Margins
    -Corrective Maintenance - Handle Incidents and Defects coming from BNPP-Fortis
    -Preventive maintenance - Optimize application processes and code

    Adaptive&Evolutive Maintenant
    -Keep the datawarehouse in line with evolving technology and software product releases.
    -Implement the functionalities in order to make the platform evolve in line with changing business needs.

    Operational Service and Quality Management
    -Timeline and planning follow up
    -Risks and issues management

    My main activities are:

    Oracle DBA :
    Document and Implement DB-changes, DB Maintenance tuning.

    Platform Administrator :
    PowerCenter Administration Tasks, platform support, Tool Vendor Support

    ETL Framework :
    Manage the ETL Application Framework, standards and guidelines. Review Designs.

    Release Management :
    Coordinate releases, maintain release documentation, deploy PowerCenter and Unix-scripts.

    Role : Technical team Coordinator / Tech Lead.
    Tools : Unix Script, Informatica v8, Oracle 10g
  • Fedex - Senior BI Consultant

    GENNEVILLIERS 2009 - 2010 Primary Tasks and responsibilities :

    1. Familiarize with the existing XML parsing environment
    2. Translate the functional design document and database model into the needed tables
    3. Develop the needed ETL workflows to fill the tables with data
    4. Cooperate with other ETL developers to ensure transparency and smooth integration in the existing ETL workflows
  • Johnson Controls - Senior BI Consultant

    Colombes 2009 - 2009 22/6/2009 - 20/9/2009 Johnson & Johnson

    Name: Clinical Trials Management System
    Role: Analyst Programmer, Technical Analyst

    Description: Central Business Support Services, a Division of Global Clinical Operations, part of J&J is responsible for support of the IT systems used within GCO.

    One of the main systems supported is the Clinical Trials Management System, a system that allows you track the progress and activities of a clinical trial.
    CTMS currently has its own cognos reporting environment setup, based on a datamart that was developped in house (CACTUS). A set of predefined reports is already available in this reporting tool (AGORA).

    They were planning to extend this datamart with a set of new tables from another GCO supported system, Trial Master Source.

    Primary Tasks and responsibilities
    -Familiarize with the existing reporting environment
    -Translate the functional design document and database model into the needed tables
    -Develop the needed ETL workflows to fill the tables with data
    -Cooperate with other ETL developers to ensure transparency and smooth integration in the existing ETL workflows

    Toward the end of the project a set of cognos reports have been developed based on the added tables to cover the standard reporting needs for the Trial Master Source project.

    Technical background : ETL analysis and development in Informatica Power Center 8.5.1
    · Data modeling, PL/SQL, Performance Tuning
    · Cognos experience 8(ReportNet and framework manager ; Analysis Studio , Metrics Studio)
    Technical background: Informatica PowerCenter 8
  • Belgacom - Senior BI Consultant

    Bruxelles 2008 - 2009 1/7/2008 - 23/06/2008 BELGACOM Belgacom Group

    Name: Migration Biling Manager
    Role: Analyst, DataWarehouse Architect, Technical Analyst
    Description: Billing Manager's Overview

    Companies use numerous telecom products and services and therefore receive a large number of
    bills from Belgacom each month. Centralizing these bills and analyzing the telecoms budget require
    each company to carry out an enormous amount of followup and generates high costs.

    Belgacom Billing Manager (BMG) is an Internet application which, on the basis of predefined criteria,
    provides belgacom customers with a reliable and secure solution for:
    o creating reports,
    o analyzing reports,
    o downloading reports.

    All data is extracted from Belgacom's official billing system.

    Customers have access to their billing data records of the last 13 months.
    The current solution regarding the reporting is based on Business Object Webi 6.5.2. The DBMS is ORACLE 9i.

    Mission Objectives

    Belgacom intends to migrate its current Billing Manager application in 2008 to a completely new system, based on the architecture and the technology delivered by MicroStrategy.
    The objectives of Belgacom for this migration project are the following:
    1. Stop using technology that will no longer be supported within Belgacom mid 2008
    2. Provide its customers a more simple and more user-friendly application for reporting and analysis on billing data
    3. Provide new functional and technical capabilities that will increase the usability of the application for Belgacom?s customers
    4. Provide a more reliable, stable and better performing system with very little down-time
    5. Migrate all standard and all personal reports
    6. And in the longer term: differentiate itself from the competition by offering its customer new , innovative services through this new Billing Manager system.

    In this contexte, my work will be to analyze the existing reports in Business Object, create the new report on Microstrategy and try to optimize as much as possible.
    Technical background: MicroStrategy Desktop, MicroStrategy, Microstrategy Advanced Reporting, MicroStrategy Architect, MicroStrategy Web, Business Objects
  • Groupe Danone - Consultant BI

    PARIS 2006 - 2008 21/8/2006 - 31/1/2008 Unilog Logica Danone

    Name: Pyramide : Junior Third Party Maintenance Project Leader
    Role: Analyst Programmer, Functional Analyst, IT Support

    Description: Danone is the number one food products company in France, world leader in dairy products

    Pyramide : Danone Corporate TPM

    Danone Corporate have a Business Intelligence Third Party Maintance to control the cost of operational maintenance, the development of new services for users and have a visibility on the performance level.
    The Users were from the Financial Sector and the Commercial Sector.

    Objectives and Responsabilites :

    -Corrective and Evolving maintenance with Essbase
    -Expertise upon Request for assistance for Microstrategy
    -Analysis and modeling with PowerAMC
    -Development of data extraction mappings with Informatica from several sources ( SAP, flat files, Operational DB, Analysis of the dependencies and construction of the workflows)
    -Develop ETL workflows to fill the tables



    Domains and intervention levels
    -Design and Implementation
    -Testing
    -Documentation
    Technical background: Business Analysis, DB2, Essbase, Informatica Power Center, MicroStrategy, Power AMC, Microsoft SQL Server 2005 Business Intelligence, Oracle 9.i, Oracle PL/SQL

Formations

Réseau