Customer Service Sql Server

Andrew Clifford

Devon, PA *****

610-***-**** (Cell)

abmjc3@r.postjobfree.com

Skill Set:

Roles: Java Developer, Technical Lead, Java Architect, Technical Project

Manager, DBA, Mentor

Languages: Java (11+ years), SQL

Frameworks: J2EE, Springframework, Hibernate, JSF, GWT (2 years), Weblogic

Portal, Websphere Portal, Struts, Spring-MVC, Ant, Maven, JUnit, ActiveMQ,

Lucene, HttpUnit, Spring Security (acegi), Axis, JSON

Tools: Eclipse, Rational Software Architect, UML (Whiteboarding), Visio,

ERWin, SoapUI, Hermes, Websphere Studio

Documentation: Functional Requirements, Project Plans, Use Cases, High-

Level/Detail Designs

Application Servers: WebLogic, Websphere, JBoss, Tomcat

Databases: Oracle, MS-SQL Server, Sybase

XML: WSDL, XSLT, XSD, REST

Certifications: BEA WebLogic 7.0 Certified Specialist: Server (J2EE

Certification)

Objective:

Deliver service and user-oriented applications for medium to large-scale

development projects. Contribute to all phases of the development process.

Introduce new technologies to meet functional and nonfunctional business

objectives. Work with deliverable focused teams.

Work Experience:

Java Architect, Comcast, 3/2009 - Present (CEI America 3/2009-6/2009)

For Comcast Strategic Business Support Services, produced high-level and

detail designs of features targeted to a WebLogic, Struts, Hibernate,

Oracle, AquaLogic, and WLI environment. Designed, developed, and integrated

a GWT modules into a legacy CRM/Order Management application. Designed and

prototyped SOAP services to support complex product provisioning.

Developed batch processes leveraging JMS for concurrency. Worked with

solutions architects, enterprise architects, business analysts, and

developers on a daily basis to produce comprehensive and requirements-

traceable designs.

Java Web Architect, Planalytics, Inc., 9/2007 - 1/2009

For a business intelligence content provider, designed and developed web

application features to simplify access and understanding of the company's

cube-based reporting products leveraging Oracle, JSF, Quartz, GWT, Spring,

ActiveMQ, and JMS messaging technologies. Introduced service-orientation,

portal, content management, and a content publishing metaphor to drive a

publication-oriented business process. Worked with business owners to

convert strategic ideas into working prototypes.

Architect/Technical Lead, Citi Prepaid Services, a Citigroup company

(formerly Ecount), 8/2004 - 8/2007

Managed a group of 8 developers as a technical lead, architect, and

developer to drive new product and feature development for various

marketing and new business initiatives. Migrated legacy applications to a

new web application and services platform architecture using WebLogic

clusters, MS SQL Server, Struts, and Spring. Introduced Maven, Axis,

Spring Security (Acegi), Hibernate, and JBoss into the enterprise stack.

Acted as a liaison between developers and product analysts to help

prioritize project tasks for successful delivery. Instituted daily SCRUM

meetings and facilitated test-driven practices. Fostered frequent

whiteboard UML design sessions and open communication. Focused on fitting

team member capabilities and skills to tasks to ensure individual and

project success. Took personal responsibility for development and delivery

of high-risk projects and applications.

WebLogic Consultant, Anexinet Consulting, 4/2004 - 7/2004

For CitiGroup, New York, as a BEA Portal specialist, developed a migration

strategy from WebLogic Portal 7.0 to 8.1 for a globally distributed systems

monitoring application. For VWR International, a pharmaceuticals equipment

supplier, resolved application availability issues as a WebLogic

performance and tuning specialist. For Radian Guarantee, developed an

automated WebLogic server and Portal application deployment process.

WebLogic Portal Consultant, Alliance Consulting, 12/2003 - 3/2004

For McNeil Pharmaceuticals, designed, prototyped, and deployed a FDA

regulatory compliance portal and portlets using WebLogic Portal 8.1.

Portal development included the extension of existing navigation features

to reflect McNeil's dynamic corporate structure and the portal's potential

migration/integration to the parent company portal of Johnson & Johnson.

Senior Java Consultant, CapTech Ventures, Inc., 6/2002 - 12/2003

For Campbell's Soup, designed and deployed a custom document management

service and accompanying portlet application using WebSphere Portal Server.

The backing service incorporated hierarchical XML metadata, JAXB data

binding, and Lucene text indexing to support document searching.

For Capital One Financial, designed a high-performance query service that

concurrently queried up to 24 data sources, each consisting of up to 200

million rows while meeting a one second response time SLA. The result was

used as input into a credit application decisioning process. The system was

able to meet its performance SLA by leveraging JMS queues, WebLogic 6.1,

EJB Session Beans, JAXB XML data binding, and DB2 mainframe data sources.

Additionally, acted as an architect to produce high-level and detail design

documents in an initiative to refine Capital One's architecture and design

methodology as a prerequisite for offshore development.

For an energy company, developed a B2E portal using WebLogic 7 Portal

Server. Migrated a legacy site's look and feel into portal stylesheets.

Migrated various legacy web application features and use cases to the

portlet environment. Authored a white paper on portal operational use

