Seeking growth in the field of data analytics and data science, I look forward to conquering the data sphere, targeting mainly the manufacturing, technology and travel industries. Eager to contribute to data-driven projects and collaborate with fellow enthusiasts, let's connect and explore the world of data together.As a Master of Management Analytics student at McGill University, I look forward to collaborating with faculty and peers who share my passion for harnessing the power of data to drive strategic decision-making and solve complex business challenges.Recently, I successfully completed the Applied Data Science Program from the Massachusetts Institute of Technology (MIT), solidifying my expertise in the field. During this program, I predicted used car prices based on machine learning algorithm, where different regression models allowed me to hone my abilities in statistical analysis, data visualization, machine learning, and predictive modeling. I developed real-world expertise in tackling difficult data challenges and providing actionable insights through assignments and practical projects.https://github.com/ammadsohail99Keywords:Tech | Travel | Manufacturing | Oil and Gas | Automotive | Energy | Power | Data Analyst | Data SciencePython:Functions | Classes | Modules | Packages | Data structures (lists, dictionaries, sets, tuple) | Control flow (if, else, for loop, while loop) | File I/O | Regular expressions | Numpy | Pandas | Matplotlib | Seaborn | Jupyter Notebook | Machine Learning | Deep Learning | Generative AI | LLM | GenAI | TensorFlow | PyTorch | Keras |Natural Language Processing (NLP) | Data analysis | Data visualization | Data science | Automation | Web scraping | API development | API | Data-driven Decision Making | Data Insights | Data Cleansing | Data Cleaning | Predictive Modeling | Predictive Analysis | Descriptive Analysis | Google Collab | PyCharm | Spyder | gurobipy | Scikit-learn | SciPy Microsoft Office:Pivot Table | If statements | SUMIF and COUNTIF | Chart creation | Data analysis | Data validation | Advanced filtering | Conditional formatting | Index and Match | Data modeling | PowerPoint | ppt | PPTSQL:Sequel | JOIN | INNER JOIN | OUTER JOIN | LEFT JOIN | RIGHT JOIN | CROSS JOIN | UNION | INSERT | UPDATE | DELETE | CREATE | ALTER | DROP | CONCAT | RDBMS | INDEX | TRANSACTION | TEMPORARY TABLE | NORMALIZATION | OPTIMIZATION | DDL | DML | Data warehousing | ETL | Query | ERD | bi | NoSQL | Big Data | Cloud databases | MySQL | Apache | Data modeling | PhpMyAdmin | Neo4J
-
Data EngineerProcter & GambleToronto, On, Ca -
Research Assistant - Prof. GalperinMcgill University - Desautels Faculty Of Management Oct 2024 - Nov 2024Montreal, Quebec, Canada- Developed a scalable workflow using OpenAI's text-embedding-ada-002 model to process over 1 million rows, optimizing performance for large-scale datasets- Automated data preprocessing and API integration with Python, converting dataframes to JSONL files and consolidating outputs into a single CSV for analysis- Leveraged Dask DataFrame for efficient handling of large datasets, enabling flexible batch processing and enhanced workflow scalability -
Data Science InternCineplex May 2024 - Aug 2024Toronto, Ontario, Canada- Migrated and optimized LightGBM Machine Learning (ML) model scripts from Microsoft Azure ML to Databricks using PySpark, Spark SQL, and Python, enhancing compatibility and performance by 20%- Conducted A/B testing to assess the impact of parameter modifications on the ML model performance, achieving on average, 5% improvement in the R-squared value on both training and test datasets - Developed and automated a robust script to integrate and process outputs from two supervised machine learning models, seamlessly combining predictions to feed downstream ML workflows, reducing processing time up to 60% - Maintained version control of the repository using Azure DevOps(Repos and Git), ensuring efficient tracking, management, and updates of changes- Collaborated with BI, Data Science, and Data Engineering teams to design and integrate data solutions aligned with business goals, enhancing decision-making through actionable insights- Performed data validation checks by running SQL queries executed in Azure Data Studio within the Synapse Dev Environment, comparing and ensuring consistency against Spark SQL queries run in Databricks -
Data Architect - Academic Analytics Consulting ProjectAtkinsréalis Sep 2023 - Apr 2024Montreal, Quebec, Canada- Lead the design of intricate data architectures, utilizing cutting-edge cloud technologies such as Microsoft Azure, to optimize data workflows and storage solutions- Implemented automated data collection workflows leveraging R, Python, and API integrations, enabling efficient aggregation and processing of large datasets, resulting in improved data availability and accuracy for analytical insights - Designed and automated ETL workflows leveraging medallion architecture and orchestrated with Azure Data Factory, enabling seamless processing of datasets from diverse sources within only 35 minutes, ensuring scalability and reliability -
Trainee EngineerDescon Power Solutions (Pvt) Ltd. Jan 2023 - May 2023Rousch Power Plant- Performed Isolation and De-isolation of the plant apparatus based on the safety permit system of the company- Prepared Key Performance Indicator (KPI) reports, providing valuable insights into the plant's performance metrics and suggesting areas for improvement- Analyzed process flows in combined cycle power plants (gas and steam-powered) to trace the paths of gas and water, identifying potential performance-impacting areas through system diagnostics in the control room- Conducted detailed inspections and maintenance of faulty components, employing a systematic approach to identify issues promptly- Utilized root cause diagnostics techniques to trace out the origin of faults, enabling accurate problem identification -
Hotel Operations InternGozayaan Pakistan Nov 2022 - Dec 2022Islāmābād, Pakistan- Managing ARI (Availability, Rates, and Inventory) of different hotels on the website's back end.- Assisted the Customer Experience team for a week in building sustainable relationships of trust through open and interactive communication, handling more than 300 tasks assigned on platforms such as HubSpot, WhatsApp, etc.
Syed (Ammad) Sohail Education Details
-
Masters In Management Analytics
-
Data Science -
Mechanical Engineering -
4 A* 4 A
Frequently Asked Questions about Syed (Ammad) Sohail
What company does Syed (Ammad) Sohail work for?
Syed (Ammad) Sohail works for Procter & Gamble
What is Syed (Ammad) Sohail's role at the current company?
Syed (Ammad) Sohail's current role is Data Engineer.
What schools did Syed (Ammad) Sohail attend?
Syed (Ammad) Sohail attended Mcgill University - Desautels Faculty Of Management, Mit Professional Education, National University Of Sciences And Technology (Nust), Beaconhouse School System Wah Campus, Beaconhouse School System Wah Campus.
Who are Syed (Ammad) Sohail's colleagues?
Syed (Ammad) Sohail's colleagues are Eduardo Vega, Edward Wei, Brian Quist, Michael Jackson, Youssef Lakhdar, Aneta Golawska, Vero Carbonell.
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial