panel review by jeff ho (brief version: removing logo and all confidential info)
Post on 24-Jan-2015
89 Views
Preview:
DESCRIPTION
TRANSCRIPT
1
PANEL REVIEWJeff Ho
Finance Co-op
2
Growing in TI
• Education• Competencies
Me
• Accounting Practice• Database• Cooperation
Learning
• Automation Projects• Goal setting• Invoice Reconciliation Automation System• Closing Automation System
Contribution
3
ME
4
Education
Science Track
Jianguo High School
BBA, Accounting
National Taiwan
University
MA in Statistics
Columbia University
Programing Skills
Accounting & Business
Quantitative Analysis
Data Science
5
• Statistical Analysis• Financial Modeling• Machine Learning• Data Visualization
• C, C++, Python• HTML, CSS• R, SAS• Database, SQL, SAP,
XBRL
• Financial Market• Security Research• New Technology
• Financial Accounting• Financial Reporting• Cost and Managerial
accounting• Accounting Information
Systems
Accounting Expertise
Business Acumen
Quantitative Analysis
Programming Skills
Competencies
6
LEARNING
7
Accounting Practice
Collect Organize ReportFinancial Data
Financial Info
Accounting Information System
• SAP• EMR• BOI
Financial Reporting
• Invoice recon process
• Closing process
8
Database
What is the location of databases?How do I access the databases?Is data in the databases intact?
9
Cooperation
IT Team JeffFinance Team
Database Structure
System Support
Accounting Logic
Financial Reporting
10
CONTRIBUTION
11
Automation Projects
• Automate invoice reconciliation process to save time and to reduce errors.
Invoice Reconciliation
automation System
• Automate and optimize closing process to enhance overall efficiency of the company.
Closing Automation
System
12
Goal Setting
• Precise calculation• Well-defined logic• Bug-free program
Accuracy
• Simple• User friendly• Fast computation
Time Saving
My GoalCompany Goal
13
Development Process
Requirement Design Implementation Verification Maintenance
Invoice Reconciliation Automation System
20 days
14
Invoice Reconciliation Automation System
Requirement Design Implementation Verification Maintenance
1. Discuss system details with Finance team and IT team
2. Translate financial reporting logic to programming and database logic
3. Define calculation rules of the system
4. Define decision logic of TI disposition
15
Invoice Reconciliation Automation System
Requirement Design Implementation Verification Maintenance
1. Investigate differences between system output and manual output
2. Fix errors
3. Fix missing contents
4. Design user friendly output format
5. Adopt a simple and clean UI
16
Invoice Reconciliation Automation System
Requirement Design Implementation Verification Maintenance
1. Enhance system robustness
2. Improve system compatibility
3. Prepare “User’s Manual”, showing system demonstration and specifying proper input format
4. Help users operate the system and solve various problems
17
Manual Automation0.00
20.00
40.00
60.00
80.00
100.00
120.00
140.00
Organizing Time Running Time
Checking Time Processing Time
Benefit
44 minutes
120 minutes
63%
18
•76 minutes time saving per subcon per month
•18240 minutes time saving per year
•304 hours time saving per year
Benefit
19
Development Process
Requirement Design Implementation Verification Maintenance
Invoice Reconciliation Automation System
Closing Automation System 20 days
21 days
20
Closing Automation System
Requirement Design Implementation Verification Maintenance
1. Exactly catch accountants’ demands and closing logic
2. Discuss system issues with Finance team and IT team
3. Finish “Software Requirements Specification” according to the consensus of both teams
21
Closing Automation System
Requirement Design Implementation Verification Maintenance
1. Carry accountants’ needs and logic out through design of the closing automation systems
2. Define data integration process
3. Define decision logic of reversal process
4. Design a simple and direct UI
22
Closing Automation System
Requirement Design Implementation Verification Maintenance
1. Identify data source and acquire query strings
2. Continuously and closely cooperating with IT team, debugging the program and enhancing the system performance
23
Benefit
11:00 pm6:00 pm
ManualAutomation
Off duty Data ready
Automation
Deadline
1st work day
2nd work day
1. Shorten processing time2. Start closing process earlier
Finish closing process much earlier
top related