You're seeing this page as if you were . The main menu is still yours, though. Exit from immersion
Stanislas TranST

Stanislas Tran

Data Analyst 📉📈 BI Consultant

€550/day
1 project
Paris, FR
3-7 years

Average response time: 1 hour

Freelancer profile translated to English.
Back to original language

About Stanislas

🎉Welcome to my Description🎉


Presentation

I have been working in the data field for 5 years in Data Analyst and BI Consultant roles. I am capable of handling all stages of a data project, from data integration to the publication of data analyses via dashboards.

I have primarily worked on IT and human resources projects. My goal is to support companies in exploiting and leveraging their data.


Type of missions

📊 Data Analyst
📊 BI Consultant

Skills

✔Writing technical and functional specifications
✔Integration of all types of data via ETL/pipelines
✔Data Warehouse modeling
✔Data analysis (descriptive, diagnostic, predictive, prescriptive)
✔Creation of reports and dashboards to publish results


Technologies

✔Visualization: Power BI, Business Object (BO), Tableau
✔DevOps: Git
✔Cloud: Azure
✔Programming: Python, Java, PHP, Javascript
✔ETL/pipeline: Talend, Business Object Data Services (BODS), Azure Data Factory (ADF), Spark

Languages

đŸ‡«đŸ‡·French
đŸŽó §ó ąó „ó źó §ó żEnglish


Availability

I am available ASAP for long and short-term assignments.

Certifications

📌Microsoft Certified: Power BI Data Analyst Associate
📌Microsoft Certified: Azure Fundamentals

Degree

Master's degree in Decision Support IT (MIAGE) through apprenticeship
  • French

    Native or bilingual

  • English

    Fluent

Remote only
Primarily works remotely

Experience

  • Dassault SystĂšmes
    Data Analyst/Data Engineer
    SOFTWARE PUBLISHING
    February 2021 - December 2023 (2 years and 10 months)
    Vélizy-Villacoublay, France
    I completed an assignment for Davidson Consulting as a Data Analyst/Data Engineer for 3 months within the IT team.

    Integration of new sources into the data warehouse:

    -Integration of data from the Truesight Monitoring tool
    -Integration of data from the CMDB and BMC Discovery
    -Integration of monitoring data for Truesight server indexations
    -Integration of monitoring data for SAP BODS jobs
    -Integration of CVE data from NIST
    -Integration of data from the Zscaler tool
    -Integration of mobile threat defense data


    Data visualization:

    -Implementation of a dashboard to analyze BODS job performance
    -Implementation of a dashboard to monitor ETL process errors
    -Implementation of a dashboard to analyze Exalead generic indexation performance
    -Implementation of a dashboard to analyze event management for the Monitoring Operation team
    -Implementation of a dashboard to monitor security for access to BO reports and Dashboards
    -Implementation of a dashboard to monitor AWA scheduler performance

    Reporting:

    -Implementation of security on the Business Object reporting tool for report access
    -Implementation of a universe to cross-reference all IT data and design reports
    -Implementation of reports on machine patching status
    -Implementation of a report to analyze EDR installation on machines
    -Implementation of a report for SecOps teams
    -Implementation of a report to monitor Active Directory (AD)
    -Implementation of a report to monitor BMC CMDB data quality
    -Implementation of a report to monitor LOG4J patching
    -Migration of UNV reports and universes to UNX

    Data engineering:


    -Implementation of a generic data integration process to retrieve data requiring the use of a web service or API. A Python library was developed to support this process.
    -Implementation of Pipelines to extract data from the BMC CMDB through Python scripts executed by BODS
    -Implementation of Pipelines (Workflow) on AWA (Automic Workload Automation) to manage data warehouse population
    -Implementation of execution controls on AWA

    Development:

    -Development of a web portal to visualize, manipulate, and extract data from the IT data catalog



    Technical Environment:

    ETL: Business Object Data Service (BODS)
    Data visualization : Business Object
    Languages : Python, PHP, Javascript
    Databases : Oracle, SQL Server, PostgreSQL, MySQL
    Reporting: Business Object (BO)
    Scheduler: AWA (Automic Workload Automation)
    CMDB: BMC
    Integration: GitLab
    API Tools: SoapUi, ClientApi
    Data indexing: Exalead generic


    Oracle BODS Business Object Data Analyst Data Engineer Data visualization AWA API
  • Infobam (Groupe GBH)
    Talend Developer
    E-COMMERCE
    January 2021 - February 2021 (1 month)
    La Réunion, France
    Talend Developer:

    -Implementation of a data warehouse from vehicle sales data.
    -Implementation of automated jobs to populate the data warehouse
    -Implementation of data quality processes
    -Implementation of tests to test the data warehouse

    Technical Environment:

    -ETL: Talend
    -Database: SQL Server
    -Scheduler: Windows Scheduler
    -Versioning: Gitlab
    Talend Data Engineer Data Analyst SQL Server Gitlab Git Java
  • Senettis
    BI Consultant and Java Developer
    LOGISTICS AND SUPPLY CHAIN
    October 2020 - December 2020 (3 months)
    Paris, France
    Senettisis a company specializing in commercial cleaning services.

    I completed 2 assignments at Senettis:

    Data Analyst:

    -Creation of a data warehouse on SQL Server
    -Implementation of automated jobs on Talend to populate the Data Warehouse
    -Creation of financial reports onPower BI

    Full Stack Java Developer:

    -Creation of a construction site management and profitability analysis application
    -Implementation of a transactional SQL Server database

    Technical Environment:

    -Language: Java
    -Database: SQL Server
    -ETL: Talend
    -Data Visualization: Power BI
    -Versioning: Github
    Microsoft SQL Server Transact-SQL Java Microsoft Power BI Talend

