Support Specialist Data Analyst

Adam Breusch

**** * *** ***

Lakewood, CO *****

PH: 303-***-****

***********@*****.***

Dedicated and energetic individual who thrives on problem solving. More than 15 years’ experience in the technical field with emphasis in Database Development and Business Intelligence.

People~Process~Systems

Highlights of Experience

SQL Server 08-19, Data Tools,PowerShell,NET,Azure,AWS,MySQL8.0,Oracle12c,Hadoop,NoSQL,R,PHP,XML,HTML5,ITILv4,

Long Building Technologies Littleton, CO

SQL Server DBA: 09/17 to 03/20

●Data Warehousing with multiple ODS including GP 2015, CRM 365 and Azure Administration.

●Security, performance tuning, testing and QA.

●HADR and backup development strategy.

●Data Tools and Power BI Development for multiple Business Requirements.

●R machine learning for predictive modeling and statistical reporting.

●Migration SQL Server 2014 to 2017 with support for clients in Data Vault environment.

●SSIS ETL processes with Kingsway and Data Flow development.

CU Anschutz School of Medicine Aurora, CO

SQL Server DBA: 09/16 to 08/17

●DBA Admin on SQL Server 12-16 production servers with server configuration, Performance tuning, AWS Admin.

●HADR Configuration and maintenance with backup and reporting services.

●Full application support for student and Physician faculty on proprietary and legacy software.

●Application development SSDT, C#, VB, PowerShell and integration with Axium clinical software.

●Ensure standardization of systems implementation, change control and best practices.

●SDLC in compliant Agile SCRUM environment.

Davita Denver, CO

DB Application Analyst: 11/15 to 05/16

●Assessments, reporting and design with proprietary software and SQL Server 2008.

●SP performance reviews and development.

●Table structure reviews and performance suggestions.

●Technical consulting in identifying, implementing and supporting new SQL Server functionality.

●Phone support for client base.

●Technical adherence to company policy.

Stellar Restaurant Solutions Colorado Springs, CO

BI Development: 09/15 to 10/15 – IC

●Primary duties were to assess infrastructure, deployment, processes and validity of data in SQL Server 2014.

●Retracing, classifying and validating SSISDB and Report Server Catalog Processes.

●Communication and updates with business and executive management on daily progress.

●Implementation and design of company goals and direction.

●Data warehousing for new BI designs and proprietary software.

●ETL configuration and implementation.

Gaiam Boulder, CO

DBA/Data Warehouse: 08/14 to 08/15

●Data Warehouse Development with hybrid dimensional/normalization modeling OLTP & OLAP.

●Developing SSRS for current and future business processes and flagging potential issues.

●C# and VB scripting ETL with SSIS for application demands.

●Ad Hoc query requests including manipulation of existing SSRS subscriptions and catalogs.

●Maintained consistent statistics for Big data, query, database and network performance.

●Merge replication with Mirroring SQL Server 2012 high availability environment.

●ETL for GP MS Dynamics and AX structured tables.

●Developed flexible data model design with scalability, performance and business needs.

Zayo Group Denver, CO

DBA/Integrations: 06/13 to 08/14

●Database development and warehousing with SQL Server 2012 and MySQL 5.6.

●Backup, Security and performance strategies for best practice business environment.

●BIDS development stack for consolidation, access and reporting purposes.

●C#, PHP, Salesforce reporting, object and Apex development.

●Sevone reporting and maintenance with Metasolv NMS experience.

●Developed Mongo, SQL server integrated modeling.

●Data validation with business peer review.

●Daily Problem resolution from technology to project management.

●Worked for a High Availability redundant environment.

●SDLC for data warehouse including, requirements gathering, design, implementation, and maintenance.

Cricket Wireless Greenwood Village, CO

DBA/Reports Developer: 07/12 to 05/13

●Responsible for importation and validation of data from multiple sources into SQL Server 2008 r2.

●Business data support for sales and inventory forecasting with SSRS

●Designed and developed a full scale, multi-client reporting solution with BIDS stack.

●Regularly met with internal and external clients for business intelligence needs.

●Created, implemented and maintained a reporting suite of over 20 standard reports.

●Customized many SSRS reports to meet individual client needs.

●Performed daily ETL between systems using SSMS.

●VMWare, VSphere infrastructure supporting 50 clients.

●Installing and upgrading system software and hardware.

Easy Student Publishing Englewood, CO

DBA/Developer/Support: 04/11 to 07/12

●My SQL DBA functionality including, monitor and tuning of App Server performance.

●Identify, resolve or provided recommendations for data base and business issues.

●Performed database/infrastructure physical design, database upgrades and applied software patches.

●Acceptance testing and App deployment.

●Responding to client application support needs, internal and external.

●PHP, VB.NET development in both production and internal environments.

●Adobe CS 6 with image manipulation photo shop and Dreamweaver.

●SQL scripting, data mining, table design and dataflow engineering.

●Ad Hoc DOS Shell, UNIX Shell, SQL and VBScript experience.

●C# Share point development for company intranet.

●Image lifecycle processing on the terabyte level.

●SQL Server 2008 R2, SSRS, SSIS, TSQL Data Manipulation, ETL.

●Custom FoxPro DB application development to facilitate image processing.

