Administrative Assistant Quality Control

SUMMARY:

. Strong Mathematical as well as Statistical aptitude &

analytical/logical problem solving skills.

. Proficiency with Word, Excel's data analysis tools, PowerPoint

presentations, Access database queries/reports & Business Objects.

Have utilized SAS & Mathematica.

. 8 years of Inventory Data Analysis experience at corporate level

with large volume data in regards to multi-location distribution

centers & stores. Strong data mining skills with importing,

exporting & analyzing data from/in various software applications.

. Detail oriented, great organization skills, and strong analytical, &

quantitative skills/knowledge to ensure logical problem solving

methods.

. Strong oral & written communication skills. Ability to develop

strong collaborative relationships with team members, senior

management & clients

. Continuously identifying, analyzing & assisting towards process

improvements. Meets deadlines in a timely fashion.

. WILLING TO RELOCATE.

EDUCATION:

1999 - 2004 University of Texas at Arlington

Pursued Bachelors of Science in Mathematics, Statistics Option

. Major concentration on statistical analysis such as: descriptive

statistics, qualitative analysis, quantitative analysis, experimental

designs, hypothesis testing, regression analysis and quality control.

COMPUTER SKILLS:

. Operating Systems: Windows 95/98/2000/NT/XP.

. Software's: Microsoft Word, Excel, Access, PowerPoint, Outlook,

Business Objects/Desktop Intelligence. Familiar with SAS, Mathematica,

SQL & PeopleSoft.

. Programming Languages: C, C++, Pascal and FORTRAN.

WORK EXPERIENCE:

July 2003 - Present Inventory Data Analyst

Zale Corporation, Irving, Texas

Zale Corporation is a leading specialty retailer of diamonds & other

jewelry products in North America, operating over 1930 retail locations

throughout United States, Canada, & Puerto Rico, as well as online.

Inventory Control Analyst for Finance department, responsible for all

physical full & cycle count inventories. The overall shrink for the

company has been below 1%.

Inventory Responsibilities:

. Integrated cost analysis report for Inventory Correction Request

resulting in elimination of paperwork and saving the company in

several man hours. Created new Access database for Vendor schedules.

Created new queries & reports in Excel as well as Access with regards

to regional teams. Updated and maintained the Inventory database on

Microsoft Access.

. Conduct, analyze and report inventory results to Physical Inventory,

Loss Prevention, Distribution, Diamond Sourcing and MRPC management

monthly, quarterly & yearly. Reconcile, analyze & quantify variance

for monthly store inventories at SKU/Retail Dollar amount utilizing

general accounting principals before monthly financial close.

Investigate high shrink and make appropriate changes and

recommendations. Ensure timely validations/reconciliation on Return to

Vendor & Special Receipts of products by working closely with

Inventory Accounting as well as Accounts Payables.

. Responsible for resolving inventory related issues such as inventory

adjustments, transfer discrepancies, damaged merchandise,

replenishment requests & other operational issues at store level on a

daily basis. Research, analyze and resolve any negative on hand

inventory levels for stores.

. Balance & oversee month end financial reporting for physical inventory

department with regards to inventory reconciliation & shrink analysis.

. Implement and assist with corporate and department policies and

procedures that directly or indirectly impact the control of

inventory. Prepare and conduct one-on-one training on Inventory

Control procedures.

February 2001 - June 2003 Administrative Assistant

Zale Corporation, Irving, Texas

. Provided administrative support to the Physical Inventory Department,

consisting of the Director, forty Field Analysts and 15 in office

Analysts. Managed Business Expense vouchers and corporate car mileage

logs. Tabulated workers compensation for stores and sorted out

territories for Field Analyst.

. Tracked daily inventory changes and confirmed that the store had an

inventory packet Designed an Inventory Tracking Form on Excel, which

would track inventories for the stores sorted by analyst depending on

the type of inventory and providing the next inventory date for a

particular store.

. Initiated various other responsibilities such as ordering and

distributing Physical Inventory Reports, Adjustment to Snap Shots and

Loss Prevention Reports. In addition to that analyzed SKU traces

between two different systems such as the Cats System versus Zaleprod.

Adjusted daily SKU adjustments and entered final inventory results

into Access.

1998 - 1999 Math Tutor North Lake

College, Irving, Texas

North Lake College is a Dallas County Community College offering basic

college courses.

. Identified and illustrated various problem solving skills. Maintained

and operated the Math Lab Library. Explained algebraic, geometric,

trigonometric, statistics and calculus related topics to students.

Familiarized students with different methods of problem solving.

Contact this candidate