علاء بركات

Keywords :
Project Management, PMP, ITIL v3, Professional Scrum Master, Release Management, Resources Management, GIS, ESRI, WPF, WCF, C# 3.0/4.0, Telerik, Oracle, Entity Framework, Service Windows, MultiThreading, XML, XSLT, Team fondation services, IIS7, MSbuild, QABook.

Context
-----------
The financial crisis of 2008 and 2009, the subprime crisis and the collapse of Lehman Brothers prompted banks to freeze inter banking credit, causing a liquidity crisis. Since liquidity has become an indicator closely watched by banks and regulators.

The Liquidity project is a major project within the Société Générale group which aims to provide reports on the liquidity of the bank to regulation bodies such as Prudential Control Authority (formerly Commission Bancaire) in France and the Financial Services Authority (FSA) in England. It also allows managing and effectively taking into account the liquidity risk to ensure effective internal control on liquidity management and implementation of the new Basel III requirements (LCR, NSFR).

The LIQOR application aims to retrieve data from many applications, to enrich, to perform calculations and then generate reporting. It is a full Microsoft .Net application that consists of a Windows service, a custom workflow management engine, custom calculation modules, a SSIS 2008 packages and an ASP.Net web application.

- Technical Team Leader
- Team Management: 8 software engineers in Paris and 3 in Bangalore (Offshore).
- Release Management
- Technical documentation, processes and standards development implementation
- UML modeling
- Data modeling, relational database design and optimization
- Design and Development
- Code review and optimization
- Software architecture definition and infrastructure design
- Production process monitoring, support level 2 and 3, unit test validation
- Project Management, CM-RM, Scrum Master

Keywords : Project Management, ITIL v3, Scrum, C# 3.0/4.0, ASP.Net, DevExpress 2010, Business Intelligence (SSIS, SSRS, SSAS 2008), SQL Server 2008, Service Windows, MultiThreading, XML, XSLT, Log4Net, AutoSys, Hudson, IIS7, MSbuild, ClearCase, GIT.

Context
-----------
I joined Betclic for 10 months to strengthen, with my Microsoft .Net expertise, the technical team to ensure the launch date of Betclic online betting sites in France and Italy.