Reviews

5.0

Out of 1 rating

G

Guy

Infobam (Groupe GBH)

Reviewed on 1/12/2021

efficient and fast

Recommendations

These freelancer profiles also match your criteria

AgathaA

Agatha Frydrych

Backend Java Software Engineer

4.7

(3)

2

BaptisteB

Baptiste Duhen

Fullstack developer

4.6

(4)

5

AmedA

Amed Hamou

Senior Lead Developer

4

(2)

7

AudreyA

Audrey Champion

Web developer

4.3

(3)

4

Education

  • Master's degree in Decision Support IT (MIAGE) (Apprenticeship)
    Paris-Dauphine
    2020
    Le parcours MIAGE Informatique Décisionnelle vise à doter les étudiants de compétences scientifiques pour améliorer le fonctionnement des organisations par l'utilisation des outils de l'informatique décisionnelle et l'application d'une approche scientifique. Il s'agit donc de former des professionnels ayant une double compétence en informatique. Les objectifs de la formation : Avoir des compétences approfondies en informatique et informatique décisionnelle, (bases de données, data warehouse, nouvelles technologies de l'information) Avoir des compétences scientifiques pour comprendre les organisations et leurs impératifs stratégiques et améliorer leur fonctionnement Etre en capacité de modéliser et résoudre des problÚmes de décision à travers la maßtrise de différents outils décisionnels
  • Bachelor's degree in MIAGE
    Paris-Dauphine
    2017
    Le parcours MIAGE a pour but de donner aux Ă©tudiants une formation solide en informatique et former des futurs professionnels de la conduite de projets dans les organisations, en informatique dĂ©cisionnelle et recherche opĂ©rationnelle. Compte tenu de sa double compĂ©tence et en particulier son bagage informatique important acquis durant sa formation, l’étudiant pourra trouver un dĂ©bouchĂ© professionnel direct. Les objectifs de la formation : AcquĂ©rir une bonne comprĂ©hension des systĂšmes d'information, en associant des enseignements liĂ©s Ă  aux mathĂ©matiques, Ă  l’économie et Ă  la gestion Assimiler les connaissances informatiques en analyse, conception et dĂ©veloppement, en optimisation et en dĂ©cision, modĂ©lisation en Ă©conomie et en finance, ainsi qu'une premiĂšre approche des structures organisationnelles et des outils du management AcquĂ©rir les savoir-faire gĂ©nĂ©raux dans le domaine de la gestion, des mathĂ©matiques, de la communication en entreprise ainsi qu'une bonne connaissance en langue anglaise technologique, essentiels dans le domaine de l'informatique : la conception, la modĂ©lisation et l’architecture d’applications, les mĂ©thodes et outils de dĂ©veloppement et de gĂ©nie logiciel ainsi que la maĂźtrise des connaissances dans les domaines des systĂšmes d’exploitation, des rĂ©seaux et des bases de donnĂ©es Prendre connaissance sur l'algorithmique, programmation (Python, Java, C), bases de donnĂ©es, rĂ©seaux et de nombreux outils informatiques (PHP, HTML, Excel) DĂ©velopper une culture gĂ©nĂ©rale Ă©conomique et financiĂšre utile tant pour l’avenir professionnel des Ă©tudiants que pour leur permettre de comprendre les grands enjeux et dĂ©bats de l’économie en tant que citoyen

Certifications

Skill set

Categories