Senior Manager
Reliance Industries Limited
Total years of experience :14 years, 7 Months
IT Automation.
Key Result Areas:
Creating business analysis (BI) reports for Plant/Project Maintenance, Plant/Project Progress and related components details.
Complex query build, query tuning (Oracle Performance Tuning of Query) for INTERGRAPH Tools
SMARTPLANT Foundation (SPF), SMARTPLANT Construction (SPC), SMARTPLANT Piping and Instrumentation Diagramming
(SP P&ID) and reporting tools having frontend .NET / Telerik Reporting Platform to enhance the output look and feel and
performance.
Excellent experience in performance tuning using STATSPACK, EXPLAINS PLAN, SQL TRACE, TKPROF, AWR and ADDM reports.
Excellent Troubleshooting skills in OS level and Database level.
Awareness on Oracle Support processes for technical requests through Meta link.
Expertise in RDBMS Tools like SQL Loader, Import/Export, Data Pump, RMAN, OEM Grid Control.
Creating and refreshing materialized views.
Used SQL* Loader and External Tables to Load data from flat files to database.
Created PL/SQL procedures (jobs) to automate maintenance tasks.
Database cloning from production to test, development environment.
Significant Accomplishments:
Instrumental in roll-out of Integrated framework deployment for IIR project :
Readiness for Implement state-of-the-art Project Management Automation Tools - Engineering data (3D/2D), Procurement
(SPM / SAP), Fabrication (SPG / SPG+), Construction (SPC), Pre-commissioning, Commissioning (SPO SC) processes to facilitate
improved project delivery (Database aspect).
SPMS (In-house) develop and deploy code SPMS database monitoring, performance monitoring and performance tuning.
Database Migration of Jio (R4G) and RWORKS.
Monitoring of SPF, SPC database and provide appropriate recommendations to IT DBA team for deployment system specific
tasks
Developer (Oracle)
Provided DBA support for General Motors, Europe.
Lead team of DBA’s and Developer Team to provide 24*7 support.
Redefined database support processes and production deployment in compliance with SOX guidelines.
Created & Published Run book.
Revisited and suggested production index choices and suggested new indexes.
Regularly monitored system to keep system load stable and optimal.
Interacting with Business Analyst for the Business requirement
Estimation of effort and time of the completion of a particular QC or CR.
Release of document on Database security, Database / user creation, Role/rights, database security guidelines
Prepared Solution and Architect design for new Project for Western Power - Oracle Utilities Customer Care & Billing Module.
Lead team of 10+ staff
Managed Customer/Project deliverables.
Assisted & guided offshore team in best practices for Oracle SQL, PLSQL programming.
Defined Guidelines, Standards and Best practices for PLSQL code and SQL query writing and scripts.
Implementation of SOX guidelines in project.
24x7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution
of database issues
Oracle
PLSQL)
Development Performance testing of application code developed in PLSQL for System CR.
Support and Maintenance Capital Reporting Application of BT.
Understanding the workflow and testing requirements for Capital Reporting Application.
Testing of Deployment code from UNIX and Linux.
Control M Job Scheduling
Managed Operations and Quality team to develop and implement Web Based Content Management System
Regular discussions with various product delivery groups to identify process that needs fine tuning.
Developed package which validates the quality of product and provide trend reports.
Have set standards for quality as well as health and safety.
Defined Quality check procedures.
Master of Computer Application Includes Following Subjects Mathematics Foundation Statistical Methods Computer Environment and PC Software Computer Programming and Problem Solving Computer Organization and Assembly Programming Practical -1 Graph Theory DBMS Data Structure & File Structure Analysis and Design of Information System. OOP using Visual Basic Practical 2 Software Engineering Data communication and Networking Account & Financial Management Computer Base Optimization Technique Use of RDBMS Practical 3 Operating System System Software and C++ OODB Design Unix and System Programming Practical 4
Bachelor's Degree in Chemistry
URL removed due to policy violation. Please contact support for further information.