Back to Developers
Mohammad Ubaid Ansari

Mohammad Ubaid Ansari

Data Engineer

4+ yrs exp 90 ยท Outstanding

About

Data Analyst with hands on experience in data analysis, cleaning, validation, Excel based reporting, and dashboard development. Experienced in working with large datasets and customer records using Advanced Excel, SQL, Python, and Power BI. Skilled in transforming raw data into structured datasets, analytical reports, dashboards, and actionable insights. Strong ability to organize data, identify patterns, perform quality checks, and communicate findings clearly to support research and business decisions.

Skills & Expertise (25)

Python Advanced
8.0/10
3
Years Exp
Power BI Advanced
8.0/10
3
Years Exp
Advanced Excel Advanced
8.0/10
3
Years Exp
Pandas Advanced
8.0/10
3
Years Exp
SQL Advanced
8.0/10
3
Years Exp
Databricks Intermediate
7.5/10
2
Years Exp
DBT Intermediate
7.5/10
2
Years Exp
PySpark Intermediate
7.5/10
2
Years Exp
MySql Intermediate
7.5/10
3
Years Exp
Data Visualization Intermediate
7.5/10
3
Years Exp
Data Storytelling Intermediate
7.0/10
3
Years Exp
Data Warehousing Intermediate
7.0/10
2
Years Exp
ETL Intermediate
7.0/10
2
Years Exp
Data Modeling Intermediate
7.0/10
2
Years Exp
NumPy Intermediate
7.0/10
2
Years Exp
Matplotlib Intermediate
6.0/10
1
Years Exp
Seaborn Intermediate
6.0/10
1
Years Exp
YAML Intermediate
6.0/10
1
Years Exp
Jinja Intermediate
6.0/10
1
Years Exp
ChatGPT Beginner
5.0/10
1
Years Exp
Claude Beginner
5.0/10
1
Years Exp
Pivot Tables HLOOKUP XLOOKUP VLOOKUP

Work Experience

Data Analyst

A A AMRS

Jul 2026 - Present

Process, organize, filter, and validate structured customer and financial records using Microsoft Excel to support accurate operational reporting. Use VLOOKUP, XLOOKUP, and HLOOKUP to match records across datasets, reconcile customer information, and identify data. Use Pivot Tables to summarize customer data, identify patterns, and prepare structured reports for operational review.

Data Engineer

mao RS

Present - Present

Built an end to end data processing and analytics workflow using Python, MySQL, and Power BI, working with 12.8M+ sales records, 2.3M+ purchase records, and 430K+ inventory records across 119 vendors. Cleaned, transformed, validated, and combined large datasets using Pandas and SQL to prepare reliable data for analysis and reporting. Analyzed vendor purchasing, sales, inventory, and pricing data to identify operational trends, including the top 10 vendors accounting for 65% of total purchase dollars. Developed interactive Power BI reports to track vendor contribution, profit margins, and performance KPIs. Documented analytical findings and translated complex data into clear business insights and recommendations.

Data Analyst

D

Dec 2024 - Jun 2026

Delivered 165+ one-on-one sessions to 10+ international clients/students while maintaining a 4.3/5 average rating. Communicated complex technical information clearly to clients with different levels of technical knowledge.

Data Engineer

Ahm

Jan 2023 - Jan 2026

Built an end-to-end data engineering pipeline on Databricks to ingest 6 CSV files into Delta Lake using PySpark Structured Streaming. Implemented medallion architecture with Unity Catalog schemas to organize raw, conformed, and analytics-ready data. Created reusable PySpark transformations for deduplication, processing timestamps, and idempotent Delta MERGE upserts governed by a CDC watermark. Developed dbt incremental models using SQL and Jinja to transform trip data, and dbt snapshots to preserve SCD Type 2 history for dimensions and the fact table. Designed a star schema and documented a dbt Cloud workflow with Git version control, CI/CD-ready deployment.

Education

Bachelor of Arts - Teerthanker Mahaveer University, Moradabad

- ยท Afghanistan

Certifications

No certifications added yet

Interested in this developer?

Profile Score Breakdown

๐Ÿ“ท Photo 10/10
๐Ÿ“„ Resume 10/10
๐Ÿ’ผ Job Title 10/10
โœ๏ธ Bio 10/10
๐Ÿ› ๏ธ Skills 20/20
๐ŸŽ“ Education 10/10
โฑ๏ธ Experience 15/15
๐Ÿ’ฐ Rate 0/5
๐Ÿ† Certs 0/5
โœ… Verified 5/5
Total Score 90/100

Profile Overview

Member sinceOct 2026