SUMMARY

• Extensive experience designing and delivering Salesforce.com based solutions.
• Worked as a consultant on enterprise software projects in numerous industries including: Pharmaceuticals, Insurance, Staffing, Enterprise Software and eCommerce.
• Demonstrated competency in cloud computing, database design, and in developing solutions using a variety of popular application stacks.

PROFESSIONAL EXPERIENCE

Technical Architect

Confidential, Las Vegas, NV

Responsibilities:

• Development Environment Setup: Bitbucket Repository, Continuous Integration with Bitbucket Pipelines, Automated Testing using Robot Framework and Selenium. Production installation proceedures.
• Call Center Application: Classic Service Console, Five9 CTI with custom screen pop logic, Custom VisualForce search interface, Veeva iRep integration
• Marketing and Training Systems Integration: Development of Outbound Messages and Apex REST services to publish/subscribe changes between systems.
• Investigator Training Portal: Partner Central Winter '18 based community. Lightning custom object pages and custom Lightning Component Actions.

Tools: /Technologies: Salesforce.com, Visualforce, Apex, Console Integration Toolkit, Lightning Components, Apex Data Loader/Force.com Workbench, Migration Tool (ant), HTML, JavaScript, jQuery, Jira, Robot Framework, Selenium, Python, Bitbucket

Technical Lead

Confidential, South San Francisco, CA

Responsibilities:

• Adverse Event Reporting. Design and development of custom integrations (java) between Salesforce, SpringCM content management system and Confidential Drug Safety applications.
• ICD10 Transition. Lead transition of applications to new ICD10 diagnosis code standard.
• RS Integration. Design and development of an intelligent task assignment process for Reimbursement Specialists based on Payer, Product and Prescriber.
• Diagnosis Driven Services. Design and development of Case Management application enhancement to implement new business rules controlling services allowed.
• Access Solutions Data Retention. Archiving and deletion of old cases and related objects using Informatica Cloud.
• Maintenance, Enhancements and Support. Implement and deploy emergency changes in response to production issues. New product/line extension application updates. Tier 3 support.

Tools: /Technologies: Salesforce.com, Visualforce, Apex, Apex Data Loader, Oracle, Java, Maven, Migration Tool (ant), Informatica Cloud, HTML, JavaScript, jQuery, Sublime/MavensMate, Force.com Workbench, Jira, Bamboo, HP ALM

Technical Architect

Confidential, Philadelphia, PA

Responsibilities:

• My Patient Solutions. Redesign user authentication process for Confidential ’s Force.com sites. Design and implement new unified user profile management pages.
• New Product Rollouts. Update existing Case Management application to support new Confidential Medications. Create and update Record Types and Page Layouts. Refactor existing code.
• Intake Process Redesign. Designed and built an automated patient intake process that featured an enhanced Patient search along with a custom Case creation wizard.
• Multi Therapy View. Designed and built a custom console that allows Case Managers to view all of a patient’s open cases with consolidated related lists and attachments.
• Electronic Benefit Investigation. Developed an Apex web service integration with service provider to determine patient insurance coverage and limits.
• Maintenance and Enhancements. Implement and deploy emergency changes in response to production issues.

Tools: /Technologies: Salesforce.com, Visualforce, Apex, Apex Data Loader, Force.com IDE, Force.com Workbench, HTML, JavaScript, jQuery, Jira, Bamboo, Mercury Quality Center

Developer

Confidential, Yardley, PA

Responsibilities:

• Sales Call Scripts. Implement Visual Flow sales call scripts to guide phone sales staff and update/convert Leads.
• Custom CTI SoftPhone Layout. Custom Visualforce screen pop to perform more detailed searches, display Campaign info and launch the correct call script.
• Lead Task Generation Workflows. Action plan implementation based on Lead status and age.
• RMA Submission Visualforce Page. Implement page which integrates with Confidential ’s eCommerce system to generate RMA authorizations.
• Implement B2C/B2B Record Types. Reconfigure Lead/Account/Opportunity/Contact objects and user profiles to use record types to meet new business needs. Also, implement sharing rules between groups.
• Web - to-Lead Integration. Implement new Lead pages on eCommerce system (PHP) that create update Leads in Salesforce.com. Added Lead trigger to parse incoming JSON fields.
• Misc. ETL Updates. Maintenance and incremental updates to Java data load processes.

Tools: /Technologies: Salesforce.com, Visualforce, Apex, Force.com IDE, SQL Server, HTML, JavaScript, jQuery, Java, PHP

Developer

Confidential, Philadelphia, PA

Responsibilities:

