Ivan Vujic Email & Phone Number

• Drove insights, accountability, and efficiency through the Merchandising Services Organization. Lead the development of tools, programs, and initiatives that helped expand supplier support and services, increased work productivity of employees, and reported on risks and opportunities.• Main point of contact and manager of consultants for large data-driven projects. Created a process-driven accountancy tool to calculate the profitability of supplier accounts. Allowed for tactical operations and pricing of merchandizing services: over $40MM in identified opportunities.• Managed all Strategic Initiatives POCs and Pilot Reporting, typically via Tableau. Presented the effectiveness of programs that improved top-line growth, processes, or associate turnover.• Integrated an acquired company’s field division into our organization structure. This included clustering, distance, and schedule optimization of associates.• Developed an algorithm to direct merchandizing service associates more effectively within stores.• Utilized multiple cross-functional partners and various data sources to complete projects.• Responsible for coaching, training, and outlining best practices for Data Analysis.

Greater Atlanta Area

• Utilized advanced SQL skills within SQL Server and Tableau Desktop/Server to develop tools/metrics which consolidate and analyze data, contain procedures and preventative controls, and allow for assessing risk, opportunity, outliers, and trends.• Developed Clustering Tool for optimizing work flow of field associates, and reducing supervisor planning time from several hours to under 2 minutes.• Capitalized on extensive Excel with VBA experience to consolidate and join data, create formulas, and develop macros. Developed macros that utilize SQL Server queries within Excel, communicate with servers, and solve linear programs.• Assisted in the creation of packages, batch files, SSRS, and Microstrategy reports. • Collaborated with cross-functional and internal teams to coordinate programs and initiatives, maintain documentation, and demonstrate effectiveness of those programs.• Developed tools for Human Resources, Finance, Operations (Labor, Safety, & Strategic Initiatives), Project Execution, and Supplier Services (Customer Insights, Support, & Sales).• Recipient of four recognition awards for exceptional contributions.

Greater Atlanta Area

• (Contractor) Developed VBA Macros in Excel, Access, and PowerPoint that automated tasks normally done manually within the pricing group. Example of automation impact: Reduced creation time of a standard PowerPoint report, pulled from a MS Access Database, from 20 minutes to the click of a button.• Created a pricing localization tool in Tableau to identify markup and markdown opportunities nationwide. Allowed the analysis and visualization of several Billion $$ in sales.• Performed pricing tests and developed tools applying concepts such as price elasticity of demand, break-even analysis, market basket analysis, and Herfindahl–Hirschman Index. Applied mathematical concepts such as regression/discriminant analysis, and linear programming/optimization.• Gave pricing insights and recommendations to Merchants in charge of certain product categories.• Used SAS, Teradata SQL Assistant, and Access to extract data from databases for analysis.• Used Tableau for data visualization and filtering. Received advanced Tableau training.• Assisted senior analysts with testing and market selection.• Learned and implemented retail method of accounting.• Prepared presentations for executives.• Reviewed analytic tools created by Mu Sigma and suggested improvements.• Involved in team meetings and strategic planning with management.• Recipient of three recognition awards for exceptional performance.

Greater Atlanta Area

• (Intern) Implemented new online timesheet system with Canadian company Replicon.• Integrated Chemical Plant Job data and work progress into timesheet system.• Created deliverables with consolidated data from various departments to send to clients.• Created a new organized data structure within one Excel workbook for delivery data.• Tracked job progress and developed progress reports within Microsoft Project.

Greater Atlanta Area

• (Intern) Streamlined data entry for timesheets and other job applications using Excel with VBA.• Developed standardized timesheet with the ability to populate a timesheet database.• Assisted with scheduling, time sheets, and tracking job progress.

Greater Atlanta Area

• Worked on job sequence spreadsheets within Excel.• Obtained knowledge of technical sales proposals for multi-million dollar chemical plants.

Belgrade

• VBA programming and software sales.• Network construction and retrieving essential business data from damaged hard drives.