Alain – Python, GCP, SQL

Migration of an existing platform and the restructuring of legal documents for linguistics automation. Challenges involved adapting document formats to enhance automation efficiency, reducing manual tasks, and improving overall workflow within the legal domain.

• Created and designed the pipeline architecture on the GCP cloud;
• Set up physical and logical Data Model;
• Captured, ingested, structured, and indexed the data;
• Mapped the available elements;
• Contributed to IAM authentication management, monitoring, and CI/CD.

The project involved automating the Controller Manager's tasks using a Data Warehouse (DWH), enabling the team to store and archive financial data. It streamlined data processing and provided advanced data visualizations for stakeholders, enhancing decision-making. Key features included data automation, data quality management, data modeling, historical archiving, and integration with visualization tools.

• Spearheaded the development of a Data Warehouse(SQL Server/SSIS) for bank's Finance Department, facilitating advanced data analysis and strategic financial decision-making;
• Unified and standardized company metrics across various departments into a single Data Warehouse;
• Enabled consistent reporting and insightful cross-departmental analysis;
• Established and maintained a Data Warehouse(SQL Server/SSIS) specifically for notification data, optimizing data storage and retrieval.

Datalab for the army's management to visualize all personnel, both civilian and non-civilian, and provide recommendations for optimal career paths. The project involved a complete data pipeline for extraction, transformation, and storage, utilizing Talend Big Data for ingestion and Python for data processing, particularly for API integration.

• Designed and implemented a comprehensive end-to-end data pipeline, encompassing data extraction, transformation, and storage, ensuring efficient and accurate data handling;
• Engineered a robust data ingestion framework using Talend Big Data, optimizing data integration and streamlining the data management process;
• Developed an automated solution leveraging Python.

End-to-end pipeline for the Marine Corps to streamline personnel assignments based on factors like availability, seniority, and job priority. The solution involved a Python Qt application, integration of data from multiple sources, and creation of Python-based algorithms for assignment process optimization.

• Created an application using Python Qt;
• Developed an end-to-end pipeline to ingest data from various sources;
• Wrote matching algorithms in Python to align individuals with the best-suited destinations.