Application Production Support Analyst ALMT CCAR & Risk
Standard / Permanent
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).
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.
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.
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
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
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