Resume

Sign in

DBA and ETL

Location:
Denver, Colorado, United States
Posted:
May 06, 2019

Contact this candidate

Resume:

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.)



Contact this candidate