- Design and Development (ASP.Net, C#, VB.Net, SQL)
- Data modeling, relational database design and optimization
- Code review and optimization
- Unit test writing, Technical and functional specifications
- Workflow definition, design and development
- Odds calculation algorithm definition and optimization
- JQuery Referent

Keywords : C# 3.0/4.0, ASP.Net, SQL Server 2008, JQuery, Ajax, XML, XSLT, Team Fondation Server 2010, SCRUM.

Development of a web sites provisioning and publishing tool
(team of 5 people during 13 months).

Context
-----------
As part of a project to develop the Orange Business Services shared web hosting offer, Internet Management and Accommodation (IHL) aims to develop an automatic provisioning web sites tool and web sites migration tools between web platforms (Microsoft Windows Server 2000  2008).

This tool, once finalized, must ensure:
- Interfacing with LAPID (Layer access to Active Directory).
- Active Directory provisioning management (user accounts, ftp accounts).
- Managing the creation of sites, virtual directories and application pools in IIS7.
- Managing the creation of folders in the file system.
- Managing NTFS permissions for the directory security (ACL).
- Managing the creation of databases SQL Server, MySQL and PostgreSQL.

- Writing of technical specifications
- Design and Development
- Relational database design and optimization
- Unit tests, Test plan and validation
- Packaging and Deployment
- Support Level 2 and 3, Bug fix
- End user training
- Servers and web sites migrations

Keywords : Web Services, IIS7, C# 2.0, SQL Server 2005, Active Directory, ACL, HTTPS, FTP, SOAP, Windows Server 2008.

Design, development and implementation of a tagging tool in the pharmaceutical industry. (team of 4 people during 6 months).

Context
-----------
The labeling tool developed ensures the management and monitoring of industrial printers, creating new labels validation workflow and validation processing of applications for label printing. It must be interfaced with different host applications (PRIZEM, LIMS, OEBS, XFP ...) and print according to their data without requiring user intervention.

This software is a four-tier application :
• A Windows service developed in C #, which communicates with the software CodeSoft to manage data import and printing of labels.
• Software design patterns for CodeSoft mask and drivers to support industrial printers.
• A three-third ASP.Net web application, which allows administrators to configure and manage the entities business flow.
• A data access layer to an Oracle database 10g.

- Writing of functional and technical specifications
- UML modeling
- Data modeling, relational database design
- Design and Development
- Unit test and validation
- Test and Deployment
- Writing of operational guidelines and user manual.

Keywords : C# 2.0, ASP.Net, Oracle 10g, NHibernate, Log4Net, Sérialisation XML, Web Services, Service Windows.

Context
-----------
IVECO Finance uses a Web application that imposes certain limitations when managing billing for their great account customers. To overcome these problems, the project was to study the needs to implement a billing tool for batch generation of grouped invoices based on the data managed by their application.

This tool is a winform client application developed in Visual Basic, it allows:
- The launch via SQL * Plus and automatically PL-SQL queries to an ORACLE 9i database to export data in CSV format.
- Import CSV files into a MS Access database.
- The presentation and manipulation of data to generate files in Excel format to be validated by the client.
- Editing grouped invoices for a specific customer and a specific period.

- Needs Analysis
- Writing of functional and technical specifications
- Design And Development
- Staging database design and query optimization
- Unit test and functional tests
- Deployment, Production monitoring and support

Keywords : C#, VB.NET, ORACLE 9i, SQL Developer, PL-SQL

Context
-----------
The e-DAI is a dynamic web application developed in Java/J2EE (JSP, Servlet), it is used to manage the workflow implementation between parents, allergist and school to facilitate the integration of children with allergies in collective structures.

In a team of 3 people and for a period of six months, the project was to study and specify requirements to redevelop the GUI of the application to ensure a separation between presentation layer and the business layer using the Tapestry Framework 4.

The second part was to design and develop an input form that provides the user with a personalized and evolving it to describe an emergency protocol complete and accurate and simple way in a short time.

- Bibliographic study.
- Needs Analysis and solution definition.
- The study of the existing.
- Data Modeling
- Design and Development
- Tests and validation
- New components Integration in the existing application.

Keywords: Eclipse, Tomcat, Java, J2EE, Html, JavaScript, JSP, Tapestry 4.0, PostgreSQL.

Context
-----------
In a team of 5 people and during 5 months, my mission was to design and develop automated tools to test SIM cards configuration and validate GSM-R (Railways) after maintenance operations.
The developed tool manages the GSM-R mobile and test equipment to simulate the train environment in order to perform automatically 240 test case, which qualify and validate the mobile. At the end of the test, the software writes a PV (minutes), which contains information about the mobile (and the SIM card), its configuration and the results of various tests.

A second part of the mission (during 6 months) is the design and development of a Three-tier web application in order to :
- Collecting test results
- Managing a MSSQL Server database
- Manage the mobiles control sheets
- Perform quality control of products and different statistics reports.
This application, developed in ASP.Net, manages control sheet validation workflow for each mobile received for maintenance operation or software updating

- Needs Analysis and functional specifications
- Detailed study of GSM-R and its configuration.
- Technical Specifications.
- UML modeling and technical diagrams
- Design and installation of the bench test.
- Design and development of the software.
- Test and validation

- Web application design and development.
- Development of an advanced search interface and formatting results (html, csv)
- Test the application and its communication with the test bench.
- Users training

Keywords: ASP.Net, C#, SQL Server 2000, Html, Javascript, Regex, Visual Basic 6.0, Commandes AT, Telnet, GSM-R, GPIB.