Patrick De Werk Email & Phone Number

Roseville, Ca, Us

• Business Analyst• Database Architect - Oracle• Tune/rebuild older or inefficient database queries and processes.• Assist my team and other teams in SQL development and tuning both Oracle and Oracle Application Express (ApEx)• Production Support for existing reports in ApEx, Crystal andSQL.• Review of Crystal reports and underlying code for accuracy and rebuilding SQL as required.• Design and build Oracle Application Express (ApEx) interfaces.• Mentor and train team members in ApEx.• Development training, writing instructions and manuals.• Assist with on-boarding counties to using ApEx, and assisting with SQL when needed.• Assist with queries for cut-over and migration validation.

Folsom, Ca, Us

• Lead database designer / Database Architect• SQL developer• Python developer• Application portal administrator• SQL Server DBA.• Data Scientist

Utrecht, Utrecht, Nl

VP, Business Intelligence Developer - Information Services and Development, Web Development Team 2016-PresentVP, Business Intelligence Developer – Compliance Team 2015-2016AVP, Business Intelligence Developer – Compliance Team 2014-2015• Lead Scrum Master, working in an Agile environment, for IS&D and Database teams.• Utilize TFS (Microsoft Team Foundation Server) and Azure DevOps Server for version control, bi-weekly scrum meetings and sprints. • TFS / Azure DevOps Server Administration and customization, XML.• Applications Developer (ApEx)• Application Support (ApEx, Oracle, SQL Server, GVPO, MS Access, MS Excel).• C# for Selenium testing, and basic application coding.• Define methodology and workflow documentation for current and proposed processes.• Work with Data Warehouse team to provide application data solutions for other Rabobank teams. • Process and report development training, writing instructions and manuals. • AdHoc reporting and data mining through SQL (SQL Server and Oracle databases). . • Production Support for existing Access Databases and Excel Worksheets with VBA. • Database Architect, Oracle. Design, administration and program Oracle Application Express (ApEx) applications, utilizing SQL, Javascript, jQuery, and CSS.• Conversion of Access Databases and Excel Worksheets into Oracle Application Express (ApEx) Applications• Evaluate, tune and rebuild older or inefficient database queries and processes.• Process and report development training, writing instructions and manuals.• Mentor and train teams with Scrum, TFS and agile processes• Worked with Global Visions Patriot Officer (GVPO) Database• Data Scientist• Business Analyst

Oakland, California, Us

• Operations Excellence Team member in charge of process improvement for reporting.• Report development and maintenance to support Shield Advance Installation and Membership (I&M), Installation and Billing (I&B), Large Group, Individual and Family Plans (IFP) and Sales. Posted and distributed using various tools including Crystal Reports, MS Access, Business Objects Enterprise Server, VB.Net, VBA and Batch Processing. On demand / Adhoc reporting and data mining through SQL.• Develop and maintain databases and applications for auditing, reporting and conversion data verification. • Methodology and workflow management for report development and prioritization.• Database Architect, SQL Server. • Design, maintain and enhance in-house Enterprise Reports Systems report tracking SQL Server database and application GUI.• Technical resource for Crystal Reports, Crystal Enterprise and Business Objects software to I&M and I&B teams.• Production Support for existing reports.• Support and process data for Conversion Team, using Excel, MS Access and SQL Server. Assist with scripting legacy data through Stored Procedures in preparation for conversions.• Conversion and application support during Member Validation processes.• Assist my team and other teams in SQL development and tuning.• Evaluate, tune and rebuild older or inefficient database queries and processes.• Process and report development training, writing instructions and manuals.• Mentor and train new team members.

Oakland, California, Us

• Report development and maintenance to support Shield Advance Installation and Membership (I&M), Large Group, Individual and Family Plans (IFP) and Sales. Posted and distributed using various tools including Crystal Reports, MS Access, Business Objects Enterprise Server, VB.Net, VBA and Batch Processing. On demand / Adhoc reporting and data mining through SQL.• Develop and maintain databases and applications for auditing, reporting and conversion data verification. • Methodology and workflow management for report development and prioritization.• Database Architect, SQL Server. Design, administration and program in-house reports management tool.• Technical resource for Crystal Reports, Crystal Enterprise and Business Objects software to I&M team.• Production Support for existing reports.• Support and process data for Conversion Team, using Excel, MS Access and SQL Server. Assist with scripting legacy data through Stored Procedures in preparation for conversions.• Conversion and application support during Member Validation processes.

• Committee chair for Facility Maintenance committee.• Assessment and implementation of Facility Maintenance Software Solutions.• Purchasing, implementation, training and management of Facility Maintenance software.

Hoffman Estates, Il, Us

