Change Request

1. Understand Business requirement document - Functional Consultant / 
					   Solution designer

2. Understand Database design document - Data Modeler


3. Prepare Impact analysis document

select object_name, object_type, status 
from user_objects
where object_name in (select NAME from user_dependencies
where referenced_name = 'T_ACCOUNTS');

4. Prepare Detailed design document

SELECT LINE, TEXT FROM USER_SOURCE 
WHERE NAME = 'SP_CREATE_ACCOUNT';

5. Prepare Test case document

Fields required in writing the test cases

    Test case id:
    Test case(unit to test):
    Preconditions:
    Input test data: 
    Priority:
    Steps to be executed:
    Expected result:
    Actual result:
    Pass/Fail:
    Comments:

6. Coding - Create and Modify Oracle Objects

7. Do Unit testing / Test result document

8. do Code review

9. Support Testing team in various environment
	DIT	Development integration testing
	SIT	System integration testing
	UAT	User Acceptance testing

10. Prepare release notes 	-	RMG / Production DBA

11. Production Support

JIRA

L1	Help Desk	

Steven		1800-100-1000		Primary
David		1800-100-1001		Secondary
Lex		1800-100-1002		Escalate


L2	Analyze	
L3	Fix



















Roles and Respon
Development
Enhancement
Change request
Change Management
L3 Support
Project Life Cycle


















Environment

Dev
DIT
SIT
UAT
STAGING
PRODUCTION


Oracle Developer
Solution designer
Data Modeler
Java Developer
QA 
Oracle DBA
Release Management Group
PS Team
Pragramme Manager
Delivery Head
Senior Project Manager
Project Manager
Team lead



I/P	DEMAT_ID
O/P
SHARES SUMMARY

SCRIPT		QTY		AVG_BUY_PRICE	TOTAL_PRICE


TCS		100		1000		100000
DLF		200		100		20000


TABLE
SQL LOADER / EXTERNAL TABLE
STORED PROCEDURE
	REFCURSOR



CREATE OR REPLACE PROCEDURE SP_GET_EMP_DEPT
(
	p_dept_name in departments.department_name%type,
	p_emp_details out sys_refcursor
)

AS

BEGIN	

OPEN p_emp_details for
select 
	e.first_name, e.salary, l.city
from
	employees e, departments d, locations l
where
	e.department_id = d.department_id
and	d.location_id = l.location_id
and	d.department_name = p_dept_name;

EXCEPTION

when others then
NULL;

END;
/



CREATE OR REPLACE PROCEDURE p1(i in varchar, O OUT SYS_REFCURSOR)
AS

X VARCHAR(100);

BEGIN	

X := 'select * from '||i;

OPEN O FOR X;

END;
/

bank account	
demat account





		Citi Wealth Advisors

Exchange			NSE/BSE
Script				BHARTIARTL
MARKET PRICE			364.75
Qty				20
Limit Price			360
Stop Loss			350

			Trade Now



exchange  script  Market Price	Qty	Limit Price	Stoploss	Status

NSE	  idea	  114.80	10	110		105		Delivered
NSE	  tcs	  1000		20	990		965		Pending
NSE	  BHARTIARTL  364.75	20	360		350		Pending



SP_TRADE_NOW

exchange
Script
MARKET_PRICE			
Qty				
Limit Price			
Stop Loss

T_ORDERS

order_id
exchange
Script
MARKET_PRICE			
Qty				
Limit Price			
Stop Loss			
CREATE_DATE
CREATE_BY
MODIFIED_DATE
MODIFIED_BY
Retail client