●        Used the WebLogic Server Administration Console to control UAT/Production specific deployment details.

●        Managed Weblogic clusters having multiples of managed servers on cluster of machines.

●        Deployed multiple applications on WebLogic server and maintained load balancing, high availability and fail over functionality.

●        Managing and coordinating ongoing upgrade and migration of platform to stay up to date with the software versions and patches being released to mitigate bugs and issues.

●        Developed an automation tool using shell scripting that would start, stop and check the status of the web process on application servers from a centralized jump server and generate alarms.

●        Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.

●        Wrote Unix commands like renaming the file, extracting date from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables.

●        Involved in the continuous enhancements and fixing of UAT and production problems.

●        Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.

●        Developed PL/SQL triggers and master tables for automatic creation of primary keys.

●        Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.

●        Created indexes on the tables for faster retrieval of the data to enhance database performance.

●        Troubleshooting and resolution of all IIS application problems.

●         Successfully YES BANK Retail Net banking system upgradation done like Aadhaar Card integration with YES BANK Site to DiglockerSite,Emitra-merchant (Rajasthan government site),Credit-Debit card up gradation, RTGS, NEFT, IMPS, Debit card Block-Unblock and Bill Desk in RNB.

●         Developed SQL Queries such as Stored Procedures, Index, View, triggers in PL/SQL.

●         Trouble shooting  issues, leading technical investigations, perform root cause analysis of technical outages.    

●         If finding any bug in the application we immediately co-ordinate with the application vendor for the FIX, once we get the FIX we test the same on UAT & after user & business signoff then We implement the same on production.

●         Debug the complex code units i.e. Stored Procedures,Trigger,DDL,DML and DCL SQL queries.

●         Got exposure to simulate the cases in Development servers and Test servers (UAT) as per resolving critical cases.

●         Automatic process of excel report such as performance matrix report and budget sending report on    daily, monthly and yearly basis and sending them as an email attachment using VBA macro.

●         Knowledge of Retail Net banking, Treasury,Banking (Corporate) domain like FCC, FCR , E-reporting, EMS Server.

●        Created technical design for the back end PL/SQL based on business requirement documents and the functional system design.

●        Development of code using Packages, Stored Procedures/Functions to facilitate business needs.

●        Creation of database objects like tables, views, synonyms, materialized views, stored procedures, packages using Oracle tools like PL/SQL developer.

●        Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.

●        Involved in updating procedures, functions, triggers, and packages based on the change request.

●        Built complex queries using SQL and wrote stored procedures using PL/SQL.

●        Participated in client business needs discussions and translate those needs from a data perspective into technical executions.

●        Got all design and coding reviewed and approved by the concerned authorities. Planned and executed the testing and implementation of major systems.

●        Participated in both peer design and code reviews.

●        Developed SQL Queries such as Stored Procedures, Index, View, triggers in PL/SQL.

●        Created scripts to create new tables, views, queries for new enhancement in the application using TOAD to create new workflows for Company.

●        Designed and Developed Oracle database Tables, Views, Indexes, and Synonyms with proper privileges.

●        Designed and Developed Forms for tracking the account details of the customer.

●        Developed PLSQL packages for generating various feeds from oracle database using UTL FILE utility in the client's secure data transmission server.

●        Provided production support through monitoring, notification and job/service management. Participated in vendor review and selection where appropriate.