Connor Simmons Email & Phone Number

Atlanta, Ga, Us

Atlanta, Ga, Us

Atlanta, Ga, Us

- Building Directed Acyclic Graphs (DAGs) in Airflow within GCP Composer's environment- Performing API Calls on external endpoints to retrieve data- Converting Talend Automation jobs to Airflow jobs- Creating Tables and Views in BigQuery

Cumming, Georgia, Us

- Created and Maintained Tables, Schemas and User Roles in Snowflake Data Warehouse- Built and Maintained Data Pipelines via Snowpipes- Ingested Raw Vendor Data to Live in a Centralized Location in S3- Enhanced and Enriched Data from Ingestion to Curated Quality to Enable Internal Reporting- Designed and Modeled Tables in Snowflake via Star Schema Principles- Versioned and Committed all code changes to Github- Created Distance Based Geo-Mapping to Report on Market Health Over Time in Tableau- Created Tableau Datasources from MySQL Reporting Database, Snowflake, AWS Redshift, and MySQL Transactional Database- Used Databricks to Transform and Blend Data from Multipled Sources using Python, SQL and Spark- Built Out a New Business Product to Generate Consumer Marketing Target Lists for Consumers in Brand New Segments- Developed Weekly B2B Customer Business-Health Reporting via Email to Deploy to All Active Customers- Developed Social Media Advertising Activity Reporting Environment- Generated Graphs Based on Reporting Metrics and Stored Them in S3- Dynamically Populated HTML Templates to be Readable in Email Clients- Built and Maintained Data Pipelines Between Internal System and External Data Vendors

Cumming, Georgia, Us

- MySQL Database Administration (Data Modeling, Star-Schema Modeling, Query Optimization, User Role Permission Management)- Developed SQL Queries for Recurring Data Analysis and Ad-Hoc Data Requests- Designed and Implemented Stored Procedures, Views and Other Application Database Code - Monitored Tableau Server Health- Performed Necessary Server Maintenance (Reboots, License Updates, etc.)- Deprecated Outdated Tableau Datasources and Launched Replacement Datasources to Replicate Deprecated ones While Maintaining Data Standards - Versioned and Committed Modifications to Production Code-Base via Github - Developed and Tested Extraction, Transformation, and Load (ETL) Processes - Authored Technical Documentation and User Guides for All Reporting Delivered - Created, Updated, and Maintained Data Visualizations via Tableau Server - Published and Maintained Tableau Server Datasources - Maintained Internal Support Queue in Jira - Managed User Permissions and Project Settings in Jira Service Desk

Atlanta, Georgia, Us

- Generated Team-Specific Automated Macros in Zendesk to Minimize Re-Assignment Times - Provided Historical Reporting on Ticket-Load and Delivery Timelines via MS Excel and Tableau - Developed Library of Pre-set Data Exports in IDM Workbench to Streamline Export Process - Personally Touched 1,072,396 Online Products - Authored 38 custom MAQL queries to enable team-specific reporting in Zendesk - Developed Automated and Ad-Hoc Reporting on Employee Metrics and Performance via Zendesk- Trained New Teammates on Multiple Team-Specific Processes - Subject Matter Expert on Collection Page Creation and Maintenance - Audited Large-Scale Data Sets Against Data Standards, Product Details and Vendor Specifications - Queried SQL Databases for Large Datasets

Alpharetta, Ga., Us

- Data Analysis and Visualization via MS Excel and Tableau- Editing Field Mappings, View Layouts, and CRM Interface- Database Maintenance and Quality Control- Monitor and Track Sales Performance - Individual and Team Level- Report Directly to C-Level Executives- Track and Distribute All New Business Leads- Coordinating Multiple Database Merges- Coordinate and Maintain Multiple Performance-Based Sales and Recruiting Contests

- Counseling between 150 and 200 customers daily through their financial options through telephone and email- Communicate and thoroughly explain all options presented to customers financial needs along with securing necessary payments- Lead trainer for new representatives, teaching company policy and procedure while mapping progress for managerial review- Top monetary debt collector in Early Accounts Department eight weeks- Investigating financial hardship claims and determining where extensions may be applied

- Lead team of three in opening and closing restaurant while ensuring all duties were completed- Maintained knowledge of menu items and allergies to create an optimal experience for guests- Observed server-in-training during shifts along with providing feedback on performance and knowledge

Chicago, Il, Us

- Oversaw the arrivals, daily meals, and departures of over 700 participants- Coordinated deliveries and pickups with Capitol Police Department- Provided students the knowledge behind the mechanics of state-level governmental proceedings- Taught students how to write a legal brief and prepare verbal and/or written arguments

- Managed staff of eight to twelve while continually monitoring high-volume restaurant to ensure quality experiences- Performed checkouts for servers and bartenders to verify that all checks and monies are accounted- Supervised all business operations in the a sense of owners, including managerial, financial, and scheduling necessities - Tracked inventory weekly and placed orders within operating budget - Communicated with team of daily goals and how to exceed expectations