Ali Zain
@alizain2
Data analyst skilled in SQL, Excel, Power BI, and analytics to turn insights into smarter decisions.
What I'm looking for
I’m a data analyst who enjoys turning messy data into clear reporting and actionable dashboards. I work across SQL and Excel, and I also use Python for analytics and predictive modeling, with tools like Power BI and Looker Studio to communicate insights fast.
At Brighta Group, I streamlined data pipelines by cleaning and transforming large-scale datasets using Excel and SQL, improving reporting accuracy by as much as 25% across departments. I designed and executed Power BI dashboards for sales revenue and marketing campaigns, helping leadership spot key trends and cut operational inefficiencies by 10%. I also ran deep-dive analysis on historical financial and sales data to support different data-driven decisions across the company.
Previously, at MeasureCentric, I analyzed extensive sales and marketing datasets using SQL and Excel and built dashboards in Looker Studio, reducing overall marketing spend by 35%. I collaborated on complex analytics, including building a predictive model using Python to identify patterns across client datasets, and I helped clients boost marketing ROI by as much as 40% through well-structured presentations. Earlier at Nestlé as a Project Trainee, I used SQL and Excel to produce market analysis for a project and contributed to cutting intra-city business costs by 35% while analyzing survey insights from 250+ fruit traders.
Experience
Work history, roles, and key accomplishments
Data Analyst
Brighta Group
Nov 2024 - Present (1 year 9 months)
Streamlined data pipelines by cleaning and transforming large-scale datasets using Excel and SQL, improving reporting accuracy across departments by up to 25%. Designed Power BI dashboards for sales revenue and marketing campaigns, enabling leadership to spot trends and cut operational inefficiencies by 10%.
Marketing Analyst
MeasureCentric
Aug 2023 - Nov 2024 (1 year 3 months)
Analyzed sales and marketing datasets using SQL and Excel, and built dashboards using Looker Studio, reducing overall marketing spend by 35%. Collaborated on analytics including a Python predictive model, and delivered client presentations and dashboards that helped boost marketing ROI by up to 40%.
Project Trainee
Nestlé
Jun 2022 - Aug 2022 (2 months)
Formulated a market analysis report using SQL and Excel for Nestlé’s project 'Rapid Appraisal of Fruits in Gilgit City,' helping cut intra-city business costs by 35%. Supported a marketing survey with insights from 250+ fruit traders and produced a marketing strategy report and Excel dashboard to aid stakeholder decision-making.
Education
Degrees, certifications, and relevant coursework
Lahore University of Management Sciences
Bachelor of Science, Economics and Politics
2019 - 2023
Completed a BSc in Economics and Politics at LUMS (Sep 2019–May 2023), covering econometrics, statistics and data analysis, marketing principles, and Calculus I.
Tech stack
Software and tools used professionally
Availability
Location
Authorized to work in
Job categories
Interested in hiring Ali?
You can contact Ali and 90k+ other talented remote workers on Himalayas.
Message AliGet matched with your dream remote job
Sign up now and join over 250,000+ remote workers who receive personalized job alerts, curated job matches, and more for free!
