Asim Khan Email and Phone Number

• Global Analytics subject matter expert helping with the transition of a legacy Enterprise Resource Planning (ERP) to S4 SAP Hana by creating foundational Data Blocks that provided business users the ability to easily access end to end business process data. By leveraging SQL skills and the native data table structure I was able to enhance the data models by translating the ERP naming to business-friendly names, defining the data fields and filtering for actively used data resulting in the business making more efficient logic-based decisions.• Streamlined training processes for user friendly learning experiences.• Developed automated reporting solutions. Utilized SQL, Knime, Tableau, and Alteryx to generate data sets.• Built over 60 data blocks to cover the lifecycle of the business process including: purchasing, receiving, manufacturing of new products, sales orders, invoicing, accounts receivables, accounts payables, pricing, contracts, formulation, master data tables and more.• Created the logic for BOM explosion dataset, including 10 levels of BOM recipe breakdown which provided the business visibility into the different inclusion rates at each level in the Bill of Materials recipe.• Saved over $2M in costs by using in-house data analytics skills and labor to create business critical reports.• Saved over $3M in software costs by building data blocks that were more transparent and reliable than Every Angle and Business Objects (BOBJ) reports.• Enforced data security to assure strict adherence to Policy from both role based and project scope.

• Senior Business Intelligence Analyst, focused on executing and maintaining monthly financial reporting that was used by leadership and the Sales team to make critical decisions around product sales and budget planning.• Promoted utilization of reporting technologies to foster self-empowerment culture within the organization.• Developed reporting automation solutions for month end financial reporting which provided business leader and account managers critical KPIs• Automated 100 plus reports, moving them out of Excel reporting to a more accurate and user-friendly Tableau dashboard.• Spearheaded adoption of advanced reporting technologies, resulting in improved data accuracy for Commercial Sales and Finance reports.

• Designed customized data collection models for specific visualization tasks.• Developed customized reports in Tableau, summarizing and presenting data in a user-friendly format.• Worked with Senior Leadership teams to determine data needs and build Tableau Dashboards to provide unit cost analysis across different business areas.• Reports Automation Project – Automated monthly and yearly reports utilizing business intelligence tools such as Alteryx, Business Objects and Tableau.• Identified and implemented process improvements.• Providing cost of operations dashboard based on monthly expenses and monthly transactions.• Resolve service desk customer support tickets, providing data support to various business operations.

• Demonstrated Tableau functionality to providers and business users – promoting technology use and expanding the number of Tableau users across the network.• Successfully led and completed IUHP Physician Compensation project – Automated and scheduled of 800 plus physician compensation reports into one Tableau dashboard.• Provided ad hoc reporting support to business users – utilized SQL server management studio and visual studios for extracting data from SQL server.• Created and updated Tableau dashboards, SSRS reports per business requirements.• Published on boarding documents for new hires – expediting the process of new employee training.• Worked with business users to develop and maintain business, technical and functional requirements documents.• Guided and trained new team member on best practices for data analysis and visualizations techniques based on business requirements.• Created stored procedures and views in SQL server for quicker data retrieves.• Created workflow using SSIS to support HEDIS measures.• Created reports in MS Power BI to understand functionality and best practices.