
Ahmed Abbas
Senior Data Migration Engineer | ETL & PL/SQL
Salaire / Taux journalier
Lyon, France
Freelance, ouvert au CDI
Expertises
Langues
À propos
Introduction
Data Analyst & ETL Developer with 10+ years in banking, transport & IT services. Currently migrating multi-million record enterprise systems at SEIITRA using PL/SQL, PostgreSQL, and AWS/Azure cloud platforms. Specialized in data migration, Power BI reporting, and automated CI/CD pipelines to optimize data processing efficiency.
Expérience de travail
Data Analyst / Data Migration Engineer – PL/SQL & ETL Developer
SEIITRA
août 2017 - Présent
9 ans 3 mois
38330 Montbonnot-Saint-Martin, France
- Analyzed and optimized data migration processes for enterprise applications. - Developed complex migration procedures using PL/SQL and PostgreSQL. - Designed and implemented ETL pipelines with the Ambre ETL platform. - Performed data extraction, transformation, and loading (ETL) operations across multiple systems. - Conducted data quality analysis and managed data reject processing. - Oversaw Electronic Document Management (GED) migration projects. - Created interactive dashboards and reports in Power BI for business stakeholders. - Built automated CI/CD pipelines using GitLab CI to streamline delivery. - Collaborated with cross-functional teams in an Agile SCRUM environment. Key Achievements: - Migrated complex legacy systems to modern platforms. - Improved data processing efficiency by optimizing ETL procedures. - Automated manual processes, significantly reducing processing time. - Processed and migrated large-scale datasets (multi-million records) across enterprise systems. - Mentored and trained 5+ team members on advanced PL/SQL, PostgreSQL, and ETL practices as senior technical lead. Technical Environment: PostgreSQL, Oracle, MySQL, PL/SQL, Ambre ETL, Power BI, GitLab CI, Kubernetes, AWS, Azure, Git, Bitbucket, JIRA.
Java/JEE Software Engineer
SAB Banking Solutions
août 2016 - juil. 2017
1 an
Meylan, France
Project: Development of a banking web portal to digitize and automate Credit and Savings subscription processes, including a secure messaging system. Key Responsibilities: - Analyzed and specified business requirements in collaboration with functional teams. - Designed and implemented the Java MessagingManager API to ensure reliable communication. - Developed SOAP Web Services for system integration and interoperability. Built user interfaces with Liferay, enhancing the client digital experience. Technical Environment: JEE, Eclipse Mars, Maven, Tomcat 7, SVN, Spring 4.2, Liferay 6.2, Thymeleaf, UML, XML, WSDL, SOAP, JUnit 4.12, Oracle 11g, DB2, Agile (SCRUM).
Java/JEE Software Engineer
SNCF
févr. 2016 - juil. 2016
6 mois
Lyon, France
Project: Corrective and evolutionary maintenance (TMA) on an application managing SNCF staff data. Key Responsibilities: - Analyzed application issues and identified root causes. - Corrected anomalies and implemented bug fixes to restore system stability. - Developed enhancements and executed related functional and technical testing. Technical Environment: Java/JEE, Eclipse, Tomcat 7, SVN, Struts, JSP 2.1, UML, XML, JUnit 4.8, DAO, JDBC, Oracle 11g, V-Model methodology.
Java/JEE Software Engineer
STMicroelectronics France
avr. 2015 - déc. 2015
9 mois
38920 Crolles, France
Project: Development of a Processability Management Tool in Java EE. Key Responsibilities: - Analyzed and specified functional and technical requirements. - Designed and modeled an Oracle 10g database using UML. - Implemented MVC architecture with the JSF2 framework. - Developed Java–Excel import/export features using Apache POI. Technical Environment: Java EE, Eclipse Indigo (3.7), Maven 2.2, WebLogic, Jetty, SVN 1.7, Spring MVC 2, JAXB 2, UML, XML, XSD, XSLT, JUnit 4.0, Hibernate 3, MySQL, JSP 2.1, Agile (SCRUM).
Java/JEE Software Engineer
EdifiXio
juin 2014 - août 2014
3 mois
Grenoble, France
Project: Development of the TeamManager application for resource management. Key Responsibilities: - Developed the TeamManager application to support resource management processes. - Designed UML models and implemented an Oracle 10g database. - Built an MVC 2 architecture for structured application development. - Developed Java–Excel import/export features using Apache POI. - Contributed to the enhancement of the Fanvoice module for the Innovagora project. - Migrated the user interface from CSS to the Less framework. - Integrated Liferay themes to improve UI consistency. Technical Environment: JEE, Eclipse, Maven 3.5, JBoss, SVN 1.7, Struts 2, UML, XML, JUnit 4.8, Hibernate 3, Oracle 10g, JSP 2.1, Agile (SCRUM).
Java/JEE Software Engineer
BULL
avr. 2013 - oct. 2013
7 mois
Région de Grenoble, France
Project: Development of an industrialization tool for Java/JEE project integration. The solution automated delivery processes by replacing manual tasks (script execution, component building, delivery notes, delivery reports) with structured workflows. It included process modeling via a user interface, collaborative execution, and full process automation. Key Responsibilities: - Analyzed and documented delivery processes to identify automation opportunities. - Modeled and automated process activities through the application. - Integrated a project management tool for better workflow coordination. - Implemented an MVC 2 architecture to support scalable development. Technical Environment: JEE, Eclipse Indigo (3.7), Maven 2.2, Apache Tomcat 7, Spring MVC 2, Hibernate 3, JAXB 2, UML, XML, XSD, SVN 1.7, JUnit 4.0, JSP 2.1, Agile (SCRUM).
Java/JEE Software Engineer
IzyServices
mai 2012 - oct. 2012
6 mois
Annecy, France
Project: Development of an e-business portal integrating REST services and cloud solutions. Key Responsibilities: - Participated in the development of the e-business portal with RESTful services. - Contributed to cloud integration features to enhance scalability and accessibility. - Collaborated with the team to ensure functional and technical consistency. - Technical Environment: Java/JEE, REST, Cloud Integration (tools unspecified).
Formation
Université Grenoble Alpes
Master of Science - MS
2011 - 2012
2 ans
Polytech Nantes
Master of Science - MS
2010 - 2011
2 ans
University of Boumerdes
Engineer's degree