Site hosted by Angelfire.com: Build your free website today!
Home Psychology Information Tech Resume Recognition
 
 

Information Technology

  
   
Sorry, your browser doesn't support Java(tm).
     Devry's Information Technology (IT) Program was designed for the baccalaureate-level graduate seeking to pursue a career in IT.  The program was structured around a core of technology-oriented specialty courses, with emphasis on applying computer technology to solve business problems.  I augmented my college and business backgrounds as I worked  in teams to develop solutions in case studies.  Project management, communication skills and ongoing IT  administration, all of which are critically important in today's business environment, were integrated through this program.
     The IT program provided a foundation in computer programming, database technology, networking and systems analysis and design.  List below are the core studies. 
Devry   Information Technology Irving, TX 3/2001 2/2002
  PC Repair NOS Maintenance C Programming Adv C Programming  
  System Analysis Oracle Adv Oracle Web Design  
  Internet/Intranet Network Security Adv Networking Sys IT Database  
 
Work Experience Dallas Metrocare Services (MHMR) Dallas, TX  
   5 years of heavy computer usage using MSAccess, Excel, Focus, Crystal Reports, and Oracle.  I prepared fiduciary reports, aggregated data on patients, services, and the purchasing of items.  I assisted departments meet quarterly targets by preparing reports which monitored productivity and efficiency.  I also did heavy data mining to maximize revenues. 

 

 

 

  
           

One of my sample PL/SQL code for
Functions

One of my sample PL/SQL code for
Procedure
create or replace function CalcGPA
(sid number)
return number 
is 
cursor cal_grade is
select course.callid,
course.cname,
course.ccredit,
enrollment.grade,
decode(enrollment.grade, 'A', 4, 'B', 3, 'C', 2, 'D', 1, 'F', 0) as letter_grade
from course,
enrollment,
course_section
where enrollment.csecid = course_section.csecid and
course.cid = course_section.cid and
enrollment.sid = sid and enrollment.grade is not null;
v_sum_credit number := 0;
v_sum_num number := 0;
v_gpa_overall long := 0;
v_gpa number := 0;
vs_gpa number;
v_sid number:= sid;
s_gpa number:= 0;
begin
for inv_row in cal_grade loop
v_sum_credit := v_sum_credit+inv_row.ccredit;
v_sum_num := v_sum_num + inv_row.letter_grade;
v_gpa_overall := (v_sum_credit*v_sum_num/v_sum_num);
v_gpa := v_gpa+inv_row.ccredit*inv_row.letter_grade;
vs_gpa := round(v_gpa/v_sum_credit, 2);
s_gpa := vs_gpa;
end loop;
return s_gpa;
end;
/		 create or replace procedure UpdateOrderline
(orderid number, invid number, quantity number)
is
itemprice number(6,2);
currentorderid number:= orderid;
currentinvid number:= invid;
currentQuantity number:= quantity;
begin
select curr_price into itemprice
from inventory where invid = currentinvid;
update orderline
set order_price = itemprice
where orderid = currentorderid;
update inventory
set qoh = qoh -1
where invid = currentinvid;
end UpdateOrderline;
/
One of my sample PL/SQL Triggers

One of my
PL/SQL Exceptions
CREATE OR REPLACE TRIGGER instructor_biud
BEFORE INSERT OR UPDATE OR DELETE ON INSTRUCTOR
DECLARE
v_day varchar2(9);
e_update_error EXCEPTION;
BEGIN
v_day := RTRIM(TO_CHAR(SYSDATE, 'DAY'));
IF v_day NOT in ('Saturday', 'Sunday')
THEN
RAISE E_UPDATE_ERROR;
END IF;
EXCEPTION
WHEN E_UPDATE_ERROR THEN
DBMS_OUTPUT.PUT_LINE('The INSTRUCTOR table cannot be modified during weekdays');
END;
/
 DECLARE
CURSOR c_instructor IS
SELECT instructor_id, count(*) tot_sec
FROM section
GROUP BY instructor_id;

v_name VARCHAR2(30);
e_too_many_sections EXCEPTION;
BEGIN
FOR r_instructor IN c_instructor
LOOP
SELECT RTRIM(first_name)||' '||RTRIM(last_name)
INTO v_name
FROM instructor
WHERE instructor_id = 
r_instructor.instructor_id; 

IF r_instructor.tot_sec >= 10
THEN 
RAISE e_too_many_sections;
ELSE 
DBMS_OUTPUT.PUT_LINE
('Instructor '||v_name|| ' teaches '||
r_instructor.tot_sec||' sections');
END IF;
END LOOP;
EXCEPTION
WHEN e_too_many_sections 
THEN
DBMS_output.put_line('Instructor '||v_name||
' teaches too much'); 
END;
/ 

 
Samples of Web Design
Cakes by Joe Ybarra