Daniel Castro Email & Phone Number

Los Angeles, Ca, Us

Designed and developed high level executive reports and analytics using SQL in Snowflake and Tableau.Implemented visualizations and dashboards to help our Retail and Consumer Insights stakeholders make informed decisions.Optimized existing processes by leveraging automation for Merchandising and Planning reporting.Generated custom ad-hoc reports to summarize business, financial, and membership data.

Seattle, Washington, United States

Facilitated sprint planning, daily scrums, sprint backlog, sprint reviews and sprint retrospectives.Lead a team of analysts and engineers along side product managers to make decisions on pipeline maintenance and software releases.

Seattle, Washington

Supported and analyzed a large tech company's mapping data quality. Contributed to OpenStreetMap (OSM) data, an open source tool, that is community built for mapping information and road networks.Created and maintained dashboard to communicate with the program manager and client to make business decisions on enhancing OSM data. Developed and maintained Python wrapper with other team members for our MapRoulette API to fetch, upload, and update map quality projects to manage data using PostgreSQL and Superset for dashboard visualizations.Reported bi-weekly analysis of processes and statistics of output produced from a series of checks. Developed Python tools to automate calculations and statistics reports used in analysis to ensure developers scripts are not producing false positives.Other Python tools included classification of output data to include in reports and generating random samples to analyze with larger sets of data. The tools also helped improve and reduce workflow time and enhanced accuracy.

Seattle, Wa

IT intern that supported the Timberlands GIS Services team. Learned the business and IT structure of the company by assisting the customer needs.Loaded raster imagery of post harvest land parcels through scripts and models using Python in ArcMap. Maintained metadata for the imagery database using SQL statements in MS SQL Server.Digitized and edited shapefiles for oil & gas land ownership and communication tower leases by locating them using lease documentation with township and section references. Developed a congressional and legislative district viewer web map in support of the Corporate Affairs client. Web map was designed for an intuitive and interactive way to view data.

Tacoma, Wa

Collected and analyzed population data to conduct research on legislative redistricting policies and gerrymandering practices to determine how and where to redistrict boundaries using ArcGIS.Worked alongside the director to forecast future population of the country and state of Washington to predict which states will gain or lose a congressional district. Performed miscellaneous tasks that included assisting in community outreaches, keeping track of book sales, and engaging with community members.

Certificate, Python Programming

Tableau Fundamentals

Bachelor Of Arts - Ba, Geographic Information Systems

Skilled in GIS, web-based geospatial applications, and database management systems for problem solving in relation to a diverse range.

Associate Of Arts - Aa, Business Teacher Education

Activities and Societies: Director of Marketing for Accounting, Finance and Management Club