Sql Server
Resume:
Joe Celko
Voice: 512-***-****
email: *********@*********.***
website: www.celko.com
EMPLOYMENT HISTORY:
Self-employed author & consultant; Austin, TX
Judge for junior division (math) of Austin's Regional Science Festival 2012, 2013
Presenter (2 sessions) at Data Modeling Zone conference in Baltimore, MD 2013 Nov
Keynote Speaker for PostgreSQL Europe Conference, Prague, Czech Republic, 2012 Oc
Speaker at SQL Saturday #125 in Oklahoma City, OK
Adjunct Math professor (ITT-Tech) in 2012, 2013
Contracts for ninth book in MKP Series and Math book for CRC Press due 2013
Volunteer Math coach (Austin Partners in Education) at Burnett Middle School, 2012 Jan
Presenter (2 sessions) at SQL Saturday #97, Austin 2011,2012 Oct
Presenter (2 sessions) at SQL Saturday, BI Edition #86, Tampa, FL 2011 Nov
Author for Red Gate Software's Simple-Talk newsletter.
Contract employee with uShip.com. Bring DB up to ANSI/ISO Standards, teaching SQL and tuning code on SQL Server 2008 (2010-2011).
SQL programmer for ZogoTech Community College software company (2010)
Voter Registration Database for State of Texas as contractor for Nilior (2009 Dec)
Finished eighth book Data, Measurements and Standards in SQL,
Finished second edition of Trees and Hierarchies in SQL 2011 Nov
Finished the fourth edition of SQL FOR SMARTIES
Consulting for Bride Water Hedge fund (2 day SQL Class)
Consulting For Altitude Investments (patent evaluation)
One or more articles per month for Simple Talk, a publication of Redgate Software.
Contract with Nilior to look at the Voter Registration system database for Texas
DB design for Ogre Systems machine shop project
Speaker at SQL Saturday #13 in Atlanta
Speaker at SQL Saturday #14 in Orlando
Speaker at SQL Connection in Las Vegas
Speaker at PASS in Seattle
2007 Dec - 2008 Sep
Prologic Technology; Austin, TX
The company does software for Texas school district from the state & federal level down to their K-12 classrooms. The problems I was hired to fix are (1) multiple database platforms (2) improved portable schema designs (3) internal SQL training and (4) customer SQL training. I was an in-house consultant on a W-2 a good benefits package less than 5 miles from my house. I left when the school year started and the new package was ready for release.
began my eighth book on Data Standards in 2008
Consulting for Chilton Investments in Stanford, CT.
Speaking at "SQL Saturday!" events in Florida.
Dec 2007 - 2004 Aug
Self-employed author & consultant; Austin, TX
* Worked for Daman Consulting at AMD on a manufacturing database.
* Did a 30-minute email data mining project for Corky's BBQ mail order packing operation in Memphis, TN; paid in smoked ribs (really! See article at www.tdan.com).
* Taught Texas-42 on a Royal Caribbean Cruise (domino game played only in Texas).
* Advisor to Cigito on their relationship data mining tool. Set up tests to compare it to regular data mining in pure SQL.
* Speaker for DB Examiner at CA World - 2005.
* Speaker at PASS-2005 and PASS -2006
* Speaker at SAS Conference Austin - 2007
* Wrote White Papers for Sunopsis data transfer software (France)
* Designed schema for SOX (Sarbanes-Oxley) compliance software for an Austin company.
* Reviewed customizable SQL Schema for an Austin company that develops personnel systems for colleges.
* Reviewed customizable SQL Schema for an Augusta, GA company that develops disaster planning software.
* Taught math survey course evenings at Virginia College at Austin for half semester.
* Assorted speaking engagements for user groups and conferences.
* Taught two weeks of SQL classes for ChemTech/SEIMENS in Rio and Belo Horizonte, Brazil June 2006.
* Taught one week SQL classes for ShipNet in Oslo, Norway October 2006
* Teaching on-line database design classes for MySQL, Sweden, November 2006.
* Guest speaker for St. Edwards University database class, then team teacher
* Monthly columnist or INTELLIGENT ENTERPRISE on-line edition
Completed SQL PROGRAMMING STYLE in January 2007. Finished work on the third edition of SQL FOR SMARTIES in February 2005. Wrote OLAP & ANALYTICS IN SQL and did a second edition of SQL PUZZLES & ANSWERS. Wrote 20 more columns for www.dbazine.com, a feature for DR. DOBBS JOURNAL and miscellaneous short articles in various places. Got contract for seventh book in 2006 December. Austin IEEE chapter and CACTUSS in 2006. Seventh book, THINKING IN SETS, in edit.
2002 Nov - 2004 July
Neumont (nee Northface) University; Salt Lake City, UT
Vice President, RDBMS. Designing and teaching IT courses at a start-up for-profit college with graduate and undergraduate programs. The original curriculum was for an Executive MBA to be delivered on the Internet and in week long intensive camps. The unique features were: (1) direct access to "name brand" faculty and (2) team learning and leadership skills via project-oriented learning.
A venture capital firm acquired controlling interest in late 2003. The MBA program was shelved and we began a rushed undergraduate cirrocumuli. The goal of the new program was to produce IT developers with a BS degree, Microsoft and IBM certifications in 28 months of 40 hour weeks. The project team approach was retained. After the first cohort of students finished their quarterly exams in April, all but two members of the teaching faculty were fired. I was retained as a consultant for a three-month contract scheduled to end in 2004 July.
My fifth book, TREES & HIERARCHIES IN SQL, was released in 2004 April.
2002 May - 2002 Oct
Self-employed; Austin, TX
Independent contractor doing training, writing, speaking and SQL system tuning. Contracted a series of eight articles to BMC's www.dbazine.com website.
2001 Dec - 2002 May
Data Junction; Austin, TX
Employed in the Professional Services Division, but used mostly by marketing department for trade shows. Taught short internal SQL class, did minor coding, and designed an advertising novelty puzzle. Company bought by Pervasive Software.
2001 Jun - 2001 Dec
Self-employed; Austin, TX
Independent contractor doing training, writing, speaking and SQL system tuning. Regular columns in INTELLIGENT ENTERPRISE (CMP, United States) and DB/M (Array Publications, Netherlands).
2000 Sep - 2001 Jun
Trilogy; Austin, TX
Hired as database expert just before the company lost money in multiple failed "dot-com" ventures. Fired as part of second round of downsizing. Taught two SQL classes and then sat around as a trophy employee because the founders wanted to have someone with a reputation who was over 23 years of age.
1997 Aug - 2000 Sep
Self-employed; Atlanta, GA
Independent contractor doing training, writing, speaking and SQL system tuning. Rates vary between $1000 to $2000 per day plus expenses for on-site work.
* Giga's Middleware Choices II Conference. Taught SQL workshop.
* Yellow Freight Lines (Overland Park, KS)
* PowerBuilder and Sybase User Groups of Switzerland (Switzerland). Taught SQL classes.
* Precise Entertainment (Los Angeles, CA). Database design help for an Internet shopping for media related collectible merchandise.
* The Associates (Dallas, TX)
* HealthNet (Kansas City, KS).
* A. C. Nielson Media Research Clearwater, FL
* DISA (Defense Information Systems Agency) in Falls Church, VA
* AOL (Tucson, AZ)
* Sunquest (Tucson, AZ)
* J.P. Morgan (Dallas, TX)
* Lucent Technology (Westminster, CO)
* Helsinki Business Polytechnics, Institute of Information Technology (Helsinki, Finland); guest lecturer and teacher for the Computer Science department.
* State Street Institute (North Quincy, MA)
* Certitude Medical systems (Fairfax, VA) tune SQL Anywhere code in a medical utilization system. I was able to eliminate bottle necks and get tenfold thruput improvement in at least one critical SQL code in their medical utilization system.
* Speaker for Miller-Freeman seminars (San Mateo, CA), Mantel (Sao Paulo, Brazil), and Year 2000 Conference (Istanbul, Turkey).
* Taught Intro and Advanced SQL at NASA's Johnson Space Center (Houston, TX)
* Taught C/S Bootcamp for Deloitte-Touche Trainees.
* DB consultant to BRTN, the Belgium Dutch Language public broadcasting
system (Brussels, Belgium).
* Advanced SQL classes at IST Software (V xj, Sweden). Invited lecturer at Karlskrona University (Karlskrona, Sweden).
* Retained consultant for Sterling Software and Microsoft Jet engine group.
* Investigator for trucking industry firm (theft of data).
* Sybase SQL class for Liberty Mutual Life Insurance (Danvers, MA) for Soaring Eagle as part of a training series for Irish programmers.
* Database design for Precision Entertainment (Los Angeles, CA)
* Cleaning up code in the research department databases for A. C. Nielson (Clearwater, FL).
* Internal training program at Goldman-Sachs in New York City.
* Intro to MS SQL Server course at State Street Institute; North Quincy, Massachusetts
* One day Tutorial on "SQL for Smarties" in Orlando, FL for Giga's Middleware Choices II conference:
* Sybase Fast Track for AOL and Sunquest (Tucson, AZ)
1996 Oct - 1997 Aug
Northern Lights Software Ltd; Atlanta, GA
Guru (actual title!) for company specializing in client/server systems, SQL training, database and data warehouse design (home office based in New York state).
* Motorola Medical systems (Tempe, AZ) port from UNIX and Sun workstations to Windows based client/server systems.
* McGraw-Hill educational testing division (Monterrey, CA) repairing client/server test scoring system installed by Microsoft Consulting Services. Team was able to eliminate deadlocking problems and get tenfold thruput improvement in critical SQL code in their transaction processing operation.
* Customized advanced SQL class for Liberty Mutual Life Insurance (Portsmouth, NH) as part of a training series by Northern Lights. Solved two major production problems during question and answer period.
* Progress Software (Hardford, CT) advised on features for new database product as part of $100 million rollout.
* SQL Server Training class for Northeastern Utilities (Wethersfield, CT).
* Represented Northern Lights at ANSI X3H2 Database Standards Committee meetings, user group meetings, conferences and seminars.
1995 Jan - 1996 Oct
OSoft Development Corporation; Atlanta, GA
Senior staff consultant for company specializing in SQL databases and data warehouse systems.
* Analysis of new checking account system for Microbilt (Atlanta, GA). This was a client/server product for local branches which had to interface to Hogan and other mainframe banking software.
* Reviewed SQL Server project for Microsoft (Redmond, WA).
* Taught advanced SQL class for Oracle database group at Paychex (Rochester, NY). Solved several minor production problems during question and answer period.
* Taught SQL Server class at William James & Associates (Wheaton, IL), a specialized financial software company; one-day follow on advanced SQL tricks.
* Designed parts of a data warehouse for Brown & Williamson Tobacco Company (Macon, GA).
* Product adviser to Pilot Software's Lightship data mining product and Sterling Software's SQL query generator.
* Represented OSoft at ANSI X3H2 Database Standards Committee meetings, user group meetings, conferences and seminars.
1994 Sep - 1994 Oct
DRT Systems International; Westchester, IL
Senior manager for a subsidiary of Deloitte-Touche specializing in client/server systems.
* Surveyed the IRM (Information Resources Management) section of Nissan Motor Corporation in Torrance, CA.
* Presented overview of the SQL-92 standard to the staff of the Deloitte-Touche Chicago office.
1992 Mar - 1993 Feb
M&T Publishing; San Mateo, CA
Technical editor for DBMS magazine, telecomuting from Los Angeles (full salary, but my own hours). Edit materials for technical correctness, write regular monthly column, "SQL Explorer" and quarterly white papers. Retained as columnist when M&T was bought out by Miller-Freeman Publications
1991 Dec - 1992 Feb
Netbase Computing Inc.; Torrance, CA
Small consulting firm doing SQL server based downsizing projects and teaching classes.
* Designed blotter system for Dabney-Resnick, a junk bond brokerage firm, using SQL Server and JAMM for front end. Client company was mostly former Drexel-Burnham-Lambert employees and senior management.
1990 Nov - 1991 Sep
Nissan Motor Acceptance Corporation; Torrance, CA
(Contracted thru National Systems Associates) Consultant on automobile loan processing system.
* Database design and simulation modeling (SimScript) of data entry and loan application processing workloads. NMAC was consolidating regional loan application offices into a central operation in Dallas, TX and then leaving Los Angeles. Model was used for planning the move.
* Taught SQL training classes for DB2 and XDB users. Helped port DB2 from the mainframe onto PC platforms.
* Discovered why a first-time car buyer loan program lost all the profits for NMAC for a three year period. Used cluster analysis data mining tool.
* Other statistical work on loan approval process and financial systems.
1990 Mar 1990 Mar
Amgen; Thousand Oaks, CA
(Contract thru P. Murphy & Associates) Consultant for drug manufacturer as database designer for sales department system and SQL trainer. Informix/SQL system on Sun workstations under Sun/OS (Unix).
1990 Jul - 1990 Nov
Shop Television Network; Los Angeles, CA
Senior programmer on television show tracking system for cable shopping network. Using Informix/SQL and assorted utility programs under networked Xenix and SCO Unix systems. Built full E-R model for new system.
1990 May - 1990 Jul
Chambers Environmental; Newport Beach, CA
(Contract thru Emjay Computer Services) Consultant at Chambers Environmental for enhancements to manufacturing system package. Written in Progress 4GL and relational database, running on HP-9000 under HP-UX (Unix).
1989 Nov - 1989 Dec
Southern California Edison; Rosemead, CA
(Contract obtained thru MCS Computer Services) Consultant for design of textbase system for labor relations grievance procedures using IBM PC's and mainframes. Database packages used on part of project included DB2 with CSP and design work with IEW.
1989 Sep - 1989 Nov
Getty Museum Art History Program; Santa Monica, CA
Program provides text database system for art historians and architects. Assigned to geographical location project. Equipment includes Britton-Lee IDM machine, Compaq PC's and Sun workstations. Database packages include Sybase, Britton-Lee, ORACLE, Paradox and Unify.
1989 Jan - 1989 Sep
UCLA Extension School; Los Angeles, CA
Teaching occasional evening classes in the Computer Science program in the Engineering Extension School. An advanced database course on ANSI SQL-89, and the forthcoming ISO and ANSI standards in 1989. A data modeling course in 1990.
1989 Jan - 1989 Mar
Rockwell Aerospace; Downey, CA
(Contract thru Commercial Programming Services) Consultant at Rockwell Aerospace in Downey. Designed internal Software Engineering course and video taped parts of the material. Originally hired to do software metrics research project.
1985 Jul - 1988 Dec
Northrop University; Los Angeles, CA
Assistant professor teaching and developing courses in database (ORACLE), C programming, software engineering (Excelerator, Design Aid, POSE and Logic Gem) and compiler writing.
1984 Sep 1995 Jul
National Systems Associates; Scituate, MA
Part-time consultant for firm based in Massachusetts, which has operations in Los Angeles and other major cities. Some of the more interesting assignments included, but were not limited to, the following:
* Bingo game tracking database system for professional gambler. Written in Pascal on IBM PC with Northrop University students.
* Nucleus International (formerly Marcus Systems) as SQL consultant for proprietary relational database engine. Company is now part of Sands Technologies in Canada.
* FirstInterstate Bank, conversion of remittance banking system to new equipment. Custom hardware and software built into check handling equipment feeding ORACLE database on VAX.
* VM-1, designed a textbase system for financial records on midsize IBM computer for FBI contract. The system was used in criminal investigation of the Savings and Loan collapse.
1984 May - 1984 Sep
Advanced Technology Development Center; Atlanta, GA
Assorted positions with ATDC companies. ATDC is an umbrella organization which provides space and services for start up companies in the state of Georgia. Housed at Georgia Tech, but sponsored by the State of Georgia.
1982 Mar - 1984 Mar
US Army Computer Systems Command - AIRMICS; Atlanta, GA
US Computer Systems Command software research group. The primary concern of AIRMICS (Army Institute for Research in Management Information & Computer Sciences) is improved software productivity, in particular tools for easing maintenance, rapid prototyping and applications of software metrics. Duties included monitor contracts, writing research proposals, and conducting independent research work. Worked with Plexus and Onyx systems under Unix, wrote short software tool programs in "C". Proposed an analyst workbench for personal computers before CASE was popular; not implemented. Civil Service position GS-12 and also carried Georgia Tech faculty status. Secret Level clearance, certified Contract Officer Representative (COR).
1981 Jun - 1982 Jan
Software Sciences Inc.; Atlanta, GA
Systems Analyst for British-owned company that marketed small systems for bookstores and other inventory systems.
1979 Aug - 1981 Mar
Georgia Tech Engineering Experiment Station; Atlanta, GA
Research Scientist in the Computer Science and Technology Lab. Wrote parts of grant proposals, technical manuals and do other design work as needed. Position carried Georgia Tech faculty status. The work was made up of small projects lasting from a few months to a year. Non-classified projects included:
* Database for information on bridge and steel structures coating performance (storage and retrieval of non-homogeneous records)
* Computer simulation for the design of interactive dialogues for AIRMICS (team leader)
* Conversion of statistical pattern recognition package to a PDP-11 (one-man project).
1979 Mar - 1979 Aug
Woodbury Business Forms; Atlanta, GA
Programmer for one-man data processing department in twenty man company. Used modified Data General Nova, with an odd brand of BASIC for general business applications.
1978 Dec - 1979 Feb
Fulton Data Systems, Fulton National Bank; Atlanta, GA
Programmer on a Honeywell 6000 in FORTRAN for a bank-owned time-share company. Worked on a labor management program for a construction company. Bank sold the business to an outside firm.
1978 Jun - 1978 Nov
Georgia Medical Care Foundation; Atlanta, GA
PSRO Data Manager for a state-wide HEW grant project. The function of a PSRO (Physicians Standards Review Organization) is to review the medical care and cost for federally funded patients. The approach taken in the design was to build a large database, and then perform sequential analysis on cost and length of stay.
1976 Sep -1978 Jun
Department of Administrative Services; Atlanta, GA
Programmer on the mini-computer section of the centralized state computer services agency. Part of team that installed State Crime Laboratory database system. The computer used was an HP3000, with IMAGE/3000 database software. The project finished ahead of schedule, bought an extra tape drive with leftover funds, and returned $9,000 in unused funds to LEAA.
1975 Sep - 1975 Nov
Flowers Baking Company; Thomasville, GA
Programmer on a project to connect a set of Nova mini-computers to a mid-sized Burroughs computer over phone lines to tie baking plants to the company headquarters.
1974 Dec - 1975 Sep
Indiana Department of Mental Health; Indianapolis, IN
Systems Coordinator of a DEA grant project to catalog all existing drug and alcohol abuse programs in the state. Involved statistical analysis of "street traffic" and demographic data.
1974 Sep - 1974 Dec
Cato Systems; Marietta, GA
Wrote commercial application on a Data General Nova mini-computer for turnkey house.
1973 May - 1974 Sep
Department of Offender Rehabilitation; Atlanta, GA
Statistician for the Research section of the state prison system. Heavy use of demographics, statistics, experimental design, psychological scores, and research skills. Used SPSS, Easytrieve, FORTRAN and other software tools on assorted computer equipment at Universities and at Department of Administrative Services.
1973 Jan 197 3 May
Technical Analysis Corporation
Atlanta, GA
Wrote commercial application on a Data General Nova mini-computer for turnkey house. Used FORTRAN under RDOS operating system.
1970 Jan - 1971 Dec
State Highway Department
Atlanta, GA
Programmer trainee in the Road Design section. Used FORTRAN on an IBM 360 for engineering problems. Heavy calculus.
EDUCATION:
Assorted elementary schools in the United States and US Army schools in the United States and West Germany.
Sylvan Hills High School, Atlanta, GA - 1965
Won first place in Atlanta Science Fair for original work in Symbolic Logic. Paper is referenced in Martin Gardner's LOGIC MACHINES AND DIAGRAMS second edition, University of Chicago Press, 1982. National Science Fair prize of summer job at Pittman-Dunn Research labs in Philadelphia.
B.S. in Mathematics, Georgia State University - 1972
Large number of credits in statistics, followed by discrete mathematics.
MS in Mathematics, Georgia State University - 1979
Thesis: "An Algebra of Program Control Structures". Developed an algebra for structured program transformations.
MS in Information and Computer Science, Georgia Tech - work terminated in 1982 due to end of evening program. Total of 50 quarter hours earned. Thesis published as "Time Token Design Methodology", a refereed paper in the Wiley Interscience Journal SOFTWARE: PRACTICE & EXPERIENCE.
M.B.A. with specialty in Information Science, Georgia State University - Unfinished
Other Training:
DEC course in RSX11/M Operating system 1978
Yourdon Design and Analysis Courses 1979
InfoTech "Beyond Structured Programming" Seminar 1979
HP courses in MPE and IMAGE/3000 1979
Ken Orr Design and Analysis Courses 1981
IST/McAuto Design and Analysis Courses 1982
Contract Officer Representative (COR) course 1982
UCLA extension school instructor training courses 1990
Microsoft SQL Server courses 1992
Courses Taught :
See presentations in Publication credits list
STRUCTURED DESIGN & ANALYSIS - International Software
Engineering of Birmingham, AL.
INTRODUCTION TO DATA PROCESSING - Clayton Junior College
DATA MODELING - UCLA Engineering Extension
INTRO TO DB2 - IBM Consulting Services at Mazda
Consulting pn SQL Products for Vendors:
Borland International (Interbase)
Brio (Brio Query)
Coromandel Industries (VDB)
Dunn & Bradstreet (Pilot Software)
FFE (FirstSQL)
Microsoft (MS SQL Server 6.0)
Nucleus International (Nucleus)
ProLogic (Probe)
Sterling Software (Clear Access)
WATCOM (WATCOM SQL)
ORGANIZATIONS:
ACM
Member since 1972. Publications coordinator for Southeastern Regional Conference 1978. Chairman for Southeastern Regional Conference 1981. Invited speaker for ACM Tampa chapter's Professional Development seminar 1983 and 1984. Student chapter Advisor at Northrop University 1986. Vice Chairman Los Angeles SIGPlan, 1989-90. Vice Chairman Los Angeles SIGsoft, 1989-90. Invited speaker at Cal State Northridge, Nov 1988.
Mensa
Regional Gathering chairman 1977 and 1978.
Atlanta Chapter president 1974.
IQ is 155 on the Cattel scale (top 1% of population).
Science Fiction
Co-Chairman for DeepSouthCon 1970, 1972, and 1974.
OTHER EXPERIENCE:
Author of over 750 articles in the computer trade press, having written and edited several regular columns for commercial and academic publications. (See separate publication credits).
Observer for the ANSI X3.J6 BASIC language standard committee.
Member of the ANSI X3.H2 Database Standards Committee. Part of SQL language standard effort.
Part owner in three bookstores 1973 to 1974.
Finalist in the Fourth Arrango International Furniture Design competition at the Metropolitan Museum in Coral Gables, FL.
Winner of the DBMS Magazine Reader's Choice award 1995, 1996, 1997 and 1998.
PERSONAL DATA:
Birthdate = 1947 Feb 24
Height = 5' 8" Married =: 1995
Weight = 145 lbs. Secret Level Security Clearance (1981)
Contact this candidate