Technical Advisor

Steven Sims

Experienced database developer with over 24 years of system design and implementation from the Application to the Enterprise level.

Positions

Chief Data Architect, Principal Data Engineer, Data Architecture Lead, Head of Data Engineering

Education

Mesa Community College Mesa, Arizona

Scottsdale Community College Scottsdale, Arizona

Noteworthy Accomplishments

MCSP: 16939446 11-2019

Professional Experience

Data Architect/Developer (Consultant)

2020-Pres | Core Network Strategies LLC | Fayetteville, AR

Core Network Strategies is a consulting firm specializing in providing high-end IT support services for smaller telecoms throughout the US.

Client: CHR, Inc., Oregon

Worked with core CHR designers and developers in a Kanban environment to integrate small Kentucky Telcom to use CHR’s Omnia application. (3 Months)

Client: Bixby Telephone, Oklahoma

Designed and developed ETL from Progress Open Edge database to SQL Server Data Silo for core business reporting. (6 Months, continuing)

Client: Solve, Inc. (Now WipFli)

Designed complex ETL, ODS, Entity Management, and multiple Data Warehouses for Solve client, a large furniture manufacturing firm in Indiana. Design was accepted by client. (6 Months, continuing)

Client: Empire Access

Designed complex address management warehouse and processes to integrate USPS DPV, Dept of Transportation National Address Database, Census Tiger Database, and Local County/State MSAG datasets.

Sr. Data Architect/Engineer

April 2023-Pres | Audigy LLC | Vancouver, WA

Audigy is the hearing care industry’s preeminent, data-driven practice development company, representing 275 practices with 750 locations across North America. As a senior member of the Engineering Solutions Team, I am tasked with designing and engineering the new Data Lake/Warehouse, the ETL systems to populate it, Data Governance Policies, as well as mentoring a dedicated and eager team in modern data management techniques and development methodologies.

• Designed, developed, and implemented SQL procedures for migrating AWS EC2 SQL Server and SSAS data to Snowflake through S3 file system.
• Performed contrast/compare analysis to determine accuracy of data migrations.
• Designed Enterprise Data Warehouse leveraging Snowflake with intent to retire EC2 SQL Server instances.
• Liaised/managed near-shore data development team.
• Designed data-driven warehouse development procedures to speed development and ‘future-proof’ enterprise data warehouse allowing executives more options and greater flexibility.
• Implemented HIPPAA/PHIDA/PIPEDA/GPDR and sensitive data policies and security for a multi-national healthcare-related organization.
• Acted as a mentor for various team members in relation to SSIS debugging, ETL optimization, documentation, Data Warehouse architecture and engineering… specifically regarding Kimball Methodologies.
• Instrumental in discovering anti-patterns and data cleansing issues in current DW that saved the company thousands in AWS and Snowflake fees.
• Wrote Audigy’s first-ever Data Dictionary and Data Governance policy.

Sr. BI Architect/Developer

June 2020-April 2023 | Alaska Communications Inc. | Hillsboro, OR

Alaska Communications is Alaska’s leading broadband and managed IT service provider. As a member of the IT Data team, I am tasked with designing and developing systems for secure monthly and daily BI reporting to internal data stewards, as well as designing and developing various data marts and primary data vault.

• Developed protocols, processes, and systems for an enterprise data vault using 2D EAV architecture with highly reusable components.
• Developed procedures and unit testing protocols for equipment reconciliation for a large telecom network.
• Key member of the team to research and advise senior management regarding proactive data governance protocols, procedures, and systems.
• Worked closely with senior management to develop goals and schedules to create an enterprise data vault for the telecom industry.
• Designed and developed taxonomic 2DEAV database for data integration of legacy data systems.
• Designed and developed data integration feeds and Data Mart to Parent Company.
• Designed and developed REST API ETL system for Vindicia.
• Currently designing system to determine cost drivers for laying fiber cable from outside plant to address leveraging census data and ArcGIS data.
• Developed ETL from Vindicia REST servers to Telecom ODS using C#.
• Developed logic to migrate SQL Server DBs to Snowflake environment.
• Extensive CRUD and ETL development in Snowflake and Azure BLOB.
• Developed data mart in Snowflake for scorecard ingestion.
• Extensive use of Azure DevOps.
• Developed project requirements for migrating processes to Azure Data Factory and Snowflake.

Sr. Database Developer (Contractor)

August 2017-June 2020 | Alaska Communications Inc. | Hillsboro, OR

Alaska Communications is Alaska’s leading broadband and managed IT service provider. As a member of the Business team, I was tasked with designing and developing a complex ETL system to merge data from diverse applications that include: Martens, Siebel DB2, CBP DB2, Hostopia, as well as in-house applications with the intention of transforming the data to be used with the Omnia 360 application by CHR.

• Developed processes for a challenging Level 0 specification migration from multiple applications to a single application model.
• Liaised with SMEs, Operations, and vendors to establish migration requirements, refine design patterns, and resolve data integrity concerns.
• Worked with BSS and OSS Martens, CBP, and Siebel data formats.
• Developed unit testing and QA methodologies for large SSIS project with many packages.

Sr. Database Developer (Contractor)

2016-2017 | Qorvo Inc. | Hillsboro, OR

Qorvo is a leading fabricator and assembler of RF parts for use in a variety of applications including cell phones and defense. As a member of the SNOP (Sales & Operations) Forecasting Dept., my team was tasked with designing and developing a complex inventory report and the systems/services required to maintain it. Qorvo Inc. is the result of a merger between RFMD Inc. and Triquint Inc.. Both organizations maintained their own SAP installations based on their own separate guidelines.

