David Pruden Email & Phone Number

Eden Prairie , Mn, Us

• Led a team of 11 on-shore/off-shore data engineers across three pods on re-platforming and overhauling data pipeline to event based microservice architecture data warehouse and data lake using Informatica, Python, Airflow and GC. • Improved scrum practices and aligned product and project goals while training new technologies and collaborating with the Data Science Team’s AI and ML models. Team delivered increased productivity measured by department OKRs and reduced cycle time from over 30 days to under 18 days.• Implemented department’s incident management system by automating and monitoring and defects and escalations and improved JIRA reporting. • Improved team collaboration and code reviews which reduced defects by 66% and hours to resolve by 78% and improved ability to prioritize defects accurately and increased SLA adherence for P1/P2 incidents from 68% to 100%. Championed data platform team’s adoption of CI/CD and improve process orchestration documentation. [Formerly AbleTo acquired by Optum Aug 2023]

St Paul, Mn, Us

• Managed multiple teams of 10 to 22 data and software engineers, project managers and product owners across multiple projects and platforms over four geographic areas to improve and replace legacy enterprise health interface engine with HL7/FHIR transfer and facilitated inter-team dependencies and collaboration as well as team development and cross-training and reduced time and cost of support calls. • Replaced on-premises SQL databases with AWS lift and shift as well as AWS, GLUE and Python for legacy product data pipelines which resulted in improved client SLAs. • Identified pain points for underperforming teams that hindered speed to delivery and data quality issues and improved coding standards and processing time measured by increased velocity and ability to resolve issues with multi-team deployments by utilizing Six Sigma Green Belt best practices. • Maintained HIPAA, HITRUST SOC2, AMP and ATO compliance audits. • Attended area college “meet and greets,” meetups and other external events. Started a 3M Pride Employee Resource Network chapter.

Walnut Creek, California, Us

• Managed development implementation of a Preferred Strategies BI Quick Launch data warehouse SSAS Tabular model with data replicated from JDE ERP system into custom ODS and EDW. • Deployed Power BI and trained organization on self-service reporting and analytics capabilities. • Facilitated the ability to analyze data and information on 14 data perspective giving insight into company and area performance as well as improve supply and demand planning and forecasting. Automation for many manual processes including labor intensive pricing process for forecast data.

San Francisco, Ca, Us

• Led team of 4 BI Engineers to architect an Inmon schema enterprise data warehouse to support MicroStrategy front-end and global data and replace legacy Birst report database which reduced data load from 12 hour to 90 minutes.• Leveraged EDW to create a truth table and stored procedures that would track changing product family use over a rolling 6-month period for all customers to support account history analysis for product family purchase over the life of a customer. Enabled the ability to easily modify product attributes and recalculate product family data over customer life and provide analysis and support Data Science team. Produced a POC for account hierarchy visualization using Neo4j and SSIS and was awarded “True Colors” Employee of the year nomination and “Jam Session” for creative problem solving 2015.

San Francisco, California, Us

• Tuned and refactored all stored procedures using temp tables and CTEs and missing indexes as well as upgraded SSIS packages, and modified rules engine to remove linked server joins to reduce slow reports and transaction processing during peak hours and processing by 85%. Improved stability and system availability, reduced deadlocks, improved batch processing time that met or exceeded SLA. • Created stored procedures to collect PerfMon, index, and stored proc stats and stored in database with SSRS front end for all data servers to collect and report database performance statistics and interface dashboard. • Designed a user-friendly interface on enthronement health with drill down to performance stats, recommended indexes, and worst performing stored procedures. Developed a proof of concept for proxy voting history using SSAS and Tableau and migrated development environment to SQL Azure.

San Francisco, Ca, Us

