Zane Clark Email & Phone Number

Gb

𝐌𝐲 𝐑𝐨𝐥𝐞: • Migrated a large insurance-industry client to Snowflake and Matillion.• Cultivated a continuous-integration culture by developing tools, conducting training, and establishing rituals. Developed a Python package that leverages Snowpark to write the state of the Snowflake environment to schemachange-compatible SQL scripts. Configured Bitbucket Pipelines, AWS OIDC, and schemachange to deploy SQL scripts to a targeted Snowflake environment via Pull Request. Normalized git-driven deployment rituals with documentation, tutorials, and coaching.• Performed Snowflake administration and development. Integrated Snowflake with Azure AD using SCIM and SSO integrations. Designed a functional/access role structure to logically isolate environments within a single Snowflake account and support promotion via CI/CD pipeline. Implemented Dynamic Data Masking and disaster recovery Account Replication • Performed Matillion administration and development. Developed a Python package to automate change-management and environment promotion. Developed and metadata-driven orchestration jobs that reduced development time and enforced standardization of common attributes. Configured LDAP and git integrations. Performed instance migrations• Developed a REST API integration using asynchronous Python hosted on AWS infrastructure. ________________________________𝐓𝐡𝐞 𝐁𝐮𝐬𝐢𝐧𝐞𝐬𝐬:PwC, or PricewaterhouseCoopers, offers professional business services, including accounting, auditing, human resources consulting, and strategy management.

Charlotte, North Carolina, Us

𝐌𝐲 𝐑𝐨𝐥𝐞:• Migrated a large healthcare industry client to Snowflake and Matillion.• Pioneered SDLC best practices with Matillion, the client’s ETL tool. Replaced manual Matillionconfiguration change management with a git-driven approach by developing a Python library thatdetects changes to Matillion’s configuration files. Integrated this library with Matillion’s API and built-ingit utility to automate cross-environment deployment. Collaborated with the makers of Matillion tocontribute to a seamless git experience in future Matillion products.• Interfaced with stakeholders on data-quality concerns and the development of new insights.________________________________𝐓𝐡𝐞 𝐁𝐮𝐬𝐢𝐧𝐞𝐬𝐬:Method is a global strategic design and digital product development consultancy.

Los Angeles, California, Us

𝐌𝐲 𝐑𝐨𝐥𝐞:• Responsible for multiple stages of new feature development; architecture, proof-of-concept development, implementation, testing, debugging, and post-release analytics.• Architected and implemented Open Mobility Foundation (OMF) Curb Data Specification (CDS) compliant Postgres DDL and GraphQL API. Contributed to the CDS standard.• Architected and implemented event-driven architecture for asynchronous image-processing pipeline. Developed AWS architecture, wrote Lambda handlers, and designed an analytics-first schema that supported granular reporting on the status of a given image in the workflow.• Developed a custom Google Community Connector for the Google Data Studio analytics platform.• Developed and deployed Python utility libraries to a private package manager.________________________________𝐓𝐡𝐞 𝐁𝐮𝐬𝐢𝐧𝐞𝐬𝐬:Automotus partners with cities to automate parking payment and enforcement using computer vision and proprietary hardware.

Stamford, Connecticut, Us

𝐌𝐲 𝐑𝐨𝐥𝐞:• Rapidly developed proficiency with Charter’s proprietary tagging infrastructure, a pipeline that supports a half-dozen clients across multiple programming languages (Swift, Xamarin, Kotlin/Java, Brightscript, and Javascript) and provides real-time reporting capabilities via Kibana and AWS infrastructure.• Provided a higher level of support by developing the capability to build all of Charter’s client applications from source and using Charles Proxy to interrogate and augment API traffic. • Awarded for pioneering the practice of authoring regex-driven Charles Proxy API testing policies and embedding them in specifications to accelerate the development cycle. • Removed thousands of lines of code made redundant via inheritance. Improved specification maintainability and legibility by introducing a new level of inheritance - via YAML anchors and merge keys - and consolidating repeated patterns. ________________________________𝐓𝐡𝐞 𝐁𝐮𝐬𝐢𝐧𝐞𝐬𝐬:Charter Communications, Inc. (NASDAQ:CHTR) is a leading broadband connectivity company and cable operator serving more than 29 million customers in 41 states through its Spectrum brand. Over an advanced communications network, the company offers a full range of state-of-the-art residential and business services including Spectrum Internet®, TV, Mobile and Voice.

