Lead Business Analyst, Technology

Lead Business Analyst, Technology

DUTIES:

• Liaise with the Business SMEs to elaborate on business requirements for regulatory reporting and credit risk management and Define Business Requirement Documents (BRDs) for functional and nonfunctional requirements.

• Define Functional Specification and Technical Design Documents to break down requirements in Technology requirements.

• Design Use Cases, Flow Charts, Data Flow Diagrams and Dash Boards to meet business requirements.

• Analyze and profile data using Oracle SQL Developer, MS SQL Server or AWS Redshift based on the source of data to develop strategies to suffice the data sourcing needs.

• Define logical database design, fact/dimension table structure, reporting process metadata, and ETL (Extract, Transform and Load) processes.

• Define system strategy, develop system requirements, design prototypes and support technology solution implementations to achieve seamless data integration between various financial applications (Peoplesoft, Financial Application Hub, One Stream, AXIOM) to use Oracle Financial Services Analytical Applications (OFSAA) as Financial Datawarehouse.

• Analyze Oracle Financial Services Analytical Applications (OFSAA) standard business rules and functionalities and perform fit-gap analysis to align to the functional and non-functional business requirements.

• Define data quality rules, data governance standards and Master Data Management (using Ab Initio) through data sourcing to processing to reporting.

• Analyze data elements needed for reporting and define data mapping and data lineage documents to map source system data (key data attributes and dimensions) to the Financial Services Data Foundation (FSDF) standard data model.

• Responsible for working with Oracle to raise Service Request for any custom data attribute change in data model.

• Assess current state lineage and business rules to identify necessary changes and customizations on standard OAS (Oracle Analytics Server) configurations to align better to the reporting requirements.

• Support with analysis of OFSAA General Ledger (GL) Reconciliation Framework and configure reconciliation business rules to perform reconciliation between enterprise operational and GL systems data.

• Support the analysis of standard OFSAA LLFP (Loan Loss Forecasting and Provisioning) application and configure business metadata, data transformation and business rules for data processing.

• Support the System Integration Test (SIT) and User acceptance test (UAT) to help access the requirement coverage of test cases to identify and log defects and propose corrective measures.

• Partner with team members to develop project schedules, project plans, effort estimation for projects under agile and waterfall methodologies.

• Collaborate with technology partners to help them understand business requirement and to help in automation processes on OFSAA and OAS platforms.

• Define user manuals for end user applications and train business users to effectively operate applications and functionalities.

REQUIREMENTS:

• Bachelor’s degree in Business Administration, Management Information Systems (MIS), Computer Information Systems or Computer Science

• Five (5) years of experience in any occupation with development, information technology experience, or related.

• Five (5) years of experience in any occupation with development, information technology experience, or related must include:

• Financial Services experience

• OFSAA (Oracle Financial Services Analytical Applications) with knowledge of OFSAA GL (General Ledger) Reconciliation Framework

• OFSAA LLFP (Loan Loss Forecasting and Provisioning) application

• FSDF (Financial Services Data Foundation)

• OAS (Oracle Analytics Server) Reporting

• Oracle SQL (Structured Query Language),

• AWS Redshift

• ETL (Extract, Transform and Load)

• Understanding of ODI (Oracle Data Integrator) capabilities

• OFSAA Data Quality Framework

• Master Data Management (MDM) – Ab Initio

• Change Management Process (Service Now)

• Control M schedule

• Basic understanding of applications like Peoplesoft, Financial Application Hub, One Stream, AXIOM for Data Integration purposes

• Excel formula-based analysis

• Working in SDLC (Software Development Lifecycle) process from Gathering Business Requirements, design, support Development & SIT, support User Testing and Release process

SAL ARY:

$147,000 per year