Ethan Rutledge Email & Phone Number

Develop Data Pipelines integrating data from multiple sources (SAP, Excel, SharePoint, Dataverse, SQL Server), merging and conducting ETL/ELT processing as necessary, and loading into a data lakes for easy consumption and analysis by business users and BI Team. Primary data engineer implementing data model for tracking and analyzing the Department of the Interior's Bipartisan Infrastructure Law fundsCreate business applications, primarily using Microsoft Power Platform's. This includes Model Driven apps hosted on Dataverse replicating complex business procedures and Canvas Apps tied to Sharepoint and SQL server databases.Develop sematic models Power BI and create visualizations that inform data-driven business decisions. Provide key decision makers with KPIs, benchmarks and business improvements based on real time data.Generate automated reports, dashboards, primarily using Microsoft's Power Platform, python pandas, and SQL.Developed Git repositories using advanced features such as rebasing and filtering for version control of work products

Greater Denver Area

Program Analyst for the WaterSMART Grants program, focusing on the WEEG, Drought Response Program and Water Marketing Grants.

The Presidential Management Fellows (PMF) is a highly selective leadership development program that recruits outstanding recent advanced degree candidates (masters, doctorate, professional). It was created more than three decades ago by Executive Order and candidates must complete a rigorous assessment process in order to be chosen as a Finalist. The program attracts and selects the best candidates possible, and aims to develop a cadre of future government leaders. For 2015, the U.S. Office of Personnel Management selected 600 finalists from a pool of 7,800 applicants representing more than 300 colleges and universities.

Région De Lexington, Kentucky, États-Unis

Used Excel to create a complex pricing template that accounted for the many difference variables (species, airline, destination) to facilitate the quote preparation process. Assured all appropriate documents were prepared for the import and export of live animals to various countries.  Helped customers navigate the international live animal transportation including understanding a translating national regulations.Logistical manager of hundred of international pet moves, including facilitating transnational agent communication and understanding.

Région De Washington D.C. Metro, États-Unis

Researched and summarized international trade policy and literature. Extracted and summarized trade data and presented reports using a variety of software to make clear and legible graphs and charts.  Maintain Congressional Free Trade Database Worked on Search Engine Optimization and Google Adwords Strategy for Human Progress.Org  Published Letters to the Editor in the Washington Post and the Lexington Herald-Leader.

Fort Worth, Tx

Learned various research methods and data skills necessary for professors of political science.  Gained considerable experience with the statistical analysis software STATA 12.  Produced a 30 page faculty-mentored research paper that was presented at the International Studies Association (ISA) convention in San Francisco next April. The paper uses quantitative methods to examine the relationship between international economic integration and state sovereignty

Frankfort, Ky

Performed Candidate Research that was published in various media outlets for the ultimately successful 2011 Kentucky Gubernatorial Election.  Created and maintained a database of all the news media outlets in the state  Researched opposing candidates (David Williams & Richie Farmer). Met with reporters at the capital and wrote press releases for the general public with information regarding the upcoming elections.  Help organized Democratic Party meetings around the state to prepare for the elections. Called supporters to ask for campaign donations. Gained basic research skills, public writing skills, and organizational experience

Master Of Arts (M.A.), International Commerce

Bachelor'S Degree, Political Science/Economics/French, 3.96