Jake Eldridge

Software and Systems Engineer, Architect and Analyst

Experience

• Defined and designed architectures, object models, frameworks, and database schemas (physical and logical) for a customer facing web application providing advanced searching and analytics of a very large media database containing hundreds of millions of multimedia objects including images, audio, video, .doc, and .pdf files.
• Coded AJAX enabled ASP.NET web pages and controls; C# APIs and libraries; and TSQL scripts, stored procedures and triggers.
• Designed and coded a windows service to perform ETL sourcing data from a warehouse using SOA, SOAP web services, OOA/D, ER data modeling, UML, C# and SQL server.
• Designed and coded a windows service in C# to automate document email and fax distribution consuming a vendor's SOAP web service.
• Led a team of 17 to improve system capacity, scalability, performance and response time.
• Defined CLR, database and server profiles and metrics to be collected.
• Analyzed profiles and load test results to identify and remove bottlenecks.
• Optimized: client and server side code (C#/Javascript/HTML/CSS) and architectures (AJAX/denormalization/Service Broker); database queries and updates; caching; web and database server configuration; and Viewstate and session persistence.
• Coded multithreaded web pages and search functions
• Automated builds and unit testing using Cruise Control, TFS and Visual Studio test manager.
• Defined build and deployment processes for QA, UAT, load testing and production.
• Defined and enforced standards for test driven development, OO design, queries and coding.
• Created policies and processes to support offshore development in Moldova.
• Worked with sales and customer support to perform triage and troubleshoot bugs, performance and scalability problems.

• Provided software, database and system architectures, code and solutions for:
• Reporting on M&A integration of Oracle, Sybase, DB2/400 and Peoplesoft contract, claims, enrollment, billing and accounting systems.
• M&A migration of underwriting operations from VB, Sybase to Oracle Forms systems.
• Auditing application access using C#, LDAP, ADSI, Sybase and Oracle.
• File transmissions to banks and customers using C#, kshell, PGP and FTP.
• Led a team of 20 to audit and balance M&A integration of contract, claims, enrollment, billing and accounting systems. Worked with dozens of business unit supervisors and technology providers to account for every penny of over $100 billion in financial transactions.
• Provided architecture to mass load Excel documents into a J2EE, Weblogic, and Oracle document management system.
• Managed four direct reports supporting migration of claims systems including their feeds for data warehouses, accounting systems, banks (EFT and positive pay) and clients.
• Migrated user accounts for multiple claims systems translating hundreds of Active Directory accounts, MS Exchange folder ACLs and MS Exchange accounts across domains.
• Identified source system transactions during data warehouse outage for SEC audit.
• Provided tax (1099, W2, 941), legal and ad hoc reports from Oracle databases.
• Defined border network firewall packet filtering rules for M&A system migration phases.
• Defined, implemented and enforced SOX, COBiT and ISO 17799 policies and procedures.
• Defined requirements for business and system continuity and disaster recovery plans.

• Selected platform and defined architecture for a system interfacing RFID hardware, J2ME mobile devices, .NET web service applications and specialty medical hardware.
• Created UML diagrams defining system components, communications, processes and protocols.

• Integrated separate claims systems to single distributed OO, n-tier architecture using VB, DCOM/DTC/COM+ and Oracle. Coded user controls, screens, APIs and stored procedures.
• Documented existing and proposed architectures using UML and ER diagrams.
• Defined object models and interfaces for core system components.
• Led sessions with SMEs, BAs and developers to define and refine system UI and functionality.
• Performed project management duties of task definition, estimation and assignment.
• Authored technical specifications defining policies, solutions, frameworks and architectures.
• Rearchitected and refactored application security combining disparate components and classes into a single component with a simple interface.
• Vetted and integrated vendors' software products including UI controls and fax servers.
• Reviewed technical specs, solutions and code to insure compliance with policies, security standards and architectures.
• Performed information assurance audits throughout SDLC.
• Consulted for compliance of claims and contract systems with business regulations (HIPPA, OFAC) and information assurance standards (COBiT, ISO 17799).

• Defined architecture for a web restaurant portal using ASP.NET and C#.
• Authored technical specifications modeling classes and tables using UML and ER diagrams.

• Designed and coded a CRM system automating customer emails using UML, ER modeling, OOD, ASP, IIS, VB, MS Exchange.
• Built ecommerce software using UML, IIS, ASP, VB, COM, SQL Server and Cybercash.
• Vetted credit card processing vendors and integrated on line transaction processing with ordering, business, accounting and fulfillment systems.
• Defined and enforced security policies and procedures for web applications.
• Audited software systems for compliance with architectures; security standards; and service agreements with vendors and customers.
• Performed system administration, capacity planning, stress testing and tuning of queries, code, databases, web and application servers.
• Documented system connectivity to provide packet filtering rules for firewall administrators.
• Authored business impact analyses and risk assessments for web hosting and credit card processing.
• Consulted with managers on project management, adaptation of new technologies, change control, purchasing software packages and software development and deployment procedures.

• Provided data architecture and project plan, identifying dependencies, resources, tasks and costs, for migrating applications from Apache/Jrun to Websphere and integrating M&A systems and purchased software packages.
• Evaluated and recommend vendors, packages and products for J2EE application server, source code control, content management, rule based personalization and CRM.
• Created ER and UML diagrams to document system architectures and integration with M&A systems and purchased software packages.
• Defined policies and procedures for web publishing and software development and deployment.

• Designed ETL and data mart/DSS used for scheduling print jobs and machine maintenance.
• Created system and database architectures to port VB, Access desktop software to networked client-server enterprise architecture using VB, Citrix, Oracle and Solaris.
• Performed capacity planning and benchmarked data access methods and database drivers.

• Defined system, software and data architectures for a UPC data mart using VB, Oracle and Solaris. Threaded database updates with a VB ActiveX out of process server.
• Authored and coded screens, APIs and PL/SQL stored procedures.
• Led design meetings with business users to create technical specs from functional specs.
• Performed system and query tuning for very large database (1TB+, billions of records).

Associations and Memberships

• Architected, coded and implemented CMS using UML, LAMP and shell scripts.
• Apache and Linux hardening, configuration and administration.
• Administered and configured LAN and DMZ using TCP/IP, Cisco PIX Firewall and Ubuntu.
• Coded shopping cart for art exhibition using ASP and Verisign Payflow.

Education