Data Analyst Resume
SUMMARY:
- Knowledge & Experience - Over 25 years of Client/Server development using Microsoft Visual Basic from version 1.0 to the latest release of Visual Basic .NET. Two years developing Windows CE applications using Embedded Visual Basic. Leadership Skills - Performed project lead and project management duties during the implementation of JD Edwards OneWorld XE. Supervised database transfer from MS Access to SQL Server 6.5 and database transfer from SQL Server 6.5 to 7.0.
- s - Completed the full life-cycle development of many systems for an optical company, which included Order Entry via EDI into JD Edwards, order tracking through the manufacturing process and integration back into JD Edwards inventory.
- Programming Skills - Started programming in Microsoft Visual Basic when it was first released in 1991 and continue today using Visual Basic 6.0 and the latest Visual Basic .NET from Microsoft. Have a great deal of experience using Visual Basic to interface with SQL Server using ADO, RDO and ODBC. Currently updating skills with Visual Basic. NET.
- Database Skills - Very skilled in table design, indices, SQL stored procedures, triggers, maintenance and administration of databases. These skills were used mostly on Microsoft SQL Server 6.5- 2017 and Access 2000. Was the lead for the migration of data from older Access tables to SQL Server table format.
TECHNICAL SKILLS:
Platforms: Windows 3.1/3.11/95/98/ ME/NT/2000/XP/CE/Pocket PC, Microsoft .NET, DOS
Languages: Visual Basic 1 - 6, MS SQLServer, Visual Basic. NET, Embedded Visual Basic, Scheme, Dexterity
Databases: Microsoft SQL Server, PostgreSql, Oracle, Access, ADO, RDO, ODBC
Software Applications: SQL Server 6.5 - 2017, JD Edwards OneWorld XE, MS Visual Studio 6 - .NET, MS Office 2007, MS FrontPage, Gentran
PROFESSIONAL EXPERIENCE:
Confidential
Responsibilities:
- Added new features and fixed bugs on an already existingPoint of Sale application written in Dexterity software to a SQL Server 2000 database.
Confidential
Responsibilities:
- Working with a team of developers to modify and maintain a mortgage application. Scheme software to a SQL Server 2000 database. Report writing using SQL Server Reporting Services.
Confidential
Responsibilities:
- Added new features and fixed bugs on an already existing VB6 application used to measure radiation in dirt. Developed a Dashboard companion in VB6 for the application and a Pocket PC remote control program that communicated to the Client over WiFi using winsock..
Confidential
Responsibilities:
- Working on a Pocket PC application that controls a Sony EX780SP Color camera through RS232 communication. All functions of the camera (zoom, focus, exposure, pan-tilt ect.) are controlled through the application that is developed with Embedded VB 3.0
Confidential
Data Analyst
Responsibilities:
- Converted an Access 2000 database to a SQL Server 2000 database. Data migration using DTS.
- Clean up and normalization of data.
Confidential
Programmer/Analyst
Responsibilities:
- Working with a team of programmers to develop a web based Visual Basic programming environment to a SQL Server 2000 database.
Confidential
Senior Programmer/Analyst/ SQL Server 7.0 DBA
Responsibilities:
- Project lead for multiple applications that interfaced with 3 different types of robots for eyeglass lens manufacturing process.
- Responsible for multiple full life cycle projects including database design, creation and maintenance.
- Responsible for setting up, testing and maintaining EDI ordering system with Wal-Mart, Sam’s Club and National Vision.
- Applications developed with VB6, SQL Server 7.0 and Gentran 3.11
Confidential
Responsibilities:
- Development of VB5 software that transferred files through Internet FTP automatically on a scheduled basis. Included automatic sending of E-mail.
Confidential
Responsibilities:
- Development of VB4 (32 bit) software to Access 2.0 database. This software remotely controlled a time clock through RS232 communications. Developed database, help file, installation file, and all GUIs.
Confidential
Responsibilities:
- Development of multiple GUI front ends that pull information from Sybase and AS400 via stored procedures and FTP. GUIs written with VB4 and file transfer done automatically over the Internet using E-Mail and FTP.
Confidential
Responsibilities:
- Development of multiple GUI front ends using VB4 to Access 2.0 database. File transfer done automatically over the Internet using E-Mail and FTP.
Confidential
Responsibilities:
- Worked on a business application for Allied Insurance Co. Application front end with VB4 (32 bit) to SQL Server 6 database. Developed GUIs using VB4, reports using Crystal Reports and database model using Erwin 2.5. Developed installation program using WISE 4.0.
Confidential
Responsibilities:
- Worked with a team of programmers to develop a financial lending system. Developed GUI front ends to Oracle database via in line SQL. Developed GUI front ends to Oracle database via Oracle Objects. Systems designed using Visual Basic, MicroHelp VBTools4, Windows API, Windows 95.
Confidential
Responsibilities:
- Helped develop a help desk system. Developed multiple GUI front ends that pulled information from Sybase and AS400 via stored procedures. Developed help files for each GUI. Windows 95.
Confidential
Responsibilities:
- Helped develop a computer tracking system for circuit board production lines. Developed GUI front ends to Oracle database via in line SQL. Developed monitoring system that kept track of several different applications through network DDE.
Confidential
Responsibilities:
- Developed Global Agency Profile, Speedline, Territory Realignment, and Corporate Agency Profile for Delta Airlines (Sales Force Automation System). Assisted development of Insurance Reporting System for Athens Hospital. Assisted development of digital signature capture for Colonial Life. Developed application-launching system for Canada Life. Systems designed using Visual Basic 3.0, Farpoint Spreadsheet, Sheridan's Data Widgets, Access 2.0 Database, Access Basic, MicroHelp VBTools4, and Windows API.
Confidential
Responsibilities:
- Developed Confidential, a touch screen Windows application for tanning salons. System featured touch screen cash register, tanning bed scheduling, tanning bed monitor and control, and customer database. Visual Basic 3.0, Access 2.0 Database.