BUSINESS ANALYST

Database professional with * years of experience working with SQL and Oracle to extract, explore, translate, and visualize data.

Core Competencies

●Report writing

●Analysis & Presentation

●Troubleshooting/Problem Solving

●Process Improvement

Detail Oriented

EXPERIENCES

BARONA RESORT AND CASINO, LAKESIDE, CA

Database Marketing Specialist II June 2017 – Present

●Design data pulls or queries, views, and stored procedures for new programs and optimized execution of existing programs for efficiency and speed.

●Create various ad-hoc and custom data sets, reports, and analyses that heavily involves data extraction, transformation, interpretation, analysis, and validation.

●Generate reports to communicate information from property data stored in data warehouses, relational databases, multidimensional databases, and all other proprietary and third-party data systems for productivity.

●Provide estimates and actual cost reporting of Database Marketing campaigns. Recommend production alternatives that will improve cost effectiveness where appropriate.

●Identify and resolve data-related issues of concern.

●Tested the new system or current system when upgrades occurred for consistency.

Database Marketing Specialist I Jan. 2016 – June 2017

●Executed postal mail, e-mail and mobile Database Marketing campaigns, list generation, offer loading/management, art and data verification and accuracy, offer/incentive creation, validation and quality assurance to ensure accuracy in the CMS and through DM communications/channels.

●Assisted in developing and managing production schedules and deadlines. Coordinated production meetings to continually update varying departmental process documents.

●Facilitated purchases for all departments involved in Database Marketing projects including logging and monitoring invoices, vendor quotes, and authorization processes in order to ensure timely receipt of all necessary material.

●Utilized Microsoft SQL Server, Excel, and Word to aggregate and communicate information extracted from the property’s databases.

EDUCATION

B.S. Business Administration; Specialization in Human Resource Management,

San Diego State University 2014

COMPUTER/TECHNICAL SKILLS

Oracle SQL Developer

Microsoft SQL Server

SQL Server Integration Services (SSIS)

Extract Transform Load

Transact-SQL

Microsoft Office

Konami Synkros

Experiture Platform

TRAINING

Certification name: SQL for Data Science

Certification authority: Coursera

License number: M7HVWQFF967P

Contact this candidate