Corporate Business Analyst Resume Format in Word Free Download

Sample Template Example of Beautiful Excellent Professional Curriculum Vitae / Resume / CV Format with Career Objective, Job Description, Skills & Work Experience for Freshers & Experienced in Word / Doc / Pdf Free Download

Joy Cocek

309 Harriet Road, Coos Bay, OR 97001

541-297-9876 joy.cocek@gmail.com

_____________________________________Professional Experience____________________________________

The Mill Hotel Casino and RV Park North Bend, OR 97459                                                 January 2011 - Present

Database Marketing Manager (Current)

Reporting to GM, responsible for all CRM efforts related to customer acquisition, retention, and reactivation programs.

      Strong experience in SQL Server environment (2005 and 2008) utilizing SSRS, SSAS, and SSIS BI tools.

      Advanced knowledge of relational database concepts and best practices.

      Expert knowledge with the development and implementation of customer reward program philosophies that drive incremental revenues, both short and long term, while eliminating expenditures.

      Completely involved with developing and implementing a new customer loyalty program philosophy relating to mission statements, positioning, brand management, direct mail segmentation, and player development.

      Effectively developed customer lifecycle models and campaign management strategies that lead to multichannel customer communication avenues and incremental streams of revenue.

      Developed automated and reusable routines for extracting requested information from multiple databases.

      Advanced marketing campaign management techniques to include: real time marketing, guest segmentation strategies and insights, predictive analytics, regression analysis, and database management.

      Project manager for KPI reporting and real time financial scorecards delivered to senior executives.

      Excellent analytical, modeling, forecasting, and budgeting skills.

      Effectively lead and mentored 5 analysts to consistently deliver departmental analysis in an accurate and timely manner.

Affinity Gaming, Inc. Las Vegas, NV 89118                                                             March 2010 – January 2011

Corporate Business Analyst

Reporting to Regional GM, responsible for enterprise wide data analysis and reporting solutions.

      Excellent SQL coding and design of stored procedures, functions, tables, views, triggers, indexes, constraints.

      Advanced knowledge of (ETL) techniques, with an ability to maintain existing or create new ETL jobs.

      Responsible for database integrity and maintenance for optimal performance.

      Experience with database backup, recovery, monitoring and consolidation.

      Expert knowledge with the development and implementation of customer reward program philosophies

      Extracted and manipulated data to create custom reporting for business intelligence needs utilizing SQL 2005.

      Effectively produced and communicated analysis results and made recommendations to senior executives.

      Completely automated manual and repetitive analytical documents prepared by department leaders.

      Fully involved with planning and presenting enterprise budgets and financial metrics for 13 major casinos.

Corporate Financial Analyst                                                                                            October 2009 – March 2010

Reporting to CFO, fully involved with the budgeting process and the implementation of financial reporting standardization.

      Developed custom financial reporting for executive management utilizing Great Plains and FRX.

      Project Manager for developing an enterprise-wide business intelligence reporting module utilizing SSRS.

      Fully involved with corporate P&L reviews, developing annual budgets, and preparing monthly financial and operational reports for 13 casino properties.

      Implemented player reinvestment benchmarks to assist company in maintaining bottom line profit.

      Fully involved with providing analytical support to all internal operating departments.

      Tasked with periodic market research assignments and competitor analysis for future casino opportunities.

Corporate Marketing Analyst                                                                                         May 2008 - October 2009

Reporting to CFO, Fully involved with stratifying customer segments for direct mail programs and providing marketing support to upper management.

      Tasked with the development and implementation of standardized proformas and postformas for entire enterprise.

      Cross team collaboration with IT to develop and optimize stored procedures, functions, tables, views, triggers, indexes, and constraints for marketing and financial analysis reporting.

      Responsible for the extraction of segmented mailing lists for 3 Nevada properties.

      Analyzed promotions at 3 Nevada properties identifying psychographic and demographic trends of gaming customers.

      Project Manager for a new custom reporting module for the entire enterprise for business intelligence purposes.

      Effectively migrated all historical Access 2000 reporting extraction tools into a SQL Server 2005 environment.

      Provided ad-hoc zip code and regional demographic analysis to upper management utilizing Microsoft Map point.

      Fully involved with the launching a tiered customer rewards card at 13 casino properties in Nevada, Iowa, and Missouri.

Caesars Palace Hotel and Casino Las Vegas, NV 89109                                          January 2004 – May 2008

Guest Service Manager (Quality Assurance Manager)

Reporting to VP of Hotel Operations, Developed and implemented management trainee programs throughout the hotel and built relationships with UNLV contacts.

      Successfully created all internal marketing employee collateral for Guy Savoy, Rao’s, Qua Baths and Spa, COLOR Salon, and the Forum Tower for over 7,800 associates.

      Fully involved with the daily yield management of 3600 rooms and suites.

      Maintained the integrity of Caesars Palace by selling guests on options available to them when items or standards were not in place or available.

      Recipient of esteemed Harrah’s Entertainment Chairman’s Award for Community Service within first year of service.

      Developed cross training for managers and interns at 4 Las Vegas Strip properties to learn best practices.

Six Flags Astroworld, Houston, TX 77083                                                                June 2001 – January 2004

Database Marketing Analyst

Reporting to Director of Marketing, Fully involved with the analysis and segmentation of customer profiles utilizing Salesforce.com.

      Tasked with the pro and post forma analysis of direct mail and e-marketing campaigns utilizing ad hoc statistical analysis.

      Effectively maintained and segmented customer database to maximize profitability on direct mail and email campaigns.

      Utilized SQL Server 2000 for ad-hoc database analysis identifying trends in profitability and consumer psychographic and demographic behavior patterns.

      Responsible for writing and executing reports in Salesforce.com platform.

P.O.E.T.S. Billiards, College Station, TX 99745                                                       February 1998 – June 2001

Lead Bartender

Reporting to owner, lead bartender of a profitable billiard lounge.

      Collected money for drinks served.

      Effectively checked customer identification to verify age and eliminate underage drinking in the organization.

      Tasked with balancing cash and credit receipts nightly.

      Ordered liquor and other bar supplies from various external vendors.

      Planned, organized, and controlled the operations of the lounge.

Education:

Bachelors of Science Hotel Management – The University of Houston (2003)

Visual Basic Certification

Download Resume Format