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.

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