Roger Andre Email & Phone Number

Bellevue, Wa, Us

Boston, Massachusetts, Us

Help create free and open-source software for data science, scientific research, and technical communication.

Bellevue, Wa, Us

Work to discover insights about retail store performance based on geographic location, demographics and other factors. Create dashboards, reports and other analytic products in R, Power BI, Python and other tools. Ensure data integrity across multiple systems that share data and work to identify and create efficiencies and optimizations in data transfers and ETL processes. Assist others in the creation of scripts and tools to automate reporting. Act as a mentor and subject matter expert on spatial data analysis using R and SQL. Support the Retail Development organization and champion its mission in cross-departmental projects and meetings.

Bellevue, Wa, Us

Support the day-to-day operation of the Decision Analytics data science team within Retail Development at T-Mobile by doing the following: * Provide code-based spatial analysis using R and Python * Conduct data integrity checks of cross-system data feeds * Create and maintain ETL tools used within the team * Source geospatial data from the US Census and other proprietary locations * Assist in data wrangling and day-to-day ad-hoc mapping requests * Assist in the maintenance of Teradata and SQL Server relational databasesAlso act as the Subject Matter Expert on GIS and spatial analysis in support of team projects and represent Decision Analytics in this capacity in cross-departmental projects within the larger Retail Development organization.Notable achievements: * Led the effort to validate and error check addresses and geographic locations of over 22,000 T-Mobile, Metro by T-Mobile and Sprint locations * Developed multi-threaded R code to assist in geocoding point locations and calculating drivetimes at scale * Spearheaded the effort to update internal processes related to routing and drivetime calculations * Assisted the team's Principal Data Scientist in mentoring the team on Version Control and other software development practices * Provided mentoring on GIS concepts to other members of the team

Seattle, Washington, Us

Create and maintain R packages used to analyze environmental data associated with wildfire smoke. Focused primarily on working with GOES 16 & 17 Aerosol Optical Depth raster data and S4 Spatial objects.

Support the FINclusion Lab product platform by providing a range of services related to the maintenance and creation of Tableau workbooks and dashboards.

Seattle, Wa, Us

Senior Data Engineer on global basemap project* Performed all initial sourcing and data prep of map data* Created all initial MapServer map styles for v1 maps* Acted as Backlog Steward (Product Owner) for 1st 6 months of project* Assisted in the integration of 3 new team members while continuing styling and data prep work* Assisted in the day-to-day leadership of team, to include making work assignments, scrubbing backlog and leading sprints when assigned team lead is out of the officePrimary maintainer of proprietary Geocoding database used in Tableau products from 2011 - 2014* Responsible for all aspects of maintenance related to GEOCODING.FDB* Created PostgreSQL backing store to house source data* Created ETL tools in Python to extract data from backing store and create final product* Created data consistency tests in Python to ensure high data quality in shipped product* Review all data created by other Data Engineers prior to checkin and loadSource and prepare GIS data to be included in Tableau products. * Identify commercial and public domain GIS data sources for Tableau's needs* Automate the download and post-processing of the data* Develop internal systems to manage and process GIS data for; GIS format conversion, data cleaning, map data generalization, and database design and management.

Seattle, Wa, Us

* Conduct ad hoc analyses of vehicle telematics data to develop new report types that would help customers understand their fleet operations.* Conduct market research and competitive analysis to identify opportunities for growth in product offerings. * Assist Sales in explaining technical capability of existing products to prospective clients and in determining whether existing features can meet client's business needs.* Develop prototypes that demonstrate new spatial functionality in Web maps and reports.

* Created maps and visualizations of Green Energy data for Sales and Marketing groups* Setup internal Web maps to display results of ongoing Solar and Hydro research* Performed spatial analysis of GIS data with ArcGIS and PostGIS* Developed map-tile generation system to drive public FirstLook application* Wrote Python scripts to process and analyze GIS data using the GDAL/OGR library* Created automated map-image generation system using Python MapScript, PostGIS and GDAL* Created Google Earth KML/KMZ files for conferences, presentations, and internal QC* Investigated capabilities of OGC services to improve GIS data storage and display and developed prototypes to test implementation feasibility* Created and administered PostGIS databases to store 3TIER map data

Englewood, Colorado, Us

Worked in the Enterprise Management Solutions group to implement custom systems for a variety of customers. Specialized in the development of web-based mapping applications which utilized PostGIS, GeoServer, Mapserver, OpenLayers, and Linux.* Helped create Google Earth Enterprise deployment team* Led Python scripting brown-bag sessions to help bootstrap Geoprocessing skills in GIS Analysts* Wrote tools in Python ArcGIS Geoprocessing environment to automate conversion of Microstation DGN (CAD) data into ArcGIS Geodatabase layers.

Mountain View, Ca, Us

* Created and loaded new vector layers displayed in Google Earth.* Evaluated new geospatial data to determine its fitness for inclusion in Google Earth.* Worked with business partners to help style and develop new KML layers.* Setup and monitored automated vector layer updates.* Create scripts and programs to assist in data processing and analysis.* Processed and loaded satellite and aerial photo data used in Google Earth & Maps.* Performed color corrections such as histogram equalization and white/blackpoint adjustments.* Georeferenced raw aerial data sets.* Created programs and scripts to facilitate image data analysis, loading and calculation of coverage areas.* Assisted business and government customers in creating large orthophoto KML superoverlays.* Setup and maintained automated download services for new data sources.* Provided technical support and advice to Google Business Account managers when working with vendors.* Teamed with Google Engineering staff to develop ways of incorporating new data types (such as weather) into Google Earth.

Processed satellite and aerial orthophoto data to be loaded into the GlobeXplorer online image database. Also supported the Marketing and Sales groups by creating maps and doing spatial analysis of database contents.

Emeryville, California, Us

Worked in a variety of roles - Technical Support Specialist, Product Engineer, Systems Librarian.Responsible for:* Database administration, installation and troubleshooting of UNIX/Linux-based systems* Investigation and prototyping of integration of 3rd party web-based search interfaces with proprietary database system* Maintenance and support of commercial reference database implementations inside proprietary system

Arlington, Virginia, Us

Active duty military police officer with rank of Sergeant, E5, at time of separation. Worked in law enforcement and combat support for 8th Army and 4th Infantry Division. Was stationed and deployed in the Continental United States as well as overseas. Honorably discharged with awards and commendations.

Professional Certificate In Business Intelligence And Data Analytics, Data Analytics

Bachelor Of Science, Natural Resource Management

Professional Certificate, Gis And Remote Sensing