J. David Sides, MCSD

Certifications, Experience, Affiliations

5211 Pacific Concourse Dr. #1426
Los Angeles, CA 90045
Phone Number: (949) 510 - 0946 mobile

Email: dsidesva@hotmail.com

CERTIFICATIONS
 MCP # 1668461
Microsoft Certified Professional (MCP) since 1999

Microsoft Certified Solution Developer (MCSD) for Microsoft .NET, December, 2004

Certified: Developing and Implementing Web Applications with MS C#, March, 2006

Certified: Developing and Implementing Windows-based Applications with MS VB .NET, February 2004
Certified: Developing XML Web Services and Server Components with MS VB.NET, July 2004
Certified: Designing and Implementing Databases with MS SQL Server 2000, September 2004
Certified: Developing and Implementing Web Applications with VB.Net, November 2004.
Certified: Analyzing Requirements and Defining Microsoft .NET Solution Architectures, December 2004

Microsoft Certified Solution Developer (MCSD), May, 2001
Certified: Visual Basic 6.0, November 1999
Certified: Distributed Applications, January 2001
Certified: Analyzing Requirements and Defining Solution Architectures, March 2001
Certified: Designing and Implementing Web Solutions with Microsoft Visual Interdev 6.0, May 2001

Recent Additional Training
  • Completed MS SQL 2005 training course presented by QuickStart Intelligence
  • Completed certificate course training in SOA Enterprise Architecture Design Methodology presented by Developmentor Corporation.
  • Completed C# development certification course presented by Developmentor Corporation.
  • Completed MS Project Training presented by Learning Tree.

SKILLS
C# 2003/2005
ASP.NET 2003
Visual Basic .NET 2003
Enterprise Services/COM+
MS SQL Server 2005/2000/7.0 
    Design/Development/Maintenance
XML 4.0
Visual Basic 6.0/5.0/4.0
Microsoft Transaction Server 
Visual Interdev 6.0
C++
Crystal Reports
MS Access 95/97/2000
MS Access 95/97
MS Project

AFFILIATIONS
Orange County DotNet Users Group


EXPERIENCE
Senior Professional Applications Developer (15 years experience)

11/2007- Present Kinecta Federal Credit Union, 4400 Rosecrans, Manhattan Beach, CA

Lead Application Developer

4/2007 – 6/2007 LaSalle Bank, 15621 Red Hill, Suite 200, Tustin, CA 92780

Senior Software Engineer
Software engineer for the CDO Suite application, the core application for LaSalle CDO Trust Operations. Design, build, and deploy C# applications to support Chicago based CDO traders using the CDO Suite application and the CDO Suite database. Additionally, support ASP modifications to the CDO Suite application.


4/2003 – 4/2007
 
IndyMac Bank, 3 Banting, Irvine, CA 92618 

Senior Programmer Analyst. 

