R Mohan Kumar

Email:adalf3@r.postjobfree.com Contact no: +31(0) 684749064

Objective:

To associate myself with an organization, which has potential for future growth and ample, scope of learning and future enhance my skills through constant learning and meet the challenges in work.

Experience Summary:

4.9 years of IT industry experience on Development of Projects focusing on Data Base using Oracle Sql, Pl/Sql, D2K (Developer 2000) and Core DBA.

Hands on experience in Cursors, Stored Procedures, Functions and Triggers.

Expertise in using Oracle Database, Exception handling, writing stored procedures.

Hands on experience in Oracle Forms & Reports both Development and customization.

Working knowledge on ERP management system.

Experience in Data Migration from Oracle 10g to Oracle 11g.

Involved in the partition creation of the tables for performance.

Strong in using tools such as TOAD.

Import the backup dump into the Test servers through IMPDP

Experienced in environments requiring direct customer interaction during Specifications,

Design, Development and Product Implementation phases.

Personal Information:

Current Location: Netherlands

Visa Information

oVisa Type: HSM dependent visa

oVisa Issued: 27-08-2019

oVisa Validity: 22-07-2024

Experience:

Worked in KPMG ltd from June 2018 to August 2019.

Worked in Synechron technologies pvt ltd from DEC 2017 to June 2018.

Worked in KPIT technologies ltd from Jan 2015 to DEC 2017.

Educational Qualification:

2013 MCA computers from VRS and YRN College, affiliated in JNTU Kakinada University

Technical Skills:

Database : Oracle

Languages : Sql & Pl/Sql

Application Tools : Oracle Forms

Reporting Tools : Oracle Reports

Operating System : Windows 98,2000 Professional & XP,Linux(Basic)

AWARDS & RECOGNITIONS

KPIT Technologies

Awarded with “WOW” for completing the project successfully 2015.

Awarded with "WOW" for dedication towards work and completing critical project in-time 2016.

Project Experience:

Project : PORTFOLIO MANAGEMENT SYSTEM (PMS)

Technology : Oracle Database10g, 11g, PL/SQL, SQL* Loader, Linux &Windows

PMS is financial software, which was developed for State Bank of India, Securities Services Branch Mumbai. The Goal of the software is to invest the funds of employees provident fund organization in secondary and primary Market. The project is divided into following modules: - Money Market, Unit Transactions, Billing, Primary Market, Acceptance and Withdrawal and Custody are main modules.

Creation of Forms & Reports By using Templates.

Maintain and Develop in an ERP Management.

Involved in modifying various existing packages, procedures, functions and triggers according to the new business requirement.

Understanding their client requirements and incorporating the required features in existing ERP.

Managing Database Objects.

Managing Users, Resources, Privileges and Roles.

Proactively monitor the database's health and take preventive action as required.

Working experience with oracle utilities like Export/Import, Data Pump, SQL Loader.

Involved in the Delivery and User Acceptance test of the product.

Worked On Collections.

Involved in the partition creation of the tables for performance.

Project : PAYROLL MANAGEMENT

Technology : Oracle Database10g, 11g, PL/SQL, SQL* Loader, Linux &Windows

A very simple, flexible, user-friendly Payroll Management Software, capable of calculating various salary components, generating pay slips and various other salary reports. It serves statutory requirement for Profession tax, PF, ESI, and Income tax calculations. The software has on option to mail the pay slips to employees, in a pdf file format.

The system has provision to calculate arrears, deductions for loans and other advances. It has an option to define and use variable earning and deduction codes. It also provides for generating statutory reports like Profession Tax, PF, ESI, Form16, etc., and MIS reports like quarter wise salaries, salary comparison, manpower comparison, etc.

Roles and Responsibilities

Involved in Analysis of the Business Requirement for the user.

Involved in Data Migration from Oracle 9i to Oracle 10g.

Developed salary calculation Module and employee information Form.

Developed Forms for PF, ESI, Statutory entries and Leave details .

Developed Reports for Payslips, Salary, PF, ESI AND Income Tax Calculations.

And Daily, Weekly, Monthly and Yearly reports.

Developed PL/SQL Procedures, Functions, Sub Programs, Cursors and Triggers.

Developed most complex SQL queries to pulling the data from database tables.

Developed Procedures and Functions with exception handling.

Co-ordinate and participating discussions with Project Managers.

Involved in understanding the client Requirement and Preparing the Business Reqirement Doccuments. Understand the overall project functionality and giving quick response to the user Queries.

Tuning the queries as well as pl/sql program units for better performance.

Project : RETAIL MODULE

Technology : Oracle Database10g, 11g, PL/SQL, SQL* Loader, Linux &Windows

This system provides all the information needs of stocks and sales for a company, which has a very high production and sales. The stock system takes care of Purchase Order, Goods Receipt Note (GRN), Rejections, Credit Notes and many others. The sales system takes customer order, delivery note raising, invoice preparation and billing. Both the systems generate various reports and powerful Screen based enquiries that would help the user in arriving at wide criteria of stock & sales information. Customer Information System module developed using hierarchical tree structure is the real beauty of this system.

Daily Operations

Pricing

File Maintenance

Managers Utilities

Merchandising

User Defined and Retail Solutions Menus

Roles and Responsibilities

Involved in Analysis of the Business Requirement for the user.

Developed Billing calculation Module and Exchange information Form.

Developed Forms for Scan Inward, Inward, Inward return entry, Physical stock scanning, Main cash,

Petty cash entry and Sales code Master details.

Developed Reports for Product wise stock, System Vs Physical stock, Product wise sale,

And Opening stock and Closing stock, Daily, Weekly, Monthly and Yearly Sales reports.

Developed PL/SQL Procedures, Functions, Sub Programs, Cursors.

Developed most complex SQL queries to pulling the data from database tables.

Contact this candidate