• Continued development of a challenging legacy inventory reporting system sourced from the two SAP installations in an environment where $50 Million of inventory might be moved hourly.
• Liaised with SAP, Operations, and Forecasting teams to establish report requirements, refine design patterns, and resolve customer concerns.
• Designed, developed, and implemented complex Service Broker messaging system that allowed asynchronous ETL of more than 200 large SAP tables, from SAP to production report, with emphasis placed on maintainability and error tracking. This asynchronous system cut daily load times by more than 400%.
• Developed executive-level, ML-enhanced, resource tracking application from the Forecasting teams’ specifications that extrapolated future raw material price points, and resource valuation. This application leveraged the above Service Broker system for near real-time statistics and predictive analytics.
• Designed and developed File Table messaging system that was abandoned in favor of a Service Oriented system.
• Acted as data and SQL consultant for individual SNOP analysts and managers.
• Participated in interdepartmental AGILE meetings.

Database Developer (Contractor)

2014-2016 | Epiq Services Incorporated | Beaverton, OR

Epiq services a considerable market share of the data, print, and mailing needs for large class action lawsuits as well as periodic mailings that include checks, invoices, and other financial and legal data. As a key member of the Special Projects team my role was to navigate largely undocumented systems to create a viable business solution for whatever challenges that fell outside of the normal day to day operations.

• Worked on various ETL projects of financial/legal data, including print-ready data files.
• Optimized current procedures with time savings upward of 1000%.
• Created needed SSIS ETL packages as well as debugging and optimization of existing packages.
• Acted as a data consultant for large teams in the creation and maintenance of complex procedures.
• Developed contrast/compare reports to support large upgrading initiatives.
• Key member of Special Projects Team.

Report Specialist

2014 | Viewpoint Software Incorporated | Portland, OR

Created and modified custom reports using Crystal Reports XI and SSRS (2005/2012), as well as developing custom stored procedures and other data objects to serve payroll, project management, and construction-related data as part of the wide range of products in the Viewpoint Construction Management System.

• Designed and developed custom reports based on the Viewpoint database schema.
• Designed and developed necessary database objects to serve required data.
• Responsible for client contact regarding any project assigned to me.
• Responsible to the Reports Department for managing time and other billable items for each project.
• Experience with Netsuite and WebEx for time management, client meetings, and installation of reports on secure servers.

Lead Database Developer

2010-2013 | ArmInsight Incorporated | Portland, OR

• Designed logical and physical data model for a credit data reporting system in compliance with PCI Tier 1 regulatory requirements.
• Developed ETL package for FIS Datamart/Delta file format capable of processing millions of transactions.
• Developed machine learning algorithms to help identify various and specific card transactions.
• Developed decision support and psychographic models for financial transactional data.
• Developed a system to standardize bank transaction data from multiple banking platforms.
• Developed PCI Tier 1 encryption protocols.
• Designed and developed logical and physical model for high-capacity credit card rewards programs including auctions and sweepstakes.

Lead Programmer

2009-2013 | A3bearings LLC | Dallas, TX

• Designed logical and physical data model for an aviation repair ERP system in compliance with FAA regulatory requirements.
• Designed data tracking and logging system with SQL triggers.
• Developed SSRS ‘pull’ reports as well as Crystal Reports ‘push data’ reports for compliance with FAA guidelines.
• Advised the company’s senior management on equipment, protocols, and software to provide job tracking that meets FAA traceability requirements.
• Designed a client-server topology including LabVIEW network connectivity to capture real-time equipment and process data.
• Developed SSIS importation routines for various data formats.

Lead Developer (Contracted)

2008 | Expeditors International | Portland, OR

• Designed logical and physical data model of a large Inventory Tracking data system.
• Developed logic and protocol for system to handle in excess of 30,000 pallets per month to a single warehouse.
• Implemented Barcode scanning system with Windows CE.
• Integrated Accounting software based on Access 2003.
• Implemented email notification system with Lotus Notes.
• Saved 16 man-hours in paperwork processing.
• Achieved 99.999% warehouse accuracy.
• Warehouse Data conversion and normalization.

Senior Developer

2007–2010 | Voxay Incorporated | Phoenix, AZ

• Designed logical and physical model of a large cross-server database.
• Developed stored procedures for common data operations.
• Designed SSRS reports per specification.
• Implemented PCI DSS guidelines for credit card storage.
• Developed SSIS import routines for various Microsoft data formats.
• Created ASP.Net web application for customer orders, and credit card validation.
• Developed intricate data-driven medical email notification system.

Data Systems Designer

2003–2007 | PWNT Services | Phoenix, AZ

• Designed databases and data-driven software for a variety of clientele.
• Developed SSRS and Crystal reports for various uses, including financial, sales, decision support, employee time tracking, and call center phone logging.
• Converted US Census Tiger database to SQL Server.
• Refined legacy stored procedures to make better use of resources and faster runtime.
• Developed stored procedures with T-SQL and CLR as needed, including implementing various algorithms with T-SQL such as Haversine, SoundEx, Metaphone, etc.
• Developed web applications interfacing various data back-ends.
• Developed small business windows applications.

Senior Programmer

1999-2002 | YP.Net | Mesa, AZ

• Developed infrastructure, billing, and decision support applications.
• Designed, implemented, and administered ISP Radius Authentication Server System.
• Managed databases of upward of 124 Million records and 200+ tables.
• Refined legacy queries, DTS packages, and agents.
• Developed web applications in ASP.
• Extensive use of PowerBuilder and PowerDesigner.

Developer/DBA

1997-1999 | Telco Billing Incorporated | Scottsdale, AZ

• Migrated legacy data from diverse systems such as FoxPro, Paradox, Dbase, and others to SQL Server 6.5.
• Developed custom DTS packages for common migrations.
• Developed primary Call Center Applications.
• Processed data for mass mailing using Postal Service guidelines.