Steve Rezhener

Woodland Hills, CA *****

323-***-****

adhynm@r.postjobfree.com

http://www.linkedin.com/in/steverezhener

SUMMARY:

Motto: "Data is my passion"

Blogger @ https://www.datasteve.com

Strategical thinker, energetic leader, SQL community activist and enthusiastic Microsoft Data Platform with an MBA and 15+ years of SQL Server Business Intelligence/Advanced Analytics experience in the following industries:

Investment Banking

Real Estate Marketing

Banking and Mortgage Compliance

Entertainment and Online Media

Direct and Email Marketing

Retail and eCommerce

Healthcare, Cosmetics, and Skincare

Technical Consulting

EDUCATION:

University of Redlands, Burbank, CA

MBA, Information Systems Emphasis

Champlain College, Burlington, VT

BS, Computer Information Systems and Software Development

CERTIFICATIONS / TRAINING:

Edx.org, in-progress

Microsoft Professional Program Certificate in Data Science

Microsoft Learning, Los Angeles, CA 2008-2009

Microsoft Certified Professional (MCP ID: 6287183)

Microsoft Certified Technology Specialist SQL Server 2005/2008

Microsoft Certified Information Technology Professional SQL Server 2005/2008 DBA

Spoken Languages: Native in speaking, reading, and writing: English, Russian, and Hebrew

TECHNOLOGY SUMMARY:

15+ years in Database Development using SQL Server and T-SQL

12+ years in Microsoft BI stack using SSIS, SSRS, SSAS, C#/VB.NET

10+ years in Database Server Administration and Management, Server Patching and Upgrades

8+ years in SQL Server 3rd party tools: Quest, RedGate, SentryOne, IDERA, CozyRoc, Melissa

3+ yrs. AWS RDS, EC2, DMS, VPC, CLI, CloudWatch, Lambda

3+ years in Integration with MS-Access, MySQL, SQLLite, Oracle, PostgreSQL, Teradata, IBM DB2 VMS/UDB/AS400, and SharePoint 2007/2010/Online

2+ yrs in PowerBI, PowerShell, dbatools.io

1+ yrs. in Azure/GCP, ASCI ActiveBatch, VMware Hypervisor

0+ yrs. in Data Science, Python, AWS RedShift/Aurora, Snowflake, Azure ML Studio

PROFESSIONAL EXPERIENCE:

SQL Solutions Group, Woodland Hills, CA 09/2019 - present

Sr. Consultant

Business Intelligence and Database Development:

Professional Services:

Built and enhanced Salesforce CRM from/to Epicor ERP process using SSIS 2017 and C#

Utilized SentryOne Task Factory Salesforce REST API with C# to pull/push data

Created reports using SSRS 2017 to proactively identify gaps in data and correct data

Documented source-to-destination mapping from and to

Synced, pushed, pulled the project with/from/to GitHub using Visual Studio

Analyzed SSIS setup and reduce log retention from 365 to 30 days to avoid disk space ballooning

Enabled PowerBI logs to identify data refresh problems

Integrated with Active Directory to pull user info to match accounts using SSIS

Fixed setup problems with Epicor ERP and Dynamics AX

Remote DBA:

Created workflows using Process.Street to standardize on-boarding of new clients

Performed Health Checks and provided recommendations

Installed and upgraded SentryOne SQLSentry performance monitoring tools

Utilized SentryOne SQLSentry to collect metrics and Plan Explorer to improve database performance

Used Devolutions Remote Desktop Manager to manager servers for various clients

Managed public cloud architecture on Microsoft Azure and AWS

Upgraded SQL Server 2008/2008 R2 to SQL Server 2016 instances

Employed Microsoft Assessment and Planning Toolkit to discover SQL Server instances

Made use of PowerShell Core with PowerShell ISE/VS Code and dbatools.io to develop a new health check process

Monitored operational issues using OpsGenie

Created and maintained issues in Atlassian Jira KANBAN boards to track progress

Recorded task progress using Asana and Harvest

Provided guidance and direction to move on-premises infrastructure to AWS public cloud

Adopted Audit framework to record all the server/database changes

Recommended to shutdown unnecessary/unused SQL Server related services to free up resources

Identified and alerted on client gaps in business continuity plans

Analyzed performance bottlenecks and provided solutions

Setup Always On AG and Transactional Replication for HADR and offloading reporting needs

Tapped into Ola Hallengren’s scripts for routine maintenance tasks

Beautycounter, Santa Monica, CA 01/2018 – 06/2019

Lead, Data Architecture and Engineering 10/2018 – 06/2019

