SUMMARY:

• Salesforce application architecture, development, and maintenance.
• Development of Apex classes, triggers, test classes, and VisualForce Pages on Force.com platform.
• Salesforce integration with other enterprise systems using SOAP Web Services. SQL Server 6.5, 7.0, 2000, 2005, 2008/R2, 2012 20 Years Experience (10/2017)
• 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
• MDX query development
• Installation, configuration, and troubleshooting
• Cube development and performance tuning
• Development of pixel - perfect Reports
• Use of Tablix, Subreports, Graphs, and other advanced controls
• Worked with SQL Server (relational) and SSAS (multi-dimensional) data sources

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)
• Programming: 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, Irving, TX

Salesforce Technical Architect

Tools: Salesforce, Force.com IDE, Ant, Salesforce Development Tool, Salesforce1 Mobile, Microsoft SQL Server 2012 (MSSQL), C# .Net, Entity Framework, Web Services (SOAP, REST, Bulk API), APEX (classes, triggers, batch classes, schedule classes, test classes)

Responsibilities:

• Subject-Matter Expert (SME) and Salesforce Solution and Technical Architect.
• 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, and the bulk API.
• 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: 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: 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: Salesforce.com, C# .NET, CSS, Javascript, Microsoft SQL Server 2008 (MSSQL), SQL Server Analysis Services (SSAS), SQL Sever 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: .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: 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: 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.

Confidential, Plano, TX

Sr Developer, Manager, IT

Tools: C#, .Net, WinForms, SQL Server 2000, ADSI, VBA, LDAP, Active Directory, Visual Studio.Net, Visual Source Safe, ClearCase, Visio Enterprise

Responsibilities:

• Manage the personal and professional development of 22 Access Control provisioners.
• Develop and support software applications used in Access Control department.
• Develop and support SQL queries, stored procedures, and functions as needed to support applications and ad-hoc analysis.
• Interface with audit and head up projects to support the remediation of audit findings.
• Develop, maintain, and ensure adherence to processes and controls, including those mandated by Sarbanes Oxley (SOX) regulations. Project/Resource management.

Confidential, Plano, TX

Application Architect/Developer

Tools: C#.Net, VB.Net, Java, WinForms, ASP, ASP.Net, SQL Server 2000, SQL Server 2005, ADSI, Visual Basic, VBA, COM/COM+, LDAP, Active Directory, Visual Studio.Net, Visual Source Safe, Visio Enterprise, Open Source frameworks such as DotNetNuke, Jakarta Turbine, Struts, Log4J to name a few, XML, XSLT, HTML, DHTML

Responsibilities:

• Design and architect software products for DotNetNuke platform.
• Develop software requirements and manage off-shore developers and testers.
• Develop and document business processes and procedures.
• Develop, maintain, and support client-specific applications.
• Project/Resource management.
• Develop BI System
• Location Finder/Store Locator
• User Directory
• Reporting Portal
• Ad Management System
• Enhancement Financial System

Confidential, Richardson, TX

Sr Developer

Tools: Java, JSP, MDX, Visual Basic, VBScript, SQL Server 2000, Microsoft Analysis Services 2000, DTS, Visual Studio.Net, Visual Source Safe, Visio Enterprise, Struts, XML, XSLT, HTML, DHTML, Alphablox, WebSphere Application Developer (WSAD), WebSphere Application Server (WSAS), Design Patterns (MVC, DAO, DTO)

Responsibilities:

• Develop and maintain scorecard application.
• Perform code reviews and develop re-usable object library.
• Mentor junior developers.
• Contribute to the software development standards.
• Scorecard Application
• Scorecard Data Entry System
• Bulk Email System