TJ Trapp's Resume

[ download full | download header only | download projects archive only ]

Professional Summary

Experienced in secure application development utilizing Microsoft .Net technologies.  Team leader, motivator and decision maker.  Efficient communicator of technical details.  Ivy-league educated. 

Objective

Provide technical solutions to streamline business processes and enhance system functionality.

Technical Experience

ASP.Net, C#, NUnit, Visual Basic .Net, 6; T-SQL; ADO.Net, XML; Java Script; XSL; XSLT; HTML

·         Microsoft SQL Server 2000, 7.0, 6.5; Microsoft Access 2000

·         Windows 2003 Server, XP Pro, 2000 Server, Pro, NT 4.0

·         Visual Studio 2005, 2003; Visual Basic IDE; Visual Interdev IDE

·         IIS; Enterprise Manager, Profiler and Query Analyzer; Visual Source Safe;  Wise for Windows Installer

---

Relevant Experience

Warner Brothers Entertainment, Inc., Burbank, CA                                           March 2006 - Present

Senior Application Developer

·         Member of Technical Oversight Group

·         Architect / developer of financial application rewrite using ASP.Net 2.0 C#

·         Coded custom business objects that inherit from the CSLA and utilize the Enterprise Library 3.0

·         Full SDLC on a legal rights management system implementing Active Directory authentication

·         Performed object modeling with UML using Enterprise Architect

·         Interface custom application with Oracle Financials

·         Perform break/fix and small enhancements to VB6 applications

·         Create financial reports using T-SQL and PL/SQL, VB6 and Excel

 

Media-Services, Inc., Westwood, CA                                                                Oct. 2005 – March 2006

Senior Programmer

·         Coded a software solution to print 1900 pages of tax forms and saved three man weeks

·         Supported Tax’s 2005 reconciliation process by creating Master Tax CSV import files

·         Developed reporting solutions with Crystal Reports 10 and Visual Studio .Net 2003

 

NBC Universal Home Entertainment, Universal City, CA                            March 2003 – Sept. 2005

Senior Programmer Analyst

·         Programmed client/server application, STAR, in VB6 to forecast revenue, units and costs associated with a movie title

·         Programmed VBA Excel Add-Ins to interface with SQL server and Essbase

·         Created Windows installer package using Wise for Windows installer; package subsequently deployed to over 30 desktops via SMS

·         Responsible for all code changes to shared library modules

·         Created use case, sequence and class diagrams using UML

·         Installed, configured and administrated Hyperion Essbase, EAS, EIS and Analyzer

·         Programmed DAL, BLL, UIControllers and Views in VB.Net for the ASP.Net version of STAR

·         Test driven development using NUnit for all DAL and BLL classes

·         Implemented Microsoft Application Blocks into the ASP.Net web application

·         Utilized designed patterns where appropriate during development of DAL, BLL and business entity objects

·         Engaged clients by organizing sessions to gather requirements and by following up to obtain sign off on generated documentation

·         Created documents to outline business requirements for enhancements and new development

·         Translated business requirements into technical design documents

·         Reviewed design documents with developers to clarify questions related by both business processes as well as technical issues

·         Participated in Sarbanes-Oxley compliance testing

·         Oversaw disaster recovery testing for STAR during the intensive 2 week period process

·         Provided weekly status updates to project sponsors and downstream application teams

·         Trained new contractors on team standards, application coding guidelines, and provided an overview of the shared library modules

·         Conducted bi-weekly peer code reviews between team members

·         Managed contractors on multiple tasks to assist with development and integration testing

 

Bigdevelopment, Costa Mesa, CA                            July 2002 – Sept. 2002

Technical Lead

·         Delivered database architecture and system design for bigdevelopment’s first enterprise-level web application

·         Earned employer approximately $115,000 revenue in 2 months with minor database enhancements

·         Drafted proposals for management on re-organizing team roles and responsibilities

·         Created database architecture, including diagrams with primary and foreign key relationships, indices, views, stored procedures and backup / recovery strategy using Microsoft SQL Server Enterprise Manager

·         Maintained task specific, project oriented progress reports using Microsoft Word, Excel and PowerPoint 

·         Communicated progress reports to clients via collaborative data tools such as Microsoft Outlook 2000 and MSN Messenger version 4+ (and similar tools)

