Raghava

E

EDENP

Feb 2023 - Current (3 years 4 months)

EDENP is a data warehouse project from API to cloudera. As a part of migration, 210 tables are migrated to cloudera.Along with the migration, integrating the third party data in oracle with cloudera.Once data is available in cloudera hive, downstream consume the data using Tableau. The injesion activities are performed by python.

I

IWH(Investment WareHouse)

Oct 2022 - Feb 2023 (5 months)

IWH is a data migration project for database migration using Snowflake. Proposed project is to migrate the on premise database Oracle, SQL-Server to Snowflake and improve the throughput of the data processing. As a part of data migration 120 tables are migrated to AWS cloud. Once data is available in Snowflake, downstream visualize it using Tableau as a reporting tool.

R

RPA (Representative Performance Analysis)

Aug 2021 - Feb 2022 (7 months)

RPA is an ODS for AKU, FF, Property, Casualty and Legacy Casualty Insurance data of various places across Japan. Data is generated from various source systems as files in CSV, Pipe delimited format. Data is placed in AWS S3 bucket and it is consumed using snowflake and populated into ODS. Once ODS is loaded, downstream systems consume the data and publish using power BI.

I

IPP(Investment Provisioning)

Oct 2019 - Jun 2021 (1 year 9 months)

IPP is a data migration project for database migration using Snowflake. Proposed project is to migrate the objects from Postgres to Snowflake and improve the throughput of the data processing. As a part of data migration 110 tables are migrated to AWS cloud. Once data is available in Snowflake, downstream visualize it using Tableau as a reporting tool.

W

WCP (Wholesale Credit Provisioning)

Aug 2015 - Oct 2019 (4 years 3 months)

WCP is the reconciliation of the W(Wholesale) application. W is the centralized and non automated storage for the various kinds of loans from different SORs (System Of Records). There are 150 SORs in the W. Few of them are Genesis, LIQ, ELMS, RMS and DAL. Each SOR originates different kinds of loans and is populated into the W. W is acting as dedicated storage but it is not a centralized warehouse for data analysis. So the Bank decided to build the WCP as a warehouse for all the loans. So all SORs in the W are replicated in the WCP.W storage is in the Teradata DB and WCP is being built in the ORACLE DB. There are 2 layers in the WCP. They are WCP-Staging and ADR.WCP-Staging is the 45 days of retention for WCP. Data is analyzed in the ADR la

S

SBS (Small Business Scaling)

Sep 2013 - Jul 2015 (1 year 11 months)

SBS is a data warehouse in Bank. This project involves different modules SMC (Sales force Model Construction), Combine and Separate, HR_Feed and Telebusiness. Functionality in each module in this project is used to ETL the data from various upstream sources Salesforce, Oracle and SQL Server. Each module has its own business logic when data is pushed into SBS.SMC modules is a basic model used to pull the data directly from salesforce standard objects Account, User, Activities and Tasks and store all active cases in SBS. Combine and Separate module is used to load the standard objects in SBS and involves the Combine and Separate logic to combine and separate the outbound users into Bank Warehouse. The HR_Feed module is used to update the mana

C

Chartis-FDW (Chartis Financial Data Warehouse)

Nov 2012 - Aug 2013 (10 months)

Implementing the financial data warehouse for Chartis, Japan that helps to analyze the information for strategic business decisions. Chartis-FDW is a storehouse for AIU, MF, FFM, Property, Casualty and Legacy Casualty Insurance data of various places across the Japan. There is a web link dedicated for each user to kick off their ETL process. One or more Users initiates the ETL process by clicking the allocated web link and passing required parameters that will be used by the Informatica .Informatica will use the parameters during the runtime and load the data into FDW parallel. Along with the ETL process, Load balancing, process log, and error mechanism are implemented to track the ETL process. There are 279 simple and complex flows running

I

IDODS (Invest Division Operational Data Store)

Feb 2011 - Sep 2012 (1 year 8 months)

Building a new operational data store (Hub) for operational reporting needs of the Investment division. The ODS is a Centralized hub for Market Security, Position, Trade and various business data of Investment division spanning across the various lines of Businesses via Transition Management, Fund Derivatives, Overlay Services, Portfolio Services, Foreign Exchange systems, Short Term Investments and etc., There are 240 ETL Informatica mappings are designed to fetch data from both Flat files and database views across different investment divisions with real time refresh by EOD or Intraday basis. There are simple and complex business logics implemented with SCD, Staging History, Rerun logic, Feed Control Table, Audit table, Error Handling and

S

SAPA (Sales Agent Performance Analysis)

Feb 2009 - Nov 2010 (1 year 10 months)

Building a new operational data store (Hub) for operational reporting needs of the Investment division. The ODS is a Centralized hub for Market Security, Position, Trade and various business data of Investment division spanning across the various lines of Businesses via Transition Management, Fund Derivatives, Overlay Services, Portfolio Services, Foreign Exchange systems, Short Term Investments and etc., There are 240 ETL Informatica mappings are designed to fetch data from both Flat files and database views across different investment divisions with real time refresh by EOD or Intraday basis. There are simple and complex business logics implemented with SCD, Staging History, Rerun logic, Feed Control Table, Audit table, Error Handling and

T

Terra-FDW (Terra Financial Data Warehouse)

Jan 2008 - Feb 2009 (1 year 2 months)

Implementing the financial data warehouse for Terra, Japan that helps to analyze the information for strategic business decisions. Terra-FDW is a storehouse for AIU, MF, FFM, Property, Casualty and Legacy Casualty Insurance data of various places across the Japan. There is a web link dedicated for each user to kick off their ETL process. One or more Users initiates the ETL process by clicking the allocated web link and passing required parameters that will be used by the Informatica .Informatica will use the parameters during the runtime and load the data into FDW parallel. Along with the ETL process, Load balancing, process log, and error mechanism are implemented to track the ETL process. There are 279 simple and complex flows running con

About

Detail

Timeline

Résumé