
Michael Dean
- Salesforce Architect
- San Mateo, CA
- Member Since May 01, 2023
Michael Dean
Objective: Looking for a position that will allow me to utilize my extensive Salesforce and application architect background. Available immediately.
Contributed to consulting sales initiatives including building prototypes and attending sales pitches. Managed offshore development resources for build-out of customer-facing billing systems hosted on Force.com and utilizing SFDC communities. Solution includes SAML SSO support, web service integration with SAP, and custom UI featuring Visualforce and Angular Javascript framework. Farmers Insurance internal advisors are featured as community users with login-as-customer capability.
Wrote triggers and Apex code for Dell Ideas portal. Designed custom Visualforce screens for bulk opportunity management.
Designed Visualforce pages for customers to purchase and activate service contract records and warranty entitlements via customer portal (SFDC community). Wrote triggers for auto-generation of quotes as well as Apex outbound web service calls for updating warranty expire dates via Tibco. Co-authored .NET libraries for interfacing legacy ASP applications with SFDC web service API. Designed custom Visualforce reports for rendering RMA reports in Excel. Assisted in planning and executing weekly production releases and communicating release status to other internal teams.
Designed and developed Cast Iron orchestrations for real-time web service and bulk data extraction from Salesforce to BAH ERP system. Built Salesforce approval flows and workflow routing rules around business processes. Led technical requirement gathering sessions with business users and technical team. Designed and planned a data migration strategy from previous CRM. Some integration work using Dell Boomi processes.
Clients: Citicorp (New York), Frontier Communications
Co-architected and developed a Visualforce (VF)/S-control wrapper iframe solution for presenting Salesforce.com within Citi Visual Basic Wealth Management host application. Architected and developed custom Flex component for presenting merged sets of notes from disparate applications within SFDC. Collaborated with offshore resources on development tasks. Designed S-controls for custom UI behaviors including default record type and field initialization.
Clients: Autodesk, Oxford University Press, Seagate
Managed offshore technical resources for Autodesk VF/Apex customization tasks. Created VF screens for Autodesk PRM Portal customization. Architected an Apex-based solution for managing complex visibility rules around Autodesk role hierarchies. Assisted Autodesk team with Tibco web service integration into SFDC. Worked with SFDC Sales team to scope Oxford Press (OUP) engagement. Served as business analyst and technical architect for OUP project, including managing developer resources for OUP rollout. Acted as SFDC developer support contact (VF/Apex) for Seagate India-based engineering team. Customized Salesforce Customer Portal for Seagate case management and knowledgebase requirements.
Served as principal architect and engineer for application finalist in the 2008 Dreamforce Breakthrough Application of the Year award. Telephony Application includes a Java-based interface for importing voice messages into Salesforce. Flex-based UI is used to play back messages and stream communications to customers. Apex used for triggering field updates on related objects. Managed Ribbit offshore engineering resources and offshore code integration effort. Collaborated with SFDC resources on AppExchange release lifecycle and integration issues.
Clients: Dell, EmailLabs, CustomerSat, National Retirement Partners, SixApart
Customized and refaced Salesforce Customer Portal for Six Apart customer Case Management.. Work with Echo Lane Sales on Presales activities including project scoping and prototyping. Served as data migration architect for Dell Ideas rollout. Dell project included working with Dell team to establish data mapping relationships with SFDC, writing Unix/Win command line scripts for Data Loader automation. For EmailLabs, designed and co-developed PHP-based AppExchange offering allowing exporting of leads/contacts into EmailLabs email marketing system. Export includes filter specification and field mapping capability. Acted as technical lead and project manager for .CustomerSat .NET-based AppExchange plug-in. Plug-in provides exporting of leads/contacts into CustomerSat survey engine and importing of response data back into Salesforce. Built S-controls for the plug-in UI and C# server components for offline batch processing. Integrated Pervasive middleware for synchronization between Salesforce and NRP’s SQL Server database.
Served as architect for Remend’s Salesforce OEM offering, REO Agent. Built a .NET-based (C#) provisioning system for Remend AppExchange purchases. System includes email-based loading of preconfigured Salesforce org account inventory. System handles registration and provisioning of REO Agent trial accounts and purchases/conversions of trial to paid accounts. System also includes trial expiration notification. Built a Java-based gateway to send application objects into Salesforce.com. Implemented S-Controls and Javascript AJAX calls for Salesforce hosted web forms. Built an ASP-based (VS.NET) prototype web application for managing foreclosed estate properties. Application includes a VBScript, XML-based templating framework for storing template meta-data. Constructed XHTML-compliant web pages for REO processing application. Implemented Javascript DOM parsing code for DHTML effects.
Enhanced PHP-based course planning system using Mach-II framework. Assembled JasperReports/ OpenReports-based reporting solutions with custom Velocity templates for viewing report (MySQL) data. Wrote PHP5 utilities for import/export of XML data into MySQL. Designed XSLT definitions for XML to HTML reports. Evaluated reporting tools for integration into company product suite. Interfaced with clients for requirement gathering and bug resolution. Integrated a rich text editing solution into LAMP-based applications. Performed minor customizations of SugarCRM presentation layer.
Designed JSP product preview screens with XSLT transformations for multiple clients. Extended Hibernate-based persistence framework with new Java objects. Integrated Cybersource credit card gateway (w/CVN verification) into website store. Coordinated with Dell programmers to integrate Eyetide digital screensaver into Dell Media Experience product via ActiveX/Javascript interface. Enhanced C++ ATL-based screensaver with built in web browser object and keystroke detection capability. Performed MySQL data export/imports for business reporting. Provided backup DBA support including alert monitoring, tablespace adjustment and statistics computation. Performed data export/imports for Oracle 9i to 10g migration. Modified ActiveX VB installer to interface with Windows registry.
Architected and implemented (Tomcat & Oracle AS) a Java/JSP-based employee performance appraisal system to be deployed throughout campus. Appraisal system includes simple Model 1 architecture centered around form object and input tag libraries allowing for role-based field activation. Implemented schema changes and generated scripts with Erwin. Wrote PL/SQL scripts to roll employee data to new academic year. Constructed a prototype web log in feature to demonstrate benefits of Java Struts. Designed and deployed Excel and web-based reports with Oracle Reports Designer. Met with other departments to understand needs for performance evaluation; administered group requirement gathering sessions. Designed an ASP-based issue tracking database input form and database with Microsoft Access. Generated monthly bug reports with Access chart engine. Generated VBA Excel macros for simple sorting and reporting.
Installed Blue Martini CMS system, including data loading and template integration. Incorporated Blaze rules engine into CMS business logic. Designed JSP/servlet-based (Weblogic) online security framework and object permissions model. Maintained Java classes for pricing and organization interfaces to ERP and updated PL/SQL procedures for price lookups; also implemented email alerts into a custom exception framework for application interfaces. Wrote Java utility to generate an XML document modeling a schema and created XSLT transformations that yield framework-specific meta-data documents. Engineered a prototype EJB-based price server that caches prices and answers price requests in XML format and as a serialized object representation. Wrote servlet application (w/JSTL tags) for users to select payment terms and apply to invoices online. Enhanced call center screens with Visual Basic DHTML functions allowing for keystroke commands and shortcuts. Wrote simple Perl utilities to test uptime of web server. Scripted Solaris shell utilities for initializing Java processes. Assembled (csh) shell scripts for application initialization. Performed some site load (Mercury) testing; some Java object analysis (JProbe).
Designed JavaBean/Java Server Pages-based survey tool for internal employees to define, update and search for surveys in Oracle database (through TopLink middleware). Implemented JavaBean components that interface (via HTTP) with MapQuest map server, allowing users to query and zoom in on directional image maps. Wrote JavaBean and Javascript presentation logic for extracting survey content and sequestering user input via pop-up window. Served as technical lead for integrating JSP into HTML templates. Wrote Perl utilities for batch file renaming and pattern substitution. Designed user interfaces for survey tool and other content management applications.
Utilizing proprietary server-side Javascript API (Netscape server), parsed and implemented presentation logic for third-party XML content structures. Added a Javascript API into product allowing for the integration of logic tier with third-party email service vendor. Served as main technical contact with third-party vendor.
Gathered and documented client business requirements for development team. Implemented JSP presentation logic and server API calls on web pages (profile, product, shopping cart). Customized Java server classes with embedded SQL for sequestering and updating customer data. Added methods to business layer of API for accessing session and database (SQL Server) data. Modified schema, wrote insert/extract classes, and designed form for recording customer interaction with CSRs. Installed and configured merchandise content management tool and application server (WebLogic). Implemented Javascript rollover, date, and browser detection functions. Revised HTML (Homesite) online help for administrators of web-based server software. Sliced and optimized images (Photoshop) for online display. Performed SQA on server and recorded bugs in database. Edited online help user guide for online sales management tool. Wrote internal API documentation for use by engineers. Enhanced Javascript libraries with dynamic navigation and context-sensitive file auto-load. Optimized images (Photoshop) for best browser display.
Engineered Perl CGI data output programs (on Solaris) for forms sequestering survey input (with dynamic HTML response pages). Designed query form and Perl script (DBI module) that accesses (Oracle) site statistics and displays in HTML. Wrote a CGI routine for assuring the logging of links to other sites, including a CGI text editor for editing/externalizing link-mapping file. Designed a CGI cookie-based gateway mechanism for secured content area. Wrote Perl, awk and sed scripts for auto generation of index lookup files and for link changes upon system downtime. Wrote Javascript cookie functions (with encryption), a random banner generator, and get-path functions for in/outside sites. Wrote Javascript field validation and dynamic write routines around database templates for OTN registration. Constructed SQL queries for accessing site log data and reported to managers. Marketed site program offerings to internal groups. Configured Apache server for realms/CGI. Delivered downloads through lifecycle.
Designed home pages in HTML (FrontPage) for NASA aeronautical test facilities. Wrote operating procedures (Word) with GUI instructions for propulsion simulator lab and air distribution system. Authored a training manual for vacuum test apparatus, discussing components from a system perspective.
Converted all Solaris documentation to SGML (Adept Editor) and HTML and edited for online format. Designed Sun's SGML migration program site with instructional and troubleshooting pages. Wrote FrameMaker to SGML document conversion instructions (FrameMaker) for Sun writers. Revised network security software guide, implementing a task-oriented structure, appendices and index. Served as a copy editor for Sun system administration, TCP/IP, and book archive (GUI running on top of Sybase database) user's guides. Acted as a liaison between program managers/writers for authoring tool usability issues. Engineered a Perl CGI script for formatting form input and emailing to DBA. Performed Solaris installations and set up user accounts. Trained writers on editor/online authoring.
Proficient in HTML 4.0 (frames, tables, image maps, forms), Javascript (cookies, image rollovers, field validation, dynamic HTML writing, redirection), Perl, Unix (vi, sed, awk, and grep, yp services), ASP, VBScript, JSP, JHTML, SGML, Apache server configuration, PL/SQL, SQL, Information Mapping. Experience using JBuilder, JDeveloper, PHPEdit, ErWin, Toad, TopLink object modeling, FrameMaker, Word, PageMaker, Acrobat, Photoshop, Powerpoint, Excel, SAS, FrontPage, HomeSite, SourceSafe, MySQL, Oracle Reports and CVS. Have performed Solaris and NT installations.
Sun Java programmer certification, March 2004.
B.A., English, 1997, University of California, Davis. A.S. in Computer Sci., 2002, College of San Mateo.
IT Courses: Java*, Advanced Java, Java Network Programming, Java Servlets, PL/SQL, Perl, C, Adv. C, C++ (OOP), Data Structures, Pascal, Assembly, SQL, Oracle DBA. 9 units in Statistics at Stanford.