Robin Tanner Email and Phone Number

Inteledyne™ is a consulting firm comprised of highly skilled extremely focused technology professionals. We have made it our priority to partner with our clients to help them achieve the most optimally efficient data management processes possible. This improved design and structural efficiency creates significant opportunities to increase revenue, decrease costs, and reduce waste. From small projects and reporting solutions to complete business data applications, Inteledyne’s data professionals are experts in all areas of data management. Inteledyne's services include consulting and strategic planning, system development, and system management.Our areas of expertise include:• Analytics and Reporting• Custom Applications• Data Warehousing• Data Management• Call Center SolutionsResponsibilities• Managed the recruiting and development of geographically dispersed multi-functional technology teams • Developed regional partners for the purpose of opening new sales channels • Recruited a leadership team responsible for core business areas including marketing, sales, strategic partnerships, legal and asset protection• Designed solutions to meet the needs of a variety of clients across a variety of industries • Managed communication with client leadership and set expectations for deliverables and milestones• Participated in the technical development of solutions as neededI've generated between 300k and 500k in revenue through channel partnerships year over year consistently since 2010. Successfully delivered solutions for clients such as ACS, Taco Bell and Blue Shield. Substantial experience participating in RFP processes for clients such as Williams Oil and Gas and partners such as ConsultNet.

Orchestrate the development and implementation of technical solutions and modernization initiatives to drive organizational efficiencies and effectiveness. Guide clients on the evaluation of “buy” vs “build” decision analysis with regard to tooling and architecture decisions. Coordinate development activities associated with POC’s as well as modernization and migration projects. Designed snowflake security schema and DDL management framework, including documentation, roles, resource monitors, warehouses, users, and role grants. Supported the development of a self-service serverless distributed data platform using AWS Technologies, Python, and Pulumi. Defined method for column and row level security using Pulumi, Glue, and AWS Lakeformation and Athena.-Enabled clients to modernize or migrate analytics environments and applications from on-premises infrastructure to cloud infrastructure, while serving as a solution, data, and cloud architect.-Design new realtime integrations for operational source systems to the Snowflake analytics environment-Reconcile subject areas in Snowflake warehouse using data from new systems, facilitate mappings, business interviews, scoping and modeling and augmentation of consumption layer

Provide technical guidance on all areas of cloud, data and devops best practices. Take clients from solution design to implementation. Write documentation of all kinds, facilitate and participate in collaborative requirements discussions, plan project work using various best practice methodologies such as agile, waterfall and other techniques. Manage offshore resources as needed. Seek partnerships and staffing opportunities for EON.

Streamline and automate devops activities, pipelines, infrastructure, configuration management. Organize and manage IT operations related activities. Identify strategic product offerings and related technology infrastructure for data products.

Focus on design of cloud architecture and environments, orchestration, CI/CD pipelines, tooling, infrastructure as code, Kubernetes for metadata driven microservices, Argo, Airflow, data ingestion processes, cloud migrations from Netezza, Teradata and many others.

● Designed complete AWS environment, including subnets, routing tables, nacl’s, security group design, at rest encryption, CICD and Cloudformation● Designed data ingestion process, including lambdas, step functions, bash scripts and Talend API integration ● Create architectural diagrams to communicate design and seek security approvals● Designed orchestration layer, including lambdas, step functions, restartability, error handling, rejected record handling● Coordinated vendors during bake off, including on site visits, strategy for sales presentations and use case materials● Implemented AWS security components (IAM/S3 policies, users, groups, roles)● Configured VPN/VPG connectivity with Palo Alto Networks ● Created highly customizable Cloudformation templates that can be reused for various environments, applications, AMI’s, etc● Design environment promotion model ● Setup and configuration of AWS based RD Gateway with Duo MFA● Implemented infrastructure change request process● Implemented automated CICD promotion process using AWS CodeStar project (CodePipeline, CodeBuild, CodeCommit, etc)● Designed reusable orchestration framework on AWS, extendable across multiple projects and teams● Designed real time data processing by polling SQS queues for events from S3 and using Spark/EMR to read S3 data and dynamically convert unknown data schemas to parquet, pushing the data back to S3 for use with Redshift Spectrum

• Developed processes for coordinating normal project data loading to Netezza in various environments to an Ops team using wikis and status pages for multiple teams to use for coordination and communication• Lead a team of engineers responsible for managing a home grown ETL framework in Netezza• Wrote and maintained a significant amount of code written in bash, used for moving data and files around on Redhat and loading said files to Netezza• Lead the design of a very robust home grown ETL framework/ecosystem surrounding Netezza written primarily in bash, SQL and python for loading data from a variety of formats, including flat files, other RDBMS systems, JSON and excel• At times managed QA defect resolution by the development team with an offshore QA team raising tickets through JIRA• Wrote a significant number of SQL transformations to load data to target models for projects• Implemented dynamic, generic CDC ETL tools in bash and python that dynamically create CDC code in SQL using RDBMS system views• Implemented multi-threaded python design for processing interdependent data warehouse tasks using an object oriented approach for job execution with classes and properties• Implemented python messaging handlers to connect a varying number of front end GUI’s with our home grown ETL framework via named pipes and message polling for the purpose of allowing an operations/sysadmin team to monitor and control jobs running across several servers

