Business Intelligence Engineer
Frederick Mutual Insurance Company
(two month assignment) Wrote quick turnaround SQL BI queries, coached/trained junior query writers.
Feb 2017 - Apr 2017
AeroLeads people directory · profile
John S. Thomas Email & Phone Number
Data Analyst / Modeler and ETL Developer
1 work email found
@cox.net
2 phones found area 301 and 240
LinkedIn matched
✓ Verified July 2026
4 data sources
Profile completeness 86%
Role
Data Analyst / Modeler and ETL Developer
Location
Washington Dc-Baltimore Area, United States
Who is John S. Thomas? Overview
A concise factual answer block for searchers comparing this professional profile.
Quick answer
John S. Thomas is listed as Data Analyst / Modeler and ETL Developer based in Washington Dc-Baltimore Area, United States. AeroLeads shows a work email signal at cox.net, phone signal with area code 301, 240, and a matched LinkedIn profile for John S. Thomas.
John S. Thomas previously worked as Business Intelligence Engineer at Frederick Mutual Insurance Company and Data Analyst at Actionet, Inc.. John S. Thomas holds Computer Science from University Of Maryland University College.
Company email context
Email format at cox.net
This section adds company-level context without repeating John S. Thomas's masked contact details.
*@cox.net
68% confidence
AeroLeads found 1 current-domain work email signal for John S. Thomas. Compare company email patterns before reaching out.
Profile bio
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
Listed skills include Microsoft Sql Server, Etl, Data Modeling, Data Warehousing, and 19 others.
5 roles
John S. Thomas work experience
A career timeline built from the work history available for this profile.
Data Analyst
Write, document, test, and deploy ad-hoc and formally controlled SQL queries, using Oracle 12g (PL/SQL packages, stored procedures, functions).
Jul 2016 - Nov 2016
Senior Etl Developer
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.
Apr 2014 - Apr 2016
Sql Etl Data Warehouse Developer (Sql Server, Informix-Sql, Erwin, Java, C)
Administrative Office Of The Courts
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.
Mar 1990 - Apr 2014
Associate
Team Leader in programming database applications in C and Oracle 5/6 (ok it was some time ago :)).
Dec 1987 - Mar 1990
3 education records
John S. Thomas education
Computer Science
M.M., Music
B.M.E., Education
FAQ
Frequently asked questions about John S. Thomas
Quick answers generated from the profile data available on this page.
What is John S. Thomas's role at their current company?
John S. Thomas is listed as Data Analyst / Modeler and ETL Developer.
What is John S. Thomas's email address?
AeroLeads has found 1 work email signal at @cox.net for John S. Thomas.
What is John S. Thomas's phone number?
AeroLeads has found 2 phone signal(s) with area code 301, 240 for John S. Thomas.
Where is John S. Thomas based?
John S. Thomas is based in Washington Dc-Baltimore Area, United States.
What companies has John S. Thomas worked for?
John S. Thomas has worked for Frederick Mutual Insurance Company, Actionet, Inc., Udig, Administrative Office Of The Courts, and Richard S. Carson & Associates.
How can I contact John S. Thomas?
You can use AeroLeads to view verified contact signals for John S. Thomas, including work email, phone, and LinkedIn data when available.
What schools did John S. Thomas attend?
John S. Thomas holds Computer Science from University Of Maryland University College.
What skills is John S. Thomas known for?
John S. Thomas is listed with skills including Microsoft Sql Server, Etl, Data Modeling, Data Warehousing, Database Design, Enterprise Architecture, Erwin, and Transact Sql.
Find 750M verified contacts
Search by job title, company, industry, location, and seniority. Export verified B2B contact data when you need it.
Start free trialPeople with similar names
Check these profiles if this is not the John S. Thomas you were looking for.
View similar profiles
