Roland Lee
Contents
1. Portfolio Roland Lee 503 646 4467 rlee graduates iti com Roland Lee BSc AIT 13020 SW Tapadera St Beaverton OR 97008 503 646 4467 roland_97008 yahoo com Online portfolio http server2 portland iti com rlee Objective O Seeking an opportunity as a Bionformatics software engineer in a challenging team based environment Personal Profile DOOOOCDL Willing to travel IT Skills Operating Systems O Windows 98 ME 2000 O Windows NT Development Tools and Technologies O Visual Basic 6 0 O Visual Age for Java 3 5 QO Java JDK 1 2 1 3 a DB2 UDB O Microsoft Access a VBScript JavaScript a Visual Basic for Applications a HTML 4 0 Q FrontPage 2000 O ASP O ADO O SQL a COM COM a MTS IIS Methodologies a GUIDS Ba OOD and OOP O ERD Data Modeling a UML RUP a Design Patterns On tier architecture Independent Studies O Macromedia Flash Macromedia Dreamweaver a Macromedia Fireworks Current goals a CGI Perl XML Javascript and reading about NET a Learn how to implement SQL Server or Oracle database into VB or Java a Java Certification Willamette University Women s Volleyball Assistant Coach Trilingual fluent in Chinese Mandarin English and Filipino Tagalog 3 years Quality Assurance experience testing documentation Experience in Visual Basic Java DB2 Macromedia Products HTML Microsoft Access SQL ASP Java VBscript Bachelor of Science Bi2. Ian I D Vanderberg Former ITI Facilitator Curriculum We use collaborative and problem based learning methodologies to develop your technical problem solving and project management skills and prepare you to be a valuable team oriented member of the workplace You ll develop your skills as you find solutions to real world business problems as part of a project team simulating an IT industry based work environment lied Information Technolog The ITI curriculum is divided into five modules O Essentials of e Business Computing O Distributed Application Design and Development using Visual Basic 6 O Enterprise Application Development using Visual Age for Java O Enterprise Application Development using DB2 UDB O Professional Development Several team projects are completed over the 9 month accelerated post graduate program Proper analysis and design are emphasized throughout the lifespan of each project Also incorporated are team dynamic exercises conflict resolution team communication stress management delegation of tasks sharing information time management application integration resource and version management and the production of technical documentation Practical team projects allow for applied learning of concepts learned during technical instruction Presentations are made at the end of each project Team Project 1 Web Presence Students will design a Web Presence prototype for a business using HTML F
3. down calendar to select dates 14 Access Basic Programmer Basic Programming 7 test C Programming tests COBOL Programming Fortran Prograrming Interviewing Java Development Bok Lowe Mark Benge Queena Powerbuilder 5 0 Roger Peti Presenting Basic Programmer Job Order Profile Basic Programmer Joh Title Basit Programme test gt queena Company IT w Junior Programmer C Programmer x Date Opened Basic Programmer C Programmer Java Programmer Date Closed C Programmer C Programmer Basic Programmer I I C Programmer Open Under Offer Closed C Programmer Notes Request Intennew Modify Profile 15 Applicant Profile i Basic Programmingt Name Mark Benge C Programming Phone 919 444 1576 Password default Current Salary 453 32 Desired Salary 427000 wa voee Notes Skill Set Master Skills Accessg Basic Programming C Programming COBOL Programming Suma coca Perform the retrieveApplicant method param UserID int param password java lang String public void retrieveApplicant int UserID char password throws com ibm ivj eab dab DAException InvalidLoginException create String object to hold characters in array String newPass new String use for loop to concatenate characters to end of String for int i 0 i lt password leng
4. lt gt Then Instantiate objects Set objOutlookMsg objOutlook CreateItem olMailItem Write message With objOutlookMsg To strEmail Subject Position Match amp amp strPosition Body Dear amp strFirstName amp amp strLastName amp amp vbNewLine amp vbNewLine Body Body amp I have found a position that matches one or more of your job skills amp vbNewLine amp vbNewLine Body Body amp Position Title amp strPosition amp vbNewLine Body Body amp Company amp strCompany amp vbNewLine amp vbNewLine Body Body amp I will be contacting you shortly regarding the position Body Body amp At that time I can provide you with more details about Body Body amp the position and help you determine if it is one Body Body amp you wish to pursue amp vbNewLine amp vbNewLine Body Body amp Sincerely amp vbNewLine amp vbNewLine Body Body amp Alan Gregory amp vbNewLine Body Body amp Placement Associate amp vbNewLine Body Body amp Virtual Placement Agency amp vbNewLine Body Body amp agregory vpa com amp vbNewLine Body Body amp 800 555 0987 Send End With track number of emails sent to applicant intMessageSent intMessageSent 1 Else track number of applicants without email intMessageNotSent intMessageNotSent 1 End If Next display message indicating number of messages sent
5. access server database over the Internet USE CASE Maintain Dealer Information Actors eCar Connexion staff Purpose To allow eCar Connexion staff to add edit delete dealer information Overview The eCar Connexion staff can add edit delete all the dealer information The information includes the Dealer Name Contact Name Dealer Address Business Phone Number Dealer Region Email Address Web Site URL and Sell Lease capabilities The Web Site URL is optional Typical Course of Events 1 2 J This use case begins when the eCar Connexion staff enters the Dealer Information Section System Response Add Edit and Delete option displays Staff selects option If Add option selected see section Add Dealer Information If Edit option selected see section Edit Dealer Information If Delete option selected see section Delete Dealer Information Section Add Dealer Information 1 2 3 4 System Response An empty dealer form displays The staff enters their information The staff saves their information System Response Dealer Information added Alternative Scenario Line 3 Required item missing Indicate error and allow re entry at Line 2 Line 3 Required item in invalid format Indicate error and allow re entry at Line 2 rai mabitaii dealers i oe maintain ain diat NE car connexions employee The project began with obtaining requirements from
6. and the communication between them Modify Profile Show Job Orders Register Right The applet storyboard details the different ways the user can interact on the web with the client s Request interview Submit confirm userlD and password system Confirm request Job Order Profile Basic Programmer Seat AR asic Prog eae Programmer Compan Basic Programmer Basic Programmer Date Opened Basic Programmer Basic Programmer Date Closed Basic Programmer Basic Programmer Minimum Salary christine i C Programmer SSL a a pu Open Under Offer Closed C Programmer C Programmer C Programmer Notes C Programmer C Programmer Gary Graphics Designer Instructor Welcome to Maintain Job Orders Enroll Date British Airways Calloway Golf Canada Trust Canadian Canadian Tire General Motors Holiday Inn Welcome to Maintain Companies Accesso Basit Programming C Programming COBOL Programming DB Design DHTML Related Job Orders The user can view a list of Job Orders They also have the option of adding editing deleting a job order records For ease of use a combo box with all the companies is used during entry of a job record Other things include radio buttons for the status of the job text fields that only allow numbers for the salary and a drop
7. the client to develop use cases Left A sample use case from our database application for users maintaining dealer information Above The use case diagram for the application Employee is able to maintain client dealer and transaction information calculate payments or request reports 18 al Connexions Top Pa Gur mission w Dur Vision f Contaet U Ferula es perviots Please Click on an Auto Manufacturer below for more information Welcome Are you puzzled by the car buying process Let s face it No owner General Sales Manager or Salesperson has all your automobile answers at their fingertips We are an automobile brokerage with numerous relationships with automobile sales and leasing companies throughout North America We quarantee to make the best CONNECTION between YOU and your Automobile Our Mission Our mission is to provide our customers with top quality service that will match their automobile needs and desires without impacting on their busy lives Users have the option of researching cars before requesting the service of the company Welcome Clicking on a Manufacturer logo opens a new window Showing the manufacturer s website Email Us for more information on manufacturers we may have missed 19 Database Main menu Developed a Rae user interface WIS l l 1 k using VBA Utilized the background Clients and similar color sche
8. Heston Charlton Jacobs Johri Private Sub cmdEmail_Click after applicants are matched with a position option to e mail each applicant regarding position This method e mails applicants matched at end of process message indicates number of emails sent to a specific position Only applicants with email addresses are sent emails and after the task is done a message on the On Error GoTo errorHandler Dim objOutlook As New Outlook Application Dim objOutlookMsg As Outlook MailItem status bar is shown indicating how many Dim arrApplicants As Variant emails were sent Dim intCounter As Integer Dim strPosition As String Dim strEmail As String Dim strFirstName As String Dim strLastName As String Dim strCompany As String Dim intMessageSent As Integer Dim intMessageNotSent As Integer set array receiving info from BODT arrApplicants mobjPosition MatchApplicantEmail Me IstOpenPosition ItemData Me IstOpenPosition ListIndex use for loop to go through array and hold info in variables For intCounter O To UBound arrApplicants 2 strFirstName arrApplicants 2 intCounter strLastName arrApplicants 1 intCounter strEmail arrApplicants 3 intCounter fill variables with position company info from private variable list box strPosition mobjPosition Title strCompany Me istCompany List Me IlstCompany ListIndex Check if applicant has email address in applicant information If so send an email message If strEmail
9. aboratory in compliance with the FDA and GMP requirements 1999 2000 O High degree of analysis and strategy systematic and organized methods of coaching discussion of teaching and motivational methods O Supervised player development in the off season regulated practices and worked on specific skill sets with players Roland Lee BSc AIT 503 646 4467 13020 SW Tapadera St Beaverton OR 97008 rlee graduates iti com Online portfolio http server2 portland iti com rlee Technical project work The following projects were completed in an academic environment Web Application O Developed an interactive website for a Car broker using FrontPage 2000 VBScript HTML Javascript and Access 2000 QO Identified limits in capabilities of FrontPage 2000 and learned Macromedia Dreamweaver 4 Fireworks 3 and Flash 5 to enhance the appearance of the site Created a VBA application with Access 2000 of similar functionality as the website Visual Basic Application O Crowned Debugging King for ability to discern syntax and other unsolvable errors O Successful in integrating all of client s extended features to application O Built an application for a Placement Agency using Visual Basic 6 0 connected to an Access 2000 database using ADO and MTS O Developed a winning response to a Request For Proposal RFP that was both economically and strategically acceptable to the client a GUIDS Methodology and Unified Modeling Lan
10. and how many applicants did not have an email address to send to frmMDI stamdi Panels 4 Visible True frmMDI stamdi Panels 4 Picture frmMDI ilsForms ListImages 2 Picture frmMDI stamdi Panels 4 Text intMessageSent amp message s were sent to applicants amp intMessageNotSent amp applicant s did not have an email address destroy objects Set objOutlookMsg Nothing Set objOutlook Nothing reset visibility of layered buttons cmdMatchApplicant Visible True cmdemail Visible False Exit Sub errorHandler Call CheckError End Sub Private Sub cmdLogin_Click this sub on click checks the user name and password text boxes for values If values are present then connect to database and find username and password Dim arrSecurity As Variant On Error GoTo errorHandler check textboxes for values If Me txtUsername Text Then frmMDI stamdi Panels 4 Visible True frmMDI stamdi Panels 4 Picture frmMDI ilsForms ListImages 1 Picture frmMDI stamdi Panels 4 Text Please enter a Username Me txtUsername SetFocus Left This method was written for the login screen Below A specific logical sequence was required as diagrammed below ElseIf Me txtPassword Text Then frmMDI stamdi Panels 4 Visible True frmMDI stamdi Panels 4 Picture frmMDI ilsForms ListImages 1 Picture frmMDI stamdi Panels 4 Text Please enter a Password Me txtPassword SetFocus Else call validateLogin method
11. anges objWord ActiveDocument Close savechanges False quit word application objWord Quit End If reset wordobject Set objWord Nothing End Sub ZZ lt script language vbscript gt lt Option Explicit Dim SP DP IR MLP MPP RP months Function MonthlyLP SP DP IR Months this calculates the monthly lease payment MonthlyLP 0 6 SP DP IR 12 1 1 IR 12 months End Function Sub cmdLease_onclick this sub on click checks each entry for validity If validity is assured then function MLP is called with each argument passed and placed into variable MLP which is then shown in the msgbox If validation false then exit sub Else MLP MonthlyLP SP DP IR months frmcalculator txtleasepayment value formatCurrency MLP End If End sub Function Validation this function checks for valid values in txt boxes SP frmcalculator txtsellingprice value DP frmcalculator txtdownpayment value IR frmcalculator txtinterestrate value months frmcalculator txtmonths value Down Papani Fitt Fake If a txtbox is not numeric or 0 then a message box asking for a valid entry is shown Focus is set on the needed txtbox If IsNumeric SP False or SP 0 Then MsgBox Please enter a valid number in Selling Price frmcalculator txtsellingprice focus validation False Exit function ElseIf IsNumeric DP False or DP 0 Then MsgBox Please enter a valid number in Down Paymen
12. ch dealer may have one or more transactions or more transactions Each transaction must Each transaction must belong to one and only one involve one and only one client dealer 21 E Client Letter E The user has the option of selecting a client and printing a pre written thank you letter in Microsoft Word Below is the code behind this form Designed by Stone Code 7001 Option Explicit Private Sub cmdPrint_Click this sub on click opens a Thank you word document placing the string in a placeholder for name and prints the document Dim objWord As Object Dim strName As String validate that there is something in the combobox If there isn t anything prompts for a Client Name If IsNull Me cboName Value Then MsgBox Please select a Client Invalid Client Me cboName SetFocus Exit Sub Else places combobox value in strName strName Me cboName Value create application object Set objWord CreateObject Word Application open template called thankyou2 doc objWord Documents Open d My Documents Thankyou2 doc With objWord make application visible Visible True find bookmark called Name and select it ActiveDocument Bookmarks Name Select with bookmark selected change it to strName Value Selection Text strName End With Print letter in foreground so that it won t close before finishing objWord ActiveDocument PrintOut Background False close document without saving ch
13. elopment DB2 O Designed created managed and deployed an enterprise scale RDBMS using DB2 UDB based on provided business narrative functional specifications and entity attribute information a Utilized JDBC SQL JSP and Stored Procedures to create the back end of a Java application as well as the web based reports required by the client O Performed Database Administration responsibilities including managing data security data integrity backup recovery performance and maintenance Education Applied Information Technology 2001 Post Graduate Diploma in AIT November 2001 Information Technology Institute Portland Bachelor of Science 1997 Biology Major Chemistry Minor Willamette University Salem OR References He is an outstanding student and I highly recommend him both personally and professionally As a student he is among a select few whom not only take the initiative to learn new and difficult concepts but go on to master them completely His understanding of the material was always thorough and in depth This understanding ts only matched by his genuine personality Roland ts very much the team player He not only cares about the task at hand but takes care to make sure everyone on his team does as well In the team environment Roland thrives on learning a subject and then teaching it back to his teammates He is a creative intelligent and thoughtful person who would be enormous asset to whomever he works with
14. evelopment O Creating Active Server Pages and using VBScript User Services VB Forms Web Browser The Logical Design Pattern Above is not concerned with physical implementation but rather defining the abstractions necessary to achieve the appropriate scenarios with the components of the application The Class Diagram Right is a visual tool that assists in documenting the objects including their properties and methods and to define the relationships between the objects including associations aggregations and multiplicity Business Services COM HTML HTTP CCompanyBOS Name CompanyID Phone ddress City State Zip Country Notes Save Company Profile PT SValid CSecurity BOS aU ser ID maU ser Name Password ValidateL ogin Business Objects DCOM Active Server Pages CPositionBOS itle PositionID Description Contact Phone OpeningDate ClosingDate ReasonClosed Status Notes rchiveClosedPosition PlaceA pplicant Data Services Business Object Data Transfer ADO Access 2000 Database CA pplicantBOS Bi Bile Be Ele Bile Ee Ene A pplicantID Save GetSkills IsValid CSkillsBOS wee i pplicantProfile Item GetListPosition Count ListA pplicant FindPosition
15. ew MissingInformationException Please enter a skill name check length of skill name else if saveSkill getSkilIName length gt 20 H throw new StringTooLongException Skill names cannot have more than 20 letters check SkillId if O then call insertItem else updateItem if saveSkill getSkillId 0 for int i 0 i lt this size i check for duplicate names if saveSkill getSkillName equalsIgnoreCase this getElementAt i toString throw new DuplicatesException The Skill saveSkill getSkillName is already in the database insertItem saveSkill else updateItem saveSkill index 17 Web Presence Project Description O Obtaining requirements from clients through interviews with domain experts white papers etc O Developing use cases based on requirements a Creation of a website for a fictional car broker carConnexions using FrontPage 2000 Incorporate VBScript to develop client side validation calculations and make website more interactive O Developing use cases and an Entity Relationship Diagram ERD based on client s requirements for database a pplication using Microsoft Access 2000 O Designing a user interface using Visual Basic for Applications VBA to aid in entry of data into database which included a financial calculator Incorporated ActiveX components SQL queries reports Data Access Pages Allowing clients users to
16. frmcalculator txtinterestrate value frmcalculator txtinterestrate value frmcalculator txtinterestrate value End if End Function gt lt script gt 23
17. guage UML techniques utilized and implemented to ensure good analysis and design for application completion Designed and documented class diagram of 3 tier application using Microsoft Visual Modeler Created a GUIDS document as reference for proper application development O Applied Object Oriented Programming in developing distributable components for client separated application into executable component business logic and data access dll s a Utilized Active X Components SQL and other Microsoft applications such as Outlook and Excel to further enhance the application s capabilities O Designed and integrated Active Server Pages to address client s desire to further distribute their application and make the website more interactive Java Application O Appointed by team to Project Technical lead O Developed a client server application and applet for the Placement Agency in Java Java and Java Beans using JDK and IBM s Visual Age for Java interfaced with a legacy DB2 database using JDBC O Maintained strong Object Oriented Analysis Design and Application Development throughout process Incorporated Model View Persistence design pattern in development of application O Utilized UML diagramming techniques such as CRC cards Class Diagrams and Sequence Diagrams to document and analyze application to further understand potential problems and solutions O Also implemented Extreme Programming techniques to facilitate efficient application dev
18. icantskill and positionskill tables where applicant s skill id positionskill s skill ids strSQL strSQL amp FROM tbiPosition INNER JOIN tblApplicantSkill strSQL strSQL amp INNER JOIN tbiPositionSkill ON tblApplicantSkill SkillIID tblPositionSkill SkillIID inner join position and positionskill table data where positionid s match strSQL strSQL amp ON tbiPosition PositionID tblPositionSkill PositionID group by positionID title status and applicantID strSQL strSQL amp GROUP BY tbiPositionSkill PositionID tblPosition Title tbIPosition Status tblApplicantSkill ApplicantID having status open and applicant id is passed id strSQL strSQL amp HAVING tbIPosition Status open AND tblApplicantSkill ApplicantID amp intId amp order by count of skillids greater first or best fit strSQL strSQL amp ORDER BY Count tblPositionSkill SkillIID DESC mobjdataaccess Connect FindPosition mobjdataaccess RetrieveData strSQL mobjdataaccess Disconnect End Function 10 Active Server Pages Left Registered Virtual Placement Agency Positio applicants can Login via the web and view open positions Below Selecting a Systems Engineer APE yy Consultant Osition and senior Clear Case Engineer x Frogrammer Analyst clicking the SAP Specialist View Position Software Developer Info displays Data Integration Developer the position s software QA Engineer informatio
19. in Security Module passing username if user name is not present error will be raised by module Call mobjSecurity ValidateLogin Me txtUsername Text check password variable value and compare with password textbox if password is incorrect show message in status bar else enable MDI form If Me txtPassword Text mobjSecurity Password Then frmMDI mnufile Enabled True frmMDI mnuview Enabled True frmMDI mnuwindows Enabled True frmMDI tlbmdi Enabled True Unload frmLogin Call ClearStatusbar Else Err Raise LoginErrors InvalidPassword Login Invalid Password End If End If Exit Sub Show Error Check textboxes Message If textboxes are empty Textboxes not empty Call If username not in database ValidateLogin Username found Below Check Password This method queries the database If password does not errorHandler for matching positions for an Password correspond to Call SecurityErrors applicant s skill set correct oo associated Positions are ordered by number wi TASES y username of skill matches for the positon Enable MDI Public Function FindPosition intId As Integer As Variant This function returns a variant array with matching positions for an applicant Dim strSQL As String select position IDs and titles from tblposition and strSQL SELECT tblPositionSkill PositionID tblPosition Title Count tblIPositionSkill SkillIID AS CountOfSkillID inner join appl
20. ion Other options the user has include Users can view applicants that status To close a position l placing applicants who are available match the skill set of the users must supply a close date all with open positions specific position and a reason for closed An Excel Pie Chart showing the User can email applicants with A component called a percent of applicants matching the email addresses Outlook opens DateTimePicker was used for skills of the position can be in the background and sends date validation selected User can also close an messaaes for the user open position P EJ Place Applicant Available Applicants Above Users can add new positions to the database for existing companies Open Positions ID Client Server Programmer Console Game Frogrammer 25 Albert Mary Apoo Apu Budd Willian Cioe Die Data Integration Developer 22 Carfizer Quinn i Game Industry Programmer 25 Left Chase Chevy Information Systeme Manager When placing Clintone Bill 625 200 Oracle Application Analyst 28 an applicant a Dis Mike Oracle Financials Manager 11 Dole Bob Frogrammer Analyst 7 list of available applicants and open positions is displayed Users match an applicant and a position and select a closing date Recruiter Sales 17 RAF Engineer 33 SAF Specialist 27 Dunleavy Michael Gates Darryl
21. l items in database into vector skills corresponding java util Vector companies getDbCompanyManager items getVector ist hox oop through the vector taking each skill and creating a new object reference to insert into the JList for int i 0 i lt companies size i Below The saveItem CompanyData companyX new CompanyData method setDbCompany jobsdb Company companies elementAt 1 validates the companyX setCompanylId getDbCompany getId skill name for 0 companyX setCompanyName getDbCompany getName companyX setCompanyContact getDbCompany getContact or over 20 companyX setCompanyEnrollDate getDbCompany getEnroll characters It companyX setCompanyPhone getDbCompany getPhone also determines companyX setCompanyNotes getDbCompany getNotes based on the ID whether to save add element to list and calls toString method a new skill or addElement companyX update a gt selected skill Perform the saveItem method this method checks to see if save is an add or an update param obj java lang Object param index int public void saveItem Object obj int index throws com ibm ivj eab dab DAException MissingInformationException StringTooLongException DuplicatesException cast obj argument to a SkillData object named saveSkill SkillData saveSkill SkillData obj check if skill name is missing if saveSkill getSkillIName length 0 throw n
22. me as the Dealers website Transactions This along with the utilization of Reports switchboard menus facilitate Loan Calculator ease of use through familiarity and navigability Designed by Stone Code 7001 Edit Transaction menu ans ctic aN t Utilized a drop down Active X Calendar to aid transactionid 11 Sale Price 25 000 00 in proper date CliemiD Schmidt J Lease Purchase Purchase entry Calculator On Dealer ID Manily s Trucks Payment Length 36 Date 2 26 2001 faq Monthly Payments 350 21 Calculator Off A toggle button to open the loan calculator is Hext Record available to the user Previous Record Save Record Undo Record Close Form F oe r rs 20 Er rir irina Oonber IT 1PD1 Klmximrim by Sons Code Arapa An Entity Relationship Diagram ERD was developed before building the database Outlined are the three entities their attributes and relationships This is a report displaying the number of Dealers by Region Queried the database for the information but decided ona more interesting means of presenting the data Again stressing the consistency of design Superimposed query data onto graphical representations of Canada and the US 0 TRANSACTION DEALER Dealeri D Dealer_Name Contact_Name Phone Leng Monthly Payment VIN 5 Manufacturer Each client may have one Ea
23. n If Client server Programmer the applicant is Information Systems Manager interested in the position they can enter their ID and select the Apply option Company Name S AP Tithe Systems Engineer Position ID 4 Description Design and develop specific aspects of SAP HEF Logistics and Financial products Opening Date 05 02 2001 Required Skills 1 UML 2 Project Management 3 Unix Applicant ID Thank you for using Virtual Flacement Agency Java Project Description O Developing a client server application using Visual Age for Java IDE and JDK Developing a response to a Request For Proposal RFP a Utilizing UML diagramming techniques Object Oriented design and analysis Object oriented programming to design and develop application Creating reusable components called Java Beans Using Object Oriented design patterns in creating application Deploying application and creating an applet Writing a user manual and generating documentation through JavaDoc Oooo User Interface Layer Business Logic Layer i Data Access Layer Data Access Beans Java GUI Java Beans D gt Y database The Visual Basic project was redone in Java The project expands on Object Oriented Analysis amp Design by utilizing Unified Modeling Language UML diagramming techniques Above A graphical representation of the n tier application Below Object diagram created based on abstractions of business na
24. ology Major Chemistry Minor Continuously strive to remain current in new technologies to enhance ability in application development Enjoy team collaboration towards discovery and problem solving Employment History Oligos Etc 1997 2000 O Good Manufacturing Processes GMP Certified Facility followed Standard Operating Procedures SOP s stressed quality assurance and documentation of processes in manufacturing of product required constant communication with multiple departments to ensure proper techniques followed throughout production Cross trained in 3 different departments quickly learned multiple skills and assisted different departments when needed Managed multiple customer orders with different requirements and ship dates Excellent time management skills able to operate effectively under pressure Involved in purifying experimental strands of DNA for customers with customized requests resulted in increased satisfaction and customer s willingness for future collaboration Enjoyed experimentation and team work with fellow colleagues to develop innovative solutions to customer needs Customer oriented quality control emphasized accuracy and attention to detail especially for clients involved with Food and Drug Administration FDA Phase I II amp III testing resulted in good customer relationships Authored several Standard Operating Procedures SOP s to facilitate the implementation of new methods in the l
25. riteEmail CSkilIBOS Title SkillID GetSkillList Save Left Upon starting the application the user is required to login using a username Virtual Placement and password Upon successful login the main MDI form functions are enabled and Agency user can proceed Below Here is a sample of the Applicants form The user can add edit applicants to the database Our business rules state that an applicant should at least have a First Name Last Name and Al x Phone Number Aap lcant Intormatinn Applicant Skills Applicant cumenti y available Applicant ID First Hame Jobe i Knight Bob Last Mame Sure I Hating lack 2 Parton Dot Pinon 6053 Yilechez Herne Add Skills Ema Lifer Rnakes com Address 1245 5E Lawelhust Ave Liy Portland Slater Province on mH m x o C Canada Infoematon Systems Manager 1 Cieri Server Programmer 1 SAP BO Consukant 1 Notes Worked as Weenie chef lor SD 14 pears now Desperately uryderermnoloped l erse Ease of use and functionality of application was emphasized throughout application Here For available Applicants the user is able to find open positions which are sorted by number of skills the when viewing applicants only specific buttons are available applicant matche
26. rontPage 2000 VBScript and other tools that they will research and use Students will be required to develop forms and test the application developed for the Web Students will be required to design and construct a relational database that allows users to publish and collect information over the Internet using Access 2000 Team Project 2 Virtual Placement Agency In the first phase of the project students will build a client server database application 1 or 2 tier using the fundamental tools of the Visual Basic 6 0 Integrated Development Environment IDE Students will then take the completed simple client server project and further develop the project in an n tier environment The concepts of Object Oriented Analysis and Design will be introduced and students will apply them in the enhancement of their client server application in an n tier environment Microsoft Visual Modeler will be used in the creation of a complete set of GUIDS documents Once students have designed the project enhancements they will produce Visual Basic 6 0 source code using class modules Students will be introduced to and use ADO SQL ActiveX and MTS technologies to develop the enhanced project In the final phase of the project students will deploy an enhanced n tier application across a LAN and the web using ASP and IIS technologies Team Project 3 Personnel Placement Agency As a model for a large scale real life application this project allow
27. rrative nborderOata ees dobCrderld ppicantData Se JobCrdardane i omoarydd Oompa hare polcanttd SL JobOrderDater sed sasi a ppicantHame hOrderate pened FompanyenrolDate policantCurreritSalarv JobOrderTitle Ompa PAIE icantbesredSaary JhryderF4ralary rrnnanfspotes JobCrderMaxSaary Ppelicanthassword JohOrderStatus toString paicanthotes bOrderNotes acre r 1 D 1 4 SHILEtMncki i eee to SkilListanager nr a J Srsertltemt CompanyLetModel Applicant istModal Sallis ri ied Company beapplicatt Socabalbamt Oh nb Order I a L sss rabewienl1terrsi eee SrabievetpoicantStillst Srsertitern Srebieve IobOrceSkilst Yrsertlktami ormovelten caaltem i Samoveltemt pdsteltert alideteForDuplicatest Supcabaltem otreveAlTtems reertapplicantskil emevealiners retrieved ualihedsoplicarts SemovespeicantSal SrabieveCompatyJobCrderst Ssayoltomi reertJoborder skill Scavetteni Syalidater orOusicab st Sremovelobord rSlal 4 rccttitomc Semoveltent Syoclabatbernt Seatieve Mites warata i aidatesForDuplicates SgotCompaifamet Add Applicant l 1 Na w Applicant Inf fc ZN t lew Applian Ee nt 1 ur Above The sequence diagram is a visual interpretation of how a specific Use Case is CanceL implemented This New User Existing user includes indicating responsibilities of each class
28. s for that specific position Upon clicking add the applicant s status is set to available and The frame ete the ocr all form elements are emptied Here is a sample situation of originated is highlighted in red Focus is also set on specific error handling form validation that was implemented error T Vitaal Placement Agency Applicants ME al D T Saw DD a Applicant 5kills Upen Postion Mateh State Provinces JAK J USA Zip Postal ade Canada is Find Positron A specific error message is shown to user in Status Bar Soft validation used instead of message boxes RENE Industry Skills Position Applicant Skills windows N T ASP C ClearCase Cobol Cold Fusion DB Dreamweaver Fortran GUIDS Methodology HTML Java Add New Skill Cancel f Vinal Placement Agency Positions faa x Pile View Windows usss n enue mE PSA La format 7 Aequired Position SEills Positron ID 14 Project Management Cold Fusion Ww Ite Sun Solaris Manages k ContactName Sytvia Brule Desetiption Spelen Adnninietatce to jori Chase Chewy 21 E pen iong goug of srdhyikus gt rakcus e T A Fast CSS SSES Tenile Captain 1 Notes Harting Jackie 1 Carlier Quinn 1 s Eom Status P Email Applicant Each position has a posit
29. s students to demonstrate proficiency in Java Technology using Visual Age Object oriented design and development will help students gain an understanding of the potential of the Internet for business applications Students will use a Virtual Placement Agency problem from Visual Basic and create a Java based solution Students will discover the potential for powerful 3 tier architecture enterprise computing capabilities Team Project 4 Imagine Project Tracking System Phase 1 examine enterprise development the various DB2 UDB tools used throughout the module creation of DB2 users through NT User Manager database design SQL and database object creation Phase 2 apply acquired java skills to use JDBC Java Server Pages and Stored Procedures to accomplish the database connectivity Phase 3 This phase will expose you to various database administration tasks such as security managing your data data integrity backup and recovery performance and maintenance Visual Basic 6 Project Description O Developing a distributable client server application using Microsoft Visual Basic 6 0 Deployed across the Internet and connected to a Microsoft Access 2000 back end using COM MTS and IIS B Diagramming models using UML B Using GUIDS methodology to create documentation for use in application development B Developing GUI using proper GUI standards B Using object oriented analysis and design as well as component based d
30. t frmcalculator txtdownpayment focus validation False Exit Function ElseIf IsNumeric IR False Then MsgBox Please enter a valid number in Interest Rate frmcalculator txtInterestRate focus validation False Exit Function ElseIf IsNumeric Months False or Months 0 Then MsgBox Please enter a valid number of months frmcalculator txtmonths focus validation False Exit Function Else Validation True End If Check to see if IR is 0 If so then 0 becomes 0 000000001 to calculate the Payments with an interest rate as if it were 0 yet not break the divisible by zero rule If IR 0 Then IR 0 000000001 Else If frmcalculator txtinterestrate value gt 1 Then Selling Price Humber of Afb Pres Purchase Payment e670 49 402 30 IX 2 000 00 fo ag Clear Form A loan calculator was available in both the application and the intranet designed by our team Utilized VBScript to add the functionality required to this page Here is the VBScript code behind calculating the lease payment frmcalculator txtinterestrate value frmcalculator txtinterestrate value 100 Elself frmcalculator txtinterestrate value lt 0 Then MsgBox Please enter a valid Interest Rate frmcalculator txtinterestrate value 0 frmcalculator txtinterestrate value focus exit function Else frmcalculator txtinterestrate value frmcalculator txtinterestrate value End If IR
31. th i newPass newPass password i query db for applicant passing an userid and password getDbApplicantManager select where ID UserID and PASSWORD newPass java util Vector applicant getDbApplicantManager items getVector check vector size if empty throw exception if applicant size 0 throw new InvalidLoginException Invalid UserID or Password please try again else if applicant is there create new applicantData object and set ListModel s applicantData object jobsdb Applicant dbApp jobsdb Applicant applicant get 0 ApplicantData app new ApplicantData app setApplicantCurrentSalary dbApp getCurrentsalary app setApplicantDesiredSalary dbApp getDesiredsalary app setApplicantId dbApp getId app setApplicantName dbApp getName app setApplicantNotes dbApp getNotes app setApplicantPassword dbApp getPassword app setApplicantPhone dbApp getPhone setApplicant app 16 retrieves all companies from database and adds it to the list model Left The exception DAException If data access exception occurs when accessing database retrieveAllItems f public void retrieveallItems throws DAException method obtains all companies retrieve all the Companies in the db sorted by name from the getDbCompanyManager select Order By Name database and _ _ I _ populates the using getVector method place al
Download Pdf Manuals
Related Search