Ahsan Rafiq Hussain
Database Expert | Data Engineer | Cloud
-
--
ahsanghanchi
About Me
I’m an IT Professional who loves to build data-driven applications and solutions.
Proficient in database design, development, and administration, with a strong background
in data engineering. Skilled in building end-to-end solutions that extract, transform,
and load data, allowing for the transformation of data into actionable insights and
results-driven solutions. Committed to delivering high-quality, robust, and scalable
systems for clients and stakeholders.
Skills
Work Experience
Senior Database Administrator
Sibisoft – A NorthStar Company
•
•
•
•
•
Streamlining the backup process for 700 clubs, reducing the backup time by 50%.
Implementing a disaster recovery and replication layer, ensuring business continuity in case of an unexpected event.
Regularly monitoring and maintaining the health of the database systems, preventing potential outages and downtime.
Performing regular maintenance tasks, such as database tuning, index optimization, and security updates.
Providing technical support and troubleshooting for various database-related issues.
Database Administrator
Conure IT Services
•
•
•
•
•
November 2017 – October 2021
Successfully reduced server hardware utilization by 40% by implementing "Citus Data Solution" for an e-commerce
application, resulting in an increase in web user visits from 5k to 300k.
Implemented a custom audit layer at the database level to ensure data integrity for each application, enabling the creation
of custom audit reports for compliance.
Successfully designed and implemented a Timeseries schema and InfluxDB for IoT applications.
Senior Database Developer
Conure IT Services
•
Oct 2021 – Present
January 2017 – October 2017
Wrote triggers to perform the ETL process, streamlining the data storage process from the staging to the reporting
database.
Successfully handled a big data application for a telecommunications organization, with a cluster size of over 4TB.
Rewrote and optimized queries to run efficiently and promptly, using techniques such as CTE, query rearrangements, and
parallel connections.
Data Analyst / ERP Consultant
e-Blue Systems
o
o
o
o
o
January 2012 – December 2016
Made large and complex data more accessible and usable for clients.
Transformed, improved, and integrated data to meet business requirements.
Combined data result sets from multiple sources.
Delivered data in a useful and appealing way to users.
Configured and deployed complete ERP systems, including add-ons and chunks.
Data Engineer
Freelancing
o
o
o
2019 – 2021
Designing and Implementing a Data Warehouse Solution for a retail company.
Developing an efficient and automated ETL pipeline for a healthcare company.
Enhancing data security and meeting regulatory requirements for a financial services firm .
Education
Karachi Institute of Economics and Technology (PAF- KIET), Karachi
MCS — Master of Computer Science
2017
Major: OOP, OOAD, Design Pattern, RDMS and Data Structure
Other Skills & Tools
Data Visualization/Engineering: Highcharts, Matplotlib, Plotly, Seaborn, GGplot , Apache Spark, Apache Kafka,
Apache Hive, Elasticsearch, Python (Keras, Scikit-learn), Hadoop, Python.
Techniques: Tes.t Driven Development (TDD), Data-Driven Testing, Regression Testing, Automated Testing and
Security Testing, Star Schema, Snowflake, Time Series .
Tools and Frameworks: VSCode, SQLyog, DB Weaver, StarUML. Ms.Office, Advance Excel.
Databases: PostgreSQL, MySQL, MSSQL, MongoDB, InfluxDB, Cassandra
Certifications
SCD
Udemy
Coursera
Coursera
Coursera
Coursera
Udemy
Coursera
Coursera
Coursera
Coursera
Soft Skills
Certificate in Information Technology
ETL Framework for Data Warehouse Environments
Google Cloud Platform Big Data and Machine Learning Fundamentals
Building Resilient Streaming Analytics Systems on GCP
Building Batch Data Pipelines on GCP
Modernizing Data Lakes and Data Warehouses with GCP
Learning Python for Data Analysis and Visualization
Introduction to Database
Structures and Management with MySQL
Version Control
Advanced MySQL Topics
-
