Umar Farooq Shaik
Data Science Student | | | | Texas, USA

Education

The University of Texas at Dallas, Dallas, USA
Aug 2021 - May 2023 | M.S in Business Analytics (Data Science focus)
Osmania University, Hyderabad, India
Aug 2013 - May 2017 | B.Tech in Mechanical Engineering

Work Experience

Analytics Engineer Intern
May 2022 - Dec 2022 | American Family Insurance, WI
  • Collected requirements and built a Looker studio dashboard to help data engineers monitor ingestion metrics.
  • Setup an ETL pipeline with Python, Docker, Terraform, & Google Cloud to build 3 metrics for dashboard.
  • Analyzed quarterly survey data using SQL by parsing JSON data and created a statistics report in Looker studio.
  • Developed python tests for Gitlab CI/CD pipeline to automate data governance validations, saving 90% time.
  • Enforced data governance standards on more than 40 datasets migrated to Enterprise Big Query Data Lake.
  • Technology Analyst
    Aug 2017 - Jul 2021 | Accenture, Hyderabad
  • Resolved over 800 functional issues in Microsoft’s sales operations through SAP, recovering $4M in revenue.
  • Automated tasks involved in high revenue impact issues with Python and Excel VBA, saving 85% user time.
  • Assisted development and testing of 3 ETL workflows in SAP BODS to migrate sales data to Azure Data Lake.
  • Integrated Power BI with SAP to reconcile return transactions which helped identify $300K in revenue leakage.
  • Received Spotlight and ACE awards for outstanding customer service and ensuring smooth month end close.
  • Skills

    Languages
    Python, R, SQL
    Platforms and Version control
    GCP, BigQuery, Cloudrun, Cloud Storage, GitLab, CI/CD
    Frameworks
    Pytorch, scikit-learn, sktime, Flask

    Projects

    Big Data Analytics on Truck Fleets, link
    Hadoop, Tableau, R
    Stack Overflow Question tag prediction, link
    NLP, PyTorch, Python, WandB