BCIS 3610

profilenathanqiu
Assignment1_tables.xlsx

Department

Department
DNO Dname Address City State Zip
1 Accounting 762 Destiny way Westlake TX 76062
2 Finance 762 Destiny way Westlake TX 76062
3 Sales 850 Cambell Rd Richardson TX 75080
4 I.T. 2210 Main St Dallas TX 75023
5 Marketing 850 Cambell Rd Richardson TX 75080
6 HR 762 Destiny way Westlake TX 76062
7 Legal 2210 Main St Dallas TX 75023
8 Facility Mgmt 762 Destiny way Westlake TX 76062

Employee

Emp ID Name Prefix First Name Middle Initial Last Name Gender EMail DOB HireDate Salary SSN PhoneNo UserName Title DNO
677509 Drs. Lois H Walker F [email protected] 3/29/81 11/24/03 168251 467-99-4677 303-572-8492 lhwalker Sr. Director 5
940761 Ms. Brenda S Robinson F [email protected] 7/31/70 7/27/08 51063 537-71-4566 225-945-4954 bsrobinson Accountant 1
428945 Dr. Joe W Robinson M [email protected] 6/16/63 8/3/16 50155 025-92-3584 219-904-2161 jwrobinson Accountant 1
408351 Drs. Diane I Evans F [email protected] 12/4/77 4/16/99 180294 314-35-9851 215-793-6791 dievans SVP Marketing 5
193819 Mr. Benjamin R Russell M [email protected] 4/17/77 7/25/13 117642 121-98-7248 262-404-2252 brrussell Sr. Manager 4
499687 Mr. Patrick F Bailey M [email protected] 9/27/82 7/22/05 72305 439-99-7721 319-812-6957 pfbailey Programmer 4
539712 Ms. Nancy T Baker F [email protected] 6/13/95 9/14/16 98189 641-29-2071 229-336-5117 ntbaker Project Manager 4
380086 Mrs. Carol V Murphy F [email protected] 6/30/58 1/28/83 60918 423-67-7023 216-336-0009 cvmurphy Marketing Analyst 5
477616 Hon. Frances B Young F [email protected] 6/9/59 4/27/94 121587 028-92-8912 210-819-9765 fbyoung Sr. Attornet 7
162402 Hon. Diana T Peterson F [email protected] 11/13/87 2/17/14 43010 512-33-6767 479-783-5656 dtpeterson Recruiter 6
231469 Mr. Ralph L Flores M [email protected] 2/5/75 4/14/09 118457 302-15-0130 316-280-2864 rlflores Sr. Attorney 7
153989 Prof. Jack C Alexander M [email protected] 5/19/95 1/5/17 82965 428-99-9413 702-603-3769 jcalexander HR Manager 6
386158 Mrs. Melissa Q King F [email protected] 2/24/72 11/24/15 166892 277-17-9106 216-605-3731 mqking SVP HR 6
301576 Hon. Wayne G Watson M [email protected] 6/26/96 7/19/17 92758 011-94-6649 701-231-9370 wgwatson Sr. Recruiter 6
441771 Mrs. Cheryl O Scott F [email protected] 2/23/58 11/26/90 92220 596-94-2279 215-288-9345 coscott Manager Funds 2
528509 Hon. Paula G Diaz F [email protected] 8/22/66 8/22/94 152654 234-57-7671 252-531-7641 pgdiaz Fund Director 2
912990 Mr. Joshua T Stewart M [email protected] 5/18/70 9/2/02 184896 755-07-3676 217-279-9342 jtstewart Finance Chair 2
214352 Ms. Theresa G Lee F [email protected] 12/5/92 1/19/15 197537 055-02-9969 319-553-8919 tglee CFO 2
890290 Hon. Julia S Scott F [email protected] 7/15/59 2/23/05 141518 251-99-1941 423-939-1010 jsscott Director Audit 1
622406 Mr. Thomas Q Lewis M [email protected] 10/4/67 6/7/98 73862 467-99-2604 314-679-3697 tqlewis Audit Analyst 1
979607 Ms. Carol J Edwards F [email protected] 12/14/94 4/25/16 93967 316-35-9870 225-283-4295 cjedwards Fraud Analyst 2
969580 Prof. Matthew L Turner M [email protected] 10/26/93 2/7/16 52237 598-92-1988 236-972-7624 mlturner Auditor I 1
426038 Hon. Joan C Stewart F [email protected] 11/20/72 12/30/09 111673 429-99-6443 216-637-6800 jcstewart Investment Advisor 2
388642 Mrs. Ruby R Rogers F [email protected] 5/1/80 8/30/13 160623 236-55-0172 423-231-6507 rrrogers Fund Rel. Mgr. 2
560455 Ms. Carolyn V Hayes F [email protected] 3/10/58 7/3/01 42005 730-28-1350 239-882-8784 cvhayes Admin Assistant 1
477253 Mrs. Anne L Russell F [email protected] 7/29/89 11/24/13 103160 456-99-5619 605-635-1306 alrussell Real Estate Fund Mgr. 2
263480 Hon. Daniel K Cooper M [email protected] 1/1/90 3/6/14 153790 181-86-2024 701-510-8162 dkcooper BioTech Fund Mgr. 2
683826 Mr. Roger L Roberts M [email protected] 7/7/69 1/29/09 129625 120-98-6493 206-497-3141 rlroberts Tech Fund Mgr. 2
474599 Drs. Maria W Walker F [email protected] 3/19/75 10/1/98 48944 447-27-3175 423-668-5506 mwwalker Mainframe Programmer 4
335732 Ms. Brenda M Butler F [email protected] 12/6/63 8/20/87 60508 282-15-6434 480-814-8284 bmbutler Programmer Analyst I 4
329752 Hon. Lillian X Brown F [email protected] 5/12/81 4/13/15 67251 249-99-8821 239-812-9041 lxbrown Sales Associate 3
893212 Ms. Amy B Howard F [email protected] 6/16/81 6/1/03 112715 686-24-2843 803-613-3168 abhoward Manager Portfolio Sales 3
621833 Mr. Gregory X Edwards M [email protected] 8/31/93 9/30/15 169245 010-94-6817 503-256-9654 gxedwards Director IRA Sales 3
456747 Mr. Roy Z Griffin M [email protected] 5/8/91 8/23/12 170895 358-08-7660 219-506-9378 rzgriffin Director Portfolio Sales 3
278556 Prof. Richard Y Mitchell M [email protected] 7/28/93 8/18/16 122226 013-94-5886 205-621-5884 rymitchell Manager IRA Sales 3
333476 Hon. Mary P Wilson F [email protected] 12/1/67 12/22/91 109394 198-84-0652 423-937-8660 mpwilson Sr. Sales Associate 3
218791 Mr. Aaron N Price M [email protected] 2/10/69 7/3/97 54402 491-29-5152 219-287-8926 anprice Marketing Analyst 5
134841 Ms. Donna R Brown F [email protected] 9/14/83 7/17/13 129836 544-81-5182 212-434-7910 drbrown Sr. Sales Associate 3
726264 Hon. Carl N Collins M [email protected] 12/22/73 6/9/07 162159 544-81-6171 479-740-7633 cncollins Director Brokerage Sales 3
766610 Ms. Joyce E Jenkins F [email protected] 8/22/61 5/14/10 119321 695-16-6506 262-455-4187 jejenkins Sr. Sales Associate 3
923947 Ms. Mary G Bryant F [email protected] 6/21/62 5/20/04 155442 491-29-7461 319-827-3516 mgbryant VP Budgets 2
227922 Hon. Amanda M Hughes F [email protected] 7/29/82 4/19/07 114257 311-35-2540 225-544-9700 amhughes Manager Budgets and Fin 2
265813 Hon. Jack E Campbell M [email protected] 1/4/85 7/29/07 186280 047-15-1537 316-499-5737 jecampbell SVP Infrastructure 4
247137 Mr. Alan E Rivera M [email protected] 12/11/78 6/7/06 154810 399-31-7149 423-277-6819 aerivera VP Storage and Computing 4
407061 Ms. Elizabeth Q Jackson F [email protected] 8/15/64 1/19/05 85420 660-24-4434 603-568-6118 eqjackson Sales Associate 3
226714 Drs. Nancy L Davis F [email protected] 11/14/83 8/25/12 94986 224-99-5928 219-610-3067 nldavis HR Compliance Manager 6
702813 Mr. Ernest D Martinez M [email protected] 11/9/89 1/24/16 172098 672-48-7749 479-951-4138 edmartinez Patent Attorney 7
524896 Ms. Judy Y Hernandez F [email protected] 3/25/61 12/27/11 133332 534-71-4481 316-736-6126 jyhernandez Director Insights 4
363065 Drs. Nancy L Jones F [email protected] 11/10/93 10/16/15 61924 681-24-3165 212-825-1930 nljones Accountant 1
704709 Dr. Harold Z Nelson M [email protected] 12/24/84 8/23/11 156194 456-99-2066 217-555-9216 hznelson Board Advisor
461593 Ms. Nicole O Ward F [email protected] 12/12/64 1/23/89 95673 196-84-2551 231-761-7861 noward Board Advisor
392491 Mrs. Theresa R Murphy F [email protected] 12/30/87 8/3/10 51015 249-99-8801 907-356-1555 trmurphy Admin Assistant BOD
495141 Drs. Tammy B Young F [email protected] 3/22/79 4/25/15 93650 771-02-7046 231-290-3075 tbyoung Board Advisor