Andrew Prueser Email & Phone Number

Arizona, United States

PreSales Solution Architect working with Enterprise accounts in the western US. Discovery, demos, value selling for the Tricentis Automation and Data platforms.

Arizona, United States

PreSales Solution Architect working with Enterprise accounts in the western US. Discovery, demos, value selling for the Tricentis platform.

Our mission is to elevate the role of PreSales in organizations worldwide. We aim to provide PreSales professionals with the resources, knowledge, network, and mentorship to develop long, impactful careers.Our vision is to create a global community of professionals who have a passion for PreSales. A place where individuals in a PreSales role, or anyone who aspires to be, will be supported in their professional development.

Phoenix, Arizona Area

Phoenix, Arizona Area

Provided Planning, MES, and Sales IT Architecture support for acquisition team during acquisition of Fairchild Semiconductor.Key team member in development of new BI roadmap for larger ON Semiconductor corporation post acquisition. Worked closely with Infrastructure team to ensure server and database sizing, and support for BI initiative.Mentored BI team in best practices for Database design and Data Warehousing. Provided architecture for data security post business unit divestiture, providing limited access to financial data for spun off business.

South Portland, Maine

Architect hardware and database structure, maintain enterprise data warehouse and enterprise application integration database. Tune SQL statements for reporting and application integration. Mentor and train team members in ETL and Database design best practices.Designed DW for global manufacturing data; unifying data from disparate MES systems into one reporting and integration hub.Designed DW and ETL for bi-directional integration with cloud based sales support vendor.

Bath, Maine

Drive infrastructure and application architecture designs to develop standards and ensure compliant deployment of hardware platforms and software systems. Administer Oracle middle-tier infrastructure of 90+ servers supporting user authentication, document management, shop floor control, and database reporting. • Lead Architect on Oracle Database 10g to 11g +RAC upgrade and re-platform from AIX to VMWare hosted Oracle Linux.• Lead Architect on Oracle Mid-Tier 10g to 11g / 12c upgrade project (OC4J to WebLogic).• Led development project to replace disparate MS Access reporting tools with a common Oracle ADF, Java, and Oracle Database solution.• Architected and implemented Oracle Grid Infrastructure ACFS clustered file system solution to improve data access stability, and performance for document management infrastructure.• Produced management reports and graphics to track system performance and data throughput.

Led design, and development for manufacturing automation system and ETL to support a new business unit. Met primary goal of designing and deploying services based infrastructure to allow global fabrication machinery to MES, mapping and yield data at point of process. • Designed and deployed 3-tier SOA architecture based on Apache application servers.• Provided support for corporate document control systems based on Oracle WebLogic.• Extended MES message queue system via JNI for access from J2EE and RESTful services.• Leveraged Apache FOP to automate disposition reports improving production cycle time.• Embedded Quartz Scheduler in J2EE container reducing hands-on maintenance.• Developed ETL system to consolidate data and provide central access across worldwide business units.Managed enterprise-wide Sybase databases containing approx. 3TB of data. Administered database replication processes for engineering analysis, yield and QA reporting, and manufacturing data collection. Partnered with UNIX team to define upgrade roadmap for hardware and operating system. Assisted BI development team with query design and tuning.• Implemented Sybase replication solution increasing end user data access speeds by more than 2x.• Planned and executed upgrades for ASE improving performance and reducing maintenance time.• Consolidated global engineering data into regional data centers, reducing hardware and software costs.Collaborated with business partners to define and implement engineering data requirement standards. Designed, developed and supported engineering analysis data collection system from global manufacturing sites, subcontractors and foundries.• Streamlined engineering data ETL processes, decreasing transform failures and increasing data accuracy.• Designed system for data aggregation and reporting of process yield, reducing cost of scrap.• Automated electronic data transfer for external partners providing real-time analysis availability.