Manager Sales
Resume:
Xiaoguang (Jack) Lang
Current Address:
Queens, NY, 11356
*****@*******.***
EDUCATION
Indiana University, Kelley School of Business, Bloomington, IN December 2014
Bachelor of Science in Business
Majors: Accounting, Information System Overall GPA 3.34/4.00
WORK EXPERIENCE
Industrial and Commercial Bank of China, Yanji, Jilin, China June-August 2014
Assistant Banking Manager Intern
• Supported daily coverage for the firm’s corporate clients in transportation sector, which includes understanding and advising on clients’ funding need and helping develop ideas that match those needs with investor interests
• Assisted with preparation and presentation of materials/analysis used for pitching financing ideas
• Generated new business through presentation of bank products to customers and follow-up on customer questions
Jinhuang Food Co., Zhongshan, China May-July 2013
IT Intern Program
• Worked as a team to analyze the business requirements and design a database for fish production which include creating complex schema, views, triggers, and implemented the import and export of data using XML
•Developed and queried tables using SQL (Oracle 11g and MS SQL Server) which include developing ER diagram, translating the conceptual schemas to relational schemas and queried the database for over 400 products
•Assisted client manager on data cleaning, data analysis, spreadsheet modeling, and pivot tables including if statements with v lookups
•Working with teams to understand and document firm’s reporting and analytical needs, including identifying critical metrics and KPIs needed to support the company’s ongoing growth
•Developed innovative social media marketing campaigns to target high-worth clients resulting in 30% sales increase within one month
Noble Nail Salon, Longbeach, NY June - August 2012
Accounting Coordinator/Payroll Intern
• Prepared daily reconciliation of cash management activities, properly setting cash and reconciliation of monthly bank statement
•Managed 12 employees and prepared daily sales summary to help store keep track of cash inflow and outflow
• Advised store owner on advertising plan and created lock-in strategy increasing sales over 20%
•Processed changes in wage rates and occupations of employees on payroll with accuracy and updates various employee spreadsheets
ACTIVITIES
Member, Volunteer Income Tax Assistance (VITA)
• Provided free tax services to 10 clients at Indiana University and employees at IU Health Center
•Worked in a group of 7 members and interviewed taxpayer to determine if all income, deductions and allowable credits are claimed which including analyzing W-2s, 1099s and other documents
Peer Tutor, Kelley School of Business, Indiana University
•Selected as one of the 13 students to volunteer in Computers in Business (K201) class as a tutor and helped students grow in their understanding of the material by learning to communicate and coach newer students
• Assisted students with Microsoft Access and Excel to help them improve in the course while gaining strong EXCEL skills
Member, Student Accounting Society
• Attended weekly professional presentations regarding accounting careers and topics which helped me learn the hard skills and soft skills that are needed to be successful in any business environment
SKILLS AND INTERESTS
•Microsoft Excel, Access, Power Point, Word
•SQL, XML, Visual Studio, Oracle, NetSuite
•Conversant and literate in Chinese
Contact this candidate