Sql Server Visual Basic C#

LUAN C. LE

*** * ******** ***, *****, FL *****

402-***-****, Email: *******@*****.***

SUMMARY

IT professional with 15+ years of SQL and VB6 development experience, as well as 5 years of XML and Crystal Reports experience.

TECHNICAL SKILLS

Software Application Designing, Coding, Testing, and Analysis

C#, Visual Basic .Net, SQL Server, VBA, Microsoft Access, Word, Excel, Power Point, Visual FoxPro, Visual Basic 6

Cross-Functional Collaboration

Project Design & Implementation

Project Management

Accounting & Auditing Support

Business & Technology Alignments

PROFESSIONAL EXPERIENCE

American Title Inc., Omaha, Nebraska July 2014-April 2015

Systems Analyst

Successfully maintained and modified C# applications.

Successfully maintained and modified Visual Basic 6 applications.

Modified SQL queried and stored procedure for changes based on user's requests.

Modified and created Excel and Crystal reports based on user's requests.

Set up for users to test on development server and UAT server before releasing new changes.

Oriental Trading Co., Omaha, Nebraska October 2013-January 2014

IT Contractor

Successfully configured Merchandise Planning databases for Windows 7 Operating Systems

World Marketing, Inc., Omaha, Nebraska September 2012-March 2013

Senior Programmer

Successfully created and maintained Visual Basic 6 and VBA programs that reformatted customer data files from Excel and HTML into text files in alignment with business requirements.

Designed and created new Visual Basic 6 applications to reformat customer raw data files for feeding into BCC Mail Manager and Jetletter software in print shop.

Monitored and enhanced existing Visual Basic 6 applications to run smoothly on a daily basis.

Produced print files and Excel reports for Print Shop through integrations of Visual Basic and Visual FoxPro programs with SQL server, Microsoft Access databases, BCC Mail Manager, and Jetletter software.

Regularly uploaded PDF files and Microsoft Excel reports to client FTP sites, as well as sent automated email notifications to both clients and internal users.

Zurich Financial Services, Omaha, Nebraska October 1997-September 2012

Senior Programmer Analyst

Effectively collaborated with the Claims and Underwriting departments in gathering software business requirements at the initiation of new projects, in addition to providing software technical solutions and Keyfile system administration support.

Designed XML documents within the Keyfile system for use by the Claims and Underwriting teams.

Created SQL statements to retrieve data from SQL server, update and insert data to SQL server in user-interface VB6 applications.

Created stored procedures on SQL server being used by VB6 applications.

Created and maintained databases on SQL server being used by VB6 applications.

Contributed expertise in designing, implementing, and maintaining Visual Basic 6 programs to:

Integrate with SQL server, AS/400, and Keyfile electronic document imaging system.

Easily access Microsoft Office applications and the integration of data between Keyfile and Microsoft Office.

Offer Keyfile system customized menus for Claims and Underwriting department users.

Interface with scanners to import and deliver scanning images by using Keyfile API.

Accessed F3 forms designer and data integration between Keyfile and F3 forms using OLE.

National Indemnity Company, Omaha, Nebraska January 1993-October 1997

Agency Systems Supervisor

Effectively monitored programmers progress in designing, creating, and implementing rating applications for general agencies.

EDUCATION

University of Nebraska at Omaha, Omaha, NE, Bachelor of Science Degree in Mathematics

Contact this candidate