R Programmer, Strategic Analytics

Resume posted by BrandonChiazza in Government.
Desired salary: $150,000.00
Desired position type: Freelance
Location: New York United States

Contact BrandonChiazza

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