Highlights:

Earned a Data Steve nickname by promoting a data driven culture throughout the company

Articulated and presented a data road map to help the company make decisions based on facts/data

Revolutionized company access to the data by replacing aging historical OLTP reporting (1-month look back only) with real-time OLAP reporting data

Brought disparate data sources (SAP S4/HANA, MailChimp, SailThru, Square, ZenDesk, PureCloud, Narvar) into a DataMart and then into a DataWarehouse, a centralized place for all different company systems to provide a holistic picture of a company performance using descriptive and predictive analytics

Leadership:

Managed the Team

Motivated Team members to reach their full potential

Administered a culture of constant flow of communication and feedback

Leveraged Trello and Spoke to provide efficiency, transparency, and accountability

Infrastructure:

Managed to fine-tune AWS DMS via AWS CLI to reduce latency between source and target to 60 seconds

Lead an effort to improve OLTP (SQL Server) performance with deep level index analysis, removal of unnecessary indexes, creation of clustered indexes on heap tables, and defragmentation of 200+ existing clustered and non-clustered indexes to boost performance by 5 X times

Setup Power BI dashboards, reporting, and apps

Staff Augmentation:

Augmented database administration functions (scaling up to 24x7 support) using RDX Remote DBA services company

Contracted an SME to replace an old Active Directory domain controller to a new one on AWS including connecting to a company on-premises AD

Brought in an expert in Entity Framework to analyze performance bottlenecks

Data Hygiene Project:

Solicited RFPs from multiple vendors (MelissaData, Valid, 360Science, Epsilon, and Experian)

Prepared side-by-side comparison to provide metrics on QoS, pricing, and implementation

Designed a process using Melissa SSIS Personator to validate/fix/append 1.3M+ customer addresses/emails/phones and Melissa SSIS Match Up to de-dup to help with Direct & Email Marketing campaigns efforts and prevent fraud

Migration evaluations:

AWS EC2 to GCP CloudEngine

SSIS to FiveTran

SQL Server to SnowFlake

Sr. Database Engineer/Data Architecture and Descriptive Analytics 01/2018 – 10/2018

Environment: SQL Server 2017 on AWS EC2 (OLAP)

Dimensional Modeling using Snowflake Schema:

Analyzed requirements and created a DataMart with various facts and dimension tables

to help business increase revenue, optimize cost and boost profits

Utilized CDC w/SSIS to get real-time OLAP data

Enabled Dedicated Administrator Connection and Resource Governor to create a stable environment

ETL:

Built SSIS packages to populate the DataMart

Utilized BIML Express to save time on creating SSIS packages

Enhanced SSIS with CozyRoc SSIS+ components (Square/Zendesk/MailChimp REST API Source)

Upgraded SSIS packages from full/partial load into an incremental load by leveraging CDC

Employed OData to extract data from SharePoint 2016 Lists

Implemented a feed to source daily currency exchange rate changes (SSIS/XML) to convert multinational revenues to USD

Reporting and Database Development:

Created Data Governance reports using SSRS

Worked closely with Accounting, Finance, Sales, Marketing, Operations, Product Management, Email Marketing and Customer Service to develop Reports, KPIs and Dashboards, DataFeeds using SSRS/SSIS

Built Customer LTV and RFM models, Product/Catalog Matrix, Fraud Detection, CustomerList upload for Facebook Ads and MailChimp and SailThru

Enabled SSRS subscription delivery via email and file share

Established Product/General Ledger feed for Microsoft Dynamics GP

Created Vendor disbursement payment profiles feed for SAP consumption using SSIS 2017 that uploads added and updated records to SFTP (using CoreFTP command line)

Implemented CLR function to decrypt sensitive information

Utilized SAP HANA Studio, and SSIS 2017 in conjunction with SAP ODBC 32/64bit drivers to create a daily pull data from SAP S4/HANA

Made 10 custom reports for Ops Team based on SAP S/4HANA data using SSRS and T-SQL

Utilized ApexSQL Refactor to standardize T-SQL code

Employed MERGE to capture new and changed data elements

Prototyped with SSAS Cubes

Enabled Machine Learning (Python) on SQL Server 2017 to support basket analysis (apriori algorithm)

Sr. Database Engineer/AWS Infrastructure 01/2018 – 10/2018

Environment: SQL Server 2012 on AWS RDS (OLTP) with SQL Server 2017 on AWS EC2 (OLAP)

Spearheaded adaptation of MinionWare BACKUP, CHECKDB, and REINDEX tools to replace native SQL Server maintenance plans for routine check-ups

