John S. Thomas

John S. Thomas Email and Phone Number

Data Analyst / Modeler and ETL Developer
John S. Thomas's Location
Washington DC-Baltimore Area, United States
John S. Thomas's Contact Details

John S. Thomas work email

John S. Thomas phone numbers

About John S. Thomas

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

John S. Thomas's Current Company Details

Data Analyst / Modeler and ETL Developer
John S. Thomas Work Experience Details
  • Frederick Mutual Insurance Company
    Business Intelligence Engineer
    Frederick Mutual Insurance Company Feb 2017 - Apr 2017
    Frederick, Md
    (two month assignment) Wrote quick turnaround SQL BI queries, coached/trained junior query writers.
  • Actionet, Inc.
    Data Analyst
    Actionet, Inc. Jul 2016 - Nov 2016
    Windsor Mills, Md
    Write, document, test, and deploy ad-hoc and formally controlled SQL queries, using Oracle 12g (PL/SQL packages, stored procedures, functions).
  • Udig
    Senior Etl Developer
    Udig Apr 2014 - Apr 2016
    Frederick, Maryland
    Develop 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.
  • Administrative Office Of The Courts
    Sql Etl Data Warehouse Developer (Sql Server, Informix-Sql, Erwin, Java, C)
    Administrative Office Of The Courts Mar 1990 - Apr 2014
    Washington, Dc
    SQL-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.
  • Richard S. Carson & Associates
    Associate
    Richard S. Carson & Associates Dec 1987 - Mar 1990
    Bethesda, Maryland
    Team Leader in programming database applications in C and Oracle 5/6 (ok it was some time ago :)).

John S. Thomas Skills

Microsoft Sql Server Etl Data Modeling Data Warehousing Database Design Enterprise Architecture Erwin Transact Sql Enterprise Software Requirements Analysis Java C Shell Scripting Sdlc Informix C# Software Documentation Databases Sql Software Development Microsoft Office Business Intelligence Pl/sql

John S. Thomas Education Details

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?

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

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.