CURRICULUM VITAE
SOUMYA RANJAN SAHOO
E-mail- *************@*****.***, *******.*****@**********.***
CAREER OBJECTIVE
Seeking assignments in Database Applications in a growth oriented
technology driven organization.
professional synopsis
1. 4 year and 7 months of experience in Software Engineering, Production
Support & Development in the IT Sector.
1. Currently serving as Software Programmer with Ardee Business Software
Solution Ltd. and involved as production support Executive and Form &
Report Developer.
1. ERP Domain expertise in manufacturer data processing applications..
IT SKILL SET
1. Operating System : Windows XP
1. Languages Known : Oracle Forms & Report Developer 10g, Sql,
Pl/Sql
1. Databases : Oracle 10g, Oracle 9i
1. Report Developer : Oracle Report Developer.
1. Application : Ms Office, Open Office
CAREER HIGHLIGHTS
Since August'2008 : Ardee Business Pvt. Ltd., as Software
Programmer.
Chief tasks handled
1. Developed Purchase and Inventory module of a ERP Software.
2. Modification and enhancement of Oracle Stored Procedure.
3. Client and functional team interaction for business process,
requirements gathering and analysis while working as offshore
developer.
1. Mentor a growing offshore team in various phases of knowledge
transition and day to day maintenance and production support
activities.
1. Developing & Modifying Forms and Report for clients as per their
Requirement.
KEY PROJECTS HANDELED
Project # 1
Title : Web ERP (Enterprise Resource Planning) System.
Organization : Ardee Business Software Solutions Ltd., Rourkela.
Environment : Oracle 10g, forms & reports.
Duration : Aug'08 to March'11
Team Size : Three
Role : Team Member
Project Description:
Complete ERP (Enterprise Resource Planning) package is web enabled. As part
of Purchase Module team had done developing the same. Purchase Module
starts with indent of material. There is four stage approval at indent
stage ie. department, store, management & purchase. Once approved enquiry
comes into action. In enquiry stage we quote our price and quantity of
material required. Supplier quotes his price, based on it quotation is
prepared. On the basis of comparative price list Purchase Order (P0) is
made. Again there is three stage approval of PO ie. department, purchase &
management. Once approved Purchase Order is placed. Then role of Inventory
module comes into action.
As it is web enabled hence management approval can be
done remotely through web portal. Due to which there is no hindrance in day
to day activities of the company.
Roles and Responsibilities:
1. Performed any changes in the Aspire reports on users request.
1. Created a new report for Aspire reporting.
1. Performed any changes in the Aspire Forms on users request.
1. Created new Forms for Aspire requirement.
1. Written PL/SQL code for Database Trigger and Stored Procedures and
View.
1. Created Excel Sheet as per user request from Database.
1. Handling Total Material Management Module In Client Side.
1. Developed Forms and Reports of Purchase, Stores and Work module.
Project # 2
Title : Hospital Management System.
Client : Community Welfare Society (CWS) hospital.
Organization : Ardee Business Software Solutions
Ltd., Rourkela.
Environment : ORACLE 10g, forms & reports.
Duration : Apl'11 to till date
Team Size : Fifteen
Role : Team Member
Project Description:
It is a product which caters all the modules as part of Hospital Management
System (HMS) ie. master, registration, clinical, purchase, inventory,
finance, HRM, Administration,Blood Bank & auditing. It is complete
computersation of hospital functioning. Patient has to register in OPD (Out
Patient Department) based on doctor's advice he/she is admitted in the
hospital as IPD (In Patient Department). Once registered as Inpatient
he/she has to deposit certain amount. Based on doctor's remark in discharge
report, patient is discharged. Final bill is generated based on type of
patient ie. corporate client, ESI client, CWS staff. As per patient type
final bill is generated.
Roles and Responsibilities:
1. Performed any changes in the Aspire reports on users request.
2. Created a new report for Aspire reporting.
3. Performed any changes in the Aspire Forms on users request.
4. Created new Forms for Aspire requirement.
5. Written PL/SQL code for Database Trigger and Stored Procedures and
View.
6. Created Excel Sheet as per user request from Database.
7 Handling Total Blood Bank & Material Management Module In Client
Side.
8 Developed Forms and Reports of Purchase, Stores and Blood module.
TECHNICAL SKILL USED
Database : Oracle 10g
Languages : PL/SQL, Java, Oracle Forms
Tools : Oracle Forms Developer,Oracle Report
Developer,HTML
QUALIFICATION HIGHLIGHTS
6. MCA from RIMS. Rourkela.
In the Year 2008with 75%.
7. Bachelor in Science.
From: - Sambalpur University, Odisha with 52%.
In the Year 2005.
8. 10+2 Science.
From: - Council of Higher Secondary Education, Odisha With 51%.
In the Year 2002.
1. H.S.C.
From: - Board of Secondary Education, Odisha. With 82%
In the Year 2000.
PERSONAL DETAILS
Father's Name : - Mr.Ajaya Kumar Sahoo
Mother's Name : - Mrs.Sabitri Sahoo.
Date of Birth : - 02-05-1985
Permanent Address : - A/p-Udayapur, Via-Binjharpur, Dist-Jajpur,
State-Odisha.
Present Address : - 16 th Main,12 th Cross,House No-102,BTM
Lay Out,1st Stage
Tavarekere Road,Bangalore-
560029
Sex : - Male
Marital Status : - Married
Nationality : - Indian
Language Known : - Oriya/English/Hindi