●Relativity and Concordance DB data migration and Administration.

●Windows 64 7 pro, Office 10, Windows Virtual environment.

●Share point 2010 design and implementation.

●.Net development, Visual Studio 2010.

Well dyne Rx Pharmaceuticals Centennial, CO

Support Consultant: 11/10 to 2/11

●Avaya VOIP system rollout and configuration.

●Windows 7 and Office 2010 upgrades.

●McKesson application admin including Robot-Rx, Enterprise Rx suite, Pharmacy Engagement Programs

●And first hand interaction with McKesson Application Hosting

●Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.

●Perform quality assurance and testing of SQL server environment.

●Ensure best practices are applied and integrity of data is maintained through security,

●Documentation, and change management.

●Spice works configuration and maintenance.

●VERITAS system backups.

●Production printing press setup and support.

●Education and training on all new systems including 24/7 support.

Core logic Safe Rent Lakewood, CO

Network Consultant: 02/10 to 11/10

●First line of support for approximately 5000 clients nationally and internationally.

●SharePoint configuration and daily use in a ticket system capacity.

●VMware configuration and monitoring.

●Server setup including Cisco ASA, ESI PBX, AS400, Barracuda web filter, Routers and Firewalls

●Support performance on Active Directory user accounts, OU assignments and SharePoint designations

●MS Office 2010 and Windows 7

ATBS Lakewood, CO

Information/Support Specialist: 12/07 to 11/09

●Provided Technical Support for up to 200 person office. Troubleshooting Operating System Issues (Win9x, NT, 2000, XP, Vista, 7).

●SQL Analyzer for data edits using T-SQL. Developed queries daily in an ‘as needed basis’ and stored procedures.

●SQL Server 2005-2008 administration including setup, updates, migration and hardware swapping.

●VB.NET, C# Object Oriented code editing for client side data import files.

●MS Office 2003-2010 included setup and programming in Access and Excel. POP3, IMAP and user setup in Outlook.

●Active directory configuration including setup of specific users and groups, password reset, user rights and permissions, disabling and

●Enabling accounts, file folder permissions and configuring security templates.

●Network Connectivity, TCP/IP Configuration, Switch, Firewall, router management and DNS registration.

●Third Party client contact and development of file formatting, FTP, integration, process and in house QC for data integrity.

●Installed Logical printers on print server and prepared print sever to host clients. Daily user setup and maintenance on print server.

●Maintenance on all in house printers and communication with all third party vendors to resolve printing hardware issues.

●Daily desktop maintenance including drive and PCI swapping, reformatting, allocation, disaster recovery, backups and user transfers.

●Enterprise Manager to develop and maintain daily batch job processes, releasing DB locks and monitoring network DB throughput.

●Support for Sales force, Remedy and several third party applications including setup, updates, training and maintenance.

●ESI PBX phone support with programming, training and physical manipulation of phones and VOIP consoles.

Qwest/HP Denver, CO

Help Desk Tier I: 01/07 to 11/07

●Inbound/Outbound NOC call center for Web hosting data centers, the faculty that ran them and the clients who used the services.

●Around 300 calls per 10 hour shift using Clarify ticketing system, In House monitoring System and several third party applications.

●Duties included monitoring critical systems from a big board console and being proactive when there were problems.

●Logging calls and determining the issue that needs to be addressed through client contact and base knowledge of the system.

●Initiating a resolution process, reviewing that with all parties. Putting that resolution into effect by initiating repairs, tests and reviews.

●Taking client side calls and developing the same resolution process as above and working with third party contractors for repair.

●Heavy network management, TCP/IP, ISDN, ATM, Frame Relay, ARP WAN, LAN, DHCP, DNS.

●Always gave the highest level of customer satisfaction with great resolution record and high moral.

AT&T/Lucent technologies Centennial, CO

Signal Point Data Analyst: 08/03 to 01/07

●Complete analysis of cell tower frequency, throughput, physical dimensions and cell server integrity.

●Proprietary Lucent software determined new data intensive cellular signal.

●Reviewed cellular towers throughout Denver metro area and relayed data collected back to the home office.

●On call for on site changes needed for the data collection process, resets of cell servers and several other specific requests.

●Proficient in GSM, CDMA, UMTS and other telecom/wireless protocols.

Computer Research Inc. Denver, CO

System Operator/Support: 01/00 to 03/03

●Maintaining daily I/O transactions of financials from firms around the world, reporting to SIAC regulatory agency.

●Trouble shooting AS/400 I series database problems with minor programming in COBOL and FTP.

●Analysis of business and user needs, documenting requirements for rules, scenarios and user guides for system changes.

●Handled customer service issues from transmission of data, reporting issues and programming

●Assisted colleagues with all hardware software problems including updates, installation, printers and Technical support.

●Mediated customer, system and management needs with senior developers in a technical consultant role.

●24 hour on call pager rotation.

EDUCATION

B.S. in Chemistry University of Alaska Fairbanks

Atlantech comp train, Oracle 8i OCP DBA/Certifications: A+, Oracle 8i, RTI Certified PLM Asbestos Analyst

Alaska fishing deckhand Lloyd Collins set net

Volunteer at Catholic Charities

Contact this candidate