Sr. Consultant Microsoft .Net & Mssql Server Bi
Paris Area, France
Web app. 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 app. for batch treatments (email notification, workflow…).Web app. 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 SSISConsole application for scheduled job (emailing, files integration and export, weekly and monthly business reporting).Windows GUI (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 ASP.NET web app. 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.