Santosh Jha

Project - Suncorp Bank

• Write and optimize SQL queries, stored procedures, and triggers for high-performance data processing and minimal database load.
• Design and implement ETL processes using tools like AWS Glue and DataStage to automate data extraction, transformation, and loading.
• Develop scripts to automate data loading processes, ensuring timely availability of data for analytics and reporting.
• Monitor database performance, troubleshoot issues like slow-running queries, and implement indexing, partitioning, and clustering strategies.
• Monitor database performance, troubleshoot issues like slow-running queries, and implement indexing, partitioning, and clustering strategies.
• Ensure robust backup, restoration, and disaster recovery procedures for database reliability and security.
• Perform complex data transformations to derive business metrics, KPIs, and create materialized views and summary tables for faster analytics.
• Optimize ETL jobs, partitioning, and indexing for improved data warehouse performance and scalability, using compression and columnar storage for large datasets.
• Collaborate with business intelligence teams to ensure data availability and structure for reporting and analytics.
• Collaborate with business intelligence teams to ensure data availability and structure for reporting and analytics.
• Automate recurring ETL processes to ensure real-time or near-real-time data availability.
• Manage and perform data migration strategies, ensuring data integrity and accuracy during transfers between different platforms, such as from RDS to Redshift.

• Worked as an IT Analyst in Tata Consultancy Services Mumbai, From March 2016 to June 2021 Projects: (In reverse chronological order)

Project#1: GSK (Jan 2020- Jun 2021)

• Involved in the full development cycle of Planning, analysis, design, development, testing, and implementation
• Created and modified SQL Plus, PL/SQL and SQL Loader scripts for data conversions
• Developed and modified triggers, packages, functions and stored procedures for data conversions and PL/SQL procedures to create database objects dynamically based on user inputs
• Developed, tested, debugged and documented Oracle PL/SQL packages and types in accordance with company policies, company standards and industry best practices
• Imported data from SQL Server DB, Azure SQL DB to Power BI to generate reports
• Developed analysis reports and visualization using DAX functions like table function, aggregation function and iteration functions.
• Executed dashboard setups and data manipulation using DAX
• Scheduled Automatic refresh and scheduling refresh in power BI service.

Project#2: EQUIFAX (Mar 2016- Dec 2019)

• UNIX Script Development and Production Support
• Analyze and ensure efficient transition of all technical design documents and develop various SQL packages to provide support to all application developers
• Monitor and recommend changes if required to all PL/ SQL packages and provide stored procedures and design and develop various relational database
• Providing Level 2 support for various incidents, which includes impact analysis, root cause analysis and fixes
• Analyze and ensure efficient transition of all technical design documents and develop various SQL packages to provide support to all application developers