• Improved legacy Power BI reports by introducing parameters, functions, row-level security (RLS), and dynamic reporting capabilities.• Developed SQL stored procedures to generate client billing reports, create data marts, and build Electronic Data Interchange (EDI) source tables.• Implemented exceptions reports as a proactive approach to data cleanup.• Designed schemas for importing data from source systems to SQL Server database and developed methodologies to fulfill cross-functional requirements.• Created procedure to standardize unclassified data in compliance with federal guidelines for third-party reporting.• Collaborated with cross-functional teams and vendors to gather requirements for reports; facilitated monthly meetings to prioritize and recommend data cleanup efforts, enhance report accuracy, and data governance. • Conducted gap analysis between requirements and data sources to ensure alignment and accuracy.• Developed process workflows, project documentation, and data dictionaries.• Resolved Python errors and provided troubleshooting support.• Enhanced DAX and data modeling techniques in legacy Power BI desktop and paginated reports.

• Developed SQL Server stored procedures to import, transform, and update tables• Developed trending dashboards in Power BI including rolling trends, pareto charts, and performance score cards.• Designed reporting data marts from multiple large, complex tables.• Developed and launched 14 canvas Power Apps connected to shared SharePoint lists.• Created procedures in SQL Server and Power BI reports to monitor data discrepancies in source data to enhance front-end applications.• Collaborated with the development team to migrate legacy systems to modern platforms (Power Apps, SQL Server, ESRI Products, SharePoint, SAS).• Implemented error logs for stored procedures and linked to Power BI Dashboards for performance monitoring, stored procedure failures, and data discrepancies.• Trained analysts to maintain and create Power BI dashboards.

• Migrated longstanding reports from Crystal Reports to Power BI online and implemented organizational Power BI online dashboards.• Created prototypes to migrate vendor reports to Power BI in PDF format, which reduced processing time by 70%.• Streamlined Access database, resulting in reduced login times, system crashes, and data entry time.• Collaborated with stakeholders to develop technical solutions based on business requirements.• Coordinated the transition of backend databases from Microsoft Access to SQL Server.• Worked with cross-functional groups to develop data marts in SAS Enterprise Guide.• Automated repetitive tasks using SAS Enterprise Guide procedures and SQL queries, reducing processing time by over 40%.• Authored queries to determine scope of work according to wildfire risk for field crews using in Survey123.• Ran ad hoc reports & data extracts – Excel, Power BI, and SAS – pivot tables, v-lookups, conditional statements, etc.

• Developed databases and operational dashboards in Power BI for Senior Management to view throughput, quality control, and key performance indicators.• Automated reporting, reducing reporting time by over 50% by migrating reporting to Power BI.• Developed quality control metrics and methods for tracking mapping errors.• Facilitated meetings to gather requirements from clients to develop and design dynamic dashboards.• Collected requirements from users and management to determine best data models, client needs, andreporting methods for short and long-term projects.• Developed databases with 10 - 60 concurrent users, while providing technical training and documentation to users• Created custom multi-user interfaces using VBA and SQL in Access and SharePoint.• Utilized SQL to generate weekly, monthly, and bimonthly reports to assist management in making business decisions.• Create SQL scripts to conduct quality control on data and reports to search for inconsistencies in data entries.• Ran ad hoc reports.

Research & Development:• Produce project requirements and data specification documents• Conduct product research and data testing• Create user stories for design and development teams• Present research and progress updates to investors and teamsConsulting: • Create custom interactive maps using proprietary data for client's research and marketing team • Engage with clients and teams on a weekly basis to discuss project status and progress• Prepare high-level PowerPoint decks for proposals, interoffice and client presentations• Create content inventories, site maps, and HTML documentation in preparation for content migration• Edit client data for mobile integration and forward-compatibility • Manage and train the intern team in product and project development

Projects: California Basin Plan, Tijuana Historical Ecology Project, CalTrans• Maintained documentation pertaining to projects and methodologies• Provided solutions to project methodologies • Trained interns on complex project methods• Used Spatial Analyst, HEM and Utility Network Analyst tools to create and edit NHD data• Managed, reconciled, and analyzed geospatial data• Performed attribute and spatial queries• Performed quality control on long-term projects• Georeferenced historic maps and geocoded addresses• Data mining of vector and raster data

Experience in Class Action Litigation and Worker's Compensation• Prepared court binders and maintained team calendar• Maintained discovery and other documentation• Prepared state and federal court filing documents• Drafted correspondence