The bank for a changing world

Application Production Support Analyst ALMT CCAR & Risk

Contract

Standard / Permanent

Location

CA-QC-Montréal

Job function

INFORMATION TECHNOLOGY

Reference

ACR0211

About IHC creation

As part of the Enhanced Prudential Standards (EPS), the Federal Reserve requires banking organizations to establish an Intermediate Holding Company (IHC), to regulate them similarly to comparably-sized domestic Bank Holding Company (BHC).

 

Consequently, BNP Paribas has to provide the necessary legal, management and regulatory reporting on a USGAAP basis for the Intermediate Holding Company (IHC).

 

Business Overview:

The IT Transversal Team is part of the Information Technology Group which works simultaneously on a wide range of projects arising from business, strategic initiatives, regulatory changes and reengineering of existing applications to improve functionality and efficiency. 

 

The Intermediate Holding Company (“IHC”) program structured at the U.S. level across poles of activities of BNP Paribas provides guidance, supports the analysis, impact assessment and drives adjustments of the U.S. platform’s operating model due to the drastic changes introduced by the Enhanced Prudential Standards (“EPS”) for Foreign Banking Organizations (“FBOs”) finalized by the Federal Reserve in February 2014, implementing Section 165 of U.S. Dodd-Frank Act.

 

Position Summary:

The IHC Application Production Support Specialist (ALMT, CCAR & Risk) will report into the IHC APS Manager. The Specialist will perform application production support activities onshore for ALMT, CCAR & Risk applications (comprising of Triton, SAS and QlikView), and coordinate with offshore counterparts for successful identification and resolution of Production issues. Additionally the Specialist will interact with work stream leads, infrastructure & business stakeholders for issue resolution.

 

Position Accountabilities:

  • Conduct deeper analysis of issues requiring techno-functional knowledge for ALMT, CCAR & Risk applications (comprising of Triton, SAS and QlikView)

  • Perform issue investigation and resolution, planning, and release management for ALMT, CCAR & Risk applications

  • Investigate application behavior with queries directly from the business

  • Provide primary functional issues resolution (requiring end user interaction) during regular US business hours

  • Perform emergency deployments or provide hands-on application specific technical support for issues that are escalated from ISPL

  • Liaise with IT work streams, Infrastructure and ISPL APS teams to resolve Production issues for ALMT, CCAR & Risk applications

  • Work with development teams and escalate technical issues requiring L3 support

  • Collate and prepare inputs for operational meetings related to Production for ALMT, CCAR & Risk work stream (e.g. weekly/bi-weekly production update meetings, change control meetings, production KPI/ metrics)

  • Incident management – business and technology communication, coordination and resolution of incidents, from external issues such as exchange problems to internal application bugs impacting the production environment

  • Problem management – Post incident review ensuring that the issue has been permanently resolved and what value add items can be completed to ensure the issue does not reoccur

  • Release management – being the gatekeepers for the production environment, ensuring all change is understood and scheduled appropriately

  • Monitoring and continual service improvement of supported applications

  • Perform activities related to compliance/audit reporting



Required Experience:

  • 7-9 years’ experience in engineering, engineering support, or technical support environment

  • Strong technical background with Production Support experience in Oracle SQL, PL/SQL, ORACLE 12 and below, UNIX, Shell scripting

  • Hands on usage of at least one or more RDBMS e.g. Oracle, DB2, Sybase, Teradata or SQL Server

  • Windows and UNIX (and GUI) application support, use of SQL for data gathering and reporting

  • Experience and knowledge of ITSM processes, methodologies and tools

  • Prior customer-facing (internal or external) experience a must

Administrative/Technical Skills:

  • Operating Systems: UNIX, Windows, SOLARIS, Linux

  • Languages: Oracle SQL and PL/SQL, Shell Scripting, Perl

  • Database: Oracle 12 and below

  • Web Technologies: JAVA HTML XML XSLT

  • Tools and Utilities: TOAD, PUTTY, AUTOSYS, SQL LOADER

  • Knowledge of the SAS Platforms (SAS Modelling Workbench and SAS CPnM) and SAS analytical procedures including the Office Analytics, Visual Analytics, SAS Management Console

  • Qlikview expertise & hands-on development, deployment and support including end user dashboards, analyses & server side components

  • Problem solving and root cause identification skills

  • Experience supporting large and complex production systems using complex SQL queries and reporting systems

  • Excellent oral and written communication skills

Required Education or Equivalent Experience:

  • Bachelor’s degree or higher or equivalent combination of education and experience

  • Experience in a financial institution IT Environment and good knowledge of financial industry and related products are required. Understanding the recent financial regulatory initiatives such as Basel II, Basel III, Dodd-Frank Act and CCAR is a plus