R Programmer, Strategic Analytics
Summary
• Rapid comprehension of challenging concepts
• Critical thinker that identifies creative solutions to complex problems
• Astute understanding of data management, statistical methods and techniques, and optimization (especially in R)
• Strategic advisory on technical topics
• Ability to relay technical phenomena in accessible language
Education
Cornell University Master of Public Administration, Cornell Institute for Public Affairs August 2012
Cornell University Bachelor of Science, CALS, Communication, Applied Economics & Management (minor) August 2009
Awards & Honors: Pathway to Success Program, Cornell Tradition Fellow ($4,000 per annum), CIPA Fellowship ($48,000), Dean’s List
Relevant Coursework: Differential Equations, Linear Algebra, Statistics, Public Systems Modeling, Resource Economics, Finance, Public Administration, Risk Analysis & Management, Financial Accounting, Calculus (I-III), Intermediate Microeconomics, International Trade Policy
Activities: Editorial Board, Cornell Policy Review, Treasurer/Co-founder, Cornell Triathlon Club, Intern – Staff Writer, Cornell Chronicle, Intramural Soccer
Certifications: Data Science, Johns Hopkins University through Coursera (November 2014- Present)
Languages: R, HTML, CSS, VBA, SQL (T-SQL, Jet SQL), Javascript, Python (some)
Environments: LexisNexis, Lingo, Adobe In-Design and Photoshop, MS Project, Excel (Advanced), Access (Advanced), Word, Visio, Visual Studio Professional, FileMaker Pro, Rational Team Concert (RTC), Drupal, Diamond, Crystal Reports, SharePoint, SharePoint Designer, Oracle BI 11, SQL Server, BPMN 2.0, .asp
Security Clearance: Active, DHS Public Trust, Expires 2018
Experience
Assistant Director, Research & IT (Data Analytics) | August 2015 – Present |
NYC Mayor’s Office of Contract Services | New York, NY |
· Manage team of 5 data analysts and 2 business analyst consultants | |
· Program leader on Citywide Procurement Innovation (CPI), a $50 million project to overall procurement for the City’s 40 mayoral agencies | |
· Developed and RESTful API search for SharePoint portal to aimed at document sharing tool for use across Agency Chief Contracting Officers in order to improve procurement review | |
· Developed and scaled fuzzy matching algorithm (Jaro-Winkler) for billions of rows of data by parallel processing vendor names, addresses, and other contact information to identify emails of vendors in R | |
· Developed visualization of Median Cycle Time (box charts) and tables using LaTex and R for repeatable, time-saving monthly reporting | |
· Evaluated RFP responses for CPI project as part of top 8 team for successful integration and build of a SaaS COTS solution for managing procurement in the City | |
· Prepared and engaged in negotiation of Statement of Work for development of contractual terms, scope, approach and methodology, billing, etc. | |
· Analyzed and proposed sequencing and phasing of CPI project delivering analysis to executive staff, managing directors during negotiating rounds | |
Senior Budget Analyst | July 2014- August 2015 |
NYC Mayor’s Office of Management and Budget | New York, NY |
· Oversee and manage miscellaneous revenues for five City agencies that comprise approximately $500 million in annual budget | |
· Perform policy analysis of New York City Council proposed legislation addressing impact on agency budgets and public costs | |
· Conduct forecasts and baselines of revenue budgets for each Agency | |
· Developed large (7 million records) historic relational database of violation records in MS Access, tailored SQL queries, and conduct regular analysis via R for reporting | |
· Wrote matching script to identify unclaimed receivables among millions of transactions | |
· Planned and deliver on working project that seeks to improve City agency adjudicatory outcomes of issued violations as well as construct a dashboard that displays key adjudication metrics in Oracle BI (City Procurement Review); delivered presentation on findings to executive level staff | |
· Run Crystal Reports in SAP for analysts | |
Associate Consultant | April 2013-July 2014 |
Arc Aspicio, Management Consultancy | Washington DC |
Project – FEMA Risk MAP Customer & Data Services (CDS)
· Part of a five-person Change Management Team assisting in the management, communications, minor development and maintenance of approximately 40 IT system geared toward flood risk mitigation |
|
· Received Drupal and Web Design training, managing content for FEMA’s Risk Analysis websites
· Led outreach and communications for nationwide adoption of Hazus-MH software, an economic methodology for risk and loss assessment of natural disasters |
|
· Developed web tutorial and web pages using a Bootstrap CSS and HTML | |
· Assisted client by leading development of Flood Data Sharing Framework for sharing flood risk data through the FEMA ArcGIS GeoPlatform creating governance, workflow, metadata profile standards, data schema standards, and quality review checkpoint processes | |
· Managed SharePoint workflow, content, and developed pages for several thousand user-secured Risk MAP and Hazus SharePoint Portals
Company – Business Development |
|
· Developed working White Paper titled “How many data lakes should DHS have?” that entails the exploration of managing and developing a ‘Big Data’ enterprise within the Federal Government | |
· Led internal business development team that scoped and analyzed market opportunities for Data Analytics incorporation into business portfolio
· Technical section and proposal lead on several RFP responses including Cybersecurity and Communications (CS&C), DHS Infrastructure Protection (IP) Metrics, Homeland Security Information Network (HSIN) Headquarters · Supervised Junior Associate, managing her projects, delivering performance reviews, and managed relationships between her and client · Promoted from Junior Associate to Associate within six months of hire and nominated by peers for Excellence Award within three months of hire
|
|
Data Analyst and Web Developer |
March 2013- May 2013 |
Legistorm, Congressional Data Company | Washington DC |
· Was part of a team that compiled and structured a database (Stormfeed) of approximately 2 million data elements pertaining to Congressional communications using regular expressions and HTML parsing methods | |
· Developed algorithms that compared logarithmic and normal regressive analysis to be used in visual projection of data compiled in Stormfeed database | |
· Established the user interface for the Stormfeed component, helping to create and aesthetically define the search box, and pre-display data | |
Lecturer | October 2012- December 2013 |
Department of Mathematics, California University of Management and Sciences | Falls Church, VA |
· Taught College Algebra (ST131); Business Statistics (BM211); Mathematics for Business and Economics (BM281); Public Administration (SBT142); Statistics I (ST151) | |
· Work with students from various academic and ethnic backgrounds | |
· Teach Excel and R, specifically linear optimization and basic statistical analysis
|
|
Intern, Risk Analysis and Economics | August 2011- August 2012 |
US Environmental Protection Agency (EPA) | Ithaca, NY |
· Conducted full benefit-cost analysis on vapor intrusion in residential homes thus providing analytical support for the Office’s proposed vapor intrusion regulatory proposals | |
· Examined several policy implications on the DuPont-Pompton Lakes Brownfield site using analysis of both VOCs and greenhouse gases, identified significant variables and prepared draft reports | |
· Evaluated sensitivity and uncertainty of each policy via creation of tornado plots, and Monte Carlo analysis | |
· Created mathematical and economic models that included energy components based on evaluations of energy market data, RIMS I-O data, and Energy Information Administration (EIA) data (consumption, production, and pricing)
|
|
Visiting Lecturer | June 2012 – August 2012 |
Department of Mathematics, Cornell University | Ithaca, NY |
· Taught two introductory calculus courses comprised of 20 students | |
· Hired and managed a course assistant, graded papers, and assigned grades to students | |
· Designed course-work, course criteria, and developed learning strategies to be taught alongside course
|
|
Assistant Director | August 2011 – June 2012 |
Statistics Laboratory, Cornell University | Ithaca, NY |
· Hired and managed 5 student tutors, updated statistical software (Stata, R, SPSS, Minitab, Data Desk) oversaw statistical laboratory, and created system to track NYS Priority Students who use the lab | |
· Provided tutoring support for 7 calculus-based statistics courses taught across campus | |
· Performed project management tasks included planning, organizing, reporting, tracking, and scheduling | |
· Developed database and wrote code using FileMaker Pro that evaluates student performance | |
· Conducted statistical analysis that tracks student improvement over a student’s time at Cornell
|
|
Intern, Risk Analysis and Economics | August 2011- August 2012 |
US Environmental Protection Agency (EPA) | Arlington, VA |
· Researched life cycle methodology connecting it to Office of Management & Budget standards for Federal benefit-cost economic analyses including Carbon Capture and Storage LCA’s | |
· Prepared and presented graphical, economic, and draft written reports on life cycle research and analysis as outlined by management and senior economists | |
· Conducted a life cycle analysis on fly-ash brick that offered support to senior staff economists and with other divisions for a coal combustion ruling in 2011-2012 | |
· Performed statistical and economic analysis on coal combustion externalities including greenhouse gas emissions that entailed a model of lives-saved as a result of the proposed regulation |
Skills
- R (5 years)
- HTML (4 years)
- CSS (3 years)
- SQL (3 years)
- VBA (3 years)
- Javascript (6 months)
- Python (6 months)
- Oracle BI (1 year)
- SPSS, Stata, Minitab (1 year)
Specialties
- Analytics, consulting, Critical Thinking, Data, data analysis, Data Sciences, Economics, Fuzzy Matching, Optimization, Presentation, R, SaaS, Statistical Methods, statistics, Team Management
Spoken Languages
- English