Technical lead for three other analysts.

  • Designed conversion of the Home Lending Servicing division point of sale application (which is currently a two-tier desktop application) to an n-tier distributed application written in C#.
  • Designed a web-based interface to implement the Personalized Credit Card project. The application will introduce prospects and customers using the company web site to the Personalized Credit Card feature. The C# application will present marketing materials, authenticate customers, and handle the redirect to and from the vendor site where the images are created and processed.
  • Led the conversion of Framework 1.1 production applications to Framework 2.0
  • Designed/Developed/Deployed prototype IMXCampaign, 3 tier desktop member of the IMX family of applications, to allow Servicing Division Marketing personnel to process marketing campaigns where the source documents are comma delimited text files. Replaces a DTS process currently in place.
    • Vb.net
    • Web Service
    • COM+
    • SQL Server 2000
    • Features
      • Highly interactive interface
      • Table driven business logic
      • Reports milestones throughout a campaign import operation
      • Returns plain-language process and error messages during processing
      • Permits intermediate abort of campaign import process if required
      • Table driven design can accommodate future changes to input media without modifying application
      • Completely stateless business and data components, deployed in web server/ COM+ clusters.
      • Reusable IMXService web service/COM+ middle tier receives and returns typed data objects, and is employed and extended by this and other members of the IMX family of applications
  • Designed/Developed/Deployed IMXAdministrator, an n-tier ASP.NET member of the IMX family of applications, which automates routine marketing database tasks. Former process required DBA assistance.
    • Features
      • Intranet based for easy deployment to remote desktops across U.S.
      • Simple interface can be used by non-IT personnel with only minimal training.
      • Reusable IMXService web service/COM+ middle tier receives and returns typed data objects and is employed and extended by this and other members of the IMX family of applications streamlines data access
      • Extensible design, easily adaptable to new business processes.
  • Recently participated in the development of the Lead Relations Manager application, an n-tier ASP.NET application, a member of the ICLAS family of applications.
    • ASP.NET
    • Web Service
    • COM+
    • SQL Server 2000
    • Features
      • The application organizes leads based on selectable criteria.
      • Displays essential loan information in grid and JavaScript popup formats.
      • Tracks contacts by loan consultants,
      • Permits management personnel to reassign loans as needed
      • Dials leads with an in-application dialer
      • Makes appointments
      • Automatically reassigns appointments as required.
      • Completely stateless components, deployed on Web server / COM+ clusters.
      • Extends existing DataSubSystemWebSevice web service application to stream-line data access.
  • Recently participated in the ICLAS Lead Management project, a family of four applications, which collectively provided real-time response to web-originated applications.
    • Co-designed the physical architecture of the HowHearService, which became the prototype for all web services designed in the system thereafter
      • Features of middle tier
        • Web Service middle tier accepts and returns typed data object arrays.
        • Web service is a pass-through to COM+ components.
        • Completely stateless COM+ data access components for cluster deployment
        • COM+ transaction management that updates three databases in single distributed transaction.
        • A single data access component for all connections.
        • Extensive use of serializable data objects with inheritable base components
      • Applications built during project
        • HowHear Manager, an n-tier vendor management application that serves 8 web pages.
          • Features
            • Stateless web application
            • Windows, role-based authentication.
            • Interactive grid to facilitate common modifications to records
            • Manages data in three databases.
        • Lead Importer Service, a Web Service used vendors and internal users to process mortgage leads into the lead management database
          • Features
            • Receives MISMO standard vendor XML string containing application information either through a post to an ASPX page or as a string to a web service method.
            • Uses SSL for data security.
            • Uses basic authentication on external servers for vendors. (Kerberos authentication on internal servers.)
            • Deserializes xml, validates data, updates 8 tables in single transaction in two databases, and returns a response in under one second, well within design limitations.
            • Reuses and extends the DataSubSystemWebService and the HowHearService middle tier (members of the ICLAS family) for simplified maintenance.
            • A duplicate lead identification system prevents double billing.
            • Leads can be dialed within 5 minutes of receipt.
            • Load tested to 200 simultaneous users and 5000 consecutive users.
  • Support developer for extensions and modification to the Loan Comparison tool, an n-Tier addition to the ICLAS family of applications. This application is a selling tool which presents comparable loan scenarios to the Loan Consultant to assist in selling products, and produces customer offer letters for each of the scenarios.
  • Additionally, act as Loan Origination System (LOS) support analyst for the Automated Appraisal Ordering System, supporting maintenance of the three-tier proprietary marketing/lead management system in VB6/COM+/SQL2000.
  • Previously, served as member of the development and implementation team for the Automated Appraisal Ordering Implementation project.
    • Architected and implemented Appraisal Ordering application, which allows
      • Features
        • Loan Consultants can place their own appraisal orders
        • Automated appraisal review of 90% of all appraisals
        • 2 user interfaces for Loan Consultants and Processors
          • "Followup", a C++ application,
            • Presents an appraisal order interface
            • Displays an order status web page.
            • Displays automated update of appraisal status from vendor
          • "Gallagher", proprietary LOS interface
            • Presents an preliminary order interface for automatic retrieval of AVM and public records
            • Appraisals can be downloaded as PDF files.
        • MTS and later COM+ components deployed on clustered servers for faster processing and simplified maintenance used by both Followup and Gallagher.
        • Triggers record updates to appraisal related data.
        •  Multi-thread batch application runs on the ˝ hour throughout business day to submit appraisal data updates to appraisal vendor for open orders.

5/2002-4/2003 American Benefit Mortgage, Inc., 120 Columbe, Suite 600, Aliso Viejo, CA 92656

