Shivam Joshi Email & Phone Number

Noida, Uttar Pradesh, India

• Developed Cash flow/Amortization For STPL accounts for RBL Bank which provided valuable insights into future cash flow from customer loan EMIs, improving the bank’s financial forecasting capabilities. • Designed and developed an SQL-based report to generate insights into STPL Securitization data for RBL Bank. • STPLSecuritization report provides valuable data for analyzing consumer behavior and managing STPL and credit card accounts within the securitization framework.

Noida, Uttar Pradesh, India

• Faclitated ETL processes and best practices that led to a 30% increase in process efficiency for data warehousing tasks. • Designed real-time data pipeline for transferring and transforming data with Azure Synapse Analytics pipelines. • Workedwith Snowflake stream for Change Data Capture Functionality. • Developed a Process to migrate flat files from AWS S3 and Azure Blob to snowflake. • Leveraged Power BI to automate RBL and BFL portfolio reporting, achieving an 80% reduction in manual effort • Developed Complex SQL queries for extracting data and uploading data used for RBI audit. • Implemented Masking standards with Role-based access control on Snowflake, limiting PII data access.

Banglore

• Designed and executed ETL jobs for complex data transformations, supporting key decision-making processes. • Developed SQL queries for data analysis purposes, enhancing reporting capabilities for stakeholders. • Analyzed Sales Data and developed Dashboards using Power BI to give useful insights to the Business Development team which increased sales by up to 40%

Chandigarh, India

Dehradun, Uttarakhand, India

Delhi, India

Dit University

Dehradun, Uttarakhand, India

we worked on making bio oil from agriculture waste.

Vasantkunj Phase 2 New Delhi

Master'S Program, Data Science And Buisness Analytics

Bachelor Of Technology - Btech, Petroleum Engineering, 7.36