Thomas Considine
ad5d35@r.postjobfree.com
Senior Data Architect and Performance Expert
Strong problem-solving skills. Quickly moves from business needs to data structures, with a grasp of how data applications should work between the two. Learns new systems quickly and sees how to enhance performance.
Extensive experience designing and writing complex applications, introducing distributed data structures, and integrating stove-piped systems into the enterprise. Countless extensive reporting systems, insurance applications, and web hosting for over a hundred sites. Have worked with live feeds from newspapers, airports, weather services, and kiosks.
Education: Yale (BA), Harvard (MA), University of California San Diego (PhD)
Databases:
Microsoft SQL-Server 2000, 2005, …, 2016, 2017
Oracle, MySQL, Postgres,
SAP HANA, Access 2000, 2003, 2007, 2010
Languages: T-SQL, PL/SQL, VBScript, HTML, JavaScript, PowerShell, …
Data Tools: SSMS, SSRS, Excel, Oracle SQL Developer, ColdFusion, Python
Citizen: US
Experience: Database Developer, Data Modeling, Data Integration, Data Warehouse,
Dimensional Modeling (star, snowflake)
Performance tuning: SQL, Oracle, HANA, MySQL, etc.; Procedures, Triggers, Applications.
Expert with Central Server Management features in SQL Server (SQL 2008 and later)
Looking to make a difference:
project rescue; mentoring others;
consolidating architectures – for warehouse or reporting;
resolving performance problems . Thomas Considine – Work History
2015-2018 – Chief Data Architect, KSM Consulting
Architect/Developer on several major data projects for the State of Indiana.
Worked closely with ETL team to prepare and structure data for Data Science team.
Built analytic reporting systems for
oDept of Corrections (recidivism)
oDept of Revenue (tax fraud)
Built Data Warehouse with Analytic Reporting for Dept of Child Services.
Data Architect for the Governor’s Mgmt Performance Hub’s multi-dept effort using data from education, early childhood programs, and wage reporting; enabling long-term analysis of program efficacy.
2011-2014 - Enterprise Data Architect, HP Enterprise Services
NMCI -- Navy Marine Corps Intranet
Data Governance / Master Data Management / Data Performance / Configuration Baseline
Established an automated central catalog of all SQL Servers; catalogued all network databases (approx. 900) according to owner and function, software versions, and hardware beneath, as well as general hygiene. This enabled re-architecting several infrastructure applications to conserve network resources and dramatically reduce annual license costs.
(one million dollar annual savings).
Designed the data structures to produce the Product, Functional, and Allocated Baselines for NGEN, the next major phase of the Navy networks. Identified authoritative sources, designed tools to capture missing elements, coordinated efforts between teams, integrated multiple departmental models. (PL/SQL)
Data Architect, Enterprise Management Systems, with responsibility for data integrity throughout the primary ITIL applications and through all discovery and network management tools used in support of the Universal Configuration Management. Worked with technical lead on each team to analyze and refine data products, reconciling each to others. (PL/SQL)
Worked with ETL team for the NMCI Project, tuned troublesome procedures and structures; introduced new SQL techniques reducing nightly run time by 50%, meeting OLAs, and alleviating concerns about system resources. Mentored the ETL team on writing more efficient PL/SQL code and on Oracle database configuration for performance.
Instituted Master Data Management practices throughout the NMCI network. Added special application to assess and compare progress across systems.
Provided SQL support (T-SQL and PL/SQL) to Production groups. Analyzed slow-running applications and queries to tune database operations across the network. Mentored production staff on using indexes to tune performance of Oracle database systems.
2003-2011 – Data Architect, US Navy SPAWAR Logistics –
Developed an Data Warehouse for the Navy’s Program Management Office to integrate and report multiple contractor and government data systems, assisting the Navy’s Systems Command in receiving/tracking/driving the ten-billion dollar NMCI project.
(ColdFusion over T-SQL)
Provided secure data access to Navy users across the country and throughout
Europe and the Far East.
Used Agile development approach, standing up dozens of applications in response
to emergent requirements.
Developed Base Logistics Information system to track network spare parts inventories for the Navy’s ONENET network. (For bases outside the US.)
2004-2007 – Data Consultant, US Marine Corps (PM MCNIS )
Developed new USMC Command Budget System.
Identified millions of dollars in mid-year de-obligations to fund PM MCNIS operations.
2000-2011 – Independent Developer, Carpenters Union
A tour-de-force application for the Southwest Regional Council of Carpenters, providing automatic, SQL-based job matching for 65,000 union workers in seven states. Three different technologies blended in one application.
Asterisk-based IVR call-in system lets members join lists and request dispatch dates.
ColdFusion web interface directs dispatch of members to matching jobs.
SQL code managed all queuing, eligibility, selection logic, and business rules.
1992-2002 – Independent Developer, Arrowhead General Insurance
Designed and produced systems to integrate 5000 independent agents as a virtual network, linking their remote offices to the Managing Agent in Mira Mesa.
generating new auto insurance applications, with on-the-spot binding,
ordering thousands of motor vehicle reports per week, into the underwriting department.
Dynamically configuring each branch or location to allowed business lines and limits
Pre-Internet, so I wrote all modem handling and file transfer routines
Pre-Windows, so I developed custom drivers for dozens of printers.
Manufacturing and Logistics: the Eighties
Digital Equipment / Seminars Program – 1980-1990 – Instructor/Author
Hired by Digital as the leading expert on their Datatrieve product, to develop an advanced database curriculum, and to teach the Advanced Database Design and Programming seminar, using that text.
The seminar was offered roughly every 6 weeks, traveling across the country, for ten years.
The Architects Collaborative – 1979-1989 – Software Consultant
Designed and produced a total project management system for this renowned Bauhaus Design firm that helped prepare quotes for large projects (for example, an entire university) and then drove the proposal from quote to project tracking to completeness reporting and budget analysis with labor and expenses.
Reebok International – 1983-1986 – Ind. Systems Architect/Developer
Working closely with the CEO, transformed business requirements into software logic to help this sneaker startup grow to an industry leader by providing applications for each phase of wholesale distribution: order taking, overseas procurement, shipping, billing, commissions. Provided hardware systems and custom software systems.
Digital Equipment Corp – 1977-1988 – Ind. Application Architect
Application architect for DEC’s conversion of customer-related systems from mainframes housed in Maynard, MA onto a network of PDP11s across the country. Also designed and produced numerous other systems for marketing, dealer matching, field service performance, and spares replenishment across all sites. Wrote and supported (for 9 years) a comprehensive Quality Assurance reporting system for all training courses and other training products.
Ionics Incorporated – 1978-1985 – Ind. Systems Architect/Developer
Developed a full factory management solution: Inventory Control, Purchasing and Receiving, and Requirements Planning for this manufacturer of desalination equipment. Dashboards allowed CEO and VPs to drill to any level of detail in any project.
On-line Solutions Before the Internet
U S WEST – 1990-1991
Designed a multi-protocol router to allow packet networks to host French and American data systems simultaneously. This enabled distribution and support of European terminals in the US context. ( X.25 networks, before Internet Protocol ((TCP/IP)) was available).
Bell Atlantic – 1987-1988
Designed and operated a service bureau to allow the Bell Atlantic to host dozens of information services on its X.25 networks. Each Information Provider ran on the CitiNet software or on custom additions to that.
NYNEX & SIEMENS – 1986-1987
Designed an architecture for X.25 networks to direct all dial-in users to a portal node, allowing users to connect to different information providers in a single network session, with transfers between hosts managed by the network itself. (Similar to automatic call forwarding from one site to the next.)
Boston CitiNet – 1984-1990
Developed one of the very earliest on-line services linking tens of thousands of users with 90 information providers and vendors. CitiNet operated local portals throughout New England, New York City, Philadelphia, and Omaha.
Three online pioneers in the newspaper industry (Newsday, Boston Globe, Philadelphia Inquirer) were actually hosted on the CitiNet system in Boston.
This service offered online weather reports and pioneered online sales of music disks, Vermont cheese, VCRs, cookies, flowers; and introduced automated lead capture into American commerce.
See in Wikipedia: http://en.wikipedia.org/wiki/Boston_CitiNet
Ask me also about
San Diego Eye Bank (tissue bank), Anchor Insurance (MGA), Sammy’s Pizza (restaurant chain),
Gillette (blades), Remington Arms (munitions), Brockton Enterprise (newspaper),
Lotus Development Corp (Lotus 1-2-3 business reporting), UnterbergTowben (IPO software),
Bartlett Farms (Geraniums), UCSD (A/V scheduling & management).