Leonel Castellano

About Leonel Castellano

I am someone who always strives to improve and better myself every day. When presented…

Experience

1. Sr Data Analyst

   Teleion

   Jan 2018 — Present · Seattle, WA, US

   Data infrastructure and management• Provided ad hoc data import/export and transformation using T-SQL for Azure, Bing Ads, and Amazon clients• Delivered quality assurance of analytic source data, defect mitigation, database migration, and source auditing• Developed stored procedures to extract data for reports rendered in Power BI, Tableau, and QuickSight• Produced and maintained look-up tablesAnalysis reporting and alerting • Leveraged Excel and Power BI to generate automated revenue and acquisition performance views for 10+ marketing stakeholders • Use of Microsoft Flow Power BI and QuickSight to automate alerts to proactively inform stakeholders of significant performance changes• Followed GDPR and email compliance for monthly and quarterly marketing campaigns across global marketsPM/Admin• Determined business questions and objectives to produce more strategic and insightful analyses• Monitored workflow; tracking tasks through completion and making timeline adjustments as needed• Trained in agile/scrum methodologies Compliance/auditing• Experienced in mapping to controls of different frameworks (ex: ISO, Fed Ramp, and SOC) • Participated in external customer audits for Microsoft Azure & M365 global banking customers• Created Azure DevOps infrastructure for tracking audit observations from identification through remediation

Education

• Washington State University

  Bachelor of Liberal Arts – Humanities Major, Communications and Business Minors

• Washington State University

  Master of Business Administration (M.B.A.)

Skills

• Microsoft Access
• Public Speaking
• Microsoft Powerpoint
• Healthcare Marketing
• Microsoft Sql Server
• Marketing Strategy
• Program Management
• Tableau
• Power Bi
• Higher Education
• Teamwork
• Command Line (Unix)
• Strategic Planning
• Database and Direct Marketing
• Research
• Photoshop
• Powerpoint
• Microsoft Excel
• Microsoft Word
• Data Analysis
• Social Media
• Agencyagile
• Teaching
• Data Entry
• Powerpivot
• Python
• Scrum
• Customer Service
• Microsoft Office
• Business Intelligence
• Power Shell
• Direct Mail
• Community Outreach
• Access