• Built a data link between EmbARK 4D database and MediaBin SQL data and improved tracking for collections management and digital asset management systems. • Created data mart using SSIS to import data from EmbARK and MediaBin databases and authored solution for Gallery Systems. Improved data exchange processes and SSRS integrated SharePoint reporting portal as additional benefit to end users• Replaced manual letters and record tracking for loan request system by utilizing .NET and SQL to store requests, responses and linked to collections management data mart and images. • Designed an interface for press clippings using .NET, Ajax and C# to track and store PDF of news clippings and reviews and integrated SSRS reports with SharePoint. Automated ability to add, search and compile exhibition clippings and deliver compiled reports to donors and.• Designed a fully functioning asset visualization tool using .NET, C# and Silverlight PivotViewer to dynamically display and sort collections images and data.

• Created data exchange process Using SSIS and SQL to import mainframe output files, updated by state and county employees via secure .NET interface and export to files consumable by mainframes batch processing to replace existing retirement system interface. • Improved security and reliability in reporting and data transfers between legacy system and interim implementation for SOA architecture.• Redesigned website to improve navigation and searchability by converting traditional ASP to .NET framework and added uniform design across departments and pages and improved ease of use, contemporary feel, navigation and dynamic content.• Automated vendor payment interface to replace manual process using secure .NET interface with SQL database back end to support self-service inquiries using SSIS to load data feeds for payments and reduced phone calls to office.• Implemented SSIS to load web log data into SSAS to analysis possible hacking, threats and possible fraudulent activities. Created a survey results report interface using SSIS to load data and SSRS linked to SSAS cube for subscription delivery.

Montpelier, Vt, Us

Taught Introduction to Culinary Technology to new students.

Carlsbad, California, Us

• Designed and built a consolidated consumer data and ERP data warehouse cubes using SSIS and SSAS with LDAP connection to Cognos as well as SSRS reports providing the ability to slice and dice sales, distributor and product data.• Created a .NET barcode system and interface with SQL backend and SSRS reports for server backup tapes. Increased accuracy in organizing and tracking tape backups sent offsite and onsite and easy reporting.

New Britain, Ct, Us

• Automated manual nightly systems check and created a Web interface to the UNIX/AutoSys job scheduler results for UK and US Data Centers consolidation and daily batch process monitoring which significantly improved nightly procedures and job documentation.

San Mateo, California, Us

Database Administrator• Implemented standby access for all Sybase databases, requiring modification of Perl script to dump and copy transaction logs from primary servers to failover systems improved disaster recovery and business continuity.• Created diagrams for all database servers and automated process to backup and restore databases from production to disaster recovery site.QA Technician• Built an ASP web application with Access database to store QA test data to track QA desktop builds and test results and utilized Vmware to create desktop images build.• Develop a full-featured and automated change management ASP web application with email notification to replace manual Excel spreadsheet and tracking.Production Control Supervisor• Supervised and trained Production Control and Print Center staff of 4• Automated nightly batch monitoring process by creating HTML Run Sheets for all nightly jobs and scripting job schedule export data from AutoSys which improved response time and troubleshooting for job failures.

• Took over and established store with 20 employees that was not profitable and had lowest customer service in the region and made it profitable in 6 months and received award for best customer service in Eastern Division by implementing a QA process to improve order accuracy, training all employees, and empowering employees to take ownership.

• Responsible for installation of changing exhibitions, supervising interns, writing newsletter articles, supporting grant applications and day to day operations of 17,000 square foot multi-arts space.• Worked with Sister Cities project to collaborate with Art Slobobda Gallery in Novgorod Russia for exhibition and Auction which Increased revenue from auction and exhibition as well as improved publicity. • Curated “The Art as Healing” exhibition and co-curated several other arts exhibitions.

Taught undergraduate class in Introduction to Black and White Photography

Rochester, Ny, Us

Taught the summer and fall sessions of Introduction to Photography to adult continuing education students

Taught 3 semesters of undergraduate SUNY Brockport students Alternative Processes in Non-Silver Photography

Master Of Science (Ms), Applied Information Technology

Master Of Fine Arts - Mfa, Photography

Bachelor Of Fine Arts - Bfa, Photography