Ritesh P.

Ritesh P.

MCA with 13 years of Exp in Oracle , 6 years onsite, OCA (DBA) and OCA ( Developer)

, India

Experience: 13 Years

Ritesh

MCA with 13 years of Exp in Oracle , 6 years onsite, OCA (DBA) and OCA ( Developer)

24000 USD / Year

  • Notice Period: Days

13 Years

Now you can Instantly Chat with Ritesh!

About Me

Core Oracle  Pl SQL programmer with 13+ years of IT experience 

...

Show More

Portfolio Projects

Description

Working as Dev-DBA for Clydesdale Bank from offshore India . CB deals with bank customer processing in United Kingdom. Dev-DBA stands for Oracle Developer and handling some DBA related work. After acquisition of Virgin Money by CB , development started for migration existing virgin money customer to CB portfolio. A little DBA works involves user provisioning for multiple database and different schema.

Used many key features of PL/Sql for handling billions of data for processing.

Responsibility: Complete design, development and testing of modules created.

Environment: OS – UNIX

D/B: Oracle 12c

Tools :- RTC, Jira, Confluence, EPM , Lotus Notes, CyberArk

Show More Show Less

Description

The CLASS systems allow the customer to have a Loan Account set up, Payments made, Interest Accrued and Repayments applied. Users are mainly business Services, Finance, Repayment, Collections, Front Line Support etc. CLASS is used throughout the entire Customer Journey, as well as the Business Journey. It Stores application data, course data, bank details, account information, etc.

Around 3TB of data in the CLASS database is stored and it process interest, arrears, payments, transfers, repayments, credits. Interacting with external systems like BACS, HMRC, SAAS, DWP. Used many key features of PL/Sql for handling billions of data for processing.

Show More Show Less

Description

Worked as Programmer Analyst for First Data as Client. First data deals with credit card processing in United States majorly. Our reporting CLGC is mainly in Gift Cards. We use to generate daily, weekly, by-weekly, monthly reports to all the clients of First Data Co-operation like Wal-Mart, MC-Donalds, Starbucks, Ruby Tuesday and many more. Many of the reports are triggered off from Perl Scripts.

Some of them involve writing of reports in shell script with sql scripts within.

Used many key features of PL/Sql for handling billions of data for processing.

Responsibility: Complete design, development and testing of reports generated.

Environment: OS – UNIX

Scripting: - Perl

D/B: Oracle 9i

Show More Show Less

Description

The system titled R-PACS is a web based application which facilitates the BT (British Telecom) agents to plan and configure the logical inventory for their customers. It integrates with other subsystems for order placing.

Responsibilities: Currently is part of Delivery. Worked in Database Development in Oracle 10g.XML files which were pumped from other system,

parsing and validation of the same, also worked in Performance tuning. Looking after live issues which slow down the database, identifying the worse area and tuning the queries by understanding the explain plan.

Delivery:

As a Backend Developer in Delivery team, carried out the following responsibilities:

  • Writing the optimised code for the given requirement following all coding standards.
  • Handling all the database related issues. Carrying out the inlife change
  • Handling all the faults rose during CIT and SIT.
  • Unit testing
  • Preparation of object impacted & Low level design documents.

Show More Show Less