Zac D. Love Email & Phone Number

San Francisco, California, Us

Performance management, coaching, interviewing, hiring, scrum master, sprint prioritization, backlog management, quarterly and yearly planning, project requirements defining and doc creation, technical document creation and approval, project management, define data engineering expectations, define technical visions, define OKRs and KPis, data quality, liaison with the business TOOLS ➜ Snowflake, Python, GitLab, DBT, Airflow, Montecarlo, Great Expectations, Attlassian Suite◆ CONSISTENTLY GUIDE LEAD ENGINEERS TO SUCCESS IN THEIR PROJECTS by partnering with business leaders to derive clear, written requirements docs and identifying persons and roles for the project. This enables me to set development lead expectations for the engineer(s) in creating technical design docs featuring the clear approach, development plans featuring tasks to be done and a calculated overall ETA, communications plans for the projects, which sets engineers up for success throughout the project minimizing management oversight need. (i.e. Relay data, Legacy DW Deprecation, Member Summary, Product Summary, Data Quality Process and Mitigation, Month End Data, etc.)◆ LED ADVANCEMENTS IN OPERATIONAL EXCELLENCE by creating a framework to guide and motivate engineers to continually iterate on processes and infrastructure through creating a vision and strategy docs to flush out ideas, approaches, and gain buy in for the development work. Additionally setting clear on call expectations, alerting policies, as well as deriving support levels and guides.◆ ENABLED SOX COMPLIANCE for key data warehouse data used for critical and external financial use cases. Required defining and scoping the project, calculating needed resources, pitching the need for extra resources due to timing, and then hiring contractors, and managing them through a successful project completion.◆ IMPLEMENTED PII TAGGING & CCPA COMPLIANCE within the new EDW as a part of regulatory compliance requirements.

San Francisco, California, Us

◆ LEAD THE DEVELOPMENT OF DATA CERTIFICATION AND AUDIT COMPLIANCE REQUIREMENTS for data engineers and other contributors to SoFi’s data platform which required facilitating discussions between Risk, Data Engineering, External Auditors, and Platform Owners.◆ GREW THE DATA ENGINEERING GROUP by coaching and promoting 4 data engineers at varying levels to their next level role, including designing the new staff data engineer role and responsibilities. Also led interviewing and hiring of 3 additional great data engineers, and influenced leadership to hire another data engineering squad in order to enable more dedicated engineers and backlogs aligned with business units.◆ INTRODUCED HIGHER TEAM STANDARDS in data engineering by instilling standards and accountability around script performance, explicit logging, correct data modeling, instilling a burden proof for developer, and enhanced the definition of done.◆ INFLUENCED BETTER DATA DISCOVERY AND DOCUMENTATION by producing a hackathon data catalog to prove the need for a data catalog which led to the purchase of an off the shelf product. In addition I facilitated better confluence documentation by merging sources, organizing high level directories, introducing concepts for playbooks, guidebooks, an alert catalog, and coached better technical documents by data engineers.

San Francisco, California, Us

Contributed to making SoFi's data warehouse environment and team scalable to transition from a small startup to support larger company. Served as a data engineer by creating data models, contributing to architectural decisions of the overall system, developed SQL and Python ETL code, performance tuning, and provided overnight on call support. Served as an internal consultant and managed many data integration projects with various areas of the company to bring their data into the data warehouse.TOOLS ➜ Snowflake, Postgres, MySQL, Python, Git, Docker, GitLab, Attlassian Suite◆ SERVED AS THE GO TO BACKUP TEAM MANAGER many times by assuming the ownership and managerial responsibilities for the data warehouse whenever it was needed◆ DROVE AN INITIATIVE TO DEFINE A TEAM VISION by facilitating group conversations and creating safe environments for team members to share their real thoughts, hopes, and ideas for a top notch data warehouse◆ LED THE SELECTION FOR A CLOUD DATA WAREHOUSE SOLUTION to replace a previous Postgres version, enable easier scalability, and facilitate faster query response times◆ BECAME THE CODE REVIEWER THAT DEVELOPERS PREFERRED due to my thoroughness in reviewing and testing, and I also used them as teaching opportunities to mentor less experienced team members◆ REVISED THE CODE REVIEW AND QA PROCESS for our data warehouse team, by facilitating discussions, compiling pain points and suggestions, then structured a new plan centered around squads within the team◆ COLLABORATED WITH AND MOTIVATED SOFTWARE ENGINEERS near me to be part of a side project to create an automated data dictionary tool for data warehouse consumers to search keywords in the metadata and to make table names, field names, and field descriptions easily searchable for anyone

Provo, Utah, Us

