Jeff Patton Email & Phone Number

Denver, CO, US

2501 Dallas St. Aurora, CO 80010

Own and operate two boutique locations specializing in on-trend shoes, accessories, women’s apparel, and children’s apparel.

Wholesale business representing artisan jewelry and handbags.

Denver, Colorado, United States

• Support the Spectrum Reach line of business marketing and advertising Data Integration group.
• Detail and document location(s) of needed data Snowflake database tables and stored procedures.
• Develop processes for new ad agencies, extracting needed data metrics from Snowflake database tables, creating new Airflow DAGs for pipeline ingest and export to AWS S3 Buckets.
• Resolve submitted help tickets for process improvements and job failures.
• Participate Agile daily scrum, sprint planning, refinement, and retrospective.

• Gather and stage data to Azure SQL Databases, Azure Data Lake, or file outputs for downstream use.
• Use Spark/PySpark and Spark SQL with Databricks to query and transform data from SQL Servers, APIs used Postman as well), and/or pull down encrypted & non-encrypted files from SFTP to transform and stage data for.
• Detail Azure Data Factory and SSIS packages using on-premises servers in technical specification documentation. Recreate the pipelines and packages in a 100% Azure cloud-based environment leveraging Databricks, Azure.
• Participate in Change Control Board meetings for project submission and release into production, describing the project and speaking to QA/UAT results, and deployment.

Denver, Colorado, United States

• Analyze software, applications, and processes to make recommendations on best practices and technology changes.
• Establish processes and create documentation for new automation of data collection, transformation, and reporting.
• Write PL/SQL queries and procedures for Automatic Passenger Counter/Automatic Vehicle Location data cleanup. Optimize SQL queries and various processes for data export and efficient performance of reporting with Power.
• Increased time use efficiency by saving a minimum 40 hours per month in manual data entry and report creation utilizing Pentaho DI, Python, Excel, and Power BI, for transportation ridership, bus/rail operations.
• Rewrite complex SQL queries to support migration of Ride Check application backend from Oracle to MS SQL Server.

• Design and deploy dimensional data warehouse and convert older 3NF databases to a hybrid model.
• Configure and maintain databases, all associated objects, users, and permissions, for high availability reporting.
• Design and optimize ETL processes using SSIS, sourcing data from various DBMS’s and file servers, in two-week sprints.
• Lead and participate in corporate wide multi-national Agile projects with internal executive stakeholders, and outside vendors, addressing progress in Daily Stand-ups
• Train new Web Developers on database policies and best practices, ensuring all documentation and requests for new resources are created and configured properly for maximum efficiency with technology used.

• Design, and document SSIS and PDI ETL jobs, sourcing data from MSSQL Server, MySQL, Oracle, and AS400.
• Develop Microstrategy reports, and support Business Intelligence Analysts’ reporting, as critical input for decision making.
• Partner with database administrators and data architects to ensure data and reporting meets accuracy, performance, usability, and functionality requirements.

• Revenue reclamation and capacity enablement
• Document site surveys for field technicians, determining if traffic is present on the circuit(s), and locating physical components on customer networks.
• Research stranded capacity in the national and international fiber network. Coordinate release of circuits and components back into inventory through service disconnects.

• Generate daily and weekly reporting for clients and management, analyze sales and lead data to adjust demographic and geographic sales concentration.

• Create sales and gross add reporting for management and analyze distribution center programs for new device launches.

• Meet with business users and software vendors for business requirements gathering and application configuration to facilitate system hardware and/or software changes, updates, and upgrades.
• Coordinate training and user acceptance testing.

• Proactively meet with business users of all levels to identify business need. Serve as the primary contact for new and existing Fund interfaces. Document business specification requirements, process flows, and end-user.
• Data mapping and validation required for Fund launches and conversions.
• Ad hoc reporting and analysis for internal management, fund advisors, and fund managers of several different fund families.

• Daily mutual fund and money market trade processing, and creation and; sending of cap-stock money movement reports/ logs to fund accounting, custody, and the fund managers.
• Various report creation for internal management, and fund advisors and; managers of several fund families using SQL, Microsoft Excel, and Crystal Reports.