Aaron Lane Email & Phone Number

Cincinnati, Ohio, United States

• Leverages business acumen and technical expertise to craft and deliver a Business Intelligence strategy and roadmap aligned with strategic objectives, department goals, and deliver key data understandings.
• Utilize advanced Power Bi features, including but not limited to DAX calculations and custom visuals to create insightful and user-friendly data insights.

Cincinnati, Ohio, United States

• Research, review, and develop key operational and commercial metrics utilizing business intelligence, dashboard applications and multiple external data sources. Identify data errors, discrepancies, and reporting issues.
• Utilize advanced Power Bi features, including but not limited to DAX calculations and custom visuals to create insightful and user-friendly data insights.
• Proactively identify and help resolve data accuracy and reporting inconsistencies with other cross functional teams.

• Provide analytical support for sales team and supporting departments by providing data analysis, access to data and updating data infrastructure.
• Develop Power Bi dashboards and reports for sales team and supporting departments.

• Work on or lead special projects cross divisionally to solve business problems, identify opportunities, increase efficiencies and grow business
• Analyze data to provide key insights across enterprise to executive leaders and board of directors
• Build and maintain business intelligence tools and reporting
• Develop and publish KPI’s, providing context and analysis on the drivers and performance
• Pricing analysis for current customers or future customers via bids encompassing rebates, terms, freight, broker and/or sales commissions
• Act as data consultant and project manager for company, providing infrastructure, data mining, modeling, extraction and analysis

Columbus, Ohio Area

• Purchase inventory based upon analysis of various factors including forecasted monthly movements, seasonal movement, order minimums and item family run minimums to maximize profitability and reduce total inventory on.
• Develop and maintain inventory management and forecasting tools to assist in ordering and inventory management to provide accurate purchasing to maximize inventory turnover and probability
• Complete forecast analysis for item movement based upon historical data and current trends to assure proper inventory levels
• Assist or lead in item transition or item updates with internal departments and vendors to assure a smooth flow of inventory
• Build and maintain tactical relationships with vendors as a point of contact for purchase orders, prioritization and item deliveries
• Procurement contact for sales force and customer care for item specifications, inventory management and to provide order reminders for specialty and seasonal items

Columbus, Ohio Area

• Created and maintained reports to assist in providing data analysis to executive leadership and operations management to drive business decisions and improvements
• Facilitated dataflow to business for daily operations by independently anticipating management needs based upon current business demands and make recommendations for process improvement
• Created, maintained and updated reporting as well as analysis tools and database infrastructure utilized by management
• Mined various data types from multiple sources to provide overall view of current business performance as well as projected pipeline performance for segments such as financial, inventory and company workforce
• Administered electronic documentation programs, analytical dashboards, Microsoft SharePoint sites and update data for presentations
• Partnered with leadership to determine business needs and areas of opportunity for supported areas

Columbus, Ohio Area

• Data mined to create Excel reports and provide recommendations to leadership for business decisions as well as changes to existing processes
• Lead process improvement initiatives, including the documentation of internal processes, created/improved internal reporting and analysis tools such as an automated tool for new/existing reports
• Completed accurate and timely audit reports and analysis for entitlement usage and projections, schedule information, access updates and employee integrity information
• Scheduled meetings and training seminars utilizing meeting optimizers and planning strategies