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.

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.
• 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.

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.