As an accomplished Geospatial Analyst, Data Analyst, and Database Administrator with over 7 years of experience specializing in GIS systems, spatial data analysis, and database management. My expertise spans the use of tools such as ArcGIS, QGIS, MS SQL Server, MySQL, and PostgreSQL/PostGIS to manage large datasets, optimize database performance, and provide actionable insights that drive informed decision-making.
In my career, I have successfully led key projects, including the Zindagi Mehfooz Immunization Program, where I developed a GIS-based system to monitor immunization efforts, and OFC Network Planning for CMPAK and DHA, where I designed GIS maps and oversaw spatial database management for infrastructure development. Additionally, I contributed to the Kiran Sitara Public Health Program, where I conducted comprehensive data analysis to support community outreach initiatives.
My core competencies include database optimization, SQL query development, and ETL processes, along with the creation of interactive dashboards using Power BI and Python. I hold certifications in GIS Specialization from the University of California, SQL Server 2016, and Full Stack Web Development with Python, Django, and Machine Learning, which complement my hands-on experience.
I am passionate about leveraging data and technology to address complex challenges and deliver innovative, high-impact solutions. With a demonstrated ability to align technical expertise with organizational goals, I am committed to creating scalable, data-driven strategies that foster growth and efficiency.
Projects & Job Description
Sindh – Electronic Immunization Registry (S-EIR) or Zindagi Mehfooz (ZM)
The ZM Program is an immunization registry which collects and tracks Maternal and Child immunization data as well as an electronic decision support system to guide vaccinators for routine and catch-up immunizations.
Database
1. Manage MySQL and SQL Server databases with 20 million records.
2. Improve query performance by 30% through optimization techniques.
3. Reduced downtime by 40% and response time by 25% via performance tuning.
4. Designed user-centric database systems for up to 50 concurrent users.
5. Enhanced data security and access efficiency with user access management systems.
6. Reduced error rates by 15% through effective troubleshooting.
7. Established high-availability solutions, minimizing potential downtime by 50%.
8. Achieved 99.9% uptime rate by ensuring database security and availability.
9. Conduct regular database maintenance.
10. Streamline user management for over 50 team members.
11. Ensured recovery within 30 minutes via efficient backup processes.
12. Facilitated smooth transitions in data migration projects.
13. Enhanced data sharing capabilities by 30% through centralizing spatial and non-spatial data.
14. Integrated databases with GIS software.
15. Implemented a new data visualization tool for better data accessibility.
16. Utilized data analysis tools like STATA and Python for statistical analysis.
WebGIS
1. Developed a WebGIS platform using Asp.Net and MySQL, serving 50+ stakeholders for spatial data access and analysis.
2. Integrated backend functionalities across databases, GIS servers, and desktop software, improving data processing efficiency by 40%.
3. Enabled real-time spatial analysis, reducing processing time by 30% and enhancing decision-making capabilities.
4. Implemented detailed reporting features, improving data visualization for 50+ users.
GIS
1. Coverage Maps
• Developed a VB script tool to automate raw data processing, ensuring 95% accuracy and accelerating workflow efficiency.
• Established a Relational Database Management System (RDMS) for executing SQL scripts, enhancing data processing capabilities and query efficiency by 30%.
• Generated thematic maps for zero dose and defaulter children in Sindh, providing detailed coverage analysis by UC, district, and division, benefiting public health planning initiatives.
• Conducted gender ratio analysis of routine immunization coverage, visualized through category maps, improving targeted health interventions.
• Identified and mapped missed children during lockdowns for routine immunization by UC, district, and 10,000 population grid, enabling focused outreach efforts and increasing vaccination rates.
• Spatial analysis based on the distance between EPI fixed sites and IOA/RO.
• These spider-web maps are generated district-wise.
• Heat maps of the pre and post-effects of COVID-19 on routine immunization coverage are generated.
Mobile Immunization Van
• Weekly mobile van activities mapped along with EPI fixed sites.
• Buffer analysis to find out the number of unique locations within a 100m buffer.
Logistic regression analysis
• Performed logistic regression analysis using ArcGIS and R language.
Kiran Sitara for Immunization (Public Health Program)
Kiran Sitaras for Immunization Program galvanizes the potential of schoolgirls through health and leadership courses. Through the knowledge of leadership and immunization, adolescent girls conduct community outreach & mobilization to identify under two children in unreached geographical pockets for immunization, link them to the EPI services and create awareness.
1. Created research plans, tools and drafted permission letters to government officials.
2. Creation of study materials, data dictionaries, and codebooks.
3. Trained government school teachers and students on Health and Leadership curriculum.
4. Supervised survey teams, processed data effectively and produced insightful analysis.
5. Prepared project reports for the stakeholders.
6. Contributed to the manuscripts and abstracts writing.
Projects & Job Description
OFC Network Planning and development for CMPAK & DHA (DKTCC)
1. Planned and developed OFC networks.
2. Created basemaps with 0.5m satellite imagery.
3. Conducted customer tagging on GIS.
4. Performed database integration, design, and quality control.
GCS OFC Network
1. Planned and developed OFC networks.
2. Created basemaps with 0.5m satellite imagery.
3. Conducted customer tagging on GIS.
4. Managed database integration, design, and quality control.
5. Directed team management and workflow design.
Projects & Job Description
Basemap Development and Consumer Tagging for K-Electric of Bin Qasim Area
1. Developed basemap with 0.3m satellite imagery.
2. Conducted consumer data quality checks and tagging on GIS.
3. Development of billing cycle day boundaries.
4. Designed plotter size maps for surveys.
GIS Survey and data development of Commercial activities for DMC Central Karachi
1. Conducted land use surveys and data collection.
2. Developed basemap through KDA Sheets.
3. Tagged and conducted quality control for commercial data.
4. Designed digital maps for surveys.
5. Collected and analyzed data on commercial activities for DMC Central.