Talent's Information
-
Location
Mumbai, India
-
Rate
$10.0 per Hour
-
Experience
3 Year
-
Languages Known
English,Hindi
Available for
Background Verification
40 Hr/Week
About T S
A responsible and challenging position in an organization that would enable me to augment my already acquired knowledge, bring to forefront my skill and offer opportunities for growth, based on achievements.
Tech Stack Expertise
-
Oracle
Oracle 12C
2 Years
Work Experience
SQL Developer
- January 2022 - June 2023 - 1 Year
- India
Projects
MERCHANT TRANSACTION
- January 2022 - June 2023 - 18 Months
Technologies
Role & Responsibility
-
A merchant account is a type of bank account that allows businesses to accept payments in multiple ways, typically debit or credit cards. A merchant account is established under an agreement between an acceptor and a merchant acquiring bank for the settlement of payment card transactions; here transactions like offshore and onshore merchant transactions. Based on that transaction type to do final calculation and calculate of net fees service fees, offshore bank fees, GST etc. The main aim of the project is to do the final tally and generate the important reports like offshore bank reports (bank wise), onshore reports and to calculate important reports like fees (net fees, service fees, offshore bank fees..Etc) reports.
Responsibilities:
Developing procedures and functions as per requirement.
Often used bulk bind, bulk limit in pl/sql objects for improve performance.
Extensively used utl file for data transfer.
Developing sql queries for manipulation of data and transferring data.
Create script to create new tables, views, queries for new enhancement in the application using pl/sql developer tool.
Worked with crucial roles in Migration, Validation, Report Generation, Renewal Merchant details, Inactive Renewal Transaction Details.
Environment Oracle 12c.
GOLD RECIPIENT
- May 2020 - October 2021 - 18 Months
Technologies
Role & Responsibility
-
The project is to bring the Gold Loan and Silver Loan together and launch the system, Our vision is to set up the gold-buying business and loan against Gold in a professional manner. We Pay immediate cash against your gold, and silver jeweller. Pattabhi Loans (pbl Gold Loan) Gold Company clearly wants to set a milestone in the old/used Gold buying business and make customers get the present market value easier in a transparent manner. Aim to provide financial assistance to customers who want cash for gold jewellery for the best price instantly. Customer can visit nearby branches and get Spot cash for your gold at the current online price. Business environment helps needy people, who want to sell their gold in a most transparent environment with the best possible rates in all possible payment modes as per their needs and convenience.
Responsibilities:
Developing functions, procedures according to the requirement.
For crucial modules like account creation, renewal module, plan change, on-payment assets, auction generation.
Creating tables, indexes, and schemas based on requirements.
Writing queries, views for frontend resources.
Writing jobs, using UTL_file package for generating reports.
Using Oracle Loader concepts to import OS data.
