HELLO

I'm Umar Farooq

I Do

Data analyst with experience of Marketing and Sales departments. Persuing Master of Analytics from Texas A&M, University, Graduate of UT Austin, Data Analytics and Visualisation boot camp with an educational background of Economics and Finance. Entrepreneurial mindset with an aptitude for problem solving and identifying new opportunities for growth based on data analysis. Experience in important analytics tool and languages like Excel, VBA, Python, SQL, R, JavaScript, Google Analytics, HTML, CSS, Machine Learning, BigData, Tableau & PowerBI.

Portfolio

About Me

50K+
Lines of Code
40+
Project Done
100+
Jupyter Notebooks
200M+
Rows of Data

What I Do

Business Analytics

Review your business data to find growth opportunities for your business and discovery potential pitfalls.

ETL

Extract data from various sources, transform it into structured/unstructured data set and load it to database.

Data Analytics

Using SQL, Python & R to run different queries on the dataset to find trends and predict outocomes.

Amazon AWS

Load databases on the Amazon Web Services to be used for websites development or further analysis.

Web Development

Using HTML, JavaScript, Python and Flask App to development web applications to display data.

Web Design

Using CSS, plotly.js, D3.js, leaflet.js to develop interactive dashboards for data representation.

My Recommendations

Haseeb Sattar

CEO of Goghoom.com

Umar proved to be an exceptional team member with an uncanny ability to coordinate with various stakeholders. Umar's teamwork, decision making process based on data, analytical thinking is second to none. Moreover his ability to navigate tech & non-tech personnel was a specific trait which served him well. He will be an asset to any organisation.

Derrick Dennis

Data Analyst

Umar and I attended the UT Ausitn Data Analysis and Visualization Bootcamp together. During our time, Umar impressed me with his problem solving capabilities and his analytical skills. Whenever we presented team projects, I knew his group would have an outstanding presentation because of Umar’s tenacity and drive to take the project to the next level.

Yasmeen Ahsan

HRBP at Samsons Group

Umar Farooq has been an excellent resource for our organization. He is creative and have good analytical skills as well. He knows the digital marketing world and understand its dynamics well. He was working on our few projects and had proved himself to be a great asset by adding value to our company's projects. He will always go an extra mile to get the job done.

Mishaz Khawaja

Senior Executive at Nielsen

Umar is a self motivated individual with sharp organisational and management skills. His dedication to make a difference through his presence and skill set is hard to ignore. He sets his eyes for the goal and knows how to keep himself focused and committed. His soft skills are equally remarkable and he is no doubt a reliable and trustworthy team player.

Syed Ali Abbas

Sr. Manager IT at HRL

Umar has always been a dependable team member who would bring great new ideas to the table. One of the good things about Umar was his approachability and communication. He also has an uncanny ability to discover and analyse problem areas very quickly, and effectively communicate his ideas to all the stakeholders for quick resolution.

Mirgadir

Consultant Data Analyst

Umar and I took the same Data Analytics and Visualization BootCamp together. Umar is intelligent, polite, and willing to help everyone. He would always take out time to spend with other students in class to help them understand the topic on which they are stuck. He is a great problem solver and is able to quickly identify any issues with the code.

Coding Skills

CSS
HTML5
Python
JavaScript

Data Skills

SQL
Tableau & PowerBI
Excel
VBA

Professional Skills

ETL
Web Devlopment
Data Analysis
Data Visualisation

Working Knowledge

  • R, Leaflet.js, D3.js, Plotly.js

  • Machine Learning - Tensorflow, KNN Classification

  • Big Data - PySpark

  • Amazon Web Services

  • API Development

  • PostgreSQL & MongoDB

  • Pandas, Matplotlib, SQLalchemy, Flask

Education

A&M University

Master of Analytics2023 - 2025

The MS Analytics program is a 5-semester part-time program that focuses on applying statistical modeling methods to big data and solve business problems. Graduates are equipped with high demand skill-sets. These include: Business Acumen, Data Processing, Data Science/Storytelling, Machine Learning, Predictive Analytics & Statistics.

University of Texas, Austin

BOOTCAMP IN DATA ANALYTICS & VISUALISATIONAPRIL 2020 - OCT 2020

A 24-week intensive program focused on gaining technical programming skills in Excel, VBA, Python, R, JavaScript, SQL Databases, Tableau, Big Data, and Machine Learning.

Lahore University of Management Sciences

BSC IN POLITICS & ECONOMICS2010 - 2014

A four years undergraduate degree in Economics and Political Sciences, supplemented by high-concentration of Accounting and Finance courses.

Experince

Tiger Pistol

Data Analyst SaaS2021 - 2023

Develop interactive reports and dashboards in Tableau to represent platform data for clients and internal teams.

Use PostgreSQL and SQL Server to query the database for required data for Tableau Reports

Use PySpark Library in Python to develop scripts for automated reporting from platform to internal teams.

Develop predictive models using Python and Tableau to help clients understand their data and modify their inputs to achieve better results on the company’s platform.

Habib Rafiq Pvt. Ltd.

Digital Marketing Manager 2016 - 2020

Launched a successful 3000 Acres real-estate project and established a robust digital marketing team.

Developed, executed & managed various digital marketing & online sales strategies of the project, "Capital Smart City - Islamabad".

Managed online sales & referred serious clients to the sales team for finalisation. Developed weekly sales analysis and reports for Directors.

Samsons Group of Companies

Digital Marketing Specialist 2015 - 2018

Managed the TTL Marketing and Sales for one of the subsidiaries of Samsons Group.

Re-launched and increased monthly online sales of the project by 500% by advertising on various digital marketing platforms.

Launched the website for the project.

Developed advertising budget and spending strategies for approval of the Company Directors.

Calculated and presented monthly advertising ROI figures to the Company Directors.

Managed media agencies for proper implementation of Digital, PR campaigns and PR events related to Samsons and its subsidiaries.

Developed, in coordination with the media agency, print and video advertisement campaigns for different projects of the company.

Trechnology - Goghoom.com

Product Development & Innovation Manager 2014 - 2015

Successfully launched the website with an inventory of 500 hotels across Pakistan.

Worked in multiple shoes for a hospitality industry startup.

Managed key product development life-cycles and after customer feedback, coordinated with the software development team to add/remove/update features for better UI/UX of the website. Also, on-boarded hotels inventory for the website by negotiating booking rates with different hotels.

Contact Me

My Location

Austin, Texas.

Phone Number
+1 512 367 9001
Email Address
umarfoo@yahoo.com
Lets Connect