Farheen Iftikhar

Designed, developed, and maintained web-based MIS dashboards for real-time program monitoring, ensuring accurate data collation, validation, and structured reporting across multiple districts. Developed and optimized MS SQL databases for front-end and back-end systems, improving data accessibility, storage, and workflow efficiency. Handled large-scale datasets through advanced SQL queries, including data collection, cleaning, transformation, and consolidation from multiple provinces for donor reporting and decision-making. Managed and analyzed datasets covering 65,000+ students, teachers, and community stakeholders, ensuring data accuracy, consistency, and compliance with reporting standards. Created automated dashboards using Power BI and Excel for periodic reporting and performance tracking. Developed and implemented data collection tools and surveys using Kobo Toolbox, supporting baseline and endline assessments. Conducted data validation, field verification, and troubleshooting to ensure data reliability and quality. Produced analytical reports with actionable insights to support program improvement and decision-making. Collaborated with M&E teams to enhance data collection frameworks and improve evaluation processes. Delivered training on data systems and tools to improve team capacity and efficiency while consistently meeting tight deadlines and performance targets.

Led the end-to-end design, development, and maintenance of an integrated web-based MIS system enabling real-time program monitoring and improved operational efficiency across multiple districts. Defined requirements, optimized workflows, and managed critical datasets across South Punjab, KPK, and Sindh to ensure accurate, consolidated, and actionable reporting for stakeholders. Designed and developed relational MS SQL databases supporting front-end and back-end workflows, improving data integrity, accessibility, and process automation. Managed large-scale datasets (158,000 students, 2,230 teachers, 5,245 SMC members), ensuring consistency, consolidation, and reliability across operational reporting systems. Developed automated dashboards and reporting frameworks (monthly, quarterly, bi-annual, annual) to support timely decision-making for internal teams and donors. Conducted continuous process improvements by identifying bottlenecks, enhancing workflows, and improving data quality and operational efficiency. Collaborated with cross-functional teams including M&E, field staff, and program units to design tools, refine processes, and support data-driven decision-making. Designed and implemented Kobo Toolbox-based digital data collection systems and assessment frameworks to capture reliable field data. Performed data validation, field verification, and process audits during monitoring visits to ensure data accuracy and reliability. Delivered training sessions on data systems, tools, and workflows to build team capacity and improve operational effectiveness. Maintained comprehensive documentation and reporting protocols to ensure transparency and structured communication across stakeholders. Coordinated closely with M&E teams for data delivery, analysis, and tabulation while conducting field verification visits to authenticate data. Consistently maintained project databases and ensured timely reporting of achieved targets through continuous stakeholder coordination.

Served as MIS Officer for a women-focused poverty alleviation program supporting 608,000 households across interior Sindh. Managed, organized, consolidated, and visualized large-scale program data across 8 districts, ensuring accurate reporting for diverse interventions including social mobilization, income-generating grants, vocational training, and community development initiatives. Handled household-level data for 607,943 beneficiaries, ensuring structured data processing and consistency across datasets. Provided MIS technical support including troubleshooting, data imports/exports, and custom query development for reporting requirements. Collaborated with MEAL teams to design data collection tools and ensure validation and authentication of district-level data. Supported survey design, assessment, and data analysis activities for monitoring and evaluation processes. Delivered technical assistance and training to operational teams, contributing to improved data handling and situational analysis. Provided on-call support for district-level system issues and ensured continuous system functionality. Developed dashboards and visualizations using Power BI and Looker Studio to support program monitoring and decision-making.

Collaborated with clients to gather and define website requirements, translating them into functional and scalable web solutions. Designed and developed responsive front-end interfaces to ensure intuitive user experience and optimal usability. Built website architecture focusing on performance, scalability, and maintainability. Developed and managed back-end systems including database integration and server-side functionality. Created custom WordPress themes and plugins to extend website features and functionality. Conducted performance testing and optimization to improve website speed, stability, and efficiency. Resolved technical and content-related issues to ensure accurate and updated website content. Provided WordPress training to clients to enable independent website management. Monitored, maintained, and optimized live websites to ensure continuous performance, security, and reliability.

Gained hands-on experience in designing, developing, and deploying websites and web applications using XAMPP, PHP, HTML, CSS, JavaScript, jQuery, AJAX, Bootstrap, and WordPress. Conducted user interviews to gather requirements and feedback for improving website usability and functionality. Collaborated with team members to design and implement responsive website layouts and features. Created website mockups and interactive prototypes to enhance user experience and visual planning. Utilized Figma for UI/UX design and prototyping, contributing to the overall product design and development lifecycle.

Responded to user service requests by troubleshooting issues and providing timely technical solutions. Conducted field-based training sessions and collected data from participants to support program activities. Developed data collection tools to improve efficiency and accuracy of field operations. Designed custom Google Forms for structured survey data collection. Collected, analyzed, and compiled survey data to support reporting, decision-making, and program evaluation.

Received training on Supporting Female Graduates Access into Information Technology.