ORACLE (SQL,PLSQL)

Resume

Mob : +91-906******* Satish Palnati

Email : **************@*****.***

Summary

Ø 5 + years of professional experience as Software Developer and responsible for understanding, analyzing, designing and developing ERP Application in Production Environment.

ØExperienced to write database objects like tables,views,sequences,sysnonyms,indexes using Oracle tools like SQLPlus and SQL Navigator.

ØSolid Experience of creating PL/SQL Packages, Stored Procedures, Functions, Triggers, Cursors and Exception Handling.

ØGood knowledge in Tuning the SQL Queries.

ØExperinced to write Complex SQL queries using joins, Sub-queries and correlated sub-queries.

ØUsed PL/SQL tables,Cursors to process huge volumes of data and used bulk collect for mass update performance improvement process.

ØWidly used SET Operators, Calling REST-API Web service from database and PL/SQL looping concepts.

ØExperienced to write queries for Qlik View BI Tool without creating synthetic keys.

ØExperienced to develop D2k Forms & Reports.

ØAbility to learn Domain Knowledge related to the application in short period of time.

ØHaving good knowledge in xls2ora to load the data from flat files into database.

Technical Summary:

Languages : Java,PL/SQL

Databases : Orcale 10g,11G,MySql

Web-Technologies : HTML,CSS.

Tools & IDE : SQL Navigator,SQL Developer and Oracle Forms Developer

Operating Systems : Windows Family,Unix

Education:

I completed Master’s Degree in Computer Science at Acharya Nagarjuna Univesity.

Professional Summary:

I’m associated with Sathguru Management Consultants Pvt.Limited, Hyderabad as a Software developer since from Feb 2015 to till date.

Product Details:

Product Name : Retail Viva

Clients : Courts Home centers (Fiji) Ltd, Fiji Islands,

Jack's Group of Companies Fiji Islands

Role : Software Engineer

Environment : D2k(Forms&Reports),Oracle Fusion Middle Ware (Oracle ADF 11g)

Database :Oracle 11g

Clients Website : www.courts.com.fj, https://www.jacksfiji.com.

Product Description:

Retail Viva is a New Vision is a Web enabled System with a complete package of ERP like Purchase & Inventory, Point of Sales, Finance Modules, etc. It is multi-user and multi-function software with high degree of flexibility and security.

Contribution:

Analyzing the new Business Requirements requested by the client, developing and integrating into the application

Involved in writing PL/SQL procedures, functions, triggers, and packages to implement business logic.

Created indexes on the tables for easy retrieval of the data to make the data searching speed faster

Used to Global temporary table for processing the data.

Worked on Forms and Reports Builder for Developed ERP Applications.

Involved to writing queries for Integrity check of the data.

Involved to write queries for ViewObjects.

Generated sequences that can be shared by multiple users to generate unique integers.

Written SQL functions, SQL Queries, DML statements, views and SET operators.

Written different levels of triggers for validating data in D2k Forms.

Attended weekly review meetings.

Attending client meetings, collecting functional and data requirements and analysis for data integrity.

Analyzing the new Business requirements requested by the client, developing and integrating into the application.

Project : 2

Wrust Survey:

Client : Surveillance Of Wheat (India, Nepal &Bangladesh)

Role : Software Engineer.

Environment : QlikView and SQL.

Project Description:

The Surveillance of Wheat is the process of observation and capturing the data for different stages of wheat growing in different locations by the Scientists of different countries. These process is used to grow the cultivating the wheat.

Contribution:

Construct the complex SQL queries for loading the data from Database.

Avoid cross joins and avoid Synchronized keys for avoid the duplicated data using Concatenation of table columns.

Using SQL functions in QlikView expressions.

Designed various Charts (Pie, Funnel) for displaying data.

Designed dashboards for tables and pivot tables.

DECLARATION

I here by declare that all the statements made above are true to the best of my Knowledge and Belief.

Place:

Date [Satish P]

Contact this candidate