About Ammar Analytics

Hello! I’m Ammar Ullah Khan, a Microsoft-certified Data Analyst with extensive industry experience. I excel in crafting complex dashboards that illuminate industry insights for stakeholders, while also mastering machine learning, analytics, and ETL pipeline optimization. My work has empowered clients in Saudi Arabia and the USA to make informed decisions through visually compelling and comprehensive dashboards. With a strong foundation in Python, SQL, Power BI, and .NET development, I transform intricate data into clear, impactful narratives. Let’s connect and explore how my expertise in data visualization and ETL optimization can drive your business forward with cutting-edge solutions!

Experience

VentureDive

Business Intelligence Engineer

Zyne Ventures
  • Worked with clients based in Texas, Houston

  • Created all of the company’s dashboards from scratch to streamline all of their processes. Effectively did requirement gathering and involved the stakeholders including business analysts and CEO.

  • Wrote custom Python and SQL ETL Pipelines and debug the old ones for the new data. Streamlined the ETL Pipelines using Airflow. Managed Big data migration of around 50 Million records.

  • Automated about 70 percent of the repetitive tasks using Custom Python and SQL at no additional cost. This increased the productivity and time efficiency of the entire business analyst team

2024 - Present

  • I played a pivotal role in enhancing the CRMC module, driving down bench count and optimizing resource planning, which not only saved the company thousands of dollars but also boosted our deal closure rate. By developing in-depth client analytics, I directly contributed to securing 1.25 millions in deals in just one quarter. Furthermore, I revamped the finance module, enabling more effective profit planning through smarter resource allocation. These initiatives not only delivered immediate financial benefits but also positioned the company for sustained growth and success.

  • Wrote custom Python and SQL ETL Pipeline. Effectively used advanced SQL including views, windows functions and aggregate functions.

  • Built Dashboards on PowerBI with proper data dictionaries. Implemented functionalities like Drill Down, Drillthroughs, Bookmarks, custom interactions, custom maps and role-based security

Data Scientist

  • Developed an authentication system using ASP.NET, Bootstrap, and PostgreSQL in collaboration with the .NET team.

  • Worked closely with the business team to pitch projects to clients.

  • Ensured seamless integration of the authentication system with existing applications and databases.

.Net Developer

TechSurge Inc
Inseyab Consulting & Information Solutions LLC

Machine Learning Engineer

  • Design, build, and deploy machine learning models.

  • Handle large datasets, develop algorithms, and optimize models using frameworks like scikit-learn.

  • Collaborate with data scientists and software engineers to integrate models into production systems, ensuring scalability and performance.

My Certifications