Data Analyst Resume Profile Harrison - Hire IT People

SKILL PROFICIENCY

Advanced Excel and Pivot Table skills
Knowledge of SQL, SSIS, SSMS and HTML code
Professional in report management in BI Platform Elite 3E including Clarity and InfoView
Proficient in MS Word, Powerpoint, Outlook, InterAction and Adobe Acrobat Pro. and Photoshop
Strong data structuring and interpretation skills
Strong communication Chinese English and coordination in daily administrative work
Excellent knowledge of legal terminology, practices and procedures
Professional drafting skills and good typing speed

WORK EXPERIENCE

Confidential

Data Analyst/Administrative Assistant

Data analyst for Practice Management administrative assistant to Business Directors, Lateral Recruiting Manager and Office Administrator legal assistant in Business Department.
Use advanced Excel functions and Elite 3E BI platforms, such as Clarity and InfoView, to create and manage varieties of highly confidential reports and statements with numerous financial data related to staff utilization and client information.
Design and update a number of financial pivot tables.
Import and export critical budget information in the firm's financial system.
Write SQL queries in SSMS to generate reports from different sources.
Combine data from different tables in Excel and SSMS.
Proactively investigate and analyze data in various reports to uncover any inaccurate information and solve the problems.
Provide attorney performance reports for different departments HR, Marketing, Legal and Admin , and coordinate data/information exchange among the departments.
Design and modify presentations in MS PowerPoint.
Organize associate applications and prepare responses through the recruiting system-iDesktop.
Revise legal documents, such as agreements, notes and warranties in large corporate transactions.
Proofread legal documents and compare different versions using DocsCorp.
Coordinate with document notarization, certification and authentication.
Schedule intensive internal and external conferences in domestic and international offices.
Translate and proofread legal, administrative and marketing materials in English and Chinese.

Confidential

Legal Assistant

Legal Assistant to partners and associates in real estate, corporate transactions and civil litigation performed office administrative work set up and managed representative office in China.
Drafted and revised complex entity agreements, commercial leases, financing documentation and other real estate documents, and assisted in formation of legal entities.
Drafted and revised summons and complaint, pleadings, subpoenas, and other legal documents in litigations, and monitored the case status online.
Scheduled closing with all parties and prepared closing documents before and after each real estate transaction.
Managed trademark applications: filled up form, revised trademark pictures, filed with USPTO and checked status periodically.
Composed and revised letters and agreements regarding trademark transfer and/or infringement.
Oversaw establishing branch office in China, and managed most administrative and legal matters in the branch at the beginning stage.
Translated legal documents into Chinese.
Organized and improved the firm's calendar system.
Prepared billings for legal services and issued checks for account payables.

Confidential

Adjunct instructor

Taught elementary Chinese in the Department of Language and Literature.
Taught freshmen and sophomores Chinese, including reading, writing, listening and speaking.
Managed the course schedules and provided innovative teaching methods to attract and motivate students to explore the essence of the language.
Participated in drafting oral and written tests.
Evaluated students based on their performance.

We provide IT Staff Augmentation Services!

Data Analyst Resume Profile

HarrisoN

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship