Salesforce Technical Architect Resume
Southlake, TX
SUMMARY:
- Salesforce application architecture, development, and maintenance.
- Development of Salesforce Communities, including custom Lighting Components
- Development Apex classes, triggers, test classes, using VS Code, Force.com IDE, and Developer control.
- Salesforce integration with other enterprise systems using SOAP Web Services and Bulk API, and 3 rd party integration tools, such as CapStorm/CopyStorm and Jitterbit.
- SQL Server 6.5, 7.0, 2000, 2005, 2008/R2, 2012 20 Years Experience
- Database design and construction
- SQL query development
- Stored procedure, trigger, and function development
- DTS/SSIS package development and scheduling
- Performance tuning and index tuning
- Worked with databases containing hundreds of millions of records
- Installation, configuration, and production support
- Analysis Services (MDX) and Reporting Services experience (over 4 years each)
OTHER TOOLS & TECHNOLOGIES:
- ASP.NET 14 Years (10/2017)
- ASP.NET MVC 11 Years (10/2017)
- Java Server Pages (JSP) 2 Years (5/2004)
- Java Struts (MVC) 2 Years (5/2004)
- JavaScript/jQuery 12 Years (10/2017)
- XML, XSLT 13 Years (10/2012)
- HTML, XHTML 22 Years (10/2017)
- Classic ASP 13 Years (7/2009)
- APEX, SOQL 6 Years (10/2017)
- Transact - SQL 20 Years (10/2017)
- MDX 5 Years (7/2013)
- C#.NET, VB.NET 14 Years (10/2017)
- Java, J2EE 2 Years (5/2004)
- Visual Basic 4, 5, 6, VBA 10 Years (7/2008)
- Visual Basic 4, 5, 6, VBA 10 Years (7/2008)
PROFESSIONAL EXPERIENCE:
Confidential, Southlake, TX
Salesforce Technical Architect
Tools & Technologies: Lightning Components, Salesforce Communities, Force.com IDE, Ant, Salesforce Deployment Tool, Salesforce1 Mobile, Microsoft SQL Server 2012 (MSSQL), APEX (classes, triggers, batch classes, schedule classes, test classes), CapStorm/CopyStorm.
Responsibilities:
- Responsible for designing, developing, and maintaining custom applications for insurance client in Salesforce.
- Responsible for developing and maintaining Lighting components, Salesforce Communities, custom processes/flows, custom reports, and custom APEX code.
- Responsible for gathering requirements, documentation, solution design and development, testing, and deployment.
- Developed Salesforce Community using custom Lightning Components to allow vendors to update their skills and profile information.
- Developed Salesforce solution to send contract reminder emails and Confidential messages to vendors and field reps.
- Developed Salesforce solution to send license expiration reminder emails to adjustors.
- Developed Salesforce solution to send background check renewal reminder emails and Confidential messages to vendors and field reps.
- Master Data project, consolidating vendor status and stills information from multiple sources, making Salesforce system of record.
- Implemented Cases for vendor management team.
Confidential, Irving, TX
Salesforce Technical Architect
Tools & Technologies: Salesforce, Force.com IDE, Ant, Salesforce Deployment Tool, Salesforce1 Mobile, Microsoft SQL Server 2012 (MSSQL), C# .Net, Entity Framework, Web Services (SOAP, REST, Bulk API, Salesforce Connect), APEX (classes, triggers, batch classes, schedule classes, test classes), CapStorm/CopyStorm.
Responsibilities:
- Responsible for designing, developing, and maintaining custom applications for sub-prime auto lending client in Salesforce.
- Responsible for developing and maintaining custom reports, flows, approval processes, and custom APEX code.
- Responsible for integrating with data warehouse to pull data into Salesforce using SOAP, REST, the Salesforce bulk API, and Salesforce Connect.
- Developed territory management enhancements application in Salesforce.
- Integrated enterprise data warehouse data with Salesforce through .Net application calling Salesforce web services.
- Wrote approval processes, flows (including Process Builder), workflows, and email alerts.
- Wrote Apex classes, triggers, VisualForce page, controller extensions, and test classes, maintaining 90% code test coverage.
- Setup Salesforce development and test environments and instituted Salesforce change management procedures.
- Over 50 successful Salesforce custom development projects completed.
Confidential, Plano, TX
Salesforce/.Net Developer
Tools & Technologies:
Salesforce , Microsoft SQL Server 2012 (MSSQL), C#, ASP.net Web API, REST , Silverlight, SSRS, Microsoft Excel Macro, Web Services.
Responsibilities:
- Developed proof of concept application in Salesforce to replace existing Silverlight application.
- Responsible for the development of a sophisticated Excel application utilizing Excel VBA macros, calling Web API services, which pulls information from the database warehouse to create Excel reports.
- Developed events management POC application in Salesforce .
- Developed sophisticated Excel reporting application.
- Developed and maintained ASP.net API REST service.
- Developed and maintained SQL Server 2012 database and stored procedures and SSRS reports.
- Performance tuned queries against warehouse with hundreds of millions of records.
Confidential, Dallas, TX
Mobile/Hybrid/.Net Developer
Tools & Technologies: Microsoft SQL Server 2012 (MSSQL), HTML 5, Mobile Hybrid Application, jQuery, Backbone.js, Telerik AppBuilder (Icenium), PhoneGap/Cordova, REST API, ASP.net, C#
Responsibilities:
- Responsible for the further development of a health care mobile hybrid HTML 5 application.
- Developed mobile hybrid HTML 5 application using Telerik AppBuilder, built upon Backbone.js and PhoneGap/Cordova technologies.
- Developed and maintained ASP.net API REST service.
- Created and maintained SQL Server 2012 database, tables, views, and stored procedures to support API service.
- Developed features and maintained HTML 5 mobile hybrid healthcare application.
- Developed and maintained ASP.net API REST service.
- Developed and maintained SQL Server 2012 database and stored procedures.
Confidential, Dallas, TX
Salesforce/BI Developer
Tools & Technologies: Salesforce.com, C# .NET, CSS, Javascript, Microsoft SQL Server 2008 (MSSQL), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SharePoint (MOSS) 2007/2012.
Responsibilities:
- Developed and maintained Lease Management System in Salesforce to track datacenter leases, properties, and inventory.
- Wrote custom controllers , triggers , and VisualForce pages to create “Wizard” interface for lease data entry. Wrote custom JavaScript to calculate lease metrics during data entry.
- Integrated Salesforce Lease Manage System to data warehouse via Riptide Reflection, which utilities SOAP connection to Salesforce. Enabled Chatter for use within the company.
- Develop and maintain business intelligence systems, including business analysis, data modeling, warehouse development, cube development, MDX query development, MDX/cube performance tuning, and pixel-perfect report development for C-level executives.
- Developed C# ASP.net website to dynamically control access to SSAS cube via .Net Assembly.
- Created a BI system to eliminate Excel reporting task taking multiple weeks every quarter by developing a Salesforce data entry system front-end and SSAS cube to automate the collection and reporting of quarter-end processes.
- Developed pixel-perfect SQL Server Reporting Services (SSRS) reports for C-level executives, published to SharePoint (MOSS).
- Improved ETL loads times from 1 hour to 30 minutes by tuning SQL Server queries
Confidential, Frisco, TX
Architect, Sr Developer
Tools & Technologies: .Net 4.0, ASP.net MVC, jQuery, AJAX, JavaScript (Closures), Unity, Linq, Visual Studio 2010, SQL Server 2008, Windows Identity Foundation (WIF)
Responsibilities:
- Responsible for establishing and enforcing system architecture and standards.
- Responsible for developing new web applications and supporting legacy applications.
- Designed, developed, and implemented Single Sign-on (SSO) solution utilizing Windows Identity Foundation (WIF) and converted two web applications to use the SSO service.
- Established coding standards, design patterns, and system architecture for new development projects.
- Assisted in the establishment of a SDLC to better track delivery timelines and improve project oversight.
Confidential, Dallas, TX
Sr Developer, Director of Development
Tools & Technologies: SQL Server 2008, Reporting Services 2008, SQL Server Integration Services, Visual Studio 2005/2008, ASP.Net, AJAX, Telerik Controls, Classic ASP
Responsibilities:
- Manage application development team, including developing and implementing new processes, systems, and reorganizing the team for improved responsiveness to change, early return on investment, and increased control.
- Develop ASP.Net applications, web services, Windows services, SQL Server objects and reports.
- Reorganized the Application Development team by removing under-performing team members and hiring top talent
- Improved software development delivery by implementing the Agile (Scrum) process
- Developed a production support team and process to address production issues in a timely manner
Confidential, Frisco, TX
Business Intelligence Consultant
Tools & Technologies: SQL Server 2005, Reporting Services 2005, Analysis Services 2005, SQL Server Integration Services, Visual Studio 2005, AJAX, Telerik Controls, ASP.Net
Responsibilities:
- Implement data mart load strategy to load facts and dimensions from transactional systems using stored procedures wrapped in SSIS package.
- Design and implement reporting services reports against Analysis Services and SQL Server using MDX and SQL.
- Develop ASP.Net web application leveraging Microsoft AJAX toolkit and Telerik controls.