Oracle PL/SQL Developer with 9 years IT industry experience
Around 9 years of experience in IT industry.
Experience in Oracle PL/SQL Developer.
Experience in Application Support Analyst.
Experience in Oracle Application DBA. Domain knowledge of Banking and Telecom. Hard working and career committed having sound technical and communication skills.
Problem solving skills and motivational qualities along to zeal to work in team.
Pl/sql Development and Pl/sql Support - Persistent Systems
(2024-06)
Application development in Artisan for Prod and Non-Prod DB's. Writing complex queries, stored procedures, packages, functions, and triggers. Developing and optimizing PL/SQL code for data manipulation, validation, and reporting.
Resolved errors and issues in the PL/SQL back-end and database processes. Writing SQL scripts to enhance database performance and efficiency. Designing and implementing database structures, including tables, indexes, and views.
Involved in Deployments/ OS patching /Defect Handling
Pl/sql Development and ADBA - Application DBA - Tech Mahindra Limited
(2020-05 - 2024-02)
Application development and support for Médiation and Balance Manager for Prod and Non-Prod Databases. Designing and implementing database structures, including tables, indexes, and views. Writing SQL scripts to enhance database performance and efficiency.
And managing Oracle reports. Developing and optimizing PL/SQL code for data manipulation, validation, and reporting. Resolving performance issues, such as indexing and partitioning. We monitor DBA jobs, Scheduler jobs and check status for running or scheduled, If broken /failed /Disable then find reason and placed to online Jobs.
We checked Database connectivity/ Tablesapce size/ Reinstalled Datapump. Create partition/Drop Partition/refresh Materialized view. Excute the procedure on QA using common schema to export data from Medref to QA.
Documenting technical specifications, data models, and processes. Involved in OS patching /Defect Handling /Deployement. Performance tuning and query optimization to enhance database performance.
Pl/sql Development and Application Support Analyst - Tech Mahindra Limited
(2019-06 - 2020-04)
Volkswagen is a German multinational automotive manufacturing company. Participating in database design reviews and providing recommendations for enhancements conducting unit testing and debugging to ensure the functionality and accuracy of PL/SQL code. Troubleshooting and resolving database-related issues and errors.
They have various applications to provide engineering services to their end customers. And various vendors to develop and maintaining their applications. Our team has been identified as the vendor who will support E2E project.in their AMS activities.
The AMS activities involves L2 and L3 activities. The AMS team is providing L2 support to the E2E applications. The L2 activities involves Analysis of issues, Deployment and Configuration changes of applications in Test, QS and Production environments.
Primarily, the VW E2E AMS team is divided into 2 groups: Electric and Electronics (EE)
Pl/sql Development and Application Support Analyst - Tech Mahindra Limited
(2018-09 - 2019-05)
The project is Adder is a Customer Commitment Product Management System. It Manages the BT Retail Business customers' contracts. Considering a contract as a main entity. Adder can track and monitor the call spent and revenue of customers.
Customer is liable to be penalized in case fails to achieve the commitment. Commitment products within the Adder system is a combination of a package, commitment spend level (tier) and term (period of contract). If customer spend more level than given more discount for that product.
At database level each commitment product is stored on Adder In Adder's perspective, commitment products are applied on a customer network. The products are at installation level, every level of the Customer Commitment products has its own internal product code together with a list of compatible and incompatible Customer Service System products.
Technical Associate - Atos Global IT solutions and Services Private LTD
(2016-06 - 2018-07)
The project is Provide an integrated view of the business, the market and the customer through easy access to cross-functional data in order to facilitate effective decision making.
Phase of the BI project is aimed at recording the business requirements for Business Postpaid BI brings the data of the various systems in the postpaid stack to the Data warehouse platform. Postpaid stack takes care of all provisioning, Customer Service Management, Billing, Collections all other functionalities that are needed in a Customer's life cycle.
Technical Associate - ShreeCom Info Tech India Pvt. Ltd
(2013-04 - 2016-03)
The project is banking application designed and developed in Oracle 10G as backend and D2K as frontend. Various banking functionalities like account management, loan management, net banking are managed. Apart from this banks own HR module and assets management module are also developed and managed.
The application is used in district level Co-operative urban banks across 5 districts and around 40 banks having around 200 branches. Different types of reports as per the requirements can be generated through this application. Apart from the core project development, daily production support has been given on adhoc basis and as per the priority of the work request.
MCA - Master of Computer Applications - Shivaji University, Kolhapur
