Ahsan

Ahsan

Data Engineer
Pakistan

نبذة عني

With almost 2 years of expertise as a data consultant, my expertise in data engineering, ETL pipelines, and data modeling, I am looking to leverage my technical and problem-solving skills to drive positive business outco…

الخبرة

Data Engineer

IBM Corporation Middle East
Sep 2022 - حتى الآن · 4 سنوات 1 شهر

Developed and executed SQL queries on a daily basis to provide real-time data insights, making it easier for stakeholders.

Developed a customized script in python on the IBM campaign management tool to optimize query performance.

Developed and implemented an alert system that notified the appropriate team members whenever a query exceeded its execution time threshold, ultimately
reducing query response times by 40%.

By leveraging Python and ODBC to seamlessly integrate the tool with Oracle 19c were able to optimize query performance and increase the customer base by
10%, resulting in a significant boost in revenue for the client.

Collaborated with cross-functional teams to define data requirements and design efficient ETL processes, resulting in a 60% increase in data accuracy and
reliability.

Developed a script using pandas, matplotlib, plotly, and openpyxl to automate the integration of weekly reports into a single PowerPoint presentation, saving
an average of 10 hours per week.

Consultant - Data

IBM, Lahore / Remote
حتى الآن

<p>Developed and executed SQL queries on a daily basis to provide real-time data insights, making it easier for stakeholders.<br>
Developed a customized script in Python on the IBM campaign management tool to optimize query performance.<br>
Developed and implemented an alert system that notified the appropriate team members whenever a query exceeded its execution time threshold, ultimately reducing query response times by 40%.<br>
By leveraging Python and ODBC to seamlessly integrate the tool with Oracle 19c were able to optimize query performance and increase the customer base by 10%, resulting in a significant boost in revenue for the client.<br>
Collaborated with cross-functional teams to define data requirements and design efficient ETL processes, resulting in a 60% increase in data accuracy and reliability.<br>
Developed a script using pandas, matplotlib, plotly, and openpyxl to automate the integration of weekly reports into a single PowerPoint presentation, saving an average of 10 hours per week.</p>

Intern - Python Programmer

Intel, Remote

<p>Developed and implemented a scalable data pipeline system using Python and data analysis libraries, resulting in a 50% reduction in data processing time.<br>
Successfully migrated an existing on-premises data infrastructure to an AWS EC2 cluster, resulting in a 75% decrease in hardware costs and improved scalability for future growth.<br>
Collaborated with cross-functional teams to define data requirements and design efficient ETL processes.</p>

المهارات

البيانات الضخمة مستودع البيانات هادوب (Hadoop) سكالا سبارك أباتشي هايف أباتشي بيغ خدمات أمازون ويب (AWS) كافكا نوسكيو إل ردشفت (خدمة قاعدة بيانات) إس 3 (خدمة تخزين البيانات على الإنترنت) Python C++ SQL Bash MySQL Oracle Hive BigQuery Snowflake Databricks Splunk Grafana Airflow Kubernetes Docker Athena RDS Glue EC2 Cloud9 IAM ODBC pandas matplotlib plotly openpyxl
الإبلاغ عن هذا الملف الشخصي؟