SUMMARY:

A seasoned enterprise data architect with strong emphasis on MS SQL Server. Experienced ETL and BI architect spanning data ingest to insight. Proficient in Master Data Management and Data Governance stewardship. Highly skilled in implementing predictive and prescriptive data analytics strategies. Knowledgeable in leading BI technologies utilizing semi - structured, unstructured NOSQL and polymorphic data. Experienced in data warehousing using operational and 3rd party data sources. Experienced with various data warehouse methodologies including Inmon and Kimball. Expert at SQL Server data modeling, SSIS, SSAS (tabular & multidimensional) and a variety of BI & Analytics tool suites. Experienced with HA/DR solutioning including Windows Server Failover Clustering, SQL Replication, San level Block Replication, Transaction Log Shipping, Database Mirroring, and SQL Server Always On Availability Groups.

SKILLS:

• HDFS
• MS SQL Server (2008, 2008R2,2012,2014,2017).
• Sql Server Failover Clustering (WSFC)
• SQL Server Always On
• MySql
• Netezza
• Postgres
• SQL,TSQL
• U-SQL
• NZ SQL
• MDX\DMX
• PL\SQL
• Visual Basic
• Powershell
• HTML
• PHP
• Java, Jscript
• Python
• R
• CA Erwin
• ER Studio Data Architect
• SSIS
• Pentaho Data Integration
• Crystal Reports
• SSRS (2012/2014/2017 )
• SSAS (2012/2014/2017 )
• Excel
• Business Objects
• Pentaho Business Analytics
• PowerBI
• MicroStrategy

WORK EXPERIENCE:

Enterprise Data Architect

Confidential, Atlanta, GA

Responsibilities:

• Modeler, Designer, and Architect (conceptual, logical, physical) for the Confidential 's Enterprise Data Warehouse. The warehouse delivers reporting, analysis and forecasting data for all operational and financial system including claims, underwriting, accounting and actuarial data.
• Lead development of infrastructure reference architectures, methodologies, standards and leading practices.
• Architected and Configured SQL Server AlwaysOn Availability Groups with synchronous read\write primary and 2 read only secondary replicas which were then leveraged by organizational analytics teams to develop real-time reporting.
• Developed architectural standards for operational and 3rd party data integration.
• Developed strategic plans for cloud based software as well as transition plans for moving on-prem workloads to off-prem.
• Developed integration plans for 3rd party cloud offerings.
• Facilitated planning long term solutions for cloud computing and storage.
• Prepared plans for lift and shift migration efforts for cloud migration from SQL Server 2016 to MS Azure SQL Database & SQL Data Warehouse for existing groomed data marts and the Access Enterprise Data Warehouse.
• Developed numerous business specific data marts which provides which in turn feed multiple SSAS cubes that provide both self serve ad hoc reports as well as many Power BI, SSRS 2016 reports.
• Utilize TSQL & SSIS heavily for ELT\ETL.
• Lead architect for cloud based applications and databases needed to support the future state Confidential s technology platform.
• Implemented Microsoft s Change Data Capture to facilitate incremental load of data warehouse providing real time claims metrics.
• Evaluated an MS Azure & Azure Stack Implementation with Microsoft to create a Azure Hybrid Cloud PaaS environment for BI and the data warehouse.
• Developed and implemented self - service BI data strategy to extend access to PowerBI, SSRS, SSAS and Microsoft Office.

Senior SQL Server Architect

Confidential, Deerfield, IL

Responsibilities:

