George Mitea

+ Customer Database administration (CRM-Salesforce, SQL Server); + Delivery the data for sales and marketing team for analyses from the biggest to lowest level of granularity; + Analyses for marketing campaigns from product to categories or producer, support for building promo plan; + Sales analysis and target building for tracking achievements versus target from sales representative to the country level; + Analyses for marketing campaigns from product to categories or producer, support for promo plan building;

+ Weekly sales reports and market shares by distributors; + The report with plan of sales and marketing integrated general and for RM, RSM and ZSM level; + Monthly business analysis that presents the image of company with all data from all departments like sales, marketing, financial, HR, business development and regulatory; + Calculations of sales, market shares for our products and the competition from the markets where we drive; + Calculations of commissions for medical representatives and marketing team (RM, RSM, ZSM, NSM, KAM, BM, MM)

+ Analyze complex data systems and create solutions using Microsoft database technology set + Understand and translate complex business needs/requirements into functional specifications, ensuring the quality of the software and taking into account non-functional requirements + Calculation of commissions for B2B team(AM, ASM, RSM). + Activation report from sales field for commissioning. + Churn report to manage client's cancellations services. + Activities report for sales field to manage their daily activities and used for commissioning. + Monthly revenue report used to commission RSM, ASM and Coordinators (made to client level) + Retention report that manages client's portfolio for accounts managers used for commissioning. + Portfolio report, made quarterly to redistribute portfolio from SOHO region to DSF region.

+ Maintenance and improvement of the informational system that refers to debtors from the department portfolio for satisfying the necessity of reporting and taking decisions. + Optimizing operational flows and work procedures used in clients' processing from DRRC department. + Understand and translate complex business needs/requirements into functional specifications, ensuring the quality of the data. + Develop and maintain understanding the key elements of department flows and processes, tracking processes that can generate operational losses and provide support for remedying these incidents. + Identify and implements solutions to make reports with a high degree of accuracy for the database with non-retail exposures being in non-reimbursed condition (Default Database).

+ Manage SQL database with clients from distributors. + Create and optimize complex SQL queries + Manage Transart database. + Verifying sales campaigns from distributors to pharmacies (rebate or credit note) + Sell In from RB to distributors. + Sell Out from distributors to pharmacies. + Sell Out from pharmacies to patients (recreate an Access database from IMS data for efficiency). + I made an application in MS Access for the marketing-detailing department that manages contracts and scheduled events. + Stocks from distributors. + Creation and correction of the purchase order for distributors. + Verifying the rebate that distributors required from SO campaign. + Creation, updated and calculated forecast at product and brand level.

+ Issuance, verification and communication of sales and stock reports daily, weekly and monthly. + Issuing periodic reports for sales team. + Reports with client number by channel, month, and year. + Generation standard analyses, as well as those required by management.

+ Analysis of sales, inventories, budgets, daily, weekly and monthly on shops, divided into brands, seasons, groups or subgroups with related graphics. + Create items, hierarchy, features and update the database with new articles from Esprit, Springfield, Women' Secret and Peacocks. + External sales reports on store inventories and collections. + Ensure proper operation of computers, network and database of the company in collaboration with IT department. + Negotiation and calculation the freight cost producer and its distribution in the final value of the product.

+ Relationship with customers, distributors what sales and offers from pharmacies as well as bonuses for sales representatives offers in progress. + Create a database in MS Access and processing of reports in Excel as a pivot to facilitate the work for sales department, marketing and supply. ERP data are extracted from the company, reports from distributors and also from Cegedim report. + Centralization and tracking inventory from distributors. Monitoring, compilation and accounting of promotional campaigns. + Centralization and monitoring reports of the presence in pharmacy sales representatives. + Centralization and monitoring-system-access surveillance company. + Other on-demand management reports.