• 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.

West Coast University is providing education in healthcare domains. The project is dealing with a better Student Experience using MSBI. The Daily Activities involve creating Reports using SSRS, OBIEE and Power BI. Also ETL is taken care of using SSIS as and when needed.

This is a data warehouse project where IISLogs from different servers are loaded into data warehouse. After using this data various reports are developed for monitoring purpose. For example Top 20 slowest responding WebPages. Fastest executing WebPages etc.

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, Retail Banking etc.

CRisMac Legal System Distributed Windows based Project which gives information regarding to Legal matters of customer, which are under NPA category. The main use of this system is to know Bank status of any legal matters, which they are suited against customer, as well as any customer has filed case in the court against bank.

Root to Fruit is the in-house development for monitoring the performance of the each employee in the organization from bottom level to Top level.

Important modules of these systems are:CRisMAC System: This is window based application software developed for establishing a Comprehensive Database of Loans and Advances for Banking Industry.Basel II: Asset Classification & Provisioning, the banking sector is poised now to implement Basel II norms on capital Adequacy by assessing charge of various risks on capital. Asset Classification and ProvisioningCibil: Submission of CIBIL Data and on Management Information System in several Public Sectors and Private Banks