Kunal Shukla
Mumbai
Summary
2.7 years of experience as Associate Consultant at KPMG with expertise in Oracle database administration and Python automation. Proven track record in optimizing SQL performance and enhancing system efficiency through innovative shell scripting. Adept at collaborating with clients to deliver robust solutions, ensuring seamless data management and operational excellence.
Overview
3
3
years of professional experience
Work History
Associate Consultant - TE(Oracle)
KPMG
Mumbai
05.2023 - Current
- Python automation to simplify repetitive system administration and data validation tasks.
- Implemented exception handling, reusable functions, and parameterized scripts for maintainable code.
- Integrated Python scripts with shell scripts for cross-platform automation workflows.
- Experience with Oracle 12c/19c databases, including query performance monitoring, session and user management, tablespace and datafile administration, data export/import using Data Pump (expdp/impdp), and both RMAN and manual backup/recovery
- Designed and maintained PL/SQL packages, procedures, and functions to automate business logic in Oracle 19c.
- Performed debugging, exception handling, and performance optimization using DBMS_OUTPUT and EXPLAIN PLAN.
- Wrote and optimized complex SQL queries for data extraction, reporting, and performance tuning
- Developed advanced Bash shell scripts for automation of daily administrative and monitoring tasks.
- Monitored system health, CPU, and disk utilization through custom shell-based reporting tools.
- Integrated shell scripts with Oracle database jobs for seamless data loading and validation processes.
- Automated file management, log rotation, and backup operations using cron jobs and shell utilities (awk, sed, grep).
Intern
KPMG
Mumbai
01.2023 - 05.2023
- Company Overview: KPMG - INDIA
- Joined KPMG India through college placement drive as an Intern
- Gained experience working on-site in State Bank of India (GITC)
- Collaborated with teammates and clients to learn about OFSAA functionality, modules, and infrastructure
- KPMG - INDIA
Education
Bachelor of Engineering -
Ramrao Adik Institute of Technology (University of Mumbai)
Mumbai01.2023
HSC (CBSE) -
Jaipuriar School
Navi Mumbai01.2019
SSC (CBSE) -
Ryan International School
01-2017
Skills
- Oracle database administration
- Shell scripting
- Oracle PL/SQL
- Python automation
- Oracle Data Integrator
- Oracle Linux and RHEL
- WebLogic server management
- Backup and recovery strategies
- Customer collaboration
- SQL performance tuning
Accomplishments
- AWS Cloud Associate
- Oracle Data Integrator 12C (1Z0-448)
- Oracle Database Admin (1Z0-082)
Timeline
Associate Consultant - TE(Oracle)
KPMG
05.2023 - Current
Intern
KPMG
01.2023 - 05.2023
Bachelor of Engineering -
Ramrao Adik Institute of Technology (University of Mumbai)
HSC (CBSE) -
Jaipuriar School
SSC (CBSE) -
Ryan International School