Nov 2020 – Jul 2025 · 4 yrs 8 mos · Gurugram, Haryana, India · Hybrid

• MPWebGIS is a Geo-location based project focused on land records and Settlements for the state of Madhya Pradesh. It is a web based application
• Integrated with GIS maps for carrying out all land records processes. The Application enables a citizen to view his/her land details and carry out
• Online Activities such as pay land tax, request printing of records or copies it maybe khasra copy khatoni copy map copy and other similar activities.
•  Well versed in the development of Applications and support by writing stored procedures, functions, packages, enhancements in existing applications using Oracle
•  Have experience knowledge in writing cursors like explicit, parameterized, ref cursor, joins ,sub-queries, co-related queries
•  Comfortable and experienced with Linux and Windows platform
•  Good experience in Oracle tools like Toad
•  Good communication, interpersonal, research/analysis and organizational skills; quick learner, adaptable and process-oriented individual with high customer orientation

Jan 2020 – Feb 2020 · 1 mo · Noida, Uttar Pradesh, India · On-site

•  Creating custom database objects like Tables, Views, Synonyms, Sequences, Functions, Procedures and Packages according requirements.
•  Doing Changes in Procedure, Packages , Functions as per requirement.
•  Development of SQL queries to extract the data.

Aug 2018 – Sep 2019 · 1 yr 1 mo · New Delhi, Delhi, India · On-site

• It is a web application that is designed for provident fund operation on Exempted and Unexempted level. Its uses for internal employee of Employee Provident Funds. This employee generate the claim, settle the claim and also transfer the claim through this application.
• Members with authenticated Aadhaar and Bank details seeded against their UAN can now submit their PF Withdrawal/Settlement/Transfer claims online.
•  Perform Oracle Programmer related activities by writing SQL queries and analyzing PL/SQL packages, developing/enhancing packages, procedures, functions, triggers.
•  Written SQL (Join, Sub-query and complex query)

Jun 2016 – Sep 2017 · 1 yr 3 mos · Noida, Uttar Pradesh, India · On-site

• Selfcare is a online portal for Bharti Airtel. Selfcare portal is a single platform for postpaid/prepaid/telemedia/broadband customer’s for carrying out many operations such as - Registered users can View their account summary (Unbilled amount and unbilled usage), Change profile/password, add number, View/download Bills (Summary and Itemized bills) for last 10 months, make online payments through credit cards, debit card, net-banking, View payment history, change bill preference (Ebill/Paper), View Bill plan, log complaint of raise new request etc.
• Customers view all important information related to their mobile/landline/DSL/DTH connection through 121 SMS services. The portal is running on Websphere Portal with Service layer (WAS) which is integrated with other applications such as CRM, Billing System (FX), Biff Tool, Payment Gateways etc.
•  Involved in support and monitoring of the application
•  Resolving the issues as per the defined SLA
•  Written SQL (Join, Sub-query and complexquery)
•  Handling Selfcare Application
•  Work on several tool i.e, Maxit,Winscp,Putty,Soap,MicrositeDeployment,Aqua Data
• Studio,Oracle SQL Developer .
•  Monitoring applications (Kibana , AppDynamics , Pingdom) and service logs.
•  Coordinate with other’s team’s DB2,WAS,NMS,Network,Windows,CRM,NDS,Lotus,Unix.
•  Performing the operational changes at Server’s