Daniel Troyer Email & Phone Number

San Francisco, Ca, Us

Irving, Tx, Us

- Proficient in Azure data platform, utilizing SQL databases, Data Factory, and Synapse, as well as AWS resources including EC2, PostgreSQL, and Aurora RDS, demonstrating versatility across multiple cloud environments.- Implemented infrastructure as code using Terraform and repo-driven solutions to ensure environment consistency.- Developed pipelines for transporting CDC data streams to external data warehouses, as well as constructing slowly changing dimensions and facts, facilitating efficient analytics reporting.- Expertise in data modeling, including the implementation of star schema with SCD Type 2 dimensions, leveraging Synapse data flows to streamline data transformation for rapid consumption by analytics platforms.- Successfully balanced the competing priorities of feature development and technical debt management, ensuring business needs are met while maintaining a healthy data platform.- Actively involved in translating business requirements into actionable tasks, collaborating with product teams to refine functional specifications and participating in architecture teams to integrate data considerations into new application features.- Proficiency in batch processing with a focus on latency tolerance, with ongoing efforts to explore real-time data processing capabilities using Kafka on AWS and Event Bus on Azure.- Commitment to continuous learning, staying abreast of industry trends and advancements through following thought leaders on LinkedIn, studying academic materials, and pursuing vendor certifications.- Demonstrated initiative in addressing skill gaps, contributing to the OPS team by implementing PGLogical replication from Postgres to AWS RDS, resulting in increased service capacity and significant revenue gains.- Completed implementation of the first new in-product report using Synapse, Snowflake, and Terraform. This allowed the elimination of $60k of annually recurring spend on old infrastructure.

Tampa, Florida, Us

• Create ETL pipelines using Azure Data Factory between services including Azure SQL, Oracle, SFTP, and Blob storage• Architect, develop, and deploy SQL databases for proprietary applications• Optimize and redesign legacy reporting tools using current methods and technology including Power BI• Support web developers building custom applications as they interface with SQL databases• Consult with end users to design requirements for new development projectsProject Management• Lead the implementation of Agile project management within the team to define objectives and record progress• Coordinate efforts to achieve objectives as project coordinatorDevOps Repos and Pipelines• Lead structure of code repositories to progress code development and maintain documentation• Implement and maintain pipelines that deploy code to resources for testing and production• Verify PRs for deployment to production• Develop migration scripts to evolve SQL databases to match new schema requirements while preserving dataActively learning Python for data and software development

Tampa, Florida, Us

Primary responsibility: Extract data and insights from operational databases to generate Power BI Dashboards communicating insights to stakeholders including executive management.Additional responsibilities:-Design and initialize Azure SQL databases for product prototyping-Design data processes and flows for prototype applications--Coordinate the implementation of the data design with application developers-Data Engineering: Design and implement ETL and ELT pipelines in Azure Data Factory-Design and implement DevOps CI/CD Deployment Pipelines to process code from repos into Azure resources

Tampa, Fl, Us

Working with business stakeholders, domain experts, and technical resources, I create reporting from various data silos which bring insights on data quality, organization performance and profitability for those able to improve business processes and outcomes. Along with my team, I create reporting packages for stakeholders ranging from executive leadership to team supervisors. I collaborate with development teams and business line leadership for the purpose of developing application models that generate useful data exhaust for future reporting. I support the acquisitions team in restructuring data from outside organizations and integrating it into our environment. As a founding member of the Data Management Team, I frequently lead efforts to implement and perform data sanitization processes while maintaining data security, integrity, and improving standardization.During my tenure I have also been responsible for implementing vendor-based reporting solutions to tie individual performance to compensation incentives, designed custom reporting for client-side service performance visibility, and provided on-demand reports to stakeholders for acute issue resolution which I then transitioned into established tools as appropriate.Focuses: T-SQL, Excel, Power BI, Azure Synapse, ETL workflows

Tampa, Fl, Us

Escalation support for Tier 1. Specialist support covering proprietary software, primary and secondary ERP, and data repair for JSON transactional records. Developed SOPs and KB documentation for new department workflows.

Tampa, Fl, Us

Providing helpdesk support to internal users and outside clients. Creating and maintaining network documentation. Developing workflows and publishing documentation for use by support agents and end users. Designing and deploying network policies. Administrating multiple domains.

Uzhhorodskyi Raion, Ua

I design and create web sites for local businesses. These websites typically provide information on products and services available as well as contact information. I have not done work with eCommerce sites. My projects are meant to drive traffic to physical locations rather than to do business themselves. Clients have seen significant increases in sales in-store and over the phone due to the web sites I provide and the SEO efforts of a colleague and myself.

