Robert Soema Email & Phone Number

Melbourne, Vic, Au

Melbourne, Victoria, Australia

- Successfully re-designed DSM report- Created gap analysis model to forecast future SOH position- Prepared management sales presentations- Created new reports in Salefoce monitoring project pipeline uptake- Developed new project pipeline dashboards using QlikSense

Melbourne, Victoria, Australia

Melbourne, Victoria, Australia

- Successfully load Mapps into Salesforce for the BMM channel- Generate regular sales reports for the sales team- Liaise with finance to finalise budget (OP) for the sales team- Create ad-hoc reporting for the SBD sales team- Manage Krunchbox metadata- Support any queries from the sales team

Clayton, Victoria, Australia

- Created, updated & streamlined daily sales reporting- Successfully managed quarterly Bunnings business reviews- Collaborated with Finance to generate annual budgets- Liaised closely with demand planners- Supported sales team with ad hoc reporting & report training- Contact lead with external data suppliers

Melbourne Area, Australia

- Project lead for ANZ in analytical reporting dashboard- Creating & Updating existing dashboards in Tableau- Managing monthly data integration into data washing process- Providing support to ANZ Gilead sales and marketing team members- Enhanced franchise forecasting model- Supporting ad hoc reporting requests- Building rapport with internal and external stakeholders- Assist with new reporting system roll out

Melbourne Area, Australia

- Generate Generic Weekly Reports- Develop bi-monthly Generic Ranging Grid reports- Maintain 3rd Party Wholesale daily sales data- Provide monthly reports for the Consumer OTC division- Create ad hoc reports- Project Leader with the following projects: * National account territory allocation * National database cleansing * Streamlining 3PW database into data warehouse system- Support executive management with sales reports- Liaise with external 3rd party… Show more - Generate Generic Weekly Reports- Develop bi-monthly Generic Ranging Grid reports- Maintain 3rd Party Wholesale daily sales data- Provide monthly reports for the Consumer OTC division- Create ad hoc reports- Project Leader with the following projects: * National account territory allocation * National database cleansing * Streamlining 3PW database into data warehouse system- Support executive management with sales reports- Liaise with external 3rd party consultants Show less

Preparing and finalising monthly Volume Bonus commission reports & payments for Toyota & Lexus dealershipsUpdating monthly dealer presentation reports for metro and rural Toyota & Lexus dealershipsMonitoring monthly results for dealer penetrationMaintaining monthly insurance and extra care reportingSupporting the Victorian/Tasmania region with ad hoc reportingDeveloping complex dealership analysis reports to support existing dealership with changes to their… Show more Preparing and finalising monthly Volume Bonus commission reports & payments for Toyota & Lexus dealershipsUpdating monthly dealer presentation reports for metro and rural Toyota & Lexus dealershipsMonitoring monthly results for dealer penetrationMaintaining monthly insurance and extra care reportingSupporting the Victorian/Tasmania region with ad hoc reportingDeveloping complex dealership analysis reports to support existing dealership with changes to their detailsProviding administrative support to the Dealer Credit team; Achievements:Re-designed a new National report that supports the National Senior Managers and Dealer Account Managers with tracking and identifying Toyota & Lexus sales staff performanceIdentified and re-configured FY10 budget targets to ensure that numbers reflected accordingly to what was set for different Dealer Account ManagerProvided continual support with the data cleansing process of the CRM systemEnsured monthly VB payments were accurately paid within a budgeted timeframeDeveloped a strong rapport with key personnel including The National General Manager, Senior State Managers, Key Dealer Principals, Business Managers and Financial Controllers Show less

Tracking sales data on existing products on a monthly basis for sales incentive schemesEstablishing sales growth trends for marketing management teamsMaintaining the national databases to support sales and marketingLiaising with multiple data suppliers to ensure database is maintainedCreating ad hoc reports to support sales and marketing Monitoring competitor data to track trends to assist marketing with their product strategies; Achievements:Identified and redeveloped… Show more Tracking sales data on existing products on a monthly basis for sales incentive schemesEstablishing sales growth trends for marketing management teamsMaintaining the national databases to support sales and marketingLiaising with multiple data suppliers to ensure database is maintainedCreating ad hoc reports to support sales and marketing Monitoring competitor data to track trends to assist marketing with their product strategies; Achievements:Identified and redeveloped multiple reports to include new products containing complex functionality as well as simplifying previous reportsSupported the Fluvax Brand Team by collating and re-designing the product portfolio for pre-season ordersEnsured consistent high data quality for the national sales databaseMaintained a highly complex reporting system to identify the monthly progression of each sales representative to executive managementProvided detailed information that supported state tender for brand managers, which in-turn won tenders for the organisation Show less

