SUMMARY

• Dedicated business intelligence analyst with proven demonstrated ability to adapt to new technologies and industries. Experienced business reporting problem solver who goes above and beyond to get results. Proven track record of generating efficiency and improving productivity through business intelligence solutions. Self­starter, detail oriented, and works well with everyone. Received numerous awards and recognitions for process improvements.

PROFESSIONAL EXPERIENCE

Business Intelligence Analyst

Confidential, CA

Responsibilities:

• Managed business intelligence solutions for operations including creating, maintaining, troubleshooting, and supporting and training team members.
• Identified, developed, and implemented process improvement through OLAP reporting solutions for various departments including demand planning, finance, quality, & operations utilizing different BI stacks from Microsoft, IBM, and SAP. DBMS include SQL Server, Oracle, and HANA.
• Created powerful and complex analytic solutions for demand planning to report forecast, backlog, bookings, shipment, inventory, business plan, channel sell through, channel inventory, and BOM data. Prior to this, all these data points were available separately, extracted from multiple data sources and then merged into an Excel spreadsheet. This BI solution drastically reduced the time required to gather data down 90+% and allow the end users to focus more on the analytics to drive better business decisions.
• Developed different metrics and other BI solutions to gauge how the business is doing. These metrics include forecast to actuals, forecast pricing, inventory trends, inventory turns, inventory projection, excess inventory, cost trend, backlog, bookings, shipment, on time shipments, and rma among others.
• Coordinated changes with various departments to maintain data integrity and worked with corporate IT department on various projects.

Technology Consultant

Confidential, CA

Responsibilities:

• Analyzed technology requirements for store operation.
• Tested emerging software/hardware technology trends.
• Implemented POS system using LOC SMS, Microsoft Dynamics RMS on IBM SurePOS, EPSON, NCR retail hardware, & Square Credit Card Payment system.
• Troubleshoot/Serviced & Supported POS implementation.
• Implemented a surveillance camera system.

Merchandise Support Coordinator

Confidential, Oakland, CA

Responsibilities:

• Business Analyst - designed queries and reports, and implemented report hierarchy and infrastructure for daily operations to report sales and inventories to corporate using NSB Connected Retailer software for a $40 million/ yr business.
• Delivered report metrics using Microsoft Excel, NSB Connected Retailer, EBA (Enterprise Business Application, aka Richter Demand and Souring), ProClarity, and other tools to review OH, WOS, COGS, ST%, Best Seller, COMP to LY, On Order, Daily Flash Sales, etc.
• Support the office and 70+ retail locations including monitoring system failures and implementing procedures and practices to minimize future failures.
• Managed many aspects of the NSB retail system including implementation of reports, system operations, system integration with other business applications, and software consultation.
• Business unit leader for testing, systems upgrade and integration between retail and wholesale systems.
• Reconciled receiving, PO invoicing, and bookkeeping discrepancies with finance.
• Order and Product Management for the Koret Outlet Stores, Sag Harbor Outlet Stores, and the Kellwood Warehouse Stores.
• EDI, Allocation, and Reserve Specialist.
• NSB Connected Retailer System/Platform trainer.
• Systems and applications utilized include: Windows, Office, Lotus Notes, NSB Connected Retailer, EBA, Warehouse Management (AS/400), Inovis (QRS) Catalogue, and WebPDM.

Customer Service Lead

Confidential, Oakland, CA

Responsibilities:

• Managed Customers' Forecast and Distributed Koret Outlet Stores Orders
• Booked, Maintained, Allocated, and Shipped Customer Orders.
• Managed various accounts including specialty, department, and closeout stores i.e. Bealls Outlet, Peebles, Stage Stores, Dillards, Koret Outlet, Burlington Coat Factory, JC Penny, etc.
• Answered customer 800 phone line regarding inquiries, sales, reorders, and warranty.
• EDI Coordinator, Allocation, and Reserve Specialist.
• Implemented a sales allowance tracking system for merchandise returns.

Digital Image Manipulator

Confidential, Chico, CA

Responsibilities:

• Digital photo retouching and background replacement utilizing Adobe Photoshop.
• Processed and scanned panoramic school portrait film negatives for retouching with Adobe Photoshop and layout with proprietary Kodak system.
• Processed sympathy photo CD's and processed school logos, proofing prints, and packaging.
• Shipped edits, proofs, and group pictures.

Confidential

Confidential, Chico, CA

Responsibilities:

• Processed front-end professional HCFA 1500 Regular, Medical, COB (Coordination of Benefits), and VIP claims.
• Processed back-end EEC locations 10, 11, 31 PPI 9 for patient paid amount, 70, and OEC for other insurance coverage claims.
• Responsible for making sales goals through effective product placement on sales floor.
• Processed freight and merchandise goods to the sales floor on a timely manner.
• Responsible for staffing and training new associates.
• Managed 4 - 5 associates.
• Processed payroll