Ahsan

Ahsan

Data Engineer
Pakistan

About Me

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…

Experience

Data Engineer

IBM Corporation Middle East
Sep 2022 - Present · 3 years 10 months

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
Present

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.

Intern - Python Programmer

Intel, Remote

Developed and implemented a scalable data pipeline system using Python and data analysis libraries, resulting in a 50% reduction in data processing time.
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.
Collaborated with cross-functional teams to define data requirements and design efficient ETL processes.

Skills

Big Data Data Repository Hadoop Scala Spark Apache Hive Apache Pig Amazon Web Services (AWS) Kafka NoSQL Redshift S3 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
Report this Profile?