Rehan Khan Email & Phone Number

Washington, District Of Columbia, United States

World Bank Contractor●Led automation project using SQL and Tableau for Quality Assurance team that allowed for 192 hours time-savings from manual efforts.●Automate Tableau reports by querying the data warehouse using Microsoft SQL Server, delivering actionable insights to senior leadership.●Lead the transition of manual reports to automated systems across various business units, utilizing Oracle, Microsoft SQL Server, Python and Tableau for streamlined reporting.●Spearheaded an initiative using Python to automate a marketing program, enabling automatic account list provision to the IT team, saving the business roughly 5 hours weekly.●Conduct comprehensive training sessions for multiple business units on SQL database querying and connecting data warehouses to automated reporting systems.●Collaborate with the lending team to develop and maintain automated mortgage processes using Python scripts, resulting in monthly time savings of approximately 10 hours for the organization.●Develop and sustain tailored data tools aimed at enhancing organization-wide visibility and insights, culminating in comprehensive reports shared with senior leadership and all business units.

●Collaborated with senior leadership to design and automate 30+ PowerBI reports by leveraging SQL, and the Dynamics 365 API, providing critical sales insights.●Orchestrated the integration of Hubspot and Dynamics 365 through a third-party API, ensuring seamless data flow for enhanced analysis.●Trained colleagues to utilize PowerBI reports, fostering a data-driven culture and granting access to automated reports on sales, leads, and marketing data.●Utilized SQL database to automate Excel spreadsheets for leadership, enabling real-time access to sales information, and supporting data-driven decisions.●Spearheaded an automated outreach process for potential Microsoft partners using Python scripts, streamlining engagement and partnership development.●Utilized Python to automate data enrichment for sales lists, equipping sales teams with valuable client information, and enhancing deal-closing prospects.●Generated 30+ reports, utilizing Python, SQL, and PowerBI, to offer deep business insights, empowering sales leadership with the data-driven tools necessary for success.

● Conducted PowerBI training sessions and digital data collection tool workshops in rural Sub-Saharan Africa, equipping field staff with essential data analysis skills to improve data-driven decision-making.● Trained manager in data analysis using PowerBI, enhancing the organization's overall data analysis capabilities.●Spearheaded a two-year overhaul of the organization's data analysis process, replacing manual Excel-based methods with PowerBI, resulting in improved efficiency and data accuracy.●Automated reports and dashboards using API data from the LogAlto application, streamlining data visualization and analysis processes for the organization.●Co-led the implementation of a web-based database at the organization, training team members in its use, data extraction, and integration with PowerBI for comprehensive data reporting.●Developed and maintained over 30 PowerBI dashboards, providing valuable insights and data-driven decision support for the organization's public health initiatives.●Leveraged advanced Python scripting to meticulously clean, manage, and automate the seamless flow of data from the LogAlto API to PowerBI

The Gambia

● Increased food security in 500+ rural villages by leading cash transfer field exercise for food-insecure households.● Organized malnutrition screenings in over 300 communities in the North Bank Region.● Analyzed data on various food security indicators obtained through field-level data collection exercises.● Trained government and NGO partners on proper data collection methods using Open Data Kit.● Developed new reporting tools for Country Office utilizing Pictocharts.● Facilitated disaster verification exercises alongside partners after deadly windstorm.● Drafted situation report that assessed livelihood situation of post-disaster conditions in over 50 villages. ● Supported the development of food security, vulnerability analysis and the preparation of reports on food assessment needs, processes and guidance to enable effective decision-making on country strategic plans, policies and programs.● Coordinated data gathering and monitored data collection systems to ensure that rigorous quality standards were maintained for country-wide exercises.● Consulted with implementing partners (internal and external) to monitor ongoing projects, ensuring effective collaboration, timeliness and efficiency, and highlight potential risks to project delivery.● Developed multiple online screening tools utilized in nation-wide malnutrition screening exercises.● Supervised and monitored numerous food distribution teams from a central field team to ensure high standards were maintained under stressful and atypical conditions.

The Gambia

● Coordinated a community effort to write a $10,200 Let Girls Learn grant for improved access to clean water. ● Facilitated the establishment of a solar-powered borehole system that ensured access to clean water for 1,200 residents. ● Served as director of innovation and grants for Gambia Malaria Task Force Committee, representing Peace Corps The Gambia at an international conference in Senegal and through training 75+ volunteers and counterparts on malaria social and behavioral change communication, grant writing, project development, mapping and mobile data collection.● Established a new women’s garden alongside the Jarra Karantaba Village Development Committee.● Orchestrated numerous gardening capacity-building trainings at local lower basic school for students and teachers.● Educated community members on general health topics including water and sanitation hygiene (WASH), maternal and child health, and nutrition. ● Promoted gender development and girls’ education by teaching all-girls classes at the Soma Scouts Center. ● Lived and adapted to life in a rural West African village and conducted needs-assessment surveys with community members.

Master Of Science - Ms, Development

Data Science, Advanced Machine Learning Track

Bachelor'S Degree, Entomology

Activities and Societies: National Collegiate Scholar, Astrophysics Society