Information management services

• Sr software developer responsible for internal and external facing web applications.• Data model business objects.• Design business process models.• Lead development efforts.• Develop and manage application testing.• Solicit and manage user feedback to optimize development iterations for greatest impact.• Partner across domains leveraging technical resources to solve intractable problems.

• Web application development using C#, MS MVC, SQL Server and Entity Framework.• Created web application to manage employee hiring requests.• Refactored web application to track and report partner expenses to partners.• Data integration and ETL using SSIS, Perl and Powershell.• Managed developer resource.• Mentored Analysts in SQL Server.

• Created Sharepoint Online site collections using manual and scripting techniques.• Created configuration files for Sharepoint content and configuration extraction and provisioning.• Performed Sharepoint user administration in Azure Active Directory (AAD).• Demonstrated, documented and reported technical issues.

Data Steward responsible for enterprise customer data quality.• Led meetings across domains identifying internal data requirements and resolving conflicts.• Developed and used SQL queries in Toad Data Point to monitor and analyze data quality in Salesforce, Oracle EBS R12, Siebel CRM and UCM.• Created analysis reports in MS Word and Excel describing data quality issues.• Maintained enterprise data dictionary, terms and definitions in Sharepoint.• Performed user testing of Oracle EBS R12 and Siebel UCM.

Research data management for Pacific Northwest Udall Center of Excellence for Parkinson’s Disease Research.• Gathered system requirements including dataflow and system design using MS Word, Excel and Visio.• Managed information system development and testing team.• Developed data capture and reporting database in MS Access using Visual Basic for Applications (VBA)• Generated research data sets using SQL queries and MS Excel.

Data management for research neurologists, psychiatrists and administrative staff investigating Alzheimer's and Parkinson's diseases.• Created datasets from SQL Server, MS Access, Excel and text data sources with SQL queries and VBA.• Created research registry website and questionnaire forms in PHP and MySQL.• Built SQL queries for reports and resolved data quality issues with research subject contact database in MS Access.• Created and managed Sharepoint site in support of lab-wide administrative staff.• Created Infopath data entry forms for SQL Server neuropathology database.• Customized MS Access databases with VBA.

Provided expertise analyzing, administering and customizing PTC’s Product Lifecycle Management (PLM) software.• Created custom workflows using custom Java API.• Wrote and performed automated tests of web applications using Selenium.• Analyzed custom domains, types, attributes and workflows in preparation for PLM software upgrade. Documented analysis in MS Word, Excel and Visio.• Analyzed custom change management system including types and workflows in preparation for software upgrade. Documented analysis in MS Word, Excel and Visio.• Performed functional tests of pre-release software.

Principal for information architecture design for Wildand Fire research information exchange website.• Gathered and documented requirements for Web-based information exchange system between wildland fire scientists and land managers using MS Word, Excel and Visio.• Designed and documented taxonomy and metadata model for wildland fire information resources using XML schemas (XSD), XMLSpy, MS Word, Excel and Visio.• Designed and created MS Access database for cataloguing wildland fire information resources metadata. • Aided in design and administration of a Plumtree web portal.

Data management for archaeological, biological, ecological and geophysical research using tree-ring data.• Created scientific data collection web application using Java Server Pages (JSP).• Developed metadata format describing biological and geophysical data in XSD using XML Spy.• Created database for biological and geophysical data in MS Access.• Developed utilities for statistical analysis of data in Java.• Wrote two grant proposals to fund lab-wide data warehouse.• Generated research datasets in ArcInfo GIS, MS Access and Excel

Data management and analysis support for Research Ecologist.• Modeled vegetation characteristics for western forests using AcrInfo GIS.• Created computer programs to process statistical output using Unix shell scripts, VB and in ArcInfo.• Created reports for publications using MS Word, Excel and VBA.• Created maps for scientific publications in ArcView.