JOHN KRET

SUPPLY CHAIN ANALYST | BUSINESS INTELLIGENCE EXPERT Self-assured, collaborative, knowledgeable Information Technology (I.T.) professional with more than 30 years of valuable data processing career experience. Resourceful with a strong background in systems analysis, programming, and data warehouse development in the metals distribution and healthcare clinical engineering industries. Adept at guiding and mentoring others using a hands-on leadership style, often admired by peers and supervisors alike. Innovative with an ability to excel under pressure in a deadline-driven, fast-paced setting that calls for flexibility and adaptability. Juggle projects simultaneously using time management and organizational awareness. Now seeking to actively contribute to a company's leadership team that aims to be cutting-edge and progressive in an Analyst, Report Writer, or SQL Developer capacity that supports I.T. projects at the divisional or departmental levels to further career growth. ACHIEVEMENTS Liaise with management to support decision making, achieve long-term company goals, streamline processes, reduce operating costs, impact efficacy, and use coaching, mentoring, and professional development to inspire subordinate staff. Continually leverage industry best practices, skills, and writing savvy to cater to a diverse audience; deliver engaging presentations and forge solid relationships with internal and outside clientele.

• Utilize analytical tools to determine optimal courses of action; work to ensure staff is fully trained on the entire Microsoft Office Suite as well At Castle Metals, assessed product performance to determine the best mix to use; also suggested a transfer of slow-moving materials to a more suitable location yielding a $2.5M savings in company inventory. Gained a reputation for excellence in assessing & translating business systems to improve functioning, improve business practices and incur operational savings cross-departmentally. Crafted Castle Metals' operations that offered staff the functionality to generate Excel customer reports via VBA code and develop ad-hoc reports for management using Excel VBA, along with Pivot Tables and Charts Worked in conjunction with the Transformco Grocery Senior management to reduce excess inventory by $500k annually, thus allowing for more efficiency and operational excellence. Enhanced Aramark's equipment pricing accuracy, generating $100K in additional annual revenue. Integral to the Ryerson project to eliminate the internally developed computer system; gathered and interpreted long-term client requirements into data models, devised reports, and used data warehouse modeling to incur $100K in annual savings.

• Supervised team of 5 staff members.
• Achieved integrating SQL reports by completing conversion to Crystal Reports with accuracy and efficiency.
• Used Microsoft Excel to develop inventory tracking spreadsheets.
• Achieved improving supplier delivery through effectively helping with documenting supplier deficiencies.