• Assisted in the design and development of staging to IDS Coding Platform using Informatica/Netezza architecture• Consulted team and organization on more efficient methods of performing data loads • Designed CDC structure for incorporating daily incremental loads from multiple sources into the data platform• Managed and lead the development of several different Netezza - based data - driven solutions simultaneously• Played critical role in facilitating the transition for BSC to an Agile methodology for the IT organization, reducing financial and time costs• Periodically managed QA defect resolution by the development team with an offshore QA team raising tickets through JIRA• Assumes responsibility for delivery on the most complex aspects of the system, including SQL transformations for various areas of the data layer• Participates and contributes in the architectural design and validation of each of the different solutions prior to development starting

Responsibilities• Lead the design and implementation of data warehousing solutions, including the design of ETL, reporting and analytics, error handling and execution framework, and scheduling, using all Microsoft technologies• Participated in RFP responses for data warehousing projects• Lead the completion of SOW’s for projects part of a larger SLA for ongoing development relationships• Recruited and managed development teams that included a diversity of resources from software architects to BI developers and infrastructure/systems resources, both off shore and on shore• Directed the build of technology solutions, including data platforms and business solutions for workforce management and analytics• Engaged business leaders from the client to draft specifications for new solutions• Directed the extension of various client’s infrastructure to include version control and hosting ResultsSuccessfully designed and delivered multiple data warehouse solutions based on the Microsoft technology stack (Windows Server, MSSQL, SSIS, SSRS, SSAS) for a wide range of clients across a diverse set of industries. Roles held during this relationship ranged from a delivery partner to an architect to a lead engineer. All of these roles allowed me to participate, lead or drive in all aspects of the creation of several data warehouses. This opportunity allowed me to not only maintain my technical skillset, but also greatly strengthened my leadership and management skills.

Responsibilities• Reduced several month end T-SQL stored procedure processes by several hours, through code optimization, transaction control, execution plan and dmv analysis• Introduced new processes to manage and monitor server and job performance• Lead team collaboration and problem resolution with over 20 people during triage situations• Successfully implemented partitioning for data management, using a sliding window• Lead the development and management of an Informatica ETL process with over 80 workflows• Managed the scheduling of the ETL jobs using Autosys• Introduced efficiencies and resolved design flaws that reduced monthly job execution from 1 week to 4 hours• Designed and implemented a partitioning strategy that saved several hours in daily and monthly job processing time, and increased the efficiency of the reporting from taking over 90 minutes to process one report down to less than 5 minutes• Designed a reconciliation process to reconcile several billion row fact tables with a source AS400 SOR• Managed estimating timelines, milestones, and completion dates for projects• Interacted directly with the line of business to maintain communication regarding project deadlines, business needs, issues and data reconciliation for a system ranging in size from 5-10 terabytes.ResultsDramatically improved the performance of a fairly large Microsoft based data mart using Microsoft technologies, saving the business hundreds of thousands of dollars in development, maintenance and technology costs.

•Developed new ETL processes, implementing SSIS as the administration piece.•Optimized performance on existing and new servers for existing and new product lines.•Maintained overall health of servers and made suggestions for ways to improve server architecture.•Migrated Oracle 11g R2 environments to SQL Server 2008

•Worked to help optimize stored procs and develop new data models.•Helped to identify performance problems and fix bugs•Provided recommendations to the DBA team on potential improvements to the normal DBA administrative processes

Responsibilities • Implemented SSRS organizational policies to meet the needs of all departments in the company.• Developed custom dashboards streaming real time analytical data for performance monitoring• Developed database structures and systems to allow for SSAS implementation and data warehousing• Developed ETL farm for harvesting 2005 production environment and XML data types via XPath and reconciling with 2008 warehouse ready environment • Experience manipulating data inside packages and then loading into SQL Server• Frequently developed indexes to improve server performance• Wrote service to iterate through registered servers using SMOApplication object and back up servers every 48 hours• Distributed reports to all levels of management for collaborative analytical purposes• Identified key technology needs within the company and worked closely with the B.I. team to satisfy those needs through ASP.NET development, database development, Web Services development, data warehouse development and business process changes.• Developed custom C# ASP.NET applications for process monitoring and internal operations• Designed systems for moving data from a variety of formats via ETL’s to SQL Server 2005 for the purposes of SSAS implementation• Developed custom reports in SSRS for different business units within the organization• Implemented reporting solutions via VBA in Excel, Outlook, and Access 2007ResultsDesigned and maintained several different T-SQL and SSIS processes used for operational production OLTP environments, as well as OLAP and reporting data marts. Successfully delivered analytics/reporting solutions to several different departments, including VP and C – Level executives that provided real time analytics regarding revenue, customer acquisition, and website traffic.