Analyst
Greater Philadelphia Area
Provided operational, administrative, and technical support to OSC's project management team throughout all phases of the project lifecycle, including managing consultant deployments, assisting in the preparation of monthly financial reports, and providing support to OSC field staff.Project Management-Used Excel, VBA, Python, R, and other tools to automate tasks for technical team. (ex a calculator to automatically calculate consultant deployment days; learned ODK to develop a prototype mobile cell phone data collection system)-Helped oversee operational activities of Afghanisgtan projects-Compiled technical research and analyzed field data to support project activities.-Completed monthly project financial reports and invoices.-Reviewed and maintained project documents including scopes of work, workplans, branding, etc.Field Staff Support-Coordinated calls/meetings with international staff to track project progress-Edited project deliverables-Used data to create maps and other visual aids-Used Photoshop to manipulate photos and improve picture and document qualityBusiness Development-Reviewed and analyzed World Bank and US federal government business forecast documents to identify and research business opportunities-Developed a database to better catalog and analyze business opportunities-Assisted with development and coordination of proposals-Wrote a script in R to scrape GSA contractor prices. Cleaned and used data to conduct best price analysis for GSA price list-Created a script in R to get company contacts from Batchbook and automatically geocode their locations, for use by the business development team when organizing and planning trips to DCMarketing-Helped restructure compant marketing strategy, including the design of new digital and printed materials-Created a monthly company newsletter for external distribution-Managed the company website and helped develop the new prototype-Provided design/layout support for OSC presentations