Saad Salman Khan

• Developed Python scripts for real-time inventory tracking, integrating data using SSIS and automating daily reporting for senior management.

• Designed interactive dashboards to track sales, orders, and year-over-year performance trends, aiding strategic decision-making.

• Automated promotion monitoring and traffic analysis to identify key trends and optimize marketing strategies.

• Configured Master Data Services (MDS) for streamlined data input, enhancing accuracy and accessibility.

• Collaborated with cross-functional teams via Jira for project tracking and requirement gathering.

• Automated technician performance reporting, reducing manual effort and improving accuracy.
• Developed weekly KPI reports for senior leadership, leveraging SQL to extract and analyze Enterprise Data Warehouse (EDW) data.
• Administered databases to ensure data integrity, accessibility, and seamless reporting workflows.
• Led the transition from legacy systems to a new EDW platform, minimizing downtime and ensuring business continuity.

• Managed database administration (DBA) tasks, ensuring stability, availability, and optimized performance.
• Designed, developed, and maintained multiple Tableau dashboards for clients, enhancing data visualization and reporting accuracy.
• Administered SQL databases, performing ETL and SSIS operations to streamline data processing.
• Led the migration of dashboards from MicroStrategy to Tableau, improving efficiency and user accessibility.
• Conducted historical and projected drug utilization modeling, providing data-driven insights to inform strategic decisions.
• Served as Tableau Administrator, managing user roles and permissions to ensure data security and controlled access.
• Compiled and analyzed data to create professional yearly reports tailored for various clients.
• Performed data cleaning and optimization across multiple storage systems, improving virtual machine performance and efficiency.
• Provided SAS process support, diagnosing and resolving production environment issues to maintain workflow integrity.

• Designed Tableau dashboards to monitor KPIs and operational goals, improving visibility and reporting efficiency.

• Automated data extraction and reporting workflows using Microsoft PowerApps and Power Automate, streamlining operations.

• Led ETL processes to integrate SQL Server data into business intelligence solutions for improved decision-making.

• Contributed to a company-wide data migration initiative, ensuring a smooth transition and system optimization.

• Provided onboarding and training for interns in Tableau, ETL, SSIS, and SharePoint, fostering knowledge-sharing.

• Assisted in the development of software solutions for a microfinance bank, funded by the Bill and Melinda Gates Foundation.
• Conducted quality assurance assessments and coordinated with clients and vendors to address software compliance issues.
• Collaborated with finance and IT teams to enhance software efficiency and functionality.
• Reviewed IT security controls, database security, and system integrity, ensuring regulatory compliance.
• Collected and validated financial data, ensuring accuracy and completeness for reporting purposes.