I love helping people use technology to solve problems. A huge fan of puzzles, I enjoy cleaning up things like messy data and finding patterns that lead to 'Aha!' moments. My work to understand user needs, analyze business processes, and deploy solutions in iterative fashion is heavily based on the Kimball approach to data warehousing and business intelligence -- find out what the users want, then pragmatically reverse-engineer with grace. Seeking an opportunity to learn and grow alongside kind and balanced folks.
Performed custom data integration and report development for boutique financial data shop. Provided technical support to end users of enterprise web applications (ASP.NET Web Forms application running on IIS); Received and processed new software feature requests; Used C#, HTML, and CSS to build custom data reports for output to HTML, PDF, TXT, and XLS formats; Automated data report creation and delivery for internal and external customers.
Took leave from traditional work schedule to sharpen technical skills related to digital illustration, information design, and CMS workflows.
Contract position; Work on team responsible for developing and maintaining several key enterprise-level supply-chain software applications. Liaise with technical and non-technical staff to document business requirements, identify and analyze risk potential, and design test plans to validate user stories. Daily tools include Visual Studio Team Services, agile project management, and whiteboard markers.
Temporary position; Worked as part of City of Austin's multi-disciplinary Open Data Initiative team. Wrote scripts to harvest data from the City's open data portal to assess and improve data products; Developed and implemented new documentation practices for open data-related projects to increase transparency and staff participation; Designed, built, and maintained the City's open data manual; Led project to deliver UML use case specification for sending open data suggestions to the City; Write SQL statements to study enterprise data systems; Developed and delivered numerous slide deck presentations to diverse audiences; Provided training on tools such as Tableau, Excel, Google Sheets, Airtable, GitHub, and Socrata; Improved how data is moved (ETL) between various enterprise systems.
Advised Director of Health on data-related products and strategy; Evaluated data standards; Designed educational documents to help community organizations adopt and use data standards; Conducted research and issued written recommendations on project management and standards governance; Updated legacy documentation to better suit both technical and non-technical audiences; Performing technical profile-style analysis on data from various systems to assess quality and integration potential; Created screencast videos to demonstrate analysis and explain findings.
Assessed information needs and developed business requirements for health data start-up; Created complex business process diagrams; Designed data report products for hospital customers; Developed and deployed technical ETL processes using Microsoft tools to capture and prepare data for reports; Successful pilot project resulted in long-term contract award with local Kaiser hospital.
Prepared business requirements for complex health data collection systems; Used custom scripting to evaluate ambulance and hospital data from over 200 unique source systems; Planned and facilitated meetings with business users, program representatives, and IT staff; Conducted on-site visits to assess EMS data systems at local agencies across California; Advised state and local agencies on data system change management, including business requirements, software procurement, service level agreements, and success criteria; Responsible for tracking data program participation and issuing standing reports to internal and public stakeholders; Planned and prepared grant-funded project proposals, budget details, and reports leading to increased funding; Negotiated contracts between State of California, public agencies, and private consultants; Delivered California’s first set of nationally-compliant EMS data standards.
At Dell Childrens Medical Center in Austin, TX, gathered data from multiple medical record systems; Tuned and maintained database; Designed and implemented data quality issue tracking system; At Childrens Hospital Los Angeles in Los Angeles, CA, built custom reports for surgeons; Assessed information needs and improved BI delivery; Reduced data entry backlog by 50%. At Ventura County Medical Center in Ventura, CA, prepared database mapping documents and XML file exports; Analyzed large HL-7 and XML documents; Collaborated with business users, agency IT staff, and software vendors to integrate hospital data systems for business intelligence delivery; Wrote how-to manuals for department staff
Retrospective data analysis and literature review for general surgery group
Maintained schedule of surgeries; Sterilized anesthesia and surgical equipment; Transported patients; Prepared surgical suites and instrumentation for multiple surgery specialties; Developed process lists and checklists for nursing staff; Scrub technician for over 100 c-sections and minor general surgery procedures.
Provide user testing and developer feedback for local data integration platform.
Represented local Code for America brigade; Participated in quarterly meetings with members including mayors, county supervisors, and city councilmembers from across the six-county Sacramento region; Received updates from West Sacramento’s Code for America fellows on status of their software development projects; Issued recommendations related to scope, feasibility, local relevance, and scalability.
Developed and delivered hands-on training sessions for improving slide deck presentations using Google Docs; Topics included collaboration, audience-centered design, and productivity tricks; Students were junior high and high school ages. Most of their parents stuck around for the training as well!
Led and/or facilitated weekly meet-ups at local community tech space; Collaborated with local government staff to host a variety of speakers on topics related to open government, transparency, and software tutorials; Attended local government meetings to advocate for open data policies; Delivered presentations to local government officials about benefits of open data; Recruited core team members to delegate marketing and project management responsibilities; Leveraged local resources and partnerships to organize weekend-long hackathons in solidarity with Code for America’s CodeAcross and National Day of Civic Hacking.
Microsoft Excel, PowerPoint, Word, and Access; Google Docs, Sheets, and Slides; Adobe Acrobat Pro; Airtable; Socrata Open Data Portal; Asana
Python; SQL; UNIX command line; Git; Github; XML; HTML5; CSS; Bootstrap; Jekyll; Microsoft PowerBI; Tableau; WordPress; OpenRefine; Adobe Illustrator, InDesign; Sphinx; Jinja2; Microdata formats; Javascript; PostgreSQL (psql)
XPath; XSLT
2003 -- Bachelor of Arts, Chicano Studies
2003 -- Bachelor of Science, Biological Sciences