Gary Smith Email & Phone Number

Maker of one-of-a-kind orchid show automation software called ShowDay. Platform collects and uploads exhibitor and entry data, facilitates recording of ribbon and AOS judging results, and produces individualized reports for show stakeholders, including Show Chair, Judging Teams, and Exhibitors. Serving as Show Registrar for five shows in the Mid-Atlantic region. Applying exclusive “Prototype Classes” design strategy to client class and award lists. Analyzing and interpreting historical show results to discover entry trends, identify problematic classes, and spot opportunities for new ones.

United States

Experienced Data Architect with hands-on knowledge of DBMS platforms, operational and analytical data solutions, data integration tools and patterns, AWS cloud solutions, and business requirements and enablement.• Led data architecture/design activities for 2-3 agile squads. Advised other squads on data architecture issues and designed solutions as necessary.• Continued implementation of AWS PostgreSQL Operational Data Store (ODS) and Snowflake Data Lake Hub for TRP Retirement Plan Services (RPS) business. Guided SnapLogic data integration efforts to both.• Designed and implemented durable yet flexible Snowflake and PostgreSQL role-based access control (RBAC) solutions to make user access requests simple and still effectively manage access for each job position using Principle of Least Privilege (PoLP).• Designed and implemented novel row-level security solution to prevent exposure of Snowflake personal identifying information (PII) to outside U.S. (OUS) staff.• Revamped unmaintainable source-to-target (STM) mapping template to capture only needed information and enhance efficiency of business analysts. Organized STMs by data source, data target, and project in SharePoint for easy retrieval.• Led data classification effort to characterize 45,000 legacy TRP RPS data elements within a tight 2-month timeframe that allowed client to respond to impending California Privacy Rights Act (CPRA) legislation.• Developed/maintained a portfolio of ERwin data models on behalf of TRP RPS business.

Owings Mills, Maryland, United States

Information architecture, data modeling, data warehousing, data integration, data quality, data stewardship and other aspects enterprise information management.• Solely responsible for all TRP RPS data architecture and design activities since 2014.• Worked closely with client data governance on data domains, classifications, and definitions implemented in PostreSQL ODS.• Designed/implemented Snowflake Data Lake Hub for RPS business. Hub database served to augment S3 capabilities of AWS S3 file storage.• Captured architectural decisions in a consistent fashion, producing authoritative but still readable and usable documents for team use.• Designed/implemented Oracle star-schema data warehouse in support of RPS business. Guided Informatica data integration effort. TRP RPS business benefited from this second-generation warehouse from 2017 to the present.• Mentored and encouraged junior staff, leading to 2 team members becoming valued team members who were subsequently hired or promoted to a new position.• Designed/enhanced legacy DB2 operational/analytical databases in support of RPS business.• Designed/implemented DB2 operational data store (ODS) and data warehouse in support of Retail business.• Developed/maintained a portfolio of ERwin data models used by both business and IT teams as gold source database design artifacts and as reliable sources for metadata used to populate TRP repositories.• Partnered with TRP business to evaluate, select, and implement text analytics solution to evaluate customer sentiment in feedback.