John S. Thomas work email
- Valid
John S. Thomas personal email
- Valid
- Valid
- Valid
John S. Thomas phone numbers
SENIOR SQL DEVELOPER / DATA WAREHOUSE-ETL ANALYST Business intelligence data modeler, developer.Hard-core coder (SQL, also Java, C, and scripting languages).Enthusiastic documentation writer.Founding member, CA*.DB Modeler / DB Warehouse guy. Definitely a hands-on sleeves-rolled-up guy, who also speaks well and plays well with others. Incapable of Optimized a high volume stored procedure SQL script. Improved performance by over 2000% (from over 30 hours down to 1 hour 15 minutes).Designed, coded, and tested various data-ware houses and -marts.Conducted total top-down review of data warehousing scripts, methodologies, and designs .... a several thousand database tables, 7 terabytes of data, and 500,000 LOC (SQL).. Experienced with data base design and modeling including normal forms, de-normalizing, data warehouses and data marts. Used star schemas, snowflake schemas, data mapping, ERWIN, and Microsoft SQL-Server T-SQL and Informix SPL) My level of "vanilla" SQL knowledge is "expert."Developed dynamic code generation software using Java, C, SQL, and shell scripts --- before the acronym "jsp" was heard of, and when many large enterprises were just beginning to understand that "client-server" did not deliver on its promises.Designed curricula, methods, and materials for computer programming continuing education (programming, database architecture/design/modeling).Occasionally wicked, occasionally self-deprecating sense of humor.** Talent for both right- and left-brain occupations: quantitative analysis/programming and writing.* Coca-cola-holics Anonymous.** "Why settle for mere desipient sciolism when you can have dilettantish abecedarianism?"--author unnamed to protect the guilty---circa 1971
-
Business Intelligence EngineerFrederick Mutual Insurance Company Feb 2017 - Apr 2017Frederick, Md(two month assignment) Wrote quick turnaround SQL BI queries, coached/trained junior query writers.
-
Data AnalystActionet, Inc. Jul 2016 - Nov 2016Windsor Mills, MdWrite, document, test, and deploy ad-hoc and formally controlled SQL queries, using Oracle 12g (PL/SQL packages, stored procedures, functions). -
Senior Etl DeveloperUdig Apr 2014 - Apr 2016Frederick, MarylandDevelop ETL applications that daily access very large databases (> 100 terabytes), using highly optimized dynamic SQL and Pervasive, an ETL development tool similar to Informatica.Mentor less experienced developers.Translate business needs into workable solutions.Optimize complex embedded dynamic SQL queries.Conduct briefings with technical and business-oriented managers. -
Sql Etl Data Warehouse Developer (Sql Server, Informix-Sql, Erwin, Java, C)Administrative Office Of The Courts Mar 1990 - Apr 2014Washington, DcSQL-ETL-DB-Warehouse Developer (2007-2014).----------------------------------------------------------------------Conceived, designed, implemented ERWin and SQL-Server scripts to model, extract, transform, and load master data (normalized database) into data warehouses and data marts.Created a “hypermodel” of inter-database interfaces using metadata; specified extract-transform-load (ETL) stored procedures; mapped and data-cleaned ca. 10,000 data element source-to-target lineages. Used DAG MetaCenter, ERWin, SQL-Server, and MS-Exce Developed ad-hoc SQL queries against a group of databases, using MS-SQL-Server (T-SQL), and Crystal Reports as primary tools.Web application developer (1990-2007).--------------------------------------------------------Conceived, designed, and constructed a metadata-driven code generation tool used by a dozen developers; saved at least $400,000 in development costs.Developed application requirements documents and ad hoc analyses/queries; modeled logical and physical databases. -- Designed and led implementation of large-scale financial accounting, billing, and disbursement system that tracks Federal criminal fines and other debt (SQL embedded in C programs). -- Led team who developed accounts receivable, reporting, transaction management, and documentation.
-
AssociateRichard S. Carson & Associates Dec 1987 - Mar 1990Bethesda, MarylandTeam Leader in programming database applications in C and Oracle 5/6 (ok it was some time ago :)).
John S. Thomas Skills
John S. Thomas Education Details
-
Computer Science -
Education
Frequently Asked Questions about John S. Thomas
What is John S. Thomas's role at the current company?
John S. Thomas's current role is Data Analyst / Modeler and ETL Developer.
What is John S. Thomas's email address?
John S. Thomas's email address is jo****@****ail.com
What is John S. Thomas's direct phone number?
John S. Thomas's direct phone number is 130180*****
What schools did John S. Thomas attend?
John S. Thomas attended University Of Maryland University College, University Of Maryland College Park, Shenandoah University.
What are some of John S. Thomas's interests?
John S. Thomas has interest in Collecting Antiques, Exercise, Sweepstakes, Home Improvement, Collecting Art, Art, Reading, Gourmet Cooking, Sports, Renaissance Man Stuff.
What skills is John S. Thomas known for?
John S. Thomas has skills like Microsoft Sql Server, Etl, Data Modeling, Data Warehousing, Database Design, Enterprise Architecture, Erwin, Transact Sql, Enterprise Software, Requirements Analysis, Java, C.
Not the John S. Thomas you were looking for?
-
-
-
John S. Thomas, PSM
Jacksonville Beach, Fl3sam.biz, gmail.com, ghiotto.com -
1aol.com
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial