Jeffery Patton
**** * ******* ****** · Denver, CO 80205 · 303-***-**** · ac9bbo@r.postjobfree.com
Work Experience
DBA & ETL Developer/Analyst, Network Engineering (contract) – Comcast Centennial CO
Jan 2018 – Mar 2018
Brought into the Network Engineering team by the Director and Sr. Director of Comcast West Division to build from the ground up, two data warehouses environments (one for Tableau reporting, one for MSSQL Server 2016), including coordinating the setup of two virtual Windows servers.
Took the imitative to from the start to network and establish relationships, to gather information on data sources and important contacts.
Designed and developed snowflake database and table structures.
Used SSIS to develop multiple ETL jobs to gather disparate data from multiple corporate wide systems.
Self Employed - Goose and the Goat Aurora CO
Oct 2015 – Present
Opened a family shoe store at the Stanley Marketplace. Designed and built-out the store, created the look and feel, made all of the displays and fixtures.
Manage vendor relationships and purchase new products, manage budgets.
Sell fashionable men’s, women’s, and kid’s shoes and accessories.
When not at the store, I build custom retail displays for several clients, as well as print and web design work for my wife’s company
Sr. SQL Server DBA & ETL Developer - Staples Aurora CO
Apr 2015 – May 2016
Created, configured, and maintained databases, tables, views, stored procedure, functions, users and permissions.
Created and optimized ETL (Extract, Transform, Load) processes for department and company-wide projects, using MS SQL Server Integration Services (SSIS), sourcing data from various databases (SQL Server, Oracle, AS400, Teradata)
Prepared data, using SSIS, to specification for high availability reporting in Microstrategy and Tableau
Participated in corporate wide, multi-national Agile projects (utilizing JIRA for project management), with internal executive stake holders, and outside vendors.
Aided in feasibility analysis and the purchase and installation of physical and virtual servers, as well as SQL Server 2014, for a growing team of Quality Assurance Analysts, Data Analysts & Scientists, Business and Reporting Analysts.
Participated in projects as assigned, utilizing both Waterfall and Agile/Scrum methodologies.
Worked closely with the Web Development team to aid in training new developers, ensuring all documentation and requests for databases, tables, stored procedures, etc. are created and configured properly for maximum efficiency with technology used.
Founding board member of departmental group focused on creating a process (and web portal/wiki) around continued learning, internal project completion for optimizing work load, and a place to gather ideas from team members to help grow our business unit and the people in it.
Sr. Database Analyst - Staples Aurora CO
Dec 2010 – Jul 2013
Gained knowledge of a multitude of databases and systems utilized in order to source data. Including Avaya, Cisco, Kana, ClickToCoach, and Workforce Planning/Aspect in MS SQL Server; hierarchy, performance data and metrics, and attendance in MySQL; corporate wide data warehouse sales, inventory and customer data in Oracle and AS400.
Designed, created, troubleshoot and changed ETL processes and code, using SQL Server Integration Services (SSIS) and Pentaho BI/Kettle Data Integration, as needed and based on understanding the business needs. Troubleshoot data and reporting issues involving PHP, and VBS.
Performed complex ad hoc database queries to support business needs.
Participated in projects as assigned, which include Lean Six Sigma and Agile projects.
Created technical and maintenance documentation for data and analysis processes, and end user training documentation.
Created and supported reports and queries, mainly using the Microstrategy reporting tool, SQL Server, MySQL, Oracle, and AS400, based on business needs. Used and fully leveraged these tools, with a strong understanding of the business metrics and data points, to develop reports and queries that are a critical input into the decision-making process.
Worked closely with business users to identify reporting and analytical needs to facilitate the use of data and analysis to make informed operational decisions.
Used reporting expertise to identify varying ways to analyze data to help drive to root cause of issues.
Partnered with database administrators and data architects to source data, and ensure reports meet accuracy, performance, usability, and functionality requirements.
Business & Reporting Analyst (contract) – Level3 Broomfield CO
Aug – Sept 2010
Wrote and modified SQL scripts to query several databases on Oracle and SQL Server to research stranded capacity in the national and international fiber network.
Analyzed query results, create work paper documentation and site surveys for field technicians to locate physical components of a customer’s network, and determine if there is traffic on the circuit(s)
Revenue reclamation and capacity enablement: Worked with internal departments to release circuits, and components, back into inventory through service disconnects, and corrected billing issues if they were present.
Created web based, interactive dashboards and reporting using SQL scripting for data mining, designed with Visual Studio 2008 and SQL Reporting Services (SSRS), to track team metrics for capacity enablement and revenue reclamation.
Data & Reporting Analyst - Empereon Marketing Aurora CO
Jan – Aug 2010
Wrote and modified SQL scripts to query several SQL Server databases
Generated daily and weekly reports for several clients as well as internal management, using the SQL output, as well as MS Access and MS Excel
Analyzed sales and lead/contact information to aid in the adjustment of sales concentration
Supply Chain Forward Logistics (contract) - Cricket Communications Englewood CO
Oct – Dec 2009
Created sales and gross add reporting for executive management, and analysis of distribution center pilot program(s) for new device launches
Business Analyst, Corporate Applications (contract) - Aurora Bank, FSB Littleton CO
Jun – Aug 2009
Met with business users and application vendors for requirements gathering and application configuration
Wrote business requirements to facilitate system hardware and/or software changes, updates, and upgrades, identified and implement group permissions
Coordinated training and user acceptance testing
Business & Reporting Analyst - ALPS Fund Services Denver CO
Jan 2006 – Nov 2008
Proactively met with business users of all levels (from processing and shareholder reps, I.T. staff, to high level executives) to identify solutions to business problems, served as the primary contact to gather information related to new interface requests and/or issues with existing interfaces.
Worked in collaboration with other Business Analysts, System Analysts, and Project Specialists to ensure deliverables were completed in a timely manner, and that stakeholders were well informed.
Used user acceptance testing to test changes to key systems, interfaces, and files, and effectively communicated issues to developers. Created test case scripts within third party software, such as OpenLoad, for load testing and debugging.
Designed, diagramed, and documented business specification requirements, process flows, and end user interface, as well as solutions to business problems by writing and reviewing business case scenarios.
Mapped data required for data files. Validated data files and feeds created by internal developers.
Wrote SQL queries to gather information, validate and test the aforementioned bullet points
Ad hoq report creation and analysis for internal management, fund advisors, and fund managers of several different fund families, using SQL Query Analyzer, Microsoft Office (specifically Microsoft Excel and Visio).
Served as project coordinator and project manager on fund launches and conversions. Coordinated all meetings and agendas, capturing all meeting minutes, logging key issues, and created and updated project plans in a timely manner. Some Project Management coursework completed.
Education
Bachelor of Fine Arts, Graphic Design - 2001
Colorado State University, Ft. Collins, Colorado
Member of Student Organization for Visual Arts (S.O.V.A.)