Pre-sized volumes for AWS EC2 SQL Server 2017 instance

Configured DatabaseMail, Operators, and Jobs for real-time alerting

Boosted server performance and enabled real-time data from AWS RDS

Installed, configured, patched, and administered Server 2017, SSIS, SSRS and Report Portal on AWS EC2

Utilized AWS DMS with homogenous SQL Server replication (Endpoint, Replication, Lambda, and CloudWatch Events) to replicate data from an OLTP server to an OLAP server

Scaled-up and upgraded (in-place) AWS RDS SQL Server 2012 from Standard to Enterprise Edition

Enabled AWS DMS ongoing replication with Change Data Capture for real-time transactional data

Scaled-up and upgraded (side-by-side) AWS EC2 SQL Server 2017 from Standard to Enterprise Edition

Provided Performance Tuning Optimization reviews using SentryOne Plan Explorer

Surveyed SQL Server security perimeter and created a plan to match industry best practices

Analyzed unused database objects and worked on cleanup

Configured Full Text Search to search through order notes to identify fraud orders

Assessed required user activities and provisioned access

Created database maintenance plans to backup, check integrity, and apply retention policy

Worked with the PwC Auditing Team to share the data

Configured AWS Route53 to connect hostnames and public/private IPs

Utilized PowerShell to check on instance connectivity

Tested Disaster Recovery by restoring all database backups (msdb, ReportServer + SSISDB with encryption keys, and user databases)

Enabled AWS VPC pairing to bridge between 2 different local networks inside AWS public cloud

Utilized SYNONYMs to save time by shortening and obfuscating database object names

Community Health Group, San Diego, CA 10/2017 – 01/2018

SQL Server Developer for Initial Health Assessment project

Created a platform on top existing TriZetto QNXT system to incentivize members to visit doctors

JAFRA Cosmetics, Westlake Village, CA 03/2017 - 09/2017

Principal Database Engineer for a BI reporting on SAP ERP

Build reporting infrastructure on top new SAP ERP system to help with supply chain and revenue needs

VALID, Woodland Hills, CA 04/2016 - 03/2017

Sr. Database Warehouse Architect

Helped retail clients to drive more revenue by analyzing sales data

Bank of America, Woodlands Hills, CA 01/2013 – 04/2016

Sr. SQL Server Consultant / IT Program Manager, Global Compliance/Consumer Mortgages

Helped B of A to reduce the cost and liability by automating DOJ/CFPB mortgage compliance needs

Segment Interactive, Santa Monica, CA 08/2011 – 01/2011

VP, Data Architecture

Managed implementation of segmentation product based on Omniture and GA data

Outlook Amusements, Burbank, CA 10/2010 – 08/2011

Production Sr. SQL Server DBA/Developer (Database Engineer)

Equator, Culver City, CA 08/2010 – 10/2010

SQL Server DEV DBA

Napster by BestBuy 12/2009 – 08/2010

SQL Server DBA / Data Warehouse Analyst

William O’Neil, Marina Del Ray, CA

SQL Server Business Intelligence Architect / DBA 11/2007 – 12/2009

Dominion Enterprises, West Los Angeles 08/2006 – 11/2007

ASP.NET / SQL Server Developer

POSnet, Agoura Hills, CA 06/2005 – 08/2006

ASP.NET/.NET & SQL Server Developer

VOLUNTEERING:

LA Data Platform (SQL Malibu) http://ladataplatform.pass.org 09/2013 – Present

Co-Leader

SQL Saturday in Los Angeles (a.k.a. #SQLSatLA)

2020 Event Co-Organizer http://www.sqlsaturday.com/978 06/13/2020

2019 Event Co-Organizer http://www.sqlsaturday.com/891 06/15/2019

2018 Event Co-Organizer http://www.sqlsaturday.com/773 06/09/2018

2017 Event Co-Organizer http://www.sqlsaturday.com/640 06/10/2017

SQL Saturday Speaker

2017 SQL Saturday in Los Angeles: Organizing SQL Community events 06/10/2017

2017 SQL Saturday in San Diego: SSIS and More; SSRS and More 09/23/2017

2018 SQL Saturday in Orange County: Introduction to SSIS and more 04/18/2018

2018 SQL Saturday in Sacramento: Introduction to SSIS and more 07/28/2018

2018 SQL Saturday in San Diego: Introduction to SSIS and more 08/18/2018

2019 SQL Saturday in Orange County: Intro to SSIS and 3rd-party components 04/13/2019

Contact this candidate