• Legal Department Activity Tracking Application. Developed custom Salesforce.com application to manage projects and track activity for Confidential legal department.
• Case Notification SMS Messages. Built custom Case trigger to send SMS messages to support staff for cases received after hours.
• Account 360 Degree View. Implement Visualforce page to display all upcoming customer account activity in a customizable Gantt chart.
• BVS Application Integration: Made bug fixes, updated styles and added new features to this ASP.NET/C#/SQL Server Sales support application which is run via custom SFDC button (within an iframe) and reads/writes SFDC data via the API.
• Custom Quote Generation: Customized quote functionality to support Confidential pricing structure. Created custom objects to extend standard Product and Pricebook functionality. Created Visualforce wizard interface to rapid quote creation and triggers to implement business rules. Designed new quote template.
• Automated Lead Assignment: Created a Lead trigger to assign incoming leads from web-to-lead and Marketo based on Confidential rules.
• Case Backlog Statistics: Implemented Analytic Snapshots, Reports and Dashboards to report on support case trends.

Tools: /Technologies: Salesforce.com, Visualforce, Apex, Force.com Eclipse plug-in, SQL Server, HTML, JavaScript, jQuery, ASP.NET, Visual C#

Developer

Confidential, Philadelphia, PA

Responsibilities:

• SQL Server Integration Services ETL: ETL system which moves customer and sales data from the Confidential .com site to Salesforce.com. This large project included design the staging database, development TSQL stored procedures, creation of SSIS packages including C# script tasks and configuration of SQL Server Agent jobs.
• Partner Portal Implementation: Allow customer access to SF sales data using the PRM portal. Configured portal, added new page layouts and updated system sharing settings.
• Enhanced Email Campaigns: Event driven marketing email system implemented using stored procedures and SSIS package with C# script components.
• Custom Pricing: Added Custom SFDC Objects and formulas to enable customer specific pricing.
• Invoice Queue: Salesforce.com application to generate customer invoices, apply approval processes, transmit invoices to Freshbooks online invoicing site, monitor payment status and update Salesforce.com Invoice records. Automated charging to PayPal and Authorize.net.
• Revenue Forecasting: Maintain multiple forecasts on daily and monthly timeframes. Created a composite solution that includes Saleforce.com objects/code and SSIS packages.
• Sales Process. Initial system design used Opportunities for a non-sales purpose. Redesigned Salesforce data model to correct for this improper setup. Rework views, reports and custom report types.
• Vendor Payment Queue. Ported Vendor Payment Queue functionality from the Confidential web site to Salesforce.com. This involved implementing a Visualforce page, custom tab, Apex batch classes and creating new SSIS packages to integrate with Check and ACH partners. Post checks to Quickbooks Online using QODBC.
• Equipment Management. Built a Salesforce.com app to manage equipment Confidential rents/loans to customers.
• Automated Lead Conversion. Developed Email Services to automatically de-dupe and convert Leads when they respond to email campaigns.
• Call Center Setup: Configuration of Salesforce.com Call Center application. Modification of Broadworks CTI adapter and development of custom JavaScript to support adding custom fields to the Call Log screen.
• Foreign Currency Modifications: Retrofit application to support foreign currencies. Implemented pop email polling, created and SSIS package to locate and update transactions with effective exchange rate.

Tools: /Technologies: Salesforce.com, Visualforce, Apex, Email Services, Force.com Eclipse plug-in, SQL Server, SSIS, HTML, JavaScript, Visual C#, Visual C++, QODBC

Senior Developer

Confidential, Philadelphia, PA

Responsibilities:

• Data Warehouse Data Model. Conducted a Gap Analysis of current data warehouse database. Designed data model changes. Generated creation and testing scripts.
• Informatica ETL Implementation. Developed an Informatica repository design. Implemented Informatica mappings and workflows including email notifications, log file and reject file management. Developed workflow scheduling plan. Created Informatica Data Quality plans. Designed and built Java transformations to use Salesforce.com web service API. ETL Stored Procedure development. Implemented Informatica version control. Developed and executed deployment procedures. Created windows scripts for functionality not supported by Informatica.
• Automated Test scripts. Developed Windows Script Based integration test suite for QA and deployment. The system used the Salesforce.com web service API script toolkit and ADO to recreate and populate database and Salesforce.com from csv and xls files.
• Salesforce.com Development. Created Salesforce.com custom objects/custom fields. Setup Security Controls including Sharing rules, Profiles, Public Groups, Record types and Field Level security. Implemented workflow rules. Created and modified page layouts. Developed and maintained Apex Classes and Triggers.

Tools: /Technologies: Informatica, Salesforce.com, Force.com Eclipse plug-in, SQL Server, Windows Script, Java, JavaScript, VBScript

Senior Developer (Consultant)

Confidential, Ft. Washington, PA

Responsibilities:

• CRM/Lead Management. Development, deployment and support of a Salesforce.com based Lead Distribution and Sales Process Management system for GMAC Real Estate Agents and Managers. Implementation included Salesforce.com configuration, Custom Workflow implementation, development of Custom Objects and sControls, Reporting and Dashboards, integration with Company Websites for Lead distribution and Data Synchronization. Ongoing refactoring and redesign to take advantage of new Salesforce.com features with each release. Created ASP.NET website to extend Salesforce.com functionality and provide access to Customers and Partners. Data migration of existing lead data from legacy Lead Management Systems.
• Agent Recruiting. Salesforce.com application managing a region-wide database of Real Estate Agents. The system extended basic Salesforce Contact Management to support Real Estate Agent recruiting workflows. Extended existing SFDC Mail Merge and mass email features to meet requirements. Mentored junior developers for project hand-off.
• Helpdesk. Customized Salesforce.com Service and Support application for use by Confidential Helpdesk. Updated Salesforce.com security configuration to share Accounts with Lead Management Application. Implemented GMAC specific functionality to escalate cases to higher tiers. Mentored junior developers for project hand-off.
• Business Planning Tools. Development, deployment and support of a Multi-Level Planning/Forecasting tool. This ASP.NET/C# application was built using the Microsoft Web Client and Web Service Software factories. Made extensive use of TSQL stored procedures to generate complex views of plan data. Integration with accounting systems using DTS packages.
• MLS Listing Data Feeds. Development, deployment and support. MLS Listing Data. SQL Server DTS packages. B2B data exchange. Publish feeds to business partners. Developed complex views on MLS listing database. Worked with vendors and GMAC data center to setup feeds using various protocols.

Tools: /Technologies: Salesforce.com, ASP.NET, SQL Server

Director of Product Development

Confidential, Dublin, PA

Responsibilities:

• Managed Money Dashboard. Development, deployment and support of a mutual fund sales analysis web site for clients including Merrill Lynch and Smith Barney. MySQL database design, query tuning and optimization database schema. Created 20+ reports using JasperReports and JFreeChart. Development of ETL processes to load source data and map vendor specific attributes and territory definitions to application values. Performed server configuration and administration. Created system backup scripts and managed test and production server instances.
• Temporary Staffing Application. Development, deployment and support of a web-based temporary staffing agency workflow solution. Features included employee database, timecard collection and payroll submission. Supervised server and network administration.
• Advanced Recruiting Database. Development, deployment and support of a complete executive search candidate database and workflow management tool. Project included ETL existing data from Oracle database, automated job site searching, keyword database search and Outlook calendar integration. Hosted Tutorial sessions with user community. Ongoing 2nd tier support. Wrote application User Guide.
• Capital Markets Candidate Database. Requirements gathering, design and implementation of a Web-based Candidate database and Recruiting Workflow tool for large NYC Search Firm. Implemented keyword searchable candidate resume database. Created customer facing web site for client review and feedback on potential candidates. Server configuration and administration. Ongoing enhancements and 2nd tier support.
• Confidential Foundation Suite. Maintenance and new development for the Confidential XML-Based Web Application Platform. Designed and coded Eclipse plug-ins for use with the Foundation Suite product. Create and update product documentation. Support and mentoring of junior developers. Design and supervise development of issue tracking database

Tools: /Technologies: Windows Server 2000/2003, Java/J2EE, Tomcat, MySQL, HTML/JavaScript, NSIS Installer, Oracle, SQL Server, JasperReports, JFreeChart

Software Engineer

Confidential, New Hope, PA

Responsibilities:

• Law Enforcement Records Management System. Designed and implemented a web server application framework that controlled navigation, data caching and enabled advanced database queries. Managed internal release builds. Coded individual application modules.
• Integrated Workers Compensation Case Management System. Constructed a large multi-tier system composed of multiple Java/Swing clients (including connected and disconnected versions), Java business layer exposed by SOAP and an Oracle enterprise database. Created a framework for database synchronization for disconnected clients. Performed performance testing and tuning. Involved from requirements to production.
• Sales Pricing Tool. Implemented of a Web front-end for a legacy pricing system. Struts web application that staged production configuration in an Oracle database before sending batch requests through a customer provided interface to a Mainframe application.
• County Court Query System. Designed and implemented an asynchronous web query tool. Collected query parameters and submitted to various court databases via BizTalk.
• Condominium Community Management System. Ported an existing PowerBuilder client/server application to an IIS/ASP web application. Created an application that reused the existing SQL server database and stored procedures. Translated existing business logic to VB6 components.

Tools: /Technologies: HTML/JavaScript, J2SE, J2EE, Tomcat, XML/XSL, Jakarta Struts, Swing, SOAP, C#, ASP.NET, SQL Server 2000, Visual Studio .NET, Oracle, Visual Studio, IIS, ASP, BizTalk 2000, Visual Basic 6.0