Maintained and enhanced the dimensional data warehouse. Modeled new data structures, created and managed automated ETL jobs, and managed the WebFocus reporting system. Maintained existing reports, provided new automated reports, and supported ad-hoc data requests to business leaders as needed.TOOLS ➜ SQL Server, Pentaho Data Integration (Kettle) ETL, IBI WebFocus BI Reporting, SSRS◆ ENHANCED THE VISIBILITY OF COMPANY PERFORMANCE by creating a daily and a monthly key performance indicator fact tables, populated them with valuable but cumbersome data to obtain, and created reporting tools around them.◆ PROMOTED A HIGHER LEVEL OF DATA INTEGRITY by implementing ETL job logging, failure notifications which included possible failure reasons and their fix instructions, as well as ETL job monitoring which brought visibility to how processes ran or didn’t run.◆ FACILITATED A KEY ROLE IN A DATA MIGRATION of an old system to a new Exigo CRM using ETL tools. Created one time runs and a near real-time sync process for some specific data between the old and new systems to carry out a multi-phase world wide rollout over approximately 18 months.◆ ADVANCED A MIGRATION PROJECT PAST DEVISTATING ROADBLOCKS by creating a new data transfer method with the Exigo CRM systems team, provided visibility on accuracy, and changed the mood of management by rethinking our data transfer methods and putting in the extra time and effort to make it happen.◆ MENTORED A COLLEGE INTERN TO BE AN EFFECTIVE TEAM MEMBER resulting in him creating ETL jobs to be used in another system data migration and some new Modere promotion reporting via IBI WebFocus.◆ SIMPLIFIED MAINTENANCE AND INCREASED REPORTING CAPABILITIES by business managers for a constantly changing points earned system by creating data structure, automated processes, and the reporting tools. Included self-guided ad-hoc option for users to slice and analyze the data however they want.

Midvale, Ut, Us

Created, enhanced, maintained, and supported ETL jobs for new project implementations and business changes. Provided on-call day and night support of all automated and replicated processes within the data warehouse. Designed new data architecture new enterprise data warehouse implementations.TOOLS ➜ Teradata, Golden Gate Replication, DM Express & Oracle Data Integration ETL, Linux◆ BECAME KNOWN AND TRUSTED FOR SMOOTH DEPLOYMENTS and quality work by applications managers and peers.◆ INSPIRED OTHERS TO BE MORE THOROUGH in peer quality reviews by creating and following pre-written checklists to promote smoother production deployments across the department◆ RECOGNIZED FOR MY HELPFUL TICKET DOCUMENTATION FOR FAILED JOBS and my attention to step by step detail which helped increase the effectiveness of others when they were on call and encountered similar issues. It also inspired others to do the same and which became extremely helpful to everyone.◆ ORGANIZED AND DIRECTED A TERADATA CERTIFICATION COURSE taught and attended by my peers and I which promoted better system knowledge and team unity.

Draper, Ut, Us

Managed and trained a team of off shore DBA’s. Managed and monitored 3 replicated MySQL database servers and a SQL Server machine. Created new data structures, ETL jobs, queries, and stored procedures to assist developers in systems they created. Managed, maintained, and supported the Cognos reporting system and reports. Provided ad-hoc data and automated reports for internal business operations, and external clients.TOOLS ➜ MySQL, SQL Server, SSIS, Pentaho Data Integration (Kettle) ETL, Cognos BI, Linux◆ DECREASED ETL FAILURES AND INCREASED ETL PERFORMANCE by simplifying and consolidating two ETL systems into one, adding logging, and adding criticality based failure notices. The new visibility alone pointed out the opportunities for improvement.◆ DESIGNED AND IMPLEMENTED SEVERAL BACK END SYSTEMS including payroll, billing, sales tax, and agent shift management using new data structures, stored procedures, automated ETL jobs, and reports.◆ SIGNIFICANTLY CUT TIME SPENT ON AD-HOC DATA REQUESTS by proactively teaching and mentoring others in the SQL language and the company data they typically use.◆ ASSISTED IN THE CREATION OF A NEW SMALL DATA WAREHOUSE, which is the first that O'Currance had.◆ MOVED THE DATABASE SERVERS TO A NEW BUILDING the O'Currance moved into and upgraded our MySQL replicated trio.

Draper, Ut, Us

Created queries and stored procedures to assist developers in programs they created. Monitored database queries and implemented performance improvements where needed. Created reports in the Cognos reporting system to support business operations and external clients. Provided ad-hoc data requests as needed.◆ CREATED VISUAL CONSISTENCY IN COMPANY REPORTS by creating standard report templates and outlined specific things needed on each report◆ ENABLED USERS TO SCHEDULE AND MANAGE THIER OWN AUTOMATED REPORTS in a simple way by designing and creating a dynamic date selection which is out of the scope of reporting system as is comes in the box

Riverwoods, Il, Us

Supported and created new Microsoft Access Databases for the new accounts department daily production use. Created new as well as supported and recommended improvements to existing automated SAS reports. Managed and facilitated meetings for the monthly Enterprise Balanced Scorecard process.TOOLS ➜ SAS, Teradata, Microsoft Access, Excel◆ DECREASED THE COMPILATION TIME of the monthly Scorecard Excel file by creating input tabs and training managers of each location to enter their own instead of headquarters personnel tracking down all the information◆ FACILITATED MORE EFFECTIVE AND LESS TIME CONSUMING CONFERENCE CALLS by implementing improved meeting structures and more detailed advance preparation.◆ CONTRIBUTED TO PROACTIVE STAFF ADJUSTMENTS and detection of call volume changes by introducing internal daily, detailed queue rate reporting

Riverwoods, Il, Us

Took inbound and outbound sales calls. Consistently achieved and exceeded monthly sales goals for balance transfers, card protection, increased usage, and minimized account closures.◆ ACHIEVED THE HIGHEST EARNED STATUS for phone sales agents, senior account manager 2◆ TRUSTED AND INVITED TO PIONEER the Balance Transfer Professional Team due to consistent, high performance