Freelancer profile translated to English.
Back to original languageAbout Valery
Available for short expertise missions or long-term remote or on-site support.
With fifteen years of experience in software development, primarily with Microsoft platform tools, I have acquired significant experience and expertise in:
- Definition of information system architectures
- Modeling of transactional and decision-making databases.
- SQL Server performance audit through the implementation of database server monitoring tools
- Transact-SQL development through code optimization
- Development of data loading workflows via SSIS
- Development of applications with Power Apps
- Creation of databases in Dataverse
- Creation of workflows with Power Automate
- Implementation of multidimensional cubes with SSAS
- Development of reports under SSRS and Power BI
- Beginner or advanced training.
French
Native or bilingual
English
Fluent
Can work on-site
Paris (up to 50km), Cergy (up to km), Courbevoie (up to km), Puteaux (up to km), Nanterre (up to km)
Experience
- BRAKINA (Groupe Castel)Power Platform DeveloperAGRICULTUREMarch 2023 - June 2025 (2 years and 3 months)Paris, FranceDevelopment of four operational applications based on Power Platform for monitoring the manufacturing and bottling activities of beverages (Beers, Soda, etc.).
- Requirements gathering and writing functional and technical specifications
- Development of flow diagrams
- Definition of the target architecture
- Database modeling
- Creation of interface mockups with Moqups
- Creation of environments (Development, Test, Production)
- Creation of tables in Microsoft Dataverse
- Development of interfaces with Power Apps
- Creation of Power Automate flows to automate workflows
- Application deployment
- Creation of Power BI dashboards based on the Microsoft Dataverse database
- Creation of a decision-making AI layer via ThoughSpot and Snowflake
- Implementation of a decision-making POC with Fabric (Data loading into a data warehouse via Dataflow Gen 2)
Technical environment: Microsoft Dataverse, Microsoft Power Apps, Power Automate, Power Bi Desktop, Power Bi Service, Moqups, Power Query, DataFlow Gen 2, ThoughtSpot, Snowflake, Fabric - CAMTEL (Cameroon Telecommunication)BI ArchitectTELECOMMUNICATIONSMarch 2023 - March 2023 (1 month)Paris, FranceProposal of a scalable BI architecture based on an Oracle database, SSIS, and Power BI. The objective is to quickly make data available to users.
- Phase 1 - ELT: Extraction of data and storage in tables, then use of stored procedures for transformations. Finally, the data is exposed at the Power BI level via views.
- Phase 2 - ELT: Views are persisted in tables and these tables are subsequently indexed.
- Phase 3 – ETL: Creation of Datamarts (star schema)
- Creation of dashboards in Power BI
Technical environment: Oracle 12c, SSIS, Power BI, Attunity Component, Power Bi Service - Orange BankMicrosoft BI and OPS ExpertBANKING AND INSURANCEJune 2020 - February 2023 (2 years and 9 months)Montreuil, FranceOperational monitoring, maintenance in operational condition of the platform (MCO) and Migration from SQL Server to SQL Server RDS.
- Development of data loading monitoring tools
- Implementation of alerts for platform monitoring
- Implementation of database maintenance plans
- Sharing of operational metrics via Confluence
- Planning and monitoring of production deployments via Jira
- Consolidation of deliverables via Azure Devops
- Design review
- Creation of data loading workflows
- SQL Server tuning
Technical environment: Windows 8, SQL Server 2016, SQL Server Reporting Services 2016, SQL Server Integration Service 2016, Power BI Report Server, AzureDevOps, Teams, Slack, Confluence, PagerDuty, Jira, PowerShell
Reviews
Recommendations
Be the first to recommend Valery
Help this freelancer shine by sharing your experience working together.
These freelancer profiles also match your criteria
Agatha Frydrych
Backend Java Software Engineer
4.7
(3)
2
Baptiste Duhen
Fullstack developer
4.6
(4)
5
Amed Hamou
Senior Lead Developer
4
(2)
7
Audrey Champion
Web developer
4.3
(3)
4
Education
- Doctorate in Science, Specialization: Decision Support SystemUniversité de Rennes 12013Responsable de la mise en place des modèles de données et des mécanismes de requêtes associés pour les systèmes d’aide à la décision.
- Master 2 in Computer ScienceUniversité de Rennes 12009