Kurt Auzins Email & Phone Number

Fishers, In, Us

Atlanta, Ga, Us

• Designed and developed a comprehensive financial dashboard from scratch, enabling real-time tracking of key metrics such as Revenue and EBITDA against budgeted targets.• Utilized SQL to efficiently extract and manipulate data across multiple databases, ensuring seamless integration and accurate reporting.• Developed a Daily Vehicle Inspection Report system that consolidated data from diverse sources, providing a streamlined overview of vehicle movements and completed inspections.• Created an automated order management tool that processed customer orders from nearly a thousand locations, dynamically assigned them to the nearest available technicians, and generated email notifications for corresponding managers.

Fishers, In, Us

• Automated comprehensive business intelligence reports covering key metrics such as hires, promotions, tenure, retention, utilization, overtime, mileage, open orders, and recruiting trends, driving data-informed decision-making.• Administered the HR Logix Applicant Tracking System (ATS), streamlining and enhancing recruitment processes for greater efficiency.• Developed scheduling tools that optimized operational efficiencies.• Leveraged Power Query's ETL functionality to seamlessly integrate and consolidate data from diverse sources, including OData Feeds, SQL Server, ADP, TIBCO Jaspersoft, and SharePoint.• Designed star schema data models, enabling advanced dimensional analysis and deeper data insights.

Indianapolis, In, Us

• Programmed Excel workbooks using VBA to interact with Outlook and Adobe, automating the parsing of PDF files for streamlined data processing.• Extracted, cleaned, and mapped data to create a CSV upload file for an Epicor-based ERP system, ensuring accurate and efficient data integration.• Developed a comparison method for SAP Ariba PO data against existing ERP sales orders, identifying additions and changes to improve order accuracy.• Created a picture-based parts catalog, organizing thousands of specifications and photos to enhance part selection and drive sales efficiency.

Self-employed entrepreneur in real-estate; purchased and repaired several houses.

Zurich, Zurich, Ch

• Designed reporting systems crucial for retaining GE as one of NAS's largest clients, contributing to over $100 million in annual sales.• Leveraged SharePoint for publishing reports, presentations, and business tracking tools, ensuring streamlined access and collaboration.• Utilized Excel, TIBCO Spotfire, Access, PowerPoint, SharePoint, and Cognos as primary tools to deliver comprehensive business insights.

• Established best practices, conducted branch audits, and led SOP training to enhance operational efficiency.• Boosted compliance rates to over 98% through targeted process improvements.• Created annual budgets, regional roll-ups, and monthly tracking workbooks for financial oversight.• Developed an automated commission calculation process, utilizing Cognos data and Excel, to streamline nationwide commission reporting and payments.

• Grew the Indiana Technical area sales to over $10 million while managing four branches including a startup onsite at Roche. • Led application transitions for payroll and billing as well as implemented a new resume retrieval system. • Quickly evolved into a subject matter expert on the new platforms and trained end-users.

• Opened and managed an RPO operation serving Cummins• Created MS Access job order and applicant tracking databases. • Developed a VMS for contingent staffing.