Fara Niang

Implementation and optimization of data pipelines (ETL): I designed and implemented processes to extract and integrate data from source systems into analytical databases. Processing was optimized through incremental integration of critical tables, ensuring performance and data integrity.

Automation and validation of data flows: I automated daily integration flows between different data layers, incorporating rigorous validation steps to ensure information reliability.

API Management and data exposure: I designed and managed REST and SOAP APIs to expose contractual data, incorporating dynamic criteria and business rules. I also documented these APIs and managed error scenarios for simple and secure usage.

Creation of a performance monitoring tool

Development of the calculation solution: I designed and implemented a SQL Server database and stored procedures (T-SQL) to reliably automate the calculation of employee bonuses, based on key performance indicators.

Availability for business teams: I created a VBA Excel user interface to allow managers to manipulate criteria and analyze results in real-time, giving them complete autonomy over the tool.

Optimization and performance: I optimized queries to ensure fast and efficient processing of large data volumes.

Optimization of data quality: I analyzed and validated existing data, implementing strict rules to ensure compatibility with the new ERP.

Automation of the migration process: I designed and developed a custom ETL (stored procedures, advanced SQL queries) to automate extraction, transformation, and loading. This enabled fast and error-free periodic data recovery.

Reduction of migration errors: The implementation of validation rules allowed for the detection and correction of anomalies (missing data, inconsistencies) before loading, ensuring data reliability in the new ERP.

Collaboration and business alignment: I worked closely with business teams to define specifications, ensuring the project perfectly met the company's needs.