Database Marketing Analyst

· Continuously recommend new and better ways to use market data including research, segmentation, geo-demographic analysis, web analysis, etc.
· Manage all online programs, measurements, tracking and analysis of ongoing traffic and interactive lead generation programs.
· Manage robust database quality and cleansing processes including implementing new on-demand software technologies for Salesforce.
· Align business processes around marketing automation to ensure sales leads are maximized.
· Research market trends, gather market intelligence information, and give presentations to senior management.

MARKETING ANALYST 2005- Present
Kaiser Permanente / Commercial Programming Systems
Direct Response Marketing - Small Business
· Organized and processed sales and marketing information while conducting qualitative and quantitative analysis for the small business market segment.
· Assisted in the development of data collection and analytical tools to produce key metrics for dashboards, management reports, and direct mail marketing campaign analysis.
· Performed direct response marketing campaign management activities using database management tools, vendor portals, and direct mail campaign management systems.
· Helped to create small business market profiles and segments to maximize response rates for direct mail campaigns.
· Interfaced with Marketing Manager and Database Marketing Manager on test marketing strategies of new creative content with various calls to action.
· Introduced decay curves for post-mortem statistical analysis of response rates to help determine optimal marketing efforts for future direct mail campaigns.
· Presented sales and marketing analysis while making recommendations (for management and clients) for better decision making.

MARKETING ANALYST 2005
National Notary Association, Chatsworth, CA
Management Information Systems
· Monitored, maintained, compiled, and evaluated sales and marketing data while conducting analysis to report findings.
· Analyzed financial impact of marketing programs by measuring profit & loss, return on investment, and gross margin analysis.
· Assisted with the on-going capital budgeting and forecasting process by attending weekly meetings.
· Collaborate with Operations Manager on inventory management to ensure effective turnover of assets.
· Prepared marketing research and web trend reports for Marketing department while gathering competitor information and disseminating key findings.
· Analyzed marketing effectiveness for direct mail campaigns by measuring response rates, decay curves, and key metrics.

NATIONAL ACCOUNT SALES ANALYST 2004
Aurafin ? OroAmerica, Burbank, CA
Sales Planning & Analysis
· Provided analytical support to the sales team with timely point of sale, inventory, and category planning for all national accounts.
· Compared sales trends to forecasts while maximizing inventory levels to capitalize on demand.
· Made adjustments to indexes based on seasonality, demand planning, and other directly related causes.
· Issued daily procurement sales orders for largest account worth approximately $50 million in revenue.
· Managed vendor sales and inventory data using a relational database program. Built an EOQ model to pinpoint the appropriate ordering point, lower inventory holding and ordering costs, and ensure no out of stock situations.


FINANCIAL ANALYST
Walt Disney Studios / Ajilon Finance 2002 - 2003
Account Product Management
· Provided forecasting and replenishment support on key accounts within the Buena Vista Home Entertainment division.
· Made improvements to forecast model by incorporating statistical controls while using advanced Microsoft Excel spreadsheet techniques.
· Interfaced with territory Sales Manager on retail sales planning and strategy issues. Provided tactical and timely information to make better business decisions.
· Issued daily procurement orders while working closely with the forecasting department to re-compute weekly projections.
· Maintained constant communication with functional areas such as Operations, Sales, Account Product Management, and Marketing.
· Supported Senior Financial Analyst with Tomorrow Land system conversion project by auditing accounts.
· Prepared consolidated income statements across business lines while helping to ensure data integrity from old legacy systems to SAP.

SALES ANALYST / MARKET RESEARCH ADMINSTRATOR 2000 - 2001
Toyota Motor Sales USA, Torrance, CA
Strategic Planning
· Administered daily, weekly, and month-end regional sales reporting.
· Performed market research using primary and secondary data sources.
· Managed the customer relationship program (CRM) for customer retention.
· Advanced spreadsheet analysis, A3 presentations for corporate managers, and special projects.

MARKETING COORDINATOR / ANALYST 1993 - 1997
Sony Pictures Entertainment, Culver City, CA
Worldwide Product Fulfillment / Worldwide Pay Television Accounting & Finance
· Consolidated and distributed network air-schedule for field office and offer departments.
· Managed procurement orders for satellite mastering and videotape duplication.
· Coordinated satellite feeds with post-production facilities and issued purchase orders.
· Facilitated revenue reporting and analysis
· General ledger analysis while researching variances.

SKILLS
Marketing Analytics Data-Mining Statistical Modeling Forecasting
Sales Planning Access Excel PowerPoint
ODBC SQL, SAS, SPSS, SAP Mainframe
AS400 AS400 Query Pivot Tables Crystal Reports
Business Exchange Visio QAD Hyperion Enterprise
Essbase HFM Business Objects Data-Modeling
Salesforce.com CRM Lead Management Business Processes

EDUCATION
California State University Northridge 2001- 2004
College of Business & Economics
Bachelor of Science ? Business Administration / Marketing

West Los Angeles Community College 1999 - 2001
Pace Program
Associate of Arts Degree ?Liberal Arts

EXTRA CURRICULAR
International Programs Division 2001- 2002
Study Abroad in Asia for one year

MICROSOFT CERTIFICATIONS
Access 2000 & Excel 2000

SAS