Timothy Perez

• Managed team across multiple projects ensuring success and client satisfaction.
• Led weekly Snowflake office hour sessions to teach fellow colleagues about Snowflake's functionality and answer questions of all levels.
• Led multiple Snowflake study sessions to help colleagues pass SnowPro Core exam
• Attend sales calls to establish credentials and solidify new opportunities

Hyatt Hotels - Data Architect and Security Consultant

• Collaborated with Data Governance and Cyber Security teams to ensure security measures and monitoring are implemented based on company's standards.
• Implemented Network Policies, Private connectivity, Encryption (BYOK), SCIM, and SSO to protect cloud environment from external threats
• Developed, tested, and implemented comprehensive RBAC model, Object Tagging for governance, and Data Masking/Encryption policies to protect data assets and sensitive information
• Gathered, defined and refined requirements, led project design and oversaw implementation.
• Evaluated project requirements to identify and mitigate risks.
• Worked with data engineering team to resolve issues with performance, data pipeline management, or any resources from environment perspective
• Designed and documented architecture for new and existing projects
• Created comprehensive Operational Document that details implementation and ongoing maintenance of security and architecture.
• Presented security and platform architecture designs to review board to obtain necessary approvals.

• Successfully migrated storage and compute from SQL Server to Snowflake, enabling scalable data warehousing
• Developed processes, using PowerShell, that dynamically build SnowSQL cmd data pulls from SQL Server and push to Snowflake. This process is self-maintained when making schema changes on source and destination
• Designed and built dimensional models for multiple subjects for departments across the business.
• Developed reports and visuals that not only provide high level insight using KPIs, indexes, and custom scoring, but also provide actionable reports that the field can use to drive their metrics
• Built supply chain data model to present inventory metrics to assist the business with improving procurement efficiencies
• Organize demos and training for stakeholders and users to enable the business to utilize the products we build in the data space
• Successfully implemented SSRS Report Portal and Power BI (Premium) so our users can have visibility to the data and ability to build their own custom reports and visuals.
• Developed integrations between Snowflake and Salesforce using Azure Data Factory
• Configured access policies in AWS and external stages in Snowflake to seamlessly integrate with Amazon S3 storage
• Maintained current and in-depth understanding of business processes, needs and objectives.
• Worked with developers and engineers to realize technological solutions.
• Broke down technical ideas and issues into non-technical terms for business executives.
• Communicated data development and architecture strategies to senior leadership.
• Drafted visual representations of data architecture design for presentation to senior leadership.
• Designed and built Stage processes for our data to be consumed from multiple sources, implementing the business logic to consolidate the data into one relational model.
• Developed an application that calls the Google Analytics API to consume data related to our eCommerce site. I built a dimensional model for this data, so our users can analyze site traffic and mainly adoption of our new eCommerce site.

• Developed, deployed, and maintained SSIS packages that are used to achieve automation and complex integrations with several third parties.
• Designed ETL process that involves calling SalesForce API and loads data locally to several tables in database that I designed. This data is used to update integration databases to make sure connection strings that are concatenated from database will be valid. This data is also used for reporting.
• Designed GPS integration with three different vendors. This automated maintenance of GPS devices as well as automating payment reminders to assist in collection management. This integration involved complex logic in SQL to determine which payment reminders should be sent based on dealer’s criteria. It also involved building XML commands that were specified in each vendor’s API specifications and sending them through web service.

Data Analyst

• Created executive level reports for CEO.
• Implemented bug discovery and escalation process using Team Foundation Server. Worked closely with president, project manager, and developers to research bugs and determine priority and possible resolutions.
• Wrote SQL queries to proactively find corrupted data created by bugs and scripts to correct them. This included working with Database Administrator to release queries into production as regular monitoring tools.

Technical Support Specialist

• Answered customer’s technical questions and solved problems related to use of AutoStar Fusion and other hosted software solutions.
• Provided excellent customer service and worked with other team members in support, training, implementation, and engineering departments for needed problem resolutions.
• Traveled to customer locations and trained customers on proper use of software.