Sr. software Engineer/10 Yrs Exp in France/Microsoft.NET and MSSQL Server BI
-
Total years of experience :9 years, 9 Months
Console application in C# .NET to transform bank files (swift, bank statements...). Files structures and mapping rules are defined in xml files.
Technology: VS 2012, C# .NET, Framework 3.5, Xml
Web application NEGOCE:
Web application for managing business contract between sellers and clients.
Importation of files (XML and CSV) in web application.
Business reporting with MS Reporting Services, encapsulated inside web application.
Generate final client contract with offers, rates and discounts in MS Word format for client signatory.
VBA macro for saving MS Word document modification in web application with web services, manage multi users access to the document.
Store connected user policy rights (accessibility of modules and data) and validation workflow (change of status…) in XML files.
Send emails with attachments in PDF with HTTP link for accessing application without login.
Console application for batch treatments (email notification, workflow…).
Web application E-Pilot:
Web application of business reporting for enterprise sales with analysis services SSAS and reporting services SSRS (graphs, drilling, filters, tablix…). Manage end-user rights for data and modules visibility.
Conception of data warehouse with MSSQL Server (RDBS and OLAP cube).
Integration of large files with Integration Services SSIS
Console application for scheduled job (emailing, files integration and export, weekly and monthly business reporting).
Windows Graphical Application (win-form) for back office.
Global tasks:
Participation to redact specifications, technical and functional support.
Conception of databases diagrams and SQL script for creating objects. Technical documentation and user guide.
Installation, configuration and maintenance of MSSQL Server.
Conception, deployment, configuration and maintenance of DOTNET web application with IIS Server.
Installation, configuration, administration and maintenance of servers.
Management of team of 2-3 developers, offer technical solutions.
Technologies: VS 2005/2008, VSS, SVN, C#, ADO.NET, ASP.NET 2.0/3.5, web services, GUI Win Form, MS SQL Server 2005/2008, SQL, T-SQL, MDX queries, OS Windows Server 2003/2008, IIS, Reporting Services, Integration Services.
DOS, JavaScript, HTML, CSS, XML, XSLT. MS Office and VBA.
Scripting for bank statements and payment orders, monitoring bank exchange activity.
Participate to terms of reference with customers, call center, support. Custom applications, development on demand. Technical documentation and user guide.
Working with various customers described here.
Web application Online Banking
Windows GUI in C# .NET for defining split rules of banks statements.
DOS application to import and transform bank statements.
Customization of a web application of payment ordering, generation of specific banking files.
Technologies: VS 2003, GUI winform, C#, ASP.NET 1.1, Oracle 10G, Windows 2003, vbscript, html, javascript.
FIP: factory international payment.
Web Application for electronic payment, managing suppliers, users, payment orders, generation of banks files (Paymul and Swift format) for BNP, grouping orders, PDF reporting with Crystal Report Solution.
Technologies: C#, ASP.NET 1.1, javascript, html, xml, xslt, Oracle 10G, PL/SQL, Windows 2003, Crystal Report, Visual Studio 2003.
Web application for monitoring business activity (BAM) with banks.
Tracking payment orders to/from banks.
Integration of various banking formats, especially French formats (AFB).
Console DOS application to integrate bank files into customer data warehouse.
Technologies: C#, ASP.NET 1.1, javascript, html, VS 2003, MS SQL Server 2000, SQL and T-SQL, Windows 2003.
Windows GUI for transforming accounting files to bank files. Interfaces for defining structures and mapping rules saved in database, start file conversion jobs.
Technologies: Visual Basic 6.0, MS SQL Server 2000, Windows Server 2000.