Asim Khan
Fishers,IN
Summary
Highly motivated Business Intelligence and Data Analyst with over 8 years’ experience ranging from reporting automation to SAP ERP migration and building business solutions that empowered stakeholders from across different business areas the ability to create a self service model providing them with analytical reporting for their business needs.
Overview
9
9
years of professional experience
Work History
ANH GLOBAL BUSINESS INTELLIGENCE ANALYST
Cargill
04.2022 - 12.2024
- 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 efficient 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.
- Worked alongside a team that 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
Cargill
11.2018 - 04.2022
- 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 accuracy for Commercial Sales and Finance reports.
SR BUSINESS INTELLIGENCE CONSULTANT
CNO Financial
02.2018 - 10.2018
- 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.
SR BUSINESS INTELLIGENCE ANALYST
IU Health
02.2016 - 02.2018
- 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.
Education
Associate of Applied Science - Computer Science
Kingsborough Community College
Brooklyn, NY06-2001
Skills
- SQL querying
- Tableau
- Knime
- Alteryx
- SAP
- Business Objects
- Hadoop Business Warehouse
- Impala Queries
- Training
- Reporting solution
- People driven
- Team Building
- Honest Communication
- Strategic
Timeline
ANH GLOBAL BUSINESS INTELLIGENCE ANALYST
Cargill
04.2022 - 12.2024
SENIOR BUSINESS INTELLIGENCE ANALYST
Cargill
11.2018 - 04.2022
SR BUSINESS INTELLIGENCE CONSULTANT
CNO Financial
02.2018 - 10.2018
SR BUSINESS INTELLIGENCE ANALYST
IU Health
02.2016 - 02.2018
Associate of Applied Science - Computer Science
Kingsborough Community College