• Project Management• Installation, configuration and documentation of Syclo Handheld Software.• Document and support Customer Functional Acceptance Testing of installed software.• Installation of and associated applications required for supporting development and configuration.• Instructor for “Smart Work Manager for Maximo” class, including managing training database.• Technical Writing – Training Manuals and handouts for “Smart Work Manager for Maximo” class.• Customer and Technical Support.• Internal Maximo Training and technical support.• Assist with and create Crystal Reports for Finance and Professional Services groups.• Business Analyst

Us

• Methodology and workflow management specialist.• Project Management for systems upgrades / Team Lead for contract employees.• Database Architect, SQL Server. Design, administration and program in-house reports management tool.• Crystal Reports and Crystal Enterprise 9 to XI, Business Objects WEBI XI Universe and Web Design, Server Administrator. Responsible for technical documentation, scripts, manuals and administrative forms.• Support staff for Crystal Reports, Crystal Enterprise and Business Objects software.• In charge of weekly staff, support and customer update meetings, participant in regular project status meetings. • Responsible for documentation for weekly change control meetings.• Maintain Sarbanes-Oxley and other standards including those regarding processes and secure information.• Creation, implementation and documentation of new policies and procedures.

• Facility/site assessments and assisting companies in optimizing the use of CMMS (MAXIMO) software.• Advanced training in MAXIMO, Seagate Crystal Report Writer, SQL Scripting.• Technical Support for MAXIMO and Crystal reports• Database architecture, Data modeling, and Database Analysis.• Full range of knowledge of Inventory control, purchasing and other engineering needs.

Chestnut Hill, Ma, Us

• Lead Millennium / Crystal Report writer for Oracle.• Assist with building and documenting standardized procedures and report formats.• Design Tables, Views, (PL/SQL) Scripts and Stored Procedures to maintain custom reporting.• Database Analyst, assisting with QA and analysis of reporting and database problems.• Technical Consult for MAXIMO 5.1.

Norwell, Ma, Us

• Develop and manage (T-SQL) Stored Procedures, ASP pages and Crystal Reports for In-House software used at facilities nationwide.• Evaluate and compare Software and procedures to improve productivity and efficiency.• Support for end user and MIS related problems.• Document new and existing guidelines, procedures and programs.• Database analysis, data integrity verification and troubleshooting.• Business Analyst

• Project management. Assess facility maintenance needs. Assist companies in optimizing the use of CMMS software including, creation of warehouse layouts, PM Maintenance plans, inventory procedures and other SOPs.• Extensive use/training in MAXIMO (up to v5.1).• Lead trainer for basic and advanced users of MAXIMO, Crystal Reports and SQL. Develop training agendas, manuals, handouts and other class materials.• Lead report writer. Using Crystal Reports (versions 6 to 9) and SQL.• Maintain databases in SQL Server, Oracle and SQL Base Servers.• Programmer. Build custom applications with Centura Object Nationalizer, SQL stored procedures, triggers and Scripts.• Database architecture, modeling, and Database Analysis.• Business Analyst• Technical advisor to handheld software programmers assisting with logistics, functionality, QA and Beta testing.• Data Conversion Specialist. Convert, manipulate and reconfigure using various tools.

Chicago, Illinois, Us

Continuation of the previous Able Engineering job under a new contract with Bank of America

San Francisco, Ca, Us

Contracted to Bank of America Data Centers for:• Maintain MAXIMO database and related documentation.• Manage Preventive Maintenance schedules and Engineer workloads. • Build standard and ad-hoc reports for various databases on multiple platforms such as SQL Server and FoxPro, using tools such as Access and Crystal Reports.• QA, auditing and data cleansing of converted data.• Collection and entry of new asset records.

Cork, Ireland, Ie

Under contract to Bank of America Data Center for:• Maintain MAXIMO database and related documentation.• Manage Preventive Maintenance schedules and Engineer workloads. • Build standard and ad-hoc reports.• QA, auditing and data cleansing of converted data.• Collection and entry of new asset records.

• Various Supervisory positions including; Corporate Real Estate Powerdown and Systems Upgrade coordinator and part of the Project Management team; Training supervisor; Shift Supervisor and Pass Issue Supervisor.• Scheduled and supervised up to 30 employees, including hiring, processing and payroll.• Co-created and administered programs such as the "Critical Facilities Awareness" program for a safer and more productive work environment, and various other procedures, training and programming manuals.• Participated as a safety team member and first responder.• Systems knowledge includes, but not limited to, Honeywell D5200 and Delta 1000 Fire/Life Safety systems, SECARD system, various CMMS programs and CCTV and security systems.• Developed and maintained customer database and program interfaces.• Assisted in maintenance and audit of national databases.• Database Architect

Bs, Criminal Justice Administration (Law Enforcement) / Psychology / Sociology

Certificate Of Completion, Sas Enterprise Guide 1: Querying And Reporting

Certificate Of Completion, Business Objects Systems Administration And Design

Basic P.O.S.T., Law Enforcement

Aa, Psychology

Certificate Of Completion, C# Fundamentals By Coding

Certificate Of Completion, Test Automation Features In Tfs