• Architected and implemented a serverless IoT pipeline on AWS for an industrial automation client. Utilized CloudFormation to deploy serverless pipeline with S3, Lambda, SQS, DynamoDB, and Kinesis.• Maintained and extended ETL application developed for CEP in 2017.

Overland Park, Kansas, Us

𝐌𝐲 𝐑𝐨𝐥𝐞:• Implemented client solutions and integrations within an enterprise data pipeline. • Performed data-quality audits and investigations across a pipeline leveraging multiple languages (Ruby, Python), database technologies (PostgreSQL, Redshift, MongoDB, Elasticsearch), coordinators, distributed compute platforms (Databricks), and APIs. • Rapidly developed familiarity with unfamiliar tools, implemented solutions, and tested them. • Wrote – and optimized - advanced queries for relational databases, columnar databases, and NoSQL databases. ________________________________𝐓𝐡𝐞 𝐁𝐮𝐬𝐢𝐧𝐞𝐬𝐬:Quest Analytics provides the first comprehensive platform that enables health plans to optimize their member experience while complying with federal and state regulations for network adequacy and accuracy. Quests’ provider data management and network analytics services are trusted by the nation’s leading health plans, insurance, regulatory agencies and benefit consultants to provide consumers with convenient access to an adequate network of doctors and hospitals and an up-to-date, accurate directory of providers.

𝐌𝐲 𝐑𝐨𝐥𝐞: • Developed installable, desktop-based reporting software in Python with a Tkinter GUI and SQLAlchemy interface performing ETL and data warehousing operations with MySQL and Microsoft Server. • This software automated key Rebate Analyst workflows, increasing efficiency and accuracy by 90%. For more information, see https://github.com/zanebclark/cep_price_console• Routinely elicited and authored requirements by gathering information from cross-functional teams.• Designed and implemented multiple concurrent projects that met functional and technical requirements. • Created advanced custom reports within DDI Inform via ActiveReports 6, making extensive use of VB.NET script. One such report prescribed many of the organization’s daily priorities.• Authored and maintained UML mapping and flow documentation. • Other technologies employed: VBA Macros, Microsoft Access, and VBScript.________________________________𝐓𝐡𝐞 𝐁𝐮𝐬𝐢𝐧𝐞𝐬𝐬: Controlled Environment Products (CEP) is a sales and distribution company that services more than 300 active accounts located throughout the continental United States, Asia and Central America.

𝐌𝐲 𝐑𝐨𝐥𝐞: • Generated and executed project plans. Created and monitored milestones. Interfaced with management on progress and setbacks.• Designed a 1,300-test quality-assurance program that scrutinized the impact of 12 independent variables on prototype certifiability under federal grain moisture meter certification standards. • Developed a certification reporting dashboard in Microsoft Excel that saved Steinlite $24,000 in premature certification fees. • Gathered requirements via interview and observation. Performed competitive analysis by attending national trade shows and studying competitive environment. Collaborated with executive stakeholders to integrate findings into the current and future product offerings.• Performed an ROI analysis on prioritizing export markets. Collaborated with external analysts to identify ideal export markets. Identified export requirements and acquired a $30,000 grant to offset the associated costs. • Produced mechanical designs and related CAD documents in Solid works using a highly flexible top-down assembly design technique. • Implemented an FDM manufacturing process for rapid prototyping and short-run production. ________________________________________𝐓𝐡𝐞 𝐁𝐮𝐬𝐢𝐧𝐞𝐬𝐬: The Steinlite Corporation has designed, manufactured and sold agricultural-industrial grain moisture meters in Atchison since 1931 when the founder, Fred Stein, invented a method of grain moisture measurement that pulses the sample with radio-frequency waves. Dozens of moisture meter models have been developed, manufactured, and serviced at Steinlite since.

𝐌𝐲 𝐑𝐨𝐥𝐞:• Translated company accounting system from a cash to an accrual system. Implemented a cloud-hosted expense reporting process and integrated it with Quickbooks. • Developed a requirement storage solution and elicitation standard. Administered process development, project management and requirement elicitation.________________________________________𝐓𝐡𝐞 𝐁𝐮𝐬𝐢𝐧𝐞𝐬𝐬: CandyCam Multimedia Robotics was founded to create and sell affordable camera-positioning robotics to filmmakers and indoor venues for unprecedented control in recording live-action events and scripted video sequences.

