Sql Server .Net Software Application Development
Resume:
Pam Jen-Ping Wang
Edison, NJ. ****1
*********@*****.***
Summary of Experience
.NET Senior Developer with 14 years software development experiences in
object oriented web and desktop (Winforms) Applications. Experience
included in SDLC, SQL Server, Net framework (1.1, 2.0, 3.5) with Object
Oriented design and Client-Server Technology.
Software:
Visual Basic 3.0, 4.0, 5.0, and 6.0 (GUI), VBA, Visual Basic, VB.NET,
ASP.NET, C#, ADO.Net, .NET framework 1.1, .NET framework 2.0, .NET
framework 3.0, .NET framework 3.5, WCF, WPF, MVC, JQuery, Web Services,
Workflow, Microsoft Team Explore, Classical ASP, COM, Visual Source Safe,
Visual C++, SQL Server 6.5, SQL Server 7.0, SQL Server 2000 (TSQL, Stored
Procedure, Triggers, DTS, Views), SQL Server 2005, SQL Server 2005
Reporting Services, SQL Server 2008, Oracle, AJAX, HTML, IIS4.0, IIS5.0,
IIS6.0, IIS7.0, XML, CSS, VBScript, JavaScript, DBASE IV, PowerBuilder
4.0(GUI), Micro focus COBOL and COBOL II.
Programming in COBOL involving structured programming, IDMS (MAPC, ADSO,
IDD, ADSC, ADSA, ADSM, OLQ, and DME), DOS JCL and RPG II.
Software Tools:
Virtual PC 2007, Microsoft Office 2010, Microsoft Office 2007, WordPerfect,
Lotus 123, Microsoft Word, MS Excel, PC Anywhere v8.0, PC Anywhere v9.0,
ProComm Plus 4.7, Microsoft Project, Flow 4, Watermark 3.0, MS Access 2.0,
MS Access 7.0, MS Access 2000, MS Access 2002, MS Access 2003, MS Access
2007, MS Access 2010, TrueGrid, Crystal Report V8.0, Alchemy Image
application 7.3, Alchemy Web 7.3, Hummingbird DM 5.1, Lawbase 2000 V10.5.6,
Infragistics NetAdvantage for .NET 9.1, Infragistics NetAdvantage for .NET
10, ComponentArt Web.UI 2007.1 for ASP.Net, ActiveBatch 7.0, Installshield,
SubVersion and DevExpress.
Operating Systems:
MS DOS, Windows 3.1, Windows 95, Windows 98, Windows 2000, Windows XP,
Windows Vista, Windows 7, Windows 2003 Server, and Windows NT;
IBM mainframe environment under OS/MVS, TSO/ISPF;
Work Experience
06/10 - Present - Brilogy Corporation - Costa Mesa, CA. - Programmer
Analyst
. Understanding business requirements gathering, analysis and design,
development tools and technologies, release and version control, testing
methodologies and deployment management.
. Provide technical expertise in the analysis, design, development and
documentation of software applications in support business needs.
. Ensure software applications are developed according to project
specifications.
. Perform a migration process for CHOC Clinic from Access 2003 to SQL
Server 2008 with Visual Studio 2008 in VB.Net (WinForms) with Infragistic
V10.2
. Support and enhance applications,
. Coalition of Orange County Community Clinics and Signal Hills Petroleum
o using Visual Studio 2008 VB.Net (Winforms) Infragistic V10.2
o SQL Server 2008 (stored procedure, trigger, view, function, and
scripts).
12/07 - 04/10 - Bank of America (LaSalle Bank N.A) - Tustin, CA. -
Programmer III
. Provide technical expertise in the analysis, design, development and
documentation of software applications in support business needs.
. Perform complex analytical work and problem solving skills to determine
resolution strategies aligned to business needs.
. Understanding of software development life cycle processes including
requirements gathering, analysis and design, development tools and
technologies, release and version control, testing methodologies and
deployment management.
. Ensure software applications are developed according to project
specifications.
. Provide support and services to business user, peers, and other IT
departments.
. Communicates complex technical solutions to users and project manager.
. Identifies risks and makes recommendations.
. Using SQL Server 2005 (stored procedure, trigger, view, function, and
scripts).
. Support and enhance internal application
o Email Processor - Client/Server application allow download
process from Exchange Server for all the deals which is active -
Using VB.NET 2005 with SQL Server 2005.
o CDO Sweep to Web - Client/Server application sweep process to
populate data from one deal report table with CDO daily reports
and CDO daily generic reports - Using VB.NET 2008 with SQL
Server 2005.
o Free Receive - Client/Server application generating Free Receive
Transactions from FPT site. - Using VB.NET 2008 with SQL Server
2005.
. Support and enhance external point website which provide reports for bond
investments. http://www.etrustee.net. Using C# ASP.NET 2003 and 3rd Party
software Infragistics version 4.3 with SQL Server 2005.
. Support and enhance internal website which manage all the data setup for
the Bond Information. Data Management Interface (DMI) - Using C# ASP.NET
2003 with SQL Server 2005.
. Support and enhance internal application used by Transaction Manager,
Bond Administrator to run the monthly statement reports to Bond holders.
Client/server Report Writer (RW) - Using Classic ASP, VB 6.0 (Winforms),
Dynamic PDF, Adobe 8.5 with SQL Server 2005.
04/07 to 12/07 - Contract - Irvine, CA - Programmer Analyst
. Segway Financial - Irvine, CA
. LandAmerica Financial Group, Inc. - Covina, CA.
Job Duty:
. Fully involved with development life cycle using latest Microsoft
Technology.
. Fully in charge of development timeline and enhancement.
. Design, develop, implement, maintain and support existing application.
. Integrate existing outsource application to bring it for in house
development with latest Microsoft technology and latest version of 3rd
party application.
. Provide functional specification of current system.
. Estimate time line of existing system implementation.
. Interact with end-users gathering current system/application
requirement/enhancement.
. Project planning with upsizing multiple existing Visual Basic/Access
application to Visual Studio 2005 C#, .Net Framework 2.0, SQL Server 2005
and SQL Server Reporting Service.
. Using SQL Server 2005 (stored procedure, trigger, view, function, and
scripts).
. Mortgage Direct System - This is online application is use by loan
officer and telemarketer to keep track the client information and Mailing
process. Used VB.Net, ASP.Net .NET Framework 2.0, SQL Server 2005,
Infragistics NetAdvantage for .NET, ComponentArt Web.UI 2007.1 for
ASP.Net, IIS7.0, Web Services and Windows 2003 server.
. EHomeLeaders System - Used ASP.Net, VB.Net, .NET Framework 1.1, SQL
Server 2005, DevExpress, IIS6.0 and Windows 2003 server.
. Delinquency Tracking System - This application use for Tax/Flood
Outsourcing team to track delinquency tax/flood information.
Used Visual Basic 6 (Winforms), Access 2003 as front/back end
used by 15+ users.
09/03 to 04/07 - New Century Mortgage Corporation - Irvine, CA. - Software
Engineer II
. Converting the MLAS application from Classic ASP to VS 2005 C# and SQL
Server 2005 using Web Service to reference to other application.
. Maintain and modify existing client/server applications using VBA, Visual
Basic 6.0 (Winforms), ASP, ASP.NET, JavaScript, HTML and SQL Server 2000
(stored procedure, trigger, view, function, and scripts).
. Analyze existing business logic procedures, features and functionality
. Design, develop, implement, maintain and support new applications
. Create application documentation and training materials
. Research new technology that may be beneficial to the company
. Provides end users and management with ongoing status of all activities
and issues.
. Provides backup for team members when needed.
. Manages time for completing urgent requests
. SQL Server 2000 (stored procedure, trigger, view, function, and scripts).
. MLAS (Marketing Lead Analyst System) - Use by marketing department to
manage the lead by telemarketer. Using ASP, JavaScript, COM, Full Text
Search and SQL Server 2000
. Lawbase Reporting tool - A Reporting tool use by legal department to
allow user to automate the process of generating quarterly report using
ASP.NET, JavaScript, MS Word and SQL Server 2000.
. (ADS) Appraiser Database System - This application allow appraiser to
track their license status in each state. ASP, JavaScript and SQL Server
2000.
. Lawbase - This application support Legal Department daily legal document
processes. It is implemented under Citrix environment and SQL Server 2000
as a backend - Support 50+ users.
. Hummingbird DM 5.1 - Document Management System with SQL Server 2000 -
o Full-text indexing support, users may search for CAD drawings by
text, title blocks, reference files, and other text-based content
contained within the file.
o Hummingbird Imaging - using Full Text Search and image "edit-
ability," character-based data from scanned or faxed documents can
be automatically converted to text, HTML, or Microsoft Word format
and attached to the image.
03/01 to 09/03 - Integrated Data Company - Placentia, CA. - Programmer
Analyst
. Convert current DOS Tournament System into Windows Tournament System
using Access 2000 as back end and VB 6 (Winforms), as front end.
. Enhancement for Golf Administrative Service application using Access
2000, VBA, VB 6 and SQL Server.
. Responsible for the design, programming, and testing of Golf
Administrative Service Application using Access 2000, VBA, VB 6
(Winforms), and SQL Server.
. Maintained IBM mainframe Dental Practice System. Using COBOL, DOS JCL,
and RPG II.
. Created month-end report creation using Alchemy Image application for
Golf Association on the CD, and on the Internet using Alchemy Web
application/ASP using VB scrip to interface with Access 2000 database.
. Assist end users in understanding data, troubleshooting, as well as
building views of data for end users.
10/99 to 03/01 -South Coast Computers - Orange, CA. - Programmer Analyst
. Converted a DOS version of a FoxPro application to windows using a Visual
Basic 6.0 (Winforms) application and Microsoft Access 2000 database front-
end.
. Interfaced ADO and SQL with an Access 2000 database.
. Defined client requirements for software conversion involving A/R, A/P,
Raw Material, Product and Report.
. Performed end-user support and training.
. Updated and maintained Macola 7.0 Accounting Software, using Micro Focus
COBOL and Btrieve as the back end database.
07/97 to 10/99 - New Jersey Administrative Office of the Courts - Trenton,
NJ - Programmer Analyst
. Developed, debugged, tested, documented, maintained and supported in-
house computer applications.
. Defined user requirements in ACS (Automated Complaint System) for
Multiple Involved Person.
. Designed and programmed the ACS application.
. Maintained and produced major enhancements using IBM mainframe COBOL II
and IDMS for online and batch programs.
. Supported Year 2000 enhancements and report format for online and batch
programs.
. Supported production for the ACS application.
. Upgraded and modified the Automated Case Management System (Electronic
Filing) from Visual Basic 4.0 to Visual Basic 6.0 (Winforms) using ADO to
connect to SQL Server.
. Tested the ACMS application's hardware and software for Y2K compliance.
10/96 to 07/97 - Advantage System - Costa Mesa, CA - Computer Programmers
. Created client security system program using Index file structure.
. Maintained and updated the company contract application.
. Converted a DOS Mortgage Accounting application using Visual Basic 4.0
(Winforms), an Oracle database, Crystal Reports, and Access 7.0.
. Involved in project planning, design, and development for the Mortgage
Accounting application.
. Used third party software (e.g. TrueGrid) to enhance the development of
the Mortgage Accounting application.
10/94 to 3/96 - TD Rowe Corporation - Rancho Dominguez, CA. - Data
Processor
. Reduced company's operating and maintenance costs by transferring
past information from minicomputer to PC network site
. Provided end-user supports
. Generated and maintained company sales commission statements
. Handled general operational office duties
03/94 to 10/94 - State Farm Insurance - Montclair, CA. -
Customer Representative
. Prepared Premium quotes and sales proposals
. Processing policy changes and updating household information
. Contact policyholders to setup sales appointments
. Handled routine office equipment maintenance and ordering supplies
03/87 to 02/91 - Collins Co. Ltd. - Irvine, CA. - Data Processing
Supervisor
. Monitored and controlled computer on an established routine basis
. Conducted general operation functional support of daily processing
. Coordinated utilization of input, output and interchangeable file
media
. Prepared documents, reports, and operating procedures
. Interfaced with users and programming tasks according to
established standards. Assisted users to secure and verify data.
Education/Training
. University California Irvine - Extension (Microsoft .NET
Technologies Certification)
o Introduction to C# Programming using Visual Studio 2005
(Microsoft Course 2124)
o Programming for the Microsoft .NET Framework with C# (Microsoft
Course 2349)
o Core Data Access Development with Visual Studio 2005 (Microsoft
Course 2541)
o Core Distributed Application Development with Microsoft Visual
Studio 2005 (MS Course 2548)
. ASP .NET Web Apps w/ MegaLab - Certified on 4/2006
. SQL Server 2000Administrator Training - Certified on 9/2005
. Hummingbird DM Administrator Training - Certified on 2/2005
. Lawbase (Designer, LawTool, HOTDOC V6, RAV reports) Training -
2/2005
. JavaScript Programming - Cypress, CA. - 6/2000
. ASP.NET Web - Orange, CA.- 8/2005
. Advanced Web Class (ASP.NET 2005) - Orange, CA - 2/2006
. Bachelor of Business Administration, majoring in Computer
Information Systems, 6/96, California State Polytechnic University,
Pomona, CA.
. Riverside Community College, Riverside, and CA. for Business
Administration from 02/91 to 01/94.
. Computer Programming courses at the Computer Learning Center,
Anaheim, CA from 5/89 to 6/90.
Reference Available Upon Request
Contact this candidate