Data Analyst Los Angeles

CORY N. RAUGUTT

Jarrell, TX

*.*******@*******.***

References available by request

EMPLOYMENT HISTORY

Data Analyst • Austin Community College, Austin, TX • 10/16 – Present

Writing complex SQL queries with aggregate and window functions to construct and analyze large datasets

Configuring ETL processes to migrate, clean and integrate data from multiple sources

Creating interactive BI reports and dashboards to forecast trends and business opportunities

Understanding business process flows to identify and report opportunities for improvement

Performing data modeling, profiling, and validation processes necessary to implement a data warehouse

Mapping Ellucian Colleague data into third party reporting tools using Ellucian Tech Doc Data Analyst • Institute of Financial Management, Los Angeles, CA • 09/06 – 12/15

Created financial reports in Excel, Access and SAP Crystal Reports featuring advanced formulas, drill downs, charts, and pivot tables

Developed and administered an Access relational accounting database featuring data integrity checks and custom reports including income and expense, profit and loss, disbursements and ledgers

Management Assistant II • Cedars-Sinai Medical Center, Los Angeles, CA • 06/04 – 09/06

Developed and administered an Excel database for the dental clinic residency program to track the required documents for each applicant and streamline the application process by providing detailed reports to the clinic leadership

Used advanced functions and filtering in Excel for data profiling and data validation to clean up in house data sources

Database Administrator • Paramount Pictures, Los Angeles, CA • 01/00 – 06/03

Processed approvals for newly licensed South Park merchandise by checking product submissions against Comedy Central approved artwork and tracking each submission in a FileMaker quality control database, then creating status reports for the Viacom Consumer Products product development division

TOOLS & SKILLS

Microsoft SSIS/SSMS/SSRS • Ellucian Colleague ERP • Workday Reporting • Microsoft Visual Studio

• Microsoft PowerBI • Tableau • Pyramid Analytics • SAP Business Objects • SAP Crystal Reports • Domo • Welland Export • Jira • Bitbucket • Confluence • Ataccama • Informatica • Microsoft Access • Microsoft Excel • SQL • VBA • JavaScript

CERTIFICATIONS

ITIL Foundation Certificate in IT Service Management Microsoft Office Specialist

EDUCATION

B.S., University of Wisconsin

Contact this candidate