Provide reporting solutions and efficiencies to properly manage standard KPI. Additionally creating Macro driven solutions for automation of data entry and lower level repetitive tasks within BU, GBS and OAM day to day activities.
Key Task:
• Daily reporting activities for key customers
• Creating macro driven solutions for automation of tasks
• Streamlining customer reporting
• Creating reporting standardization
• Ad-hoc customer reporting creation
• Creation of core source data database
• Use statistical methods to analyze data and generate useful business reports
• Work with management team to create a prioritized list of needs for each business segment
• Identify and recommend new ways to save money by streamlining business processes
• Use data to create models that depict trends in the customer base
• Work with stakeholders to outline the specific data needs for each business method analysis project
• Interpret data, analyze results using statistical techniques and pr
2018/08-2018/11 Creation of Trade lane Dashboard:
Created a comprehensive Dashboard for (Transit Pacific East Bound) Trade lane in order to monitor billing activities, which could prevent the loss of GP. It helps operation team to save decent amount of GP.
2018/05-2018/07 Tool for Billing Process:
Operation team used to create Invoices in Cargo Point one by one which was time consuming and tedious. After standardization and automation of the process for creating Invoices, an automation tool was created .
2018/03-2018/04 Tool for Vendor Upload:
Operation team used to upload Vendor information one by one which was time consuming and tedious. After standardization and automation of the process for uploading Vendor info, an automation tool was created.
2018/02-2018/03 Tool for checking Import Security Filing Manager:
Operation team used to checking Import Security Filing Manager one by one which was time consuming and tedious. After standardization and automation of the process for checking Import Security Filing manager, an automation tool was created.
2017/11-2017/12 Tool for checking carrier website:
Operation team used to check events from Carrier website manually one by one which was time consuming and tedious. After standardization and automation of the process for checking carrier website, an automation tool was created.
2016/08-2016/08 Tool for Sailing Schedule:
Some operation staffs need to download data from carrier website to generate the Sailing Schedule report. So developed a tool can automatically extract data from carrier website and generate the sailing schedule customer needed.
2016/02-2016/07 Global Ocean Dashboard:
Design the logic and appearance of Global Ocean Dashboard. Complete the Global Ocean Dashboard and delivery to BP every month.