Smrutiranjan PLSQL Resume
Smrutiranjan PLSQL Resume
Smrutiranjan PLSQL Resume
Smruti Rout
: ranjan.ekaplus@gmail.com
Mob No : +917676297776
CAREER OBJECTIVE:
Looking for a challenging position which will lead to further opportunities in my Professional
growth and Personal satisfaction
PROFESSIONAL DETAILS :
TECHNICAL SKILLS :
Database
Languages
Tools
Operating Systems
PROFESSIONAL DETAILS:
EDUCATIONAL DETAILS:
PROJECT DETAILS:
#1.Project Name
Client
Technology
Duration
Team members
PROJECT DESCRIPTION:
WMS (Warehouse Management Systems) consists of several commercial applications which
cater to the needs of Nippon Express and hundreds of clients of Nippon Express, notable
among them include: Sprint, Philips Healthcare, HP, Seagate, Adidas, Nokia, Resmed,
Affymetrix, Nikon and many others. Nippon Express manages the complete end to end
warehouse management for its customers effectively through its complex and integrated suite
of applications which are efficient, robust and tailor-made or customized to suit the individual
customers. Nippon Express customers use the warehouses of Nippon Express to store their
goods and ship them to various customers across the globe.
The 3 Major WMS Systems are Exceed (3.5 and 3.6), PkMS & GWS. The functionality
mentioned in points 1- 3 is available in all the 3 systems. There are also a lot of bolt on
applications like SLAP 1.0, slap 3000, CMC, Loftware, connectship etc. These bolt-on
applications are used enhance the functionality the major WMS applications. Crystal reports
are used as a part of this Bolt on Applications to provide the reporting solutions and Software
is used to print the labels that are stuck to the package/ cartons.
#2.Project
Client
Duration
Team Members
PROJECT DESCRIPTION :
The objective of the project is totally based on Report .Johnson & Johnson is
pharmaceutical
Companies focused on providing product and MIS report for employees. The key features of
GPM is to generate report in PDF and RPT format .Medical information tracking system is a
Product designed for the field users i.e. Medical representatives of pharmaceutical
companies. It is the flagship product of the company. This has been used by almost all-top
Pharmaceutical companies of the world. This product holds the total information about the
mrps, employees and the products.
Modifying the stored procedures, functions, procedures and packages for the existing
codes.
Writing SQL queries as per the requirement.
Actively involved in creating various business units like writing stored procedure,
function, packages and Materialized view.
Worked on SQL*Loader to load data from flat files obtained from various facilities every
day.
Creating Reports using Crystal Reports.
Optimization of the different SQL queries to ensure faster response time.
Bug Fixing.
Writing SQL queries as per the requirement.
Performed unit test for the code, which I have developed
Prepared ERS as per Business Requirement Specification.
Test cases as per functionality.
Defect Fixing
Smruti Ranjan