Events: -Gray Summit, Purina Show Dogs 2012As an independent contractor, I was the Web Director for the American Kennel Club’s Belle City Winter Classic. This job involved running a NewTek Tricaster 350 which includes two VTRS, two graphic generators, and audio playback, plus three cameras, and five audio feeds, then broadcasting live via Livestream.com. My intended role was to run the Tricaster as a TD during the live segments under a primary Director and to run the commercial segments and some transitions myself. As it would happen, the primary Director was called away after we got started and I took over as the primary Director for about 70% of the four hour show. We estimated the online audience to be upwards of 700 viewers. Each camera from this show ran an ISO recording. Those ISOs and the line cut including the comm audio were used to re-cut the show for broadcast on network television. -Boston, Purina Incredible Dog Challenge 2014-Atlanta, Purina Incredible Dog Challenge 2015-Los Angleles, Purina Incredible Dog Challenge 2014 & 2015-Grey Summit, Purina Incredible Dog Challenge 2014 & 2015The Purina Incredible Dog Challenge is a multi-camera shoot similar to Purina Show Dogs. As a sporting event, the pace is faster and the duration is longer with several rounds for various skill sets. I served as the Web Director as well as one of the primary on-site infrastructure techs, dealing with video distribution and several independent networks providing IP video streaming connections and standard data connections.

Us

Video Production and Systems Integration:Print MediaDesign (Photoshop, Illustrator, InDesign)Production (Canon IR-ADV 5255c, various print houses)Video ProductionLive Video DirectorPost ProductionSystems IntegrationWorkflow Design and OptimizationData Flow from Building Automation to Digital SignageWeb Designpure HTML and CSSWordpressI returned to Idlewild to join the Communications Department Full-Time working with digital media in particular as well as a secondary responsibility in print media. I specialize in taking new problems and ideas to create a new workflow for deployment to a wider audience. I developed the mass email system with MailChimp and Wordpress as well as the data flow from the building automation system to the digital signage system. My goal is to develop a platform that enables the end user to cause a desired effect without having to understand the whole system that makes it work.For more information, see A/V/L Tech below.

Tampa, Florida, Us

Camera shot directionPresentation supportGraphic placement

Tampa, Fl, Us

Camera shot directionConcert SupportAd placementEvent Set and Strike

Miami, Florida, Us

Scuba suport for OceanAria. Flight support for Blue Planet. Various band sets and special event support.

Miami, Florida, Us

Backstage tracks on Spirits of the Seasons, an Ice Spectacular.General support for the Cruise Division for bands, parades, and other events.

Orlando, Florida, Us

I was hired by Sea World Parks & Entertainment to work on the new Christmas Town event at Busch Gardens Tampa Bay as a seasonal employee. I worked in varying capacities from set and prop manufacturing and assembly to lighting installation and set rigging. I served in the warehouse as well as the park. According to park policy, employees must be trained and certified internally to run most equipment. I have been signed off on standard vehicles plus box truck, forklift, lull (off-road forklift with a boom), and scissor lift. Although I have not needed to run a show, I have received basic lighting and audio training enabling me to cover vacant show positions in time of need.This term with Busch Gardens has reawakened my interest in rigging. I’ve had some experience rigging at Idlewild, but the Christmas Town installation involved rigging various elements ranging from smaller lighting elements to several-hundred pound topiaries over guest areas. I find myself much more interested in rigging than in lighting and audio.I rejoined the team at Busch Gardens Tampa in April 2013, starting in Consumer Events working on preparations for Howl O Scream and Kinetix. The release of the Technician Career Ladder to seasonal employees provided me with new training opportunities that I have pursued in earnest, including the Rigging class with Jay Glerum and High Reach training. In the Summer, I was transferred to the Moroccan Palace, where I have served as Video, E-Track, and Follow Spot 1&2 as well as serving on Scenic and Rigging work nights. In the Palace, I have worked with the Scenic Lead to redesign and build props such as the umbrella for the Great Barrier Reef scene. I also serve as Opening Tech and have begun training on Follow Spot in the Desert Grill. Under the direction of a show manager, I assisted in development and deployment of the new version of the Technician Career Ladder.

Us

Graphics creation and deployment Animation creation and deployment Video Director Web Director Camera shot direction Presentation support Concert support Theatrical production supportGraphic placementSet install and strikeRigging

Drywall Trim CarpentryGeneral home and commercial construction and repair

Electrical Engineering, Philosophy

High School Diploma