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, 201220 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 Analysis Services (SSAS) 2000, 2005, 2008:4 Years Experience(4/2014)
• MDX query development
• Installation, configuration, and troubleshooting
• Cube development and performance tuning Reporting Services (SSRS) 2000, 2005, 2008, 2012:4 Years Experience(4/2014)
• 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:

Web Technologies: ASP.NET14 Years(10/2017), ASP.NET MVC11 Years(10/2017), Java Server Pages (JSP)2 Years(5/2004), Java Struts (MVC)2 Years(5/2004), JavaScript/jQuery12 Years(10/2017), XML, XSLT13 Years(10/2012), HTML, XHTML22 Years(10/2017), Classic ASP13 Years(7/2009)

Programming: APEX, SOQL6 Years(10/2017)

Transact: SQL20 Years(10/2017), MDX5 Years(7/2013), C#.NET, VB.NET14 Years(10/2017), Java, J2EE2 Years(5/2004), Visual Basic 4, 5, 6, VBA10 Years(7/2008), Visual Basic 4, 5, 6, VBA10 Years(7/2008), Salesforce (Salesforce.com/SFDC/Force.com)6 Years Experience(10/2017)

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, Salesforce Connect), APEX (classes, triggers, batch classes, schedule classes, test classes)

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: 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 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: .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 Consultan

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.
• Ad Profitability Dashboard
• Proposal Generator Web Application

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.

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.

Confidential, Addison, TX

Sr Consultant

Tools: SQL Server 2000, SQL Server 7.0, DTS, Visual Basic 6.0, VBA, ADO, COM+/DCOM/MTS, VBScript, Javascript, Microsoft Remote Scripting, Visual Studio, Visual Source Safe, Visio Enterprise, XML, XSLT, HTML, DHTML, Crystal Reports

Responsibilities:

• Support small to medium sized businesses in the areas of IT strategy, server and desktop support, software support, software development, database design and development, database performance tuning, website and web application development, security reviews, and disaster recovery.