Lead Programmer/Project Manager for the ABM Management Console, a mortgage company lead management and loan origination system. 

  • Co-designed and solely coded the ABMConsole, a 3-tier mortgage lead management system.
    • Visual Basic 6.0, Windows 2000
    • SQL Server 2000
    • COM+
    • Features
      • Tracks new prospects from the first call through loan funding. 
      • Provides programmatic control of lead marketing data
      • Paperless, time-stamped lead tracking by loan officer, by team, and by division. 
      • Provides automatic lead assignment and reassignment (via MS Access Server scheduled process)
      • Restricts views of leads by loan officer,
      • Allows manager controlled lead reassignment
      • Produces payroll data and "snapshot" management reports. 
      • Enforces federal Home Mortgage Disclosure Act (HMDA) rules regarding the collection of required applicant information. 
      • Provides user links and two-way data integration between the core SQL Server data management system and existing marketing and third party loan origination and document systems (including Calyx Point), and proprietary payroll systems. 
      • Submits credit information to a credit reporting company and retrieves on-line credit reports from them via a developer-designed one-button, XML based web service. 
      • The ABM Management Console is designed to allow the company to take advantage of state of the art user software as it becomes commercially available while maintaining paperless control of the data generated and used by those systems in the company SQL Server database.
      • All rollout milestones were met and each version of the application rolled out on time. 
  • Additionally developed automated MS Access reporting tools for use by the business office to streamline some reporting that had previously been done by hand.  Design changes and bug tracking records are
    maintained in an MS Access database.


3/1999 – 11/29/2001 Advanced Technology Systems, 7915 Jones Branch Drive, McLean, VA 22102

Systems Analyst.

  • Member of the WHISARD project, Wage and Hour Support Division of the Department of Labor
    • Gather requirements
    • Design, test, and implementing new features in Delphi 4.0/6.0 and Quick Reports for the Wage and Hour Support Division (WHISARD) application
  • Previously, report developer in Delphi 4.0 and Report Builder Pro using SQL accessed data from the WHISARD database, a 10 gig. Informix database.
    • Developed and maintained a two tier report utility application until the application was retired.
      • InfoPower
      • WPTools third party controls ,
      • Numerous custom controls, and
      • Star Team version control software.
  • Jointly converted WHISARD to Delphi 6.0 with one other team member.
  • Submitted a high-level design for parallel development of an n-tier version of WHISARD that incorporates both a form-based and browser-based user tier, and moved business logic to COM+ based DLLs in stages.
  • Selected to give final round technical presentation for large competitive bid Federal Aviation Administration contract, which was awarded to the company.
  • Formerly, Lead programmer on Clipper 5.2 and Visual Basic 5.0 maintenance projects for the Department of Housing and Urban Development.
    • The Visual Basic 5.0
    • MS Access database, component deployed on hand held computers used by housing inspectors.
  • Results were ported to a central RDM server upon the inspector’s return.

4/1994 - 3/1999 GCI Information Services McLean, VA 22102

Systems Analyst

  • Lead developer for Patentin, a desktop Clipper 5.2/Fivewin (a WIN 3.1 GUI development environment), multi-user application for the Patent and Trademark Office
    • Features
      • Create a genetic sequence listing for genetic patent applications filed with the US Patent and Trademark Office.
      • Presented a custom designed, built-in sequence editor that could handle 10-million characters.
    •  The application was posted as a download on the USPTO.GOV website and overnight email user support was provided until the application was retired.
  • Developed parts inventory data management applications for the Department of the Navy, USS Sea Wolf project.


8 years experience in motor vehicle finance and leasing.

EDUCATION
University of Arkansas - Fayetteville, Arkansas
Bachelor's Degree BSBA Administrative Management
Minor – Chemistry; additional coursework - Finance/Accounting

Previous Training and Experience
12/1999 Ciber Learning Center US-VA-McLean Certification Microsoft Certified Solution Developer "Mastering" series course work, with the Visual Basic 6.0, the MS SQLServer 7.0 database, and Visual Interdev 6.0 options, leading to MCSD certification. Passed Visual Basic 6.0 desktop exam, Visual Basic 6.0 Distributed exam, Analyzing Requirements and Defining Solution Architectures exam, and Design Web Solutions with Visual Interdev 6.0. Certified as a Microsoft Certified Professional (MCP) November, 1999, and as a Microsoft Certified Solution Developer (MCSD) in May 2001.


U.S. Navy Tactical Jet Flight Training . Served active and reserve naval service as pilot and intelligence officer.

AUTHORED WORKS
Franklin's Caveat, copyright 1998
Memory, copyright 2000
In the Temple of Apollo (draft), copyright 2007