Sales Management

Guilherme Cramer de O. R. Noronha

630-***-**** ● acsti0@r.postjobfree.com ● http://www.linkedin.com/in/guilhermecramer SENIOR DATA ANALYST

A highly regarded, well-qualified, and superior problem-solving leader with the expertise and advanced ability to identify trends, develop strategies, uncover underlying issues, and provide workable solutions. Expertise in leading teams, consulting in international businesses, performing strategic analysis/discussion, critical thinking, business plan development, and presentations. Fluent in Portuguese and English, with a knowledge of Spanish, French, and Italian. Willing to relocate. Currently seeking a management-level position where a deep and varied skill set can best be utilized. AREAS OF EXPERTISE

Marketing and Sales Analysis ● Forecasting ● Business Intelligence ● Data Scientist ● Leadership/Management ● Development Plans ● Business/Consumer Insights ● Solutions Advice ● Project Management ● Warehouse, Oracle, Business Objects, other BI tools ● Strategic Analysis/Problem Identification ● Software/Content Testing and Documenting PROFESSIONAL EXPERIENCE

CHAMBERLAIN COLLEGE OF NURSING, Downers Grove, IL, 2014 – 2015 Institutional Effectiveness Senior Data Analyst

Managed projects and collaborated with multiple departments to maintain accreditation; improved student experiences. Completed forecasting, surveys, strategic analyses, and KPI development, also utilizing MS Access and SQL. Advocated multiple process and policy changes/improvements that were eventually adopted by the company. KEY ACCOMPLISHMENTS:

Optimized bimonthly reports and processes; developed student enrollment forecasting for programs and clinical sites.

Created efficient and streamlined post-course exit surveys to gather student/course data.

Improved bimonthly performance of student, teacher, and program performance reporting. VILLAGE OF ROCKTON, Rockton, IL, 2013

Consultant (MBA Research Project)

Developed a comprehensive business, social, and an all-encompassing, long-term development plan including marketing analyses, management plans, operations plans, and finance/risk analysis within city budgets. As the group leader and project manager, led scouting visits to Rockton to gather insights, take photographs, and survey locations. Developed a vision based on Rockton’s past to lead the future, a concept well-received by the mayor and city boards. MCDONALD’S CORPORATION, Oak Brook, IL, 2008 - 2011 Latin America Business Insights Specialist

Reported to the VP of Marketing, Strategy, and Insights of Latin America, tasked with intelligence gathering, product insights and analysis, as the subject matter expert for sales and product data. Identified and communicated trends/insights to senior management, and performed extensive work with senior leadership in Marketing and Operations. Developed, managed, and presented business reviews, performance reports, and pricing audits. Utilized economic journals for forecasting, performed detailed analysis of sales, transactions, and consumer trends. Managed and trained external vendors. KEY ACCOMPLISHMENTS:

Restructured and managed sales databases to include individual reports on product categories, transactions/sales from stores through the country level; items, promotions, and revenue comparison through menu categories.

Post-program analysis for large initiatives such as FIFA World Cup 2010, and 2008 Olympics.

Developed/communicated analyses of historical Happy Meal performance, comparing results to specific promotions and property licenses, resulting in changes to property/license selection, pricing, offer timing, and budget allocation.

Created detailed pricing reports on maximizing margins leading to a company pricing initiative to reestablish the product versus price relationship.

Developed and led a cross-functional project that track hourly/daily sales; eventually adopted throughout the company, to uncover opportunities to increase foot traffic and check averages.

Analyzed sales, operations, and real estate for new and re-imaged stores with qualitative summaries included in the McDonald’s Board of Directors report. Prepared quarterly financial, real estate, operations, and HR scorecards.

Developed, prepared, and presented the McDonald’s Latin America franchisee satisfaction survey. EDUCATION

NORTHERN ILLINOIS UNIVERSITY, DEKALB, IL, MBA and BS in Economics UNIVERSITÉ MONTESQUIEU-BORDEAUX IV, BORDEAUX, FR, Masters in International Management

Contact this candidate