cases.

J2EE Architect, Scient, Inc., 5/1998 - 5/2002

For the Colgate Darden School of Business at the University of Virginia,

acted as J2EE architect and technical lead to web-enable admissions, class

registration, and career service systems as a product offering to other

schools. Conducted technical analysis and design sessions before

implementation of a J2EE server application suite that could be operated as

an ASP or installed at a purchasing school. Using Struts, Websphere, and

SQL Server 2000, the suite incorporated over 600 unique JSP pages and

Struts actions interfacing with stateless session business services. EJB

CMP entity beans were used almost exclusively with some optimized database

queries for performance critical use cases. To reduce long-term cost of

ownership, made extensive use of portable MVC and EJB design patterns and

frameworks. Personally designed and developed a highly customizable

Struts-based online admissions module leveraging dynamic forms. Developed

custom code generators to speed development time of templated Struts and

EJB objects. Produced EJB session and entity beans and web application

prototypes.

For the Mayo Clinic, led a development team to architect, design, and

implement www.mayoclinic.com, a medical information portal. Designed a

high-performance publishing system that allowed a group of non-technical

editors to proof and promote new medical articles, and stage and publish

daily site editions to over 100 configurable pages featuring over 5,000 XML-

based content pieces. Designed and developed a content templating system

incorporating custom XML DTD designs and XSLT transformations for all site

content supporting several article styles and syndication. The application

was deployed to a high-availability WebLogic 5.1 cluster architecture using

iPlanet, Oracle 8i, Oracle Intermedia, BigIP, and Interwoven Teamsite on

Sun Solaris. The site received over 9 million page hits in its first month.

For GE Supply, General Electric's electrical and lighting sales division,

designed and developed the www.motordirect.com e-commerce web site.

Integrated an existing product catalog and fulfillment center into a custom

Cold Fusion-based e-commerce web application. Produced the site in two

months. This won recognition for the client at GE's divisional summit as

one of the first divisions to have a new site operational after Jack

Welch's "go to internet" mandate. Used PGP, Cybercash payment system, and

Verisign SSL certificate encryption to securely transmit credit card data

to a fulfillment center.

For Scient, initiated and developed marketing materials for a new

consulting service product targeted towards web site refacing proposals.

The service included standardizing site style guidelines, separating site

content from presentation using XML and XSLT, and recommendations for

content management services. The client would be presented the reduced

maintenance costs of XML-based content updates, as well as, global XSLT and

CSS styles changes. A demonstration was developed presenting a site

supporting English, French, Spanish, and Korean content. All languages were

supported in one XML document reducing maintenance costs. The

demonstration was produced using Apache Tomcat, Xerces XML parser, and

Xalan XSLT engine. XMLSpy was used for DTD design.

For Philip Morris, Inc., developed a Java Swing-based MVC client framework

that integrated with several CORBA services in order to build laptop-based

applications to be deployed to all Philip Morris, Inc. field sales force

and marketing departments. The systems were developed using Java JDK and

Swing, Iona OrbixWeb CORBA middleware, and Oracle RDBMS. Framework

features included data-driven validation and a pluggable business rules

engine.

For First Union Bank, Charlotte, coordinated technical research and made

recommendations for a Yahoo-style shopping service and accompanying portal

services targeted towards 10 million bank customers as part of a venture to

produce a mega banking/shopping portal. Conducted a review and recommended

a J2EE portal architecture integrating content management, e-commerce, and

CRM systems.

For MyFavoriteShoe.com, acted as technical lead in the design and

development of the online shoe store. This start-up focused on offering

state-of-the-art personalization services and customer service features.

The site was built using ATG Dynamo e-commerce and personalization services

and Oracle on Solaris. Efforts included focusing primarily on CRM engine

implementation linking product, customers, and marketing campaigns.

Sybase DBA, CarMax, Richmond, VA, 7/1995 - 5/1998

Led a team of 3 database administrators supporting the operational

performance of all corporate and store Sybase OLTP and decision support

databases on HP-UX Unix systems. Managed all schema modifications made to

production databases. Acted as Unix system administrator for HP-UX.

Designed and presented an Internet-based inventory browser applet developed

using Java 1.0.2 JDK as a proof-of-concept to web-enable legacy systems.

Senior MIS Analyst, Circuit City Stores, Inc., Richmond, VA, 5/1993 -

7/1995

Designed and developed a client/server application to track all corporate

legal matters for corporate and human resource legal departments.

Developed various in-house applications using MS-Access and SQL Server

including a system to manage inventory and shipping logistics for all store

openings. Acted as MIS liaison to marketing and merchandising departments.

Foxpro Developer, Eurocard International, S.A., Waterloo, Belgium, 7/1992 -

8/1992

Developed a client/server statistical reporting application producing daily

credit card chargeback activity for Eurocard's legal department. The MS-

Foxpro application queried an AS/400 server and produced statistical

reports.

Education:

MS - Management Information Systems, McIntire School of Commerce,

University of Virginia

MBA, Babcock Graduate School of Management, Wake Forest University

BA - History, Hampden-Sydney College

Certifications

BEA WebLogic 7.0 Certified Specialist: Server, 12/2002

Contact this candidate