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 hand•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•Review sales force requests for new item movements from customers and provide item release dates based upon available inventory and total pipeline availability

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