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.
• 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.
• 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.

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.
• 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.
• 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.

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.
• 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.

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.
• 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.

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.
• 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.
• 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.
• 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.
• 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.
• 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.

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.
• 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.

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

• 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.

• 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