Business Analyst Resume

Title
Business Analyst

Primary Skills
ms access, sql

Location
US-VA-McLean (will consider relocating)

Posted
Sep-23-09


Summary

• 6 years experience in retail operations with a proven track record of achievement in point-of-sale systems, installations/implementations, systems analyst, business analysis, vendor management and Consulting in Logistics and Supply Chain Management.
• Works closely with internal and external parties to enhance company practices, providing greater efficiency for key tasks.
• Expert in Data Analysis, Strategic Planning, Cost Reduction, Quantitative Modeling, Simulation, and Operation Research.
• Highly Proficient with tools like Word, Excel, PowerPoint, Access, Publisher, Visio and MS Project and HP-PPM and SalesForce CRM, Caliber Analyst and TIBCO BPM.
• Data flow Modeling and Object Modeling, Case Analysis, Workflow Analysis, and Functional Decomposition.
• Exposure in SAP work-instructions, Personnel Procedures and Inventory Control
• Proficient with Statistical and analytical tools like MS Excel, VBA, MS Access, and SQL to solve business problems.
• Goal-oriented individual with strong leadership capabilities.



Achievements

Project Lead for Automated Special Order Contact Lenses for Stores and Web Orders: Converted the Wal-Mart Stores Optical Applications from manual faxing of customer contact lens orders to vendors, to a completely automated Electronic Data Interchange (EDI) PO. Created from scratch a new EDI Cross Docking Contact Lenses PO with the prescription in specific memo areas of the PO resulted in 10 % cost reductions to Wal-Mart from all contact lens vendors. First Time an EDI Contact Lens PO was created in the industry setting the EDI standard.

• System Analyst for Wal-Mart ISD Home Office Year 2000 (Y2K) Team: As the only System Analyst with the twelve member Year 2000 (Y2K) team, we originated and developed a methodology for Y2K Testing for all Wal-Mart Systems; that reduced systems hardware, and still allowed complete testing of all systems applications. The year 2000 change over resulted in absolutely no issues in all of Wal-Mart worldwide.
• POS Specialists: Proven track record from both a vendor and a retailer's perspective in a Wide variety of management and sales positions, including Branch Sales Manager in Point Of Sale (POS) Systems. One of the first to implement UPC bar code scanning in General Merchandise in Dallas / Ft. Worth in 1985.
• Turn Key Implementer of POS: Sold, designed, programmed, installed and trained all POS Systems solutions communicating to the General Merchandise Retailer's Back Office Systems for all eleven years at Sweda Dallas / Ft. Worth branch office. Advancements ranged from Account Representative to Branch Sales Manager over 6 Associates.
• Inventor: Created long -- term solutions for clients, resulting in numerous firsts, and leveraging of the available technology. Currently hold two industrial patents from similar analytical and conceptual observation of the customer's concerns and finding the best solutions as an Industrial Sales Engineer.

Skill Sets:- MS Excel, MS Access, SQL, VBA, SAP, PC*, MS SQL Server, Oracle, UML, MS Visio, ArcGIS, MS Project,MS-office 2003-2008.

Experience Summary:-
The Target Corporation (Minneapolis, MN) March 2009-- Present
Retail Analyst
Responsible for day-to-day management, involving marketing/pricing strategy, financial analysis, sales/inventory projection, import commits/domestic ordering, safety stock calculations, supply chain/logistics coordination, and reporting to leadership for six highly profitable and visible categories. Balanced financial allowances for weekly spending reviews and monthly forecasting with VPs, Directors, Senior Buyer, and company accountants. Weekly status reporting to Merchandise Planning Managers, 2 Buyers, and Division Captains.
Key Achievements:-
• Mobilized team members and vendor partners, leveraged knowledge bases, and utilized all available resources to drive sales, exceed expectations, and beat financial goals
• Developed reputation for success; relied upon by buyers of other analysts' categories for input/opinion/solutions
• Regularly updated projections of sales and inventory levels up to 12 months into the future in order to better prepare for and capture the sales potential of the retail market and ensure profitability by optimizing inventory levels, relying upon anticipation of sales trends and consequent receipt need well in advance of actual spending
• Created spreadsheet in MS Excel to predict demand patterns, the results of which drives purchasing and shipping schedules to ensure adequate availability of product at the distribution center and at the store level. Automate the calculations by creating macro in VBA.
• Create ad hoc reports with SQL, perform daily and weekly report generation and maintenance procedures.
• Convinced leadership of Target's 3rd largest Shower-goods vendor and sole vendor of tension rods,
• Met face-to-face with President and inventory analysis team of largest Shower-goods vendor to communicate dissatisfaction with frequently late and incomplete shipments, and developed objectives
• Designed and implemented Sales plan Strategy and Rapid Reaction Plan to allow for greater in-season flexibility in chasing inventory, employing production quantity trigger dates, aggressive production percentage schedules, multiple vendor availability per item, and more reactive sales projections for seasonally-sensitive Beach Category
• Moved domestic sourcing in line with Import Production, given reality of business and market, and due to the fact that most domestically sourced items were produced overseas; initiated long-term projection based production planning for domestic vendors



Macys, (Cincinnati, OH) May 2008--Oct 2008

Retail Analyst

Albertsons LLC is one of the successor companies to Albertson's, Inc. Bakery, This project was aimed to analyzed customer needs by developing tools and techniques for maximize vendor profit.

Albertsons, (Dallas, TX) June 2007--Feb 2008
Retail Analyst
Responsible for CRM related operation. Supported the CRM team on data analysis and reporting and act as the contact point. Responsible for smoothly running of internal applications and databases. Coordinated external partners to implement or maintain applications. Worked with the teams to design and specify new requirements

Supervalu, (Eden Praire, MN) Aug 2006--Mar 2007
Distribution and Data Analyst

Retail chain with a network of more than 2,500 stores; headquartered in Minneapolis, Minnesota; acquired the retail properties of Albertson's Inc in 2006, making it the third-largest grocery retailer in the US. Project was aimed to managed the daily activities of the departments. Monitored the timing ,sales and inventory of the department.

Sears, Roebuck and Co, (Hoffman Estates, IL) June 2005--April 2006
Retail analyst

Sears, Roebuck and co. is a leading broadline retailing company that offers a wide range of home
merchandise, apparel & automotive products & services through more than 2,400 stores in the US & Canada

MERVYNS LLC, (Fremont, California) July 2003--Feb 2005
Distribution Analyst

Managed the daily activities of the warehouse and outbound departments. Provided functional leadership in the distribution center with a $13.4 million operational budget. Supervised and developed the talent of 22 direct reports through cross training and expanding their problem solving skills to produce a highly functional team.
EDUCATION:-
MBA emphasis in Technology & Operations Management from Aurora University, Aurora, IL
Bachelor of Science in Electrical Engineering from Northern Illinois University, DeKalb, IL

Certifications
See above


You must be logged in and have a current resume access subscription. Login or Register »

Resumes in McLean, VA | Resumes in Virginia

View other Business Analyst resumes, Business Analyst resumes