Sales Analyst
Resume:
Dimple Darjee
Rockaway, NJ ***66
************@*******.***
EXPERIENCE
BP Lubricants Wayne, NJ
Performance Reporting Analyst, 2006 - Present
. Prepare and analyze monthly reports including but not limited to
Operating Committee Presentation package, E-Expense Reporting, and
Departmental Reports.
. Develop Plans and Forecasts for expense lines below Operating
Contribution on the Profit and Loss Statement
. Responsible for the processing and analyzing the Monthly Fixed and
Variable rebate entries to ensure they align with the Forecast and
Plan, which includes working with the channel analyst in interpreting
the monthly data
. Member of several projects (Enterprise 2 (SAP Based) Reporting system
and new management structure)
. Responsible for the Consolidation Database for Operating Unit
Party City Rockaway, NJ
Merchandise Planning Analyst, 2003 - 2006
. Developed an Access database, "Advanced Distribution", to satisfy a
business requirement not present in base PMM. The application allows
Planning and Allocation to systematically create purchase orders and
transfers to the stores.
. Managed Project Plan and status meetings with Senior Management and
Conducted User training sessions for the "Advanced Distribution"
database
. Created planning tools in Excel to forecast and analyze sales, gross
margin and inventory at various levels of the business on a weekly
basis
. Created automated store reporting which allowed stores to focus on
their Top 25 Everyday Selling Items
. Significantly improved the day-to-day efficiency of existing reporting
Trans World Entertainment Albany, NY
Margin Analyst, Retail Accounting, 2000 - 2003
. Developed Merchandise Plans at Department level by week for Sales,
Gross Margin, Purchases, Returns, and Inventory
. Responsible for the data integrity of the stock ledger system
. Instrumental in the successful development and implementation of the
Price Protection/Vendor Markdowns project, which allowed allowances to
flow through the stock ledger and allowing accurate reporting of
merchandise margin.
. Utilized POS/Sales Audit Systems and detailed analysis to reveal
unauthorized employee pricing data manipulation/theft
. Involved in the AS400 upgrade and merchandise hierarchy restatement
. Developed several standard and adhoc Sales, Margin and Return on
Investment reporting for senior management
. Introduced new electronic information distribution process to reduce
wasted paper and time
. Reviewed reports created from coworkers before issuing to senior
management
Dimple Darjee - continued
Page 2
OTHER EXPERIENCE
Michaels Parsippany, NJ & Clifton Park, NY
Instructor, 2003 - 2008
. Taught all jewelry classes to various levels while increasing sales in
the beading department
Kaiser Permanente Latham, NY
Senior Data Analyst, 1999 -2000
Financial Analyst, 1998 - 1999
. Developed monthly and adhoc reporting (staffing, cost center, accounts
payable, line of business, state regulated, inpatient/outpatient, and
pharmacy)
. Instrumental in the automation of manual data entry of employee Service
Records
St. Peter's Hospital Albany, NY
Staff Accountant, 1997 - 1998
. Developed operating budget for multi-corporation firm including expense
target formulation, margin analysis
. Responsible for the Mecon Benchmarking Project and received Max Award
for Excellence
Grant Thornton London, England
International Intern, 1994
. Gained experience and exposure in the Corporate Finance, Audit,
Marketing, Tax, and National Marketing Departments
EDUCATION
Siena College, Loudonville, NY
Masters of Business Administration, Professional Accountancy, 1999
Bachelors of Business Administration, Major: Accounting, Minor: Mathematics
1996
COMPUTER SKILLS
Windows XP/98/95, Microsoft Office (Access, Excel, Word, PowerPoint,
Project), Lotus 123, Hyperion Pillar, AS400/JDE, PMM, Cognos, Oracle
Financial Analyzer
ACTIVITIES
American Heart Association, Team Captain, Leader & Awards Committee Member
2000 - 2003
Contact this candidate