Piyush K.

Piyush K.

IT Profession based in Hyderabad

Hyderabad , India

Experience: 4 Years

Piyush

Hyderabad , India

IT Profession based in Hyderabad

12336 USD / Year

  • Immediate: Available

4 Years

Now you can Instantly Chat with Piyush!

About Me

Proven excellence in Database Modeling, Database Architecture, Database Warehousing & Analytics & Visualization Applications  Proficient in providing Technical Design and Architectural Leadership to multiple teams & projects to help ensure appl...

Show More

Portfolio Projects

FDIc 370 Provisioning

Company

FDIc 370 Provisioning

Role

Software Architect

Description

Project Scope: Regulatory requirement of reporting deposit account (TD, DDA) entities to Federal Deposit Insurance Corporation for Insurance coverage determination. Tools Involved: SAP Power Designer, Oracle SQL, Notepad ++, Informatica PowerCenter Role:  Conducted Preliminary delta analysis of deposit account entities in existing treasury system (Treasury Authorized Data Store)  Scrutinized & converted COBOL (mainframe) files into Exadata tables, defining corresponding data types, load pattern and load pattern and frequency   Created conceptual, logical and physical data models for staging, core and provisioning data layers  Analyzed FDIC requirements & updating KBE’s, and underlying physical data attributes in Treasury database  Conceptualized DDL, DML and mapped specifications for E2E database development  Designed mappings, sessions and work-flows for data load into FDIC tables for defect defection at early phase of development  Implemented Agile methodology in delivering information solutions to client, adhered to the FDIC compliance 

Show More Show Less

German24C Provisioning System

Company

German24C Provisioning System

Role

Software Architect

Description

Project Scope:  To report new accounts, account closures and all changes to any of the reportable data attributes to Bank of Verlag, Germany on the day after the change took place; fulfillment of regulatory and operational requirements Impact: Reduction in modelling and development effort by 20% (around 45 attributes) by leveraging client data from Master and Reference data hub. Tools Involved: SAP Power Designer, Oracle SQL, Informatica Role:  Analyzed Source System (SOR) by frequent business interactions and implemented OGG (Oracle Golden Gate) replication for data movement from Cesium(Client Onboarding Platform) to TrADS  Created & maintained German24C provisioning mapping documents with the focus on tracking the account or stakeholder data amendment  Validated and updated  conceptual and physical data models for: o Strategy definition for rewriting file data into table post extract generation o Delivering the DDL, DML and mapping specification artefacts for E2E Database development o Assisted in the gap analysis of the business requirement and ensured the incorporation of the key business attributes in the model 

Show More Show Less