Gary Lester Erikson
Charlotte, NC 28213 • [Send email using form at bottom]
Afton, VA 22920
________________________________________
IT Professional
Systems Analyst Systems Developer Systems Architect
• Expertise in: Microsoft server operating system platform with focus on SQL
Server, database schema, .Net Framework, VB.Net 3 tier applications and VB6 3
tier applications using DCOM and COM+.
• Collaborate with Business Analysts and End Users: Frequently sought out by
both IT and program managers for guidance and to act as a mentor to other team
members. Understand and validate customer requirements. Resolve questions of
program intent, data input, output requirements, and inclusion of internal checks
and controls.
• Team Player: Reputation for developing highly reusable code, isolating
problem areas and applying appropriate solutions promptly. Entrusted with
confidential sensitive information.
• Troubleshooting: Skilled in evaluating interrelationships to determine the
effects of contemplated program changes. Analyze program performance and correct
deficiencies, resolve backward compatibility (version conflicts).
Skills
Development Languages
Visual Studio 2003 (4 + years)
VB.Net (4 + years)
XML, XSLT and XSL (4 + years)
VB 6 (8 years)
VBA (8 years)
VBScript (8 years)
MS SQL Server 7.0 (4 years)
MS SQL Server 2000 (8 years)
MS SQL Server 2003 (1 year)
MS SQL Server 2005 (1 year)
MS SQL Server 2008 (1 year)
DTS Packages with SQL Server 2000 (8 years)
SSIS with SQL Server 2005 (1 year)
SSIS with SQL Server 2008 (1 year)
Crystal Reports 7/8/9 (8 years)
ASP.NET (5 months)
JavaScript (5 months)
HTTP, HTML (5 months)
Microsoft Office Suite and exposed objects for programming and automation. (8
years)
Operating Systems
Server 2000, 2003, 2005
Windows 98
Windows 2000 Professional
XP
Vista
General Knowledge
Component and Object Oriented Development (8 years)
ANSI SQL (8 years)
T-SQL (8 years)
SQL Jobs (8 years)
Windows API (4 + years)
COM/DCOM and COM+ using VB6 (4 years)
ADO (8 years)
ODBC (8 years)
RDO (8 years)
familiar with COM/DCOM and COM+ using ATL with C++
ADO.NET (5 months)
OLEDB.Net (5 months)
ActiveX (8 years)
DML (8 years)
DDL (8 years))
Experience
LASH GROUP (contract to hire with Robert Half, 2005) - Charlotte, NC 2005-2009
System Developer
Performed programming logic, debug, unit test and functional test of the
business logic. Developed VB 6.0, VB.NET, SQL Jobs, DTS packages, SSIS packages,
ANSI SQL, Transact –SQL, database schema to include table
creation/modification/indexes/constraints, stored procedures, user defined
functions, views, etc.
• As a member of internal legacy maintenance team, maintained and enhanced 9+
VB6 applications.
• As member of the VB.NET team, maintained over 11 VB.Net applications and
developed several new VB.NET applications.
• Individual Projects include: Maintaining Automated Fax applications,
Electronic Document Cabinet and Automated Distribution applications.
• As Team Leader, successfully oversaw development of several VB6 applications.
• Technical Advisor: Collaborated with program manager and business analyst to
create business and technical requirements to automate product orders to a
distributor. Created SQL stored procedures, SQL functions, SQL Jobs and VB.NET
console application. Coordinated with the network group to create Secure File
Transfer Protocol directory or the File Transfer Protocol directory requiring
encryption and decryption of files. Process still in use today.
• Database Conversions: Collaborated with Program managers to supply data
without giving proprietary information to outside companies so that they could
manage contracts for distributor product orders and patient demographics. Created
SQL stored procedures, SQL functions and a VB.NET application to create the MS
Excel spreadsheets. The transfer of data enabled the companies to meet contract
requirements.
• Transferred Server Processes: Transferred 12 year old processes that had no
technical or business documentation to two new servers. Required extensive study
of the old process and meetings with the third party software company to create
new documentation and understand their applications. In recreating the process on
the new server, used a SQL Job, dos batch files and SQL scripts. Set up the new
directory. The process is still in use today.
• Data Alignment: Created database schema and SQL to align each nurse with the
proper patient based on zip code. Ensured each nurse was set up with
permissions. Process still in use today.
CONTRACT Systems Analysis/Systems Developer positions 2004
MERCHANDISING CORPORATION OF AMERICA (MCA), Charlotte, NC
• Maintained SQL Jobs, server permissions and email accounts.
• Maintained and created new functionality to an MS Access application.
• Maintained and created new functionality to web application using ASP.Net.
YORK COUNTY, York, SC
• Completed web application used by Roads Planning department using ASP.Net.
MECKLENBURG COUNTY - Charlotte, NC (as a contractor with Modis, Inc.) 2001-
2004
Systems Analysis/Systems Developer
• As a member of a two person team, developed VB6 code for Social Services
intake application.
• Developed proof of concept for XML and COM+. Trained other Mecklenburg County
personnel on XML, XSD and XSLT used with SQL Server 2000 to provide well formed
XML using XML Explicit, and COM+ for three tier VB6 applications.
• Developed VB6 code for a three tier VB6 application which used XML and
transactions provided by COM+.
OTHER EXPERIENCE includes: Purchasing Agent/Buyer,
Administrator prior to 2001
Education
BS Education – University of Michigan, Ann Arbor, MI
Majored in mathematics; Minor in Physical Sciences
Currently pursuing Microsoft 70-448 TS SQL Server 2008 Business Intelligence
Development and Maintenance certification using www.quickcert.com.
Kaplan University
Currently pursuing Microsoft Certified Professional Developer (MCPD) Enterprise
courses in preparation to obtain MCPD: Enterprise Application Developer
certification – September 2009 to present
Military Army E-5 Honorable Discharge |
