Data Sql Server
Resume:
Nicole Tian
************@*****.***
OBJECTIVE
To obtain a Data Analyst position utilizing strong reporting and data analytical skills
SUMMARY OF QUALIFICATIONS
• Two years excellent quantitative, analytical and problem-solving skills through business and
data analysis as well as Excel financial modeling including VBA programming work experience
• Bachelor degree in Mathematics and enrolled in CFA program
• Expert user of Microsoft Excel and Access including VBA and pivot tables, building and
implementing complicated reports/models
• An in-depth grasp of SQL reporting, analytics and business intelligence with excellent
understanding of database structures, principles, theories and practices
• SAS experience includes detailed knowledge of statistical analysis of financial, marketing and
health care data and in the production of reports, tables, graphs and listing
• Excellent skills in Microsoft Word, PowerPoint, Project, Visio, R, MATLAB and Java
• Self-motivated and enthusiastic team player with strong interpersonal communication skills,
presentation and multitasking skills
• Responsible and reliable worker with a meticulous attention to detail
• Self-starter with a high degree of initiative and the ability to learn and adapt quickly
WORK EXPERIENCE
Actuarial Pricing Analyst
CIGNA & CMC Life Insurance Company Limited, Shenzhen, China, 2012
• Built and improved Excel reports/models using VBA code, pivot tables and Excel built-in
functions including VLookup
• Analyzed massive and highly complex data sets of policyholders, performed ad-hoc analysis
using pivot tables for profit testing models and data manipulation
• Created VBA programs to automatically update Excel workbooks, encompassing class and
program modules and external data queries
• Added new columns to existing tables modified stored procedures and user defined functions in
SQL server
• Analyzed and implemented tables in SQL for reserve systems utilized by valuation actuaries
• Designed and implemented Excel VBA programs, MS Access queries/table structures and SAS
code to calculate reserves and ensure accuracy of forecasting reports
• Assembled & analyzed the modeling database using data mining techniques, including data
reduction, data enhancement and data transformations
• Gained strong analytic and problem-solving skills thorough assembling risk model test plans
Analyst – Investment
China Water Affairs Group Limited, Nanchang, China, 2010
• Created customizable Excel applications for analysts using VBA and Excel object models
• Carried out analysis of given data and drew correct inferences, in keeping objectives of analysis
• Used a Microsoft Access Data Project (ADP) front-end linked to a SQL server back-end
• Used pivot tables for Excel investment report on spreadsheet and adjusted programmatically
• Designed data marts in Excel that were used as the source for analytic reporting
• Maintained the research database, renewed and improved it from time to time
Corporate Banking and Consumer Banking Units Rotation
Citibank Co., Shenzhen, China, 2008
• Programmed Excel VBA forms and pivot tables to make the work more efficient
• Created various ad-hoc SQL queries for customer reports, executive management reports and
types of report types like tables, matrix, sub reports etc.
• Gathered data necessary to accomplish analysis from a number of sources, accumulated it
together in prearranged format and entered the data in MS Access and SAS
• Used Excel built-in functions including VLookup to modify Excel model for Citibank system
upgrade project
• Settled on the methodologies and procedures for carrying out effectual data analysis
AWARDS&ACHIEVEMENTS
• Completed Society of Actuaries Exams Probability/1 & Financial Mathematics/2 incl. VEE-
Economics, VEE-Corporate Finance credits
• Completed Organizational & Human Development’s Student Leadership Program, University
of Waterloo, Waterloo, ON, 2011
• 99th percentile in University of Waterloo Euclid Mathematics Contest, University of Waterloo,
Waterloo, ON, 2007
EDUCATION
Bachelor of Mathematics, Honours Actuarial Science, Honours Statistics,
Sept 2007 – Jan 2012, University of Waterloo
Contact this candidate