• Architected and implemented all data structures and ETL for Kroger's online budgeting system utilizing Netezza and SQL Server and SSIS.
• Created Product Category Sales Forecasting & Budgeting platform which created metrics including sales & profit margin for all of Kroger s 2300+ stores and thousands of suppliers. The platform utilized IBM s Netezza and generated over 7 million in annual revenue the company.
• Developed large 10 TB data warehouse using SQL Server\Netezza to house forecasting & budgeting data.
• Developed Semantic models in SQL Server to encapsulate all necessary user data to be easily queried in a drag - and-drop experience.
• Developed continuous integration (CI) pipeline for code promoted through all environments in SDLC.
• Created extensive test automation for all deployments which greatly enhanced both application and data quality.
• Designed, developed and implemented all Netezza analytics and algorithms used to track and report budget to actual sales and gross margin quotas for Kroger's budget system.
• Project designer for SQL Server Analysis Services tabular and multi-dimensional models.
• Developed numerous SSIS packages to perform ETL to import, transform and migrate data between different platforms (SQL Server, Neteeza & Postgres) to SQL Database and SQL Server Analysis Services Tabular models in the cloud for use by imbedded Power BI dashboards).

Database Architect \ Developer

Confidential, West Chicago, IL

Responsibilities:

• Developed custom SQL Server stored procedures used to access database for Confidential 's Confidential, a JAVA based marketing system.
• Experience gained in development environment using Agile methodology and Change Management through MS Team Foundation Server.
• Ongoing Stress Testing and Performance tuning on tables and stored procs in Confidential system.
• Created numerous enterprise reports utilizing BIDS and SSRS.
• Developed and maintained SSIS packages used to import and transform customer and client data and load into Confidential system.
• Set up Change Data Capture to maintain data and metadata integrity between operational database and data warehouse which feeds Confidential 's Enterprise Reporting.

SQL Server Database Architect \ DBA \ Developer

Confidential, Deerfield, IL

Responsibilities:

• Developed detailed transition plan handbook for Confidential Take Care clinics backend systems integration for all Take Care clinics nationwide.
• Used CA ERwin to reverse engineer Oracle database schemas for migration to SQL server Schemas.
• Designed and Developed SSIS ETL migrations and upgrades from SQL Server 2008 R2 to SQL Server 2012.
• Experimented with query optimization utilizing the xVelocity in - memory analytics engine and the xVelocity memory-optimized columnstore index features in SQL Server 2012.
• Developed proof of concept utilizing SQL Server 2012's Hyper-V virtualization platform with Live
• Migration and server replication to cloud hosted environment.
• Worked on server capacity planning team for Physical and Virtual Servers which utilized historical trending data from FOGLIGHT Performance Analyzer monitoring software.
• Designed and Deployed HA technology solutions which include multiple N+1 SQL Server Virtual
• Clusters to house Confidential Take Care Clinics EMR and Flu Shot tracking Databases.
• Performed maintenance and production support for over 100 servers and 300+ applications.
• Performance Tuning of sql queries and stored procedures for most sql server applications.
• Experience in breakthrough performance for analytic queries employing techniques such as columnar storage, state-of-the-art compression, in-memory caching and highly parallel data scanning and aggregation algorithms.

Senior SQL Server SQL Server Developer \ DBA

Confidential, Northbrook, IL

Responsibilities:

• Provided SQL Server 2008R2 Support for JAVA based application which includes parameterized SSIS package data migrations.
• Trained Report Developers using SSRS. Created templates for most client facing reports.
• Wrote numerous complex stored procs to serve as the data source for client reports.
• Created numerous multi - dimensional & Tabular SSAS cubes for consumption by BI tools like Business
• Objects and Microstrategy.
• Provided administrative support for all development, QA, and Production SQL Server databases. Over 300 databases in total.
• Maintained SQL Server schemas via scripts and deployed through Red Gate tool suite.
• Trained developers on how to run and evaluate execution plans on their queries, use query hints and optimize their applications.

Senior DB Architect

Confidential, Schaumburg, IL

Responsibilities:

l.

• Provided SQL Server 2008R2 Support in conjunction with Sharepoint 2010 Implementations and
• Sharepoint 2007 migrations to 2010.
• Performed consulting services for various clients which include designing SSIS ETL packages and setting up staging tables which were used to update the data warehouse.
• Created sophisticated TSQL based maintenance plans which perform table index rebuilds, database repair and statistics updates based on actual results from data allocation, index fragmentation and consistency checks.
• Performed extensive DW database tuning for several clients, achieving over a 75% increase in overall performance.
• Tackled complex performance related issues such as parameter sniffing, locking\blocking, index tuning and query optimization.
• Configured filegroups and designed column based partitioning schemes and partition functions to improve query performance of the client's DW.
• Built Analysis Services Data Cubes and created SQL Reporting Services reports which utilized stored procedures using MDX to query multidimensional tables.
• Frequent use of MDX to extract sets and tuples with numerous axes.
• Very familiar with the use of MDX functions, Scope & Context Definition, and Error Handling.
• Created numerous BI dashboards for clients using Sharepoint 2010's PerformancePoint too

SQL Server Database Architect

Confidential, Austin, TX

Responsibilities:

• Provided administration support of SQL Server 2008R2 support across entire enterprise.
• Managed 45+ SQL Server Instances, from 20 gb to a 2 terabyte data warehouse.
• Wrote TSQL ETL scripts against DB2 database for iseries and OS/2 to migrate data into the data warehouse.
• Responsible for disaster recovery planning for all SQL Servers.
• Implemented database mirroring for constant availability of sales force automation and personnel routing databases.
• Implemented Quest LiteSpeed DB backups to network drives to replace outdated tape - based backups.
• Consolidated SQL Servers instances, reducing server count by 50% and saving over $200k in licensing in one year.
• Rewrote and tuned long-running SQL queries to cut execution time, ease database load and improve scalability.
• Designed and populated aggregated DW reporting tables using TSQL, stored procedures and DTS packages.
• Implemented database partitioning to handle tables with over 300 million rows.
• Trained developers on how to write better queries, optimize their applications and to become junior database administrators.
• Performed capacity planning, maintenance, evaluations, purchasing, benchmark testing.

Senior SQL DBA

Confidential, San Antonio, TX

Responsibilities:

• Provided SQL Server 2005 database support for the Confidential Automated Loan Processing System (ALPS) which resides in large (1.2 TB) 2005 Enterprise Edition SQL Server Db in an 8 node clustered environment.
• This position involves providing both full time technical support for the system as well as ongoing system performance monitoring, tuning, and enhancements which provide maximum availability and performance.
• Developed customized reports utilizing multi - dimensional tables using pre-aggregated OLAP cubes that provided drill down capability of historical loan data.
• Maintained 3.5 terabyte data warehouse used in OLAP and multi-dimensional analysis. Extensively used SSIS in building data warehouse cubes in the data warehouse.
• Supported 50 separate ancillary SQL databases which either feed data to or extract data via SSIS from the ALPS db.
• Guided and supported .NET application developers through technical analysis, standards, code review, and best practices.
• Performed ongoing performance enhancements through query optimization and load balancing.
• Supported full life cycle development via multiple regression test and development environments.
• Responsible for all Admin functions; (server configurations, database partitioning, maintenance plans, backup and recovery).
• Creation of Database Objects (tables, indexes, views, synonyms), users, roles, systems, backups, troubleshooting for business users, monitoring, etc..
• Provided Tier 3 level support for enterprise wide sql server 2000 to 2005 migration effort. This project required analysis of approximately 1700 SQL 2000 databases to determine a migration plan. Migration efforts ranged from simple migrations to those with multiple clusters and SRDF replication. Developed over 200 migration plans and personally executed approximately 35 of the more complex migrations.

Senior Database Administrator

Confidential, San Antonio, TX

Responsibilities:

• Managed Confidential entire SQL Server 2005 farm which includes over 100 production servers and approximately 250 databases. Currently in process of hardening the security environment and implementing numerous shop standards.
• Administered over 50 mission critical databases for Confidential .
• Provide ongoing high availability support for Confidential 's Internet Banking and Check Imaging Systems which operate in SQL Clustered environment.
• Provided database design, performance monitoring, database tuning, database backups, and SQL tuning.