Sohaib Zafar Ansari
Data Analyst / Engineer
Experience
Data Engineer
- MobieTrain (Remote, Portugal)
- June 2023 - November 2023
- Developed data solutions using Google Cloud services.
- Managed and enhanced existing data pipelines.
- Improved database and dashboard performance.
Lead Data Engineer
- Orpea Group (Lisbon, Portugal)
- April 2021 - May 2023
- Work as an Infrastructure administrator and Lead Data engineer.
- Administration of Multiple tools and their servers, which are used by the entire data team. Data Galaxy, Informatica, Denodo, MongoDB, DOT Anonymizer.
- Working together with the Business teams / data owners to understand the data and its origin.
- Building of Standardized Data pipelines to onboard data from 25 countries where Orpea branches exist with several different data sources.
- Implementation of Use cases for several teams from different countries.
- Integration of MongoDB in the Data flow pipeline to track the flow of changes and updates in the data itself.
- Maintenance of roles and users of all the tools for data governance.
- Data Anonymization to comply with the GDPRs rules.
- Data profiling using informatica for exploratory data analysis.
- Building Data Warehouse for real-estate department using SQL Server Management Studio and SQL Server Integration Services.
- Building small encrypted data pipelines across multiple applications using Enovacom.
IT Developer / Data Consultant
- Whitestar Asset Solutions (Lisbon, Portugal)
- August 2020 - March 2021
- Development of IT solutions for data flow of unstructured data using Microsoft Azure Tools.
- Data transformation using Pyspark and Python in Databricks.
- Test driven development with Unit tests of seen cases.
- Data factory to automate the data flow for the final user.
- Azure DevOps to build the infrastructure and Deploy.
Data Analyst / Data Engineer
- Daltix (Lisbon, Portugal)
- April 2018 - April 2020
- I was responsible for the first line delivery of reports, custom analysis, visualizations and working with the commercial team to deliver presentations and data insights.
- Setup Customer databases and ingest data in them by setting up an automated process.
- Extraction, Transformation and Loading of data for Daily/ Weekly/ Monthly/one off Report Deliveries.
- Dashboards on Tableau and Excel for data visualization.
- Scaling the Framework by writing implementations and constantly maintaining them.
- Data Quality Assurance to maintain the good quality of the data collected by the company and received by the client.
- Setting up and maintaining Metabase for user friendly descriptive analysis.
- Jira as a tool to stay updated to tasks that needs to be tacked.
Customer Service Intern
- McCann Worldgroup (New Delhi, India)
- June 2014 - July 2014
- Analyzing every day newspaper advertisements for Wallmart in India.
- Billboards and newspaper advertisements for General motors
- Video advertisements and package designing for Dabur products.
Outgoing Exchange Manager
- AIESEC in AMU (Aligarh, India)
- Nov 2013 -Nov 2014
- Marketing and conducting presentations for outgoing exchange programs of AIESEC
- Matching profiles of potential candidates with international internships available
Education
Master in Statistics and Information Management (Specialization of Market Research and CRM)
- Nova IMS, Universidade Nova de Lisboa, Portugal
- 2016 - 2019
Master of Agribusiness Management
- Aligarh Muslim University, India
- 2013 -2015
Bachelor of Commerce (Honors)
- Aligarh Muslim University, India
- 2010 -2013
Academic Projects
- Research on Job seekers survey in Aligarh Muslim University
- Dissertation on Brand and product differentiation on Milk products in Aligarh city
- Building a data warehouse for a sport equipment manufacturer
- Factor and Cluster analysis on survey results of a car company
- Market research on customer satisfaction of A Padaria Portuguesa services (A leading restaurant chain in Portugal)
- Partial Least Squares applied to Internet Banking Data for risk minimization
- Segmentation analysis and Predictive modelling for wine rack purchase prediction
- Master Thesis on changing trends in Market Basket Analysis
TECH. Skills
Contact
- Sohaib Ansari
- sohaibansariamu@gmail.com
- (+351) 920373464
- sohaib150193
- Atlassian Agile Project Management Professional Certificate
- OpenEDG Python Institute: Programming with Python Professional Certificate
- PMI - Project Management Foundations: Small Projects
- Google Ads 2022 - Professional Course
- Introduction to Data Warehouses
- Intro to SQL for Data Science Course
- Introduction to R Course
- Advance SQL for Data Scientists
- The Data Science of Marketing
- Intro to Python for Data Science Course
- Python Statistics Essential Training
- Pandas for Data Science
- NumPy Data Science Essential training
- Machine Learning for Marketing: Essential Training
- Building a Recommendation System with Python Machine Learning & AI
- Learning Data Science: Tell Stories With Data
“I had the pleasure to work with Sohaib at Daltix on a lot of different data analysis projects. He is reliable, organized, diligent, and a fast learner. All these attributes were critical when a project was assigned to him, as we always work under important, business driven deadlines. As end responsible of a business project, he also needed to reach out to other teams to get things done. Being a fast learner and a person with a broad interest field, this helped him understand the market fit and quickly choose the right path to deliver successful projects. As a colleague he is very social and brings a very healthy “happy” atmosphere to the team. It was a pleasure to work with Sohaib!”
“It has been great working with Sohaib: he’s been able to learn quickly on the job and I’ve never seen him without a smile on his face. He’s very reliable and puts a lot of care & effort into his work. During his last weeks he also onboarded new employees with great care and got them up and running in no time. Besides that he also knows how to document his work so that other people understand it. I’m sure his passion for data will make him a great candidate for data-related roles. ”
“During my time at Daltix I worked closely with Sohaib. I would say that Sohaib’s biggest strengths are his commitment to deliver and his curiosity. On numerous occasions, Sohaib decided to work at odd hours or stay until late if it guaranteed a more satisfied customer. He also has a very curious mind, always looking to improve himself and learn from his peers. At the same time he is always available to help his colleagues and share his knowledge. In short, I believe that Sohaib can be an asset to any team, as he is a great team player and a good data analyst.”
“I have had the pleasure of working with Sohaib for the past half year at MobieTrain and I also had the pleasure to work with him at Daltix, before. I can confidently say that he’s one of the most committed and reliable employees I have ever met. In the role of Data Engineer, he was perfectly integrated in our international team.
He’s a very professional person, with the ability to quickly understand any problem that we throw at him, while already working out the best solutions for it.
In addition to the technical skills, he has excellent communication and interpersonal skills, being able to work effectively with people from all levels of the organization. Sohaib is always willing to go the extra mile and consistently delivers high-quality work on time. He’s also a team player and is always willing to help out his colleagues, adding value that goes way beyond delivery.
We’ve witnessed, first-hand, in more than one occasion, the commitment and willingness to go the extra mile to deliver with the expected quality, allowing us to launch our features in time.”
“I worked directly with Sohaib as a Data Analyst at Daltix.
Sohaib is great to work with; he’s eager to learn and I’ve seen him progress greatly with his python and SQL skills over the course of the two years we worked together. Besides being a great learner, he’s always available to help out in stressful situations (we had many!) and is never afraid to reach out for help when needed, which ensured pain points would not go unnoticed.
He also added a lot to our company culture with his positive attitude and humour, as well as the funny portuguese expressions he learns day to day! I really hope we get to work together again in the nearby future. ”
“I highly recommend Sohaib Ansari for his unwavering commitment and outstanding contributions to our team. Sohaib played a vital role in our success by suggesting excellent options that significantly enhanced our ETL process. His proactive approach and innovative solutions showcase his expertise in data engineering and analytics. Sohaib’s dedication and problem-solving skills make him an invaluable asset to any organization.”