Jiri Vosta

Analytical and BI support for Business Departments Support branches in CR and abroad (SK, RU, HU) Creation of analyses and reports Programing in Excel VBA and T-SQL Creation of Stored Procedures (MS SQL Server)

Analytical support of back-office Creation of reporting - definition of resources, generating and visualization of outputs Reports for daily operational management, incl. capacity management and cost optimization Trend statistics, comprehensive management reporting Managing of datawarehouse (datamart) Monitoring of process inconsistencies and process optimization

Analytical services for Consumer Business Unit Cooperation in creating internal systems with external suppliers Data mining from internal systems and design of predictive models Preparation of targets for proactive communications to customers Recommendations based on prepared analysis Analytical support to Senior Management and other departments

Work for main client Telefónica CR (leading telecommunication operator in CR) Responsibility for assigned projects (preparing of cost estimates, negotiation with clients) Presentation of results and analyses Campaign Management, Cross-Selling, Up-Selling (campaign evaluation and subsequent recommendation) Advanced data handling Team management, co-ordination of work and priority assignment Recruitment of new employees and their training

Work for main client Telefónica CR (leading telecommunication operator in CR) Administration of the collection of large dB of customers with their detailed characteristics Campaign Management, Cross-Selling, Up-Selling (definition of target and comm. channel, schedule communication incl. Follow-up) Calculation of basic indicators Preparation of standardized analysis and transfer the results into a presentation Regular reporting and corresponding automatization Basic interpretation of the data

System issues analysis and resolving of problems Provide a consultancy service to the users Project management, implementation of system and business process changes

Development of software systems for Sales department in cooperation with suppliers Creation of report automatization with help of MS Excel and simple macros in VBA Technical support of Sales Rep (database management of outlets, wholesalers and sales representatives)

Applied Informatics