Developer Sql Server Management .Net Oracle Sales
Resume:
Paul W. Lee
Pearland, Texas 77584
Email: ***********@*****.***
Cell: 281-***-****
Home: 713-***-****
Key Skills
Software Development (15+ years)
.ASP, VB Script, JavaScript (6+ years)
ASP.NET, C#, XML, AJAX (3+ years)
C/C++, Pro C (5+ years)
Visual Basic (5+ years)
SQL Server (10+ years)
Oracle, PL/SQL (5+ years)
Gas Trading/Risk Management (5+ years)
Professional Summary:
With more than 15 years of experience in software analysis, design,
development, and implementation of Multi Tier Business applications
primarily using tools like C#, .NET, VB.NET, AJAX, Web Services, Visual
Basic 6.0, ASP 2.0/3.0, HTML, DHTML, CSS, VBScript, JavaScript, XML, XSLT,
COM/COM+, MTS, ADO 2.6, ADO.NET, SQL Server 7.0/2000/2005, Oracle 8i-/11i,
Crystal Report 8.0/11.0, SSRS, IIS 5.0/6.0 on various projects in e-
Business, Financial, Intranet development, Gas Transportation, Gas Trading
and Risk Management and involved in all aspects of software life cycle
through functional specs, system analysis and design, OOAD, database
designing, coding, implementation, testing and bug fixing while playing
proven role of lead, designer, developer, analyst and programmer.
Excellent problem solving/trouble shooting, communication and team
interpersonal skills.
Area Exp Area Exp
ASP.NET, VB.NET, C#, 3 Years JavaScript, VB 6 Years
ADO.NET, AJAX, Web Script, HTML, DHTML,
Services, .Net CSS
Framework 1.1/2.0,
Reporting Services
(SSRS).
XML, XSLT 2 Years VB 6.0, ASP, 6 Years
COM/DCOM
Oracle 8i-10g, SQL 10 Years PowerBuilder 3 Years
Server, Sybase,
PL/SQL, T-SQL
Crystal Report/SSRS 3 Years IIS5.0/6.0 & 5 Years
Personal web server
C, C++, Pro C 5 Years Visual Studio 8 Years
Gas/Risk Trading 5 Years Pipeline/Downstream 4 Years
Visual Source Safe 8 Years PVCS 2 Years
UNIX/C/Korn Shell 2 Years Oracle Forms 2 Years
scripting
Professional Experience:
Jan 2010 - Feb 2011
Shell Trading
ASP/.NET Developer
. Maintain and enhance a web intranet application called Spotlight used
for managing resources, financials and time entry for the Blueprint
Project. Spotlight consist of a mixture of classic ASP and .NET pages
with 2 external VB.NET applications to exchange data with MS Project.
Oct 2009 - Dec 2009
Kinder Morgan
SQL Developer
. Member of a team of developers to convert over 4500 Sybase 12.5 stored
procedures to SQL server. Also, take results sets from SQL server and
check them against the original output by the Sybase procedures.
Jun 2009 - Aug 2009
Methodist Hospital
Web Developer
. Provide enhancements to the Methodist website
. Used Java, JavaScript, Struts, Broadvision with Oracle as the database
in a Unix environment
. Used Eclipse for code development and CVS for version control
February 2008 - March 2009
Wells Fargo
Web Developer
. Provide Security Remediation on the PCARD web application. Ensure
code did not allow SQL injection, cross site scripting and other known
security flows that could compromise the website.
. Used .ASP, VBScript, JavaScript, AJAX, SSRS and .NET with SQL server
2000/2005.
. Provide Security Remediation on the PCARD PowerBuilder 6.5
application.
. Used Clear Quest for bug tracking.
. Used Visual Source Safe for maintaining the coding environment.
June 2007 - February 2008
PTI Systems
SQL/C++ Developer
. Created C++ code to interface with Crystal Report 8.5 and 11 to allow
the Prorad application to print and preview reports.
. Used Microsoft Visual Studio 2003 and Visual C++.
. Created several Crystal Reports in both 8.5 and 11 for the Sentinel
application.
. Developed Oracle procedures for new client data migration from their
existing system to Sentinel.
. Used Oracle 10g and 8i databases.
. Used Visual Source Safe for maintaining the coding environment.
February 2007 - May 2007
Shell Oil (Lubes)
Web Developer
. Maintain and develop new enhancements for the PLM Stoplight
application using .ASP and SQL Server 2000 with some basic SAP
knowledge to find required data elements when necessary.
. Used Visual Studio 2005, .ASP, VBScript, JavaScript, and SQL Server
2000.
. Used Visual Source Safe for maintaining the coding environment.
July 2006 - February 2007
El Paso Energy
Application Developer
. Maintain and develop new enhancements to the El Paso Gas
Transportation System, focusing on the Volume Allocation System (VAS).
The VAS application used Vision Jade (Java) as the front end, AppWorx
as the batch scheduler and a SQL Server database.
. Used Vision Jade, Microsoft Visual Studio, SQL Server 2000 and
AppWorks.
. Used Visual Source Safe for maintaining the coding environment.
. Used Clear Quest for bug tracking.
June 2005 - July 2006
Raft International
VB/.NET Developer
. Maintain and develop new enhancements to the Raft International Credit
Risk Management Application VB6, .ASP, XLT and SQL Server 2000.
. Create a web front to the Raft Analytics Engine using Visual Studio
2005, C#, .NET 2.0, ASP.NET, SSRS and SQL Server 2000.
. Used Visual Source Safe for maintaining the coding environment.
. Used RIMS for bug tracking.
December 2004 - June 2005
Adea Solutions (Assigned to HP)
Web Developer
. Develop new enhancements and maintain the HP SMB (Small Medium
Business) website
. Used .ASP, VB Script, JavaScript, SQL Server 2000, Commerce Server
2003, Visual InterDev, COM, and XML.
. Used Visual Source Safe for maintaining the coding environment.
December 2003 - November 2004
ECOM (Loomis Fargo, Tariff Data Systems, Money Management)
Application Developer
. Developed an intranet application for Loomis, Fargo's sales force to
track and log their sales prospects. This intranet web application
was created using ASP.NET, C#, SQL Server 2000 and .NET 1.1.
. Worked on Tariff Data Systems website developing enhancements,
performance fixes, and bug fixes. Tools used were .ASP, VB Script,
Java Script, Visual Interdev, and SQL Server 2000.
. Worked at Money Management International developing enhancements for
their website and internal application. Also, implemented third
parties utilities such as a barcode library and FAQ components to
their website.
. Tools used were .ASP, ASP.NET, C#, VB Script, Java Script, XML, Visual
Interdev, VB 6, and SQL Server 2000.
November 2000 - November 2003
ECOM, Adea Solutions (Assigned at HP)
Web Developer
. Develop and maintain the HP SMB (Small Medium Business) website. Some
projects were to change the "look and feel" from Compaq to HP
standards and create small web services for the transition to Commerce
2003 and HP's next generation website. The tools used were SQL Server
2000, Site Server 2000, and Visual InterDev, Source Safe, along with
ASP, ASP .NET, COM, ActiveX, and XML.
. Worked at HP/Compaq on the Government, Education, and Medical website
conversion from Oracle to SQL Server with a new front end ASP code.
. Tools used were .ASP, VB Script, Java Script, XML, COM, Visual
Interdev, Commerce Server 2000 and SQL Server 2000.
. Used Visual Source Safe for maintaining the coding environment.
November 1999 - October 2000
Engage Energy
Application Developer
. Part of the team to rewrite the Position Management backend process to
create positions for each of the deals that are entered into the
system. Maintaining Position and Strategy management PowerBuilder
screens and the back-end stored procedures. Tools used were
PowerBuilder 6.5, PFC and SQL Server.
. Developed and maintain PowerBuilder 6.5/PFC screens for the Capital at
Credit Risk application.
. Used PVCS for maintaining the coding environment.
November 1997 - October 1999
El Paso Energy
Application Developer
. As the project lead I helped designed and developed a new Intranet
Safety Tracking System for El Paso Energy. The development tools used
were FrontPage, SQL Server, Crystal Reports, .ASP, VB Script,
JavaScript, ADO, and MAPI.
. Designed and implemented the interface, which allowed stored
procedures to access to a third party gas volume calculator DLL using
Visual Basic, COM and ActiveX objects.
. Converted legacy measurement system that used batch UNIX jobs with a
Sybase databases and C++ to Windows NT using SQL Server database and
Visual C++.
. Converted some of the batch measurement processes written in C to
stored procedures in SQL Server.
March 1996 - November 1997
Enron Capital and Trade
C Developer
. Maintained the Enron deal entry system called TAGG where I created and
maintained tables, views, triggers, stored procedures, and user
accounts on the Oracle database. The TAGG System used PowerBuilder
5.0 to allow users to enter deals. Then, using triggers, batch jobs
would take the deal data and translate/convert the data to the risk
management database. This process utilized a distributed computing
environment called Paradise, which allowed multiple UNIX servers to
process each request based on their ability to process it.
. Pro C programmer working on ERMS the Enron Risk Management System.
Using the Data from TAGG and other risk management data (curves, NYMEX
prices) ERMS would valuate each deal. After the valuation, we used
Oracle Report Writer to produce reports, which would show traders
their positions.
. Used Oracle, Pro C and Oracle Forms
. Used PowerBuilder 5.0
. Used PVCS for maintaining the coding environment
November 1994 - March 1996
BSG Consulting
Consultant
. Visual C++ programmer to create an interface between Myriad and
Documentum. Using Myriad's DDE functions and Documentum's libraries,
I created a DLL and EXE which allowed the client to use Myriad to
display documents stored in Documentum.
. C programmer to work on a Gas Allocation System for EnergyTracs.
Developed C programs on UNIX systems with embedded SQL commands
accessing a Sybase 10 server. Wrote several UNIX scripts to provide
better version control and Lotus 123 macros to automate unit testing.
Also, created custom reports using the SQR language.
Education:
University of Houston - University Park
Major: Computer Engineering Technology
Contact this candidate