ALEX JURECKI

Plano, TX ***** acxcny@r.postjobfree.com 469-***-****

SUMMARY OF QUALIFICATIONS

Skilled data analyst, able to work independently as well as on cross functional teams in order to understand and translate requirements, design solutions, analyze and interpret results, and present findings up to an executive management level. Agile team-player able to manage time efficiently and successfully manage several projects simultaneously.

Knowledgeable and experienced in a variety of analytical and technical tools such as SAP, SQL, SSIS, SSRS, Minitab, Tableau, MS Excel, MS Access, SharePoint, VBA, Python, and Java. Always willing and eager to embrace new tools, processes, and strategies that promise to improve operational efficiency.

WORK HISTORY

OPERATIONS ANALYST Ericsson Inc, Plano TX 8/2015-9/2016

Managed warehouse personnel and assured assigned department goals were achieved. Monitored hourly performance and addressed inefficient activity. Engaged with employees as well as other warehouse staff on a consistent basis. Motivated and encouraged employees to achieve individual performance goals.

Developed KPI analytics and reporting (daily, weekly, monthly, quarterly, and yearly) using business intelligence analytical tools. Prepared and oversaw daily and weekly production meetings with Operations Managers and leads. Generated reports on productivity, production status and labor hours for monthly/quarterly business reviews.

Abstracted and researched quality data to perform root cause analysis. Reviewed trends and took preventative actions and provided short term and long term solutions. Identified and implemented process improvements across the operations organization

Responsible for management of packaging materials. Utilized SQL and MS Excel, Access, Outlook, and VBA programming language to automate 80% of ordering materials, managing inventory levels, and payment for materials, as well as developing and implementing plans for efficient use of materials.

Worked closely with subject matter experts and key stakeholders to understand business reporting requirements and implemented automated reporting solutions in SQL, Tableau, and Excel/Access (VBA) to meet requirements.

Developed and implemented in-house program in Java programming language to connect directly to SAP application servers and automatically generate reports and perform transactions in a highly configurable (ad-hoc) and efficient manner.

SUPPLY CHAIN ANALYST Ericsson Inc, Plano TX 12/2013-8/2015

Reconciled over $10M of inventory variances between SAP and 3rd Party Provider (3PP) software.

Eliminated overtime for report generation through development of reports using SQL as well as Visual Basic (VBA) macros to automate repetitive and time consuming tasks.

Involved in planning and execution of the complete move of a 300,000 sqft national warehouse and distribution center from one 3PP in Irving to a new 3PP in Lewisville. Utilized advanced data analysis techniques to manage flow of materials out of former warehouse and to ensure correct inbound processing at new provider’s facility. Successfully accounted for several thousand handling units of hundreds of different product types.

SUPPLY CHAIN ANALYST INTERNSHIP Ericsson Inc, Plano TX 5/2013-12/2013

Reduced WIP and excess inventory by over $250K; added benefit of project included material procurement cost avoidance through identification and reallocation of idle and unused materials.

EDUCATION

UNIVERSITY OF TEXAS AT DALLAS Richardson TX 2009-2013

B.S. Business Administration

Major in Procurement, Supply Chain Operations

Minor in Database Administration

CERTIFICATIONS

SAP CERTIFIED ASSOCIATE

TERP 10 - Business Foundation & Integration with SAP ERP 6.0 EHP5

ORACLE CERTIFIED ASSOCIATE

MySQL 5.0

TECHNICAL SKILLS

SAP: MM, SCM, CRM, SRM, EWM, APO, SD, HANA, BW

SQL and TSQL: Microsoft SQL Server 2008, SSRS/SSIS, MySQL

Minitab, Tableau, Java, Python, Lean Six Sigma

Expert Level MS Office (Excel, Access, SharePoint, VBA Macros)

Contact this candidate