** ******* ** **********@*****.*** Cell: 732-***-****
New Brunswick NJ 08901
Hemal Dalal
Summary of Qualifications
. Strong Excel, PowerPoint and Access skills, with particular focus on
financial modeling and the use of advanced features of spreadsheets
. Strength in research/ analysis/ client relations/ financial planning
. Strong history of completing projects on time and within budgets
. Experienced with Hyperion Planning and Hyperion Essbase
. Created spreadsheet applications such as Excel extensively to model
financial statements such as the income statement and balance sheet
. Exceptionally organized with great ability to work on multiple
projects at once
. Deep level of analytical ability and accuracy
. Remarkable ability to work independently and complete tasks with
minimal supervision
. Excellent interpersonal and organization skills
. Exceptional flexibility and ability to work independently and in a
team
. Excellent communication, both oral and written skills
Education
RUTGERS- Business School - New Brunswick, NJ
B.S. Major: Finance and Business Administration, August 2008
Major GPA: 3.62/4.00; Cumulative GPA: 3.6/4.00 - Dean's List/ Honor Student
Working towards MBA
Professional Experience
Lynmar Capital Group - Marlton, NJ Sep
2009 - April 2010
Junior Financial Analyst
. Analyzing financial statements, 10k's, 10Q's, income statements and
balance sheets
. Assist in the preparation and transmission of Month End reporting to
clients
. Provided financial support and analysis to Operations and Marketing
areas for strategic business decisions and cost savings initiatives
. Created NPV, IRR, discount cash flow, and ROI models for evaluating
financial implications of new products and investments, and provide
recommendations to senior management
. Analyzed and interpret monthly variances and trends between budgets,
actual and prior results in developing projections and forecast
. Researched problems and provided recommendations to management
Coty Prestige- Manhattan, NY
Sep 2008- Aug 2009
Account Analyst
. Prepared excel worksheet with daily, weekly and monthly sales reports
. Responsible for managing sales of 20% of the stores in tri-state area
. Co-managed monthly budget by performing monthly variance analysis
. Innovated various strategies to increases sales and created plans to
place marketing advertisements throughout locations where the product
was promoted
. Prepared and presented monthly sales and forecast for the following
month to provide precise picture to management
Fragrance Elite- Manhattan, NY
Sep 2007 - Aug 2008 Account Coordinator
. Assisted the regional executive with the performance analysis of
departmental stores
. Built models within excel to forecast future sales helping benchmark
against competitors
. Presented product launches to customers on a one-on-one and on a large
customer base level
. Helped with advertising campaigns and assisted in creating new
strategies to increase sales
. Guided employees in the maintenance of stock products offered by the
company
Hess Corporation- Woodbridge, NJ May
2007- Aug 2007 Finance Internship
. Worked closely with VP of Retail Business Services in performing
analysis of convenience stores merchandise, new business programs and
new markets which can provide prospective growth
. Integrated P&L reports and assisted manager with statistical budgeting
analysis
. Analyzed monthly net income statements from different sites and
forecast volume using existing forecasting models
. Provided administrative support for dealers and branded retailers; and
updated fuel pricing market surveys
. Analyzed data provided from surveys and market based research and
created a streamlined report for management
Awards
. 2nd Place in Instructional Area of Vehicle and Petroleum Marketing in
NJ Southern Regional Conference
. 3rd Place in New Jersey in Vehicle and Petroleum Marketing in Southern
Regional Conference
. In Recognition of Superior services to the Community for Operation
Smile Club
. University Membership 2004-2008-Financial Management Association
Leaderships/Activities
. Rutgers Finance Society - Head of Fundraising
. Little Investment Banker of Rutgers (LIBOR) - Active Member
. Finance Management Association - Active Member