Kalan C. Dawson

EXPERIENCE

CRM, CMS, and small business ERP administration, customization, and data

migration (Salesforce, NetSuite, Zuora)

Agile development and project management (JIRA, Confluence, MS Project)

Database structure, ERD development, data modeling, ETL procedures, and SQL

development

Business Analytics suites (Spotfire, MicroStrategy)

Microsoft Office suite (Excel, Access, Word, Visio)

Windows, Windows server, and Unix / Linux based operating systems

Online form builders with CRM / database connectivity (Formsite,

FormAssembly)

Image editing programs (Adobe Photoshop, GNU Image Manipulation)

PROFESSIONAL POSITIONS

Product Owner for Business Intelligence June

2011 - Feb 2014

Open English (Coral Gables, FL)

. Designed and developed dashboards by building ad-hoc queries, stored

procedures, and views to better support business metrics and efficient

OLAP reporting (MySQL, TIBCO Spotfire)

. Interfaced directly with VPs to define business requirements,

standardize company concepts, and scope development deliverables for

reporting accuracy, scalability, and other specific needs across

company divisions

. Supervised star schema and ETL development, metadata modeling,

profiling, and data dictionaries for ODS, staging environment, and

data warehouse layer (MySQL, Talend)

. Worked with remote development team to improve ODS reliability and ETL

performance during rapid growth of business intelligence report

consumption, increasing database performance by 20%

. Established payment approval rate calculations and automated 400,000-

record executive dashboard using payment suite (Zuora) and other data

source, decreasing time-to-delivery by 75%

. Designed, scoped, and administered deployment plan for business

intelligence environments, reporting utility acceptance, and training

by consulting firm for remote development team

. Implemented data integrity improvements and coordinated 100,000-record

legacy data migration across ERP (NetSuite), CRM (Salesforce), and

payment suite (Zuora and internal software) platforms

. Automated 1,000-team, 30,000-student hourly schedule, daily shift, and

student attendance reporting for Live Instruction by developing re-

usable stored procedures for business intelligence environment (MySQL)

in operational data store, increasing efficiency of reporting by more

than 40%

. Improved data quality through refined business processes, custom

object optimizations, and automation within production systems

(Salesforce.com, Zuora, NetSuite) to increase KPI reliability

throughout the company

. Managed multi-point business intelligence decision matrix (proof of

concept) for remote development team, including evaluations of

MicroStrategy, TIBCO Spotfire, Tableau, Birst, and Board

. Administered data connections, information schemas, and user

management procedures for TIBCO Spotfire

. Synchronized development team efforts with other company divisions

ESL instructor Nov

2010 - June 2011

. Designed and implemented centralized schedule, PTO, payroll

management, and quality assurance management for 200+-employee Live

Instruction division using CRM suite (Salesforce.com), form suites,

and external scheduling suites as part of department automation

project

. Presented proof-of-concept for re-modeled CRM suite custom objects

(Salesforce.com) to better serve both short-term goals (increased

sales and advising efficiency) and long-term historical data needs

. Mentored teachers as senior provider of University-level advanced

grammar and syntax assistance, word usage clarification, and

pronunciation during hourly live classes of up to 11 students for non-

native English speakers

. Provided detailed and personalized feedback for students, evaluated

and updated 6-tier multi-media learning module content, and planned

teacher-student feedback forum

Assistant to the Director of the Center for Freshman Advising

Dec 2005 - June 2011

Center for Freshman Advising, University of Miami (Coral Gables, FL)

. Provided and improved metrics necessary to effectively evaluate and

optimize academic advising, student distribution by major, and predict

advisor needs by semester (SQL and MS Excel)

. Re-engineered, updated, and maintained database of first-year students

using aggregate information from multiple sources (MicroStrategy EDW,

MS Excel, MS Access), reducing manual work by over 30%

. Implemented streamlined emergency ETL procedures that enabled office

staff to update key information using MicroStrategy on an ad-hoc

basis, reducing gap in data availability

. Defined business rule logic and executed business rule automation for

first-year student guidance, inter-departmental projects, and Center

operational and supply needs by semester

. Established, maintained, and streamlined digital mass communications

between students, advisers, and academic offices, eliminating almost

100% of copy and manual work

. Installed and provided support / end-user instruction for software

used in Center

. Led team of student assistants though office modernization project

Associate Technician, End-User Support Oct

2001 - Dec 2005

Information Technology, University of Miami (Coral Gables, FL)

. Provided IT staff with extensive computer support (hardware, software,

network) in both Windows and Unix environments

. Oversaw case management, coordinated work distribution, and trained

student workers in student service center, resulting in increased

efficiency and 50% fewer overtime hours

. Deployed, maintained, and supported key enterprise applications

including: Microsoft Office Professional suite, Connected Backup,

Dell OpenManage, and Symantec antivirus

. Executed business rule mining and implemented improvements to server

data backup, offsite storage, and student support case management

procedures

. Special projects: bootable rescue discs and flash keys, writing

technical process documentation for software installation and support,

website maintenance and HTML standardization

EDUCATION

University of Miami Coral

Gables, FL

Bachelor of Computer Science with a minor in Mathematics (May 2011)

Bachelor of Psychology with minors in English, Philosophy (May 2011)

Bachelor of Liberal Arts with focuses in Literature, Sociology, and

Mathematics (May 2011)

Contact this candidate