SUMMARY

• Senior Data Engineering/Business Intelligence professional with over 25 years of experience in database development and architecture.
• Demonstrated expertise as a Data Warehouse Architect, BI Developer, and Manager.
• Expert level skills with ETL Technologies. Regularly mentored/taught SSIS to other staff.
• Very strong SQL Server Data Warehouse evaluation, design and development skills.
• Hands - on Data Architect with SQL 2008/12/16 and Azure experience.
• Extensive experience with on-prem to Azure data warehouse migration.
• Expertise in client/customer facing roles. Participated in pre-sales, POC development, and other sales activities.
• System integration/ETL experience with Salesforce, Dynamics CRM and SAP among others.
• Proven abilities as individual contributor and team leader.
• Strong data warehouse (on-prem and cloud) development costing, resourcing, SLA/PLA creation.

PROFESSIONAL EXPERIENCE

Confidential

Senior Data Engineer

Responsibilities:

• Designed and created high performance SSIS solutions for data warehouse loads.
• Designed and implemented Data Warehouse and data lake schemas.
• Was responsible for client onboarding and EDI interfaces.
• Held 3rd level support (on call) responsibilities for all data engineering products and clients.

Confidential

Principle Data Architect

Responsibilities:

• Performed evaluations of client data warehouses and presented recommendations for improvements.
• Designed data warehouse solutions for on - prem to Azure migrations.
• Created full BI stack (SSIS/SSAS/PowerBI) solutions.
• Worked closely with clients onsite to analyze and design solutions to fit business requirements.
• Created migration plans for PowerBI environments with clustered data gateways.

Confidential

Senior Business Intelligence Developer

Responsibilities:

• Created technical documentation for large, multi - national IaaS migration.
• Provision and manage Azure SQL Databases (PaaS)
• Provision and manage on-prem SQL 2016 Databases
• Gained experience with SnapLogic, PowerBi and Pentaho
• Authored whitepaper on implementing ElasticSearch as engine to search across diverse network topologies for compliance documents.

Confidential

Lead Business Intelligence Developer

Responsibilities:

• Designed and created complex BI solutions using SSIS and TSQL.
• Worked extensively on DW architecture.
• Created ETL packages with diverse source/destinations including SQL, SAP, Omniture Data, SalesForce, Mongo, MySQL, Google Analytics, JSON, etc.
• Created large data - sets and cubes for consumption by MicroStrategy. Tuned MicroStrategy generated queries.
• Responsible for performance tuning of existing ETL jobs and server side processes.
• Functioned as primary development DBA.
• Architecture and system modeling with Visual Paradigm.

Confidential

Sr Business Intelligence Developer

Responsibilities:

• Designed and created BI solutions using SSIS and SSRS.
• Provided data architecture and best practice guidance to other developers.
• Worked extensively with PMO team on client implementations and data mapping.
• Created logical and physical data models and performed metadata management with ERStudio.

Confidential

SQL Data Warehouse Developer

Responsibilities:

• Designed and created complex ETL solutions for DB2 to SQL data conversion
• Extensive performance tuning duties
• ETL transformations for tables up to 800m rows of data

Confidential

Data Architect/SQL Developer

Responsibilities:

• SQL 2008 Data Architect and Developer.
• Extensive use of XML/XSLT for data feeds to/from JBOSS
• Responsible for integration planning for 50+ SQL 2000/2005/2008 Databases
• Responsible for all facets of Data Architecture and SQL programming for very large data security project.

Confidential

SQL Developer/Analyst

Responsibilities:

• SQL 2008 development and report design/creation.
• Heavy use of Microsoft SSRS including Report Builder 2.0.
• Designed and created complex SSIS packages for existing financial BI solution.
• Extensive data analysis to design future data warehouse.
• Authored report for senior management summarizing the "state of the data" to govern development and reporting efforts.

Confidential

SQL Development Manager/Data Architect

Responsibilities:

• Database Architect for large (> 2 TB) high - volume Data Warehouse.
• Performed data modeling and documentation using ERWin.
• Led a staff of 6 developers including project planning and staff/task scheduling.
• Created technology roadmap to migrate 35+ applications from local data to Data Warehouse.
• Responsible for all aspects of data governance including quality, security, and compliance (HIPAA, PCI, etc)
• Was responsible for OLAP Cube and Data Mart design for consumer applications and reporting.
• Extensive SSRS report/dashboard design and development.
• Responsible for designing and implementing data security strategies including Login, Role, and Object permissions/ownership.

Confidential

Data Warehouse Architect/Developer

Responsibilities:

• Designed and created Data Warehouse and associated reporting for large USAF logistics program.
• Authored and delivered data analysis reports and presentations for Senior (Theater/Command) Management.
• Heavy report development with Crystal Reports and SQL Server Reporting Services.
• Responsible for disaster recovery, performance tuning, security design and implementation, and other routine maintenance functions.
• Worked with all levels of staff to design and create BI solutions. Reduced existing processes by 90% in some cases.
• Designed and created all ETL processes for consumer applications.

Confidential

Sr. SQL Developer/DBA

Responsibilities:

• Functioned as MS SQL 2000 DBA for 30+ databases. Duties include data migration, performance tuning, and automation of tasks through agent jobs.
• Designed and wrote stored procedures (SQL 2000) for enterprise level accounting application.
• Performed maintenance of VB 6.0 custom application integrated with Solomon 5.5
• Responsible for routine maintenance, disaster recovery strategies and implementation, and performance tuning.

Confidential

Self-Employed Consultant

Responsibilities:

• Provided general application development, data conversions and IT support services to small and mid - sized businesses.
• Heavy Visual Basic (VB 6 and .NET) and SQL Server development and DBA duties.
• The industry-leading provider of enterprise infrastructure management, employee relationship management, and business management software.

Confidential

Director of Technology

Responsibilities:

• Managed 50 plus developers offshore including project scheduling, resource allocation, and performance.
• Created and managed development budgets to $4m.
• Supervised product managers and responsible for overall product strategy and systems architecture.
• Detailed tasks included project planning, schedule preparation, resource planning, and coordinating release activities with support.
• Was responsible for vendor management including SLA negotiations and performance monitoring.
• Authored database development "Best Practices" documents and conducted development management workshops for subordinate managers.