Fabrice Bloncourt Email & Phone Number

Montreal, QC, CA

Boucherville, Quebec, Canada

• ERP (Enterprise Resource Planning) - Responsibilities
• Analyze, configure, develop, and implement Oracle R12 Applications in different modules
• Work with peer developers, analysts, and system administrators to diagnose and implement enhancements, projects tasks, apply patches and bug fixes
• Collaborate by providing support and development in the ERP migration project
• Support functional analysts and end users in completing integrated and acceptance tests as part of support and projects
• Write technical documentation (DS140) based on analysis documents (AN100) and execute test scenarios (TE30)

• Provide operational support for OSI PI servers, PI Interfaces, PI AF, PI Coresight, PI ProcessBook and PI DataLink.
• Create, modify and review PL-SQL queries for standardized production reports, as well as running ad-hoc reports.
• Development of complex T-SQL (functions, stored procedures, CTE)
• Monitor database system details, suggest performance tuning. (MS SQL Server)
• Development and implementation of self-serve applications providing access to production data.
• Produce as well as maintain documentation.Expertise gaine in the following: VB6, Access, Excel, T-SQL, PL/SQL, ASP.NET C# (MVC4), Razor CSHTML.

• Responsabilities:
• Act as reporting prime during project implementations.
• Ensure the continuous evolution of the Reporting System.
• Review code from a performance perspective and optimize.
• Share with junior team members on best practices in relational database and algorithmic programming and this through the whole spectrum (Speed, efficiency, security just to name a few).
• Deal with production issues ranging from the total paralysis of All Fido Reporting servers to more specific problems like data missing for an agent. Expertise gained in the following: Access, Excel, ASP, ASP.NET.

• Responsabilities:
• Analyze business needs and requirements.
• Translate business needs into technical and system design specifications.
• Write and maintain SQL code. (functions, stored procedures, objects)
• Create and maintain ETL jobs. (DTS,SSIS)
• Monitor production systems and proactively optimize database performance.

Creation of Report with the use of Excel.Manipulation of Data through Pivot Tables.Extraction of Data through DTS.Completion of Ad Hoc requests.

• Responsabilities:
• Work closely with the Project manager for the implementation and delivery of fido.ca
• Manage and optimize existing content pages (HTML and CSS).
• Recommend enhancements to optimize customer experience.
• Accountable for precise and timely website content update and implementation.
• Deliver and implement content changes for products, pricing, brand strategy, self-serve functionalities, etc.Expertise gained: