• Preparing LLD and HLD
• Task Allocation and tracking
• Requirement analysis
• Developing SSIS Packages.
• Developing reports using SSRS, OBIEE and Tableau.
• Test Case Preparation
• Unit Test & System Testing
• Database Design

Description: - The GENESIS Data warehouse is a common pool of Contracts, Positions and Customer Account balances, across all of Citi, for the use of Finance, Risk and Compliance and any other unit requiring such data

The scope of the GENESIS is to facilitate functional requirements for data acquisition (including reference data) from the Product Processors and complete the standard values Transformation and Enrichments of Key Dimensions and GL anchoring before loading the data into the Warehouse.

Responsibilities

• Communication with client.
• Preparing LLD and HLD
• Tasks Tracking and Task allocation.
• Development of ETL packages using Datastage.

Preparing Test Cases and Test Plan.

Description: - This is a data warehouse project where IISLogs from Knowledge Exchange Sites are loaded into data warehouse. After using this data, various reports developed for monitoring purpose. For example, who had uploaded data in the site, who had visited frequently to site etc.

Responsibilities

• Preparing Design document
• Development of Reports using SSRS
• Unit Test & System Testing

Description: This is web-based solution of Management Information System (MIS). Reserve bank of India has directed all public sector banks to build MIS.MIS consists of latest & accurate information on progress/achievements in the area of assets (loans & advances), liabilities (deposits) & housekeeping. Information bank need to collect is on weekly, fortnightly, monthly, quarterly, half-yearly & yearly in the areas of Risk Management, Foreign Exchange, Social Banking, and Retail Banking etc.

Responsibilities

• Communication with client.
• Preparing LLD.
• Development of Reports using SSRS
• Unit Test & System Testing.
• Support at client side and Involved in UAT.
• End User Training.