TECHNICAL SKILLS:

Platforms: Salesforce Sales Cloud, Service Cloud, Force.com, .Net, Java

Programming: Apex, Visualforce, SOQL, SQL, C#, VB.NET, SOAP, REST, JSON, XML, T - SQL, PL/SQL

Industries: Sales, Consulting, Retail, Financial, HR, Construction, Educational Software, Trust Administration, Software, Insurance, Oil and Gas, Chemical.

Architecture: Web and client-server application architecture, database architecture, SaaS, SOA.

Data modeling: Erwin, Logical, Physical, very large data models.

Database: Microsoft SQL Server, Oracle, ETL, SSIS, MySQL, JDBC, ADO, ODBC

Web: ASP.NET, JSP, JavaScript, AJAX, HTML, ASP, XML, CSS, IIS, Apache, Tomcat, Forte, JDBC.

Methodology: Agile, Scrum, XP, TDD

PROFESSIONAL EXPERIENCE:

Confidential

Salesforce Technical Architect

• Responsible for full life-cycle development of several applications including an improved sales forecasting system and an improved quote system.
• Developed many smaller systems using Visual Force, Apex, SOQL, triggers and javascript.
• Implemented an integration with CPQ (a third party quoting tool) using SOAP.
• Used Jitterbit to transform and load large datasets
• Managed offshore developers in Ukraine and Argentina.
• Refactored over 50,000 lines of code to handle problems like indeterminate order of trigger execution, recursive trigger execuction, poorly written code, meaningless and fragile test classes and constant problems with governor limits.

Confidential

Salesforce Technical Architect / Project Manager / Technical Sales

• Cambria - Developed a Partner Portal and Online Ordering application for the largest stone countertop manufacturer in the US. Used OAuth to provide single sign on. Used DBAmp to allow existing .Net applications easy access to Salesforce data and to allow SSIS to connect to Salesforce for ETL operations.
• City of San Francisco - Migrated the city’s official forms to Salesforce so residents can fill them out online and get follow up communication and PDF receipts through Salesforce.
• British Columbia Lottery Corporation - Developed a Portal that allowed users to submit proof eligibility to gamble and automated tools for verification.

Confidential

Database Architect

• Used SSIS to load very large flat file data sets on an hourly basis.
• Assisted in cube design and writing MDX queries
• Used the Scrum agile framework to give stakeholders a regular view of the current progress and an opportunity to make periodic adjustments to the course of the project.

Confidential

Salesforce Developer

• BACR - Developed an online application and volunteer matching for AmeriCorp.
• Future US - Developed an online Ad Impression Management and billing system.

Confidential

Project Manager/ Database Architect/ Chief Architect

• Managed project from business requirements analysis through production deployment.
• Estimated cost, time and team requirements and managed $700,000 dollar budget.
• Hired and managed a team of 4 on-shore developers and 10 off-shore developers in India.
• Worked hands-on with developers to help improve their programming technique, solve problems and ensure that we delivered high quality code using iterative development.
• Established processes for change control, off-shore and on-shore testing, source control, and bug tracking.
• Bridged communication between business users, IT management and developers.
• Architected a data model that provided excellent performance for both the application and reports.
• Architected a multi-tier .Net WinForms application satisfying key requirements of usability, extensibility, performance, and maintainability. The feedback from the manager in charge of maintenance is that she and her developers consider the application to be very easy to maintain and enhance and the users consider the application to be high performing and easy to use.

Confidential

Project Manager/ Database Architect/ Chief Architect

• Developed new business process by interviewing domain experts and application prototyping. Continually worked with customers to determine business strategy and product direction.
• Analyzed business requirements and developed initial set of use cases.
• Made engineering oriented presentations to investors, customers and business partners.
• Hired and managed a team of four developers.
• Evaluated and selected software development tools for source control, bug tracking, and project management.
• Developed long term architecture requirements and provided oversight and technical leadership on product analysis and design.
• Developed multi-tier architecture and framework during initial release of .Net.
• Coded at database, business and web layer using VB.Net and ASP.Net.
• Built plug-and-play technology components such as mail, PDF, Excel and digital signature interfaces.
• Developed the data model for the entire application (160 tables) using Erwin.
• Evaluated automated testing tools; and developed and reviewed test scripts developed in Rational Robot.
• Developed majority of the stored procedures using T-SQL.
• Loaded SQL Server database from various ODBC sources using DTS.
• Developed data, business and presentation layer using VB.Net, ASP.Net, ADO.Net and JavaScript.
• Managed and participated in integration and acceptance testing.
• Automated load testing process and helped in performance tuning.

Confidential

Project Manager/ Database Architect/ Analyst Consultant

• As project manager, database architect and developer, built a client-server trading and account management system. The trading system is now a core business tool that is used to manage portfolios and optimize trading for accounts totaling more than 2 billion dollars.
• Developed an income estimation web site that allows potential donors to see what their projected income would be depending on various parameters like gift amount, trust payout rate, investment objective, age, etc. Primary responsibilities included writing functional specification and “use case” scenarios, and then developing an object model and data model with BpWin and ErWin.
• Developed enterprise-wide data model consisting of over 150 tables using ErWin and implemented it on SQL Server 6.5 and 7.0. Documented nearly every column in every table. Wrote T-SQL stored procedures and triggers to provide row level security and improved performance, and to enforce data integrity constraints and business rules. Modeled and coded parts of the data layer in Visual Basic. Helped other programmers optimize their database access by using stored procedures, better index design, better query syntax, more efficient ADO techniques, forced join plans, etc. Helped solve concurrency control and locking problems.
• Wrote parts of the functional specification and helped technical writer develop user documentation.
• Developed web interface allowing clients to view trust information using ASP, SQL, COM+ AND ADO.
• Synchronized various ODBC data sources with SQL Server database using DTS.
• Helped CIO of company with developing corporate strategic direction at both a business and technical level.
• Trained junior Database Administrator in SQL Server administration.