SQL o Database Microsoft SQL Server 2000 and 2005 Sybase Adaptiv

Jacob Lloyd

Kirkland, WA

*****.***@*****.*** (email)

http://www.linkedin.com/in/jacoblloyd (linkedin)

OBJECTIVE: Continue to develop and grow my technical skills, knowledge, and expertise as part of a collaborative technical services team.

CAREER HISTORY AND EXPERIENCE:

Level11 \ Synapse 2014 – Present

oSenior Software Engineer

Mustard Gain Inc. 2013 – 2013

oSenior Software Engineer (Contractor)

Walt Disney Company (Disney Technology Solutions and Services (DTSS), Seattle, WA 2005 – 2013

oSenior Software Engineer

Customer Solutions and Tools (CST) Group

Mobile Engineering Group

PhotoWorks Corporation, Seattle, WA 2004 – 2005

oJava Middleware Developer (Consultant)

ShareBuilder Corporation, Bellevue, WA 2000 – 2004

oSoftware Developer, Product Development

Catalyst Corporation, Bothell, WA 1999 – 2000

oComputer Programmer/Analyst (Consultant)

oProduct Development

Serverlogic Corporation, Bellevue, WA 1996 – 1999

oComputer Programmer (Technical Consulting Group)

Boeing Company, Tukwila, WA

Boeing Company, Kent, WA

oComputer Programmer (Product Development Group)

oProduct Support Technician

TECHNOLOGIES, API’s AND FRAMEWORKS:

SQL

oDatabase

Microsoft SQL Server 2000 and 2005

Sybase Adaptive Server Enterprise (ASE) 11.5 - 12.5

MySQL

PostgreSQL

oSkills

Schema design

Transaction managed stored procedures

Query tuning, plan analysis and index utilization and optimization

NoSQL

oMongoDB

oCassandra

Java

oCore Java Tools & API’s

Java API for RESTful Web Services (JAX-RS)

Java Architecture for XML Binding (JAXB)

Java API for XML Processing (JAXP)

Java Servlet

Java Message Service (JMS)

JavaMail

oMiddleware

Spring Framework

iBatis

JBoss Messaging

oWeb Development

HTML

Cascading Style Sheets (CSS)

Knockout \ JavaScript

Apache Wicket

Tomcat

oDevelopment Process & Tools

Bug\Issue\Project Tracking & Documentation

JIRA

Bugzilla

Confluence

Development Tools

Netbeans \ IntelliJ IDEA \ Eclipse

Maven2

ANT

Source Control

Subversion & CVS

Perforce

Continues Integration

Jenkins

QuickBuild

Hudson

Protocols

oTCP/IP Suite

Hypertext Transfer Protocol (HTTP)

Simple Mail Transfer Protocol (SMTP)

Short Message Peer to Peer (SMPP) (sms)

Other Technical Skills and Tools Experience

oSelenium (browser-based regression automation with java junit)

oXSL Transformations (XSLT)

oXML Path Language (XPath)

oUML Class Diagram Modeling

oLinux

Ubuntu

Bash shell

oPowerBuilder

SKILLS AND WORK EXPERIENCE:

Level11 \ Synapse

oWorking on enterprise Java systems for collecting and processing large volumes of data from wearable devices within the parks and entertainment industry (Walt Disney World). The enterprise software development is in collaboration with product development company Synapse.

Mustard Grain Inc.

oSenior Software Engineer (Contractor)

Learning Apache Cassandra and Hadoop

Working in a collaborative, team oriented, agile environment with a group of senior engineers, developing a 'big data' processing application from a mobile data pipeline, utilizing Apache Cassandra and Hadoop.

Using MySQL and PostgreSQL as a data store for location based relational data and geospatial mapping of locational data.

Walt Disney Company (Disney Technology Solutions and Services (DTSS))

oCustomer Solutions and Tools (CST) Group

Senior Software Engineer

Designed and developed REST APIs for transacting with the Disney email suppression system. This project replaced an old FTP\PGP based system with REST API’s fronted with OAuth. Project involved migrating Disney segments and their 3rd party email vendors from the old system and onboarding on to the API based system.

Designed and developed monitoring and email notification system, leveraging MongoDB as the document store with a web based front-end for configuring the system using pure HTML\CSS\JQuery\ KnockoutJS and Restful API's into the back-end doc store using Apache CXF\JAX-RS and Jackson for JSON processing.

Developed half day, Interactive, hands on, teaching seminar on 'Introduction to MongoDB Development'

oInstalling, configuring and running MongoDB

oUsing the MongoDB Javascript shell environment

Administrative activities

Scripting the shell in Javascript

Interacting with your database using the shell

oInteracting with your database using Morphia

Assigned by manager to Disney’s ‘Buddy’ program as an intern mentor.

oMentored intern in designing and developing an integrated web application support platform from the ground up.

Held sprint planning meetings and daily scrum sessions during each two week sprint cycle

Mentored intern on following development practices:

Maven project implementation, techniques and plug-in usage

Standard DAO implementation patterns using Generics, Interfaces and IOC injection with Spring Framework

Designed and developed Apache Wicket based web application leveraging componentized DAO layer

Embedded into other Disney development teams scrum sessions and monthly release cycles in designing and developing product bugs, enhancements and architectural performance improvements

oMobile Engineering Group

Senior Software Engineer

Lead Engineer on high performance messaging system used as the sms messaging platform for Disney products

oESPN SMS sporting alert product

Worked with ESPN’s development and project management teams as the lead engineer for monthly bug and enhancement releases

Developed solutions for bugs, new features and guided architectural direction of platform. Projects included:

Support for multiple languages within sms alerts

Scaled messaging system from 100 ms to 900 ms out to aggregator

Expanded messaging systems support for SMPP protocol for additional features such as return responses, premium (billable) sms and sms aggregator specific extensions

Responsible for setup of development and QA messaging environments

Code reviewed other developers java middleware code, web page changes and stored procedures

Coordinated monthly releases with ESPN development and project management teams

Acted as lead engineer in monthly meetings with 3rd party SMS aggregator

oLead software engineer for Disney and ESPN MVNO products

Setup messaging system and environments for sms features within the MVNO product offering

Worked with 3rd party vendors in nationwide testing sessions, coordinated and oversaw handset testing for product launch

PhotoWorks Corporation

oAs a Java Middleware Developer I was responsible for designing and developing XML messaging framework that supported two aspects of day-to-day business activities:

Connector between legacy and new enterprise systems allowing transactional interoperability

Facilitate third party order transactions

oThe core of the XML messaging frameworks was a large and complex W3C XML schema that defined all business transactions such as creating, modifying and retrieving customer data; creating, authorizing and modifying analog photo orders.

Legacy systems and third party vendors sent HTTP xml based real-time request messages that performed the following tasks:

Validated XML schema request message

Interacted with the JAXB objects to extract XML data

Executed and processed the XML request message for photo order

oProject roles and responsibilities

Software Developer for transactional messaging framework / Build Manager / Deployment Lead

Linux deployment environment for QA and production environments

ShareBuilder Corporation

oSoftware developer on product development team and lead developer for a large transactional based brokerage application

oLead developer on several medium to large projects addressing the needs of the 50 plus brokerage users including broker-dealer, customer care, marketing, and operations

oDesigned and developed several advanced stored procedures and table schema designs

Worked closely with the DBA in index identification and utilization for performance

oParticipated as a developer and lead developer on the following Projects:

Developed file processing and reporting modules for market orders and 3rd party reporting files.

Relational data conversion from relational data to XML to HTML report generation

Maintained and added new FTP and PGP encryption modules

Redesigned brokerage applications library structure into a more understandable, extensible and object-oriented structure

Designed and developed new 401K functionality in support of new website features.

Designed and developed an end-to-end Funds disbursement system allowing for the processing, reconciling, and printing of checks and ACH requests

Designed and developed new Educational Savings Account (ESA) modules.

Trained other developers on programming techniques and standards.

Catalyst Corporation

oWorked as Computer Programmer/Analyst on the sales software product line (SmartQuote).

Worked with team of developers on the maintenance and development of new product features

Developed an application wide dynamic search/sort tool that improved customer interaction with the application

Lead developer on migration of SmartQuote from PowerBuilder version 5.x to 7.x.

Developed and presented an executive/technical presentation on the cost benefit of choosing an Application Server (Sybase EAServer) as the new product path for developing a web based SmartQuote system.

Serverlogic Corporation

oComputer Programmer, Consultant

Worked as part of a product team in developing transactional-based applications both on and offsite using PowerBuilder.

oComputer Programmer, Product Development

Designed/Developed product solutions for bugs, customer enhancement requests and general product maintenance of product line of developer tools in PowerBuilder: PowerLock, PowerObjects and PowerClass

Integrated and supported new graphical controls into security administration tool

oProduct Support Technician

Logged, reported and documented customer issues and concerns.

EDUCATION AND AWARDS:

Bellevue Community College, Bellevue, WA

oComputer Science: Advanced Java Programming 2003

oLanguage Arts: French

Bates Technical College, Tacoma, WA

oAssociate of Applied Science (A.A.Sc.), Computer Science 1994 – 1996

The Boeing Company

oCertificate of Achievement, Information & Communications Systems Outstanding Performance 1998

Contact this candidate