Shobhit Rawat

• Having +8 years of experiences in Linux, Unix Shell Scripting, SQL, Oracle database programming, Production support, Oracle Apps DBA, Implementation Maintenance and deployments.
• Have worked on Oracle and PL/SQL based applications using Oracle PL/SQL and SQL Technologies under Windows, Linux Environments.
• Involved in Development of the applications through Oracle using PL/SQL created Tables, cursors ,Stored Procedures, Functions, Indexing and SQL queries.
• Worked in patching, cloning, Database maintenance, performance tuning.
• Created Shell scripts for invoking SQL Scripts and scheduled them using Crontab.
• Experienced in Trouble shooting using Logs and traces.
• Optimisation and maintenance of existing informatica workflows
• Migrating code related to data fixes and custom features as per (SDLC).
• Taken part in deployments and automation of python scripts.
• Created JavaScript's and shell scripts for multiple projects.
• Monitored SQL Server Logs, Application logs and analyzing the logs.
• Data migration on test and production environments.
• Involved in writing complex SQL Scripts using excel sheets for loading data into maintenance tables.
• Involved Requirements Gathering from the Business Users, Design and Develop work flows.
• Actively participated in interactions with users, team lead, DBAs and technical manager to fully understand the requirements system.

DataInsightX:

Role: Design and maintenance of a data warehouse for storing and analyzing large volumes of banking data to derive actionable insights for decision-making.

Description: Project involved in writing PL/SQL and Python codes for automation actionable insights to stakeholders within banking sector. This involves the design, development, and maintenance of a robust data warehouse infrastructure capable of storing and analyzing large volumes of banking data from various sources.

Responsibilities:

• Collaborate with data architects and analysts to design and implement the data model for the data warehouse, ensuring optimal performance and scalability.
• Develop PL/SQL scripts or procedures to extract, transform and load data from various source systems into the data warehouse, ensuring integrity and accuracy throughout the process.
• Optimize SQL queries, indexes, and database structure to improve the performance of data retrieval and analysis processes within the data warehouse environment.
• Implement data quality checks and validation routines to identify and resolve data anomalies, inconsistencies, and errors during the ETL process.
• Document PL/SQL code, data models, and ETL processes, and provide training and knowledge transfer to other team members to ensure the maintainability and scalability of the project.
• Collaborate with cross-functional teams including data engineers, analysts, business stakeholders, and IT professionals to understand requirements, gather feedback, and deliver solutions that meet the needs of the business.

Online Store Database Management System:
Role: Designed and implemented a comprehensive database management system for an online store.
Description: Project involved in utilizing PL/SQL for efficient data handling and transaction management. The system
encompassed various aspects of e-commerce functionality, including product inventory management, customer
information storage, order processing, and transaction tracking.
Responsibilities:

• Developed PL/SQL procedures and functions to facilitate seamless interaction with the database, enabling fast
  and secure data retrieval, insertion, and updates.
• Implemented a robust data model to organize and store product information, including attributes such as name,
  description, price, and inventory levels, ensuring data and integrity and consistency.
• Designed and optimized SQL queries to retrieve product listings, filter search results, and generate dynamic
  content for the online store interface, enhancing user experience and performance.
• Collaborated with cross-functional teams, including frontend developers, business analysts, and quality
  assurance engineers to ensure seamless integration of database components with the overall e-commerce
  platform.
• Conducted performance tuning and optimization efforts to enhance scalability and responsiveness of the
  database system.
• Provided ongoing support and maintenance for the database infrastructure, including monitoring system health,
  troubleshooting issues, and implementing software updates and patches as needed.

AXIS BANK INTERNAL AUDIT DEVELOPMENT :
Role: Development and Creating Design.
Description: Project Involved with the development of codes on the charge types and execution of scripts for the
monthly/Quarterly basis as per the requirement with the updating and creation of new scripts.
Responsibilities:

• Execution of Multiple Charge types JavaScript's on Monthly/Quarterly basis.
• Development of Codes on PL/SQL, SQL, & Shell scripting.
• Update Queries and Scripts as per the changes required.
• Created Tables, Procedures, Functions, Triggers, Exceptions and other database objects.
• Created documents detailing the process for each of the test scripts and the scenarios each script performs.

Network Based attendance System (NBAS) :
Role: Application Developer and Administrator
Description: Project involved for creating automatic network-oriented class attendance system in VLAN environment.
Along with web-based reporting, backup, and VLAN facilities. All student's data maintain automatically with the NBAS project.
Responsibilities:

• Daily Monitoring of System and services.
• Start the project with scratch created the base tables using shell scripting.
• Created Stored Procedures, Functions, Triggers, Index, Views, Exception handling.
• Created different Tables, Cursors, Procedures, triggers in Oracle schema.
• Wrote Apache based CGI-Programming in shell for reporting in browser.
• Installed and configured Apache Application server.
• Responsible for client/server programming using sockets on SOLARIS.
• Oracle R12.2, R12.1, 11i based support environments.
• Involved in troubleshooting and tuning application server.
• Created Backup scenario using RMAN.
• Oracle Vault setup for security Purpose of attendance schema.
• Handling SOA/Agile/Informatica/Business objects related issues and backup.

• Exam 1Z0-821 and 1Z0-822

Oracle Certified PL/SQL Development & Solaris 11 Administration

• Exam 1Z0-052

Oracle Certified Database Associate

• Reading novels
• Listening to music

I hereby declare that the above mentioned information is correct up to my knowledge and i bear the responsibility for the correctness of the above mentioned particulars.