Consolidating multiple databases from different sources after competitive acquisition of companiesCreating sales budget structure for Victoria, South Australia and TasmaniaMonitoring the sales budget and forecasts structure for State, Regional and Business ManagersAnalysing financial statistics reports from the customer sales databaseMaintaining the customer database for sales and customer retainment purposesPreparing and reviewing sales revenue reports for weekly state and… Show more Consolidating multiple databases from different sources after competitive acquisition of companiesCreating sales budget structure for Victoria, South Australia and TasmaniaMonitoring the sales budget and forecasts structure for State, Regional and Business ManagersAnalysing financial statistics reports from the customer sales databaseMaintaining the customer database for sales and customer retainment purposesPreparing and reviewing sales revenue reports for weekly state and interstate daily business manager's activity and acquisitionsUpdating the monthly revenue figures Providing local desktop support; Achievements:Successfully identified, developed and maintained a new reporting mechanism from multiple customer databases to support business strategies and identify key accounts across the different business streamsImproved the structure and data quality of customers within a consolidated databaseProgressively maintained and updated budgeted forecasts with State, Regional and Business managersEffectively provided monthly updated sales results from multiple databases which were the basis for the construction of the Sales team budgets and forecastsEnsured consistently high quality data for the Victorian, South Australian and Tasmanian customer databases Show less

Analysing gaming data and generating financial statistics reports from the Corporate Data Warehouse (CDW)Maintaining the national patron database for marketing purposes as well as updating the international patron databasePreparing and reviewing departmental revenue reports and weekly promotionsReviewing weekly, monthly and quarterly membership listing and updating unwanted patrons listsVerifying data accuracy with duplication processes with different databases;… Show more Analysing gaming data and generating financial statistics reports from the Corporate Data Warehouse (CDW)Maintaining the national patron database for marketing purposes as well as updating the international patron databasePreparing and reviewing departmental revenue reports and weekly promotionsReviewing weekly, monthly and quarterly membership listing and updating unwanted patrons listsVerifying data accuracy with duplication processes with different databases; Achievements:Successfully ensuring high data quality for the national patron databaseSuccessfully developed various KPI for membership attainment across the organisation and significantly improved customer satisfaction levelsImproved the membership reviewing process to filter and attain high quality members in different gaming membership clubsImproved the intake of international and interstate clients by providing gaming analytical reportsContributed to the improvement of revenue by successfully analysing the gaming behaviour of VIP members Show less

Responsibilities:Providing exceptional customer service to patrons who are participating from the gaming arena.; Achievements:Successfully minimised variance level during monetary transactionsExcelled in chip handling techniqueMaintained and developed financial reports on account holdersDeveloped an excellent rapport with VIP patrons

Providing exceptional customer service to patrons who are participating from the pokies arena.; Achievements:Resolved patron queriesDeveloped cash handling skillsBuilt rapport with patrons, work colleagues and managementDeveloped high stress resilience

Analysing supply chain dataCreating regular sales reports to support Strategic and Operations Management Understanding the Relational Database Management System environmentSupporting the Star Alliance group with analysis reportsProviding onsite helpdesk support; Achievements:Created ad hoc reports for internal clientsAnalysed Star Alliance reports to improve processes within AnsettSupported the Engineering Business Unit segment with cycle reportsDeveloped a… Show more Analysing supply chain dataCreating regular sales reports to support Strategic and Operations Management Understanding the Relational Database Management System environmentSupporting the Star Alliance group with analysis reportsProviding onsite helpdesk support; Achievements:Created ad hoc reports for internal clientsAnalysed Star Alliance reports to improve processes within AnsettSupported the Engineering Business Unit segment with cycle reportsDeveloped a standard reporting template for the Supply DivisionEstablished a user guide documentation on the reporting system Resolved helpdesk/desktop issues Show less

Bachelor Of Computing, Information Systems

Masters, Information Technology