-
Société Générale
- Informatica consultant
PARIS
2014 - 2016
BASYLIQ project: the aim is to deliver liquidity ratios including BASEL 3: LCR, NSFR and others
Design and development of the new features of BASYLIQ system including:
- Informatica mappings and workflows development
- ksh Shell programming
- Development of stored procedures, SQL queries
- Tuning of SQL queries, PL/SQL objects, and Informatica mappings
- Execution automation : control-m Jobs creation
- Production support, analyzing and resolving execution issues
- Using partitioning in most of the data-warehouse tables in order to improve the queries performance.
Technical environment: PowerCenter 9.6.1, Oracle 11g, Ksh shell programming, control-m, ClearCase (versioning software), HP Agile, Business Objects
-
ERDF
- Informatica expert consultant
2014 - 2014
Proof of concept for data migration : from Informatica 9.1, Unix Solaris, Oracle 10g to Informatica 9.5, Linux Red hat, Oracle 11g, evolutive and corrective maintenance of the PDM application.
- Informatica administration : Informatica software installation, domains and services configuration, creation of users, grant priviligies to users.
- Informatica version upgrade from 9.1 to 9.5 : repository containing all the mappings/workflows of the application.
- Installation of PDM application on the Red hat Linux server.
- Database configuration, users management, priviligies, tnsnames, listener.
- Ksh scripts adaptation to the Linux Red hat server.
- Acceptance test plan, performance test plan, data migration guidelines.
- evolutive and corrective maintenance of the PDM application
-
Tarkett
- Informatica consultant
Puteaux
2013 - 2014
- Development of Informatica mappings, workflows taking into account performance aspects to load the data warehouse, data-marts
- Design of the mappings and job chain stages
- Creating the database tables, indexes…
- Creating SQL server stored procedures
- Managing partitioning in SQL server tables
- Unit testing and delivery management
Technical environment: PowerCenter 9.1.0 (Informatica), SQL server 2008 R2, T-SQL, stored procedures, partitioning, SAP.
-
Bouygues Telecom
- Informatica consultant
Meudon
2012 - 2013
- Develop High Level, detail-level ETL design including data capture, integration, data staging, transformation and aggregation.
- Development of the new functionalities: database design, Shell scripting programming to process data and run Informatica Mappings
- Conducting analyses of ETL processes and suggest improvements, database tuning, SQL, PL/SQL performance improvement.
- Creation of technical documentation such as high level design, design Proposals, low Level detailed Design and Implementation specifications for ETL processes.
- Installation and configuration of informatica software server and client tools, creation of the repository database, creation of the repository and integration services.
- Release management using IBM Rational Synergy
- Training of new consultants.
Technical environment: PowerCenter 9.1.0 (Informatica), Oracle 10g, Unix, Shell, SQL, PL/SQL, MDM IBM infosphere, SIEBEL CRM, Oracle OBIEE, Teradata, IBM Rational Synergy
-
BNP Paribas Cardif
- Informatica consultant
Nanterre
2011 - 2011
• System evolution, adaptive, perfective, and corrective maintenance using Informatica
• PL/SQL development
• Optimization of Informatica workflows and processes
• SQL and PL/SQL performance tuning
• Analyze and process of the production incidents
Technical environment: PowerCenter 8.6.0 (Informatica), Oracle 11g PL/SQL, Unix Shell
-
SODEXO Solutions de motivation france Nanterre
- PL/SQL specialist
Nanterre
2010 - 2011
• Data Model evolution
• Evolution and corrective maintenance of the web services (PL/SQL) managing the back office’s checks and cards command requests.
• Creation and evolution of the PL/SQL packages including stored procedures, functions, triggers, collections, dynamic SQL and PL/SQL, exceptions handling…
• SQL and PL/SQL requests optimization
• Management of the clients refund: checks reception, checking and validation of the payment transactions, XML refund files generation (PL/SQL programming).
• Technical advice to the team members about the developments and queries optimization.
• Optical service project : aiming to letting elders who don’t benefit of the CMU (health insurance complementary) to have access to a high quality French made glasses along with the best individual optical service:
- Database data model design.
- Web services development (PL/SQL)
- Application test.
- Data loading based on excel files supplied (PL/SQL procedures and functions)
- Technical accepting testing
- Resolution of technical and business issues, communicate with the final clients and perform solutions.
Technical environment: Oracle 10g, PL/SQL, Shell linux, XML, web services
-
Macifilia
- Informatica developer
2008 - 2010
- Analyze of the data bases (Oracle, AS400, Access) containing insurance products data.
- Database design.
- Conception and development of data loading using Informatica Powercenter, quality assessment, test and following their deployment in the several environments: acceptance tests, full deployment.
- Account for work load estimation, and issues encountered.
- PL/SQL implementation of data extraction: complex queries, procedures, functions, performance enhancement.
- Adaptative and corrective maintenance.
Technical environment: PowerCenter 8.6 (Informatica), Oracle 10g, PL/SQL
-
Trace One
- .net MS reporting services Developer
2008 - 2008
Implementating the Business Intelligence part of the trace one collaborative application.
- Self-training of the MS reporting services tool.
- Analyze of the existing database data modal.
- Design and implementation of the reporting database based on the global existing one.
- Implementation of T-SQL stored procedures for the selection of the data used in the reports: performance improvement, dynamic management of filters depending on the user choices.
- Reports implementation using SQL reporting services, filtering parameters management using C#, Reports graphic interface’s implementation using ASP.net, handling the authentification and security access.
Technical environment: SQL Server 2005, PL-SQL, Visual Studio 2005, MS Reporting Services, ASP .net, C#
