I need roles and responsibilities for the below mentioned duties and responsibilities.In the attached document you can find the file i need in that format• Develop, test and implement new software p
Business Intelligence & Data Analyst under SOC code 15-1199
Job duties-TEMPLATE (For information only)
Develop various extracts using IBM infosphere DataStage required for Executive dashboards which contain the reports about the liquidity risk, stock quotes, correspondence balance and loan value. This dashboard is being accessed by CEO, CIO of xxxxx through hand-held device to check the summary of these key matrices. Extracts are scheduled for every 2 hours in Cisco Tidal to provide the real time data to the executives to make timely decisions – 5%
Create ETL logic to calculate the delinquency, consecutive payment history from past 36 months on a daily basis and loaded into Oracle partitioned table. These values are calculated from multiple attributes of the loans which is obtained by joining different tables which contains data regarding related accounts and delinquency in the data ware house -5%
Automate Commercial trail balance report in IBM Cognos. Previously report was being created manually using access DB by the business user. Design re-usable DataStage utilities to extract data from Automated Financial System (AFS), load Data warehouse and DataMart after applying complex business rules. – 5%
Create Key performance indicator reports for Escrows, Delinquent loans, Loans boarded, Loan acquired from other banks like Desert community bank or Wells Fargo, Estimation of future acquisitions. Develop ETL logic to load the summary and detail tables with different measurable values like number of loans, average loans per month, average loan year and trend comparing the current vs previous year/month. -10%
Perform extensive testing of data loaded before automating the queries in the Cognos and made them available to the business users. Ran various complex queries on the data being used in the report and compared it with source data and existing manual report data to see if the total amount and loan numbers are matching in report tables – 10%
Create master customer database, which provide a 360-degree view of the customer using IBM master data management toolset. Perform analysis of data related to the subject area of parties associated with a loan and collateral by writing the complex queries on huge volume of data. Develop data models to incorporate party information coming from diverse source systems like loan processing system, mortgage originating system, retail banking system and load data using ETL DataStage. – 10%
Develop Oracle passport views, partitioned tables, functions and procedures in Oracle SQL/PLSQL as per the request from the Corporate MIS team and Subservicing team. Performance tuned the ETL process and queries using advanced scripting techniques like hints which will override the system execution plan. Developed logic in oracle scripts instead of physical storage of the duplicate data in database to fulfill the user requests to make data available from the partitioned table everyday not only on business days. This helped to optimize the database storage. -5%
Develop ETL jobs to extract real time Stock data from Webservices and developed jobs to analyze complex data structures like JSON and XMLs by utilizing advanced features in Oracle and IBM DataStage. Implement data quality checks before loading data to target table using information analyzer and DataStage Quality stage – 10%
Automate the extract, transform and load process to support various data feed engines in the organization like BAMO and wide variety of reports like Quantitative Risk Management, Capital Market Reports, Secondary Market Reports, Mortgage Life Cycle reports, Mortgage Recapture reports using Unix shell scripts in Cisco Tidal. – 10%
Develop extracts and various management level cubes using IBM infosphere tool set for reports like Quantitative Risk Management, Capital Market reports, Secondary Market reports, Subservicing Invoice Generation process, Mortgage Life Cycle reports, Mortgage Recapture reports - 10%
Maintain IBM Infosphere products like product upgrades, backup, restore and debugging server performance issues by working with the IBM vendors to resolve the same - 5%
Be responsible for developing proof of concept for address standardization process using iLytics and creating extracts for millions of supporting transactions involved in the retail banking which is used by Actimize, this helps the xxxxxx in fraud detection and money laundering. – 5%
Work closely with business users and data governance team on requirements gathering and implementing requirements – 5%
Creating various artifacts like Technical Design document, Functional Specification documents (FSD), Production Implementation document for CAB (Change approval board), Unit Test case documents based on the business rules and Job run book which contains the dependency of different entities in the data warehouse to help future maintenance. -5%