𝐌𝐲 𝐑𝐨𝐥𝐞: • Authored a 55-page handbook on the installation, and use of, World Help Solution’s mobile application. This handbook supported early beta product launches in off-grid areas of South Africa. Facilitated iterative adjustments to this document to include feedback from beta users. • Performed bookkeeping and financial reporting services. Created a human resources onboarding process including the supporting documentation and audit workflow.________________________________________𝐓𝐡𝐞 𝐁𝐮𝐬𝐢𝐧𝐞𝐬𝐬: World Help Solutions offers a mobile software platform that allows local health workers in Malawi to triage patients, educate on treatments and preventative care, and store health data for later use and analysis - all without cellular or wifi.

New York, Ny, Us

𝐌𝐲 𝐑𝐨𝐥𝐞: • Instructed students in The Princeton Review's test-preparation techniques.• Proctored standardized tests________________________________________𝐓𝐡𝐞 𝐁𝐮𝐬𝐢𝐧𝐞𝐬𝐬: Since 1981, The Princeton Review (TPR) has been helping students get into their dream schools. TPR is a premiere test preparation company with course offerings for every standardized test and offices around the world.

𝐌𝐲 𝐑𝐨𝐥𝐞:• Founded The Company of an Optimist: Obtained certifications from various vocational rehabilitation agencies, branded my service, developed a client base, and fostered customer relationships. • Regularly consulted in unfamiliar industries and workplaces with authority and comfort.• Designed and administered a relational database in Microsoft Access• Administered client interviews and assimilated information into narratives designed to highlight occupational strengths.__________________________________𝐓𝐡𝐞 𝐁𝐮𝐬𝐢𝐧𝐞𝐬𝐬: The Company of an Optimist contracted with the State of Colorado to assist individuals with disabilities in obtaining employment.

𝐌𝐲 𝐑𝐨𝐥𝐞: • Administered a vocational rehabilitation program that provided supportive employment opportunities to individuals with disabilities. • Regularly achieved program quality improvement through standardization, efficiency, and program supports.• Provided comprehensive case management to clients by not only facilitating successful employment, but advocating for the highest level of independence and self-actualization ________________________________𝐓𝐡𝐞 𝐁𝐮𝐬𝐢𝐧𝐞𝐬𝐬: Goodwill Industries of Colorado Springs Career Development Center (CDC) partners with El Paso County Department of Human Services to train and put job seekers to work in the Colorado Springs, CO community. Our experienced staff, established regional presence and strong community partnerships can help clients find their paths to personal and financial independence.

𝐌𝐲 𝐑𝐨𝐥𝐞:• Organized opportunities for individuals with disabilities to access the community.

Colorado Springs, Co, Us

𝐌𝐲 𝐑𝐨𝐥𝐞: • Provided mobile services for the staff and guests of a large, decentralized conference center. • Regularly managed the execution of events; requiring a high degree of flexibility, an ability to operate under pressure, and an aptitude for problem solving. • Operated as the face of the organization to guests by addressing requests and issues.________________________________𝐓𝐡𝐞 𝐁𝐮𝐬𝐢𝐧𝐞𝐬𝐬: The Glen Eyrie Group of the Navigators maintains and operates the Glen Eyrie Castle as a conference center and retreat destination. The castle was built north of the Garden of the Gods in 1871 by General William Jackson Palmer, the founder of Colorado Springs. The castle is now the centerpiece of a 750 acre campus with 97 lodging rooms and over 16,500 square feed of meeting space.

Us

𝐌𝐲 𝐑𝐨𝐥𝐞:• Assistant manager in food service industry, accountable for 20+ employees.• Produced a portioning competition to combat the industry’s primary challenge to profitability; overportioning• Traveled to research other franchised stores within the Cold-Stone brand from which I developed a video outlining optimal performance and basic entertainment training________________________________𝐓𝐡𝐞 𝐁𝐮𝐬𝐢𝐧𝐞𝐬𝐬: The Cold Stone Creamery franchise pioneered the concept of folding "mix ins" into ice cream on a frozen slab of granite in front of the customer.