Senior Analyst Resume Detroit, MI - Hire IT People

SUMMARY

Experienced professional in analytics, operations, materials management, and information technology.
Experiences include systems implementation, systems development, project leader, data mining, data analysis, report writing, software training, inventory control, purchasing, programming, and warehouse management - in retail, distribution, and manufacturing settings.
The accumulation of these experiences has given me a broad-based understanding of operational, material and employee management.
Recently completed a Masters in Predictive Analytics at Northwestern University.
The combination of my analytic skills with my business experience enables me to help businesses become more profitable through evidence based decision making.

TECHNICAL SKILLS

Development Tools: SQL, PL/SQL, R, Python, Visual Basic, VBA Excel, VBA Access

Software: Excel, Access, Word, Power Point, SAS, PostgreSQL, Microsoft SQL Server, SQL Server Reporting Services, SSIS, Help Systems SEQUEL Viewpoint, Domo. Salesforce, Tableau

PROFESSIONAL EXPERIENCE

Confidential, Detroit, MI

Senior Analyst

Responsibilities:

Created custom model in R for reporting of ongoing promotional event, reducing process time by 20% while increasing precision of results
Performed detailed analysis for important client's private label team, identifying opportunities for more cost-effective product assortments and a potential 30% reduction of SKU's
Assembled store profiles based on sales, demographics, location, and programs for important client, providing client with improved insight and understanding of its alliance members
Developed reports utilizing R to extract data from a SQL Server database, then combinations of Excel, VBA, Google Sheets, and Domo to automate output, delivering timely reporting for important client

Confidential

Business Analyst / Consultant

Responsibilities:

Re-created and modified numerous reports related to Inventory valuation and daily operations; made database of liquidation jewelry for sales / management team to replace retired legacy system

Confidential, Morrisville, NC

Business Analyst / Consultant

Responsibilities:

Determined through investigation, analysis, and collaboration correct data to extract for reporting from existing ERP system, Microsoft NAV; used SSRS to transfer data; Access reporting database to import transfer files by VBA code and Access macros, constructed numerous reports for Inventory, Purchasing, and Sales

Confidential, Wood Dale, IL

Manager

Responsibilities:

Built a forecasting process for Jewelry that encompassed three different customer types.
These reports and tools analyzed and combined various demand curves to produce a favorable forecast; keeping backorders between 2% - 4% of unit volume.
Established management reports utilizing complex SQL queries for retrieving base data to export into Excel, and VBA macros to format.
One report was used daily by Packaging Department to calculate packaging needs and another report displayed top selling items by groupings
Served as an integral part of 5 system conversions/implementations as a liaison between programmers and staff, being able to convey to programmers information staff needed

We provide IT Staff Augmentation Services!

Senior Analyst Resume

Detroit, MI

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship