Graduated in Business Administration . Intermediate English . 9 years experience in national and multinational companies in analysis , management strategy and planning, marketing and sales in B2B and B2C channels . Experience in market assessment , management and Sellin / Sellout . Strategic and systemic view of various business segments and complexity , ability to work with multiple integrated teams , identify internal needs and ability to lead and develop people. ADM and Sales Management. Training and management of distribution channels . Datacleasing , segmentation , cross-selling , identification, extraction, classification and organization of information in business intelligence , CRM and DBM knowledge , Excel , Access, ETL , Web Analytics , SAP BW , PivotTable . In the last four years I have been focused on planning, intelligence and administration of sales .
Specialties : Planning, Administration and Commercial Control, Planning and Demand Management with the sales team , Process Management , Pricing and Forecast
Report directly to the Sales Director PLANNING - Support for S & OP meetings with indicators and consolidated sales estimates to support demand planning by providing indicators of need for imports . Product mix analysis , defining KPIs and progress tracking for effective commercial policy , positivization categories and market penetration through distribution channels . Sales Estimates - Responsible for the maintenance and consolidation of Estimate "year to date " plan to achieve "year to goal " ( the Budget Forecast ) Interface areas with Mkt Trade , Supply, Marketing , Finance and Sales . Creation and maintenance of BI Sales ( based on Sharepoint and Power Pivot , reflecting historical Sellin by channels , categories , brands , SKUs , providing management information for Officers, Supply Chain , Finance , Trade Mkt , Marketing and Sales . Support strategic analysis ( internal and market ) with the directors of sales . Planning goals of the sales team Participation of product pricing strategy and commercial policy ( external data collection and internal meetings ) MANAGEMENT - Management of 2 people in the area, Variable remuneration committees and Control of variable remuneration , assessment and communication. Rebates - Management providing rebates of sales area to report to the finance and monitoring of investment per customer plan. Commercial Policy - Responsible for communication, implementation and management of trade policy in the SAP system Budget Control of sales administration . Expense Control Communication - Management of daily communication with Sales team (Goal vs Plan , adjustments estimates , monitoring of variable compensation , growth of the credit portfolio, control inventory reports and forecasting availability of items , open orders management mailing customers. and dissemination of results . Responsible for training and integration of the sales staff in the use of information , management reports , software . Operational management of the client portfolio - Registers clients , daily monitoring of incoming orders , adjustment problems , interface with Finance , Customer Service , Supply . Participated in the team responsible for indicating index strategies to improve engagement of people . SAP - Worked with BPC (Business Process Champion ) for 1 year in the implementation of SAP in Brazil . Responsible for the entire process flow area within the ADM sales of OTC module of SAP . Coordination of all reports of Sellin Division Writing using BEX Analyzer and IRIS , with user key in the creation and maintenance of regional reports for global dissemination . SELLOUT - Coordination deployment analysis Sellout tool through partnership with business Genexis Responsible for indicators SELLOUT ( Break , Dropsize , DOH , stock, SELLIN VS SELLOUT ) , competition analysis .
Indices of Productivity Analysis, Trends, Pricing, Planning Field of 200 executives, Analysis of NCC, NetSales, Market Share in Business Intelligence (CRM 127 and CRM 132 SAP BW). Domain analysis of the Pivot Table for OLAP Cube. Database Marketing and manipulation of large databases of legal person (cadastral, history of CRM, field plan, bases Supply, curve ABC). Exploratory analysis and data cleansing. I also used to Datacleasing and the Kettle ETL, and SAP. Maintenance of the hierarchy structure of sales.
Domain xlam Excel Add-ins for managing routines with VBA, creating applications in Visual Basic to the area as a system of sending mail with attachments to large databases, system for generating customized reports for sales team. Field of SQL Server, XML, Access and Excel. GeoMarketing used, plotting and routing schedules field plan. Preparation and presentation of performances. Planning and implementation of the tool in Excel for management of the simulators of variable compensation for all executives.
Development of sheet prices for the country, including IPI, ICMS and ST for 2000 products.
Data analysis, identifying opportunities and strategic fixes, turning data into information systems analysis experience with CRM.
Elaboration of strategic planning, action plan, fitness reports, exploratory data analysis.
Segmented based surveys with a focus on market information, experience in negotiations with representatives and distributors, management and visits to potential customers.
Responsible for portfolio management of U.S. $ 2500,000,00, including client as AmBev, Plant Jacarezinho, Alsco, Scania, Mahle, Duratex Superhighway, Petrobras, Caterpillar, CSN, Parker Hannifin, Colpal, Mercedez, Orsa, Toyota, Schindler, Souza Cruz and Votorantim. 10% increase in sales team.
Development projects with the departments of Marketing and Communications for stock sales.
Responsible for raising and maintaining customer base, extraction and manipulation of individual data, data enrichment, studies of market potentials and breakeven analysis.
Clean database (Datacleasing), segmentation, responsible for the quality of the mailing, cross-selling, identifying, extracting, classifying and organizing information and knowledge with CRM DBM, Excel, Access, ETL, SQL Queries and manipulation of database large, with 10 years history of the company.
Web Marketing realized, coordinated customer relationship via the web and by telephone.
Coordinated sales of subscriptions in the stands at literary events such as Festival of Japan in 2007 and 2008, Anime Friends 2007, Biennial Book / RJ 2007. Biennial and SP 2008.
Oversee sales of subscriptions to the magazine Made in Japan domestically.