Fori Oktavianto, S. Kom's Linkedin Analytics

25 years Experience in Salesforce Effectiveness, Business Intelligence, Data Warehouse, Software Development Life Cycle, IT, and Project Management. Bachelor of Informatics Engineering from Budi Luhur University. 10 years of Salesforce Effectiveness experience : • Maintain sales operation database (Product, Channel, Outlet) and territory mapping (Region, District, Territory, Field Force) • Provide Daily, Monthly, and Annual Sales Report. • Provide KPIs for the Sales and Marketing Team. • Provide BI analysis about the Pharma Market from IPMG and IQVIA. • Sales Incentive Calculation 10 years of Business Intelligence and Data Warehouse experience: • Data warehousing using Star Schema with Microsoft SQL Analysis Service, Power Pivot, and Power Query from multiple data sources: text file, dbf, excel, and Tableau dashboard. • Complex Data query with Microsoft SQL Server, • Dashboard development with Microsoft Power BI and Microsoft Excel. • Large scale database with 5.000.000 people data. 13 Years of SDLC (Software Development Life Cycle) experience: • Desktop Application Programmer, • Business System Analyst • Data Normalization Designer and SQL Server Database Administrator. • User Acceptance Test • Documentation 13 Years of IT and Project Management experience: • Project Management and Vendor Management when I was IT Head at Plaza Toyota, • Lead network and infrastructure helpdesk team when I was IT Head at Plaza Toyota, • Led programmer team when I was Programmer Head at LGNOTA. Accomplishment: • Earlier Executive Dashboard daily data update from 10:00 AM to 6:35 AM, • Shortened lead time of monthly Sales Claims from 5 days to 2 days, • Shortened lead time of monthly Incentive Calculation from 3 days to 1 day, • Shortened annual Field Force Territory mapping lead time from 20 days to 5 days. • Earlier IPMG and IQVIA data submitted from the 10th to the 5th day of every month. • Marketing Operation System and Microsoft Power BI Dashboard. Accomplishments from previous company: Plaza Toyota : • Evolved Plaza Toyota Workshop IT Infrastructure from 0 workshops in 2006 to 6 workshops in 2011 located in Jakarta, Serpong, and Bandung. • Implemented ERP, CRM, Workshop service, and spare part inventory software. • Build plazatoyota.co.id website. PT Hyundai Mobil Indonesia: • Build and implemented Vehicle Sales Operation application application software PT Bimantara Citra Tbk: • Build and implemented Fixed Assets and HRIS application application software Good Communication Skills, Fast learner, Target Oriented, Team Player