Ken Derosa

Ken Derosa

Data Analytics Reporting · APC Partner Services, Inc

Ladera Ranch, CA

In My Own Words

A dynamic, driven, and experienced leader in the Administration/Account Management, Social Media, and Data Analyst Skills in Manufacturing, Insurance, and Internet Digital Media Industries

Work Experience

Data Analytics Reporting

APC Partner Services, Inc

2015 – Present

Heavy Excel reporting (V-Lookups, Pivot Tables, Graphs); manage Excel research projects Provide data competitive analysis and data trends; prepare PowerPoint presentations for the CEO

Order Entry Specialist (Temporary Assignment)

Dell Software

2014 – 2015

Entered orders into Siebel database; processed Purchase Orders and invoices Worked with Sales team to obtain missing information on orders Performed analysis and updates in Salesforce with client accounts

Online Media Coordinator

YPM INC

2012 – 2014

Monitored performance metrics and competitor activity for client accounts Managed client online ads; verified and audited ad performance Developed Excel reports (V-Look Ups and Pivot Tables); prepared PowerPoint presentations Provided clients with program optimization, metrics analysis and budget creation; supported plan timelines for new product releases

Administrative Assistant

Boulder Manufacturing

2008 – 2012

Supported Vice President and Managers with aircraft sales and marketing functions Issued purchase orders; prepared quotes and proposal request packages; prepared invoices Created, managed and updated inventory Excel spreadsheets; issued monthly invoices

Contract Analyst

Apria Healthcare

2007 – 2008

Worked directly with the Legal Department Attorney on new contracts Proofread and redlined contracts; recommended appropriate revisions and cancellations Managed special research projects; filing, scanning, data entry

Data Management

Safeguard

2006 – 2007

Loaded data and corrected database errors, analyzed and audited databases for accuracy Maintained and created customer databases; managed client accounts; generated reports Complied monthly status reports for senior management; performed heavy data entry

Support Specialist

Pacific Life

2003 – 2006

Processed customer applications and examined for accuracy; verified insurance information. Processed mail, handled filing, faxing and photocopying; performed data entry and mailings. Scanned and routed applications, invoices, and contracts into database and performed data entry Assisted IT department with the implementation process of new software; tested software Wrote department procedures for new database; trained management on new software

Education

Certificate

NEW HORIZONS

2001 – 2005

Certificate

Bachelors Degree

Saddleback College

1982 – 2016

Bachelors Degree

Interests

TravelLearningHikingInvestingConcertsCruisesRare music collectorMovie enthusiast

Industries

BikeGolfDiveCreative AgenciesFashionFishingLifestyleMoto & PowersportsMusicOutdoorRunSkateSnowStreetwearSurfSwimTechTriathlonWakeYogaHealth & Fitness