Experience

• 

  PureLogics

  • Lahore, Punjab, Pakistan

  • Senior Software Engineer

    • Jan 2023 - Present
    • Lahore, Punjab, Pakistan

    • Insights of Snowflakes, Salesforce, Google Analytics 4.• Conduct in-depth data analysis using Python libraries such as NumPy, pandas, matplotlib, and scikit-learn.• Design and develop interactive reports, dashboards, and visualizations in Power BI.• Extract, transform, and load (ETL) data from various sources into Power BI.• Write complex SQL queries for data retrieval and manipulation.• Collaborate with business analysts and stakeholders to define requirements and ensure deliverables meet expectations.• Troubleshoot and resolve issues with Power BI reports and dashboards.• Optimize Power BI performance for scalability and maintainability.• Develop and maintain comprehensive documentation for Power BI solutions.• Implement security measures to protect sensitive data and ensure compliance with data protection regulations.• Develop complex DAX measures and calculated columns in Power BI to derive insights.• Refine data models to support efficient report generation and analysis.• Configure automated data refresh schedules in Power BI to ensure timely updates.• Fine-tune queries and model designs to enhance performance and responsiveness.• Design and develop applications using Power Apps to streamline business processes.• Automate workflows using Power Automate to improve efficiency and reduce manual tasks.• Integrate Power BI with Power Apps and Power Automate to create comprehensive business solutions.• Utilized AWS, Azure, and GCP services in conjunction with Power BI for enhanced data integration and analysis.

• 

  Professional Employers Private Limited.

  • Peshawar, Khyber Pakhtunkhwa, Pakistan

  • ERU Town Data Usage and Risk Assessment Officer

    • Apr 2021 - Jan 2023
    • Peshawar, Khyber Pakhtunkhwa, Pakistan

    • Identified and gathered data from various sources, including databases and online platforms.• Cleaned and organized data to ensure accuracy and completeness.• Analyzed data using statistical techniques and visualization tools such as Google Data Studio, Tableau, and Power BI.• Reviewed data for inconsistencies and anomalies before generating analytical outputs.• Presented findings to stakeholders through reports and presentations.• Acted as the focal point for data requests from partners, government, and other stakeholders.• Collaborated with cross-functional teams to identify areas for improvement and develop data-driven solutions.• Used statistical models and machine learning algorithms to predict future trends and outcomes.• Maintained and updated databases and data systems.• Stayed up-to-date with industry trends and emerging technologies related to data analysis.

• 

  CHIP Training and Consulting (Pvt.) Ltd.

  • NWFP Peshawar, Pakistan

  • Data Support Officer

    • Dec 2017 - Apr 2021
    • NWFP Peshawar, Pakistan

    • Support the timely and high-quality collection, analyses, production, and dissemination ofdata/information. This includes response specific information (what, where, who, how many, how quickly, status), internal and external situation reports (SitReps), epidemic bulletins, rapidneeds assessments, health risk assessments, and the Public Health Situation Analysis, and health inputs into humanitarian needs overviews (HNO), and strategic response plans (SRP). • Contribute information to the drafting of all relevant planning documents including project proposals, appeals, reports, dashboards, etc. • Contribute information to the drafting of all relevant HQ documents such as briefing notes, update notes, regular reports, annual reports, M&E documents, among others• Troubleshooting of office Equipment’s during failures.• Calculating Risk Assessment by different Modeling approaches such as on Performance of Anti-Polio Campaign, Environmental Sampling result with the help of waterfall graph.• Creating Required form for data collection in KOBO, Google Forms, Whatsapp messages, Text, Clappia.• Compiling of data in excel and Oracle MIS along with Online Integrated Disease MIS.• Cleaning of collected data using different methodologies.• Analysis on data using different Tools• Visualization of data using QGIS, PowerBI, Tableau, Powerpoint, Google Data Studio.• Joining of different tables/Datasets using bi-variate modeling, Slicer, Pivot Tables, SQL Joining methods. Preparing Reports in MS Powerpoint, MS Word, Dashboards in Tableau, PowerBi, Google Data Studio in interaction with GIS maps etc). • Perform any other related duties, as required by the functional supervisor

• 

  World Health Organization

  • Data Assistant

    • Sep 2015 - Nov 2017

    • Worked in WHO in Polio Eradication Initiative Program in High Risk district Peshawar. In Polio Campaign Cell: • Maintaining Attendance Records of field staff using Third party App "Clappia". • Troubleshooting of office Equipments during failures. • Creating Required form for data collection in KOBO, Google Forms, Whatsapp messages, Text, Clappia. • Compiling of data in excel and Oracle MIS along with Online Integrated Disease MIS. • Cleaning of collected data using different methodologies. • Analysis on data using different Tools • Visualization of data using QGIS, PowerBI, Tableau, Powerpoint, Google Data Studio. in AFP/Polio Cases Surveillance Cell: • Updating/ Maintaining WHO MIS with all AFP/Polio Cases Investigation form. • Tracking of each AFP/Cases to check the Completeness/ Compliance / Timeliness. • Joining of different tables/Datasets using bi-variate modeling, Slicer, Pivot Tables, SQL Joining methods.

• 

  SoftDepth Solutions

  • Peshawar

  • Online Application Developer

    • Mar 2014 - Aug 2015
    • Peshawar

    Developing web application in PHP tool. Building Database in SQL Language using MySQL for web application. Making website Format in HTML5 and in CSS. Creating Runtime effects for web application in Java Script and in JQuery. Make separate Admin panel for every web application, which control whole user end.