·         Educated non-technical team members and clients on new technologies such as XML, XSL and Active Directory

·         Drafted, revised, and reviewed project proposals

·         Estimated costs based upon project needs; incorporated estimates into project proposals

·         Submitted project proposals to clients

 

Myrient, Aliso Viejo, CA                            Sept. 2001 – March 2002

Lead Application Engineer

·         Lead team responsible for the design, development, implementation and maintenance companies new Customer Relations Management Intranet application

·         $2 million revenue discovered upon restructuring database

·         $1 million revenue generated after introducing new late fees system to Accounts Payable

·         Halved operating costs implementing corporate Intranet

·         Trained multiple departments on correct use of new Intranet software

·         Organized and distributed project tasks and deadlines to team members

·         Maintained application schedules by coordinating with multiple departments

·         Developed application responsible for successfully transferring all data from legacy system into MS SQL 2000 database

·         Designed internal accounting workflow processes and programmed the functionality using MS Visual Basic 6 and COM+ Technology

·         Coded Trouble Tickets module capable of handling customer service requests for a DSL service provider

·         Consulted with SEC officials to ensure accurateness of business rules for new billing software

·         Integrated software components from multiple development teams into a workable software suite

·         Configured other departments’ computers (Windows 2000 Pro and Server, Windows NT, Windows 9x) for use with new software

 

Iocene Technology, Newport Beach, CA                            June 1999 – Sept. 2001

Lead Application Engineer

·         Managed work efforts of all developers for both client-related and internal projects

·         Motivated team by tracking metrics and providing recognition after key deliverables

·         Coached, mentored, and conducted regular evaluations for all non-executive employees

·         Communicated technology vision and goals to development team

·         Developed complex, multi-tiered, secure and scalable Internet software applications

·         Identified client needs and requirements and prepared time/cost estimates for use within the proposal process

·         Established and enforced all company coding standards, methodologies and documentation

·         Designed and developed tools used internally to decrease development time and abstract, complex technical tasks from less-experienced or non-technical individuals

·         Built development team expertise in relevant web technologies: VB, ASP, COM, XML, HTML

·         Researched new technologies, evaluated their usefulness, and incorporated them into the existing architecture

·         Developed applications using ASP technology in Visual Interdev editor environment

·         Coded applications in VBScript, JavaScript, and HTML

·         Middleware (COM) programmed in VB, utilizing ADO, SOAP, XML, and XSL technologies

·         Integrated Active Directory into menu bar for administrative interfaces

·         Successfully deployed numerous application versions to IIS Web Farm

·         Architected databases using MS SQL Server 2000 and MS SQL Server 7

·         Created and manipulated databases using MS Access and MS SQL Server 6.5

·         Queried Oracle databases for information relating to application needs

·         Integrated Cybersource, DCTI and Cashlynk into middleware (COM) layer

·         Utilized MS Message Queuing to deliver asynchronous messages

·         Remote data connections using ODBC

·         Delivered content securely with use of Windows media services

 

Education

University of Pennsylvania, Philadelphia, PA

        School of Arts and Science

        Bachelor of Arts in Sociology, May 1999

        Activities: Varsity Football (1998 Ivy Champs), Phi Gamma Delta Fraternity

 

Significant Courses

Computer Science Engineering

·         CSE 350 – Software Design / Engineering                                                                              Jan. 1999 – May 1999

o        Team Based Development, Architecture Specifications, Interface & Design Specifications, Test Plans, Interface Evaluations, Documentation Preparation and Product Presentation

·         CSE 330 – Database Management Systems                                                                          Sept. 1998 – Dec. 1998

o        Relational, Object Oriented, Locking, Normalization, De-normalization, Normal Forms, Boyce-Codd, Indexes, Clustered Indexes, T-SQL, Query optimization

·         CSE 121/131 – Programming Languages & Techniques II                                       Jan. 1998 – May 1998

o        Java, Object Oriented, Unix, Emacs

·         CSE 120/130 - Programming Languages & Techniques I                                               Sept. 1997 – Dec. 1997

o        Scheme, ML, Arrays, Conditionals, Recursion, Lists, Functions, Searching, Sorting, Unix, Emacs