frans tjandra

Office of the Vice President for IT and CIO (OVPIT) leads the IT services that support the faculty, students, and staff on all IU campuses and beyond. Obtained better price negotiation for IU e-Text with the publishers by providing insightful information regarding the price comparison between the current IU e-Text’s price and Amazon through data analytics on Microsoft Excel Achieved 90% of the total student registrations in the integration of Duo (dual log-in authentication) by developing an engagement strategy to reach and educate the students through different campus’ media platforms

Accenture is a leading global professional services company providing a range of strategy, consulting, digital, technology & operations services and solutions. Created virtual assistant personality, conversation flow, and UX/UI design for client’s chatbot to convert customer service inquiries from social media channels to sales Enhanced chat bot’s NLU (Natural Language Understanding) based on the fallback intents and customer feedback to boost customer experience and the accuracy of the service requested by adding combinations wording Maintained error rate of the chatbot to be below 10% on AI hub, Auth0 hub, and Google hub by performing quality assurance on the system network, conversation flow and locating bugs on the system log Improved the working process efficiency by managing Jira (agile software development tool) and generating a weekly report to track the project performance and timeline

BUS-K 303 provides an introduction to the ways that technology enables and empowers business decision-making. In this introductory analytics course, students will learn how companies apply technology tools to prepare, analyze, model, and display the information used to manage their business by using Microsoft Excel. Recognized in the top 15% of peer tutors for mastery of simulation modeling, data visualization, and classroom leadership in fall 2016 Selected as the top 10 peer tutors by instructor and TA to hold office hours and accommodate consultation for students Assisted instructor and TA to mentor over 40 students in the advanced application of Microsoft Excel during class sessions

BUS-K 201 provides an introduction to the role of computers and other information technologies in business. It provides instruction in both functional and conceptual computer literacy. Topics include technology and organizational change, telecommunications, privacy in the information age, and business security on the Internet. The course presents an introduction to two of the most widely used database and spreadsheet packages: Microsoft Access and Microsoft Excel. The goal is to show how they can be applied to real business problems to help make important decisions. Provided in-class assistance to 30 students by clarifying class materials and troubleshooting errors in Microsoft Access and Microsoft Excel Held recap sessions with TA to help students review class materials and answer questions for exam preparations

* EY is a global leader in assurance, tax, transaction and advisory services. * Shortened the duration of tax report preparation by validating, identifying and compiling relevant transactions on Microsoft Excel from the database * Established more compelling information as evidence to appeal request letters from an analysis in business tax regulations, financial reports, and contractual agreements

A major food company in Indonesia that specializes in producing snacks and instant noodles. Their products are not only consumed by local people but also exported to other countries such as United States, Canada, Kenya, Russia, Brunei Darussalam, and Singapore. - Engaged in a mid-year review meeting that was attended by employees from other branches around the world and learned how Indofood adapts their business in different countries. - Gave a suggestion to reduce the marketing cost up to 20% in Kenya by allocating the funds to advertisements on social media such as Facebook and Twitter instead of spending the funds on TV advertisements. - Revised the design of the packaging of Indomie to be more attractive to local people to increase the sales in Brunei up to 10%.

Activities and Societies: Permias Bloomington

Earned the certificate of achievement in business-transfer Activities and Societies: Indo DVC, DVC PBL, DVC Enactus, International Students Club