Vivek K.

Vivek K.

PLSQL developer, performance tuning shell scripting

, India

Experience: 12 Years

Vivek

PLSQL developer, performance tuning shell scripting

49371.5 USD / Year

  • Immediate: Available

12 Years

Now you can Instantly Chat with Vivek!

About Me

Hi,

I am having 12 year experience in SQL PLSQL advance performance tuning shell scripting control-M GIT JIRA SVN.

I am having knowledge of MySQL Postgresql visual basic core Java Hive basics Python programming.

 

...

Show More

Portfolio Projects

gather requirement,Implementation and UNIT testing, Deployment..

Contribute

worked as Sr. Programmer. Get requirement from client and analysis with BA.. Implement modules and do the UNIT testing. Helping to QA team for SIT and performance testing.

Description

Load data from files to database as per requirement.

Implement functionality of module(s) and generate reports.

Prepare output report and dump in OS file with requirement file format.

Send these files to client for verification , after client verification requirement's source code need to be deployement on Production environment.

Role:-

Interacting with client for requirement gathering and analyzing and making metadata

Configuration, preparation of TDD (Technical Design Document) as per requirement.

Handling database team, assigning task to team members and guiding them for functionality and technical where ever required.

Get requirement from client and analysis with BA..
Implement modules and do the UNIT testing.
Helping to QA team for SIT and performance testing and making queries as per business requirement.

Show More Show Less

Description

This application is used for providing corporate loans.

So application using various modules like creating proposals for company and making CAL (Customer Agreement letter) issuance and acceptance, And applying various limit handling various currencies for disbursement amount and monitoring with the help of scheduler as well as manual reports generation and transactions.

Other modules are event, re-verification, derivatives, covenants, pending compliances, drawing power, IRR calculation, PI calculation, post sanction modules, checklist, etc.

This application is interacting with core banking also.

Creating hierarchies for SM, SGH and BGH etc.

Creating company level and user level hierarchy and using them into transactions along with organization structure.

Requirement analysis, Implementation.

Guide team members about functionality and implementation module.

Worked as DBA and developer.

Done performance tuning.

Done data modeling for project.

Show More Show Less

Description

This project involves the whole management of the telecom including call detail, Link Analysis, Link Reflection, Location pattern, SDR Analysis, Subscriber Activation Detail, International Roamers, suspect number, international number, silent number, shared Handset Analysis. And managing circle detail, cell Location detail etc.

Worked on Telecomproject.

Worked on oracle database 11g.

Worked on oracle scheduler for periodic reports.

Shell script for functionality implementation.

Show More Show Less

Description

Worked as database developer.

Oracle plsql.

Implemented treasury transaction module and reports for senior management.

Show More Show Less