Devdatta Kumar Email & Phone Number

Pune, Mh, In

Pune, Maharashtra, India

Risk Authority is Moody’s Credit Risk application based on Basel I, II, and III. It encompasses credit, market, liquidity, concentration, and operational risks. As part of the EDWH Risk Team we provided source data to Risk Authority application in desired format. RBI EDWH is responsible to provide unified data across organization. It acts as single truth of data for GDWH, Data tribe and DI teams. Data sources from multiple countries are loaded.Moody’s Risk Authority (RAY) and Limit Management system.• Involved in Credit Risk to provide all source data to calculate Risk Weighted Assets(RWA).• Understanding business requirement and designing appropriate EDWH changes.• Handling changes in EDWH scheduler(UC4) in ODI and in Teradata for RDI team.• Responsible for testing implemented requirement by preparing and loading data as per RBI EDWH standard.• Making changes in Teradata stored procedures and Bteq script to load into data warehouse.• Used Teradata utilities TPT, fastload, tpump to load data.• Created ETL solution to read dependency between Objects and create data Lineage between different tables of RAY using Python.Team Lead:• Lead 9 resources responsible to provide end to end support of banking Data warehouse involving multiple tools.• Technically providing solution to issues in Data Warehouse all processes.• Allocating and supporting task as per agile process.• Responsible for day-to-day management of resources and deliverables.• Maintaining Knowledge bank for issues and resolution.• Proper guidelines to Team for fixing code changes wherever required.Current OrganizationProject Worked• Diagnosing and resolving data and system issues to ensure warehouse usability for the consumers.• Coordinating with various teams and raise ticket for all issues, analyze root cause and assist in efficient resolution of all production tickets.

Pune Area, India

• Gathering system design requirements, design and write system specifications.• Responsible for Detailed Design or Component Design document.• Responsible for writing Teradata stored procedures and Bteq script to load into data warehouse.• Used Teradata utilities TPT, fastload, tpump to load data.• Responsible to prepare Unit Test plan for the requirements.• Involved in preparation of UTC and Data Modeling documents.• Involved in SIT and UAT defect call.

Gurgaon, India

Analysis of BRD and checking the technical feasibility of requirement and then converting those into technical codes to fulfill those requiremnts with proper testing.

Chennai Area, India

Developing of stored procedures to load data into teradata as per business requirements.

Bachelor Of Technology (B.Tech.), Electronics And Communications Engineering

Bachelor Of Technology (B.Tech.), Electronics And Communication Engineering, 83%