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
Location
Karachi, Pakistan
Contacts
+92 336-2349646
ammarullahkhan5@gmail.com
Expertise
Transforming data into impactful stories for my clients