Tracy Talbot Email and Phone Number
Austin, TX, US
Tracy Talbot's Location
Austin, Texas, United States, United States
Tracy Talbot's Contact Details
Tracy Talbot work email
- Valid
- Valid
- Valid
Tracy Talbot personal email
- Valid
Tracy Talbot phone numbers
About Tracy Talbot
Began career as a computer programmer. Quickly moved into analysis and database design/development. Interned at the State of Wisconsin Employee Trust Fund and ranked number 1 in the State of Wisconsin MIS exam. After a few years working for ETF, left to enter the consulting arena. Worked for several consulting firms with various Wisconsin and Texas clients, focused primarily on database related development projects. Industry exposure includes Insurance, Education, Telecommunication, Apparel, Government, Vacation Rental, Direct Marketing, and Video Games. I've sought out positions in all roles of the system development life cycle from project management, team lead, business analyst, systems analyst, data analyst, data modeler, data architect, application designer, programmer/developer, QA, technical writer, data administration and even business-side end-user. Goals are to continue learning, growing, and achieving new levels of experience and expertise specific to data management. My passion is data. From business problem definition and needs assessment, data profiling, data gap analysis, data requirements definition, conceptual, logical and physical data modeling (OLTP and OLAP), source-to-target data mapping and translation requirements, data integration, data dictionary and enterprise taxonomy, to information management, data governance, metadata management and data architecture, I'm at home. I fit somewhere between the Business and IT in the space where corporate data exists.Specialties: Relational Database Design, Dimensional Database Design (star schema, data marts), Database Data Modeling (ERD tools), Information Management, Data Governance, Meta Data Management, Master Data Management, Enterprise Data Warehouse Architecture, and Technical Documentation
Tracy Talbot's Current Company Details
Teacher Retirement System Of Texas
View
Senior Data Modeler - Enterprise Data and Analytics Team
Austin, TX, US
- Website:
- trs.texas.gov
- Employees:
- 1377
Tracy Talbot Work Experience Details
-
Senior Data Modeler - Enterprise Data And Analytics TeamTeacher Retirement System Of TexasAustin, Tx, Us
-
Senior Data Modeler - Enterprise Data & Analytics TeamTeacher Retirement System Of Texas Nov 2023 - PresentAustin, Texas, Us
-
SabbaticalSelf-Employed Sep 2021 - Nov 2023Paused my career to care for my terminally ill parent who was living alone. After she passed and her estate managed, I came back home with a new puppy and worked as my own General Contractor in a complete home remodel (all of this was as, if not more, challenging than my real profession!) Now that my mother's estate is settled, my home remodel is complete, and my puppy raised, I'm more than a little bored and chomping at the bit to get back to work. I'm open to full-time remote opportunities or hybrid work in the greater Austin,TX area as an internal hire or contract consultant. I'm looking for a company that values data as an asset, invested in ensuring data is fit for use, and is looking for a business analyst / data analyst (database not statistics), or data modeler (conceptual, logical, physical).
-
Data Manager - Business Intelligence - AisApple Jun 2019 - Aug 2021Cupertino, California, UsAssist in design of data quality metrics platform to accompany global AIS business intelligence metrics aimed at improving transparency of data fitness and highlight opportunities to increase team awareness of data management, governance, and organizational change. Performed special executive projects data analysis of asset management domain.Tools: Databricks, AWS, Spark, SQL, Confluence -
Data Analyst - AisApple Aug 2017 - May 2019Cupertino, California, UsTaxonomy and documentation (data dictionary, schema, domain definitions, known exception conditions) for global security APIs. Data analysis of pipeline ingestion feeds (new and existing) for fitness for use. Coordination with data source providers and downstream analysts for data feed onboarding. Wrote standardized scripts to compare disparate existing feeds with new pipeline feeds for quality assurance. Performed special executive projects data analysis. Responsible for publishing pipeline onboarding data guidelines, and other technical/process documents. Responsible for team wiki documentation.Tools: Databricks, AWS, Splunk, SQL, Java, Scala, JSON, XML, Confluence
-
Information ArchitectWargaming.Net May 2015 - Aug 2017Nicosia, CyProof of concept, prototyping, and development of metadata management structure, process, and general content including reverse engineering physical assets (Hadoop/Oracle/Tableau/Oracle Data Modeler) into Oracle Metadata Manager and establishing semantic-layer metadata. Establishment and consensus of Business Intelligence terms/definitions (ontology and taxonomy). Provide technical SQL and data support for data scientists and data analysts. Gather and consolidate enterprise-level user requirements across multiple departments into a single deliverable using consistent terminology, structure, and content. Assist in metadata relevant projects including developing linkage between and technical definitions of subject area metadata, game logs, KPIs/metrics, and presentation layer/dashboards to provide visibility from desired dashboard/metric and the required log event details required to produce it. Assisted in designing requirements/template for metadata collection at ingestion from data producers as part of new data source ingestion request. Reverse engineered physical Oracle / Hadoop data structures into physical / logical data models and augmenting with business definitions, logical keys, and business rules. A dedicated member of oversight team and technical workgroups addressing GDPR global compliance.Oracle RDBMS, Impala (Hadoop), Oracle SQL Developer, Oracle Data Modeler, Oracle Metadata Manager, Visio, Excel, Word, Powerpoint -
Enterprise Data ModelerBethesda Softworks Mar 2015 - May 2015Rockville, Md, UsParticipate on the Enterprise Business Intelligence Team. Performed readiness assessment for enterprise data warehouse initiative and drafted findings for various project initiatives, identified and documented existing source data stores (reverse engineered ERDs), assisted in development of high level project planning and work breakdown structures for BI team initiatives (EDW, Campaign Management, Finance), drafted educational material on topic of polymorphic associations as they relate to database design.MySQL, Toad for MySQL 7.3, HeidiSQL 8.1, Impala (Hadoop), ER/Studio DA 10.0, Oracle SQL Developer Data Modeler, Visio, Excel, Word, Hansoft -
Independent Consultant (Protean Forge Llc) - Data ArchitectEzcorp Jul 2014 - Dec 2014Rollingwood, Texas, UsSame contractor role converted to independent contractor. Continued support of data model revisions for eCommerce Portal throughout project development life-cycle. Continued support of Catalog Management System (CMS) bulk load templates (for hierarchy management system, reference metadata and item catalog MDM), revising data translation rules/edits/errors, and supporting developers during development/testing. Drafted test cases for functional testing of CMS bulk load templates. Developed OLTP (3NF) data model for interim Dynamic Pricing initiative. Performed reverse engineering of new BI EDW ETL to produce S2T data maps and Data Flow Diagrams to document complex SSIS SQL translations.T-SQL, SQL Server 2012, SSMS, SSIS, ER/Studio DA 9.7, Visio, Excel, Word, TIBCO/MDM -
Consultant (Silver Peak Solutions) - Data ArchitectEzcorp Sep 2013 - Jul 2014Rollingwood, Texas, UsResponsible for conceptual/logical/physical data modeling of new databases (ODS, Product MDM, and Ecommerce Portal) and development of database design documents (design, standards, data dictionary, database planning and security, DDL for tables, constraints, indexes and triggers, DML load scripts (including complex CTEs for ragged hierarchies)), data prototyping and source-to-target data mapping. Created reverse-engineered ERD for OLTP database into ER/Studio, evaluated model and conducted extensive data analysis in development of integrated database designs and prototype data. Lead multi-level database reviews (development, executives, & enterprise architecture committee). Projects managed on accelerated timelines with turnaround requirements ranging from 2 weeks to 2 months. Participated in business requirements phase of MDM project, lead tech requirements and development of bulk load templates (S2T maps) and translation/integration requirements for Point of Sale OLTP database and 3rd party (TIBCO MDM) tool. Drafted detailed functional test cases for CMS bulk load templates used during unit and string testing. Participated in business requirements Dynamic Pricing project meetings and developed OLTP (3NF) logical/physical data models for several iterations of Dynamic Pricing initiatives. T-SQL, SQL Server 2012, SSMS, ER/Studio DA 9.5, Excel, Word, TIBCO/MDM, Spotfire
-
Data AnalystTrion Worlds, Inc. May 2012 - Aug 2013Redwood City, UsResponsible for physical data model administration, development of enterprise BI taxonomy and core enterprise BI metrics data dictionary, development of various BI process and data flow documents, and development of BI Process and Procedure protocols (all published on the BI wiki). Develop and maintain living Plan of Record documents for green-lighted BI projects. Analyze and design data model for MTX wallet tables and integration into existing data warehouse, analyze and design data model to house data extracted from Oracle RightNow for custom reporting, analyze and design enterprise customer segmentation attribute data model, analyze and design enterprise BI metrics data model (retiring existing non-scalable schema) to source dashboards. Analyze, design and develop MTX financial transaction views to feed into Finance application (Agresso) replacing existing non-MTX push-driven feeds. Provide data analysis of data sources including the date warehouse, OLTP database and game logs via Hive (Hadoop). Write, review and tune complex SQL, data validation of OLTP, log, and data warehouse data, report prototype development, metadata development, and campaign list production. T-SQL, SQL Server 2008, SSMS, Toad (SS2008), Hive (Hadoop), Toad Data Modeler, Excel, Word, Rally, Perforce -
Sr. ConsultantIntersys Consulting, Inc. May 2011 - Apr 2012Austin, Texas, UsParticipate as team member of data warehousing practice team. Contribute to the development of proprietary data warehouse project delivery methodology, including branding, sales and instructional presentations, scoping of methodology/tool, design and development of technical structure and client deliverables. Validated and refined the methodology/tool in a billable client environment.Participate as part of DW practice team in delivery of a large scale data warehouse with over a dozen external sources. Responsible for the development of ETL architecture documentation, dimensional data modeling (ERDs), source-to-target data mapping, data analysis and profiling, QA of data migration and design documents, development of data dictionary and other related tasks. Completed training on Microsoft Parallel Data Warehouse (PDW 2.0) appliance.T-SQL, SQL Server 2008, SQL Server PDW 2.0, SSMS, Nexus Chameleon, SSIS, Visio 2010, Excel, Word, SharePoint -
Database Engineer/ArchitectHomeaway.Com Oct 2010 - May 2011Participate as data modeler/architect on application development projects for SQL Server. Conduct data analysis, data requirements gathering, physical data modeling (via PowerDesigner), DDL (including databases, tables, constraints, indexes, triggers, views, functions, stored procedures), DML (one-time data loads and hot-fixes) and DCL script development, database environment creation (development, test, staging and production environments), creation and maintenance of ETL stored procedures and functions, metadata management, development and revision of business specific views, drafting data modeling and naming standards, change-control procedures, change request protocols, and other documentation relevant to this service bureau’s wiki, source-to-target data mapping from OLTP to DW as well as from legacy database to replacement database, identification and resolution of DW ETL issues, performance tuning, troubleshooting of business-level view data issues, and customer facing interactions with multiple levels of management. T-SQL, SQL Server 2008, Visual Studio 2008, SSMS, SSIS, PowerDesigner, Excel, Word, Rally, StreamStep, SVN
-
ConsultantIntersys Consulting, Inc. Mar 2010 - Oct 2010Austin, Texas, UsWorking at AMD doing data migration analysis, SSRS, SSIS and SSAS development and SQL tuning in SQL Server 2008. See details in AMD entry below.
-
Consultant (Intersys Consulting) - Bi DeveloperAmd Mar 2010 - Oct 2010Santa Clara, California, UsProvide data analysis and planning for development of cubes for reporting layer of data warehouse project. Develop elemental level data mappings from legacy data structures through raw sources, base layer relational database, and package layer dimensional database (Inmon approach). Develop data usage patterns from legacy reports to be migrated to cube structure while also validating and tuning existing SQL of legacy stored procedures (this was a prototype that was then used for the entire project). Developed technical specification document for migrating legacy reports into new cube driven reporting (this was a prototype that was then used for the entire project). Provide legacy maintenance including modification and creation of views, stored procedures, and SSRS reports. Supported executive-level initiative to resolve problems in launch of portal data migration effort per special request. Within first month of 2nd project, took on leadership activities to augment existing team capabilities (providing prototypes to move project forward in analysis phase). Working with lead DA to identify and resolve post-ETL data integrity issues. Built SSAS degenerate dimension cube for master dimension visibility as a prototype for the rest of the project. Migrated legacy finance reports using package layer database and stored procedures. Drafted technical instruction manual for production deployment of BI assets.T-SQL, SQL Server 2008, Visual Studio 2008, SSMS, SSRS, SSIS, SSAS, SharePoint, Excel, Word, Remedy, Quality Center -
ConsultantOdyssey Information Services Jul 2008 - Feb 2010Plano, Texas, UsWorking at the Texas Windstorm Insurance Association doing SSRS and SSIS development and SQL tuning in SQL Server 2005. See details in TWIA entry below. -
Consultant (Odyssey Information Services) - Data Warehouse SpecialistTexas Windstorm Insurance Association Jul 2008 - Feb 2010Provide data analysis and modeling, database/ETL/report development, and metadata management services as part of data warehouse team. Document (via ER/Studio) existing data warehouse structures via reverse engineering, and develop logical/physical models for new dimensional designs as requested. Provide analysis of and support for existing legacy DW Crystal reports and design/develop reengineered SSRS DW reports in retirement of legacy reporting including reports, stored procedures, functions, tables, indexes, and Report Manager implementations. In effort to retire legacy data warehouse, performed reconciliation of legacy and new data warehouse reports and underlying data. Improved existing reporting structures via development standardization, reusability measures, documentation, and SQL tuning. Troubleshooting of existing SSIS ETL processes to identify source of highly complex legacy data errors and implementation of data and process fixes. Developed new SSIS ETL processes as new data sources were introduced. Assisted in commencement of dimensional model design for new data warehouse that resolves problems with the current 3rd party-developed database design.ER/Studio 8.0, SQL, SQL Server 2005, Visual Studio 2005, SSMS, SSRS, SSIS, VSS, VB, Crystal Reports, Excel, Word, Visio
-
Sr Data AdministratorWps Health Insurance Aug 2007 - Jul 2008Madison, Wi, UsData administration, data analysis, data modeler, relational database design, meta data management, data governance. Laison between project manager/business analyst/application developers and Database Administrators. Responsible for maintenance of master database models, support database related projects with data analysis, design and modeling, collection and management of entity/attribute meta data, and higher level data architecture and process design support as requested by management.Erwin 7, SQL, DB2/Oracle/SQL Server/Access, Excel, Word, Visio, MS Project -
Sr Business AnalystLands' End Business Outfitters Oct 2001 - Jul 2007Dodgeville, Wi, UsWith the roll-out of the Enterprise Data Warehouse, I was offered the unique opportunity to become the end-user of a data warehouse that I helped deliver. Assumed role of Customer House File Retention and Reactivation Officer within B-to-B Direct Marketing Division. Responsible for customer segmentation, forecasting and planning, campaign management, offer development, back-end analysis and tracking, testing, executive and strategic reporting, decision support tasks, operational data support, data analysis, business analysis, national accounts support, liaison with IT/IS, database prototyping, metadata management, 3rd party application support (RDBMS, DB2, MSAccess, SQL, Advanced SAS, Advanced MSExcel, JCL, MVS, TSO/ISPF, Windows, MSOffice, MSProject, Salesforce.com, Affinium Campaign, Business Objects) -
Sr ConsultantSundial Software Jun 1998 - Oct 2001Madison, Wi, UsAssignments: Great Lakes Higher Education, Lands End Business Outfitters, Lands End.(LE) Enterprise Data Warehouse Lead Analyst. Designed LEBO (b2b division) data warehouse data model from which enterprise data warehouse model grew. Defined and drafted project problem definition, ROI, scope and approach, conceptual and technical design documents and other project documentation. Responsible for Data & ETL requirements (format/cleansing/derivation); metadata & domains; data dictionary definitions, use cases and prototype data, conducting design sessions and reviews, and supported development team. Designed 1st dimensional data mart for LEBO Dir. Marketing. Hired by LEBO Direct Marketing to help leverage EDW, becoming business-side end-user of my own data warehouse...a valuable (and humbling) opportunity. (RDBMS, DB2, SQL, JCL, MVS, TSO/ISPF, Windows, MSOffice, MSProject, Business Objects, ERwin)(LEBO) Hired for Bus. Objects reporting. Found/elevated data integrity issues & assigned to lead data gap analysis project (business needs vs. existing data). Project deliverables distributed throughout LEBO/LE. Invited to join LE project team designing Enterprise Data Warehouse (EDW).(GLHE) Lead Tech Analyst/Dev, Conceptual/Detail Design & Tech Specs, Apps Devt, Interface/Report Design, Training Junior Staff. -
Sr Consultant & Staff ManagerNew Resources Corporation 1998 - 1998Milwaukee, Wisconsin, UsAssignments: Lands EndManufacturing supply chain OLTP database modeling. Staff Mgr: Mgmt of 3-6 consultants, career development, performance reviewsConsultant: Data Modeler, Data Analyst, Relational Database Design, Database Development (RDBMS, DB2, SQL, TSO/ISPF, Windows, MSOffice, MS Project, ERwin) -
Consultant And Staff Manager/Group LeaderCapgemini 1995 - 1998Paris, France, FrAssignments: Cuna Mutual Insurance, TDS Telecom.Staff Mgr: Mgmt of 9-12 consultants, career planning and development, performance reviews, guidance and mentoring of junior staff.Consultant: Programmer/Analyst, Business Analysis, Conceptual Designs, Technical Specifications, Applications Development, Interface Design, Report Design, Relational Database Design, Database Development, Database Tuning, QA/Testing, Staff Training (RDBMS, DB2, Oracle, SQL*Plus, Triggers, Stored Procedures, PL/SQL, COBOL, IEF, JCL, MVS, TSO/ISPF, Windows, MSOffice, Universal Data Model-Insurance) -
Management Information Specialist 4State Of Wisconsin, Department Of Employee Trust Funds 1991 - 1995Programmer/Analyst, Business Analysis, Conceptual Designs, Technical Specifications, Applications Development, Interface Design, Report Design, Relational Database Design, Database Development, Database & SQL Tuning, QA/Testing, Production Support (RDBMS, DB2, SQL-DCL/DDL/DML, COBOL, SAS, CICS, JCL, MVS, TSO/ISPF, Windows, MSOffice)
Tracy Talbot Skills
Data Warehousing
Data Modeling
Databases
Business Intelligence
Database Design
Etl
Sql
Sdlc
Business Analysis
Requirements Analysis
Microsoft Sql Server
Relational Databases
Software Development
Data Integration
Data Analysis
Integration
Visio
Ssis
Sharepoint
Dimensional Modeling
Ssrs
Metadata Management
Erwin
Technical Documentation
T Sql
Oracle
Information Management
Enterprise Architecture
Data Management
Business Objects
Requirements Gathering
Master Data Management
Metadata
Data Migration
Pl/sql
Performance Tuning
Db2
Agile Methodologies
Testing
Consulting
Architecture
Visual Studio
Visual Basic
Analysis
Business Requirements
Sql Tuning
Dashboard
Access
Hadoop
Data Warehouse Architecture
Apache Spark
Databricks
Python
Tracy Talbot Education Details
-
Lakeland UniversityBusiness Administration - Minor -
Madison Area Technical CollegeData Processing
Frequently Asked Questions about Tracy Talbot
What company does Tracy Talbot work for?
Tracy Talbot works for Teacher Retirement System Of Texas
What is Tracy Talbot's role at the current company?
Tracy Talbot's current role is Senior Data Modeler - Enterprise Data and Analytics Team.
What is Tracy Talbot's email address?
Tracy Talbot's email address is tr****@****ail.com
What is Tracy Talbot's direct phone number?
Tracy Talbot's direct phone number is (510) 962*****
What schools did Tracy Talbot attend?
Tracy Talbot attended Lakeland University, Madison Area Technical College.
What are some of Tracy Talbot's interests?
Tracy Talbot has interest in Writing, Target Shooting (Pistol/rifle), Home Automation, Reading, Diy Home Improvements, Home Theater Design, Laminate Flooring, Fiber, Clay, Creative Arts.
What skills is Tracy Talbot known for?
Tracy Talbot has skills like Data Warehousing, Data Modeling, Databases, Business Intelligence, Database Design, Etl, Sql, Sdlc, Business Analysis, Requirements Analysis, Microsoft Sql Server, Relational Databases.
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
Aero Online
Your AI prospecting assistant
Select data to include:
Total price:
$0.00
0 records × $0.02 per record
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.
Start your free trial