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.